{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Fériés et autres jours fermés","Liste Agents","Modèle"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Fériés et autres jours fermés","index":0,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,9,0,11],[1,9,1,11],[2,12,2,16],[0,12,0,17]]}
[null,null,null,null,null,null,null,null,null,"Année en cours\n  <-----Servez-vous de l'ascenceur------>",null,null,"Calcul des jours fériés et jours non travaillés"]
[null,null,null,null,null,null,null,null,2022,null,null,null,"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$I$2","v":2022}]
[null,null,null,null,null,null,null,null,null,null,"1er jour du mois",null,"Num Semaine","Jours fériés",null,"Jour","Détail"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR($N$5),MONTH(J5),1)","v":"2022-01-01"},null,{"$f":"WEEKNUM(N5)","v":1},{"$f":"DATE($I$2,1,1)","v":"2022-01-01"},{"$f":"WEEKDAY(N5)","v":7},{"$f":"N5","v":"2022-01-01"},"Jour de l'an"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR($N$5),MONTH(K5)+1,1)","v":"2022-02-01"},null,{"$f":"WEEKNUM(N6)","v":17},{"$f":"DATE($I$2,3,29.56+0.979*MOD(204-11*MOD($I$2,19),30)-WEEKDAY(DATE($I$2,3,28.56+0.979*MOD(204-11*MOD($I$2,19),30))))+1","v":"2022-04-18"},{"$f":"WEEKDAY(N6)","v":2},{"$f":"N6","v":"2022-04-18"},"Lundi de pâques"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR($N$5),MONTH(K6)+1,1)","v":"2022-03-01"},null,{"$f":"WEEKNUM(N7)","v":19},{"$f":"DATE($I$2,5,1)","v":"2022-05-01"},{"$f":"WEEKDAY(N7)","v":1},{"$f":"N7","v":"2022-05-01"},"Fête du travail"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR($N$5),MONTH(K7)+1,1)","v":"2022-04-01"},null,{"$f":"WEEKNUM(N8)","v":20},{"$f":"DATE($I$2,5,8)","v":"2022-05-08"},{"$f":"WEEKDAY(N8)","v":1},{"$f":"N8","v":"2022-05-08"},"Victoire 45"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR($N$5),MONTH(K8)+1,1)","v":"2022-05-01"},null,{"$f":"WEEKNUM(N9)","v":22},{"$f":"N6+38","v":"2022-05-26"},{"$f":"WEEKDAY(N9)","v":5},{"$f":"N9","v":"2022-05-26"},"Ascension"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR($N$5),MONTH(K9)+1,1)","v":"2022-06-01"},null,{"$f":"WEEKNUM(N10)","v":27},{"$f":"N8+49","v":"2022-06-26"},{"$f":"WEEKDAY(N10)","v":1},{"$f":"N10","v":"2022-06-26"},"Lundi de pentecôte"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR($N$5),MONTH(K10)+1,1)","v":"2022-07-01"},null,{"$f":"WEEKNUM(N11)","v":29},{"$f":"DATE($I$2,7,14)","v":"2022-07-14"},{"$f":"WEEKDAY(N11)","v":5},{"$f":"N11","v":"2022-07-14"},"Fête nationale"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR($N$5),MONTH(K11)+1,1)","v":"2022-08-01"},null,{"$f":"WEEKNUM(N12)","v":34},{"$f":"DATE($I$2,8,15)","v":"2022-08-15"},{"$f":"WEEKDAY(N12)","v":2},{"$f":"N12","v":"2022-08-15"},"Assomption"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR($N$5),MONTH(K12)+1,1)","v":"2022-09-01"},null,{"$f":"WEEKNUM(N13)","v":45},{"$f":"DATE($I$2,11,1)","v":"2022-11-01"},{"$f":"WEEKDAY(N13)","v":3},{"$f":"N13","v":"2022-11-01"},"Toussaint"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR($N$5),MONTH(K13)+1,1)","v":"2022-10-01"},null,{"$f":"WEEKNUM(N14)","v":46},{"$f":"DATE($I$2,11,11)","v":"2022-11-11"},{"$f":"WEEKDAY(N14)","v":6},{"$f":"N14","v":"2022-11-11"},"Armistice 14 18"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR($N$5),MONTH(K14)+1,1)","v":"2022-11-01"},null,{"$f":"WEEKNUM(N15)","v":53},{"$f":"DATE($I$2,12,25)","v":"2022-12-25"},{"$f":"WEEKDAY(N15)","v":1},{"$f":"N15","v":"2022-12-25"},"Noël"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR($N$5),MONTH(K15)+1,1)","v":"2022-12-01"},null,{"$f":"WEEKNUM(N16)","v":22},{"$f":"IF(WEEKDAY(N9=6),N9+1,\"\")","v":"2022-05-27"},{"$f":"WEEKDAY(N16)","v":6},{"$f":"N16","v":"2022-05-27"},"Jour suivant le jeudi de l'ascension"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKNUM(N17)","v":0},null,{"$f":"WEEKDAY(N17)","v":7},{"$f":"N17","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKNUM(N18)","v":0},null,{"$f":"WEEKDAY(N18)","v":7},{"$f":"N18","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKNUM(N19)","v":0},null,{"$f":"WEEKDAY(N19)","v":7},{"$f":"N19","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKNUM(N20)","v":0},null,{"$f":"WEEKDAY(N20)","v":7},{"$f":"N20","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKNUM(N21)","v":0},null,{"$f":"WEEKDAY(N21)","v":7},{"$f":"N21","v":"00:00:00"}]

{"sheet":"Liste Agents","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["NUM AGENT","NOM"]
[1111111,"A"]
[1111112,"B"]
[1111113,"C"]
[1111114,"D"]
[1111115,"E"]
[1111116,"F"]
[1111117,"G"]
[1111118,"H"]
[1111119,"I"]
[1111120,"J"]
[1111121,"K"]
[1111122,"L"]
[1111123,"M"]
[1111124,"N"]
[1111125,"O"]
[1111126,"P"]
[1111127,"Q"]
[1111128,"R"]

{"sheet":"Modèle","index":2,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
[null,null,"TEST1",null,"TEST2",null,"TEST3"]
["NUM AGENT","NOM","Nbre XX","Nbre YY","Nbre XX","Nbre YY","Nbre XX","Nbre YY","traitement global","% exclusions"]
[{"$f":"'Liste Agents'!A2","v":1111111},{"$f":"'Liste Agents'!B2","v":"A"},null,null,null,null,null,null,{"$f":"SUM($C3:$H3)","v":0},{"$f":"IF(SUM($D3,$F3,$H3)=0,0,SUM($D3,$F3,$H3)/$I3)","v":0}]
[{"$f":"'Liste Agents'!A3","v":1111112},{"$f":"'Liste Agents'!B3","v":"B"},null,null,null,null,null,null,{"$f":"SUM($C4:$H4)","v":0},{"$f":"IF(SUM($D4,$F4,$H4)=0,0,SUM($D4,$F4,$H4)/$I4)","v":0}]
[{"$f":"'Liste Agents'!A4","v":1111113},{"$f":"'Liste Agents'!B4","v":"C"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A5","v":1111114},{"$f":"'Liste Agents'!B5","v":"D"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A6","v":1111115},{"$f":"'Liste Agents'!B6","v":"E"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A7","v":1111116},{"$f":"'Liste Agents'!B7","v":"F"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A8","v":1111117},{"$f":"'Liste Agents'!B8","v":"G"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A9","v":1111118},{"$f":"'Liste Agents'!B9","v":"H"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A10","v":1111119},{"$f":"'Liste Agents'!B10","v":"I"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A11","v":1111120},{"$f":"'Liste Agents'!B11","v":"J"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A12","v":1111121},{"$f":"'Liste Agents'!B12","v":"K"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A13","v":1111122},{"$f":"'Liste Agents'!B13","v":"L"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A14","v":1111123},{"$f":"'Liste Agents'!B14","v":"M"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A15","v":1111124},{"$f":"'Liste Agents'!B15","v":"N"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A16","v":1111125},{"$f":"'Liste Agents'!B16","v":"O"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A17","v":1111126},{"$f":"'Liste Agents'!B17","v":"P"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A18","v":1111127},{"$f":"'Liste Agents'!B18","v":"Q"},null,null,null,null,null,null,0,0]
[{"$f":"'Liste Agents'!A19","v":1111128},{"$f":"'Liste Agents'!B19","v":"R"},null,null,null,null,null,null,0,0]
[null,"TOTAL",{"$f":"SUM(C3:C20)","v":0},0,0,0,0,0,0,0]