{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ACCUEIL","PERMISUIVI","REFERENTIELS","SECU","DEBUT","APPEL"],"not_rendered":{"charts":0,"images":21,"macros":0,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ACCUEIL","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,2,19,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ESCALADE - PERMIS SUIVI "]

{"sheet":"PERMISUIVI","index":1,"n_rows":91,"n_cols":167,"rows_kept":91,"cut":false,"hidden":false,"merged":[[69,16,71,16],[72,16,74,16],[75,16,77,16],[78,16,80,16],[81,16,83,16],[84,16,86,16],[87,16,89,16],[90,16,92,16],[75,149,77,149],[75,150,77,150],[78,149,80,149],[78,150,80,150],[81,149,83,149],[81,150,83,150],[84,149,86,149],[84,150,86,150],[87,149,89,149],[87,150,89,150],[90,149,92,149],[90,150,92,150],[81,136,83,136],[81,137,83,137],[81,138,83,138],[81,140,83,140],[81,141,83,141],[81,143,83,143],[81,144,83,144],[87,132,89,132],[90,120,92,120],[81,146,83,146],[69,136,71,136],[69,137,71,137],[54,16,56,16],[57,16,59,16],[57,136,59,136],[57,137,59,137],[57,138,59,138],[57,140,59,140],[57,141,59,141],[57,143,59,143],[57,144,59,144],[57,146,59,146],[57,147,59,147],[54,146,56,146],[0,3,0,9],[0,13,0,14],[60,16,62,16],[63,16,65,16],[66,16,68,16],[1,16,2,16],[6,16,8,16],[9,16,11,16],[12,16,14,16],[15,16,17,16],[18,16,20,16],[21,16,23,16],[24,16,26,16],[27,16,29,16],[30,16,32,16],[33,16,35,16],[36,16,38,16],[39,16,41,16],[42,16,44,16],[45,16,47,16],[0,149,2,149],[3,149,5,149],[3,150,5,150],[6,149,8,149],[6,150,8,150],[9,149,11,149],[9,150,11,150],[12,149,14,149],[12,150,14,150],[15,149,17,149],[15,150,17,150],[18,149,20,149],[18,150,20,150],[21,149,23,149],[21,150,23,150],[24,149,26,149],[0,118,1,119],[18,144,20,144],[18,146,20,146],[18,147,20,147],[9,144,11,144],[9,146,11,146],[9,147,11,147],[24,120,26,120],[24,122,26,124],[24,125,26,125],[24,127,26,129],[24,130,26,130],[24,132,26,132],[15,127,17,129],[15,130,17,130],[15,132,17,132],[3,16,5,16],[84,1,86,1],[87,1,89,1],[90,1,92,1],[87,136,89,136],[87,137,89,137],[87,138,89,138],[87,140,89,140],[87,141,89,141],[87,143,89,143],[87,144,89,144],[87,146,89,146],[87,147,89,147],[87,152,89,152],[90,136,92,136],[90,137,92,137],[90,138,92,138],[90,140,92,140],[90,141,92,141],[90,143,92,143],[90,144,92,144],[90,146,92,146],[90,147,92,147],[90,152,92,152],[87,120,89,120],[87,122,89,124],[87,125,89,125],[87,127,89,129],[87,130,89,130],[48,16,50,16],[51,144,53,144],[51,16,53,16],[81,152,83,152],[84,136,86,136],[84,137,86,137],[84,138,86,138],[84,140,86,140],[84,141,86,141],[84,143,86,143],[84,144,86,144],[84,146,86,146],[84,147,86,147],[84,152,86,152],[75,136,77,136],[75,137,77,137],[75,138,77,138],[75,140,77,140],[75,141,77,141],[75,143,77,143],[75,144,77,144],[75,146,77,146],[75,147,77,147],[75,152,77,152],[78,136,80,136],[78,137,80,137],[78,138,80,138],[78,140,80,140],[78,141,80,141],[78,143,80,143],[78,144,80,144],[78,146,80,146],[78,147,80,147],[81,147,83,147],[78,152,80,152],[69,138,71,138],[69,140,71,140],[69,141,71,141],[69,143,71,143],[69,144,71,144],[69,146,71,146],[69,147,71,147],[69,152,71,152],[72,136,74,136],[72,137,74,137],[72,138,74,138],[72,140,74,140],[72,141,74,141],[72,143,74,143],[72,144,74,144],[72,146,74,146],[72,147,74,147],[72,152,74,152],[69,149,71,149],[69,150,71,150],[72,149,74,149],[72,150,74,150],[63,136,65,136],[63,137,65,137],[63,138,65,138],[63,140,65,140],[63,141,65,141],[63,143,65,143],[63,144,65,144],[63,146,65,146],[63,147,65,147],[63,152,65,152],[66,136,68,136],[66,137,68,137],[66,138,68,138],[66,140,68,140],[66,141,68,141],[66,143,68,143],[66,144,68,144],[66,146,68,146],[66,147,68,147],[66,152,68,152],[63,149,65,149],[63,150,65,150],[66,149,68,149],[66,150,68,150],[57,152,59,152],[60,136,62,136],[60,137,62,137],[60,138,62,138],[60,140,62,140],[60,141,62,141],[60,143,62,143],[60,144,62,144],[60,146,62,146],[60,147,62,147],[60,152,62,152],[57,149,59,149],[57,150,59,150],[60,149,62,149],[60,150,62,150],[51,136,53,136],[51,137,53,137],[51,138,53,138],[51,140,53,140],[51,141,53,141],[51,143,53,143],[51,152,53,152],[54,136,56,136],[54,137,56,137],[54,138,56,138],[54,140,56,140],[54,141,56,141],[54,143,56,143],[54,144,56,144],[51,146,53,146],[51,147,53,147],[54,152,56,152],[51,149,53,149],[51,150,53,150],[54,149,56,149],[54,150,56,150],[45,136,47,136],[45,137,47,137],[45,138,47,138],[45,140,47,140],[45,141,47,141],[45,143,47,143],[45,144,47,144],[45,146,47,146],[45,147,47,147],[45,152,47,152],[48,136,50,136],[48,137,50,137],[48,138,50,138],[48,140,50,140],[48,141,50,141],[48,143,50,143],[48,144,50,144],[48,146,50,146],[48,147,50,147],[48,152,50,152],[45,149,47,149],[45,150,47,150],[48,149,50,149],[48,150,50,150],[54,147,56,147],[39,136,41,136],[39,137,41,137],[39,138,41,138],[39,140,41,140],[39,141,41,141],[39,143,41,143],[39,144,41,144],[39,146,41,146],[39,147,41,147],[39,152,41,152],[42,136,44,136],[42,137,44,137],[42,138,44,138],[42,140,44,140],[42,141,44,141],[42,143,44,143],[42,144,44,144],[42,146,44,146],[42,147,44,147],[42,152,44,152],[39,149,41,149],[39,150,41,150],[42,149,44,149],[42,150,44,150],[33,136,35,136],[33,137,35,137],[33,138,35,138],[33,140,35,140],[33,141,35,141],[33,143,35,143],[33,144,35,144],[33,146,35,146],[33,147,35,147],[33,152,35,152],[36,136,38,136],[36,137,38,137],[36,138,38,138],[36,140,38,140],[36,141,38,141],[36,143,38,143],[36,144,38,144],[36,146,38,146],[36,147,38,147],[36,152,38,152],[33,149,35,149],[33,150,35,150],[36,149,38,149],[36,150,38,150],[27,136,29,136],[27,137,29,137],[27,138,29,138],[27,140,29,140],[27,141,29,141],[27,143,29,143],[27,144,29,144],[27,146,29,146],[27,147,29,147],[27,152,29,152],[24,150,26,150],[30,136,32,136],[30,137,32,137],[30,138,32,138],[30,140,32,140],[30,141,32,141],[30,143,32,143],[30,144,32,144],[30,146,32,146],[30,147,32,147],[30,152,32,152],[27,149,29,149],[27,150,29,150],[30,149,32,149],[30,150,32,150],[18,152,20,152],[21,136,23,136],[21,137,23,137],[21,138,23,138],[21,140,23,140],[21,141,23,141],[21,143,23,143],[21,144,23,144],[21,146,23,146],[21,147,23,147],[21,152,23,152],[24,136,26,136],[24,137,26,137],[24,138,26,138],[24,140,26,140],[24,141,26,141],[24,143,26,143],[24,144,26,144],[24,146,26,146],[24,147,26,147],[24,152,26,152],[9,152,11,152],[12,136,14,136],[12,137,14,137],[12,138,14,138],[12,140,14,140],[12,141,14,141],[12,143,14,143],[12,144,14,144],[12,146,14,146],[12,147,14,147],[12,152,14,152],[15,136,17,136],[15,137,17,137],[15,138,17,138],[15,140,17,140],[15,141,17,141],[15,143,17,143],[15,144,17,144],[15,146,17,146],[15,147,17,147],[15,152,17,152],[90,127,92,129],[90,130,92,130],[90,132,92,132],[81,120,83,120],[81,122,83,124],[81,125,83,125],[81,127,83,129],[81,130,83,130],[81,132,83,132],[84,120,86,120],[84,122,86,124],[84,125,86,125],[84,127,86,129],[84,130,86,130],[84,132,86,132],[75,120,77,120],[75,122,77,124],[75,125,77,125],[75,127,77,129],[75,130,77,130],[75,132,77,132],[78,120,80,120],[78,122,80,124],[78,125,80,125],[78,127,80,129],[78,130,80,130],[78,132,80,132],[90,122,92,124],[90,125,92,125],[69,120,71,120],[69,122,71,124],[69,125,71,125],[69,127,71,129],[69,130,71,130],[69,132,71,132],[72,120,74,120],[72,122,74,124],[72,125,74,125],[72,127,74,129],[72,130,74,130],[72,132,74,132],[63,120,65,120],[63,122,65,124],[63,125,65,125],[63,127,65,129],[63,130,65,130],[63,132,65,132],[66,120,68,120],[66,122,68,124],[66,125,68,125],[66,127,68,129],[66,130,68,130],[66,132,68,132],[57,120,59,120],[57,122,59,124],[57,125,59,125],[57,127,59,129],[57,130,59,130],[57,132,59,132],[60,120,62,120],[60,122,62,124],[60,125,62,125],[60,127,62,129],[60,130,62,130],[60,132,62,132],[51,120,53,120],[51,122,53,124],[51,125,53,125],[51,127,53,129],[51,130,53,130],[51,132,53,132],[54,120,56,120],[54,122,56,124],[54,125,56,125],[54,127,56,129],[54,130,56,130],[54,132,56,132],[45,120,47,120],[45,122,47,124],[45,125,47,125],[45,127,47,129],[45,130,47,130],[45,132,47,132],[48,120,50,120],[48,122,50,124],[48,125,50,125],[48,127,50,129],[48,130,50,130],[48,132,50,132],[39,120,41,120],[39,122,41,124],[39,125,41,125],[39,127,41,129],[39,130,41,130],[39,132,41,132],[42,120,44,120],[42,122,44,124],[42,125,44,125],[42,127,44,129],[42,130,44,130],[42,132,44,132],[33,120,35,120],[33,122,35,124],[33,125,35,125],[33,127,35,129],[33,130,35,130],[33,132,35,132],[36,120,38,120],[36,122,38,124],[36,125,38,125],[36,127,38,129],[36,130,38,130],[36,132,38,132],[27,120,29,120],[27,122,29,124],[27,125,29,125],[27,127,29,129],[27,130,29,130],[27,132,29,132],[30,120,32,120],[30,122,32,124],[30,125,32,125],[30,127,32,129],[30,130,32,130],[30,132,32,132],[18,120,20,120],[18,122,20,124],[18,125,20,125],[18,127,20,129],[18,130,20,130],[18,132,20,132],[12,132,14,132],[3,141,5,141],[0,136,1,138],[0,140,2,140],[0,143,2,143],[3,143,5,143],[9,136,11,136],[9,137,11,137],[9,138,11,138],[9,140,11,140],[9,141,11,141],[9,143,11,143],[15,120,17,120],[15,122,17,124],[15,125,17,125],[21,120,23,120],[21,122,23,124],[21,125,23,125],[21,127,23,129],[21,130,23,130],[21,132,23,132],[18,136,20,136],[18,137,20,137],[18,138,20,138],[18,140,20,140],[18,141,20,141],[18,143,20,143],[0,146,2,146],[3,146,5,146],[3,147,5,147],[1,152,2,152],[3,152,5,152],[6,120,8,120],[6,122,8,124],[6,125,8,125],[6,127,8,129],[6,130,8,130],[6,132,8,132],[6,136,8,136],[6,137,8,137],[6,138,8,138],[6,140,8,140],[6,141,8,141],[6,143,8,143],[6,144,8,144],[6,146,8,146],[6,147,8,147],[6,152,8,152],[1,122,1,125],[3,125,5,125],[3,120,5,120],[3,136,5,136],[2,122,2,124],[3,122,5,124],[87,109,89,109],[87,111,89,111],[87,113,89,113],[87,115,89,115],[90,109,92,109],[90,111,92,111],[90,113,92,113],[90,115,92,115],[81,109,83,109],[81,111,83,111],[81,113,83,113],[81,115,83,115],[84,109,86,109],[84,111,86,111],[84,113,86,113],[84,115,86,115],[75,109,77,109],[75,111,77,111],[75,113,77,113],[75,115,77,115],[78,109,80,109],[78,111,80,111],[78,113,80,113],[78,115,80,115],[72,113,74,113],[72,115,74,115],[63,109,65,109],[63,111,65,111],[63,113,65,113],[63,115,65,115],[66,109,68,109],[66,111,68,111],[66,113,68,113],[66,115,68,115],[57,109,59,109],[57,111,59,111],[57,113,59,113],[57,115,59,115],[60,109,62,109],[60,111,62,111],[60,113,62,113],[60,115,62,115],[51,109,53,109],[51,111,53,111],[51,113,53,113],[51,115,53,115],[54,109,56,109],[54,111,56,111],[54,113,56,113],[54,115,56,115],[45,109,47,109],[45,111,47,111],[45,113,47,113],[45,115,47,115],[48,109,50,109],[48,111,50,111],[48,113,50,113],[48,115,50,115],[39,109,41,109],[39,111,41,111],[39,113,41,113],[39,115,41,115],[42,109,44,109],[42,111,44,111],[42,113,44,113],[42,115,44,115],[33,109,35,109],[33,111,35,111],[33,113,35,113],[33,115,35,115],[36,109,38,109],[36,111,38,111],[36,113,38,113],[36,115,38,115],[27,109,29,109],[27,111,29,111],[27,113,29,113],[27,115,29,115],[30,109,32,109],[30,111,32,111],[30,113,32,113],[30,115,32,115],[21,109,23,109],[21,111,23,111],[21,113,23,113],[21,115,23,115],[24,109,26,109],[24,111,26,111],[24,113,26,113],[24,115,26,115],[15,109,17,109],[15,111,17,111],[15,113,17,113],[15,115,17,115],[18,109,20,109],[18,111,20,111],[18,113,20,113],[18,115,20,115],[9,109,11,109],[9,111,11,111],[9,113,11,113],[9,115,11,115],[12,109,14,109],[12,111,14,111],[12,113,14,113],[12,115,14,115],[1,108,1,115],[3,109,5,109],[3,111,5,111],[3,113,5,113],[3,115,5,115],[6,109,8,109],[6,111,8,111],[6,113,8,113],[6,115,8,115],[87,99,89,99],[87,101,89,101],[87,103,89,103],[87,105,89,105],[90,99,92,99],[90,101,92,101],[90,103,92,103],[90,105,92,105],[81,99,83,99],[81,101,83,101],[81,103,83,103],[81,105,83,105],[84,99,86,99],[84,101,86,101],[84,103,86,103],[84,105,86,105],[75,99,77,99],[75,101,77,101],[75,103,77,103],[75,105,77,105],[78,99,80,99],[78,101,80,101],[78,103,80,103],[78,105,80,105],[69,99,71,99],[69,101,71,101],[69,103,71,103],[69,105,71,105],[72,99,74,99],[72,101,74,101],[72,103,74,103],[72,105,74,105],[63,99,65,99],[63,101,65,101],[63,103,65,103],[63,105,65,105],[66,99,68,99],[66,101,68,101],[66,103,68,103],[66,105,68,105],[57,99,59,99],[57,101,59,101],[57,103,59,103],[57,105,59,105],[60,99,62,99],[60,101,62,101],[60,103,62,103],[60,105,62,105],[51,99,53,99],[51,101,53,101],[51,103,53,103],[51,105,53,105],[54,99,56,99],[54,101,56,101],[54,103,56,103],[54,105,56,105],[45,99,47,99],[45,101,47,101],[45,103,47,103],[45,105,47,105],[48,99,50,99],[48,101,50,101],[48,103,50,103],[48,105,50,105],[39,99,41,99],[39,101,41,101],[39,103,41,103],[39,105,41,105],[42,99,44,99],[42,101,44,101],[42,103,44,103],[42,105,44,105],[33,99,35,99],[33,101,35,101],[33,103,35,103],[33,105,35,105],[36,99,38,99],[36,101,38,101],[36,103,38,103],[36,105,38,105],[27,99,29,99],[27,101,29,101],[27,103,29,103],[27,105,29,105],[30,99,32,99],[30,101,32,101],[30,103,32,103],[30,105,32,105],[21,99,23,99],[21,101,23,101],[21,103,23,103],[21,105,23,105],[24,99,26,99],[24,101,26,101],[24,103,26,103],[24,105,26,105],[15,99,17,99],[15,101,17,101],[15,103,17,103],[15,105,17,105],[18,99,20,99],[18,101,20,101],[18,103,20,103],[18,105,20,105],[9,99,11,99],[9,101,11,101],[9,103,11,103],[9,105,11,105],[12,99,14,99],[12,101,14,101],[12,103,14,103],[12,105,14,105],[1,98,1,105],[3,99,5,99],[3,101,5,101],[3,103,5,103],[3,105,5,105],[6,99,8,99],[6,101,8,101],[6,103,8,103],[6,105,8,105],[87,89,89,89],[87,91,89,91],[87,93,89,93],[87,95,89,95],[90,89,92,89],[90,91,92,91],[90,93,92,93],[90,95,92,95],[81,89,83,89],[81,91,83,91],[81,93,83,93],[81,95,83,95],[84,89,86,89],[84,91,86,91],[84,93,86,93],[84,95,86,95],[75,89,77,89],[75,91,77,91],[75,93,77,93],[75,95,77,95],[78,89,80,89],[78,91,80,91],[78,93,80,93],[78,95,80,95],[69,89,71,89],[69,91,71,91],[69,93,71,93],[69,95,71,95],[72,89,74,89],[72,91,74,91],[72,93,74,93],[72,95,74,95],[63,89,65,89],[63,91,65,91],[63,93,65,93],[63,95,65,95],[66,89,68,89],[66,91,68,91],[66,93,68,93],[66,95,68,95],[57,89,59,89],[57,91,59,91],[57,93,59,93],[57,95,59,95],[60,89,62,89],[60,91,62,91],[60,93,62,93],[60,95,62,95],[51,89,53,89],[51,91,53,91],[51,93,53,93],[51,95,53,95],[54,89,56,89],[54,91,56,91],[54,93,56,93],[54,95,56,95],[45,89,47,89],[45,91,47,91],[45,93,47,93],[45,95,47,95],[48,89,50,89],[48,91,50,91],[48,93,50,93],[48,95,50,95],[39,89,41,89],[39,91,41,91],[39,93,41,93],[39,95,41,95],[42,89,44,89],[42,91,44,91],[42,93,44,93],[42,95,44,95],[33,89,35,89],[33,91,35,91],[33,93,35,93],[33,95,35,95],[36,89,38,89],[36,91,38,91],[36,93,38,93],[36,95,38,95],[27,89,29,89],[27,91,29,91],[27,93,29,93],[27,95,29,95],[30,89,32,89],[30,91,32,91],[30,93,32,93],[30,95,32,95],[21,89,23,89],[21,91,23,91],[21,93,23,93],[21,95,23,95],[24,89,26,89],[24,91,26,91],[24,93,26,93],[24,95,26,95],[9,89,11,89],[9,91,11,91],[9,93,11,93],[9,95,11,95],[12,89,14,89],[12,91,14,91],[12,93,14,93],[12,95,14,95],[1,88,1,95],[3,89,5,89],[3,91,5,91],[3,93,5,93],[3,95,5,95],[6,89,8,89],[6,91,8,91],[6,93,8,93],[6,95,8,95],[87,79,89,79],[87,81,89,81],[87,83,89,83],[87,85,89,85],[90,79,92,79],[90,81,92,81],[90,83,92,83],[90,85,92,85],[81,79,83,79],[81,81,83,81],[81,83,83,83],[81,85,83,85],[84,79,86,79],[84,81,86,81],[84,83,86,83],[84,85,86,85],[75,79,77,79],[75,81,77,81],[75,83,77,83],[75,85,77,85],[78,79,80,79],[78,81,80,81],[78,83,80,83],[78,85,80,85],[69,79,71,79],[69,81,71,81],[69,83,71,83],[69,85,71,85],[72,79,74,79],[72,81,74,81],[72,83,74,83],[72,85,74,85],[63,79,65,79],[63,81,65,81],[63,83,65,83],[63,85,65,85],[66,79,68,79],[66,81,68,81],[66,83,68,83],[66,85,68,85],[57,79,59,79],[57,81,59,81],[57,83,59,83],[57,85,59,85],[60,79,62,79],[60,81,62,81],[60,83,62,83],[60,85,62,85],[51,79,53,79],[51,81,53,81],[51,83,53,83],[51,85,53,85],[54,79,56,79],[54,81,56,81],[54,83,56,83],[54,85,56,85],[45,79,47,79],[45,81,47,81],[45,83,47,83],[45,85,47,85],[48,79,50,79],[48,81,50,81],[48,83,50,83],[48,85,50,85],[39,79,41,79],[39,81,41,81],[39,83,41,83],[39,85,41,85],[42,79,44,79],[42,81,44,81],[42,83,44,83],[42,85,44,85],[33,79,35,79],[33,81,35,81],[33,83,35,83],[33,85,35,85],[36,79,38,79],[36,81,38,81],[36,83,38,83],[36,85,38,85],[27,79,29,79],[27,81,29,81],[27,83,29,83],[27,85,29,85]],"merged_total":3103,"flags":["merged_cut"]}
[null,null,null,"VALIDER VOTRE PERMIS EN 1er",null,null,null,null,null,null,null,null,null,"CONSULTER LE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EVALUATION / REFERENTIEL",null,"Niveau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"REFERENTIELS!C31","v":"Nombre de séances réalisées"},null,null,null,{"$f":"REFERENTIELS!C33","v":"Points restants sur le permis"},null,null,{"$f":"REFERENTIELS!C35","v":"Nombre de voies moyen réalisés par séance"},null,null,{"$f":"REFERENTIELS!C37","v":"Hauteur grimpée"},null,null,"Nombre de voies assurées"]
[null,"STAGE",null,"PERMIS DE GRIMPER",null,null,"PERMIS D'ASSURER",null,null,null,null,"POINTS du PERMIS",null,"    BILAN DU CYCLE",null,null,"Nombre de voies assurées",null,"SEANCE 1-VOIES REALISEES",null,null,null,null,null,null,null,null,null,"SEANCE 2-VOIES REALISEES",null,null,null,null,null,null,null,null,null,"SEANCE 3-VOIES REALISEES",null,null,null,null,null,null,null,null,null,"SEANCE 4-VOIES REALISEES",null,null,null,null,null,null,null,null,null,"SEANCE 5-VOIES REALISEES",null,null,null,null,null,null,null,null,null,"SEANCE 6-VOIES REALISEES",null,null,null,null,null,null,null,null,null,"SEANCE 7-VOIES REALISEES",null,null,null,null,null,null,null,null,null,"SEANCE 8-VOIES REALISEES",null,null,null,null,null,null,null,null,null,"SEANCE 9-VOIES REALISEES",null,null,null,null,null,null,null,null,null,"SEANCE 10-VOIES REALISEES",null,null,null,null,null,null,null,null,null,null,null,"N4",null,"Coordination de l’action Grimper/ s’assurer.",null,null,null,null,"Coordinations des actions assureur/grimpeur.",null,null,null,null,"NOTE /20",null,null,"EVALUATION / CYCLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE /20",null,null,"BILAN DES VOIES REALISEES","Toutes","3c","4a","4b","4c","5a","5b","5c","6a","6b","6c"]
[null,null,"sexe","Tenue-S'équiper","Nœud 8","Communique","S'équiper","Concentré","4 temps","Rappel",null,null,null,"Nombre voies réalisées","Hauteur grimpée (m)","Voie préférée",null,null,"Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","VOIES ASSUREES",null,"Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","VOIES ASSUREES",null,"Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","VOIES ASSUREES",null,"Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","VOIES ASSUREES",null,"Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","VOIES ASSUREES",null,"Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","VOIES ASSUREES",null,"Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","VOIES ASSUREES",null,"Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","VOIES ASSUREES",null,"Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","VOIES ASSUREES",null,"Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","Voie-Cotation-Couleur","Hauteur validée","VOIES ASSUREES",null,null,"Voie validée",{"$f":"IF(DQ2=\"N3\",\"pts /12\",\"pts /14\")","v":"pts /14"},null,"Critères",null,null,{"$f":"IF(DQ2=\"N3\",\"pts /4\",\"pts /3\")","v":"pts /3"},null,"Critères",null,null,{"$f":"IF(DQ2=\"N3\",\"pts /4\",\"pts /3\")","v":"pts /3"},null,null,null,null,null,2,"%",{"$f":"CONCATENATE(\"/ \",REFERENTIELS!B31)","v":"/ 2pts"},null,null,{"$f":"CONCATENATE(\"/ \",REFERENTIELS!B33)","v":"/ 6 pts"},null,null,{"$f":"CONCATENATE(\"/ \",REFERENTIELS!B35)","v":"/ 4 pts"},null,null,{"$f":"CONCATENATE(\"/ \",REFERENTIELS!B37)","v":"/ 4 pts"},null,null,{"$f":"CONCATENATE(\"/ \",REFERENTIELS!B39)","v":"/ 4 pts"}]
[1,{"$f":"OFFSET(INDEX(eleves,MATCH(A4,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Alexandre"},{"$f":"OFFSET(INDEX(eleves,MATCH(A4,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},"oui",null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D4:J6,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T4,V4,X4,Z4,AD4,AF4,AH4,AJ4,AN4,AP4,AR4,AT4,AX4,AZ4,BB4,BD4,BH4,BJ4,BL4,BN4,BR4,BT4,BV4,BX4,CB4,CD4,CF4,CL4,CN4,CP4,CR4,CX4,CZ4,DB4,DF4,DH4,DJ4,DL4)","v":0},{"$f":"T4+V4+X4+Z4+AD4+AF4+AH4+AJ4+AN4+AP4+AR4+AT4+AX4+AZ4+BB4+BD4+BH4+BJ4+BL4+BN4+BR4+BT4+BV4+BX4+CB4+CD4+CF4+CH4+CL4+CN4+CP4+CR4+CX4+CZ4+DB4+CV4+DF4+DH4+DJ4+DL4","v":0},null,{"$f":"AA4+AK4+AU4+BE4+BO4+BY4+CI4+CS4+DC4+DM4","v":0},null,1,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S4),ISNUMBER(AA4)),1,0)","v":1},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC4),ISNUMBER(AK4)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM4),ISNUMBER(AU4)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW4),ISNUMBER(BE4)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG4),ISNUMBER(BO4)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ4),ISNUMBER(BY4)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA4),ISNUMBER(CI4)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK4),ISNUMBER(CS4)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU4),ISNUMBER(DC4)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE4),ISNUMBER(DM4)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C4=\"g\",HLOOKUP(DP5,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP5,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C4=\"g\",HLOOKUP(DP5,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP5,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ4+DV4+EA4","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN4+DD4+CT4+CJ4+BZ4+BP4+BF4+AV4+AL4+AB4","v":1},{"$f":"EG4/$EG$3","v":0.5},{"$f":"HLOOKUP(EH4,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0.5},null,{"$f":"L4","v":0},{"$f":"HLOOKUP(EK4,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N4/EG4","v":0},{"$f":"HLOOKUP(EN4,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":0},null,{"$f":"O4","v":0},{"$f":"HLOOKUP(ES4,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ4-REFERENTIELS!$E$37:$M$37)),ABS(EQ4-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q4","v":0},{"$f":"HLOOKUP(ET4,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI4+EL4+EO4+ER4+EU4","v":0.5},null,null,{"$f":"N4","v":0},{"$f":"COUNTIF(S4:DM6,$FA$2)","v":0},{"$f":"COUNTIF(S4:DM6,$FB$2)","v":0},{"$f":"COUNTIF(S4:DM6,$FC$2)","v":1},{"$f":"COUNTIF(S4:DM6,$FD$2)","v":0},{"$f":"COUNTIF(S4:DM6,$FE$2)","v":0},{"$f":"COUNTIF(S4:DM6,$FF$2)","v":0},{"$f":"COUNTIF(S4:DM6,$FG$2)","v":0},{"$f":"COUNTIF(S4:DM6,$FH$2)","v":0},{"$f":"COUNTIF(S4:DM6,$FI$2)","v":0},{"$f":"COUNTIF(S4:DM6,$FJ$2)","v":0},{"$f":"COUNTIF(S4:DM6,$FK$2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaune"]
[2,{"$f":"OFFSET(INDEX(eleves,MATCH(A7,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Alexis F."},{"$f":"OFFSET(INDEX(eleves,MATCH(A7,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D7:J9,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T7,V7,X7,Z7,AD7,AF7,AH7,AJ7,AN7,AP7,AR7,AT7,AX7,AZ7,BB7,BD7,BH7,BJ7,BL7,BN7,BR7,BT7,BV7,BX7,CB7,CD7,CF7,CL7,CN7,CP7,CR7,CX7,CZ7,DB7,DF7,DH7,DJ7,DL7)","v":0},{"$f":"T7+V7+X7+Z7+AD7+AF7+AH7+AJ7+AN7+AP7+AR7+AT7+AX7+AZ7+BB7+BD7+BH7+BJ7+BL7+BN7+BR7+BT7+BV7+BX7+CB7+CD7+CF7+CH7+CL7+CN7+CP7+CR7+CX7+CZ7+DB7+CV7+DF7+DH7+DJ7+DL7","v":0},null,{"$f":"AA7+AK7+AU7+BE7+BO7+BY7+CI7+CS7+DC7+DM7","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S7),ISNUMBER(AA7)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC7),ISNUMBER(AK7)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM7),ISNUMBER(AU7)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW7),ISNUMBER(BE7)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG7),ISNUMBER(BO7)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ7),ISNUMBER(BY7)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA7),ISNUMBER(CI7)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK7),ISNUMBER(CS7)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU7),ISNUMBER(DC7)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE7),ISNUMBER(DM7)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C7=\"g\",HLOOKUP(DP8,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP8,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C7=\"g\",HLOOKUP(DP8,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP8,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ7+DV7+EA7","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN7+DD7+CT7+CJ7+BZ7+BP7+BF7+AV7+AL7+AB7","v":0},{"$f":"EG7/$EG$3","v":0},{"$f":"HLOOKUP(EH7,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L7","v":0},{"$f":"HLOOKUP(EK7,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N7/EG7","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN7,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O7","v":0},{"$f":"HLOOKUP(ES7,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ7-REFERENTIELS!$E$37:$M$37)),ABS(EQ7-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q7","v":0},{"$f":"HLOOKUP(ET7,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI7+EL7+EO7+ER7+EU7","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N7","v":0},{"$f":"COUNTIF(S7:DM9,$FA$2)","v":0},{"$f":"COUNTIF(S7:DM9,$FB$2)","v":0},{"$f":"COUNTIF(S7:DM9,$FC$2)","v":0},{"$f":"COUNTIF(S7:DM9,$FD$2)","v":0},{"$f":"COUNTIF(S7:DM9,$FE$2)","v":0},{"$f":"COUNTIF(S7:DM9,$FF$2)","v":0},{"$f":"COUNTIF(S7:DM9,$FG$2)","v":0},{"$f":"COUNTIF(S7:DM9,$FH$2)","v":0},{"$f":"COUNTIF(S7:DM9,$FI$2)","v":0},{"$f":"COUNTIF(S7:DM9,$FJ$2)","v":0},{"$f":"COUNTIF(S7:DM9,$FK$2)","v":0}]
[]
[]
[3,{"$f":"OFFSET(INDEX(eleves,MATCH(A10,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Anthony"},{"$f":"OFFSET(INDEX(eleves,MATCH(A10,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D10:J12,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T10,V10,X10,Z10,AD10,AF10,AH10,AJ10,AN10,AP10,AR10,AT10,AX10,AZ10,BB10,BD10,BH10,BJ10,BL10,BN10,BR10,BT10,BV10,BX10,CB10,CD10,CF10,CL10,CN10,CP10,CR10,CX10,CZ10,DB10,DF10,DH10,DJ10,DL10)","v":0},{"$f":"T10+V10+X10+Z10+AD10+AF10+AH10+AJ10+AN10+AP10+AR10+AT10+AX10+AZ10+BB10+BD10+BH10+BJ10+BL10+BN10+BR10+BT10+BV10+BX10+CB10+CD10+CF10+CH10+CL10+CN10+CP10+CR10+CX10+CZ10+DB10+CV10+DF10+DH10+DJ10+DL10","v":0},null,{"$f":"AA10+AK10+AU10+BE10+BO10+BY10+CI10+CS10+DC10+DM10","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S10),ISNUMBER(AA10)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC10),ISNUMBER(AK10)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM10),ISNUMBER(AU10)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW10),ISNUMBER(BE10)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG10),ISNUMBER(BO10)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ10),ISNUMBER(BY10)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA10),ISNUMBER(CI10)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK10),ISNUMBER(CS10)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU10),ISNUMBER(DC10)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE10),ISNUMBER(DM10)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C10=\"g\",HLOOKUP(DP11,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP11,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C10=\"g\",HLOOKUP(DP11,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP11,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ10+DV10+EA10","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN10+DD10+CT10+CJ10+BZ10+BP10+BF10+AV10+AL10+AB10","v":0},{"$f":"EG10/$EG$3","v":0},{"$f":"HLOOKUP(EH10,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L10","v":0},{"$f":"HLOOKUP(EK10,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N10/EG10","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN10,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O10","v":0},{"$f":"HLOOKUP(ES10,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ10-REFERENTIELS!$E$37:$M$37)),ABS(EQ10-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q10","v":0},{"$f":"HLOOKUP(ET10,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI10+EL10+EO10+ER10+EU10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N10","v":0},{"$f":"COUNTIF(S10:DM12,$FA$2)","v":0},{"$f":"COUNTIF(S10:DM12,$FB$2)","v":0},{"$f":"COUNTIF(S10:DM12,$FC$2)","v":0},{"$f":"COUNTIF(S10:DM12,$FD$2)","v":0},{"$f":"COUNTIF(S10:DM12,$FE$2)","v":0},{"$f":"COUNTIF(S10:DM12,$FF$2)","v":0},{"$f":"COUNTIF(S10:DM12,$FG$2)","v":0},{"$f":"COUNTIF(S10:DM12,$FH$2)","v":0},{"$f":"COUNTIF(S10:DM12,$FI$2)","v":0},{"$f":"COUNTIF(S10:DM12,$FJ$2)","v":0},{"$f":"COUNTIF(S10:DM12,$FK$2)","v":0}]
[]
[]
[4,{"$f":"OFFSET(INDEX(eleves,MATCH(A13,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Christian"},{"$f":"OFFSET(INDEX(eleves,MATCH(A13,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D13:J15,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T13,V13,X13,Z13,AD13,AF13,AH13,AJ13,AN13,AP13,AR13,AT13,AX13,AZ13,BB13,BD13,BH13,BJ13,BL13,BN13,BR13,BT13,BV13,BX13,CB13,CD13,CF13,CL13,CN13,CP13,CR13,CX13,CZ13,DB13,DF13,DH13,DJ13,DL13)","v":0},{"$f":"T13+V13+X13+Z13+AD13+AF13+AH13+AJ13+AN13+AP13+AR13+AT13+AX13+AZ13+BB13+BD13+BH13+BJ13+BL13+BN13+BR13+BT13+BV13+BX13+CB13+CD13+CF13+CH13+CL13+CN13+CP13+CR13+CX13+CZ13+DB13+CV13+DF13+DH13+DJ13+DL13","v":0},null,{"$f":"AA13+AK13+AU13+BE13+BO13+BY13+CI13+CS13+DC13+DM13","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S13),ISNUMBER(AA13)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC13),ISNUMBER(AK13)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM13),ISNUMBER(AU13)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW13),ISNUMBER(BE13)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG13),ISNUMBER(BO13)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ13),ISNUMBER(BY13)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA13),ISNUMBER(CI13)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK13),ISNUMBER(CS13)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU13),ISNUMBER(DC13)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE13),ISNUMBER(DM13)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C13=\"g\",HLOOKUP(DP14,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP14,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C13=\"g\",HLOOKUP(DP14,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP14,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ13+DV13+EA13","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN13+DD13+CT13+CJ13+BZ13+BP13+BF13+AV13+AL13+AB13","v":0},{"$f":"EG13/$EG$3","v":0},{"$f":"HLOOKUP(EH13,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L13","v":0},{"$f":"HLOOKUP(EK13,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N13/EG13","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN13,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O13","v":0},{"$f":"HLOOKUP(ES13,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ13-REFERENTIELS!$E$37:$M$37)),ABS(EQ13-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q13","v":0},{"$f":"HLOOKUP(ET13,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI13+EL13+EO13+ER13+EU13","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N13","v":0},{"$f":"COUNTIF(S13:DM15,$FA$2)","v":0},{"$f":"COUNTIF(S13:DM15,$FB$2)","v":0},{"$f":"COUNTIF(S13:DM15,$FC$2)","v":0},{"$f":"COUNTIF(S13:DM15,$FD$2)","v":0},{"$f":"COUNTIF(S13:DM15,$FE$2)","v":0},{"$f":"COUNTIF(S13:DM15,$FF$2)","v":0},{"$f":"COUNTIF(S13:DM15,$FG$2)","v":0},{"$f":"COUNTIF(S13:DM15,$FH$2)","v":0},{"$f":"COUNTIF(S13:DM15,$FI$2)","v":0},{"$f":"COUNTIF(S13:DM15,$FJ$2)","v":0},{"$f":"COUNTIF(S13:DM15,$FK$2)","v":0}]
[]
[]
[5,{"$f":"OFFSET(INDEX(eleves,MATCH(A16,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Claudine"},{"$f":"OFFSET(INDEX(eleves,MATCH(A16,numero,0),MATCH($B$2,classe,0)),0,2)","v":"f"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D16:J18,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T16,V16,X16,Z16,AD16,AF16,AH16,AJ16,AN16,AP16,AR16,AT16,AX16,AZ16,BB16,BD16,BH16,BJ16,BL16,BN16,BR16,BT16,BV16,BX16,CB16,CD16,CF16,CL16,CN16,CP16,CR16,CX16,CZ16,DB16,DF16,DH16,DJ16,DL16)","v":0},{"$f":"T16+V16+X16+Z16+AD16+AF16+AH16+AJ16+AN16+AP16+AR16+AT16+AX16+AZ16+BB16+BD16+BH16+BJ16+BL16+BN16+BR16+BT16+BV16+BX16+CB16+CD16+CF16+CH16+CL16+CN16+CP16+CR16+CX16+CZ16+DB16+CV16+DF16+DH16+DJ16+DL16","v":0},null,{"$f":"AA16+AK16+AU16+BE16+BO16+BY16+CI16+CS16+DC16+DM16","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S16),ISNUMBER(AA16)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC16),ISNUMBER(AK16)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM16),ISNUMBER(AU16)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW16),ISNUMBER(BE16)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG16),ISNUMBER(BO16)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ16),ISNUMBER(BY16)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA16),ISNUMBER(CI16)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK16),ISNUMBER(CS16)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU16),ISNUMBER(DC16)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE16),ISNUMBER(DM16)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C16=\"g\",HLOOKUP(DP17,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP17,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C16=\"g\",HLOOKUP(DP17,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP17,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ16+DV16+EA16","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN16+DD16+CT16+CJ16+BZ16+BP16+BF16+AV16+AL16+AB16","v":0},{"$f":"EG16/$EG$3","v":0},{"$f":"HLOOKUP(EH16,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L16","v":0},{"$f":"HLOOKUP(EK16,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N16/EG16","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN16,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O16","v":0},{"$f":"HLOOKUP(ES16,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ16-REFERENTIELS!$E$37:$M$37)),ABS(EQ16-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q16","v":0},{"$f":"HLOOKUP(ET16,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI16+EL16+EO16+ER16+EU16","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N16","v":0},{"$f":"COUNTIF(S16:DM18,$FA$2)","v":0},{"$f":"COUNTIF(S16:DM18,$FB$2)","v":0},{"$f":"COUNTIF(S16:DM18,$FC$2)","v":0},{"$f":"COUNTIF(S16:DM18,$FD$2)","v":0},{"$f":"COUNTIF(S16:DM18,$FE$2)","v":0},{"$f":"COUNTIF(S16:DM18,$FF$2)","v":0},{"$f":"COUNTIF(S16:DM18,$FG$2)","v":0},{"$f":"COUNTIF(S16:DM18,$FH$2)","v":0},{"$f":"COUNTIF(S16:DM18,$FI$2)","v":0},{"$f":"COUNTIF(S16:DM18,$FJ$2)","v":0},{"$f":"COUNTIF(S16:DM18,$FK$2)","v":0}]
[]
[]
[6,{"$f":"OFFSET(INDEX(eleves,MATCH(A19,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Emmanuel"},{"$f":"OFFSET(INDEX(eleves,MATCH(A19,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D19:J21,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T19,V19,X19,Z19,AD19,AF19,AH19,AJ19,AN19,AP19,AR19,AT19,AX19,AZ19,BB19,BD19,BH19,BJ19,BL19,BN19,BR19,BT19,BV19,BX19,CB19,CD19,CF19,CL19,CN19,CP19,CR19,CX19,CZ19,DB19,DF19,DH19,DJ19,DL19)","v":0},{"$f":"T19+V19+X19+Z19+AD19+AF19+AH19+AJ19+AN19+AP19+AR19+AT19+AX19+AZ19+BB19+BD19+BH19+BJ19+BL19+BN19+BR19+BT19+BV19+BX19+CB19+CD19+CF19+CH19+CL19+CN19+CP19+CR19+CX19+CZ19+DB19+CV19+DF19+DH19+DJ19+DL19","v":0},null,{"$f":"AA19+AK19+AU19+BE19+BO19+BY19+CI19+CS19+DC19+DM19","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S19),ISNUMBER(AA19)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC19),ISNUMBER(AK19)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM19),ISNUMBER(AU19)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW19),ISNUMBER(BE19)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG19),ISNUMBER(BO19)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ19),ISNUMBER(BY19)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA19),ISNUMBER(CI19)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK19),ISNUMBER(CS19)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU19),ISNUMBER(DC19)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE19),ISNUMBER(DM19)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C19=\"g\",HLOOKUP(DP20,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP20,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C19=\"g\",HLOOKUP(DP20,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP20,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ19+DV19+EA19","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN19+DD19+CT19+CJ19+BZ19+BP19+BF19+AV19+AL19+AB19","v":0},{"$f":"EG19/$EG$3","v":0},{"$f":"HLOOKUP(EH19,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L19","v":0},{"$f":"HLOOKUP(EK19,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N19/EG19","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN19,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O19","v":0},{"$f":"HLOOKUP(ES19,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ19-REFERENTIELS!$E$37:$M$37)),ABS(EQ19-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q19","v":0},{"$f":"HLOOKUP(ET19,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI19+EL19+EO19+ER19+EU19","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N19","v":0},{"$f":"COUNTIF(S19:DM21,$FA$2)","v":0},{"$f":"COUNTIF(S19:DM21,$FB$2)","v":0},{"$f":"COUNTIF(S19:DM21,$FC$2)","v":0},{"$f":"COUNTIF(S19:DM21,$FD$2)","v":0},{"$f":"COUNTIF(S19:DM21,$FE$2)","v":0},{"$f":"COUNTIF(S19:DM21,$FF$2)","v":0},{"$f":"COUNTIF(S19:DM21,$FG$2)","v":0},{"$f":"COUNTIF(S19:DM21,$FH$2)","v":0},{"$f":"COUNTIF(S19:DM21,$FI$2)","v":0},{"$f":"COUNTIF(S19:DM21,$FJ$2)","v":0},{"$f":"COUNTIF(S19:DM21,$FK$2)","v":0}]
[]
[]
[7,{"$f":"OFFSET(INDEX(eleves,MATCH(A22,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Eric"},{"$f":"OFFSET(INDEX(eleves,MATCH(A22,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D22:J24,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T22,V22,X22,Z22,AD22,AF22,AH22,AJ22,AN22,AP22,AR22,AT22,AX22,AZ22,BB22,BD22,BH22,BJ22,BL22,BN22,BR22,BT22,BV22,BX22,CB22,CD22,CF22,CL22,CN22,CP22,CR22,CX22,CZ22,DB22,DF22,DH22,DJ22,DL22)","v":0},{"$f":"T22+V22+X22+Z22+AD22+AF22+AH22+AJ22+AN22+AP22+AR22+AT22+AX22+AZ22+BB22+BD22+BH22+BJ22+BL22+BN22+BR22+BT22+BV22+BX22+CB22+CD22+CF22+CH22+CL22+CN22+CP22+CR22+CX22+CZ22+DB22+CV22+DF22+DH22+DJ22+DL22","v":0},null,{"$f":"AA22+AK22+AU22+BE22+BO22+BY22+CI22+CS22+DC22+DM22","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S22),ISNUMBER(AA22)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC22),ISNUMBER(AK22)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM22),ISNUMBER(AU22)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW22),ISNUMBER(BE22)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG22),ISNUMBER(BO22)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ22),ISNUMBER(BY22)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA22),ISNUMBER(CI22)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK22),ISNUMBER(CS22)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU22),ISNUMBER(DC22)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE22),ISNUMBER(DM22)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C22=\"g\",HLOOKUP(DP23,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP23,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C22=\"g\",HLOOKUP(DP23,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP23,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ22+DV22+EA22","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN22+DD22+CT22+CJ22+BZ22+BP22+BF22+AV22+AL22+AB22","v":0},{"$f":"EG22/$EG$3","v":0},{"$f":"HLOOKUP(EH22,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L22","v":0},{"$f":"HLOOKUP(EK22,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N22/EG22","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN22,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O22","v":0},{"$f":"HLOOKUP(ES22,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ22-REFERENTIELS!$E$37:$M$37)),ABS(EQ22-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q22","v":0},{"$f":"HLOOKUP(ET22,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI22+EL22+EO22+ER22+EU22","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N22","v":0},{"$f":"COUNTIF(S22:DM24,$FA$2)","v":0},{"$f":"COUNTIF(S22:DM24,$FB$2)","v":0},{"$f":"COUNTIF(S22:DM24,$FC$2)","v":0},{"$f":"COUNTIF(S22:DM24,$FD$2)","v":0},{"$f":"COUNTIF(S22:DM24,$FE$2)","v":0},{"$f":"COUNTIF(S22:DM24,$FF$2)","v":0},{"$f":"COUNTIF(S22:DM24,$FG$2)","v":0},{"$f":"COUNTIF(S22:DM24,$FH$2)","v":0},{"$f":"COUNTIF(S22:DM24,$FI$2)","v":0},{"$f":"COUNTIF(S22:DM24,$FJ$2)","v":0},{"$f":"COUNTIF(S22:DM24,$FK$2)","v":0}]
[]
[]
[8,{"$f":"OFFSET(INDEX(eleves,MATCH(A25,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Fred"},{"$f":"OFFSET(INDEX(eleves,MATCH(A25,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D25:J27,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T25,V25,X25,Z25,AD25,AF25,AH25,AJ25,AN25,AP25,AR25,AT25,AX25,AZ25,BB25,BD25,BH25,BJ25,BL25,BN25,BR25,BT25,BV25,BX25,CB25,CD25,CF25,CL25,CN25,CP25,CR25,CX25,CZ25,DB25,DF25,DH25,DJ25,DL25)","v":0},{"$f":"T25+V25+X25+Z25+AD25+AF25+AH25+AJ25+AN25+AP25+AR25+AT25+AX25+AZ25+BB25+BD25+BH25+BJ25+BL25+BN25+BR25+BT25+BV25+BX25+CB25+CD25+CF25+CH25+CL25+CN25+CP25+CR25+CX25+CZ25+DB25+CV25+DF25+DH25+DJ25+DL25","v":0},null,{"$f":"AA25+AK25+AU25+BE25+BO25+BY25+CI25+CS25+DC25+DM25","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S25),ISNUMBER(AA25)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC25),ISNUMBER(AK25)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM25),ISNUMBER(AU25)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW25),ISNUMBER(BE25)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG25),ISNUMBER(BO25)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ25),ISNUMBER(BY25)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA25),ISNUMBER(CI25)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK25),ISNUMBER(CS25)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU25),ISNUMBER(DC25)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE25),ISNUMBER(DM25)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C25=\"g\",HLOOKUP(DP26,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP26,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C25=\"g\",HLOOKUP(DP26,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP26,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ25+DV25+EA25","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN25+DD25+CT25+CJ25+BZ25+BP25+BF25+AV25+AL25+AB25","v":0},{"$f":"EG25/$EG$3","v":0},{"$f":"HLOOKUP(EH25,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L25","v":0},{"$f":"HLOOKUP(EK25,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N25/EG25","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN25,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O25","v":0},{"$f":"HLOOKUP(ES25,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ25-REFERENTIELS!$E$37:$M$37)),ABS(EQ25-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q25","v":0},{"$f":"HLOOKUP(ET25,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI25+EL25+EO25+ER25+EU25","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N25","v":0},{"$f":"COUNTIF(S25:DM27,$FA$2)","v":0},{"$f":"COUNTIF(S25:DM27,$FB$2)","v":0},{"$f":"COUNTIF(S25:DM27,$FC$2)","v":0},{"$f":"COUNTIF(S25:DM27,$FD$2)","v":0},{"$f":"COUNTIF(S25:DM27,$FE$2)","v":0},{"$f":"COUNTIF(S25:DM27,$FF$2)","v":0},{"$f":"COUNTIF(S25:DM27,$FG$2)","v":0},{"$f":"COUNTIF(S25:DM27,$FH$2)","v":0},{"$f":"COUNTIF(S25:DM27,$FI$2)","v":0},{"$f":"COUNTIF(S25:DM27,$FJ$2)","v":0},{"$f":"COUNTIF(S25:DM27,$FK$2)","v":0}]
[]
[]
[9,{"$f":"OFFSET(INDEX(eleves,MATCH(A28,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Gwen"},{"$f":"OFFSET(INDEX(eleves,MATCH(A28,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D28:J30,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T28,V28,X28,Z28,AD28,AF28,AH28,AJ28,AN28,AP28,AR28,AT28,AX28,AZ28,BB28,BD28,BH28,BJ28,BL28,BN28,BR28,BT28,BV28,BX28,CB28,CD28,CF28,CL28,CN28,CP28,CR28,CX28,CZ28,DB28,DF28,DH28,DJ28,DL28)","v":0},{"$f":"T28+V28+X28+Z28+AD28+AF28+AH28+AJ28+AN28+AP28+AR28+AT28+AX28+AZ28+BB28+BD28+BH28+BJ28+BL28+BN28+BR28+BT28+BV28+BX28+CB28+CD28+CF28+CH28+CL28+CN28+CP28+CR28+CX28+CZ28+DB28+CV28+DF28+DH28+DJ28+DL28","v":0},null,{"$f":"AA28+AK28+AU28+BE28+BO28+BY28+CI28+CS28+DC28+DM28","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S28),ISNUMBER(AA28)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC28),ISNUMBER(AK28)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM28),ISNUMBER(AU28)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW28),ISNUMBER(BE28)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG28),ISNUMBER(BO28)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ28),ISNUMBER(BY28)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA28),ISNUMBER(CI28)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK28),ISNUMBER(CS28)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU28),ISNUMBER(DC28)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE28),ISNUMBER(DM28)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C28=\"g\",HLOOKUP(DP29,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP29,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C28=\"g\",HLOOKUP(DP29,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP29,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ28+DV28+EA28","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN28+DD28+CT28+CJ28+BZ28+BP28+BF28+AV28+AL28+AB28","v":0},{"$f":"EG28/$EG$3","v":0},{"$f":"HLOOKUP(EH28,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L28","v":0},{"$f":"HLOOKUP(EK28,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N28/EG28","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN28,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O28","v":0},{"$f":"HLOOKUP(ES28,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ28-REFERENTIELS!$E$37:$M$37)),ABS(EQ28-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q28","v":0},{"$f":"HLOOKUP(ET28,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI28+EL28+EO28+ER28+EU28","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N28","v":0},{"$f":"COUNTIF(S28:DM30,$FA$2)","v":0},{"$f":"COUNTIF(S28:DM30,$FB$2)","v":0},{"$f":"COUNTIF(S28:DM30,$FC$2)","v":0},{"$f":"COUNTIF(S28:DM30,$FD$2)","v":0},{"$f":"COUNTIF(S28:DM30,$FE$2)","v":0},{"$f":"COUNTIF(S28:DM30,$FF$2)","v":0},{"$f":"COUNTIF(S28:DM30,$FG$2)","v":0},{"$f":"COUNTIF(S28:DM30,$FH$2)","v":0},{"$f":"COUNTIF(S28:DM30,$FI$2)","v":0},{"$f":"COUNTIF(S28:DM30,$FJ$2)","v":0},{"$f":"COUNTIF(S28:DM30,$FK$2)","v":0}]
[]
[]
[10,{"$f":"OFFSET(INDEX(eleves,MATCH(A31,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Julien"},{"$f":"OFFSET(INDEX(eleves,MATCH(A31,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D31:J33,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T31,V31,X31,Z31,AD31,AF31,AH31,AJ31,AN31,AP31,AR31,AT31,AX31,AZ31,BB31,BD31,BH31,BJ31,BL31,BN31,BR31,BT31,BV31,BX31,CB31,CD31,CF31,CL31,CN31,CP31,CR31,CX31,CZ31,DB31,DF31,DH31,DJ31,DL31)","v":0},{"$f":"T31+V31+X31+Z31+AD31+AF31+AH31+AJ31+AN31+AP31+AR31+AT31+AX31+AZ31+BB31+BD31+BH31+BJ31+BL31+BN31+BR31+BT31+BV31+BX31+CB31+CD31+CF31+CH31+CL31+CN31+CP31+CR31+CX31+CZ31+DB31+CV31+DF31+DH31+DJ31+DL31","v":0},null,{"$f":"AA31+AK31+AU31+BE31+BO31+BY31+CI31+CS31+DC31+DM31","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S31),ISNUMBER(AA31)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC31),ISNUMBER(AK31)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM31),ISNUMBER(AU31)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW31),ISNUMBER(BE31)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG31),ISNUMBER(BO31)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ31),ISNUMBER(BY31)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA31),ISNUMBER(CI31)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK31),ISNUMBER(CS31)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU31),ISNUMBER(DC31)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE31),ISNUMBER(DM31)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C31=\"g\",HLOOKUP(DP32,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP32,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C31=\"g\",HLOOKUP(DP32,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP32,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ31+DV31+EA31","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN31+DD31+CT31+CJ31+BZ31+BP31+BF31+AV31+AL31+AB31","v":0},{"$f":"EG31/$EG$3","v":0},{"$f":"HLOOKUP(EH31,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L31","v":0},{"$f":"HLOOKUP(EK31,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N31/EG31","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN31,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O31","v":0},{"$f":"HLOOKUP(ES31,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ31-REFERENTIELS!$E$37:$M$37)),ABS(EQ31-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q31","v":0},{"$f":"HLOOKUP(ET31,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI31+EL31+EO31+ER31+EU31","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N31","v":0},{"$f":"COUNTIF(S31:DM33,$FA$2)","v":0},{"$f":"COUNTIF(S31:DM33,$FB$2)","v":0},{"$f":"COUNTIF(S31:DM33,$FC$2)","v":0},{"$f":"COUNTIF(S31:DM33,$FD$2)","v":0},{"$f":"COUNTIF(S31:DM33,$FE$2)","v":0},{"$f":"COUNTIF(S31:DM33,$FF$2)","v":0},{"$f":"COUNTIF(S31:DM33,$FG$2)","v":0},{"$f":"COUNTIF(S31:DM33,$FH$2)","v":0},{"$f":"COUNTIF(S31:DM33,$FI$2)","v":0},{"$f":"COUNTIF(S31:DM33,$FJ$2)","v":0},{"$f":"COUNTIF(S31:DM33,$FK$2)","v":0}]
[]
[]
[11,{"$f":"OFFSET(INDEX(eleves,MATCH(A34,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Laurent"},{"$f":"OFFSET(INDEX(eleves,MATCH(A34,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D34:J36,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T34,V34,X34,Z34,AD34,AF34,AH34,AJ34,AN34,AP34,AR34,AT34,AX34,AZ34,BB34,BD34,BH34,BJ34,BL34,BN34,BR34,BT34,BV34,BX34,CB34,CD34,CF34,CL34,CN34,CP34,CR34,CX34,CZ34,DB34,DF34,DH34,DJ34,DL34)","v":0},{"$f":"T34+V34+X34+Z34+AD34+AF34+AH34+AJ34+AN34+AP34+AR34+AT34+AX34+AZ34+BB34+BD34+BH34+BJ34+BL34+BN34+BR34+BT34+BV34+BX34+CB34+CD34+CF34+CH34+CL34+CN34+CP34+CR34+CX34+CZ34+DB34+CV34+DF34+DH34+DJ34+DL34","v":0},null,{"$f":"AA34+AK34+AU34+BE34+BO34+BY34+CI34+CS34+DC34+DM34","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S34),ISNUMBER(AA34)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC34),ISNUMBER(AK34)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM34),ISNUMBER(AU34)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW34),ISNUMBER(BE34)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG34),ISNUMBER(BO34)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ34),ISNUMBER(BY34)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA34),ISNUMBER(CI34)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK34),ISNUMBER(CS34)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU34),ISNUMBER(DC34)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE34),ISNUMBER(DM34)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C34=\"g\",HLOOKUP(DP35,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP35,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C34=\"g\",HLOOKUP(DP35,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP35,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ34+DV34+EA34","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN34+DD34+CT34+CJ34+BZ34+BP34+BF34+AV34+AL34+AB34","v":0},{"$f":"EG34/$EG$3","v":0},{"$f":"HLOOKUP(EH34,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L34","v":0},{"$f":"HLOOKUP(EK34,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N34/EG34","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN34,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O34","v":0},{"$f":"HLOOKUP(ES34,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ34-REFERENTIELS!$E$37:$M$37)),ABS(EQ34-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q34","v":0},{"$f":"HLOOKUP(ET34,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI34+EL34+EO34+ER34+EU34","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N34","v":0},{"$f":"COUNTIF(S34:DM36,$FA$2)","v":0},{"$f":"COUNTIF(S34:DM36,$FB$2)","v":0},{"$f":"COUNTIF(S34:DM36,$FC$2)","v":0},{"$f":"COUNTIF(S34:DM36,$FD$2)","v":0},{"$f":"COUNTIF(S34:DM36,$FE$2)","v":0},{"$f":"COUNTIF(S34:DM36,$FF$2)","v":0},{"$f":"COUNTIF(S34:DM36,$FG$2)","v":0},{"$f":"COUNTIF(S34:DM36,$FH$2)","v":0},{"$f":"COUNTIF(S34:DM36,$FI$2)","v":0},{"$f":"COUNTIF(S34:DM36,$FJ$2)","v":0},{"$f":"COUNTIF(S34:DM36,$FK$2)","v":0}]
[]
[]
[12,{"$f":"OFFSET(INDEX(eleves,MATCH(A37,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Marc-Antoine"},{"$f":"OFFSET(INDEX(eleves,MATCH(A37,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D37:J39,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T37,V37,X37,Z37,AD37,AF37,AH37,AJ37,AN37,AP37,AR37,AT37,AX37,AZ37,BB37,BD37,BH37,BJ37,BL37,BN37,BR37,BT37,BV37,BX37,CB37,CD37,CF37,CL37,CN37,CP37,CR37,CX37,CZ37,DB37,DF37,DH37,DJ37,DL37)","v":0},{"$f":"T37+V37+X37+Z37+AD37+AF37+AH37+AJ37+AN37+AP37+AR37+AT37+AX37+AZ37+BB37+BD37+BH37+BJ37+BL37+BN37+BR37+BT37+BV37+BX37+CB37+CD37+CF37+CH37+CL37+CN37+CP37+CR37+CX37+CZ37+DB37+CV37+DF37+DH37+DJ37+DL37","v":0},null,{"$f":"AA37+AK37+AU37+BE37+BO37+BY37+CI37+CS37+DC37+DM37","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S37),ISNUMBER(AA37)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC37),ISNUMBER(AK37)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM37),ISNUMBER(AU37)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW37),ISNUMBER(BE37)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG37),ISNUMBER(BO37)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ37),ISNUMBER(BY37)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA37),ISNUMBER(CI37)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK37),ISNUMBER(CS37)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU37),ISNUMBER(DC37)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE37),ISNUMBER(DM37)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C37=\"g\",HLOOKUP(DP38,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP38,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C37=\"g\",HLOOKUP(DP38,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP38,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ37+DV37+EA37","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN37+DD37+CT37+CJ37+BZ37+BP37+BF37+AV37+AL37+AB37","v":0},{"$f":"EG37/$EG$3","v":0},{"$f":"HLOOKUP(EH37,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L37","v":0},{"$f":"HLOOKUP(EK37,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N37/EG37","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN37,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O37","v":0},{"$f":"HLOOKUP(ES37,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ37-REFERENTIELS!$E$37:$M$37)),ABS(EQ37-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q37","v":0},{"$f":"HLOOKUP(ET37,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI37+EL37+EO37+ER37+EU37","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N37","v":0},{"$f":"COUNTIF(S37:DM39,$FA$2)","v":0},{"$f":"COUNTIF(S37:DM39,$FB$2)","v":0},{"$f":"COUNTIF(S37:DM39,$FC$2)","v":0},{"$f":"COUNTIF(S37:DM39,$FD$2)","v":0},{"$f":"COUNTIF(S37:DM39,$FE$2)","v":0},{"$f":"COUNTIF(S37:DM39,$FF$2)","v":0},{"$f":"COUNTIF(S37:DM39,$FG$2)","v":0},{"$f":"COUNTIF(S37:DM39,$FH$2)","v":0},{"$f":"COUNTIF(S37:DM39,$FI$2)","v":0},{"$f":"COUNTIF(S37:DM39,$FJ$2)","v":0},{"$f":"COUNTIF(S37:DM39,$FK$2)","v":0}]
[]
[]
[13,{"$f":"OFFSET(INDEX(eleves,MATCH(A40,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Marco"},{"$f":"OFFSET(INDEX(eleves,MATCH(A40,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D40:J42,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T40,V40,X40,Z40,AD40,AF40,AH40,AJ40,AN40,AP40,AR40,AT40,AX40,AZ40,BB40,BD40,BH40,BJ40,BL40,BN40,BR40,BT40,BV40,BX40,CB40,CD40,CF40,CL40,CN40,CP40,CR40,CX40,CZ40,DB40,DF40,DH40,DJ40,DL40)","v":0},{"$f":"T40+V40+X40+Z40+AD40+AF40+AH40+AJ40+AN40+AP40+AR40+AT40+AX40+AZ40+BB40+BD40+BH40+BJ40+BL40+BN40+BR40+BT40+BV40+BX40+CB40+CD40+CF40+CH40+CL40+CN40+CP40+CR40+CX40+CZ40+DB40+CV40+DF40+DH40+DJ40+DL40","v":0},null,{"$f":"AA40+AK40+AU40+BE40+BO40+BY40+CI40+CS40+DC40+DM40","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S40),ISNUMBER(AA40)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC40),ISNUMBER(AK40)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM40),ISNUMBER(AU40)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW40),ISNUMBER(BE40)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG40),ISNUMBER(BO40)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ40),ISNUMBER(BY40)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA40),ISNUMBER(CI40)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK40),ISNUMBER(CS40)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU40),ISNUMBER(DC40)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE40),ISNUMBER(DM40)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C40=\"g\",HLOOKUP(DP41,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP41,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C40=\"g\",HLOOKUP(DP41,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP41,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ40+DV40+EA40","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN40+DD40+CT40+CJ40+BZ40+BP40+BF40+AV40+AL40+AB40","v":0},{"$f":"EG40/$EG$3","v":0},{"$f":"HLOOKUP(EH40,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L40","v":0},{"$f":"HLOOKUP(EK40,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N40/EG40","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN40,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O40","v":0},{"$f":"HLOOKUP(ES40,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ40-REFERENTIELS!$E$37:$M$37)),ABS(EQ40-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q40","v":0},{"$f":"HLOOKUP(ET40,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI40+EL40+EO40+ER40+EU40","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N40","v":0},{"$f":"COUNTIF(S40:DM42,$FA$2)","v":0},{"$f":"COUNTIF(S40:DM42,$FB$2)","v":0},{"$f":"COUNTIF(S40:DM42,$FC$2)","v":0},{"$f":"COUNTIF(S40:DM42,$FD$2)","v":0},{"$f":"COUNTIF(S40:DM42,$FE$2)","v":0},{"$f":"COUNTIF(S40:DM42,$FF$2)","v":0},{"$f":"COUNTIF(S40:DM42,$FG$2)","v":0},{"$f":"COUNTIF(S40:DM42,$FH$2)","v":0},{"$f":"COUNTIF(S40:DM42,$FI$2)","v":0},{"$f":"COUNTIF(S40:DM42,$FJ$2)","v":0},{"$f":"COUNTIF(S40:DM42,$FK$2)","v":0}]
[]
[]
[14,{"$f":"OFFSET(INDEX(eleves,MATCH(A43,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Morgane"},{"$f":"OFFSET(INDEX(eleves,MATCH(A43,numero,0),MATCH($B$2,classe,0)),0,2)","v":"f"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D43:J45,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T43,V43,X43,Z43,AD43,AF43,AH43,AJ43,AN43,AP43,AR43,AT43,AX43,AZ43,BB43,BD43,BH43,BJ43,BL43,BN43,BR43,BT43,BV43,BX43,CB43,CD43,CF43,CL43,CN43,CP43,CR43,CX43,CZ43,DB43,DF43,DH43,DJ43,DL43)","v":0},{"$f":"T43+V43+X43+Z43+AD43+AF43+AH43+AJ43+AN43+AP43+AR43+AT43+AX43+AZ43+BB43+BD43+BH43+BJ43+BL43+BN43+BR43+BT43+BV43+BX43+CB43+CD43+CF43+CH43+CL43+CN43+CP43+CR43+CX43+CZ43+DB43+CV43+DF43+DH43+DJ43+DL43","v":0},null,{"$f":"AA43+AK43+AU43+BE43+BO43+BY43+CI43+CS43+DC43+DM43","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S43),ISNUMBER(AA43)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC43),ISNUMBER(AK43)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM43),ISNUMBER(AU43)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW43),ISNUMBER(BE43)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG43),ISNUMBER(BO43)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ43),ISNUMBER(BY43)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA43),ISNUMBER(CI43)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK43),ISNUMBER(CS43)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU43),ISNUMBER(DC43)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE43),ISNUMBER(DM43)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C43=\"g\",HLOOKUP(DP44,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP44,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C43=\"g\",HLOOKUP(DP44,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP44,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ43+DV43+EA43","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN43+DD43+CT43+CJ43+BZ43+BP43+BF43+AV43+AL43+AB43","v":0},{"$f":"EG43/$EG$3","v":0},{"$f":"HLOOKUP(EH43,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L43","v":0},{"$f":"HLOOKUP(EK43,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N43/EG43","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN43,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O43","v":0},{"$f":"HLOOKUP(ES43,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ43-REFERENTIELS!$E$37:$M$37)),ABS(EQ43-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q43","v":0},{"$f":"HLOOKUP(ET43,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI43+EL43+EO43+ER43+EU43","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N43","v":0},{"$f":"COUNTIF(S43:DM45,$FA$2)","v":0},{"$f":"COUNTIF(S43:DM45,$FB$2)","v":0},{"$f":"COUNTIF(S43:DM45,$FC$2)","v":0},{"$f":"COUNTIF(S43:DM45,$FD$2)","v":0},{"$f":"COUNTIF(S43:DM45,$FE$2)","v":0},{"$f":"COUNTIF(S43:DM45,$FF$2)","v":0},{"$f":"COUNTIF(S43:DM45,$FG$2)","v":0},{"$f":"COUNTIF(S43:DM45,$FH$2)","v":0},{"$f":"COUNTIF(S43:DM45,$FI$2)","v":0},{"$f":"COUNTIF(S43:DM45,$FJ$2)","v":0},{"$f":"COUNTIF(S43:DM45,$FK$2)","v":0}]
[]
[]
[15,{"$f":"OFFSET(INDEX(eleves,MATCH(A46,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Nathalie"},{"$f":"OFFSET(INDEX(eleves,MATCH(A46,numero,0),MATCH($B$2,classe,0)),0,2)","v":"f"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D46:J48,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T46,V46,X46,Z46,AD46,AF46,AH46,AJ46,AN46,AP46,AR46,AT46,AX46,AZ46,BB46,BD46,BH46,BJ46,BL46,BN46,BR46,BT46,BV46,BX46,CB46,CD46,CF46,CL46,CN46,CP46,CR46,CX46,CZ46,DB46,DF46,DH46,DJ46,DL46)","v":0},{"$f":"T46+V46+X46+Z46+AD46+AF46+AH46+AJ46+AN46+AP46+AR46+AT46+AX46+AZ46+BB46+BD46+BH46+BJ46+BL46+BN46+BR46+BT46+BV46+BX46+CB46+CD46+CF46+CH46+CL46+CN46+CP46+CR46+CX46+CZ46+DB46+CV46+DF46+DH46+DJ46+DL46","v":0},null,{"$f":"AA46+AK46+AU46+BE46+BO46+BY46+CI46+CS46+DC46+DM46","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S46),ISNUMBER(AA46)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC46),ISNUMBER(AK46)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM46),ISNUMBER(AU46)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW46),ISNUMBER(BE46)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG46),ISNUMBER(BO46)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ46),ISNUMBER(BY46)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA46),ISNUMBER(CI46)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK46),ISNUMBER(CS46)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU46),ISNUMBER(DC46)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE46),ISNUMBER(DM46)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C46=\"g\",HLOOKUP(DP47,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP47,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C46=\"g\",HLOOKUP(DP47,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP47,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ46+DV46+EA46","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN46+DD46+CT46+CJ46+BZ46+BP46+BF46+AV46+AL46+AB46","v":0},{"$f":"EG46/$EG$3","v":0},{"$f":"HLOOKUP(EH46,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L46","v":0},{"$f":"HLOOKUP(EK46,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N46/EG46","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN46,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O46","v":0},{"$f":"HLOOKUP(ES46,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ46-REFERENTIELS!$E$37:$M$37)),ABS(EQ46-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q46","v":0},{"$f":"HLOOKUP(ET46,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI46+EL46+EO46+ER46+EU46","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N46","v":0},{"$f":"COUNTIF(S46:DM48,$FA$2)","v":0},{"$f":"COUNTIF(S46:DM48,$FB$2)","v":0},{"$f":"COUNTIF(S46:DM48,$FC$2)","v":0},{"$f":"COUNTIF(S46:DM48,$FD$2)","v":0},{"$f":"COUNTIF(S46:DM48,$FE$2)","v":0},{"$f":"COUNTIF(S46:DM48,$FF$2)","v":0},{"$f":"COUNTIF(S46:DM48,$FG$2)","v":0},{"$f":"COUNTIF(S46:DM48,$FH$2)","v":0},{"$f":"COUNTIF(S46:DM48,$FI$2)","v":0},{"$f":"COUNTIF(S46:DM48,$FJ$2)","v":0},{"$f":"COUNTIF(S46:DM48,$FK$2)","v":0}]
[]
[]
[16,{"$f":"OFFSET(INDEX(eleves,MATCH(A49,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Nico Afriat"},{"$f":"OFFSET(INDEX(eleves,MATCH(A49,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D49:J51,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T49,V49,X49,Z49,AD49,AF49,AH49,AJ49,AN49,AP49,AR49,AT49,AX49,AZ49,BB49,BD49,BH49,BJ49,BL49,BN49,BR49,BT49,BV49,BX49,CB49,CD49,CF49,CL49,CN49,CP49,CR49,CX49,CZ49,DB49,DF49,DH49,DJ49,DL49)","v":0},{"$f":"T49+V49+X49+Z49+AD49+AF49+AH49+AJ49+AN49+AP49+AR49+AT49+AX49+AZ49+BB49+BD49+BH49+BJ49+BL49+BN49+BR49+BT49+BV49+BX49+CB49+CD49+CF49+CH49+CL49+CN49+CP49+CR49+CX49+CZ49+DB49+CV49+DF49+DH49+DJ49+DL49","v":0},null,{"$f":"AA49+AK49+AU49+BE49+BO49+BY49+CI49+CS49+DC49+DM49","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S49),ISNUMBER(AA49)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC49),ISNUMBER(AK49)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM49),ISNUMBER(AU49)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW49),ISNUMBER(BE49)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG49),ISNUMBER(BO49)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ49),ISNUMBER(BY49)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA49),ISNUMBER(CI49)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK49),ISNUMBER(CS49)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU49),ISNUMBER(DC49)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE49),ISNUMBER(DM49)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C49=\"g\",HLOOKUP(DP50,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP50,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C49=\"g\",HLOOKUP(DP50,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP50,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ49+DV49+EA49","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN49+DD49+CT49+CJ49+BZ49+BP49+BF49+AV49+AL49+AB49","v":0},{"$f":"EG49/$EG$3","v":0},{"$f":"HLOOKUP(EH49,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L49","v":0},{"$f":"HLOOKUP(EK49,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N49/EG49","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN49,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O49","v":0},{"$f":"HLOOKUP(ES49,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ49-REFERENTIELS!$E$37:$M$37)),ABS(EQ49-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q49","v":0},{"$f":"HLOOKUP(ET49,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI49+EL49+EO49+ER49+EU49","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N49","v":0},{"$f":"COUNTIF(S49:DM51,$FA$2)","v":0},{"$f":"COUNTIF(S49:DM51,$FB$2)","v":0},{"$f":"COUNTIF(S49:DM51,$FC$2)","v":0},{"$f":"COUNTIF(S49:DM51,$FD$2)","v":0},{"$f":"COUNTIF(S49:DM51,$FE$2)","v":0},{"$f":"COUNTIF(S49:DM51,$FF$2)","v":0},{"$f":"COUNTIF(S49:DM51,$FG$2)","v":0},{"$f":"COUNTIF(S49:DM51,$FH$2)","v":0},{"$f":"COUNTIF(S49:DM51,$FI$2)","v":0},{"$f":"COUNTIF(S49:DM51,$FJ$2)","v":0},{"$f":"COUNTIF(S49:DM51,$FK$2)","v":0}]
[]
[]
[17,{"$f":"OFFSET(INDEX(eleves,MATCH(A52,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Nico Podu"},{"$f":"OFFSET(INDEX(eleves,MATCH(A52,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D52:J54,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T52,V52,X52,Z52,AD52,AF52,AH52,AJ52,AN52,AP52,AR52,AT52,AX52,AZ52,BB52,BD52,BH52,BJ52,BL52,BN52,BR52,BT52,BV52,BX52,CB52,CD52,CF52,CL52,CN52,CP52,CR52,CX52,CZ52,DB52,DF52,DH52,DJ52,DL52)","v":0},{"$f":"T52+V52+X52+Z52+AD52+AF52+AH52+AJ52+AN52+AP52+AR52+AT52+AX52+AZ52+BB52+BD52+BH52+BJ52+BL52+BN52+BR52+BT52+BV52+BX52+CB52+CD52+CF52+CH52+CL52+CN52+CP52+CR52+CX52+CZ52+DB52+CV52+DF52+DH52+DJ52+DL52","v":0},null,{"$f":"AA52+AK52+AU52+BE52+BO52+BY52+CI52+CS52+DC52+DM52","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S52),ISNUMBER(AA52)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC52),ISNUMBER(AK52)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM52),ISNUMBER(AU52)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW52),ISNUMBER(BE52)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG52),ISNUMBER(BO52)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ52),ISNUMBER(BY52)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA52),ISNUMBER(CI52)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK52),ISNUMBER(CS52)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU52),ISNUMBER(DC52)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE52),ISNUMBER(DM52)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C52=\"g\",HLOOKUP(DP53,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP53,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C52=\"g\",HLOOKUP(DP53,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP53,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ52+DV52+EA52","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN52+DD52+CT52+CJ52+BZ52+BP52+BF52+AV52+AL52+AB52","v":0},{"$f":"EG52/$EG$3","v":0},{"$f":"HLOOKUP(EH52,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L52","v":0},{"$f":"HLOOKUP(EK52,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N52/EG52","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN52,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O52","v":0},{"$f":"HLOOKUP(ES52,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ52-REFERENTIELS!$E$37:$M$37)),ABS(EQ52-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q52","v":0},{"$f":"HLOOKUP(ET52,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI52+EL52+EO52+ER52+EU52","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N52","v":0},{"$f":"COUNTIF(S52:DM54,$FA$2)","v":0},{"$f":"COUNTIF(S52:DM54,$FB$2)","v":0},{"$f":"COUNTIF(S52:DM54,$FC$2)","v":0},{"$f":"COUNTIF(S52:DM54,$FD$2)","v":0},{"$f":"COUNTIF(S52:DM54,$FE$2)","v":0},{"$f":"COUNTIF(S52:DM54,$FF$2)","v":0},{"$f":"COUNTIF(S52:DM54,$FG$2)","v":0},{"$f":"COUNTIF(S52:DM54,$FH$2)","v":0},{"$f":"COUNTIF(S52:DM54,$FI$2)","v":0},{"$f":"COUNTIF(S52:DM54,$FJ$2)","v":0},{"$f":"COUNTIF(S52:DM54,$FK$2)","v":0}]
[]
[]
[18,{"$f":"OFFSET(INDEX(eleves,MATCH(A55,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Olivier"},{"$f":"OFFSET(INDEX(eleves,MATCH(A55,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D55:J57,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T55,V55,X55,Z55,AD55,AF55,AH55,AJ55,AN55,AP55,AR55,AT55,AX55,AZ55,BB55,BD55,BH55,BJ55,BL55,BN55,BR55,BT55,BV55,BX55,CB55,CD55,CF55,CL55,CN55,CP55,CR55,CX55,CZ55,DB55,DF55,DH55,DJ55,DL55)","v":0},{"$f":"T55+V55+X55+Z55+AD55+AF55+AH55+AJ55+AN55+AP55+AR55+AT55+AX55+AZ55+BB55+BD55+BH55+BJ55+BL55+BN55+BR55+BT55+BV55+BX55+CB55+CD55+CF55+CH55+CL55+CN55+CP55+CR55+CX55+CZ55+DB55+CV55+DF55+DH55+DJ55+DL55","v":0},null,{"$f":"AA55+AK55+AU55+BE55+BO55+BY55+CI55+CS55+DC55+DM55","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S55),ISNUMBER(AA55)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC55),ISNUMBER(AK55)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM55),ISNUMBER(AU55)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW55),ISNUMBER(BE55)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG55),ISNUMBER(BO55)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ55),ISNUMBER(BY55)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA55),ISNUMBER(CI55)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK55),ISNUMBER(CS55)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU55),ISNUMBER(DC55)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE55),ISNUMBER(DM55)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C55=\"g\",HLOOKUP(DP56,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP56,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C55=\"g\",HLOOKUP(DP56,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP56,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ55+DV55+EA55","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN55+DD55+CT55+CJ55+BZ55+BP55+BF55+AV55+AL55+AB55","v":0},{"$f":"EG55/$EG$3","v":0},{"$f":"HLOOKUP(EH55,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L55","v":0},{"$f":"HLOOKUP(EK55,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N55/EG55","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN55,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O55","v":0},{"$f":"HLOOKUP(ES55,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ55-REFERENTIELS!$E$37:$M$37)),ABS(EQ55-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q55","v":0},{"$f":"HLOOKUP(ET55,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI55+EL55+EO55+ER55+EU55","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N55","v":0},{"$f":"COUNTIF(S55:DM57,$FA$2)","v":0},{"$f":"COUNTIF(S55:DM57,$FB$2)","v":0},{"$f":"COUNTIF(S55:DM57,$FC$2)","v":0},{"$f":"COUNTIF(S55:DM57,$FD$2)","v":0},{"$f":"COUNTIF(S55:DM57,$FE$2)","v":0},{"$f":"COUNTIF(S55:DM57,$FF$2)","v":0},{"$f":"COUNTIF(S55:DM57,$FG$2)","v":0},{"$f":"COUNTIF(S55:DM57,$FH$2)","v":0},{"$f":"COUNTIF(S55:DM57,$FI$2)","v":0},{"$f":"COUNTIF(S55:DM57,$FJ$2)","v":0},{"$f":"COUNTIF(S55:DM57,$FK$2)","v":0}]
[]
[]
[19,{"$f":"OFFSET(INDEX(eleves,MATCH(A58,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Pascal"},{"$f":"OFFSET(INDEX(eleves,MATCH(A58,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D58:J60,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T58,V58,X58,Z58,AD58,AF58,AH58,AJ58,AN58,AP58,AR58,AT58,AX58,AZ58,BB58,BD58,BH58,BJ58,BL58,BN58,BR58,BT58,BV58,BX58,CB58,CD58,CF58,CL58,CN58,CP58,CR58,CX58,CZ58,DB58,DF58,DH58,DJ58,DL58)","v":0},{"$f":"T58+V58+X58+Z58+AD58+AF58+AH58+AJ58+AN58+AP58+AR58+AT58+AX58+AZ58+BB58+BD58+BH58+BJ58+BL58+BN58+BR58+BT58+BV58+BX58+CB58+CD58+CF58+CH58+CL58+CN58+CP58+CR58+CX58+CZ58+DB58+CV58+DF58+DH58+DJ58+DL58","v":0},null,{"$f":"AA58+AK58+AU58+BE58+BO58+BY58+CI58+CS58+DC58+DM58","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S58),ISNUMBER(AA58)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC58),ISNUMBER(AK58)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM58),ISNUMBER(AU58)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW58),ISNUMBER(BE58)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG58),ISNUMBER(BO58)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ58),ISNUMBER(BY58)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA58),ISNUMBER(CI58)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK58),ISNUMBER(CS58)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU58),ISNUMBER(DC58)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE58),ISNUMBER(DM58)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C58=\"g\",HLOOKUP(DP59,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP59,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C58=\"g\",HLOOKUP(DP59,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP59,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ58+DV58+EA58","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN58+DD58+CT58+CJ58+BZ58+BP58+BF58+AV58+AL58+AB58","v":0},{"$f":"EG58/$EG$3","v":0},{"$f":"HLOOKUP(EH58,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L58","v":0},{"$f":"HLOOKUP(EK58,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N58/EG58","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN58,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O58","v":0},{"$f":"HLOOKUP(ES58,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ58-REFERENTIELS!$E$37:$M$37)),ABS(EQ58-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q58","v":0},{"$f":"HLOOKUP(ET58,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI58+EL58+EO58+ER58+EU58","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N58","v":0},{"$f":"COUNTIF(S58:DM60,$FA$2)","v":0},{"$f":"COUNTIF(S58:DM60,$FB$2)","v":0},{"$f":"COUNTIF(S58:DM60,$FC$2)","v":0},{"$f":"COUNTIF(S58:DM60,$FD$2)","v":0},{"$f":"COUNTIF(S58:DM60,$FE$2)","v":0},{"$f":"COUNTIF(S58:DM60,$FF$2)","v":0},{"$f":"COUNTIF(S58:DM60,$FG$2)","v":0},{"$f":"COUNTIF(S58:DM60,$FH$2)","v":0},{"$f":"COUNTIF(S58:DM60,$FI$2)","v":0},{"$f":"COUNTIF(S58:DM60,$FJ$2)","v":0},{"$f":"COUNTIF(S58:DM60,$FK$2)","v":0}]
[]
[]
[20,{"$f":"OFFSET(INDEX(eleves,MATCH(A61,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Phil G."},{"$f":"OFFSET(INDEX(eleves,MATCH(A61,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D61:J63,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T61,V61,X61,Z61,AD61,AF61,AH61,AJ61,AN61,AP61,AR61,AT61,AX61,AZ61,BB61,BD61,BH61,BJ61,BL61,BN61,BR61,BT61,BV61,BX61,CB61,CD61,CF61,CL61,CN61,CP61,CR61,CX61,CZ61,DB61,DF61,DH61,DJ61,DL61)","v":0},{"$f":"T61+V61+X61+Z61+AD61+AF61+AH61+AJ61+AN61+AP61+AR61+AT61+AX61+AZ61+BB61+BD61+BH61+BJ61+BL61+BN61+BR61+BT61+BV61+BX61+CB61+CD61+CF61+CH61+CL61+CN61+CP61+CR61+CX61+CZ61+DB61+CV61+DF61+DH61+DJ61+DL61","v":0},null,{"$f":"AA61+AK61+AU61+BE61+BO61+BY61+CI61+CS61+DC61+DM61","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S61),ISNUMBER(AA61)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC61),ISNUMBER(AK61)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM61),ISNUMBER(AU61)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW61),ISNUMBER(BE61)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG61),ISNUMBER(BO61)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ61),ISNUMBER(BY61)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA61),ISNUMBER(CI61)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK61),ISNUMBER(CS61)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU61),ISNUMBER(DC61)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE61),ISNUMBER(DM61)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C61=\"g\",HLOOKUP(DP62,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP62,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C61=\"g\",HLOOKUP(DP62,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP62,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ61+DV61+EA61","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN61+DD61+CT61+CJ61+BZ61+BP61+BF61+AV61+AL61+AB61","v":0},{"$f":"EG61/$EG$3","v":0},{"$f":"HLOOKUP(EH61,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L61","v":0},{"$f":"HLOOKUP(EK61,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N61/EG61","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN61,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O61","v":0},{"$f":"HLOOKUP(ES61,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ61-REFERENTIELS!$E$37:$M$37)),ABS(EQ61-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q61","v":0},{"$f":"HLOOKUP(ET61,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI61+EL61+EO61+ER61+EU61","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N61","v":0},{"$f":"COUNTIF(S61:DM63,$FA$2)","v":0},{"$f":"COUNTIF(S61:DM63,$FB$2)","v":0},{"$f":"COUNTIF(S61:DM63,$FC$2)","v":0},{"$f":"COUNTIF(S61:DM63,$FD$2)","v":0},{"$f":"COUNTIF(S61:DM63,$FE$2)","v":0},{"$f":"COUNTIF(S61:DM63,$FF$2)","v":0},{"$f":"COUNTIF(S61:DM63,$FG$2)","v":0},{"$f":"COUNTIF(S61:DM63,$FH$2)","v":0},{"$f":"COUNTIF(S61:DM63,$FI$2)","v":0},{"$f":"COUNTIF(S61:DM63,$FJ$2)","v":0},{"$f":"COUNTIF(S61:DM63,$FK$2)","v":0}]
[]
[]
[21,{"$f":"OFFSET(INDEX(eleves,MATCH(A64,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Philippe G."},{"$f":"OFFSET(INDEX(eleves,MATCH(A64,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D64:J66,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T64,V64,X64,Z64,AD64,AF64,AH64,AJ64,AN64,AP64,AR64,AT64,AX64,AZ64,BB64,BD64,BH64,BJ64,BL64,BN64,BR64,BT64,BV64,BX64,CB64,CD64,CF64,CL64,CN64,CP64,CR64,CX64,CZ64,DB64,DF64,DH64,DJ64,DL64)","v":0},{"$f":"T64+V64+X64+Z64+AD64+AF64+AH64+AJ64+AN64+AP64+AR64+AT64+AX64+AZ64+BB64+BD64+BH64+BJ64+BL64+BN64+BR64+BT64+BV64+BX64+CB64+CD64+CF64+CH64+CL64+CN64+CP64+CR64+CX64+CZ64+DB64+CV64+DF64+DH64+DJ64+DL64","v":0},null,{"$f":"AA64+AK64+AU64+BE64+BO64+BY64+CI64+CS64+DC64+DM64","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S64),ISNUMBER(AA64)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC64),ISNUMBER(AK64)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM64),ISNUMBER(AU64)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW64),ISNUMBER(BE64)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG64),ISNUMBER(BO64)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ64),ISNUMBER(BY64)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA64),ISNUMBER(CI64)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK64),ISNUMBER(CS64)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU64),ISNUMBER(DC64)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE64),ISNUMBER(DM64)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C64=\"g\",HLOOKUP(DP65,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP65,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C64=\"g\",HLOOKUP(DP65,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP65,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ64+DV64+EA64","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN64+DD64+CT64+CJ64+BZ64+BP64+BF64+AV64+AL64+AB64","v":0},{"$f":"EG64/$EG$3","v":0},{"$f":"HLOOKUP(EH64,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L64","v":0},{"$f":"HLOOKUP(EK64,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N64/EG64","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN64,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O64","v":0},{"$f":"HLOOKUP(ES64,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ64-REFERENTIELS!$E$37:$M$37)),ABS(EQ64-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q64","v":0},{"$f":"HLOOKUP(ET64,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI64+EL64+EO64+ER64+EU64","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N64","v":0},{"$f":"COUNTIF(S64:DM66,$FA$2)","v":0},{"$f":"COUNTIF(S64:DM66,$FB$2)","v":0},{"$f":"COUNTIF(S64:DM66,$FC$2)","v":0},{"$f":"COUNTIF(S64:DM66,$FD$2)","v":0},{"$f":"COUNTIF(S64:DM66,$FE$2)","v":0},{"$f":"COUNTIF(S64:DM66,$FF$2)","v":0},{"$f":"COUNTIF(S64:DM66,$FG$2)","v":0},{"$f":"COUNTIF(S64:DM66,$FH$2)","v":0},{"$f":"COUNTIF(S64:DM66,$FI$2)","v":0},{"$f":"COUNTIF(S64:DM66,$FJ$2)","v":0},{"$f":"COUNTIF(S64:DM66,$FK$2)","v":0}]
[]
[]
[22,{"$f":"OFFSET(INDEX(eleves,MATCH(A67,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Stef"},{"$f":"OFFSET(INDEX(eleves,MATCH(A67,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D67:J69,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T67,V67,X67,Z67,AD67,AF67,AH67,AJ67,AN67,AP67,AR67,AT67,AX67,AZ67,BB67,BD67,BH67,BJ67,BL67,BN67,BR67,BT67,BV67,BX67,CB67,CD67,CF67,CL67,CN67,CP67,CR67,CX67,CZ67,DB67,DF67,DH67,DJ67,DL67)","v":0},{"$f":"T67+V67+X67+Z67+AD67+AF67+AH67+AJ67+AN67+AP67+AR67+AT67+AX67+AZ67+BB67+BD67+BH67+BJ67+BL67+BN67+BR67+BT67+BV67+BX67+CB67+CD67+CF67+CH67+CL67+CN67+CP67+CR67+CX67+CZ67+DB67+CV67+DF67+DH67+DJ67+DL67","v":0},null,{"$f":"AA67+AK67+AU67+BE67+BO67+BY67+CI67+CS67+DC67+DM67","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S67),ISNUMBER(AA67)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC67),ISNUMBER(AK67)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM67),ISNUMBER(AU67)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW67),ISNUMBER(BE67)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG67),ISNUMBER(BO67)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ67),ISNUMBER(BY67)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA67),ISNUMBER(CI67)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK67),ISNUMBER(CS67)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU67),ISNUMBER(DC67)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE67),ISNUMBER(DM67)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C67=\"g\",HLOOKUP(DP68,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP68,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C67=\"g\",HLOOKUP(DP68,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP68,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ67+DV67+EA67","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN67+DD67+CT67+CJ67+BZ67+BP67+BF67+AV67+AL67+AB67","v":0},{"$f":"EG67/$EG$3","v":0},{"$f":"HLOOKUP(EH67,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L67","v":0},{"$f":"HLOOKUP(EK67,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N67/EG67","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN67,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O67","v":0},{"$f":"HLOOKUP(ES67,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ67-REFERENTIELS!$E$37:$M$37)),ABS(EQ67-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q67","v":0},{"$f":"HLOOKUP(ET67,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI67+EL67+EO67+ER67+EU67","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N67","v":0},{"$f":"COUNTIF(S67:DM69,$FA$2)","v":0},{"$f":"COUNTIF(S67:DM69,$FB$2)","v":0},{"$f":"COUNTIF(S67:DM69,$FC$2)","v":0},{"$f":"COUNTIF(S67:DM69,$FD$2)","v":0},{"$f":"COUNTIF(S67:DM69,$FE$2)","v":0},{"$f":"COUNTIF(S67:DM69,$FF$2)","v":0},{"$f":"COUNTIF(S67:DM69,$FG$2)","v":0},{"$f":"COUNTIF(S67:DM69,$FH$2)","v":0},{"$f":"COUNTIF(S67:DM69,$FI$2)","v":0},{"$f":"COUNTIF(S67:DM69,$FJ$2)","v":0},{"$f":"COUNTIF(S67:DM69,$FK$2)","v":0}]
[]
[]
[23,{"$f":"OFFSET(INDEX(eleves,MATCH(A70,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Thomas"},{"$f":"OFFSET(INDEX(eleves,MATCH(A70,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D70:J72,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T70,V70,X70,Z70,AD70,AF70,AH70,AJ70,AN70,AP70,AR70,AT70,AX70,AZ70,BB70,BD70,BH70,BJ70,BL70,BN70,BR70,BT70,BV70,BX70,CB70,CD70,CF70,CL70,CN70,CP70,CR70,CX70,CZ70,DB70,DF70,DH70,DJ70,DL70)","v":0},{"$f":"T70+V70+X70+Z70+AD70+AF70+AH70+AJ70+AN70+AP70+AR70+AT70+AX70+AZ70+BB70+BD70+BH70+BJ70+BL70+BN70+BR70+BT70+BV70+BX70+CB70+CD70+CF70+CH70+CL70+CN70+CP70+CR70+CX70+CZ70+DB70+CV70+DF70+DH70+DJ70+DL70","v":0},null,{"$f":"AA70+AK70+AU70+BE70+BO70+BY70+CI70+CS70+DC70+DM70","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S70),ISNUMBER(AA70)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC70),ISNUMBER(AK70)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM70),ISNUMBER(AU70)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW70),ISNUMBER(BE70)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG70),ISNUMBER(BO70)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ70),ISNUMBER(BY70)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA70),ISNUMBER(CI70)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK70),ISNUMBER(CS70)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU70),ISNUMBER(DC70)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE70),ISNUMBER(DM70)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C70=\"g\",HLOOKUP(DP71,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP71,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C70=\"g\",HLOOKUP(DP71,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP71,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ70+DV70+EA70","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN70+DD70+CT70+CJ70+BZ70+BP70+BF70+AV70+AL70+AB70","v":0},{"$f":"EG70/$EG$3","v":0},{"$f":"HLOOKUP(EH70,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L70","v":0},{"$f":"HLOOKUP(EK70,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N70/EG70","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN70,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O70","v":0},{"$f":"HLOOKUP(ES70,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ70-REFERENTIELS!$E$37:$M$37)),ABS(EQ70-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q70","v":0},{"$f":"HLOOKUP(ET70,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI70+EL70+EO70+ER70+EU70","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N70","v":0},{"$f":"COUNTIF(S70:DM72,$FA$2)","v":0},{"$f":"COUNTIF(S70:DM72,$FB$2)","v":0},{"$f":"COUNTIF(S70:DM72,$FC$2)","v":0},{"$f":"COUNTIF(S70:DM72,$FD$2)","v":0},{"$f":"COUNTIF(S70:DM72,$FE$2)","v":0},{"$f":"COUNTIF(S70:DM72,$FF$2)","v":0},{"$f":"COUNTIF(S70:DM72,$FG$2)","v":0},{"$f":"COUNTIF(S70:DM72,$FH$2)","v":0},{"$f":"COUNTIF(S70:DM72,$FI$2)","v":0},{"$f":"COUNTIF(S70:DM72,$FJ$2)","v":0},{"$f":"COUNTIF(S70:DM72,$FK$2)","v":0}]
[]
[]
[24,{"$f":"OFFSET(INDEX(eleves,MATCH(A73,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Tristan"},{"$f":"OFFSET(INDEX(eleves,MATCH(A73,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D73:J75,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T73,V73,X73,Z73,AD73,AF73,AH73,AJ73,AN73,AP73,AR73,AT73,AX73,AZ73,BB73,BD73,BH73,BJ73,BL73,BN73,BR73,BT73,BV73,BX73,CB73,CD73,CF73,CL73,CN73,CP73,CR73,CX73,CZ73,DB73,DF73,DH73,DJ73,DL73)","v":0},{"$f":"T73+V73+X73+Z73+AD73+AF73+AH73+AJ73+AN73+AP73+AR73+AT73+AX73+AZ73+BB73+BD73+BH73+BJ73+BL73+BN73+BR73+BT73+BV73+BX73+CB73+CD73+CF73+CH73+CL73+CN73+CP73+CR73+CX73+CZ73+DB73+CV73+DF73+DH73+DJ73+DL73","v":0},null,{"$f":"AA73+AK73+AU73+BE73+BO73+BY73+CI73+CS73+DC73+DM73","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S73),ISNUMBER(AA73)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC73),ISNUMBER(AK73)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM73),ISNUMBER(AU73)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW73),ISNUMBER(BE73)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG73),ISNUMBER(BO73)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ73),ISNUMBER(BY73)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA73),ISNUMBER(CI73)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK73),ISNUMBER(CS73)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU73),ISNUMBER(DC73)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE73),ISNUMBER(DM73)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C73=\"g\",HLOOKUP(DP74,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP74,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C73=\"g\",HLOOKUP(DP74,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP74,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ73+DV73+EA73","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN73+DD73+CT73+CJ73+BZ73+BP73+BF73+AV73+AL73+AB73","v":0},{"$f":"EG73/$EG$3","v":0},{"$f":"HLOOKUP(EH73,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L73","v":0},{"$f":"HLOOKUP(EK73,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N73/EG73","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN73,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O73","v":0},{"$f":"HLOOKUP(ES73,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ73-REFERENTIELS!$E$37:$M$37)),ABS(EQ73-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q73","v":0},{"$f":"HLOOKUP(ET73,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI73+EL73+EO73+ER73+EU73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N73","v":0},{"$f":"COUNTIF(S73:DM75,$FA$2)","v":0},{"$f":"COUNTIF(S73:DM75,$FB$2)","v":0},{"$f":"COUNTIF(S73:DM75,$FC$2)","v":0},{"$f":"COUNTIF(S73:DM75,$FD$2)","v":0},{"$f":"COUNTIF(S73:DM75,$FE$2)","v":0},{"$f":"COUNTIF(S73:DM75,$FF$2)","v":0},{"$f":"COUNTIF(S73:DM75,$FG$2)","v":0},{"$f":"COUNTIF(S73:DM75,$FH$2)","v":0},{"$f":"COUNTIF(S73:DM75,$FI$2)","v":0},{"$f":"COUNTIF(S73:DM75,$FJ$2)","v":0},{"$f":"COUNTIF(S73:DM75,$FK$2)","v":0}]
[]
[]
[25,{"$f":"OFFSET(INDEX(eleves,MATCH(A76,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Vivien"},{"$f":"OFFSET(INDEX(eleves,MATCH(A76,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D76:J78,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T76,V76,X76,Z76,AD76,AF76,AH76,AJ76,AN76,AP76,AR76,AT76,AX76,AZ76,BB76,BD76,BH76,BJ76,BL76,BN76,BR76,BT76,BV76,BX76,CB76,CD76,CF76,CL76,CN76,CP76,CR76,CX76,CZ76,DB76,DF76,DH76,DJ76,DL76)","v":0},{"$f":"T76+V76+X76+Z76+AD76+AF76+AH76+AJ76+AN76+AP76+AR76+AT76+AX76+AZ76+BB76+BD76+BH76+BJ76+BL76+BN76+BR76+BT76+BV76+BX76+CB76+CD76+CF76+CH76+CL76+CN76+CP76+CR76+CX76+CZ76+DB76+CV76+DF76+DH76+DJ76+DL76","v":0},null,{"$f":"AA76+AK76+AU76+BE76+BO76+BY76+CI76+CS76+DC76+DM76","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S76),ISNUMBER(AA76)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC76),ISNUMBER(AK76)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM76),ISNUMBER(AU76)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW76),ISNUMBER(BE76)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG76),ISNUMBER(BO76)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ76),ISNUMBER(BY76)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA76),ISNUMBER(CI76)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK76),ISNUMBER(CS76)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU76),ISNUMBER(DC76)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE76),ISNUMBER(DM76)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C76=\"g\",HLOOKUP(DP77,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP77,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C76=\"g\",HLOOKUP(DP77,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP77,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ76+DV76+EA76","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN76+DD76+CT76+CJ76+BZ76+BP76+BF76+AV76+AL76+AB76","v":0},{"$f":"EG76/$EG$3","v":0},{"$f":"HLOOKUP(EH76,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L76","v":0},{"$f":"HLOOKUP(EK76,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N76/EG76","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN76,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O76","v":0},{"$f":"HLOOKUP(ES76,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ76-REFERENTIELS!$E$37:$M$37)),ABS(EQ76-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q76","v":0},{"$f":"HLOOKUP(ET76,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI76+EL76+EO76+ER76+EU76","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N76","v":0},{"$f":"COUNTIF(S76:DM78,$FA$2)","v":0},{"$f":"COUNTIF(S76:DM78,$FB$2)","v":0},{"$f":"COUNTIF(S76:DM78,$FC$2)","v":0},{"$f":"COUNTIF(S76:DM78,$FD$2)","v":0},{"$f":"COUNTIF(S76:DM78,$FE$2)","v":0},{"$f":"COUNTIF(S76:DM78,$FF$2)","v":0},{"$f":"COUNTIF(S76:DM78,$FG$2)","v":0},{"$f":"COUNTIF(S76:DM78,$FH$2)","v":0},{"$f":"COUNTIF(S76:DM78,$FI$2)","v":0},{"$f":"COUNTIF(S76:DM78,$FJ$2)","v":0},{"$f":"COUNTIF(S76:DM78,$FK$2)","v":0}]
[]
[]
[26,{"$f":"OFFSET(INDEX(eleves,MATCH(A79,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Xav"},{"$f":"OFFSET(INDEX(eleves,MATCH(A79,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D79:J81,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T79,V79,X79,Z79,AD79,AF79,AH79,AJ79,AN79,AP79,AR79,AT79,AX79,AZ79,BB79,BD79,BH79,BJ79,BL79,BN79,BR79,BT79,BV79,BX79,CB79,CD79,CF79,CL79,CN79,CP79,CR79,CX79,CZ79,DB79,DF79,DH79,DJ79,DL79)","v":0},{"$f":"T79+V79+X79+Z79+AD79+AF79+AH79+AJ79+AN79+AP79+AR79+AT79+AX79+AZ79+BB79+BD79+BH79+BJ79+BL79+BN79+BR79+BT79+BV79+BX79+CB79+CD79+CF79+CH79+CL79+CN79+CP79+CR79+CX79+CZ79+DB79+CV79+DF79+DH79+DJ79+DL79","v":0},null,{"$f":"AA79+AK79+AU79+BE79+BO79+BY79+CI79+CS79+DC79+DM79","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S79),ISNUMBER(AA79)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC79),ISNUMBER(AK79)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM79),ISNUMBER(AU79)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW79),ISNUMBER(BE79)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG79),ISNUMBER(BO79)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ79),ISNUMBER(BY79)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA79),ISNUMBER(CI79)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK79),ISNUMBER(CS79)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU79),ISNUMBER(DC79)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE79),ISNUMBER(DM79)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C79=\"g\",HLOOKUP(DP80,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP80,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C79=\"g\",HLOOKUP(DP80,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP80,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ79+DV79+EA79","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN79+DD79+CT79+CJ79+BZ79+BP79+BF79+AV79+AL79+AB79","v":0},{"$f":"EG79/$EG$3","v":0},{"$f":"HLOOKUP(EH79,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L79","v":0},{"$f":"HLOOKUP(EK79,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N79/EG79","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN79,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O79","v":0},{"$f":"HLOOKUP(ES79,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ79-REFERENTIELS!$E$37:$M$37)),ABS(EQ79-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q79","v":0},{"$f":"HLOOKUP(ET79,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI79+EL79+EO79+ER79+EU79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N79","v":0},{"$f":"COUNTIF(S79:DM81,$FA$2)","v":0},{"$f":"COUNTIF(S79:DM81,$FB$2)","v":0},{"$f":"COUNTIF(S79:DM81,$FC$2)","v":0},{"$f":"COUNTIF(S79:DM81,$FD$2)","v":0},{"$f":"COUNTIF(S79:DM81,$FE$2)","v":0},{"$f":"COUNTIF(S79:DM81,$FF$2)","v":0},{"$f":"COUNTIF(S79:DM81,$FG$2)","v":0},{"$f":"COUNTIF(S79:DM81,$FH$2)","v":0},{"$f":"COUNTIF(S79:DM81,$FI$2)","v":0},{"$f":"COUNTIF(S79:DM81,$FJ$2)","v":0},{"$f":"COUNTIF(S79:DM81,$FK$2)","v":0}]
[]
[]
[27,{"$f":"OFFSET(INDEX(eleves,MATCH(A82,numero,0),MATCH($B$2,classe,0)),0,1)","v":"CC"},{"$f":"OFFSET(INDEX(eleves,MATCH(A82,numero,0),MATCH($B$2,classe,0)),0,2)","v":"f"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D82:J84,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T82,V82,X82,Z82,AD82,AF82,AH82,AJ82,AN82,AP82,AR82,AT82,AX82,AZ82,BB82,BD82,BH82,BJ82,BL82,BN82,BR82,BT82,BV82,BX82,CB82,CD82,CF82,CL82,CN82,CP82,CR82,CX82,CZ82,DB82,DF82,DH82,DJ82,DL82)","v":0},{"$f":"T82+V82+X82+Z82+AD82+AF82+AH82+AJ82+AN82+AP82+AR82+AT82+AX82+AZ82+BB82+BD82+BH82+BJ82+BL82+BN82+BR82+BT82+BV82+BX82+CB82+CD82+CF82+CH82+CL82+CN82+CP82+CR82+CX82+CZ82+DB82+CV82+DF82+DH82+DJ82+DL82","v":0},null,{"$f":"AA82+AK82+AU82+BE82+BO82+BY82+CI82+CS82+DC82+DM82","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S82),ISNUMBER(AA82)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC82),ISNUMBER(AK82)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM82),ISNUMBER(AU82)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW82),ISNUMBER(BE82)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG82),ISNUMBER(BO82)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ82),ISNUMBER(BY82)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA82),ISNUMBER(CI82)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK82),ISNUMBER(CS82)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU82),ISNUMBER(DC82)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE82),ISNUMBER(DM82)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C82=\"g\",HLOOKUP(DP83,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP83,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C82=\"g\",HLOOKUP(DP83,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP83,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ82+DV82+EA82","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN82+DD82+CT82+CJ82+BZ82+BP82+BF82+AV82+AL82+AB82","v":0},{"$f":"EG82/$EG$3","v":0},{"$f":"HLOOKUP(EH82,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L82","v":0},{"$f":"HLOOKUP(EK82,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N82/EG82","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN82,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O82","v":0},{"$f":"HLOOKUP(ES82,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ82-REFERENTIELS!$E$37:$M$37)),ABS(EQ82-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q82","v":0},{"$f":"HLOOKUP(ET82,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI82+EL82+EO82+ER82+EU82","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N82","v":0},{"$f":"COUNTIF(S82:DM84,$FA$2)","v":0},{"$f":"COUNTIF(S82:DM84,$FB$2)","v":0},{"$f":"COUNTIF(S82:DM84,$FC$2)","v":0},{"$f":"COUNTIF(S82:DM84,$FD$2)","v":0},{"$f":"COUNTIF(S82:DM84,$FE$2)","v":0},{"$f":"COUNTIF(S82:DM84,$FF$2)","v":0},{"$f":"COUNTIF(S82:DM84,$FG$2)","v":0},{"$f":"COUNTIF(S82:DM84,$FH$2)","v":0},{"$f":"COUNTIF(S82:DM84,$FI$2)","v":0},{"$f":"COUNTIF(S82:DM84,$FJ$2)","v":0},{"$f":"COUNTIF(S82:DM84,$FK$2)","v":0}]
[]
[]
[28,{"$f":"OFFSET(INDEX(eleves,MATCH(A85,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Barby"},{"$f":"OFFSET(INDEX(eleves,MATCH(A85,numero,0),MATCH($B$2,classe,0)),0,2)","v":"f"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D85:J87,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T85,V85,X85,Z85,AD85,AF85,AH85,AJ85,AN85,AP85,AR85,AT85,AX85,AZ85,BB85,BD85,BH85,BJ85,BL85,BN85,BR85,BT85,BV85,BX85,CB85,CD85,CF85,CL85,CN85,CP85,CR85,CX85,CZ85,DB85,DF85,DH85,DJ85,DL85)","v":0},{"$f":"T85+V85+X85+Z85+AD85+AF85+AH85+AJ85+AN85+AP85+AR85+AT85+AX85+AZ85+BB85+BD85+BH85+BJ85+BL85+BN85+BR85+BT85+BV85+BX85+CB85+CD85+CF85+CH85+CL85+CN85+CP85+CR85+CX85+CZ85+DB85+CV85+DF85+DH85+DJ85+DL85","v":0},null,{"$f":"AA85+AK85+AU85+BE85+BO85+BY85+CI85+CS85+DC85+DM85","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S85),ISNUMBER(AA85)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC85),ISNUMBER(AK85)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM85),ISNUMBER(AU85)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW85),ISNUMBER(BE85)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG85),ISNUMBER(BO85)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ85),ISNUMBER(BY85)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA85),ISNUMBER(CI85)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK85),ISNUMBER(CS85)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU85),ISNUMBER(DC85)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE85),ISNUMBER(DM85)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C85=\"g\",HLOOKUP(DP86,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP86,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C85=\"g\",HLOOKUP(DP86,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP86,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ85+DV85+EA85","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN85+DD85+CT85+CJ85+BZ85+BP85+BF85+AV85+AL85+AB85","v":0},{"$f":"EG85/$EG$3","v":0},{"$f":"HLOOKUP(EH85,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L85","v":0},{"$f":"HLOOKUP(EK85,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N85/EG85","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN85,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O85","v":0},{"$f":"HLOOKUP(ES85,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ85-REFERENTIELS!$E$37:$M$37)),ABS(EQ85-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q85","v":0},{"$f":"HLOOKUP(ET85,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI85+EL85+EO85+ER85+EU85","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N85","v":0},{"$f":"COUNTIF(S85:DM87,$FA$2)","v":0},{"$f":"COUNTIF(S85:DM87,$FB$2)","v":0},{"$f":"COUNTIF(S85:DM87,$FC$2)","v":0},{"$f":"COUNTIF(S85:DM87,$FD$2)","v":0},{"$f":"COUNTIF(S85:DM87,$FE$2)","v":0},{"$f":"COUNTIF(S85:DM87,$FF$2)","v":0},{"$f":"COUNTIF(S85:DM87,$FG$2)","v":0},{"$f":"COUNTIF(S85:DM87,$FH$2)","v":0},{"$f":"COUNTIF(S85:DM87,$FI$2)","v":0},{"$f":"COUNTIF(S85:DM87,$FJ$2)","v":0},{"$f":"COUNTIF(S85:DM87,$FK$2)","v":0}]
[]
[]
[29,{"$f":"OFFSET(INDEX(eleves,MATCH(A88,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Jo"},{"$f":"OFFSET(INDEX(eleves,MATCH(A88,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D88:J90,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T88,V88,X88,Z88,AD88,AF88,AH88,AJ88,AN88,AP88,AR88,AT88,AX88,AZ88,BB88,BD88,BH88,BJ88,BL88,BN88,BR88,BT88,BV88,BX88,CB88,CD88,CF88,CL88,CN88,CP88,CR88,CX88,CZ88,DB88,DF88,DH88,DJ88,DL88)","v":0},{"$f":"T88+V88+X88+Z88+AD88+AF88+AH88+AJ88+AN88+AP88+AR88+AT88+AX88+AZ88+BB88+BD88+BH88+BJ88+BL88+BN88+BR88+BT88+BV88+BX88+CB88+CD88+CF88+CH88+CL88+CN88+CP88+CR88+CX88+CZ88+DB88+CV88+DF88+DH88+DJ88+DL88","v":0},null,{"$f":"AA88+AK88+AU88+BE88+BO88+BY88+CI88+CS88+DC88+DM88","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S88),ISNUMBER(AA88)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC88),ISNUMBER(AK88)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM88),ISNUMBER(AU88)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW88),ISNUMBER(BE88)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG88),ISNUMBER(BO88)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ88),ISNUMBER(BY88)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA88),ISNUMBER(CI88)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK88),ISNUMBER(CS88)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU88),ISNUMBER(DC88)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE88),ISNUMBER(DM88)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C88=\"g\",HLOOKUP(DP89,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP89,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C88=\"g\",HLOOKUP(DP89,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP89,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ88+DV88+EA88","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN88+DD88+CT88+CJ88+BZ88+BP88+BF88+AV88+AL88+AB88","v":0},{"$f":"EG88/$EG$3","v":0},{"$f":"HLOOKUP(EH88,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L88","v":0},{"$f":"HLOOKUP(EK88,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N88/EG88","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN88,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O88","v":0},{"$f":"HLOOKUP(ES88,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ88-REFERENTIELS!$E$37:$M$37)),ABS(EQ88-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q88","v":0},{"$f":"HLOOKUP(ET88,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI88+EL88+EO88+ER88+EU88","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N88","v":0},{"$f":"COUNTIF(S88:DM90,$FA$2)","v":0},{"$f":"COUNTIF(S88:DM90,$FB$2)","v":0},{"$f":"COUNTIF(S88:DM90,$FC$2)","v":0},{"$f":"COUNTIF(S88:DM90,$FD$2)","v":0},{"$f":"COUNTIF(S88:DM90,$FE$2)","v":0},{"$f":"COUNTIF(S88:DM90,$FF$2)","v":0},{"$f":"COUNTIF(S88:DM90,$FG$2)","v":0},{"$f":"COUNTIF(S88:DM90,$FH$2)","v":0},{"$f":"COUNTIF(S88:DM90,$FI$2)","v":0},{"$f":"COUNTIF(S88:DM90,$FJ$2)","v":0},{"$f":"COUNTIF(S88:DM90,$FK$2)","v":0}]
[]
[]
[30,{"$f":"OFFSET(INDEX(eleves,MATCH(A91,numero,0),MATCH($B$2,classe,0)),0,1)","v":"Nico T."},{"$f":"OFFSET(INDEX(eleves,MATCH(A91,numero,0),MATCH($B$2,classe,0)),0,2)","v":"g"},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(D91:J93,\"oui\")=7,6,0)","v":0},null,{"$f":"COUNTA(T91,V91,X91,Z91,AD91,AF91,AH91,AJ91,AN91,AP91,AR91,AT91,AX91,AZ91,BB91,BD91,BH91,BJ91,BL91,BN91,BR91,BT91,BV91,BX91,CB91,CD91,CF91,CL91,CN91,CP91,CR91,CX91,CZ91,DB91,DF91,DH91,DJ91,DL91)","v":0},{"$f":"T91+V91+X91+Z91+AD91+AF91+AH91+AJ91+AN91+AP91+AR91+AT91+AX91+AZ91+BB91+BD91+BH91+BJ91+BL91+BN91+BR91+BT91+BV91+BX91+CB91+CD91+CF91+CH91+CL91+CN91+CP91+CR91+CX91+CZ91+DB91+CV91+DF91+DH91+DJ91+DL91","v":0},null,{"$f":"AA91+AK91+AU91+BE91+BO91+BY91+CI91+CS91+DC91+DM91","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(S91),ISNUMBER(AA91)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AC91),ISNUMBER(AK91)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AM91),ISNUMBER(AU91)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(AW91),ISNUMBER(BE91)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BG91),ISNUMBER(BO91)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(BQ91),ISNUMBER(BY91)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CA91),ISNUMBER(CI91)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CK91),ISNUMBER(CS91)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(CU91),ISNUMBER(DC91)),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(DE91),ISNUMBER(DM91)),1,0)","v":0},null,null,{"$f":"IF($DQ$2=\"N3\",IF(C91=\"g\",HLOOKUP(DP92,REFERENTIELS!$F$8:$M$9,2,FALSE),HLOOKUP(DP92,REFERENTIELS!$F$8:$M$10,3,FALSE)),IF(C91=\"g\",HLOOKUP(DP92,REFERENTIELS!$F$20:$M$21,2,FALSE),HLOOKUP(DP92,REFERENTIELS!$F$20:$M$22,3,FALSE)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ91+DV91+EA91","v":{"$error":"#N/A"}},null,null,null,{"$f":"DN91+DD91+CT91+CJ91+BZ91+BP91+BF91+AV91+AL91+AB91","v":0},{"$f":"EG91/$EG$3","v":0},{"$f":"HLOOKUP(EH91,REFERENTIELS!$E$31:$M$32,2,TRUE)","v":0},null,{"$f":"L91","v":0},{"$f":"HLOOKUP(EK91,REFERENTIELS!$D$33:$M$34,2,FALSE)","v":0},null,{"$f":"N91/EG91","v":{"$error":"#DIV/0!"}},{"$f":"HLOOKUP(EN91,REFERENTIELS!$D$35:$M$36,2,TRUE)","v":{"$error":"#DIV/0!"}},null,{"$f":"O91","v":0},{"$f":"HLOOKUP(ES91,REFERENTIELS!$E$37:$M$38,2,FALSE)","v":0},{"$f":"INDEX(REFERENTIELS!$E$37:$M$37,MATCH(MIN(ABS(EQ91-REFERENTIELS!$E$37:$M$37)),ABS(EQ91-REFERENTIELS!$E$37:$M$37),0))","v":0},{"$f":"Q91","v":0},{"$f":"HLOOKUP(ET91,REFERENTIELS!$E$39:$M$40,2,TRUE)","v":0},null,{"$f":"EI91+EL91+EO91+ER91+EU91","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N91","v":0},{"$f":"COUNTIF(S91:DM93,$FA$2)","v":0},{"$f":"COUNTIF(S91:DM93,$FB$2)","v":0},{"$f":"COUNTIF(S91:DM93,$FC$2)","v":0},{"$f":"COUNTIF(S91:DM93,$FD$2)","v":0},{"$f":"COUNTIF(S91:DM93,$FE$2)","v":0},{"$f":"COUNTIF(S91:DM93,$FF$2)","v":0},{"$f":"COUNTIF(S91:DM93,$FG$2)","v":0},{"$f":"COUNTIF(S91:DM93,$FH$2)","v":0},{"$f":"COUNTIF(S91:DM93,$FI$2)","v":0},{"$f":"COUNTIF(S91:DM93,$FJ$2)","v":0},{"$f":"COUNTIF(S91:DM93,$FK$2)","v":0}]

{"sheet":"REFERENTIELS","index":2,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[38,1,39,1],[38,2,39,2],[36,1,37,1],[36,2,37,2],[27,1,27,2],[30,1,31,1],[30,2,31,2],[32,1,33,1],[32,2,33,2],[34,1,35,1],[34,2,35,2],[27,3,27,12],[28,1,28,2],[28,3,28,12],[29,7,29,12],[29,3,29,6],[3,1,3,2],[3,3,3,12],[4,1,4,2],[4,3,4,12],[5,3,5,5],[5,6,5,12],[6,1,9,1],[6,2,9,2],[6,3,6,12],[7,3,7,4],[10,3,10,5],[10,6,10,12],[11,3,11,5],[11,6,11,12],[15,1,15,2],[15,3,15,12],[16,1,16,2],[16,3,16,12],[17,3,17,5],[18,1,21,1],[18,2,21,2],[19,3,19,4],[17,6,17,12],[18,3,18,12],[22,9,22,12],[23,9,23,12],[23,3,23,5],[22,3,22,5],[22,6,22,8],[23,6,23,8]]}
[]
[]
[]
[null,"COMPETENCES ATTENDUES",null,"PRINCIPES D’ELABORATION DE L’EPREUVE"]
[null,"Niveau 3:\nPour  grimper  en  moulinette  des  voies  de  difficulté  4  à  5,  se dominer   et      conduire   son   déplacement   en   s'adaptant   à différentes formes de prises et de support.\nAssurer sa sécurité et celle d'autrui à la montée comme à la descente.",null,"Le dispositif  comprend des voies de niveau 3c à 5c pour les filles et de 4a à 6a pour les garçons, d’une longueur minimale de 7 m en SAE et 12 m en falaise.\nLe candidat choisit son niveau de difficulté selon la modalité d’ascension  en moulinette avec une boucle pincée 1 mètre au dessus du baudrier par un élastique ou sans boucle, dans une voie plus ou moins connue.\nL’épreuve  consiste  à    s’équiper,  s’encorder    puis  grimper   dans  un  temps  maximum  de  8  minutes. L’épreuve est complétée par une prestation d’assurage  au cours  du grimper d’un partenaire.\nA la première chute, le candidat peut reprendre sa progression. A la seconde chute, l’épreuve s’arrête. Dans  le cas d’un  arrêt  de l’épreuve,  le candidat  marque les  points  en  fonction  de  la  hauteur de  voie gravie.  Les  points  accordés  à  la  cotation  seront  obligatoirement  inférieurs  à  la  moitié  des  points possibles selon la cotation."]
[null,"POINTS A AFFECTER","ELEMENTS A EVALUER","NIVEAU 3 EN COURS D’ACQUISITION\nDe 0 à 9 pts",null,null,"DEGRE D’ACQUISITION DU  NIVEAU 3\nde 10 à 20 pts"]
[null,"12 Points","Cotation de l’itinéraire choisi.","Points attribués en fonction de la cotation de la voie."]
[null,null,null,"COTATION",null,"3c","4a","4b","4c","5a","5b","5c","6a"]
[null,null,null,"Garçons","Moulinette",null,6,7,8,9,10,11,12]
[null,null,null,"Filles","Moulinette",6,7,8,9,10,11,12]
[null,"4 Points","Coordination de l’action Grimper/ s’assurer.","Réalisation de la voie sans boucle pincée.\nAu-delà des 8 minutes. Ascension corde tendue.\nRedescente irrégulière en cherchant à retrouver la verticalité.",null,null,"Réalisation de la voie sans faire sauter la boucle pincée. Fluidité du parcours.\nRedescente en acceptant d’éloigner le buste de la paroi. Redescente régulière et fluide (espace arrière construit)."]
[null,"4 Points","Coordinations des actions assureur/grimpeur.","En moulinette,  assurage en 4 temps avec une tension irrégulière (trop de mou ou la boucle pincée saute).",null,null,"Assurage en contrôlant  la tension de la corde (la boucle pincée ne saute pas).\nAssurage sans décalage avec la progression du grimpeur. Communication efficace."]
[]
[]
[]
[null,"COMPETENCES ATTENDUES",null,"PRINCIPES D’ELABORATION DE L’EPREUVE"]
[null,"Niveau 4 :\nPour grimper en tête des voies de difficulté 4 à 5, conduire son déplacement en s'économisant selon des itinéraires variés en direction.\nAssurer sa sécurité et celle d'autrui à la montée comme à la descente.",null,"Le dispositif  comprend des voies de niveau 3c à 6a, d’une longueur minimale de 7 m en SAE et 12 m en falaise. Les dégaines sont en place.\nLe candidat choisit son niveau de difficulté pour grimper en tête dans 1 ou 2 voies  connues.\nL’épreuve consiste à se préparer, s’équiper  puis grimper  dans un temps maximum de 8 mn (par voie). L’épreuve est complétée par une prestation d’assurage au cours  du grimper du partenaire\nA la 1ére chute, le candidat peut reprendre sa progression. A la seconde chute, l’épreuve s’arrête. L’épreuve s’arrête si le candidat ne mousquetonne pas tous les points.\nDans le cas d’un arrêt de l’épreuve, le candidat marque les points en fonction de la hauteur de voie gravie. Les points accordés à la cotation seront obligatoirement inférieurs à la moitié des points possibles selon la cotation."]
[null,"POINTS A AFFECTER","ELEMENTS A EVALUER","NIVEAU 4 EN COURS D’ACQUISITION\nDe 0 à 9 pts",null,null,"DEGRE D’ACQUISITION DU  NIVEAU 4\nde 10 à 20"]
[null,"14 Points","Cotation de l’itinéraire choisi.","Points attribués en fonction de la cotation de la voie."]
[null,null,null,"COTATION",null,"3c","4a","4b","4c","5a","5b","5c","6a"]
[null,null,null,"Garçons","En tête",6,8,10,11,12,13,13.5,14]
[null,null,null,"Filles","En tête",7,9,11,12,13,13.5,14]
[null,"3 Points","Coordination de l’action Grimper/ s’assurer.","Mousquetonnage à l’envers (vrillé)\nredescente irrégulière en cherchant à retrouver la verticalité",null,null,"Mousquetonnage hésitant mais correct\nredescente en acceptant d’éloigner le buste/paroi",null,null,"Mousquetonnage intégré dans la progression (rapidité, économie) redescente régulière et fluide (espace arrière construit"]
[null,"3 Points","Coordinations des actions assureur/grimpeur.","Assure  mais donne et reprend le mou avec retard",null,null,"Assure en contrôlant  la tension de la corde.\nAssure sans décalage avec la progression du grimpeur.",null,null,"Donne et reprend le mou dans la progression du grimpeur"]
[]
[]
[]
[null,"EVALUATION CYCLE",null,"PRINCIPES D’ELABORATION DE L’EPREUVE"]
[null,"Etre assidu en cours. Chercher à progresser et à se dépasser en essayant de réaliser un maximum de voies. Evoluer en toute sécurité en conservant ses permis et ses points. ",null,"Les élèves doivent valider des permis de grimper et d'assurer avant de pouvoir évoluer sur le mur. Ils disposent ensuite de 6 pts qui peuvent être perdus selon leur manque au règle de sécurité de la salle. ILs relèvent l'ensemble des voies réalisées au fil des séances. Leur progression et leur persévérence "]
[null,"POINTS A AFFECTER","ELEMENTS A EVALUER","NIVEAU  EN COURS D’ACQUISITION\nDe 0 à 9 pts",null,null,null,"DEGRE D’ACQUISITION DU  NIVEAU  de 10 à 20 pts"]
[null,"2pts","Nombre de séances réalisées","% séances (%)",0,0.3,0.45,0.5,0.6,0.7,0.8,0.9,1]
[null,null,null,"Points attribués",0,0.1,0.25,0.5,1,1.25,1.5,1.75,2]
[null,"6 pts","Points restants sur le permis","Pts restants",0,1,2,3,4,5,6]
[null,null,null,"Points attribués",0,1,2,3,4,5,6]
[null,"4 pts","Nombre de voies moyen réalisés par séance","Nb moyen voies ",0,0.5,1,1.5,2,2.5,3]
[null,null,null,"Points attribués",0,1,2,2.5,3,3.5,4]
[null,"4 pts","Hauteur grimpée","Hauteur totale grimpée (m)",0,40,60,80,120,160,180,240]
[null,null,null,"Points attribués",0,1,1.5,2,2.5,3,3.5,4,5783]
[null,"4 pts","Voies assurées","Nb de voies assurées",0,4,6,8,11,14,17,20]
[null,null,null,"Points attribués",0,1,1.5,2,2.5,3,3.5,4]

{"sheet":"SECU","index":3,"n_rows":61,"n_cols":4,"rows_kept":61,"cut":false,"hidden":false,"merged":[[12,1,12,3],[30,1,30,3],[1,1,1,3],[4,1,4,3],[16,1,16,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[13,1,13,3],[14,1,14,3],[25,1,25,3],[28,1,28,3],[53,1,53,3],[58,1,58,3],[59,1,59,3],[31,1,31,3],[17,1,17,3],[26,1,26,3],[27,1,27,3],[34,1,34,3],[50,1,50,3],[51,3,52,3],[32,1,32,3]]}
[]
[null,"REGLES DE SECURITE EN ESCALADE"]
[null,"LE GRIMPEUR",null,"L'ASSUREUR"]
[]
[null,"Avant le cours"]
[null,"S’assurer que le matériel est en état. S’assurer que le mur et les cordes soient bien fixés. "]
[null,"S’assurer que des tapis entourent la zone de grimpe. Ils permettent d’amortir les corps en cas de chutes. "]
[null,"S’assurer que rien n’encombre les tapis (qu’aucun matériel ne traine) afin d’assurer la réception du grimpeur et que personne ne se prenne les pieds."]
[]
[null,"Avant la grimpe"]
[null,"Avoir une tenue adaptée: cheveux attachés, bagues et bracelets interdits, vestes et gilets posés, chewing gum jetés."]
[null,"S’échauffer."]
[null,"Mettre son baudrier"]
[null,"Savoir mettre un baudrier : se met comme un slip, le « pontet » devant, je desserre toutes les sangles, j’enfile la ceinture et je passe les jambières. Je remonte la ceinture au dessus des épines iliaques (taille plus fine qu’aux hanches) et je serre. Ensuite je serre les jambes (en dernier !), les sangles avant des jambières doivent être à plat. Je coince le restant de ceinture dans le dos pour ne pas être gêné et le  « porte matériel » sur le côté. Aidez et vérifiez le baudrier des deux autres. "]
[null,"S’assurer que tous les élèves ont mis leur baudrier à l’endroit et est serré convenablement. "]
[null,"DEMANDER A L'ENSEIGNANT \nDE LES VERIFIER UN PAR UN"]
[]
[]
[]
[null,"Réaliser un double noeud de 8"]
[null,"Savoir « s’encorder » : « nœud de 8 » et « nœud d’arrêt » : je prends le bout de la corde, j’utilise une longueur équivalente à la hauteur de mon aisselle au sol. Je fais une boucle et je la tourne d’un tour complet, je prends le bout de la corde et je la passe dans cette boucle (j’obtiens un nœud en forme de 8). Je passe le bout de la corde dans mon pontet et je vais suivre exactement la corde en sens inverse (ou faire une parallèle à la première corde en partant de mon pontet) en gardant une longueur de corde entre le nœud et le baudrier d’une main. A la sortie j’ai environ 15 à 20 cm de corde, je fais un nœud d’arrêt (nœud simple en prenant les deux cordes) en appui sur le nœud de 8. \nATTENTION ne jamais laisser un nœud sur une corde !\n"]
[null,null,null,"Vérifier le nœud de 8 du grimpeur"]
[null,null,null,"Préparer son matériel d'assurage"]
[null,"Vérifier que l’assureur ait placé la corde dans le bon sens à l’intérieur du panier et dans le moursqueton vissé",null,"Placer les 2 brins de corde dans le même trou du panier. Faire passer la boucle du panier dans le mousqueton avec la anse du panier.  Visser le mousqueton."]
[null,null,null," "]
[null,"VERIFICATIONS"]
[null,"Vérifier que le grimpeur et l’assureur peuvent agir en sécurité. Le grimpeur et l’assureur peuvent se vérifier eux-mêmes avant d’être vérifiés par le professeur. "]
[null,"Vérifier que les cordes ne soient pas entortillées."]
[null,"Vérifier si le grimpeur est bien relié par la même corde à l’assureur."]
[]
[null,"Durant la grimpe et la descente"]
[null,"AVOIR UN LANGAGE COMMUN"]
[null,"Les 2 partenaires doivent se mettre d'accord sur un langage commun :  \"DEPART\"-\"AVALE\"-\"SEC\"-\"DU MOU\""]
[null,"Le grimpeur doit annoncer son départ : \"DEPART\"",null,"Et le grimpeur doit préciser qu'il est : \"PRÊT\""]
[null,"Le grimpeur et l’assureur doivent communiquer pour faire savoir l’un à l’autre ce qu’ils veulent (Prévenir la chute, avoir du mou ou pas…)."]
[null,"ATTITUDE DU GRIMPEUR",null,"ATTITUDE DE L'ASSUREUR"]
[null,"Vérifier que personne ne soit au-dessus ou au-dessous du grimpeur.",null," L’assureur doit être sûr de ses appuis en les encrant au sol par une fente avant. Jambe avant opposée au côté de la corde. "]
[null," Le grimpeur choisit une voie à son niveau.",null,"L’assureur doit se concentrer sur la grimpe de son partenaire, prêt à retenir une chute à tout moment. Jambes légèrement fléchies et décalées."]
[null," En haut de la voie ne pas mettre ses mains dans les mousquetons accrochés."]
[null," Le grimpeur doit prévenir son assureur s’il veut arrêter sa grimpe et non se jeter dans le vide.",null,"L’assureur ne doit pas quitter les yeux sont partenaires. "]
[null,null,null,"L’assureur doit effectuer une manœuvre précise pour assurer son partenaire (Avaler, tirer, croiser, décroiser, tirer). "]
[null,null,null,"L’assureur ne doit pas trop être près du mur pour ne pas gêner le grimpeur avec la corde."]
[null,null,null,"L’assureur peut être soutenu par un contre assureur qui doit lui aussi être concentré sur le grimpeur. Il ne devra pas être collé à l’assureur pour lui laisser de l’espace dans la réalisation de sa manœuvre. Il tient le mou de la corde. "]
[null,null,null,"REALISER LES 5 TEMPS"]
[]
[]
[]
[]
[null,null,null,"L’assurage s’effectue en cinq temps comme suit :\n1-La main gauche est située le plus haut possible sur le brin de corde allant vers le haut.\nLa main droite est située le plus près possible du huit sur le brin allant vers le bas (corde de vie).\n2-J’avale le mou de la corde avec les deux mains. La main droite vient s’élever au dessus du huit, tandis que la main gauche vient près du huit, tout en avalant la corde.\n3-Je bloque. La main droite vient s’abaisser en dessous du huit.\n4-Je me prépare à changer de main. La main gauche vient se placer, par un mouvement de gauche à droite par en dessous du huit, au dessus de la main droite sur la corde de vie\n5-Je change de main. La main droite vient se placer au dessus de la main gauche sur la corde de vie, le plus près possible du huit.\n"]
[null,null,null,"NE JAMAIS LACHER LA CORDE DE VIE"]
[null,"EN CAS DE CHUTE"]
[null,"En cas de chute, le grimpeur doit se remettre face au mur et tenter de se stabiliser avec les mains et les pieds contre le mur. ",null,"RESTER VIGILANT ET MAINTENIR LE GRIMPEUR EN POSITION STABILISEE"]
[null,"En cas de chute, le grimpeur ne doit pas se rattraper à la corde. "]
[null,"PRECISIONS POUR LA DESCENTE "]
[null,"Lors de la descente, le grimpeur doit être face au mur et doit avoir les pieds sur le mur mais le bassin et les mains décollés pour ne pas râper son corps contre celui-ci.",null,"La descente doit être fluide et régulière "]
[]
[null,"Il reste calme et fait confiance à son partenaire",null,"Les 2 mains sont placées sur la CORDE DE VIE et réalisent des mouvements alternatifs : je donne du mou main droite et je rattrape main gauche, je donne du mou main gauche et je rettrape main droite"]
[]
[null,"APRES LA GRIMPE"]
[null,"Ranger son matériel"]
[null,"Valider la voie réussie",null,"Valider le nombre de voie assurée"]

{"sheet":"DEBUT","index":4,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"VOIES","COTATION VOIES","COULEURS","VALIDE","Hauteur validée","Pts permis","sexe","Niveaux","pts"]
[null,null,null,null,"oui",null,null,"g","N3"]
[null,1,"Toutes","Blanche","non",3,6,"f","N4",0]
[null,2,"3c","Bleue ","en cours",5,5,null,null,1]
[null,3,"4a","Jaune",null,7,null,null,null,2]
[null,4,"4b","Noire",null,9,4,null,null,3]
[null,5,"4c","Orange",null,11,3,null,null,4]
[null,6,"5a","Rose ",null,13,null,null,null,5]
[null,7,"5b","Rouge",null,15,2,null,null,6]
[null,8,"5c","Verte",null,null,1,null,null,7]
[null,9,"6a","Violette",null,1,0,null,null,8]
[null,10,"6b","Bleues C.",null,2,null,null,null,9]
[null,11,"6c","Noires C.",null,4,null,null,null,10]
[null,12,null,"Rouges C.",null,6,null,null,null,11]
[null,13,null,null,null,8,null,null,null,12]
[null,14,null,null,null,10,null,null,null,13]
[null,15,null,null,null,12,null,null,null,14]
[null,16,null,null,null,null,null,null,null,15]
[null,17,null,null,null,null,null,null,null,16]
[null,18,null,null,null,null,null,null,null,17]
[null,19,null,null,null,null,null,null,null,18]
[null,20,null,null,null,null,null,null,null,19]
[null,21,null,null,null,null,null,null,null,20]

{"sheet":"APPEL","index":5,"n_rows":38,"n_cols":28,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,19,0,20],[0,22,0,23],[0,25,0,26],[0,1,0,2],[0,4,0,5],[0,7,0,8],[0,10,0,11],[0,13,0,14],[0,16,0,17]]}
[null,"TELEC",null,null,"1PROE",null,null,"TGA",null,null,"1EVS",null,null,"1GA",null,null,"1TU",null,null,"STAGE"]
[null,"NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe"]
[1,null,"Abdelbasset","g",null,"Abdelwahid","g",null,"Bertile","f",null,"Abir","f",null,"Camille","f",null,"Amir","g",null,"Alexandre","g"]
[2,null,"Alen","g",null,"Ali","g",null,"Chirine","f",null,"Adama","g",null,"Emilie","f",null,"Badrane","g",null,"Alexis F.","g"]
[3,null,"Bilal","g",null,"Fares","g",null,"Isma","f",null,"Elfeta","f",null,"Gehna","f",null,"Emre","g",null,"Anthony","g"]
[4,null,"Christian","g",null,"Gilles","g",null,"Jihenne","f",null,"Faiz","g",null,"Ismeta","f",null,"Hedi","g",null,"Christian","g"]
[5,null,"Halis","g",null,"Haykel","g",null,"Kandji","f",null,"Fares","g",null,"Janette","f",null,"Mansour","g",null,"Claudine","f"]
[6,null,"Laurent","g",null,"Mohamed","g",null,"Kenza","f",null,"Hocine","g",null,"Jenna","f",null,"Mounia","g",null,"Emmanuel","g"]
[7,null,"Madjid","g",null,"Mohamed","g",null,"Khayra","f",null,"Imen","f",null,"Juliana","f",null,"Mustafa","g",null,"Eric","g"]
[8,null,"Mickael","g",null,"Mohamed","g",null,"Liddia","f",null,"Jenny","f",null,"Kelly","f",null,"Sombate rothanak","g",null,"Fred","g"]
[9,null,"Salim","g",null,"Phi tram","g",null,"Louiza","f",null,"Jennyline","f",null,"Laura","f",null,"Wail","g",null,"Gwen","g"]
[10,null,"Willy","g",null,"Ryad","g",null,"Lydia","f",null,"Kévin","g",null,"Lea","f",null,"Yohann","g",null,"Julien","g"]
[11,null,null,null,null,"Xhorxh","g",null,"Margarita","f",null,"Melvine","f",null,"Linda","f",null,"Zayd","g",null,"Laurent","g"]
[12,null,null,null,null,"Yassine","g",null,"Mouna","f",null,"Nesrine","f",null,"Maïssane","f",null,null,null,null,"Marc-Antoine","g"]
[13,null,null,null,null,"Quitino ",null,null,"Nadia","f",null,"Ruth","f",null,"Mélinda","f",null,null,null,null,"Marco","g"]
[14,null,null,null,null,null,null,null,"Naila","f",null,"Sabrina","f",null,"Meltem","f",null,null,null,null,"Morgane","f"]
[15,null,null,null,null,null,null,null,"Naoures","f",null,"Sandra","f",null,"Morgane","f",null,null,null,null,"Nathalie","f"]
[16,null,null,null,null,null,null,null,"Nessrine","f",null,"Siwar","f",null,"Naomie","f",null,null,null,null,"Nico Afriat","g"]
[17,null,null,null,null,null,null,null,"Noemie","f",null,"Suleyman","g",null,"Nejma","f",null,null,null,null,"Nico Podu","g"]
[18,null,null,null,null,null,null,null,"Sarinece","f",null,null,null,null,"Nore-ymen","f",null,null,null,null,"Olivier","g"]
[19,null,null,null,null,null,null,null,"Sofia","f",null,null,null,null,"Rachda","f",null,null,null,null,"Pascal","g"]
[20,null,null,null,null,null,null,null,"Thais sirine","f",null,null,null,null,"Sauraya","f",null,null,null,null,"Phil G.","g"]
[21,null,null,null,null,null,null,null,"Victoria","f",null,null,null,null,"Sibel","f",null,null,null,null,"Philippe G.","g"]
[22,null,null,null,null,null,null,null,"Wiem","f",null,null,null,null,"Wacilla","f",null,null,null,null,"Stef","g"]
[23,null,null,null,null,null,null,null,"Ynès","f",null,null,null,null,"Yosr","f",null,null,null,null,"Thomas","g"]
[24,null,null,null,null,null,null,null,"Zineb","f",null,null,null,null,"Zekiye","f",null,null,null,null,"Tristan","g"]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vivien","g"]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Xav","g"]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CC","f"]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barby","f"]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jo","g"]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nico T.","g"]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steven","g"]
[32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cyrilinou","g"]
[33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mick","g"]
[34]
[35]
[36]