{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Accueil","IST (4)","00","recap"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Accueil","index":0,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[27,4,27,5],[27,6,27,7],[11,7,11,10],[13,7,13,10]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"ÉTAT DES LIEUX DES FORMATIONS"]
[null,null,null,null,null,null,"SUIVIES PAR VOS IST"]
[]
[null,null,null,null,null,null,"Commencez par renseigner les éléments ci-dessous  pour ensuite renseigner les formations suivies par l'individu"]
[null,null,null,null,null,null,"Vous pourrez renseigner autant d'individus que nécessaire"]
[]
[]
[null,null,null,null,null,null,"Nom"]
[]
[null,null,null,null,null,null,"Prénom"]
[]
[null,null,null,null,null,null,"date embauche"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Cet outil permet de réaliser un état des lieux des formations suivies par vos IST"]
[null,null,null,null,null,null,"Cependant les résultat obtenus avec cet outil n'ont pas de valeur contractuelle"]
[null,null,null,null,null,null,"Il en va de la responsabilité individuelle des IST d'attester des formations suivies (certificat de stage, objectifs pédagogiques…)"]

{"sheet":"IST (4)","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":true,"merged":[[11,1,11,2],[11,4,11,5],[11,6,11,8]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"État des lieux des formations suivies"]
[null,null,null,null,null,null,{"$f":"Accueil!$H$12","v":0}]
[null,null,null,null,null,null,{"$f":"Accueil!$H$14","v":0}]
[]
[]
[]
[null,"Stage des 105 heures",null,"Dispensé",null,null,"Compétence 1"]
[null,null,null,null,null,null,"Intitulé Formation","Durée (heures)","Date"]
[null,{"$f":"TODAY()-Accueil!H16","v":45020},null,{"$f":"IF(B14>365,\"Oui\",\"Non\")","v":"Oui"}]
[]
[]
[null,"2022-10-29"]
[]
[null,{"$f":"TODAY()","v":"2023-04-04"}]

{"sheet":"00","index":2,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[[32,7,32,9],[13,16,13,18],[13,13,13,15],[13,10,13,12],[13,1,13,3],[13,4,13,6],[13,7,13,9]]}
[]
[]
[]
[null,null,null,{"$f":"TODAY()-Accueil!H16","v":45020}]
[]
[null,null,null,null,"État des lieux des formations suivies"]
[null,null,null,null,{"$f":"Accueil!$H$12","v":0}]
[null,null,null,null,{"$f":"Accueil!$H$14","v":0}]
[]
[null,null,null,null,"Dispense de stage de 105 heures :",{"$f":"IF(D4>365,\"Oui\",\"Non\")","v":"Oui"}]
[null,null,null,null,"Nbs total d'heures de formation réalisées :",{"$f":"C26+F26+I26+L26+O26+R26","v":0}]
[null,null,null,null,"Estimation d'heures restantes à effectuer :",{"$f":"240-F11","v":240}]
[]
[null,"COMPÉTENCE 1 (+)",null,null,"COMPÉTENCE 2 (+)",null,null,"COMPÉTENCE 3 (+)",null,null,"COMPÉTENCE 4 (+)",null,null,"COMPÉTENCE 5 (+)",null,null,"COMPÉTENCE 6 (+)"]
[null,"Intitulé Formation","Durée (heures)","Année","Intitulé Formation","Durée (heures)","Année","Intitulé Formation","Durée (heures)","Année","Intitulé Formation","Durée (heures)","Année","Intitulé Formation","Durée (heures)","Année","Intitulé Formation","Durée (heures)","Année"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C16:C25)","v":0},null,null,{"$f":"SUM(F16:F25)","v":0},null,null,{"$f":"SUM(I16:I25)","v":0},null,null,{"$f":"SUM(L16:L25)","v":0},null,null,{"$f":"SUM(O16:O25)","v":0},null,null,{"$f":"SUM(R16:R25)","v":0}]

{"sheet":"recap","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[[10,5,10,6]]}
[]
[]
[]
[]
[]
[null,null,null,"État des lieux"]
[null,null,null,"Récapitulatif"]
[]
[]
[]
[null,null,null,null,null,"Comptage"]
[null,null,"Nom","Prénom","Dispense stage","Heures réalisées","Heures restantes"]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]