{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":37,"n_cols":29,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Jour","Heure de début","Heure de fin","Salaire","Taux horaire","Collaborateur","victoire","2018-03-12","Si jour férier",{"$f":"1.6","v":1.6},"Majoration de 60%"]
["2018-03-12","23:08:00","17:45:00",{"$f":"IF(C2>B2,(C2-B2-IF(B2*1<\"6:00\"*1,\"6:00\"-B2,0))*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1),0)+IF(\"6:00\"-B2>0,((\"6:00\"-B2)*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1))*J3,IF(C2<B2,((\"24:00\"-B2)*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1)),0)+IF(C2-B2<0,((MIN(C2,\"6:00\")*24)*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1))*J3,0)+IF(C2-B2<0,IF(C2-\"6:00\">0,((C2-\"6:00\")*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1)),0),0))","v":538.06666666666661},17.5,"A","Pentacôte","2018-06-04","Si Dimanche +100%",2,"Majoration du double"]
[{"$f":"\"Le jour de la semaine \" & WEEKDAY(A2) & \" soit le lundi\"","v":"Le jour de la semaine 2 soit le lundi"},null,null,"OU",null,"B","Fête nationale","2018-07-14","Si heur de nuit +10%",1.1000000000000001,"Majoration de 10% pour les heures de nuit"]
[null,null,null,{"$f":"IF(C2>B2,(C2-B2-IF(B2*1<\"6:00\"*1,\"6:00\"-B2,0)),0)+IF(\"6:00\"-B2>0,(\"6:00\"-B2)*J3,IF(C2<B2,(\"24:00\"-B2),0)+IF(C2-B2<0,(MIN(C2,\"6:00\"))*J3,0)+IF(C2-B2<0,IF(C2-\"6:00\">0,(C2-\"6:00\"),0)))*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1)","v":538.06666666666672},null,"C","Toussaint","2018-11-01"]
[null,null,null,null,null,null,"Ascension","2018-05-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.5]
[null,null,null,null,null,null,"Armistice","2018-11-11"]
[null,null,null,null,null,null,"Noêl","2018-12-25"]
[]
[]
[]
[]
[null,null,null,null,null,"Cas B","Si heure de  la fin < heure du début - Heure avant minuit ","Heure de minuit à 6:00","Heures après 6:00 s'il y en a "]
[null,null,null,null,null,"Formule",{"$f":"IF(C2<B2,((\"24:00\"-B2)*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1)),0)","v":24.266666666666655},{"$f":"IF(C2-B2<0,((MIN(C2,\"6:00\")*24)*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1))*J3,0)","v":184.8},{"$f":"IF(C2-B2<0,IF(C2-\"6:00\">0,((C2-\"6:00\")*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1)),0),0)","v":329}]
[null,null,null,null,null,"Les 3 formules réunies :",{"$f":"IF(C2<B2,((\"24:00\"-B2)*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1)),0)+IF(C2-B2<0,((MIN(C2,\"6:00\")*24)*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1))*J3,0)+IF(C2-B2<0,IF(C2-\"6:00\">0,((C2-\"6:00\")*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1)),0),0)","v":538.06666666666661}]
[]
[null,null,null,null,null,"Cas A","Si Heure de fin > Heure de début sans les heures avant 6:00 (nuit) ","Ajout des heures entre minuit et 6:00 si le quart de travail a débuté avant 6:00 "]
[null,null,null,null,null,"Formule :",{"$f":"IF(C2>B2,(C2-B2-IF(B2*1<\"6:00\"*1,\"6:00\"-B2,0))*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1),0)","v":0},{"$f":"IF(\"6:00\"-B2>0,((\"6:00\"-B2)*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1))*J3,0)","v":0}]
[null,null,null,null,null,"Les 2 formules réunies :",{"$f":"IF(C2>B2,(C2-B2-IF(B2*1<\"6:00\"*1,\"6:00\"-B2,0))*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1),0)+IF(\"6:00\"-B2>0,((\"6:00\"-B2)*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1))*J3,0)","v":0}]
[]
[null,null,null,null,null,"Cas A Et B Réunis",{"$f":"IF(C2>B2,(C2-B2-IF(B2*1<\"6:00\"*1,\"6:00\"-B2,0))*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1),0)+IF(\"6:00\"-B2>0,((\"6:00\"-B2)*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1))*J3,IF(C2<B2,((\"24:00\"-B2)*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1)),0)+IF(C2-B2<0,((MIN(C2,\"6:00\")*24)*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1))*J3,0)+IF(C2-B2<0,IF(C2-\"6:00\">0,((C2-\"6:00\")*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1)),0),0))","v":538.06666666666661}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Cas B","Si heure de  la fin < heure du début - Heure avant minuit ","Heure de minuit à 6:00","Heures après 6:00 s'il y en a "]
[null,null,null,null,null,"Formule",{"$f":"IF(C2<B2,(\"24:00\"-B2),0)","v":"00:52:00"},{"$f":"IF(C2-B2<0,(MIN(C2,\"6:00\"))*J3,0)","v":"06:36:00"},{"$f":"IF(C2-B2<0,IF(C2-\"6:00\">0,(C2-\"6:00\"),0))","v":"11:45:00"}]
[null,null,null,null,null,"Les 3 formules réunies :",{"$f":"IF(C2<B2,(\"24:00\"-B2),0)+IF(C2-B2<0,(MIN(C2,\"6:00\"))*J3,0)+IF(C2-B2<0,IF(C2-\"6:00\">0,(C2-\"6:00\"),0))","v":"19:13:00"}]
[]
[null,null,null,null,null,"Cas A","Si Heure de fin > Heure de début sans les heures avant 6:00 (nuit) ","Ajout des heures entre minuit et 6:00 si le quart de travail a débuté avant 6:00 "]
[null,null,null,null,null,"Formule :",{"$f":"IF(C2>B2,(C2-B2-IF(B2*1<\"6:00\"*1,\"6:00\"-B2,0)),0)","v":"00:00:00"},{"$f":"IF(\"6:00\"-B2>0,(\"6:00\"-B2)*J3,0)","v":"00:00:00"}]
[null,null,null,null,null,"Les 2 formules réunies :",{"$f":"IF(C2>B2,(C2-B2-IF(B2*1<\"6:00\"*1,\"6:00\"-B2,0)),0)+IF(\"6:00\"-B2>0,(\"6:00\"-B2)*J3,0)","v":"00:00:00"}]
[]
[null,null,null,null,null,"Cas A Et B Réunis",{"$f":"IF(C2>B2,(C2-B2-IF(B2*1<\"6:00\"*1,\"6:00\"-B2,0)),0)+IF(\"6:00\"-B2>0,(\"6:00\"-B2)*J3,IF(C2<B2,(\"24:00\"-B2),0)+IF(C2-B2<0,(MIN(C2,\"6:00\"))*J3,0)+IF(C2-B2<0,IF(C2-\"6:00\">0,(C2-\"6:00\"),0)))*24*E2*IF(WEEKDAY(A2)=1,J2,1)*IF(ISNUMBER(MATCH(A2,Fetes,0)),J1,1)","v":538.06666666666672}]