{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["STAGIAIRES","TK","Attestation","Paramètres","Liste","Liste des formations"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":85,"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":"STAGIAIRES","index":0,"n_rows":16,"n_cols":34,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,0,22,0]]}
[null,null,"Edition Attestation","Nom","Prénom","Organisation","Email","Formation","Date début de la formation","Date de fin de la formation","Obj 1\nEvaluation","Obj 2\nEvaluation","Obj 3\nEvaluation","Obj 4\nEvaluation","Obj 5\nEvaluation","Obj 6\nEvaluation","Obj 7\nEvaluation","Obj 8\nEvaluation","Obj 9\nEvaluation","Obj 10\nEvaluation","Mode déroulement de la formation","Durée en jours de la formation","Durée en heures de la formation","Obj 1","Obj 2","Obj 3","Obj 4","Obj 5","Obj 6","Obj 7","Obj 8","Obj 9","Obj 10","Erreur Date de fin"]
["Avant de commencer :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,2,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,2,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,3,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,3,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,4,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,4,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,5,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,5,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,6,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,6,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,7,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,7,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,8,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,8,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,9,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,9,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,10,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,10,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,11,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,11,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,12,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,12,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,13,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,13,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,14,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,14,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(AND(tb_stagaire[[#This Row],[Date début de la formation]]<>\"\",tb_stagaire[[#This Row],[Date de fin de la formation]]<>\"\"),tb_stagaire[[#This Row],[Date de fin de la formation]]-tb_stagaire[[#This Row],[Date début de la formation]],\"\")","v":""}]
["Renseignez les éléments à l'onglet Paramètres\n\nRenseigner les caractéristiques des formations à l'onglet Liste des formations\n\nSur l'onglet Attestation, personnaliser le document\n\nRenseigner les informations concernant les stagiaires et la formation suivie\n\nIndiquer la lettre x dans la colonne Edition Attestation pour les attestations que vous souhaitez générer\n\nCliquez ensuite sur le bouton Générer pour créer les PDF",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,2,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,2,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,3,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,3,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,4,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,4,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,5,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,5,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,6,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,6,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,7,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,7,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,8,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,8,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,9,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,9,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,10,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,10,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,11,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,11,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,12,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,12,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,13,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,13,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,14,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,14,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(AND(tb_stagaire[[#This Row],[Date début de la formation]]<>\"\",tb_stagaire[[#This Row],[Date de fin de la formation]]<>\"\"),tb_stagaire[[#This Row],[Date de fin de la formation]]-tb_stagaire[[#This Row],[Date début de la formation]],\"\")","v":""}]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,2,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,2,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,3,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,3,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,4,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,4,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,5,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,5,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,6,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,6,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,7,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,7,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,8,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,8,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,9,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,9,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,10,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,10,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,11,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,11,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,12,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,12,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,13,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,13,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,14,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,14,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(AND(tb_stagaire[[#This Row],[Date début de la formation]]<>\"\",tb_stagaire[[#This Row],[Date de fin de la formation]]<>\"\"),tb_stagaire[[#This Row],[Date de fin de la formation]]-tb_stagaire[[#This Row],[Date début de la formation]],\"\")","v":""}]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,2,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,2,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,3,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,3,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,4,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,4,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,5,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,5,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,6,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,6,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,7,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,7,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,8,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,8,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,9,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,9,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,10,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,10,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,11,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,11,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,12,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,12,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,13,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,13,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,14,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,14,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(AND(tb_stagaire[[#This Row],[Date début de la formation]]<>\"\",tb_stagaire[[#This Row],[Date de fin de la formation]]<>\"\"),tb_stagaire[[#This Row],[Date de fin de la formation]]-tb_stagaire[[#This Row],[Date début de la formation]],\"\")","v":""}]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,2,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,2,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,3,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,3,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,4,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,4,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,5,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,5,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,6,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,6,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,7,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,7,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,8,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,8,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,9,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,9,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,10,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,10,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,11,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,11,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,12,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,12,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,13,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,13,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(tb_stagaire[[#This Row],[Formation]]<>\"\",IFERROR(IF(VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,14,0)=0,\"\",VLOOKUP(tb_stagaire[[#This Row],[Formation]],zone_programme,14,0)),\"Formation non défini\"),\"\")","v":""},{"$f":"IF(AND(tb_stagaire[[#This Row],[Date début de la formation]]<>\"\",tb_stagaire[[#This Row],[Date de fin de la formation]]<>\"\"),tb_stagaire[[#This Row],[Date de fin de la formation]]-tb_stagaire[[#This Row],[Date début de la formation]],\"\")","v":""}]
[]
[]
[]
[]
[]
[null,null,"Ce fichier est bridé à 5 lignes."]
[null,null,"Si vous souhaitez utiliser ce fichier avec un nombre de lignes illimitées, vous pouvez le télécharger sur le lien suivant : ",null,null,null,null,null,null,"attestation de formation"]
[null,null,"Il est posibble d'intégrer le fonctionnement de ce modèle sur vos propres fichiers."]
[null,null,"Ce fichier génére une seule attestation, mais il est possible de le faire évoluer pour générer plusieurs types de certificats en fonction de votre besoin"]
[null,null,"Pour cela veuillez nous contacter",null,null,"Contact"]

{"sheet":"TK","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Objet outlok","Attestation de participation à une formation DOPHIS"]
["Message Outlook :","Bonjour, \n\n\nVeuillez trouver ci-joint votre attestation de participation à un programme de formation et votre attestation de fin de formation.\n\nCordialement.\n\n\nDOPHIS"]

{"sheet":"Attestation","index":2,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[28,4,29,6],[37,0,37,7],[34,0,34,7],[33,9,37,9],[35,0,35,7],[36,0,36,7],[33,0,33,7],[29,0,29,3],[4,0,4,7],[8,0,8,7],[9,0,9,7],[13,0,13,7],[15,0,15,7],[6,0,6,7],[7,0,7,7],[16,0,16,3],[16,4,16,7],[17,0,17,3],[17,4,17,7],[18,0,18,3],[18,4,18,7],[19,0,19,3],[19,4,19,7],[20,0,20,3],[20,4,20,7],[22,0,22,3],[22,4,22,7],[26,0,26,3],[26,4,26,7],[21,0,21,3],[21,4,21,7],[23,0,23,3],[23,4,23,7],[24,0,24,3],[24,4,24,7],[25,0,25,3],[25,4,25,7]]}
[]
[null,null,null,null,null,null,null,"Attestation de formation",null,"Coller ou insérer une image de votre logo"]
[null,null,null,null,null,null,null,"Document d'évaluation des acquis attestant de la réalisation effective de l'action de formation"]
[]
["Je soussigné,\nJules FERRY, représentant légal de Nom de l'OF, organisme de formation enregistré sous le numéro de déclaration d'activité XXXXXXXXXXX auprès de la Direction Régionale des Entreprises, de la Concurrence, de la Consommation, du Travail et de l’Emploi (DIRECCTE) auprès du Préfet de la région YYYYYY,",null,null,null,null,null,null,null,null,"A adapter la phrase à votre OF"]
["atteste que "]
[{"$f":"IF(at_prenom<>\"\",at_prenom,\"\") & \" \" & IF(at_nom<>\"\",at_nom,\"\")","v":" "}]
[{"$f":"\"salarié de l'organisation : \" & IF(at_organisation<>\"\",at_organisation,\"\")","v":"salarié de l'organisation : "}]
[{"$f":"\"a suivi l'action : \" & IF(at_formation<>\"\",at_formation,\"\")","v":"a suivi l'action : "}]
[{"$f":"\"la formation s'est déroulée : \" & IF(at_mode<>\"\",at_mode,\"\")","v":"la formation s'est déroulée : "}]
["Date de début : ",{"$f":"IF(at_date_debut<>\"\",at_date_debut,\"\")","v":""},null,"Date de fin :",{"$f":"IF(at_date_fin<>\"\",at_date_fin,\"\")","v":""}]
[{"$f":"\"pour une durée de \" & IF(at_duree_jour<>\"\",at_duree_jour,\"\") & \" jour(s) = \" & IF(at_duree_heure<>\"\",at_duree_heure,\"\") & \" heures \"","v":"pour une durée de  jour(s) =  heures "}]
[]
["OBJECTIFS DE LA FORMATION"]
[]
["Type d’action de formation conformément à l’art. L6313-1 du code du travail : Action de formation (action concourant au développement des compétences qui entre dans le champ d'application des dispositions relatives à la formation professionnelle)."]
["Objectif",null,null,null,"Les compétences nécessaires à l'atteinte des objectifs sont"]
[{"$f":"IF(at_OP_1<>\"\",at_OP_1,\"\")","v":""},null,null,null,{"$f":"IF(at_obj_1<>\"\",at_obj_1,\"\")","v":""}]
[{"$f":"IF(at_OP_2<>\"\",at_OP_2,\"\")","v":""},null,null,null,{"$f":"IF(at_obj_2<>\"\",at_obj_2,\"\")","v":""}]
[{"$f":"IF(at_OP_3<>\"\",at_OP_3,\"\")","v":""},null,null,null,{"$f":"IF(at_obj_3<>\"\",at_obj_3,\"\")","v":""}]
[{"$f":"IF(at_OP_4<>\"\",at_OP_4,\"\")","v":""},null,null,null,{"$f":"IF(at_obj_4<>\"\",at_obj_4,\"\")","v":""}]
[{"$f":"IF(at_OP_5<>\"\",at_OP_5,\"\")","v":""},null,null,null,{"$f":"IF(at_obj_5<>\"\",at_obj_5,\"\")","v":""}]
[{"$f":"IF(at_OP_6<>\"\",at_OP_6,\"\")","v":""},null,null,null,{"$f":"IF(at_obj_6<>\"\",at_obj_6,\"\")","v":""}]
[{"$f":"IF(at_OP_7<>\"\",at_OP_7,\"\")","v":""},null,null,null,{"$f":"IF(at_obj_7<>\"\",at_obj_7,\"\")","v":""}]
[{"$f":"IF(at_OP_8<>\"\",at_OP_8,\"\")","v":""},null,null,null,{"$f":"IF(at_obj_8<>\"\",at_obj_8,\"\")","v":""}]
[{"$f":"IF(at_OP_9<>\"\",at_OP_9,\"\")","v":""},null,null,null,{"$f":"IF(at_obj_9<>\"\",at_obj_9,\"\")","v":""}]
[{"$f":"IF(at_OP_10<>\"\",at_OP_10,\"\")","v":""},null,null,null,{"$f":"IF(at_obj_10<>\"\",at_obj_10,\"\")","v":""}]
[]
[null,null,null,null,"Signature de la direction de l'organisme de formation "]
[{"$f":"\"Fait à \" & choix_ville","v":"Fait à Ville de l'OF"}]
[{"$f":"\"le \" &  TEXT(IF(choix_date<>\"\",choix_date,\"\"),\"jj/mm/aaaa\")","v":"le "},null,null,null,null,null,{"$f":"choix_RL & \", \" & Fonction_RL","v":"Test RL, Gérant"}]
[null,null,null,null,null,null,null,null,null,"Coller une image de votre signature"]
[]
["Nom de l'OF",null,null,null,null,null,null,null,null,"A adapter à votre OF"]
["contact : Jules Ferry, jules.ferry@educ.fr"]
["SAS au capital de 10 000 euros"]
["Numéro SIRET de l’organisme de formation : XXXXXXXXXXXXXX"]
["Déclaration enregistrée sous le n°XXXXXXXXXXX auprès du Préfet de la région YYYYY"]

{"sheet":"Paramètres","index":3,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"PARAMETRES",null,null,null,null,null,null,null,null,null,"Evolution possible du fichier"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Génération automatique d'un mail au stagiaire avec l'attestation "]
[null,"Veuillez définir les paramètres suivants avant de pouvoir éditer les attestations. Ces informations apparaissent sur les PDF.",null,null,null,null,null,null,null,null,null,null,"Génération d'autres documents dont des CERFA"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pour toute évolution du fichier, veuillez nous contacter,"]
[null,"Représentant légal (Prénom et Nom)","Test RL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Contact"]
[null,"Fonction du représentant légal","Gérant"]
[]
[null,"Nom de l'organisation","Nom OF"]
[]
[null,"Ville d'émission del'attestation","Ville de l'OF"]
[]
[null,"Répertoire de création des attestations"]
[]
[]
[]
[null,"Nombre d'objectifs à afficher sur la feuille Stagiaire et l'attestation",10]
[]
[]
[null,null,{"$f":"CONCATENATE(\"'Liste des formations'!\",IF(CELL(\"colonne\",tb_formation[[#Headers],[Formation]])<=26,LEFT(RIGHT(ADDRESS(1,CELL(\"colonne\",tb_formation[[#Headers],[Formation]])),LEN(ADDRESS(1,CELL(\"colonne\",tb_formation[[#Headers],[Formation]])))-1),1),LEFT(RIGHT(ADDRESS(1,CELL(\"colonne\",tb_formation[[#Headers],[Formation]])),LEN(ADDRESS(1,CELL(\"colonne\",tb_formation[[#Headers],[Formation]])))-1),2)),\"2:\",IF(CELL(\"colonne\",tb_formation[[#Headers],[Formation]])<=26,LEFT(RIGHT(ADDRESS(1,CELL(\"colonne\",tb_formation[[#Headers],[Formation]])),LEN(ADDRESS(1,CELL(\"colonne\",tb_formation[[#Headers],[Formation]])))-1),1),LEFT(RIGHT(ADDRESS(1,CELL(\"colonne\",tb_formation[[#Headers],[Formation]])),LEN(ADDRESS(1,CELL(\"colonne\",tb_formation[[#Headers],[Formation]])))-1),2)),COUNTA(col_nom_formation))","v":"'Liste des formations'!C2:C7"}]
[]
[null,"Pour définir le répertoire où vous souhaitez créer les attestations, cliquer sur le classeur"]

{"sheet":"Liste","index":4,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["LISTES DEROULANTES",null,null,null,null,null,null,null,"Mode de déroulement","en présentiel",null,"Atteinte objectif","Acquises"]
[null,null,null,null,null,null,null,null,null,"en distanciel",null,null,"Non Acquises"]
[null,null,null,null,null,null,null,null,null,"en présentiel et en distanciel",null,null,"En cours d'acquisition"]

{"sheet":"Liste des formations","index":5,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,10,0]]}
["Programmes de formation",null,"Formation","Mode de déroulement","Durée en jour","Durée en heures","Objectif 1","Objectif 2","Objectif 3","Objectif 4","Objectif 5","Objectif 6","Objectif 7","Objectif 8","Objectif 9","Objectif 10"]
["Veuillez renseigner les éléments descriptifs des formations qui apparaitront sur les attestations et qui pourront êtte sélectionnées à l'onglet STAGAIRES"]
[null,null," "]
[null,null," "]
[null,null," "]
[null,null," "]
[]
[]
[]
[]
[]
[null,null,"Ce fichier est bridé à 5 lignes."]
[null,null,"Si vous souhaitez utiliser ce fichier avec un nombre de lignes illimitées, vous pouvez le télécharger sur : ",null,null,null,"attestation de formation"]