{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INDEX","pointage","relevé"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"INDEX","index":0,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,36,17],[29,4,30,13],[2,13,3,19]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pointage journalier - Atelier / Chantier"]

{"sheet":"pointage","index":1,"n_rows":35,"n_cols":83,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,21,2,23],[16,16,16,17],[16,5,16,6],[19,16,19,17],[22,9,22,11],[19,5,19,6],[19,8,19,9],[19,11,19,12],[15,16,15,17],[14,16,14,17],[20,8,20,9],[11,14,11,16],[12,14,12,20],[8,9,8,11],[12,1,12,2],[14,1,14,3],[14,5,14,6],[14,11,14,12],[26,11,26,12],[17,5,17,6],[17,16,17,17],[10,1,10,2],[10,4,10,5],[14,8,14,9],[20,11,20,12],[23,9,23,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 - CHANTIER",null,"repas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 - ATELIER",null,"hôtel",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 - SORTIE ACHATS",null,"paris",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 - SORTIE DEVIS",null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - NETTOYAGE ATELIER",null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - ATTENTE ATELIER",null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7 - FERIE",null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"Frédéric Gueudet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8 - CONGES PAYES",null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"Julien Manteau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9 - CONGE MALADIE",null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"Nicolas Quennesson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 - CONGE PATERNITE",null,null,null,9]
[null,"Nom & Prénom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"Aurélien Dizier",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11 - CONGE EXC. NAISSANCE",null,null,null,10]
[null,null,null,null,"jour","mois","année",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,"Charles Leclercq",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12 - CONGE EXC. DECES",null,null,null,11]
[null,"Entrez la date",null,null,null,null,null,null,"Aujourd'hui, nous sommes le ",null,null,null,null,null,{"$f":"TODAY()","v":"2014-01-06"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,"Thierry Sarrazin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13 - CONGE EXC. MARIAGE",null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,"Alberto Harasse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14 - CONGE EXC. MALADIE ENFANT"]
[null,"Détail(s) de votre journée",null,null,null,"motif(s)",null,null,"heures travaillées",null,null,"heures de route",null,null,"n° fiche",null,"nom du client",null,null,"panier",null,null,null,null,null,null,null,null,null,null,null,13,null,"Tony Abrassart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15 - FORMATION"]
[null,null,null,null,null,null,null,null,"h","min",null,"h","min",null,"obligatoire",null,"obligatoire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,null,"Contrats"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,"Intérimaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sous-traitance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,null,null,null,null,null,null,null,"total Hrs travaillées",null,null,"total Hrs de route",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043]
[null,null,null,null,null,null,null,null,{"$f":"SUM(TIME(I17,J17,0),TIME(I18,J18,0))","v":"00:00:00"},null,null,{"$f":"SUM(TIME(L17,M17,0),TIME(L18,M18,0))","v":"00:00:00"}]
[]
[null,null,null,null,null,null,null,null,null,"soit"]
[null,null,null,null,null,null,null,null,null,{"$f":"I21+L21","v":"00:00:00"}]
[]
[]
[{"$f":"CONCATENATE(E11)","v":""},{"$f":"DATE(G13,F13,E13)","v":{"$error":"#NUM!"}},{"$f":"CONCATENATE(F17)","v":""},{"$f":"TIME(I17,J17,0)","v":"00:00:00"},{"$f":"TIME(L17,M17,0)","v":"00:00:00"},{"$f":"CONCATENATE(O17)","v":""},{"$f":"CONCATENATE(Q17)","v":""},{"$f":"CONCATENATE(T17)","v":""}]
[{"$f":"CONCATENATE(E11)","v":""},{"$f":"DATE(G13,F13,E13)","v":{"$error":"#NUM!"}},{"$f":"CONCATENATE(F18)","v":""},{"$f":"TIME(I18,J18,0)","v":"00:00:00"},{"$f":"TIME(L18,M18,0)","v":"00:00:00"},{"$f":"CONCATENATE(O18)","v":""},{"$f":"CONCATENATE(Q18)","v":""},{"$f":"CONCATENATE(T18)","v":""}]
[]
["Nicolas Quennesson","2026-04-05","12 - CONGE EXC. DECES","00:00:00","00:00:00","","",""]
["Nicolas Quennesson","2026-04-05","14 - CONGE EXC. MALADIE ENFANT","00:00:00","00:00:00","","",""]
["Aurélien Dizier","2020-05-05","6 - ATTENTE ATELIER","00:00:00","00:00:00","","","repas"]
["Aurélien Dizier","2020-05-05","4 - SORTIE DEVIS","00:00:00","00:00:00","","","paris"]
["Charles Leclercq","2013-08-05","8 - CONGES PAYES","00:00:00","00:00:00","","",""]
["Charles Leclercq","2013-08-05","7 - FERIE","00:00:00","00:00:00","","",""]

{"sheet":"relevé","index":2,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,10,0,11],[0,15,0,16]]}
["nom","date","motifs","hrs travaillées","hrs de route","n° fiche","client","panier"]
["Nicolas Quennesson","2026-04-05","12 - CONGE EXC. DECES","00:00:00","00:00:00","","",""]
["Nicolas Quennesson","2026-04-05","14 - CONGE EXC. MALADIE ENFANT","00:00:00","00:00:00","","",""]
["Aurélien Dizier","2020-05-05","6 - ATTENTE ATELIER","00:00:00","00:00:00","","","repas"]
["Aurélien Dizier","2020-05-05","4 - SORTIE DEVIS","00:00:00","00:00:00","","","paris"]
["Charles Leclercq","2013-08-05","8 - CONGES PAYES","00:00:00","00:00:00","","",""]
["Charles Leclercq","2013-08-05","7 - FERIE","00:00:00","00:00:00","","",""]