{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Janv","Févr","Mars","Avr","Base"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":1,"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":"Janv","index":0,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,11,5,12],[5,13,5,14],[5,3,5,10],[3,0,3,15]]}
[1]
[]
[{"$f":"IF(OR(COUNTIF($C8,\"*m*\"),COUNTIF($C8,\"*am*\")),\"\",\"\")","v":""}]
[{"$f":"UPPER(\"PLANNING PESEE/TRI DU MOIS DE \"&TEXT(A9,(\"MMMM AAAA\")))","v":"PLANNING PESEE/TRI DU MOIS DE JANVIER 2020"}]
[]
[null,null,"ARS","CDI EN CDP",null,null,null,null,null,null,null,"INTERIM EN CDP",null,"CDI AU TRI"]
[null,null,"STRABACH.M","AIT HACENE.H","BARBIER.S","BAUDIN.J","FRANCOIS.P","DIDOT.F","JALLU.N","MARTIN.L","VINCENT.J","LEFRANC.M","KRIEGEL.M","DEHARBE.F","OUDIN.C","Commentaires",null,"Commentaires Personnels"]
[{"$f":"DATE(Base!E2+2019,A1,1)","v":"2020-01-01"},{"$f":"WEEKNUM($A8,21)","v":1},"J"]
[{"$f":"A8+1","v":"2020-01-02"},{"$f":"IF(WEEKDAY($A9,3)=0,WEEKNUM($A9,21),\"\")","v":""},"J",null,null,null,null,null,null,null,"CP"]
[{"$f":"A9+1","v":"2020-01-03"},"","J",null,null,null,null,null,null,null,"CP"]
["2020-01-04",""]
["2020-01-05",""]
["2020-01-06",2,"J"]
["2020-01-07","","J","FOR",null,null,null,null,null,null,null,null,null,null,null,"H.formation incendie"]
["2020-01-08","","J"]
["2020-01-09","","J"]
["2020-01-10","","J"]
["2020-01-11",""]
[{"$f":"A18+1","v":"2020-01-12"},""]
["2020-01-13",3,"J","RTT"]
["2020-01-14","","AM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AM voir avec Dédé dossier de…...."]
["2020-01-15","","J"]
["2020-01-16","","J"]
["2020-01-17","","J"]
["2020-01-18",""]
[{"$f":"A25+1","v":"2020-01-19"},""]
["2020-01-20",4,"J"]
["2020-01-21","","J"]
["2020-01-22","","J"]
["2020-01-23","","J"]
["2020-01-24","","J"]
["2020-01-25",""]
["2020-01-26",""]
["2020-01-27",5,"J"]
["2020-01-28","","J"]
[{"$f":"A35+1","v":"2020-01-29"},"","J"]
["2020-01-30","","J"]
["2020-01-31","","J"]

{"sheet":"Févr","index":1,"n_rows":38,"n_cols":95,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,0,2,17],[5,3,5,11],[5,12,5,14],[5,15,5,16]]}
[2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"UPPER(\"PLANNING PESEE/TRI DU MOIS DE \"&TEXT(A8,(\"MMMM AAAA\")))","v":"PLANNING PESEE/TRI DU MOIS DE FÉVRIER 2020"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"IF(WEEKDAY($A8,3)=0,WEEKNUM($A8,21),\"\")","v":""}]
[]
[null,null,"ARS","CDI EN CDP",null,null,null,null,null,null,null,null,"INTERIM EN CDP",null,null,"CDI AU TRI"]
[null,null,"S.M","A.H","B.S","DIDOT.F","J.N","M.L","T.N","B.J",null,"F.P","L.M",null,"K.M","D.F","O.C","Commentaires",null,"Commentaires Personnels"]
[{"$f":"DATE(Base!E2+2019,A1,1)","v":"2020-02-01"},{"$f":"WEEKNUM($A8,21)","v":5}]
[{"$f":"A8+1","v":"2020-02-02"},{"$f":"IF(WEEKDAY($A9,3)=0,WEEKNUM($A9,21),\"\")","v":""}]
[{"$f":"A9+1","v":"2020-02-03"},6,"J"]
["2020-02-04","","J"]
["2020-02-05","","J"]
["2020-02-06","","J"]
["2020-02-07","","J"]
["2020-02-08",""]
["2020-02-09",""]
["2020-02-10",7,"J"]
["2020-02-11","","J"]
[{"$f":"A18+1","v":"2020-02-12"},"","J"]
["2020-02-13","","J"]
["2020-02-14","","J"]
["2020-02-15",""]
["2020-02-16",""]
["2020-02-17",8,"J"]
["2020-02-18","","J"]
[{"$f":"A25+1","v":"2020-02-19"},"","J"]
["2020-02-20","","J"]
["2020-02-21","","J"]
["2020-02-22",""]
["2020-02-23",""]
["2020-02-24",9,"J"]
["2020-02-25","","J"]
["2020-02-26","","J"]
["2020-02-27","","J"]
["2020-02-28","","J"]
[{"$f":"A35+1","v":"2020-02-29"},""]
["2020-03-01",""]
["2020-03-02",10,"J"]

{"sheet":"Mars","index":2,"n_rows":38,"n_cols":93,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,0,2,15],[5,3,5,10],[5,11,5,12],[5,13,5,14]]}
[3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"UPPER(\"PLANNING PESEE/TRI DU MOIS DE \"&TEXT(A8,(\"MMMM AAAA\")))","v":"PLANNING PESEE/TRI DU MOIS DE MARS 2020"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"IF(WEEKDAY($A8,3)=0,WEEKNUM($A8,21),\"\")","v":""}]
[]
[null,null,"ARS","CDI EN CDP",null,null,null,null,null,null,null,"INTERIM EN CDP",null,"CDI AU TRI"]
[null,null,"S.M","A.H","B.S","DIDOT.F","J.N","M.L","T.N","B.J","F.P","L.M","K.M","D.F","O.C","Commentaires",null,"Commentaires Personnels"]
[{"$f":"DATE(Base!E2+2019,A1,1)","v":"2020-03-01"},{"$f":"WEEKNUM($A8,21)","v":9}]
[{"$f":"A8+1","v":"2020-03-02"},{"$f":"IF(WEEKDAY($A9,3)=0,WEEKNUM($A9,21),\"\")","v":10},"J"]
[{"$f":"A9+1","v":"2020-03-03"},"","J"]
["2020-03-04","","J"]
["2020-03-05","","J"]
["2020-03-06","","J"]
["2020-03-07",""]
["2020-03-08",""]
["2020-03-09",11,"J"]
["2020-03-10","","J"]
["2020-03-11","","J"]
[{"$f":"A18+1","v":"2020-03-12"},"","J"]
["2020-03-13","","J"]
["2020-03-14",""]
["2020-03-15",""]
["2020-03-16",12,"J"]
["2020-03-17","","J"]
["2020-03-18","","J"]
[{"$f":"A25+1","v":"2020-03-19"},"","J"]
["2020-03-20","","J"]
["2020-03-21",""]
["2020-03-22",""]
["2020-03-23",13,"J"]
["2020-03-24","","J"]
["2020-03-25","","J"]
["2020-03-26","","J"]
["2020-03-27","","J"]
["2020-03-28",""]
[{"$f":"A35+1","v":"2020-03-29"},""]
["2020-03-30",14,"J"]
["2020-03-31","","J"]

{"sheet":"Avr","index":3,"n_rows":38,"n_cols":93,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,0,2,15],[5,3,5,10],[5,11,5,12],[5,13,5,14]]}
[4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"UPPER(\"PLANNING PESEE/TRI DU MOIS DE \"&TEXT(A8,(\"MMMM AAAA\")))","v":"PLANNING PESEE/TRI DU MOIS DE AVRIL 2020"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"IF(WEEKDAY($A8,3)=0,WEEKNUM($A8,21),\"\")","v":""}]
[]
[null,null,"ARS","CDI EN CDP",null,null,null,null,null,null,null,"INTERIM EN CDP",null,"CDI AU TRI"]
[null,null,"S.M","A.H","B.S","DIDOT.F","J.N","M.L","T.N","B.J","F.P","L.M","K.M","D.F","O.C","Commentaires",null,"Commentaires Personnels"]
[{"$f":"DATE(Base!E2+2019,A1,1)","v":"2020-04-01"},{"$f":"WEEKNUM($A8,21)","v":14},"J"]
[{"$f":"A8+1","v":"2020-04-02"},{"$f":"IF(WEEKDAY($A9,3)=0,WEEKNUM($A9,21),\"\")","v":""},"J"]
[{"$f":"A9+1","v":"2020-04-03"},"","J"]
["2020-04-04",""]
["2020-04-05",""]
["2020-04-06",15,"J"]
["2020-04-07","","J"]
["2020-04-08","","J"]
["2020-04-09","","J"]
["2020-04-10","","J"]
["2020-04-11",""]
[{"$f":"A18+1","v":"2020-04-12"},""]
["2020-04-13",16,"J"]
["2020-04-14","","J"]
["2020-04-15","","J"]
["2020-04-16","","J"]
["2020-04-17","","J"]
["2020-04-18",""]
[{"$f":"A25+1","v":"2020-04-19"},""]
["2020-04-20",17,"J"]
["2020-04-21","","J"]
["2020-04-22","","J"]
["2020-04-23","","J"]
["2020-04-24","","J"]
["2020-04-25",""]
["2020-04-26",""]
["2020-04-27",18,"J"]
["2020-04-28","","J"]
[{"$f":"A35+1","v":"2020-04-29"},"","J"]
["2020-04-30","","J"]
["2020-05-01","","J"]

{"sheet":"Base","index":4,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,8,1,9]]}
[null,null,null,null,null,"Janvier",2020,null,"année",{"$f":"E2+2019","v":2020}]
[null,null,null,"année",1,"Fevrier",2021,null,"Jour férier",null,null,"CP"]
["1er jour du mois",{"$f":"DATE(E2+2019,A1,1)","v":"2019-12-01"},null,"mois",2,"Mars",2022,null,null,null,null,"RTT",null,"AM"]
["dernier jour du mois",{"$f":"DATE(E2+2019,A1+1,1)-1","v":"2019-12-31"},null,null,null,"Avril",2023,null,"jour de l'an",{"$f":" DATE($J$1,1,1)","v":"2020-01-01"},null,"RCN",null,"M"]
[null,null,null,null,null,"Mai",2024,null,"Pâques",{"$f":" ROUND(DATE($J$1,4,MOD(234-11*MOD($J$1,19),30))/7,)*7-6","v":"2020-04-12"},null,"RCR"]
[null,null,null,null,null,"Juin",2025,null,"Lundi de paques",{"$f":"J5+1","v":"2020-04-13"},null,"MAL"]
[null,null,null,null,null,"Juillet",2026,null,"1er mai",{"$f":"DATE($J$1,5,1)","v":"2020-05-01"},null,"PAT"]
[null,null,null,null,null,"Août",2027,null,"2020-05-08",{"$f":"DATE($J$1,5,8)","v":"2020-05-08"},null,"CAN"]
[null,null,null,null,null,"Septembre",2028,null,"Ascenscion",{"$f":"J5+39","v":"2020-05-21"},null,"MEN"]
[null,null,null,null,null,"Octobre",2029,null,"Pentecote",{"$f":"J6+49","v":"2020-06-01"},null,"HV"]
[null,null,null,null,null,"Novembre",2030,null,"Lundi de Pentecote",{"$f":"J7+50","v":"2020-06-20"},null,"NAI"]
[null,null,null,null,null,"Décembre",2031,null,"2020-07-14",{"$f":"DATE($J$1,7,14)","v":"2020-07-14"},null,"MAT"]
[null,null,null,null,null,null,null,null,"15 aout",{"$f":"DATE($J$1,8,15)","v":"2020-08-15"},null,"PAT"]
[null,null,null,null,null,null,null,null,"1er novembre",{"$f":"DATE($J$1,11,1)","v":"2020-11-01"},null,"CSS"]
[null,null,null,null,null,null,null,null,"2020-11-11",{"$f":"DATE($J$1,12,25)","v":"2020-12-25"},null,"DEM"]
[null,null,null,null,null,null,null,null,"2020-12-25",{"$f":"DATE($J$1,11,11)","v":"2020-11-11"},null,"FOR"]
[null,null,null,null,null,null,null,null,null,null,null,"ES"]
[null,null,null,null,null,null,null,null,null,null,null,"EF"]