{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sept. 23","Mars 24","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Sept. 23","index":0,"n_rows":81,"n_cols":36,"rows_kept":81,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,2,1,3]]}
["Occupation des locaux Marche/Bertrix/Arlon/Libramont\n(décompte des places disponibles)"]
[null,null,"Notez que \nBertrix = 5 places mais seules 3 sont échangeables\nMarche = 6 places mais seules 4 sont échangeables",null,null,null,null,null,null,null,null,null,null,null,null,"Le bureau de Cathy est libre à Bertrix les lundi, mercredis et vendredi (matin seulement). Bât Social, près des RH. ",null,null,null,"Matrice pour les bureaux privés",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,null,null,null,"lundi","mardi","mercredi","jeudi","vendredi"]
[null,null,"Semaine 36","2023-09-04",null,null,"2023-09-05",null,null,"2023-09-06",null,null,"2023-09-07",null,null,"2023-09-08",null,null,null,"Bertrix","Cathy",1,0,1,0,1,null,null,null,"Bertrix","Cathy",1,0,1,0,1]
["France",null,null,"Bertrix",{"$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":0},"Bertrix",null,null,"TT",null,null,"TT",null,null,"Bertrix",null,null,null,"Bertrix","France",1,1,1,1,1,null,null,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}]
["Sabine",null,null,"Congé",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A7,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A7,$U$4:$U$8,0),1),0),0)","v":0},0,"Congé",null,null,"Congé",null,null,"Congé",null,null,"en 4/5"]
["Alice",null,null,"TT",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A8,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A8,$U$4:$U$8,0),1),0),0)","v":0},0,"Marche",null,null,"TT",null,null,"Bertrix",null,null,"Bertrix"]
["Manon",null,null,"Marche",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A9,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A9,$U$4:$U$8,0),1),0),0)","v":0},0,"Marche",null,null,"Marche",null,null,"Bertrix",null,null,"TT"]
["Nicolas",null,null,"Congé",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A10,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A10,$U$4:$U$8,0),1),0),0)","v":0},0,"Congé",null,null,"Congé",null,null,"Congé",null,null,"Congé"]
["Alexandra",null,null,"en 4/5",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A11,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A11,$U$4:$U$8,0),1),0),0)","v":0},0,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche"]
["Charlotte",null,null,null,{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A12,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A12,$U$4:$U$8,0),1),0),0)","v":0},0]
["Cathy",null,null,null,{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A13,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A13,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},1]
["Jean-François",null,null,null,{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A14,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A14,$U$4:$U$8,0),1),0),0)","v":0},0]
["Sophie",null,null,null,{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A15,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A15,$U$4:$U$8,0),1),0),0)","v":0},0]
[null,null,null,null,{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A16,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A16,$U$4:$U$8,0),1),0),0)","v":0},0]
[null,null,null,null,{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A17,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A17,$U$4:$U$8,0),1),0),0)","v":0},0]
["Bertrix",5,"Reste",{"$f":"$B$18-COUNTIF(D$5:D$16,$A18)-F18","v":3},0,0,{"$f":"$B$18-COUNTIF(G$5:G$16,$A18)","v":4},null,null,{"$f":"$B$18-COUNTIF(J$5:J$16,$A18)","v":5},null,null,{"$f":"$B$18-COUNTIF(M$5:M$16,$A18)","v":3},null,null,{"$f":"$B$18-COUNTIF(P$5:P$16,$A18)","v":3}]
["Marche",6,"Reste",{"$f":"$B$18-COUNTIF(D$5:D$16,$A19)-F19","v":4},0,0,{"$f":"$B$19-COUNTIF(G$5:G$16,$A19)","v":3},null,null,{"$f":"$B$19-COUNTIF(J$5:J$16,$A19)","v":4},null,null,{"$f":"$B$19-COUNTIF(M$5:M$16,$A19)","v":5},null,null,{"$f":"$B$19-COUNTIF(P$5:P$16,$A19)","v":5}]
["Arlon",2,"Reste",5,0,0]
["Libramont",4,"Reste",5,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,"semaine 37","2023-09-11",0,0,"2023-09-12",null,null,"2023-09-13",null,null,"2023-09-14",null,null,"2023-09-15"]
["France",null,null,"Bertrix","Bertrix",0,"Bertrix",null,null,"Marche",null,null,"En déplacement",null,null,"TT"]
["Sandra",null,null,null,0,0]
["Sabine",null,null,"Congé",0,0,"Congé",null,null,"Congé",null,null,"Congé",null,null,"en 4/5"]
["Alice",null,null,"TT",0,0,"Marche",null,null,"Marche",null,null,"TT",null,null,"Libramont"]
["Manon",null,null,"Marche",0,0,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche"]
["Nicolas",null,null,"Congé",0,0,"Congé",null,null,"Congé",null,null,"Congé",null,null,"Congé"]
["Alexandra",null,null,"en 4/5",0,0,null,null,null,null,null,null,"Marche"]
["Charlotte ",null,null,null,0,0,"Libramont"]
["Cathy",null,null,null,"Bertrix",1]
["Jean-François",null,null,null,0,0]
["Sophie",null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["Bertrix",5,"Reste",{"$f":"$B$38-COUNTIF(D$25:D$32,$A38)","v":4},0,0,{"$f":"$B$38-COUNTIF(G$25:G$32,$A38)","v":4},null,null,{"$f":"$B$38-COUNTIF(J$25:J$32,$A38)","v":5},null,null,{"$f":"$B$38-COUNTIF(M$25:M$32,$A38)","v":5},null,null,{"$f":"$B$38-COUNTIF(P$25:P$32,$A38)","v":5}]
["Marche",6,"Reste",{"$f":"$B$39-COUNTIF(D$25:D$32,$A39)","v":5},0,0,{"$f":"$B$39-COUNTIF(G$25:G$32,$A39)","v":4},null,null,{"$f":"$B$39-COUNTIF(J$25:J$32,$A39)","v":3},null,null,{"$f":"$B$39-COUNTIF(M$25:M$32,$A39)","v":4},null,null,{"$f":"$B$39-COUNTIF(P$25:P$32,$A39)","v":5}]
["Arlon",2,"Reste",null,0,0]
["Libramont",4,"Reste",null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,"semaine 38","2023-09-18",0,0,"2023-09-19",null,null,"2023-09-20",null,null,"2023-09-21",null,null,"2023-09-22"]
["France",null,null,"Marche","Bertrix",1,"Bertrix",null,null,"En déplacement",null,null,"TT",null,null,"TT"]
["Sandra",null,null,null,0,0]
["Sabine",null,null,"Marche",0,0,"Bertrix",null,null,"Marche",null,null,"Bertrix",null,null,"en 4/5"]
["Alice",null,null,"Marche",0,0,"Bertrix",null,null,"En déplacement",null,null,"TT",null,null,"TT"]
["Manon",null,null,"Marche",0,0,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche"]
["Nicolas",null,null,"Congé",0,0,"Bertrix",null,null,"Bertrix",null,null,"Bertrix",null,null,"Bertrix"]
["Alexandra",null,null,null,0,0,null,null,null,null,null,null,"Marche"]
["Charlotte",null,null,null,0,0]
["Cathy",null,null,null,"Bertrix",1]
["Jean-François",null,null,null,0,0]
["Sophie",null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["Bertrix",5,"Reste",{"$f":"$B$58-COUNTIF(D$45:D$56,$A58)","v":5},0,0,{"$f":"$B$58-COUNTIF(G$45:G$56,$A58)","v":1},null,null,{"$f":"$B$58-COUNTIF(J$45:J$56,$A58)","v":4},null,null,{"$f":"$B$58-COUNTIF(M$45:M$56,$A58)","v":3},null,null,{"$f":"$B$58-COUNTIF(P$45:P$56,$A58)","v":4}]
["Marche",6,"Reste",{"$f":"$B$59-COUNTIF(D$45:D$56,$A59)","v":2},0,0,{"$f":"$B$59-COUNTIF(G$45:G$56,$A59)","v":5},null,null,{"$f":"$B$59-COUNTIF(J$45:J$56,$A59)","v":4},null,null,{"$f":"$B$59-COUNTIF(M$45:M$56,$A59)","v":4},null,null,{"$f":"$B$59-COUNTIF(P$45:P$56,$A59)","v":5}]
["Arlon",2,"Reste",null,0,0]
["Libramont",4,"Reste",null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,"semaine 39","2023-09-25",0,0,"2023-09-26",null,null,"2023-09-27",null,null,"2023-09-28",null,null,"2023-09-29"]
["France",null,null,"Bertrix","Bertrix",0,"En déplacement",null,null,"En déplacement",null,null,"Marche",null,null,"TT"]
["Sandra",null,null,null,0,0]
["Sabine",null,null,"Bertrix",0,0,null,null,null,null,null,null,null,null,null,"en 4/5"]
["Alice",null,null,"TT",0,0,"TT",null,null,"Marche",null,null,"Marche",null,null,"Bertrix"]
["Manon",null,null,"Marche",0,0,"Marche",null,null,"Marche",null,null,"Marche",null,null,"Marche"]
["Nicolas",null,null,"Bertrix",0,{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A70,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A70,$U$4:$U$8,0),1),0)<>D70,1,0),0)","v":0},"Bertrix",null,null,"Bertrix",null,null,"Bertrix",null,null,"Bertrix"]
["Alexandra",null,null," ",0,0,null,null,null,null,null,null,"Marche"]
["Charlotte",null,null,null,0,0]
["Cathy",null,null,null,"Bertrix",1]
["Jean-François",null,null,null,0,0]
["Sophie",null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["Bertrix",5,"Reste",{"$f":"$B$78-COUNTIF(D$65:D$76,$A78)","v":2},0,0,{"$f":"$B$78-COUNTIF(G$65:G$76,$A78)","v":4},null,null,{"$f":"$B$78-COUNTIF(J$65:J$76,$A78)","v":4},null,null,{"$f":"$B$78-COUNTIF(M$65:M$76,$A78)","v":4},null,null,{"$f":"$B$78-COUNTIF(P$65:P$76,$A78)","v":3}]
["Marche",6,"Reste",{"$f":"$B$79-COUNTIF(D$65:D$76,$A79)","v":5},0,0,{"$f":"$B$79-COUNTIF(G$65:G$76,$A79)","v":5},null,null,{"$f":"$B$79-COUNTIF(J$65:J$76,$A79)","v":4},null,null,{"$f":"$B$79-COUNTIF(M$65:M$76,$A79)","v":2},null,null,{"$f":"$B$79-COUNTIF(P$65:P$76,$A79)","v":5}]
["Arlon",2,"Reste",null,0,0]
["Libramont",4,"Reste",null,{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A81,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A81,$U$4:$U$8,0),1),0),0)","v":0},0]

{"sheet":"Mars 24","index":1,"n_rows":80,"n_cols":26,"rows_kept":80,"cut":false,"hidden":false,"merged":[[0,0,0,15]]}
["Occupation des locaux Marche/Bertrix/Arlon/Libramont\n(décompte des places disponibles)"]
[null,null,"Notez que \nBertrix = 5 places mais seules 3 sont échangeables\nMarche = 6 places mais seules 4 sont échangeables","Mars 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le bureau de Cathy est libre à Bertrix les lundi, mercredis et vendredi (matin seulement). Bât Social, près des RH. ","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},"Bertrix",{"$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":0}," ",{"$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},"Bertrix",{"$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}]
["Sabine",null,null,"Marche",0,0,"Bertrix",0,0,null,0,0,null,0,0,null,0,0]
["Alice",null,null,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0]
["Manon",null,null,"Bertrix",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0]
["Nicolas",null,null,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0]
["Alexandra",null,null,"Arlon",0,0,"Arlon",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,"Libramont","Bertrix",1,"Bertrix",0,0,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,"Reste",{"$f":"$B18-COUNTIF(D$5:D$16,$A18)-F18","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A18)","v":2},{"$f":"$B$18-COUNTIF(G$5:G$16,$A18)-I18","v":0},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A18)","v":0},{"$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":2},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A19)","v":0},{"$f":"$B$19-COUNTIF(G$5:G$16,$A19)","v":4},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",1,null,0,{"$f":"$B$20-COUNTIF(G$5:G$16,$A20)","v":1},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",1,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,null,"Lundi",null,null,"mardi",null,null,"mercredi",null,null,"jeudi ",null,null,"vendredi"]
[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,"Marche",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A25,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0)<>D25,1,0),0)","v":1},"Bertrix",{"$f":"IFERROR(IF(INDEX($W$4:$W$8,MATCH($A25,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0)<>G25,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($X$4:$X$8,MATCH($A25,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0)<>J25,1,0),0)","v":1}," ",{"$f":"IFERROR(IF(INDEX($Y$4:$Y$8,MATCH($A25,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0)<>M25,1,0),0)","v":1}," ",{"$f":"IFERROR(IF(INDEX($Z$4:$Z$8,MATCH($A25,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A25,$U$4:$U$8,0),1),0)<>P25,1,0),0)","v":1}]
["Sandra",null,null,"Bertrix",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A26,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0)<>D26,1,0),0)","v":0},"Bertrix",{"$f":"IFERROR(IF(INDEX($W$4:$W$8,MATCH($A26,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0)<>G26,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($X$4:$X$8,MATCH($A26,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0)<>J26,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($Y$4:$Y$8,MATCH($A26,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0)<>M26,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($Z$4:$Z$8,MATCH($A26,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A26,$U$4:$U$8,0),1),0)<>P26,1,0),0)","v":0}]
["Sabine",null,null,"Marche",0,0,"Bertrix",0,0,null,0,0,null,0,0,null,0,0]
["Alice",null,null,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0]
["Manon",null,null,"Bertrix",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0]
["Nicolas",null,null,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0]
["Alexandra",null,null,"Arlon",0,0,"Arlon",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,"Libramont","Bertrix",1,"Bertrix",0,0,null,"Bertrix",1,"Libramont",0,1,null,"Bertrix",1]
["Jean-François",null,null,"Bertrix",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,"Reste",{"$f":"$B38-COUNTIF(D$5:D$16,$A38)-F38","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A38)","v":2},{"$f":"$B$18-COUNTIF(G$5:G$16,$A38)-I38","v":0},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A38)","v":0},{"$f":"$B$18-COUNTIF(J$5:J$16,$A38)-L38","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A38)","v":2},{"$f":"$B$18-COUNTIF(M$5:M$16,$A38)-O38","v":3},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A38)","v":1},{"$f":"SUMIFS(P25:P35,O25:O35,$A38)","v":0},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A38)","v":2}]
["Marche",6,"Reste",{"$f":"$B39-COUNTIF(D$5:D$16,$A39)-F39","v":2},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A39)","v":0},{"$f":"$B$19-COUNTIF(G$5:G$16,$A39)","v":4},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A39)","v":0},{"$f":"$B$19-COUNTIF(J$5:J$16,$A39)","v":4},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A39)","v":0},{"$f":"$B$19-COUNTIF(M$5:M$16,$A39)","v":4},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A39)","v":0},{"$f":"$B$19-COUNTIF(P$5:P$16,$A39)","v":4},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A39)","v":0}]
["Arlon",2,"Reste",1,null,0,{"$f":"$B$20-COUNTIF(G$5:G$16,$A40)","v":1},null,0,{"$f":"$B$20-COUNTIF(J$5:J$16,$A40)","v":2},null,0,{"$f":"$B$20-COUNTIF(M$5:M$16,$A40)","v":2},null,0,{"$f":"$B$20-COUNTIF(P$5:P$16,$A40)","v":2},null,0]
["Libramont",4,"Reste",1,null,0,{"$f":"$B$21-COUNTIF(G$5:G$16,$A41)","v":4},null,0,{"$f":"$B$21-COUNTIF(J$5:J$16,$A41)","v":4},null,0,{"$f":"$B$21-COUNTIF(M$5:M$16,$A41)","v":0},null,0,{"$f":"$B$21-COUNTIF(P$5:P$16,$A41)","v":4},null,0]
[]
[null,null,null,"Lundi",null,null,"mardi",null,null,"mercredi",null,null,"jeudi ",null,null,"vendredi"]
[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,"Libramont",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A45,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0)<>D45,1,0),0)","v":1},"Bertrix",{"$f":"IFERROR(IF(INDEX($W$4:$W$8,MATCH($A45,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0)<>G45,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($X$4:$X$8,MATCH($A45,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0)<>J45,1,0),0)","v":1}," ",{"$f":"IFERROR(IF(INDEX($Y$4:$Y$8,MATCH($A45,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0)<>M45,1,0),0)","v":1}," ",{"$f":"IFERROR(IF(INDEX($Z$4:$Z$8,MATCH($A45,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A45,$U$4:$U$8,0),1),0)<>P45,1,0),0)","v":1}]
["Sandra",null,null,"Bertrix",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A46,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0)<>D46,1,0),0)","v":0},"Bertrix",{"$f":"IFERROR(IF(INDEX($W$4:$W$8,MATCH($A46,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0)<>G46,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($X$4:$X$8,MATCH($A46,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0)<>J46,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($Y$4:$Y$8,MATCH($A46,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0)<>M46,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($Z$4:$Z$8,MATCH($A46,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A46,$U$4:$U$8,0),1),0)<>P46,1,0),0)","v":0}]
["Sabine",null,null,"Marche",0,0,"Bertrix",0,0,null,0,0,null,0,0,null,0,0]
["Alice",null,null,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0]
["Manon",null,null,"Bertrix",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0]
["Nicolas",null,null,"Marche",0,0,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0]
["Alexandra",null,null,"Libramont",0,0,"Arlon",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,"Bertrix",0,0,null,"Bertrix",1,"Libramont",{"$f":"IFERROR(IF(INDEX($Y$4:$Y$8,MATCH($A53,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A53,$U$4:$U$8,0),1),0),0)","v":0},1,null,"Bertrix",1]
["Jean-François",null,null,"Bertrix",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,"Reste",{"$f":"$B58-COUNTIF(D$5:D$16,$A58)-F58","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A58)","v":2},{"$f":"$B$18-COUNTIF(G$5:G$16,$A58)-I58","v":0},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A58)","v":0},{"$f":"$B$18-COUNTIF(J$5:J$16,$A58)-L58","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A58)","v":2},{"$f":"$B$18-COUNTIF(M$5:M$16,$A58)-O58","v":3},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A58)","v":1},{"$f":"SUMIFS(P45:P55,O45:O55,$A58)","v":0},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A58)","v":2}]
["Marche",6,"Reste",{"$f":"$B59-COUNTIF(D$5:D$16,$A59)-F59","v":2},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A59)","v":0},{"$f":"$B$19-COUNTIF(G$5:G$16,$A59)","v":4},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A59)","v":0},{"$f":"$B$19-COUNTIF(J$5:J$16,$A59)","v":4},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A59)","v":0},{"$f":"$B$19-COUNTIF(M$5:M$16,$A59)","v":4},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A59)","v":0},{"$f":"$B$19-COUNTIF(P$5:P$16,$A59)","v":4},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A59)","v":0}]
["Arlon",2,"Reste",1,null,0,{"$f":"$B$20-COUNTIF(G$5:G$16,$A60)","v":1},null,0,{"$f":"$B$20-COUNTIF(J$5:J$16,$A60)","v":2},null,0,{"$f":"$B$20-COUNTIF(M$5:M$16,$A60)","v":2},null,0,{"$f":"$B$20-COUNTIF(P$5:P$16,$A60)","v":2},null,0]
["Libramont",4,"Reste",1,null,0,{"$f":"$B$21-COUNTIF(G$5:G$16,$A61)","v":4},null,0,{"$f":"$B$21-COUNTIF(J$5:J$16,$A61)","v":4},null,0,{"$f":"$B$21-COUNTIF(M$5:M$16,$A61)","v":0},null,0,{"$f":"$B$21-COUNTIF(P$5:P$16,$A61)","v":4},null,0]
[]
[null,null,null,"Lundi",null,null,"mardi",null,null,"mercredi",null,null,"jeudi ",null,null,"vendredi"]
[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,"Marche",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A65,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0)<>D65,1,0),0)","v":1},"Bertrix",{"$f":"IFERROR(IF(INDEX($W$4:$W$8,MATCH($A65,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0)<>G65,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($X$4:$X$8,MATCH($A65,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0)<>J65,1,0),0)","v":1}," ",{"$f":"IFERROR(IF(INDEX($Y$4:$Y$8,MATCH($A65,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0)<>M65,1,0),0)","v":1}," ",{"$f":"IFERROR(IF(INDEX($Z$4:$Z$8,MATCH($A65,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0),0)","v":"Bertrix"},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A65,$U$4:$U$8,0),1),0)<>P65,1,0),0)","v":1}]
["Sandra",null,null,"Bertrix",{"$f":"IFERROR(IF(INDEX($V$4:$V$8,MATCH($A66,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0)<>D66,1,0),0)","v":0},"Bertrix",{"$f":"IFERROR(IF(INDEX($W$4:$W$8,MATCH($A66,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0)<>G66,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($X$4:$X$8,MATCH($A66,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0)<>J66,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($Y$4:$Y$8,MATCH($A66,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0)<>M66,1,0),0)","v":0}," ",{"$f":"IFERROR(IF(INDEX($Z$4:$Z$8,MATCH($A66,$U$4:$U$8,0),1)=1,INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0),0)","v":0},{"$f":"IF(IFERROR(INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0)<>0,IF(IFERROR(INDEX($T$4:$T$8,MATCH($A66,$U$4:$U$8,0),1),0)<>P66,1,0),0)","v":0}]
["Sabine",null,null,"Marche",0,0,"Bertrix",0,0,null,0,0,null,0,0,null,0,0]
["Alice",null,null,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0]
["Manon",null,null,"Bertrix",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0]
["Nicolas",null,null,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0]
["Alexandra",null,null,"Libramont",0,0,"Arlon",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,"Libramont","Bertrix",1,"Bertrix",0,0,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,"Reste",{"$f":"$B77-COUNTIF(D$5:D$16,$A77)-F77","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A77)","v":2},{"$f":"$B$18-COUNTIF(G$5:G$16,$A77)-I77","v":0},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A77)","v":0},{"$f":"$B$18-COUNTIF(J$5:J$16,$A77)-L77","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A77)","v":2},{"$f":"$B$18-COUNTIF(M$5:M$16,$A77)-O77","v":3},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A77)","v":1},{"$f":"SUMIFS(P64:P74,O64:O74,$A77)","v":0},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A77)","v":2}]
["Marche",6,"Reste",{"$f":"$B78-COUNTIF(D$5:D$16,$A78)-F78","v":2},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A78)","v":0},{"$f":"$B$19-COUNTIF(G$5:G$16,$A78)","v":4},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A78)","v":0},{"$f":"$B$19-COUNTIF(J$5:J$16,$A78)","v":4},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A78)","v":0},{"$f":"$B$19-COUNTIF(M$5:M$16,$A78)","v":4},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A78)","v":0},{"$f":"$B$19-COUNTIF(P$5:P$16,$A78)","v":4},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A78)","v":0}]
["Arlon",2,"Reste",1,null,0,{"$f":"$B$20-COUNTIF(G$5:G$16,$A79)","v":1},null,0,{"$f":"$B$20-COUNTIF(J$5:J$16,$A79)","v":2},null,0,{"$f":"$B$20-COUNTIF(M$5:M$16,$A79)","v":2},null,0,{"$f":"$B$20-COUNTIF(P$5:P$16,$A79)","v":2},null,0]
["Libramont",4,"Reste",1,null,0,{"$f":"$B$21-COUNTIF(G$5:G$16,$A80)","v":4},null,0,{"$f":"$B$21-COUNTIF(J$5:J$16,$A80)","v":4},null,0,{"$f":"$B$21-COUNTIF(M$5:M$16,$A80)","v":0},null,0,{"$f":"$B$21-COUNTIF(P$5:P$16,$A80)","v":4},null,0]

{"sheet":"Feuil2","index":2,"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"]