{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["jours feriés","planning"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"jours feriés","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Jours fériés français"]
["année",{"$f":"YEAR(planning!B2)","v":2017},null,"Ne Pas supprimer cette feuille utilisée pour mettre en rose les jours fériés"]
[]
["jour de l'an",{"$f":"DATE(an,1,1)","v":"2017-01-01"}]
["Pâques",{"$f":"(ROUND(DATE(an,4,MOD(234-11*MOD(an,19),30))/7,)*7-6)","v":"2017-04-16"}]
["Lundi de Pâques",{"$f":"B5+1","v":"2017-04-17"}]
["Fête du travail",{"$f":"DATE(an,5,1)","v":"2017-05-01"}]
["Victoire de 1945",{"$f":"DATE(an,5,8)","v":"2017-05-08"}]
["Ascension",{"$f":"B5+39","v":"2017-05-25"}]
["Pentecôte",{"$f":"B5+49","v":"2017-06-04"}]
["Lundi de Pentecôte",{"$f":"B10+1","v":"2017-06-05"}]
["Fête nationale",{"$f":"DATE(an,7,14)","v":"2017-07-14"}]
["Assomption",{"$f":"DATE(an,8,15)","v":"2017-08-15"}]
["Toussaint",{"$f":"DATE(an,11,1)","v":"2017-11-01"}]
["Armistice",{"$f":"DATE(an,11,11)","v":"2017-11-11"}]
["Noel",{"$f":"DATE(an,12,25)","v":"2017-12-25"}]

{"sheet":"planning","index":1,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["JOUR","DATE","FERIE",null,null,null,null,null,"Début","Fin","HT","HJ","HN","HD","HF"]
[{"$f":"B2","v":"2017-08-01"},"2017-08-01",null,null,null,null,null,null,0.33333333333333331,0.79166666666666663,{"$f":"IF(I2=\"\",\"\",MOD(J2-I2,1))","v":"11:00:00"},{"$f":"IF( I2=\"\",\"\",K2-M2)","v":"11:00:00"},{"$f":"IF(OR(I2=\"\",J2=\"\"),\"\",(MOD(J2-I2,1)-IF(J2>I2,MAX(0,MIN(J2,21/24)-MAX(I2,6/24)),MAX(0,21/24-MAX(I2,6/24))+MAX(0,MIN(J2,21/24)-6/24))))","v":"00:00:00"},{"$f":"IF(I2=\"\",\"\",IF(COUNTIF(fériés,B2)<>0,\"\",IF(WEEKDAY(B2)=1, K2,0)))","v":0},{"$f":"IF(NOT(ISBLANK(C2)),K2,\"\")","v":""}]
["2017-08-02",{"$f":"B2+1","v":"2017-08-02"},null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-03","2017-08-03",null,null,null,null,null,null,0.79166666666666663,1,"05:00:00","02:00:00","03:00:00",0,""]
["2017-08-04","2017-08-04",null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-05","2017-08-05",null,null,null,null,null,null,0.79166666666666663,0.29166666666666669,"12:00:00","03:00:00","09:00:00",0,""]
["2017-08-06","2017-08-06",null,null,null,null,null,null,0.79166666666666663,0.29166666666666669,"12:00:00","03:00:00","09:00:00",0.5,""]
["2017-08-07","2017-08-07",null,null,null,null,null,null,0.20833333333333334,0.91666666666666663,"17:00:00","15:00:00","02:00:00",0,""]
["2017-08-08","2017-08-08",null,null,null,null,null,null,0.20833333333333334,0.91666666666666663,"17:00:00","15:00:00","02:00:00",0,""]
["2017-08-09","2017-08-09",null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-10","2017-08-10",null,null,null,null,null,null,0.75,0.83333333333333337,"02:00:00","02:00:00","00:00:00",0,""]
["2017-08-11","2017-08-11",null,null,null,null,null,null,0.75,0.91666666666666663,"04:00:00","03:00:00","01:00:00",0,""]
["2017-08-12","2017-08-12",null,null,null,null,null,null,0.75,0.20833333333333334,"11:00:00","03:00:00","08:00:00",0,""]
["2017-08-13","2017-08-13",null,null,null,null,null,null,0.75,0.5,"18:00:00","09:00:00","09:00:00",0.75,""]
["2017-08-14","2017-08-14",null,null,null,null,null,null,0.95833333333333337,0.20833333333333334,"06:00:00","00:00:00","06:00:00",0,""]
["2017-08-15","2017-08-15","x",null,null,null,null,null,0.95833333333333337,0.5,"13:00:00","06:00:00","07:00:00","",0.54166666666666663]
["2017-08-16","2017-08-16",null,null,null,null,null,null,0.95833333333333337,0.91666666666666663,"23:00:00","15:00:00","08:00:00",0,""]
["2017-08-17","2017-08-17",null,null,null,null,null,null,0.16666666666666666,0.20833333333333334,"01:00:00","00:00:00","01:00:00",0,""]
["2017-08-18","2017-08-18",null,null,null,null,null,null,0.16666666666666666,0.5,"08:00:00","06:00:00","02:00:00",0,""]
["2017-08-19","2017-08-19",null,null,null,null,null,null,0.16666666666666666,0.91666666666666663,"18:00:00","15:00:00","03:00:00",0,""]
["2017-08-20","2017-08-20",null,null,null,null,null,null,0.16666666666666666,4.1666666666666664E-2,"21:00:00","15:00:00","06:00:00",0.875,""]
["2017-08-21","2017-08-21",null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-22","2017-08-22",null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-23","2017-08-23",null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-24","2017-08-24",null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-25","2017-08-25",null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-26","2017-08-26",null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-27","2017-08-27",null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-28","2017-08-28",null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-29","2017-08-29",null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-30","2017-08-30",null,null,null,null,null,null,null,null,"","","","",""]
["2017-08-31","2017-08-31",null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K2:K32)","v":8.2916666666666661},{"$f":"SUM(L2:L32)","v":5.125},{"$f":"SUM(M2:M32)","v":3.1666666666666661},{"$f":"SUM(N2:N32)","v":2.125},{"$f":"SUM(O2:O32)","v":0.54166666666666663}]
[]
["LEGENDE :"]
["HT","Nombre d'heures total"]
["HD","Nombre d'heures de Dimanche"]
["HN","Nombre d'heures de Nuit",null,null,"entre 21h et 06h formules programmées en colonne M"]
["HJ","Nombre d'heures de Jour",null,null,"entre 6h et 21h"]
["HF","Nombre d'heures de Fériés"]
[]
["les jours fériés s'affichent en rouge et on  met une croix colonne C pour la formule colonne HF"]