{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Calendrier d’horaire de travail","Travaux et équipes"],"not_rendered":{"defined_names":37},"read":"whole","date_system":"1900"}

{"sheet":"Calendrier d’horaire de travail","index":0,"n_rows":75,"n_cols":39,"rows_kept":75,"merged":[[0,33,0,38],[4,1,5,1],[10,1,11,1],[16,1,17,1],[22,1,23,1],[28,1,29,1],[34,1,35,1],[40,1,41,1],[46,1,47,1],[52,1,53,1],[58,1,59,1],[64,1,65,1],[70,1,71,1]]}
[null,"Calendrier D’HORAIRE DE TRAVAIL",{"$nulls":31},2020]
[]
[{"$nulls":28},"Horaire 1",{"$nulls":3},"Horaire 2",{"$nulls":3},"Horaire 3"]
[]
[null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),1,1)","v":"2020-01-01"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+1)=1),_xlfn.SINGLE(JanSun1)+1,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+2)=1),_xlfn.SINGLE(JanSun1)+2,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+3)=1),_xlfn.SINGLE(JanSun1)+3,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+4)=1),_xlfn.SINGLE(JanSun1)+4,\"\"))","v":"2020-01-01"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+5)=1),_xlfn.SINGLE(JanSun1)+5,\"\"))","v":"2020-01-02"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+6)=1),_xlfn.SINGLE(JanSun1)+6,\"\"))","v":"2020-01-03"},{"$f":"_xlfn.SINGLE(IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1))=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1))=1),JanSun1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+7)=1),_xlfn.SINGLE(JanSun1)+7,\"\")))","v":"2020-01-04"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+1)=1),_xlfn.SINGLE(JanSun1)+1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+8)=1),_xlfn.SINGLE(JanSun1)+8,\"\"))","v":"2020-01-05"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+2)=1),_xlfn.SINGLE(JanSun1)+2,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+9)=1),_xlfn.SINGLE(JanSun1)+9,\"\"))","v":"2020-01-06"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+3)=1),_xlfn.SINGLE(JanSun1)+3,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+10)=1),_xlfn.SINGLE(JanSun1)+10,\"\"))","v":"2020-01-07"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+4)=1),_xlfn.SINGLE(JanSun1)+4,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+11)=1),_xlfn.SINGLE(JanSun1)+11,\"\"))","v":"2020-01-08"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+5)=1),_xlfn.SINGLE(JanSun1)+5,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+12)=1),_xlfn.SINGLE(JanSun1)+12,\"\"))","v":"2020-01-09"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+6)=1),_xlfn.SINGLE(JanSun1)+6,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+13)=1),_xlfn.SINGLE(JanSun1)+13,\"\"))","v":"2020-01-10"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+7)=1),_xlfn.SINGLE(JanSun1)+7,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+14)=1),_xlfn.SINGLE(JanSun1)+14,\"\"))","v":"2020-01-11"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+8)=1),_xlfn.SINGLE(JanSun1)+8,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+15)=1),_xlfn.SINGLE(JanSun1)+15,\"\"))","v":"2020-01-12"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+9)=1),_xlfn.SINGLE(JanSun1)+9,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+16)=1),_xlfn.SINGLE(JanSun1)+16,\"\"))","v":"2020-01-13"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+10)=1),_xlfn.SINGLE(JanSun1)+10,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+17)=1),_xlfn.SINGLE(JanSun1)+17,\"\"))","v":"2020-01-14"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+11)=1),_xlfn.SINGLE(JanSun1)+11,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+18)=1),_xlfn.SINGLE(JanSun1)+18,\"\"))","v":"2020-01-15"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+12)=1),_xlfn.SINGLE(JanSun1)+12,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+19)=1),_xlfn.SINGLE(JanSun1)+19,\"\"))","v":"2020-01-16"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+13)=1),_xlfn.SINGLE(JanSun1)+13,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+20)=1),_xlfn.SINGLE(JanSun1)+20,\"\"))","v":"2020-01-17"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+14)=1),_xlfn.SINGLE(JanSun1)+14,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+21)=1),_xlfn.SINGLE(JanSun1)+21,\"\"))","v":"2020-01-18"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+15)=1),_xlfn.SINGLE(JanSun1)+15,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+22)=1),_xlfn.SINGLE(JanSun1)+22,\"\"))","v":"2020-01-19"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+16)=1),_xlfn.SINGLE(JanSun1)+16,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+23)=1),_xlfn.SINGLE(JanSun1)+23,\"\"))","v":"2020-01-20"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+17)=1),_xlfn.SINGLE(JanSun1)+17,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+24)=1),_xlfn.SINGLE(JanSun1)+24,\"\"))","v":"2020-01-21"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+18)=1),_xlfn.SINGLE(JanSun1)+18,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+25)=1),_xlfn.SINGLE(JanSun1)+25,\"\"))","v":"2020-01-22"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+19)=1),_xlfn.SINGLE(JanSun1)+19,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+26)=1),_xlfn.SINGLE(JanSun1)+26,\"\"))","v":"2020-01-23"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+20)=1),_xlfn.SINGLE(JanSun1)+20,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+27)=1),_xlfn.SINGLE(JanSun1)+27,\"\"))","v":"2020-01-24"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+21)=1),_xlfn.SINGLE(JanSun1)+21,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+28)=1),_xlfn.SINGLE(JanSun1)+28,\"\"))","v":"2020-01-25"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+22)=1),_xlfn.SINGLE(JanSun1)+22,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+29)=1),_xlfn.SINGLE(JanSun1)+29,\"\"))","v":"2020-01-26"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+23)=1),_xlfn.SINGLE(JanSun1)+23,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+30)=1),_xlfn.SINGLE(JanSun1)+30,\"\"))","v":"2020-01-27"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+24)=1),_xlfn.SINGLE(JanSun1)+24,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+31)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+31)=1),_xlfn.SINGLE(JanSun1)+31,\"\"))","v":"2020-01-28"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+25)=1),_xlfn.SINGLE(JanSun1)+25,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+32)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+32)=1),_xlfn.SINGLE(JanSun1)+32,\"\"))","v":"2020-01-29"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+26)=1),_xlfn.SINGLE(JanSun1)+26,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+33)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+33)=1),_xlfn.SINGLE(JanSun1)+33,\"\"))","v":"2020-01-30"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+27)=1),_xlfn.SINGLE(JanSun1)+27,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+34)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+34)=1),_xlfn.SINGLE(JanSun1)+34,\"\"))","v":"2020-01-31"},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+28)=1),_xlfn.SINGLE(JanSun1)+28,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+35)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+35)=1),_xlfn.SINGLE(JanSun1)+35,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+29)=1),_xlfn.SINGLE(JanSun1)+29,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+36)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+36)=1),_xlfn.SINGLE(JanSun1)+36,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JanSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+30)=1),_xlfn.SINGLE(JanSun1)+30,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JanSun1)+37)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JanSun1)+37)=1),_xlfn.SINGLE(JanSun1)+37,\"\"))","v":""}]
[null,null,"Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu"]
[null,{"$f":"IF(Job1_Name=\"\",\"\",Job1_Name)","v":"Poste 1"},{"$f":"IF(OR(NOT(ISNUMBER(C5)),C5<Job1_StartDate),\"\",IF(MID(Job1_Pattern,MOD(C5-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift1_Code,1,IF(MID(Job1_Pattern,MOD(C5-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift2_Code,2,IF(MID(Job1_Pattern,MOD(C5-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift3_Code,3,\"\"))))","v":""},"","","","","","",1,1,1,1,"","",2,2,2,2,"","",1,1,1,"",2,2,2,"","","",1,1,"",2,2,"","",""]
[null,{"$f":"IF(Job2_Name=\"\",\"\",Job2_Name)","v":"Poste 2"},{"$f":"IF(OR(NOT(ISNUMBER(C5)),C5<Job2_StartDate),\"\",IF(MID(Job2_Pattern,MOD(C5-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift1_Code,1,IF(MID(Job2_Pattern,MOD(C5-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift2_Code,2,IF(MID(Job2_Pattern,MOD(C5-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift3_Code,3,\"\"))))","v":""},"","","","","","","","","","","","","","","","",2,2,2,2,"","","","","",1,"","",2,2,2,"","","","",""]
[null,{"$f":"IF(Job3_Name=\"\",\"\",Job3_Name)","v":"Poste 3"},{"$f":"IF(OR(NOT(ISNUMBER(C5)),C5<Job3_StartDate),\"\",IF(MID(Job3_Pattern,MOD(C5-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift1_Code,1,IF(MID(Job3_Pattern,MOD(C5-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift2_Code,2,IF(MID(Job3_Pattern,MOD(C5-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift3_Code,3,\"\"))))","v":""},"","","","","","","","","","","","","","","","","","","","",3,3,"","","","",3,3,"","","","",3,"","",""]
[]
[null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),2,1)","v":"2020-02-01"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+1)=2),_xlfn.SINGLE(FebSun1)+1,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+2)=2),_xlfn.SINGLE(FebSun1)+2,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+3)=2),_xlfn.SINGLE(FebSun1)+3,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+4)=2),_xlfn.SINGLE(FebSun1)+4,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+5)=2),_xlfn.SINGLE(FebSun1)+5,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+6)=2),_xlfn.SINGLE(FebSun1)+6,\"\"))","v":""},{"$f":"_xlfn.SINGLE(IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1))=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1))=2),FebSun1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+7)=2),_xlfn.SINGLE(FebSun1)+7,\"\")))","v":"2020-02-01"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+1)=2),_xlfn.SINGLE(FebSun1)+1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+8)=2),_xlfn.SINGLE(FebSun1)+8,\"\"))","v":"2020-02-02"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+2)=2),_xlfn.SINGLE(FebSun1)+2,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+9)=2),_xlfn.SINGLE(FebSun1)+9,\"\"))","v":"2020-02-03"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+3)=2),_xlfn.SINGLE(FebSun1)+3,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+10)=2),_xlfn.SINGLE(FebSun1)+10,\"\"))","v":"2020-02-04"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+4)=2),_xlfn.SINGLE(FebSun1)+4,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+11)=2),_xlfn.SINGLE(FebSun1)+11,\"\"))","v":"2020-02-05"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+5)=2),_xlfn.SINGLE(FebSun1)+5,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+12)=2),_xlfn.SINGLE(FebSun1)+12,\"\"))","v":"2020-02-06"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+6)=2),_xlfn.SINGLE(FebSun1)+6,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+13)=2),_xlfn.SINGLE(FebSun1)+13,\"\"))","v":"2020-02-07"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+7)=2),_xlfn.SINGLE(FebSun1)+7,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+14)=2),_xlfn.SINGLE(FebSun1)+14,\"\"))","v":"2020-02-08"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+8)=2),_xlfn.SINGLE(FebSun1)+8,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+15)=2),_xlfn.SINGLE(FebSun1)+15,\"\"))","v":"2020-02-09"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+9)=2),_xlfn.SINGLE(FebSun1)+9,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+16)=2),_xlfn.SINGLE(FebSun1)+16,\"\"))","v":"2020-02-10"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+10)=2),_xlfn.SINGLE(FebSun1)+10,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+17)=2),_xlfn.SINGLE(FebSun1)+17,\"\"))","v":"2020-02-11"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+11)=2),_xlfn.SINGLE(FebSun1)+11,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+18)=2),_xlfn.SINGLE(FebSun1)+18,\"\"))","v":"2020-02-12"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+12)=2),_xlfn.SINGLE(FebSun1)+12,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+19)=2),_xlfn.SINGLE(FebSun1)+19,\"\"))","v":"2020-02-13"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+13)=2),_xlfn.SINGLE(FebSun1)+13,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+20)=2),_xlfn.SINGLE(FebSun1)+20,\"\"))","v":"2020-02-14"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+14)=2),_xlfn.SINGLE(FebSun1)+14,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+21)=2),_xlfn.SINGLE(FebSun1)+21,\"\"))","v":"2020-02-15"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+15)=2),_xlfn.SINGLE(FebSun1)+15,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+22)=2),_xlfn.SINGLE(FebSun1)+22,\"\"))","v":"2020-02-16"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+16)=2),_xlfn.SINGLE(FebSun1)+16,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+23)=2),_xlfn.SINGLE(FebSun1)+23,\"\"))","v":"2020-02-17"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+17)=2),_xlfn.SINGLE(FebSun1)+17,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+24)=2),_xlfn.SINGLE(FebSun1)+24,\"\"))","v":"2020-02-18"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+18)=2),_xlfn.SINGLE(FebSun1)+18,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+25)=2),_xlfn.SINGLE(FebSun1)+25,\"\"))","v":"2020-02-19"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+19)=2),_xlfn.SINGLE(FebSun1)+19,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+26)=2),_xlfn.SINGLE(FebSun1)+26,\"\"))","v":"2020-02-20"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+20)=2),_xlfn.SINGLE(FebSun1)+20,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+27)=2),_xlfn.SINGLE(FebSun1)+27,\"\"))","v":"2020-02-21"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+21)=2),_xlfn.SINGLE(FebSun1)+21,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+28)=2),_xlfn.SINGLE(FebSun1)+28,\"\"))","v":"2020-02-22"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+22)=2),_xlfn.SINGLE(FebSun1)+22,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+29)=2),_xlfn.SINGLE(FebSun1)+29,\"\"))","v":"2020-02-23"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+23)=2),_xlfn.SINGLE(FebSun1)+23,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+30)=2),_xlfn.SINGLE(FebSun1)+30,\"\"))","v":"2020-02-24"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+24)=2),_xlfn.SINGLE(FebSun1)+24,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+31)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+31)=2),_xlfn.SINGLE(FebSun1)+31,\"\"))","v":"2020-02-25"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+25)=2),_xlfn.SINGLE(FebSun1)+25,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+32)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+32)=2),_xlfn.SINGLE(FebSun1)+32,\"\"))","v":"2020-02-26"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+26)=2),_xlfn.SINGLE(FebSun1)+26,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+33)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+33)=2),_xlfn.SINGLE(FebSun1)+33,\"\"))","v":"2020-02-27"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+27)=2),_xlfn.SINGLE(FebSun1)+27,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+34)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+34)=2),_xlfn.SINGLE(FebSun1)+34,\"\"))","v":"2020-02-28"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+28)=2),_xlfn.SINGLE(FebSun1)+28,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+35)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+35)=2),_xlfn.SINGLE(FebSun1)+35,\"\"))","v":"2020-02-29"},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+29)=2),_xlfn.SINGLE(FebSun1)+29,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+36)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+36)=2),_xlfn.SINGLE(FebSun1)+36,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(FebSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+30)=2),_xlfn.SINGLE(FebSun1)+30,\"\"),IF(AND(YEAR(_xlfn.SINGLE(FebSun1)+37)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(FebSun1)+37)=2),_xlfn.SINGLE(FebSun1)+37,\"\"))","v":""}]
[null,null,"Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu"]
[null,{"$f":"IF(Job1_Name=\"\",\"\",Job1_Name)","v":"Poste 1"},{"$f":"IF(OR(NOT(ISNUMBER(C11)),C11<Job1_StartDate),\"\",IF(MID(Job1_Pattern,MOD(C11-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift1_Code,1,IF(MID(Job1_Pattern,MOD(C11-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift2_Code,2,IF(MID(Job1_Pattern,MOD(C11-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift3_Code,3,\"\"))))","v":""},"","","","","","","","",1,1,1,1,"","",2,2,2,2,"","",1,1,1,"",2,2,2,"","","",1,1,"",2,"",""]
[null,{"$f":"IF(Job2_Name=\"\",\"\",Job2_Name)","v":"Poste 2"},{"$f":"IF(OR(NOT(ISNUMBER(C11)),C11<Job2_StartDate),\"\",IF(MID(Job2_Pattern,MOD(C11-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift1_Code,1,IF(MID(Job2_Pattern,MOD(C11-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift2_Code,2,IF(MID(Job2_Pattern,MOD(C11-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift3_Code,3,\"\"))))","v":""},"","","","","",1,1,"","","",2,2,"",1,1,"","","",2,2,2,2,"","","","","",1,"","",2,2,2,"","",""]
[null,{"$f":"IF(Job3_Name=\"\",\"\",Job3_Name)","v":"Poste 3"},{"$f":"IF(OR(NOT(ISNUMBER(C11)),C11<Job3_StartDate),\"\",IF(MID(Job3_Pattern,MOD(C11-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift1_Code,1,IF(MID(Job3_Pattern,MOD(C11-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift2_Code,2,IF(MID(Job3_Pattern,MOD(C11-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift3_Code,3,\"\"))))","v":""},"","","","","",3,3,"","","",3,"","","","","","",3,3,"","","",3,3,"","","","",3,3,"","","","","",""]
[]
[null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),3,1)","v":"2020-03-01"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+1)=3),_xlfn.SINGLE(MarSun1)+1,\"\"))","v":"2020-03-01"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+2)=3),_xlfn.SINGLE(MarSun1)+2,\"\"))","v":"2020-03-02"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+3)=3),_xlfn.SINGLE(MarSun1)+3,\"\"))","v":"2020-03-03"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+4)=3),_xlfn.SINGLE(MarSun1)+4,\"\"))","v":"2020-03-04"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+5)=3),_xlfn.SINGLE(MarSun1)+5,\"\"))","v":"2020-03-05"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+6)=3),_xlfn.SINGLE(MarSun1)+6,\"\"))","v":"2020-03-06"},{"$f":"_xlfn.SINGLE(IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1))=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1))=3),MarSun1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+7)=3),_xlfn.SINGLE(MarSun1)+7,\"\")))","v":"2020-03-07"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+1)=3),_xlfn.SINGLE(MarSun1)+1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+8)=3),_xlfn.SINGLE(MarSun1)+8,\"\"))","v":"2020-03-08"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+2)=3),_xlfn.SINGLE(MarSun1)+2,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+9)=3),_xlfn.SINGLE(MarSun1)+9,\"\"))","v":"2020-03-09"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+3)=3),_xlfn.SINGLE(MarSun1)+3,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+10)=3),_xlfn.SINGLE(MarSun1)+10,\"\"))","v":"2020-03-10"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+4)=3),_xlfn.SINGLE(MarSun1)+4,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+11)=3),_xlfn.SINGLE(MarSun1)+11,\"\"))","v":"2020-03-11"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+5)=3),_xlfn.SINGLE(MarSun1)+5,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+12)=3),_xlfn.SINGLE(MarSun1)+12,\"\"))","v":"2020-03-12"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+6)=3),_xlfn.SINGLE(MarSun1)+6,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+13)=3),_xlfn.SINGLE(MarSun1)+13,\"\"))","v":"2020-03-13"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+7)=3),_xlfn.SINGLE(MarSun1)+7,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+14)=3),_xlfn.SINGLE(MarSun1)+14,\"\"))","v":"2020-03-14"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+8)=3),_xlfn.SINGLE(MarSun1)+8,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+15)=3),_xlfn.SINGLE(MarSun1)+15,\"\"))","v":"2020-03-15"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+9)=3),_xlfn.SINGLE(MarSun1)+9,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+16)=3),_xlfn.SINGLE(MarSun1)+16,\"\"))","v":"2020-03-16"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+10)=3),_xlfn.SINGLE(MarSun1)+10,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+17)=3),_xlfn.SINGLE(MarSun1)+17,\"\"))","v":"2020-03-17"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+11)=3),_xlfn.SINGLE(MarSun1)+11,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+18)=3),_xlfn.SINGLE(MarSun1)+18,\"\"))","v":"2020-03-18"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+12)=3),_xlfn.SINGLE(MarSun1)+12,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+19)=3),_xlfn.SINGLE(MarSun1)+19,\"\"))","v":"2020-03-19"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+13)=3),_xlfn.SINGLE(MarSun1)+13,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+20)=3),_xlfn.SINGLE(MarSun1)+20,\"\"))","v":"2020-03-20"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+14)=3),_xlfn.SINGLE(MarSun1)+14,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+21)=3),_xlfn.SINGLE(MarSun1)+21,\"\"))","v":"2020-03-21"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+15)=3),_xlfn.SINGLE(MarSun1)+15,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+22)=3),_xlfn.SINGLE(MarSun1)+22,\"\"))","v":"2020-03-22"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+16)=3),_xlfn.SINGLE(MarSun1)+16,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+23)=3),_xlfn.SINGLE(MarSun1)+23,\"\"))","v":"2020-03-23"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+17)=3),_xlfn.SINGLE(MarSun1)+17,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+24)=3),_xlfn.SINGLE(MarSun1)+24,\"\"))","v":"2020-03-24"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+18)=3),_xlfn.SINGLE(MarSun1)+18,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+25)=3),_xlfn.SINGLE(MarSun1)+25,\"\"))","v":"2020-03-25"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+19)=3),_xlfn.SINGLE(MarSun1)+19,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+26)=3),_xlfn.SINGLE(MarSun1)+26,\"\"))","v":"2020-03-26"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+20)=3),_xlfn.SINGLE(MarSun1)+20,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+27)=3),_xlfn.SINGLE(MarSun1)+27,\"\"))","v":"2020-03-27"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+21)=3),_xlfn.SINGLE(MarSun1)+21,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+28)=3),_xlfn.SINGLE(MarSun1)+28,\"\"))","v":"2020-03-28"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+22)=3),_xlfn.SINGLE(MarSun1)+22,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+29)=3),_xlfn.SINGLE(MarSun1)+29,\"\"))","v":"2020-03-29"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+23)=3),_xlfn.SINGLE(MarSun1)+23,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+30)=3),_xlfn.SINGLE(MarSun1)+30,\"\"))","v":"2020-03-30"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+24)=3),_xlfn.SINGLE(MarSun1)+24,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+31)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+31)=3),_xlfn.SINGLE(MarSun1)+31,\"\"))","v":"2020-03-31"},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+25)=3),_xlfn.SINGLE(MarSun1)+25,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+32)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+32)=3),_xlfn.SINGLE(MarSun1)+32,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+26)=3),_xlfn.SINGLE(MarSun1)+26,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+33)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+33)=3),_xlfn.SINGLE(MarSun1)+33,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+27)=3),_xlfn.SINGLE(MarSun1)+27,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+34)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+34)=3),_xlfn.SINGLE(MarSun1)+34,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+28)=3),_xlfn.SINGLE(MarSun1)+28,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+35)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+35)=3),_xlfn.SINGLE(MarSun1)+35,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+29)=3),_xlfn.SINGLE(MarSun1)+29,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+36)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+36)=3),_xlfn.SINGLE(MarSun1)+36,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(MarSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+30)=3),_xlfn.SINGLE(MarSun1)+30,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MarSun1)+37)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MarSun1)+37)=3),_xlfn.SINGLE(MarSun1)+37,\"\"))","v":""}]
[null,null,"Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu"]
[null,{"$f":"IF(Job1_Name=\"\",\"\",Job1_Name)","v":"Poste 1"},{"$f":"IF(OR(NOT(ISNUMBER(C17)),C17<Job1_StartDate),\"\",IF(MID(Job1_Pattern,MOD(C17-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift1_Code,1,IF(MID(Job1_Pattern,MOD(C17-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift2_Code,2,IF(MID(Job1_Pattern,MOD(C17-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift3_Code,3,\"\"))))","v":2},"","","",1,1,1,1,"","",2,2,2,2,"","",1,1,1,"",2,2,2,"","","",1,1,"",2,2,"","","","","",""]
[null,{"$f":"IF(Job2_Name=\"\",\"\",Job2_Name)","v":"Poste 2"},{"$f":"IF(OR(NOT(ISNUMBER(C17)),C17<Job2_StartDate),\"\",IF(MID(Job2_Pattern,MOD(C17-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift1_Code,1,IF(MID(Job2_Pattern,MOD(C17-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift2_Code,2,IF(MID(Job2_Pattern,MOD(C17-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift3_Code,3,\"\"))))","v":""},1,1,"","","",2,2,"",1,1,"","","",2,2,2,2,"","","","","",1,"","",2,2,2,"","","","","","","",""]
[null,{"$f":"IF(Job3_Name=\"\",\"\",Job3_Name)","v":"Poste 3"},{"$f":"IF(OR(NOT(ISNUMBER(C17)),C17<Job3_StartDate),\"\",IF(MID(Job3_Pattern,MOD(C17-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift1_Code,1,IF(MID(Job3_Pattern,MOD(C17-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift2_Code,2,IF(MID(Job3_Pattern,MOD(C17-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift3_Code,3,\"\"))))","v":3},3,3,"","","",3,"","","","","","",3,3,"","","",3,3,"","","","",3,3,"","","","",3,"","","","","",""]
[]
[null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),4,1)","v":"2020-04-01"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+1)=4),_xlfn.SINGLE(AprSun1)+1,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+2)=4),_xlfn.SINGLE(AprSun1)+2,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+3)=4),_xlfn.SINGLE(AprSun1)+3,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+4)=4),_xlfn.SINGLE(AprSun1)+4,\"\"))","v":"2020-04-01"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+5)=4),_xlfn.SINGLE(AprSun1)+5,\"\"))","v":"2020-04-02"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+6)=4),_xlfn.SINGLE(AprSun1)+6,\"\"))","v":"2020-04-03"},{"$f":"_xlfn.SINGLE(IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1))=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1))=4),AprSun1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+7)=4),_xlfn.SINGLE(AprSun1)+7,\"\")))","v":"2020-04-04"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+1)=4),_xlfn.SINGLE(AprSun1)+1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+8)=4),_xlfn.SINGLE(AprSun1)+8,\"\"))","v":"2020-04-05"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+2)=4),_xlfn.SINGLE(AprSun1)+2,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+9)=4),_xlfn.SINGLE(AprSun1)+9,\"\"))","v":"2020-04-06"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+3)=4),_xlfn.SINGLE(AprSun1)+3,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+10)=4),_xlfn.SINGLE(AprSun1)+10,\"\"))","v":"2020-04-07"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+4)=4),_xlfn.SINGLE(AprSun1)+4,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+11)=4),_xlfn.SINGLE(AprSun1)+11,\"\"))","v":"2020-04-08"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+5)=4),_xlfn.SINGLE(AprSun1)+5,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+12)=4),_xlfn.SINGLE(AprSun1)+12,\"\"))","v":"2020-04-09"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+6)=4),_xlfn.SINGLE(AprSun1)+6,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+13)=4),_xlfn.SINGLE(AprSun1)+13,\"\"))","v":"2020-04-10"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+7)=4),_xlfn.SINGLE(AprSun1)+7,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+14)=4),_xlfn.SINGLE(AprSun1)+14,\"\"))","v":"2020-04-11"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+8)=4),_xlfn.SINGLE(AprSun1)+8,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+15)=4),_xlfn.SINGLE(AprSun1)+15,\"\"))","v":"2020-04-12"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+9)=4),_xlfn.SINGLE(AprSun1)+9,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+16)=4),_xlfn.SINGLE(AprSun1)+16,\"\"))","v":"2020-04-13"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+10)=4),_xlfn.SINGLE(AprSun1)+10,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+17)=4),_xlfn.SINGLE(AprSun1)+17,\"\"))","v":"2020-04-14"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+11)=4),_xlfn.SINGLE(AprSun1)+11,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+18)=4),_xlfn.SINGLE(AprSun1)+18,\"\"))","v":"2020-04-15"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+12)=4),_xlfn.SINGLE(AprSun1)+12,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+19)=4),_xlfn.SINGLE(AprSun1)+19,\"\"))","v":"2020-04-16"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+13)=4),_xlfn.SINGLE(AprSun1)+13,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+20)=4),_xlfn.SINGLE(AprSun1)+20,\"\"))","v":"2020-04-17"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+14)=4),_xlfn.SINGLE(AprSun1)+14,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+21)=4),_xlfn.SINGLE(AprSun1)+21,\"\"))","v":"2020-04-18"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+15)=4),_xlfn.SINGLE(AprSun1)+15,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+22)=4),_xlfn.SINGLE(AprSun1)+22,\"\"))","v":"2020-04-19"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+16)=4),_xlfn.SINGLE(AprSun1)+16,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+23)=4),_xlfn.SINGLE(AprSun1)+23,\"\"))","v":"2020-04-20"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+17)=4),_xlfn.SINGLE(AprSun1)+17,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+24)=4),_xlfn.SINGLE(AprSun1)+24,\"\"))","v":"2020-04-21"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+18)=4),_xlfn.SINGLE(AprSun1)+18,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+25)=4),_xlfn.SINGLE(AprSun1)+25,\"\"))","v":"2020-04-22"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+19)=4),_xlfn.SINGLE(AprSun1)+19,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+26)=4),_xlfn.SINGLE(AprSun1)+26,\"\"))","v":"2020-04-23"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+20)=4),_xlfn.SINGLE(AprSun1)+20,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+27)=4),_xlfn.SINGLE(AprSun1)+27,\"\"))","v":"2020-04-24"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+21)=4),_xlfn.SINGLE(AprSun1)+21,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+28)=4),_xlfn.SINGLE(AprSun1)+28,\"\"))","v":"2020-04-25"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+22)=4),_xlfn.SINGLE(AprSun1)+22,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+29)=4),_xlfn.SINGLE(AprSun1)+29,\"\"))","v":"2020-04-26"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+23)=4),_xlfn.SINGLE(AprSun1)+23,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+30)=4),_xlfn.SINGLE(AprSun1)+30,\"\"))","v":"2020-04-27"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+24)=4),_xlfn.SINGLE(AprSun1)+24,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+31)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+31)=4),_xlfn.SINGLE(AprSun1)+31,\"\"))","v":"2020-04-28"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+25)=4),_xlfn.SINGLE(AprSun1)+25,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+32)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+32)=4),_xlfn.SINGLE(AprSun1)+32,\"\"))","v":"2020-04-29"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+26)=4),_xlfn.SINGLE(AprSun1)+26,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+33)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+33)=4),_xlfn.SINGLE(AprSun1)+33,\"\"))","v":"2020-04-30"},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+27)=4),_xlfn.SINGLE(AprSun1)+27,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+34)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+34)=4),_xlfn.SINGLE(AprSun1)+34,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+28)=4),_xlfn.SINGLE(AprSun1)+28,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+35)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+35)=4),_xlfn.SINGLE(AprSun1)+35,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+29)=4),_xlfn.SINGLE(AprSun1)+29,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+36)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+36)=4),_xlfn.SINGLE(AprSun1)+36,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(AprSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+30)=4),_xlfn.SINGLE(AprSun1)+30,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AprSun1)+37)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AprSun1)+37)=4),_xlfn.SINGLE(AprSun1)+37,\"\"))","v":""}]
[null,null,"Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu"]
[null,{"$f":"IF(Job1_Name=\"\",\"\",Job1_Name)","v":"Poste 1"},{"$f":"IF(OR(NOT(ISNUMBER(C23)),C23<Job1_StartDate),\"\",IF(MID(Job1_Pattern,MOD(C23-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift1_Code,1,IF(MID(Job1_Pattern,MOD(C23-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift2_Code,2,IF(MID(Job1_Pattern,MOD(C23-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift3_Code,3,\"\"))))","v":""},"","","","","",1,1,1,1,"","",2,2,2,2,"","",1,1,1,"",2,2,2,"","","",1,1,"",2,2,"","","",""]
[null,{"$f":"IF(Job2_Name=\"\",\"\",Job2_Name)","v":"Poste 2"},{"$f":"IF(OR(NOT(ISNUMBER(C23)),C23<Job2_StartDate),\"\",IF(MID(Job2_Pattern,MOD(C23-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift1_Code,1,IF(MID(Job2_Pattern,MOD(C23-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift2_Code,2,IF(MID(Job2_Pattern,MOD(C23-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift3_Code,3,\"\"))))","v":""},"","",1,1,"","","",2,2,"",1,1,"","","",2,2,2,2,"","","","","",1,"","",2,2,2,"","","","","",""]
[null,{"$f":"IF(Job3_Name=\"\",\"\",Job3_Name)","v":"Poste 3"},{"$f":"IF(OR(NOT(ISNUMBER(C23)),C23<Job3_StartDate),\"\",IF(MID(Job3_Pattern,MOD(C23-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift1_Code,1,IF(MID(Job3_Pattern,MOD(C23-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift2_Code,2,IF(MID(Job3_Pattern,MOD(C23-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift3_Code,3,\"\"))))","v":""},"","",3,3,"","","",3,"","","","","","",3,3,"","","",3,3,"","","","",3,3,"","","","",3,"","","",""]
[]
[null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),5,1)","v":"2020-05-01"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+1)=5),_xlfn.SINGLE(MaySun1)+1,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+2)=5),_xlfn.SINGLE(MaySun1)+2,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+3)=5),_xlfn.SINGLE(MaySun1)+3,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+4)=5),_xlfn.SINGLE(MaySun1)+4,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+5)=5),_xlfn.SINGLE(MaySun1)+5,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+6)=5),_xlfn.SINGLE(MaySun1)+6,\"\"))","v":"2020-05-01"},{"$f":"_xlfn.SINGLE(IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1))=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1))=5),MaySun1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+7)=5),_xlfn.SINGLE(MaySun1)+7,\"\")))","v":"2020-05-02"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+1)=5),_xlfn.SINGLE(MaySun1)+1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+8)=5),_xlfn.SINGLE(MaySun1)+8,\"\"))","v":"2020-05-03"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+2)=5),_xlfn.SINGLE(MaySun1)+2,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+9)=5),_xlfn.SINGLE(MaySun1)+9,\"\"))","v":"2020-05-04"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+3)=5),_xlfn.SINGLE(MaySun1)+3,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+10)=5),_xlfn.SINGLE(MaySun1)+10,\"\"))","v":"2020-05-05"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+4)=5),_xlfn.SINGLE(MaySun1)+4,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+11)=5),_xlfn.SINGLE(MaySun1)+11,\"\"))","v":"2020-05-06"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+5)=5),_xlfn.SINGLE(MaySun1)+5,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+12)=5),_xlfn.SINGLE(MaySun1)+12,\"\"))","v":"2020-05-07"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+6)=5),_xlfn.SINGLE(MaySun1)+6,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+13)=5),_xlfn.SINGLE(MaySun1)+13,\"\"))","v":"2020-05-08"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+7)=5),_xlfn.SINGLE(MaySun1)+7,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+14)=5),_xlfn.SINGLE(MaySun1)+14,\"\"))","v":"2020-05-09"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+8)=5),_xlfn.SINGLE(MaySun1)+8,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+15)=5),_xlfn.SINGLE(MaySun1)+15,\"\"))","v":"2020-05-10"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+9)=5),_xlfn.SINGLE(MaySun1)+9,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+16)=5),_xlfn.SINGLE(MaySun1)+16,\"\"))","v":"2020-05-11"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+10)=5),_xlfn.SINGLE(MaySun1)+10,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+17)=5),_xlfn.SINGLE(MaySun1)+17,\"\"))","v":"2020-05-12"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+11)=5),_xlfn.SINGLE(MaySun1)+11,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+18)=5),_xlfn.SINGLE(MaySun1)+18,\"\"))","v":"2020-05-13"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+12)=5),_xlfn.SINGLE(MaySun1)+12,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+19)=5),_xlfn.SINGLE(MaySun1)+19,\"\"))","v":"2020-05-14"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+13)=5),_xlfn.SINGLE(MaySun1)+13,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+20)=5),_xlfn.SINGLE(MaySun1)+20,\"\"))","v":"2020-05-15"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+14)=5),_xlfn.SINGLE(MaySun1)+14,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+21)=5),_xlfn.SINGLE(MaySun1)+21,\"\"))","v":"2020-05-16"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+15)=5),_xlfn.SINGLE(MaySun1)+15,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+22)=5),_xlfn.SINGLE(MaySun1)+22,\"\"))","v":"2020-05-17"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+16)=5),_xlfn.SINGLE(MaySun1)+16,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+23)=5),_xlfn.SINGLE(MaySun1)+23,\"\"))","v":"2020-05-18"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+17)=5),_xlfn.SINGLE(MaySun1)+17,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+24)=5),_xlfn.SINGLE(MaySun1)+24,\"\"))","v":"2020-05-19"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+18)=5),_xlfn.SINGLE(MaySun1)+18,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+25)=5),_xlfn.SINGLE(MaySun1)+25,\"\"))","v":"2020-05-20"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+19)=5),_xlfn.SINGLE(MaySun1)+19,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+26)=5),_xlfn.SINGLE(MaySun1)+26,\"\"))","v":"2020-05-21"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+20)=5),_xlfn.SINGLE(MaySun1)+20,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+27)=5),_xlfn.SINGLE(MaySun1)+27,\"\"))","v":"2020-05-22"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+21)=5),_xlfn.SINGLE(MaySun1)+21,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+28)=5),_xlfn.SINGLE(MaySun1)+28,\"\"))","v":"2020-05-23"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+22)=5),_xlfn.SINGLE(MaySun1)+22,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+29)=5),_xlfn.SINGLE(MaySun1)+29,\"\"))","v":"2020-05-24"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+23)=5),_xlfn.SINGLE(MaySun1)+23,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+30)=5),_xlfn.SINGLE(MaySun1)+30,\"\"))","v":"2020-05-25"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+24)=5),_xlfn.SINGLE(MaySun1)+24,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+31)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+31)=5),_xlfn.SINGLE(MaySun1)+31,\"\"))","v":"2020-05-26"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+25)=5),_xlfn.SINGLE(MaySun1)+25,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+32)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+32)=5),_xlfn.SINGLE(MaySun1)+32,\"\"))","v":"2020-05-27"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+26)=5),_xlfn.SINGLE(MaySun1)+26,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+33)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+33)=5),_xlfn.SINGLE(MaySun1)+33,\"\"))","v":"2020-05-28"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+27)=5),_xlfn.SINGLE(MaySun1)+27,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+34)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+34)=5),_xlfn.SINGLE(MaySun1)+34,\"\"))","v":"2020-05-29"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+28)=5),_xlfn.SINGLE(MaySun1)+28,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+35)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+35)=5),_xlfn.SINGLE(MaySun1)+35,\"\"))","v":"2020-05-30"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+29)=5),_xlfn.SINGLE(MaySun1)+29,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+36)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+36)=5),_xlfn.SINGLE(MaySun1)+36,\"\"))","v":"2020-05-31"},{"$f":"IF(DAY(_xlfn.SINGLE(MaySun1))=1,IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+30)=5),_xlfn.SINGLE(MaySun1)+30,\"\"),IF(AND(YEAR(_xlfn.SINGLE(MaySun1)+37)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(MaySun1)+37)=5),_xlfn.SINGLE(MaySun1)+37,\"\"))","v":""}]
[null,null,"Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu"]
[null,{"$f":"IF(Job1_Name=\"\",\"\",Job1_Name)","v":"Poste 1"},{"$f":"IF(OR(NOT(ISNUMBER(C29)),C29<Job1_StartDate),\"\",IF(MID(Job1_Pattern,MOD(C29-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift1_Code,1,IF(MID(Job1_Pattern,MOD(C29-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift2_Code,2,IF(MID(Job1_Pattern,MOD(C29-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift3_Code,3,\"\"))))","v":""},"","","","","","","",1,1,1,1,"","",2,2,2,2,"","",1,1,1,"",2,2,2,"","","",1,1,"",2,2,"",""]
[null,{"$f":"IF(Job2_Name=\"\",\"\",Job2_Name)","v":"Poste 2"},{"$f":"IF(OR(NOT(ISNUMBER(C29)),C29<Job2_StartDate),\"\",IF(MID(Job2_Pattern,MOD(C29-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift1_Code,1,IF(MID(Job2_Pattern,MOD(C29-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift2_Code,2,IF(MID(Job2_Pattern,MOD(C29-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift3_Code,3,\"\"))))","v":""},"","","","",1,1,"","","",2,2,"",1,1,"","","",2,2,2,2,"","","","","",1,"","",2,2,2,"","",1,""]
[null,{"$f":"IF(Job3_Name=\"\",\"\",Job3_Name)","v":"Poste 3"},{"$f":"IF(OR(NOT(ISNUMBER(C29)),C29<Job3_StartDate),\"\",IF(MID(Job3_Pattern,MOD(C29-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift1_Code,1,IF(MID(Job3_Pattern,MOD(C29-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift2_Code,2,IF(MID(Job3_Pattern,MOD(C29-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift3_Code,3,\"\"))))","v":""},"","","","",3,3,"","","",3,"","","","","","",3,3,"","","",3,3,"","","","",3,3,"","","","",3,3,""]
[]
[null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),6,1)","v":"2020-06-01"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+1)=6),_xlfn.SINGLE(JunSun1)+1,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+2)=6),_xlfn.SINGLE(JunSun1)+2,\"\"))","v":"2020-06-01"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+3)=6),_xlfn.SINGLE(JunSun1)+3,\"\"))","v":"2020-06-02"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+4)=6),_xlfn.SINGLE(JunSun1)+4,\"\"))","v":"2020-06-03"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+5)=6),_xlfn.SINGLE(JunSun1)+5,\"\"))","v":"2020-06-04"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+6)=6),_xlfn.SINGLE(JunSun1)+6,\"\"))","v":"2020-06-05"},{"$f":"_xlfn.SINGLE(IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1))=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1))=6),JunSun1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+7)=6),_xlfn.SINGLE(JunSun1)+7,\"\")))","v":"2020-06-06"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+1)=6),_xlfn.SINGLE(JunSun1)+1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+8)=6),_xlfn.SINGLE(JunSun1)+8,\"\"))","v":"2020-06-07"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+2)=6),_xlfn.SINGLE(JunSun1)+2,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+9)=6),_xlfn.SINGLE(JunSun1)+9,\"\"))","v":"2020-06-08"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+3)=6),_xlfn.SINGLE(JunSun1)+3,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+10)=6),_xlfn.SINGLE(JunSun1)+10,\"\"))","v":"2020-06-09"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+4)=6),_xlfn.SINGLE(JunSun1)+4,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+11)=6),_xlfn.SINGLE(JunSun1)+11,\"\"))","v":"2020-06-10"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+5)=6),_xlfn.SINGLE(JunSun1)+5,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+12)=6),_xlfn.SINGLE(JunSun1)+12,\"\"))","v":"2020-06-11"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+6)=6),_xlfn.SINGLE(JunSun1)+6,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+13)=6),_xlfn.SINGLE(JunSun1)+13,\"\"))","v":"2020-06-12"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+7)=6),_xlfn.SINGLE(JunSun1)+7,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+14)=6),_xlfn.SINGLE(JunSun1)+14,\"\"))","v":"2020-06-13"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+8)=6),_xlfn.SINGLE(JunSun1)+8,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+15)=6),_xlfn.SINGLE(JunSun1)+15,\"\"))","v":"2020-06-14"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+9)=6),_xlfn.SINGLE(JunSun1)+9,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+16)=6),_xlfn.SINGLE(JunSun1)+16,\"\"))","v":"2020-06-15"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+10)=6),_xlfn.SINGLE(JunSun1)+10,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+17)=6),_xlfn.SINGLE(JunSun1)+17,\"\"))","v":"2020-06-16"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+11)=6),_xlfn.SINGLE(JunSun1)+11,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+18)=6),_xlfn.SINGLE(JunSun1)+18,\"\"))","v":"2020-06-17"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+12)=6),_xlfn.SINGLE(JunSun1)+12,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+19)=6),_xlfn.SINGLE(JunSun1)+19,\"\"))","v":"2020-06-18"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+13)=6),_xlfn.SINGLE(JunSun1)+13,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+20)=6),_xlfn.SINGLE(JunSun1)+20,\"\"))","v":"2020-06-19"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+14)=6),_xlfn.SINGLE(JunSun1)+14,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+21)=6),_xlfn.SINGLE(JunSun1)+21,\"\"))","v":"2020-06-20"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+15)=6),_xlfn.SINGLE(JunSun1)+15,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+22)=6),_xlfn.SINGLE(JunSun1)+22,\"\"))","v":"2020-06-21"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+16)=6),_xlfn.SINGLE(JunSun1)+16,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+23)=6),_xlfn.SINGLE(JunSun1)+23,\"\"))","v":"2020-06-22"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+17)=6),_xlfn.SINGLE(JunSun1)+17,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+24)=6),_xlfn.SINGLE(JunSun1)+24,\"\"))","v":"2020-06-23"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+18)=6),_xlfn.SINGLE(JunSun1)+18,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+25)=6),_xlfn.SINGLE(JunSun1)+25,\"\"))","v":"2020-06-24"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+19)=6),_xlfn.SINGLE(JunSun1)+19,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+26)=6),_xlfn.SINGLE(JunSun1)+26,\"\"))","v":"2020-06-25"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+20)=6),_xlfn.SINGLE(JunSun1)+20,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+27)=6),_xlfn.SINGLE(JunSun1)+27,\"\"))","v":"2020-06-26"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+21)=6),_xlfn.SINGLE(JunSun1)+21,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+28)=6),_xlfn.SINGLE(JunSun1)+28,\"\"))","v":"2020-06-27"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+22)=6),_xlfn.SINGLE(JunSun1)+22,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+29)=6),_xlfn.SINGLE(JunSun1)+29,\"\"))","v":"2020-06-28"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+23)=6),_xlfn.SINGLE(JunSun1)+23,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+30)=6),_xlfn.SINGLE(JunSun1)+30,\"\"))","v":"2020-06-29"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+24)=6),_xlfn.SINGLE(JunSun1)+24,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+31)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+31)=6),_xlfn.SINGLE(JunSun1)+31,\"\"))","v":"2020-06-30"},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+25)=6),_xlfn.SINGLE(JunSun1)+25,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+32)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+32)=6),_xlfn.SINGLE(JunSun1)+32,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+26)=6),_xlfn.SINGLE(JunSun1)+26,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+33)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+33)=6),_xlfn.SINGLE(JunSun1)+33,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+27)=6),_xlfn.SINGLE(JunSun1)+27,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+34)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+34)=6),_xlfn.SINGLE(JunSun1)+34,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+28)=6),_xlfn.SINGLE(JunSun1)+28,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+35)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+35)=6),_xlfn.SINGLE(JunSun1)+35,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+29)=6),_xlfn.SINGLE(JunSun1)+29,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+36)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+36)=6),_xlfn.SINGLE(JunSun1)+36,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JunSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+30)=6),_xlfn.SINGLE(JunSun1)+30,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JunSun1)+37)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JunSun1)+37)=6),_xlfn.SINGLE(JunSun1)+37,\"\"))","v":""}]
[null,null,"Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu"]
[null,{"$f":"IF(Job1_Name=\"\",\"\",Job1_Name)","v":"Poste 1"},{"$f":"IF(OR(NOT(ISNUMBER(C35)),C35<Job1_StartDate),\"\",IF(MID(Job1_Pattern,MOD(C35-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift1_Code,1,IF(MID(Job1_Pattern,MOD(C35-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift2_Code,2,IF(MID(Job1_Pattern,MOD(C35-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift3_Code,3,\"\"))))","v":""},"","",1,1,1,1,"","",2,2,2,2,"","",1,1,1,"",2,2,2,"","","",1,1,"",2,2,"","","","","","",""]
[null,{"$f":"IF(Job2_Name=\"\",\"\",Job2_Name)","v":"Poste 2"},{"$f":"IF(OR(NOT(ISNUMBER(C35)),C35<Job2_StartDate),\"\",IF(MID(Job2_Pattern,MOD(C35-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift1_Code,1,IF(MID(Job2_Pattern,MOD(C35-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift2_Code,2,IF(MID(Job2_Pattern,MOD(C35-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift3_Code,3,\"\"))))","v":""},1,"","","",2,2,"",1,1,"","","",2,2,2,2,"","","","","",1,"","",2,2,2,"","",1,"","","","","",""]
[null,{"$f":"IF(Job3_Name=\"\",\"\",Job3_Name)","v":"Poste 3"},{"$f":"IF(OR(NOT(ISNUMBER(C35)),C35<Job3_StartDate),\"\",IF(MID(Job3_Pattern,MOD(C35-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift1_Code,1,IF(MID(Job3_Pattern,MOD(C35-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift2_Code,2,IF(MID(Job3_Pattern,MOD(C35-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift3_Code,3,\"\"))))","v":""},3,"","","",3,"","","","","","",3,3,"","","",3,3,"","","","",3,3,"","","","",3,3,"","","","","",""]
[]
[null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),7,1)","v":"2020-07-01"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+1)=7),_xlfn.SINGLE(JulSun1)+1,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+2)=7),_xlfn.SINGLE(JulSun1)+2,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+3)=7),_xlfn.SINGLE(JulSun1)+3,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+4)=7),_xlfn.SINGLE(JulSun1)+4,\"\"))","v":"2020-07-01"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+5)=7),_xlfn.SINGLE(JulSun1)+5,\"\"))","v":"2020-07-02"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+6)=7),_xlfn.SINGLE(JulSun1)+6,\"\"))","v":"2020-07-03"},{"$f":"_xlfn.SINGLE(IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1))=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1))=7),JulSun1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+7)=7),_xlfn.SINGLE(JulSun1)+7,\"\")))","v":"2020-07-04"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+1)=7),_xlfn.SINGLE(JulSun1)+1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+8)=7),_xlfn.SINGLE(JulSun1)+8,\"\"))","v":"2020-07-05"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+2)=7),_xlfn.SINGLE(JulSun1)+2,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+9)=7),_xlfn.SINGLE(JulSun1)+9,\"\"))","v":"2020-07-06"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+3)=7),_xlfn.SINGLE(JulSun1)+3,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+10)=7),_xlfn.SINGLE(JulSun1)+10,\"\"))","v":"2020-07-07"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+4)=7),_xlfn.SINGLE(JulSun1)+4,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+11)=7),_xlfn.SINGLE(JulSun1)+11,\"\"))","v":"2020-07-08"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+5)=7),_xlfn.SINGLE(JulSun1)+5,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+12)=7),_xlfn.SINGLE(JulSun1)+12,\"\"))","v":"2020-07-09"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+6)=7),_xlfn.SINGLE(JulSun1)+6,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+13)=7),_xlfn.SINGLE(JulSun1)+13,\"\"))","v":"2020-07-10"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+7)=7),_xlfn.SINGLE(JulSun1)+7,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+14)=7),_xlfn.SINGLE(JulSun1)+14,\"\"))","v":"2020-07-11"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+8)=7),_xlfn.SINGLE(JulSun1)+8,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+15)=7),_xlfn.SINGLE(JulSun1)+15,\"\"))","v":"2020-07-12"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+9)=7),_xlfn.SINGLE(JulSun1)+9,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+16)=7),_xlfn.SINGLE(JulSun1)+16,\"\"))","v":"2020-07-13"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+10)=7),_xlfn.SINGLE(JulSun1)+10,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+17)=7),_xlfn.SINGLE(JulSun1)+17,\"\"))","v":"2020-07-14"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+11)=7),_xlfn.SINGLE(JulSun1)+11,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+18)=7),_xlfn.SINGLE(JulSun1)+18,\"\"))","v":"2020-07-15"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+12)=7),_xlfn.SINGLE(JulSun1)+12,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+19)=7),_xlfn.SINGLE(JulSun1)+19,\"\"))","v":"2020-07-16"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+13)=7),_xlfn.SINGLE(JulSun1)+13,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+20)=7),_xlfn.SINGLE(JulSun1)+20,\"\"))","v":"2020-07-17"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+14)=7),_xlfn.SINGLE(JulSun1)+14,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+21)=7),_xlfn.SINGLE(JulSun1)+21,\"\"))","v":"2020-07-18"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+15)=7),_xlfn.SINGLE(JulSun1)+15,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+22)=7),_xlfn.SINGLE(JulSun1)+22,\"\"))","v":"2020-07-19"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+16)=7),_xlfn.SINGLE(JulSun1)+16,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+23)=7),_xlfn.SINGLE(JulSun1)+23,\"\"))","v":"2020-07-20"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+17)=7),_xlfn.SINGLE(JulSun1)+17,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+24)=7),_xlfn.SINGLE(JulSun1)+24,\"\"))","v":"2020-07-21"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+18)=7),_xlfn.SINGLE(JulSun1)+18,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+25)=7),_xlfn.SINGLE(JulSun1)+25,\"\"))","v":"2020-07-22"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+19)=7),_xlfn.SINGLE(JulSun1)+19,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+26)=7),_xlfn.SINGLE(JulSun1)+26,\"\"))","v":"2020-07-23"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+20)=7),_xlfn.SINGLE(JulSun1)+20,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+27)=7),_xlfn.SINGLE(JulSun1)+27,\"\"))","v":"2020-07-24"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+21)=7),_xlfn.SINGLE(JulSun1)+21,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+28)=7),_xlfn.SINGLE(JulSun1)+28,\"\"))","v":"2020-07-25"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+22)=7),_xlfn.SINGLE(JulSun1)+22,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+29)=7),_xlfn.SINGLE(JulSun1)+29,\"\"))","v":"2020-07-26"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+23)=7),_xlfn.SINGLE(JulSun1)+23,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+30)=7),_xlfn.SINGLE(JulSun1)+30,\"\"))","v":"2020-07-27"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+24)=7),_xlfn.SINGLE(JulSun1)+24,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+31)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+31)=7),_xlfn.SINGLE(JulSun1)+31,\"\"))","v":"2020-07-28"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+25)=7),_xlfn.SINGLE(JulSun1)+25,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+32)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+32)=7),_xlfn.SINGLE(JulSun1)+32,\"\"))","v":"2020-07-29"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+26)=7),_xlfn.SINGLE(JulSun1)+26,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+33)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+33)=7),_xlfn.SINGLE(JulSun1)+33,\"\"))","v":"2020-07-30"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+27)=7),_xlfn.SINGLE(JulSun1)+27,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+34)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+34)=7),_xlfn.SINGLE(JulSun1)+34,\"\"))","v":"2020-07-31"},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+28)=7),_xlfn.SINGLE(JulSun1)+28,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+35)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+35)=7),_xlfn.SINGLE(JulSun1)+35,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+29)=7),_xlfn.SINGLE(JulSun1)+29,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+36)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+36)=7),_xlfn.SINGLE(JulSun1)+36,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(JulSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+30)=7),_xlfn.SINGLE(JulSun1)+30,\"\"),IF(AND(YEAR(_xlfn.SINGLE(JulSun1)+37)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(JulSun1)+37)=7),_xlfn.SINGLE(JulSun1)+37,\"\"))","v":""}]
[null,null,"Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu"]
[null,{"$f":"IF(Job1_Name=\"\",\"\",Job1_Name)","v":"Poste 1"},{"$f":"IF(OR(NOT(ISNUMBER(C41)),C41<Job1_StartDate),\"\",IF(MID(Job1_Pattern,MOD(C41-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift1_Code,1,IF(MID(Job1_Pattern,MOD(C41-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift2_Code,2,IF(MID(Job1_Pattern,MOD(C41-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift3_Code,3,\"\"))))","v":""},"","","","",1,1,1,1,"","",2,2,2,2,"","",1,1,1,"",2,2,2,"","","",1,1,"",2,2,"","","","",""]
[null,{"$f":"IF(Job2_Name=\"\",\"\",Job2_Name)","v":"Poste 2"},{"$f":"IF(OR(NOT(ISNUMBER(C41)),C41<Job2_StartDate),\"\",IF(MID(Job2_Pattern,MOD(C41-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift1_Code,1,IF(MID(Job2_Pattern,MOD(C41-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift2_Code,2,IF(MID(Job2_Pattern,MOD(C41-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift3_Code,3,\"\"))))","v":""},"","",1,"","","",2,2,"",1,1,"","","",2,2,2,2,"","","","","",1,"","",2,2,2,"","",1,1,"","",""]
[null,{"$f":"IF(Job3_Name=\"\",\"\",Job3_Name)","v":"Poste 3"},{"$f":"IF(OR(NOT(ISNUMBER(C41)),C41<Job3_StartDate),\"\",IF(MID(Job3_Pattern,MOD(C41-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift1_Code,1,IF(MID(Job3_Pattern,MOD(C41-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift2_Code,2,IF(MID(Job3_Pattern,MOD(C41-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift3_Code,3,\"\"))))","v":""},"","",3,"","","",3,"","","","","","",3,3,"","","",3,3,"","","","",3,3,"","","","",3,3,3,"","",""]
[]
[null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),8,1)","v":"2020-08-01"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+1)=8),_xlfn.SINGLE(AugSun1)+1,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+2)=8),_xlfn.SINGLE(AugSun1)+2,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+3)=8),_xlfn.SINGLE(AugSun1)+3,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+4)=8),_xlfn.SINGLE(AugSun1)+4,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+5)=8),_xlfn.SINGLE(AugSun1)+5,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+6)=8),_xlfn.SINGLE(AugSun1)+6,\"\"))","v":""},{"$f":"_xlfn.SINGLE(IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1))=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1))=8),AugSun1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+7)=8),_xlfn.SINGLE(AugSun1)+7,\"\")))","v":"2020-08-01"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+1)=8),_xlfn.SINGLE(AugSun1)+1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+8)=8),_xlfn.SINGLE(AugSun1)+8,\"\"))","v":"2020-08-02"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+2)=8),_xlfn.SINGLE(AugSun1)+2,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+9)=8),_xlfn.SINGLE(AugSun1)+9,\"\"))","v":"2020-08-03"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+3)=8),_xlfn.SINGLE(AugSun1)+3,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+10)=8),_xlfn.SINGLE(AugSun1)+10,\"\"))","v":"2020-08-04"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+4)=8),_xlfn.SINGLE(AugSun1)+4,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+11)=8),_xlfn.SINGLE(AugSun1)+11,\"\"))","v":"2020-08-05"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+5)=8),_xlfn.SINGLE(AugSun1)+5,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+12)=8),_xlfn.SINGLE(AugSun1)+12,\"\"))","v":"2020-08-06"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+6)=8),_xlfn.SINGLE(AugSun1)+6,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+13)=8),_xlfn.SINGLE(AugSun1)+13,\"\"))","v":"2020-08-07"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+7)=8),_xlfn.SINGLE(AugSun1)+7,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+14)=8),_xlfn.SINGLE(AugSun1)+14,\"\"))","v":"2020-08-08"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+8)=8),_xlfn.SINGLE(AugSun1)+8,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+15)=8),_xlfn.SINGLE(AugSun1)+15,\"\"))","v":"2020-08-09"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+9)=8),_xlfn.SINGLE(AugSun1)+9,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+16)=8),_xlfn.SINGLE(AugSun1)+16,\"\"))","v":"2020-08-10"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+10)=8),_xlfn.SINGLE(AugSun1)+10,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+17)=8),_xlfn.SINGLE(AugSun1)+17,\"\"))","v":"2020-08-11"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+11)=8),_xlfn.SINGLE(AugSun1)+11,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+18)=8),_xlfn.SINGLE(AugSun1)+18,\"\"))","v":"2020-08-12"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+12)=8),_xlfn.SINGLE(AugSun1)+12,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+19)=8),_xlfn.SINGLE(AugSun1)+19,\"\"))","v":"2020-08-13"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+13)=8),_xlfn.SINGLE(AugSun1)+13,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+20)=8),_xlfn.SINGLE(AugSun1)+20,\"\"))","v":"2020-08-14"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+14)=8),_xlfn.SINGLE(AugSun1)+14,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+21)=8),_xlfn.SINGLE(AugSun1)+21,\"\"))","v":"2020-08-15"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+15)=8),_xlfn.SINGLE(AugSun1)+15,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+22)=8),_xlfn.SINGLE(AugSun1)+22,\"\"))","v":"2020-08-16"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+16)=8),_xlfn.SINGLE(AugSun1)+16,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+23)=8),_xlfn.SINGLE(AugSun1)+23,\"\"))","v":"2020-08-17"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+17)=8),_xlfn.SINGLE(AugSun1)+17,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+24)=8),_xlfn.SINGLE(AugSun1)+24,\"\"))","v":"2020-08-18"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+18)=8),_xlfn.SINGLE(AugSun1)+18,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+25)=8),_xlfn.SINGLE(AugSun1)+25,\"\"))","v":"2020-08-19"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+19)=8),_xlfn.SINGLE(AugSun1)+19,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+26)=8),_xlfn.SINGLE(AugSun1)+26,\"\"))","v":"2020-08-20"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+20)=8),_xlfn.SINGLE(AugSun1)+20,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+27)=8),_xlfn.SINGLE(AugSun1)+27,\"\"))","v":"2020-08-21"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+21)=8),_xlfn.SINGLE(AugSun1)+21,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+28)=8),_xlfn.SINGLE(AugSun1)+28,\"\"))","v":"2020-08-22"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+22)=8),_xlfn.SINGLE(AugSun1)+22,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+29)=8),_xlfn.SINGLE(AugSun1)+29,\"\"))","v":"2020-08-23"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+23)=8),_xlfn.SINGLE(AugSun1)+23,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+30)=8),_xlfn.SINGLE(AugSun1)+30,\"\"))","v":"2020-08-24"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+24)=8),_xlfn.SINGLE(AugSun1)+24,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+31)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+31)=8),_xlfn.SINGLE(AugSun1)+31,\"\"))","v":"2020-08-25"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+25)=8),_xlfn.SINGLE(AugSun1)+25,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+32)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+32)=8),_xlfn.SINGLE(AugSun1)+32,\"\"))","v":"2020-08-26"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+26)=8),_xlfn.SINGLE(AugSun1)+26,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+33)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+33)=8),_xlfn.SINGLE(AugSun1)+33,\"\"))","v":"2020-08-27"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+27)=8),_xlfn.SINGLE(AugSun1)+27,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+34)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+34)=8),_xlfn.SINGLE(AugSun1)+34,\"\"))","v":"2020-08-28"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+28)=8),_xlfn.SINGLE(AugSun1)+28,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+35)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+35)=8),_xlfn.SINGLE(AugSun1)+35,\"\"))","v":"2020-08-29"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+29)=8),_xlfn.SINGLE(AugSun1)+29,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+36)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+36)=8),_xlfn.SINGLE(AugSun1)+36,\"\"))","v":"2020-08-30"},{"$f":"IF(DAY(_xlfn.SINGLE(AugSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+30)=8),_xlfn.SINGLE(AugSun1)+30,\"\"),IF(AND(YEAR(_xlfn.SINGLE(AugSun1)+37)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(AugSun1)+37)=8),_xlfn.SINGLE(AugSun1)+37,\"\"))","v":"2020-08-31"}]
[null,null,"Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu"]
[null,{"$f":"IF(Job1_Name=\"\",\"\",Job1_Name)","v":"Poste 1"},{"$f":"IF(OR(NOT(ISNUMBER(C47)),C47<Job1_StartDate),\"\",IF(MID(Job1_Pattern,MOD(C47-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift1_Code,1,IF(MID(Job1_Pattern,MOD(C47-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift2_Code,2,IF(MID(Job1_Pattern,MOD(C47-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift3_Code,3,\"\"))))","v":""},"","","","","","",1,1,1,1,"","",2,2,2,2,"","",1,1,1,"",2,2,2,"","","",1,1,"",2,2,"","",""]
[null,{"$f":"IF(Job2_Name=\"\",\"\",Job2_Name)","v":"Poste 2"},{"$f":"IF(OR(NOT(ISNUMBER(C47)),C47<Job2_StartDate),\"\",IF(MID(Job2_Pattern,MOD(C47-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift1_Code,1,IF(MID(Job2_Pattern,MOD(C47-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift2_Code,2,IF(MID(Job2_Pattern,MOD(C47-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift3_Code,3,\"\"))))","v":""},"","","","","","","","",2,2,"",1,1,"","","",2,2,2,2,"","","","","",1,"","",2,2,2,"","",1,1,""]
[null,{"$f":"IF(Job3_Name=\"\",\"\",Job3_Name)","v":"Poste 3"},{"$f":"IF(OR(NOT(ISNUMBER(C47)),C47<Job3_StartDate),\"\",IF(MID(Job3_Pattern,MOD(C47-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift1_Code,1,IF(MID(Job3_Pattern,MOD(C47-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift2_Code,2,IF(MID(Job3_Pattern,MOD(C47-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift3_Code,3,\"\"))))","v":""},"","","","","","","","",3,"","","","","","",3,3,"","","",3,3,"","","","",3,3,"","","","",3,3,3,""]
[]
[null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),9,1)","v":"2020-09-01"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+1)=9),_xlfn.SINGLE(DimSep1)+1,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+2)=9),_xlfn.SINGLE(DimSep1)+2,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+3)=9),_xlfn.SINGLE(DimSep1)+3,\"\"))","v":"2020-09-01"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+4)=9),_xlfn.SINGLE(DimSep1)+4,\"\"))","v":"2020-09-02"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+5)=9),_xlfn.SINGLE(DimSep1)+5,\"\"))","v":"2020-09-03"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+6)=9),_xlfn.SINGLE(DimSep1)+6,\"\"))","v":"2020-09-04"},{"$f":"_xlfn.SINGLE(IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1))=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1))=9),DimSep1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+7)=9),_xlfn.SINGLE(DimSep1)+7,\"\")))","v":"2020-09-05"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+1)=9),_xlfn.SINGLE(DimSep1)+1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+8)=9),_xlfn.SINGLE(DimSep1)+8,\"\"))","v":"2020-09-06"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+2)=9),_xlfn.SINGLE(DimSep1)+2,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+9)=9),_xlfn.SINGLE(DimSep1)+9,\"\"))","v":"2020-09-07"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+3)=9),_xlfn.SINGLE(DimSep1)+3,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+10)=9),_xlfn.SINGLE(DimSep1)+10,\"\"))","v":"2020-09-08"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+4)=9),_xlfn.SINGLE(DimSep1)+4,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+11)=9),_xlfn.SINGLE(DimSep1)+11,\"\"))","v":"2020-09-09"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+5)=9),_xlfn.SINGLE(DimSep1)+5,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+12)=9),_xlfn.SINGLE(DimSep1)+12,\"\"))","v":"2020-09-10"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+6)=9),_xlfn.SINGLE(DimSep1)+6,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+13)=9),_xlfn.SINGLE(DimSep1)+13,\"\"))","v":"2020-09-11"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+7)=9),_xlfn.SINGLE(DimSep1)+7,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+14)=9),_xlfn.SINGLE(DimSep1)+14,\"\"))","v":"2020-09-12"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+8)=9),_xlfn.SINGLE(DimSep1)+8,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+15)=9),_xlfn.SINGLE(DimSep1)+15,\"\"))","v":"2020-09-13"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+9)=9),_xlfn.SINGLE(DimSep1)+9,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+16)=9),_xlfn.SINGLE(DimSep1)+16,\"\"))","v":"2020-09-14"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+10)=9),_xlfn.SINGLE(DimSep1)+10,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+17)=9),_xlfn.SINGLE(DimSep1)+17,\"\"))","v":"2020-09-15"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+11)=9),_xlfn.SINGLE(DimSep1)+11,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+18)=9),_xlfn.SINGLE(DimSep1)+18,\"\"))","v":"2020-09-16"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+12)=9),_xlfn.SINGLE(DimSep1)+12,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+19)=9),_xlfn.SINGLE(DimSep1)+19,\"\"))","v":"2020-09-17"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+13)=9),_xlfn.SINGLE(DimSep1)+13,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+20)=9),_xlfn.SINGLE(DimSep1)+20,\"\"))","v":"2020-09-18"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+14)=9),_xlfn.SINGLE(DimSep1)+14,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+21)=9),_xlfn.SINGLE(DimSep1)+21,\"\"))","v":"2020-09-19"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+15)=9),_xlfn.SINGLE(DimSep1)+15,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+22)=9),_xlfn.SINGLE(DimSep1)+22,\"\"))","v":"2020-09-20"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+16)=9),_xlfn.SINGLE(DimSep1)+16,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+23)=9),_xlfn.SINGLE(DimSep1)+23,\"\"))","v":"2020-09-21"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+17)=9),_xlfn.SINGLE(DimSep1)+17,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+24)=9),_xlfn.SINGLE(DimSep1)+24,\"\"))","v":"2020-09-22"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+18)=9),_xlfn.SINGLE(DimSep1)+18,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+25)=9),_xlfn.SINGLE(DimSep1)+25,\"\"))","v":"2020-09-23"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+19)=9),_xlfn.SINGLE(DimSep1)+19,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+26)=9),_xlfn.SINGLE(DimSep1)+26,\"\"))","v":"2020-09-24"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+20)=9),_xlfn.SINGLE(DimSep1)+20,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+27)=9),_xlfn.SINGLE(DimSep1)+27,\"\"))","v":"2020-09-25"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+21)=9),_xlfn.SINGLE(DimSep1)+21,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+28)=9),_xlfn.SINGLE(DimSep1)+28,\"\"))","v":"2020-09-26"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+22)=9),_xlfn.SINGLE(DimSep1)+22,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+29)=9),_xlfn.SINGLE(DimSep1)+29,\"\"))","v":"2020-09-27"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+23)=9),_xlfn.SINGLE(DimSep1)+23,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+30)=9),_xlfn.SINGLE(DimSep1)+30,\"\"))","v":"2020-09-28"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+24)=9),_xlfn.SINGLE(DimSep1)+24,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+31)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+31)=9),_xlfn.SINGLE(DimSep1)+31,\"\"))","v":"2020-09-29"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+25)=9),_xlfn.SINGLE(DimSep1)+25,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+32)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+32)=9),_xlfn.SINGLE(DimSep1)+32,\"\"))","v":"2020-09-30"},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+26)=9),_xlfn.SINGLE(DimSep1)+26,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+33)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+33)=9),_xlfn.SINGLE(DimSep1)+33,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+27)=9),_xlfn.SINGLE(DimSep1)+27,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+34)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+34)=9),_xlfn.SINGLE(DimSep1)+34,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+28)=9),_xlfn.SINGLE(DimSep1)+28,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+35)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+35)=9),_xlfn.SINGLE(DimSep1)+35,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+29)=9),_xlfn.SINGLE(DimSep1)+29,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+36)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+36)=9),_xlfn.SINGLE(DimSep1)+36,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(DimSep1))=1,IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+30)=9),_xlfn.SINGLE(DimSep1)+30,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DimSep1)+37)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DimSep1)+37)=9),_xlfn.SINGLE(DimSep1)+37,\"\"))","v":""}]
[null,null,"Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu"]
[null,{"$f":"IF(Job1_Name=\"\",\"\",Job1_Name)","v":"Poste 1"},{"$f":"IF(OR(NOT(ISNUMBER(C53)),C53<Job1_StartDate),\"\",IF(MID(Job1_Pattern,MOD(C53-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift1_Code,1,IF(MID(Job1_Pattern,MOD(C53-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift2_Code,2,IF(MID(Job1_Pattern,MOD(C53-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift3_Code,3,\"\"))))","v":""},"",1,1,1,1,"","",2,2,2,2,"","",1,1,1,"",2,2,2,"","","",1,1,"",2,2,"","","","","","","",""]
[null,{"$f":"IF(Job2_Name=\"\",\"\",Job2_Name)","v":"Poste 2"},{"$f":"IF(OR(NOT(ISNUMBER(C53)),C53<Job2_StartDate),\"\",IF(MID(Job2_Pattern,MOD(C53-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift1_Code,1,IF(MID(Job2_Pattern,MOD(C53-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift2_Code,2,IF(MID(Job2_Pattern,MOD(C53-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift3_Code,3,\"\"))))","v":""},"","","",2,2,"",1,1,"","","",2,2,2,2,"","","","","",1,"","",2,2,2,"","",1,1,"","","","","",""]
[null,{"$f":"IF(Job3_Name=\"\",\"\",Job3_Name)","v":"Poste 3"},{"$f":"IF(OR(NOT(ISNUMBER(C53)),C53<Job3_StartDate),\"\",IF(MID(Job3_Pattern,MOD(C53-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift1_Code,1,IF(MID(Job3_Pattern,MOD(C53-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift2_Code,2,IF(MID(Job3_Pattern,MOD(C53-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift3_Code,3,\"\"))))","v":""},"","","",3,"","","","","","",3,3,"","","",3,3,"","","","",3,3,"","","","",3,3,3,"","","","","",""]
[]
[null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),10,1)","v":"2020-10-01"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+1)=10),_xlfn.SINGLE(OctSun1)+1,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+2)=10),_xlfn.SINGLE(OctSun1)+2,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+3)=10),_xlfn.SINGLE(OctSun1)+3,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+4)=10),_xlfn.SINGLE(OctSun1)+4,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+5)=10),_xlfn.SINGLE(OctSun1)+5,\"\"))","v":"2020-10-01"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+6)=10),_xlfn.SINGLE(OctSun1)+6,\"\"))","v":"2020-10-02"},{"$f":"_xlfn.SINGLE(IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1))=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1))=10),OctSun1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+7)=10),_xlfn.SINGLE(OctSun1)+7,\"\")))","v":"2020-10-03"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+1)=10),_xlfn.SINGLE(OctSun1)+1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+8)=10),_xlfn.SINGLE(OctSun1)+8,\"\"))","v":"2020-10-04"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+2)=10),_xlfn.SINGLE(OctSun1)+2,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+9)=10),_xlfn.SINGLE(OctSun1)+9,\"\"))","v":"2020-10-05"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+3)=10),_xlfn.SINGLE(OctSun1)+3,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+10)=10),_xlfn.SINGLE(OctSun1)+10,\"\"))","v":"2020-10-06"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+4)=10),_xlfn.SINGLE(OctSun1)+4,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+11)=10),_xlfn.SINGLE(OctSun1)+11,\"\"))","v":"2020-10-07"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+5)=10),_xlfn.SINGLE(OctSun1)+5,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+12)=10),_xlfn.SINGLE(OctSun1)+12,\"\"))","v":"2020-10-08"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+6)=10),_xlfn.SINGLE(OctSun1)+6,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+13)=10),_xlfn.SINGLE(OctSun1)+13,\"\"))","v":"2020-10-09"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+7)=10),_xlfn.SINGLE(OctSun1)+7,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+14)=10),_xlfn.SINGLE(OctSun1)+14,\"\"))","v":"2020-10-10"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+8)=10),_xlfn.SINGLE(OctSun1)+8,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+15)=10),_xlfn.SINGLE(OctSun1)+15,\"\"))","v":"2020-10-11"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+9)=10),_xlfn.SINGLE(OctSun1)+9,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+16)=10),_xlfn.SINGLE(OctSun1)+16,\"\"))","v":"2020-10-12"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+10)=10),_xlfn.SINGLE(OctSun1)+10,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+17)=10),_xlfn.SINGLE(OctSun1)+17,\"\"))","v":"2020-10-13"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+11)=10),_xlfn.SINGLE(OctSun1)+11,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+18)=10),_xlfn.SINGLE(OctSun1)+18,\"\"))","v":"2020-10-14"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+12)=10),_xlfn.SINGLE(OctSun1)+12,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+19)=10),_xlfn.SINGLE(OctSun1)+19,\"\"))","v":"2020-10-15"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+13)=10),_xlfn.SINGLE(OctSun1)+13,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+20)=10),_xlfn.SINGLE(OctSun1)+20,\"\"))","v":"2020-10-16"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+14)=10),_xlfn.SINGLE(OctSun1)+14,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+21)=10),_xlfn.SINGLE(OctSun1)+21,\"\"))","v":"2020-10-17"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+15)=10),_xlfn.SINGLE(OctSun1)+15,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+22)=10),_xlfn.SINGLE(OctSun1)+22,\"\"))","v":"2020-10-18"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+16)=10),_xlfn.SINGLE(OctSun1)+16,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+23)=10),_xlfn.SINGLE(OctSun1)+23,\"\"))","v":"2020-10-19"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+17)=10),_xlfn.SINGLE(OctSun1)+17,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+24)=10),_xlfn.SINGLE(OctSun1)+24,\"\"))","v":"2020-10-20"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+18)=10),_xlfn.SINGLE(OctSun1)+18,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+25)=10),_xlfn.SINGLE(OctSun1)+25,\"\"))","v":"2020-10-21"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+19)=10),_xlfn.SINGLE(OctSun1)+19,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+26)=10),_xlfn.SINGLE(OctSun1)+26,\"\"))","v":"2020-10-22"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+20)=10),_xlfn.SINGLE(OctSun1)+20,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+27)=10),_xlfn.SINGLE(OctSun1)+27,\"\"))","v":"2020-10-23"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+21)=10),_xlfn.SINGLE(OctSun1)+21,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+28)=10),_xlfn.SINGLE(OctSun1)+28,\"\"))","v":"2020-10-24"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+22)=10),_xlfn.SINGLE(OctSun1)+22,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+29)=10),_xlfn.SINGLE(OctSun1)+29,\"\"))","v":"2020-10-25"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+23)=10),_xlfn.SINGLE(OctSun1)+23,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+30)=10),_xlfn.SINGLE(OctSun1)+30,\"\"))","v":"2020-10-26"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+24)=10),_xlfn.SINGLE(OctSun1)+24,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+31)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+31)=10),_xlfn.SINGLE(OctSun1)+31,\"\"))","v":"2020-10-27"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+25)=10),_xlfn.SINGLE(OctSun1)+25,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+32)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+32)=10),_xlfn.SINGLE(OctSun1)+32,\"\"))","v":"2020-10-28"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+26)=10),_xlfn.SINGLE(OctSun1)+26,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+33)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+33)=10),_xlfn.SINGLE(OctSun1)+33,\"\"))","v":"2020-10-29"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+27)=10),_xlfn.SINGLE(OctSun1)+27,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+34)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+34)=10),_xlfn.SINGLE(OctSun1)+34,\"\"))","v":"2020-10-30"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+28)=10),_xlfn.SINGLE(OctSun1)+28,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+35)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+35)=10),_xlfn.SINGLE(OctSun1)+35,\"\"))","v":"2020-10-31"},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+29)=10),_xlfn.SINGLE(OctSun1)+29,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+36)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+36)=10),_xlfn.SINGLE(OctSun1)+36,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(OctSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+30)=10),_xlfn.SINGLE(OctSun1)+30,\"\"),IF(AND(YEAR(_xlfn.SINGLE(OctSun1)+37)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(OctSun1)+37)=10),_xlfn.SINGLE(OctSun1)+37,\"\"))","v":""}]
[null,null,"Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu"]
[null,{"$f":"IF(Job1_Name=\"\",\"\",Job1_Name)","v":"Poste 1"},{"$f":"IF(OR(NOT(ISNUMBER(C59)),C59<Job1_StartDate),\"\",IF(MID(Job1_Pattern,MOD(C59-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift1_Code,1,IF(MID(Job1_Pattern,MOD(C59-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift2_Code,2,IF(MID(Job1_Pattern,MOD(C59-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift3_Code,3,\"\"))))","v":""},"","","",1,1,1,1,"","",2,2,2,2,"","",1,1,1,"",2,2,2,"","","",1,1,"",2,2,"","","",1,"",""]
[null,{"$f":"IF(Job2_Name=\"\",\"\",Job2_Name)","v":"Poste 2"},{"$f":"IF(OR(NOT(ISNUMBER(C59)),C59<Job2_StartDate),\"\",IF(MID(Job2_Pattern,MOD(C59-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift1_Code,1,IF(MID(Job2_Pattern,MOD(C59-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift2_Code,2,IF(MID(Job2_Pattern,MOD(C59-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift3_Code,3,\"\"))))","v":""},"","","","","",2,2,"",1,1,"","","",2,2,2,2,"","","","","",1,"","",2,2,2,"","",1,1,"","","",""]
[null,{"$f":"IF(Job3_Name=\"\",\"\",Job3_Name)","v":"Poste 3"},{"$f":"IF(OR(NOT(ISNUMBER(C59)),C59<Job3_StartDate),\"\",IF(MID(Job3_Pattern,MOD(C59-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift1_Code,1,IF(MID(Job3_Pattern,MOD(C59-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift2_Code,2,IF(MID(Job3_Pattern,MOD(C59-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift3_Code,3,\"\"))))","v":""},"","","","","",3,"","","","","","",3,3,"","","",3,3,"","","","",3,3,"","","","",3,3,3,"","","",""]
[]
[null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),11,1)","v":"2020-11-01"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+1)=11),_xlfn.SINGLE(NovSun1)+1,\"\"))","v":"2020-11-01"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+2)=11),_xlfn.SINGLE(NovSun1)+2,\"\"))","v":"2020-11-02"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+3)=11),_xlfn.SINGLE(NovSun1)+3,\"\"))","v":"2020-11-03"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+4)=11),_xlfn.SINGLE(NovSun1)+4,\"\"))","v":"2020-11-04"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+5)=11),_xlfn.SINGLE(NovSun1)+5,\"\"))","v":"2020-11-05"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+6)=11),_xlfn.SINGLE(NovSun1)+6,\"\"))","v":"2020-11-06"},{"$f":"_xlfn.SINGLE(IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1))=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1))=11),NovSun1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+7)=11),_xlfn.SINGLE(NovSun1)+7,\"\")))","v":"2020-11-07"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+1)=11),_xlfn.SINGLE(NovSun1)+1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+8)=11),_xlfn.SINGLE(NovSun1)+8,\"\"))","v":"2020-11-08"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+2)=11),_xlfn.SINGLE(NovSun1)+2,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+9)=11),_xlfn.SINGLE(NovSun1)+9,\"\"))","v":"2020-11-09"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+3)=11),_xlfn.SINGLE(NovSun1)+3,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+10)=11),_xlfn.SINGLE(NovSun1)+10,\"\"))","v":"2020-11-10"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+4)=11),_xlfn.SINGLE(NovSun1)+4,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+11)=11),_xlfn.SINGLE(NovSun1)+11,\"\"))","v":"2020-11-11"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+5)=11),_xlfn.SINGLE(NovSun1)+5,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+12)=11),_xlfn.SINGLE(NovSun1)+12,\"\"))","v":"2020-11-12"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+6)=11),_xlfn.SINGLE(NovSun1)+6,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+13)=11),_xlfn.SINGLE(NovSun1)+13,\"\"))","v":"2020-11-13"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+7)=11),_xlfn.SINGLE(NovSun1)+7,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+14)=11),_xlfn.SINGLE(NovSun1)+14,\"\"))","v":"2020-11-14"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+8)=11),_xlfn.SINGLE(NovSun1)+8,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+15)=11),_xlfn.SINGLE(NovSun1)+15,\"\"))","v":"2020-11-15"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+9)=11),_xlfn.SINGLE(NovSun1)+9,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+16)=11),_xlfn.SINGLE(NovSun1)+16,\"\"))","v":"2020-11-16"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+10)=11),_xlfn.SINGLE(NovSun1)+10,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+17)=11),_xlfn.SINGLE(NovSun1)+17,\"\"))","v":"2020-11-17"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+11)=11),_xlfn.SINGLE(NovSun1)+11,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+18)=11),_xlfn.SINGLE(NovSun1)+18,\"\"))","v":"2020-11-18"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+12)=11),_xlfn.SINGLE(NovSun1)+12,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+19)=11),_xlfn.SINGLE(NovSun1)+19,\"\"))","v":"2020-11-19"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+13)=11),_xlfn.SINGLE(NovSun1)+13,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+20)=11),_xlfn.SINGLE(NovSun1)+20,\"\"))","v":"2020-11-20"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+14)=11),_xlfn.SINGLE(NovSun1)+14,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+21)=11),_xlfn.SINGLE(NovSun1)+21,\"\"))","v":"2020-11-21"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+15)=11),_xlfn.SINGLE(NovSun1)+15,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+22)=11),_xlfn.SINGLE(NovSun1)+22,\"\"))","v":"2020-11-22"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+16)=11),_xlfn.SINGLE(NovSun1)+16,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+23)=11),_xlfn.SINGLE(NovSun1)+23,\"\"))","v":"2020-11-23"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+17)=11),_xlfn.SINGLE(NovSun1)+17,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+24)=11),_xlfn.SINGLE(NovSun1)+24,\"\"))","v":"2020-11-24"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+18)=11),_xlfn.SINGLE(NovSun1)+18,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+25)=11),_xlfn.SINGLE(NovSun1)+25,\"\"))","v":"2020-11-25"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+19)=11),_xlfn.SINGLE(NovSun1)+19,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+26)=11),_xlfn.SINGLE(NovSun1)+26,\"\"))","v":"2020-11-26"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+20)=11),_xlfn.SINGLE(NovSun1)+20,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+27)=11),_xlfn.SINGLE(NovSun1)+27,\"\"))","v":"2020-11-27"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+21)=11),_xlfn.SINGLE(NovSun1)+21,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+28)=11),_xlfn.SINGLE(NovSun1)+28,\"\"))","v":"2020-11-28"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+22)=11),_xlfn.SINGLE(NovSun1)+22,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+29)=11),_xlfn.SINGLE(NovSun1)+29,\"\"))","v":"2020-11-29"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+23)=11),_xlfn.SINGLE(NovSun1)+23,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+30)=11),_xlfn.SINGLE(NovSun1)+30,\"\"))","v":"2020-11-30"},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+24)=11),_xlfn.SINGLE(NovSun1)+24,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+31)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+31)=11),_xlfn.SINGLE(NovSun1)+31,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+25)=11),_xlfn.SINGLE(NovSun1)+25,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+32)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+32)=11),_xlfn.SINGLE(NovSun1)+32,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+26)=11),_xlfn.SINGLE(NovSun1)+26,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+33)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+33)=11),_xlfn.SINGLE(NovSun1)+33,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+27)=11),_xlfn.SINGLE(NovSun1)+27,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+34)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+34)=11),_xlfn.SINGLE(NovSun1)+34,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+28)=11),_xlfn.SINGLE(NovSun1)+28,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+35)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+35)=11),_xlfn.SINGLE(NovSun1)+35,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+29)=11),_xlfn.SINGLE(NovSun1)+29,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+36)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+36)=11),_xlfn.SINGLE(NovSun1)+36,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(NovSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+30)=11),_xlfn.SINGLE(NovSun1)+30,\"\"),IF(AND(YEAR(_xlfn.SINGLE(NovSun1)+37)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(NovSun1)+37)=11),_xlfn.SINGLE(NovSun1)+37,\"\"))","v":""}]
[null,null,"Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu"]
[null,{"$f":"IF(Job1_Name=\"\",\"\",Job1_Name)","v":"Poste 1"},{"$f":"IF(OR(NOT(ISNUMBER(C65)),C65<Job1_StartDate),\"\",IF(MID(Job1_Pattern,MOD(C65-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift1_Code,1,IF(MID(Job1_Pattern,MOD(C65-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift2_Code,2,IF(MID(Job1_Pattern,MOD(C65-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift3_Code,3,\"\"))))","v":1},1,1,"","",2,2,2,2,"","",1,1,1,"",2,2,2,"","","",1,1,"",2,2,"","","",1,"","","","","","",""]
[null,{"$f":"IF(Job2_Name=\"\",\"\",Job2_Name)","v":"Poste 2"},{"$f":"IF(OR(NOT(ISNUMBER(C65)),C65<Job2_StartDate),\"\",IF(MID(Job2_Pattern,MOD(C65-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift1_Code,1,IF(MID(Job2_Pattern,MOD(C65-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift2_Code,2,IF(MID(Job2_Pattern,MOD(C65-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift3_Code,3,\"\"))))","v":""},2,2,"",1,1,"","","",2,2,2,2,"","","","","",1,"","",2,2,2,"","",1,1,"","","","","","","","",""]
[null,{"$f":"IF(Job3_Name=\"\",\"\",Job3_Name)","v":"Poste 3"},{"$f":"IF(OR(NOT(ISNUMBER(C65)),C65<Job3_StartDate),\"\",IF(MID(Job3_Pattern,MOD(C65-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift1_Code,1,IF(MID(Job3_Pattern,MOD(C65-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift2_Code,2,IF(MID(Job3_Pattern,MOD(C65-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift3_Code,3,\"\"))))","v":""},3,"","","","","","",3,3,"","","",3,3,"","","","",3,3,"","","","",3,3,3,"","","","","","","","",""]
[]
[null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),12,1)","v":"2020-12-01"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+1)=12),_xlfn.SINGLE(DecSun1)+1,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+2)=12),_xlfn.SINGLE(DecSun1)+2,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+3)=12),_xlfn.SINGLE(DecSun1)+3,\"\"))","v":"2020-12-01"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+4)=12),_xlfn.SINGLE(DecSun1)+4,\"\"))","v":"2020-12-02"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+5)=12),_xlfn.SINGLE(DecSun1)+5,\"\"))","v":"2020-12-03"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,\"\",IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+6)=12),_xlfn.SINGLE(DecSun1)+6,\"\"))","v":"2020-12-04"},{"$f":"_xlfn.SINGLE(IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1))=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1))=12),DecSun1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+7)=12),_xlfn.SINGLE(DecSun1)+7,\"\")))","v":"2020-12-05"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+1)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+1)=12),_xlfn.SINGLE(DecSun1)+1,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+8)=12),_xlfn.SINGLE(DecSun1)+8,\"\"))","v":"2020-12-06"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+2)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+2)=12),_xlfn.SINGLE(DecSun1)+2,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+9)=12),_xlfn.SINGLE(DecSun1)+9,\"\"))","v":"2020-12-07"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+3)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+3)=12),_xlfn.SINGLE(DecSun1)+3,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+10)=12),_xlfn.SINGLE(DecSun1)+10,\"\"))","v":"2020-12-08"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+4)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+4)=12),_xlfn.SINGLE(DecSun1)+4,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+11)=12),_xlfn.SINGLE(DecSun1)+11,\"\"))","v":"2020-12-09"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+5)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+5)=12),_xlfn.SINGLE(DecSun1)+5,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+12)=12),_xlfn.SINGLE(DecSun1)+12,\"\"))","v":"2020-12-10"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+6)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+6)=12),_xlfn.SINGLE(DecSun1)+6,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+13)=12),_xlfn.SINGLE(DecSun1)+13,\"\"))","v":"2020-12-11"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+7)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+7)=12),_xlfn.SINGLE(DecSun1)+7,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+14)=12),_xlfn.SINGLE(DecSun1)+14,\"\"))","v":"2020-12-12"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+8)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+8)=12),_xlfn.SINGLE(DecSun1)+8,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+15)=12),_xlfn.SINGLE(DecSun1)+15,\"\"))","v":"2020-12-13"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+9)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+9)=12),_xlfn.SINGLE(DecSun1)+9,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+16)=12),_xlfn.SINGLE(DecSun1)+16,\"\"))","v":"2020-12-14"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+10)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+10)=12),_xlfn.SINGLE(DecSun1)+10,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+17)=12),_xlfn.SINGLE(DecSun1)+17,\"\"))","v":"2020-12-15"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+11)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+11)=12),_xlfn.SINGLE(DecSun1)+11,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+18)=12),_xlfn.SINGLE(DecSun1)+18,\"\"))","v":"2020-12-16"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+12)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+12)=12),_xlfn.SINGLE(DecSun1)+12,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+19)=12),_xlfn.SINGLE(DecSun1)+19,\"\"))","v":"2020-12-17"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+13)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+13)=12),_xlfn.SINGLE(DecSun1)+13,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+20)=12),_xlfn.SINGLE(DecSun1)+20,\"\"))","v":"2020-12-18"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+14)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+14)=12),_xlfn.SINGLE(DecSun1)+14,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+21)=12),_xlfn.SINGLE(DecSun1)+21,\"\"))","v":"2020-12-19"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+15)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+15)=12),_xlfn.SINGLE(DecSun1)+15,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+22)=12),_xlfn.SINGLE(DecSun1)+22,\"\"))","v":"2020-12-20"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+16)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+16)=12),_xlfn.SINGLE(DecSun1)+16,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+23)=12),_xlfn.SINGLE(DecSun1)+23,\"\"))","v":"2020-12-21"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+17)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+17)=12),_xlfn.SINGLE(DecSun1)+17,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+24)=12),_xlfn.SINGLE(DecSun1)+24,\"\"))","v":"2020-12-22"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+18)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+18)=12),_xlfn.SINGLE(DecSun1)+18,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+25)=12),_xlfn.SINGLE(DecSun1)+25,\"\"))","v":"2020-12-23"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+19)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+19)=12),_xlfn.SINGLE(DecSun1)+19,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+26)=12),_xlfn.SINGLE(DecSun1)+26,\"\"))","v":"2020-12-24"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+20)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+20)=12),_xlfn.SINGLE(DecSun1)+20,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+27)=12),_xlfn.SINGLE(DecSun1)+27,\"\"))","v":"2020-12-25"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+21)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+21)=12),_xlfn.SINGLE(DecSun1)+21,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+28)=12),_xlfn.SINGLE(DecSun1)+28,\"\"))","v":"2020-12-26"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+22)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+22)=12),_xlfn.SINGLE(DecSun1)+22,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+29)=12),_xlfn.SINGLE(DecSun1)+29,\"\"))","v":"2020-12-27"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+23)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+23)=12),_xlfn.SINGLE(DecSun1)+23,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+30)=12),_xlfn.SINGLE(DecSun1)+30,\"\"))","v":"2020-12-28"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+24)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+24)=12),_xlfn.SINGLE(DecSun1)+24,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+31)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+31)=12),_xlfn.SINGLE(DecSun1)+31,\"\"))","v":"2020-12-29"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+25)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+25)=12),_xlfn.SINGLE(DecSun1)+25,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+32)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+32)=12),_xlfn.SINGLE(DecSun1)+32,\"\"))","v":"2020-12-30"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+26)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+26)=12),_xlfn.SINGLE(DecSun1)+26,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+33)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+33)=12),_xlfn.SINGLE(DecSun1)+33,\"\"))","v":"2020-12-31"},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+27)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+27)=12),_xlfn.SINGLE(DecSun1)+27,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+34)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+34)=12),_xlfn.SINGLE(DecSun1)+34,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+28)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+28)=12),_xlfn.SINGLE(DecSun1)+28,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+35)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+35)=12),_xlfn.SINGLE(DecSun1)+35,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+29)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+29)=12),_xlfn.SINGLE(DecSun1)+29,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+36)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+36)=12),_xlfn.SINGLE(DecSun1)+36,\"\"))","v":""},{"$f":"IF(DAY(_xlfn.SINGLE(DecSun1))=1,IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+30)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+30)=12),_xlfn.SINGLE(DecSun1)+30,\"\"),IF(AND(YEAR(_xlfn.SINGLE(DecSun1)+37)=_xlfn.SINGLE(AnnéeCivile),MONTH(_xlfn.SINGLE(DecSun1)+37)=12),_xlfn.SINGLE(DecSun1)+37,\"\"))","v":""}]
[null,null,"Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu"]
[null,{"$f":"IF(Job1_Name=\"\",\"\",Job1_Name)","v":"Poste 1"},{"$f":"IF(OR(NOT(ISNUMBER(C71)),C71<Job1_StartDate),\"\",IF(MID(Job1_Pattern,MOD(C71-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift1_Code,1,IF(MID(Job1_Pattern,MOD(C71-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift2_Code,2,IF(MID(Job1_Pattern,MOD(C71-Job1_StartDate,LEN(Job1_Pattern))+1,1)=Job1_Shift3_Code,3,\"\"))))","v":""},"",1,1,1,"","",2,2,2,2,"","",1,1,1,"",2,2,2,"","","",1,1,"",2,2,"","","",1,1,"","","",""]
[null,{"$f":"IF(Job2_Name=\"\",\"\",Job2_Name)","v":"Poste 2"},{"$f":"IF(OR(NOT(ISNUMBER(C71)),C71<Job2_StartDate),\"\",IF(MID(Job2_Pattern,MOD(C71-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift1_Code,1,IF(MID(Job2_Pattern,MOD(C71-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift2_Code,2,IF(MID(Job2_Pattern,MOD(C71-Job2_StartDate,LEN(Job2_Pattern))+1,1)=Job2_Shift3_Code,3,\"\"))))","v":""},"","",2,2,"",1,1,"","","",2,2,2,2,"","","","","",1,"","",2,2,2,"","",1,1,"","","","","","",""]
[null,{"$f":"IF(Job3_Name=\"\",\"\",Job3_Name)","v":"Poste 3"},{"$f":"IF(OR(NOT(ISNUMBER(C71)),C71<Job3_StartDate),\"\",IF(MID(Job3_Pattern,MOD(C71-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift1_Code,1,IF(MID(Job3_Pattern,MOD(C71-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift2_Code,2,IF(MID(Job3_Pattern,MOD(C71-Job3_StartDate,LEN(Job3_Pattern))+1,1)=Job3_Shift3_Code,3,\"\"))))","v":""},"","",3,"","","","","","",3,3,"","","",3,3,"","","","",3,3,"","","","",3,3,3,"","","","","","",""]

{"sheet":"Travaux et équipes","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[4,1,4,2],[6,1,8,1],[10,1,12,1],[14,1,16,1],[18,1,18,2],[20,1,20,2],[21,1,21,2]]}
[null,"Détails des tâches et des haoraires",{"$nulls":4}," "]
[]
[{"$nulls":3},"Poste 1","Poste 2","Poste 3"]
[]
[null,"Description des tâches",null,"Poste 1","Poste 2","Poste 3"]
[]
[null,"Horaire 1","Nom de l’horaire","Horaire de jour","Horaire de jour"]
[null,null,"Code","D","D"]
[null,null,"Heures","De 6:00 à 22:00","De 6:00 à 22:00"]
[]
[null,"Horaire 2","Nom de l’horaire","Horaire de nuit","Horaire de nuit"]
[null,null,"Code","N","N"]
[null,null,"Heures","De 22:00 à 12:00","De 22:00 à 12:00"]
[]
[null,"Horaire 3","Nom de l’horaire",null,null,"Mi-horaire"]
[null,null,"Code",null,null,"L"]
[null,null,"Heures",null,null,"De 14:00 à 16:00"]
[]
[null," Code congé",null,"x","x","x"]
[]
[null,"Date de début de l’horaire",null,{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),1,5)","v":"2020-01-05"},{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),1,15)","v":"2020-01-15"},{"$f":"DATE(_xlfn.SINGLE(AnnéeCivile),1,19)","v":"2020-01-19"}]
[null,"Modèle",null,"DDDDxxNNNNxxDDDxNNNxxxDDxNNxxx","NNNNxxxxxDxxNNNxxDDxxxNNxDDxxx","LLxxxxLLxxxxLLLxxxLxxxxxxLLxxx"]