{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Feuil1_(3)","Test_jp","août","septembre"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":35,"comments":1,"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":"Feuil1_(3)","index":0,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"TEXT($D$18,\"mmmm\")","v":"août"},{"$f":"WEEKNUM(D18)","v":33}]
[]
["n°semaine","date","heurearrivee","heuremidi","heurereprise","heurefin","cumul"]
[{"$f":"WEEKNUM($D$18)","v":33},{"$f":"IFERROR(SMALL(IF(semaineaout=$B$2,datesaout,\"\"),ROW(INDIRECT(\"1:\"&ROWS(semaineaout)))),\"\")","v":"2022-08-08"},{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(datesaout=$B5)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(datesaout=$B5)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(datesaout=$B5)*(semaineaout=$B$2),0)),\"\")","v":"13:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(datesaout=$B5)*(semaineaout=$B$2),0)),\"\")","v":"19:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(G$4),MATCH(1,(datesaout=$B5)*(semaineaout=$B$2),0)),\"\")","v":0.25}]
[null,"2022-08-09",{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(datesaout=$B6)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(datesaout=$B6)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(datesaout=$B6)*(semaineaout=$B$2),0)),\"\")","v":"14:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(datesaout=$B6)*(semaineaout=$B$2),0)),\"\")","v":"17:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(G$4),MATCH(1,(datesaout=$B6)*(semaineaout=$B$2),0)),\"\")","v":0.125}]
[null,"2022-08-10",{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(datesaout=$B7)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(datesaout=$B7)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(datesaout=$B7)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(datesaout=$B7)*(semaineaout=$B$2),0)),\"\")","v":"08:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(G$4),MATCH(1,(datesaout=$B7)*(semaineaout=$B$2),0)),\"\")","v":0.33333333333333331},null,null,null,null,null,null,null,null,null,"2021-12-01"]
[null,"2022-08-11",{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(datesaout=$B8)*(semaineaout=$B$2),0)),\"\")","v":"06:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(datesaout=$B8)*(semaineaout=$B$2),0)),\"\")","v":"12:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(datesaout=$B8)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(datesaout=$B8)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(G$4),MATCH(1,(datesaout=$B8)*(semaineaout=$B$2),0)),\"\")","v":0.25},null,null,null,null,null,null,null,null,null,"2021-12-02"]
[null,"2022-08-12",{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(datesaout=$B9)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(datesaout=$B9)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(datesaout=$B9)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(datesaout=$B9)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(G$4),MATCH(1,(datesaout=$B9)*(semaineaout=$B$2),0)),\"\")","v":0},null,null,null,null,null,null,null,null,null,"2021-12-03"]
[null,"2022-08-13",{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(datesaout=$B10)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(datesaout=$B10)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(datesaout=$B10)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(datesaout=$B10)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(G$4),MATCH(1,(datesaout=$B10)*(semaineaout=$B$2),0)),\"\")","v":0},null,null,null,null,null,null,null,null,null,"2021-12-04"]
[null,"2022-08-14",{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(datesaout=$B11)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(datesaout=$B11)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(datesaout=$B11)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(datesaout=$B11)*(semaineaout=$B$2),0)),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(INDIRECT(G$4),MATCH(1,(datesaout=$B11)*(semaineaout=$B$2),0)),\"\")","v":0},{"$f":"G11","v":0},null,null,null,null,null,null,null,null,"2021-12-05"]
[null,"",{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(date=$B12)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(date=$B12)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(date=$B12)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(date=$B12)*(mois=$B$2),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"2021-12-06"]
[null,"",{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(date=$B13)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(date=$B13)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(date=$B13)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(date=$B13)*(mois=$B$2),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"2021-12-07"]
[null,"",{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(date=$B14)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(date=$B14)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(date=$B14)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(date=$B14)*(mois=$B$2),0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"2021-12-08"]
[{"$f":"INDIRECT(\" '[testtableau.xls]\"&A2&\" '!k13\")","v":{"$error":"#REF!"}},{"$f":"IF('Feuil1_(3)'!A2<>\"\",'Feuil1_(3)'!A2,\"\")","v":"août"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-09"]
[{"$f":"INDIRECT(\"'\"&A2&\"'!k13\")","v":" "},{"$f":"INDIRECT(\"'[testtableau.xls]\"&A5&\"'!F1\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-10"]
["semaines (lundi)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-11"]
["2022-07-18",null,"DU :","2022-08-08","AU :",{"$f":"D18+7","v":"2022-08-15"},null,null,null,null,null,null,null,null,null,null,"2021-12-12"]
[{"$f":"A18+7","v":"2022-07-25"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-13"]
[{"$f":"A19+7","v":"2022-08-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-14"]
["2022-08-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-15"]
["2022-08-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-16"]
["2022-08-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-17"]
["2022-08-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-18"]
["2022-09-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-19"]
["2022-09-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-20"]
["2022-09-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-21"]
["2022-09-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-22"]
["2022-10-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-31"]

{"sheet":"Test_jp","index":1,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Année"]
[{"$f":"TEXT($D$18,\"mmmm\")","v":"août"},{"$f":"WEEKNUM(D18)","v":36},null,null,null,null,null,null,null,null,null,null,2022]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKNUM(M3)","v":53},{"$f":"(DATE(M2,1,1)+((1-1)*7))-((WEEKDAY((DATE(M2,1,1)+((1-1)*7)),2))-1)","v":"2021-12-27"}]
["n°semaine","datesaout","heurearrivee","heuremidi","heurereprise","heurefin","cumul",null,null,null,null,{"$f":"WEEKNUM(M4)","v":2},{"$f":"M3+7","v":"2022-01-03"}]
[{"$f":"WEEKNUM($D$18)","v":36},{"$f":"D18","v":"2022-08-29"},null,null,"13:00:00","19:00:00","06:00:00",0.25,null,null,null,{"$f":"WEEKNUM(M5)","v":3},{"$f":"M4+7","v":"2022-01-10"}]
[null,{"$f":"B5+1","v":"2022-08-30"},null,null,"14:00:00","17:00:00","03:00:00",0.375,null,null,null,4,"2022-01-17"]
[null,{"$f":"B6+1","v":"2022-08-31"},null,null,null,"08:00:00","08:00:00",0.70833333333333326,null,null,null,5,"2022-01-24"]
[null,"2022-09-01","08:00:00","11:00:00","13:00:00","17:00:00","07:00:00",0.29166666666666674,null,null,null,6,"2022-01-31"]
[null,"2022-09-02",null,null,"14:00:00","18:00:00","04:00:00",0.45833333333333337,null,null,null,7,"2022-02-07"]
[null,"2022-09-03",null,null,null,null,"00:00:00",0.45833333333333337,null,null,null,8,"2022-02-14"]
[null,"2022-09-04",null,null,null,null,"00:00:00",0.45833333333333337,null,null,null,9,"2022-02-21"]
[null,null,{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(date=$B12)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(date=$B12)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(date=$B12)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(date=$B12)*(mois=$B$2),0)),\"\")","v":""},null,null,null,null,null,10,"2022-02-28"]
[null,null,{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(date=$B13)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(date=$B13)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(date=$B13)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(date=$B13)*(mois=$B$2),0)),\"\")","v":""},null,null,null,null,null,11,"2022-03-07"]
[null,null,{"$f":"IFERROR(INDEX(INDIRECT(C$4),MATCH(1,(date=$B14)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(D$4),MATCH(1,(date=$B14)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(E$4),MATCH(1,(date=$B14)*(mois=$B$2),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(F$4),MATCH(1,(date=$B14)*(mois=$B$2),0)),\"\")","v":""},null,null,null,null,null,12,"2022-03-14"]
[null,{"$f":"IF(Test_jp!A2<>\"\",Test_jp!A2,\"\")","v":"août"},null,null,null,null,null,null,null,null,null,13,"2022-03-21"]
[{"$f":"INDIRECT(\"'\"&A2&\"'!k13\")","v":" "},null,null,null,null,null,null,null,null,null,null,14,"2022-03-28"]
["semaines",null,null,null,null,null,null,null,null,null,null,15,"2022-04-04"]
["2022-07-18",null,"DU :","2022-08-29","AU :",{"$f":"D18+6","v":"2022-09-04"},null,null,null,null,null,16,"2022-04-11"]
[{"$f":"A18+7","v":"2022-07-25"},null,null,null,null,null,null,null,null,null,null,17,"2022-04-18"]
[{"$f":"A19+7","v":"2022-08-01"},null,null,null,null,null,null,null,null,null,null,18,"2022-04-25"]
["2022-08-08",null,null,null,null,null,null,null,null,null,null,19,"2022-05-02"]
["2022-08-15",null,null,null,null,null,null,null,null,null,null,20,"2022-05-09"]
["2022-08-22",null,null,null,null,null,null,null,null,null,null,21,"2022-05-16"]
["2022-08-29",null,null,null,null,null,null,null,null,null,null,22,"2022-05-23"]
["2022-09-05",null,null,null,null,null,null,null,null,null,null,23,"2022-05-30"]
["2022-09-12",null,null,null,null,null,null,null,null,null,null,24,"2022-06-06"]
["2022-09-19",null,null,null,null,null,null,null,null,null,null,25,"2022-06-13"]
["2022-09-26",null,null,null,null,null,null,null,null,null,null,26,"2022-06-20"]
["2022-10-03",null,null,null,null,null,null,null,null,null,null,27,"2022-06-27"]
[null,null,null,null,null,null,null,null,null,null,null,28,"2022-07-04"]
[null,null,null,null,null,null,null,null,null,null,null,29,"2022-07-11"]
[null,null,null,null,null,null,null,null,null,null,null,30,"2022-07-18"]
[null,null,null,null,null,null,null,null,null,null,null,31,"2022-07-25"]
[null,null,null,null,null,null,null,null,null,null,null,32,"2022-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,33,"2022-08-08"]
[null,null,null,null,null,null,null,null,null,null,null,34,"2022-08-15"]
[null,null,null,null,null,null,null,null,null,null,null,35,"2022-08-22"]
[null,null,null,null,null,null,null,null,null,null,null,36,"2022-08-29"]
[null,null,null,null,null,null,null,null,null,null,null,37,"2022-09-05"]
[null,null,null,null,null,null,null,null,null,null,null,38,"2022-09-12"]
[null,null,null,null,null,null,null,null,null,null,null,39,"2022-09-19"]
[null,null,null,null,null,null,null,null,null,null,null,40,"2022-09-26"]
[null,null,null,null,null,null,null,null,null,null,null,41,"2022-10-03"]
[null,null,null,null,null,null,null,null,null,null,null,42,"2022-10-10"]
[null,null,null,null,null,null,null,null,null,null,null,43,"2022-10-17"]
[null,null,null,null,null,null,null,null,null,null,null,44,"2022-10-24"]
[null,null,null,null,null,null,null,null,null,null,null,45,"2022-10-31"]
[null,null,null,null,null,null,null,null,null,null,null,46,"2022-11-07"]
[null,null,null,null,null,null,null,null,null,null,null,47,"2022-11-14"]
[null,null,null,null,null,null,null,null,null,null,null,48,"2022-11-21"]
[null,null,null,null,null,null,null,null,null,null,null,49,"2022-11-28"]
[null,null,null,null,null,null,null,null,null,null,null,50,"2022-12-05"]
[null,null,null,null,null,null,null,null,null,null,null,51,"2022-12-12"]
[null,null,null,null,null,null,null,null,null,null,null,52,"2022-12-19"]
[null,null,null,null,null,null,null,null,null,null,null,53,"2022-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,1,"2023-01-02"]
[null,null,null,null,null,null,null,null,null,null,null,2,"2023-01-09"]
[null,null,null,null,null,null,null,null,null,null,null,3,"2023-01-16"]
[null,null,null,null,null,null,null,null,null,null,null,4,"2023-01-23"]
[null,null,null,null,null,null,null,null,null,null,null,5,"2023-01-30"]
[null,null,null,null,null,null,null,null,null,null,null,6,"2023-02-06"]

{"sheet":"août","index":2,"n_rows":34,"n_cols":19,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,18,8,20],[0,0,0,4],[0,5,0,6],[0,7,0,10],[4,12,5,16],[7,12,8,16],[0,12,1,14],[17,12,17,13],[10,12,11,16],[10,18,11,20],[13,12,13,13],[14,12,14,13],[15,12,15,13],[16,12,16,13]]}
["RELEVE D'HEURES DE : ",null,null,null,null,8,null,2022,null,null,null,1,"août"]
["semaineaout","jour","date","heurearrivee","heuremidi","heurereprise","heurefin","cumul",null,null,"total"]
[32,{"$f":"TEXT(C3,\"jjjj\")","v":"lundi"},{"$f":"DATE(H1,F1,L1)","v":"2022-08-01"},"10:00:00","12:00:00","13:30:00","15:15:00",{"$f":"(E3-D3)+(G3-F3)","v":"03:45:00"},{"$f":"H3","v":0.15624999999999994},null,{"$f":"IF(B3=\"dimanche\",I3,\" \")","v":" "}]
[{"$f":"A3","v":32},{"$f":"TEXT(C4,\"jjjj\")","v":"mardi"},{"$f":"C3+1","v":"2022-08-02"},null,null,null,null,"00:00:00",{"$f":"IF(B4=\"lundi\",H4,H4+I3)","v":0.15624999999999994},"VACANCES"," "]
[{"$f":"A4","v":32},"mercredi",{"$f":"C4+1","v":"2022-08-03"},null,null,"13:00:00","19:00:00","06:00:00",0.40624999999999994,"VACANCES"," ",null,"HEURES DU MOIS :",null,null,null,null,null,{"$f":"SUM(K3:K33)","v":1.6979166666666665}]
[32,"jeudi","2022-08-04",null,null,null,null,"00:00:00",0.40624999999999994,"VACANCES"," "]
[32,"vendredi","2022-08-05","08:00:00","12:00:00","13:00:00","17:00:00","08:00:00",0.73958333333333337,"VACANCES"," "]
[32,"samedi","2022-08-06",null,null,null,null,"00:00:00",0.73958333333333337,null," ",null,"JOURS OUVRES :",null,null,null,null,null,{"$f":"NETWORKDAYS(C3,C33)","v":23}]
[32,"dimanche","2022-08-07",null,null,null,null,"00:00:00",0.73958333333333337,null,0.73958333333333337]
[{"$f":"IF($B10=\"lundi\",WEEKNUM($C10),\" \")","v":33},"lundi","2022-08-08",null,null,"13:00:00","19:00:00","06:00:00",0.25,"VACANCES"," "]
[33,"mardi","2022-08-09",null,null,"14:00:00","17:00:00","03:00:00",0.375,"VACANCES"," ",null,"JOURS TRAVAILLES",null,null,null,null,null,{"$f":"COUNTIFS($H$3:$H$33,\">0:00\",$J$3:$J$33,\"<>FERIE\",J3:$J$33,\"<>VACANCES\",J3:$J$33,\"<>MALADIE\")","v":11}]
[33,"mercredi","2022-08-10",null,null,null,"08:00:00","08:00:00",0.70833333333333326,"VACANCES"," "]
[33,"jeudi","2022-08-11","06:00:00","12:00:00",null,null,"06:00:00",0.95833333333333326,"VACANCES"," "]
[33,"vendredi","2022-08-12",null,null,null,null,"00:00:00",0.95833333333333326,"VACANCES"," ",null,"FERIE"]
[33,"samedi","2022-08-13",null,null,null,null,"00:00:00",0.95833333333333326,null," ",null,"MALADIE"]
[33,"dimanche","2022-08-14",null,null,null,null,"00:00:00",0.95833333333333326,null,0.95833333333333326,null,"RTT"]
[{"$f":"WEEKNUM(C17,2)","v":34},"lundi","2022-08-15","10:00:00","12:00:00","13:30:00","15:15:00",{"$f":"(E17-D17)+(G17-F17)","v":"03:45:00"},{"$f":"IF(B17=\"lundi\",H17,H17+I16)","v":0.15624999999999994},null,null,null,"VACANCES"]
[{"$f":"WEEKNUM(C18,2)","v":34},"mardi","2022-08-16",null,null,null,null,"00:00:00",0.15624999999999994,null,null,null,"FORMATION"]
[34,"mercredi","2022-08-17",null,null,"13:00:00","19:00:00","06:00:00",0.40624999999999994]
[34,"jeudi","2022-08-18",null,null,null,null,"00:00:00",0.40624999999999994]
[34,"vendredi","2022-08-19","08:00:00","12:00:00","13:00:00","17:00:00","08:00:00",0.73958333333333337]
[34,"samedi","2022-08-20",null,null,null,null,"00:00:00",0.73958333333333337]
[34,"dimanche","2022-08-21",null,null,null,null,"00:00:00",0.73958333333333337]
[35,"lundi","2022-08-22",null,null,"13:00:00","19:00:00","06:00:00",0.25]
[35,"mardi","2022-08-23",null,null,"14:00:00","17:00:00","03:00:00",0.375]
[35,"mercredi","2022-08-24",null,null,null,"08:00:00","08:00:00",0.70833333333333326]
[35,"jeudi","2022-08-25","06:00:00","12:00:00",null,null,"06:00:00",0.95833333333333326]
[35,"vendredi","2022-08-26",null,null,null,null,"00:00:00",0.95833333333333326]
[35,"samedi","2022-08-27",null,null,null,null,"00:00:00",0.95833333333333326]
[35,"dimanche","2022-08-28",null,null,null,null,"00:00:00",0.95833333333333326]
[36,"lundi","2022-08-29",null,null,"13:00:00","19:00:00","06:00:00",0.25]
[36,"mardi","2022-08-30",null,null,"14:00:00","17:00:00","03:00:00",0.375]
[36,"mercredi","2022-08-31",null,null,null,"08:00:00","08:00:00",0.70833333333333326]
[null,null,"2022-09-01"]

{"sheet":"septembre","index":3,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,4],[0,5,0,6],[0,7,0,10],[0,11,1,13]]}
["RELEVE D'HEURES DE : ",null,null,null,null,9,null,2022,null,null,null,"septembre"]
[null,1,"date","heuresD"]
[36,{"$f":"TEXT(C3,\"jjjj\")","v":"jeudi"},{"$f":"DATE(H1,F1,B2)","v":"2022-09-01"},"08:00:00","11:00:00","13:00:00","17:00:00",{"$f":"(E3-D3)+(G3-F3)","v":"07:00:00"},{"$f":"H3","v":0.29166666666666674},null,{"$f":"IF(B3=\"dimanche\",I3,\" \")","v":" "}]
[36,{"$f":"TEXT(C4,\"jjjj\")","v":"vendredi"},{"$f":"C3+1","v":"2022-09-02"},null,null,"14:00:00","18:00:00",{"$f":"(E4-D4)+(G4-F4)","v":"04:00:00"},{"$f":"IF(B4=\"lundi\",H4,H4+I3)","v":0.45833333333333337},false," "]
[36,"samedi",{"$f":"C4+1","v":"2022-09-03"},null,null,null,null,"00:00:00",0.45833333333333337,true," "]
[36,"dimanche","2022-09-04",null,null,null,null,"00:00:00",0.45833333333333337,true,0.45833333333333337]
[{"$f":"IF($B7=\"lundi\",WEEKNUM($C7),\" \")","v":37},"lundi","2022-09-05",null,null,null,null,"00:00:00",0,false," "]
[37,"mardi","2022-09-06","08:00:00","12:30:00","15:00:00","17:30:00","07:00:00",0.29166666666666669,false," "]
[37,"mercredi","2022-09-07","08:00:00","12:30:00","15:00:00","17:30:00","07:00:00",0.58333333333333337,false," "]
[37,"jeudi","2022-09-08","07:00:00","11:00:00","13:00:00","16:00:00","07:00:00",0.875,false," "]
[37,"vendredi","2022-09-09",null,null,null,null,"00:00:00",0.875,false," "]
[37,"samedi","2022-09-10",null,null,null,null,"00:00:00",0.875,"VACANCES"," "]
[37,"dimanche","2022-09-11",null,null,null,null,"00:00:00",0.875,"VACANCES",0.875]
[38,"lundi","2022-09-12","08:00:00","13:00:00","14:00:00","17:00:00","08:00:00",0.33333333333333331,"VACANCES"," "]
[38,"mardi","2022-09-13","10:00:00","12:00:00","13:30:00","15:15:00","03:45:00",0.48958333333333326,null," "]
[38,"mercredi","2022-09-14",null,null,"13:00:00","17:00:00","04:00:00",0.65625,null," "]
[38,{"$f":"TEXT(C17,\"jjjj\")","v":"jeudi"},"2022-09-15",null,null,null,null,"00:00:00",{"$f":"IF(B17=\"lundi\",H17,H17+I16)","v":0.65625},"VACANCES",{"$f":"IF(B17=\"dimanche\",I17,\" \")","v":" "}]
[38,"vendredi","2022-09-16","08:00:00","12:00:00",null,null,"04:00:00",0.82291666666666674,"VACANCES"," "]
[38,"samedi","2022-09-17",null,null,null,null,"00:00:00",0.82291666666666674,"VACANCES"," "]
[39,"dimanche","2022-09-18",null,null,null,null,"00:00:00",0.82291666666666674,"VACANCES",0.82291666666666674]