{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Employés","Planning mensuel congés","Synthèse congés annuel","Listes","Instructions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Employés","index":0,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,2,2,5]]}
[null,null,"Listes des employés"]
[]
[]
[]
[null,null,null,null,"Liste employés"]

{"sheet":"Planning mensuel congés","index":1,"n_rows":163,"n_cols":32,"rows_kept":163,"cut":false,"hidden":false,"merged":[[0,1,2,8]]}
[null,"Planning mensuel congés"]
[]
[]
[null,null,null,"Service:","Nom Service"]
[null,null,null,"Année:","Année"]
[null,"Légende",null,null,null,null,null,null,"Autres  (maternité, …)","AUTRES"]
[null,"Week-end",null,"Congé","C. ou C./2","Congé sans solde","S.S.",null,"Absences autorisées","ABS.  AUT."]
[null,"Jour férié",null,"RTT","RTT","Maladie","MAL.",null,"Absences non autorisées","ABS. NON AUT."]
["Janvier","Nombre de jours",{"$f":"IF(OR($E$5=\"\", $E$5=\"Année\",A9=\"\"),\"Entrer année ou vérifier mois\",DAY(DATE(E5,MONTH(A9&\"1\")+1,1)-1))","v":"Entrer année ou vérifier mois"}]
["Employés",{"$f":"IF(OR($E$5=\"\",$E$5=\"Année\",A9=\"\"),\"\",DAY(DATE($E$5,MONTH(A9&\"1\")+1,1)-1)-DAY(DATE($E$5,MONTH(A9&\"1\")+1,1)-1)+1)","v":""},{"$f":"_xlfn.IFS(B10=\"\",\"\",B10<$C9,B10+1,B10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(C10=\"\",\"\",C10<$C9,C10+1,C10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(D10=\"\",\"\",D10<$C9,D10+1,D10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(E10=\"\",\"\",E10<$C9,E10+1,E10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(F10=\"\",\"\",F10<$C9,F10+1,F10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(G10=\"\",\"\",G10<$C9,G10+1,G10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(H10=\"\",\"\",H10<$C9,H10+1,H10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(I10=\"\",\"\",I10<$C9,I10+1,I10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(J10=\"\",\"\",J10<$C9,J10+1,J10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(K10=\"\",\"\",K10<$C9,K10+1,K10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(L10=\"\",\"\",L10<$C9,L10+1,L10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(M10=\"\",\"\",M10<$C9,M10+1,M10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(N10=\"\",\"\",N10<$C9,N10+1,N10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(O10=\"\",\"\",O10<$C9,O10+1,O10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(P10=\"\",\"\",P10<$C9,P10+1,P10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(Q10=\"\",\"\",Q10<$C9,Q10+1,Q10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(R10=\"\",\"\",R10<$C9,R10+1,R10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(S10=\"\",\"\",S10<$C9,S10+1,S10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(T10=\"\",\"\",T10<$C9,T10+1,T10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(U10=\"\",\"\",U10<$C9,U10+1,U10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(V10=\"\",\"\",V10<$C9,V10+1,V10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(W10=\"\",\"\",W10<$C9,W10+1,W10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(X10=\"\",\"\",X10<$C9,X10+1,X10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(Y10=\"\",\"\",Y10<$C9,Y10+1,Y10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(Z10=\"\",\"\",Z10<$C9,Z10+1,Z10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(AA10=\"\",\"\",AA10<$C9,AA10+1,AA10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(AB10=\"\",\"\",AB10<$C9,AB10+1,AB10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(AC10=\"\",\"\",AC10<$C9,AC10+1,AC10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(AD10=\"\",\"\",AD10<$C9,AD10+1,AD10=$C9,\"\")","v":""},{"$f":"_xlfn.IFS(AE10=\"\",\"\",AE10<$C9,AE10+1,AE10=$C9,\"\")","v":""}]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""}]
[]
["Février","Nombre de jours",{"$f":"IF(OR($E$5=\"\", $E$5=\"Année\",A22=\"\"),\"Entrer année ou vérifier mois\",DAY(DATE(E18,MONTH(A22&\"1\")+1,1)-1))","v":"Entrer année ou vérifier mois"}]
["Employés",{"$f":"IF(OR($E$5=\"\",$E$5=\"Année\",A22=\"\"),\"\",DAY(DATE($E$5,MONTH(A22&\"1\")+1,1)-1)-DAY(DATE($E$5,MONTH(A22&\"1\")+1,1)-1)+1)","v":""},{"$f":"_xlfn.IFS(B23=\"\",\"\",B23<$C22,B23+1,B23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(C23=\"\",\"\",C23<$C22,C23+1,C23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(D23=\"\",\"\",D23<$C22,D23+1,D23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(E23=\"\",\"\",E23<$C22,E23+1,E23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(F23=\"\",\"\",F23<$C22,F23+1,F23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(G23=\"\",\"\",G23<$C22,G23+1,G23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(H23=\"\",\"\",H23<$C22,H23+1,H23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(I23=\"\",\"\",I23<$C22,I23+1,I23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(J23=\"\",\"\",J23<$C22,J23+1,J23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(K23=\"\",\"\",K23<$C22,K23+1,K23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(L23=\"\",\"\",L23<$C22,L23+1,L23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(M23=\"\",\"\",M23<$C22,M23+1,M23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(N23=\"\",\"\",N23<$C22,N23+1,N23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(O23=\"\",\"\",O23<$C22,O23+1,O23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(P23=\"\",\"\",P23<$C22,P23+1,P23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(Q23=\"\",\"\",Q23<$C22,Q23+1,Q23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(R23=\"\",\"\",R23<$C22,R23+1,R23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(S23=\"\",\"\",S23<$C22,S23+1,S23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(T23=\"\",\"\",T23<$C22,T23+1,T23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(U23=\"\",\"\",U23<$C22,U23+1,U23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(V23=\"\",\"\",V23<$C22,V23+1,V23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(W23=\"\",\"\",W23<$C22,W23+1,W23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(X23=\"\",\"\",X23<$C22,X23+1,X23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(Y23=\"\",\"\",Y23<$C22,Y23+1,Y23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(Z23=\"\",\"\",Z23<$C22,Z23+1,Z23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(AA23=\"\",\"\",AA23<$C22,AA23+1,AA23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(AB23=\"\",\"\",AB23<$C22,AB23+1,AB23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(AC23=\"\",\"\",AC23<$C22,AC23+1,AC23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(AD23=\"\",\"\",AD23<$C22,AD23+1,AD23=$C22,\"\")","v":""},{"$f":"_xlfn.IFS(AE23=\"\",\"\",AE23<$C22,AE23+1,AE23=$C22,\"\")","v":""}]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""}]
[]
["Mars","Nombre de jours",{"$f":"IF(OR($E$5=\"\", $E$5=\"Année\",A35=\"\"),\"Entrer année ou vérifier mois\",DAY(DATE(E31,MONTH(A35&\"1\")+1,1)-1))","v":"Entrer année ou vérifier mois"}]
["Employés",{"$f":"IF(OR($E$5=\"\",$E$5=\"Année\",A35=\"\"),\"\",DAY(DATE($E$5,MONTH(A35&\"1\")+1,1)-1)-DAY(DATE($E$5,MONTH(A35&\"1\")+1,1)-1)+1)","v":""},{"$f":"_xlfn.IFS(B36=\"\",\"\",B36<$C35,B36+1,B36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(C36=\"\",\"\",C36<$C35,C36+1,C36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(D36=\"\",\"\",D36<$C35,D36+1,D36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(E36=\"\",\"\",E36<$C35,E36+1,E36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(F36=\"\",\"\",F36<$C35,F36+1,F36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(G36=\"\",\"\",G36<$C35,G36+1,G36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(H36=\"\",\"\",H36<$C35,H36+1,H36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(I36=\"\",\"\",I36<$C35,I36+1,I36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(J36=\"\",\"\",J36<$C35,J36+1,J36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(K36=\"\",\"\",K36<$C35,K36+1,K36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(L36=\"\",\"\",L36<$C35,L36+1,L36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(M36=\"\",\"\",M36<$C35,M36+1,M36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(N36=\"\",\"\",N36<$C35,N36+1,N36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(O36=\"\",\"\",O36<$C35,O36+1,O36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(P36=\"\",\"\",P36<$C35,P36+1,P36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(Q36=\"\",\"\",Q36<$C35,Q36+1,Q36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(R36=\"\",\"\",R36<$C35,R36+1,R36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(S36=\"\",\"\",S36<$C35,S36+1,S36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(T36=\"\",\"\",T36<$C35,T36+1,T36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(U36=\"\",\"\",U36<$C35,U36+1,U36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(V36=\"\",\"\",V36<$C35,V36+1,V36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(W36=\"\",\"\",W36<$C35,W36+1,W36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(X36=\"\",\"\",X36<$C35,X36+1,X36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(Y36=\"\",\"\",Y36<$C35,Y36+1,Y36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(Z36=\"\",\"\",Z36<$C35,Z36+1,Z36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(AA36=\"\",\"\",AA36<$C35,AA36+1,AA36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(AB36=\"\",\"\",AB36<$C35,AB36+1,AB36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(AC36=\"\",\"\",AC36<$C35,AC36+1,AC36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(AD36=\"\",\"\",AD36<$C35,AD36+1,AD36=$C35,\"\")","v":""},{"$f":"_xlfn.IFS(AE36=\"\",\"\",AE36<$C35,AE36+1,AE36=$C35,\"\")","v":""}]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""}]
[]
["Avril","Nombre de jours",{"$f":"IF(OR($E$5=\"\", $E$5=\"Année\",A48=\"\"),\"Entrer année ou vérifier mois\",DAY(DATE(E44,MONTH(A48&\"1\")+1,1)-1))","v":"Entrer année ou vérifier mois"}]
["Employés",{"$f":"IF(OR($E$5=\"\",$E$5=\"Année\",A48=\"\"),\"\",DAY(DATE($E$5,MONTH(A48&\"1\")+1,1)-1)-DAY(DATE($E$5,MONTH(A48&\"1\")+1,1)-1)+1)","v":""},{"$f":"_xlfn.IFS(B49=\"\",\"\",B49<$C48,B49+1,B49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(C49=\"\",\"\",C49<$C48,C49+1,C49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(D49=\"\",\"\",D49<$C48,D49+1,D49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(E49=\"\",\"\",E49<$C48,E49+1,E49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(F49=\"\",\"\",F49<$C48,F49+1,F49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(G49=\"\",\"\",G49<$C48,G49+1,G49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(H49=\"\",\"\",H49<$C48,H49+1,H49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(I49=\"\",\"\",I49<$C48,I49+1,I49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(J49=\"\",\"\",J49<$C48,J49+1,J49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(K49=\"\",\"\",K49<$C48,K49+1,K49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(L49=\"\",\"\",L49<$C48,L49+1,L49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(M49=\"\",\"\",M49<$C48,M49+1,M49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(N49=\"\",\"\",N49<$C48,N49+1,N49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(O49=\"\",\"\",O49<$C48,O49+1,O49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(P49=\"\",\"\",P49<$C48,P49+1,P49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(Q49=\"\",\"\",Q49<$C48,Q49+1,Q49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(R49=\"\",\"\",R49<$C48,R49+1,R49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(S49=\"\",\"\",S49<$C48,S49+1,S49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(T49=\"\",\"\",T49<$C48,T49+1,T49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(U49=\"\",\"\",U49<$C48,U49+1,U49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(V49=\"\",\"\",V49<$C48,V49+1,V49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(W49=\"\",\"\",W49<$C48,W49+1,W49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(X49=\"\",\"\",X49<$C48,X49+1,X49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(Y49=\"\",\"\",Y49<$C48,Y49+1,Y49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(Z49=\"\",\"\",Z49<$C48,Z49+1,Z49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(AA49=\"\",\"\",AA49<$C48,AA49+1,AA49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(AB49=\"\",\"\",AB49<$C48,AB49+1,AB49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(AC49=\"\",\"\",AC49<$C48,AC49+1,AC49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(AD49=\"\",\"\",AD49<$C48,AD49+1,AD49=$C48,\"\")","v":""},{"$f":"_xlfn.IFS(AE49=\"\",\"\",AE49<$C48,AE49+1,AE49=$C48,\"\")","v":""}]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""}]
[]
["Mai","Nombre de jours",{"$f":"IF(OR($E$5=\"\", $E$5=\"Année\",A61=\"\"),\"Entrer année ou vérifier mois\",DAY(DATE(E57,MONTH(A61&\"1\")+1,1)-1))","v":"Entrer année ou vérifier mois"}]
["Employés",{"$f":"IF(OR($E$5=\"\",$E$5=\"Année\",A61=\"\"),\"\",DAY(DATE($E$5,MONTH(A61&\"1\")+1,1)-1)-DAY(DATE($E$5,MONTH(A61&\"1\")+1,1)-1)+1)","v":""},{"$f":"_xlfn.IFS(B62=\"\",\"\",B62<$C61,B62+1,B62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(C62=\"\",\"\",C62<$C61,C62+1,C62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(D62=\"\",\"\",D62<$C61,D62+1,D62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(E62=\"\",\"\",E62<$C61,E62+1,E62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(F62=\"\",\"\",F62<$C61,F62+1,F62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(G62=\"\",\"\",G62<$C61,G62+1,G62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(H62=\"\",\"\",H62<$C61,H62+1,H62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(I62=\"\",\"\",I62<$C61,I62+1,I62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(J62=\"\",\"\",J62<$C61,J62+1,J62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(K62=\"\",\"\",K62<$C61,K62+1,K62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(L62=\"\",\"\",L62<$C61,L62+1,L62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(M62=\"\",\"\",M62<$C61,M62+1,M62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(N62=\"\",\"\",N62<$C61,N62+1,N62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(O62=\"\",\"\",O62<$C61,O62+1,O62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(P62=\"\",\"\",P62<$C61,P62+1,P62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(Q62=\"\",\"\",Q62<$C61,Q62+1,Q62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(R62=\"\",\"\",R62<$C61,R62+1,R62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(S62=\"\",\"\",S62<$C61,S62+1,S62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(T62=\"\",\"\",T62<$C61,T62+1,T62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(U62=\"\",\"\",U62<$C61,U62+1,U62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(V62=\"\",\"\",V62<$C61,V62+1,V62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(W62=\"\",\"\",W62<$C61,W62+1,W62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(X62=\"\",\"\",X62<$C61,X62+1,X62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(Y62=\"\",\"\",Y62<$C61,Y62+1,Y62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(Z62=\"\",\"\",Z62<$C61,Z62+1,Z62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(AA62=\"\",\"\",AA62<$C61,AA62+1,AA62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(AB62=\"\",\"\",AB62<$C61,AB62+1,AB62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(AC62=\"\",\"\",AC62<$C61,AC62+1,AC62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(AD62=\"\",\"\",AD62<$C61,AD62+1,AD62=$C61,\"\")","v":""},{"$f":"_xlfn.IFS(AE62=\"\",\"\",AE62<$C61,AE62+1,AE62=$C61,\"\")","v":""}]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""}]
[]
["Juin","Nombre de jours",{"$f":"IF(OR($E$5=\"\", $E$5=\"Année\",A74=\"\"),\"Entrer année ou vérifier mois\",DAY(DATE(E70,MONTH(A74&\"1\")+1,1)-1))","v":"Entrer année ou vérifier mois"}]
["Employés",{"$f":"IF(OR($E$5=\"\",$E$5=\"Année\",A74=\"\"),\"\",DAY(DATE($E$5,MONTH(A74&\"1\")+1,1)-1)-DAY(DATE($E$5,MONTH(A74&\"1\")+1,1)-1)+1)","v":""},{"$f":"_xlfn.IFS(B75=\"\",\"\",B75<$C74,B75+1,B75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(C75=\"\",\"\",C75<$C74,C75+1,C75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(D75=\"\",\"\",D75<$C74,D75+1,D75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(E75=\"\",\"\",E75<$C74,E75+1,E75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(F75=\"\",\"\",F75<$C74,F75+1,F75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(G75=\"\",\"\",G75<$C74,G75+1,G75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(H75=\"\",\"\",H75<$C74,H75+1,H75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(I75=\"\",\"\",I75<$C74,I75+1,I75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(J75=\"\",\"\",J75<$C74,J75+1,J75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(K75=\"\",\"\",K75<$C74,K75+1,K75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(L75=\"\",\"\",L75<$C74,L75+1,L75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(M75=\"\",\"\",M75<$C74,M75+1,M75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(N75=\"\",\"\",N75<$C74,N75+1,N75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(O75=\"\",\"\",O75<$C74,O75+1,O75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(P75=\"\",\"\",P75<$C74,P75+1,P75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(Q75=\"\",\"\",Q75<$C74,Q75+1,Q75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(R75=\"\",\"\",R75<$C74,R75+1,R75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(S75=\"\",\"\",S75<$C74,S75+1,S75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(T75=\"\",\"\",T75<$C74,T75+1,T75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(U75=\"\",\"\",U75<$C74,U75+1,U75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(V75=\"\",\"\",V75<$C74,V75+1,V75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(W75=\"\",\"\",W75<$C74,W75+1,W75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(X75=\"\",\"\",X75<$C74,X75+1,X75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(Y75=\"\",\"\",Y75<$C74,Y75+1,Y75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(Z75=\"\",\"\",Z75<$C74,Z75+1,Z75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(AA75=\"\",\"\",AA75<$C74,AA75+1,AA75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(AB75=\"\",\"\",AB75<$C74,AB75+1,AB75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(AC75=\"\",\"\",AC75<$C74,AC75+1,AC75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(AD75=\"\",\"\",AD75<$C74,AD75+1,AD75=$C74,\"\")","v":""},{"$f":"_xlfn.IFS(AE75=\"\",\"\",AE75<$C74,AE75+1,AE75=$C74,\"\")","v":""}]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""}]
[]
["Juillet","Nombre de jours",{"$f":"IF(OR($E$5=\"\", $E$5=\"Année\",A87=\"\"),\"Entrer année ou vérifier mois\",DAY(DATE(E83,MONTH(A87&\"1\")+1,1)-1))","v":"Entrer année ou vérifier mois"}]
["Employés",{"$f":"IF(OR($E$5=\"\",$E$5=\"Année\",A87=\"\"),\"\",DAY(DATE($E$5,MONTH(A87&\"1\")+1,1)-1)-DAY(DATE($E$5,MONTH(A87&\"1\")+1,1)-1)+1)","v":""},{"$f":"_xlfn.IFS(B88=\"\",\"\",B88<$C87,B88+1,B88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(C88=\"\",\"\",C88<$C87,C88+1,C88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(D88=\"\",\"\",D88<$C87,D88+1,D88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(E88=\"\",\"\",E88<$C87,E88+1,E88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(F88=\"\",\"\",F88<$C87,F88+1,F88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(G88=\"\",\"\",G88<$C87,G88+1,G88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(H88=\"\",\"\",H88<$C87,H88+1,H88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(I88=\"\",\"\",I88<$C87,I88+1,I88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(J88=\"\",\"\",J88<$C87,J88+1,J88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(K88=\"\",\"\",K88<$C87,K88+1,K88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(L88=\"\",\"\",L88<$C87,L88+1,L88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(M88=\"\",\"\",M88<$C87,M88+1,M88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(N88=\"\",\"\",N88<$C87,N88+1,N88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(O88=\"\",\"\",O88<$C87,O88+1,O88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(P88=\"\",\"\",P88<$C87,P88+1,P88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(Q88=\"\",\"\",Q88<$C87,Q88+1,Q88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(R88=\"\",\"\",R88<$C87,R88+1,R88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(S88=\"\",\"\",S88<$C87,S88+1,S88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(T88=\"\",\"\",T88<$C87,T88+1,T88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(U88=\"\",\"\",U88<$C87,U88+1,U88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(V88=\"\",\"\",V88<$C87,V88+1,V88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(W88=\"\",\"\",W88<$C87,W88+1,W88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(X88=\"\",\"\",X88<$C87,X88+1,X88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(Y88=\"\",\"\",Y88<$C87,Y88+1,Y88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(Z88=\"\",\"\",Z88<$C87,Z88+1,Z88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(AA88=\"\",\"\",AA88<$C87,AA88+1,AA88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(AB88=\"\",\"\",AB88<$C87,AB88+1,AB88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(AC88=\"\",\"\",AC88<$C87,AC88+1,AC88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(AD88=\"\",\"\",AD88<$C87,AD88+1,AD88=$C87,\"\")","v":""},{"$f":"_xlfn.IFS(AE88=\"\",\"\",AE88<$C87,AE88+1,AE88=$C87,\"\")","v":""}]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""}]
[]
["Août","Nombre de jours",{"$f":"IF(OR($E$5=\"\", $E$5=\"Année\",A100=\"\"),\"Entrer année ou vérifier mois\",DAY(DATE(E96,MONTH(A100&\"1\")+1,1)-1))","v":"Entrer année ou vérifier mois"}]
["Employés",{"$f":"IF(OR($E$5=\"\",$E$5=\"Année\",A100=\"\"),\"\",DAY(DATE($E$5,MONTH(A100&\"1\")+1,1)-1)-DAY(DATE($E$5,MONTH(A100&\"1\")+1,1)-1)+1)","v":""},{"$f":"_xlfn.IFS(B101=\"\",\"\",B101<$C100,B101+1,B101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(C101=\"\",\"\",C101<$C100,C101+1,C101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(D101=\"\",\"\",D101<$C100,D101+1,D101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(E101=\"\",\"\",E101<$C100,E101+1,E101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(F101=\"\",\"\",F101<$C100,F101+1,F101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(G101=\"\",\"\",G101<$C100,G101+1,G101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(H101=\"\",\"\",H101<$C100,H101+1,H101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(I101=\"\",\"\",I101<$C100,I101+1,I101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(J101=\"\",\"\",J101<$C100,J101+1,J101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(K101=\"\",\"\",K101<$C100,K101+1,K101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(L101=\"\",\"\",L101<$C100,L101+1,L101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(M101=\"\",\"\",M101<$C100,M101+1,M101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(N101=\"\",\"\",N101<$C100,N101+1,N101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(O101=\"\",\"\",O101<$C100,O101+1,O101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(P101=\"\",\"\",P101<$C100,P101+1,P101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(Q101=\"\",\"\",Q101<$C100,Q101+1,Q101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(R101=\"\",\"\",R101<$C100,R101+1,R101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(S101=\"\",\"\",S101<$C100,S101+1,S101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(T101=\"\",\"\",T101<$C100,T101+1,T101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(U101=\"\",\"\",U101<$C100,U101+1,U101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(V101=\"\",\"\",V101<$C100,V101+1,V101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(W101=\"\",\"\",W101<$C100,W101+1,W101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(X101=\"\",\"\",X101<$C100,X101+1,X101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(Y101=\"\",\"\",Y101<$C100,Y101+1,Y101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(Z101=\"\",\"\",Z101<$C100,Z101+1,Z101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(AA101=\"\",\"\",AA101<$C100,AA101+1,AA101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(AB101=\"\",\"\",AB101<$C100,AB101+1,AB101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(AC101=\"\",\"\",AC101<$C100,AC101+1,AC101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(AD101=\"\",\"\",AD101<$C100,AD101+1,AD101=$C100,\"\")","v":""},{"$f":"_xlfn.IFS(AE101=\"\",\"\",AE101<$C100,AE101+1,AE101=$C100,\"\")","v":""}]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""}]
[]
["Septembre","Nombre de jours",{"$f":"IF(OR($E$5=\"\", $E$5=\"Année\",A113=\"\"),\"Entrer année ou vérifier mois\",DAY(DATE(E109,MONTH(A113&\"1\")+1,1)-1))","v":"Entrer année ou vérifier mois"}]
["Employés",{"$f":"IF(OR($E$5=\"\",$E$5=\"Année\",A113=\"\"),\"\",DAY(DATE($E$5,MONTH(A113&\"1\")+1,1)-1)-DAY(DATE($E$5,MONTH(A113&\"1\")+1,1)-1)+1)","v":""},{"$f":"_xlfn.IFS(B114=\"\",\"\",B114<$C113,B114+1,B114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(C114=\"\",\"\",C114<$C113,C114+1,C114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(D114=\"\",\"\",D114<$C113,D114+1,D114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(E114=\"\",\"\",E114<$C113,E114+1,E114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(F114=\"\",\"\",F114<$C113,F114+1,F114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(G114=\"\",\"\",G114<$C113,G114+1,G114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(H114=\"\",\"\",H114<$C113,H114+1,H114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(I114=\"\",\"\",I114<$C113,I114+1,I114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(J114=\"\",\"\",J114<$C113,J114+1,J114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(K114=\"\",\"\",K114<$C113,K114+1,K114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(L114=\"\",\"\",L114<$C113,L114+1,L114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(M114=\"\",\"\",M114<$C113,M114+1,M114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(N114=\"\",\"\",N114<$C113,N114+1,N114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(O114=\"\",\"\",O114<$C113,O114+1,O114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(P114=\"\",\"\",P114<$C113,P114+1,P114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(Q114=\"\",\"\",Q114<$C113,Q114+1,Q114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(R114=\"\",\"\",R114<$C113,R114+1,R114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(S114=\"\",\"\",S114<$C113,S114+1,S114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(T114=\"\",\"\",T114<$C113,T114+1,T114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(U114=\"\",\"\",U114<$C113,U114+1,U114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(V114=\"\",\"\",V114<$C113,V114+1,V114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(W114=\"\",\"\",W114<$C113,W114+1,W114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(X114=\"\",\"\",X114<$C113,X114+1,X114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(Y114=\"\",\"\",Y114<$C113,Y114+1,Y114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(Z114=\"\",\"\",Z114<$C113,Z114+1,Z114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(AA114=\"\",\"\",AA114<$C113,AA114+1,AA114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(AB114=\"\",\"\",AB114<$C113,AB114+1,AB114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(AC114=\"\",\"\",AC114<$C113,AC114+1,AC114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(AD114=\"\",\"\",AD114<$C113,AD114+1,AD114=$C113,\"\")","v":""},{"$f":"_xlfn.IFS(AE114=\"\",\"\",AE114<$C113,AE114+1,AE114=$C113,\"\")","v":""}]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""}]
[]
["Octobre","Nombre de jours",{"$f":"IF(OR($E$5=\"\", $E$5=\"Année\",A126=\"\"),\"Entrer année ou vérifier mois\",DAY(DATE(E122,MONTH(A126&\"1\")+1,1)-1))","v":"Entrer année ou vérifier mois"}]
["Employés",{"$f":"IF(OR($E$5=\"\",$E$5=\"Année\",A126=\"\"),\"\",DAY(DATE($E$5,MONTH(A126&\"1\")+1,1)-1)-DAY(DATE($E$5,MONTH(A126&\"1\")+1,1)-1)+1)","v":""},{"$f":"_xlfn.IFS(B127=\"\",\"\",B127<$C126,B127+1,B127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(C127=\"\",\"\",C127<$C126,C127+1,C127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(D127=\"\",\"\",D127<$C126,D127+1,D127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(E127=\"\",\"\",E127<$C126,E127+1,E127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(F127=\"\",\"\",F127<$C126,F127+1,F127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(G127=\"\",\"\",G127<$C126,G127+1,G127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(H127=\"\",\"\",H127<$C126,H127+1,H127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(I127=\"\",\"\",I127<$C126,I127+1,I127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(J127=\"\",\"\",J127<$C126,J127+1,J127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(K127=\"\",\"\",K127<$C126,K127+1,K127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(L127=\"\",\"\",L127<$C126,L127+1,L127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(M127=\"\",\"\",M127<$C126,M127+1,M127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(N127=\"\",\"\",N127<$C126,N127+1,N127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(O127=\"\",\"\",O127<$C126,O127+1,O127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(P127=\"\",\"\",P127<$C126,P127+1,P127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(Q127=\"\",\"\",Q127<$C126,Q127+1,Q127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(R127=\"\",\"\",R127<$C126,R127+1,R127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(S127=\"\",\"\",S127<$C126,S127+1,S127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(T127=\"\",\"\",T127<$C126,T127+1,T127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(U127=\"\",\"\",U127<$C126,U127+1,U127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(V127=\"\",\"\",V127<$C126,V127+1,V127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(W127=\"\",\"\",W127<$C126,W127+1,W127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(X127=\"\",\"\",X127<$C126,X127+1,X127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(Y127=\"\",\"\",Y127<$C126,Y127+1,Y127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(Z127=\"\",\"\",Z127<$C126,Z127+1,Z127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(AA127=\"\",\"\",AA127<$C126,AA127+1,AA127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(AB127=\"\",\"\",AB127<$C126,AB127+1,AB127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(AC127=\"\",\"\",AC127<$C126,AC127+1,AC127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(AD127=\"\",\"\",AD127<$C126,AD127+1,AD127=$C126,\"\")","v":""},{"$f":"_xlfn.IFS(AE127=\"\",\"\",AE127<$C126,AE127+1,AE127=$C126,\"\")","v":""}]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""}]
[]
["Novembre","Nombre de jours",{"$f":"IF(OR($E$5=\"\", $E$5=\"Année\",A139=\"\"),\"Entrer année ou vérifier mois\",DAY(DATE(E135,MONTH(A139&\"1\")+1,1)-1))","v":"Entrer année ou vérifier mois"}]
["Employés",{"$f":"IF(OR($E$5=\"\",$E$5=\"Année\",A139=\"\"),\"\",DAY(DATE($E$5,MONTH(A139&\"1\")+1,1)-1)-DAY(DATE($E$5,MONTH(A139&\"1\")+1,1)-1)+1)","v":""},{"$f":"_xlfn.IFS(B140=\"\",\"\",B140<$C139,B140+1,B140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(C140=\"\",\"\",C140<$C139,C140+1,C140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(D140=\"\",\"\",D140<$C139,D140+1,D140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(E140=\"\",\"\",E140<$C139,E140+1,E140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(F140=\"\",\"\",F140<$C139,F140+1,F140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(G140=\"\",\"\",G140<$C139,G140+1,G140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(H140=\"\",\"\",H140<$C139,H140+1,H140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(I140=\"\",\"\",I140<$C139,I140+1,I140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(J140=\"\",\"\",J140<$C139,J140+1,J140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(K140=\"\",\"\",K140<$C139,K140+1,K140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(L140=\"\",\"\",L140<$C139,L140+1,L140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(M140=\"\",\"\",M140<$C139,M140+1,M140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(N140=\"\",\"\",N140<$C139,N140+1,N140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(O140=\"\",\"\",O140<$C139,O140+1,O140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(P140=\"\",\"\",P140<$C139,P140+1,P140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(Q140=\"\",\"\",Q140<$C139,Q140+1,Q140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(R140=\"\",\"\",R140<$C139,R140+1,R140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(S140=\"\",\"\",S140<$C139,S140+1,S140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(T140=\"\",\"\",T140<$C139,T140+1,T140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(U140=\"\",\"\",U140<$C139,U140+1,U140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(V140=\"\",\"\",V140<$C139,V140+1,V140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(W140=\"\",\"\",W140<$C139,W140+1,W140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(X140=\"\",\"\",X140<$C139,X140+1,X140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(Y140=\"\",\"\",Y140<$C139,Y140+1,Y140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(Z140=\"\",\"\",Z140<$C139,Z140+1,Z140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(AA140=\"\",\"\",AA140<$C139,AA140+1,AA140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(AB140=\"\",\"\",AB140<$C139,AB140+1,AB140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(AC140=\"\",\"\",AC140<$C139,AC140+1,AC140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(AD140=\"\",\"\",AD140<$C139,AD140+1,AD140=$C139,\"\")","v":""},{"$f":"_xlfn.IFS(AE140=\"\",\"\",AE140<$C139,AE140+1,AE140=$C139,\"\")","v":""}]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""}]
[]
["Décembre","Nombre de jours",{"$f":"IF(OR($E$5=\"\", $E$5=\"Année\",A152=\"\"),\"Entrer année ou vérifier mois\",DAY(DATE(E148,MONTH(A152&\"1\")+1,1)-1))","v":"Entrer année ou vérifier mois"}]
["Employés",{"$f":"IF(OR($E$5=\"\",$E$5=\"Année\",A152=\"\"),\"\",DAY(DATE($E$5,MONTH(A152&\"1\")+1,1)-1)-DAY(DATE($E$5,MONTH(A152&\"1\")+1,1)-1)+1)","v":""},{"$f":"_xlfn.IFS(B153=\"\",\"\",B153<$C152,B153+1,B153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(C153=\"\",\"\",C153<$C152,C153+1,C153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(D153=\"\",\"\",D153<$C152,D153+1,D153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(E153=\"\",\"\",E153<$C152,E153+1,E153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(F153=\"\",\"\",F153<$C152,F153+1,F153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(G153=\"\",\"\",G153<$C152,G153+1,G153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(H153=\"\",\"\",H153<$C152,H153+1,H153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(I153=\"\",\"\",I153<$C152,I153+1,I153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(J153=\"\",\"\",J153<$C152,J153+1,J153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(K153=\"\",\"\",K153<$C152,K153+1,K153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(L153=\"\",\"\",L153<$C152,L153+1,L153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(M153=\"\",\"\",M153<$C152,M153+1,M153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(N153=\"\",\"\",N153<$C152,N153+1,N153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(O153=\"\",\"\",O153<$C152,O153+1,O153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(P153=\"\",\"\",P153<$C152,P153+1,P153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(Q153=\"\",\"\",Q153<$C152,Q153+1,Q153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(R153=\"\",\"\",R153<$C152,R153+1,R153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(S153=\"\",\"\",S153<$C152,S153+1,S153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(T153=\"\",\"\",T153<$C152,T153+1,T153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(U153=\"\",\"\",U153<$C152,U153+1,U153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(V153=\"\",\"\",V153<$C152,V153+1,V153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(W153=\"\",\"\",W153<$C152,W153+1,W153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(X153=\"\",\"\",X153<$C152,X153+1,X153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(Y153=\"\",\"\",Y153<$C152,Y153+1,Y153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(Z153=\"\",\"\",Z153<$C152,Z153+1,Z153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(AA153=\"\",\"\",AA153<$C152,AA153+1,AA153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(AB153=\"\",\"\",AB153<$C152,AB153+1,AB153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(AC153=\"\",\"\",AC153<$C152,AC153+1,AC153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(AD153=\"\",\"\",AD153<$C152,AD153+1,AD153=$C152,\"\")","v":""},{"$f":"_xlfn.IFS(AE153=\"\",\"\",AE153<$C152,AE153+1,AE153=$C152,\"\")","v":""}]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""}]

{"sheet":"Synthèse congés annuel","index":2,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,2,1,7],[3,3,3,6],[4,3,4,6]]}
[null,null,"Synthèse annuelle congés  "]
[]
[]
[null,null,"Service:",{"$f":"'Planning mensuel congés'!$E$4","v":"Nom Service"}]
[null,null,"Année:",{"$f":"'Planning mensuel congés'!$E$5","v":"Année"}]
[]
["Employés","Nombre de jours de congés posés","Nombre de jours de RTT posés","Nombre de jours d'absence autorisée","Nombre de jours de congés sans solde posés","Nombre de jours de maladie","Nombre de jours d'Absence non autorisée","Nombre de jours de \"Autre\" posés"]
[{"$f":" IF(Employés!$E$6=\"\",\"\",Employés!$E$6)","v":""},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A8)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9)+('Planning mensuel congés'!$A$9:$A$10000=$A8)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A8)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$13)+('Planning mensuel congés'!$A$9:$A$10000=$A8)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$14))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A8)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$8)+('Planning mensuel congés'!$A$9:$A$10000=$A8)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$17))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A8)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$12)+('Planning mensuel congés'!$A$9:$A$10000=$A8)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$18))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A8)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$11)+('Planning mensuel congés'!$A$9:$A$10000=$A8)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$19))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A8)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$7)+('Planning mensuel congés'!$A$9:$A$10000=$A8)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$16))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A8)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$6)+('Planning mensuel congés'!$A$9:$A$10000=$A8)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$15))/2)","v":0}]
[{"$f":" IF(Employés!$E$7=\"\",\"\",Employés!$E$7)","v":""},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A9)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9)+('Planning mensuel congés'!$A$9:$A$10000=$A9)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A9)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$13)+('Planning mensuel congés'!$A$9:$A$10000=$A9)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$14))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A9)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$8)+('Planning mensuel congés'!$A$9:$A$10000=$A9)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$17))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A9)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$12)+('Planning mensuel congés'!$A$9:$A$10000=$A9)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$18))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A9)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$11)+('Planning mensuel congés'!$A$9:$A$10000=$A9)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$19))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A9)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$7)+('Planning mensuel congés'!$A$9:$A$10000=$A9)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$16))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A9)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$6)+('Planning mensuel congés'!$A$9:$A$10000=$A9)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$15))/2)","v":0}]
[{"$f":" IF(Employés!$E$8=\"\",\"\",Employés!$E$8)","v":""},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A10)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9)+('Planning mensuel congés'!$A$9:$A$10000=$A10)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A10)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$13)+('Planning mensuel congés'!$A$9:$A$10000=$A10)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$14))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A10)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$8)+('Planning mensuel congés'!$A$9:$A$10000=$A10)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$17))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A10)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$12)+('Planning mensuel congés'!$A$9:$A$10000=$A10)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$18))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A10)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$11)+('Planning mensuel congés'!$A$9:$A$10000=$A10)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$19))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A10)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$7)+('Planning mensuel congés'!$A$9:$A$10000=$A10)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$16))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A10)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$6)+('Planning mensuel congés'!$A$9:$A$10000=$A10)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$15))/2)","v":0}]
[{"$f":" IF(Employés!$E$9=\"\",\"\",Employés!$E$9)","v":""},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A11)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9)+('Planning mensuel congés'!$A$9:$A$10000=$A11)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A11)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$13)+('Planning mensuel congés'!$A$9:$A$10000=$A11)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$14))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A11)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$8)+('Planning mensuel congés'!$A$9:$A$10000=$A11)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$17))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A11)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$12)+('Planning mensuel congés'!$A$9:$A$10000=$A11)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$18))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A11)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$11)+('Planning mensuel congés'!$A$9:$A$10000=$A11)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$19))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A11)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$7)+('Planning mensuel congés'!$A$9:$A$10000=$A11)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$16))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A11)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$6)+('Planning mensuel congés'!$A$9:$A$10000=$A11)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$15))/2)","v":0}]
[{"$f":" IF(Employés!$E$10=\"\",\"\",Employés!$E$10)","v":""},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A12)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9)+('Planning mensuel congés'!$A$9:$A$10000=$A12)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A12)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$13)+('Planning mensuel congés'!$A$9:$A$10000=$A12)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$14))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A12)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$8)+('Planning mensuel congés'!$A$9:$A$10000=$A12)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$17))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A12)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$12)+('Planning mensuel congés'!$A$9:$A$10000=$A12)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$18))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A12)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$11)+('Planning mensuel congés'!$A$9:$A$10000=$A12)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$19))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A12)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$7)+('Planning mensuel congés'!$A$9:$A$10000=$A12)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$16))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A12)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$6)+('Planning mensuel congés'!$A$9:$A$10000=$A12)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$15))/2)","v":0}]
[{"$f":" IF(Employés!$E$11=\"\",\"\",Employés!$E$11)","v":""},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A13)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9)+('Planning mensuel congés'!$A$9:$A$10000=$A13)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A13)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$13)+('Planning mensuel congés'!$A$9:$A$10000=$A13)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$14))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A13)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$8)+('Planning mensuel congés'!$A$9:$A$10000=$A13)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$17))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A13)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$12)+('Planning mensuel congés'!$A$9:$A$10000=$A13)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$18))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A13)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$11)+('Planning mensuel congés'!$A$9:$A$10000=$A13)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$19))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A13)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$7)+('Planning mensuel congés'!$A$9:$A$10000=$A13)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$16))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A13)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$6)+('Planning mensuel congés'!$A$9:$A$10000=$A13)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$15))/2)","v":0}]
[{"$f":" IF(Employés!$E$12=\"\",\"\",Employés!$E$12)","v":""},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A14)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9)+('Planning mensuel congés'!$A$9:$A$10000=$A14)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A14)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$13)+('Planning mensuel congés'!$A$9:$A$10000=$A14)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$14))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A14)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$8)+('Planning mensuel congés'!$A$9:$A$10000=$A14)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$17))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A14)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$12)+('Planning mensuel congés'!$A$9:$A$10000=$A14)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$18))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A14)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$11)+('Planning mensuel congés'!$A$9:$A$10000=$A14)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$19))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A14)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$7)+('Planning mensuel congés'!$A$9:$A$10000=$A14)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$16))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A14)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$6)+('Planning mensuel congés'!$A$9:$A$10000=$A14)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$15))/2)","v":0}]
[{"$f":" IF(Employés!$E$13=\"\",\"\",Employés!$E$13)","v":""},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A15)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9)+('Planning mensuel congés'!$A$9:$A$10000=$A15)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A15)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$13)+('Planning mensuel congés'!$A$9:$A$10000=$A15)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$14))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A15)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$8)+('Planning mensuel congés'!$A$9:$A$10000=$A15)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$17))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A15)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$12)+('Planning mensuel congés'!$A$9:$A$10000=$A15)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$18))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A15)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$11)+('Planning mensuel congés'!$A$9:$A$10000=$A15)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$19))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A15)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$7)+('Planning mensuel congés'!$A$9:$A$10000=$A15)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$16))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A15)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$6)+('Planning mensuel congés'!$A$9:$A$10000=$A15)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$15))/2)","v":0}]
[{"$f":" IF(Employés!$E$14=\"\",\"\",Employés!$E$14)","v":""},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A16)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9)+('Planning mensuel congés'!$A$9:$A$10000=$A16)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A16)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$13)+('Planning mensuel congés'!$A$9:$A$10000=$A16)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$14))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A16)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$8)+('Planning mensuel congés'!$A$9:$A$10000=$A16)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$17))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A16)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$12)+('Planning mensuel congés'!$A$9:$A$10000=$A16)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$18))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A16)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$11)+('Planning mensuel congés'!$A$9:$A$10000=$A16)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$19))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A16)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$7)+('Planning mensuel congés'!$A$9:$A$10000=$A16)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$16))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A16)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$6)+('Planning mensuel congés'!$A$9:$A$10000=$A16)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$15))/2)","v":0}]
[{"$f":" IF(Employés!$E$15=\"\",\"\",Employés!$E$15)","v":""},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A17)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9)+('Planning mensuel congés'!$A$9:$A$10000=$A17)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$9))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A17)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$13)+('Planning mensuel congés'!$A$9:$A$10000=$A17)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$14))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A17)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$8)+('Planning mensuel congés'!$A$9:$A$10000=$A17)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$17))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A17)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$12)+('Planning mensuel congés'!$A$9:$A$10000=$A17)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$18))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A17)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$11)+('Planning mensuel congés'!$A$9:$A$10000=$A17)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$19))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A17)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$7)+('Planning mensuel congés'!$A$9:$A$10000=$A17)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$16))/2)","v":0},{"$f":"SUMPRODUCT(('Planning mensuel congés'!$A$9:$A$10000=$A17)*('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$6)+('Planning mensuel congés'!$A$9:$A$10000=$A17)*(('Planning mensuel congés'!$B$9:$AF$10000=Listes!$G$15))/2)","v":0}]
["TOTAL ",{"$f":"SUM(B8:B17)","v":0},{"$f":"SUM(C8:C17)","v":0},0,0,0,0,0]

{"sheet":"Listes","index":3,"n_rows":84,"n_cols":7,"rows_kept":84,"cut":false,"hidden":true,"merged":[[4,3,4,4],[0,3,2,6]]}
[null,null,null,"Listes "]
[]
[]
[]
[null,"Années",null,"Jours fériés",null,null,"Type d'absence"]
[null,2022,null,"Jour de l'an","2022-01-01",null,"AUTRE"]
[null,2023,null,"Lundi de Pâques",{"$f":"IF(OR('Planning mensuel congés'!$E$5=\"\",'Planning mensuel congés'!$E$5=\"Année\"),\"Entrer année\",(FLOOR(DAY(MINUTE('Planning mensuel congés'!$E$5/38)/2+56)&\"/5/\"&'Planning mensuel congés'!$E$5,7)-34)+1)","v":"Entrer année"},null,"ABS. NON AUT."]
[null,2024,null,"Fête du travail","2022-05-01",null,"ABS. AUT."]
[null,2025,null,"Victoire de 1945","2022-05-08",null,"C."]
[null,2026,null,"Ascension",{"$f":"IF(OR('Planning mensuel congés'!$E$5=\"\",'Planning mensuel congés'!$E$5=\"Année\"),\"Entrer année\",(FLOOR(DAY(MINUTE('Planning mensuel congés'!$E$5/38)/2+56)&\"/5/\"&'Planning mensuel congés'!$E$5,7)-34)+39)","v":"Entrer année"},null,"C./2"]
[null,2027,null,"Lundi de Pentecôte",{"$f":"IF(OR('Planning mensuel congés'!$E$5=\"\",'Planning mensuel congés'!$E$5=\"Année\"),\"Entrer année\",(FLOOR(DAY(MINUTE('Planning mensuel congés'!$E$5/38)/2+56)&\"/5/\"&'Planning mensuel congés'!$E$5,7)-34)+50)","v":"Entrer année"},null,"MAL."]
[null,2028,null,"Fête nationale","2022-07-14",null,"S.S."]
[null,2029,null,"Assomption","2022-08-15",null,"RTT"]
[null,2030,null,"Toussaint","2022-11-01",null,"RTT/2"]
[null,2031,null,"Armistice","2022-11-11",null,"AUTRE/2"]
[null,2032,null,"Nöel","2022-12-25",null,"ABS. NON AUT./2"]
[null,2033,null,null,null,null,"ABS. AUT./2"]
[null,2034,null,null,null,null,"S.S./2"]
[null,2035,null,null,null,null,"MAL./2"]
[null,2036]
[null,2037]
[null,2038]
[null,2039]
[null,2040]
[null,2041]
[null,2042]
[null,2043]
[null,2044]
[null,2045]
[null,2046]
[null,2047]
[null,2048]
[null,2049]
[null,2050]
[null,2051]
[null,2052]
[null,2053]
[null,2054]
[null,2055]
[null,2056]
[null,2057]
[null,2058]
[null,2059]
[null,2060]
[null,2061]
[null,2062]
[null,2063]
[null,2064]
[null,2065]
[null,2066]
[null,2067]
[null,2068]
[null,2069]
[null,2070]
[null,2071]
[null,2072]
[null,2073]
[null,2074]
[null,2075]
[null,2076]
[null,2077]
[null,2078]
[null,2079]
[null,2080]
[null,2081]
[null,2082]
[null,2083]
[null,2084]
[null,2085]
[null,2086]
[null,2087]
[null,2088]
[null,2089]
[null,2090]
[null,2091]
[null,2092]
[null,2093]
[null,2094]
[null,2095]
[null,2096]
[null,2097]
[null,2098]
[null,2099]
[null,2100]

{"sheet":"Instructions","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,3,13,7],[0,2,2,9],[12,3,12,7],[11,3,11,7],[10,3,10,7],[8,3,8,7],[9,3,9,7]]}
[null,null,"Planning congés - Instructions"]
[]
[]
[]
[null,"La saisie de donnée se fait dans l'onglet \"Planning mensuel congés\""]
[null,"L'onglet \"Synthèse congés annuel\" permet d'avoir une vision synthétique du nombre de congé pris par les employés"]
[null,"Un onglet masqué \"Liste\" est disponible pour mettre à jour les listes déroulantes (si besoin)"]
[]
[null,null,"Etape","Description"]
[null,null,1,"Compléter le nom des employées dans l'onglet  \"Employés\" et la colonne \"Liste employés\""]
[null,null,2,"Entrer le nom du service dans l'onglet \"Planning mensuel congés\""]
[null,null,3,"Sélectionner ou compléter l'année dans l'onglet \"Planning mensuel congés\""]
[null,null,4,"Sélectionner à l'aide de la liste déroulante le type d'absence souhaité pour chaque employé dans l'onglet \"Planning mensuel congés\". L'absence s'affiche en une couleur spécifique en fonction de son type"]
[null,null,5,"Si vous souhaitez réinitialiser le fichier, cliquer sur le bouton \"REINITIALISER\" puis sur \"Oui\". Après avoir cliquer sur le bouton \"REINITIALISER\", si vous ne souhaitez plus effectuer cette action, cliquer sur \"Non\" puis sur \"OK\" dans la fenêtre qui s'affichera."]