{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","paramêtre"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":41,"n_cols":113,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["ANNÉE",null,"2020-01-01",null,null,null,null,null,null,null,"FERIÉE","   WEEK-END",null,22,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date","Fériée"]
["Mois",null,{"$f":"INDEX(mois,D2)","v":"2020-05-01"},5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-01","jour de l'an"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-12","pâques"]
[{"$f":"\"Semaine \"& WEEKNUM(B4)","v":"Semaine 18"},{"$f":"C2","v":"2020-05-01"},null,"Entrée","Pause","Sortie","T/Hr","Hr/25%","Hr/50%","Nuit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-13","lundi de pâques"]
[{"$f":"C5","v":"2020-05-01"},null,{"$f":"C2","v":"2020-05-01"},null,null,null,{"$f":"IF(D5=\"\",\"\",(MOD(F5-D5,24)))","v":""},{"$f":"IF(G5<>\"\",G5-$N$1,\"\")","v":""},null,{"$f":"MOD($F5-$D5,24)-($F5<$D5)*($N$1-$O$1)-MEDIAN($F5,$O$1,$N$1)+MEDIAN($D5,$O$1,$N$1)","v":0},null,null,"Bouton effacé  pour les cellules",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-01","fête du travail"]
[{"$f":"A5+1","v":"2020-05-02"},null,{"$f":"C5+1","v":"2020-05-02"},19,null,5,{"$f":"IF(D6=\"\",\"\",(MOD(F6-D6,24)))","v":10},{"$f":"IF(G6<>\"\",G6-$N$1,\"\")","v":-12},null,{"$f":"MOD($F6-$D6,24)-($F6<$D6)*($N$1-$O$1)-MEDIAN($F6,$O$1,$N$1)+MEDIAN($D6,$O$1,$N$1)","v":7},null,null,"D5:F11;D13:F19;D21:F27;D29:F35;D37:F39",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-08","victoire 1945"]
[{"$f":"A6+1","v":"2020-05-03"},null,{"$f":"C6+1","v":"2020-05-03"},19,null,5,10,-12,null,{"$f":"MOD($F7-$D7,24)-($F7<$D7)*($N$1-$O$1)-MEDIAN($F7,$O$1,$N$1)+MEDIAN($D7,$O$1,$N$1)","v":7},null,null,"Jais une macro mais es- que long peut faire pareille San macro ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-21","ascention"]
[{"$f":"A7+1","v":"2020-05-04"},null,{"$f":"C7+1","v":"2020-05-04"},null,null,null,"","",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-31","pantecôte"]
["2020-05-05",null,"2020-05-05",null,null,null,"","",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-01","lundi de pantecôte"]
["2020-05-06",null,"2020-05-06",null,null,null,"","",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-07-14","fête national"]
[{"$f":"A10+1","v":"2020-05-07"},null,"2020-05-07",null,null,null,{"$f":"IF(D11=\"\",\"\",(MOD(F11-D11,24)))","v":""},"",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-08-15","assonption"]
[{"$f":"\"Semaine \"& WEEKNUM(B12)","v":"Semaine 19"},{"$f":"B4+7","v":"2020-05-08"},null,{"$f":"SUM(G5:G11)","v":20},null,"TOTAL :",{"$f":"MIN(35/24*24,SUM(G5:G11))","v":20},{"$f":"MIN(8/24*24,SUM(D12-G12))","v":0},{"$f":"SUM(G5:G11)-G12-H12","v":0},{"$f":"SUM(J5:J11)","v":14},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-01","toussaint"]
[{"$f":"C13","v":"2020-05-08"},null,{"$f":"C11+1","v":"2020-05-08"},null,null,null,"",{"$f":"IF(G13<>\"\",G13-$N$1,\"\")","v":""},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-11","armistice"]
[{"$f":"A13+1","v":"2020-05-09"},null,{"$f":"C13+1","v":"2020-05-09"},null,null,null,{"$f":"IF(D14=\"\",\"\",(MOD(F14-D14,24)))","v":""},"",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-25","noêl"]
[{"$f":"A14+1","v":"2020-05-10"},null,{"$f":"C14+1","v":"2020-05-10"},null,null,null,"","",null,0]
[{"$f":"A15+1","v":"2020-05-11"},null,"2020-05-11",null,null,null,"","",null,0]
["2020-05-12",null,"2020-05-12",null,null,null,"","",null,0]
["2020-05-13",null,"2020-05-13",null,null,null,"","",null,0]
[{"$f":"A18+1","v":"2020-05-14"},null,"2020-05-14",null,null,null,{"$f":"IF(D19=\"\",\"\",(MOD(F19-D19,24)))","v":""},"",null,{"$f":"MOD($F19-$D19,24)-($F19<$D19)*($N$1-$O$1)-MEDIAN($F19,$O$1,$N$1)+MEDIAN($D19,$O$1,$N$1)","v":0}]
[{"$f":"\"Semaine \"& WEEKNUM(B20)","v":"Semaine 20"},{"$f":"B12+7","v":"2020-05-15"},null,{"$f":"SUM(G13:G19)","v":0},null,"TOTAL :",{"$f":"MIN(35/24*24,SUM(G13:G19))","v":0},{"$f":"MIN(8/24*24,SUM(D20-G20))","v":0},{"$f":"SUM(G13:G19)-G20-H20","v":0},{"$f":"SUM(J13:J19)","v":0}]
[{"$f":"C21","v":"2020-05-15"},null,{"$f":"C19+1","v":"2020-05-15"},null,null,null,"","",null,{"$f":"MOD($F21-$D21,24)-($F21<$D21)*($N$1-$O$1)-MEDIAN($F21,$O$1,$N$1)+MEDIAN($D21,$O$1,$N$1)","v":0}]
[{"$f":"A21+1","v":"2020-05-16"},null,{"$f":"C21+1","v":"2020-05-16"},null,null,null,"","",null,{"$f":"MOD($F22-$D22,24)-($F22<$D22)*($N$1-$O$1)-MEDIAN($F22,$O$1,$N$1)+MEDIAN($D22,$O$1,$N$1)","v":0}]
[{"$f":"A22+1","v":"2020-05-17"},null,{"$f":"C22+1","v":"2020-05-17"},null,null,null,"","",null,0]
[{"$f":"A23+1","v":"2020-05-18"},null,"2020-05-18",null,null,null,"","",null,0]
["2020-05-19",null,"2020-05-19",null,null,null,"","",null,0]
["2020-05-20",null,"2020-05-20",null,null,null,"","",null,0]
[{"$f":"A26+1","v":"2020-05-21"},null,"2020-05-21",null,null,null,"","",null,{"$f":"MOD($F27-$D27,24)-($F27<$D27)*($N$1-$O$1)-MEDIAN($F27,$O$1,$N$1)+MEDIAN($D27,$O$1,$N$1)","v":0}]
[{"$f":"\"Semaine \"& WEEKNUM(B28)","v":"Semaine 21"},{"$f":"B20+7","v":"2020-05-22"},null,{"$f":"SUM(G21:G27)","v":0},null,"TOTAL :",{"$f":"MIN(35/24*24,SUM(G21:G27))","v":0},{"$f":"MIN(7/24*24,SUM(D28-G28))","v":0},{"$f":"SUM(G21:G27)-G28-H28","v":0},{"$f":"SUM(J21:J27)","v":0}]
[{"$f":"C29","v":"2020-05-22"},null,{"$f":"C27+1","v":"2020-05-22"},null,null,null,"","",null,{"$f":"MOD($F29-$D29,24)-($F29<$D29)*($N$1-$O$1)-MEDIAN($F29,$O$1,$N$1)+MEDIAN($D29,$O$1,$N$1)","v":0}]
[{"$f":"A29+1","v":"2020-05-23"},null,{"$f":"C29+1","v":"2020-05-23"},null,null,null,"","",null,{"$f":"MOD($F30-$D30,24)-($F30<$D30)*($N$1-$O$1)-MEDIAN($F30,$O$1,$N$1)+MEDIAN($D30,$O$1,$N$1)","v":0}]
[{"$f":"A30+1","v":"2020-05-24"},null,{"$f":"C30+1","v":"2020-05-24"},null,null,null,"","",null,{"$f":"MOD($F31-$D31,24)-($F31<$D31)*($N$1-$O$1)-MEDIAN($F31,$O$1,$N$1)+MEDIAN($D31,$O$1,$N$1)","v":0}]
[{"$f":"A31+1","v":"2020-05-25"},null,"2020-05-25",null,null,null,"","",null,0]
["2020-05-26",null,"2020-05-26",null,null,null,"","",null,0]
["2020-05-27",null,"2020-05-27",null,null,null,"","",null,0]
[{"$f":"A34+1","v":"2020-05-28"},null,"2020-05-28",null,null,null,"","",null,{"$f":"MOD($F35-$D35,24)-($F35<$D35)*($N$1-$O$1)-MEDIAN($F35,$O$1,$N$1)+MEDIAN($D35,$O$1,$N$1)","v":0}]
[{"$f":"\"Semaine \"& WEEKNUM(B36)","v":"Semaine 22"},{"$f":"B28+7","v":"2020-05-29"},null,{"$f":"SUM(G29:G35)","v":0},null,"TOTAL :",{"$f":"MIN(35/24*24,SUM(G29:G35))","v":0},{"$f":"MIN(7/24*24,SUM(D36-G36))","v":0},{"$f":"SUM(G29:G35)-G36-H36","v":0},{"$f":"SUM(J29:J35)","v":0}]
[{"$f":"C37","v":"2020-05-29"},null,{"$f":"C35+1","v":"2020-05-29"},null,null,null,"","",null,{"$f":"MOD($F37-$D37,24)-($F37<$D37)*($N$1-$O$1)-MEDIAN($F37,$O$1,$N$1)+MEDIAN($D37,$O$1,$N$1)","v":0}]
[{"$f":"A37+1","v":"2020-05-30"},null,{"$f":"C37+1","v":"2020-05-30"},null,null,null,"","",null,{"$f":"MOD($F38-$D38,24)-($F38<$D38)*($N$1-$O$1)-MEDIAN($F38,$O$1,$N$1)+MEDIAN($D38,$O$1,$N$1)","v":0}]
[{"$f":"A38+1","v":"2020-05-31"},null,{"$f":"C38+1","v":"2020-05-31"},null,null,null,"","",null,{"$f":"MOD($F39-$D39,24)-($F39<$D39)*($N$1-$O$1)-MEDIAN($F39,$O$1,$N$1)+MEDIAN($D39,$O$1,$N$1)","v":0}]
[{"$f":"A39+1","v":"2020-06-01"},null,{"$f":"C39+1","v":"2020-06-01"},null,null,null,null,null,null,{"$f":"MOD($F40-$D40,24)-($F40<$D40)*($N$1-$O$1)-MEDIAN($F40,$O$1,$N$1)+MEDIAN($D40,$O$1,$N$1)","v":0},{"$f":"EDATE(C2,1)","v":"2020-06-01"}]
["2020-06-02",null,{"$f":"C40+1","v":"2020-06-02"},null,null,null,null,null,null,{"$f":"MOD($F41-$D41,24)-($F41<$D41)*($N$1-$O$1)-MEDIAN($F41,$O$1,$N$1)+MEDIAN($D41,$O$1,$N$1)","v":0}]

{"sheet":"paramêtre","index":1,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Feuil1!C1","v":"2020-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O1+31","v":"2020-02-01"}]
[null,null,2021,null,null,null,"Jour de l'an","   =DATE($C$3;1;1)",null,null,null,null,null,null,{"$f":"O2+30","v":"2020-03-02"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O3+30","v":"2020-04-01"}]
["mois","Année",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O4+30","v":"2020-05-01"}]
["=DATE(D2;MOIS(\"1/\"&C2);1)",null,null,{"$f":" DATE($C$3,1,1)","v":"2021-01-01"},null,"Jour de l'an",null,null,null,null,null,null,null,null,{"$f":"O5+31","v":"2020-06-01"}]
["=NB.SI($DI$1:$DJ$14;C5)=1",null,null,{"$f":"FLOOR(DAY(MINUTE($C$3/38)/2+56)&\"/5/\"&$C$3,7)-34","v":"2021-04-04"},null,"Pâques","Pâques                                =PLANCHER(JOUR(MINUTE($C$3/38)/2+56)&\"/5/\"&$C$3;7)-34",null,null,null,null,null,null,null,{"$f":"O6+31","v":"2020-07-02"}]
["condition jour fériée",null,null,{"$f":" D7 + 1","v":"2021-04-05"},null,"Lundi de Pâques","Lundi de Pâques","   =D7+1",null,null,null,null,null,null,{"$f":"O7+30","v":"2020-08-01"}]
["D2 = (2020 deroulant)",null,null,{"$f":" DATE($C$3,5,1)","v":"2021-05-01"},null,"Fête du travail","Fête du travail","   =DATE($C$3;5;1)",null,null,null,null,null,null,{"$f":"O8+30","v":"2020-08-31"}]
["C2 = (mois déroulant)",null,null,{"$f":" DATE($C$3,5,8)","v":"2021-05-08"},null,"Armistice 39/45","Armistice 39/45","   =DATE($C$3;5;8)",null,null,null,null,null,null,{"$f":"O9+31","v":"2020-10-01"}]
[null,null,null,{"$f":" D7 + 39","v":"2021-05-13"},null,"Ascension","Ascension","   =D7+39",null,null,null,null,null,null,{"$f":"O10+31","v":"2020-11-01"}]
[null,null,null,{"$f":" D7 + 49","v":"2021-05-23"},null,"Pentecôte","Pentecôte","   =D7+49",null,null,null,null,null,null,{"$f":"O11+31","v":"2020-12-02"}]
[null,{"$f":"C3","v":2021},null,{"$f":" D7 + 50","v":"2021-05-24"},null,"Lundi de Pentecôte","Lundi de Pentecôte","   =D7+50"]
[null,null,null,{"$f":" DATE($C$3,7,14)","v":"2021-07-14"},null,"Fête Nationale","Fête Nationale","   =DATE($C$3;7;14)"]
[null,null,null,{"$f":" DATE($C$3,8,15)","v":"2021-08-15"},null,"Assomption","Assomption","   =DATE($C$3;8;15)"]
[null,null,null,{"$f":" DATE($C$3,11,1)","v":"2021-11-01"},null,"Toussaint","Toussaint","   =DATE($C$3;11;1)"]
[null,null,null,{"$f":" DATE($C$3,11,11)","v":"2021-11-11"},null,"Armistice 14/18","Armistice 14/18","   =DATE($C$3;11;11)"]
[null,null,null,{"$f":" DATE($C$3,12,25)","v":"2021-12-25"},null,"Noël","Noël","   =DATE($C$3;12;25)"]
[]
[null,null,null,null,null,null,"1) il faut afficher l'onglet développeur (voir dans les options)"]
[null,null,null,null,null,null,"2) Insérer / Toupie : soit depuis les contrôles de formulaire, soit depuis les ActiveX / dessiner le contrôle"]
[null,null,null,null,null,null,"Pour un contrôle de formulaire : Clic droit / format du contrôle / régler min, max et lier la cellule située sous la toupie"]
[null,"Total Journée:",null,null,null,null,"Pour un ActiveX / Clic droit Propriétés / régler min, max et lier la cellule située sous la toupie (LinkedCell)/ désactiver le mode création"]
[null,"=SI(D5=\"\";\"\";(MOD(F5-D5;24)))"]
[null,"Heurre de Nuits:"]
[null,"=MOD($F5-$D5;24)-($F5<$D5)*($P$1-$O$1)-MEDIANE($F5;$O$1;$P$1)+MEDIANE($D5;$O$1;$P$1)"]
[null,"Heurre 25%",null,null,null,"o,6,00","p,22,00"]
[null,"=SI(G5<>\"\";G57-$N$1;\"\")    (N=7 linge 1)"]
[null,"dépasse pas 7: arrêt total puis pas a 50%"]
[null,"=MIN(8/24*24;SOMME(G12-D12))"]
[null,"Heurre 50%   "]
[null,"=SOMME(I4:I8)-I10   (somme 25%-total 25%)"]
[]
[null,"dépasse pas 35h"]
[null,"=MIN(35/24*24;SOMME(F4:F9))"]
[]
[null,"=SI(NB(B3:C3;24)<2;\"\";"]
[]
[null,"pour si en entré rien et sortie =total journée =celule vide"]
[]
[null,"=SI(E11=\"\";\"\";(MOD(E11-c11;24)))"]
[]
["Les heures supplémentaires seront comptabilisées en semaine civile."]
["Plus précisément, en application de l'article L 3121-35 du Code du Travail,"]
["la semaine débute le lundi à 0 heure et se termine le dimanche à 24 heures."]