{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Mars 24","Feuil2"],"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":"Mars 24","index":0,"n_rows":63,"n_cols":26,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,15]]}
["Occupation des locaux Marche/Bertrix…......."]
[null,null,null,"Mars 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrice pour les bureaux privés"]
[null,null,null,"Lundi",null,null,"mardi",null,null,"mercredi",null,null,"jeudi ",null,null,"vendredi",null,null,null,null,null,"lundi","mardi","mercredi","jeudi","vendredi"]
[null,null,"Semaine 10","2024-03-04",null,null,"2024-03-05",null,null,"2024-03-06",null,null,"2024-03-07",null,null,"2024-03-08",null,null,null,"Bertrix","Cathy",1,0,1,0,1]
["France",null,null,"Marche",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A5,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0)<>D5,1,0),0)","v":1},"Marche",{"$f":"IFERROR(IF(INDEX($W$4:$W$8,MATCH($A5,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0)<>G5,1,0),0)","v":1}," ",{"$f":"IFERROR(IF(INDEX($X$4:$X$8,MATCH($A5,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0)<>J5,1,0),0)","v":1}," ",{"$f":"IFERROR(IF(INDEX($Y$4:$Y$8,MATCH($A5,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0)<>M5,1,0),0)","v":1}," ",{"$f":"IFERROR(IF(INDEX($Z$4:$Z$8,MATCH($A5,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A5,$U$4:$U$8,0),1),0)<>P5,1,0),0)","v":1},null,"Bertrix","France",1,1,1,1,1]
["Sandra",null,null,"Bertrix",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A6,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0)<>D6,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($W$4:$W$8,MATCH($A6,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0)<>G6,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($X$4:$X$8,MATCH($A6,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0)<>J6,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($Y$4:$Y$8,MATCH($A6,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0)<>M6,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($Z$4:$Z$8,MATCH($A6,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A6,$U$4:$U$8,0),1),0)<>P6,1,0),0)","v":0},null,"Bertrix","Nicolas",1,1,1,1,1]
["Sabine",null,null,"Marche",0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,"Marche","Alice",1,1,1,1,1]
["Alice",null,null,"Marche","Marche",0,"Marche","Marche",0,"Marche","Marche",0,"Marche","Marche",0,"Marche","Marche",0,null,"Marche","Manon",1,1,1,1,1]
["Manon",null,null,"Bertrix","Marche",1,"Marche","Marche",0,"Marche","Marche",0,"Marche","Marche",0,"Marche","Marche",0]
["Nicolas",null,null,"Bertrix","Bertrix",0,"Bertrix","Bertrix",0,"Bertrix","Bertrix",0,"Bertrix","Bertrix",0,"Bertrix","Bertrix",0]
["Alexandra",null,null,"Marche",0,0,null,0,0,null,0,0,"Libramont",0,0,null,0,0]
["Charlotte",null,null,"Marche",0,0," ",0,0,null,0,0,"Libramont",0,0,null,0,0]
["Cathy",null,null,"Bertrix","Bertrix",0,null,0,1,null,"Bertrix",1,"Libramont",0,1,null,"Bertrix",1]
["Jean-François",null,null,"Libramont",0,0,null,0,0,null,0,0,"Libramont",0,0,null,0,0]
["Sophie",null,null,"Libramont",0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[]
[]
["Bertrix",5,null,{"$f":"$B18-COUNTIF(D$5:D$16,$A18)-F18","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A18)","v":1},{"$f":"$B$18-COUNTIF(G$5:G$16,$A18)-I18","v":3},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A18)","v":1},{"$f":"$B$18-COUNTIF(J$5:J$16,$A18)-L18","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A18)","v":2},{"$f":"$B$18-COUNTIF(M$5:M$16,$A18)-O18","v":3},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A18)","v":1},{"$f":"SUMIFS(P5:P15,O5:O15,$A18)","v":0},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A18)","v":2}]
["Marche",6,"Reste",{"$f":"$B19-COUNTIF(D$5:D$16,$A19)-F19","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A19)","v":1},{"$f":"$B$19-COUNTIF(G$5:G$16,$A19)","v":3},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A19)","v":0},{"$f":"$B$19-COUNTIF(J$5:J$16,$A19)","v":4},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A19)","v":0},{"$f":"$B$19-COUNTIF(M$5:M$16,$A19)","v":4},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A19)","v":0},{"$f":"$B$19-COUNTIF(P$5:P$16,$A19)","v":4},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A19)","v":0}]
["Arlon",2,"Reste",2,null,0,{"$f":"$B$20-COUNTIF(G$5:G$16,$A20)","v":2},null,0,{"$f":"$B$20-COUNTIF(J$5:J$16,$A20)","v":2},null,0,{"$f":"$B$20-COUNTIF(M$5:M$16,$A20)","v":2},null,0,{"$f":"$B$20-COUNTIF(P$5:P$16,$A20)","v":2},null,0]
["Libramont",4,"Reste",2,null,0,{"$f":"$B$21-COUNTIF(G$5:G$16,$A21)","v":4},null,0,{"$f":"$B$21-COUNTIF(J$5:J$16,$A21)","v":4},null,0,{"$f":"$B$21-COUNTIF(M$5:M$16,$A21)","v":0},null,0,{"$f":"$B$21-COUNTIF(P$5:P$16,$A21)","v":4},null,0]
[]
[]
[null,null,"semaine 11","2024-03-11",null,null,"2024-03-12",null,null,"2024-03-13",null,null,"2024-03-14",null,null,"2024-03-15"]
["France",null,null,"Bertrix",null,null," ",null,null," ",null,null," ",null,null," "]
["Sabine",null,null,"Bertrix",null,null," ",null,null," ",null,null," ",null,null," "]
["Alice",null,null,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche"]
["Manon",null,null,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche"]
["Nicolas",null,null,"Bertrix",null,null,"Bertrix",null,null,"Bertrix",null,null,"Bertrix",null,null,"Bertrix"]
["Sandra",null,null,"Bertrix",null,null,"Bertrix",null,null," ",null,null,"Bertrix",null,null,"Bertrix"]
["Alexandra"]
[]
[]
["Bertrix",3,"Reste",{"$f":"$B$34-COUNTIF(D$25:D$32,$A34)","v":-1},null,null,{"$f":"$B$34-COUNTIF(G$26:G$32,$A34)","v":1},null,null,2,null,null,1,null,null,1]
["Marche",5,"Reste",1,null,null,1,null,null,1,null,null,1,null,null,1]
[]
[]
[null,null,"semaine 12","2024-03-18",null,null,"2024-03-19",null,null,"2024-03-20",null,null,"2024-03-21",null,null,"2024-03-22"]
["France",null,null,"Bertrix",null,null," ",null,null," ",null,null," ",null,null," "]
["Sabine",null,null,"Bertrix",null,null," ",null,null," ",null,null," ",null,null," "]
["Alice",null,null,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche"]
["Manon",null,null,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche"]
["Nicolas",null,null,"Bertrix",null,null,"Bertrix",null,null,"Bertrix",null,null,"Bertrix",null,null,"Bertrix"]
["Sandra",null,null,"Bertrix",null,null,"Bertrix",null,null," ",null,null,"Bertrix",null,null,"Bertrix"]
["Alexandra"]
[]
[]
["Bertrix",3,"Reste",{"$f":"$B$48-COUNTIF(D$39:D$46,$A48)","v":-1},null,null,{"$f":"$B$48-COUNTIF(G$39:G$46,$A48)","v":1},null,null,2,null,null,1,null,null,1]
["Marche",5,"Reste",{"$f":"$B$49-COUNTIF(D$39:D$46,$A49)","v":3},null,null,{"$f":"$B$49-COUNTIF(G$39:G$46,$A49)","v":3},null,null,3,null,null,3,null,null,3]
[]
[]
[null,null,"semaine 13","2024-03-25",null,null,"2024-03-26",null,null,"2024-03-27",null,null,"2024-03-28",null,null,"2024-03-29"]
["France",null,null,"Bertrix",null,null," ",null,null," ",null,null," ",null,null," "]
["Sabine",null,null,"Bertrix",null,null," ",null,null," ",null,null," ",null,null," "]
["Alice",null,null,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche"]
["Manon",null,null,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche"]
["Nicolas",null,null,"Bertrix",null,null,"Bertrix",null,null,"Bertrix",null,null,"Bertrix",null,null,"Bertrix"]
["Sandra",null,null,"Bertrix",null,null,"Bertrix",null,null," ",null,null,"Bertrix",null,null,"Bertrix"]
["Alexandra"]
[]
[]
["Bertrix",3,"Reste",{"$f":"$B$62-COUNTIF(D$53:D$60,$A62)","v":-1},null,null,{"$f":"$B$62-COUNTIF(G$53:G$60,$A62)","v":1},null,null,2,null,null,1,null,null,1]
["Marche",5,"Reste",{"$f":"$B$63-COUNTIF(D$53:D$60,$A63)","v":3},null,null,{"$f":"$B$63-COUNTIF(G$53:G$60,$A63)","v":3},null,null,3,null,null,3,null,null,3]

{"sheet":"Feuil2","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null," "]
[null,"Bertrix"]
[null,"Marche"]
[null,"Libramont"]
[null,"Arlon"]
[null,"Congé"]
[null,"en 4/5"]
[null,"TT"]
[null,"En déplacement"]