{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":3,"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":"Feuil1","index":0,"n_rows":26,"n_cols":45,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,2,24,3],[3,0,4,3],[4,22,4,44],[4,4,4,20],[22,2,22,3],[23,2,23,3]]}
[]
[]
[]
["Planning été 2022"]
[null,null,null,null,{"$f":"E6","v":"2022-07-07"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W6","v":"2022-08-01"}]
["Poste","Prénom NOM","début","fin","2022-07-07",{"$f":"E6+1","v":"2022-07-08"},{"$f":"F6+3","v":"2022-07-11"},{"$f":"G6+1","v":"2022-07-12"},{"$f":"H6+1","v":"2022-07-13"},"2022-07-14","2022-07-15",{"$f":"K6+3","v":"2022-07-18"},{"$f":"L6+1","v":"2022-07-19"},"2022-07-20","2022-07-21","2022-07-22",{"$f":"P6+3","v":"2022-07-25"},{"$f":"Q6+1","v":"2022-07-26"},"2022-07-27","2022-07-28","2022-07-29",null,{"$f":"U6+3","v":"2022-08-01"},{"$f":"W6+1","v":"2022-08-02"},"2022-08-03","2022-08-04","2022-08-05",{"$f":"AA6+3","v":"2022-08-08"},{"$f":"AB6+1","v":"2022-08-09"},"2022-08-10","2022-08-11","2022-08-12",{"$f":"AF6+3","v":"2022-08-15"},{"$f":"AG6+1","v":"2022-08-16"},"2022-08-17","2022-08-18","2022-08-19",{"$f":"AK6+3","v":"2022-08-22"},{"$f":"AL6+1","v":"2022-08-23"},"2022-08-24","2022-08-25","2022-08-26",{"$f":"AP6+3","v":"2022-08-29"},{"$f":"AQ6+1","v":"2022-08-30"},"2022-08-31"]
["Directeur","Agent 1","2022-07-07","2022-08-31","d","d","d","d","d",null,"d","d","d","d","d","d","d","d","d","d","d",null,"v","v","v","v","v","v","v","v","v","v",null,"d","d","d","d","d","d","d","d","d","d","d","d"]
[]
["Diplômé","Agent 3","2022-07-07","2022-07-31","m","m","m","m","m",null,"m","m","m","m","m","m","m","m","m","m","m"]
["Diplômé","Agent 4","2022-07-07","2022-08-07","m","m","m","m","m",null,"m","m","m","m","m","m","m","m","m","m","m",null,"m","m","m","m","m","v","v","v","v","v",null,"v","v","v","v","m","m","m","m","m","m","m","m"]
["Diplômé","Agent 5","2022-07-07","2022-07-31","p","p","p","p","p",null,"p","p","p","p","p","p","p","p","p","p","p"]
["Diplômé","Agent 6","2022-07-07","2022-08-31","p","p","p","p","p",null,"p","m","m","m","m","m","p","p","p","p","p",null,"p","p","p","p","p","p","p","p","p","p",null,"p","p","p","p","p","p","p","p","p","p","p","p"]
["Non diplômé","Agent 7","2022-07-07","2022-08-31","p","p","p","p","p",null,"p","p","p","p","p","p","p","p","m","m","m",null,"p","p","p","p","p","p","p","p","p","p",null,"p","p","p","p","p","p","p","p","p","p","p","p"]
["Stagiaire","Agent 8","2022-07-07","2022-07-31","p","p","p","p","p",null,"p","p","p","p","p","p","p","p","p","p","p"]
["Non diplômé","Agent 9","2022-07-07","2022-07-31","m","m","m","m","m",null,"m","m","m","m","m","m","m","m","m","m","m"]
["Diplômé","Agent 10","2022-07-07","2022-07-17","p","p","p","p","p",null,"p","v","v","v","v","v","v","v","v","v","v",null,"p","p","p","p","p","p","p","p","p","p",null,"p","p","p","p","p","p","p","p","p","p","p","p"]
["Diplômé","Agent 11","2022-07-07","2022-07-10","p","p","v","v","v",null,"v","v","v","v","v","v","v","v","p","p","p",null,"p","p","p","p","p","p","p","p","p","p",null,"p","p","p","p","p","p","p","p","p","p","p","p"]
["Diplômé","Agent 12","2022-07-07","2022-08-17","m","m","m","m","m",null,"m","p","p","p","p","p","m","m","c","c","c",null,"m","m","m","m","m","m","m","m","m","m",null,"m","m","v","v","v","v","v","v","v","v","v","v"]
["Diplômé","Agent 13","2022-07-18","2022-07-22",null,null,null,null,null,null,null,"c","c","c","c","c"]
["Diplômé","Agent 14","2022-07-07","2022-07-15","p","p","c","c","c",null,"c","v","v","v","v","v","v","v","v","v","v",null,"p","p","p","p","p","p","p","p","p","p",null,"p","p","p","p","p","p","p","p","p","p","p","p"]
["Diplômé","Agent 15","2022-07-11","2022-07-29",null,null,"c","c","c",null,"c","c","c","c","c","c",null,null,"c","c","c"]
[null,null,null,null,{"$f":"IF(AND($C22<=E$6,$D22>=E$6),\"x\",\"\")","v":""},{"$f":"IF(AND($C22<=F$6,$D22>=F$6),\"o\",\"\")","v":""},"","","","","",{"$f":"IF(AND($C22<=L$6,$D22>L$6),\"o\",\"\")","v":""},"","","","","","","","","",null,{"$f":"IF(AND($C22<=W$6,$D22>W$6),\"o\",\"\")","v":""},"","","","","","","","","",null,{"$f":"IF(AND($C22<=AH$6,$D22>AH$6),\"o\",\"\")","v":""},"","","","","","","","","","",""]
[null,null,"Primaires",null,{"$f":"COUNTIF(E$9:E$22,\"p\")","v":7},{"$f":"COUNTIF(F$9:F$22,\"p\")","v":7},{"$f":"COUNTIF(G$9:G$22,\"p\")","v":5},{"$f":"COUNTIF(H$9:H$22,\"p\")","v":5},{"$f":"COUNTIF(I$9:I$22,\"p\")","v":5},null,{"$f":"COUNTIF(K$9:K$22,\"p\")","v":5},{"$f":"COUNTIF(L$9:L$22,\"p\")","v":4},{"$f":"COUNTIF(M$9:M$22,\"p\")","v":4},{"$f":"COUNTIF(N$9:N$22,\"p\")","v":4},{"$f":"COUNTIF(O$9:O$22,\"p\")","v":4},{"$f":"COUNTIF(P$9:P$22,\"p\")","v":4},{"$f":"COUNTIF(Q$9:Q$22,\"p\")","v":4},{"$f":"COUNTIF(R$9:R$22,\"p\")","v":4},{"$f":"COUNTIF(S$9:S$22,\"p\")","v":4},{"$f":"COUNTIF(T$9:T$22,\"p\")","v":4},{"$f":"COUNTIF(U$9:U$22,\"p\")","v":4},null,{"$f":"COUNTIF(W$9:W$22,\"p\")","v":5},{"$f":"COUNTIF(X$9:X$22,\"p\")","v":5},{"$f":"COUNTIF(Y$9:Y$22,\"p\")","v":5},{"$f":"COUNTIF(Z$9:Z$22,\"p\")","v":5},{"$f":"COUNTIF(AA$9:AA$22,\"p\")","v":5},{"$f":"COUNTIF(AB$9:AB$22,\"p\")","v":5},{"$f":"COUNTIF(AC$9:AC$22,\"p\")","v":5},{"$f":"COUNTIF(AD$9:AD$22,\"p\")","v":5},{"$f":"COUNTIF(AE$9:AE$22,\"p\")","v":5},{"$f":"COUNTIF(AF$9:AF$22,\"p\")","v":5},null,{"$f":"COUNTIF(AH$9:AH$22,\"p\")","v":5},{"$f":"COUNTIF(AI$9:AI$22,\"p\")","v":5},{"$f":"COUNTIF(AJ$9:AJ$22,\"p\")","v":5},{"$f":"COUNTIF(AK$9:AK$22,\"p\")","v":5},{"$f":"COUNTIF(AL$9:AL$22,\"p\")","v":5},{"$f":"COUNTIF(AM$9:AM$22,\"p\")","v":5},{"$f":"COUNTIF(AN$9:AN$22,\"p\")","v":5},{"$f":"COUNTIF(AO$9:AO$22,\"p\")","v":5},{"$f":"COUNTIF(AP$9:AP$22,\"p\")","v":5},{"$f":"COUNTIF(AQ$9:AQ$22,\"p\")","v":5},{"$f":"COUNTIF(AR$9:AR$22,\"p\")","v":5},{"$f":"COUNTIF(AS$9:AS$22,\"p\")","v":5}]
[null,null,"Maternelles",null,{"$f":"COUNTIF(E$9:E$22,\"m\")","v":4},{"$f":"COUNTIF(F$9:F$22,\"m\")","v":4},{"$f":"COUNTIF(G$9:G$22,\"m\")","v":4},{"$f":"COUNTIF(H$9:H$22,\"m\")","v":4},{"$f":"COUNTIF(I$9:I$22,\"m\")","v":4},null,{"$f":"COUNTIF(K$9:K$22,\"m\")","v":4},{"$f":"COUNTIF(L$9:L$22,\"m\")","v":4},{"$f":"COUNTIF(M$9:M$22,\"m\")","v":4},{"$f":"COUNTIF(N$9:N$22,\"m\")","v":4},{"$f":"COUNTIF(O$9:O$22,\"m\")","v":4},{"$f":"COUNTIF(P$9:P$22,\"m\")","v":4},{"$f":"COUNTIF(Q$9:Q$22,\"m\")","v":4},{"$f":"COUNTIF(R$9:R$22,\"m\")","v":4},{"$f":"COUNTIF(S$9:S$22,\"m\")","v":4},{"$f":"COUNTIF(T$9:T$22,\"m\")","v":4},{"$f":"COUNTIF(U$9:U$22,\"m\")","v":4},null,{"$f":"COUNTIF(W$9:W$22,\"m\")","v":2},{"$f":"COUNTIF(X$9:X$22,\"m\")","v":2},{"$f":"COUNTIF(Y$9:Y$22,\"m\")","v":2},{"$f":"COUNTIF(Z$9:Z$22,\"m\")","v":2},{"$f":"COUNTIF(AA$9:AA$22,\"m\")","v":2},{"$f":"COUNTIF(AB$9:AB$22,\"m\")","v":1},{"$f":"COUNTIF(AC$9:AC$22,\"m\")","v":1},{"$f":"COUNTIF(AD$9:AD$22,\"m\")","v":1},{"$f":"COUNTIF(AE$9:AE$22,\"m\")","v":1},{"$f":"COUNTIF(AF$9:AF$22,\"m\")","v":1},null,{"$f":"COUNTIF(AH$9:AH$22,\"m\")","v":1},{"$f":"COUNTIF(AI$9:AI$22,\"m\")","v":1},{"$f":"COUNTIF(AJ$9:AJ$22,\"m\")","v":0},{"$f":"COUNTIF(AK$9:AK$22,\"m\")","v":0},{"$f":"COUNTIF(AL$9:AL$22,\"m\")","v":1},{"$f":"COUNTIF(AM$9:AM$22,\"m\")","v":1},{"$f":"COUNTIF(AN$9:AN$22,\"m\")","v":1},{"$f":"COUNTIF(AO$9:AO$22,\"m\")","v":1},{"$f":"COUNTIF(AP$9:AP$22,\"m\")","v":1},{"$f":"COUNTIF(AQ$9:AQ$22,\"m\")","v":1},{"$f":"COUNTIF(AR$9:AR$22,\"m\")","v":1},{"$f":"COUNTIF(AS$9:AS$22,\"m\")","v":1}]
[null,null,"Camp",null,{"$f":"COUNTIF(E$9:E$22,\"c\")","v":0},{"$f":"COUNTIF(F$9:F$22,\"c\")","v":0},{"$f":"COUNTIF(G$9:G$22,\"c\")","v":2},{"$f":"COUNTIF(H$9:H$22,\"c\")","v":2},{"$f":"COUNTIF(I$9:I$22,\"c\")","v":2},null,{"$f":"COUNTIF(K$9:K$22,\"c\")","v":2},{"$f":"COUNTIF(L$9:L$22,\"c\")","v":2},{"$f":"COUNTIF(M$9:M$22,\"c\")","v":2},{"$f":"COUNTIF(N$9:N$22,\"c\")","v":2},{"$f":"COUNTIF(O$9:O$22,\"c\")","v":2},{"$f":"COUNTIF(P$9:P$22,\"c\")","v":2},{"$f":"COUNTIF(Q$9:Q$22,\"c\")","v":0},{"$f":"COUNTIF(R$9:R$22,\"c\")","v":0},{"$f":"COUNTIF(S$9:S$22,\"c\")","v":2},{"$f":"COUNTIF(T$9:T$22,\"c\")","v":2},{"$f":"COUNTIF(U$9:U$22,\"c\")","v":2},null,{"$f":"COUNTIF(W$9:W$22,\"c\")","v":0},{"$f":"COUNTIF(X$9:X$22,\"c\")","v":0},{"$f":"COUNTIF(Y$9:Y$22,\"c\")","v":0},{"$f":"COUNTIF(Z$9:Z$22,\"c\")","v":0},{"$f":"COUNTIF(AA$9:AA$22,\"c\")","v":0},{"$f":"COUNTIF(AB$9:AB$22,\"c\")","v":0},{"$f":"COUNTIF(AC$9:AC$22,\"c\")","v":0},{"$f":"COUNTIF(AD$9:AD$22,\"c\")","v":0},{"$f":"COUNTIF(AE$9:AE$22,\"c\")","v":0},{"$f":"COUNTIF(AF$9:AF$22,\"c\")","v":0},null,{"$f":"COUNTIF(AH$9:AH$22,\"c\")","v":0},{"$f":"COUNTIF(AI$9:AI$22,\"c\")","v":0},{"$f":"COUNTIF(AJ$9:AJ$22,\"c\")","v":0},{"$f":"COUNTIF(AK$9:AK$22,\"c\")","v":0},{"$f":"COUNTIF(AL$9:AL$22,\"c\")","v":0},{"$f":"COUNTIF(AM$9:AM$22,\"c\")","v":0},{"$f":"COUNTIF(AN$9:AN$22,\"c\")","v":0},{"$f":"COUNTIF(AO$9:AO$22,\"c\")","v":0},{"$f":"COUNTIF(AP$9:AP$22,\"c\")","v":0},{"$f":"COUNTIF(AQ$9:AQ$22,\"c\")","v":0},{"$f":"COUNTIF(AR$9:AR$22,\"c\")","v":0},{"$f":"COUNTIF(AS$9:AS$22,\"c\")","v":0}]
[null,null,null,"TOTAL",{"$f":"SUM(E23:E25)","v":11},{"$f":"SUM(F23:F25)","v":11},11,11,11,null,11,10,10,10,10,10,8,8,10,10,10,null,7,7,7,7,7,6,6,6,6,6,null,6,6,5,5,6,6,6,6,6,6,6,6]