{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Accueil","Eleve1","Eleve2","Eleve3","Eleve4","Eleve5"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Accueil","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,1,16],[4,2,4,4],[2,1,2,16],[3,1,3,16]]}
[null,"Baccalauréat professionnel"]
[]
[null,"Métiers du commerce et de la vente"]
[null,"Option A \"Animation et gestion de l'espace commercial\""]
["Nom","Prénom","Trimestre"]
["Nom 1","Prénom 1"]
["Nom 2","Prénom 2"]
["Nom 3","Prénom 3"]
["Nom 4","Prénom 4"]
["Nom 5","Prénom 5"]

{"sheet":"Eleve1","index":1,"n_rows":116,"n_cols":38,"rows_kept":116,"cut":false,"hidden":false,"merged":[[0,1,1,4],[0,12,1,16],[0,24,1,28]]}
[null,"Evaluation 1er trimestre",null,null,null,null,"Maîtrise insuffisante",null,"Maîtrise satisfaisante",null,null,null,"Evaluation 2ème trimestre",null,null,null,null,null,null,null,null,null,null,null,"Evaluation 3ème trimestre"]
[null,null,null,null,null,null,"Maîtrise fragile",null,"Très bonne maîtrise"]
[null,"E1T1","E2T1","E3T1","E4T1","E5T1","E6T1","E7T1","E8T1","E9T1","E10T1","BilanT1","Moyenne retenue","E1T2","E2T2","E3T2","E4T2","E5T2","E6T2","E7T2","E8T2","E9T2","E10T2","BilanT2","Moyenne retenue","E1T3","E2T3","E3T3","E4T3","E5T3","E6T3","E7T3","E8T3","E9T3","E9T3","BilanT3","Moyenne retenue","Bilan Annuel"]
["Compétences 1 : Conseiller et vendre",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(B4:K4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N4:W4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z4:AI4),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M4,Y4,AK4),\"\")","v":""}]
["Assurer la veille commerciale",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N5:W5),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z5:AI5),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M5,Y5,AK5),\"\")","v":""}]
["Rechercher, hiérarchiser, exploiter et actualiser en continu les informations sur l’entreprise et son marché",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,""]
["Maitriser la technologie des produits",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,""]
["Sélectionner les outils de recherche d'information les plus adapté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,""]
["Réaliser la vente dans un cadre omnicanal",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,""]
["Intégrer l’omnicanal dansle processus de vente",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,""]
["Prendre contact avec le client",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,""]
["S’adapter au contexte commercial et au comportement du client",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écouvrir, analyser et identifier le(s) besoin(s) du client, sa (ses) motivation(s) et ses freins éventuels",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écouvrir, analyser et reformuler les besoins du client",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,""]
["Présenter l’entreprise et/ou ses produits et/ou ses services",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,""]
["Conseiller le client en proposant la solution adaptée",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,""]
["Argumenter",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,""]
["Réaliser une démonstration le cas échéant",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,""]
["Répondre aux objections du client",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,""]
["Proposer les produits et/ou les services associé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,""]
["Détecter les opportunités de vente(s)additionnelle(s) et les concrétiser",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,""]
["S’assurer de la disponibilité du produit",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,""]
["Formaliser l'accord du client",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,""]
["Assurer l’exécution de la vente",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,""]
["Mettre en place les modalités de réeglement et de livraison",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,""]
["Rassurer le client sur son choix",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,""]
["Prendre congé",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,""]
["Groupe de compétences 2 : Suivre les ventes",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,""]
["Assurer le suivi de la commande du produit et/ou du service",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,""]
["Suivre l’évolution de la commande et éventuellement du règlement",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,""]
["Informer le client des délais et des modalités de mise a disposition",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,""]
["Mettre en ceuvre le ou les services associé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,""]
["Sélectionner le cas échéant le prestataire le plus adapté",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,""]
["\nCollecter et transmettre les informations au service de l'entreprise ou aux prestataires concerné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,""]
["Suivre l’exécution du ou des service(s) associé(s) et en rendre compte",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,""]
["Effectuer le cas échéant les relances",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,""]
["Traiter les retours et les réclamations du client",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,""]
["\nIdentifier le(s) probléme(s) rencontré(s) par le client",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,""]
["Proposer une solution adaptée en tenant compte des procédures de l’entreprise et de la réglementation",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,""]
["S’assurer de la satisfaction du client",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,""]
["Collecter les informations de satisfaction auprés des clients",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,""]
["Mesurer et analyser la satisfaction du client",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,""]
["Transmettre les informations sur la satisfaction du client",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,""]
["Exploiter les informations recueillies a des fins d’amélioration",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,""]
["Proposer des éléments de nature a améliorer la satisfaction client",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,""]
["Groupe de compétences 3 : Fidéliser la clientèle et développer la relation client",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,""]
["Traiter et exploiter l'information ou le contact client",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,""]
["Traiter les messages et/ou les demandes des clients",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,""]
["Recueillir, extraire, exploiter, synthétiser les données : « de sources internes « de sources externes",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,""]
["Rendre compte des données appropriées",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,""]
["Proposer ces actions de fidélisation et/ou de développement de la relation client en adéquation avec les données recueillies et orientation commerciale de l’entreprise ",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,""]
["Contribuer a des actions de fidélisation de la clientéle et de développement de la relation client",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,""]
["Sélectionner et mettre en ceuvre les outils de fidélisation et/ou de développement de la relation client de l'entreprise",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,""]
["Concourir a la préparation et a organisation d’événements et/ou d’opérations de fidélisation/ développement de la relation client",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,""]
["Participer a la mise en ceuvre des événements et/ou opérations de fidélisation/ développement de la relation client",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,""]
["Effectuer des ventes au rebond",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,""]
["Réaliser les opérations de suivi post événement",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,""]
["Mobiliser les outils d'internet et les réseaux sociaux",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,""]
["Evaluer les actions de fidélisation et de développement de la relation client",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,""]
["Enrichir et actualiser le SIC",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,""]
["Mesurer et analyser les résultats",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,""]
["Rendre compte des actions et des résultats par écrit et/ou a l'oral",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,""]
["Proposer des axes d’amélioration",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,""]
["Groupe de compétences 4A : Animer et gérer l'espace commercial",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,""]
["Assurer les opérations préalables a la vente",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,""]
["Etablir les commandes des produits auprés de la centrale d’achats et/ou des fournisseurs indépendants sélectionnés avec la hiérarchie, en tenant compte des contraintes",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,""]
["Préparer les commandes des clients issues de l’omnicanal",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,""]
["Veiller a la gestion rigoureuse des stocks et au réapprovisionnement en tenant compte des régles de sécurité et d’hygiéne",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(B68:K68),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,""]
["Réceptionner, contrôler et stocker les marchandises (quantitatif et qualitatif)",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N69:W69),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z69:AI69),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M69,Y69,AK69),\"\")","v":""}]
["Respecter les régles de valorisation des déchets et réduire le gaspillage",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,""]
["\nEffectuer les relances et préparer les retours fournisseurs",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,""]
["Etablir le prix en fonction de variables commerciales données",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,""]
["Etiqueter les produits et les sécuriser",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,""]
["Enrichir et exploiter le systeme d'information commercial",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,""]
["Comparer les résultats aux objectifs fixés et proposer des actions correctrices",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,""]
["Participer aux opérations d'inventaire",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,""]
["Identifier les invendus ",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,""]
["Lutter contre la démarque",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,""]
["Gérer les retours et les changes des clients",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,""]
["Rendre l’unité commerciale attractive et fonctionnelle",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,""]
["S’assurer de la disponibilité et de la qualité des produits",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,""]
["Implanter les produits selon une logique commerciale et/ou d'entreprise",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,""]
["Vérifier I’étiquetage, le balisage et la mise en valeur des produits",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,""]
["S’assurer de la bonne tenue et de la propreté du rayon",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,""]
["Accueillir, informer et orienter le client dans l’unité commerciale et a l'extérieur",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,""]
["Mettre en place la signalétique",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,""]
["Participer a l'agencement de la surface de vente",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,""]
["Aménager la vitrine et/ou le rayon",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,""]
["Mettre en scéne l’offre et en optimiser la visibilité",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,""]
["Veiller au respect des régles d’hygiéne et de sécurité.",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,""]
["Valoriser loffre sur les sites marchands et les réseaux sociaux",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évelopper la clientele",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,""]
["Proposer des actions commerciales génératrices de trafic dans l’unité commerciale",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,""]
["Sélectionner les gammes de produits a mettre en avant en lien avec la stratégie de l’unité commerciale",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,""]
["Participer a la planification et a organisation des actions de promotion des marchandises",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émarcher une nouvelle clientéle Communiquer sur l'événement",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,""]
["Communiquer sur l'évènement",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,""]
["Recourir aux sites marchands et aux réseaux sociaux",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,""]
["Inciter a l'achat par une action commerciale, le cas échéant interactive",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,""]
["Générer des contacts positifs/utiles",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,""]
["Participer a l’évaluation et a l'analyse des performances des actions commerciales",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,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(B102:K102),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N102:W102),\"\")","v":""},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,{"$f":"IFERROR(AVERAGE(M103:W103),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Y103:AI103),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(L103,X103,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L104,X104,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L105,X105,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L106,X106,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L107,X107,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L108,X108,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L109,X109,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L110,X110,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L111,X111,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L112,X112,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L113,X113,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L114,X114,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L115,X115,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L116,X116,#REF!),\"\")","v":""}]

{"sheet":"Eleve2","index":2,"n_rows":116,"n_cols":38,"rows_kept":116,"cut":false,"hidden":false,"merged":[[0,1,1,4],[0,12,1,16],[0,24,1,28]]}
[null,"Evaluation 1er trimestre",null,null,null,null,"Maîtrise insuffisante",null,"Maîtrise satisfaisante",null,null,null,"Evaluation 2ème trimestre",null,null,null,null,null,null,null,null,null,null,null,"Evaluation 3ème trimestre"]
[null,null,null,null,null,null,"Maîtrise fragile",null,"Très bonne maîtrise"]
[null,"E1T1","E2T1","E3T1","E4T1","E5T1","E6T1","E7T1","E8T1","E9T1","E10T1","BilanT1","Moyenne retenue","E1T2","E2T2","E3T2","E4T2","E5T2","E6T2","E7T2","E8T2","E9T2","E10T2","BilanT2","Moyenne retenue","E1T3","E2T3","E3T3","E4T3","E5T3","E6T3","E7T3","E8T3","E9T3","E9T3","BilanT3","Moyenne retenue","Bilan Annuel"]
["Compétences 1 : Conseiller et vendre",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(B4:K4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N4:W4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z4:AI4),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M4,Y4,AK4),\"\")","v":""}]
["Assurer la veille commerciale",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N5:W5),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z5:AI5),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M5,Y5,AK5),\"\")","v":""}]
["Rechercher, hiérarchiser, exploiter et actualiser en continu les informations sur l’entreprise et son marché",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,""]
["Maitriser la technologie des produits",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,""]
["Sélectionner les outils de recherche d'information les plus adapté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,""]
["Réaliser la vente dans un cadre omnicanal",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,""]
["Intégrer l’omnicanal dansle processus de vente",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,""]
["Prendre contact avec le client",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,""]
["S’adapter au contexte commercial et au comportement du client",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écouvrir, analyser et identifier le(s) besoin(s) du client, sa (ses) motivation(s) et ses freins éventuels",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écouvrir, analyser et reformuler les besoins du client",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,""]
["Présenter l’entreprise et/ou ses produits et/ou ses services",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,""]
["Conseiller le client en proposant la solution adaptée",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,""]
["Argumenter",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,""]
["Réaliser une démonstration le cas échéant",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,""]
["Répondre aux objections du client",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,""]
["Proposer les produits et/ou les services associé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,""]
["Détecter les opportunités de vente(s)additionnelle(s) et les concrétiser",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,""]
["S’assurer de la disponibilité du produit",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,""]
["Formaliser l'accord du client",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,""]
["Assurer l’exécution de la vente",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,""]
["Mettre en place les modalités de réeglement et de livraison",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,""]
["Rassurer le client sur son choix",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,""]
["Prendre congé",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,""]
["Groupe de compétences 2 : Suivre les ventes",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,""]
["Assurer le suivi de la commande du produit et/ou du service",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,""]
["Suivre l’évolution de la commande et éventuellement du règlement",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,""]
["Informer le client des délais et des modalités de mise a disposition",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,""]
["Mettre en ceuvre le ou les services associé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,""]
["Sélectionner le cas échéant le prestataire le plus adapté",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,""]
["\nCollecter et transmettre les informations au service de l'entreprise ou aux prestataires concerné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,""]
["Suivre l’exécution du ou des service(s) associé(s) et en rendre compte",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,""]
["Effectuer le cas échéant les relances",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,""]
["Traiter les retours et les réclamations du client",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,""]
["\nIdentifier le(s) probléme(s) rencontré(s) par le client",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,""]
["Proposer une solution adaptée en tenant compte des procédures de l’entreprise et de la réglementation",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,""]
["S’assurer de la satisfaction du client",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,""]
["Collecter les informations de satisfaction auprés des clients",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,""]
["Mesurer et analyser la satisfaction du client",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,""]
["Transmettre les informations sur la satisfaction du client",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,""]
["Exploiter les informations recueillies a des fins d’amélioration",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,""]
["Proposer des éléments de nature a améliorer la satisfaction client",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,""]
["Groupe de compétences 3 : Fidéliser la clientèle et développer la relation client",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,""]
["Traiter et exploiter l'information ou le contact client",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,""]
["Traiter les messages et/ou les demandes des clients",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,""]
["Recueillir, extraire, exploiter, synthétiser les données : « de sources internes « de sources externes",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,""]
["Rendre compte des données appropriées",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,""]
["Proposer ces actions de fidélisation et/ou de développement de la relation client en adéquation avec les données recueillies et orientation commerciale de l’entreprise ",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,""]
["Contribuer a des actions de fidélisation de la clientéle et de développement de la relation client",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,""]
["Sélectionner et mettre en ceuvre les outils de fidélisation et/ou de développement de la relation client de l'entreprise",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,""]
["Concourir a la préparation et a organisation d’événements et/ou d’opérations de fidélisation/ développement de la relation client",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,""]
["Participer a la mise en ceuvre des événements et/ou opérations de fidélisation/ développement de la relation client",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,""]
["Effectuer des ventes au rebond",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,""]
["Réaliser les opérations de suivi post événement",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,""]
["Mobiliser les outils d'internet et les réseaux sociaux",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,""]
["Evaluer les actions de fidélisation et de développement de la relation client",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,""]
["Enrichir et actualiser le SIC",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,""]
["Mesurer et analyser les résultats",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,""]
["Rendre compte des actions et des résultats par écrit et/ou a l'oral",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,""]
["Proposer des axes d’amélioration",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,""]
["Groupe de compétences 4A : Animer et gérer l'espace commercial",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,""]
["Assurer les opérations préalables a la vente",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,""]
["Etablir les commandes des produits auprés de la centrale d’achats et/ou des fournisseurs indépendants sélectionnés avec la hiérarchie, en tenant compte des contraintes",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,""]
["Préparer les commandes des clients issues de l’omnicanal",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,""]
["Veiller a la gestion rigoureuse des stocks et au réapprovisionnement en tenant compte des régles de sécurité et d’hygiéne",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(B68:K68),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,""]
["Réceptionner, contrôler et stocker les marchandises (quantitatif et qualitatif)",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N69:W69),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z69:AI69),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M69,Y69,AK69),\"\")","v":""}]
["Respecter les régles de valorisation des déchets et réduire le gaspillage",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,""]
["\nEffectuer les relances et préparer les retours fournisseurs",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,""]
["Etablir le prix en fonction de variables commerciales données",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,""]
["Etiqueter les produits et les sécuriser",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,""]
["Enrichir et exploiter le systeme d'information commercial",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,""]
["Comparer les résultats aux objectifs fixés et proposer des actions correctrices",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,""]
["Participer aux opérations d'inventaire",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,""]
["Identifier les invendus ",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,""]
["Lutter contre la démarque",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,""]
["Gérer les retours et les changes des clients",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,""]
["Rendre l’unité commerciale attractive et fonctionnelle",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,""]
["S’assurer de la disponibilité et de la qualité des produits",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,""]
["Implanter les produits selon une logique commerciale et/ou d'entreprise",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,""]
["Vérifier I’étiquetage, le balisage et la mise en valeur des produits",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,""]
["S’assurer de la bonne tenue et de la propreté du rayon",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,""]
["Accueillir, informer et orienter le client dans l’unité commerciale et a l'extérieur",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,""]
["Mettre en place la signalétique",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,""]
["Participer a l'agencement de la surface de vente",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,""]
["Aménager la vitrine et/ou le rayon",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,""]
["Mettre en scéne l’offre et en optimiser la visibilité",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,""]
["Veiller au respect des régles d’hygiéne et de sécurité.",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,""]
["Valoriser loffre sur les sites marchands et les réseaux sociaux",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évelopper la clientele",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,""]
["Proposer des actions commerciales génératrices de trafic dans l’unité commerciale",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,""]
["Sélectionner les gammes de produits a mettre en avant en lien avec la stratégie de l’unité commerciale",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,""]
["Participer a la planification et a organisation des actions de promotion des marchandises",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émarcher une nouvelle clientéle Communiquer sur l'événement",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,""]
["Communiquer sur l'évènement",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,""]
["Recourir aux sites marchands et aux réseaux sociaux",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,""]
["Inciter a l'achat par une action commerciale, le cas échéant interactive",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,""]
["Générer des contacts positifs/utiles",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,""]
["Participer a l’évaluation et a l'analyse des performances des actions commerciales",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(M103:W103),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Y103:AI103),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(L103,X103,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L104,X104,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L105,X105,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L106,X106,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L107,X107,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L108,X108,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L109,X109,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L110,X110,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L111,X111,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L112,X112,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L113,X113,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L114,X114,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L115,X115,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L116,X116,#REF!),\"\")","v":""}]

{"sheet":"Eleve3","index":3,"n_rows":116,"n_cols":38,"rows_kept":116,"cut":false,"hidden":false,"merged":[[0,1,1,4],[0,12,1,16],[0,24,1,28]]}
[null,"Evaluation 1er trimestre",null,null,null,null,"Maîtrise insuffisante",null,"Maîtrise satisfaisante",null,null,null,"Evaluation 2ème trimestre",null,null,null,null,null,null,null,null,null,null,null,"Evaluation 3ème trimestre"]
[null,null,null,null,null,null,"Maîtrise fragile",null,"Très bonne maîtrise"]
[null,"E1T1","E2T1","E3T1","E4T1","E5T1","E6T1","E7T1","E8T1","E9T1","E10T1","BilanT1","Moyenne retenue","E1T2","E2T2","E3T2","E4T2","E5T2","E6T2","E7T2","E8T2","E9T2","E10T2","BilanT2","Moyenne retenue","E1T3","E2T3","E3T3","E4T3","E5T3","E6T3","E7T3","E8T3","E9T3","E9T3","BilanT3","Moyenne retenue","Bilan Annuel"]
["Compétences 1 : Conseiller et vendre",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(B4:K4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N4:W4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z4:AI4),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M4,Y4,AK4),\"\")","v":""}]
["Assurer la veille commerciale",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N5:W5),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z5:AI5),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M5,Y5,AK5),\"\")","v":""}]
["Rechercher, hiérarchiser, exploiter et actualiser en continu les informations sur l’entreprise et son marché",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,""]
["Maitriser la technologie des produits",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,""]
["Sélectionner les outils de recherche d'information les plus adapté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,""]
["Réaliser la vente dans un cadre omnicanal",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,""]
["Intégrer l’omnicanal dansle processus de vente",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,""]
["Prendre contact avec le client",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,""]
["S’adapter au contexte commercial et au comportement du client",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écouvrir, analyser et identifier le(s) besoin(s) du client, sa (ses) motivation(s) et ses freins éventuels",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écouvrir, analyser et reformuler les besoins du client",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,""]
["Présenter l’entreprise et/ou ses produits et/ou ses services",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,""]
["Conseiller le client en proposant la solution adaptée",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,""]
["Argumenter",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,""]
["Réaliser une démonstration le cas échéant",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,""]
["Répondre aux objections du client",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,""]
["Proposer les produits et/ou les services associé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,""]
["Détecter les opportunités de vente(s)additionnelle(s) et les concrétiser",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,""]
["S’assurer de la disponibilité du produit",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,""]
["Formaliser l'accord du client",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,""]
["Assurer l’exécution de la vente",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,""]
["Mettre en place les modalités de réeglement et de livraison",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,""]
["Rassurer le client sur son choix",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,""]
["Prendre congé",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,""]
["Groupe de compétences 2 : Suivre les ventes",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,""]
["Assurer le suivi de la commande du produit et/ou du service",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,""]
["Suivre l’évolution de la commande et éventuellement du règlement",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,""]
["Informer le client des délais et des modalités de mise a disposition",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,""]
["Mettre en ceuvre le ou les services associé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,""]
["Sélectionner le cas échéant le prestataire le plus adapté",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,""]
["\nCollecter et transmettre les informations au service de l'entreprise ou aux prestataires concerné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,""]
["Suivre l’exécution du ou des service(s) associé(s) et en rendre compte",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,""]
["Effectuer le cas échéant les relances",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,""]
["Traiter les retours et les réclamations du client",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,""]
["\nIdentifier le(s) probléme(s) rencontré(s) par le client",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,""]
["Proposer une solution adaptée en tenant compte des procédures de l’entreprise et de la réglementation",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,""]
["S’assurer de la satisfaction du client",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,""]
["Collecter les informations de satisfaction auprés des clients",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,""]
["Mesurer et analyser la satisfaction du client",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,""]
["Transmettre les informations sur la satisfaction du client",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,""]
["Exploiter les informations recueillies a des fins d’amélioration",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,""]
["Proposer des éléments de nature a améliorer la satisfaction client",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,""]
["Groupe de compétences 3 : Fidéliser la clientèle et développer la relation client",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,""]
["Traiter et exploiter l'information ou le contact client",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,""]
["Traiter les messages et/ou les demandes des clients",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,""]
["Recueillir, extraire, exploiter, synthétiser les données : « de sources internes « de sources externes",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,""]
["Rendre compte des données appropriées",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,""]
["Proposer ces actions de fidélisation et/ou de développement de la relation client en adéquation avec les données recueillies et orientation commerciale de l’entreprise ",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,""]
["Contribuer a des actions de fidélisation de la clientéle et de développement de la relation client",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,""]
["Sélectionner et mettre en ceuvre les outils de fidélisation et/ou de développement de la relation client de l'entreprise",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,""]
["Concourir a la préparation et a organisation d’événements et/ou d’opérations de fidélisation/ développement de la relation client",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,""]
["Participer a la mise en ceuvre des événements et/ou opérations de fidélisation/ développement de la relation client",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,""]
["Effectuer des ventes au rebond",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,""]
["Réaliser les opérations de suivi post événement",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,""]
["Mobiliser les outils d'internet et les réseaux sociaux",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,""]
["Evaluer les actions de fidélisation et de développement de la relation client",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,""]
["Enrichir et actualiser le SIC",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,""]
["Mesurer et analyser les résultats",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,""]
["Rendre compte des actions et des résultats par écrit et/ou a l'oral",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,""]
["Proposer des axes d’amélioration",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,""]
["Groupe de compétences 4A : Animer et gérer l'espace commercial",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,""]
["Assurer les opérations préalables a la vente",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,""]
["Etablir les commandes des produits auprés de la centrale d’achats et/ou des fournisseurs indépendants sélectionnés avec la hiérarchie, en tenant compte des contraintes",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,""]
["Préparer les commandes des clients issues de l’omnicanal",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,""]
["Veiller a la gestion rigoureuse des stocks et au réapprovisionnement en tenant compte des régles de sécurité et d’hygiéne",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(B68:K68),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,""]
["Réceptionner, contrôler et stocker les marchandises (quantitatif et qualitatif)",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N69:W69),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z69:AI69),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M69,Y69,AK69),\"\")","v":""}]
["Respecter les régles de valorisation des déchets et réduire le gaspillage",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,""]
["\nEffectuer les relances et préparer les retours fournisseurs",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,""]
["Etablir le prix en fonction de variables commerciales données",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,""]
["Etiqueter les produits et les sécuriser",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,""]
["Enrichir et exploiter le systeme d'information commercial",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,""]
["Comparer les résultats aux objectifs fixés et proposer des actions correctrices",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,""]
["Participer aux opérations d'inventaire",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,""]
["Identifier les invendus ",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,""]
["Lutter contre la démarque",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,""]
["Gérer les retours et les changes des clients",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,""]
["Rendre l’unité commerciale attractive et fonctionnelle",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,""]
["S’assurer de la disponibilité et de la qualité des produits",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,""]
["Implanter les produits selon une logique commerciale et/ou d'entreprise",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,""]
["Vérifier I’étiquetage, le balisage et la mise en valeur des produits",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,""]
["S’assurer de la bonne tenue et de la propreté du rayon",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,""]
["Accueillir, informer et orienter le client dans l’unité commerciale et a l'extérieur",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,""]
["Mettre en place la signalétique",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,""]
["Participer a l'agencement de la surface de vente",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,""]
["Aménager la vitrine et/ou le rayon",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,""]
["Mettre en scéne l’offre et en optimiser la visibilité",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,""]
["Veiller au respect des régles d’hygiéne et de sécurité.",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,""]
["Valoriser loffre sur les sites marchands et les réseaux sociaux",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évelopper la clientele",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,""]
["Proposer des actions commerciales génératrices de trafic dans l’unité commerciale",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,""]
["Sélectionner les gammes de produits a mettre en avant en lien avec la stratégie de l’unité commerciale",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,""]
["Participer a la planification et a organisation des actions de promotion des marchandises",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émarcher une nouvelle clientéle Communiquer sur l'événement",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,""]
["Communiquer sur l'évènement",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,""]
["Recourir aux sites marchands et aux réseaux sociaux",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,""]
["Inciter a l'achat par une action commerciale, le cas échéant interactive",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,""]
["Générer des contacts positifs/utiles",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,""]
["Participer a l’évaluation et a l'analyse des performances des actions commerciales",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(M103:W103),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Y103:AI103),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(L103,X103,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L104,X104,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L105,X105,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L106,X106,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L107,X107,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L108,X108,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L109,X109,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L110,X110,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L111,X111,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L112,X112,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L113,X113,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L114,X114,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L115,X115,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L116,X116,#REF!),\"\")","v":""}]

{"sheet":"Eleve4","index":4,"n_rows":116,"n_cols":38,"rows_kept":116,"cut":false,"hidden":false,"merged":[[0,1,1,4],[0,12,1,16],[0,24,1,28]]}
[null,"Evaluation 1er trimestre",null,null,null,null,"Maîtrise insuffisante",null,"Maîtrise satisfaisante",null,null,null,"Evaluation 2ème trimestre",null,null,null,null,null,null,null,null,null,null,null,"Evaluation 3ème trimestre"]
[null,null,null,null,null,null,"Maîtrise fragile",null,"Très bonne maîtrise"]
[null,"E1T1","E2T1","E3T1","E4T1","E5T1","E6T1","E7T1","E8T1","E9T1","E10T1","BilanT1","Moyenne retenue","E1T2","E2T2","E3T2","E4T2","E5T2","E6T2","E7T2","E8T2","E9T2","E10T2","BilanT2","Moyenne retenue","E1T3","E2T3","E3T3","E4T3","E5T3","E6T3","E7T3","E8T3","E9T3","E9T3","BilanT3","Moyenne retenue","Bilan Annuel"]
["Groupe de compétences 1 : Conseiller et vendre",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(B4:K4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N4:W4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z4:AI4),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M4,Y4,AK4),\"\")","v":""}]
["Assurer la veille commerciale",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N5:W5),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z5:AI5),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M5,Y5,AK5),\"\")","v":""}]
["Rechercher, hiérarchiser, exploiter et actualiser en continu les informations sur l’entreprise et son marché",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,""]
["Maitriser la technologie des produits",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,""]
["Sélectionner les outils de recherche d'information les plus adapté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,""]
["Réaliser la vente dans un cadre omnicanal",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,""]
["Intégrer l’omnicanal dansle processus de vente",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,""]
["Prendre contact avec le client",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,""]
["S’adapter au contexte commercial et au comportement du client",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écouvrir, analyser et identifier le(s) besoin(s) du client, sa (ses) motivation(s) et ses freins éventuels",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écouvrir, analyser et reformuler les besoins du client",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,""]
["Présenter l’entreprise et/ou ses produits et/ou ses services",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,""]
["Conseiller le client en proposant la solution adaptée",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,""]
["Argumenter",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,""]
["Réaliser une démonstration le cas échéant",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,""]
["Répondre aux objections du client",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,""]
["Proposer les produits et/ou les services associé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,""]
["Détecter les opportunités de vente(s)additionnelle(s) et les concrétiser",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,""]
["S’assurer de la disponibilité du produit",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,""]
["Formaliser l'accord du client",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,""]
["Assurer l’exécution de la vente",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,""]
["Mettre en place les modalités de réeglement et de livraison",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,""]
["Rassurer le client sur son choix",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,""]
["Prendre congé",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,""]
["Groupe de compétences 2 : Suivre les ventes",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,""]
["Assurer le suivi de la commande du produit et/ou du service",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,""]
["Suivre l’évolution de la commande et éventuellement du règlement",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,""]
["Informer le client des délais et des modalités de mise a disposition",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,""]
["Mettre en ceuvre le ou les services associé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,""]
["Sélectionner le cas échéant le prestataire le plus adapté",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,""]
["\nCollecter et transmettre les informations au service de l'entreprise ou aux prestataires concerné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,""]
["Suivre l’exécution du ou des service(s) associé(s) et en rendre compte",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,""]
["Effectuer le cas échéant les relances",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,""]
["Traiter les retours et les réclamations du client",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,""]
["\nIdentifier le(s) probléme(s) rencontré(s) par le client",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,""]
["Proposer une solution adaptée en tenant compte des procédures de l’entreprise et de la réglementation",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,""]
["S’assurer de la satisfaction du client",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,""]
["Collecter les informations de satisfaction auprés des clients",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,""]
["Mesurer et analyser la satisfaction du client",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,""]
["Transmettre les informations sur la satisfaction du client",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,""]
["Exploiter les informations recueillies a des fins d’amélioration",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,""]
["Proposer des éléments de nature a améliorer la satisfaction client",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,""]
["Groupe de compétences 3 : Fidéliser la clientèle et développer la relation client",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,""]
["Traiter et exploiter l'information ou le contact client",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,""]
["Traiter les messages et/ou les demandes des clients",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,""]
["Recueillir, extraire, exploiter, synthétiser les données : « de sources internes « de sources externes",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,""]
["Rendre compte des données appropriées",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,""]
["Proposer ces actions de fidélisation et/ou de développement de la relation client en adéquation avec les données recueillies et orientation commerciale de l’entreprise ",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,""]
["Contribuer a des actions de fidélisation de la clientéle et de développement de la relation client",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,""]
["Sélectionner et mettre en ceuvre les outils de fidélisation et/ou de développement de la relation client de l'entreprise",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,""]
["Concourir a la préparation et a organisation d’événements et/ou d’opérations de fidélisation/ développement de la relation client",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,""]
["Participer a la mise en ceuvre des événements et/ou opérations de fidélisation/ développement de la relation client",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,""]
["Effectuer des ventes au rebond",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,""]
["Réaliser les opérations de suivi post événement",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,""]
["Mobiliser les outils d'internet et les réseaux sociaux",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,""]
["Evaluer les actions de fidélisation et de développement de la relation client",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,""]
["Enrichir et actualiser le SIC",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,""]
["Mesurer et analyser les résultats",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,""]
["Rendre compte des actions et des résultats par écrit et/ou a l'oral",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,""]
["Proposer des axes d’amélioration",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,""]
["Groupe de compétences 4A : Animer et gérer l'espace commercial",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,""]
["Assurer les opérations préalables a la vente",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,""]
["Etablir les commandes des produits auprés de la centrale d’achats et/ou des fournisseurs indépendants sélectionnés avec la hiérarchie, en tenant compte des contraintes",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,""]
["Préparer les commandes des clients issues de l’omnicanal",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,""]
["Veiller a la gestion rigoureuse des stocks et au réapprovisionnement en tenant compte des régles de sécurité et d’hygiéne",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(B68:K68),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,""]
["Réceptionner, contrôler et stocker les marchandises (quantitatif et qualitatif)",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N69:W69),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z69:AI69),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M69,Y69,AK69),\"\")","v":""}]
["Respecter les régles de valorisation des déchets et réduire le gaspillage",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,""]
["\nEffectuer les relances et préparer les retours fournisseurs",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,""]
["Etablir le prix en fonction de variables commerciales données",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,""]
["Etiqueter les produits et les sécuriser",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,""]
["Enrichir et exploiter le systeme d'information commercial",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,""]
["Comparer les résultats aux objectifs fixés et proposer des actions correctrices",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,""]
["Participer aux opérations d'inventaire",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,""]
["Identifier les invendus ",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,""]
["Lutter contre la démarque",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,""]
["Gérer les retours et les changes des clients",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,""]
["Rendre l’unité commerciale attractive et fonctionnelle",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,""]
["S’assurer de la disponibilité et de la qualité des produits",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,""]
["Implanter les produits selon une logique commerciale et/ou d'entreprise",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,""]
["Vérifier I’étiquetage, le balisage et la mise en valeur des produits",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,""]
["S’assurer de la bonne tenue et de la propreté du rayon",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,""]
["Accueillir, informer et orienter le client dans l’unité commerciale et a l'extérieur",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,""]
["Mettre en place la signalétique",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,""]
["Participer a l'agencement de la surface de vente",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,""]
["Aménager la vitrine et/ou le rayon",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,""]
["Mettre en scéne l’offre et en optimiser la visibilité",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,""]
["Veiller au respect des régles d’hygiéne et de sécurité.",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,""]
["Valoriser loffre sur les sites marchands et les réseaux sociaux",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évelopper la clientele",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,""]
["Proposer des actions commerciales génératrices de trafic dans l’unité commerciale",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,""]
["Sélectionner les gammes de produits a mettre en avant en lien avec la stratégie de l’unité commerciale",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,""]
["Participer a la planification et a organisation des actions de promotion des marchandises",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émarcher une nouvelle clientéle Communiquer sur l'événement",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,""]
["Communiquer sur l'évènement",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,""]
["Recourir aux sites marchands et aux réseaux sociaux",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,""]
["Inciter a l'achat par une action commerciale, le cas échéant interactive",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,""]
["Générer des contacts positifs/utiles",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,""]
["Participer a l’évaluation et a l'analyse des performances des actions commerciales",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(M103:W103),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Y103:AI103),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(L103,X103,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L104,X104,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L105,X105,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L106,X106,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L107,X107,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L108,X108,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L109,X109,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L110,X110,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L111,X111,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L112,X112,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L113,X113,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L114,X114,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L115,X115,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L116,X116,#REF!),\"\")","v":""}]

{"sheet":"Eleve5","index":5,"n_rows":116,"n_cols":38,"rows_kept":116,"cut":false,"hidden":false,"merged":[[0,1,1,4],[0,12,1,16],[0,24,1,28]]}
[null,"Evaluation 1er trimestre",null,null,null,null,"Maîtrise insuffisante",null,"Maîtrise satisfaisante",null,null,null,"Evaluation 2ème trimestre",null,null,null,null,null,null,null,null,null,null,null,"Evaluation 3ème trimestre"]
[null,null,null,null,null,null,"Maîtrise fragile",null,"Très bonne maîtrise"]
[null,"E1T1","E2T1","E3T1","E4T1","E5T1","E6T1","E7T1","E8T1","E9T1","E10T1","BilanT1","Moyenne retenue","E1T2","E2T2","E3T2","E4T2","E5T2","E6T2","E7T2","E8T2","E9T2","E10T2","BilanT2","Moyenne retenue","E1T3","E2T3","E3T3","E4T3","E5T3","E6T3","E7T3","E8T3","E9T3","E9T3","BilanT3","Moyenne retenue","Bilan Annuel"]
["Compétences 1 : Conseiller et vendre",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(B4:K4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N4:W4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z4:AI4),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M4,Y4,AK4),\"\")","v":""}]
["Assurer la veille commerciale",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N5:W5),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z5:AI5),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M5,Y5,AK5),\"\")","v":""}]
["Rechercher, hiérarchiser, exploiter et actualiser en continu les informations sur l’entreprise et son marché",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,""]
["Maitriser la technologie des produits",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,""]
["Sélectionner les outils de recherche d'information les plus adapté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,""]
["Réaliser la vente dans un cadre omnicanal",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,""]
["Intégrer l’omnicanal dansle processus de vente",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,""]
["Prendre contact avec le client",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,""]
["S’adapter au contexte commercial et au comportement du client",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écouvrir, analyser et identifier le(s) besoin(s) du client, sa (ses) motivation(s) et ses freins éventuels",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écouvrir, analyser et reformuler les besoins du client",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,""]
["Présenter l’entreprise et/ou ses produits et/ou ses services",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,""]
["Conseiller le client en proposant la solution adaptée",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,""]
["Argumenter",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,""]
["Réaliser une démonstration le cas échéant",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,""]
["Répondre aux objections du client",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,""]
["Proposer les produits et/ou les services associé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,""]
["Détecter les opportunités de vente(s)additionnelle(s) et les concrétiser",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,""]
["S’assurer de la disponibilité du produit",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,""]
["Formaliser l'accord du client",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,""]
["Assurer l’exécution de la vente",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,""]
["Mettre en place les modalités de réeglement et de livraison",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,""]
["Rassurer le client sur son choix",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,""]
["Prendre congé",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,""]
["Groupe de compétences 2 : Suivre les ventes",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,""]
["Assurer le suivi de la commande du produit et/ou du service",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,""]
["Suivre l’évolution de la commande et éventuellement du règlement",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,""]
["Informer le client des délais et des modalités de mise a disposition",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,""]
["Mettre en ceuvre le ou les services associé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,""]
["Sélectionner le cas échéant le prestataire le plus adapté",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,""]
["\nCollecter et transmettre les informations au service de l'entreprise ou aux prestataires concerné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,""]
["Suivre l’exécution du ou des service(s) associé(s) et en rendre compte",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,""]
["Effectuer le cas échéant les relances",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,""]
["Traiter les retours et les réclamations du client",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,""]
["\nIdentifier le(s) probléme(s) rencontré(s) par le client",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,""]
["Proposer une solution adaptée en tenant compte des procédures de l’entreprise et de la réglementation",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,""]
["S’assurer de la satisfaction du client",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,""]
["Collecter les informations de satisfaction auprés des clients",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,""]
["Mesurer et analyser la satisfaction du client",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,""]
["Transmettre les informations sur la satisfaction du client",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,""]
["Exploiter les informations recueillies a des fins d’amélioration",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,""]
["Proposer des éléments de nature a améliorer la satisfaction client",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,""]
["Groupe de compétences 3 : Fidéliser la clientèle et développer la relation client",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,""]
["Traiter et exploiter l'information ou le contact client",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,""]
["Traiter les messages et/ou les demandes des clients",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,""]
["Recueillir, extraire, exploiter, synthétiser les données : « de sources internes « de sources externes",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,""]
["Rendre compte des données appropriées",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,""]
["Proposer ces actions de fidélisation et/ou de développement de la relation client en adéquation avec les données recueillies et orientation commerciale de l’entreprise ",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,""]
["Contribuer a des actions de fidélisation de la clientéle et de développement de la relation client",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,""]
["Sélectionner et mettre en ceuvre les outils de fidélisation et/ou de développement de la relation client de l'entreprise",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,""]
["Concourir a la préparation et a organisation d’événements et/ou d’opérations de fidélisation/ développement de la relation client",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,""]
["Participer a la mise en ceuvre des événements et/ou opérations de fidélisation/ développement de la relation client",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,""]
["Effectuer des ventes au rebond",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,""]
["Réaliser les opérations de suivi post événement",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,""]
["Mobiliser les outils d'internet et les réseaux sociaux",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,""]
["Evaluer les actions de fidélisation et de développement de la relation client",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,""]
["Enrichir et actualiser le SIC",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,""]
["Mesurer et analyser les résultats",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,""]
["Rendre compte des actions et des résultats par écrit et/ou a l'oral",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,""]
["Proposer des axes d’amélioration",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,""]
["Groupe de compétences 4A : Animer et gérer l'espace commercial",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,""]
["Assurer les opérations préalables a la vente",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,""]
["Etablir les commandes des produits auprés de la centrale d’achats et/ou des fournisseurs indépendants sélectionnés avec la hiérarchie, en tenant compte des contraintes",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,""]
["Préparer les commandes des clients issues de l’omnicanal",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,""]
["Veiller a la gestion rigoureuse des stocks et au réapprovisionnement en tenant compte des régles de sécurité et d’hygiéne",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(B68:K68),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,""]
["Réceptionner, contrôler et stocker les marchandises (quantitatif et qualitatif)",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(N69:W69),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Z69:AI69),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(M69,Y69,AK69),\"\")","v":""}]
["Respecter les régles de valorisation des déchets et réduire le gaspillage",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,""]
["\nEffectuer les relances et préparer les retours fournisseurs",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,""]
["Etablir le prix en fonction de variables commerciales données",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,""]
["Etiqueter les produits et les sécuriser",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,""]
["Enrichir et exploiter le systeme d'information commercial",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,""]
["Comparer les résultats aux objectifs fixés et proposer des actions correctrices",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,""]
["Participer aux opérations d'inventaire",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,""]
["Identifier les invendus ",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,""]
["Lutter contre la démarque",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,""]
["Gérer les retours et les changes des clients",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,""]
["Rendre l’unité commerciale attractive et fonctionnelle",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,""]
["S’assurer de la disponibilité et de la qualité des produits",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,""]
["Implanter les produits selon une logique commerciale et/ou d'entreprise",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,""]
["Vérifier I’étiquetage, le balisage et la mise en valeur des produits",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,""]
["S’assurer de la bonne tenue et de la propreté du rayon",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,""]
["Accueillir, informer et orienter le client dans l’unité commerciale et a l'extérieur",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,""]
["Mettre en place la signalétique",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,""]
["Participer a l'agencement de la surface de vente",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,""]
["Aménager la vitrine et/ou le rayon",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,""]
["Mettre en scéne l’offre et en optimiser la visibilité",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,""]
["Veiller au respect des régles d’hygiéne et de sécurité.",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,""]
["Valoriser loffre sur les sites marchands et les réseaux sociaux",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évelopper la clientele",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,""]
["Proposer des actions commerciales génératrices de trafic dans l’unité commerciale",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,""]
["Sélectionner les gammes de produits a mettre en avant en lien avec la stratégie de l’unité commerciale",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,""]
["Participer a la planification et a organisation des actions de promotion des marchandises",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émarcher une nouvelle clientéle Communiquer sur l'événement",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,""]
["Communiquer sur l'évènement",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,""]
["Recourir aux sites marchands et aux réseaux sociaux",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,""]
["Inciter a l'achat par une action commerciale, le cas échéant interactive",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,""]
["Générer des contacts positifs/utiles",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,""]
["Participer a l’évaluation et a l'analyse des performances des actions commerciales",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(M103:W103),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Y103:AI103),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(L103,X103,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L104,X104,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L105,X105,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L106,X106,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L107,X107,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L108,X108,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L109,X109,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L110,X110,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L111,X111,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L112,X112,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L113,X113,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L114,X114,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L115,X115,#REF!),\"\")","v":""}]
[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,{"$f":"IFERROR(AVERAGE(L116,X116,#REF!),\"\")","v":""}]