{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["entrees sorties","nb collab par responsable"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"entrees sorties","index":0,"n_rows":17,"n_cols":53,"rows_kept":17,"cut":false,"hidden":false,"merged":[[11,27,11,30],[11,31,11,35],[11,36,11,39],[11,40,11,44],[11,45,11,48],[11,49,11,52],[11,1,11,4],[11,5,11,9],[11,10,11,13],[11,14,11,17],[11,18,11,22],[11,23,11,26]]}
[]
[2018,3,"Collaborateurs","Date d'arrivée prévue","Date de départ prévue"]
[null,"Pierre","Collaborateur 1","2015-05-15","2018-05-22"]
[null,"Pierre","Collaborateur 2","2016-09-23","2018-12-31"]
[null,"Pierre","Collaborateur 3","2018-02-11","2018-03-08"]
[null,"Pierre","Collaborateur 4","2018-01-25","2019-02-12"]
[null,"Pierre","Collaborateur 5","2018-03-26","2018-08-01"]
[null,"Paul","Collaborateur 6","2018-01-10","2018-07-20"]
[null,"Paul","Collaborateur 7","2018-02-01","2019-11-28"]
[]
[]
[2018,"Janvier",null,null,null,"Février",null,null,null,null,"Mars",null,null,null,"Avril",null,null,null,"Mai",null,null,null,null,"Juin",null,null,null,"Juillet",null,null,null,"Aout",null,null,null,null,"Septembre",null,null,null,"Octobre",null,null,null,null,"Novembre",null,null,null,"Décembre"]
["N° de semaine",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,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52]
["début semaine",{"$f":"7*B$13+DATE($A$12,1,3)-WEEKDAY(DATE($A$12,1,3))-5","v":"2018-01-01"},{"$f":"7*C$13+DATE($A$12,1,3)-WEEKDAY(DATE($A$12,1,3))-5","v":"2018-01-08"},"2018-01-15","2018-01-22","2018-01-29","2018-02-05","2018-02-12","2018-02-19","2018-02-26","2018-03-05","2018-03-12","2018-03-19","2018-03-26","2018-04-02","2018-04-09"]
["fin semaine",{"$f":"7*B$13+DATE($A$12,1,3)-WEEKDAY(DATE($A$12,1,3))+1","v":"2018-01-07"},{"$f":"7*C$13+DATE($A$12,1,3)-WEEKDAY(DATE($A$12,1,3))+1","v":"2018-01-14"},"2018-01-21","2018-01-28","2018-02-04","2018-02-11","2018-02-18","2018-02-25","2018-03-04","2018-03-11","2018-03-18","2018-03-25","2018-04-01","2018-04-08","2018-04-15"]
["Pierre",{"$f":"COUNTIFS($B$3:$B$9,$A16,$D$3:$D$9,\"<=\" & B$14,$E$3:$E$9,\">=\" & B$15)","v":2},{"$f":"COUNTIFS($B$3:$B$9,$A16,$D$3:$D$9,\"<=\" & C$14,$E$3:$E$9,\">=\" & C$15)","v":2},2,2,3,3,4,4,4,3,3,3,4,4,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Paul",{"$f":"COUNTIFS($B$3:$B$9,$A17,$D$3:$D$9,\"<=\" & B$14,$E$3:$E$9,\">=\" & B$15)","v":0},0,1,1,1,2,2,2,2,2,2,2,2,2,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"nb collab par responsable","index":1,"n_rows":5,"n_cols":54,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,50,1,53],[1,6,1,10],[1,11,1,14],[1,2,1,5],[1,15,1,18],[1,19,1,23],[1,24,1,27],[1,28,1,31],[1,32,1,36],[1,37,1,40],[1,41,1,45],[1,46,1,49]]}
[]
[null,2018,"Janvier",null,null,null,"Février",null,null,null,null,"Mars",null,null,null,"Avril",null,null,null,"Mai",null,null,null,null,"Juin",null,null,null,"Juillet",null,null,null,"Aout",null,null,null,null,"Septembre",null,null,null,"Octobre",null,null,null,null,"Novembre",null,null,null,"Décembre"]
[null,"N° de semaine",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,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52]
[null,"Pierre",2,2,2,3,3,4]
[null,"Paul",0,1,1,1,2,2]