{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tableau","Barème"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":400,"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":"Tableau","index":0,"n_rows":101,"n_cols":27,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Sexe F ou G/M","Classe","Projet","Perf 1","Perf 2","Perf 3","Perf 4","Perf 5","Perf 6","Meilleur Perf","Perf moyenne","Ecart","Note record /10","Note moyenne /4","Note ecart /2","Note technique/4","Note Javelot",null,"Sexe fin"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F2:K2)>0,MAX(F2:K2),\"\")","v":""},{"$f":"IF(COUNTA(F2:K2)<3,\"\",(LARGE(F2:K2,1)+LARGE(F2:K2,2)+LARGE(F2:K2,3))/3)","v":""},{"$f":"IF(M2<>\"\", IF(E2<>\"\",(ABS(M2-E2)/E2)*100,\"Projet ?\"),\"\")","v":""},{"$f":"IF(L2<>\"\",IF(OR(C2=\"G\",C2=\"M\"),LOOKUP(L2,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C2=\"F\",LOOKUP(L2,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M2<>\"\",IF(OR(C2=\"G\",C2=\"M\"),LOOKUP(M2,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C2=\"F\",LOOKUP(M2,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(N2<>\"\",IF($N2<=5,2,IF(AND($N2>5,$N2<=10),1,IF(AND($N2>10,$N2<=20),0.5,0))),\"\")","v":""},null,{"$f":"IF(OR(O2=\"\",P2=\"\",N2=\"\",N2=\"Projet ?\",O2=\"(F ou G)\"),\"\",IF(R2=\"\",\"Note tech ?\",IF(AND(R2<=4,R2>=0),R2+Q2+P2+O2,\"Err Nt tech.\")))","v":""},null,{"$f":"IF(C2=\"g\",\"G\",IF(C2=\"m\",\"G\",IF(C2=\"F\",\"F\",\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F3:K3)>0,MAX(F3:K3),\"\")","v":""},{"$f":"IF(COUNTA(F3:K3)<3,\"\",(LARGE(F3:K3,1)+LARGE(F3:K3,2)+LARGE(F3:K3,3))/3)","v":""},"",{"$f":"IF(L3<>\"\",IF(OR(C3=\"G\",C3=\"M\"),LOOKUP(L3,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C3=\"F\",LOOKUP(L3,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M3<>\"\",IF(OR(C3=\"G\",C3=\"M\"),LOOKUP(M3,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C3=\"F\",LOOKUP(M3,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,"","Moyenne F :",{"$f":"IF(ISERROR(AA3),\"\",AVERAGEIF(U2:U101,\"=F\",S2:S101))","v":""},null,null,null,{"$f":"AVERAGEIF(U2:U101,\"=F\",S2:S101)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L4<>\"\",IF(OR(C4=\"G\",C4=\"M\"),LOOKUP(L4,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C4=\"F\",LOOKUP(L4,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M4<>\"\",IF(OR(C4=\"G\",C4=\"M\"),LOOKUP(M4,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C4=\"F\",LOOKUP(M4,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,"","Moyenne G :",{"$f":"IF(ISERROR(AA4),\"\",AVERAGEIF(U2:U101,\"=G\",S2:S101))","v":""},null,null,null,{"$f":"AVERAGEIF(U2:U101,\"=G\",S2:S101)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L5<>\"\",IF(OR(C5=\"G\",C5=\"M\"),LOOKUP(L5,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C5=\"F\",LOOKUP(L5,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M5<>\"\",IF(OR(C5=\"G\",C5=\"M\"),LOOKUP(M5,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C5=\"F\",LOOKUP(M5,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,"","Moyenne :",{"$f":"IF(AND(W3=\"\",W4=\"\"),\"\",AVERAGE(S2:S101))","v":""},null,null,null,{"$f":"AVERAGE(S2:S101)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L6<>\"\",IF(OR(C6=\"G\",C6=\"M\"),LOOKUP(L6,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C6=\"F\",LOOKUP(L6,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M6<>\"\",IF(OR(C6=\"G\",C6=\"M\"),LOOKUP(M6,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C6=\"F\",LOOKUP(M6,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,"","Note Max :",{"$f":"IF(SUM(S2:S101)>0,MAX(S2:S101),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L7<>\"\",IF(OR(C7=\"G\",C7=\"M\"),LOOKUP(L7,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C7=\"F\",LOOKUP(L7,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M7<>\"\",IF(OR(C7=\"G\",C7=\"M\"),LOOKUP(M7,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C7=\"F\",LOOKUP(M7,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,"","Note Min :",{"$f":"IF(SUM(S2:S101)>0,MIN(S2:S101),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L8<>\"\",IF(OR(C8=\"G\",C8=\"M\"),LOOKUP(L8,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C8=\"F\",LOOKUP(L8,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M8<>\"\",IF(OR(C8=\"G\",C8=\"M\"),LOOKUP(M8,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C8=\"F\",LOOKUP(M8,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L9<>\"\",IF(OR(C9=\"G\",C9=\"M\"),LOOKUP(L9,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C9=\"F\",LOOKUP(L9,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M9<>\"\",IF(OR(C9=\"G\",C9=\"M\"),LOOKUP(M9,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C9=\"F\",LOOKUP(M9,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,"","Date épreuve : "]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L10<>\"\",IF(OR(C10=\"G\",C10=\"M\"),LOOKUP(L10,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C10=\"F\",LOOKUP(L10,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M10<>\"\",IF(OR(C10=\"G\",C10=\"M\"),LOOKUP(M10,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C10=\"F\",LOOKUP(M10,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L11<>\"\",IF(OR(C11=\"G\",C11=\"M\"),LOOKUP(L11,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C11=\"F\",LOOKUP(L11,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M11<>\"\",IF(OR(C11=\"G\",C11=\"M\"),LOOKUP(M11,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C11=\"F\",LOOKUP(M11,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L12<>\"\",IF(OR(C12=\"G\",C12=\"M\"),LOOKUP(L12,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C12=\"F\",LOOKUP(L12,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M12<>\"\",IF(OR(C12=\"G\",C12=\"M\"),LOOKUP(M12,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C12=\"F\",LOOKUP(M12,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L13<>\"\",IF(OR(C13=\"G\",C13=\"M\"),LOOKUP(L13,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C13=\"F\",LOOKUP(L13,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M13<>\"\",IF(OR(C13=\"G\",C13=\"M\"),LOOKUP(M13,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C13=\"F\",LOOKUP(M13,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L14<>\"\",IF(OR(C14=\"G\",C14=\"M\"),LOOKUP(L14,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C14=\"F\",LOOKUP(L14,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M14<>\"\",IF(OR(C14=\"G\",C14=\"M\"),LOOKUP(M14,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C14=\"F\",LOOKUP(M14,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L15<>\"\",IF(OR(C15=\"G\",C15=\"M\"),LOOKUP(L15,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C15=\"F\",LOOKUP(L15,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M15<>\"\",IF(OR(C15=\"G\",C15=\"M\"),LOOKUP(M15,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C15=\"F\",LOOKUP(M15,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L16<>\"\",IF(OR(C16=\"G\",C16=\"M\"),LOOKUP(L16,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C16=\"F\",LOOKUP(L16,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M16<>\"\",IF(OR(C16=\"G\",C16=\"M\"),LOOKUP(M16,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C16=\"F\",LOOKUP(M16,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L17<>\"\",IF(OR(C17=\"G\",C17=\"M\"),LOOKUP(L17,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C17=\"F\",LOOKUP(L17,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M17<>\"\",IF(OR(C17=\"G\",C17=\"M\"),LOOKUP(M17,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C17=\"F\",LOOKUP(M17,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L18<>\"\",IF(OR(C18=\"G\",C18=\"M\"),LOOKUP(L18,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C18=\"F\",LOOKUP(L18,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M18<>\"\",IF(OR(C18=\"G\",C18=\"M\"),LOOKUP(M18,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C18=\"F\",LOOKUP(M18,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L19<>\"\",IF(OR(C19=\"G\",C19=\"M\"),LOOKUP(L19,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C19=\"F\",LOOKUP(L19,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M19<>\"\",IF(OR(C19=\"G\",C19=\"M\"),LOOKUP(M19,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C19=\"F\",LOOKUP(M19,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L20<>\"\",IF(OR(C20=\"G\",C20=\"M\"),LOOKUP(L20,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C20=\"F\",LOOKUP(L20,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M20<>\"\",IF(OR(C20=\"G\",C20=\"M\"),LOOKUP(M20,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C20=\"F\",LOOKUP(M20,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L21<>\"\",IF(OR(C21=\"G\",C21=\"M\"),LOOKUP(L21,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C21=\"F\",LOOKUP(L21,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M21<>\"\",IF(OR(C21=\"G\",C21=\"M\"),LOOKUP(M21,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C21=\"F\",LOOKUP(M21,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L22<>\"\",IF(OR(C22=\"G\",C22=\"M\"),LOOKUP(L22,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C22=\"F\",LOOKUP(L22,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M22<>\"\",IF(OR(C22=\"G\",C22=\"M\"),LOOKUP(M22,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C22=\"F\",LOOKUP(M22,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L23<>\"\",IF(OR(C23=\"G\",C23=\"M\"),LOOKUP(L23,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C23=\"F\",LOOKUP(L23,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M23<>\"\",IF(OR(C23=\"G\",C23=\"M\"),LOOKUP(M23,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C23=\"F\",LOOKUP(M23,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L24<>\"\",IF(OR(C24=\"G\",C24=\"M\"),LOOKUP(L24,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C24=\"F\",LOOKUP(L24,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M24<>\"\",IF(OR(C24=\"G\",C24=\"M\"),LOOKUP(M24,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C24=\"F\",LOOKUP(M24,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L25<>\"\",IF(OR(C25=\"G\",C25=\"M\"),LOOKUP(L25,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C25=\"F\",LOOKUP(L25,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M25<>\"\",IF(OR(C25=\"G\",C25=\"M\"),LOOKUP(M25,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C25=\"F\",LOOKUP(M25,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L26<>\"\",IF(OR(C26=\"G\",C26=\"M\"),LOOKUP(L26,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C26=\"F\",LOOKUP(L26,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M26<>\"\",IF(OR(C26=\"G\",C26=\"M\"),LOOKUP(M26,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C26=\"F\",LOOKUP(M26,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L27<>\"\",IF(OR(C27=\"G\",C27=\"M\"),LOOKUP(L27,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C27=\"F\",LOOKUP(L27,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M27<>\"\",IF(OR(C27=\"G\",C27=\"M\"),LOOKUP(M27,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C27=\"F\",LOOKUP(M27,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L28<>\"\",IF(OR(C28=\"G\",C28=\"M\"),LOOKUP(L28,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C28=\"F\",LOOKUP(L28,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M28<>\"\",IF(OR(C28=\"G\",C28=\"M\"),LOOKUP(M28,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C28=\"F\",LOOKUP(M28,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L29<>\"\",IF(OR(C29=\"G\",C29=\"M\"),LOOKUP(L29,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C29=\"F\",LOOKUP(L29,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M29<>\"\",IF(OR(C29=\"G\",C29=\"M\"),LOOKUP(M29,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C29=\"F\",LOOKUP(M29,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L30<>\"\",IF(OR(C30=\"G\",C30=\"M\"),LOOKUP(L30,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C30=\"F\",LOOKUP(L30,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M30<>\"\",IF(OR(C30=\"G\",C30=\"M\"),LOOKUP(M30,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C30=\"F\",LOOKUP(M30,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L31<>\"\",IF(OR(C31=\"G\",C31=\"M\"),LOOKUP(L31,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C31=\"F\",LOOKUP(L31,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M31<>\"\",IF(OR(C31=\"G\",C31=\"M\"),LOOKUP(M31,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C31=\"F\",LOOKUP(M31,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L32<>\"\",IF(OR(C32=\"G\",C32=\"M\"),LOOKUP(L32,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C32=\"F\",LOOKUP(L32,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M32<>\"\",IF(OR(C32=\"G\",C32=\"M\"),LOOKUP(M32,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C32=\"F\",LOOKUP(M32,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L33<>\"\",IF(OR(C33=\"G\",C33=\"M\"),LOOKUP(L33,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C33=\"F\",LOOKUP(L33,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M33<>\"\",IF(OR(C33=\"G\",C33=\"M\"),LOOKUP(M33,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C33=\"F\",LOOKUP(M33,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L34<>\"\",IF(OR(C34=\"G\",C34=\"M\"),LOOKUP(L34,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C34=\"F\",LOOKUP(L34,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M34<>\"\",IF(OR(C34=\"G\",C34=\"M\"),LOOKUP(M34,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C34=\"F\",LOOKUP(M34,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,{"$f":"IF(C34=\"g\",\"G\",IF(C34=\"m\",\"G\",IF(C34=\"F\",\"F\",\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L35<>\"\",IF(OR(C35=\"G\",C35=\"M\"),LOOKUP(L35,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C35=\"F\",LOOKUP(L35,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M35<>\"\",IF(OR(C35=\"G\",C35=\"M\"),LOOKUP(M35,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C35=\"F\",LOOKUP(M35,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L36<>\"\",IF(OR(C36=\"G\",C36=\"M\"),LOOKUP(L36,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C36=\"F\",LOOKUP(L36,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M36<>\"\",IF(OR(C36=\"G\",C36=\"M\"),LOOKUP(M36,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C36=\"F\",LOOKUP(M36,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F37:K37)>0,MAX(F37:K37),\"\")","v":""},{"$f":"IF(COUNTA(F37:K37)<3,\"\",(LARGE(F37:K37,1)+LARGE(F37:K37,2)+LARGE(F37:K37,3))/3)","v":""},{"$f":"IF(M37<>\"\", IF(E37<>\"\",(ABS(M37-E37)/E37)*100,\"Projet ?\"),\"\")","v":""},{"$f":"IF(L37<>\"\",IF(OR(C37=\"G\",C37=\"M\"),LOOKUP(L37,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C37=\"F\",LOOKUP(L37,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M37<>\"\",IF(OR(C37=\"G\",C37=\"M\"),LOOKUP(M37,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C37=\"F\",LOOKUP(M37,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(N37<>\"\",IF($N37<=5,2,IF(AND($N37>5,$N37<=10),1,IF(AND($N37>10,$N37<=20),0.5,0))),\"\")","v":""},null,{"$f":"IF(OR(O37=\"\",P37=\"\",N37=\"\",N37=\"Projet ?\",O37=\"(F ou G)\"),\"\",IF(R37=\"\",\"Note tech ?\",IF(AND(R37<=4,R37>=0),R37+Q37+P37+O37,\"Err Nt tech.\")))","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L38<>\"\",IF(OR(C38=\"G\",C38=\"M\"),LOOKUP(L38,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C38=\"F\",LOOKUP(L38,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M38<>\"\",IF(OR(C38=\"G\",C38=\"M\"),LOOKUP(M38,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C38=\"F\",LOOKUP(M38,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L39<>\"\",IF(OR(C39=\"G\",C39=\"M\"),LOOKUP(L39,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C39=\"F\",LOOKUP(L39,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M39<>\"\",IF(OR(C39=\"G\",C39=\"M\"),LOOKUP(M39,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C39=\"F\",LOOKUP(M39,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L40<>\"\",IF(OR(C40=\"G\",C40=\"M\"),LOOKUP(L40,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C40=\"F\",LOOKUP(L40,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M40<>\"\",IF(OR(C40=\"G\",C40=\"M\"),LOOKUP(M40,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C40=\"F\",LOOKUP(M40,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L41<>\"\",IF(OR(C41=\"G\",C41=\"M\"),LOOKUP(L41,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C41=\"F\",LOOKUP(L41,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M41<>\"\",IF(OR(C41=\"G\",C41=\"M\"),LOOKUP(M41,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C41=\"F\",LOOKUP(M41,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L42<>\"\",IF(OR(C42=\"G\",C42=\"M\"),LOOKUP(L42,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C42=\"F\",LOOKUP(L42,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M42<>\"\",IF(OR(C42=\"G\",C42=\"M\"),LOOKUP(M42,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C42=\"F\",LOOKUP(M42,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L43<>\"\",IF(OR(C43=\"G\",C43=\"M\"),LOOKUP(L43,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C43=\"F\",LOOKUP(L43,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M43<>\"\",IF(OR(C43=\"G\",C43=\"M\"),LOOKUP(M43,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C43=\"F\",LOOKUP(M43,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L44<>\"\",IF(OR(C44=\"G\",C44=\"M\"),LOOKUP(L44,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C44=\"F\",LOOKUP(L44,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M44<>\"\",IF(OR(C44=\"G\",C44=\"M\"),LOOKUP(M44,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C44=\"F\",LOOKUP(M44,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L45<>\"\",IF(OR(C45=\"G\",C45=\"M\"),LOOKUP(L45,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C45=\"F\",LOOKUP(L45,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M45<>\"\",IF(OR(C45=\"G\",C45=\"M\"),LOOKUP(M45,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C45=\"F\",LOOKUP(M45,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L46<>\"\",IF(OR(C46=\"G\",C46=\"M\"),LOOKUP(L46,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C46=\"F\",LOOKUP(L46,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M46<>\"\",IF(OR(C46=\"G\",C46=\"M\"),LOOKUP(M46,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C46=\"F\",LOOKUP(M46,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L47<>\"\",IF(OR(C47=\"G\",C47=\"M\"),LOOKUP(L47,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C47=\"F\",LOOKUP(L47,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M47<>\"\",IF(OR(C47=\"G\",C47=\"M\"),LOOKUP(M47,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C47=\"F\",LOOKUP(M47,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L48<>\"\",IF(OR(C48=\"G\",C48=\"M\"),LOOKUP(L48,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C48=\"F\",LOOKUP(L48,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M48<>\"\",IF(OR(C48=\"G\",C48=\"M\"),LOOKUP(M48,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C48=\"F\",LOOKUP(M48,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L49<>\"\",IF(OR(C49=\"G\",C49=\"M\"),LOOKUP(L49,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C49=\"F\",LOOKUP(L49,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M49<>\"\",IF(OR(C49=\"G\",C49=\"M\"),LOOKUP(M49,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C49=\"F\",LOOKUP(M49,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L50<>\"\",IF(OR(C50=\"G\",C50=\"M\"),LOOKUP(L50,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C50=\"F\",LOOKUP(L50,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M50<>\"\",IF(OR(C50=\"G\",C50=\"M\"),LOOKUP(M50,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C50=\"F\",LOOKUP(M50,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L51<>\"\",IF(OR(C51=\"G\",C51=\"M\"),LOOKUP(L51,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C51=\"F\",LOOKUP(L51,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M51<>\"\",IF(OR(C51=\"G\",C51=\"M\"),LOOKUP(M51,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C51=\"F\",LOOKUP(M51,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L52<>\"\",IF(OR(C52=\"G\",C52=\"M\"),LOOKUP(L52,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C52=\"F\",LOOKUP(L52,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M52<>\"\",IF(OR(C52=\"G\",C52=\"M\"),LOOKUP(M52,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C52=\"F\",LOOKUP(M52,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L53<>\"\",IF(OR(C53=\"G\",C53=\"M\"),LOOKUP(L53,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C53=\"F\",LOOKUP(L53,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M53<>\"\",IF(OR(C53=\"G\",C53=\"M\"),LOOKUP(M53,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C53=\"F\",LOOKUP(M53,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L54<>\"\",IF(OR(C54=\"G\",C54=\"M\"),LOOKUP(L54,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C54=\"F\",LOOKUP(L54,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M54<>\"\",IF(OR(C54=\"G\",C54=\"M\"),LOOKUP(M54,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C54=\"F\",LOOKUP(M54,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L55<>\"\",IF(OR(C55=\"G\",C55=\"M\"),LOOKUP(L55,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C55=\"F\",LOOKUP(L55,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M55<>\"\",IF(OR(C55=\"G\",C55=\"M\"),LOOKUP(M55,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C55=\"F\",LOOKUP(M55,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L56<>\"\",IF(OR(C56=\"G\",C56=\"M\"),LOOKUP(L56,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C56=\"F\",LOOKUP(L56,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M56<>\"\",IF(OR(C56=\"G\",C56=\"M\"),LOOKUP(M56,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C56=\"F\",LOOKUP(M56,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L57<>\"\",IF(OR(C57=\"G\",C57=\"M\"),LOOKUP(L57,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C57=\"F\",LOOKUP(L57,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M57<>\"\",IF(OR(C57=\"G\",C57=\"M\"),LOOKUP(M57,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C57=\"F\",LOOKUP(M57,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L58<>\"\",IF(OR(C58=\"G\",C58=\"M\"),LOOKUP(L58,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C58=\"F\",LOOKUP(L58,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M58<>\"\",IF(OR(C58=\"G\",C58=\"M\"),LOOKUP(M58,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C58=\"F\",LOOKUP(M58,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L59<>\"\",IF(OR(C59=\"G\",C59=\"M\"),LOOKUP(L59,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C59=\"F\",LOOKUP(L59,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M59<>\"\",IF(OR(C59=\"G\",C59=\"M\"),LOOKUP(M59,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C59=\"F\",LOOKUP(M59,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L60<>\"\",IF(OR(C60=\"G\",C60=\"M\"),LOOKUP(L60,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C60=\"F\",LOOKUP(L60,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M60<>\"\",IF(OR(C60=\"G\",C60=\"M\"),LOOKUP(M60,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C60=\"F\",LOOKUP(M60,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L61<>\"\",IF(OR(C61=\"G\",C61=\"M\"),LOOKUP(L61,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C61=\"F\",LOOKUP(L61,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M61<>\"\",IF(OR(C61=\"G\",C61=\"M\"),LOOKUP(M61,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C61=\"F\",LOOKUP(M61,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L62<>\"\",IF(OR(C62=\"G\",C62=\"M\"),LOOKUP(L62,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C62=\"F\",LOOKUP(L62,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M62<>\"\",IF(OR(C62=\"G\",C62=\"M\"),LOOKUP(M62,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C62=\"F\",LOOKUP(M62,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L63<>\"\",IF(OR(C63=\"G\",C63=\"M\"),LOOKUP(L63,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C63=\"F\",LOOKUP(L63,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M63<>\"\",IF(OR(C63=\"G\",C63=\"M\"),LOOKUP(M63,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C63=\"F\",LOOKUP(M63,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L64<>\"\",IF(OR(C64=\"G\",C64=\"M\"),LOOKUP(L64,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C64=\"F\",LOOKUP(L64,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M64<>\"\",IF(OR(C64=\"G\",C64=\"M\"),LOOKUP(M64,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C64=\"F\",LOOKUP(M64,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L65<>\"\",IF(OR(C65=\"G\",C65=\"M\"),LOOKUP(L65,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C65=\"F\",LOOKUP(L65,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M65<>\"\",IF(OR(C65=\"G\",C65=\"M\"),LOOKUP(M65,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C65=\"F\",LOOKUP(M65,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L66<>\"\",IF(OR(C66=\"G\",C66=\"M\"),LOOKUP(L66,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C66=\"F\",LOOKUP(L66,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M66<>\"\",IF(OR(C66=\"G\",C66=\"M\"),LOOKUP(M66,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C66=\"F\",LOOKUP(M66,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,{"$f":"IF(C66=\"g\",\"G\",IF(C66=\"m\",\"G\",IF(C66=\"F\",\"F\",\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L67<>\"\",IF(OR(C67=\"G\",C67=\"M\"),LOOKUP(L67,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C67=\"F\",LOOKUP(L67,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M67<>\"\",IF(OR(C67=\"G\",C67=\"M\"),LOOKUP(M67,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C67=\"F\",LOOKUP(M67,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L68<>\"\",IF(OR(C68=\"G\",C68=\"M\"),LOOKUP(L68,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C68=\"F\",LOOKUP(L68,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M68<>\"\",IF(OR(C68=\"G\",C68=\"M\"),LOOKUP(M68,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C68=\"F\",LOOKUP(M68,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L69<>\"\",IF(OR(C69=\"G\",C69=\"M\"),LOOKUP(L69,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C69=\"F\",LOOKUP(L69,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M69<>\"\",IF(OR(C69=\"G\",C69=\"M\"),LOOKUP(M69,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C69=\"F\",LOOKUP(M69,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L70<>\"\",IF(OR(C70=\"G\",C70=\"M\"),LOOKUP(L70,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C70=\"F\",LOOKUP(L70,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M70<>\"\",IF(OR(C70=\"G\",C70=\"M\"),LOOKUP(M70,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C70=\"F\",LOOKUP(M70,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L71<>\"\",IF(OR(C71=\"G\",C71=\"M\"),LOOKUP(L71,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C71=\"F\",LOOKUP(L71,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M71<>\"\",IF(OR(C71=\"G\",C71=\"M\"),LOOKUP(M71,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C71=\"F\",LOOKUP(M71,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L72<>\"\",IF(OR(C72=\"G\",C72=\"M\"),LOOKUP(L72,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C72=\"F\",LOOKUP(L72,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M72<>\"\",IF(OR(C72=\"G\",C72=\"M\"),LOOKUP(M72,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C72=\"F\",LOOKUP(M72,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L73<>\"\",IF(OR(C73=\"G\",C73=\"M\"),LOOKUP(L73,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C73=\"F\",LOOKUP(L73,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M73<>\"\",IF(OR(C73=\"G\",C73=\"M\"),LOOKUP(M73,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C73=\"F\",LOOKUP(M73,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L74<>\"\",IF(OR(C74=\"G\",C74=\"M\"),LOOKUP(L74,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C74=\"F\",LOOKUP(L74,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M74<>\"\",IF(OR(C74=\"G\",C74=\"M\"),LOOKUP(M74,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C74=\"F\",LOOKUP(M74,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L75<>\"\",IF(OR(C75=\"G\",C75=\"M\"),LOOKUP(L75,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C75=\"F\",LOOKUP(L75,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M75<>\"\",IF(OR(C75=\"G\",C75=\"M\"),LOOKUP(M75,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C75=\"F\",LOOKUP(M75,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L76<>\"\",IF(OR(C76=\"G\",C76=\"M\"),LOOKUP(L76,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C76=\"F\",LOOKUP(L76,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M76<>\"\",IF(OR(C76=\"G\",C76=\"M\"),LOOKUP(M76,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C76=\"F\",LOOKUP(M76,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L77<>\"\",IF(OR(C77=\"G\",C77=\"M\"),LOOKUP(L77,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C77=\"F\",LOOKUP(L77,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M77<>\"\",IF(OR(C77=\"G\",C77=\"M\"),LOOKUP(M77,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C77=\"F\",LOOKUP(M77,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F78:K78)>0,MAX(F78:K78),\"\")","v":""},{"$f":"IF(COUNTA(F78:K78)<3,\"\",(LARGE(F78:K78,1)+LARGE(F78:K78,2)+LARGE(F78:K78,3))/3)","v":""},{"$f":"IF(M78<>\"\", IF(E78<>\"\",(ABS(M78-E78)/E78)*100,\"Projet ?\"),\"\")","v":""},{"$f":"IF(L78<>\"\",IF(OR(C78=\"G\",C78=\"M\"),LOOKUP(L78,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C78=\"F\",LOOKUP(L78,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M78<>\"\",IF(OR(C78=\"G\",C78=\"M\"),LOOKUP(M78,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C78=\"F\",LOOKUP(M78,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(N78<>\"\",IF($N78<=5,2,IF(AND($N78>5,$N78<=10),1,IF(AND($N78>10,$N78<=20),0.5,0))),\"\")","v":""},null,{"$f":"IF(OR(O78=\"\",P78=\"\",N78=\"\",N78=\"Projet ?\",O78=\"(F ou G)\"),\"\",IF(R78=\"\",\"Note tech ?\",IF(AND(R78<=4,R78>=0),R78+Q78+P78+O78,\"Err Nt tech.\")))","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L79<>\"\",IF(OR(C79=\"G\",C79=\"M\"),LOOKUP(L79,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C79=\"F\",LOOKUP(L79,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M79<>\"\",IF(OR(C79=\"G\",C79=\"M\"),LOOKUP(M79,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C79=\"F\",LOOKUP(M79,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L80<>\"\",IF(OR(C80=\"G\",C80=\"M\"),LOOKUP(L80,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C80=\"F\",LOOKUP(L80,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M80<>\"\",IF(OR(C80=\"G\",C80=\"M\"),LOOKUP(M80,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C80=\"F\",LOOKUP(M80,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L81<>\"\",IF(OR(C81=\"G\",C81=\"M\"),LOOKUP(L81,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C81=\"F\",LOOKUP(L81,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M81<>\"\",IF(OR(C81=\"G\",C81=\"M\"),LOOKUP(M81,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C81=\"F\",LOOKUP(M81,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L82<>\"\",IF(OR(C82=\"G\",C82=\"M\"),LOOKUP(L82,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C82=\"F\",LOOKUP(L82,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M82<>\"\",IF(OR(C82=\"G\",C82=\"M\"),LOOKUP(M82,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C82=\"F\",LOOKUP(M82,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L83<>\"\",IF(OR(C83=\"G\",C83=\"M\"),LOOKUP(L83,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C83=\"F\",LOOKUP(L83,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M83<>\"\",IF(OR(C83=\"G\",C83=\"M\"),LOOKUP(M83,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C83=\"F\",LOOKUP(M83,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L84<>\"\",IF(OR(C84=\"G\",C84=\"M\"),LOOKUP(L84,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C84=\"F\",LOOKUP(L84,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M84<>\"\",IF(OR(C84=\"G\",C84=\"M\"),LOOKUP(M84,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C84=\"F\",LOOKUP(M84,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L85<>\"\",IF(OR(C85=\"G\",C85=\"M\"),LOOKUP(L85,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C85=\"F\",LOOKUP(L85,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M85<>\"\",IF(OR(C85=\"G\",C85=\"M\"),LOOKUP(M85,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C85=\"F\",LOOKUP(M85,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L86<>\"\",IF(OR(C86=\"G\",C86=\"M\"),LOOKUP(L86,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C86=\"F\",LOOKUP(L86,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M86<>\"\",IF(OR(C86=\"G\",C86=\"M\"),LOOKUP(M86,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C86=\"F\",LOOKUP(M86,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L87<>\"\",IF(OR(C87=\"G\",C87=\"M\"),LOOKUP(L87,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C87=\"F\",LOOKUP(L87,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M87<>\"\",IF(OR(C87=\"G\",C87=\"M\"),LOOKUP(M87,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C87=\"F\",LOOKUP(M87,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L88<>\"\",IF(OR(C88=\"G\",C88=\"M\"),LOOKUP(L88,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C88=\"F\",LOOKUP(L88,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M88<>\"\",IF(OR(C88=\"G\",C88=\"M\"),LOOKUP(M88,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C88=\"F\",LOOKUP(M88,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L89<>\"\",IF(OR(C89=\"G\",C89=\"M\"),LOOKUP(L89,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C89=\"F\",LOOKUP(L89,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M89<>\"\",IF(OR(C89=\"G\",C89=\"M\"),LOOKUP(M89,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C89=\"F\",LOOKUP(M89,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L90<>\"\",IF(OR(C90=\"G\",C90=\"M\"),LOOKUP(L90,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C90=\"F\",LOOKUP(L90,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M90<>\"\",IF(OR(C90=\"G\",C90=\"M\"),LOOKUP(M90,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C90=\"F\",LOOKUP(M90,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L91<>\"\",IF(OR(C91=\"G\",C91=\"M\"),LOOKUP(L91,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C91=\"F\",LOOKUP(L91,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M91<>\"\",IF(OR(C91=\"G\",C91=\"M\"),LOOKUP(M91,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C91=\"F\",LOOKUP(M91,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L92<>\"\",IF(OR(C92=\"G\",C92=\"M\"),LOOKUP(L92,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C92=\"F\",LOOKUP(L92,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M92<>\"\",IF(OR(C92=\"G\",C92=\"M\"),LOOKUP(M92,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C92=\"F\",LOOKUP(M92,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L93<>\"\",IF(OR(C93=\"G\",C93=\"M\"),LOOKUP(L93,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C93=\"F\",LOOKUP(L93,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M93<>\"\",IF(OR(C93=\"G\",C93=\"M\"),LOOKUP(M93,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C93=\"F\",LOOKUP(M93,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F94:K94)>0,MAX(F94:K94),\"\")","v":""},{"$f":"IF(COUNTA(F94:K94)<3,\"\",(LARGE(F94:K94,1)+LARGE(F94:K94,2)+LARGE(F94:K94,3))/3)","v":""},{"$f":"IF(M94<>\"\", IF(E94<>\"\",(ABS(M94-E94)/E94)*100,\"Projet ?\"),\"\")","v":""},{"$f":"IF(L94<>\"\",IF(OR(C94=\"G\",C94=\"M\"),LOOKUP(L94,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C94=\"F\",LOOKUP(L94,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M94<>\"\",IF(OR(C94=\"G\",C94=\"M\"),LOOKUP(M94,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C94=\"F\",LOOKUP(M94,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(N94<>\"\",IF($N94<=5,2,IF(AND($N94>5,$N94<=10),1,IF(AND($N94>10,$N94<=20),0.5,0))),\"\")","v":""},null,{"$f":"IF(OR(O94=\"\",P94=\"\",N94=\"\",N94=\"Projet ?\",O94=\"(F ou G)\"),\"\",IF(R94=\"\",\"Note tech ?\",IF(AND(R94<=4,R94>=0),R94+Q94+P94+O94,\"Err Nt tech.\")))","v":""},null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L95<>\"\",IF(OR(C95=\"G\",C95=\"M\"),LOOKUP(L95,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C95=\"F\",LOOKUP(L95,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M95<>\"\",IF(OR(C95=\"G\",C95=\"M\"),LOOKUP(M95,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C95=\"F\",LOOKUP(M95,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L96<>\"\",IF(OR(C96=\"G\",C96=\"M\"),LOOKUP(L96,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C96=\"F\",LOOKUP(L96,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M96<>\"\",IF(OR(C96=\"G\",C96=\"M\"),LOOKUP(M96,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C96=\"F\",LOOKUP(M96,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L97<>\"\",IF(OR(C97=\"G\",C97=\"M\"),LOOKUP(L97,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C97=\"F\",LOOKUP(L97,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M97<>\"\",IF(OR(C97=\"G\",C97=\"M\"),LOOKUP(M97,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C97=\"F\",LOOKUP(M97,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L98<>\"\",IF(OR(C98=\"G\",C98=\"M\"),LOOKUP(L98,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C98=\"F\",LOOKUP(L98,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M98<>\"\",IF(OR(C98=\"G\",C98=\"M\"),LOOKUP(M98,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C98=\"F\",LOOKUP(M98,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L99<>\"\",IF(OR(C99=\"G\",C99=\"M\"),LOOKUP(L99,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C99=\"F\",LOOKUP(L99,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M99<>\"\",IF(OR(C99=\"G\",C99=\"M\"),LOOKUP(M99,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C99=\"F\",LOOKUP(M99,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L100<>\"\",IF(OR(C100=\"G\",C100=\"M\"),LOOKUP(L100,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C100=\"F\",LOOKUP(L100,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M100<>\"\",IF(OR(C100=\"G\",C100=\"M\"),LOOKUP(M100,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C100=\"F\",LOOKUP(M100,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(L101<>\"\",IF(OR(C101=\"G\",C101=\"M\"),LOOKUP(L101,Barème!$D$5:$D$82,Barème!$C$5:$C$82),IF(C101=\"F\",LOOKUP(L101,Barème!$B$5:$B$82,Barème!$C$5:$C$82),\"(F ou G)\")),\"\")","v":""},{"$f":"IF(M101<>\"\",IF(OR(C101=\"G\",C101=\"M\"),LOOKUP(M101,Barème!$H$5:$H$82,Barème!$G$5:$G$82),IF(C101=\"F\",LOOKUP(M101,Barème!$F$5:$F$82,Barème!$G$5:$G$82),\"(F ou G)\")),\"\")","v":""},"",null,"",null,""]

{"sheet":"Barème","index":1,"n_rows":82,"n_cols":8,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Perf fille","Note","Perf garçon",null,"Moy fille","Note","Moy garçon"]
[null,0,0,0,null,0,0,0]
[null,8.59,0,11.19,null,7.79,0,8.99]
[null,8.6,0.5,11.2,null,7.8,0.2,9]
[null,{"$f":"((B10-B7)/3)+B7","v":8.6999999999999993},0.74999999999999989,{"$f":"((D10-D7)/3)+D7","v":11.533333333333333},null,{"$f":"((F10-F7)/3)+F7","v":7.8666666666666663},0.3,{"$f":"((H10-H7)/3)+H7","v":9.3333333333333339}]
[null,{"$f":"((B10-B7)/3)+B8","v":8.7999999999999989},0.87499999999999989,{"$f":"((D10-D7)/3)+D8","v":11.866666666666667},null,{"$f":"((F10-F7)/3)+F8","v":7.9333333333333327},0.35,{"$f":"((H10-H7)/3)+H8","v":9.6666666666666679}]
[null,8.9,1,12.2,null,8,0.4,10]
[null,{"$f":"(B10+B12)/2","v":8.9750000000000014},1.125,{"$f":"(D10+D12)/2","v":12.35},null,{"$f":"(F10+F12)/2","v":8.0500000000000007},0.45,{"$f":"(H10+H12)/2","v":10.25}]
[null,{"$f":"(B14+B10)/2","v":9.0500000000000007},1.25,{"$f":"(D14+D10)/2","v":12.5},null,{"$f":"(F14+F10)/2","v":8.1},0.5,{"$f":"(H14+H10)/2","v":10.5}]
[null,{"$f":"(B12+B14)/2","v":9.125},1.375,{"$f":"(D12+D14)/2","v":12.65},null,{"$f":"(F12+F14)/2","v":8.1499999999999986},0.55000000000000004,{"$f":"(H12+H14)/2","v":10.75}]
[null,9.1999999999999993,1.4999999999999998,12.8,null,8.1999999999999993,0.6,11]
[null,{"$f":"(B14+B16)/2","v":9.2749999999999986},1.625,{"$f":"(D14+D16)/2","v":12.950000000000001},null,{"$f":"(F14+F16)/2","v":8.375},0.65,{"$f":"(H14+H16)/2","v":11.3}]
[null,{"$f":"(B18+B14)/2","v":9.35},1.7499999999999998,{"$f":"(D18+D14)/2","v":13.100000000000001},null,{"$f":"(F18+F14)/2","v":8.5500000000000007},0.7,{"$f":"(H18+H14)/2","v":11.6}]
[null,{"$f":"(B16+B18)/2","v":9.4250000000000007},1.875,{"$f":"(D16+D18)/2","v":13.25},null,{"$f":"(F16+F18)/2","v":8.7250000000000014},0.75,{"$f":"(H16+H18)/2","v":11.899999999999999}]
[null,9.5,2,13.4,null,8.9,0.8,12.2]
[null,{"$f":"(B18+B20)/2","v":9.625},2.125,{"$f":"(D18+D20)/2","v":13.55},null,{"$f":"(F18+F20)/2","v":9.0500000000000007},0.85,{"$f":"(H18+H20)/2","v":12.35}]
[null,{"$f":"(B22+B18)/2","v":9.75},2.25,{"$f":"(D22+D18)/2","v":13.7},null,{"$f":"(F22+F18)/2","v":9.1999999999999993},0.9,{"$f":"(H22+H18)/2","v":12.5}]
[null,{"$f":"(B20+B22)/2","v":9.875},2.3749999999999996,{"$f":"(D20+D22)/2","v":13.85},null,{"$f":"(F20+F22)/2","v":9.35},0.95,{"$f":"(H20+H22)/2","v":12.65}]
[null,10,2.5,14,null,9.5,1,12.8]
[null,{"$f":"(B22+B24)/2","v":10.125},2.625,{"$f":"(D22+D24)/2","v":14.3},null,{"$f":"(F22+F24)/2","v":9.625},1.05,{"$f":"(H22+H24)/2","v":12.950000000000001}]
[null,{"$f":"(B26+B22)/2","v":10.25},2.75,{"$f":"(D26+D22)/2","v":14.6},null,{"$f":"(F26+F22)/2","v":9.75},1.1000000000000001,{"$f":"(H26+H22)/2","v":13.100000000000001}]
[null,{"$f":"(B24+B26)/2","v":10.375},2.8749999999999996,{"$f":"(D24+D26)/2","v":14.899999999999999},null,{"$f":"(F24+F26)/2","v":9.875},1.1499999999999999,{"$f":"(H24+H26)/2","v":13.25}]
[null,10.5,2.9999999999999996,15.2,null,10,1.2,13.4]
[null,{"$f":"(B26+B28)/2","v":10.65},3.125,{"$f":"(D26+D28)/2","v":15.5},null,{"$f":"(F26+F28)/2","v":10.125},1.25,{"$f":"(H26+H28)/2","v":13.55}]
[null,{"$f":"(B30+B26)/2","v":10.8},3.25,{"$f":"(D30+D26)/2","v":15.799999999999999},null,{"$f":"(F30+F26)/2","v":10.25},1.3,{"$f":"(H30+H26)/2","v":13.7}]
[null,{"$f":"(B28+B30)/2","v":10.95},3.375,{"$f":"(D28+D30)/2","v":16.099999999999998},null,{"$f":"(F28+F30)/2","v":10.375},1.35,{"$f":"(H28+H30)/2","v":13.85}]
[null,11.1,3.4999999999999996,16.399999999999999,null,10.5,1.4,14]
[null,{"$f":"(B30+B32)/2","v":11.25},3.6249999999999996,{"$f":"(D30+D32)/2","v":16.7},null,{"$f":"(F30+F32)/2","v":10.65},1.45,{"$f":"(H30+H32)/2","v":14.3}]
[null,{"$f":"(B34+B30)/2","v":11.399999999999999},3.75,{"$f":"(D34+D30)/2","v":17},null,{"$f":"(F34+F30)/2","v":10.8},1.5,{"$f":"(H34+H30)/2","v":14.6}]
[null,{"$f":"(B32+B34)/2","v":11.549999999999999},3.875,{"$f":"(D32+D34)/2","v":17.3},null,{"$f":"(F32+F34)/2","v":10.95},1.55,{"$f":"(H32+H34)/2","v":14.899999999999999}]
[null,11.7,4,17.600000000000001,null,11.1,1.6,15.2]
[null,{"$f":"(B34+B36)/2","v":11.85},4.1249999999999991,{"$f":"(D34+D36)/2","v":17.900000000000002},null,{"$f":"(F34+F36)/2","v":11.25},1.65,{"$f":"(H34+H36)/2","v":15.5}]
[null,{"$f":"(B38+B34)/2","v":12},4.25,{"$f":"(D38+D34)/2","v":18.200000000000003},null,{"$f":"(F38+F34)/2","v":11.399999999999999},1.7,{"$f":"(H38+H34)/2","v":15.799999999999999}]
[null,{"$f":"(B36+B38)/2","v":12.15},4.375,{"$f":"(D36+D38)/2","v":18.5},null,{"$f":"(F36+F38)/2","v":11.549999999999999},1.75,{"$f":"(H36+H38)/2","v":16.099999999999998}]
[null,12.3,4.5,18.8,null,11.7,1.8,16.399999999999999]
[null,{"$f":"(B38+B40)/2","v":12.450000000000001},4.625,{"$f":"(D38+D40)/2","v":19.100000000000001},null,{"$f":"(F38+F40)/2","v":11.85},1.85,{"$f":"(H38+H40)/2","v":16.7}]
[null,{"$f":"(B42+B38)/2","v":12.600000000000001},4.7499999999999991,{"$f":"(D42+D38)/2","v":19.399999999999999},null,{"$f":"(F42+F38)/2","v":12},1.9,{"$f":"(H42+H38)/2","v":17}]
[null,{"$f":"(B40+B42)/2","v":12.75},4.875,{"$f":"(D40+D42)/2","v":19.7},null,{"$f":"(F40+F42)/2","v":12.15},1.95,{"$f":"(H40+H42)/2","v":17.3}]
[null,12.9,5,20,null,12.3,2,17.600000000000001]
[null,{"$f":"(B42+B44)/2","v":13.05},5.1249999999999991,{"$f":"(D42+D44)/2","v":20.375},null,{"$f":"(F42+F44)/2","v":12.450000000000001},2.0499999999999998,{"$f":"(H42+H44)/2","v":17.900000000000002}]
[null,{"$f":"(B46+B42)/2","v":13.2},5.25,{"$f":"(D46+D42)/2","v":20.75},null,{"$f":"(F46+F42)/2","v":12.600000000000001},2.1,{"$f":"(H46+H42)/2","v":18.200000000000003}]
[null,{"$f":"(B44+B46)/2","v":13.35},5.3749999999999991,{"$f":"(D44+D46)/2","v":21.125},null,{"$f":"(F44+F46)/2","v":12.75},2.15,{"$f":"(H44+H46)/2","v":18.5}]
[null,13.5,5.5,21.5,null,12.9,2.2000000000000002,18.8]
[null,{"$f":"(B46+B48)/2","v":13.65},5.625,{"$f":"(D46+D48)/2","v":21.875},null,{"$f":"(F46+F48)/2","v":13.05},2.25,{"$f":"(H46+H48)/2","v":19.100000000000001}]
[null,{"$f":"(B50+B46)/2","v":13.8},5.7499999999999991,{"$f":"(D50+D46)/2","v":22.25},null,{"$f":"(F50+F46)/2","v":13.2},2.2999999999999998,{"$f":"(H50+H46)/2","v":19.399999999999999}]
[null,{"$f":"(B48+B50)/2","v":13.95},5.875,{"$f":"(D48+D50)/2","v":22.625},null,{"$f":"(F48+F50)/2","v":13.35},2.35,{"$f":"(H48+H50)/2","v":19.7}]
[null,14.1,5.9999999999999991,23,null,13.5,2.4,20]
[null,{"$f":"(B50+B52)/2","v":14.375},6.125,{"$f":"(D50+D52)/2","v":23.375},null,{"$f":"(F50+F52)/2","v":13.65},2.4500000000000002,{"$f":"(H50+H52)/2","v":20.375}]
[null,{"$f":"(B54+B50)/2","v":14.649999999999999},6.25,{"$f":"(D54+D50)/2","v":23.75},null,{"$f":"(F54+F50)/2","v":13.8},2.5,{"$f":"(H54+H50)/2","v":20.75}]
[null,{"$f":"(B52+B54)/2","v":14.924999999999999},6.3749999999999991,{"$f":"(D52+D54)/2","v":24.125},null,{"$f":"(F52+F54)/2","v":13.95},2.5499999999999998,{"$f":"(H52+H54)/2","v":21.125}]
[null,15.2,6.5,24.5,null,14.1,2.6,21.5]
[null,{"$f":"(B54+B56)/2","v":15.475},6.6249999999999991,{"$f":"(D54+D56)/2","v":24.625},null,{"$f":"(F54+F56)/2","v":14.375},2.65,{"$f":"(H54+H56)/2","v":21.875}]
[null,{"$f":"(B58+B54)/2","v":15.75},6.75,{"$f":"(D58+D54)/2","v":24.75},null,{"$f":"(F58+F54)/2","v":14.649999999999999},2.7,{"$f":"(H58+H54)/2","v":22.25}]
[null,{"$f":"(B56+B58)/2","v":16.024999999999999},6.875,{"$f":"(D56+D58)/2","v":24.875},null,{"$f":"(F56+F58)/2","v":14.924999999999999},2.75,{"$f":"(H56+H58)/2","v":22.625}]
[null,16.3,6.9999999999999991,25,null,15.2,2.8,23]
[null,{"$f":"(B58+B60)/2","v":16.575000000000003},7.125,{"$f":"(D58+D60)/2","v":25.375},null,{"$f":"(F58+F60)/2","v":15.475},2.85,{"$f":"(H58+H60)/2","v":23.375}]
[null,{"$f":"(B62+B58)/2","v":16.850000000000001},7.2499999999999991,{"$f":"(D62+D58)/2","v":25.75},null,{"$f":"(F62+F58)/2","v":15.75},2.9,{"$f":"(H62+H58)/2","v":23.75}]
[null,{"$f":"(B60+B62)/2","v":17.125},7.375,{"$f":"(D60+D62)/2","v":26.125},null,{"$f":"(F60+F62)/2","v":16.024999999999999},2.95,{"$f":"(H60+H62)/2","v":24.125}]
[null,17.399999999999999,7.5,26.5,null,16.3,3,24.5]
[null,{"$f":"(B62+B64)/2","v":17.674999999999997},7.6249999999999991,{"$f":"(D62+D64)/2","v":26.875},null,{"$f":"(F62+F64)/2","v":16.575000000000003},3.05,{"$f":"(H62+H64)/2","v":24.625}]
[null,{"$f":"(B66+B62)/2","v":17.95},7.75,{"$f":"(D66+D62)/2","v":27.25},null,{"$f":"(F66+F62)/2","v":16.850000000000001},3.1,{"$f":"(H66+H62)/2","v":24.75}]
[null,{"$f":"(B64+B66)/2","v":18.225000000000001},7.8749999999999991,{"$f":"(D64+D66)/2","v":27.625},null,{"$f":"(F64+F66)/2","v":17.125},3.15,{"$f":"(H64+H66)/2","v":24.875}]
[null,18.5,8,28,null,17.399999999999999,3.2,25]
[null,{"$f":"(B66+B68)/2","v":18.774999999999999},8.125,{"$f":"(D66+D68)/2","v":28.375},null,{"$f":"(F66+F68)/2","v":17.674999999999997},3.25,{"$f":"(H66+H68)/2","v":25.375}]
[null,{"$f":"(B70+B66)/2","v":19.05},8.2499999999999982,{"$f":"(D70+D66)/2","v":28.75},null,{"$f":"(F70+F66)/2","v":17.95},3.3,{"$f":"(H70+H66)/2","v":25.75}]
[null,{"$f":"(B68+B70)/2","v":19.325000000000003},8.375,{"$f":"(D68+D70)/2","v":29.125},null,{"$f":"(F68+F70)/2","v":18.225000000000001},3.35,{"$f":"(H68+H70)/2","v":26.125}]
[null,19.600000000000001,8.5,29.5,null,18.5,3.4,26.5]
[null,{"$f":"(B70+B72)/2","v":19.900000000000002},8.625,{"$f":"(D70+D72)/2","v":29.875},null,{"$f":"(F70+F72)/2","v":18.774999999999999},3.45,{"$f":"(H70+H72)/2","v":26.875}]
[null,{"$f":"(B74+B70)/2","v":20.200000000000003},8.75,{"$f":"(D74+D70)/2","v":30.25},null,{"$f":"(F74+F70)/2","v":19.05},3.5,{"$f":"(H74+H70)/2","v":27.25}]
[null,{"$f":"(B72+B74)/2","v":20.5},8.8749999999999982,{"$f":"(D72+D74)/2","v":30.625},null,{"$f":"(F72+F74)/2","v":19.325000000000003},3.55,{"$f":"(H72+H74)/2","v":27.625}]
[null,20.8,9,31,null,19.600000000000001,3.6,28]
[null,{"$f":"(B74+B76)/2","v":21.1},9.125,{"$f":"(D74+D76)/2","v":31.375},null,{"$f":"(F74+F76)/2","v":19.900000000000002},3.65,{"$f":"(H74+H76)/2","v":28.375}]
[null,{"$f":"(B78+B74)/2","v":21.4},9.25,{"$f":"(D78+D74)/2","v":31.75},null,{"$f":"(F78+F74)/2","v":20.200000000000003},3.7,{"$f":"(H78+H74)/2","v":28.75}]
[null,{"$f":"(B76+B78)/2","v":21.7},9.375,{"$f":"(D76+D78)/2","v":32.125},null,{"$f":"(F76+F78)/2","v":20.5},3.75,{"$f":"(H76+H78)/2","v":29.125}]
[null,22,9.4999999999999982,32.5,null,20.8,3.8,29.5]
[null,{"$f":"(B78+B80)/2","v":22.25},9.625,{"$f":"(D78+D80)/2","v":32.875},null,{"$f":"(F78+F80)/2","v":21.1},3.85,{"$f":"(H78+H80)/2","v":29.875}]
[null,{"$f":"(B82+B78)/2","v":22.5},9.75,{"$f":"(D82+D78)/2","v":33.25},null,{"$f":"(F82+F78)/2","v":21.4},3.9,{"$f":"(H82+H78)/2","v":30.25}]
[null,{"$f":"(B80+B82)/2","v":22.75},9.875,{"$f":"(D80+D82)/2","v":33.625},null,{"$f":"(F80+F82)/2","v":21.7},3.95,{"$f":"(H80+H82)/2","v":30.625}]
[null,23,10,34,null,22,4,31]