{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Test","Feuille Pointage","Fériés"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":7,"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":"1904"}

{"sheet":"Test","index":0,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[1,"Lundi",null,"Abcence autorisée",null,"Formule mise en forme conditionnelle"]
[2,"Mardi",null,"Absence maladie"]
[3,"Mercredi",null,"Absence sans motif",null,"samedi et dimanche en surbrillance: =JOURSEM($A1;2)>5  (A1 adapter la colonne et la ligne au document)"]
[4,"Jeudi",null,"Accident du travail"]
[5,"Vendredi",null,"Congé "]
[6,"Samedi",null,"Heures de récupération"]
[7,"Dimanche"]

{"sheet":"Feuille Pointage","index":1,"n_rows":384,"n_cols":10,"rows_kept":384,"cut":false,"hidden":false,"merged":[[259,0,288,0],[290,0,320,0],[322,0,351,0],[353,0,383,0],[69,0,99,0],[101,0,130,0],[132,0,162,0],[164,0,193,0],[195,0,225,0],[227,0,257,0],[39,0,67,0],[0,0,0,1],[0,2,0,3],[0,4,0,6],[1,1,1,2],[2,0,2,1],[2,4,2,5],[2,6,2,8],[3,2,3,3],[3,4,3,5],[3,7,3,8],[7,0,37,0],[38,0,38,16383]]}
["Feuille de présence ",null,"Nom de l'employé:",null,null,null,null,null,"Adresse \nelectronique:"]
["Responsable:",null,null,null,null,null,null,null,"Téléphone:"]
["Totaux de l'année à cette date:"]
["Heures \nnormales:",null,"Heures\nsupplémentaires:",null,null,null,"Total:"]
[]
[2018,"Date","Heure \nArrivée","Début \nPause","Fin \nPause","Heure \nDépart","Cumul\n/Jour","Cumul\n/Semaine","Cumul\n/Mois","Observations"]
[]
["janvier",{"$f":"DATE(An,1,1)","v":"2018-01-01"},null,null,null,null,{"$f":"(D8-C8)+(F8-E8)","v":"00:00:00"}]
[null,{"$f":"B8+1","v":"2018-01-02"},null,null,null,null,{"$f":"(D9-C9)+(F9-E9)","v":"00:00:00"}]
[null,{"$f":"B9+1","v":"2018-01-03"},null,null,null,null,{"$f":"(D10-C10)+(F10-E10)","v":"00:00:00"}]
[null,"2018-01-04",null,null,null,null,"00:00:00"]
[null,"2018-01-05",null,null,null,null,"00:00:00"]
[null,"2018-01-06",null,null,null,null,"00:00:00"]
[null,"2018-01-07",null,null,null,null,"00:00:00",{"$f":"SUM(G8:G14)","v":"00:00:00"}]
[null,"2018-01-08",null,null,null,null,"00:00:00"]
[null,"2018-01-09",null,null,null,null,"00:00:00"]
[null,"2018-01-10",null,null,null,null,"00:00:00"]
[null,"2018-01-11",null,null,null,null,"00:00:00"]
[null,"2018-01-12",null,null,null,null,"00:00:00"]
[null,"2018-01-13",null,null,null,null,"00:00:00"]
[null,"2018-01-14",null,null,null,null,"00:00:00",{"$f":"SUM(G15:G21)","v":"00:00:00"}]
[null,"2018-01-15",null,null,null,null,"00:00:00"]
[null,"2018-01-16",null,null,null,null,"00:00:00"]
[null,"2018-01-17",null,null,null,null,"00:00:00"]
[null,"2018-01-18",null,null,null,null,"00:00:00"]
[null,"2018-01-19",null,null,null,null,"00:00:00"]
[null,"2018-01-20",null,null,null,null,"00:00:00"]
[null,"2018-01-21",null,null,null,null,"00:00:00",{"$f":"SUM(G22:G28)","v":"00:00:00"}]
[null,"2018-01-22",null,null,null,null,"00:00:00"]
[null,"2018-01-23",null,null,null,null,"00:00:00"]
[null,"2018-01-24",null,null,null,null,"00:00:00"]
[null,"2018-01-25",null,null,null,null,"00:00:00"]
[null,"2018-01-26",null,null,null,null,"00:00:00"]
[null,"2018-01-27",null,null,null,null,"00:00:00"]
[null,"2018-01-28",null,null,null,null,"00:00:00",{"$f":"SUM(G29:G35)","v":"00:00:00"}]
[null,"2018-01-29",null,null,null,null,"00:00:00"]
[null,"2018-01-30",null,null,null,null,"00:00:00"]
[null,"2018-01-31",null,null,null,null,"00:00:00"]
[]
["février",{"$f":"B38+1","v":"2018-02-01"},null,null,null,null,{"$f":"(D40-C40+F40-E40)*24","v":0}]
[null,{"$f":"B40+1","v":"2018-02-02"},null,null,null,null,{"$f":"(D41-C41+F41-E41)*24","v":0}]
[null,{"$f":"B41+1","v":"2018-02-03"},null,null,null,null,0]
[null,"2018-02-04",null,null,null,null,0]
[null,"2018-02-05",null,null,null,null,0]
[null,"2018-02-06",null,null,null,null,0]
[null,"2018-02-07",null,null,null,null,0,{"$f":"SUM(G40:G46)","v":"00:00:00"}]
[null,"2018-02-08",null,null,null,null,0]
[null,"2018-02-09",null,null,null,null,0]
[null,"2018-02-10",null,null,null,null,0]
[null,"2018-02-11",null,null,null,null,0]
[null,"2018-02-12",null,null,null,null,0]
[null,"2018-02-13",null,null,null,null,0]
[null,"2018-02-14",null,null,null,null,0,{"$f":"SUM(G47:G53)","v":"00:00:00"}]
[null,"2018-02-15",null,null,null,null,0]
[null,"2018-02-16",null,null,null,null,0]
[null,"2018-02-17",null,null,null,null,0]
[null,"2018-02-18",null,null,null,null,0]
[null,"2018-02-19",null,null,null,null,0]
[null,"2018-02-20",null,null,null,null,0]
[null,"2018-02-21",null,null,null,null,0,{"$f":"SUM(G54:G60)","v":"00:00:00"}]
[null,"2018-02-22",null,null,null,null,0]
[null,"2018-02-23",null,null,null,null,0]
[null,"2018-02-24",null,null,null,null,0]
[null,"2018-02-25",null,null,null,null,0]
[null,"2018-02-26",null,null,null,null,0]
[null,"2018-02-27",null,null,null,null,0]
[null,"2018-02-28",null,null,null,null,0,{"$f":"SUM(G61:G67)","v":"00:00:00"}]
[null,{"$f":"IF(MONTH(B67+1)=MONTH(B67),B67+1,\"\")","v":""},null,null,null,null,0]
[]
["mars",{"$f":"DATE(An,INT(MOD(COLUMN()/1,12)+1),1)","v":"2018-03-01"},null,null,null,null,"00:00:00"]
[null,{"$f":"B70+1","v":"2018-03-02"},null,null,null,null,"00:00:00"]
[null,{"$f":"B71+1","v":"2018-03-03"},null,null,null,null,"00:00:00"]
[null,"2018-03-04",null,null,null,null,"00:00:00"]
[null,"2018-03-05",null,null,null,null,{"$f":"(D74-C74)+(F74-E74)","v":"00:00:00"}]
[null,"2018-03-06",null,null,null,null,"00:00:00"]
[null,"2018-03-07",null,null,null,null,"00:00:00",{"$f":"SUM(G70:G76)","v":"00:00:00"}]
[null,"2018-03-08",null,null,null,null,"00:00:00"]
[null,"2018-03-09",null,null,null,null,"00:00:00"]
[null,"2018-03-10",null,null,null,null,"00:00:00"]
[null,"2018-03-11",null,null,null,null,"00:00:00"]
[null,"2018-03-12",null,null,null,null,"00:00:00"]
[null,"2018-03-13",null,null,null,null,"00:00:00"]
[null,"2018-03-14",null,null,null,null,"00:00:00",{"$f":"SUM(G77:G83)","v":"00:00:00"}]
[null,"2018-03-15",null,null,null,null,"00:00:00"]
[null,"2018-03-16",null,null,null,null,"00:00:00"]
[null,"2018-03-17",null,null,null,null,"00:00:00"]
[null,"2018-03-18",null,null,null,null,"00:00:00"]
[null,"2018-03-19",null,null,null,null,"00:00:00"]
[null,"2018-03-20",null,null,null,null,"00:00:00"]
[null,"2018-03-21",null,null,null,null,"00:00:00",{"$f":"SUM(G84:G90)","v":"00:00:00"}]
[null,"2018-03-22",null,null,null,null,"00:00:00"]
[null,"2018-03-23",null,null,null,null,"00:00:00"]
[null,"2018-03-24",null,null,null,null,"00:00:00"]
[null,"2018-03-25",null,null,null,null,"00:00:00"]
[null,"2018-03-26",null,null,null,null,"00:00:00"]
[null,"2018-03-27",null,null,null,null,"00:00:00"]
[null,"2018-03-28",null,null,null,null,"00:00:00",{"$f":"SUM(G91:G97)","v":"00:00:00"}]
[null,"2018-03-29",null,null,null,null,"00:00:00"]
[null,"2018-03-30",null,null,null,null,"00:00:00"]
[null,{"$f":"B99+1","v":"2018-03-31"},null,null,null,null,"00:00:00"]
[]
["avril",{"$f":"B100+1","v":"2018-04-01"},null,null,null,null,{"$f":"(D102-C102+F102-E102)*24","v":0}]
[null,{"$f":"B102+1","v":"2018-04-02"},null,null,null,null,0]
[null,{"$f":"B103+1","v":"2018-04-03"},null,null,null,null,0]
[null,"2018-04-04",null,null,null,null,0]
[null,"2018-04-05",null,null,null,null,0]
[null,"2018-04-06",null,null,null,null,0]
[null,"2018-04-07",null,null,null,null,0,{"$f":"SUM(G102:G108)","v":"00:00:00"}]
[null,{"$f":"B108+1","v":"2018-04-08"},null,null,null,null,0]
[null,"2018-04-09",null,null,null,null,0]
[null,"2018-04-10",null,null,null,null,0]
[null,"2018-04-11",null,null,null,null,0]
[null,"2018-04-12",null,null,null,null,0]
[null,"2018-04-13",null,null,null,null,0]
[null,"2018-04-14",null,null,null,null,0,{"$f":"SUM(G109:G115)","v":"00:00:00"}]
[null,"2018-04-15",null,null,null,null,0]
[null,"2018-04-16",null,null,null,null,0]
[null,"2018-04-17",null,null,null,null,0]
[null,"2018-04-18",null,null,null,null,0]
[null,"2018-04-19",null,null,null,null,0]
[null,"2018-04-20",null,null,null,null,0]
[null,"2018-04-21",null,null,null,null,0,{"$f":"SUM(G116:G122)","v":"00:00:00"}]
[null,"2018-04-22",null,null,null,null,0]
[null,"2018-04-23",null,null,null,null,0]
[null,"2018-04-24",null,null,null,null,0]
[null,"2018-04-25",null,null,null,null,0]
[null,"2018-04-26",null,null,null,null,0]
[null,"2018-04-27",null,null,null,null,0]
[null,"2018-04-28",null,null,null,null,0,{"$f":"SUM(G123:G129)","v":"00:00:00"}]
[null,{"$f":"IF(MONTH(B129+1)=MONTH(B129),B129+1,\"\")","v":"2018-04-29"},null,null,null,null,0]
[null,{"$f":"IF(MONTH(B130+1)=MONTH(B130),B130+1,\"\")","v":"2018-04-30"},null,null,null,null,0]
[]
["mai",{"$f":"B131+1","v":"2018-05-01"},null,null,null,null,{"$f":"(D133-C133)+(F133-E133)","v":"00:00:00"}]
[null,{"$f":"B133+1","v":"2018-05-02"},null,null,null,null,"00:00:00"]
[null,{"$f":"B134+1","v":"2018-05-03"},null,null,null,null,"00:00:00"]
[null,"2018-05-04",null,null,null,null,"00:00:00"]
[null,"2018-05-05",null,null,null,null,"00:00:00"]
[null,"2018-05-06",null,null,null,null,"00:00:00"]
[null,"2018-05-07",null,null,null,null,"00:00:00",{"$f":"SUM(G133:G139)","v":"00:00:00"}]
[null,"2018-05-08",null,null,null,null,"00:00:00"]
[null,"2018-05-09",null,null,null,null,"00:00:00"]
[null,"2018-05-10",null,null,null,null,"00:00:00"]
[null,"2018-05-11",null,null,null,null,"00:00:00"]
[null,"2018-05-12",null,null,null,null,"00:00:00"]
[null,"2018-05-13",null,null,null,null,"00:00:00"]
[null,"2018-05-14",null,null,null,null,"00:00:00",{"$f":"SUM(G140:G146)","v":"00:00:00"}]
[null,"2018-05-15",null,null,null,null,"00:00:00"]
[null,"2018-05-16",null,null,null,null,"00:00:00"]
[null,"2018-05-17",null,null,null,null,"00:00:00"]
[null,"2018-05-18",null,null,null,null,"00:00:00"]
[null,"2018-05-19",null,null,null,null,"00:00:00"]
[null,"2018-05-20",null,null,null,null,"00:00:00"]
[null,"2018-05-21",null,null,null,null,"00:00:00",{"$f":"SUM(G147:G153)","v":"00:00:00"}]
[null,"2018-05-22",null,null,null,null,"00:00:00"]
[null,"2018-05-23",null,null,null,null,"00:00:00"]
[null,"2018-05-24",null,null,null,null,"00:00:00"]
[null,"2018-05-25",null,null,null,null,"00:00:00"]
[null,"2018-05-26",null,null,null,null,"00:00:00"]
[null,"2018-05-27",null,null,null,null,"00:00:00"]
[null,"2018-05-28",null,null,null,null,"00:00:00",{"$f":"SUM(G154:G160)","v":"00:00:00"}]
[null,"2018-05-29",null,null,null,null,"00:00:00"]
[null,"2018-05-30",null,null,null,null,"00:00:00"]
[null,"2018-05-31",null,null,null,null,"00:00:00"]
[]
["juin",{"$f":"B163+1","v":"2018-06-01"},null,null,null,null,{"$f":"(D165-C165)+(F165-E165)","v":"00:00:00"}]
[null,{"$f":"B165+1","v":"2018-06-02"},null,null,null,null,"00:00:00"]
[null,{"$f":"B166+1","v":"2018-06-03"},null,null,null,null,"00:00:00"]
[null,"2018-06-04",null,null,null,null,"00:00:00"]
[null,"2018-06-05",null,null,null,null,"00:00:00"]
[null,"2018-06-06",null,null,null,null,{"$f":"(D170-C170+F170-E170)*24","v":0}]
[null,"2018-06-07",null,null,null,null,0,{"$f":"SUM(G165:G171)","v":"00:00:00"}]
[null,"2018-06-08",null,null,null,null,"00:00:00"]
[null,"2018-06-09",null,null,null,null,"00:00:00"]
[null,"2018-06-10",null,null,null,null,"00:00:00"]
[null,"2018-06-11",null,null,null,null,"00:00:00"]
[null,"2018-06-12",null,null,null,null,"00:00:00"]
[null,"2018-06-13",null,null,null,null,{"$f":"(D177-C177+F177-E177)*24","v":0}]
[null,"2018-06-14",null,null,null,null,0,{"$f":"SUM(G172:G178)","v":"00:00:00"}]
[null,"2018-06-15",null,null,null,null,"00:00:00"]
[null,"2018-06-16",null,null,null,null,"00:00:00"]
[null,"2018-06-17",null,null,null,null,"00:00:00"]
[null,"2018-06-18",null,null,null,null,"00:00:00"]
[null,"2018-06-19",null,null,null,null,"00:00:00"]
[null,"2018-06-20",null,null,null,null,{"$f":"(D184-C184+F184-E184)*24","v":0}]
[null,"2018-06-21",null,null,null,null,0,{"$f":"SUM(G179:G185)","v":"00:00:00"}]
[null,"2018-06-22",null,null,null,null,"00:00:00"]
[null,"2018-06-23",null,null,null,null,"00:00:00"]
[null,"2018-06-24",null,null,null,null,"00:00:00"]
[null,"2018-06-25",null,null,null,null,"00:00:00"]
[null,"2018-06-26",null,null,null,null,"00:00:00"]
[null,"2018-06-27",null,null,null,null,{"$f":"(D191-C191+F191-E191)*24","v":0}]
[null,"2018-06-28",null,null,null,null,0,{"$f":"SUM(G186:G192)","v":"00:00:00"}]
[null,{"$f":"IF(MONTH(B192+1)=MONTH(B192),B192+1,\"\")","v":"2018-06-29"},null,null,null,null,"00:00:00"]
[null,{"$f":"B193+1","v":"2018-06-30"},null,null,null,null,"00:00:00"]
[]
["juillet",{"$f":"B194+1","v":"2018-07-01"},null,null,null,null,{"$f":"(D196-C196)+(F196-E196)","v":"00:00:00"}]
[null,{"$f":"B196+1","v":"2018-07-02"},null,null,null,null,"00:00:00"]
[null,{"$f":"B197+1","v":"2018-07-03"},null,null,null,null,"00:00:00"]
[null,"2018-07-04",null,null,null,null,"00:00:00"]
[null,"2018-07-05",null,null,null,null,"00:00:00"]
[null,"2018-07-06",null,null,null,null,"00:00:00"]
[null,"2018-07-07",null,null,null,null,"00:00:00",{"$f":"SUM(G196:G202)","v":"00:00:00"}]
[null,"2018-07-08",null,null,null,null,"00:00:00"]
[null,"2018-07-09",null,null,null,null,"00:00:00"]
[null,"2018-07-10",null,null,null,null,"00:00:00"]
[null,"2018-07-11",null,null,null,null,"00:00:00"]
[null,"2018-07-12",null,null,null,null,"00:00:00"]
[null,"2018-07-13",null,null,null,null,"00:00:00"]
[null,"2018-07-14",null,null,null,null,"00:00:00",{"$f":"SUM(G203:G209)","v":"00:00:00"}]
[null,"2018-07-15",null,null,null,null,"00:00:00"]
[null,"2018-07-16",null,null,null,null,"00:00:00"]
[null,"2018-07-17",null,null,null,null,"00:00:00"]
[null,"2018-07-18",null,null,null,null,"00:00:00"]
[null,"2018-07-19",null,null,null,null,"00:00:00"]
[null,"2018-07-20",null,null,null,null,"00:00:00"]
[null,"2018-07-21",null,null,null,null,"00:00:00",{"$f":"SUM(G210:G216)","v":"00:00:00"}]
[null,"2018-07-22",null,null,null,null,"00:00:00"]
[null,"2018-07-23",null,null,null,null,"00:00:00"]
[null,"2018-07-24",null,null,null,null,"00:00:00"]
[null,"2018-07-25",null,null,null,null,"00:00:00"]
[null,"2018-07-26",null,null,null,null,"00:00:00"]
[null,"2018-07-27",null,null,null,null,"00:00:00"]
[null,"2018-07-28",null,null,null,null,"00:00:00",{"$f":"SUM(G217:G223)","v":"00:00:00"}]
[null,"2018-07-29",null,null,null,null,"00:00:00"]
[null,"2018-07-30",null,null,null,null,"00:00:00"]
[null,"2018-07-31",null,null,null,null,"00:00:00"]
[]
["août",{"$f":"B226+1","v":"2018-08-01"},null,null,null,null,{"$f":"(D228-C228)+(F228-E228)","v":"00:00:00"}]
[null,{"$f":"B228+1","v":"2018-08-02"},null,null,null,null,"00:00:00"]
[null,{"$f":"B229+1","v":"2018-08-03"},null,null,null,null,"00:00:00"]
[null,"2018-08-04",null,null,null,null,"00:00:00"]
[null,"2018-08-05",null,null,null,null,"00:00:00"]
[null,"2018-08-06",null,null,null,null,"00:00:00"]
[null,"2018-08-07",null,null,null,null,"00:00:00",{"$f":"SUM(G228:G234)","v":"00:00:00"}]
[null,"2018-08-08",null,null,null,null,"00:00:00"]
[null,"2018-08-09",null,null,null,null,"00:00:00"]
[null,"2018-08-10",null,null,null,null,"00:00:00"]
[null,"2018-08-11",null,null,null,null,"00:00:00"]
[null,"2018-08-12",null,null,null,null,"00:00:00"]
[null,"2018-08-13",null,null,null,null,"00:00:00"]
[null,"2018-08-14",null,null,null,null,"00:00:00",{"$f":"SUM(G235:G241)","v":"00:00:00"}]
[null,"2018-08-15",null,null,null,null,"00:00:00"]
[null,"2018-08-16",null,null,null,null,"00:00:00"]
[null,"2018-08-17",null,null,null,null,"00:00:00"]
[null,"2018-08-18",null,null,null,null,"00:00:00"]
[null,"2018-08-19",null,null,null,null,"00:00:00"]
[null,"2018-08-20",null,null,null,null,"00:00:00"]
[null,"2018-08-21",null,null,null,null,"00:00:00",{"$f":"SUM(G242:G248)","v":"00:00:00"}]
[null,"2018-08-22",null,null,null,null,"00:00:00"]
[null,"2018-08-23",null,null,null,null,"00:00:00"]
[null,"2018-08-24",null,null,null,null,"00:00:00"]
[null,"2018-08-25",null,null,null,null,"00:00:00"]
[null,"2018-08-26",null,null,null,null,"00:00:00"]
[null,"2018-08-27",null,null,null,null,"00:00:00"]
[null,"2018-08-28",null,null,null,null,"00:00:00",{"$f":"SUM(G249:G255)","v":"00:00:00"}]
[null,{"$f":"IF(MONTH(B255+1)=MONTH(B255),B255+1,\"\")","v":"2018-08-29"},null,null,null,null,"00:00:00"]
[null,{"$f":"B256+1","v":"2018-08-30"},null,null,null,null,"00:00:00"]
[null,"2018-08-31",null,null,null,null,"00:00:00",{"$f":"SUM(G252:G258)","v":"00:00:00"}]
[]
["septembre",{"$f":"B258+1","v":"2018-09-01"},null,null,null,null,{"$f":"(D260-C260)+(F260-E260)","v":"00:00:00"}]
[null,{"$f":"B260+1","v":"2018-09-02"},null,null,null,null,"00:00:00"]
[null,{"$f":"B261+1","v":"2018-09-03"},null,null,null,null,"00:00:00"]
[null,"2018-09-04",null,null,null,null,"00:00:00"]
[null,"2018-09-05",null,null,null,null,"00:00:00"]
[null,"2018-09-06",null,null,null,null,"00:00:00"]
[null,"2018-09-07",null,null,null,null,"00:00:00",{"$f":"SUM(G260:G266)","v":"00:00:00"}]
[null,"2018-09-08",null,null,null,null,"00:00:00"]
[null,"2018-09-09",null,null,null,null,"00:00:00"]
[null,"2018-09-10",null,null,null,null,"00:00:00"]
[null,"2018-09-11",null,null,null,null,"00:00:00"]
[null,"2018-09-12",null,null,null,null,"00:00:00"]
[null,"2018-09-13",null,null,null,null,"00:00:00"]
[null,"2018-09-14",null,null,null,null,"00:00:00",{"$f":"SUM(G267:G273)","v":"00:00:00"}]
[null,"2018-09-15",null,null,null,null,"00:00:00"]
[null,"2018-09-16",null,null,null,null,"00:00:00"]
[null,"2018-09-17",null,null,null,null,"00:00:00"]
[null,"2018-09-18",null,null,null,null,"00:00:00"]
[null,"2018-09-19",null,null,null,null,"00:00:00"]
[null,"2018-09-20",null,null,null,null,"00:00:00"]
[null,"2018-09-21",null,null,null,null,"00:00:00",{"$f":"SUM(G274:G280)","v":"00:00:00"}]
[null,"2018-09-22",null,null,null,null,"00:00:00"]
[null,"2018-09-23",null,null,null,null,"00:00:00"]
[null,"2018-09-24",null,null,null,null,"00:00:00"]
[null,"2018-09-25",null,null,null,null,"00:00:00"]
[null,"2018-09-26",null,null,null,null,"00:00:00"]
[null,"2018-09-27",null,null,null,null,"00:00:00"]
[null,"2018-09-28",null,null,null,null,"00:00:00",{"$f":"SUM(G281:G287)","v":"00:00:00"}]
[null,"2018-09-29",null,null,null,null,"00:00:00"]
[null,"2018-09-30",null,null,null,null,"00:00:00",{"$f":"SUM(G279:G289)","v":"00:00:00"}]
[]
["octobre",{"$f":"B289+1","v":"2018-10-01"},null,null,null,null,{"$f":"(D291-C291)+(F291-E291)","v":"00:00:00"}]
[null,{"$f":"B291+1","v":"2018-10-02"},null,null,null,null,"00:00:00"]
[null,{"$f":"B292+1","v":"2018-10-03"},null,null,null,null,"00:00:00"]
[null,"2018-10-04",null,null,null,null,"00:00:00"]
[null,"2018-10-05",null,null,null,null,"00:00:00"]
[null,"2018-10-06",null,null,null,null,"00:00:00"]
[null,"2018-10-07",null,null,null,null,"00:00:00",{"$f":"SUM(G291:G297)","v":"00:00:00"}]
[null,"2018-10-08",null,null,null,null,"00:00:00"]
[null,"2018-10-09",null,null,null,null,"00:00:00"]
[null,"2018-10-10",null,null,null,null,"00:00:00"]
[null,"2018-10-11",null,null,null,null,"00:00:00"]
[null,"2018-10-12",null,null,null,null,"00:00:00"]
[null,"2018-10-13",null,null,null,null,"00:00:00"]
[null,"2018-10-14",null,null,null,null,"00:00:00",{"$f":"SUM(G298:G304)","v":"00:00:00"}]
[null,"2018-10-15",null,null,null,null,"00:00:00"]
[null,"2018-10-16",null,null,null,null,"00:00:00"]
[null,"2018-10-17",null,null,null,null,"00:00:00"]
[null,"2018-10-18",null,null,null,null,"00:00:00"]
[null,"2018-10-19",null,null,null,null,"00:00:00"]
[null,"2018-10-20",null,null,null,null,"00:00:00"]
[null,"2018-10-21",null,null,null,null,"00:00:00",{"$f":"SUM(G305:G311)","v":"00:00:00"}]
[null,"2018-10-22",null,null,null,null,"00:00:00"]
[null,"2018-10-23",null,null,null,null,"00:00:00"]
[null,"2018-10-24",null,null,null,null,"00:00:00"]
[null,"2018-10-25",null,null,null,null,"00:00:00"]
[null,"2018-10-26",null,null,null,null,"00:00:00"]
[null,"2018-10-27",null,null,null,null,"00:00:00"]
[null,"2018-10-28",null,null,null,null,"00:00:00",{"$f":"SUM(G312:G318)","v":"00:00:00"}]
[null,{"$f":"IF(MONTH(B318+1)=MONTH(B318),B318+1,\"\")","v":"2018-10-29"},null,null,null,null,"00:00:00"]
[null,{"$f":"B319+1","v":"2018-10-30"},null,null,null,null,"00:00:00",{"$f":"SUM(G314:G320)","v":"00:00:00"}]
[null,{"$f":"B320+1","v":"2018-10-31"},null,null,null,null,"00:00:00"]
[]
["novembre",{"$f":"B321+1","v":"2018-11-01"},null,null,null,null,{"$f":"(D323-C323)+(F323-E323)","v":"00:00:00"}]
[null,{"$f":"B323+1","v":"2018-11-02"},null,null,null,null,"00:00:00"]
[null,{"$f":"B324+1","v":"2018-11-03"},null,null,null,null,"00:00:00"]
[null,"2018-11-04",null,null,null,null,"00:00:00"]
[null,"2018-11-05",null,null,null,null,"00:00:00"]
[null,"2018-11-06",null,null,null,null,"00:00:00"]
[null,"2018-11-07",null,null,null,null,"00:00:00",{"$f":"SUM(G323:G329)","v":"00:00:00"}]
[null,"2018-11-08",null,null,null,null,"00:00:00"]
[null,"2018-11-09",null,null,null,null,"00:00:00"]
[null,"2018-11-10",null,null,null,null,"00:00:00"]
[null,"2018-11-11",null,null,null,null,"00:00:00"]
[null,"2018-11-12",null,null,null,null,"00:00:00"]
[null,"2018-11-13",null,null,null,null,"00:00:00"]
[null,"2018-11-14",null,null,null,null,"00:00:00",{"$f":"SUM(G330:G336)","v":"00:00:00"}]
[null,"2018-11-15",null,null,null,null,"00:00:00"]
[null,"2018-11-16",null,null,null,null,"00:00:00"]
[null,"2018-11-17",null,null,null,null,"00:00:00"]
[null,"2018-11-18",null,null,null,null,"00:00:00"]
[null,"2018-11-19",null,null,null,null,"00:00:00"]
[null,"2018-11-20",null,null,null,null,"00:00:00"]
[null,"2018-11-21",null,null,null,null,"00:00:00",{"$f":"SUM(G337:G343)","v":"00:00:00"}]
[null,"2018-11-22",null,null,null,null,"00:00:00"]
[null,"2018-11-23",null,null,null,null,"00:00:00"]
[null,"2018-11-24",null,null,null,null,"00:00:00"]
[null,"2018-11-25",null,null,null,null,"00:00:00"]
[null,"2018-11-26",null,null,null,null,"00:00:00"]
[null,"2018-11-27",null,null,null,null,"00:00:00"]
[null,"2018-11-28",null,null,null,null,"00:00:00",{"$f":"SUM(G344:G350)","v":"00:00:00"}]
[null,"2018-11-29",null,null,null,null,"00:00:00"]
[null,"2018-11-30",null,null,null,null,"00:00:00",{"$f":"SUM(G346:G352)","v":"00:00:00"}]
[]
["décembre",{"$f":"B352+1","v":"2018-12-01"},null,null,null,null,{"$f":"(D354-C354)+(F354-E354)","v":"00:00:00"}]
[null,{"$f":"B354+1","v":"2018-12-02"},null,null,null,null,"00:00:00"]
[null,"2018-12-03",null,null,null,null,"00:00:00"]
[null,"2018-12-04",null,null,null,null,"00:00:00"]
[null,"2018-12-05",null,null,null,null,"00:00:00"]
[null,"2018-12-06",null,null,null,null,"00:00:00"]
[null,"2018-12-07",null,null,null,null,"00:00:00",{"$f":"SUM(G354:G360)","v":"00:00:00"}]
[null,"2018-12-08",null,null,null,null,"00:00:00"]
[null,"2018-12-09",null,null,null,null,"00:00:00"]
[null,"2018-12-10",null,null,null,null,"00:00:00"]
[null,"2018-12-11",null,null,null,null,"00:00:00"]
[null,"2018-12-12",null,null,null,null,"00:00:00"]
[null,"2018-12-13",null,null,null,null,"00:00:00"]
[null,"2018-12-14",null,null,null,null,"00:00:00",{"$f":"SUM(G361:G367)","v":"00:00:00"}]
[null,"2018-12-15",null,null,null,null,"00:00:00"]
[null,"2018-12-16",null,null,null,null,"00:00:00"]
[null,"2018-12-17",null,null,null,null,"00:00:00"]
[null,"2018-12-18",null,null,null,null,"00:00:00"]
[null,"2018-12-19",null,null,null,null,"00:00:00"]
[null,"2018-12-20",null,null,null,null,"00:00:00"]
[null,"2018-12-21",null,null,null,null,"00:00:00",{"$f":"SUM(G368:G374)","v":"00:00:00"}]
[null,"2018-12-22",null,null,null,null,"00:00:00"]
[null,"2018-12-23",null,null,null,null,"00:00:00"]
[null,"2018-12-24",null,null,null,null,"00:00:00"]
[null,"2018-12-25",null,null,null,null,"00:00:00"]
[null,"2018-12-26",null,null,null,null,"00:00:00"]
[null,"2018-12-27",null,null,null,null,"00:00:00"]
[null,"2018-12-28",null,null,null,null,"00:00:00",{"$f":"SUM(G375:G381)","v":"00:00:00"}]
[null,{"$f":"IF(MONTH(B381+1)=MONTH(B381),B381+1,\"\")","v":"2018-12-29"},null,null,null,null,"00:00:00"]
[null,"2018-12-30",null,null,null,null,"00:00:00"]
[null,"2018-12-31",null,null,null,null,"00:00:00",{"$f":"SUM(G378:G384)","v":"00:00:00"}]

{"sheet":"Fériés","index":2,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Année",{"$f":"'Feuille Pointage'!An","v":2018},true]
[{"$f":"\"Noël \"&B1-1","v":"Noël 2017"},{"$f":"DATE($B$1-1,12,25)","v":"2017-12-25"}]
["Jour de l'an",{"$f":"DATE($B$1,1,1)","v":"2018-01-01"}]
["Dimanche de Pâques",{"$f":"DATE($B$1,3,29.56+0.979*MOD(204-11*MOD($B$1,19),30)- WEEKDAY(DATE($B$1,3,28.56+0.979*MOD(204-11*MOD($B$1,19),30))))","v":"2018-04-01"}]
["Lundi de Pâques",{"$f":"B4+1","v":"2018-04-02"}]
["Fête du travail",{"$f":"DATE($B$1,5,1)","v":"2018-05-01"}]
["Victoire 45",{"$f":"DATE($B$1,5,8)","v":"2018-05-08"}]
["Ascension",{"$f":"$B$5+38","v":"2018-05-10"}]
["Lundi de Pentecôte",{"$f":"IF($C$1,,$B$5+49)","v":"1904-01-01"}]
["Fête nationale",{"$f":"DATE($B$1,7,14)","v":"2018-07-14"}]
["Assomption",{"$f":"DATE($B$1,8,15)","v":"2018-08-15"}]
["Toussaint",{"$f":"DATE($B$1,11,1)","v":"2018-11-01"}]
["Armistice 14-18",{"$f":"DATE($B$1,11,11)","v":"2018-11-11"}]
["Noël",{"$f":"DATE($B$1,12,25)","v":"2018-12-25"}]
[{"$f":"\"Jour de l'an \" & B1+1","v":"Jour de l'an 2019"},{"$f":"DATE($B$1+1,1,1)","v":"2019-01-01"}]
["Lundi de Pâques",{"$f":"DATE($B$1+1,3,29.56+0.979*MOD(204-11*MOD($B$1+1,19),30)- WEEKDAY(DATE($B$1+1,3,28.56+0.979*MOD(204-11*MOD($B$1+1,19),30))))+1","v":"2019-04-22"}]
["Fête du travail",{"$f":"DATE($B$1+1,5,1)","v":"2019-05-01"}]
["Victoire 45",{"$f":"DATE($B$1+1,5,8)","v":"2019-05-08"}]
["Ascension",{"$f":"$B$5+38","v":"2018-05-10"}]
["Lundi de Pentecôte",{"$f":"IF($C$1,,$B$5+49)","v":"1904-01-01"}]
["Fête nationale",{"$f":"DATE($B$1+1,7,14)","v":"2019-07-14"}]
["Assomption",{"$f":"DATE($B$1+1,8,15)","v":"2019-08-15"}]
["Toussaint",{"$f":"DATE($B$1+1,11,1)","v":"2019-11-01"}]
["Armistice 14-18",{"$f":"DATE($B$1+1,11,11)","v":"2019-11-11"}]
["Noël",{"$f":"DATE($B$1+1,12,25)","v":"2019-12-25"}]
[{"$f":"\"Jour de l'an \" & B1+2","v":"Jour de l'an 2020"},{"$f":"DATE($B$1+2,1,1)","v":"2020-01-01"}]
["Ponts, fériés locaux"]
["et jours chômés"]