{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["MO","Template","Projets","Initialisation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":6,"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":"MO","index":0,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Cliquer ici pour générer une nouvelle feuille et sélectionner le mois correspondant :"]

{"sheet":"Template","index":1,"n_rows":88,"n_cols":21,"rows_kept":88,"cut":false,"hidden":false,"merged":[[1,20,2,20],[0,2,0,16],[3,2,3,14],[4,3,4,4],[4,6,4,7],[4,9,4,10],[4,12,4,13],[4,15,4,16],[13,2,13,14],[20,2,20,14],[21,3,21,4],[21,6,21,7],[21,9,21,10],[21,12,21,13],[21,15,21,16],[30,2,30,14],[37,2,37,14],[38,3,38,4],[38,6,38,7],[38,9,38,10],[38,12,38,13],[38,15,38,16],[47,2,47,14],[54,2,54,14],[55,3,55,4],[55,6,55,7],[55,9,55,10],[55,12,55,13],[81,2,81,14],[55,15,55,16],[64,2,64,14],[71,2,71,14],[72,3,72,4],[72,6,72,7],[72,9,72,10],[72,12,72,13],[72,15,72,16]]}
[null,null,{"$f":"B2","v":"00:00:00"}]
["MOIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heures supplémentaires ",null,null,"Heures règlementaires"]
["Année",2016]
["NOM",null,{"$f":"\"semaine \"&INT(MOD(INT((MIN(C6,F6,I6,L6,O6)-2)/7)+0.6,52+5/28))+1","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H6+K6+N6+Q6+E6","v":0},{"$f":"Q4-U4","v":0},null,"Semaine 1"]
["H/semaine",35,"Lundi ",null,null,"Mardi ",null,null,"Mercredi ",null,null,"Jeudi ",null,null,"Vendredi",null,null,null,null,"Semaine 2"]
["Total Heures /Mois",{"$f":"Q4+Q21+Q38+Q55+Q72","v":0},{"$f":"IF(WEEKDAY(WORKDAY((\"1/\"&B2&\"/\"&B3)*1-1,1,Fériés))=2,WORKDAY((\"1/\"&B2&\"/\"&B3)*1-1,1,Fériés),\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"E9+E10+E11+E12+E16+E17+E18+E19","v":"00:00:00"},{"$f":"IF(C6=\"\",IF(WEEKDAY(WORKDAY((\"1/\"&B2&\"/\"&B3)*1-1,1,Fériés))=3,WORKDAY((\"1/\"&B2&\"/\"&B3)*1-1,1,Fériés),\"\"),C6+1)","v":{"$error":"#VALUE!"}},null,{"$f":"H9+H10+H11+H12+H16+H17+H18+H19","v":"00:00:00"},{"$f":"IF(F6=\"\",IF(WEEKDAY(WORKDAY((\"1/\"&B2&\"/\"&B3)*1-1,1,Fériés))=4,WORKDAY((\"1/\"&B2&\"/\"&B3)*1-1,1,Fériés),\"\"),F6+1)","v":{"$error":"#VALUE!"}},null,{"$f":"K9+K10+K11+K12+K16+K18+K17+K19","v":"00:00:00"},{"$f":"IF(I6=\"\",IF(WEEKDAY(WORKDAY((\"1/\"&B2&\"/\"&B3)*1-1,1,Fériés))=5,WORKDAY((\"1/\"&B2&\"/\"&B3)*1-1,1,Fériés),\"\"),I6+1)","v":{"$error":"#VALUE!"}},null,{"$f":"N9+N10+N11+N12+N16+N17+N18+N19","v":"00:00:00"},{"$f":"IF(L6=\"\",IF(WEEKDAY(WORKDAY((\"1/\"&B2&\"/\"&B3)*1-1,1,Fériés))=6,WORKDAY((\"1/\"&B2&\"/\"&B3)*1-1,1,Fériés),\"\"),L6+1)","v":{"$error":"#VALUE!"}},null,{"$f":"Q9+Q10+Q11+Q12+Q16+Q18+Q17+Q19","v":"00:00:00"},null,null,"Semaine 3"]
["Heures complementaires",{"$f":"R4+R21+R38+R55+R72","v":0},"PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure",null,null,"Semaine 4"]
[null,null,"Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00",null,null,"Semaine 5"]
[]
[]
[]
[]
[null,null,"Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00"]
[]
[null,null,"Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00"]
[]
[]
[]
[]
[null,null,"Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00"]
[null,null,{"$f":"\"semaine \"&INT(MOD(INT((C23-2)/7)+0.6,52+5/28))+1","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E23+H23+K23+N23+Q23","v":0},{"$f":"Q21-U5","v":0}]
[null,null,"Lundi",null,null,"mardi",null,null,"Mercredi",null,null,"Jeudi",null,null,"Vendredi"]
[null,null,{"$f":"O6+3","v":{"$error":"#VALUE!"}},null,{"$f":"E26+E27+E28+E29+E33+E34+E35+E36","v":"00:00:00"},{"$f":"C23+1","v":{"$error":"#VALUE!"}},null,{"$f":"H26+H27+H28+H29+H33+H34+H35+H36","v":"00:00:00"},{"$f":"F23+1","v":{"$error":"#VALUE!"}},null,{"$f":"K26+K27+K28+K29+K33+K34+K35+K36","v":"00:00:00"},{"$f":"I23+1","v":{"$error":"#VALUE!"}},null,{"$f":"N26+N27+N28+N29+N33+N35+N34+N36","v":"00:00:00"},{"$f":"L23+1","v":{"$error":"#VALUE!"}},null,{"$f":"Q26+Q27+Q28+Q29+Q33+Q34+Q35+Q36","v":"00:00:00"}]
[null,null,"PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure"]
[null,null,"Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00"]
[]
[]
[]
[]
[null,null,"Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00"]
[]
[null,null,"Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00"]
[]
[]
[]
[]
[null,null,"Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00"]
[null,null,{"$f":"\"semaine \"&INT(MOD(INT((C40-2)/7)+0.6,52+5/28))+1","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E40+H40+K40+N40+Q40","v":0},{"$f":"Q38-U6","v":0}]
[null,null,"Lundi",null,null,"mardi",null,null,"Mercredi",null,null,"Jeudi",null,null,"Vendredi"]
[null,null,{"$f":"O23+3","v":{"$error":"#VALUE!"}},null,{"$f":"E43+E44+E45+E46+E50+E51+E52+E53","v":"00:00:00"},{"$f":"C40+1","v":{"$error":"#VALUE!"}},null,{"$f":"H43+H44+H45+H46+H50+H51+H52+H53","v":"00:00:00"},{"$f":"F40+1","v":{"$error":"#VALUE!"}},null,{"$f":"K43+K44+K45+K46+K50+K51+K52+K53","v":"00:00:00"},{"$f":"I40+1","v":{"$error":"#VALUE!"}},null,{"$f":"N43+N44+N45+N46+N50+N52+N51+N53","v":"00:00:00"},{"$f":"L40+1","v":{"$error":"#VALUE!"}},null,{"$f":"Q43+Q44+Q45+Q46+Q50+Q51+Q52+Q53","v":"00:00:00"}]
[null,null,"PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure"]
[null,null,"Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00"]
[]
[]
[]
[]
[null,null,"Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00"]
[]
[null,null,"Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00"]
[]
[]
[]
[]
[null,null,"Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00"]
[null,null,{"$f":"\"semaine \"&INT(MOD(INT((C57-2)/7)+0.6,52+5/28))+1","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E57+H57+K57+N57+Q57","v":0},{"$f":"Q55-U7","v":0}]
[null,null,"Lundi",null,null,"mardi",null,null,"Mercredi",null,null,"Jeudi",null,null,"Vendredi"]
[null,null,{"$f":"O40+3","v":{"$error":"#VALUE!"}},null,{"$f":"E60+E61+E62+E63+E67+E68+E69+E70","v":"00:00:00"},{"$f":"C57+1","v":{"$error":"#VALUE!"}},null,{"$f":"H60+H61+H62+H63+H67+H68+H69+H70","v":"00:00:00"},{"$f":"F57+1","v":{"$error":"#VALUE!"}},null,{"$f":"K60+K61+K62+K63+K67+K68+K69+K70","v":"00:00:00"},{"$f":"I57+1","v":{"$error":"#VALUE!"}},null,{"$f":"N60+N61+N62+N63+N67+N69+N68+N70","v":"00:00:00"},{"$f":"IF(MONTH(L57+1)=MONTH(1&B2),L57+1,\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"Q60+Q61+Q62+Q63+Q67+Q68+Q69+Q70","v":"00:00:00"}]
[null,null,"PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure"]
[null,null,"Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00"]
[]
[]
[]
[]
[null,null,"Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00"]
[]
[null,null,"Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00"]
[]
[]
[]
[]
[null,null,"Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00"]
[null,null,"semaine 5",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E74+H74+K74+N74+Q74","v":0},{"$f":"Q72-U8","v":0}]
[null,null,"Lundi",null,null,"mardi",null,null,"Mercredi",null,null,"Jeudi",null,null,"Vendredi"]
[null,null,{"$f":"IF(O57=\"\",\"\",IF(MONTH(O57+3)=MONTH(1&B2),O57+3,\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"E77+E78+E79+E80+E84+E85+E86+E87","v":"00:00:00"},{"$f":"IF(C74=\"\",\"\",IF(MONTH(C74+1)=MONTH(1&B2),C74+1,\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"H77+H78+H79+H80+H84+H85+H86+H87","v":"00:00:00"},{"$f":"IF(F74=\"\",\"\",IF(MONTH(F74+1)=MONTH(1&B2),F74+1,\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"K77+K78+K79+K80+K84+K85+K86+K87","v":"00:00:00"},{"$f":"IF(I74=\"\",\"\",IF(MONTH(I74+1)=MONTH(1&B2),I74+1,\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"N77+N78+N79+N80+N84+N86+N85+N87","v":"00:00:00"},{"$f":"IF(L74=\"\",\"\",IF(MONTH(L74+1)=MONTH(1&B2),L74+1,\"\"))","v":{"$error":"#VALUE!"}},null,{"$f":"Q77+Q78+Q79+Q80+Q84+Q85+Q86+Q87","v":"00:00:00"}]
[null,null,"PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure","PROJETS","Tâches","Heure"]
[null,null,"Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00","Arrivée",null,"09:00:00"]
[]
[]
[]
[]
[null,null,"Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00","Départ",null,"12:30:00"]
[]
[null,null,"Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00","Arrivée",null,"14:00:00"]
[]
[]
[]
[]
[null,null,"Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00","Départ",null,"17:30:00"]

{"sheet":"Projets","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Projets","Production","Gestion","R & D","Maintenance","Trajet","Total heures"]
["Ile des sciences"]
["Diorren"]
["HITS"]
["DBOX"]
["Atelier"]
["Véolia"]
["Sancerre"]
["Prospection"]
["CNR"]
["Twizy"]
["Dubaï Emaar "]
["Jetpack"]

{"sheet":"Initialisation","index":3,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,1,6,2]]}
[]
[]
[null,"Année",2016]
[]
[]
[]
[null,"Jours fériés"]
[null,{"$f":"DATE(Année,1,1)","v":"2016-01-01"},"jour de l'an"]
[null,{"$f":"DATE(Année,3,29.56+0.979*MOD(204-11*MOD(Année,19),30)-WEEKDAY(DATE(Année,3,28.56+0.979*MOD(204-11*MOD(Année,19),30))))","v":"2016-03-27"},"Pâques"]
[null,{"$f":"B9+1","v":"2016-03-28"},"Lundi de Pâques"]
[null,{"$f":"DATE(Année,5,1)","v":"2016-05-01"},"Fête du travail"]
[null,{"$f":"DATE(Année,5,8)","v":"2016-05-08"},"Armistice 1945"]
[null,{"$f":"B9+39","v":"2016-05-05"},"Ascension"]
[null,{"$f":"B9+49","v":"2016-05-15"},"Pentecôte"]
[null,{"$f":"B9+50","v":"2016-05-16"},"Lundi Pentecôte"]
[null,{"$f":"DATE(Année,7,14)","v":"2016-07-14"},"Fête Nationnale"]
[null,{"$f":"DATE(Année,8,15)","v":"2016-08-15"},"Assomption"]
[null,{"$f":"DATE(Année,11,1)","v":"2016-11-01"},"Tous saint"]
[null,{"$f":"DATE(Année,11,11)","v":"2016-11-11"},"Armistice 1918"]
[null,{"$f":"DATE(Année,12,25)","v":"2016-12-25"},"25 décembre"]