{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Identification","S1","S2 et Bilan de compétences"],"not_rendered":{"charts":16,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Identification","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,1],[0,0,0,4],[2,0,2,4],[3,1,3,4],[4,1,4,4],[14,1,14,2],[11,0,11,4],[12,0,12,4],[13,0,13,4],[6,1,6,4],[10,0,10,4],[16,0,16,4],[18,0,18,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[19,0,19,1]]}
["Toutes les cases grisées doivent être renseignées par les professeurs concernés. Elles deviennent blanches une fois remplies"]
[]
["Identification",null,null,null,null,null,null,"C4A"]
["Diplôme ","Certificat d'Aptitude Professionnelle \" Conducteur Agent d'accueil en autobus et autocar \"  ",null,null,null,null,null,"EP2"]
["Épreuve","EP2 – Conduite d’un véhicule en sécurité - Unité UP2"]
["Coefficient ",5]
["Établissement du candidat",null,null,null,null,null,null,{"$f":"CONCATENATE(H4,\"-\",H3,\"-\",B8,\"-\",B9)","v":"EP2-C4A-2025-"}]
["Session  ",2025]
["Nom - Prénom du Candidat"]
["Numéro de Candidat"]
[]
["Description sommaire du travail demandé"]
[]
["Tâches support de l'évaluation"]
["A2.1","Conduite en sécurité, de manière rationnelle et mise en oeuvre des procédures d’incident et d’accident"]
[]
[" Les lignes renseignent automatiquement la feuille \"Bilan de compétences\" sauf la date à renseigner manuellement le jour de l'attribution de la note"]
["Noms et prénoms des professeurs évaluateurs"]

{"sheet":"S1","index":1,"n_rows":45,"n_cols":24,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,2,1,7],[0,8,3,8],[21,2,21,7],[27,2,27,7],[5,2,5,8],[8,2,8,8],[35,9,35,16],[30,3,30,5],[30,6,30,7],[29,9,29,16],[2,3,2,4],[47,3,47,8],[5,0,17,0],[37,3,37,8],[38,3,38,8],[40,3,40,7],[42,3,42,8],[44,3,44,8],[45,3,45,8],[31,1,31,7],[32,1,32,8],[34,1,34,8],[35,1,35,8],[18,0,22,0],[28,2,28,7],[16,2,16,8],[12,5,12,8]]}
[null,{"$f":"Identification!B4","v":"Certificat d'Aptitude Professionnelle \" Conducteur Agent d'accueil en autobus et autocar \"  "},"",null,null,null,null,null,"colonne H"]
[null,{"$f":"Identification!B5","v":"EP2 – Conduite d’un véhicule en sécurité - Unité UP2"}]
[null,{"$f":"T(Identification!B9)","v":""},null,"MI",null,"MF","MS","TBM"]
[null,"Bilan des compétences                                                                                   évaluation","E*",0,0.5,1,2,3,null,null,null,"explication: à effacer après validation"]
[null,"C3 CONDUIRE DE MANIÈRE PROFESSIONNELLE"]
["C3.1","Connaître et maîtriser son véhicule",null,null,null,null,null,null,null,null,null,"sous totaux permis","note sur 18"]
[null,"Savoir s'installer et assurer la sécurité à bord",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C7:H7)=1,\"\",\"◄\"))","v":"◄"},null,null,15,10,"si bonus <2: non valide",null,null,null,null,null,null,null,{"$f":"COUNTA(G7)","v":0},0,{"$f":"IF(G7<>\"\",'S2 et Bilan de compétences'!L6=\"X\",\"\")","v":""}]
[null,"Connaître et utiliser les commandes",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C8:H8)=1,\"\",\"◄\"))","v":"◄"},null,null,{"$f":"L7+1","v":16},10,"si bonus<1: non valide"]
[null,"Appréhender la route",null,null,null,null,null,null,null,null,null,{"$f":"L8+1","v":17},10]
[null,"Prendre l'information",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C10:H10)=1,\"\",\"◄\"))","v":"◄"},null,null,18,{"$f":"(L10-17)*(8/9)+10","v":10.888888888888889}]
[null,"Adapter son allure aux circonstances",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C11:H11)=1,\"\",\"◄\"))","v":"◄"},null,null,19,{"$f":"(L11-17)*(8/9)+10","v":11.777777777777779}]
[null,"Appliquer la réglementation",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C12:H12)=1,\"\",\"◄\"))","v":"◄"},null,null,20,12.666666666666666]
[null,"Partager la route avec les autres usagers",null,null,null,null,null,null,null,null,null,21,13.555555555555555]
[null,"Communiquer avec les autres usagers",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C14:H14)=1,\"\",\"◄\"))","v":"◄"},null,null,22,14.444444444444445]
[null,"Partager la chaussée",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C15:H15)=1,\"\",\"◄\"))","v":"◄"},null,null,23,15.333333333333332]
[null,"Maintenir les espaces de sécurité",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C16:H16)=1,\"\",\"◄\"))","v":"◄"},null,null,24,16.222222222222221]
[null,"Autonomie / conscience du risque",null,null,null,null,null,null,null,null,null,25,17.111111111111111]
[null,"Conduite autonome",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C18:H18)=1,\"\",\"◄\"))","v":"◄"},null,null,{"$f":"L17+1","v":26},18]
["C3.2","Adaptation aux situations",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C19:H19)=1,\"\",\"◄\"))","v":"◄"},{"$f":"(IF(D19<>\"\",0,0)+IF(E19<>\"\",1,0)+IF(F19<>\"\",2,0))","v":0},null,{"$f":"L18+1","v":27},18.888888888888889]
[null,"Analyse des situations",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C20:H20)=1,\"\",\"◄\"))","v":"◄"},{"$f":"(IF(D20<>\"\",0,0)+IF(E20<>\"\",1,0)+IF(F20<>\"\",2,0))","v":0},null,{"$f":"L19+1","v":28},19.777777777777779]
[null,null,{"$f":"COUNTA(C7:C20)","v":0},0,0,0,0,0,null,null,null,{"$f":"L20+1","v":29},{"$f":"20","v":20}]
[null,"Sous-totaux (Fiche de recueil)",{"$f":"D4*D21+E4*E21+F4*F21+G4*G21+H4*H21","v":0},null,null,null,null,null,null,{"$f":"IF(((15<=C22)*AND(C22<=17)),17,C22)","v":0},{"$f":"D4*D21+E4*E21+F4*F21+G4*G21+H4*H21+(COUNTA(J19:J20,J23:J24))","v":4}]
[null,"Conduite économique et respectueuse de l'environnement",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C23:H23)=1,\"\",\"◄\"))","v":"◄"},{"$f":"(IF(D20<>\"\",0,0)+IF(E20<>\"\",1,0)+IF(F20<>\"\",2,0))","v":0}]
["C3.1","Courtoisie",null,null,null,null,null,null,{"$f":"(IF(COUNTA(C24:H24)=1,\"\",\"◄\"))","v":"◄"},{"$f":"(IF(D20<>\"\",0,0)+IF(E20<>\"\",1,0)+IF(F20<>\"\",2,0))","v":0}]
[]
[null,"Examen non mené à son terme"]
[null,null,{"$f":"C21+COUNTA(C26)","v":0},{"$f":"D21+COUNTA(D23:D24)","v":0},{"$f":"E21+COUNTA(E23:E24)","v":0},{"$f":"F21+COUNTA(F23:F24)","v":0},{"$f":"G21+COUNTA(G23:G24)","v":0},{"$f":"H21+COUNTA(H23:H24)","v":0},null,"total général"]
[null,"Total général (Fiche de recueil: en points)",{"$f":"D27*D4+E27*E4+F27*F4+G27*G4+H27*H4","v":0},null,null,null,null,null,{"$f":"COUNTIF(I7:I24,\"◄\")","v":13},{"$f":"AND(C28>=17,I28=0)","v":false}]
[null,"Bilan de l'épreuve en Circulation",{"$f":"IF(C27>0,\"INSUFFISANT\", J29)","v":"INSUFFISANT"},null,null,null,null,null,{"$f":"AND(I28>0,COUNTA(C26)=0)","v":true},{"$f":"IF(J28=TRUE,\"FAVORABLE\",\"INSUFFISANT\")","v":"INSUFFISANT"},{"$f":"AND(C29=\"INSUFFISANT\",C30<>\"\")","v":false}]
[null,"Candidat étant en possession d'un permis D valide et d'une qualification initiale",null,null,null,null,null,null,null,{"$f":"IF(K29=TRUE, \"CANDIDAT DÉJÀ TITULAIRE DE SON PERMIS D VALIDE\",\"\")","v":""}]
[null,"Note coéfficientée proposée au jury:",null,null,null,null,"/140"]
[null,"*: Eliminatoire"]
[null,"Si le candidat a mené l'examen à son terme, le symbole ◄ ne doit pas apparaître en colonne H."]
[]
[null,"Appréciation globale:",null,null,null,null,null,null,null,{"$f":"AND(C29=\"INSUFFISANT\",C30=\"\",B36=\"\")","v":true}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J35=TRUE,\"VEUILLEZ COMMENTER VOTRE RESULTAT EN METTANT EN EVIDENCE LES POINTS NECESSITANT UN COMPLEMENT DE FORMATION\",\"\")","v":"VEUILLEZ COMMENTER VOTRE RESULTAT EN METTANT EN EVIDENCE LES POINTS NECESSITANT UN COMPLEMENT DE FORMATION"}]
[]
[null,"Noms des correcteurs et Signatures",null,"Date"]
[]
[]
[]
[]
[null,"Epreuve hors circulation "]
[]
[null,"Noms des correcteurs et Signatures",null,"Date"]

{"sheet":"S2 et Bilan de compétences","index":2,"n_rows":62,"n_cols":32,"rows_kept":62,"cut":false,"hidden":false,"merged":[[15,0,18,0],[15,1,18,1],[18,2,18,6],[24,0,26,0],[24,1,26,1],[26,2,26,6],[22,0,22,1],[22,2,22,6],[24,2,24,6],[23,0,23,12],[25,2,25,6],[20,8,20,13],[19,0,19,6],[20,0,20,6],[21,0,21,13],[47,10,47,11],[45,10,45,11],[46,10,46,11],[48,10,48,11],[31,2,31,6],[32,2,32,6],[33,2,33,6],[35,2,35,6],[37,2,37,6],[40,2,40,6],[38,2,38,6],[39,2,39,6],[41,2,41,6],[48,7,48,9],[48,2,48,6],[45,7,45,9],[45,2,45,6],[46,7,46,9],[46,2,46,6],[47,7,47,9],[47,2,47,6],[34,2,34,6],[30,2,30,6],[44,2,44,11],[1,8,1,11],[5,2,5,6],[36,2,36,6],[19,8,19,13],[28,2,28,6],[29,2,29,6],[3,0,3,13],[36,0,41,0],[27,0,35,0],[27,1,35,1],[27,2,27,6],[36,1,41,1],[5,0,14,0],[5,1,14,1],[12,2,12,6],[13,2,13,6],[11,2,11,6],[14,2,14,6],[10,2,10,6],[9,2,9,6],[8,2,8,6],[7,2,7,6],[0,0,0,1],[0,2,0,6],[1,3,1,6],[2,0,2,1],[2,2,2,6],[56,7,56,10],[49,10,49,11],[55,2,55,5],[55,7,55,10],[51,2,51,5],[49,7,49,9],[49,2,49,6],[24,16,26,16],[27,16,35,16],[36,16,41,16],[62,1,62,5],[60,2,60,5],[56,2,56,5],[52,1,54,1],[57,2,57,5],[58,2,58,5],[59,2,59,5],[52,2,54,5],[42,7,42,11],[43,7,43,11],[42,2,42,6],[43,2,43,6],[61,1,61,5],[5,16,14,16],[15,16,18,16],[15,2,15,6],[16,2,16,6],[17,2,17,6],[6,2,6,6]]}
["CAP \" Conducteur Agent d'accueil en autobus et autocar \" ",null,{"$f":"Identification!B5","v":"EP2 – Conduite d’un véhicule en sécurité - Unité UP2"}]
[]
["COMPÉTENCES ÉVALUÉES",null,"                                      Critères d'évaluation                       ",null,null,null,null,"E","NM","MI ","MF","MS","TBM",null,null,"Poids de la compétence","Notes","Éval","Notes",null,null,null,null,null,null,null,null,null,null,"sous totaux permis","note sur 18"]
["SITUATION 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,10,"si bonus <2: non valide"]
["C3 CONDUIRE DE MANIÈRE PROFESSIONNELLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"SUM(Q6:Q19)","v":0},{"$f":"SUM(R6:R19)","v":0},{"$f":"SUM(S6:S19)","v":0},null,null,{"$f":"SUM(V6:V19)","v":0},{"$f":"IF(V5=14,1,0)","v":0},{"$f":"SUM(X6:X19)","v":0},{"$f":"W5","v":0},"Valeur Eliminatoire",null,null,null,{"$f":"AD4+1","v":16},10,"si bonus<1: non valide"]
["C3.1","Conduire un véhicule en toute sécurité","L’installation au poste de conduite est réalisée en conformité et la sécurité à bord est assurée.",null,null,null,null,null,{"$f":"T('S1'!D7)","v":""},null,{"$f":"T('S1'!F7)","v":""},{"$f":"T('S1'!G7)","v":""},null,{"$f":"IF($U6>1,\"◄\",(IF($U6<1,\"◄\",\"\")))","v":"◄"},null,0.5,{"$f":"SUM(S6:S15)","v":0},{"$f":"IF(COUNTBLANK(H6:M6)=6,0,IF(H6=\"\",P6,0))","v":0},{"$f":"(IF(J6<>\"\",0.25,0)+IF(K6<>\"\",1,0)+IF(L6<>\"\",2,0))+IF(M6<>\"\",3,0)","v":0},null,{"$f":"COUNTIF(H6:M6,\"x\")","v":0},{"$f":"COUNTBLANK(N6)","v":0},null,{"$f":"V6","v":0},null,null,null,null,null,{"$f":"AD5+1","v":17},10]
[null,null,"Les commandes sont connues et utilisées de manière rationnelle.",null,null,null,null,{"$f":"T('S1'!C8)","v":""},{"$f":"T('S1'!D8)","v":""},null,{"$f":"T('S1'!F8)","v":""},{"$f":"T('S1'!G8)","v":""},{"$f":"T('S1'!H8)","v":""},"◄",null,1,null,{"$f":"IF(COUNTBLANK(H7:M7)=6,0,IF(H7=\"\",P7,0))","v":0},{"$f":"(IF(J7<>\"\",0,0)+IF(K7<>\"\",1,0)+IF(L7<>\"\",2,0)+IF(M7<>\"\",3,0))","v":0},null,{"$f":"COUNTIF(H7:M7,\"x\")","v":0},{"$f":"COUNTBLANK(N7)","v":0},null,{"$f":"V7","v":0},null,{"$f":"COUNTA(H7)","v":1},null,null,null,18,{"$f":"(AD7-17)*(8/9)+10","v":10.888888888888889}]
[null,null,"L’information est prise.",null,null,null,null,{"$f":"T('S1'!C10)","v":""},{"$f":"T('S1'!D10)","v":""},null,{"$f":"T('S1'!F10)","v":""},{"$f":"T('S1'!G10)","v":""},{"$f":"T('S1'!H10)","v":""},"◄",null,1,null,0,{"$f":"(IF(J8<>\"\",0.5,0)+IF(K8<>\"\",1,0)+IF(L8<>\"\",2,0)+IF(M8<>\"\",3,0))","v":0},null,0,0,null,0,null,{"$f":"COUNTA(H8)","v":1},null,null,null,19,{"$f":"(AD8-17)*(8/9)+10","v":11.777777777777779}]
[null,null,"L’allure est adaptée aux circonstances",null,null,null,null,{"$f":"T('S1'!C11)","v":""},{"$f":"T('S1'!D11)","v":""},null,{"$f":"T('S1'!F11)","v":""},{"$f":"T('S1'!G11)","v":""},{"$f":"T('S1'!H11)","v":""},"◄",null,1,null,0,0,null,0,0,null,0,null,1,null,null,null,20,12.666666666666666]
[null,null,"La réglementation prévue par le code de la route est appliquée",null,null,null,null,{"$f":"T('S1'!C12)","v":""},{"$f":"T('S1'!D12)","v":""},null,{"$f":"T('S1'!F12)","v":""},{"$f":"T('S1'!G12)","v":""},{"$f":"T('S1'!H12)","v":""},"◄",null,1,null,0,0,null,0,0,null,0,null,1,null,null,null,21,13.555555555555555]
[null,null,"La communication avec les autres usagers est pertinente.",null,null,null,null,{"$f":"T('S1'!C14)","v":""},{"$f":"T('S1'!D14)","v":""},null,{"$f":"T('S1'!F14)","v":""},{"$f":"T('S1'!G14)","v":""},{"$f":"T('S1'!H14)","v":""},"◄",null,1,null,0,0,null,0,0,null,0,null,1,null,null,null,22,14.444444444444445]
[null,null,"La chaussée est partagée",null,null,null,null,{"$f":"T('S1'!C15)","v":""},{"$f":"T('S1'!D15)","v":""},null,{"$f":"T('S1'!F15)","v":""},{"$f":"T('S1'!G15)","v":""},{"$f":"T('S1'!H15)","v":""},"◄",null,1,null,0,0,null,0,0,null,0,null,1,null,null,null,23,15.333333333333332]
[null,null,"Les espaces de sécurité sont maintenus.",null,null,null,null,{"$f":"T('S1'!C16)","v":""},{"$f":"T('S1'!D16)","v":""},null,{"$f":"T('S1'!F16)","v":""},{"$f":"T('S1'!G16)","v":""},{"$f":"T('S1'!H16)","v":""},"◄",null,1,null,0,0,null,0,0,null,0,null,1,{"$f":"SUM(Z7:Z13)","v":7},null,null,24,16.222222222222221]
[null,null,"Le conducteur fait preuve de courtoisie à l’égard des autres usagers.",null,null,null,null,null,{"$f":"T('S1'!D24)","v":""},null,{"$f":"T('S1'!F24)","v":""},null,null,"◄",null,0.5,null,0,{"$f":"(IF(J14<>\"\",0.25,0)+IF(K14<>\"\",1,0)+IF(L14<>\"\",1,0))+IF(M14<>\"\",3,0)","v":0},null,0,0,null,0,null,null,null,null,null,25,17.111111111111111]
[null,null,"La conduite est assurée en autonomie et en sécurité",null,null,null,null,null,{"$f":"T('S1'!D18)","v":""},{"$f":"T('S1'!E18)","v":""},{"$f":"T('S1'!F18)","v":""},null,null,"◄",null,1,null,0,{"$f":"(IF(J15<>\"\",0.5,0)+IF(K15<>\"\",1,0)+IF(L15<>\"\",2,0))+IF(M15<>\"\",3,0)","v":0},null,0,0,null,0,null,{"$f":"SUM(S6:S15)","v":0},{"$f":"Z15+Z19","v":0},null,null,{"$f":"AD14+1","v":26},18]
["C3.2","Mettre en oeuvre les principes d’éco-conduite","La consommation du véhicule est maitrisée.",null,null,null,null,null,{"$f":"T('S1'!D23)","v":""},null,null,null,null,{"$f":"IF($U16>1,\"◄\",(IF($U16<1,\"◄\",\"\")))","v":"◄"},null,1.5,{"$f":"SUM(S16:S19)","v":0},{"$f":"IF(COUNTBLANK(H16:M16)=6,0,IF(H16=\"\",P16,0))","v":0},{"$f":"(IF(J16<>\"\",0.5,0)+IF(K16<>\"\",1,0)+IF(L16<>\"\",2,0))+IF(M16<>\"\",3,0)","v":0},null,{"$f":"COUNTIF(H16:M16,\"x\")","v":0},0,null,0,null,null,null,null,null,{"$f":"AD15+1","v":27},18.888888888888889]
[null,null,"Le conducteur fait preuve d’anticipation.",null,null,null,null,null,{"$f":"T('S1'!D19)","v":""},null,null,null,null,{"$f":"IF($U17>1,\"◄\",(IF($U17<1,\"◄\",\"\")))","v":"◄"},null,2,null,{"$f":"IF(COUNTBLANK(H17:M17)=6,0,IF(H17=\"\",P17,0))","v":0},{"$f":"(IF(J17<>\"\",0.5,0)+IF(K17<>\"\",1,0)+IF(L17<>\"\",2,0))+IF(M17<>\"\",3,0)","v":0},null,{"$f":"COUNTIF(H17:M17,\"x\")","v":0},0,null,0,null,null,null,null,null,{"$f":"AD16+1","v":28},19.777777777777779]
[null,null,"La conduite est adaptée au type de véhicule et au profil de la route.",null,null,null,null,null,{"$f":"T('S1'!D20)","v":""},null,null,null,null,"◄",null,1.5,null,{"$f":"IF(COUNTBLANK(H18:M18)=6,0,IF(H18=\"\",P18,0))","v":0},{"$f":"(IF(J18<>\"\",0.75,0)+IF(K18<>\"\",1,0)+IF(L18<>\"\",2,0))+IF(M18<>\"\",3,0)","v":0},null,{"$f":"COUNTIF(H18:M18,\"x\")","v":0},0,null,0,null,null,null,null,null,{"$f":"AD17+1","v":29},{"$f":"20","v":20}]
[null,null,"La conduite est souple et préserve le confort des clients.",null,null,null,null,null,{"$f":"T('S1'!D23)","v":""},null,null,null,null,"◄",null,1.5,null,{"$f":"IF(COUNTBLANK(H19:M19)=6,0,IF(H19=\"\",P19,0))","v":0},{"$f":"(IF(J19<>\"\",0.5,0)+IF(K19<>\"\",1,0)+IF(L19<>\"\",2,0))+IF(M19<>\"\",3,0)","v":0},null,{"$f":"COUNTIF(H19:M19,\"x\")","v":0},0,null,0,null,{"$f":"SUM(S16:S19)","v":0},{"$f":"(Q5/34)*20","v":0},null,null,{"$f":"AD18+1","v":30},{"$f":"20","v":20}]
["EXAMEN NON MENE A SON TERME",null,null,null,null,null,null,{"$f":"T('S1'!C26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"AA19","v":0},null,null,{"$f":"AD19+1","v":31},{"$f":"20","v":20}]
["PERMIS D Valide extérieur ",null,null,null,null,null,null,{"$f":"T('S1'!C30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,null,{"$f":"AD20+1","v":32},{"$f":"20","v":20}]
["SITUATION 2",null,null,null,null,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":"AD21+1","v":33},{"$f":"20","v":20}]
["COMPÉTENCES ÉVALUÉES",null,"                                      Critères d'évaluation                       ",null,null,null,null,null,"Non","MI","MF","MS","TBM"]
["C3 CONDUIRE DE MANIÈRE PROFESSIONNELLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"SUM(Q25:Q42)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R25:R42)","v":0},{"$f":"SUM(S25:S42)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(V25:V42)","v":0},{"$f":"IF(V24=18,1,0)","v":0},{"$f":"SUM(V25:V42)","v":0},{"$f":"W24","v":0}]
["C3.3","Identifier, interpréter les dysfonctionnements liés au véhicule","Le ou les voyants allumés, les symptômes sont interprétés",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($U25>1,\"◄\",(IF($U25<1,\"◄\",\"\")))","v":"◄"},null,1,{"$f":"SUM(S25:S27)","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNTBLANK(I25:M25)=5,0,IF(I25=\"\",P25,0))","v":0},{"$f":"(IF(K25<>\"\",1/3,0)+IF(L25<>\"\",2/3,0)+IF(M25<>\"\",1,0))*P$24*40*R25/SUM(R$25:R$42)","v":{"$error":"#DIV/0!"}},null,{"$f":"COUNTA(I25:M25)","v":0},{"$f":"COUNTBLANK(N25)","v":0},null,{"$f":"V25","v":0}]
[null,null,"Le système concerné est identifié et localisé, voire réinitialisé si nécessaire",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($U26>1,\"◄\",(IF($U26<1,\"◄\",\"\")))","v":"◄"},null,1,null,{"$f":"IF(COUNTBLANK(I26:M26)=5,0,IF(I26=\"\",P26,0))","v":0},{"$f":"(IF(K26<>\"\",1/3,0)+IF(L26<>\"\",2/3,0)+IF(M26<>\"\",1,0))*P$24*40*R26/SUM(R$25:R$42)","v":{"$error":"#DIV/0!"}},null,0,{"$f":"COUNTBLANK(N26)","v":0},null,{"$f":"V26","v":0}]
[null,null,"La décision de poursuivre ou non la mission est prise à l’issue d’une analyse des risques.",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,0,{"$error":"#DIV/0!"},null,0,0,null,0]
["C3.4","Gérer les situations d’incident, d’accident et de contrôle routier","Le véhicule est immobilisé en sécurité",null,null,null,null,null,null,null,null,null,null,"◄",null,1,{"$f":"SUM(S28:S36)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,0,0,null,0]
[null,null,"Le périmètre de sécurité est établi le cas échéant",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,0,{"$error":"#DIV/0!"},null,0,0,null,0]
[null,null,"Les incidents sont identifiés et signalés de manière professionnelle.",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,0,{"$error":"#DIV/0!"},null,0,0,null,0]
[null,null,"Les passagers sont évacués si nécessaire selon les techniques d’évacuation et mis en sécurité en toutes circonstances.",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,0,{"$error":"#DIV/0!"},null,0,0,null,0]
[null,null,"La signalisation de sécurité est mise en place.",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,0,{"$error":"#DIV/0!"},null,0,0,null,0]
[null,null,"Les services d’urgence sont contactés selon la procédure en vigueur.",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,0,{"$error":"#DIV/0!"},null,0,0,null,0]
[null,null,"Les équipements de secours appropriés sont mobilisés.",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,{"$f":"IF(COUNTBLANK(I34:M34)=5,0,IF(I34=\"\",P34,0))","v":0},{"$f":"(IF(K34<>\"\",1/3,0)+IF(L34<>\"\",2/3,0)+IF(M34<>\"\",1,0))*P$24*40*R34/SUM(R$25:R$42)","v":{"$error":"#DIV/0!"}},null,{"$f":"COUNTA(I34:M34)","v":0},0,null,0]
[null,null,"Le constat amiable est rédigé avec précision et exactitude.",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,{"$f":"IF(COUNTBLANK(I35:M35)=5,0,IF(I35=\"\",P35,0))","v":0},{"$f":"(IF(K35<>\"\",1/3,0)+IF(L35<>\"\",2/3,0)+IF(M35<>\"\",1,0))*P$24*40*R35/SUM(R$25:R$42)","v":{"$error":"#DIV/0!"}},null,{"$f":"COUNTA(I35:M35)","v":0},0,null,0]
[null,null,"Les contrôles routiers sont abordés avec professionnalisme.",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,{"$f":"IF(COUNTBLANK(I36:M36)=5,0,IF(I36=\"\",P36,0))","v":0},{"$f":"(IF(K36<>\"\",1/3,0)+IF(L36<>\"\",2/3,0)+IF(M36<>\"\",1,0))*P$24*40*R36/SUM(R$25:R$42)","v":{"$error":"#DIV/0!"}},null,{"$f":"COUNTA(I36:M36)","v":0},0,null,0]
["C3.5","Suivre un itinéraire","Les arrêts commerciaux sont abordés et quittés en sécurité.",null,null,null,null,null,null,null,null,null,null,"◄",null,1,{"$f":"SUM(S37:S42)","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNTBLANK(I37:M37)=5,0,IF(I37=\"\",P37,0))","v":0},{"$f":"(IF(K37<>\"\",1/3,0)+IF(L37<>\"\",2/3,0)+IF(M37<>\"\",1,0))*P$24*40*R37/SUM(R$25:R$42)","v":{"$error":"#DIV/0!"}},null,{"$f":"COUNTA(I37:M37)","v":0},0,null,0]
[null,null,"Les arrêts de précision garantissent l’accès des voyageurs en toute sécurité",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,0,{"$error":"#DIV/0!"},null,0,0,null,0]
[null,null,"L’itinéraire est respecté et adapté en fonction des contraintes de circulation.",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,0,{"$error":"#DIV/0!"},null,0,0,null,0]
[null,null,"Les horaires et les temps entre les arrêts sont respectés.",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,0,{"$error":"#DIV/0!"},null,0,0,null,0]
[null,null,"La conduite est adaptée lors du franchissement des tunnels et passages à niveaux, et lorsque le véhicule est à proximité de chantiers routiers.",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,0,{"$error":"#DIV/0!"},null,0,0,null,0]
[null,null,"La conduite est adaptée à la présence d’usagers vulnérables (piétons, cyclistes, etc.).",null,null,null,null,null,null,null,null,null,null,"◄",null,1,null,0,{"$error":"#DIV/0!"},null,0,0,null,0]
[null,null,"Taux d'indicateurs évalués pour C3 - Situation 1",null,null,null,null,{"$f":"IF(H21=\"x\",\"Permis Validé\",R5/SUM(P6:P19))","v":0}]
[null,null,"Taux d'indicateurs évalués pour C3 - Situation 2",null,null,null,null,{"$f":"R24/SUM(P25:P42)","v":0}]
[null,null,{"$f":"IF('S1'!K29=TRUE, \"LE CANDIDAT EST DÉJÀ TITULAIRE DE SON PERMIS CE VALIDE\",\"\")","v":""}]
[null,null,"Note situation 1 obtenue par calcul automatique",null,null,null,null,{"$f":"IF(H21=\"x\",\"Permis validé\",IF(OR(Y5=0,H43<1,AA19<10,U20=1,'S1'!C29:H29=\"INSUFFISANT\"),\"NV\",((S46))))","v":"NV"},null,null,"/20",null,null,null,null,null,null,null,{"$f":"IF((AA19<=20),AA20,(AA21))","v":0}]
[null,null,"Note situation 2 obtenue par calcul automatique",null,null,null,null,{"$f":"IF(OR(Y24=0,H44<0.5),\"!\",(Q24))","v":"!"},null,null,"/20"]
[null,null,"Note moyenne obtenue par calcul automatique",null,null,null,null,{"$f":"IF(H21=\"x\",H47,IF(OR(Y24<1,H44<0.5,H43<1),\"NV\",AVERAGE(H46:H47)))","v":"NV"},null,null,"/20"]
[null,null,"                                                                                                         Note sur 20 proposée au jury                                                                          \n  (la cellule est rouge si la note n'est pas validable)  ",null,null,null,null,12,null,null,"/20"]
[null,null,"Note X coefficient",null,null,null,null,{"$f":"IF(H48=\"NV\",\"NV\",(H49)*6)","v":"NV"},null,null,"/120"]
[]
[null,"Nom - Prénom du Candidat"]
[null,{"$f":"CONCATENATE(Identification!B9,\" \",Identification!B10)","v":" "}]
[]
[]
[null,"Nom et prénom des examinateurs                                                         attribuant la note","Emargements",null,null,null,null,"Date"]
[null,{"$f":"CONCATENATE(Identification!A19)","v":""},null,null,null,null,null,{"$f":"TODAY()","v":"2024-12-02"}]
[null,{"$f":"CONCATENATE(Identification!A20)","v":""}]
[null,{"$f":"CONCATENATE(Identification!A21)","v":""}]
[null,{"$f":"CONCATENATE(Identification!A22)","v":""}]
[null,{"$f":"CONCATENATE(Identification!A23)","v":""}]
[null,"Appréciation globale"]