{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MARS 2021","DATE REF ET JOURS FERIES"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MARS 2021","index":0,"n_rows":49,"n_cols":29,"rows_kept":49,"cut":false,"hidden":false,"merged":[[4,14,6,14],[4,15,6,15],[4,18,6,18],[4,16,6,16],[0,5,2,21],[4,13,6,13],[4,19,6,19],[4,20,6,20],[4,17,6,17],[4,21,6,21],[35,3,41,3],[35,23,41,23],[36,26,36,27],[38,26,38,27],[39,26,46,27],[42,3,48,3],[42,23,48,23],[21,3,27,3],[21,23,27,23],[24,26,25,26],[24,27,25,27],[28,3,34,3],[28,23,34,23],[14,23,20,23],[0,23,1,27],[0,29,0,30],[4,24,6,24],[6,26,6,27],[7,23,13,23],[4,23,5,23],[4,0,5,0],[4,4,5,5],[4,12,6,12],[14,3,20,3],[7,3,13,3],[4,10,5,11],[4,6,6,6],[4,7,6,7],[4,8,6,8],[4,9,6,9]]}
[null,null,null,"Num Mois",null,{"$f":"DATE('DATE REF ET JOURS FERIES'!D1,D2,1)","v":"2021-03-01"}]
["Année 8 pour changer",null,null,3]
["Base journalière"]
[0.29166666666666669]
[null,null,null,null,"Horaires journée entière ou période 1",null,"Total Journée ou période 1","NUIT 0:00 à 6:00","JOUR 06:00 à 22:00","SOIR  22:00 à 24:00","Horaires si période 2",null,"Total heures si période 2","NUIT 0:00 à 6:00","JOUR 06:00 à 22:00","SOIR  22:00 à 24:00","TOTAL JOURNEE ENTIERE","Veille couchée   -3h si nuit >= 5 h","TOTAL 0:00 à 6:00","TOTAL 06:00 à 22:00","TOTAL  22:00 à 24:00","Total heures - les heures couchées ",null," Heures effectuées ","Observations (CT - CA - AM)"]
[]
["TOTAL",null,null,{"$f":"SUM(D8:D39)","v":6.7083333333333339},"Début","Fin",null,null,null,null,"Début","Fin",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X8:X49)","v":0.87500000000000011},null,null,"Récapitulatif",null,{"$f":"X7","v":0.87500000000000011}]
[{"$f":"IF(WEEKDAY(F1,2)=1,F1,\"\")","v":"2021-03-01"},{"$f":"IF(A8=\"\",\"\",IF(AND(ISERROR(VLOOKUP(A8,fériés,1,FALSE)),WEEKDAY(A8,2)<=5),\"\",IF(WEEKDAY(A8,2)=6,\"S\",IF(WEEKDAY(A8,2)=7,\"D\",IF(VLOOKUP(A8,fériés,1,FALSE),\"F\",\"\")))))","v":""},{"$f":"IF(A8=\"\",\"\",IF(AND(A8<>\"\",NETWORKDAYS(A8,A8,fériés)=1),1,\"\"))","v":1},{"$f":"IF(SUM(C8:C14)=0,\"\",SUM(C8:C14)*$A$4)","v":1.4583333333333335},0,0.41666666666666669,{"$f":"IF(AND($A8<>\"\",E8<>\"\",F8<>\"\"),IF(E8=F8,24/24,IF(F8<E8,MOD(F8-E8,1),F8-E8)),\"\")","v":0.41666666666666669},{"$f":"IF(G8=\"\",\"\",IF(AND(E8<F8,E8>=0/24,F8<=6/24),F8-E8,IF(OR(AND(E8<F8,E8<6/24,F8<=22/24),AND(E8<F8,E8<6/24,F8<=24/24)),6/24-E8,IF(AND(E8<F8,E8<6/24,F8<=6/24),(6/24-E8)+(6/24-F8),IF(OR(AND(E8<F8,E8>=6/24,F8<=22/24),AND(E8<F8,E8>=6/24,E8<22/24,F8>22/24,F8<=24/24),AND(E8<F8,E8>=22/24,F8<=24/24)),\"\",IF(OR(AND(E8>F8,E8>=6/24,E8<22/24,F8>0/24,F8<=6/24),AND(E8>F8,E8>=22/24,F8>0/24,F8<=6/24)),F8,IF(OR(AND(E8>F8,E8>=6/24,E8<22/24,F8>6/24,F8<=22/24),AND(E8>F8,E8>=22/24,F8>0/24,F8<=22/24),AND(E8=F8,E8>=6/24),AND(E8=F8,E8>=22/24)),6/24,IF(AND(E8=F8,E8<6/24),(6/24-E8)+F8,\"\"))))))))","v":"06:00:00"},{"$f":"IF(G8=\"\",\"\",IF(OR(AND(E8<F8,E8>=0/24,F8<=6/24),AND(E8<F8,E8>=22/24,F8<=24/24),AND(E8>F8,E8>=22/24,F8>0/24,F8<=6/24)),\"\",IF(OR(AND(E8<F8,E8<6/24,F8<=22/24),AND(E8>F8,E8>=22/24,F8>0/24,F8<=22/24)),F8-6/24,IF(OR(AND(E8<F8,E8<6/24,F8<=24/24),AND(E8<F8,E8<6/24,F8<=6/24),AND(E8=F8,E8<6/24),AND(E8=F8,E8>=22/24)),16/24,IF(AND(E8<F8,E8>=6/24,F8<=22/24),F8-E8,IF(OR(AND(E8<F8,E8>=6/24,E8<22/24,F8>22/24,F8<=24/24),AND(E8>F8,E8>=6/24,E8<22/24,F8>0/24,F8<=6/24)),22/24-E8,IF(AND(E8>F8,E8>=6/24,E8<22/24,F8>6/24,F8<=22/24),(22/24-E8)+(F8-6/24),IF(AND(E8=F8,E8>=6/24),(22/24-E8)+(F8-6/24),\"\"))))))))","v":"04:00:00"},{"$f":"IF(G8=\"\",\"\",IF(OR(AND(E8<F8,E8>=0/24,F8<=6/24),AND(E8<F8,E8<6/24,F8<=22/24),AND(E8<F8,E8>=6/24,F8<=22/24)),\"\",IF(OR(AND(E8<F8,E8<6/24,F8<=24/24),AND(E8<F8,E8>=6/24,E8<22/24,F8>22/24,F8<=24/24)),F8-22/24,IF(OR(AND(E8<F8,E8<6/24,F8<=6/24),AND(E8>F8,E8>=6/24,E8<22/24,F8>0/24,F8<=6/24),AND(E8>F8,E8>=6/24,E8<22/24,F8>6/24,F8<=22/24),AND(E8=F8,E8<6/24),AND(E8=F8,E8>=6/24)),2/24,IF(AND(E8<F8,E8>=22/24,F8<=24/24),F8-E8,IF(OR(AND(E8>F8,E8>=22/24,F8>0/24,F8<=6/24),AND(E8>F8,E8>=22/24,F8>0/24,F8<=22/24)),24/24-E8,IF(AND(E8=F8,E8>=22/24),(24/24-E8)+(F8-22/24),\"\")))))))","v":""},0.58333333333333337,0.70833333333333337,{"$f":"IF(AND($A8<>\"\",K8<>\"\",L8<>\"\"),IF(K8=L8,24/24,IF(L8<K8,MOD(L8-K8,1),L8-K8)),\"\")","v":0.125},{"$f":"IF(M8=\"\",\"\",IF(AND(K8<L8,K8>=0/24,L8<=6/24),L8-K8,IF(OR(AND(K8<L8,K8<6/24,L8<=22/24),AND(K8<L8,K8<6/24,L8<=24/24)),6/24-K8,IF(AND(K8<L8,K8<6/24,L8<=6/24),(6/24-K8)+(6/24-L8),IF(OR(AND(K8<L8,K8>=6/24,L8<=22/24),AND(K8<L8,K8>=6/24,K8<22/24,L8>22/24,L8<=24/24),AND(K8<L8,K8>=22/24,L8<=24/24)),\"\",IF(OR(AND(K8>L8,K8>=6/24,K8<22/24,L8>0/24,L8<=6/24),AND(K8>L8,K8>=22/24,L8>0/24,L8<=6/24)),L8,IF(OR(AND(K8>L8,K8>=6/24,K8<22/24,L8>6/24,L8<=22/24),AND(K8>L8,K8>=22/24,L8>0/24,L8<=22/24),AND(K8=L8,K8>=6/24),AND(K8=L8,K8>=22/24)),6/24,IF(AND(K8=L8,K8<6/24),(6/24-K8)+L8,\"\"))))))))","v":""},{"$f":"IF(M8=\"\",\"\",IF(OR(AND(K8<L8,K8>=0/24,L8<=6/24),AND(K8<L8,K8>=22/24,L8<=24/24),AND(K8>L8,K8>=22/24,L8>0/24,L8<=6/24)),\"\",IF(OR(AND(K8<L8,K8<6/24,L8<=22/24),AND(K8>L8,K8>=22/24,L8>0/24,L8<=22/24)),L8-6/24,IF(OR(AND(K8<L8,K8<6/24,L8<=24/24),AND(K8<L8,K8<6/24,L8<=6/24),AND(K8=L8,K8<6/24),AND(K8=L8,K8>=22/24)),16/24,IF(AND(K8<L8,K8>=6/24,L8<=22/24),L8-K8,IF(OR(AND(K8<L8,K8>=6/24,K8<22/24,L8>22/24,L8<=24/24),AND(K8>L8,K8>=6/24,K8<22/24,L8>0/24,L8<=6/24)),22/24-K8,IF(AND(K8>L8,K8>=6/24,K8<22/24,L8>6/24,L8<=22/24),(22/24-K8)+(L8-6/24),IF(AND(K8=L8,K8>=6/24),(22/24-K8)+(L8-6/24),\"\"))))))))","v":"03:00:00"},{"$f":"IF(M8=\"\",\"\",IF(OR(AND(K8<L8,K8>=0/24,L8<=6/24),AND(K8<L8,K8<6/24,L8<=22/24),AND(K8<L8,K8>=6/24,L8<=22/24)),\"\",IF(OR(AND(K8<L8,K8<6/24,L8<=24/24),AND(K8<L8,K8>=6/24,K8<22/24,L8>22/24,L8<=24/24)),L8-22/24,IF(OR(AND(K8<L8,K8<6/24,L8<=6/24),AND(K8>L8,K8>=6/24,K8<22/24,L8>0/24,L8<=6/24),AND(K8>L8,K8>=6/24,K8<22/24,L8>6/24,L8<=22/24),AND(K8=L8,K8<6/24),AND(K8=L8,K8>=6/24)),2/24,IF(AND(K8<L8,K8>=22/24,L8<=24/24),L8-K8,IF(OR(AND(K8>L8,K8>=22/24,L8>0/24,L8<=6/24),AND(K8>L8,K8>=22/24,L8>0/24,L8<=22/24)),24/24-K8,IF(AND(K8=L8,K8>=22/24),(24/24-K8)+(L8-22/24),\"\")))))))","v":""},{"$f":"IF(AND(G8=\"\",M8=\"\"),\"\",SUM(G8,M8))","v":0.54166666666666674},{"$f":"IF(Q8=\"\",\"\",IF(SUM(S8,U8)=\"\",\"\",IF(SUM(S8,U8)>=0.2083333,SUM(S8,U8)-0.125,SUM(S8,U8))))","v":"03:00:00"},{"$f":"IF(AND(H8=\"\",N8=\"\"),\"\",SUM(H8,N8))","v":"06:00:00"},{"$f":"IF(AND(I8=\"\",O8=\"\"),\"\",SUM(I8,O8))","v":"07:00:00"},{"$f":"IF(AND(J8=\"\",P8=\"\"),\"\",SUM(J8,P8))","v":""},{"$f":"IF(SUM(R8,T8)=0,\"\",SUM(R8,T8))","v":"10:00:00"},null,{"$f":"IF(SUM(Q8:Q14)=0,\"\",SUM(Q8:Q14))","v":0.87500000000000011},null,null,"Total heures à effectuer",{"$f":"IF($D$7=0,\"-\",$D$7)","v":6.7083333333333339},{"$f":"D7","v":6.7083333333333339}]
[{"$f":"IF(A8<>\"\",A8+1,IF(WEEKDAY($F$1,2)=2,$F$1,\"\"))","v":"2021-03-02"},"",1,null,0.375,0.70833333333333337,0.33333333333333337,{"$f":"IF(G9=\"\",\"\",IF(AND(E9<F9,E9>=0/24,F9<=6/24),F9-E9,IF(OR(AND(E9<F9,E9<6/24,F9<=22/24),AND(E9<F9,E9<6/24,F9<=24/24)),6/24-E9,IF(AND(E9<F9,E9<6/24,F9<=6/24),(6/24-E9)+(6/24-F9),IF(OR(AND(E9<F9,E9>=6/24,F9<=22/24),AND(E9<F9,E9>=6/24,E9<22/24,F9>22/24,F9<=24/24),AND(E9<F9,E9>=22/24,F9<=24/24)),\"\",IF(OR(AND(E9>F9,E9>=6/24,E9<22/24,F9>0/24,F9<=6/24),AND(E9>F9,E9>=22/24,F9>0/24,F9<=6/24)),F9,IF(OR(AND(E9>F9,E9>=6/24,E9<22/24,F9>6/24,F9<=22/24),AND(E9>F9,E9>=22/24,F9>0/24,F9<=22/24),AND(E9=F9,E9>=6/24),AND(E9=F9,E9>=22/24)),6/24,IF(AND(E9=F9,E9<6/24),(6/24-E9)+F9,\"\"))))))))","v":""},{"$f":"IF(G9=\"\",\"\",IF(OR(AND(E9<F9,E9>=0/24,F9<=6/24),AND(E9<F9,E9>=22/24,F9<=24/24),AND(E9>F9,E9>=22/24,F9>0/24,F9<=6/24)),\"\",IF(OR(AND(E9<F9,E9<6/24,F9<=22/24),AND(E9>F9,E9>=22/24,F9>0/24,F9<=22/24)),F9-6/24,IF(OR(AND(E9<F9,E9<6/24,F9<=24/24),AND(E9<F9,E9<6/24,F9<=6/24),AND(E9=F9,E9<6/24),AND(E9=F9,E9>=22/24)),16/24,IF(AND(E9<F9,E9>=6/24,F9<=22/24),F9-E9,IF(OR(AND(E9<F9,E9>=6/24,E9<22/24,F9>22/24,F9<=24/24),AND(E9>F9,E9>=6/24,E9<22/24,F9>0/24,F9<=6/24)),22/24-E9,IF(AND(E9>F9,E9>=6/24,E9<22/24,F9>6/24,F9<=22/24),(22/24-E9)+(F9-6/24),IF(AND(E9=F9,E9>=6/24),(22/24-E9)+(F9-6/24),\"\"))))))))","v":"08:00:00"},{"$f":"IF(G9=\"\",\"\",IF(OR(AND(E9<F9,E9>=0/24,F9<=6/24),AND(E9<F9,E9<6/24,F9<=22/24),AND(E9<F9,E9>=6/24,F9<=22/24)),\"\",IF(OR(AND(E9<F9,E9<6/24,F9<=24/24),AND(E9<F9,E9>=6/24,E9<22/24,F9>22/24,F9<=24/24)),F9-22/24,IF(OR(AND(E9<F9,E9<6/24,F9<=6/24),AND(E9>F9,E9>=6/24,E9<22/24,F9>0/24,F9<=6/24),AND(E9>F9,E9>=6/24,E9<22/24,F9>6/24,F9<=22/24),AND(E9=F9,E9<6/24),AND(E9=F9,E9>=6/24)),2/24,IF(AND(E9<F9,E9>=22/24,F9<=24/24),F9-E9,IF(OR(AND(E9>F9,E9>=22/24,F9>0/24,F9<=6/24),AND(E9>F9,E9>=22/24,F9>0/24,F9<=22/24)),24/24-E9,IF(AND(E9=F9,E9>=22/24),(24/24-E9)+(F9-22/24),\"\")))))))","v":""},null,null,"","","","",0.33333333333333337,"00:00:00","","08:00:00","","08:00:00",null,null,null,null,"Total heures effectuées",{"$f":"IF(SUM(X7,AB17,AB36,AB25,(AB22*A4))<0,\"-\"&TEXT(SUM(X7,AB17,AB36,AB25,(AB22*A4))*-1,\"[hh]:mm\"),TEXT(SUM(X7,AB17,AB36,AB25,(AB22*A4)),\"[hh]:mm\"))","v":"21:00"},{"$f":"SUM(X7,AB17,AB36,AB25,(AB22*A4))","v":0.87500000000000011}]
[{"$f":"IF(A9<>\"\",A9+1,IF(WEEKDAY($F$1,2)=3,$F$1,\"\"))","v":"2021-03-03"},"",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"Balance mois précédent (+/-)",{"$f":"IF(AC10<0,\"-\"&TEXT(AC10*-1,\"[hh]:mm\"),TEXT(AC10,\"[hh]:mm\"))","v":"00:00"},0]
[{"$f":"IF(A10<>\"\",A10+1,IF(WEEKDAY($F$1,2)=4,$F$1,\"\"))","v":"2021-03-04"},"",1,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",null,null,null,null,"Balance du mois (+/-)",{"$f":"IF(AC11<0,\"-\"&TEXT(AC11*-1,\"[hh]:mm\"),TEXT(AC11,\"[hh]:mm\"))","v":"-140:00"},{"$f":"AC9-AC8+AC10","v":-5.8333333333333339}]
[{"$f":"IF(A11<>\"\",A11+1,IF(WEEKDAY($F$1,2)=5,$F$1,\"\"))","v":"2021-03-05"},"",1,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",null,null,null,null,"Heures supplémentaires payées",0]
[{"$f":"IF(A12<>\"\",A12+1,IF(WEEKDAY($F$1,2)=6,$F$1,\"\"))","v":"2021-03-06"},"S","",null,null,null,null,null,null,null,null,null,"","","","","","","","","","",null,null,null,null,"Nouvelle balance (+/-)",{"$f":"IF(AC13<0,\"-\"&TEXT(AC13*-1,\"[hh]:mm\"),TEXT(AC13,\"[hh]:mm\"))","v":"-140:00"},{"$f":"AC11-AB12","v":-5.8333333333333339}]
[{"$f":"IF(A13<>\"\",A13+1,IF(WEEKDAY($F$1,2)=7,$F$1,\"\"))","v":"2021-03-07"},"D","",null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"Nombre de CT",{"$f":"COUNTIF($Y$8:$Y$49,\"CT\")","v":0}]
[{"$f":"IF(A14+1<EDATE($F$1,1),A14+1,\"\")","v":"2021-03-08"},"",1,{"$f":"SUM(C15:C21)*$A$4","v":1.4583333333333335},null,null,"","","","",null,null,"","","","","","","","","","",null,"",null,null,"Nombre de CA",{"$f":"COUNTIF($Y$8:$Y$49,\"CA\")","v":0}]
["2021-03-09","",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"Arrêt Maladie AM",{"$f":"COUNTIF($Y$8:$Y$49,\"AM\")","v":0}]
["2021-03-10","",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"Heures CA / AM / AUTRES CONGES",{"$f":"SUM(AC17)","v":0},{"$f":"A4*SUM(AB15,AB16,AB21,AB14)","v":0}]
["2021-03-11","",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"Dim. Et jours fériés travaillés ce mois (heures)",{"$f":"AC18","v":0},{"$f":"SUMIF($B$8:$B$49,\"D\",$M$8:$M$49)+SUMIF($B$8:$B$49,\"F\",$M$8:$M$49)","v":0}]
["2021-03-12","",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"Heures samedi travaillées",{"$f":"AC19","v":0},{"$f":"SUMIF($B$8:$B$49,\"S\",$M$8:$M$49)","v":0}]
["2021-03-13","S","",null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"Veilles couchées",{"$f":"IF(AC20<0,\"-\"&TEXT(AC20*-1,\"[hh]:mm\"),TEXT(AC20,\"[hh]:mm\"))","v":"03:00"},{"$f":"SUM(U8:U41,R8:R41)","v":0.125}]
["2021-03-14","D","",null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"Autres congés (Noter le nombre jours et non pas les heures)",0]
["2021-03-15","",1,1.4583333333333335,null,null,"","","","",null,null,"","","","","","","","","","",null,"",null,null,"Jours de camps",0]
["2021-03-16","",1,null,null,null,"","","","",null,null,"","","","","","","","","",""]
["2021-03-17","",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"Veilles debout","Heures"]
["2021-03-18","",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,null,0]
["2021-03-19","",1,null,null,null,"","","","",null,null,"","","","","","","","","",""]
["2021-03-20","S","",null,null,null,"","","","",null,null,"","","","","","","","","",""]
["2021-03-21","D","",null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"Jour et raison du nombre d'heures à ajouter","Heures"]
["2021-03-22","",1,1.4583333333333335,null,null,"","","","",null,null,"","","","","","","","","","",null,"",null,null,null,0]
["2021-03-23","",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,null,0]
["2021-03-24","",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,null,0]
["2021-03-25","",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,null,0]
["2021-03-26","",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,null,0]
["2021-03-27","S","",null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,null,0]
["2021-03-28","D","",null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,null,0]
[{"$f":"IF(A35=\"\",\"\",IF(A35+1<EDATE($F$1,1),A35+1,\"\"))","v":"2021-03-29"},"",1,{"$f":"IF(SUM(C36:C42)=0,\"\",SUM(C36:C42)*$A$4)","v":0.875},null,null,"","","","",null,null,"","","","","","","","","","",null,"",null,null,"TOTAL DES HEURES EN +",{"$f":"SUM(AB29:AB35)","v":0}]
["2021-03-30","",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"ASTREINTES"]
["2021-03-31","",1,null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"Nombre d'astreintes :",0]
["","","",null,null,null,"","","","",null,null,"","","","","","","","","","",null,null,null,null,"Astreinte du 00/00/2021 au 00/00/2021 et du 00/00/2021 au 00/00/2021"]
["","","",null,null,null,"","","","",null,null,"","","","","","","","","",""]
["","","",null,null,null,"","","","",null,null,"","","","","","","","","",""]
["","","",null,null,null,"","","","",null,null,"","","","","","","","","",""]
["","","",{"$f":"IF(SUM(C43:C49)=0,\"\",SUM(C43:C49)*$A$4)","v":""},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,null,"","","","",null,null,"","","","","","","","","",""]
["","","",null,null,null,"","","","",null,null,"","","","","","","","","",""]

{"sheet":"DATE REF ET JOURS FERIES","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["2013-01-01",{"$f":"E1","v":"2021-01-01"},null,2021,{"$f":"DATE(D1,1,1)","v":"2021-01-01"}]
["Pâques",{"$f":"ROUND(DATE(YEAR(B1),4,MOD(234-11*MOD(YEAR(B1),19),30))/7,0)*7-6","v":"2021-04-04"}]
["lundi Pâques",{"$f":"B2+1","v":"2021-04-05"},null,"CHANGER L'ANNEE CI-DESSUS"]
["Ascension",{"$f":"B2+39","v":"2021-05-13"}]
["2013-05-01",{"$f":"DATE(YEAR(B1),5,1)","v":"2021-05-01"}]
["2013-05-08",{"$f":"DATE(YEAR(B1),5,8)","v":"2021-05-08"}]
["Pentecôte",{"$f":"B2+49","v":"2021-05-23"}]
["Lundi de Pentecôte",{"$f":"B2+50","v":"2021-05-24"}]
["2013-07-14",{"$f":"DATE(YEAR(B1),7,14)","v":"2021-07-14"}]
["2013-08-15",{"$f":"DATE(YEAR(B1),8,15)","v":"2021-08-15"}]
["2013-11-01",{"$f":"DATE(YEAR(B1),11,1)","v":"2021-11-01"}]
["2013-11-11",{"$f":"DATE(YEAR(B1),11,11)","v":"2021-11-11"}]
["noël",{"$f":"DATE(YEAR(B1),12,25)","v":"2021-12-25"}]
["2013-01-01",{"$f":"DATE(YEAR(B1)+1,1,1)","v":"2022-01-01"}]