{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sept. 23","Mars 24","Source","Feuil2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":26,"rows_kept":81,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,3,1,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","Septembre 2023",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 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]
["France",null,null,"Arlon",{"$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,"Congé",0,0,"Bertrix",0,0,null,0,0,null,0,0,null,0,0]
["Alice",null,null,"TT",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0]
["Manon",null,null,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0]
["Nicolas",null,null,"Congé",0,0,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0,"Bertrix",0,0]
["Alexandra",null,null,"en 4/5",0,0,"Arlon",0,0,null,0,0,"Libramont",0,0,null,0,0]
["Charlotte",null,null,"Congé",0,0," ",0,0,null,0,0,"Libramont",0,0,null,0,0]
["Cathy",null,null," ","Bertrix",1,"Bertrix",0,0,"En déplacement","Bertrix",1,"Libramont",0,1,null,"Bertrix",1]
["Jean-François",null,null," ",0,0,null,0,0,null,0,0,"Libramont",0,0,null,0,0]
["Sophie",null,null," ",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":2},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",4,"Reste",{"$f":"$B19-COUNTIF(D$5:D$16,$A19)-F19","v":3},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A19)","v":0},{"$f":"$B$19-COUNTIF(G$5:G$16,$A19)","v":2},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A19)","v":0},{"$f":"$B$19-COUNTIF(J$5:J$16,$A19)","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A19)","v":0},{"$f":"$B$19-COUNTIF(M$5:M$16,$A19)","v":2},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A19)","v":0},{"$f":"$B$19-COUNTIF(P$5:P$16,$A19)","v":2},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",4,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 37",{"$f":"P4+3","v":"2023-09-11"},null,null,{"$f":"D24+1","v":"2023-09-12"},null,null,{"$f":"G24+1","v":"2023-09-13"},null,null,{"$f":"J24+1","v":"2023-09-14"},null,null,{"$f":"M24+1","v":"2023-09-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,"en 4/5",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0]
["Manon",null,null,"Bertrix",0,0,"Congé",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,"Marche","Bertrix",1,"Bertrix",0,0,null,"Bertrix",1,"Libramont",0,1,null,"Bertrix",1]
["Jean-François",null,null,"Marche",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$25:D$36,$A38)-F38","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A38)","v":2},{"$f":"$B38-COUNTIF(G$25:G$36,$A38)-I38","v":0},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A38)","v":0},{"$f":"$B38-COUNTIF(J$25:J$36,$A38)-L38","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A38)","v":2},{"$f":"$B38-COUNTIF(M$25:M$36,$A38)-O38","v":3},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A38)","v":1},{"$f":"$B38-COUNTIF(P$25:P$36,$A38)-R38","v":2},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A38)","v":2}]
["Marche",4,"Reste",{"$f":"$B39-COUNTIF(D$25:D$36,$A39)-F39","v":-2},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A39)","v":0},{"$f":"$B39-COUNTIF(G$25:G$36,$A39)-I39","v":4},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A39)","v":0},{"$f":"$B39-COUNTIF(J$25:J$36,$A39)-L39","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A39)","v":0},{"$f":"$B39-COUNTIF(M$25:M$36,$A39)-O39","v":2},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A39)","v":0},{"$f":"$B39-COUNTIF(P$25:P$36,$A39)-R39","v":2},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A39)","v":0}]
["Arlon",2,"Reste",1,null,0,{"$f":"$B40-COUNTIF(G$25:G$36,$A40)-I40","v":1},null,0,2,null,0,2,null,0,2,null,0]
["Libramont",4,"Reste",3,null,0,4,null,0,4,null,0,0,null,0,4,null,0]
[]
[null,null,null,"Lundi",null,null,"mardi",null,null,"mercredi",null,null,"jeudi ",null,null,"vendredi"]
[null,null,"Semaine 38",{"$f":"P24+3","v":"2023-09-18"},null,null,{"$f":"D44+1","v":"2023-09-19"},null,null,{"$f":"G44+1","v":"2023-09-20"},null,null,{"$f":"J44+1","v":"2023-09-21"},null,null,{"$f":"M44+1","v":"2023-09-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,"Marche",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$45:D$56,$A58)-F58","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A58)","v":2},{"$f":"$B58-COUNTIF(G$45:G$56,$A58)-I58","v":0},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A58)","v":0},{"$f":"$B58-COUNTIF(J$45:J$56,$A58)-L58","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A58)","v":2},{"$f":"$B58-COUNTIF(M$45:M$56,$A58)-O58","v":3},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A58)","v":1},{"$f":"$B58-COUNTIF(P$45:P$56,$A58)-R58","v":2},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A58)","v":2}]
["Marche",4,"Reste",{"$f":"$B59-COUNTIF(D$45:D$56,$A59)-F59","v":-1},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A59)","v":0},{"$f":"$B59-COUNTIF(G$45:G$56,$A59)-I59","v":2},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A59)","v":0},{"$f":"$B59-COUNTIF(J$45:J$56,$A59)-L59","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A59)","v":0},{"$f":"$B59-COUNTIF(M$45:M$56,$A59)-O59","v":2},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A59)","v":0},{"$f":"$B59-COUNTIF(P$45:P$56,$A59)-R59","v":2},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A59)","v":0}]
["Arlon",2,"Reste",2,null,0,1,null,0,2,null,0,2,null,0,2,null,0]
["Libramont",4,"Reste",1,null,0,4,null,0,4,null,0,0,null,0,4,null,0]
[]
[null,null,null,"Lundi",null,null,"mardi",null,null,"mercredi",null,null,"jeudi ",null,null,"vendredi"]
[null,null,"Semaine 39",{"$f":"P44+3","v":"2023-09-25"},null,null,{"$f":"D64+1","v":"2023-09-26"},null,null,{"$f":"G64+1","v":"2023-09-27"},null,null,{"$f":"J64+1","v":"2023-09-28"},null,null,{"$f":"M64+1","v":"2023-09-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,"Bertrix","Bertrix",0,"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":"$B78-COUNTIF(D$65:D$77,$A78)-F78","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A78)","v":2},{"$f":"$B78-COUNTIF(G$65:G$77,$A78)-I78","v":0},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A78)","v":0},{"$f":"$B78-COUNTIF(J$65:J$77,$A78)-L78","v":1},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A78)","v":2},{"$f":"$B78-COUNTIF(M$65:M$77,$A78)-O78","v":3},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A78)","v":1},{"$f":"$B78-COUNTIF(P$65:P$77,$A78)-R78","v":2},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A78)","v":2}]
["Marche",4,"Reste",{"$f":"$B79-COUNTIF(D$65:D$77,$A79)-F79","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A79)","v":0},{"$f":"$B79-COUNTIF(G$65:G$77,$A79)-I79","v":2},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A79)","v":0},{"$f":"$B79-COUNTIF(J$65:J$77,$A79)-L79","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A79)","v":0},{"$f":"$B79-COUNTIF(M$65:M$77,$A79)-O79","v":2},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A79)","v":0},{"$f":"$B79-COUNTIF(P$65:P$77,$A79)-R79","v":2},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A79)","v":0}]
["Arlon",2,"Reste",2,null,0,1,null,0,2,null,0,2,null,0,2,null,0]
["Libramont",4,"Reste",0,null,0,4,null,0,4,null,0,0,null,0,4,null,0]

{"sheet":"Mars 24","index":1,"n_rows":81,"n_cols":26,"rows_kept":81,"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",{"$f":"PROPER(TEXT(D4,\"mmmm aaaa\"))","v":"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,{"$f":"WORKDAY(EOMONTH(P4,-1),1)","v":"2024-03-01"}]
["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",4,"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":0},{"$f":"$B$19-COUNTIF(G$5:G$16,$A19)","v":2},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A19)","v":0},{"$f":"$B$19-COUNTIF(J$5:J$16,$A19)","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A19)","v":0},{"$f":"$B$19-COUNTIF(M$5:M$16,$A19)","v":2},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A19)","v":0},{"$f":"$B$19-COUNTIF(P$5:P$16,$A19)","v":2},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",{"$f":"P4+3","v":"2024-03-11"},null,null,{"$f":"D24+1","v":"2024-03-12"},null,null,{"$f":"G24+1","v":"2024-03-13"},null,null,{"$f":"J24+1","v":"2024-03-14"},null,null,{"$f":"M24+1","v":"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,"en 4/5",0,0,"Marche",0,0,"Marche",0,0,"Marche",0,0]
["Manon",null,null,"Bertrix",0,0,"Congé",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,"Marche","Bertrix",1,"Bertrix",0,0,null,"Bertrix",1,"Libramont",0,1,null,"Bertrix",1]
["Jean-François",null,null,"Marche",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$25:D$36,$A38)-F38","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A38)","v":2},{"$f":"$B38-COUNTIF(G$25:G$36,$A38)-I38","v":0},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A38)","v":0},{"$f":"$B38-COUNTIF(J$25:J$36,$A38)-L38","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A38)","v":2},{"$f":"$B38-COUNTIF(M$25:M$36,$A38)-O38","v":3},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A38)","v":1},{"$f":"$B38-COUNTIF(P$25:P$36,$A38)-R38","v":2},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A38)","v":2}]
["Marche",6,"Reste",{"$f":"$B39-COUNTIF(D$25:D$36,$A39)-F39","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A39)","v":0},{"$f":"$B39-COUNTIF(G$25:G$36,$A39)-I39","v":6},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A39)","v":0},{"$f":"$B39-COUNTIF(J$25:J$36,$A39)-L39","v":4},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A39)","v":0},{"$f":"$B39-COUNTIF(M$25:M$36,$A39)-O39","v":4},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A39)","v":0},{"$f":"$B39-COUNTIF(P$25:P$36,$A39)-R39","v":4},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A39)","v":0}]
["Arlon",2,"Reste",1,null,0,{"$f":"$B40-COUNTIF(G$25:G$36,$A40)-I40","v":1},null,0,2,null,0,2,null,0,2,null,0]
["Libramont",4,"Reste",3,null,0,4,null,0,4,null,0,0,null,0,4,null,0]
[]
[null,null,null,"Lundi",null,null,"mardi",null,null,"mercredi",null,null,"jeudi ",null,null,"vendredi"]
[null,null,"Semaine 12",{"$f":"P24+3","v":"2024-03-18"},null,null,{"$f":"D44+1","v":"2024-03-19"},null,null,{"$f":"G44+1","v":"2024-03-20"},null,null,{"$f":"J44+1","v":"2024-03-21"},null,null,{"$f":"M44+1","v":"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,"Marche",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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonjour,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Une précision de votre part :"]
["Bertrix",5,"Reste",{"$f":"$B58-COUNTIF(D$45:D$56,$A58)-F58","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A58)","v":2},{"$f":"$B58-COUNTIF(G$45:G$56,$A58)-I58","v":0},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A58)","v":0},{"$f":"$B58-COUNTIF(J$45:J$56,$A58)-L58","v":2},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A58)","v":2},{"$f":"$B58-COUNTIF(M$45:M$56,$A58)-O58","v":3},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A58)","v":1},{"$f":"$B58-COUNTIF(P$45:P$56,$A58)-R58","v":2},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A58)","v":2},"Pour les bureaux privés, seules France et Cathy ont un bureau privé à Bertrix. Tous les autres sont interchangeables."]
["Marche",6,"Reste",{"$f":"$B59-COUNTIF(D$45:D$56,$A59)-F59","v":1},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A59)","v":0},{"$f":"$B59-COUNTIF(G$45:G$56,$A59)-I59","v":4},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A59)","v":0},{"$f":"$B59-COUNTIF(J$45:J$56,$A59)-L59","v":4},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A59)","v":0},{"$f":"$B59-COUNTIF(M$45:M$56,$A59)-O59","v":4},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A59)","v":0},{"$f":"$B59-COUNTIF(P$45:P$56,$A59)-R59","v":4},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A59)","v":0},"Mais l’information sur votre fichier indique le contraire..."]
["Arlon",2,"Reste",2,null,0,1,null,0,2,null,0,2,null,0,2,null,0]
["Libramont",4,"Reste",1,null,0,4,null,0,4,null,0,0,null,0,4,null,0,"Note : le message poste 14 (très intéressant.) a disparu ……  que pensez ¨"]
[]
[null,null,null,"Lundi",null,null,"mardi",null,null,"mercredi",null,null,"jeudi ",null,null,"vendredi",null,null,"Merci du retour pour la suite"]
[null,null,"Semaine 13",{"$f":"P44+3","v":"2024-03-25"},null,null,{"$f":"D64+1","v":"2024-03-26"},null,null,{"$f":"G64+1","v":"2024-03-27"},null,null,{"$f":"J64+1","v":"2024-03-28"},null,null,{"$f":"M64+1","v":"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,"Bertrix","Bertrix",0,"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":"$B78-COUNTIF(D$65:D$77,$A78)-F78","v":0},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A78)","v":2},{"$f":"$B78-COUNTIF(G$65:G$77,$A78)-I78","v":0},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A78)","v":0},{"$f":"$B78-COUNTIF(J$65:J$77,$A78)-L78","v":1},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A78)","v":2},{"$f":"$B78-COUNTIF(M$65:M$77,$A78)-O78","v":3},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A78)","v":1},{"$f":"$B78-COUNTIF(P$65:P$77,$A78)-R78","v":2},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A78)","v":2}]
["Marche",6,"Reste",{"$f":"$B79-COUNTIF(D$65:D$77,$A79)-F79","v":2},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A79)","v":0},{"$f":"$B79-COUNTIF(G$65:G$77,$A79)-I79","v":4},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A79)","v":0},{"$f":"$B79-COUNTIF(J$65:J$77,$A79)-L79","v":4},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A79)","v":0},{"$f":"$B79-COUNTIF(M$65:M$77,$A79)-O79","v":4},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A79)","v":0},{"$f":"$B79-COUNTIF(P$65:P$77,$A79)-R79","v":4},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A79)","v":0}]
["Arlon",2,"Reste",2,null,0,1,null,0,2,null,0,2,null,0,2,null,0]
["Libramont",4,"Reste",0,null,0,4,null,0,4,null,0,0,null,0,4,null,0]

{"sheet":"Source","index":2,"n_rows":81,"n_cols":26,"rows_kept":81,"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",{"$f":"PROPER(TEXT(D4,\"mmmm aaaa\"))","v":"Septembre 2023"},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","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]
["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},null,{"$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},null,{"$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},null,{"$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},null,{"$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},null,{"$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},null,{"$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},null,{"$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},null,{"$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,"Bertrix",0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Alice",null,null,"Bertrix",0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Manon",null,null,"en 4/5",0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Nicolas",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,{"$f":"WORKDAY(EOMONTH(P4,-1),1)","v":"2023-09-01"}]
["Alexandra",null,null,null,0,0,null,0,0,"en 4/5",0,0,null,0,0,null,0,0]
["Charlotte",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Cathy",null,null,null,"Bertrix",1,null,0,1,null,"Bertrix",1,null,0,1,null,"Bertrix",1]
["Jean-François",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Sophie",null,null,null,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":1},{"$f":"$B$18-COUNTIF(G$5:G$16,$A18)-I18","v":4},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":3},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":4},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",4,"Reste",{"$f":"$B19-COUNTIF(D$5:D$16,$A19)-F19","v":4},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",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",4,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":4},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",{"$f":"P4+3","v":"2023-09-11"},null,null,{"$f":"D24+1","v":"2023-09-12"},null,null,{"$f":"G24+1","v":"2023-09-13"},null,null,{"$f":"J24+1","v":"2023-09-14"},null,null,{"$f":"M24+1","v":"2023-09-15"}]
["France",null,null,null,{"$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},null,{"$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":1},null,{"$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},null,{"$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},null,{"$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,null,{"$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},null,{"$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},null,{"$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},null,{"$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,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Alice",null,null,null,0,0,"En déplacement",0,0,null,0,0,null,0,0,null,0,0]
["Manon",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Nicolas",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Alexandra",null,null,null,0,0,null,0,0,null,0,0,"TT",0,0,null,0,0]
["Charlotte",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Cathy",null,null,null,"Bertrix",1,null,0,1,null,"Bertrix",1,null,0,1,null,"Bertrix",1]
["Jean-François",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Sophie",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[]
[]
["Bertrix",5,"Reste",{"$f":"$B38-COUNTIF(D$25:D$36,$A38)-F38","v":4},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A38)","v":1},{"$f":"$B38-COUNTIF(G$25:G$36,$A38)-I38","v":4},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A38)","v":1},{"$f":"$B38-COUNTIF(J$25:J$36,$A38)-L38","v":3},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A38)","v":2},{"$f":"$B38-COUNTIF(M$25:M$36,$A38)-O38","v":4},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A38)","v":1},{"$f":"$B38-COUNTIF(P$25:P$36,$A38)-R38","v":3},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A38)","v":2}]
["Marche",6,"Reste",{"$f":"$B39-COUNTIF(D$25:D$36,$A39)-F39","v":6},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A39)","v":0},{"$f":"$B39-COUNTIF(G$25:G$36,$A39)-I39","v":6},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A39)","v":0},{"$f":"$B39-COUNTIF(J$25:J$36,$A39)-L39","v":6},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A39)","v":0},{"$f":"$B39-COUNTIF(M$25:M$36,$A39)-O39","v":6},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A39)","v":0},{"$f":"$B39-COUNTIF(P$25:P$36,$A39)-R39","v":6},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A39)","v":0}]
["Arlon",2,"Reste",2,null,0,{"$f":"$B40-COUNTIF(G$25:G$36,$A40)-I40","v":2},null,0,2,null,0,2,null,0,2,null,0]
["Libramont",4,"Reste",4,null,0,4,null,0,4,null,0,4,null,0,4,null,0]
[]
[null,null,null,"Lundi",null,null,"mardi",null,null,"mercredi",null,null,"jeudi ",null,null,"vendredi"]
[null,null,"Semaine 12",{"$f":"P24+3","v":"2023-09-18"},null,null,{"$f":"D44+1","v":"2023-09-19"},null,null,{"$f":"G44+1","v":"2023-09-20"},null,null,{"$f":"J44+1","v":"2023-09-21"},null,null,{"$f":"M44+1","v":"2023-09-22"}]
["France",null,null,null,{"$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},null,{"$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":1},null,{"$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},null,{"$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},null,{"$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,null,{"$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},null,{"$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},null,{"$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},null,{"$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},null,{"$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,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Alice",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Manon",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Nicolas",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Alexandra",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Charlotte",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Cathy",null,null,null,"Bertrix",1,null,0,1,null,"Bertrix",1,null,{"$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,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Sophie",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[]
[]
["Bertrix",5,"Reste",{"$f":"$B58-COUNTIF(D$45:D$56,$A58)-F58","v":4},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A58)","v":1},{"$f":"$B58-COUNTIF(G$45:G$56,$A58)-I58","v":4},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A58)","v":1},{"$f":"$B58-COUNTIF(J$45:J$56,$A58)-L58","v":3},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A58)","v":2},{"$f":"$B58-COUNTIF(M$45:M$56,$A58)-O58","v":4},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A58)","v":1},{"$f":"$B58-COUNTIF(P$45:P$56,$A58)-R58","v":3},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A58)","v":2}]
["Marche",6,"Reste",{"$f":"$B59-COUNTIF(D$45:D$56,$A59)-F59","v":6},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A59)","v":0},{"$f":"$B59-COUNTIF(G$45:G$56,$A59)-I59","v":6},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A59)","v":0},{"$f":"$B59-COUNTIF(J$45:J$56,$A59)-L59","v":6},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A59)","v":0},{"$f":"$B59-COUNTIF(M$45:M$56,$A59)-O59","v":6},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A59)","v":0},{"$f":"$B59-COUNTIF(P$45:P$56,$A59)-R59","v":6},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A59)","v":0}]
["Arlon",2,"Reste",2,null,0,2,null,0,2,null,0,2,null,0,2,null,0]
["Libramont",4,"Reste",4,null,0,4,null,0,4,null,0,4,null,0,4,null,0]
[]
[null,null,null,"Lundi",null,null,"mardi",null,null,"mercredi",null,null,"jeudi ",null,null,"vendredi"]
[null,null,"Semaine 13",{"$f":"P44+3","v":"2023-09-25"},null,null,{"$f":"D64+1","v":"2023-09-26"},null,null,{"$f":"G64+1","v":"2023-09-27"},null,null,{"$f":"J64+1","v":"2023-09-28"},null,null,{"$f":"M64+1","v":"2023-09-29"}]
["France",null,null,null,{"$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},null,{"$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":1},null,{"$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},null,{"$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},null,{"$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,null,{"$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},null,{"$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},null,{"$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},null,{"$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},null,{"$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,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Alice",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Manon",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Nicolas",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Alexandra",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Charlotte",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Cathy",null,null,null,"Bertrix",1,null,0,1,null,"Bertrix",1,null,0,1,null,"Bertrix",1]
["Jean-François",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Sophie",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[]
[]
["Bertrix",5,"Reste",{"$f":"$B78-COUNTIF(D$65:D$77,$A78)-F78","v":4},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A78)","v":1},{"$f":"$B78-COUNTIF(G$65:G$77,$A78)-I78","v":4},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A78)","v":1},{"$f":"$B78-COUNTIF(J$65:J$77,$A78)-L78","v":3},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A78)","v":2},{"$f":"$B78-COUNTIF(M$65:M$77,$A78)-O78","v":4},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A78)","v":1},{"$f":"$B78-COUNTIF(P$65:P$77,$A78)-R78","v":3},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A78)","v":2}]
["Marche",6,"Reste",{"$f":"$B79-COUNTIF(D$65:D$77,$A79)-F79","v":6},null,{"$f":"SUMIFS(F$5:F$15,E$5:E$15,$A79)","v":0},{"$f":"$B79-COUNTIF(G$65:G$77,$A79)-I79","v":6},null,{"$f":"SUMIFS(I$5:I$15,H$5:H$15,$A79)","v":0},{"$f":"$B79-COUNTIF(J$65:J$77,$A79)-L79","v":6},null,{"$f":"SUMIFS(L$5:L$15,K$5:K$15,$A79)","v":0},{"$f":"$B79-COUNTIF(M$65:M$77,$A79)-O79","v":6},null,{"$f":"SUMIFS(O$5:O$15,N$5:N$15,$A79)","v":0},{"$f":"$B79-COUNTIF(P$65:P$77,$A79)-R79","v":6},null,{"$f":"SUMIFS(R$5:R$15,Q$5:Q$15,$A79)","v":0}]
["Arlon",2,"Reste",2,null,0,2,null,0,2,null,0,2,null,0,2,null,0]
["Libramont",4,"Reste",4,null,0,4,null,0,4,null,0,4,null,0,4,null,0]

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