{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Formulaire","Archives","Sixième","Première","Terminale","Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"Formulaire","index":0,"n_rows":16,"n_cols":26,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,4,14,5],[13,4,13,5],[1,1,1,8],[5,6,5,7],[8,6,8,7],[4,6,4,7],[7,6,7,7],[5,2,5,3],[11,2,11,5]]}
[]
[null,"Formulaire d'inscription\n(Tous les champs sont obligatoires)"]
[]
[null,null,null,null,null,null,null,"Sexe",null,null,null,null,null,null,null,null,"6ème"]
[null,null,"Nom de famille",null,null,null,"Prénoms",null,null,null,null,null,null,"Nom de famille",null,null,"5ème",null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,null,null,null,"Passant ",{"$f":"IF(G6=\"\",\"nok\",\"\")","v":"nok"},"Prénom",null,null,"4ème","ANNEE SCOLAIRE",null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,"Doublant",{"$f":"IF(C9=\"\",\"nok\",\"\")","v":"nok"},"Classe",null,null,"3ème"]
[null,null,"Classe",null,"Age",null,"Etablissement de provenance",null,null,null,null,"Exclu",{"$f":"IF(E9=\"\",\"nok\",\"\")","v":"nok"},"Age",null,null,"2nde",null,"2020    -    2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G9=\"\",\"nok\",\"\")","v":"nok"},"Ets de provenance",null,null,"1ère"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C12=\"\",\"nok\",\"\")","v":"nok"},"adresse",null,null,"Tle"]
[null,null,"Adresse",null,null,null,null,"Statut",null,null,null,null,{"$f":"IF(H12=\"\",\"nok\",\"\")","v":"nok"},"statut",null,null,"Autres"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15=\"\",\"nok\",\"\")","v":"nok"},"naissance"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E15=\"\",\"nok\",\"\")","v":"nok"},"parent"]
[null,null,"Naissance",null,"Parent",null,null,"Téléphone",null,null,null,null,{"$f":"IF(H15=\"\",\"nok\",\"\")","v":"nok"},"telephone"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I4=\"\",\"nok\",\"\")","v":"nok"},"Sexe"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(M5:M15,\"nok\")","v":10}]

{"sheet":"Archives","index":1,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Nom ","Prénom","Classe","Age","Ets de Provenance","Adresse","Statut","Date de naissance","Nom du Parent","Téléphone","Sexe"]
[null,null,"jkgb jh","bien","6ème",15,"lolo","molm jkgbbgqdlkh","Passant ","2015-08-15","hfvjytfchkkfgbjgyri",565845586,"F"]
[null,null,"jkgb jh","super","6ème",17,"lolo neou","mal arrier","Doublant","2012-10-10","linhetuetb",585458563,"G"]
[null,null,"moi","bein","4ème",9,"juinhsgrz","ljhbkfge;fjgbksgfjzfj","Exclu","2011-12-11","koinhjhsgre",568974523,"F"]
[null,null,"soki","jkhn","6ème",11,"jhbgfjbhgc","hgrftvfbgkhg","Passant ","2015-05-15","jhgfvhufkjuygyuuik",78965485,"F"]
[null,null,"test","jiji","5ème",12,"cs dgegf","ghjhklkluilululm","Passant ","2001-12-14","gjhkhkhkk",7853556383,"G"]
[null,null,"Test2","Maurice","3ème",15,"CEG le MERIDIEN","OCOTOMEY ZOUNGA","Passant ","1990-09-22","ZANGBA FELICIEN",66820438,"G"]
[null,null,"test3","loi","3ème",15,"klh","jhfvtcjhfvubj","PASSANT ","2015-08-15","hhfvhbvjdtjfkhjftd",978825554,"g"]
[null,null,"ana","lolio","3ème",12,"jgbk","fgdscfg fkhjg l","Passant ","2012-02-15"," fdjhhbkjn:k",58471526,"F"]

{"sheet":"Sixième","index":2,"n_rows":80,"n_cols":82,"rows_kept":80,"cut":false,"hidden":false,"merged":[[14,10,14,11],[5,14,6,15],[5,16,6,16],[2,27,3,27],[2,38,3,38],[2,28,3,28],[2,18,4,18],[5,17,6,17],[2,14,2,15],[3,14,3,15],[4,14,4,15],[2,24,3,24],[2,25,3,25],[2,26,3,26],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,23,3,23],[3,32,3,33],[4,32,4,33],[5,32,6,33],[5,35,6,35],[5,34,6,34],[0,19,0,22],[0,55,0,58],[2,50,2,51],[2,54,4,54],[2,55,3,55],[2,56,3,56],[2,57,3,57],[2,58,3,58],[9,10,9,11],[2,46,3,46],[2,44,3,44],[2,45,3,45],[2,32,2,33],[2,36,4,36],[2,39,3,39],[2,40,3,40],[2,41,3,41],[2,42,3,42],[2,43,3,43],[2,37,3,37],[2,79,2,81],[2,64,3,64],[3,50,3,51],[4,50,4,51],[5,50,6,51],[5,52,6,52],[5,53,6,53],[2,59,3,59],[2,60,3,60],[2,61,3,61],[2,62,3,62],[2,63,3,63],[5,76,5,78],[6,76,6,78],[5,79,5,80],[6,79,6,80],[3,70,3,72],[3,73,3,75],[3,76,3,78],[3,79,3,80],[4,70,4,72],[4,73,4,75],[4,76,4,78],[4,79,4,80],[13,71,13,72],[14,71,14,72],[15,71,15,72],[16,71,16,72],[8,74,8,75],[9,74,9,75],[4,68,4,69],[2,68,3,69],[5,68,5,69],[6,68,6,69],[7,68,7,69],[5,70,5,72],[6,70,6,72],[5,73,5,75],[6,73,6,75],[2,70,2,78],[7,79,7,80],[7,76,7,78],[7,73,7,75],[7,70,7,72],[8,71,8,72],[9,71,9,72],[10,71,10,72],[11,71,11,72],[12,71,12,72],[15,74,15,75],[8,77,8,78],[9,77,9,78],[10,77,10,78],[11,77,11,78],[12,77,12,78],[13,77,13,78],[14,77,14,78],[15,77,15,78],[10,74,10,75],[11,74,11,75],[12,74,12,75],[13,74,13,75],[14,74,14,75],[16,77,16,78],[8,79,8,80],[9,79,9,80],[10,79,10,80],[11,79,11,80],[12,79,12,80],[13,79,13,80],[14,79,14,80],[15,79,15,80],[16,79,16,80]]}
[]
["Classe"]
["6ème",null,"Nom ","Prénom","Age","Sexe","Statut","Ets de Provenance",null,null,null,null,null,null,"Moyenne de la classe   :",null,{"$f":"IF( COUNT(Q8:Q109)<>0,AVERAGE(Q8:Q109),\"\")","v":11.666666666666666},{"$f":"IF( COUNT(R8:R109)<>0,AVERAGE(R8:R109),\"\")","v":11.666666666666666},"Matière","Philo","Français","Hist-Géo","LV 1","LV 2","Maths","Phys-Chim","EPS","jng",null,null,null,null,"Moyenne de la classe   :",null,{"$f":"IF( COUNT(AI8:AI109)<>0,AVERAGE(AI8:AI109),\"\")","v":12.833333333333332},{"$f":"IF( COUNT(AJ8:AJ109)<>0,AVERAGE(AJ8:AJ109),\"\")","v":12.333333333333332},"Matière","Philo","Français","Hist-Géo","LV 1","LV 2","Maths","Phys-Chim","EPS","jng",null,null,null,null,"Moyenne de la classe   :",null,{"$f":"IF( COUNT(BA8:BA109)<>0,AVERAGE(BA8:BA109),\"\")","v":10},{"$f":"IF( COUNT(BB8:BB109)<>0,AVERAGE(BB8:BB109),\"\")","v":10},"Matière","Philo","Français","Hist-Géo","LV 1","LV 2","Maths","Phys-Chim","EPS","jng",null,null,null,null,null,null,"Bilan Annuel"]
[null,null,"jkgb jh","bien",15,"F","Passant ","lolo",null,null,null,null,null,null,"Moyenne la plus haute :",null,{"$f":"IF(COUNT(Q8:Q109)<>0,MAX(Q8:Q109),\"\")","v":14.5},{"$f":"IF(COUNT(R8:R109)<>0,MAX(R8:R109),\"\")","v":14.666666666666666},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moyenne la plus haute :",null,{"$f":"IF(COUNT(AI8:AI109)<>0,MAX(AI8:AI109),\"\")","v":13},{"$f":"IF(COUNT(AJ8:AJ109)<>0,MAX(AJ8:AJ109),\"\")","v":12.666666666666666},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moyenne la plus haute :",null,{"$f":"IF(COUNT(BA8:BA109)<>0,MAX(BA8:BA109),\"\")","v":10},{"$f":"IF(COUNT(BB8:BB109)<>0,MAX(BB8:BB109),\"\")","v":10},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1er Trimestre",null,null,"2ème Trimestre",null,null,"3ème Trimestre",null,null,"Moyennes annuelles",null,"Ordre"]
[null,null,"jkgb jh","super",17,"G","Doublant","lolo neou",null,null,null,null,null,null,"Moyenne la plus basse :",null,{"$f":"IF(COUNT(Q8:Q109)<>0,MIN(Q8:Q109),\"\")","v":10},{"$f":"IF(COUNT(R8:R109)<>0,MIN(R8:R109),\"\")","v":10},null,{"$f":"IF(T3<>\"\",\"Coef\",\"\")","v":"Coef"},"Coef","Coef","Coef","Coef","Coef","Coef","Coef","Coef","",null,null,null,"Moyenne la plus basse :",null,{"$f":"IF(COUNT(AI8:AI109)<>0,MIN(AI8:AI109),\"\")","v":12.666666666666666},{"$f":"IF(COUNT(AJ8:AJ109)<>0,MIN(AJ8:AJ109),\"\")","v":12},null,{"$f":"IF(AL3<>\"\",\"Coef\",\"\")","v":"Coef"},"Coef","Coef","Coef","Coef","Coef","Coef","Coef","Coef","",null,null,null,"Moyenne la plus basse :",null,{"$f":"IF(COUNT(BA8:BA109)<>0,MIN(BA8:BA109),\"\")","v":10},{"$f":"IF(COUNT(BB8:BB109)<>0,MIN(BB8:BB109),\"\")","v":10},null,{"$f":"IF(BD3<>\"\",\"Coef\",\"\")","v":"Coef"},"Coef","Coef","Coef","Coef","Coef","Coef","Coef","Coef","",null,null,null,"Moyenne de la classe   :",null,{"$f":"Q3","v":11.666666666666666},null,null,{"$f":"AI3","v":12.833333333333332},null,null,{"$f":"BA3","v":10},null,null,{"$f":"IF(COUNT(CB9:CB75)<>0,AVERAGE(CB9:CB75),\"\")","v":12.111111111111109}]
[null,null,"soki","jkhn",11,"F","Passant ","jhbgfjbhgc",null,null,null,null,null,null,"Nom et Prénoms",null,"Moy-Brute","Moy-pond","Rang",2,1,3,2,1,1,1,3,null,null,null,null,null,"Nom et Prénoms",null,"Moy-Brute","Moy-pond","Rang",2,1,3,2,1,1,1,3,null,null,null,null,null,"Nom et Prénoms",null,"Moy-Brute","Moy-pond","Rang",2,1,3,2,1,1,1,3,null,null,null,null,null,"Moyenne la plus haute :",null,{"$f":"Q4","v":14.5},null,null,{"$f":"AI4","v":13},null,null,{"$f":"BA4","v":10},null,null,{"$f":"IF(COUNT(CB9:CB17)<>0,MAX(CB9:CB17),\"\")","v":14.666666666666666}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF( AND(SUMIF(T8:T75,\">=0\",$AF8:$AF75)>0,COUNT(T8:T75)<>0,T6<>\"\"),SUMPRODUCT(T8:T75,$AF8:$AF75)/SUMIF(T8:T75,\">=0\",$AF8:$AF75),\"\")","v":12.5},12.5,"","","",10,"",3,{"$f":"IF( AND(SUMIF(AB8:AB75,\">=0\",$AF8:$AF75)>0,COUNT(AB8:AB75)<>0,AB6<>\"\"),SUMPRODUCT(AB8:AB75,$AF8:$AF75)/SUMIF(AB8:AB75,\">=0\",$AF8:$AF75),\"\")","v":""},{"$f":"IF( AND(SUMIF(AC8:AC75,\">=0\",$AF8:$AF75)>0,COUNT(AC8:AC75)<>0,AC6<>\"\"),SUMPRODUCT(AC8:AC75,$AF8:$AF75)/SUMIF(AC8:AC75,\">=0\",$AF8:$AF75),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF( AND(SUMIF(AL8:AL75,\">=0\",$AF8:$AF75)>0,COUNT(AL8:AL75)<>0,AL6<>\"\"),SUMPRODUCT(AL8:AL75,$AF8:$AF75)/SUMIF(AL8:AL75,\">=0\",$AF8:$AF75),\"\")","v":11},13.5,"","",15,"","","","","",null,null,null,null,null,null,null,null,{"$f":"IF( AND(SUMIF(BD8:BD75,\">=0\",$AF8:$AF75)>0,COUNT(BD8:BD75)<>0,BD6<>\"\"),SUMPRODUCT(BD8:BD75,$AF8:$AF75)/SUMIF(BD8:BD75,\">=0\",$AF8:$AF75),\"\")","v":10},"","","","",10,"",3,{"$f":"IF( AND(SUMIF(BL8:BL75,\">=0\",$AF8:$AF75)>0,COUNT(BL8:BL75)<>0,BL6<>\"\"),SUMPRODUCT(BL8:BL75,$AF8:$AF75)/SUMIF(BL8:BL75,\">=0\",$AF8:$AF75),\"\")","v":""},{"$f":"IF( AND(SUMIF(BM8:BM75,\">=0\",$AF8:$AF75)>0,COUNT(BM8:BM75)<>0,BM6<>\"\"),SUMPRODUCT(BM8:BM75,$AF8:$AF75)/SUMIF(BM8:BM75,\">=0\",$AF8:$AF75),\"\")","v":""},null,null,null,"Moyenne la plus basse :",null,{"$f":"Q5","v":10},null,null,12.666666666666666,null,null,10,null,null,{"$f":"IF(COUNT(CB9:CB17)<>0,MIN(CB9:CB17),\"\")","v":10.666666666666666}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C4<>\"\",TRIM(PROPER(C4)),\"\")","v":"Jkgb Jh"},"Bien",{"$f":"IF(OR(P8=\"\",COUNT(T8:AC8)<1),\"\",AVERAGE(T8:AC8))","v":10},{"$f":"IF(OR(P8=\"\",SUMIF(T8:AC8,\">=0\",T6:AC6)=0),\"\",SUMPRODUCT(T6:AC6,T8:AC8)/SUMIF(T8:AC8,\">=0\",T6:AC6))","v":10},{"$f":"IF(AND(R8<>\"\",COUNT(R8:R75)>1),RANK(R8,R$8:R$75),\"\")","v":3},null,null,null,null,null,10,null,null,null,null,null,null,{"$f":"IF(C4=\"\",0,1)","v":1},{"$f":"IF(C4<>\"\",TRIM(PROPER(C4)),\"\")","v":"Jkgb Jh"},{"$f":"IF(D4<>\"\",TRIM(PROPER(D4)),\"\")","v":"Bien"},{"$f":"IF(OR(AH8=\"\",COUNT(AL8:AU8)<1),\"\",AVERAGE(AL8:AU8))","v":12.666666666666666},{"$f":"IF(OR(AH8=\"\",SUMIF(AL8:AU8,\">=0\",AL6:AU6)=0),\"\",SUMPRODUCT(AL6:AU6,AL8:AU8)/SUMIF(AL8:AU8,\">=0\",AL6:AU6))","v":12},{"$f":"IF(AND(AJ8<>\"\",COUNT(AJ8:AJ75)>1),RANK(AJ8,AJ$8:AJ$75),\"\")","v":2},10,13,null,null,15,null,null,null,null,null,null,null,null,{"$f":"IF(C4<>\"\",TRIM(PROPER(C4)),\"\")","v":"Jkgb Jh"},{"$f":"IF(D4<>\"\",TRIM(PROPER(D4)),\"\")","v":"Bien"},{"$f":"IF(OR(AZ8=\"\",COUNT(BD8:BM8)<1),\"\",AVERAGE(BD8:BM8))","v":10},{"$f":"IF(OR(AZ8=\"\",SUMIF(BD8:BM8,\">=0\",BD6:BM6)=0),\"\",SUMPRODUCT(BD6:BM6,BD8:BM8)/SUMIF(BD8:BM8,\">=0\",BD6:BM6))","v":10},{"$f":"IF(AND(BB8<>\"\",COUNT(BB8:BB75)>1),RANK(BB8,BB$8:BB$75),\"\")","v":1},null,null,null,null,null,10,null,null,null,null,null,null,null,"Noms des élèves",null,"***********",null,null,"***********",null,null,"***********",null,null,"************"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jkgb Jh","Super",{"$f":"IF(OR(P9=\"\",COUNT(T9:AC9)<1),\"\",AVERAGE(T9:AC9))","v":10.5},{"$f":"IF(OR(P9=\"\",SUMIF(T9:AC9,\">=0\",T6:AC6)=0),\"\",SUMPRODUCT(T6:AC6,T9:AC9)/SUMIF(T9:AC9,\">=0\",T6:AC6))","v":10.333333333333334},{"$f":"IF(AND(R9<>\"\",COUNT(R8:R75)>1),RANK(R9,R$8:R$75),\"\")","v":2},10,11,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C5=\"\",0,1)","v":1},{"$f":"IF(C5<>\"\",TRIM(PROPER(C5)),\"\")","v":"Jkgb Jh"},"Super",{"$f":"IF(OR(AH9=\"\",COUNT(AL9:AU9)<1),\"\",AVERAGE(AL9:AU9))","v":13},{"$f":"IF(OR(AH9=\"\",SUMIF(AL9:AU9,\">=0\",AL6:AU6)=0),\"\",SUMPRODUCT(AL6:AU6,AL9:AU9)/SUMIF(AL9:AU9,\">=0\",AL6:AU6))","v":12.666666666666666},{"$f":"IF(AND(AJ9<>\"\",COUNT(AJ8:AJ75)>1),RANK(AJ9,AJ$8:AJ$75),\"\")","v":1},12,14,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C5<>\"\",TRIM(PROPER(C5)),\"\")","v":"Jkgb Jh"},"Super",{"$f":"IF(OR(AZ9=\"\",COUNT(BD9:BM9)<1),\"\",AVERAGE(BD9:BM9))","v":10},{"$f":"IF(OR(AZ9=\"\",SUMIF(BD9:BM9,\">=0\",BD6:BM6)=0),\"\",SUMPRODUCT(BD6:BM6,BD9:BM9)/SUMIF(BD9:BM9,\">=0\",BD6:BM6))","v":10},{"$f":"IF(AND(BB9<>\"\",COUNT(BB8:BB75)>1),RANK(BB9,BB$8:BB$75),\"\")","v":1},10,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C4<>\"\",TRIM(PROPER(C4)),\"\")","v":"Jkgb Jh"},{"$f":"IF(D4<>\"\",TRIM(PROPER(D4)),\"\")","v":"Bien"},{"$f":"R8","v":10},{"$f":"S8","v":3},null,{"$f":"AJ8","v":12},{"$f":"AK8","v":2},null,{"$f":"BB8","v":10},{"$f":"BC8","v":1},null,{"$f":"IF(COUNT(BS9,BV9,BY9)>0,AVERAGE(BS9,BV9,BY9),\"\")","v":10.666666666666666},null,{"$f":"IF(AND(CB9<>\"\",COUNT(B$9:BS$17)>1),RANK(CB9,CB$9:CB$17),\"\")","v":3}]
[null,null,null,null,null,null,null,null,null,null,"Effectif Genre",null,null,null,{"$f":"IF(C6<>\"\",TRIM(PROPER(C6)),\"\")","v":"Soki"},"Jkhn",{"$f":"IF(OR(P10=\"\",COUNT(T10:AC10)<1),\"\",AVERAGE(T10:AC10))","v":14.5},{"$f":"IF(OR(P10=\"\",SUMIF(T10:AC10,\">=0\",T6:AC6)=0),\"\",SUMPRODUCT(T6:AC6,T10:AC10)/SUMIF(T10:AC10,\">=0\",T6:AC6))","v":14.666666666666666},{"$f":"IF(AND(R10<>\"\",COUNT(R8:R75)>1),RANK(R10,R$8:R$75),\"\")","v":1},15,14,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C6=\"\",0,1)","v":1},{"$f":"IF(C6<>\"\",TRIM(PROPER(C6)),\"\")","v":"Soki"},"Jkhn",{"$f":"IF(OR(AH10=\"\",COUNT(AL10:AU10)<1),\"\",AVERAGE(AL10:AU10))","v":""},{"$f":"IF(OR(AH10=\"\",SUMIF(AL10:AU10,\">=0\",AL6:AU6)=0),\"\",SUMPRODUCT(AL6:AU6,AL10:AU10)/SUMIF(AL10:AU10,\">=0\",AL6:AU6))","v":""},{"$f":"IF(AND(AJ10<>\"\",COUNT(AJ8:AJ75)>1),RANK(AJ10,AJ$8:AJ$75),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C6<>\"\",TRIM(PROPER(C6)),\"\")","v":"Soki"},"Jkhn",{"$f":"IF(OR(AZ10=\"\",COUNT(BD10:BM10)<1),\"\",AVERAGE(BD10:BM10))","v":""},{"$f":"IF(OR(AZ10=\"\",SUMIF(BD10:BM10,\">=0\",BD6:BM6)=0),\"\",SUMPRODUCT(BD6:BM6,BD10:BM10)/SUMIF(BD10:BM10,\">=0\",BD6:BM6))","v":""},{"$f":"IF(AND(BB10<>\"\",COUNT(BB8:BB75)>1),RANK(BB10,BB$8:BB$75),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C5<>\"\",TRIM(PROPER(C5)),\"\")","v":"Jkgb Jh"},"Super",{"$f":"R9","v":10.333333333333334},{"$f":"S9","v":2},null,{"$f":"AJ9","v":12.666666666666666},{"$f":"AK9","v":1},null,{"$f":"BB9","v":10},{"$f":"BC9","v":1},null,{"$f":"IF(COUNT(BS10,BV10,BY10)>0,AVERAGE(BS10,BV10,BY10),\"\")","v":11},null,{"$f":"IF(AND(CB10<>\"\",COUNT(B$9:BS$17)>1),RANK(CB10,CB$9:CB$17),\"\")","v":2}]
[null,null,null,null,null,null,null,null,null,null,"Nbre F",{"$f":"COUNTIF(F4:F202,\"F\")","v":2},null,null,"","",{"$f":"IF(OR(P11=\"\",COUNT(T11:AC11)<1),\"\",AVERAGE(T11:AC11))","v":""},{"$f":"IF(OR(P11=\"\",SUMIF(T11:AC11,\">=0\",T6:AC6)=0),\"\",SUMPRODUCT(T6:AC6,T11:AC11)/SUMIF(T11:AC11,\">=0\",T6:AC6))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7=\"\",0,1)","v":0},{"$f":"IF(C7<>\"\",TRIM(PROPER(C7)),\"\")","v":""},"",{"$f":"IF(OR(AH11=\"\",COUNT(AL11:AU11)<1),\"\",AVERAGE(AL11:AU11))","v":""},{"$f":"IF(OR(AH11=\"\",SUMIF(AL11:AU11,\">=0\",AL6:AU6)=0),\"\",SUMPRODUCT(AL6:AU6,AL11:AU11)/SUMIF(AL11:AU11,\">=0\",AL6:AU6))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7<>\"\",TRIM(PROPER(C7)),\"\")","v":""},"",{"$f":"IF(OR(AZ11=\"\",COUNT(BD11:BM11)<1),\"\",AVERAGE(BD11:BM11))","v":""},{"$f":"IF(OR(AZ11=\"\",SUMIF(BD11:BM11,\">=0\",BD6:BM6)=0),\"\",SUMPRODUCT(BD6:BM6,BD11:BM11)/SUMIF(BD11:BM11,\">=0\",BD6:BM6))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C6<>\"\",TRIM(PROPER(C6)),\"\")","v":"Soki"},"Jkhn",14.666666666666666,null,null,"","",null,"","",null,14.666666666666666,null,1]
[null,null,null,null,null,null,null,null,null,null,"Nbre G",{"$f":"COUNTIF(F4:F204,\"G\")","v":1},null,null,"","","",{"$f":"IF(OR(P12=\"\",SUMIF(T12:AC12,\">=0\",T6:AC6)=0),\"\",SUMPRODUCT(T6:AC6,T12:AC12)/SUMIF(T12:AC12,\">=0\",T6:AC6))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C8=\"\",0,1)","v":0},{"$f":"IF(C8<>\"\",TRIM(PROPER(C8)),\"\")","v":""},{"$f":"IF(V8<>\"\",TRIM(PROPER(V8)),\"\")","v":""},"",{"$f":"IF(OR(AH12=\"\",SUMIF(AL12:AU12,\">=0\",AL6:AU6)=0),\"\",SUMPRODUCT(AL6:AU6,AL12:AU12)/SUMIF(AL12:AU12,\">=0\",AL6:AU6))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C8<>\"\",TRIM(PROPER(C8)),\"\")","v":""},"","",{"$f":"IF(OR(AZ12=\"\",SUMIF(BD12:BM12,\">=0\",BD6:BM6)=0),\"\",SUMPRODUCT(BD6:BM6,BD12:BM12)/SUMIF(BD12:BM12,\">=0\",BD6:BM6))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7<>\"\",TRIM(PROPER(C7)),\"\")","v":""},"","",null,null,"",0,null,"",0,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Tableau2[[#All],[Colonne2]])","v":3},null,null,"","","",{"$f":"IF(OR(P13=\"\",SUMIF(T13:AC13,\">=0\",T6:AC6)=0),\"\",SUMPRODUCT(T6:AC6,T13:AC13)/SUMIF(T13:AC13,\">=0\",T6:AC6))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C9=\"\",0,1)","v":0},{"$f":"IF(C9<>\"\",TRIM(PROPER(C9)),\"\")","v":""},{"$f":"IF(V9<>\"\",TRIM(PROPER(V9)),\"\")","v":""},"",{"$f":"IF(OR(AH13=\"\",SUMIF(AL13:AU13,\">=0\",AL6:AU6)=0),\"\",SUMPRODUCT(AL6:AU6,AL13:AU13)/SUMIF(AL13:AU13,\">=0\",AL6:AU6))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C9<>\"\",TRIM(PROPER(C9)),\"\")","v":""},{"$f":"IF(D9<>\"\",TRIM(PROPER(D9)),\"\")","v":""},"",{"$f":"IF(OR(AZ13=\"\",SUMIF(BD13:BM13,\">=0\",BD6:BM6)=0),\"\",SUMPRODUCT(BD6:BM6,BD13:BM13)/SUMIF(BD13:BM13,\">=0\",BD6:BM6))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C8<>\"\",TRIM(PROPER(C8)),\"\")","v":""},"","",null,null,"",null,null,"",0,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C10<>\"\",TRIM(PROPER(C10)),\"\")","v":""},"","",{"$f":"IF(OR(P14=\"\",SUMIF(T14:AC14,\">=0\",T8:AC8)=0),\"\",SUMPRODUCT(T8:AC8,T14:AC14)/SUMIF(T14:AC14,\">=0\",T8:AC8))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(U10<>\"\",TRIM(PROPER(U10)),\"\")","v":"14"},{"$f":"IF(V10<>\"\",TRIM(PROPER(V10)),\"\")","v":""},"",{"$f":"IF(OR(AH14=\"\",SUMIF(AL14:AU14,\">=0\",AL8:AU8)=0),\"\",SUMPRODUCT(AL8:AU8,AL14:AU14)/SUMIF(AL14:AU14,\">=0\",AL8:AU8))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C10<>\"\",TRIM(PROPER(C10)),\"\")","v":""},"","",{"$f":"IF(OR(AZ14=\"\",SUMIF(BD14:BM14,\">=0\",BD8:BM8)=0),\"\",SUMPRODUCT(BD8:BM8,BD14:BM14)/SUMIF(BD14:BM14,\">=0\",BD8:BM8))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C9<>\"\",TRIM(PROPER(C9)),\"\")","v":""},"","",null,null,"",null,null,"",0,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"Statut",null,null,null,"","","",{"$f":"IF(OR(P15=\"\",SUMIF(T15:AC15,\">=0\",T9:AC9)=0),\"\",SUMPRODUCT(T9:AC9,T15:AC15)/SUMIF(T15:AC15,\">=0\",T9:AC9))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","","",{"$f":"IF(OR(AH15=\"\",SUMIF(AL15:AU15,\">=0\",AL9:AU9)=0),\"\",SUMPRODUCT(AL9:AU9,AL15:AU15)/SUMIF(AL15:AU15,\">=0\",AL9:AU9))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C11<>\"\",TRIM(PROPER(C11)),\"\")","v":""},"","",{"$f":"IF(OR(AZ15=\"\",SUMIF(BD15:BM15,\">=0\",BD9:BM9)=0),\"\",SUMPRODUCT(BD9:BM9,BD15:BM15)/SUMIF(BD15:BM15,\">=0\",BD9:BM9))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C10<>\"\",TRIM(PROPER(C10)),\"\")","v":""},"","",null,null,"",null,null,"",0,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"Nbre Passant",{"$f":"COUNTIF(G4:G205,\"Passant \")","v":2},null,null,"","","",{"$f":"IF(OR(P16=\"\",SUMIF(T16:AC16,\">=0\",T10:AC10)=0),\"\",SUMPRODUCT(T10:AC10,T16:AC16)/SUMIF(T16:AC16,\">=0\",T10:AC10))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(OR(AH16=\"\",SUMIF(AL16:AU16,\">=0\",AL10:AU10)=0),\"\",SUMPRODUCT(AL10:AU10,AL16:AU16)/SUMIF(AL16:AU16,\">=0\",AL10:AU10))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C12<>\"\",TRIM(PROPER(C12)),\"\")","v":""},"","",{"$f":"IF(OR(AZ16=\"\",SUMIF(BD16:BM16,\">=0\",BD10:BM10)=0),\"\",SUMPRODUCT(BD10:BM10,BD16:BM16)/SUMIF(BD16:BM16,\">=0\",BD10:BM10))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C11<>\"\",TRIM(PROPER(C11)),\"\")","v":""},"","",null,null,"",null,null,"",0,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"Nbre Doublant",{"$f":"COUNTIF(G4:G205,\"Doublant\")","v":1},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C12<>\"\",TRIM(PROPER(C12)),\"\")","v":""},"","",null,null,"",null,null,"",0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Nbre Exclu",{"$f":"COUNTIF(G4:G205,\"Exclu\")","v":0},null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C67<>\"\",TRIM(PROPER(C67)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C70<>\"\",TRIM(PROPER(C70)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"Première","index":3,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["Classe"]
["1ère",null,"Nom ","Prénom","Age","Sexe","Statut","Ets de Provenance"]

{"sheet":"Terminale","index":4,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["Classe"]
["Tle",null,"Nom ","Prénom","Age","Sexe","Statut","Ets de Provenance"]

{"sheet":"Feuil1","index":5,"n_rows":9,"n_cols":18,"rows_kept":9,"cut":false,"hidden":false,"merged":[[7,2,8,3],[7,4,8,4],[7,5,8,5],[4,11,5,11],[4,12,5,12],[4,2,4,3],[4,6,6,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,17,5,17],[5,2,5,3],[6,2,6,3],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16]]}
[]
[]
[]
[]
[null,null,"Moyenne de la classe   :",null,{"$f":"IF( COUNT(J15:J116)<>0,AVERAGE(J15:J116),\"\")","v":""},{"$f":"IF( COUNT(K15:K116)<>0,AVERAGE(K15:K116),\"\")","v":""},"Matière","Philo","Français","Hist-Géo","LV 1","LV 2","Maths","Phys-Chim","SVT","EPS"]
[null,null,"Moyenne la plus haute :",null,{"$f":"IF(COUNT(J15:J116)<>0,MAX(J15:J116),\"\")","v":""},{"$f":"IF(COUNT(K15:K116)<>0,MAX(K15:K116),\"\")","v":""}]
[null,null,"Moyenne la plus basse :",null,{"$f":"IF(COUNT(J15:J116)<>0,MIN(J15:J116),\"\")","v":""},{"$f":"IF(COUNT(K15:K116)<>0,MIN(K15:K116),\"\")","v":""},null,{"$f":"IF(H5<>\"\",\"Coef\",\"\")","v":"Coef"},"Coef","Coef","Coef","Coef","Coef","Coef","Coef","Coef","",""]
[null,null,"Nom et Prénoms",null,"Moy-Brute","Moy-pond","Rang",1,1,1,2,1,1,1,1,1]
[null,null,null,null,null,null,null,{"$f":"IF( AND(SUMIF(M17:M118,\">=0\",$BO17:$BO118)>0,COUNT(M17:M118)<>0,H8<>\"\"),SUMPRODUCT(M17:M118,$BO17:$BO118)/SUMIF(M17:M118,\">=0\",$BO17:$BO118),\"\")","v":""},"","","","","","","","","",""]