{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Planning global","Planning par salarié","Paramètres"],"not_rendered":{"charts":0,"images":0,"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":"Planning global","index":0,"n_rows":637,"n_cols":35,"rows_kept":637,"cut":false,"hidden":false,"merged":[]}
[4]
[1]
[]
["Société","Matricule","Nom","Prénom",{"$f":"+DATE(A2+2018,A1,1)","v":"2019-04-01"},{"$f":"+E4+1","v":"2019-04-02"},{"$f":"+F4+1","v":"2019-04-03"},{"$f":"+G4+1","v":"2019-04-04"},"2019-04-05","2019-04-06","2019-04-07","2019-04-08","2019-04-09","2019-04-10","2019-04-11","2019-04-12","2019-04-13","2019-04-14","2019-04-15","2019-04-16","2019-04-17","2019-04-18","2019-04-19","2019-04-20","2019-04-21","2019-04-22","2019-04-23","2019-04-24","2019-04-25","2019-04-26","2019-04-27","2019-04-28","2019-04-29","2019-04-30","2019-05-01"]
["Société A",1,"A"]
["Société A",2,"B"]
["Société B",3,"C"]
["Société A",4,"D"]
["Société A",5,"A"]
["Société A",6,"B"]
["Société A",7,"C"]
["Société A",8,"D"]
["Société A",9,"A"]
["Société A",10,"B"]
["Société A",11,"C"]
["Société A",12,"D"]
["Société A",13,"A"]
["Société A",14,"B"]
["Société A",15,"C"]
["Société A",16,"D"]
["Société C",17,"A"]
["Société C",18,"B"]
["Société A",19,"C"]
["Société A",20,"D"]
["Société A",21,"A"]
["Société B",22,"B"]
["Société C",23,"C"]
["Société A",24,"D"]
["Société A",25,"A"]
["Société A",26,"B"]
["Société A",27,"C"]
["Société D",28,"D"]
["Société A",29,"A"]
["Société A",30,"B"]
["Société A",31,"C"]
["Société A",32,"D"]
["Société A",33,"A"]
["Société A",34,"B"]
["Société A",35,"C"]
["Société A",36,"D"]
["Société A",37,"A"]
["Société A",38,"B"]
["Société A",39,"C"]
["Société A",40,"D"]
["Société A",41,"A"]
["Société A",42,"B"]
["Société A",43,"C"]
["Société A",44,"D"]
["Société A",45,"A"]
["Société A",46,"B"]
["Société A",47,"C"]
["Société A",48,"D"]
["Société A",49,"A"]
["Société A",50,"B"]
["Société A",51,"C"]
["Société C",52,"D"]
["Société A",53,"A"]
["Société A",54,"B"]
["Société A",55,"C"]
["Société A",56,"D"]
["Société A",57,"A"]
["Société A",58,"B"]
["Société A",59,"C"]
["Société A",60,"D"]
["Société A",61,"A"]
["Société D",62,"B"]
["Société A",63,"C"]
["Société A",64,"D"]
["Société B",65,"A"]
["Société A",66,"B"]
["Société A",67,"C"]
["Société A",68,"D"]
["Société A",69,"A"]
["Société A",70,"B"]
["Société A",71,"C"]
["Société A",72,"D"]
["Société A",73,"A"]
["Société A",74,"B"]
["Société A",75,"C"]
["Société C",76,"D"]
["Société A",77,"A"]
["Société A",78,"B"]
["Société A",79,"C"]
["Société A",80,"D"]
["Société A",81,"A"]
["Société A",82,"B"]
["Société A",83,"C"]
["Société A",84,"D"]
["Société A",85,"A"]
["Société A",86,"B"]
["Société A",87,"C"]
["Société A",88,"D"]
["Société A",89,"A"]
["Société A",90,"B"]
["Société A",91,"C"]
["Société A",92,"D"]
["Société A",93,"A"]
["Société A",94,"B"]
["Société A",95,"C"]
["Société A",96,"D"]
["Société A",97,"A"]
["Société A",98,"B"]
["Société A",99,"C"]
["Société A",100,"D"]
["Société A",101,"A"]
["Société A",102,"B"]
["Société A",103,"C"]
["Société A",104,"D"]
["Société A",105,"A"]
["Société A",106,"B"]
["Société A",107,"C"]
["Société A",108,"D"]
["Société A",109,"A"]
["Société A",110,"B"]
["Société A",111,"C"]
["Société A",112,"D"]
["Société A",113,"A"]
["Société A",114,"B"]
["Société A",115,"C"]
["Société A",116,"D"]
["Société A",117,"A"]
["Société B",118,"B"]
["Société A",119,"C"]
["Société A",120,"D"]
["Société A",121,"A"]
["Société A",122,"B"]
["Société A",123,"C"]
["Société A",124,"D"]
["Société A",125,"A"]
["Société A",126,"B"]
["Société A",127,"C"]
["Société A",128,"D"]
["Société A",129,"A"]
["Société A",130,"B"]
["Société B",131,"C"]
["Société A",132,"D"]
["Société A",133,"A"]
["Société A",134,"B"]
["Société A",135,"C"]
["Société A",136,"D"]
["Société A",137,"A"]
["Société A",138,"B"]
["Société A",139,"C"]
["Société A",140,"D"]
["Société A",141,"A"]
["Société A",142,"B"]
["Société A",143,"C"]
["Société A",144,"D"]
["Société A",145,"A"]
["Société A",146,"B"]
["Société A",147,"C"]
["Société A",148,"D"]
["Société A",149,"A"]
["Société A",150,"B"]
["Société A",151,"C"]
["Société D",152,"D"]
["Société D",153,"A"]
["Société D",154,"B"]
["Société A",155,"C"]
["Société D",156,"D"]
["Société B",157,"A"]
["Société A",158,"B"]
["Société A",159,"C"]
["Société A",160,"D"]
["Société A",161,"A"]
["Société A",162,"B"]
["Société A",163,"C"]
["Société A",164,"D"]
["Société A",165,"A"]
["Société D",166,"B"]
["Société A",167,"C"]
["Société A",168,"D"]
["Société A",169,"A"]
["Société A",170,"B"]
["Société A",171,"C"]
["Société A",172,"D"]
["Société A",173,"A"]
["Société A",174,"B"]
["Société A",175,"C"]
["Société A",176,"D"]
["Société A",177,"A"]
["Société A",178,"B"]
["Société A",179,"C"]
["Société A",180,"D"]
["Société A",181,"A"]
["Société A",182,"B"]
["Société B",183,"C"]
["Société A",184,"D"]
["Société A",185,"A"]
["Société A",186,"B"]
["Société A",187,"C"]
["Société B",188,"D"]
["Société A",189,"A"]
["Société A",190,"B"]
["Société A",191,"C"]
["Société A",192,"D"]
["Société A",193,"A"]
["Société A",194,"B"]
["Société A",195,"C"]
["Société A",196,"D"]
["Société A",197,"A"]
["Société A",198,"B"]
["Société A",199,"C"]
["Société A",200,"D"]
["Société A",201,"A"]
["Société B",202,"B"]
["Société A",203,"C"]
["Société A",204,"D"]
["Société A",205,"A"]
["Société A",206,"B"]
["Société A",207,"C"]
["Société C",208,"D"]
["Société A",209,"A"]
["Société A",210,"B"]
["Société A",211,"C"]
["Société A",212,"D"]
["Société A",213,"A"]
["Société A",214,"B"]
["Société A",215,"C"]
["Société A",216,"D"]
["Société D",217,"A"]
["Société A",218,"B"]
["Société A",219,"C"]
["Société A",220,"D"]
["Société A",221,"A"]
["Société A",222,"B"]
["Société A",223,"C"]
["Société A",224,"D"]
["Société A",225,"A"]
["Société A",226,"B"]
["Société A",227,"C"]
["Société A",228,"D"]
["Société A",229,"A"]
["Société A",230,"B"]
["Société A",231,"C"]
["Société A",232,"D"]
["Société A",233,"A"]
["Société A",234,"B"]
["Société A",235,"C"]
["Société A",236,"D"]
["Société A",237,"A"]
["Société A",238,"B"]
["Société A",239,"C"]
["Société D",240,"D"]
["Société A",241,"A"]
["Société A",242,"B"]
["Société A",243,"C"]
["Société A",244,"D"]
["Société A",245,"A"]
["Société A",246,"B"]
["Société A",247,"C"]
["Société A",248,"D"]
["Société A",249,"A"]
["Société A",250,"B"]
["Société A",251,"C"]
["Société A",252,"D"]
["Société A",253,"A"]
["Société A",254,"B"]
["Société A",255,"C"]
["Société A",256,"D"]
["Société A",257,"A"]
["Société A",258,"B"]
["Société A",259,"C"]
["Société A",260,"D"]
["Société D",261,"A"]
["Société A",262,"B"]
["Société C",263,"C"]
["Société A",264,"D"]
["Société A",265,"A"]
["Société A",266,"B"]
["Société A",267,"C"]
["Société C",268,"D"]
["Société D",269,"A"]
["Société A",270,"B"]
["Société A",271,"C"]
["Société A",272,"D"]
["Société A",273,"A"]
["Société A",274,"B"]
["Société A",275,"C"]
["Société A",276,"D"]
["Société A",277,"A"]
["Société A",278,"B"]
["Société D",279,"C"]
["Société A",280,"D"]
["Société A",281,"A"]
["Société A",282,"B"]
["Société A",283,"C"]
["Société A",284,"D"]
["Société A",285,"A"]
["Société A",286,"B"]
["Société A",287,"C"]
["Société D",288,"D"]
["Société C",289,"A"]
["Société A",290,"B"]
["Société A",291,"C"]
["Société A",292,"D"]
["Société A",293,"A"]
["Société A",294,"B"]
["Société A",295,"C"]
["Société B",296,"D"]
["Société A",297,"A"]
["Société A",298,"B"]
["Société A",299,"C"]
["Société A",300,"D"]
["Société A",301,"A"]
["Société A",302,"B"]
["Société A",303,"C"]
["Société A",304,"D"]
["Société A",305,"A"]
["Société A",306,"B"]
["Société B",307,"C"]
["Société A",308,"D"]
["Société B",309,"A"]
["Société A",310,"B"]
["Société A",311,"C"]
["Société A",312,"D"]
["Société A",313,"A"]
["Société A",314,"B"]
["Société A",315,"C"]
["Société A",316,"D"]
["Société A",317,"A"]
["Société A",318,"B"]
["Société A",319,"C"]
["Société A",320,"D"]
["Société A",321,"A"]
["Société D",322,"B"]
["Société A",323,"C"]
["Société A",324,"D"]
["Société A",325,"A"]
["Société A",326,"B"]
["Société A",327,"C"]
["Société A",328,"D"]
["Société C",329,"A"]
["Société A",330,"B"]
["Société D",331,"C"]
["Société A",332,"D"]
["Société A",333,"A"]
["Société A",334,"B"]
["Société A",335,"C"]
["Société D",336,"D"]
["Société A",337,"A"]
["Société A",338,"B"]
["Société A",339,"C"]
["Société A",340,"D"]
["Société A",341,"A"]
["Société A",342,"B"]
["Société A",343,"C"]
["Société A",344,"D"]
["Société A",345,"A"]
["Société A",346,"B"]
["Société A",347,"C"]
["Société A",348,"D"]
["Société C",349,"A"]
["Société A",350,"B"]
["Société A",351,"C"]
["Société A",352,"D"]
["Société D",353,"A"]
["Société A",354,"B"]
["Société A",355,"C"]
["Société A",356,"D"]
["Société D",357,"A"]
["Société A",358,"B"]
["Société B",359,"C"]
["Société A",360,"D"]
["Société A",361,"A"]
["Société A",362,"B"]
["Société A",363,"C"]
["Société C",364,"D"]
["Société C",365,"A"]
["Société A",366,"B"]
["Société A",367,"C"]
["Société A",368,"D"]
["Société A",369,"A"]
["Société B",370,"B"]
["Société A",371,"C"]
["Société D",372,"D"]
["Société A",373,"A"]
["Société A",374,"B"]
["Société A",375,"C"]
["Société A",376,"D"]
["Société A",377,"A"]
["Société A",378,"B"]
["Société A",379,"C"]
["Société A",380,"D"]
["Société A",381,"A"]
["Société B",382,"B"]
["Société A",383,"C"]
["Société A",384,"D"]
["Société A",385,"A"]
["Société A",386,"B"]
["Société A",387,"C"]
["Société A",388,"D"]
["Société A",389,"A"]
["Société A",390,"B"]
["Société A",391,"C"]
["Société A",392,"D"]
["Société B",393,"A"]
["Société A",394,"B"]
["Société A",395,"C"]
["Société A",396,"D"]
["Société A",397,"A"]
["Société A",398,"B"]
["Société A",399,"C"]
["Société A",400,"D"]
["Société A",401,"A"]
["Société A",402,"B"]
["Société A",403,"C"]
["Société A",404,"D"]
["Société A",405,"A"]
["Société A",406,"B"]
["Société A",407,"C"]
["Société A",408,"D"]
["Société A",409,"A"]
["Société A",410,"B"]
["Société A",411,"C"]
["Société A",412,"D"]
["Société A",413,"A"]
["Société A",414,"B"]
["Société A",415,"C"]
["Société A",416,"D"]
["Société A",417,"A"]
["Société A",418,"B"]
["Société A",419,"C"]
["Société A",420,"D"]
["Société A",421,"A"]
["Société A",422,"B"]
["Société A",423,"C"]
["Société A",424,"D"]
["Société A",425,"A"]
["Société A",426,"B"]
["Société A",427,"C"]
["Société A",428,"D"]
["Société A",429,"A"]
["Société A",430,"B"]
["Société A",431,"C"]
["Société A",432,"D"]
["Société A",433,"A"]
["Société A",434,"B"]
["Société A",435,"C"]
["Société A",436,"D"]
["Société A",437,"A"]
["Société C",438,"B"]
["Société A",439,"C"]
["Société A",440,"D"]
["Société A",441,"A"]
["Société B",442,"B"]
["Société A",443,"C"]
["Société A",444,"D"]
["Société A",445,"A"]
["Société A",446,"B"]
["Société A",447,"C"]
["Société A",448,"D"]
["Société A",449,"A"]
["Société C",450,"B"]
["Société A",451,"C"]
["Société A",452,"D"]
["Société A",453,"A"]
["Société A",454,"B"]
["Société A",455,"C"]
["Société A",456,"D"]
["Société A",457,"A"]
["Société A",458,"B"]
["Société A",459,"C"]
["Société A",460,"D"]
["Société A",461,"A"]
["Société A",462,"B"]
["Société A",463,"C"]
["Société A",464,"D"]
["Société A",465,"A"]
["Société A",466,"B"]
["Société A",467,"C"]
["Société A",468,"D"]
["Société A",469,"A"]
["Société A",470,"B"]
["Société A",471,"C"]
["Société A",472,"D"]
["Société A",473,"A"]
["Société A",474,"B"]
["Société A",475,"C"]
["Société A",476,"D"]
["Société A",477,"A"]
["Société A",478,"B"]
["Société A",479,"C"]
["Société A",480,"D"]
["Société A",481,"A"]
["Société A",482,"B"]
["Société A",483,"C"]
["Société A",484,"D"]
["Société A",485,"A"]
["Société D",486,"B"]
["Société A",487,"C"]
["Société A",488,"D"]
["Société A",489,"A"]
["Société A",490,"B"]
["Société A",491,"C"]
["Société A",492,"D"]
["Société A",493,"A"]
["Société A",494,"B"]
["Société A",495,"C"]
["Société A",496,"D"]
["Société B",497,"A"]
["Société A",498,"B"]
["Société A",499,"C"]
["Société A",500,"D"]
["Société D",501,"A"]
["Société A",502,"B"]
["Société A",503,"C"]
["Société A",504,"D"]
["Société A",505,"A"]
["Société A",506,"B"]
["Société A",507,"C"]
["Société A",508,"D"]
["Société A",509,"A"]
["Société A",510,"B"]
["Société A",511,"C"]
["Société A",512,"D"]
["Société A",513,"A"]
["Société A",514,"B"]
["Société A",515,"C"]
["Société D",516,"D"]
["Société A",517,"A"]
["Société A",518,"B"]
["Société A",519,"C"]
["Société A",520,"D"]
["Société A",521,"A"]
["Société A",522,"B"]
["Société A",523,"C"]
["Société A",524,"D"]
["Société A",525,"A"]
["Société C",526,"B"]
["Société B",527,"C"]
["Société A",528,"D"]
["Société A",529,"A"]
["Société C",530,"B"]
["Société D",531,"C"]
["Société A",532,"D"]
["Société A",533,"A"]
["Société A",534,"B"]
["Société A",535,"C"]
["Société A",536,"D"]
["Société A",537,"A"]
["Société A",538,"B"]
["Société A",539,"C"]
["Société A",540,"D"]
["Société A",541,"A"]
["Société A",542,"B"]
["Société B",543,"C"]
["Société B",544,"D"]
["Société A",545,"A"]
["Société A",546,"B"]
["Société A",547,"C"]
["Société C",548,"D"]
["Société A",549,"A"]
["Société A",550,"B"]
["Société A",551,"C"]
["Société A",552,"D"]
["Société A",553,"A"]
["Société A",554,"B"]
["Société A",555,"C"]
["Société A",556,"D"]
["Société A",557,"A"]
["Société A",558,"B"]
["Société A",559,"C"]
["Société A",560,"D"]
["Société A",561,"A"]
["Société A",562,"B"]
["Société A",563,"C"]
["Société A",564,"D"]
["Société A",565,"A"]
["Société A",566,"B"]
["Société A",567,"C"]
["Société D",568,"D"]
["Société A",569,"A"]
["Société A",570,"B"]
["Société A",571,"C"]
["Société A",572,"D"]
["Société A",573,"A"]
["Société A",574,"B"]
["Société A",575,"C"]
["Société A",576,"D"]
["Société A",577,"A"]
["Société A",578,"B"]
["Société B",579,"C"]
["Société A",580,"D"]
["Société C",581,"A"]
["Société A",582,"B"]
["Société A",583,"C"]
["Société A",584,"D"]
["Société A",585,"A"]
["Société A",586,"B"]
["Société A",587,"C"]
["Société A",588,"D"]
["Société A",589,"A"]
["Société B",590,"B"]
["Société A",591,"C"]
["Société A",592,"D"]
["Société A",593,"A"]
["Société A",594,"B"]
["Société C",595,"C"]
["Société A",596,"D"]
["Société A",597,"A"]
["Société A",598,"B"]
["Société A",599,"C"]
["Société A",600,"D"]
["Société A",601,"A"]
["Société A",602,"B"]
["Société A",603,"C"]
["Société A",604,"D"]
["Société A",605,"A"]
["Société A",606,"B"]
["Société A",607,"C"]
["Société A",608,"D"]
["Société A",609,"A"]
["Société A",610,"B"]
["Société A",611,"C"]
["Société C",612,"D"]
["Société A",613,"A"]
["Société A",614,"B"]
["Société A",615,"C"]
["Société B",616,"D"]
["Société B",617,"A"]
["Société A",618,"B"]
["Société A",619,"C"]
["Société A",620,"D"]
["Société A",621,"A"]
["Société A",622,"B"]
["Société A",623,"C"]
["Société A",624,"D"]
["Société A",625,"A"]
["Société A",626,"B"]
["Société A",627,"C"]
["Société A",628,"D"]
["Société A",629,"A"]
["Société A",630,"B"]
["Société A",631,"C"]
["Société A",632,"D"]
["Société A",633,"A"]

{"sheet":"Planning par salarié","index":1,"n_rows":18,"n_cols":33,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,0,17,0]]}
[]
[null,"NOM :"]
[null,"Prénom :"]
[null,"Société :"]
[]
[null,"Date",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[2019,"Janvier"]
[null,"Février"]
[null,"Mars"]
[null,"Avril"]
[null,"Mai"]
[null,"Juin"]
[null,"Juillet"]
[null,"Août"]
[null,"Septembre"]
[null,"Octobre"]
[null,"Novembre"]
[null,"Décembre"]

{"sheet":"Paramètres","index":2,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
[]
["Type d'absences :"]
["Maladie","M"]
["Congés payés","C"]
["RC/RTT","R"]
["Formation","F"]
["Autres","Z"]
[]
[]
["Janvier",2019]
["Février",2020]
["Mars",2021]
["Avril",2022]
["Mai",2023]
["Juin",2024]
["Juillet",2025]
["Août",2026]
["Septembre",2027]
["Octobre",2028]
["Novembre",2029]
["Décembre",2030]
[]
["Année",2019]
[]
["1er Janvier","2019-01-01",{"$f":"DATE($B$23,1,1)","v":"2019-01-01"}]
["Pâques","2019-04-21"]
["Lundi de Pâques","2019-04-22",{"$f":"B26+1","v":"2019-04-22"}]
["1er Mai","2019-01-05",{"$f":"DATE($B$23,5,1)","v":"2019-05-01"}]
["2019-05-08","2019-08-05",{"$f":"DATE($B$23,5,8)","v":"2019-05-08"}]
["Ascenscion","2019-05-30",{"$f":"B26+39","v":"2019-05-30"}]
["Pentecôte","2019-09-06",{"$f":"B26+49","v":"2019-06-09"}]
["Lundi de la Pentecôte","2019-10-06",{"$f":"B26+50","v":"2019-06-10"}]
["2019-07-14","2019-07-14",{"$f":"DATE($B$23,7,14)","v":"2019-07-14"}]
["2019-08-15","2019-08-15",{"$f":"DATE($B$23,8,15)","v":"2019-08-15"}]
["1er Novembre","2019-01-11",{"$f":"DATE($B$23,11,1)","v":"2019-11-01"}]
["2019-11-11","2019-11-11",{"$f":"DATE($B$23,11,11)","v":"2019-11-11"}]
["2019-12-25","2019-12-25",{"$f":"DATE($B$23,12,25)","v":"2019-12-25"}]