{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Formulaires","Service","Cgn"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Formulaires","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"merged":[[1,1,1,14]]}
[]
[null,"INDEX FORMULAIRES"]

{"sheet":"Service","index":1,"n_rows":7,"n_cols":15,"rows_kept":7,"merged":[[3,1,3,14],[4,1,4,3],[4,5,4,7],[4,8,4,9],[4,10,4,12]]}
[]
[{"$nulls":4},"Colonne masquée"]
[]
[null,"Services selon Graphiques"]
[null,"Services ",{"$nulls":3},"Tour de service (TDS)",null,null,"Pauses",null,"Travail de nuit",null,null,"D.T.","Bonus"]
[null,"Année","Période","T.service","Concat. service","Début","Fin ","Durée TDS","Déduites","Compensée","De 22h.-24h.","Plus de minuit ","Avant  06h.","Sans comp.","Total des bonus"]
[null,18,"A","lm1",{"$f":"CONCATENATE(Tableau1[Année],Tableau1[Période],Tableau1[T.service])","v":"18Alm1"},0.1840277777777778,0.5104166666666666,{"$f":"MOD(Tableau1[[Fin ]]-Tableau1[Début],1)","v":0.32638888888888884},0,0,{"$f":"IF(OR(Tableau1[[#This Row],[Début]]=\"\",Tableau1[[Fin ]]=\"\"),Cgn!$F$5,IF(Tableau1[[Fin ]]>Cgn!$E$7,(Tableau1[[Fin ]]-Cgn!$E$7)*Cgn!$G$7,(IF(Tableau1[[Fin ]]<Cgn!$F$8,Cgn!$G$5,Cgn!$E$8))))","v":0},{"$f":"IF(Tableau1[[Fin ]]<Cgn!$F$8,(Tableau1[[Fin ]]-Cgn!$F$5)*Cgn!$G$8,Cgn!$F$5)","v":0},{"$f":"IF(Tableau1[Début]<Cgn!$F$8,(Cgn!$F$8-Tableau1[Début])*Cgn!$G$8,Cgn!$F$5)","v":0.026388888888888885},{"$f":"Tableau1[Durée TDS]-Tableau1[Déduites]-Tableau1[Compensée]","v":0.32638888888888884},{"$f":"Tableau1[Compensée]+Tableau1[De 22h.-24h.]+Tableau1[[Plus de minuit ]]+Tableau1[Avant  06h.]","v":0.026388888888888885}]

{"sheet":"Cgn","index":2,"n_rows":18,"n_cols":14,"rows_kept":18,"merged":[[3,9,3,10]]}
["C"]
[]
[]
[{"$nulls":3},"Conditions horaires",{"$nulls":5},"Période horaire",null,null,"Année"]
[{"$nulls":3},"Durée jour de traval",0.3416666666666666,0,0.020833333333333332,null,null,"Périodes","Abrév.",null,"Année","Abr"]
[{"$nulls":3},"Nbre de jour ouvrable sem.",5,{"$f":"SUM(E5*E6)","v":1.708333333333333},"Semaine",null,null,"Printemps","P",null,2018,18]
[{"$nulls":3},"Heure  de nuit comp. ",0.9166666666666666,1,{"v":0.25,"d":"25%"},null,null,"Eté","E",null,2019,19]
[{"$nulls":3},"Heure comp. ",0,0.25,{"v":0.4,"d":"40%"},null,null,"Automne","A",null,2020,20]
[{"$nulls":3},"Prix du km",null,"0.90",{"$nulls":3},"Hiver","H",null,2021,21]
[{"$nulls":3},"Durée du travail jour","Hiver/print.",0.4166666666666667,{"$nulls":6},2022,22]
[null,null,"Eté","2018-05-01","2014-10-30",0.5,{"$nulls":6},2023,23]
[{"$nulls":3},"Heures supplémentaire",{"v":1.25,"d":"125%"},{"v":1.5,"d":"150%"},{"v":2,"d":"200%"},{"$nulls":5},2024,24]
[{"$nulls":3},"Repas","Déjeuné",{"v":9,"d":"9 CHF"},{"$nulls":6},2025,25]
[{"$nulls":4},"Diner",{"v":27,"d":"27 CHF"}]
[{"$nulls":4},"Souper",{"v":27,"d":"27 CHF"}]
[{"$nulls":4},"Casse-croute",{"v":10,"d":"10 CHF"}]
[]
[{"$nulls":4},"Dimanche",{"v":60,"d":"60 CHF"}]