{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PARAMETTRE","ENREGISTREMENT","DONNEENET"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":62,"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":"PARAMETTRE","index":0,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Mois","N°","Select semaine"]
["Janvier",1,1]
["Février",2,2]
["Mars",3,3]
["Avril",4,4]
["Mai",5,5]
["Juin",6,6]
["Juillet",7,7]
["Août",8,8]
["Septembre",9,9]
["Octobre",10,10]
["Novembre",11,11]
["Décembre",12,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[null,null,21]
[null,null,22]
[null,null,23]
[null,null,24]
[null,null,25]
[null,null,26]
[null,null,27]
[null,null,28]
[null,null,29]
[null,null,30]
[null,null,31]
[null,null,32]
[null,null,33]
[null,null,34]
[null,null,35]
[null,null,36]
[null,null,37]
[null,null,38]
[null,null,39]
[null,null,40]
[null,null,41]
[null,null,42]
[null,null,43]
[null,null,44]
[null,null,45]
[null,null,46]
[null,null,47]
[null,null,48]
[null,null,49]
[null,null,50]
[null,null,51]
[null,null,52]
[null,null,53]

{"sheet":"ENREGISTREMENT","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[14,1,14,7]]}
[]
[null,"N° d'ordre","Date","Heure"]
[null,{"$f":"MAX(DONNEENET!A:A)+1","v":17},{"$f":"TODAY()","v":"2015-09-05"},{"$f":"NOW()","v":42252.632331365741}]
[]
[null,"Semaine","Période du ","au","Heures cumulées"]
[null,36,{"$f":"B8","v":"2015-09-01"},{"$f":"C6+6","v":"2015-09-07"},{"$f":"SUM(B13:H13)","v":42249.368540972224},null,"Valider un fin de semaine",null,null,null,{"$f":"B6","v":36}]
[]
[null,{"$f":"IFERROR(INDEX(Champ[],MATCH(COLUMN()-1,DONNEENET!$G:$G,0),2),\"\")","v":"2015-09-01"},{"$f":"IFERROR(INDEX(Champ[],MATCH(COLUMN()-1,DONNEENET!$G:$G,0),2),\"\")","v":"2015-09-02"},{"$f":"IFERROR(INDEX(Champ[],MATCH(COLUMN()-1,DONNEENET!$G:$G,0),2),\"\")","v":"2015-09-03"},{"$f":"IFERROR(INDEX(Champ[],MATCH(COLUMN()-1,DONNEENET!$G:$G,0),2),\"\")","v":"2015-09-04"},{"$f":"IFERROR(INDEX(Champ[],MATCH(COLUMN()-1,DONNEENET!$G:$G,0),2),\"\")","v":"2015-09-05"},{"$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":""}]
[null,{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(B$8,DONNEENET!$B:$B,0),3),\"\")","v":"09:36:34"},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(C$8,DONNEENET!$B:$B,0),3),\"\")","v":42249.371124189813},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(D$8,DONNEENET!$B:$B,0),3),\"\")","v":42250.413712037036},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(E$8,DONNEENET!$B:$B,0),3),\"\")","v":42251.417037037034},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(F$8,DONNEENET!$B:$B,0),3),\"\")","v":42252.455260995368},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(G$8,DONNEENET!$B:$B,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(H$8,DONNEENET!$B:$B,0),3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(B$8,DONNEENET!$B:$B,0)+1,3),\"\")","v":42248.566504629627},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(C$8,DONNEENET!$B:$B,0)+1,3),\"\")","v":42249.590138194442},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(D$8,DONNEENET!$B:$B,0)+1,3),\"\")","v":42250.587438773146},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(E$8,DONNEENET!$B:$B,0)+1,3),\"\")","v":42251.586315972221},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(F$8,DONNEENET!$B:$B,0)+1,3),\"\")","v":42252.586053819447},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(G$8,DONNEENET!$B:$B,0)+1,3),\"\")","v":""},{"$f":"IFERROR(INDEX(DONNEENET!$A:$H,MATCH(H$8,DONNEENET!$B:$B,0)+1,3),\"\")","v":""}]
[null,{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(B$8,DONNEENET!$B:$B,0)+2,3))","v":""},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(C$8,DONNEENET!$B:$B,0)+2,3))","v":42249.746818055559},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(D$8,DONNEENET!$B:$B,0)+2,3))","v":42250.743289120372},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(E$8,DONNEENET!$B:$B,0)+2,3))","v":42251.745836458336},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(F$8,DONNEENET!$B:$B,0)+2,3))","v":""},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(G$8,DONNEENET!$B:$B,0)+2,3))","v":""},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(H$8,DONNEENET!$B:$B,0)+2,3))","v":""}]
[null,{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(B$8,DONNEENET!$B:$B,0)+3,3))","v":""},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(C$8,DONNEENET!$B:$B,0)+3,3))","v":42249.92408449074},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(D$8,DONNEENET!$B:$B,0)+3,3))","v":42250.878285416664},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(E$8,DONNEENET!$B:$B,0)+3,3))","v":42251.943191087965},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(F$8,DONNEENET!$B:$B,0)+3,3))","v":""},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(G$8,DONNEENET!$B:$B,0)+3,3))","v":""},{"$f":"IF(COUNTIF(DONNEENET!$G:$G,COLUMN()-1)<3,\"\",INDEX(DONNEENET!$A:$H,MATCH(H$8,DONNEENET!$B:$B,0)+3,3))","v":""}]
[null,{"$f":"SUM(B10,B12)-SUM(B9,B11)","v":42248.16611111111},{"$f":"SUM(C10,C12)-SUM(C9,C11)","v":"09:30:38.630"},"07:24:33.670","08:47:57.140","03:08:20.500","00:00:00","00:00:00"]
[null,null,null,null,null,{"$f":"SUM(B13:F13)","v":42249.368540972224}]

{"sheet":"DONNEENET","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"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":0.40039351851851851},null,{"$f":"Enr_select_sem","v":36}]
[1,"2015-09-01","09:36:34",null,null,null,{"$f":"IF(AND(B3=B2,H3=Enr_select_sem),G2,IF(H3=Enr_select_sem,MAX($G$1:G2)+1,\"\"))","v":1},{"$f":"WEEKNUM(B3,2)","v":36}]
[2,"2015-09-01",42248.566504629627,null,null,null,{"$f":"IF(AND(B4=B3,H4=Enr_select_sem),G3,IF(H4=Enr_select_sem,MAX($G$1:G3)+1,\"\"))","v":1},36]
[3,"2015-09-02",42249.371124189813,null,null,null,{"$f":"IF(AND(B5=B4,H5=Enr_select_sem),G4,IF(H5=Enr_select_sem,MAX($G$1:G4)+1,\"\"))","v":2},36]
[4,"2015-09-02",42249.590138194442,null,null,null,{"$f":"IF(AND(B6=B5,H6=Enr_select_sem),G5,IF(H6=Enr_select_sem,MAX($G$1:G5)+1,\"\"))","v":2},36]
[5,"2015-09-02",42249.746818055559,null,null,null,{"$f":"IF(AND(B7=B6,H7=Enr_select_sem),G6,IF(H7=Enr_select_sem,MAX($G$1:G6)+1,\"\"))","v":2},36]
[6,"2015-09-02",42249.92408449074,null,null,null,{"$f":"IF(AND(B8=B7,H8=Enr_select_sem),G7,IF(H8=Enr_select_sem,MAX($G$1:G7)+1,\"\"))","v":2},36]
[7,"2015-09-03",42250.413712037036,null,null,null,{"$f":"IF(AND(B9=B8,H9=Enr_select_sem),G8,IF(H9=Enr_select_sem,MAX($G$1:G8)+1,\"\"))","v":3},{"$f":"WEEKNUM(B9,2)","v":36}]
[8,"2015-09-03",42250.587438773146,null,null,null,{"$f":"IF(AND(B10=B9,H10=Enr_select_sem),G9,IF(H10=Enr_select_sem,MAX($G$1:G9)+1,\"\"))","v":3},36]
[9,"2015-09-03",42250.743289120372,null,null,null,{"$f":"IF(AND(B11=B10,H11=Enr_select_sem),G10,IF(H11=Enr_select_sem,MAX($G$1:G10)+1,\"\"))","v":3},36]
[10,"2015-09-03",42250.878285416664,null,null,null,{"$f":"IF(AND(B12=B11,H12=Enr_select_sem),G11,IF(H12=Enr_select_sem,MAX($G$1:G11)+1,\"\"))","v":3},36]
[11,"2015-09-04",42251.417037037034,null,null,null,{"$f":"IF(AND(B13=B12,H13=Enr_select_sem),G12,IF(H13=Enr_select_sem,MAX($G$1:G12)+1,\"\"))","v":4},36]
[12,"2015-09-04",42251.586315972221,null,null,null,{"$f":"IF(AND(B14=B13,H14=Enr_select_sem),G13,IF(H14=Enr_select_sem,MAX($G$1:G13)+1,\"\"))","v":4},36]
[13,"2015-09-04",42251.745836458336,null,null,null,{"$f":"IF(AND(B15=B14,H15=Enr_select_sem),G14,IF(H15=Enr_select_sem,MAX($G$1:G14)+1,\"\"))","v":4},36]
[14,"2015-09-04",42251.943191087965,null,null,null,{"$f":"IF(AND(B16=B15,H16=Enr_select_sem),G15,IF(H16=Enr_select_sem,MAX($G$1:G15)+1,\"\"))","v":4},36]
[15,"2015-09-05",42252.455260995368,null,null,null,{"$f":"IF(AND(B17=B16,H17=Enr_select_sem),G16,IF(H17=Enr_select_sem,MAX($G$1:G16)+1,\"\"))","v":5},{"$f":"WEEKNUM(B17,2)","v":36}]
[16,"2015-09-05",42252.586053819447,null,null,null,{"$f":"IF(AND(B18=B17,H18=Enr_select_sem),G17,IF(H18=Enr_select_sem,MAX($G$1:G17)+1,\"\"))","v":5},{"$f":"WEEKNUM(B18,2)","v":36}]