{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Info modèle","Instructions","Matrice","Technique","Métier","Spécifique","Plan action compétences"],"not_rendered":{"charts":6,"images":1,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Technique","index":3,"reason":"not_a_worksheet"},{"sheet":"Métier","index":4,"reason":"not_a_worksheet"},{"sheet":"Spécifique","index":5,"reason":"not_a_worksheet"}],"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":"Info modèle","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Matrice","index":2,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,6],[1,3,1,6],[8,1,8,5],[9,1,9,5],[1,1,1,2],[3,1,3,5],[4,1,4,5],[7,1,7,5],[5,1,5,5],[6,1,6,5]]}
[null,"Prestation",null,"Date de mise à jour"]
[]
[]
["Niveau","Echelle d'évaluation"]
[0,"Non concerné – aucune connaissance"]
[1,"Connaissances théoriques avec la capacité d’exécution stricte de consignes précises"]
[2,"Compétence mise en œuvre avec l‘appui d’un professionnel qui la maîtrise"]
[3,"Compétence maîtrisée dans un contexte familier"]
[4,"Compétence maîtrisée et utilisable dans des contextes nouveaux"]
[5,"Compétence maîtrisée  dans différents contextes avec la capacité de la transmettre"]
[]
["Domaine","Sous-domaine","Sujet","Niveau à atteindre en fin de transition","Nb de ressources nécessaires au niveau requis","Backup","Auto-nomie","Niveau \nback up","niveau\nauto-nomie","Nb  ress. Niv. 5","Nb  ress. Niv. 4","Nb  ress. Niv. 3","Nb  ress. Niv. 2","Nb  ress. Niv. 1","Ressource 1","Ressource 2"]
["Compétences techniques",null,null,null,null,{"$f":"IF(AND(D13<>\"\",E13<>\"\"),IF(IF(MatriceCompétences[[#This Row],[Nb  ress. Niv. 4]]>E13,4,IF(K13+L13>E13,3,IF(K13+L13+M13>E13,2,IF(K13+L13+M13+N13>E13,1,0))))>=D13,1,0),\"\")","v":""},{"$f":"IF(AND(D13<>\"\",E13<>\"\"),IF(I13>=D13,1,0),\"\")","v":""},{"$f":"IF(AND(D13<>\"\",E13<>\"\"),\n    MIN(\n   IF( J13>E13,\n    5,\n    IF(J13+K13>E13,\n     4,\n     IF(J13+K13+L13>E13,\n      3,\n      IF(J13+K13+L13+M13>E13,\n       2,\n       IF(J13+K13+L13+M13+N13>E13,\n        1,\n        0\n       )\n      )\n     )\n    )\n\n   ),\n  D13\n  ),\"\"\n )","v":""},{"$f":"IF(AND(D13<>\"\",E13<>\"\"),\n    MIN(\n   IF( J13>=E13,\n    5,\n    IF(J13+K13>=E13,\n     4,\n     IF(J13+K13+L13>=E13,\n      3,\n      IF(J13+K13+L13+M13>=E13,\n       2,\n       IF(J13+K13+L13+M13+N13>=E13,\n        1,\n        0\n       )\n      )\n     )\n    )\n\n   ),\n  D13\n  ),\"\"\n )","v":""},{"$f":"COUNTIF($O13:$P13,5)","v":0}]
[null,"TEC 1","compétence 1",null,null,{"$f":"IF(AND(D14<>\"\",E14<>\"\"),IF(IF(MatriceCompétences[[#This Row],[Nb  ress. Niv. 4]]>E14,4,IF(K14+L14>E14,3,IF(K14+L14+M14>E14,2,IF(K14+L14+M14+N14>E14,1,0))))>=D14,1,0),\"\")","v":""},{"$f":"IF(AND(D14<>\"\",E14<>\"\"),IF(I14>=D14,1,0),\"\")","v":""},"","",{"$f":"COUNTIF($O14:$P14,5)","v":0},{"$f":"COUNTIF($O14:$P14,4)","v":0},{"$f":"COUNTIF($O14:$P14,3)","v":0},{"$f":"COUNTIF($O14:$P14,2)","v":0},{"$f":"COUNTIF($O14:$P14,1)","v":0}]
[null,"TEC 1","compétence 2",null,null,{"$f":"IF(AND(D15<>\"\",E15<>\"\"),IF(IF(MatriceCompétences[[#This Row],[Nb  ress. Niv. 4]]>E15,4,IF(K15+L15>E15,3,IF(K15+L15+M15>E15,2,IF(K15+L15+M15+N15>E15,1,0))))>=D15,1,0),\"\")","v":""},"","","",{"$f":"COUNTIF($O15:$P15,5)","v":0},{"$f":"COUNTIF($O15:$P15,4)","v":0},{"$f":"COUNTIF($O15:$P15,3)","v":0},{"$f":"COUNTIF($O15:$P15,2)","v":0},{"$f":"COUNTIF($O15:$P15,1)","v":0}]
[null,null,null,null,null,{"$f":"IF(AND(D16<>\"\",E16<>\"\"),IF(IF(MatriceCompétences[[#This Row],[Nb  ress. Niv. 4]]>E16,4,IF(K16+L16>E16,3,IF(K16+L16+M16>E16,2,IF(K16+L16+M16+N16>E16,1,0))))>=D16,1,0),\"\")","v":""},"","","",{"$f":"COUNTIF($O16:$P16,5)","v":0},{"$f":"COUNTIF($O16:$P16,4)","v":0},{"$f":"COUNTIF($O16:$P16,3)","v":0},{"$f":"COUNTIF($O16:$P16,2)","v":0},{"$f":"COUNTIF($O16:$P16,1)","v":0}]
["Compétences Métier",null,null,null,null,{"$f":"IF(AND(D17<>\"\",E17<>\"\"),IF(IF(MatriceCompétences[[#This Row],[Nb  ress. Niv. 4]]>E17,4,IF(K17+L17>E17,3,IF(K17+L17+M17>E17,2,IF(K17+L17+M17+N17>E17,1,0))))>=D17,1,0),\"\")","v":""},"","","",{"$f":"COUNTIF($O17:$P17,5)","v":0}]
[]
[]
[]
[]
[]
[]
["Compétences Spécifiques",null,null,null,null,{"$f":"IF(AND(D24<>\"\",E24<>\"\"),IF(IF(MatriceCompétences[[#This Row],[Nb  ress. Niv. 4]]>E24,4,IF(K24+L24>E24,3,IF(K24+L24+M24>E24,2,IF(K24+L24+M24+N24>E24,1,0))))>=D24,1,0),\"\")","v":""},{"$f":"IF(AND(D24<>\"\",E24<>\"\"),IF(I24>=D24,1,0),\"\")","v":""},"","",{"$f":"COUNTIF($O24:$P24,5)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(AND(D29<>\"\",E29<>\"\"),IF(IF(MatriceCompétences[[#This Row],[Nb  ress. Niv. 4]]>E29,4,IF(K29+L29>E29,3,IF(K29+L29+M29>E29,2,IF(K29+L29+M29+N29>E29,1,0))))>=D29,1,0),\"\")","v":""},"","","",{"$f":"COUNTIF($O29:$P29,5)","v":0},{"$f":"COUNTIF($O29:$P29,4)","v":0},{"$f":"COUNTIF($O29:$P29,3)","v":0},{"$f":"COUNTIF($O29:$P29,2)","v":0},{"$f":"COUNTIF($O29:$P29,1)","v":0}]
["Fin tableau",null,null,null,null,{"$f":"IF(AND(D30<>\"\",E30<>\"\"),IF(IF(MatriceCompétences[[#This Row],[Nb  ress. Niv. 4]]>E30,4,IF(K30+L30>E30,3,IF(K30+L30+M30>E30,2,IF(K30+L30+M30+N30>E30,1,0))))>=D30,1,0),\"\")","v":""},"","","",{"$f":"COUNTIF($O30:$P30,5)","v":0}]

{"sheet":"Plan action compétences","index":6,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Domaine","Sous-domaine","Sujet","Collaborateur","Type d'action\n(formation, coaching, …)","Niveau actuel","Niveau cible","Niveau atteint","Échéance prévisionnelle","Charge prévisionnelle","Date exécution\nréelle","Commentaire"]
["Compétences Techniques"]
[null,"TEC 1","compétence 1","Collaborateur 1"]
[null,"TEC 1","compétence 1","Collaborateur 2"]
["Compétences métier"]
[null,"FONC 1","compétence 1","Collaborateur 1"]
[null,"FONC 1","compétence 2","Collaborateur 3"]
[null,"FONC 1","compétence 3"]
[null,"FONC 2","compétence 1"]
[null,"FONC 2","compétence 2"]
[null,"FONC 2","compétence 3"]
["Compétences spécifiques "]
[null,"SPEC 1","Compétence 1"]
[null,"SPEC 1","Compétence 2"]
[null,"SPEC 1","Compétence 3"]
[null,"SPEC 2","Compétence 1"]
[null,"SPEC 2","Compétence 2"]
[null,"SPEC 2","Compétence 3"]
["Fin tableau"]