{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Feuille de présence d’employé"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Feuille de présence d’employé","index":0,"n_rows":138,"n_cols":11,"rows_kept":138,"merged":[[0,0,0,10],[2,1,2,2],[4,1,4,2],[6,0,6,10],[16,0,16,1],[16,3,16,4],[27,0,27,1],[27,3,27,4],[38,0,38,1],[38,3,38,4],[39,0,39,10],[49,0,49,1],[49,3,49,4],[60,0,60,1],[60,3,60,4],[71,0,71,1],[71,3,71,4],[72,0,72,10],[82,0,82,1],[82,3,82,4],[93,0,93,1],[93,3,93,4],[104,0,104,1],[104,3,104,4],[105,0,105,10],[115,0,115,1],[115,3,115,4],[126,0,126,1],[126,3,126,4],[137,0,137,1],[137,3,137,4]]}
["Fichier de présence des employés : Quotidien, hebdomadaire, mensuel, annuel"]
[]
["Nom de l'employé :",null,null,"Adresse de messagerie :",null,"Totaux année à ce jour :"]
[]
["Responsable :",null,null,"Téléphone :",null,"Heures normales :",{"$f":"SUM(C17,C28,C39,C50,C61,C72,C83,C94,C105,C116,C127,C138)","v":{"v":40,"d":"40.00"}},"Heures supplémentaires :",{"$f":"SUM(F17,F28,F39,F50,F61,F72,F83,F94,F105,F116,F127,F138)","v":{"v":5,"d":"5.00"}},"Total :",{"$f":"SUM(G5:I5)","v":{"v":45,"d":"45.00"}}]
[]
["Janvier, février, mars "]
["Janvier","Semaine 1","Heures supplémentaires","Semaine 2","HeuresSup2","Semaine 3","HeuresSup3","Semaine 4","HeuresSup4","Semaine 5","HeuresSup5"]
["Lundi",{"v":8,"d":"8.00"},{"v":2,"d":"2.00"}]
["Mardi",{"v":8,"d":"8.00"}]
["Mercredi",{"v":8,"d":"8.00"}]
["Jeudi",{"v":8,"d":"8.00"},{"v":1,"d":"1.00"}]
["Vendredi",{"v":8,"d":"8.00"},{"v":2,"d":"2.00"}]
["Samedi"]
["Dimanche"]
["Total",{"$f":"SUBTOTAL(109,Table1[Semaine 1])","v":{"v":40,"d":"40.00"}},{"$f":"SUBTOTAL(109,Table1[Heures supplémentaires])","v":{"v":5,"d":"5.00"}},{"$f":"SUBTOTAL(109,Table1[Semaine 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table1[HeuresSup2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table1[Semaine 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table1[HeuresSup3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table1[Semaine 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table1[HeuresSup4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table1[Semaine 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table1[HeuresSup5])","v":{"v":0,"d":"0.00"}}]
["Heures normales janvier :",null,{"$f":"SUM(B16,D16,F16,H16,J16)","v":{"v":40,"d":"40.00"}},"Heures supplémentaires janvier :",null,{"$f":"SUM(C16,E16,G16,I16,K16)","v":{"v":5,"d":"5.00"}}]
[]
["Février","Semaine 1","Heures supplémentaires","Semaine 2","HeuresSup2","Semaine 3","HeuresSup3","Semaine 4","HeuresSup4","Semaine 5","HeuresSup5"]
["Lundi"]
["Mardi"]
["Mercredi"]
["Jeudi"]
["Vendredi"]
["Samedi"]
["Dimanche"]
["Total",{"$f":"SUBTOTAL(109,Table2[Semaine 1])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table2[Heures supplémentaires])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table2[Semaine 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table2[HeuresSup2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table2[Semaine 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table2[HeuresSup3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table2[Semaine 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table2[HeuresSup4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table2[Semaine 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Table2[HeuresSup5])","v":{"v":0,"d":"0.00"}}]
["Heures normales février :",null,{"$f":"SUM(B27,D27,F27,H27,J27)","v":{"v":0,"d":"0.00"}},"Heures supplémentaires février :",null,{"$f":"SUM(C27,E27,G27,I27,K27)","v":{"v":0,"d":"0.00"}}]
[]
["Mars","Semaine 1","Heures supplémentaires","Semaine 2","HeuresSup2","Semaine 3","HeuresSup3","Semaine 4","HeuresSup4","Semaine 5","HeuresSup5"]
["Lundi"]
["Mardi"]
["Mercredi"]
["Jeudi"]
["Vendredi"]
["Samedi"]
["Dimanche"]
["Total",{"$f":"SUBTOTAL(109,B31:B37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Heures normales mars :",null,{"$f":"SUM(B38,D38,F38,H38,J38)","v":{"v":0,"d":"0.00"}},"Heures supplémentaires mars :",null,{"$f":"SUM(C38,E38,G38,I38,K38)","v":{"v":0,"d":"0.00"}}]
["Avril, mai, juin"]
["Avril","Semaine 1","Heures supplémentaires","Semaine 2","HeuresSup2","Semaine 3","HeuresSup3","Semaine 4","HeuresSup4","Semaine 5","HeuresSup5"]
["Lundi"]
["Mardi"]
["Mercredi"]
["Jeudi"]
["Vendredi"]
["Samedi"]
["Dimanche"]
["Total",{"$f":"SUBTOTAL(109,B42:B48)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Heures normales avril :",null,{"$f":"SUM(B49,D49,F49,H49,J49)","v":{"v":0,"d":"0.00"}},"Heures supplémentaires avril :",null,{"$f":"SUM(C49,E49,G49,I49,K49)","v":{"v":0,"d":"0.00"}}]
[]
["Mai","Semaine 1","Heures supplémentaires","Semaine 2","HeuresSup2","Semaine 3","HeuresSup3","Semaine 4","HeuresSup4","Semaine 5","HeuresSup5"]
["Lundi"]
["Mardi"]
["Mercredi"]
["Jeudi"]
["Vendredi"]
["Samedi"]
["Dimanche"]
["Total",{"$f":"SUBTOTAL(109,B53:B59)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Heures normales mai :",null,{"$f":"SUM(B60,D60,F60,H60,J60)","v":{"v":0,"d":"0.00"}},"Heures supplémentaires mai :",null,{"$f":"SUM(C60,E60,G60,I60,K60)","v":{"v":0,"d":"0.00"}}]
[]
["Juin","Semaine 1","Heures supplémentaires","Semaine 2","HeuresSup2","Semaine 3","HeuresSup3","Semaine 4","HeuresSup4","Semaine 5","HeuresSup5"]
["Lundi"]
["Mardi"]
["Mercredi"]
["Jeudi"]
["Vendredi"]
["Samedi"]
["Dimanche"]
["Total",{"$f":"SUBTOTAL(109,B64:B70)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Heures normales juin :",null,{"$f":"SUM(B71,D71,F71,H71,J71)","v":{"v":0,"d":"0.00"}},"Heures supplémentaires juin :",null,{"$f":"SUM(C71,E71,G71,I71,K71)","v":{"v":0,"d":"0.00"}}]
["Juillet, août, septembre  "]
["Juillet","Semaine 1","Heures supplémentaires","Semaine 2","HeuresSup2","Semaine 3","HeuresSup3","Semaine 4","HeuresSup4","Semaine 5","HeuresSup5"]
["Lundi"]
["Mardi"]
["Mercredi"]
["Jeudi"]
["Vendredi"]
["Samedi"]
["Dimanche"]
["Total",{"$f":"SUBTOTAL(109,B75:B81)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Heures normales juillet :",null,{"$f":"SUM(B82,D82,F82,H82,J82)","v":{"v":0,"d":"0.00"}},"Heures supplémentaires juillet :",null,{"$f":"SUM(C82,E82,G82,I82,K82)","v":{"v":0,"d":"0.00"}}]
[]
["Août","Semaine 1","Heures supplémentaires","Semaine 2","HeuresSup2","Semaine 3","HeuresSup3","Semaine 4","HeuresSup4","Semaine 5","HeuresSup5"]
["Lundi"]
["Mardi"]
["Mercredi"]
["Jeudi"]
["Vendredi"]
["Samedi"]
["Dimanche"]
["Total",{"$f":"SUBTOTAL(109,B86:B92)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Heures normales août :",null,{"$f":"SUM(B93,D93,F93,H93,J93)","v":{"v":0,"d":"0.00"}},"Heures supplémentaires août :",null,{"$f":"SUM(C93,E93,G93,I93,K93)","v":{"v":0,"d":"0.00"}}]
[]
["Septembre","Semaine 1","Heures supplémentaires","Semaine 2","HeuresSup2","Semaine 3","HeuresSup3","Semaine 4","HeuresSup4","Semaine 5","HeuresSup5"]
["Lundi"]
["Mardi"]
["Mercredi"]
["Jeudi"]
["Vendredi"]
["Samedi"]
["Dimanche"]
["Total",{"$f":"SUBTOTAL(109,B97:B103)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Heures normales septembre :",null,{"$f":"SUM(B104,D104,F104,H104,J104)","v":{"v":0,"d":"0.00"}},"Heures supplémentaires septembre :",null,{"$f":"SUM(C104,E104,G104,I104,K104)","v":{"v":0,"d":"0.00"}}]
["Octobre, novembre, décembre"]
["Octobre","Semaine 1","Heures supplémentaires","Semaine 2","HeuresSup2","Semaine 3","HeuresSup3","Semaine 4","HeuresSup4","Semaine 5","HeuresSup5"]
["Lundi"]
["Mardi"]
["Mercredi"]
["Jeudi"]
["Vendredi"]
["Samedi"]
["Dimanche"]
["Total",{"$f":"SUBTOTAL(109,B108:B114)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Heures normales octobre :",null,{"$f":"SUM(B115,D115,F115,H115,J115)","v":{"v":0,"d":"0.00"}},"Heures supplémentaires octobre :",null,{"$f":"SUM(C115,E115,G115,I115,K115)","v":{"v":0,"d":"0.00"}}]
[]
["Novembre","Semaine 1","Heures supplémentaires","Semaine 2","HeuresSup2","Semaine 3","HeuresSup3","Semaine 4","HeuresSup4","Semaine 5","HeuresSup5"]
["Lundi"]
["Mardi"]
["Mercredi"]
["Jeudi"]
["Vendredi"]
["Samedi"]
["Dimanche"]
["Total",{"$f":"SUBTOTAL(109,B119:B125)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Heures normales novembre :",null,{"$f":"SUM(B126,D126,F126,H126,J126)","v":{"v":0,"d":"0.00"}},"Heures supplémentaires novembre :",null,{"$f":"SUM(C126,E126,G126,I126,K126)","v":{"v":0,"d":"0.00"}}]
[]
["Décembre","Semaine 1","Heures supplémentaires","Semaine 2","HeuresSup2","Semaine 3","HeuresSup3","Semaine 4","HeuresSup4","Semaine 5","HeuresSup5"]
["Lundi"]
["Mardi"]
["Mercredi"]
["Jeudi"]
["Vendredi"]
["Samedi"]
["Dimanche"]
["Total",{"$f":"SUBTOTAL(109,B130:B136)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Heures normales décembre :",null,{"$f":"SUM(B137,D137,F137,H137,J137)","v":{"v":0,"d":"0.00"}},"Heures supplémentaires décembre :",null,{"$f":"SUM(C137,E137,G137,I137,K137)","v":{"v":0,"d":"0.00"}}]