{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ZONAGE","ENREGISTREMENT","Feuil1","DONNEENET"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":57,"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":"ZONAGE","index":0,"n_rows":54,"n_cols":43,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["ZONE",null,"Plonge","Chaud","Froid","Envoi","Office","Réserve",null,"Machine_à_laver","Zone_de_lavage","Étagère","Mur",null,"Four_mixte","Four_statique","Buffet","Piano","Hotte",null,"Évier","Espace_froid","Armoire_NEGG","Armoire_NEGD",null,"Espace_envoi","Double_portes","Cellule","Tour_PC","Sol",null,"Réception","Armoire_boissons","Buffet_office","Légumerie",null,"Étagères","Coffre","Vestiaire",null,"Lave",null,"Semaine"]
["Plonge",null,"Machine_à_laver","Four_mixte","Évier","Espace_envoi","Réception","Étagères",null,"Cuve","Plan_de_plonge","Etagère","Mur",null,"Cuve","Cuve","Tiroir_légumes","Plaque cuisson","Grilles",null,"Bac_plonge","Étagère_vitre","Intérieur","Intérieur",null,"Étagère_passe","Intérieur","Intérieur","Four_MO","Égout1",null,"Plan-de_réception","Intérieur","Intérieur","Intérieur",null,"Étagère_denrée","Intérieur","Intérieur",null,"Nettoyé",null,1]
["Chaud",null,"Zone_de_lavage","Four_statique","Espace_froid","Double_portes","Armoire_boissons","Coffre",null,"Façade","Muret_verre",null,null,null,"Façade","Façade","Tiroir_viande","Gril","Façade",null,"Mur","Vitre","Façade","Façade",null,"Mur","Façade","Façade","Turbine","Égout2",null,"Lave_mains","Façade","Façade","Façade",null,"Étagère_lessive","Façade","Façade",null,"Assainie",null,2]
["Froid",null,"Étagère","Buffet_froid","Armoire_NEGG","Cellule","Buffet_office","Vestiaire",null,"Cuve_&_façade","Sousbassement",null,null,null,"Dessus","Ensemble","Tiroir_poisson","Bain_marie","Ensemble",null,"Étagère_bac","Plan_de_travail","Ensemble","Ensemble",null,"Plan_de_travail","Ensemble","Ensemble","Muret",null,null,"Muret_envoi","Ensemble","Ensemble","Ensemble",null,"Sol_réserve","Ensemble","Ensemble",null,"Désinfecté",null,3]
["Envoi",null,"Mur","Piano","Armoire_NEGD","Tour_PC","Légumerie",null,null,null,"Étagère_plonge",null,null,null,"Ensemble",null,"tiroir_sauce","Plan_de_travail",null,null,"Sousbassement","Ensemble",null,null,null,"Ensemble",null,null,"Étagère_PC",null,null,"Porte_sortie",null,"Étagère_off",null,null,null,null,"Tapis",null,"Décapé",null,4]
["Office",null,null,"Hotte","Sol","Sol",null,null,null,null,"Plonge",null,null,null,null,null,"Tiroir_plats","Crédence",null,null,"Ensemble",null,null,null,null,null,null,null,null,null,null,"Porte_accès_cuisine",null,"Muret_plonge",null,null,null,null,null,null,"Dégraissé",null,5]
["Réserve",null,null,null,null,null,null,null,null,null,"Espace_complet",null,null,null,null,null,"Façade","Tiroir_ustensil",null,null,null,null,null,null,null,null,null,null,null,null,null,"Porte_accès_salle",null,"M.glaçon",null,null,null,null,null,null,"Ramonée",null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ensemble","Ensemble",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,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,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,null,null,null,null,null,null,null,null,null,null,null,9]
[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,10]
[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,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,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,null,null,null,null,null,null,null,null,null,null,null,13]
[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,14]
[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,15]
[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,16]
[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,17]
[null,null,null,null,null,null,null,null,null,"Nettoyé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,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,"Assainissement",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,19]
[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,20]
[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,21]
[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,22]
[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,23]
[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,24]
[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,25]
[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,26]
[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,27]
[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,28]
[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,29]
[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,30]
[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,31]
[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,32]
[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,33]
[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,34]
[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,35]
[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,36]
[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,37]
[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,38]
[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,39]
[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,40]
[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,41]
[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,42]
[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,43]
[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,44]
[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,45]
[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,46]
[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,47]
[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,48]
[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,49]
[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,50]
[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,51]
[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,52]
[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,53]

{"sheet":"ENREGISTREMENT","index":1,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[19,1,19,7],[15,1,15,7],[16,1,16,7],[4,5,4,6],[13,1,14,7],[17,1,18,7]]}
[]
[null,"N° d'ordre","Date","Heure"]
[null,{"$f":"MAX(DONNEENET!A:A)+1","v":73},{"$f":"TODAY()+11","v":"2015-09-10"},{"$f":"NOW()","v":42246.241726388886}]
[]
[null,"Semaine",37,null,null,"Heures effectuées",null,{"$f":"SUM(B12:H12)","v":5.6115740590030327E-3},null,null,{"$f":"C5","v":37}]
[]
[null,{"$f":"IFERROR(INDEX((DONNEENET!B:B),MATCH(ROW(DONNEENET!G1),DONNEENET!G:G,0)),\"\")","v":"2015-09-07"},{"$f":"IFERROR(INDEX((DONNEENET!B:B),MATCH(ROW(DONNEENET!G5),DONNEENET!G:G,0)),\"\")","v":"2015-09-08"},{"$f":"IFERROR(INDEX((DONNEENET!B:B),MATCH(ROW(DONNEENET!G9),DONNEENET!G:G,0)),\"\")","v":"2015-09-09"},{"$f":"IFERROR(INDEX((DONNEENET!B:B),MATCH(ROW(DONNEENET!G13),DONNEENET!G:G,0)),\"\")","v":"2015-09-10"},{"$f":"IFERROR(INDEX((DONNEENET!B:B),MATCH(ROW(DONNEENET!G17),DONNEENET!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX((DONNEENET!B:B),MATCH(ROW(DONNEENET!G21),DONNEENET!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX((DONNEENET!B:B),MATCH(ROW(DONNEENET!G25),DONNEENET!G:G,0)),\"\")","v":""}]
["Heures de prise de poste",{"$f":"IFERROR(VLOOKUP(B$7,DONNEENET!$B:$C,2,0),0)","v":42246.155146180557},{"$f":"IFERROR(VLOOKUP(C$7,DONNEENET!$B:$C,2,0),0)","v":42246.160185300927},{"$f":"IFERROR(VLOOKUP(D$7,DONNEENET!$B:$C,2,0),0)","v":42246.168280208331},{"$f":"IFERROR(VLOOKUP(E$7,DONNEENET!$B:$C,2,0),0)","v":42246.170578240744},{"$f":"IFERROR(VLOOKUP(F$7,DONNEENET!$B:$C,2,0),0)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(G$7,DONNEENET!$B:$C,2,0),0)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(H$7,DONNEENET!$B:$C,2,0),0)","v":"00:00:00"}]
["Pause ou Départ",{"$f":"IFERROR(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(B$7,DONNEENET!$B:$B,0)),1,1),0)","v":42246.155156828703},{"$f":"IFERROR(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(C$7,DONNEENET!$B:$B,0)),1,1),0)","v":42246.160192592593},{"$f":"IFERROR(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(D$7,DONNEENET!$B:$B,0)),1,1),0)","v":42246.16830208333},{"$f":"IFERROR(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(E$7,DONNEENET!$B:$B,0)),1,1),0)","v":42246.17058622685},{"$f":"IFERROR(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(F$7,DONNEENET!$B:$B,0)),1,1),0)","v":"00:00:00"},{"$f":"IFERROR(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(G$7,DONNEENET!$B:$B,0)),1,1),0)","v":"00:00:00"},{"$f":"IFERROR(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(H$7,DONNEENET!$B:$B,0)),1,1),0)","v":"00:00:00"}]
["Reprise",{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(B$7,DONNEENET!$B:$B,0)),2,0)=B$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(B$7,DONNEENET!$B:$B,0)),0,0)=B$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(B$7,DONNEENET!$B:$B,0)),2,1),0),0)","v":42246.155163310184},{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(C$7,DONNEENET!$B:$B,0)),2,0)=C$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(C$7,DONNEENET!$B:$B,0)),0,0)=C$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(C$7,DONNEENET!$B:$B,0)),2,1),0),0)","v":42246.160198495367},{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(D$7,DONNEENET!$B:$B,0)),2,0)=D$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(D$7,DONNEENET!$B:$B,0)),0,0)=D$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(D$7,DONNEENET!$B:$B,0)),2,1),0),0)","v":"00:00:00"},{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(E$7,DONNEENET!$B:$B,0)),2,0)=E$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(E$7,DONNEENET!$B:$B,0)),0,0)=E$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(E$7,DONNEENET!$B:$B,0)),2,1),0),0)","v":42246.170598495373},{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(F$7,DONNEENET!$B:$B,0)),2,0)=F$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(F$7,DONNEENET!$B:$B,0)),0,0)=F$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(F$7,DONNEENET!$B:$B,0)),2,1),0),0)","v":"00:00:00"},{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(G$7,DONNEENET!$B:$B,0)),2,0)=G$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(G$7,DONNEENET!$B:$B,0)),0,0)=G$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(G$7,DONNEENET!$B:$B,0)),2,1),0),0)","v":"00:00:00"},{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(H$7,DONNEENET!$B:$B,0)),2,0)=H$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(H$7,DONNEENET!$B:$B,0)),0,0)=H$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(H$7,DONNEENET!$B:$B,0)),2,1),0),0)","v":"00:00:00"}]
["Départ",{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(B$7,DONNEENET!$B:$B,0)),3,0)=B$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(B$7,DONNEENET!$B:$B,0)),0,0)=B$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(B$7,DONNEENET!$B:$B,0)),3,1),0),0)","v":42246.159863773151},{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(C$7,DONNEENET!$B:$B,0)),3,0)=C$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(C$7,DONNEENET!$B:$B,0)),0,0)=C$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(C$7,DONNEENET!$B:$B,0)),3,1),0),0)","v":42246.160204629632},{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(D$7,DONNEENET!$B:$B,0)),3,0)=D$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(D$7,DONNEENET!$B:$B,0)),0,0)=D$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(D$7,DONNEENET!$B:$B,0)),3,1),0),0)","v":"00:00:00"},{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(E$7,DONNEENET!$B:$B,0)),3,0)=E$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(E$7,DONNEENET!$B:$B,0)),0,0)=E$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(E$7,DONNEENET!$B:$B,0)),3,1),0),0)","v":42246.171455671298},{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(F$7,DONNEENET!$B:$B,0)),3,0)=F$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(F$7,DONNEENET!$B:$B,0)),0,0)=F$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(F$7,DONNEENET!$B:$B,0)),3,1),0),0)","v":"00:00:00"},{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(G$7,DONNEENET!$B:$B,0)),3,0)=G$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(G$7,DONNEENET!$B:$B,0)),0,0)=G$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(G$7,DONNEENET!$B:$B,0)),3,1),0),0)","v":"00:00:00"},{"$f":"IFERROR(IF(AND(OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(H$7,DONNEENET!$B:$B,0)),3,0)=H$7,OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(H$7,DONNEENET!$B:$B,0)),0,0)=H$7),OFFSET(INDIRECT(\"DONNEENET!B\"&MATCH(H$7,DONNEENET!$B:$B,0)),3,1),0),0)","v":"00:00:00"}]
[null,{"$f":"SUM(B9+B11-B10-B8)","v":"00:06:47.040"},{"$f":"SUM(C9+C11-C10-C8)","v":"00:00:01.160"},"00:00:01.890",{"$f":"SUM(E9+E11-E10-E8)","v":"00:01:14.750"},"00:00:00","00:00:00","00:00:00"]
[]
[null,"Explication: Lorsque l'on sélectionne le n° de semaine en CELLULE C5 apparait dans le tableau en dessous les jours et les heures effectués durant la semaine sélectionnée"]
[]
[null,"Les données qui apparaissent dans les cellule du tableau proviennent de la feuille DONNEENET"]
[null,"Problème 1 Les cellules non complètées provoquent un calcul impossible ( #VALEUR!)"]
[null,"Problème 2: Les cellule qui n'ont pas complétées sur leur journées le sont par celle du jour suivant, créant ainsi un décalage (Exemple: Les valeurs de D10 ET D11 auraient dû s'afficher en E8 et E9 tandis que celles en E8 et E9 devraient être en E10 et E11"]

{"sheet":"Feuil1","index":2,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Nom","Lieu","Naissance","Math ","Français","Science","Moyenne"]
["Tangui","Bruxelles","1998-02-05",8,6,8,7.333333333333333]
["Magalie","Mons","1997-11-11",9,7,8,8]
["Isabelle","Liège","1997-04-12",6,7,5,6]
["Stéphane","Bruxelles","1997-07-13",7,9,8,8]
["Alain","Liège","1997-12-03",10,8,9,9]
["Philippe","Bruxelles","1998-03-02",8,8,7,7.666666666666667]
["Marie","Namur","1997-06-03",7,10,8,8.3333333333333339]

{"sheet":"DONNEENET","index":3,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,8,0,9],[1,8,1,9]]}
["N° d'ordre","Date d'intervention","Lieu d'intervention","Equipement traité","Partie","Action menée","N° ATTRIB","Semaine","Réalisations effectuées"]
[0,null,null,null,null,null,{"$f":"IF(H2=Enr_select_sem,MAX($G$1:G1)+1,\"\")","v":""},{"$f":"WEEKNUM(B2,2)","v":1},{"$f":"IFERROR(INDEX(C:C,MATCH(ROW(G1),G:G,0)),\"\")","v":42246.155146180557},null,1]
[1,"2015-08-30",42246.132549189817,null,null,null,{"$f":"IF(H3=Enr_select_sem,MAX($G$1:G2)+1,\"\")","v":""},{"$f":"WEEKNUM(B3,2)","v":35},null,null,1]
[2,"2015-08-30",42246.132904976854,null,null,null,{"$f":"IF(H4=Enr_select_sem,MAX($G$1:G3)+1,\"\")","v":""},35]
[3,"2015-08-30",42246.132937731483,null,null,null,{"$f":"IF(H5=Enr_select_sem,MAX($G$1:G4)+1,\"\")","v":""},35]
[4,"2015-08-30",42246.13295752315,null,null,null,{"$f":"IF(H6=Enr_select_sem,MAX($G$1:G5)+1,\"\")","v":""},35]
[31,"2015-08-31",42246.153339236109,null,null,null,{"$f":"IF(H7=Enr_select_sem,MAX($G$1:G6)+1,\"\")","v":""},36]
[32,"2015-08-31",42246.153796759259,null,null,null,{"$f":"IF(H8=Enr_select_sem,MAX($G$1:G7)+1,\"\")","v":""},36]
[33,"2015-08-31",42246.153804513888,null,null,null,{"$f":"IF(H9=Enr_select_sem,MAX($G$1:G8)+1,\"\")","v":""},36]
[34,"2015-08-31",42246.153820949075,null,null,null,{"$f":"IF(H10=Enr_select_sem,MAX($G$1:G9)+1,\"\")","v":""},36]
[35,"2015-09-01",42246.153981481482,null,null,null,{"$f":"IF(H11=Enr_select_sem,MAX($G$1:G10)+1,\"\")","v":""},36]
[36,"2015-09-01",42246.153988194441,null,null,null,{"$f":"IF(H12=Enr_select_sem,MAX($G$1:G11)+1,\"\")","v":""},36]
[37,"2015-09-01",42246.153993171298,null,null,null,{"$f":"IF(H13=Enr_select_sem,MAX($G$1:G12)+1,\"\")","v":""},36]
[38,"2015-09-01",42246.153998379632,null,null,null,{"$f":"IF(H14=Enr_select_sem,MAX($G$1:G13)+1,\"\")","v":""},36]
[39,"2015-09-02",42246.154144675929,null,null,null,{"$f":"IF(H15=Enr_select_sem,MAX($G$1:G14)+1,\"\")","v":""},36]
[40,"2015-09-02",42246.154150115741,null,null,null,{"$f":"IF(H16=Enr_select_sem,MAX($G$1:G15)+1,\"\")","v":""},36]
[41,"2015-09-02",42246.15415509259,null,null,null,{"$f":"IF(H17=Enr_select_sem,MAX($G$1:G16)+1,\"\")","v":""},36]
[42,"2015-09-02",42246.154159722224,null,null,null,{"$f":"IF(H18=Enr_select_sem,MAX($G$1:G17)+1,\"\")","v":""},36]
[43,"2015-09-03",42246.154257175927,null,null,null,{"$f":"IF(H19=Enr_select_sem,MAX($G$1:G18)+1,\"\")","v":""},36]
[44,"2015-09-03",42246.154264930556,null,null,null,{"$f":"IF(H20=Enr_select_sem,MAX($G$1:G19)+1,\"\")","v":""},36]
[45,"2015-09-03",42246.154370949072,null,null,null,{"$f":"IF(H21=Enr_select_sem,MAX($G$1:G20)+1,\"\")","v":""},36]
[46,"2015-09-03",42246.154379861109,null,null,null,{"$f":"IF(H22=Enr_select_sem,MAX($G$1:G21)+1,\"\")","v":""},36]
[47,"2015-09-04",42246.154687037037,null,null,null,{"$f":"IF(H23=Enr_select_sem,MAX($G$1:G22)+1,\"\")","v":""},36]
[48,"2015-09-04",42246.154693634257,null,null,null,{"$f":"IF(H24=Enr_select_sem,MAX($G$1:G23)+1,\"\")","v":""},36]
[49,"2015-09-04",42246.154700115738,null,null,null,{"$f":"IF(H25=Enr_select_sem,MAX($G$1:G24)+1,\"\")","v":""},36]
[50,"2015-09-04",42246.154707407404,null,null,null,{"$f":"IF(H26=Enr_select_sem,MAX($G$1:G25)+1,\"\")","v":""},36]
[51,"2015-09-05",42246.154808101855,null,null,null,{"$f":"IF(H27=Enr_select_sem,MAX($G$1:G26)+1,\"\")","v":""},36]
[52,"2015-09-05",42246.154819212963,null,null,null,{"$f":"IF(H28=Enr_select_sem,MAX($G$1:G27)+1,\"\")","v":""},36]
[53,"2015-09-05",42246.154826157406,null,null,null,{"$f":"IF(H29=Enr_select_sem,MAX($G$1:G28)+1,\"\")","v":""},36]
[54,"2015-09-05",42246.154834374996,null,null,null,{"$f":"IF(H30=Enr_select_sem,MAX($G$1:G29)+1,\"\")","v":""},36]
[55,"2015-09-06",42246.154997453705,null,null,null,{"$f":"IF(H31=Enr_select_sem,MAX($G$1:G30)+1,\"\")","v":""},36]
[56,"2015-09-06",42246.155003240739,null,null,null,{"$f":"IF(H32=Enr_select_sem,MAX($G$1:G31)+1,\"\")","v":""},36]
[57,"2015-09-06",42246.155009027774,null,null,null,{"$f":"IF(H33=Enr_select_sem,MAX($G$1:G32)+1,\"\")","v":""},36]
[58,"2015-09-06",42246.155015393517,null,null,null,{"$f":"IF(H34=Enr_select_sem,MAX($G$1:G33)+1,\"\")","v":""},36]
[59,"2015-09-07",42246.155146180557,null,null,null,{"$f":"IF(H35=Enr_select_sem,MAX($G$1:G34)+1,\"\")","v":1},37]
[60,"2015-09-07",42246.155156828703,null,null,null,{"$f":"IF(H36=Enr_select_sem,MAX($G$1:G35)+1,\"\")","v":2},37]
[61,"2015-09-07",42246.155163310184,null,null,null,{"$f":"IF(H37=Enr_select_sem,MAX($G$1:G36)+1,\"\")","v":3},37]
[62,"2015-09-07",42246.159863773151,null,null,null,{"$f":"IF(H38=Enr_select_sem,MAX($G$1:G37)+1,\"\")","v":4},37]
[63,"2015-09-08",42246.160185300927,null,null,null,{"$f":"IF(H39=Enr_select_sem,MAX($G$1:G38)+1,\"\")","v":5},37]
[64,"2015-09-08",42246.160192592593,null,null,null,{"$f":"IF(H40=Enr_select_sem,MAX($G$1:G39)+1,\"\")","v":6},37]
[65,"2015-09-08",42246.160198495367,null,null,null,{"$f":"IF(H41=Enr_select_sem,MAX($G$1:G40)+1,\"\")","v":7},37]
[66,"2015-09-08",42246.160204629632,null,null,null,{"$f":"IF(H42=Enr_select_sem,MAX($G$1:G41)+1,\"\")","v":8},37]
[67,"2015-09-09",42246.168280208331,null,null,null,{"$f":"IF(H43=Enr_select_sem,MAX($G$1:G42)+1,\"\")","v":9},37]
[68,"2015-09-09",42246.16830208333,null,null,null,{"$f":"IF(H44=Enr_select_sem,MAX($G$1:G43)+1,\"\")","v":10},37]
[69,"2015-09-10",42246.170578240744,null,null,null,{"$f":"IF(H45=Enr_select_sem,MAX($G$1:G44)+1,\"\")","v":11},37]
[70,"2015-09-10",42246.17058622685,null,null,null,{"$f":"IF(H46=Enr_select_sem,MAX($G$1:G45)+1,\"\")","v":12},37]
[71,"2015-09-10",42246.170598495373,null,null,null,{"$f":"IF(H47=Enr_select_sem,MAX($G$1:G46)+1,\"\")","v":13},37]
[72,"2015-09-10",42246.171455671298,null,null,null,{"$f":"IF(H48=Enr_select_sem,MAX($G$1:G47)+1,\"\")","v":14},37]