{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["TS","Activités"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"TS","index":0,"n_rows":46,"n_cols":42,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,20,2,27],[45,2,45,10],[46,2,50,10],[45,16,45,24],[46,16,50,24],[1,9,2,18],[3,9,3,18],[4,9,4,18],[5,9,5,18],[6,9,6,18],[7,9,7,18],[8,9,8,18],[9,9,9,18],[3,20,3,26],[4,20,4,26],[5,20,5,26],[6,20,6,26],[7,20,7,26],[8,20,8,26],[9,20,9,26],[12,0,12,1],[1,0,2,7],[13,0,13,1],[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,1,8,7],[9,1,9,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Janvier",2022,"2022-01-01"]
["Références du collaborateur",null,null,null,null,null,null,null,null,"Référence du/des projets subventionnés",null,null,null,null,null,null,null,null,null,null,"Absences",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Février",2023,"2022-04-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mars",2024,"2022-05-01"]
["Nom du Bénéficiaire/Partenaire",null,null,null,null,null,null,null,null,"Projet 1",null,null,null,null,null,null,null,null,null,null,"Weekend",null,null,null,null,null,null,"WE",null,null,null,null,null,null,null,null,null,"Avril",2025,"2022-05-26",{"$f":"J4","v":"Projet 1"},"projet_1"]
["Nom du collaborateur",null,null,null,null,null,null,null,null,"Projet 2",null,null,null,null,null,null,null,null,null,null,"Maladie",null,null,null,null,null,null,"M",null,null,null,null,null,null,null,null,null,"Mai",2026,"2022-06-06","Projet 2","projet_2"]
["Nom du responsable hiérarchique",null,null,null,null,null,null,null,null,"Projet 3",null,null,null,null,null,null,null,null,null,null,"Congé légal",null,null,null,null,null,null,"C",null,null,null,null,null,null,null,null,null,"Juin",null,"2022-07-21","Projet 3","projet_3"]
["Régime de travail (indiquer %)",1,null,null,null,null,null,null,null,"Projet 4",null,null,null,null,null,null,null,null,null,null,"Jours fériés",null,null,null,null,null,null,"JF",null,null,null,null,null,null,null,null,null,"Juillet",null,"2022-08-15","Projet 4","projet_4"]
["Plafond annuel",{"$f":"1720*B7","v":1720},null,null,null,null,null,null,null,"Projet 5",null,null,null,null,null,null,null,null,null,null,"Autres motifs",null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,"Août",null,null,"Projet 5","projet_5"]
["Année",2022,null,null,null,null,null,null,null,"Projet 6",null,null,null,null,null,null,null,null,null,null,"Récupération",null,null,null,null,null,null,"R",null,null,null,null,null,null,null,null,null,"Septembre",null,"2022-11-01","Projet 6","projet_6"]
["Mois",1,null,null,null,null,null,null,null,"Projet 7",null,null,null,null,null,null,null,null,null,null,"Temps partiel",null,null,null,null,null,null,"TP",null,null,null,null,null,null,null,null,null,"Octobre",null,"2022-12-25","Projet 7","projet_7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Novembre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Décembre"]
["Jours du calendrier",null,{"$f":"DATE(B9,B10,1)","v":"2022-01-01"},{"$f":"C13+1","v":"2022-01-02"},{"$f":"D13+1","v":"2022-01-03"},"2022-01-04","2022-01-05","2022-01-06","2022-01-07","2022-01-08","2022-01-09","2022-01-10","2022-01-11","2022-01-12","2022-01-13","2022-01-14","2022-01-15","2022-01-16","2022-01-17","2022-01-18","2022-01-19","2022-01-20","2022-01-21","2022-01-22","2022-01-23","2022-01-24","2022-01-25","2022-01-26","2022-01-27","2022-01-28","2022-01-29","2022-01-30","2022-01-31","Total"]
["Absences",null,{"$f":"IF(WEEKDAY(C13,2)>5,\"WE\",\"\")","v":"WE"},{"$f":"IF(WEEKDAY(D13,2)>5,\"WE\",\"\")","v":"WE"},{"$f":"IF(WEEKDAY(E13,2)>5,\"WE\",\"\")","v":""},"","","","","WE","WE","","","","","","WE","WE","","","","","","WE","WE","","","","","","WE","WE",""]
["Intitulé du projet","Activités"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C16:AF16)","v":0},null,null,{"$f":"VLOOKUP(A16,$AO$4:$AP$10,2,TRUE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C17:AF17)","v":0},null,null,{"$f":"VLOOKUP(A17,$AO$4:$AP$10,2,TRUE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,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,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,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,0,null,null,{"$f":"VLOOKUP(A25,$AO$4:$AP$10,2,TRUE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$error":"#N/A"}]
[null,{"$f":"\"Total - \"&J4","v":"Total - Projet 1"},{"$f":"SUMIF($A$16:$A$34,$J4,C$16:C$34)","v":0},{"$f":"SUMIF($A$16:$A$34,$J4,D$16:D$34)","v":0},{"$f":"SUM(E16:E34)","v":0},{"$f":"SUMIF($A$16:$A$34,$J4,F$16:F$34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMIF($A$16:$A$34,$J4,AH$16:AH$34)","v":0}]
[null,"Total - Projet 2",{"$f":"SUMIF($A$16:$A$34,$J5,C$16:C$34)","v":0},{"$f":"SUMIF($A$16:$A$34,$J5,D$16:D$34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMIF($A$16:$A$34,$J5,AH$16:AH$34)","v":0}]
[null,"Total - Projet 3",{"$f":"SUMIF($A$16:$A$34,$J6,C$16:C$34)","v":0},{"$f":"SUMIF($A$16:$A$34,$J$6,D$16:D$34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total - Projet 4",{"$f":"SUMIF($A$16:$A$34,$J$7,C$16:C$34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total - Projet 5",{"$f":"SUMIF($A$16:$A$34,$J$8,C$16:C$34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total - Projet 6",{"$f":"SUMIF($A$16:$A$34,$J$9,C$16:C$34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total - Projet 7",{"$f":"SUMIF($A$16:$A$34,$J$10,C$16:C$34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Heures HORS SUBVENTION",{"$f":"SUMIF($A$16:$A$34,$Q$11,C$16:C$34)","v":0},{"$f":"SUMIF($A$16:$A$34,$Q$11,D$16:D$34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total",{"$f":"SUM(C35:C42)","v":0},0,{"$f":"SUM(E35:E42)","v":0},{"$f":"SUM(F35:F42)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C43:AG43)","v":0}]
[null,"* Normalement une journée = 7,6 heures et 1 an à temps plein = 1.720 heures max"]
[]
[null,null,"Date et signature du collaborateur",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date et signature du responsable hiérarchique"]

{"sheet":"Activités","index":1,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Projet 1",{"$f":"TS!J5","v":"Projet 2"},{"$f":"TS!J6","v":"Projet 3"},{"$f":"TS!J7","v":"Projet 4"},{"$f":"TS!J8","v":"Projet 5"},{"$f":"TS!J9","v":"Projet 6"},{"$f":"TS!J10","v":"Projet 7"}]
["Activité 1"]