{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Synthèse","Import","Données"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Synthèse","index":0,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,7,11,7],[8,7,9,7],[8,1,9,1],[10,1,11,1],[8,6,9,6],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6]]}
[]
[null,null,null,null,null,"FILIERE COMMERCE              "]
[null,null,{"$f":"Données!E1","v":"NOM PRENOM"},{"$f":"Données!C1","v":"SECTEUR"},{"$f":"Données!F1","v":"STATUT"},{"$f":"Données!A1","v":"DATE DE DEBUT"},{"$f":"Données!B1","v":"DATE DE FIN"}]
[null,null,"","",""]
[]
[]
[null,null,"Temps de travail journalier > 9H","Amplitude horaire > 11H","Repos journalier \n<11H","Jour de repos hebdomadaire < 2 jours","Badgeage manuel","Total"]
[]
[null,"Nombre total d'infractions",{"$f":"SUM(C14:C1000002)","v":0},{"$f":"SUM(D14:D1000002)","v":0},{"$f":"SUM(E14:E1000002)","v":0},{"$f":"SUM(F14:F1000002)","v":0},{"$f":"SUM(G14:G1000002)","v":0}]
[]
[null,"Cout estimé"]
[]
[]
[null,{"$f":"Données!E1","v":"NOM PRENOM"},{"$f":"Données!F1","v":"STATUT"},{"$f":"Données!G1","v":"MODULANT"},{"$f":"Données!H1","v":"Temps travail journalier > 9h"},{"$f":"Données!I1","v":"Amplitude journaliere > 11h"},{"$f":"Données!J1","v":"Repos journalier < 11h"},{"$f":"Données!K1","v":"Jour de repos hebdomadaire < 2 jours"},{"$f":"Données!L1","v":"Badgeage manuel"}]

{"sheet":"Import","index":1,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["1er jour de la semaine",{"$f":"MID(A5,32,10)","v":"01/01/2018"}]
["Dernier jour de la semaine",{"$f":"MID(A5,46,10)","v":"07/01/2018"}]
[]
["<LIMOGES / Etat des alertes du 01/01/2018 au 07/01/2018"]
["Secteur","Matricule","Nom-prenom","Statut","Modulant","Temps travail journalier > 9h","Amplitude journaliÃ¨re > 11h","repos journalier < 11h","Jour de repos hebdomadaire < 2 jours","Badgeage manuel"]
["SECTEUR BOIS BATI             ",1,"NOM 1","AGENT DE MAITRISE             ","N",1,0,0,0,0]
["SECTEUR BOIS BATI             ",2,"NOM 2","EMPLOYE                       ","O",0,1,0,0,0]
["FILIERE COMMERCE              ",2,"NOM 3","CADRE                         ","N",0,0,1,0,0]
["SECTEUR SERVICES              ",2,"NOM 4","EMPLOYE                       ","N",0,0,0,1,1]
["SERVICE LOGISTIQUE            ",2,"NOM 5","EMPLOYE                       ","O",0,0,0,0,0]
["SERVICE CAISSES               ",2,"NOM 6","EMPLOYE                       ","O",0,0,0,0,0]
["SECTEUR DECORATION            ",2,"NOM 7","AGENT DE MAITRISE             ","N",0,1,0,0,0]
["SERVICE ADMINISTRATIF         ",2,"NOM 8","AGENT DE MAITRISE             ","N",0,0,0,0,0]
["SECTEUR TECHNIQUE             ",2,"NOM 9","EMPLOYE                       ","N",0,0,0,0,0]
["SERVICE LOGISTIQUE            ",2,"NOM 10","EMPLOYE                       ","O",1,0,0,0,0]
["SECTEUR JARDIN",2,"NOM 11","EMPLOYE                       ","O",0,0,0,0,0]
["SERVICE LOGISTIQUE            ",2,"NOM 12","EMPLOYE                       ","O",0,0,0,0,0]
["SECTEUR TECHNIQUE             ",2,"NOM 13","AGENT DE MAITRISE             ","N",0,0,0,0,0]
["SECTEUR AMENAGEMENT           ",2,"NOM 14","AGENT DE MAITRISE             ","N",0,0,0,0,0]

{"sheet":"Données","index":2,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["DATE DE DEBUT","DATE DE FIN","SECTEUR","MATRICULE","NOM PRENOM","STATUT","MODULANT","Temps travail journalier > 9h","Amplitude journaliere > 11h","Repos journalier < 11h","Jour de repos hebdomadaire < 2 jours","Badgeage manuel"]
["2018-01-01","2018-01-07","FILIERE COMMERCE              ",2,"NOM 3","CADRE                         ","N",0,0,1,0,0]
["2018-01-01","2018-01-07","SECTEUR BOIS BATI             ",1,"NOM 1","AGENT DE MAITRISE             ","N",1,0,0,0,0]
["2018-01-01","2018-01-05","SECTEUR BOIS BATI             ",2,"NOM 2","EMPLOYE                       ","O",0,1,0,0,0]
["2018-01-01","2018-01-07","SECTEUR DECORATION            ",2,"NOM 7","AGENT DE MAITRISE             ","N",0,1,0,0,0]
["2018-01-01","2018-01-07","SECTEUR SERVICES              ",2,"NOM 4","EMPLOYE                       ","N",0,0,0,1,1]
["2018-01-01","2018-01-07","SERVICE LOGISTIQUE            ",2,"NOM 10","EMPLOYE                       ","O",1,0,0,0,0]