{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calcul TP"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Calcul TP","index":0,"n_rows":82,"n_cols":6,"rows_kept":82,"cut":false,"hidden":false,"merged":[[2,0,2,6],[15,3,15,5],[18,3,18,5],[21,2,21,3]]}
[]
[]
["Calcul de la DHT  temps partiel semaines choisies"]
[]
["saisir le nombre d'heures pour un jour férié correspondant au cycle de l'agent soit :"]
[" 5,83 pour un cycle de 6 jours travaillés et 7 heures pour un cycle de 5 jours"]
[]
["saisir le nombre d'heures que l'agent aurait effectué réellement pendant sa semaine non travaillée"]
[]
["alerte sur les semaines comportant des jours fériés (à vérifier avec calendriers)"]
[]
["saisir les minutes en centièmes"]
[]
["calcul heures réellement travaillées"]
[]
[null,{"$f":"1607+F82","v":1274.49},null,"1607 - la somme des périodes non travaillées"]
[]
["Calcul Quotité "]
[null,{"$f":"(B16/1607)*100","v":79.308649657747353},"%","nombres d'heures travaillées / 1607 * 100"]
[]
["DHTdu salarié"]
[null,35,"heures /centièmes"]
[]
["Pour la saisie dans SIGP convertir la DHT en heures minutes"]
[]
[]
[]
["CALENDRIERS 2016",null,null,"jours fériés","semaines non travaillées heures à déduire","heures non travaillées"]
["semaine 1","2016-10-03",{"$f":"B29+6","v":"2016-10-09"},null,null,{"$f":"E29-D29","v":0}]
["semaine 2",{"$f":"C29+1","v":"2016-10-10"},{"$f":"B30+6","v":"2016-10-16"},null,null,{"$f":"E30-D30","v":0}]
["semaine 3",{"$f":"C30+1","v":"2016-10-17"},{"$f":"B31+6","v":"2016-10-23"},null,null,0]
["semaine 4","2016-10-24","2016-10-30",null,null,0]
["semaine 5","2016-10-31","2016-11-06",null,null,0]
["semaine 6","2016-11-07","2016-11-13",null,null,0]
["semaine 7","2016-11-14","2016-11-20",null,null,0]
["semaine 8","2016-11-21","2016-11-27",null,null,0]
["semaine 9","2016-11-28","2016-12-04",null,null,0]
["semaine 10","2016-12-05","2016-12-11",null,null,0]
["semaine 11","2016-12-12","2016-12-18",null,null,0]
["semaine 12","2016-12-19","2016-12-25",null,null,0]
["semaine 13","2016-12-26","2017-01-01",null,null,0]
["semaine 14","2017-01-02","2017-01-08",null,null,0]
["semaine 15","2017-01-09","2017-01-15",null,null,0]
["semaine 16","2017-01-16","2017-01-22",null,null,0]
["semaine 17","2017-01-23","2017-01-29",null,null,0]
["semaine 18","2017-01-30","2017-02-05",null,null,0]
["semaine 19","2017-02-06","2017-02-12",null,null,0]
["semaine 20","2017-02-13","2017-02-19",null,-35,-35]
["semaine 21","2017-02-20","2017-02-26",null,-35,-35]
["semaine 22","2017-02-27","2017-03-05",null,null,0]
["semaine 23","2017-03-06","2017-03-12",null,null,0]
["semaine 24","2017-03-13","2017-03-19",null,null,0]
["semaine 25","2017-03-20","2017-03-26",null,null,0]
["semaine 26","2017-03-27","2017-04-02",null,null,0]
["semaine 27","2017-04-03","2017-04-09",null,null,0]
["semaine 28","2017-04-10","2017-04-16",null,-35,-35]
["semaine 29","2017-04-17","2017-04-23",-11.66,-35,-23.34]
["semaine 30","2017-04-24","2017-04-30",null,null,0]
["semaine 31","2017-05-01","2017-05-07",null,null,0]
["semaine 32","2017-05-08","2017-05-14",null,null,0]
["semaine 33","2017-05-15","2017-05-21",null,-35,-35]
["semaine 34","2017-05-22","2017-05-28",null,null,0]
["semaine 35","2017-05-29","2017-06-04",null,null,0]
["semaine 36","2017-06-05","2017-06-11",null,null,0]
["semaine 37","2017-06-12","2017-06-18",null,-35,-35]
["semaine 38","2017-06-19","2017-06-25",null,null,0]
["semaine 39","2017-06-26","2017-07-02",null,null,0]
["semaine 40","2017-07-03","2017-07-09",null,null,0]
["semaine 41","2017-07-10","2017-07-16",-5.83,-35,-29.17]
["semaine 42","2017-07-17","2017-07-23",null,null,0]
["semaine 43","2017-07-24","2017-07-30",null,null,0]
["semaine 44","2017-07-31","2017-08-06",null,null,0]
["semaine 45","2017-08-07","2017-08-13",null,-35,-35]
["semaine 46","2017-08-14","2017-08-20",null,null,0]
["semaine 47","2017-08-21","2017-08-27",null,null,0]
["semaine 48","2017-08-28","2017-09-03",null,null,0]
["semaine 49","2017-09-04","2017-09-10",null,-35,-35]
["semaine 50","2017-09-11","2017-09-17",null,null,0]
["semaine 51","2017-09-18","2017-09-24",null,null,0]
["semaine 52","2017-09-25","2017-10-01",null,-35,-35]
[]
[null,null,null,null,null,{"$f":"SUM(F29:F80)","v":-332.51}]