{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["Mode opératoire","Section","Candidat 1","Candidat 2","Candidat 3","Candidat 4","Candidat 5","Candidat 6","Candidat 7","Candidat 8","Candidat 9","Candidat 10","Candidat 11","Candidat 12","Candidat 13","Candidat 14","Candidat 15","Candidat 16","Candidat 17","Candidat 18","Candidat 19","Candidat 20","Candidat 21","Candidat 22","Candidat 23","Candidat 24"],"not_rendered":{"charts":24,"images":6,"macros":1,"external_links":0,"defined_names":26,"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":"Mode opératoire","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Compléter dans l'ordre SVP"]
[]
[null,"DANS L'ONGLET \"Section\" (cet onglet permet le calcul et le report automatiques des moyennes et de la répartition des avis)"]
[1,"Saisir l'année de la session en C1:E1 (sera répercuté automatiquement dans les autres onglets)"]
[2,"Saisir le nom de l'établissement en L1 (idem)"]
[3,"Saisir l'effectif de la section en G19 (idem)"]
[]
[null,"DANS CHAQUE ONGLET INDIVIDUEL"]
[4,"Déplacer le logo correspondant à l'académie en J1:K3"]
[5,"Insérer le Cachet de l'Etablissement en L1:L3 (ou l'apposer manuellement après impression)"]
[6,"Noter le nom du candidat en B2 (sera répercuté automatiquement dans le nom de l'onglet, sauf si homonyme, auquel cas l'onglet pourra être renommé manuellement) NOTA : Le renommage automatique des onglets nécessite l'activation des macros à l'ouverture du fichier"]
[7,"Noter le Prénom du candidat en E2"]
[8,"Noter la Date de naissance du candidat en B3"]
[9,"Noter le N° INSEE du candidat en E3"]
[10,"Saisir les notes de 1ère année du candidat en D7:E17"]
[11,"Saisir les notes de 2ème année du candidat en G7:H17"]
[12,"Indiquer l'avis du conseil (\"X\" ou \"x\") en H22, H23 ou H24"]
[13,"Noter les observations du conseil de classe en L20:L24"]
[]
[null,"ONGLETS INUTILISÉS"]
[14,"S'assurer qu'aucune note ou avis n'a été saisi dans un onglet inutilisé"]
[15,"Ne pas supprimer les onglets inutilisés, un clic droit sur le nom de l'onglet permet de le masquer ou de réafficher ceux ayant été masqués"]
[]
[null,"IMPRESSION ET ÉMARGEMENT"]
[16,"Imprimer les fiches individuelles en recto-verso sur papier cartonné (120 g/m² minimum)"]
[17,"Faire émarger le candidat"]

{"sheet":"Section","index":1,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,11,2,11],[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[20,3,20,6],[4,9,4,10],[22,7,22,8],[20,7,20,8],[21,7,21,8],[0,0,0,1],[4,0,5,1],[4,6,4,8],[18,7,18,10],[19,7,19,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[11,9,11,10],[12,9,12,10],[13,9,13,10],[23,7,23,8],[19,11,23,11],[20,9,20,10],[4,11,5,11],[5,9,5,10],[16,9,16,10],[10,9,10,10],[9,9,9,10],[8,9,8,10],[7,9,7,10],[6,9,6,10],[14,9,14,10],[15,9,15,10]]}
["BTS FONDERIE",null,2021,null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,"Etablissement"]
[null,"Section",null,null,null,null,null,null,null,null,null,"(Cachet)"]
[]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\nclasse"]
["U1","Culture générale et expression",3,{"$f":"AVERAGE('Candidat 1'!D7,'Candidat 2'!D7,'Candidat 3'!D7,'Candidat 4'!D7,'Candidat 5'!D7,'Candidat 6'!D7,'Candidat 7'!D7,'Candidat 8'!D7,'Candidat 9'!D7,'Candidat 10'!D7,'Candidat 11'!D7,'Candidat 12'!D7,'Candidat 13'!D7,'Candidat 14'!D7,'Candidat 15'!D7,'Candidat 16'!D7,'Candidat 17'!D7,'Candidat 18'!D7,'Candidat 19'!D7,'Candidat 20'!D7,'Candidat 21'!D7,'Candidat 22'!D7,'Candidat 23'!D7,'Candidat 24'!D7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!E7,'Candidat 2'!E7,'Candidat 3'!E7,'Candidat 4'!E7,'Candidat 5'!E7,'Candidat 6'!E7,'Candidat 7'!E7,'Candidat 8'!E7,'Candidat 9'!E7,'Candidat 10'!E7,'Candidat 11'!E7,'Candidat 12'!E7,'Candidat 13'!E7,'Candidat 14'!E7,'Candidat 15'!E7,'Candidat 16'!E7,'Candidat 17'!E7,'Candidat 18'!E7,'Candidat 19'!E7,'Candidat 20'!E7,'Candidat 21'!E7,'Candidat 22'!E7,'Candidat 23'!E7,'Candidat 24'!E7)","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},{"$f":"AVERAGE('Candidat 1'!G7,'Candidat 2'!G7,'Candidat 3'!G7,'Candidat 4'!G7,'Candidat 5'!G7,'Candidat 6'!G7,'Candidat 7'!G7,'Candidat 8'!G7,'Candidat 9'!G7,'Candidat 10'!G7,'Candidat 11'!G7,'Candidat 12'!G7,'Candidat 13'!G7,'Candidat 14'!G7,'Candidat 15'!G7,'Candidat 16'!G7,'Candidat 17'!G7,'Candidat 18'!G7,'Candidat 19'!G7,'Candidat 20'!G7,'Candidat 21'!G7,'Candidat 22'!G7,'Candidat 23'!G7,'Candidat 24'!G7)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!H7,'Candidat 2'!H7,'Candidat 3'!H7,'Candidat 4'!H7,'Candidat 5'!H7,'Candidat 6'!H7,'Candidat 7'!H7,'Candidat 8'!H7,'Candidat 9'!H7,'Candidat 10'!H7,'Candidat 11'!H7,'Candidat 12'!H7,'Candidat 13'!H7,'Candidat 14'!H7,'Candidat 15'!H7,'Candidat 16'!H7,'Candidat 17'!H7,'Candidat 18'!H7,'Candidat 19'!H7,'Candidat 20'!H7,'Candidat 21'!H7,'Candidat 22'!H7,'Candidat 23'!H7,'Candidat 24'!H7)","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},null,null,{"$f":"IF(J7=\"/\",0,$C7*J7)","v":0}]
["U2","Langue vivante - Anglais",2,{"$f":"AVERAGE('Candidat 1'!D8,'Candidat 2'!D8,'Candidat 3'!D8,'Candidat 4'!D8,'Candidat 5'!D8,'Candidat 6'!D8,'Candidat 7'!D8,'Candidat 8'!D8,'Candidat 9'!D8,'Candidat 10'!D8,'Candidat 11'!D8,'Candidat 12'!D8,'Candidat 13'!D8,'Candidat 14'!D8,'Candidat 15'!D8,'Candidat 16'!D8,'Candidat 17'!D8,'Candidat 18'!D8,'Candidat 19'!D8,'Candidat 20'!D8,'Candidat 21'!D8,'Candidat 22'!D8,'Candidat 23'!D8,'Candidat 24'!D8)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!E8,'Candidat 2'!E8,'Candidat 3'!E8,'Candidat 4'!E8,'Candidat 5'!E8,'Candidat 6'!E8,'Candidat 7'!E8,'Candidat 8'!E8,'Candidat 9'!E8,'Candidat 10'!E8,'Candidat 11'!E8,'Candidat 12'!E8,'Candidat 13'!E8,'Candidat 14'!E8,'Candidat 15'!E8,'Candidat 16'!E8,'Candidat 17'!E8,'Candidat 18'!E8,'Candidat 19'!E8,'Candidat 20'!E8,'Candidat 21'!E8,'Candidat 22'!E8,'Candidat 23'!E8,'Candidat 24'!E8)","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},{"$f":"AVERAGE('Candidat 1'!G8,'Candidat 2'!G8,'Candidat 3'!G8,'Candidat 4'!G8,'Candidat 5'!G8,'Candidat 6'!G8,'Candidat 7'!G8,'Candidat 8'!G8,'Candidat 9'!G8,'Candidat 10'!G8,'Candidat 11'!G8,'Candidat 12'!G8,'Candidat 13'!G8,'Candidat 14'!G8,'Candidat 15'!G8,'Candidat 16'!G8,'Candidat 17'!G8,'Candidat 18'!G8,'Candidat 19'!G8,'Candidat 20'!G8,'Candidat 21'!G8,'Candidat 22'!G8,'Candidat 23'!G8,'Candidat 24'!G8)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!H8,'Candidat 2'!H8,'Candidat 3'!H8,'Candidat 4'!H8,'Candidat 5'!H8,'Candidat 6'!H8,'Candidat 7'!H8,'Candidat 8'!H8,'Candidat 9'!H8,'Candidat 10'!H8,'Candidat 11'!H8,'Candidat 12'!H8,'Candidat 13'!H8,'Candidat 14'!H8,'Candidat 15'!H8,'Candidat 16'!H8,'Candidat 17'!H8,'Candidat 18'!H8,'Candidat 19'!H8,'Candidat 20'!H8,'Candidat 21'!H8,'Candidat 22'!H8,'Candidat 23'!H8,'Candidat 24'!H8)","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},null,null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,{"$f":"AVERAGE('Candidat 1'!D9,'Candidat 2'!D9,'Candidat 3'!D9,'Candidat 4'!D9,'Candidat 5'!D9,'Candidat 6'!D9,'Candidat 7'!D9,'Candidat 8'!D9,'Candidat 9'!D9,'Candidat 10'!D9,'Candidat 11'!D9,'Candidat 12'!D9,'Candidat 13'!D9,'Candidat 14'!D9,'Candidat 15'!D9,'Candidat 16'!D9,'Candidat 17'!D9,'Candidat 18'!D9,'Candidat 19'!D9,'Candidat 20'!D9,'Candidat 21'!D9,'Candidat 22'!D9,'Candidat 23'!D9,'Candidat 24'!D9)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!E9,'Candidat 2'!E9,'Candidat 3'!E9,'Candidat 4'!E9,'Candidat 5'!E9,'Candidat 6'!E9,'Candidat 7'!E9,'Candidat 8'!E9,'Candidat 9'!E9,'Candidat 10'!E9,'Candidat 11'!E9,'Candidat 12'!E9,'Candidat 13'!E9,'Candidat 14'!E9,'Candidat 15'!E9,'Candidat 16'!E9,'Candidat 17'!E9,'Candidat 18'!E9,'Candidat 19'!E9,'Candidat 20'!E9,'Candidat 21'!E9,'Candidat 22'!E9,'Candidat 23'!E9,'Candidat 24'!E9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(D9:E9)<>0,AVERAGE(D9:E9),\"/\")","v":"/"},{"$f":"AVERAGE('Candidat 1'!G9,'Candidat 2'!G9,'Candidat 3'!G9,'Candidat 4'!G9,'Candidat 5'!G9,'Candidat 6'!G9,'Candidat 7'!G9,'Candidat 8'!G9,'Candidat 9'!G9,'Candidat 10'!G9,'Candidat 11'!G9,'Candidat 12'!G9,'Candidat 13'!G9,'Candidat 14'!G9,'Candidat 15'!G9,'Candidat 16'!G9,'Candidat 17'!G9,'Candidat 18'!G9,'Candidat 19'!G9,'Candidat 20'!G9,'Candidat 21'!G9,'Candidat 22'!G9,'Candidat 23'!G9,'Candidat 24'!G9)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!H9,'Candidat 2'!H9,'Candidat 3'!H9,'Candidat 4'!H9,'Candidat 5'!H9,'Candidat 6'!H9,'Candidat 7'!H9,'Candidat 8'!H9,'Candidat 9'!H9,'Candidat 10'!H9,'Candidat 11'!H9,'Candidat 12'!H9,'Candidat 13'!H9,'Candidat 14'!H9,'Candidat 15'!H9,'Candidat 16'!H9,'Candidat 17'!H9,'Candidat 18'!H9,'Candidat 19'!H9,'Candidat 20'!H9,'Candidat 21'!H9,'Candidat 22'!H9,'Candidat 23'!H9,'Candidat 24'!H9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},null,null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,{"$f":"AVERAGE('Candidat 1'!D10,'Candidat 2'!D10,'Candidat 3'!D10,'Candidat 4'!D10,'Candidat 5'!D10,'Candidat 6'!D10,'Candidat 7'!D10,'Candidat 8'!D10,'Candidat 9'!D10,'Candidat 10'!D10,'Candidat 11'!D10,'Candidat 12'!D10,'Candidat 13'!D10,'Candidat 14'!D10,'Candidat 15'!D10,'Candidat 16'!D10,'Candidat 17'!D10,'Candidat 18'!D10,'Candidat 19'!D10,'Candidat 20'!D10,'Candidat 21'!D10,'Candidat 22'!D10,'Candidat 23'!D10,'Candidat 24'!D10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!E10,'Candidat 2'!E10,'Candidat 3'!E10,'Candidat 4'!E10,'Candidat 5'!E10,'Candidat 6'!E10,'Candidat 7'!E10,'Candidat 8'!E10,'Candidat 9'!E10,'Candidat 10'!E10,'Candidat 11'!E10,'Candidat 12'!E10,'Candidat 13'!E10,'Candidat 14'!E10,'Candidat 15'!E10,'Candidat 16'!E10,'Candidat 17'!E10,'Candidat 18'!E10,'Candidat 19'!E10,'Candidat 20'!E10,'Candidat 21'!E10,'Candidat 22'!E10,'Candidat 23'!E10,'Candidat 24'!E10)","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(D10:E10)<>0,AVERAGE(D10:E10),\"/\")","v":"/"},{"$f":"AVERAGE('Candidat 1'!G10,'Candidat 2'!G10,'Candidat 3'!G10,'Candidat 4'!G10,'Candidat 5'!G10,'Candidat 6'!G10,'Candidat 7'!G10,'Candidat 8'!G10,'Candidat 9'!G10,'Candidat 10'!G10,'Candidat 11'!G10,'Candidat 12'!G10,'Candidat 13'!G10,'Candidat 14'!G10,'Candidat 15'!G10,'Candidat 16'!G10,'Candidat 17'!G10,'Candidat 18'!G10,'Candidat 19'!G10,'Candidat 20'!G10,'Candidat 21'!G10,'Candidat 22'!G10,'Candidat 23'!G10,'Candidat 24'!G10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!H10,'Candidat 2'!H10,'Candidat 3'!H10,'Candidat 4'!H10,'Candidat 5'!H10,'Candidat 6'!H10,'Candidat 7'!H10,'Candidat 8'!H10,'Candidat 9'!H10,'Candidat 10'!H10,'Candidat 11'!H10,'Candidat 12'!H10,'Candidat 13'!H10,'Candidat 14'!H10,'Candidat 15'!H10,'Candidat 16'!H10,'Candidat 17'!H10,'Candidat 18'!H10,'Candidat 19'!H10,'Candidat 20'!H10,'Candidat 21'!H10,'Candidat 22'!H10,'Candidat 23'!H10,'Candidat 24'!H10)","v":{"$error":"#DIV/0!"}},"/",{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},null,null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,{"$f":"AVERAGE('Candidat 1'!D11,'Candidat 2'!D11,'Candidat 3'!D11,'Candidat 4'!D11,'Candidat 5'!D11,'Candidat 6'!D11,'Candidat 7'!D11,'Candidat 8'!D11,'Candidat 9'!D11,'Candidat 10'!D11,'Candidat 11'!D11,'Candidat 12'!D11,'Candidat 13'!D11,'Candidat 14'!D11,'Candidat 15'!D11,'Candidat 16'!D11,'Candidat 17'!D11,'Candidat 18'!D11,'Candidat 19'!D11,'Candidat 20'!D11,'Candidat 21'!D11,'Candidat 22'!D11,'Candidat 23'!D11,'Candidat 24'!D11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!E11,'Candidat 2'!E11,'Candidat 3'!E11,'Candidat 4'!E11,'Candidat 5'!E11,'Candidat 6'!E11,'Candidat 7'!E11,'Candidat 8'!E11,'Candidat 9'!E11,'Candidat 10'!E11,'Candidat 11'!E11,'Candidat 12'!E11,'Candidat 13'!E11,'Candidat 14'!E11,'Candidat 15'!E11,'Candidat 16'!E11,'Candidat 17'!E11,'Candidat 18'!E11,'Candidat 19'!E11,'Candidat 20'!E11,'Candidat 21'!E11,'Candidat 22'!E11,'Candidat 23'!E11,'Candidat 24'!E11)","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(D11:E11)<>0,AVERAGE(D11:E11),\"/\")","v":"/"},{"$f":"AVERAGE('Candidat 1'!G11,'Candidat 2'!G11,'Candidat 3'!G11,'Candidat 4'!G11,'Candidat 5'!G11,'Candidat 6'!G11,'Candidat 7'!G11,'Candidat 8'!G11,'Candidat 9'!G11,'Candidat 10'!G11,'Candidat 11'!G11,'Candidat 12'!G11,'Candidat 13'!G11,'Candidat 14'!G11,'Candidat 15'!G11,'Candidat 16'!G11,'Candidat 17'!G11,'Candidat 18'!G11,'Candidat 19'!G11,'Candidat 20'!G11,'Candidat 21'!G11,'Candidat 22'!G11,'Candidat 23'!G11,'Candidat 24'!G11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!H11,'Candidat 2'!H11,'Candidat 3'!H11,'Candidat 4'!H11,'Candidat 5'!H11,'Candidat 6'!H11,'Candidat 7'!H11,'Candidat 8'!H11,'Candidat 9'!H11,'Candidat 10'!H11,'Candidat 11'!H11,'Candidat 12'!H11,'Candidat 13'!H11,'Candidat 14'!H11,'Candidat 15'!H11,'Candidat 16'!H11,'Candidat 17'!H11,'Candidat 18'!H11,'Candidat 19'!H11,'Candidat 20'!H11,'Candidat 21'!H11,'Candidat 22'!H11,'Candidat 23'!H11,'Candidat 24'!H11)","v":{"$error":"#DIV/0!"}},"/",{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},null,null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,{"$f":"AVERAGE('Candidat 1'!D12,'Candidat 2'!D12,'Candidat 3'!D12,'Candidat 4'!D12,'Candidat 5'!D12,'Candidat 6'!D12,'Candidat 7'!D12,'Candidat 8'!D12,'Candidat 9'!D12,'Candidat 10'!D12,'Candidat 11'!D12,'Candidat 12'!D12,'Candidat 13'!D12,'Candidat 14'!D12,'Candidat 15'!D12,'Candidat 16'!D12,'Candidat 17'!D12,'Candidat 18'!D12,'Candidat 19'!D12,'Candidat 20'!D12,'Candidat 21'!D12,'Candidat 22'!D12,'Candidat 23'!D12,'Candidat 24'!D12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!E12,'Candidat 2'!E12,'Candidat 3'!E12,'Candidat 4'!E12,'Candidat 5'!E12,'Candidat 6'!E12,'Candidat 7'!E12,'Candidat 8'!E12,'Candidat 9'!E12,'Candidat 10'!E12,'Candidat 11'!E12,'Candidat 12'!E12,'Candidat 13'!E12,'Candidat 14'!E12,'Candidat 15'!E12,'Candidat 16'!E12,'Candidat 17'!E12,'Candidat 18'!E12,'Candidat 19'!E12,'Candidat 20'!E12,'Candidat 21'!E12,'Candidat 22'!E12,'Candidat 23'!E12,'Candidat 24'!E12)","v":{"$error":"#DIV/0!"}},"/",{"$f":"AVERAGE('Candidat 1'!G12,'Candidat 2'!G12,'Candidat 3'!G12,'Candidat 4'!G12,'Candidat 5'!G12,'Candidat 6'!G12,'Candidat 7'!G12,'Candidat 8'!G12,'Candidat 9'!G12,'Candidat 10'!G12,'Candidat 11'!G12,'Candidat 12'!G12,'Candidat 13'!G12,'Candidat 14'!G12,'Candidat 15'!G12,'Candidat 16'!G12,'Candidat 17'!G12,'Candidat 18'!G12,'Candidat 19'!G12,'Candidat 20'!G12,'Candidat 21'!G12,'Candidat 22'!G12,'Candidat 23'!G12,'Candidat 24'!G12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!H12,'Candidat 2'!H12,'Candidat 3'!H12,'Candidat 4'!H12,'Candidat 5'!H12,'Candidat 6'!H12,'Candidat 7'!H12,'Candidat 8'!H12,'Candidat 9'!H12,'Candidat 10'!H12,'Candidat 11'!H12,'Candidat 12'!H12,'Candidat 13'!H12,'Candidat 14'!H12,'Candidat 15'!H12,'Candidat 16'!H12,'Candidat 17'!H12,'Candidat 18'!H12,'Candidat 19'!H12,'Candidat 20'!H12,'Candidat 21'!H12,'Candidat 22'!H12,'Candidat 23'!H12,'Candidat 24'!H12)","v":{"$error":"#DIV/0!"}},"/","/",null,null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,{"$f":"AVERAGE('Candidat 1'!D13,'Candidat 2'!D13,'Candidat 3'!D13,'Candidat 4'!D13,'Candidat 5'!D13,'Candidat 6'!D13,'Candidat 7'!D13,'Candidat 8'!D13,'Candidat 9'!D13,'Candidat 10'!D13,'Candidat 11'!D13,'Candidat 12'!D13,'Candidat 13'!D13,'Candidat 14'!D13,'Candidat 15'!D13,'Candidat 16'!D13,'Candidat 17'!D13,'Candidat 18'!D13,'Candidat 19'!D13,'Candidat 20'!D13,'Candidat 21'!D13,'Candidat 22'!D13,'Candidat 23'!D13,'Candidat 24'!D13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!E13,'Candidat 2'!E13,'Candidat 3'!E13,'Candidat 4'!E13,'Candidat 5'!E13,'Candidat 6'!E13,'Candidat 7'!E13,'Candidat 8'!E13,'Candidat 9'!E13,'Candidat 10'!E13,'Candidat 11'!E13,'Candidat 12'!E13,'Candidat 13'!E13,'Candidat 14'!E13,'Candidat 15'!E13,'Candidat 16'!E13,'Candidat 17'!E13,'Candidat 18'!E13,'Candidat 19'!E13,'Candidat 20'!E13,'Candidat 21'!E13,'Candidat 22'!E13,'Candidat 23'!E13,'Candidat 24'!E13)","v":{"$error":"#DIV/0!"}},"/",{"$f":"AVERAGE('Candidat 1'!G13,'Candidat 2'!G13,'Candidat 3'!G13,'Candidat 4'!G13,'Candidat 5'!G13,'Candidat 6'!G13,'Candidat 7'!G13,'Candidat 8'!G13,'Candidat 9'!G13,'Candidat 10'!G13,'Candidat 11'!G13,'Candidat 12'!G13,'Candidat 13'!G13,'Candidat 14'!G13,'Candidat 15'!G13,'Candidat 16'!G13,'Candidat 17'!G13,'Candidat 18'!G13,'Candidat 19'!G13,'Candidat 20'!G13,'Candidat 21'!G13,'Candidat 22'!G13,'Candidat 23'!G13,'Candidat 24'!G13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!H13,'Candidat 2'!H13,'Candidat 3'!H13,'Candidat 4'!H13,'Candidat 5'!H13,'Candidat 6'!H13,'Candidat 7'!H13,'Candidat 8'!H13,'Candidat 9'!H13,'Candidat 10'!H13,'Candidat 11'!H13,'Candidat 12'!H13,'Candidat 13'!H13,'Candidat 14'!H13,'Candidat 15'!H13,'Candidat 16'!H13,'Candidat 17'!H13,'Candidat 18'!H13,'Candidat 19'!H13,'Candidat 20'!H13,'Candidat 21'!H13,'Candidat 22'!H13,'Candidat 23'!H13,'Candidat 24'!H13)","v":{"$error":"#DIV/0!"}},"/","/",null,null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,{"$f":"AVERAGE('Candidat 1'!D14,'Candidat 2'!D14,'Candidat 3'!D14,'Candidat 4'!D14,'Candidat 5'!D14,'Candidat 6'!D14,'Candidat 7'!D14,'Candidat 8'!D14,'Candidat 9'!D14,'Candidat 10'!D14,'Candidat 11'!D14,'Candidat 12'!D14,'Candidat 13'!D14,'Candidat 14'!D14,'Candidat 15'!D14,'Candidat 16'!D14,'Candidat 17'!D14,'Candidat 18'!D14,'Candidat 19'!D14,'Candidat 20'!D14,'Candidat 21'!D14,'Candidat 22'!D14,'Candidat 23'!D14,'Candidat 24'!D14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!E14,'Candidat 2'!E14,'Candidat 3'!E14,'Candidat 4'!E14,'Candidat 5'!E14,'Candidat 6'!E14,'Candidat 7'!E14,'Candidat 8'!E14,'Candidat 9'!E14,'Candidat 10'!E14,'Candidat 11'!E14,'Candidat 12'!E14,'Candidat 13'!E14,'Candidat 14'!E14,'Candidat 15'!E14,'Candidat 16'!E14,'Candidat 17'!E14,'Candidat 18'!E14,'Candidat 19'!E14,'Candidat 20'!E14,'Candidat 21'!E14,'Candidat 22'!E14,'Candidat 23'!E14,'Candidat 24'!E14)","v":{"$error":"#DIV/0!"}},"/",{"$f":"AVERAGE('Candidat 1'!G14,'Candidat 2'!G14,'Candidat 3'!G14,'Candidat 4'!G14,'Candidat 5'!G14,'Candidat 6'!G14,'Candidat 7'!G14,'Candidat 8'!G14,'Candidat 9'!G14,'Candidat 10'!G14,'Candidat 11'!G14,'Candidat 12'!G14,'Candidat 13'!G14,'Candidat 14'!G14,'Candidat 15'!G14,'Candidat 16'!G14,'Candidat 17'!G14,'Candidat 18'!G14,'Candidat 19'!G14,'Candidat 20'!G14,'Candidat 21'!G14,'Candidat 22'!G14,'Candidat 23'!G14,'Candidat 24'!G14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!H14,'Candidat 2'!H14,'Candidat 3'!H14,'Candidat 4'!H14,'Candidat 5'!H14,'Candidat 6'!H14,'Candidat 7'!H14,'Candidat 8'!H14,'Candidat 9'!H14,'Candidat 10'!H14,'Candidat 11'!H14,'Candidat 12'!H14,'Candidat 13'!H14,'Candidat 14'!H14,'Candidat 15'!H14,'Candidat 16'!H14,'Candidat 17'!H14,'Candidat 18'!H14,'Candidat 19'!H14,'Candidat 20'!H14,'Candidat 21'!H14,'Candidat 22'!H14,'Candidat 23'!H14,'Candidat 24'!H14)","v":{"$error":"#DIV/0!"}},"/","/",null,null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,{"$f":"AVERAGE('Candidat 1'!D15,'Candidat 2'!D15,'Candidat 3'!D15,'Candidat 4'!D15,'Candidat 5'!D15,'Candidat 6'!D15,'Candidat 7'!D15,'Candidat 8'!D15,'Candidat 9'!D15,'Candidat 10'!D15,'Candidat 11'!D15,'Candidat 12'!D15,'Candidat 13'!D15,'Candidat 14'!D15,'Candidat 15'!D15,'Candidat 16'!D15,'Candidat 17'!D15,'Candidat 18'!D15,'Candidat 19'!D15,'Candidat 20'!D15,'Candidat 21'!D15,'Candidat 22'!D15,'Candidat 23'!D15,'Candidat 24'!D15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!E15,'Candidat 2'!E15,'Candidat 3'!E15,'Candidat 4'!E15,'Candidat 5'!E15,'Candidat 6'!E15,'Candidat 7'!E15,'Candidat 8'!E15,'Candidat 9'!E15,'Candidat 10'!E15,'Candidat 11'!E15,'Candidat 12'!E15,'Candidat 13'!E15,'Candidat 14'!E15,'Candidat 15'!E15,'Candidat 16'!E15,'Candidat 17'!E15,'Candidat 18'!E15,'Candidat 19'!E15,'Candidat 20'!E15,'Candidat 21'!E15,'Candidat 22'!E15,'Candidat 23'!E15,'Candidat 24'!E15)","v":{"$error":"#DIV/0!"}},"/",{"$f":"AVERAGE('Candidat 1'!G15,'Candidat 2'!G15,'Candidat 3'!G15,'Candidat 4'!G15,'Candidat 5'!G15,'Candidat 6'!G15,'Candidat 7'!G15,'Candidat 8'!G15,'Candidat 9'!G15,'Candidat 10'!G15,'Candidat 11'!G15,'Candidat 12'!G15,'Candidat 13'!G15,'Candidat 14'!G15,'Candidat 15'!G15,'Candidat 16'!G15,'Candidat 17'!G15,'Candidat 18'!G15,'Candidat 19'!G15,'Candidat 20'!G15,'Candidat 21'!G15,'Candidat 22'!G15,'Candidat 23'!G15,'Candidat 24'!G15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('Candidat 1'!H15,'Candidat 2'!H15,'Candidat 3'!H15,'Candidat 4'!H15,'Candidat 5'!H15,'Candidat 6'!H15,'Candidat 7'!H15,'Candidat 8'!H15,'Candidat 9'!H15,'Candidat 10'!H15,'Candidat 11'!H15,'Candidat 12'!H15,'Candidat 13'!H15,'Candidat 14'!H15,'Candidat 15'!H15,'Candidat 16'!H15,'Candidat 17'!H15,'Candidat 18'!H15,'Candidat 19'!H15,'Candidat 20'!H15,'Candidat 21'!H15,'Candidat 22'!H15,'Candidat 23'!H15,'Candidat 24'!H15)","v":{"$error":"#DIV/0!"}},"/","/",null,null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10"]
["UF2","Engagement étudiant (facultative)",">10",null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,14,"Classe",null,null,null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,{"$f":"SUM('Candidat 1'!H22:I22=\"X\",'Candidat 2'!H22:I22=\"X\",'Candidat 3'!H22:I22=\"X\",'Candidat 4'!H22:I22=\"X\",'Candidat 5'!H22:I22=\"X\",'Candidat 6'!H22:I22=\"X\",'Candidat 7'!H22:I22=\"X\",'Candidat 8'!H22:I22=\"X\",'Candidat 9'!H22:I22=\"X\",'Candidat 10'!H22:I22=\"X\",'Candidat 11'!H22:I22=\"X\",'Candidat 12'!H22:I22=\"X\",'Candidat 13'!H22:I22=\"X\",'Candidat 14'!H22:I22=\"X\",'Candidat 15'!H22:I22=\"X\",'Candidat 16'!H23:I23=\"X\",'Candidat 17'!H22:I22=\"X\",'Candidat 18'!H22:I22=\"X\",'Candidat 19'!H22:I22=\"X\",'Candidat 20'!H22:I22=\"X\",'Candidat 21'!H22:I22=\"X\",'Candidat 22'!H22:I22=\"X\",'Candidat 23'!H22:I22=\"X\",'Candidat 24'!H22:I22=\"X\")","v":0},null,{"$f":"H22/SUM($H$22:$I$24)*100","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,{"$f":"SUM('Candidat 1'!H23:I23=\"X\",'Candidat 2'!H23:I23=\"X\",'Candidat 3'!H23:I23=\"X\",'Candidat 4'!H23:I23=\"X\",'Candidat 5'!H23:I23=\"X\",'Candidat 6'!H23:I23=\"X\",'Candidat 7'!H23:I23=\"X\",'Candidat 8'!H23:I23=\"X\",'Candidat 9'!H23:I23=\"X\",'Candidat 10'!H23:I23=\"X\",'Candidat 11'!H23:I23=\"X\",'Candidat 12'!H23:I23=\"X\",'Candidat 13'!H23:I23=\"X\",'Candidat 14'!H23:I23=\"X\",'Candidat 15'!H23:I23=\"X\",'Candidat 16'!H24:I24=\"X\",'Candidat 17'!H23:I23=\"X\",'Candidat 18'!H23:I23=\"X\",'Candidat 19'!H23:I23=\"X\",'Candidat 20'!H23:I23=\"X\",'Candidat 21'!H23:I23=\"X\",'Candidat 22'!H23:I23=\"X\",'Candidat 23'!H23:I23=\"X\",'Candidat 24'!H23:I23=\"X\")","v":0},null,{"$f":"H23/SUM($H$22:$I$24)*100","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,{"$f":"SUM('Candidat 1'!H24:I24=\"X\",'Candidat 2'!H24:I24=\"X\",'Candidat 3'!H24:I24=\"X\",'Candidat 4'!H24:I24=\"X\",'Candidat 5'!H24:I24=\"X\",'Candidat 6'!H24:I24=\"X\",'Candidat 7'!H24:I24=\"X\",'Candidat 8'!H24:I24=\"X\",'Candidat 9'!H24:I24=\"X\",'Candidat 10'!H24:I24=\"X\",'Candidat 11'!H24:I24=\"X\",'Candidat 12'!H24:I24=\"X\",'Candidat 13'!H24:I24=\"X\",'Candidat 14'!H24:I24=\"X\",'Candidat 15'!H24:I24=\"X\",'Candidat 16'!H25:I25=\"X\",'Candidat 17'!H24:I24=\"X\",'Candidat 18'!H24:I24=\"X\",'Candidat 19'!H24:I24=\"X\",'Candidat 20'!H24:I24=\"X\",'Candidat 21'!H24:I24=\"X\",'Candidat 22'!H24:I24=\"X\",'Candidat 23'!H24:I24=\"X\",'Candidat 24'!H24:I24=\"X\")","v":0},null,{"$error":"#DIV/0!"},"%"]

{"sheet":"Candidat 1","index":2,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[20,3,20,8],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[1,11,2,11],[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$f":"IF(J17=\"Non évalué\",0,$C17*J17)","v":{"$error":"#VALUE!"}}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 2","index":3,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[20,3,20,8],[1,11,2,11],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 3","index":4,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[1,11,2,11],[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11],[20,3,20,8]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 4","index":5,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[20,3,20,8],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[1,11,2,11],[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 5","index":6,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[20,3,20,8],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[1,11,2,11],[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 6","index":7,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[20,3,20,8],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[1,11,2,11],[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 7","index":8,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[1,11,2,11],[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11],[20,3,20,8]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 8","index":9,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[20,3,20,8],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[1,11,2,11],[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 9","index":10,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[20,3,20,8],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[1,11,2,11],[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 10","index":11,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[20,3,20,8],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[1,11,2,11],[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 11","index":12,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[1,11,2,11],[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11],[20,3,20,8]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 12","index":13,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[1,11,2,11],[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11],[20,3,20,8]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 13","index":14,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[1,11,2,11],[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11],[20,3,20,8]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 14","index":15,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,1,24,4],[24,5,24,6],[4,2,5,2],[19,3,19,6],[18,0,18,2],[19,0,23,2],[18,3,18,5],[23,3,23,6],[22,3,22,6],[21,3,21,6],[0,0,0,1],[4,0,5,1],[4,6,4,8],[4,9,4,10],[0,2,0,4],[4,3,4,5],[1,2,1,3],[2,2,2,3],[0,9,2,10],[0,5,0,8],[1,4,1,8],[2,4,2,8],[9,18,9,19],[1,11,2,11],[23,7,23,8],[19,7,19,8],[22,7,22,8],[18,7,18,8],[21,7,21,8],[19,11,23,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,11,5,11],[20,3,20,8]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 15","index":16,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,9,18,10],[19,0,23,2],[19,11,23,11],[20,9,20,10],[21,3,21,6],[21,7,21,8],[22,3,22,6],[22,7,22,8],[23,3,23,6],[23,7,23,8],[19,3,19,6],[19,7,19,8],[19,9,19,10],[20,3,20,8],[4,0,5,1],[4,2,5,2],[4,3,4,5],[4,6,4,8],[24,1,24,4],[24,5,24,6],[18,0,18,2],[18,3,18,5],[18,7,18,8],[0,0,0,1],[0,2,0,4],[0,5,0,8],[0,9,2,10],[1,2,1,3],[1,4,1,8],[2,2,2,3],[2,4,2,8],[4,9,4,10],[4,18,5,18],[9,18,9,21],[1,11,2,11],[4,11,5,11]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 16","index":17,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[25,1,25,4],[25,5,25,6],[20,11,24,11],[21,9,21,10],[22,3,22,6],[22,7,22,8],[23,3,23,6],[23,7,23,8],[24,3,24,6],[24,7,24,8],[19,0,19,2],[19,3,19,5],[19,7,19,8],[19,9,19,10],[20,0,24,2],[20,3,20,6],[20,7,20,8],[20,9,20,10],[21,3,21,8],[1,11,2,11],[4,11,5,11],[0,0,0,1],[0,2,0,4],[0,5,0,8],[0,9,2,10],[1,2,1,3],[1,4,1,8],[2,2,2,3],[2,4,2,8],[4,0,5,1],[4,2,5,2],[4,3,4,5],[4,6,4,8],[4,9,4,10]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D18:E18)<>0,AVERAGE(D18:E18),\"\")","v":""},null,null,{"$f":"IF(COUNT(G18:H18)<>0,AVERAGE(G18:H18),\"\")","v":""},{"$f":"F18","v":""},null,null,{"$f":"IF(J18=\"Non évalué\",0,$C18*J18)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}},null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M8:M12)/SUMIFS(C8:C12,M8:M12,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H21","v":0}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J25","v":0},"%"]

{"sheet":"Candidat 17","index":18,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,1,24,4],[24,5,24,6],[19,11,23,11],[20,9,20,10],[21,3,21,6],[21,7,21,8],[22,3,22,6],[22,7,22,8],[23,3,23,6],[23,7,23,8],[18,0,18,2],[18,3,18,5],[18,7,18,8],[18,9,18,10],[19,0,23,2],[19,3,19,6],[19,7,19,8],[19,9,19,10],[20,3,20,8],[1,11,2,11],[4,11,5,11],[0,0,0,1],[0,2,0,4],[0,5,0,8],[0,9,2,10],[1,2,1,3],[1,4,1,8],[2,2,2,3],[2,4,2,8],[4,0,5,1],[4,2,5,2],[4,3,4,5],[4,6,4,8],[4,9,4,10]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 18","index":19,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,9,18,10],[19,0,23,2],[19,11,23,11],[20,9,20,10],[21,3,21,6],[21,7,21,8],[22,3,22,6],[22,7,22,8],[23,3,23,6],[23,7,23,8],[19,3,19,6],[19,7,19,8],[19,9,19,10],[20,3,20,8],[4,0,5,1],[4,2,5,2],[4,3,4,5],[4,6,4,8],[24,1,24,4],[24,5,24,6],[18,0,18,2],[18,3,18,5],[18,7,18,8],[0,0,0,1],[0,2,0,4],[0,5,0,8],[0,9,2,10],[1,2,1,3],[1,4,1,8],[2,2,2,3],[2,4,2,8],[4,9,4,10],[4,18,5,18],[9,18,9,21],[1,11,2,11],[4,11,5,11]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 19","index":20,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[9,18,9,20],[24,1,24,4],[24,5,24,6],[19,11,23,11],[20,9,20,10],[21,3,21,6],[21,7,21,8],[22,3,22,6],[22,7,22,8],[23,3,23,6],[23,7,23,8],[18,0,18,2],[18,3,18,5],[18,7,18,8],[18,9,18,10],[19,0,23,2],[19,3,19,6],[19,7,19,8],[19,9,19,10],[20,3,20,8],[1,11,2,11],[4,11,5,11],[0,0,0,1],[0,2,0,4],[0,5,0,8],[0,9,2,10],[1,2,1,3],[1,4,1,8],[2,2,2,3],[2,4,2,8],[4,0,5,1],[4,2,5,2],[4,3,4,5],[4,6,4,8],[4,9,4,10]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 20","index":21,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[9,18,9,19],[24,1,24,4],[24,5,24,6],[19,11,23,11],[20,9,20,10],[21,3,21,6],[21,7,21,8],[22,3,22,6],[22,7,22,8],[23,3,23,6],[23,7,23,8],[18,0,18,2],[18,3,18,5],[18,7,18,8],[18,9,18,10],[19,0,23,2],[19,3,19,6],[19,7,19,8],[19,9,19,10],[20,3,20,8],[1,11,2,11],[4,11,5,11],[0,0,0,1],[0,2,0,4],[0,5,0,8],[0,9,2,10],[1,2,1,3],[1,4,1,8],[2,2,2,3],[2,4,2,8],[4,0,5,1],[4,2,5,2],[4,3,4,5],[4,6,4,8],[4,9,4,10]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 21","index":22,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,9,18,10],[19,0,23,2],[19,11,23,11],[20,9,20,10],[21,3,21,6],[21,7,21,8],[22,3,22,6],[22,7,22,8],[23,3,23,6],[23,7,23,8],[19,3,19,6],[19,7,19,8],[19,9,19,10],[20,3,20,8],[4,0,5,1],[4,2,5,2],[4,3,4,5],[4,6,4,8],[24,1,24,4],[24,5,24,6],[18,0,18,2],[18,3,18,5],[18,7,18,8],[0,0,0,1],[0,2,0,4],[0,5,0,8],[0,9,2,10],[1,2,1,3],[1,4,1,8],[2,2,2,3],[2,4,2,8],[4,9,4,10],[4,18,5,18],[9,18,9,21],[1,11,2,11],[4,11,5,11]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 22","index":23,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,1,24,4],[24,5,24,6],[19,11,23,11],[20,9,20,10],[21,3,21,6],[21,7,21,8],[22,3,22,6],[22,7,22,8],[23,3,23,6],[23,7,23,8],[18,0,18,2],[18,3,18,5],[18,7,18,8],[18,9,18,10],[19,0,23,2],[19,3,19,6],[19,7,19,8],[19,9,19,10],[20,3,20,8],[1,11,2,11],[4,11,5,11],[0,0,0,1],[0,2,0,4],[0,5,0,8],[0,9,2,10],[1,2,1,3],[1,4,1,8],[2,2,2,3],[2,4,2,8],[4,0,5,1],[4,2,5,2],[4,3,4,5],[4,6,4,8],[4,9,4,10]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 23","index":24,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,1,24,4],[24,5,24,6],[19,11,23,11],[20,9,20,10],[21,3,21,6],[21,7,21,8],[22,3,22,6],[22,7,22,8],[23,3,23,6],[23,7,23,8],[18,0,18,2],[18,3,18,5],[18,7,18,8],[18,9,18,10],[19,0,23,2],[19,3,19,6],[19,7,19,8],[19,9,19,10],[20,3,20,8],[1,11,2,11],[4,11,5,11],[0,0,0,1],[0,2,0,4],[0,5,0,8],[0,9,2,10],[1,2,1,3],[1,4,1,8],[2,2,2,3],[2,4,2,8],[4,0,5,1],[4,2,5,2],[4,3,4,5],[4,6,4,8],[4,9,4,10]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]

{"sheet":"Candidat 24","index":25,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,9,18,10],[19,0,23,2],[19,11,23,11],[20,9,20,10],[21,3,21,6],[21,7,21,8],[22,3,22,6],[22,7,22,8],[23,3,23,6],[23,7,23,8],[19,3,19,6],[19,7,19,8],[19,9,19,10],[20,3,20,8],[4,0,5,1],[4,2,5,2],[4,3,4,5],[4,6,4,8],[24,1,24,4],[24,5,24,6],[18,0,18,2],[18,3,18,5],[18,7,18,8],[0,0,0,1],[0,2,0,4],[0,5,0,8],[0,9,2,10],[1,2,1,3],[1,4,1,8],[2,2,2,3],[2,4,2,8],[4,9,4,10],[4,18,5,18],[9,18,9,21],[1,11,2,11],[4,11,5,11]]}
["BTS FONDERIE",null,{"$f":"Section!C1","v":2021},null,null,"LIVRET SCOLAIRE",null,null,null,"Logo Académie",null,{"$f":"Section!L1","v":"Etablissement"}]
["Nom",null,"Prénom(s) :",null,null,null,null,null,null,null,null,"(Cachet)"]
["Date de \nnaissance",null,"N°INSEE :"]
[]
["UNITES",null,"Coef.","1ère année",null,null,"2ème année",null,null,"1ère et 2ème année",null,"APPRECIATIONS"]
[null,null,null,"1er sem.","2ème sem.","Moyenne Année","1er sem.","2ème sem.","Moyenne Année","Moyenne\ncandidat","Moyenne Classe"]
["U1","Culture générale et expression",3,null,null,{"$f":"IF(COUNT(D7:E7)<>0,AVERAGE(D7:E7),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G7:H7)<>0,AVERAGE(G7:H7),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F7),ISNUMBER(I7)),AVERAGE(F7,I7),\"/\")","v":"/"},{"$f":"Section!J7","v":"/"},null,{"$f":"IF(J7=\"Non évalué\",0,$C7*J7)","v":{"$error":"#VALUE!"}}]
["U2","Langue vivante - Anglais",2,null,null,{"$f":"IF(COUNT(D8:E8)<>0,AVERAGE(D8:E8),\"/\")","v":"/"},null,null,{"$f":"IF(COUNT(G8:H8)<>0,AVERAGE(G8:H8),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F8),ISNUMBER(I8)),AVERAGE(F8,I8),\"/\")","v":"/"},{"$f":"Section!J8","v":"/"},null,{"$f":"IF(J8=\"Non évalué\",0,$C8*J8)","v":{"$error":"#VALUE!"}}]
["U31","Mathématiques",2,null,null,"/",null,null,{"$f":"IF(COUNT(G9:H9)<>0,AVERAGE(G9:H9),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F9),ISNUMBER(I9)),AVERAGE(F9,I9),\"/\")","v":"/"},{"$f":"Section!J9","v":"/"},null,{"$error":"#VALUE!"}]
["U32","Physique - Chimie",2,null,null,"/",null,null,{"$f":"IF(COUNT(G10:H10)<>0,AVERAGE(G10:H10),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F10),ISNUMBER(I10)),AVERAGE(F10,I10),\"/\")","v":"/"},{"$f":"Section!J10","v":"/"},null,{"$error":"#VALUE!"}]
["U4","Conception préliminaire",4,null,null,"/",null,null,{"$f":"IF(COUNT(G11:H11)<>0,AVERAGE(G11:H11),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F11),ISNUMBER(I11)),AVERAGE(F11,I11),\"/\")","v":"/"},{"$f":"Section!J11","v":"/"},null,{"$error":"#VALUE!"}]
["U5","Projet industriel de conception et d’initialisation de processus",6,null,null,"/",null,null,{"$f":"IF(COUNT(G12:H12)<>0,AVERAGE(G12:H12),\"/\")","v":"/"},{"$f":"IF(OR(ISNUMBER(F12),ISNUMBER(I12)),AVERAGE(F12,I12),\"/\")","v":"/"},{"$f":"Section!J12","v":"/"},null,{"$error":"#VALUE!"}]
["U61","Projet collaboratif d’optimisation d’un produit et d’un processus",3,null,null,"/",null,null,"/","/",{"$f":"Section!J13","v":"/"},null,{"$error":"#VALUE!"}]
["U62","Étude de moulage",4,null,null,"/",null,null,"/","/",{"$f":"Section!J14","v":"/"},null,{"$error":"#VALUE!"}]
["U63","Gestion et suivi de réalisation en entreprise",3,null,null,"/",null,null,"/","/",{"$f":"Section!J15","v":"/"},null,{"$error":"#VALUE!"}]
["UF1","Langue vivante 2 (facultative)",">10",null,null,{"$f":"IF(COUNT(D16:E16)<>0,AVERAGE(D16:E16),\"\")","v":""},null,null,{"$f":"IF(COUNT(G16:H16)<>0,AVERAGE(G16:H16),\"\")","v":""},{"$f":"IF(COUNT(F16,I16)<>0,AVERAGE(F16,I16),\"\")","v":""}]
["UF2","Engagement étudiant (facultative)",">10",null,null,{"$f":"IF(COUNT(D17:E17)<>0,AVERAGE(D17:E17),\"\")","v":""},null,null,{"$f":"IF(COUNT(G17:H17)<>0,AVERAGE(G17:H17),\"\")","v":""},{"$f":"IF(COUNT(F17,I17)<>0,AVERAGE(F17,I17),\"\")","v":""},null,null,{"$error":"#VALUE!"}]
[]
["Date et signature du candidat.\nObservations éventuelles.",null,null,"Effectif de la classe",null,null,{"$f":"Section!G19","v":14},"Candidat",null,"Classe",null,"Observations éventuelles du conseil de classe"]
[null,null,null,"MOYENNE GENERALE",null,null,null,{"$f":"SUM(M7:M11)/SUMIFS(C7:C11,M7:M11,\"<>0\")","v":{"$error":"#VALUE!"}},null,{"$f":"Section!H20","v":{"$error":"#VALUE!"}}]
[null,null,null,"AVIS POUR L'EXAMEN",null,null,null,null,null,"Répartition (%)"]
[null,null,null,"TRES FAVORABLE",null,null,null,null,null,{"$f":"+Section!J22","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"FAVORABLE",null,null,null,null,null,{"$f":"+Section!J23","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,"DOIT FAIRE SES PREUVES",null,null,null,null,null,{"$f":"+Section!J24","v":{"$error":"#DIV/0!"}},"%"]