{"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.350047569445}]
[]
[null,"Semaine",37,null,null,"Heures effectuées",null,{"$f":"SUM(B12:H12)","v":"00:08:04.840"},null,null,{"$f":"C5","v":37}]
[]
[null,{"$f":"IFERROR(INDEX(Champ[],MATCH(COLUMN()-1,DONNEENET!$G:$G,0),2),\"\")","v":"2015-09-07"},{"$f":"IFERROR(INDEX(Champ[],MATCH(COLUMN()-1,DONNEENET!$G:$G,0),2),\"\")","v":"2015-09-08"},{"$f":"IFERROR(INDEX(Champ[],MATCH(COLUMN()-1,DONNEENET!$G:$G,0),2),\"\")","v":"2015-09-09"},{"$f":"IFERROR(INDEX(Champ[],MATCH(COLUMN()-1,DONNEENET!$G:$G,0),2),\"\")","v":"2015-09-10"},{"$f":"IFERROR(INDEX(Champ[],MATCH(COLUMN()-1,DONNEENET!$G:$G,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Champ[],MATCH(COLUMN()-1,DONNEENET!$G:$G,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(Champ[],MATCH(COLUMN()-1,DONNEENET!$G:$G,0),2),\"\")","v":""}]
["Heures de prise de poste",{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(B$7,DONNEENET!$B:$B,0),3),\"\")","v":42246.155146180557},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(C$7,DONNEENET!$B:$B,0),3),\"\")","v":42246.160185300927},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(D$7,DONNEENET!$B:$B,0),3),\"\")","v":42246.168280208331},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(E$7,DONNEENET!$B:$B,0),3),\"\")","v":42246.170578240744},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(F$7,DONNEENET!$B:$B,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(G$7,DONNEENET!$B:$B,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(H$7,DONNEENET!$B:$B,0),3),\"\")","v":""}]
["Pause ou Départ",{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(B$7,DONNEENET!$B:$B,0)+1,3),\"\")","v":42246.155156828703},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(C$7,DONNEENET!$B:$B,0)+1,3),\"\")","v":42246.160192592593},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(D$7,DONNEENET!$B:$B,0)+1,3),\"\")","v":42246.16830208333},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(E$7,DONNEENET!$B:$B,0)+1,3),\"\")","v":42246.17058622685},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(F$7,DONNEENET!$B:$B,0)+1,3),\"\")","v":""},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(G$7,DONNEENET!$B:$B,0)+1,3),\"\")","v":""},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(H$7,DONNEENET!$B:$B,0)+1,3),\"\")","v":""}]
["Reprise",{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(B$7,DONNEENET!$B:$B,0)+2,3))","v":42246.155163310184},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(C$7,DONNEENET!$B:$B,0)+2,3))","v":42246.160198495367},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(D$7,DONNEENET!$B:$B,0)+2,3))","v":""},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(E$7,DONNEENET!$B:$B,0)+2,3))","v":42246.170598495373},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(F$7,DONNEENET!$B:$B,0)+2,3))","v":""},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(G$7,DONNEENET!$B:$B,0)+2,3))","v":""},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(H$7,DONNEENET!$B:$B,0)+2,3))","v":""}]
["Départ",{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(B$7,DONNEENET!$B:$B,0)+3,3))","v":42246.159863773151},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(C$7,DONNEENET!$B:$B,0)+3,3))","v":42246.160204629632},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(D$7,DONNEENET!$B:$B,0)+3,3))","v":""},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(E$7,DONNEENET!$B:$B,0)+3,3))","v":42246.171455671298},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(F$7,DONNEENET!$B:$B,0)+3,3))","v":""},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(G$7,DONNEENET!$B:$B,0)+3,3))","v":""},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(H$7,DONNEENET!$B:$B,0)+3,3))","v":""}]
[null,{"$f":"SUM(B9,B11)-SUM(B8,B10)","v":"00:06:47.040"},{"$f":"SUM(C9,C11)-SUM(C8,C10)","v":"00:00:01.160"},"00:00:01.890","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(AND(B2=B1,H2=Enr_select_sem),G1,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,{"$f":"Enr_select_sem","v":37}]
[1,"2015-08-30",42246.132549189817,null,null,null,{"$f":"IF(AND(B3=B2,H3=Enr_select_sem),G2,IF(H3=Enr_select_sem,MAX($G$1:G2)+1,\"\"))","v":""},{"$f":"WEEKNUM(B3,2)","v":35}]
[2,"2015-08-30",42246.132904976854,null,null,null,{"$f":"IF(AND(B4=B3,H4=Enr_select_sem),G3,IF(H4=Enr_select_sem,MAX($G$1:G3)+1,\"\"))","v":""},35]
[3,"2015-08-30",42246.132937731483,null,null,null,{"$f":"IF(AND(B5=B4,H5=Enr_select_sem),G4,IF(H5=Enr_select_sem,MAX($G$1:G4)+1,\"\"))","v":""},35]
[4,"2015-08-30",42246.13295752315,null,null,null,{"$f":"IF(AND(B6=B5,H6=Enr_select_sem),G5,IF(H6=Enr_select_sem,MAX($G$1:G5)+1,\"\"))","v":""},35]
[31,"2015-08-31",42246.153339236109,null,null,null,{"$f":"IF(AND(B7=B6,H7=Enr_select_sem),G6,IF(H7=Enr_select_sem,MAX($G$1:G6)+1,\"\"))","v":""},36]
[32,"2015-08-31",42246.153796759259,null,null,null,{"$f":"IF(AND(B8=B7,H8=Enr_select_sem),G7,IF(H8=Enr_select_sem,MAX($G$1:G7)+1,\"\"))","v":""},36]
[33,"2015-08-31",42246.153804513888,null,null,null,{"$f":"IF(AND(B9=B8,H9=Enr_select_sem),G8,IF(H9=Enr_select_sem,MAX($G$1:G8)+1,\"\"))","v":""},36]
[34,"2015-08-31",42246.153820949075,null,null,null,{"$f":"IF(AND(B10=B9,H10=Enr_select_sem),G9,IF(H10=Enr_select_sem,MAX($G$1:G9)+1,\"\"))","v":""},36]
[35,"2015-09-01",42246.153981481482,null,null,null,{"$f":"IF(AND(B11=B10,H11=Enr_select_sem),G10,IF(H11=Enr_select_sem,MAX($G$1:G10)+1,\"\"))","v":""},36]
[36,"2015-09-01",42246.153988194441,null,null,null,{"$f":"IF(AND(B12=B11,H12=Enr_select_sem),G11,IF(H12=Enr_select_sem,MAX($G$1:G11)+1,\"\"))","v":""},36]
[37,"2015-09-01",42246.153993171298,null,null,null,{"$f":"IF(AND(B13=B12,H13=Enr_select_sem),G12,IF(H13=Enr_select_sem,MAX($G$1:G12)+1,\"\"))","v":""},36]
[38,"2015-09-01",42246.153998379632,null,null,null,{"$f":"IF(AND(B14=B13,H14=Enr_select_sem),G13,IF(H14=Enr_select_sem,MAX($G$1:G13)+1,\"\"))","v":""},36]
[39,"2015-09-02",42246.154144675929,null,null,null,{"$f":"IF(AND(B15=B14,H15=Enr_select_sem),G14,IF(H15=Enr_select_sem,MAX($G$1:G14)+1,\"\"))","v":""},36]
[40,"2015-09-02",42246.154150115741,null,null,null,{"$f":"IF(AND(B16=B15,H16=Enr_select_sem),G15,IF(H16=Enr_select_sem,MAX($G$1:G15)+1,\"\"))","v":""},36]
[41,"2015-09-02",42246.15415509259,null,null,null,{"$f":"IF(AND(B17=B16,H17=Enr_select_sem),G16,IF(H17=Enr_select_sem,MAX($G$1:G16)+1,\"\"))","v":""},36]
[42,"2015-09-02",42246.154159722224,null,null,null,{"$f":"IF(AND(B18=B17,H18=Enr_select_sem),G17,IF(H18=Enr_select_sem,MAX($G$1:G17)+1,\"\"))","v":""},36]
[43,"2015-09-03",42246.154257175927,null,null,null,{"$f":"IF(AND(B19=B18,H19=Enr_select_sem),G18,IF(H19=Enr_select_sem,MAX($G$1:G18)+1,\"\"))","v":""},36]
[44,"2015-09-03",42246.154264930556,null,null,null,{"$f":"IF(AND(B20=B19,H20=Enr_select_sem),G19,IF(H20=Enr_select_sem,MAX($G$1:G19)+1,\"\"))","v":""},36]
[45,"2015-09-03",42246.154370949072,null,null,null,{"$f":"IF(AND(B21=B20,H21=Enr_select_sem),G20,IF(H21=Enr_select_sem,MAX($G$1:G20)+1,\"\"))","v":""},36]
[46,"2015-09-03",42246.154379861109,null,null,null,{"$f":"IF(AND(B22=B21,H22=Enr_select_sem),G21,IF(H22=Enr_select_sem,MAX($G$1:G21)+1,\"\"))","v":""},36]
[47,"2015-09-04",42246.154687037037,null,null,null,{"$f":"IF(AND(B23=B22,H23=Enr_select_sem),G22,IF(H23=Enr_select_sem,MAX($G$1:G22)+1,\"\"))","v":""},36]
[48,"2015-09-04",42246.154693634257,null,null,null,{"$f":"IF(AND(B24=B23,H24=Enr_select_sem),G23,IF(H24=Enr_select_sem,MAX($G$1:G23)+1,\"\"))","v":""},36]
[49,"2015-09-04",42246.154700115738,null,null,null,{"$f":"IF(AND(B25=B24,H25=Enr_select_sem),G24,IF(H25=Enr_select_sem,MAX($G$1:G24)+1,\"\"))","v":""},36]
[50,"2015-09-04",42246.154707407404,null,null,null,{"$f":"IF(AND(B26=B25,H26=Enr_select_sem),G25,IF(H26=Enr_select_sem,MAX($G$1:G25)+1,\"\"))","v":""},36]
[51,"2015-09-05",42246.154808101855,null,null,null,{"$f":"IF(AND(B27=B26,H27=Enr_select_sem),G26,IF(H27=Enr_select_sem,MAX($G$1:G26)+1,\"\"))","v":""},36]
[52,"2015-09-05",42246.154819212963,null,null,null,{"$f":"IF(AND(B28=B27,H28=Enr_select_sem),G27,IF(H28=Enr_select_sem,MAX($G$1:G27)+1,\"\"))","v":""},36]
[53,"2015-09-05",42246.154826157406,null,null,null,{"$f":"IF(AND(B29=B28,H29=Enr_select_sem),G28,IF(H29=Enr_select_sem,MAX($G$1:G28)+1,\"\"))","v":""},36]
[54,"2015-09-05",42246.154834374996,null,null,null,{"$f":"IF(AND(B30=B29,H30=Enr_select_sem),G29,IF(H30=Enr_select_sem,MAX($G$1:G29)+1,\"\"))","v":""},36]
[55,"2015-09-06",42246.154997453705,null,null,null,{"$f":"IF(AND(B31=B30,H31=Enr_select_sem),G30,IF(H31=Enr_select_sem,MAX($G$1:G30)+1,\"\"))","v":""},36]
[56,"2015-09-06",42246.155003240739,null,null,null,{"$f":"IF(AND(B32=B31,H32=Enr_select_sem),G31,IF(H32=Enr_select_sem,MAX($G$1:G31)+1,\"\"))","v":""},36]
[57,"2015-09-06",42246.155009027774,null,null,null,{"$f":"IF(AND(B33=B32,H33=Enr_select_sem),G32,IF(H33=Enr_select_sem,MAX($G$1:G32)+1,\"\"))","v":""},36]
[58,"2015-09-06",42246.155015393517,null,null,null,{"$f":"IF(AND(B34=B33,H34=Enr_select_sem),G33,IF(H34=Enr_select_sem,MAX($G$1:G33)+1,\"\"))","v":""},36]
[59,"2015-09-07",42246.155146180557,null,null,null,{"$f":"IF(AND(B35=B34,H35=Enr_select_sem),G34,IF(H35=Enr_select_sem,MAX($G$1:G34)+1,\"\"))","v":1},37]
[60,"2015-09-07",42246.155156828703,null,null,null,{"$f":"IF(AND(B36=B35,H36=Enr_select_sem),G35,IF(H36=Enr_select_sem,MAX($G$1:G35)+1,\"\"))","v":1},37]
[61,"2015-09-07",42246.155163310184,null,null,null,{"$f":"IF(AND(B37=B36,H37=Enr_select_sem),G36,IF(H37=Enr_select_sem,MAX($G$1:G36)+1,\"\"))","v":1},37]
[62,"2015-09-07",42246.159863773151,null,null,null,{"$f":"IF(AND(B38=B37,H38=Enr_select_sem),G37,IF(H38=Enr_select_sem,MAX($G$1:G37)+1,\"\"))","v":1},37]
[63,"2015-09-08",42246.160185300927,null,null,null,{"$f":"IF(AND(B39=B38,H39=Enr_select_sem),G38,IF(H39=Enr_select_sem,MAX($G$1:G38)+1,\"\"))","v":2},37]
[64,"2015-09-08",42246.160192592593,null,null,null,{"$f":"IF(AND(B40=B39,H40=Enr_select_sem),G39,IF(H40=Enr_select_sem,MAX($G$1:G39)+1,\"\"))","v":2},37]
[65,"2015-09-08",42246.160198495367,null,null,null,{"$f":"IF(AND(B41=B40,H41=Enr_select_sem),G40,IF(H41=Enr_select_sem,MAX($G$1:G40)+1,\"\"))","v":2},37]
[66,"2015-09-08",42246.160204629632,null,null,null,{"$f":"IF(AND(B42=B41,H42=Enr_select_sem),G41,IF(H42=Enr_select_sem,MAX($G$1:G41)+1,\"\"))","v":2},37]
[67,"2015-09-09",42246.168280208331,null,null,null,{"$f":"IF(AND(B43=B42,H43=Enr_select_sem),G42,IF(H43=Enr_select_sem,MAX($G$1:G42)+1,\"\"))","v":3},37]
[68,"2015-09-09",42246.16830208333,null,null,null,{"$f":"IF(AND(B44=B43,H44=Enr_select_sem),G43,IF(H44=Enr_select_sem,MAX($G$1:G43)+1,\"\"))","v":3},37]
[69,"2015-09-10",42246.170578240744,null,null,null,{"$f":"IF(AND(B45=B44,H45=Enr_select_sem),G44,IF(H45=Enr_select_sem,MAX($G$1:G44)+1,\"\"))","v":4},37]
[70,"2015-09-10",42246.17058622685,null,null,null,{"$f":"IF(AND(B46=B45,H46=Enr_select_sem),G45,IF(H46=Enr_select_sem,MAX($G$1:G45)+1,\"\"))","v":4},37]
[71,"2015-09-10",42246.170598495373,null,null,null,{"$f":"IF(AND(B47=B46,H47=Enr_select_sem),G46,IF(H47=Enr_select_sem,MAX($G$1:G46)+1,\"\"))","v":4},37]
[72,"2015-09-10",42246.171455671298,null,null,null,{"$f":"IF(AND(B48=B47,H48=Enr_select_sem),G47,IF(H48=Enr_select_sem,MAX($G$1:G47)+1,\"\"))","v":4},37]