{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["BD","Calendrier","Jour_feries","Sources","DONNEES"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":28,"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":"BD","index":0,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["NOM","PRENOM","D. NAISSANCE","NIVEAU","TELEPHONE","EMAIL","ADRESSE","CACI","DATE D'ECHEANCE","TAILLE"]
["TEST1","Tes1","23/11/1994","PE 20 "]
["TEST2","Test2","18/09/1993","PE 20 "]
["TEST3","Test3","22 mai 1993","N3"]
["TEST4","Test4","30/10/1992","N2"]
["TEST5","Test5","31 mars 1993","PE 20 "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"","","","","",""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diane","N3"]

{"sheet":"Calendrier","index":1,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,4,2,6],[1,8,1,9],[5,15,5,16],[5,17,5,18]]}
["a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R"]
["a",null,"Année",null,{"$f":"IF(C3<>\"\",\"Calendrier  \" & C3,\"\")","v":"Calendrier  2020"},null,null,null,"Noter un RDV",null,null,null,null,null,null,"T",""]
["a",null,2020,null,null,null,null,null,null,null,null,null,null,null,null,"R"]
["a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R"]
["a",null,"2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01"]
["a",null,{"$f":"IF($C$3<>\"\",PROPER(TEXT(C5,\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF($C$3<>\"\",PROPER(TEXT(D5,\"mmmm\")),\"\")","v":"Février"},"Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre",null,"Matin",null,"Après-midi"]
["a",1,{"$f":"IF(C$6<>\"\",DATE($C$3,MONTH(C$5),$B7),\"\")","v":"2020-01-01"},{"$f":"IF(D$6<>\"\",DATE($C$3,MONTH(D$5),$B7),\"\")","v":"2020-02-01"},"2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01",null,"Plongeurs","Niv / Bre","Plongeurs","Niv / Bre"]
["a",2,{"$f":"IF(C$6<>\"\",IF(MONTH(DATE($C$3,MONTH(C$5),$B8))=MONTH(C$7),DATE($C$3,MONTH(C$5),$B8),\"\"),\"\")","v":"2020-01-02"},{"$f":"IF(D$6<>\"\",IF(MONTH(DATE($C$3,MONTH(D$5),$B8))=MONTH(D$7),DATE($C$3,MONTH(D$5),$B8),\"\"),\"\")","v":"2020-02-02"},"2020-03-02","2020-04-02","2020-05-02","2020-06-02","2020-07-02","2020-08-02","2020-09-02","2020-10-02","2020-11-02","2020-12-02",1,"François","Aucun"]
["a",3,{"$f":"IF(C$6<>\"\",IF(MONTH(DATE($C$3,MONTH(C$5),$B9))=MONTH(C$7),DATE($C$3,MONTH(C$5),$B9),\"\"),\"\")","v":"2020-01-03"},"2020-02-03","2020-03-03","2020-04-03","2020-05-03","2020-06-03","2020-07-03","2020-08-03","2020-09-03","2020-10-03","2020-11-03","2020-12-03",2]
["a",4,"2020-01-04","2020-02-04","2020-03-04","2020-04-04","2020-05-04","2020-06-04","2020-07-04","2020-08-04","2020-09-04","2020-10-04","2020-11-04","2020-12-04",3]
["a",5,"2020-01-05",{"$f":"IF(D$6<>\"\",IF(MONTH(DATE($C$3,MONTH(D$5),$B11))=MONTH(D$7),DATE($C$3,MONTH(D$5),$B11),\"\"),\"\")","v":"2020-02-05"},"2020-03-05","2020-04-05","2020-05-05","2020-06-05","2020-07-05","2020-08-05","2020-09-05","2020-10-05","2020-11-05","2020-12-05",4]
["a",6,"2020-01-06","2020-02-06","2020-03-06","2020-04-06",{"$f":"IF(G$6<>\"\",IF(MONTH(DATE($C$3,MONTH(G$5),$B12))=MONTH(G$7),DATE($C$3,MONTH(G$5),$B12),\"\"),\"\")","v":"2020-05-06"},"2020-06-06","2020-07-06","2020-08-06","2020-09-06","2020-10-06","2020-11-06","2020-12-06",5,null,""]
["a",7,"2020-01-07","2020-02-07","2020-03-07","2020-04-07","2020-05-07","2020-06-07","2020-07-07","2020-08-07","2020-09-07","2020-10-07","2020-11-07","2020-12-07",6,null,""]
["a",8,"2020-01-08","2020-02-08","2020-03-08","2020-04-08","2020-05-08","2020-06-08","2020-07-08","2020-08-08","2020-09-08","2020-10-08","2020-11-08","2020-12-08",7,null,""]
["a",9,"2020-01-09","2020-02-09","2020-03-09","2020-04-09","2020-05-09","2020-06-09","2020-07-09","2020-08-09","2020-09-09","2020-10-09","2020-11-09","2020-12-09",8,null,""]
["a",10,"2020-01-10","2020-02-10","2020-03-10","2020-04-10","2020-05-10","2020-06-10","2020-07-10","2020-08-10","2020-09-10","2020-10-10","2020-11-10","2020-12-10",9,null,""]
["a",11,"2020-01-11","2020-02-11","2020-03-11","2020-04-11","2020-05-11","2020-06-11","2020-07-11","2020-08-11","2020-09-11","2020-10-11","2020-11-11","2020-12-11",10,null,""]
["a",12,"2020-01-12","2020-02-12","2020-03-12","2020-04-12","2020-05-12","2020-06-12","2020-07-12","2020-08-12","2020-09-12","2020-10-12","2020-11-12","2020-12-12",11,null,""]
["a",13,"2020-01-13","2020-02-13","2020-03-13","2020-04-13","2020-05-13","2020-06-13","2020-07-13","2020-08-13","2020-09-13","2020-10-13","2020-11-13","2020-12-13",12,null,""]
["a",14,"2020-01-14","2020-02-14","2020-03-14","2020-04-14","2020-05-14","2020-06-14","2020-07-14","2020-08-14","2020-09-14","2020-10-14","2020-11-14","2020-12-14",13,null,""]
["a",15,"2020-01-15","2020-02-15","2020-03-15","2020-04-15","2020-05-15","2020-06-15","2020-07-15","2020-08-15","2020-09-15","2020-10-15","2020-11-15","2020-12-15",14,null,""]
["a",16,"2020-01-16","2020-02-16","2020-03-16","2020-04-16","2020-05-16","2020-06-16","2020-07-16","2020-08-16","2020-09-16","2020-10-16","2020-11-16","2020-12-16",15,null,""]
["a",17,"2020-01-17","2020-02-17","2020-03-17","2020-04-17","2020-05-17","2020-06-17","2020-07-17","2020-08-17","2020-09-17","2020-10-17","2020-11-17","2020-12-17",16,null,""]
["a",18,"2020-01-18","2020-02-18","2020-03-18","2020-04-18","2020-05-18","2020-06-18","2020-07-18","2020-08-18","2020-09-18","2020-10-18","2020-11-18","2020-12-18",17,null,""]
["a",19,"2020-01-19","2020-02-19","2020-03-19","2020-04-19","2020-05-19","2020-06-19","2020-07-19","2020-08-19","2020-09-19","2020-10-19","2020-11-19","2020-12-19",18,null,""]
["a",20,"2020-01-20","2020-02-20","2020-03-20","2020-04-20","2020-05-20","2020-06-20","2020-07-20","2020-08-20","2020-09-20","2020-10-20","2020-11-20","2020-12-20",19,null,""]
["a",21,"2020-01-21","2020-02-21","2020-03-21","2020-04-21","2020-05-21","2020-06-21","2020-07-21","2020-08-21","2020-09-21","2020-10-21","2020-11-21","2020-12-21",20,null,""]
["a",22,"2020-01-22","2020-02-22","2020-03-22","2020-04-22","2020-05-22","2020-06-22","2020-07-22","2020-08-22","2020-09-22","2020-10-22","2020-11-22","2020-12-22",25,null,""]
["a",23,"2020-01-23","2020-02-23","2020-03-23","2020-04-23","2020-05-23","2020-06-23","2020-07-23","2020-08-23","2020-09-23","2020-10-23","2020-11-23","2020-12-23",26,null,""]
["a",24,"2020-01-24","2020-02-24","2020-03-24","2020-04-24","2020-05-24","2020-06-24","2020-07-24","2020-08-24","2020-09-24","2020-10-24","2020-11-24","2020-12-24",27,null,""]
["a",25,"2020-01-25","2020-02-25","2020-03-25","2020-04-25","2020-05-25","2020-06-25","2020-07-25","2020-08-25","2020-09-25","2020-10-25","2020-11-25","2020-12-25",28]
["a",26,"2020-01-26","2020-02-26","2020-03-26","2020-04-26","2020-05-26","2020-06-26","2020-07-26","2020-08-26","2020-09-26","2020-10-26","2020-11-26","2020-12-26",29]
["a",27,"2020-01-27","2020-02-27","2020-03-27","2020-04-27","2020-05-27","2020-06-27","2020-07-27","2020-08-27","2020-09-27","2020-10-27","2020-11-27","2020-12-27",30]
["a",28,"2020-01-28","2020-02-28","2020-03-28","2020-04-28","2020-05-28","2020-06-28","2020-07-28","2020-08-28","2020-09-28","2020-10-28","2020-11-28","2020-12-28",null,null,""]
["a",29,"2020-01-29","2020-02-29","2020-03-29","2020-04-29","2020-05-29","2020-06-29","2020-07-29","2020-08-29","2020-09-29","2020-10-29","2020-11-29","2020-12-29",null,null,""]
["a",30,"2020-01-30","","2020-03-30","2020-04-30","2020-05-30","2020-06-30","2020-07-30","2020-08-30","2020-09-30","2020-10-30","2020-11-30","2020-12-30"]
["a",31,"2020-01-31","","2020-03-31","","2020-05-31","","2020-07-31","2020-08-31","","2020-10-31","","2020-12-31"]

{"sheet":"Jour_feries","index":2,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,1,1,7]]}
[]
[null,"Jour fériés en France"]
[]
[null,null,2020,2021,2022,2023,2024,2025,null,2020,{"$f":"IF(J4<>\"\",HLOOKUP(J4,$C$4:$H$5,2,FALSE),\"\")","v":4}]
[null,null,4,5,6,4,5,6]
[null,"Jour de l'an","2020-01-01","2021-01-01","2022-01-01","2020-01-01","2021-01-01","2022-01-01",null,{"$f":"INDEX($C$6:$H$16,K6,$K$4)","v":"2020-01-01"},1]
[null,"Lundi de Pâques","2020-04-13","2021-04-05","2022-04-18","2020-04-13","2021-04-05","2022-04-18",null,{"$f":"INDEX($C$6:$H$16,K7,$K$4)","v":"2020-04-13"},2]
[null,"Fête du Travail","2020-05-01","2021-05-01","2022-05-01","2020-05-01","2021-05-01","2022-05-01",null,"2020-05-01",3]
[null,"8 Mai","2020-05-08","2021-05-08","2022-05-08","2020-05-08","2021-05-08","2022-05-08",null,"2020-05-08",4]
[null,"Jeudi de l'Ascension","2020-05-21","2021-05-13","2022-05-26","2020-05-21","2021-05-13","2022-05-26",null,"2020-05-21",5]
[null,"Lundi de Pentecôte","2020-06-01","2021-05-24","2022-06-06","2020-06-01","2021-05-24","2022-06-06",null,"2020-06-01",6]
[null,"Fête Nationale","2020-07-14","2021-07-14","2022-07-14","2020-07-14","2021-07-14","2022-07-14",null,"2020-07-14",7]
[null,"Assomption","2020-08-15","2021-08-15","2022-08-15","2020-08-15","2021-08-15","2022-08-15",null,"2020-08-15",8]
[null,"La Toussaint","2020-11-01","2021-11-01","2022-11-01","2020-11-01","2021-11-01","2022-11-01",null,"2020-11-01",9]
[null,"Armistice","2020-11-11","2021-11-11","2022-11-11","2020-11-11","2021-11-11","2022-11-11",null,"2020-11-11",10]
[null,"Noël","2020-12-25","2021-12-25","2022-12-25","2020-12-25","2021-12-25","2022-12-25",null,"2020-12-25",11]

{"sheet":"Sources","index":3,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Jours","Mois"]
[1,"Janvier",1]
[2,"Février",2]
[3,"Mars",3]
[4,"Avril",4]
[5,"Mai",5]
[6,"Juin",6]
[7,"Juillet",7]
[8,"Août",8]
[9,"Septembre",9]
[10,"Octobre",10]
[11,"Novembre",11]
[12,"Décembre",12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]

{"sheet":"DONNEES","index":4,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["------","------","------","------","------"]
["Aucun",140,40,"Oui","XXXS"]
["PE12",141,41,"Non","XXS"]
["PE20 ",142,42,null,"XS"]
["PE40",143,43,null,"S"]
["PE60",144,44,null,"M"]
["PA12",145,45,null,"L"]
["PA20",146,46,null,"XL"]
["PA40",147,47,null,"XXL"]
["PA60",148,48]
["N1",149,49]
["N2",150,50]
["N3",151,51]
["G.P",152,52]
["E2",153,53]
["E3",154,54]
["E4",155,55]
["------",156,56]
["OWD - RSTC",157,57]
["AOWD - RSTC",158,58]
["RD - RSTC",159,59]
["DM - RSTC",160,60]
["INST - RSTC",161,61]
["------",162,62]
["MF1 - E3",163,63]
["MF2 - E4",164,64]
["------",165,65]
["BEES 1",166,66]
["BEES 2",167,67]
["BEES 3",168,68]
["------",169,69]
["BPJEPS - E2",170,70]
["DEJEPS - E3",171,71]
["DEJEPS - E4",172,72]
["DESJEPS - E4",173,73]
[null,174,74]
[null,175,75]
[null,175,76]
[null,177,77]
[null,178,78]
[null,179,79]
[null,180,80]
[null,181,81]
[null,182,82]
[null,183,83]
[null,184,84]
[null,185,85]
[null,186,86]
[null,187,87]
[null,188,88]
[null,189,89]
[null,190,90]
[null,191,91]
[null,192,92]
[null,193,93]
[null,194,94]
[null,195,95]
[null,196,96]
[null,197,97]
[null,198,98]
[null,199,99]
[null,"+++",100]
[null,null,"+++"]