{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Contacts","1","Table","Fériés","Vacances","Marche à suivre"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":40,"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":"Contacts","index":0,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Contact","Prénom","Smartphone","Courrier électronique","N° véhicule","N° équipe","Couleur équipe","Commentaires"]
[null,"NASCIMENTO","Casimiro",null,null,1,1,"#8BD9B2"]
[null,"DE SOUSA","Alcides",null,null,1,1,"#8BD9B2"]
[null,"CARVALHO","Eugenio",null,null,9,2,"#AFCEEB"]
[null,"DA ROCHA","Daniel",null,null,3,3,"#FFE38B"]
[null,"DA CRUZ","Ricardo Silva",null,null,3,3,"#FFE38B"]
[null,"SALGADO","Rafael Da Silva",null,null,4,4,"#6CEBF8"]
[null,"MOREIRA","Vitor",null,null,4,4,"#6CEBF8"]
[null,"COSTA","Antonio",null,null,6,5,"#C4E59F"]
[null,"TONY","Da Rocha Oliveira",null,null,6,5,"#C4E59F"]
[null,"CARRERA","Carlos",null,null,9,6,"#75C7FF"]
[null,"GUEVARA","Nelson",null,null,9,6,"#75C7FF"]
[null,"DA SILVA","Emanuel Magalhaes",null,null,10,7,"#FFC5EC"]
[null,"FREIXO ","Joao ",null,null,12,7,"#FFC5EC"]
[null,"MARTINS ","Paulo ",null,null,13,8,"#F9D0B9"]
[null,"FERIZI","Adem",null,null,14,9,"#FFA3A3"]
[null,"JARDIN","Fabien",null,null,14,9,"#FFA3A3"]
[null,"DE OLIVEIRA","Jorge",null,null,null,10,"#FFD85D","JDO"]
[null,"De OLIVEIRA","Steve",null,null,null,10,"#FFD85D","SDO"]
[null,"GONZALEZ","Carlos",null,null,null,10,"#FFD85D","CG"]
[null,"MAGALHAESD","Cristiano",null,null,null,10,"#FFD85D","CM"]
[null,"PONTES","Leandro",null,null,null,10,"#FFD85D","LP"]
[null,"SCHLAEPPI","Robin",null,null,null,10,"#FFD85D","RS"]
[null,"GREN/MARQ",null,null,null,null,11,"#D7FFAF"]
[null,"TEMPORAIRE",null,null,null,null,12,"#D7FBFD"]
[null,"A DEFINIR",null,null,null,null,13,"#FFFFB9"]
[null,"PONCAGE",null,null,null,null,14,"#E0E0E0"]
[null,"FINITION",null,null,null,null,14,"#E0E0E0"]
[null,"CDF",null,null,null,null,14,"#E0E0E0"]
[null,"JOINTS",null,null,null,null,14,"#E0E0E0"]
[null,"LISSAGE",null,null,null,null,14,"#E0E0E0"]
[null,"IMPREGNATION",null,null,null,null,14,"#E0E0E0"]
[null,"PLINTHES",null,null,null,null,14,"#E0E0E0"]

{"sheet":"1","index":1,"n_rows":277,"n_cols":19,"rows_kept":277,"cut":false,"hidden":false,"merged":[[153,2,153,5],[154,2,154,5],[275,2,275,5],[276,2,276,5],[29,4,29,5],[191,2,191,5],[192,2,192,5],[203,2,203,5],[204,2,204,5],[215,2,215,5],[216,2,216,5],[227,2,227,5],[228,2,228,5],[239,2,239,5],[107,2,107,5],[108,2,108,5],[119,2,119,5],[120,2,120,5],[131,2,131,5],[132,2,132,5],[143,2,143,5],[176,2,176,5],[177,2,177,5],[178,2,178,5],[240,2,240,5],[251,2,251,5],[273,2,273,5],[274,2,274,5],[259,3,259,4],[260,2,260,5],[261,2,261,5],[262,2,262,5],[269,2,269,4],[269,5,269,9],[252,2,252,5],[263,2,263,5],[264,2,264,5],[185,2,185,4],[185,5,185,9],[269,16,269,18],[271,3,271,4],[272,2,272,5],[245,2,245,4],[245,5,245,9],[245,16,245,18],[247,3,247,4],[248,2,248,5],[249,2,249,5],[250,2,250,5],[257,2,257,4],[257,5,257,9],[257,16,257,18],[233,16,233,18],[235,3,235,4],[236,2,236,5],[237,2,237,5],[238,2,238,5],[211,3,211,4],[212,2,212,5],[213,2,213,5],[214,2,214,5],[221,2,221,4],[221,5,221,9],[221,16,221,18],[223,3,223,4],[224,2,224,5],[225,2,225,5],[226,2,226,5],[233,2,233,4],[233,5,233,9],[197,16,197,18],[199,3,199,4],[200,2,200,5],[201,2,201,5],[202,2,202,5],[209,2,209,4],[209,5,209,9],[209,16,209,18],[188,2,188,5],[189,2,189,5],[190,2,190,5],[197,2,197,4],[197,5,197,9],[142,2,142,5],[129,2,129,5],[130,2,130,5],[185,16,185,18],[187,3,187,4],[165,2,165,5],[166,2,166,5],[173,2,173,4],[173,5,173,9],[173,16,173,18],[161,2,161,4],[161,5,161,9],[161,16,161,18],[163,3,163,4],[164,2,164,5],[137,16,137,18],[149,2,149,4],[149,5,149,9],[168,2,168,5],[144,2,144,5],[167,2,167,5],[175,3,175,4],[151,3,151,4],[152,2,152,5],[65,16,65,18],[89,2,89,4],[89,5,89,9],[149,16,149,18],[125,2,125,4],[125,5,125,9],[125,16,125,18],[127,3,127,4],[128,2,128,5],[113,16,113,18],[115,3,115,4],[116,2,116,5],[117,2,117,5],[118,2,118,5],[113,2,113,4],[139,3,139,4],[140,2,140,5],[141,2,141,5],[113,5,113,9],[137,2,137,4],[137,5,137,9],[93,2,93,5],[94,2,94,5],[79,3,79,4],[80,2,80,5],[81,2,81,5],[82,2,82,5],[57,2,57,5],[58,2,58,5],[104,2,104,5],[70,2,70,5],[77,2,77,4],[65,2,65,4],[65,5,65,9],[59,2,59,5],[60,2,60,5],[71,2,71,5],[72,2,72,5],[95,2,95,5],[96,2,96,5],[105,2,105,5],[106,2,106,5],[103,3,103,4],[69,2,69,5],[77,5,77,9],[1,17,1,18],[2,7,2,8],[2,9,2,10],[2,11,2,12],[15,17,15,18],[17,7,17,8],[17,9,17,10],[17,11,17,12],[41,16,41,18],[41,5,41,9],[15,7,15,8],[15,11,15,12],[15,9,15,10],[2,13,2,14],[2,15,2,16],[2,17,2,18],[1,15,1,16],[3,15,3,16],[3,17,3,18],[5,7,5,18],[56,2,56,5],[13,7,13,18],[15,13,15,14],[15,15,15,16],[17,13,17,14],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[17,15,17,16],[17,17,17,18],[35,4,35,5],[36,4,36,5],[2,4,3,4],[37,4,37,5],[47,2,47,5],[48,2,48,5],[77,16,77,18],[101,2,101,4],[101,5,101,9],[101,16,101,18],[19,7,19,18],[27,7,27,18],[41,2,41,4],[43,3,43,4],[31,4,31,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[44,2,44,5],[45,2,45,5],[46,2,46,5],[67,3,67,4],[68,2,68,5],[53,16,53,18],[55,3,55,4],[89,16,89,18],[91,3,91,4],[92,2,92,5],[53,2,53,4],[53,5,53,9]]}
[]
[null,null,null,null,"Semaine",null,null,{"$f":"CHOOSE(1+MOD(Table!$B$2+1-2,7),\"Dimanche\",\"Lundi\",\"Mardi\",\"Mercredi\",\"Jeudi\",\"Vendredi\",\"Samedi\")","v":"Lundi"},null,{"$f":"CHOOSE(1+MOD(Table!$B$2+2-2,7),\"Dimanche\",\"Lundi\",\"Mardi\",\"Mercredi\",\"Jeudi\",\"Vendredi\",\"Samedi\")","v":"Mardi"},null,{"$f":"CHOOSE(1+MOD(Table!$B$2+3-2,7),\"Dimanche\",\"Lundi\",\"Mardi\",\"Mercredi\",\"Jeudi\",\"Vendredi\",\"Samedi\")","v":"Mercredi"},null,{"$f":"CHOOSE(1+MOD(Table!$B$2+4-2,7),\"Dimanche\",\"Lundi\",\"Mardi\",\"Mercredi\",\"Jeudi\",\"Vendredi\",\"Samedi\")","v":"Jeudi"},null,{"$f":"CHOOSE(1+MOD(Table!$B$2+5-2,7),\"Dimanche\",\"Lundi\",\"Mardi\",\"Mercredi\",\"Jeudi\",\"Vendredi\",\"Samedi\")","v":"Vendredi"},null,{"$f":"CHOOSE(1+MOD(Table!$B$2+6-2,7),\"Dimanche\",\"Lundi\",\"Mardi\",\"Mercredi\",\"Jeudi\",\"Vendredi\",\"Samedi\")","v":"Samedi"}]
[null,null,null,null,1,null,null,{"$f":"IF($E$3=\"\",\"\",7*$E$3+DATE(Table!$E$2,1,3)-WEEKDAY(DATE(Table!$E$2,1,3))-5)","v":"2024-01-01"},null,{"$f":"IF($E$3=\"\",\"\",7*$E$3+DATE(Table!$E$2,1,3)-WEEKDAY(DATE(Table!$E$2,1,3))-4)","v":"2024-01-02"},null,{"$f":"IF($E$3=\"\",\"\",7*$E$3+DATE(Table!$E$2,1,3)-WEEKDAY(DATE(Table!$E$2,1,3))-3)","v":"2024-01-03"},null,{"$f":"IF($E$3=\"\",\"\",7*$E$3+DATE(Table!$E$2,1,3)-WEEKDAY(DATE(Table!$E$2,1,3))-2)","v":"2024-01-04"},null,{"$f":"IF($E$3=\"\",\"\",7*$E$3+DATE(Table!$E$2,1,3)-WEEKDAY(DATE(Table!$E$2,1,3))-1)","v":"2024-01-05"},null,{"$f":"IF($E$3=\"\",\"\",7*$E$3+DATE(Table!$E$2,1,3)-WEEKDAY(DATE(Table!$E$2,1,3)))","v":"2024-01-06"}]
[null,null,null,null,null,null,null,{"$f":"TEXT(H3,\"mmmm aaa\")","v":"janvier 2024"},null,{"$f":"TEXT(J3,\"mmmm aaa\")","v":"janvier 2024"},null,{"$f":"TEXT(L3,\"mmmm aaa\")","v":"janvier 2024"},null,{"$f":"TEXT(N3,\"mmmm aaa\")","v":"janvier 2024"},null,{"$f":"TEXT(P3,\"mmmm aaa\")","v":"janvier 2024"},null,{"$f":"TEXT(R3,\"mmmm aaa\")","v":"janvier 2024"}]
[]
[null,null,null,null,null,null,null,"Vacances"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(AND(H3>=Vacances!$B$3,H3<=Vacances!$C$3),AND(H3>=Vacances!$B$4,H3<=Vacances!$C$4),AND(H3>=Vacances!$B$5,H3<=Vacances!$C$5),AND(H3>=Vacances!$B$6,H3<=Vacances!$C$6),AND(H3>=Vacances!$B$7,H3<=Vacances!$C$7),AND(H3>=Vacances!$B$8,H3<=Vacances!$C$8)),\"VD\",\"\")","v":"VD"},{"$f":"IF(OR(AND(H3>=Vacances!$D$3,H3<=Vacances!$E$3),AND(H3>=Vacances!$D$4,H3<=Vacances!$E$4),AND(H3>=Vacances!$D$5,H3<=Vacances!$E$5),AND(H3>=Vacances!$D$6,H3<=Vacances!$E$6),AND(H3>=Vacances!$D$7,H3<=Vacances!$E$7),AND(H3>=Vacances!$D$8,H3<=Vacances!$E$8)),\"VS\",\"\")","v":"VS"},{"$f":"IF(OR(AND(J3>=Vacances!$B$3,J3<=Vacances!$C$3),AND(J3>=Vacances!$B$4,J3<=Vacances!$C$4),AND(J3>=Vacances!$B$5,J3<=Vacances!$C$5),AND(J3>=Vacances!$B$6,J3<=Vacances!$C$6),AND(J3>=Vacances!$B$7,J3<=Vacances!$C$7),AND(J3>=Vacances!$B$8,J3<=Vacances!$C$8)),\"VD\",\"\")","v":"VD"},{"$f":"IF(OR(AND(J3>=Vacances!$D$3,J3<=Vacances!$E$3),AND(J3>=Vacances!$D$4,J3<=Vacances!$E$4),AND(J3>=Vacances!$D$5,J3<=Vacances!$E$5),AND(J3>=Vacances!$D$6,J3<=Vacances!$E$6),AND(J3>=Vacances!$D$7,J3<=Vacances!$E$7),AND(J3>=Vacances!$D$8,J3<=Vacances!$E$8)),\"VS\",\"\")","v":"VS"},{"$f":"IF(OR(AND(L3>=Vacances!$B$3,L3<=Vacances!$C$3),AND(L3>=Vacances!$B$4,L3<=Vacances!$C$4),AND(L3>=Vacances!$B$5,L3<=Vacances!$C$5),AND(L3>=Vacances!$B$6,L3<=Vacances!$C$6),AND(L3>=Vacances!$B$7,L3<=Vacances!$C$7),AND(L3>=Vacances!$B$8,L3<=Vacances!$C$8)),\"VD\",\"\")","v":"VD"},{"$f":"IF(OR(AND(L3>=Vacances!$D$3,L3<=Vacances!$E$3),AND(L3>=Vacances!$D$4,L3<=Vacances!$E$4),AND(L3>=Vacances!$D$5,L3<=Vacances!$E$5),AND(L3>=Vacances!$D$6,L3<=Vacances!$E$6),AND(L3>=Vacances!$D$7,L3<=Vacances!$E$7),AND(L3>=Vacances!$D$8,L3<=Vacances!$E$8)),\"VS\",\"\")","v":"VS"},{"$f":"IF(OR(AND(N3>=Vacances!$B$3,N3<=Vacances!$C$3),AND(N3>=Vacances!$B$4,N3<=Vacances!$C$4),AND(N3>=Vacances!$B$5,N3<=Vacances!$C$5),AND(N3>=Vacances!$B$6,N3<=Vacances!$C$6),AND(N3>=Vacances!$B$7,N3<=Vacances!$C$7),AND(N3>=Vacances!$B$8,N3<=Vacances!$C$8)),\"VD\",\"\")","v":"VD"},{"$f":"IF(OR(AND(N3>=Vacances!$D$3,N3<=Vacances!$E$3),AND(N3>=Vacances!$D$4,N3<=Vacances!$E$4),AND(N3>=Vacances!$D$5,N3<=Vacances!$E$5),AND(N3>=Vacances!$D$6,N3<=Vacances!$E$6),AND(N3>=Vacances!$D$7,N3<=Vacances!$E$7),AND(N3>=Vacances!$D$8,N3<=Vacances!$E$8)),\"VS\",\"\")","v":"VS"},{"$f":"IF(OR(AND(P3>=Vacances!$B$3,P3<=Vacances!$C$3),AND(P3>=Vacances!$B$4,P3<=Vacances!$C$4),AND(P3>=Vacances!$B$5,P3<=Vacances!$C$5),AND(P3>=Vacances!$B$6,P3<=Vacances!$C$6),AND(P3>=Vacances!$B$7,P3<=Vacances!$C$7),AND(P3>=Vacances!$B$8,P3<=Vacances!$C$8)),\"VD\",\"\")","v":"VD"},{"$f":"IF(OR(AND(P3>=Vacances!$D$3,P3<=Vacances!$E$3),AND(P3>=Vacances!$D$4,P3<=Vacances!$E$4),AND(P3>=Vacances!$D$5,P3<=Vacances!$E$5),AND(P3>=Vacances!$D$6,P3<=Vacances!$E$6),AND(P3>=Vacances!$D$7,P3<=Vacances!$E$7),AND(P3>=Vacances!$D$8,P3<=Vacances!$E$8)),\"VS\",\"\")","v":"VS"},{"$f":"IF(OR(AND(R3>=Vacances!$B$3,R3<=Vacances!$C$3),AND(R3>=Vacances!$B$4,R3<=Vacances!$C$4),AND(R3>=Vacances!$B$5,R3<=Vacances!$C$5),AND(R3>=Vacances!$B$6,R3<=Vacances!$C$6),AND(R3>=Vacances!$B$7,R3<=Vacances!$C$7),AND(R3>=Vacances!$B$8,R3<=Vacances!$C$8)),\"VD\",\"\")","v":"VD"}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(AND(H3>=Vacances!$F$3,H3<=Vacances!$G$3),AND(H3>=Vacances!$F$4,H3<=Vacances!$G$4),AND(H3>=Vacances!$F$5,H3<=Vacances!$G$5),AND(H3>=Vacances!$F$6,H3<=Vacances!$G$6),AND(H3>=Vacances!$F$7,H3<=Vacances!$G$7),AND(H3>=Vacances!$F$8,H3<=Vacances!$G$8)),\"GE\",\"\")","v":"GE"},{"$f":"IF(OR(AND(H3>=Vacances!$H$3,H3<=Vacances!$I$3),AND(H3>=Vacances!$H$4,H3<=Vacances!$I$4),AND(H3>=Vacances!$H$5,H3<=Vacances!$I$5),AND(H3>=Vacances!$H$6,H3<=Vacances!$I$6),AND(H3>=Vacances!$H$7,H3<=Vacances!$I$7),AND(H3>=Vacances!$H$8,H3<=Vacances!$I$8)),\"NE\",\"\")","v":"NE"},{"$f":"IF(OR(AND(J3>=Vacances!$F$3,J3<=Vacances!$G$3),AND(J3>=Vacances!$F$4,J3<=Vacances!$G$4),AND(J3>=Vacances!$F$5,J3<=Vacances!$G$5),AND(J3>=Vacances!$F$6,J3<=Vacances!$G$6),AND(J3>=Vacances!$F$7,J3<=Vacances!$G$7),AND(J3>=Vacances!$F$8,J3<=Vacances!$G$8)),\"GE\",\"\")","v":"GE"},{"$f":"IF(OR(AND(J3>=Vacances!$H$3,J3<=Vacances!$I$3),AND(J3>=Vacances!$H$4,J3<=Vacances!$I$4),AND(J3>=Vacances!$H$5,J3<=Vacances!$I$5),AND(J3>=Vacances!$H$6,J3<=Vacances!$I$6),AND(J3>=Vacances!$H$7,J3<=Vacances!$I$7),AND(J3>=Vacances!$H$8,J3<=Vacances!$I$8)),\"NE\",\"\")","v":"NE"},{"$f":"IF(OR(AND(L3>=Vacances!$F$3,L3<=Vacances!$G$3),AND(L3>=Vacances!$F$4,L3<=Vacances!$G$4),AND(L3>=Vacances!$F$5,L3<=Vacances!$G$5),AND(L3>=Vacances!$F$6,L3<=Vacances!$G$6),AND(L3>=Vacances!$F$7,L3<=Vacances!$G$7),AND(L3>=Vacances!$F$8,L3<=Vacances!$G$8)),\"GE\",\"\")","v":"GE"},{"$f":"IF(OR(AND(L3>=Vacances!$H$3,L3<=Vacances!$I$3),AND(L3>=Vacances!$H$4,L3<=Vacances!$I$4),AND(L3>=Vacances!$H$5,L3<=Vacances!$I$5),AND(L3>=Vacances!$H$6,L3<=Vacances!$I$6),AND(L3>=Vacances!$H$7,L3<=Vacances!$I$7),AND(L3>=Vacances!$H$8,L3<=Vacances!$I$8)),\"NE\",\"\")","v":"NE"},{"$f":"IF(OR(AND(N3>=Vacances!$F$3,N3<=Vacances!$G$3),AND(N3>=Vacances!$F$4,N3<=Vacances!$G$4),AND(N3>=Vacances!$F$5,N3<=Vacances!$G$5),AND(N3>=Vacances!$F$6,N3<=Vacances!$G$6),AND(N3>=Vacances!$F$7,N3<=Vacances!$G$7),AND(N3>=Vacances!$F$8,N3<=Vacances!$G$8)),\"GE\",\"\")","v":"GE"},{"$f":"IF(OR(AND(N3>=Vacances!$H$3,N3<=Vacances!$I$3),AND(N3>=Vacances!$H$4,N3<=Vacances!$I$4),AND(N3>=Vacances!$H$5,N3<=Vacances!$I$5),AND(N3>=Vacances!$H$6,N3<=Vacances!$I$6),AND(N3>=Vacances!$H$7,N3<=Vacances!$I$7),AND(N3>=Vacances!$H$8,N3<=Vacances!$I$8)),\"NE\",\"\")","v":"NE"},{"$f":"IF(OR(AND(P3>=Vacances!$F$3,P3<=Vacances!$G$3),AND(P3>=Vacances!$F$4,P3<=Vacances!$G$4),AND(P3>=Vacances!$F$5,P3<=Vacances!$G$5),AND(P3>=Vacances!$F$6,P3<=Vacances!$G$6),AND(P3>=Vacances!$F$7,P3<=Vacances!$G$7),AND(P3>=Vacances!$F$8,P3<=Vacances!$G$8)),\"GE\",\"\")","v":"GE"},{"$f":"IF(OR(AND(P3>=Vacances!$H$3,P3<=Vacances!$I$3),AND(P3>=Vacances!$H$4,P3<=Vacances!$I$4),AND(P3>=Vacances!$H$5,P3<=Vacances!$I$5),AND(P3>=Vacances!$H$6,P3<=Vacances!$I$6),AND(P3>=Vacances!$H$7,P3<=Vacances!$I$7),AND(P3>=Vacances!$H$8,P3<=Vacances!$I$8)),\"NE\",\"\")","v":"NE"},{"$f":"IF(OR(AND(R3>=Vacances!$D$3,R3<=Vacances!$E$3),AND(R3>=Vacances!$D$4,R3<=Vacances!$E$4),AND(R3>=Vacances!$D$5,R3<=Vacances!$E$5),AND(R3>=Vacances!$D$6,R3<=Vacances!$E$6),AND(R3>=Vacances!$D$7,R3<=Vacances!$E$7),AND(R3>=Vacances!$D$8,R3<=Vacances!$E$8)),\"VS\",\"\")","v":"VS"}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(AND(H3>=Vacances!$J$3,H3<=Vacances!$K$3),AND(H3>=Vacances!$J$4,H3<=Vacances!$K$4),AND(H3>=Vacances!$J$5,H3<=Vacances!$K$5),AND(H3>=Vacances!$J$6,H3<=Vacances!$K$6),AND(H3>=Vacances!$J$7,H3<=Vacances!$K$7),AND(H3>=Vacances!$J$8,H3<=Vacances!$K$8)),\"FR\",\"\")","v":"FR"},{"$f":"IF(OR(AND(H3>=Vacances!$L$3,H3<=Vacances!$M$3),AND(H3>=Vacances!$L$4,H3<=Vacances!$M$4),AND(H3>=Vacances!$L$5,H3<=Vacances!$M$5),AND(H3>=Vacances!$L$6,H3<=Vacances!$M$6),AND(H3>=Vacances!$L$7,H3<=Vacances!$M$7),AND(H3>=Vacances!$L$8,H3<=Vacances!$M$8)),\"JU\",\"\")","v":"JU"},{"$f":"IF(OR(AND(J3>=Vacances!$J$3,J3<=Vacances!$K$3),AND(J3>=Vacances!$J$4,J3<=Vacances!$K$4),AND(J3>=Vacances!$J$5,J3<=Vacances!$K$5),AND(J3>=Vacances!$J$6,J3<=Vacances!$K$6),AND(J3>=Vacances!$J$7,J3<=Vacances!$K$7),AND(J3>=Vacances!$J$8,J3<=Vacances!$K$8)),\"FR\",\"\")","v":"FR"},{"$f":"IF(OR(AND(J3>=Vacances!$L$3,J3<=Vacances!$M$3),AND(J3>=Vacances!$L$4,J3<=Vacances!$M$4),AND(J3>=Vacances!$L$5,J3<=Vacances!$M$5),AND(J3>=Vacances!$L$6,J3<=Vacances!$M$6),AND(J3>=Vacances!$L$7,J3<=Vacances!$M$7),AND(J3>=Vacances!$L$8,J3<=Vacances!$M$8)),\"JU\",\"\")","v":"JU"},{"$f":"IF(OR(AND(L3>=Vacances!$J$3,L3<=Vacances!$K$3),AND(L3>=Vacances!$J$4,L3<=Vacances!$K$4),AND(L3>=Vacances!$J$5,L3<=Vacances!$K$5),AND(L3>=Vacances!$J$6,L3<=Vacances!$K$6),AND(L3>=Vacances!$J$7,L3<=Vacances!$K$7),AND(L3>=Vacances!$J$8,L3<=Vacances!$K$8)),\"FR\",\"\")","v":"FR"},{"$f":"IF(OR(AND(L3>=Vacances!$L$3,L3<=Vacances!$M$3),AND(L3>=Vacances!$L$4,L3<=Vacances!$M$4),AND(L3>=Vacances!$L$5,L3<=Vacances!$M$5),AND(L3>=Vacances!$L$6,L3<=Vacances!$M$6),AND(L3>=Vacances!$L$7,L3<=Vacances!$M$7),AND(L3>=Vacances!$L$8,L3<=Vacances!$M$8)),\"JU\",\"\")","v":"JU"},{"$f":"IF(OR(AND(N3>=Vacances!$J$3,N3<=Vacances!$K$3),AND(N3>=Vacances!$J$4,N3<=Vacances!$K$4),AND(N3>=Vacances!$J$5,N3<=Vacances!$K$5),AND(N3>=Vacances!$J$6,N3<=Vacances!$K$6),AND(N3>=Vacances!$J$7,N3<=Vacances!$K$7),AND(N3>=Vacances!$J$8,N3<=Vacances!$K$8)),\"FR\",\"\")","v":"FR"},{"$f":"IF(OR(AND(N3>=Vacances!$L$3,N3<=Vacances!$M$3),AND(N3>=Vacances!$L$4,N3<=Vacances!$M$4),AND(N3>=Vacances!$L$5,N3<=Vacances!$M$5),AND(N3>=Vacances!$L$6,N3<=Vacances!$M$6),AND(N3>=Vacances!$L$7,N3<=Vacances!$M$7),AND(N3>=Vacances!$L$8,N3<=Vacances!$M$8)),\"JU\",\"\")","v":"JU"},{"$f":"IF(OR(AND(P3>=Vacances!$J$3,P3<=Vacances!$K$3),AND(P3>=Vacances!$J$4,P3<=Vacances!$K$4),AND(P3>=Vacances!$J$5,P3<=Vacances!$K$5),AND(P3>=Vacances!$J$6,P3<=Vacances!$K$6),AND(P3>=Vacances!$J$7,P3<=Vacances!$K$7),AND(P3>=Vacances!$J$8,P3<=Vacances!$K$8)),\"FR\",\"\")","v":"FR"},{"$f":"IF(OR(AND(P3>=Vacances!$L$3,P3<=Vacances!$M$3),AND(P3>=Vacances!$L$4,P3<=Vacances!$M$4),AND(P3>=Vacances!$L$5,P3<=Vacances!$M$5),AND(P3>=Vacances!$L$6,P3<=Vacances!$M$6),AND(P3>=Vacances!$L$7,P3<=Vacances!$M$7),AND(P3>=Vacances!$L$8,P3<=Vacances!$M$8)),\"JU\",\"\")","v":"JU"},{"$f":"IF(OR(AND(R3>=Vacances!$F$3,R3<=Vacances!$G$3),AND(R3>=Vacances!$F$4,R3<=Vacances!$G$4),AND(R3>=Vacances!$F$5,R3<=Vacances!$G$5),AND(R3>=Vacances!$F$6,R3<=Vacances!$G$6),AND(R3>=Vacances!$F$7,R3<=Vacances!$G$7),AND(R3>=Vacances!$F$8,R3<=Vacances!$G$8)),\"GE\",\"\")","v":"GE"}]
[]
[null,null,null,null,null,null,null,"Fermeture"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(AND(H3>=Vacances!$B$13,H3<=Vacances!$C$13),AND(H3>=Vacances!$B$14,H3<=Vacances!$C$14),AND(H3>=Vacances!$B$15,H3<=Vacances!$C$15)),\"Fermeture VD\",\"\")","v":"Fermeture VD"},null,{"$f":"IF(OR(AND(J3>=Vacances!$B$13,J3<=Vacances!$C$13),AND(J3>=Vacances!$B$14,J3<=Vacances!$C$14),AND(J3>=Vacances!$B$15,J3<=Vacances!$C$15)),\"Fermeture VD\",\"\")","v":"Fermeture VD"},null,{"$f":"IF(OR(AND(L3>=Vacances!$B$13,L3<=Vacances!$C$13),AND(L3>=Vacances!$B$14,L3<=Vacances!$C$14),AND(L3>=Vacances!$B$15,L3<=Vacances!$C$15)),\"Fermeture VD\",\"\")","v":"Fermeture VD"},null,{"$f":"IF(OR(AND(N3>=Vacances!$B$13,N3<=Vacances!$C$13),AND(N3>=Vacances!$B$14,N3<=Vacances!$C$14),AND(N3>=Vacances!$B$15,N3<=Vacances!$C$15)),\"Fermeture VD\",\"\")","v":"Fermeture VD"},null,{"$f":"IF(OR(AND(P3>=Vacances!$B$13,P3<=Vacances!$C$13),AND(P3>=Vacances!$B$14,P3<=Vacances!$C$14),AND(P3>=Vacances!$B$15,P3<=Vacances!$C$15)),\"Fermeture VD\",\"\")","v":"Fermeture VD"},null,{"$f":"IF(OR(AND(R3>=Vacances!$B$13,R3<=Vacances!$C$13),AND(R3>=Vacances!$B$14,R3<=Vacances!$C$14),AND(R3>=Vacances!$B$15,R3<=Vacances!$C$15)),\"Fermeture VD\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(AND(H3>=Vacances!$F$13,H3<=Vacances!$G$13),AND(H3>=Vacances!$F$14,H3<=Vacances!$G$14),AND(H3>=Vacances!$F$15,H3<=Vacances!$G$15)),\"Fermeture GE\",\"\")","v":"Fermeture GE"},null,{"$f":"IF(OR(AND(J3>=Vacances!$F$13,J3<=Vacances!$G$13),AND(J3>=Vacances!$F$14,J3<=Vacances!$G$14),AND(J3>=Vacances!$F$15,J3<=Vacances!$G$15)),\"Fermeture GE\",\"\")","v":"Fermeture GE"},null,{"$f":"IF(OR(AND(L3>=Vacances!$F$13,L3<=Vacances!$G$13),AND(L3>=Vacances!$F$14,L3<=Vacances!$G$14),AND(L3>=Vacances!$F$15,L3<=Vacances!$G$15)),\"Fermeture GE\",\"\")","v":"Fermeture GE"},null,{"$f":"IF(OR(AND(N3>=Vacances!$F$13,N3<=Vacances!$G$13),AND(N3>=Vacances!$F$14,N3<=Vacances!$G$14),AND(N3>=Vacances!$F$15,N3<=Vacances!$G$15)),\"Fermeture GE\",\"\")","v":"Fermeture GE"},null,{"$f":"IF(OR(AND(P3>=Vacances!$F$13,P3<=Vacances!$G$13),AND(P3>=Vacances!$F$14,P3<=Vacances!$G$14),AND(P3>=Vacances!$F$15,P3<=Vacances!$G$15)),\"Fermeture GE\",\"\")","v":"Fermeture GE"},null,{"$f":"IF(OR(AND(R3>=Vacances!$F$13,R3<=Vacances!$G$13),AND(R3>=Vacances!$F$14,R3<=Vacances!$G$14),AND(R3>=Vacances!$F$15,R3<=Vacances!$G$15)),\"Fermeture GE\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,"Fériés"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,H3)=0,H3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,H3)>0,_xlfn.XLOOKUP(H3,Fériés!$C$6:$C$27,Fériés!$E$6:$E$27)=\"Oui\"),\"VD\",\"\"))","v":"VD"},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,H3)=0,H3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,H3)>0,_xlfn.XLOOKUP(H3,Fériés!$C$6:$C$27,Fériés!$F$6:$F$27)=\"Oui\"),\"VS\",\"\"))","v":"VS"},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,J3)=0,J3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,J3)>0,_xlfn.XLOOKUP(J3,Fériés!$C$6:$C$27,Fériés!$E$6:$E$27)=\"Oui\"),\"VD\",\"\"))","v":"VD"},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,J3)=0,J3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,J3)>0,_xlfn.XLOOKUP(J3,Fériés!$C$6:$C$27,Fériés!$F$6:$F$27)=\"Oui\"),\"VS\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,L3)=0,L3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,L3)>0,_xlfn.XLOOKUP(L3,Fériés!$C$6:$C$27,Fériés!$E$6:$E$27)=\"Oui\"),\"VD\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,L3)=0,L3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,L3)>0,_xlfn.XLOOKUP(L3,Fériés!$C$6:$C$27,Fériés!$F$6:$F$27)=\"Oui\"),\"VS\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,N3)=0,N3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,N3)>0,_xlfn.XLOOKUP(N3,Fériés!$C$6:$C$27,Fériés!$E$6:$E$27)=\"Oui\"),\"VD\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,N3)=0,N3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,N3)>0,_xlfn.XLOOKUP(N3,Fériés!$C$6:$C$27,Fériés!$F$6:$F$27)=\"Oui\"),\"VS\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,P3)=0,P3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,P3)>0,_xlfn.XLOOKUP(P3,Fériés!$C$6:$C$27,Fériés!$E$6:$E$27)=\"Oui\"),\"VD\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,P3)=0,P3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,P3)>0,_xlfn.XLOOKUP(P3,Fériés!$C$6:$C$27,Fériés!$F$6:$F$27)=\"Oui\"),\"VS\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,R3)=0,R3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,R3)>0,_xlfn.XLOOKUP(R3,Fériés!$C$6:$C$27,Fériés!$E$6:$E$27)=\"Oui\"),\"VD\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,R3)=0,R3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,R3)>0,_xlfn.XLOOKUP(R3,Fériés!$C$6:$C$27,Fériés!$F$6:$F$27)=\"Oui\"),\"VS\",\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,H3)=0,H3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,H3)>0,_xlfn.XLOOKUP(H3,Fériés!$C$6:$C$27,Fériés!$G$6:$G$27)=\"Oui\"),\"GE\",\"\"))","v":"GE"},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,H3)=0,H3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,H3)>0,_xlfn.XLOOKUP(H3,Fériés!$C$6:$C$27,Fériés!$H$6:$H$27)=\"Oui\"),\"NE\",\"\"))","v":"NE"},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,J3)=0,J3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,J3)>0,_xlfn.XLOOKUP(J3,Fériés!$C$6:$C$27,Fériés!$G$6:$G$27)=\"Oui\"),\"GE\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,J3)=0,J3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,J3)>0,_xlfn.XLOOKUP(J3,Fériés!$C$6:$C$27,Fériés!$H$6:$H$27)=\"Oui\"),\"NE\",\"\"))","v":"NE"},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,L3)=0,L3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,L3)>0,_xlfn.XLOOKUP(L3,Fériés!$C$6:$C$27,Fériés!$G$6:$G$27)=\"Oui\"),\"GE\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,L3)=0,L3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,L3)>0,_xlfn.XLOOKUP(L3,Fériés!$C$6:$C$27,Fériés!$H$6:$H$27)=\"Oui\"),\"NE\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,N3)=0,N3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,N3)>0,_xlfn.XLOOKUP(N3,Fériés!$C$6:$C$27,Fériés!$G$6:$G$27)=\"Oui\"),\"GE\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,N3)=0,N3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,N3)>0,_xlfn.XLOOKUP(N3,Fériés!$C$6:$C$27,Fériés!$H$6:$H$27)=\"Oui\"),\"NE\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,P3)=0,P3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,P3)>0,_xlfn.XLOOKUP(P3,Fériés!$C$6:$C$27,Fériés!$G$6:$G$27)=\"Oui\"),\"GE\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,P3)=0,P3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,P3)>0,_xlfn.XLOOKUP(P3,Fériés!$C$6:$C$27,Fériés!$H$6:$H$27)=\"Oui\"),\"NE\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,R3)=0,R3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,R3)>0,_xlfn.XLOOKUP(R3,Fériés!$C$6:$C$27,Fériés!$G$6:$G$27)=\"Oui\"),\"GE\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,R3)=0,R3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,R3)>0,_xlfn.XLOOKUP(R3,Fériés!$C$6:$C$27,Fériés!$H$6:$H$27)=\"Oui\"),\"NE\",\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,H3)=0,H3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,H3)>0,_xlfn.XLOOKUP(H3,Fériés!$C$6:$C$27,Fériés!$I$6:$I$27)=\"Oui\"),\"FR\",\"\"))","v":"FR"},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,H3)=0,H3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,H3)>0,_xlfn.XLOOKUP(H3,Fériés!$C$6:$C$27,Fériés!$J$6:$J$27)=\"Oui\"),\"JU\",\"\"))","v":"JU"},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,J3)=0,J3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,J3)>0,_xlfn.XLOOKUP(J3,Fériés!$C$6:$C$27,Fériés!$I$6:$I$27)=\"Oui\"),\"FR\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,J3)=0,J3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,J3)>0,_xlfn.XLOOKUP(J3,Fériés!$C$6:$C$27,Fériés!$J$6:$J$27)=\"Oui\"),\"JU\",\"\"))","v":"JU"},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,L3)=0,L3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,L3)>0,_xlfn.XLOOKUP(L3,Fériés!$C$6:$C$27,Fériés!$I$6:$I$27)=\"Oui\"),\"FR\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,L3)=0,L3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,L3)>0,_xlfn.XLOOKUP(L3,Fériés!$C$6:$C$27,Fériés!$J$6:$J$27)=\"Oui\"),\"FR\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,N3)=0,N3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,N3)>0,_xlfn.XLOOKUP(N3,Fériés!$C$6:$C$27,Fériés!$I$6:$I$27)=\"Oui\"),\"FR\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,N3)=0,N3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,N3)>0,_xlfn.XLOOKUP(N3,Fériés!$C$6:$C$27,Fériés!$J$6:$J$27)=\"Oui\"),\"JU\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,P3)=0,P3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,P3)>0,_xlfn.XLOOKUP(P3,Fériés!$C$6:$C$27,Fériés!$I$6:$I$27)=\"Oui\"),\"FR\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,P3)=0,P3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,P3)>0,_xlfn.XLOOKUP(P3,Fériés!$C$6:$C$27,Fériés!$J$6:$J$27)=\"Oui\"),\"JU\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,R3)=0,R3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,R3)>0,_xlfn.XLOOKUP(R3,Fériés!$C$6:$C$27,Fériés!$I$6:$I$27)=\"Oui\"),\"FR\",\"\"))","v":""},{"$f":"IF(OR(COUNTIF(Fériés!$C$6:$C$27,R3)=0,R3=\"\"),\"\",IF(AND(COUNTIF(Fériés!$C$6:$C$27,R3)>0,_xlfn.XLOOKUP(R3,Fériés!$C$6:$C$27,Fériés!$J$6:$J$27)=\"Oui\"),\"JU\",\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,"Absences"]
[]
[null,null,null,null,"MOTIFS",null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[]
[null,null,null,null,"Accident"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,2,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,3,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,4,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,5,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,6,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,7,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,8,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,9,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,10,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,11,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,12,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,13,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,14,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,15,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,16,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,17,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,18,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,19,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]
[]
[]
[]
[]
[]
[]
[null,20,"Statut chantier",null,null,null,null,"MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM","MAT","APM"]
[null,"Note 1"]
[null,"Note 2"]
[null,"Note 3"]
[null,"Note 4"]
[null,"Note 5"]

{"sheet":"Table","index":2,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Mode","1er mois","1er jour année","Année","Système semaine","Succ.","Code couleur succ.","N° véhicule","Absences","Statut"]
[null,2,1,"2024-01-01",2024,1,"VD","#FFF2C9",1,"Congé","Confirmé"]
[null,null,null,null,null,null,"VS","#FAD9C2",2,"Vacances","Non confirmé"]
[null,null,null,null,null,null,"GE","#FFC5C5",3,"Maladie"]
[null,null,null,null,null,null,"NE","#D4E8C6",4,"Accident"]
[null,null,null,null,null,null,"FR","#C9D6ED",5]
[null,null,null,null,null,null,"FTX","#ECD9FF",6]
[null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,20]

{"sheet":"Fériés","index":3,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Jours fériés cantonaux"]
[]
[null,"Jour","Jour","Tombe le"]
[null,null,null,null,"VD","VS","GE","NE","FR","JU","FVE"]
[null,"1er jour de l'An","2024-01-01","Le 1er janvier","Oui","Oui","Oui","Oui","Oui","Oui"]
[null,"2ème jour de l'An","2024-01-02","Le 2 janvier","Oui","Non","Non","Oui","Non","Oui","Oui"]
[null,"Instauration de la République de Neuchâtel","2024-03-01","Le 1er mars","Non","Non","Non","Oui","Non","Non","Non"]
[null,"Vendredi Saint",{"$f":"C10-2","v":"2024-03-29"},"2 jours avant Pâques","Oui","Oui","Oui","Oui","Oui","Oui","Oui"]
[null,"Pâques","2024-03-31","Trop compliqué"]
[null,"Lundi de Pâques",{"$f":"C10+1","v":"2024-04-01"},"1 jour après Pâques","Oui","Oui","Oui","Non","Non","Oui","Oui"]
[null,"Fête du travail","2024-05-01","Le 1er mai","Non","Non","Oui","Oui","Non","Oui","Non"]
[null,"Ascension",{"$f":"C10+39","v":"2024-05-09"},"39 jours après Pâques","Oui","Oui","Oui","Oui","Oui","Oui","Oui"]
[null,"Pont Ascension",{"$f":"C13+1","v":"2024-05-10"},"40 jours après Pâques",{"$f":"IF($C$29>=7,\"Non\",\"Oui\")","v":"Non"},{"$f":"IF($C$29>=7,\"Non\",\"Oui\")","v":"Non"},"Non","Non","Non","Non"]
[null,"Lundi de Pentecôte",{"$f":"C10+50","v":"2024-05-20"},"50 jours après Pâques","Oui","Oui","Oui","Non","Non","Oui","Oui"]
[null,"Fête Dieu",{"$f":"C10+60","v":"2024-05-30"},"60 jours après Pâques","Non","Oui","Non","Non","Oui","Oui","Non"]
[null,"Commémoration Plébiscite jurassien","2024-06-23","Le 23 juin","Non","Non","Non","Non","Non","Oui","Non"]
[null,"Fête nationale","2024-08-01","Le 1er août","Oui","Oui","Oui","Oui","Oui","Oui","Oui"]
[null,"Assomption","2024-08-15","Le 15 août","Non","Oui","Non","Non","Oui","Oui","Non"]
[null,"Jeûne genevois","2024-09-05","Jeudi qui suit le 1er dimanche de septembre","Non","Non","Oui","Non","Non","Non","Non"]
[null,"Jeûne fédéral","2024-09-16","Lundi qui suit le 3ème dimanche de septembre","Oui","Oui","Non","Non","Non","Non","Oui"]
[null,"Toussaint","2024-11-01","Le 1er novembre","Non","Oui","Non","Non","Oui","Oui","Non"]
[null,"Immaculée Conception","2024-12-08","Le 8 décembre","Non","Oui","Non","Non","Oui","Non","Non"]
[null,"Noël","2024-12-25","Le 25 décembre","Oui","Oui","Oui","Oui","Oui","Oui","Oui"]
[]
[]
[]
[]
[null,null,{"$f":"COUNTIF(K6:K24,\"Oui\")","v":8},null,"Nombre de jours fériés FVE hors week-end"]
[null,null,null,null,{"$f":"IF(C29<7,\"Le nombre des jours fériés étant inférieur à 7, le \"&_xlfn.XLOOKUP(\"Pont Ascension\",B6:B27,C6:C27)&TEXT(C14,\"jjjj jj mmmm aaaa\")&\" est un jour non travaillé mais indemnisé.\",\"Le nombre des jours fériés étant supérieur à 6, le \"&TEXT(C14,\"jjjj jj mmmm aaaa\")&\" est un jour travaillé.\")","v":"Le nombre des jours fériés étant supérieur à 6, le vendredi 10 mai 2024 est un jour travaillé."}]
[]
[]
[null,null,"Ne pas renseigner la colonne FVE pour les fêtes qui donnent sur un week-end"]
[null,null,"Ne pas effacer la ligne \"Pâques\""]
[null,null,"Ne pas mofiier le nom \"Pont Ascension\""]

{"sheet":"Vacances","index":4,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,11,1,12],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[11,11,11,12],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10]]}
[]
[null,"Vacances Vaud",null,"Vacances Valais",null,"Vacances Genève",null,"Vacances Neuchâtel",null,"Vacances Fribourg",null,"Vacances Jura"]
[null,"2024-01-01","2024-01-06","2024-01-01","2024-01-06","2024-01-01","2024-01-06","2024-01-01","2024-01-06","2024-01-01","2024-01-06","2024-01-01","2024-01-06"]
[null,"2024-02-12","2024-02-16","2024-02-12","2024-02-16","2024-02-19","2024-02-23","2024-02-26","2024-03-01","2024-02-26","2024-03-08","2024-02-19","2024-02-23"]
[null,"2024-04-01","2024-04-12","2024-04-01","2024-04-12","2024-04-01","2024-04-12","2024-04-01","2024-04-12","2024-04-22","2024-05-03","2024-03-29","2024-04-12"]
[null,"2024-07-01","2024-08-16","2024-06-24","2024-08-16","2024-07-01","2024-08-16","2024-07-08","2024-08-16","2024-07-08","2024-07-08","2024-08-16","2023-08-18"]
[null,"2024-10-14","2024-10-25","2024-10-17","2024-10-25","2024-10-21","2024-10-25","2024-10-07","2024-10-18","2024-10-21","2024-11-01","2024-10-14","2024-10-25"]
[null,"2024-12-23","2025-01-03","2024-12-23","2025-01-03","2024-12-23","2025-01-03","2024-12-23","2025-01-03","2024-12-23","2025-01-03","2024-12-23","2025-01-03"]
[]
[]
[]
[null,"Vacances succursale VD",null,"Vacances succursale VS",null,"Vacances succursale GE",null,"Vacances succursale NE",null,"Vacances succursale FR",null,"Vacances succursale JU"]
[null,"2024-01-01","2024-01-05",null,null,"2024-01-01","2024-01-05"]

{"sheet":"Marche à suivre","index":5,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,"Préparation du fichier pour l'année suivante :"]
[]
[1,"Ouvrir le fichier \"Planning_Chantiers_Modèle\""]
[null,"Enregistrer sous et nommer le fichier \"Planning_Chantiers_AAAA\" pour créer le fichier de la nouvelle année",null,null,null,null,null,null,null,"1 افتح ملف \"Planning_Site_Model\"."]
[null,null,null,null,null,null,null,null,null,"  احفظ باسم وقم بتسمية الملف \"Planning_Chantiers_AAAA\" لإنشاء ملف العام الجديد"]
["1A","Enlever la protection sur la feuille \"Vacances\" "]
[null,"Mettre à jour les périodes de vacances scolaires et de fermeture de l'entreprise pour l'année concernée",null,null,null,null,null,null,null,"1A قم بإزالة الحماية الموجودة على ورقة \"الإجازة\"."]
[null,"Mettre la protection sur la feuille \"Vacances\"",null,null,null,null,null,null,null,"  تحديث العطلات المدرسية وفترات إغلاق الأعمال للعام المعني"]
[null,null,null,null,null,null,null,null,null,"  ضع الحماية على ورقة \"الإجازة\"."]
[null,"Si le nombre de lignes pour les vacances scolaires est supérieur à 6 il faut modifier les formules dans la feuille \"Chantiers\""]
[null,"Si le nombre de lignes pour les fermetures de l'entreprise est supérieur à 3 lignes il faut modifier les formules dans la feuille \"Chantiers\"",null,null,null,null,null,null,null,"  إذا كان عدد أسطر العطل المدرسية أكبر من 6 يجب عليك تعديل الصيغ في ورقة \"الإنشاءات\""]
[null,"Ne pas changer le format des dates ni modifier l'ordre des colonnes",null,null,null,null,null,null,null,"  إذا كان عدد الأسطر الخاصة بإغلاق الشركة أكبر من 3 أسطر، فيجب عليك تعديل الصيغ في ورقة \"المواقع\"."]
[null,null,null,null,null,null,null,null,null,"  لا تقم بتغيير تنسيق التاريخ أو تغيير ترتيب الأعمدة"]
[2,"Enlever la protection sur la feuille \"Fériés cantons\" "]
[null,"Mettre uniquement à jour les dates dans lesquelles il n'y a aucune formule",null,null,null,null,null,null,null,"2 قم بإزالة الحماية الموجودة على ورقة \"Canton Holidays\"."]
[null,"Mettre à jour les jours fériés par canton",null,null,null,null,null,null,null,"  تواريخ التحديث فقط التي لا توجد فيها صيغة"]
[null,"Mettre à jour les jours fériés FVE (Répondre \"Non\" pour les jours fériés qui tombent un week-end)",null,null,null,null,null,null,null,"  تحديث العطلات الرسمية حسب الكانتونات"]
[null,null,null,null,null,null,null,null,null,"  تحديث عطلات FVE (الإجابة بـ \"لا\" للعطلات التي تقع في عطلة نهاية الأسبوع)"]
[null,"3 dates supplémentaires sont dispo en ligne 21 à 23\nLe calcul pour déterminer si le \"Pont de l'Ascension\" est un jour férié s'effectue automatiquement mais à vérifier"]
[null,null,null,null,null,null,null,null,null,"  \"3 تواريخ إضافية متاحة عبر الإنترنت من 21 إلى 23"]
[null,"Ne pas suppriner ni renseigner la ligne \"Pâques\"\nNe pas changer les libellés",null,null,null,null,null,null,null,"يتم إجراء الحساب لتحديد ما إذا كان \"جسر الصعود\" عطلة رسمية تلقائيًا ولكن يجب التحقق منه."]
[]
[null,"Mettre la protection sur la feuille \"Fériés cantons\"\"",null,null,null,null,null,null,null,"  \"لا تحذف أو تملأ سطر \"عيد الفصح\"."]
[null,null,null,null,null,null,null,null,null,"لا تغير التسميات\""]
["1C","Il n'y a normalement rien à changer dans la feuille \"Table\" à moins de vouloir changer des couleurs, rajouter des motifs d'absence ou des succursales"]
[null,null,null,null,null,null,null,null,null,"  ضع الحماية على ورقة \"Canton Holidays\"."]
["1D","Modifier l'année du calendrier dans la feuille \"Table\""]
[null,"Modifier la date du 1er jour de l'année dans la feuille \"Table\"",null,null,null,null,null,null,null,"1C لا يوجد عادةً أي شيء يمكن تغييره في ورقة \"الجدول\" إلا إذا كنت تريد تغيير الألوان أو إضافة أسباب الغياب أو الفروع"]
[]
[null,null,null,null,null,null,null,null,null,"1D قم بتغيير السنة التقويمية في ورقة \"الجدول\"."]
[null,"Mettre à jour les contacts",null,null,null,null,null,null,null,"  قم بتعديل تاريخ اليوم الأول من السنة في ورقة \"الجدول\"."]
[]
[null,"Enlever la protection sur la feuille \"Contacts\""]
[null,"Supprimer/modifier/rajouter un collaborateur",null,null,null,null,null,null,null,"  تحديث جهات الاتصال"]
[null,"Vérifier que le nouveau collaborateur est visible dans les listes déroulantes de la feuille \"1\""]
[null,"Si des nouveaux collaborateurs ont été rajoutés en fin de liste et qu'ils n'apparaissent pas dans les listes déroulantes il faut modifier les formules de ces listes",null,null,null,null,null,null,null,"  قم بإزالة الحماية من ورقة \"جهات الاتصال\"."]
[null,"Le N° de l'équipe détermine la couleur affichée pour chaque collaborateur",null,null,null,null,null,null,null,"  حذف/تعديل/إضافة متعاون"]
[null,"Si de nouvelles équipes respectivement de nouvelles couleurs doivent être ajoutées il faut modifier les formules",null,null,null,null,null,null,null,"  تأكد من ظهور المتعاون الجديد في القوائم المنسدلة للورقة \"1\""]
[null,null,null,null,null,null,null,null,null,"  إذا تمت إضافة متعاونين جدد في نهاية القائمة ولم يظهروا في القوائم المنسدلة، فيجب عليك تعديل صيغ هذه القوائم"]
[null,null,null,null,null,null,null,null,null,"  يحدد رقم الفريق اللون المعروض لكل موظف"]
[null,null,null,null,null,null,null,null,null,"  إذا كان من الضروري إضافة فرق جديدة أو ألوان جديدة، فيجب تعديل الصيغ"]