{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calendrier du projet","Légende"],"not_rendered":{"charts":0,"images":1,"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":"Calendrier du projet","index":0,"n_rows":115,"n_cols":30,"rows_kept":115,"cut":false,"hidden":false,"merged":[[2,0,5,29]]}
[]
[]
["Swissmem Programme de formation (version 28 janvier 2019)"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Nouvelle inscription:"]
[]
[]
[]
["Sem.","Semestre","Spalte4","Domaine","Activité","Onglet DFP","Spalte44","1re année d'app.","2e année d'app.","3e année d'app.","4e année d'app.","Spalte43"," ","Formateur à titre accessoire","Supérieur professionnel","Personne en formation","Spalte42","Profession","AM","AU","ET","KA","KR","PM","MP","PR","Statut","Statut2","Spalte12","Observations"]
[0,"1. Semester",null,"Absences","Vacances, maladie, accident",null,null,"X","X","X","X",null,"X","X","X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[0,"1. Semester",null,"Formation en entreprise","Formation approfondie\nAcquisition de la compétence opérationnelle 1 et/ou 2\n(à quelle période, dans quel service)",3,null,null,null,"X","X",null,"X","X","X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[0,"1. Semester",null,"Formation en entreprise","Cours interentreprises (formation de base et complémentaire):\nAcquisition des compétences opérationnelles entreprise/école de métiers\n(à quelle période, dans quel service)",3,null,"X","X","X","X",null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Initiation aux prescriptions internes à l'entreprise en matière de sécurité au travail et protection de la santé",2,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Initiation aux directives et aux dispositions internes",null,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Absences","Planification des vacances",null,null,"X","X","X","X",null,"X","X",null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Initiation au dossier de formation et des prestations:\nProgramme de formation",3,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Initiation au dossier de formation et des prestations:\nPlan d'études (école professionnelle)",5,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nBulletins semestriels et note d'expérience",5,null,null,"X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nProgramme du cours CIE et rapport du cours CIE",4,null,"X","X",null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Initiation à la structure et tenue du dossier de formation et des prestations",3,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Information sur l'entreprise et l'organisation",null,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Information sur la structure du catalogue des compétences et ressources",3,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Information sur la formation de base (entreprise, CIE et école)",null,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Cours interentreprises (formation de base et complémentaire):\nInformation sur les cours interentreprises",null,null,"X","X",null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Formation de base et formation complémentaire: \nInformation sur les compétences opérationnelles",null,null,"X",null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Annexe 2: Attestation de formation relative aux mesures d'accompagnement en matière de sécurité au travail et protection de la santé",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[31,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Annexe 2: Mesures d'accompagnement en matière de sécurité au travail et protection de la santé",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[32,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Initiation au dossier de formation et des prestations:\nAttestation de formation «Sécurité au travail, protection de la santé et protection de l'environnement»",2,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[32,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Initiation au dossier de formation et des prestations:\nInitiation aux rapports de formation",3,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[32,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Initiation au dossier de formation et des prestations:\nBulletins semestriels et note d'expérience",null,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[32,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Initiation au dossier de formation et des prestations:\nCatalogue des compétences et ressources",3,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[32,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Information sur l'entreprise, les produits et les clients",null,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[32,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Information sur le contrôle des acquis",3,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[35,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Visite du prochain poste d'affectation",null,null,"X","X","X","X",null,"X","X",null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[40,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Visite de l'usine",null,null,"X",null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[41,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nAttestation de formation «Sécurité au travail, protection de la santé et protection de l'environnement»",2,null,"X","X","X","X",null,"X","X",null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[41,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nCatalogue des compétences et ressources",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[41,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nDossier de formation",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[41,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Contrôle du dossier de formation et des prestations",null,null,null,null,null,null,null,"X","X","X",null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[42,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nDiscussion des rapports de formation",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[42,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Prise de contact avec les parents, l'école, l'entreprise / faire le point de la situation après la prolongation du temps d'essai",null,null,"X",null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[44,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Soirée des parents temps d'essai",null,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[45,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Visite du prochain poste d'affectation",null,null,"X","X","X","X",null,"X","X",null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[46,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Préparation PQ","Travail pratique «TPI»:\nInformation des supérieurs professionnels par les autorités d'examen cantonales",null,null,null,null,null,null,null,"X",null,"X",null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[46,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Préparation PQ","Travail pratique «TPI»:\nInscription des candidats à l'examen selon autorités d'examen cantonales",null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[46,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Préparation PQ","Examen partiel «TP»:\nInscription du/de la candidate selon autorités d'examen cantonales",null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[48,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"1. Semester"},null,"Formation en entreprise","Demandes et décomptes canton",null,null,null,null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[2,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nAttestation de formation «Sécurité au travail, protection de la santé et protection de l'environnement»",2,null,"X","X","X","X",null,"X","X",null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[2,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nProgramme de formation",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[2,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nCatalogue des compétences et ressources",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[2,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nDossier de formation",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[2,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Travail pratique «TPI»:\nInformation des apprentis au sujet du TPI",null,null,null,null,null,"X",null,"X",null,"X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[2,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Sondage engagement de l'apprenti après l'apprentissage",null,null,null,null,null,"X",null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[3,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nDiscussion rapports de formation",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[3,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Contrôle du dossier de formation et des prestations",null,null,null,null,null,null,null,"X","X","X",null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[3,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Travail pratique «TPI»:\nDéposition de l'énoncé du devoir",null,null,null,null,null,"X",null,"X",null,"X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[4,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nProgramme de formation",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[5,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Travail pratique «TPI»:\nRéalisation du TPI dans l'entreprise",null,null,null,null,null,"X",null,null,null,"X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[5,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Début période du TIP (jusqu'à la semaine 25)",null,null,null,null,"X","X",null,"X",null,"X",null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[5,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Examen partiel «TP»:\nDétermination du choix des modules d'examen (à option/à option obligatoire)",null,null,null,"X",null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[6,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Connaissances professionnelles «CP» et enseignement de culture générale «ECG»:\nPréparation par le candidat",null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[6,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Visite des experts d'examen externes",null,null,null,null,null,"X",null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[6,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Travail pratique «TPI»:\nOrganisation de la présentation et de l'entretien professionnel",null,null,null,null,null,"X",null,null,null,"X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[6,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nBulletins semestriels et note d'expérience",5,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[6,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Examen partiel «TP»:\nInformation des apprentis sur l'examen partiel ",null,null,null,"X",null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[6,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Connaissances professionnelles «CP» et enseignement de culture générale «ECG»:\nPréparation à l'école",null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[7,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Travail pratique «TPI»:\nEvaluation du TPI",null,null,null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[7,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Examen partiel «TP»:\nPréparation interne de l'examen",null,null,null,"X",null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[10,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Visite du prochain poste d'affectation",null,null,"X","X","X","X",null,"X","X",null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[12,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Examen partiel «TP»:\nSemaine externe de préparation de l'examen",null,null,null,"X",null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[16,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nAttestation de formation «Sécurité au travail, protection de la santé et protection de l'environnement»",2,null,"X","X","X","X",null,"X","X",null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[16,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nProgramme de formation",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[16,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nCatalogue des compétences et ressources",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[16,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nDossier de formation",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[17,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nDiscussion des rapports de formation",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[17,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Contrôle du dossier de formation et des prestations",null,null,null,null,null,null,null,"X","X","X",null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[18,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Orientation sur la carrière professionnelle «Quelle suite après l'apprentissage»",null,null,null,null,null,"X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[20,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Visite du prochain poste d'affectation",null,null,"X","X","X","X",null,"X","X",null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[22,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Soirée des parents avant le début de l'apprentissage (19h00)",null,null,"X",null,null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[22,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Début période de l'examen partiel (jusqu'à la fin de la semaine  27)",null,null,null,"X",null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[22,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Examen partiel «TP»:\nPréparation de l'équipement personnel du candidat selon autorités d'examen cantonales",null,null,null,"X",null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[23,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Examen partiel «TP»:\nRéalisation de l'examen partiel selon autorités d'examen cantonales",null,null,null,"X",null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[23,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Connaissances professionnelles «CP» et enseignement de culture générale «ECG»:\nExamen des connaissances professionnelles selon aut. d'examen cant.",null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[23,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Connaissances professionnelles «CP» et enseignement de culture générale «ECG»:\nExamen enseignement de la culture générale selon aut. d'examen cant.",null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[25,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nAttestation de formation «Sécurité au travail, protection de la santé et protection de l'environnement»",2,null,"X","X","X","X",null,"X","X",null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[25,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nProgramme de formation",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[25,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Voyage de diplôme",null,null,null,null,null,"X",null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[25,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nCatalogue des compétences et ressources",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[25,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nDossier de formation",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[25,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Bulletin des notes et certificat de travail à la fin de la formation de base:\nCertificat de travail",6,null,null,null,null,"X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[25,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Préparation PQ","Bulletin de notes et certificat de travail à la fin de la formation de base:\nBulletin de notes de la procédure de qualification",6,null,null,null,null,"X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[25,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Formation approfondie:\nDécision des compétences opérationnelles à acquérir",null,null,null,"X","X",null,null,"X","X","X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[26,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Tenue à jour du dossier de formation et des prestations:\nDiscussion des rapports de formation",3,null,"X","X","X","X",null,"X",null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[26,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Contrôle du dossier de formation et des prestations",null,null,null,null,null,null,null,"X","X","X",null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[26,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Ecole professionnelle,  y compr. maturité professionnelle","Bulletins semestriels",5,null,"X","X","X","X",null,"X","X","X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[26,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Enseignement de culture générale","Bulletins semestriels",5,null,"X","X","X","X",null,"X","X","X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[27,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Rangement",null,null,"X","X","X","X",null,"X","X",null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[27,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Fête de remise des diplômes",null,null,null,null,null,"X",null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[27,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Préparation pour les nouveaux apprentis",null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[28,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Formation en entreprise","Début recrutement des apprentis",null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[29,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Ecole professionnelle,  y compr. maturité professionnelle","Plan d'étude disponible",5,null,"X","X","X","X",null,"X","X","X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[29,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Ecole professionnelle,  y compr. maturité professionnelle","Jours d'école",null,null,"X","X","X","X",null,"X","X","X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[29,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Enseignement de culture générale","Jours d'école",null,null,"X","X","X","X",null,"X","X","X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[29,{"$f":"IF(Aktivitäten[[#This Row],[Sem.]]<31,\"2.Semester\",\"1. Semester\")","v":"2.Semester"},null,"Ecole professionnelle,  y compr. maturité professionnelle","Jours d'école maturité professionnelle",null,null,"X","X","X","X",null,"X","X","X","X",null,null,null,null,null,null,null,null,null,null,null,"ouvert"]
[]
["Nom",null,null,"…………………………………"]
["Prénom",null,null,"…………………………………"]
["No pers.",null,null,"…………………………………"]
["Entreprise",null,null,"…………………………………"]
[null,null,null,"…………………………………"]
[]
["Début d'app.",null,null,"…………………………………"]

{"sheet":"Légende","index":1,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[5,9,5,10]]}
[]
[]
[]
[]
[]
[null,"Thème",null,"Profession",null,"Année d'apprentissage",null,"Statut",null,"Onglet DFP"]
[null,"Absences",null,"Constructeur d'appareils industriels CFC",null,"1re année d'apprentissage",null,"ouvert",null,2,"Sécurité au travail, protection de la santé et protection de l'environnement/efficience des ressources"]
[null,"Information sur l'entreprise",null,"Automaticien CFC",null,"2e année d'apprentissage",null,"en cours",null,3,"Entreprise"]
[null,"Dossier de formation et des prestations",null,"Monteur-automaticien CFC",null,"3e année d'apprentissage",null,"terminé",null,4,"CIE"]
[null,"Sécurité au travail et protection de la santé",null,"Electronicien CFC",null,"4e année d'apprentissage",null,"en retard",null,5,"Ecole professionnelle"]
[null,"Formation en entreprise",null,"Employé de commerce profil E CFC",null,null,null,null,null,6,"Contrat d'apprentissage et dossier de candidature"]
[null,"Ecole professionnelle,  y compr. maturité professionnelle",null,"Employé de commerce profil G CFC",null,null,null,null,null,7,"champ libre"]
[null,"Enseignement de culture générale",null,"Dessinateur-constructeur industriel CFC",null,null,null,null,null,8,"champ libre"]
[null,"Préparation PQ",null,"Polymécanicien CFC"]
[null,"champ libre",null,"Mécanicien de production CFC"]
[null,"champ libre",null,"Praticien en mécanique CFC"]
[null,null,null,"champ libre"]
[null,null,null,"champ libre"]