{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BASE","NOVEMBRE","DECEMBRE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"BASE","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Année",null,"Mois"]
[]
[2013,null,1]
[2014,null,2]
[2015,null,3]
[2016,null,4]
[2017,null,5]
[2018,null,6]
[2019,null,7]
[2020,null,8]
[2021,null,9]
[null,null,10]
[null,null,11]
[null,null,12]

{"sheet":"NOVEMBRE","index":1,"n_rows":48,"n_cols":17,"rows_kept":48,"cut":false,"hidden":false,"merged":[[5,0,7,1],[5,4,6,5],[5,2,6,3],[5,14,6,14],[4,11,4,14],[5,8,6,9],[5,10,5,11],[5,12,6,12],[5,13,6,13],[40,10,40,12],[45,10,45,13],[47,10,47,13],[40,1,44,2],[40,4,44,5],[40,7,44,8],[46,1,47,2],[46,4,47,5],[46,7,47,8],[4,2,4,4],[4,5,4,7],[1,8,3,10],[1,2,3,4],[4,8,4,10],[1,5,3,7],[5,6,6,7],[7,16,7,19],[6,16,6,22],[1,11,3,12]]}
[]
[11,null,"Cases à remplir"]
[2017]
[{"$f":"DATE(A3,A2,1)","v":"2017-11-01"}]
[null,null,"NOM:",null,null,null,null,null,"PRENOM:"]
["CRENEAU HORAIRE",null,"ARRIVEE\n7H30-9H30",null,"DEPART DEJ.\n12H",null,"RETOUR DEJ.\n14H",null,"DEPART\n16H30-19H00",null,"ABSENCES",null,"TOTAL\nJOURS\nen heures","TOTAL\nHEURES\nSEMAINE","TOTAL\nHEURE\nRECUP."]
[null,null,null,null,null,null,null,null,null,null,"CP\nMaladie\nFérie","RECUP",null,null,null,null,"CONGES PAYES / MALADIE / JOUR FERIE = 7 H\n\nRECUPERATION : MENTION \"RECUP\" = CALCUL HEURES REELLES"]
[null,null,"HEURE","MINUTES","HEURE","MINUTES","HEURE","MINUTES","HEURE","MINUTES"]
[{"$f":"B9","v":"2017-11-01"},{"$f":"DATE(A3,A2,1)","v":"2017-11-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K9=0,((E9*60+F9)-(C9*60+D9)+(I9*60+J9)-(G9*60+H9))/60,K9)","v":0},{"$f":"IF(SUM(C8:L9)=0,M9,0)","v":0},{"$f":"IF(M9>7,M9-7,IF(AND(M9<7,M9>=1),M9-7,IF(M9=0,M9-L9,0)))","v":0}]
["2017-11-02",{"$f":"B9+1","v":"2017-11-02"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K10=0,((E10*60+F10)-(C10*60+D10)+(I10*60+J10)-(G10*60+H10))/60,K10)","v":0},{"$f":"IF(SUM(C9:L10)=0,M9,0)","v":0},{"$f":"IF(M10>7,M10-7,IF(AND(M10<7,M10>=1),M10-7,IF(M10=0,M10-L10,0)))","v":0}]
["2017-11-03","2017-11-03",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C10:L11)=0,(M9),0)","v":0},0]
["2017-11-04","2017-11-04",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C11:L12)=0,SUM(M9:M10),0)","v":0},0]
["2017-11-05","2017-11-05",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C12:L13)=0,SUM(M9:M11),0)","v":0},0]
["2017-11-06","2017-11-06",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C13:L14)=0,SUM(M9:M12),0)","v":0},0]
["2017-11-07",{"$f":"B14+1","v":"2017-11-07"},null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C14:L15)=0,SUM(M9:M13),0)","v":0},0]
[{"$f":"B16","v":"2017-11-08"},"2017-11-08",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C15:L16)=0,SUM(M10:M14),0)","v":0},0]
["2017-11-09","2017-11-09",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C16:L17)=0,SUM(M11:M15),0)","v":0},0]
["2017-11-10","2017-11-10",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C17:L18)=0,SUM(M12:M16),0)","v":0},0]
[{"$f":"B19","v":"2017-11-11"},"2017-11-11",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C18:L19)=0,SUM(M13:M17),0)","v":0},0]
["2017-11-12","2017-11-12",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C19:L20)=0,SUM(M14:M18),0)","v":0},0]
["2017-11-13","2017-11-13",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-14","2017-11-14",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-15","2017-11-15",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-16","2017-11-16",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-17","2017-11-17",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-18","2017-11-18",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-19","2017-11-19",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K27=0,((E27*60+F27)-(C27*60+D27)+(I27*60+J27)-(G27*60+H27))/60,K27)","v":0},{"$f":"IF(SUM(C26:L27)=0,SUM(M21:M25),0)","v":0},0]
["2017-11-20","2017-11-20",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-21","2017-11-21",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-22","2017-11-22",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-23","2017-11-23",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-24","2017-11-24",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-25","2017-11-25",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-26","2017-11-26",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C33:L34)=0,SUM(M28:M32),0)","v":0},0]
["2017-11-27","2017-11-27",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-28","2017-11-28",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-29","2017-11-29",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-11-30","2017-11-30",null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(EST.IMPAIR(A2),IF(AND(SUM(C39:L39)=0,SUM(C36:L37)=0),M38,IF(AND(SUM(C39:L39)=0,SUM(C35:L36)=0),SUM(M37:M38),IF(AND(SUM(C39:L39)=0,SUM(C34:L35)=0),SUM(M36:M38),IF(AND(SUM(C39:L39)=0,SUM(C33:L34)=0),SUM(M35:M38),IF(AND(SUM(C39:L39)=0,SUM(C32:L33)=0),SUM(M34:M38),0))))),0)","v":{"$error":"#NAME?"}},0]
[]
[null,"Signature salarié:\n\n\n",null,null,"Signature service RH:\n\n\n",null,null,"Signature  manager:\n\n\n",null,null,"TOTAL MOIS",null,null,{"$f":"SUM(N9:N39)","v":{"$error":"#NAME?"}},{"$f":"SUM(O9:O39)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"SOIT",{"$f":"INT(N41)","v":{"$error":"#NAME?"}},"Heures"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(N41-L43)*60","v":{"$error":"#NAME?"}},"Minutes"]
[]
[null,null,null,null,null,null,null,null,null,null,"CUMUL à REPORTER  M-1"]
[null,"Fait le :",null,null,"Fait le:",null,null,"Fait le:"]
[null,null,null,null,null,null,null,null,null,null,"CUMUL à REPORTER  fin M",null,null,null,{"$f":"O46+O41","v":0}]

{"sheet":"DECEMBRE","index":2,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[47,10,47,13],[40,1,44,2],[40,4,44,5],[40,7,44,8],[1,8,3,10],[1,2,3,4],[4,11,4,14],[1,5,3,7],[40,10,40,12],[1,11,3,12],[48,1,48,6],[5,0,6,1],[5,2,5,3],[5,4,5,5],[5,6,5,7],[46,1,46,4],[4,2,4,4],[4,5,4,7],[4,8,4,10],[5,8,5,9],[45,10,45,13]]}
[]
[12,null,"Cases à remplir"]
[2017]
[{"$f":"DATE(A3,A2,1)","v":"2017-12-01"}]
[null,null,"NOM:",null,null,{"$f":"+NOVEMBRE!F5","v":0},null,null,"PRENOM:",null,null,{"$f":"+NOVEMBRE!L5","v":0}]
["CRENEAU HORAIRE",null,"ARRIVEE\n7H30-9H30",null,"DEPART DEJ.\n12H",null,"RETOUR DEJ.\n14H",null,"DEPART\n16H30-19H00",null,"CP\nMaladie\nFérie","RECUP","TOTAL\nJOURS\nen heures","TOTAL\nHEURES\nSEMAINE","TOTAL\nHEURE\nRECUP."]
[null,null,"HEURE","MINUTES","HEURE","MINUTES","HEURE","MINUTES","HEURE","MINUTES"]
[{"$f":"B8","v":"2017-12-01"},{"$f":"DATE(A3,A2,1)","v":"2017-12-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K8=0,((E8*60+F8)-(C8*60+D8)+(I8*60+J8)-(G8*60+H8))/60,K8)","v":0},{"$f":"IF(SUM(C7:L8)=0,M8,0)","v":0},{"$f":"IF(M8>7,M8-7,IF(AND(M8<7,M8>=1),M8-7,IF(M8=0,L8,0)))","v":0}]
["2017-12-02",{"$f":"B8+1","v":"2017-12-02"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K9=0,((E9*60+F9)-(C9*60+D9)+(I9*60+J9)-(G9*60+H9))/60,K9)","v":0},{"$f":"IF(SUM(C8:L9)=0,M8,0)","v":0},{"$f":"IF(M9>7,M9-7,IF(AND(M9<7,M9>=1),M9-7,IF(M9=0,L9,0)))","v":0}]
["2017-12-03","2017-12-03",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C9:L10)=0,(M8),0)","v":0},0]
["2017-12-04","2017-12-04",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C10:L11)=0,SUM(M8:M9),0)","v":0},0]
["2017-12-05","2017-12-05",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C11:L12)=0,SUM(M8:M10),0)","v":0},0]
["2017-12-06","2017-12-06",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C12:L13)=0,SUM(M8:M11),0)","v":0},0]
["2017-12-07",{"$f":"B13+1","v":"2017-12-07"},null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C13:L14)=0,SUM(M8:M12),0)","v":0},0]
[{"$f":"B15","v":"2017-12-08"},"2017-12-08",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C14:L15)=0,SUM(M9:M13),0)","v":0},0]
["2017-12-09","2017-12-09",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C15:L16)=0,SUM(M10:M14),0)","v":0},0]
["2017-12-10","2017-12-10",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C16:L17)=0,SUM(M11:M15),0)","v":0},0]
[{"$f":"B18","v":"2017-12-11"},"2017-12-11",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(SUM(C17:L18)=0,SUM(M12:M16),0)","v":0},0]
["2017-12-12","2017-12-12",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-13","2017-12-13",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-14","2017-12-14",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-15","2017-12-15",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-16","2017-12-16",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-17","2017-12-17",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-18","2017-12-18",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-19","2017-12-19",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-20","2017-12-20",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-21","2017-12-21",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-22","2017-12-22",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-23","2017-12-23",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-24","2017-12-24",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-25","2017-12-25",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-26","2017-12-26",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-27","2017-12-27",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-28","2017-12-28",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-29","2017-12-29",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-30","2017-12-30",null,null,null,null,null,null,null,null,null,null,0,0,0]
["2017-12-31",{"$f":"B37+1","v":"2017-12-31"},null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(EST.PAIR(A2),IF(AND(SUM(C38:L38)=0,SUM(C35:L36)=0),M37,IF(AND(SUM(C38:L38)=0,SUM(C34:L35)=0),SUM(M36:M37),IF(AND(SUM(C38:L38)=0,SUM(C33:L34)=0),SUM(M35:M37),IF(AND(SUM(C38:L38)=0,SUM(C32:L33)=0),SUM(M34:M37),IF(AND(SUM(C38:L38)=0,SUM(C31:L32)=0),SUM(M33:M37),0))))),0)","v":{"$error":"#NAME?"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(EST.IMPAIR(A2),IF(AND(SUM(C39:L39)=0,SUM(C36:L37)=0),M38,IF(AND(SUM(C39:L39)=0,SUM(C35:L36)=0),SUM(M37:M38),IF(AND(SUM(C39:L39)=0,SUM(C34:L35)=0),SUM(M36:M38),IF(AND(SUM(C39:L39)=0,SUM(C33:L34)=0),SUM(M35:M38),IF(AND(SUM(C39:L39)=0,SUM(C32:L33)=0),SUM(M34:M38),0))))),0)","v":{"$error":"#NAME?"}},0]
[]
[null,"Signature du salarié:\n\n\nFait le:",null,null,"Signature supérieur:\n\n\nFait le:",null,null,"Signature service RH:\n\n\nFait le:",null,null,"TOTAL MOIS",null,null,{"$f":"SUM(N8:N38)","v":{"$error":"#NAME?"}},{"$f":"SUM(O8:O38)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"SOIT",{"$f":"INT(N41)","v":{"$error":"#NAME?"}},"Heures"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(N41-L43)*60","v":{"$error":"#NAME?"}},"Minutes"]
[]
[null,null,null,null,null,null,null,null,null,null,"CUMUL à REPORTER  M-1",null,null,null,{"$f":"NOVEMBRE!O48","v":0}]
[null,"CONGES PAYES / MALADIE / JOUR FERIE = 7 H"]
[null,null,null,null,null,null,null,null,null,null,"CUMUL à REPORTER  fin M",null,null,null,{"$f":"O46+O41","v":0}]
[null,"RECUPERATION : MENTION \"RECUP\" = CALCUL HEURES REELLES"]