{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["1TA","1HB","1LA","1TB","1LB","1HA","1TC","1EA","1EB","1TE","1TD","MODELLO"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"1TA","index":0,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,8,3,9],[3,10,3,12],[0,0,0,20],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[6,8,6,9],[6,10,6,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[9,8,9,9],[9,10,9,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[31,8,31,9],[31,10,31,12],[38,13,38,16],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12]]}
[]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,null,"X","M",2002,78.900000000000006,170,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":27.301038062283741},"D",null,"S",null,null,0,150,575,2866,"+","=",{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[2,null,"X","M",2001,73.7,176,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":23.792613636363637},"D",null,"I",null,null,-31,167,616,null,null,null,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[3,null,"X","M",2001,62.4,172,21.092482422931315,"D",null,"S",null,null,0,194,462,2238,"+","+","??","Normopeso"]
[4,null,"X","M",1998,80.2,179,25.030429761867609,"D",null,"N",null,null,0,225,503,2369,"+","+","??","Normopeso"]
[5,null,null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[6,null,"X","M",2001,53.7,172,18.151703623580318,"D",null,"S",null,null,-23,214,462,2334,"+","=","??","Sottopeso"]
[7,null,"X","M",2001,48.1,170,16.643598615916957,"D",null,"S",null,null,-15,201,525,2745,"+","=","??","Sottopeso"]
[8,null,"X","M",2000,68.2,172,23.053001622498652,"D",null,"N",null,null,-19,154,650,3131,"+","=","??","Normopeso"]
[9,null,"X","M",2001,75.8,171,25.922506070243838,"D",null,"I",null,null,18,166,590,2903,"=","=","??","Normopeso"]
[10,null,null,"M",2000,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[11,null,"X","M",2002,90,178,28.405504355510669,"D",null,"I",null,null,"#-13","134#","747#","3700#","-","-","??","Sovrappeso"]
[12,null,"X","M",2001,57.2,174,18.89285242436253,"D",null,"I",null,null,-9,174,507,2353,"+","+","??","Sottopeso"]
[13,null,"X","M",1999,79.099999999999994,178,24.965282161343261,"S",null,"N",null,null,-14,178,631,3278,"=","-","??","Normopeso"]
[14,null,"X","M",2001,48.5,158,19.427976285851624,"D",null,"S",null,null,-21,183,531,2447,"-","+","??","Sottopeso"]
[15,null,"X","M",2001,45.7,157,18.540305894762465,"D",null,"S",null,null,-20,195,516,2431,"+","=","??","Sottopeso"]
[16,null,"X","F",2001,58.2,156,23.915187376725836,"D",null,"S",null,null,22,null,null,null,null,null,"??","Normopeso"]
[17,null,"X","M",2001,52.7,158,21.11039897452331,"D",null,"I",null,null,-15,172,506,2231,"=","-","??","Normopeso"]
[18,null,"X","M",2001,70,170,24.221453287197235,"D",null,"I",null,null,6,215,478,2350,"++","=","??","Normopeso"]
[19,null,null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[20,null,null,"M",1999,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[21,null,"X","M",2000,47,162,17.908855357415025,"D",null,"S",null,null,1,191,487,2241,"+","+","??","Sottopeso"]
[22,null,"X","M",2000,68.5,163,25.781926305092401,"D",null,"S",null,null,-18,176,491,2331,"+","++","??","Normopeso"]
[23,null,null,"M",2002,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[24,null,"X","M",2001,58.5,169,20.482476103777881,"D",null,"S",null,null,9,225,457,2125,"+","++","??","Sottopeso"]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":0},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2000.6666666666667},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":64.021052631578954},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":168.68421052631578},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":22.349452228539377},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.94736842105263153},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":5.2631578947368418E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.52631578947368418},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.15789473684210525},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.31578947368421051},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-7.166666666666667},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":187.05882352941177},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":528.64705882352939},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2523.3125},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":5.8823529411764705E-2},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.11764705882352941}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.94736842105263153},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2000.6666666666667},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":64.344444444444463},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":169.38888888888889},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":22.26246694252902},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.94444444444444442},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":5.5555555555555552E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.5},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.16666666666666666},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.33333333333333331},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-8.882352941176471},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":187.05882352941177},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":528.64705882352939},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2523.3125},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.6470588235294118},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.29411764705882354}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":5.2631578947368418E-2},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":58.2},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":156},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":23.915187376725836},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":22},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.17647058823529413},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.41176470588235292}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":19},null,null,null,null,null,null,null,null,null,null,"Record",null,null,null,{"$f":"COUNTIF(R$3:R$32,\"-\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.11764705882352941},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.17647058823529413}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":22},{"$f":"MAX(O3:O32)","v":225},{"$f":"MIN(P3:P32)","v":457},{"$f":"MIN(Q3:Q32)","v":2125},{"$f":"COUNTIF(R$3:R$32,\"--\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0},{"$f":"COUNTIF(S$3:S$32,\"--\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":0}]

{"sheet":"1HB","index":1,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,16],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[9,8,9,9],[9,10,9,12],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[6,8,6,9],[6,10,6,12],[3,8,3,9],[3,10,3,12],[0,0,0,20],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12]]}
["1HB"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,null,"X","F",2001,53.2,169,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":18.626798781555269},"D",null,"N",null,null,-30,null,null,null,null,null,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[2,null,"X","M",1999,75.3,172,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":25.452947539210385},"D",null,"I",null,null,0,null,null,null,null,null,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[3,null,"X","M",2001,48.7,161,18.787855406813009,"D",null,"S",null,null,-27,null,null,null,null,null,"??","Sottopeso"]
[4,null,"X","M",1999,59.4,164,22.08506841165973,"D",null,"I",null,null,-2,null,null,null,null,null,"??","Normopeso"]
[5,null,"X","M",2001,65.2,171,22.297459047228209,"D",null,"I",null,null,-5,null,null,null,null,null,"??","Normopeso"]
[6,null,null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[7,null,"X","M",2001,90.7,175,29.616326530612245,"S",null,"I",null,null,-14,null,null,null,null,null,"??","Sovrappeso"]
[8,null,"X","M",2001,69.7,163,26.233580488539278,"D",null,"I",null,null,-15,null,null,null,null,null,"??","Normopeso"]
[9,null,"X","M",2001,57.8,174,19.091029198044655,"D",null,"I",null,null,-7,null,null,null,null,null,"??","Sottopeso"]
[10,null,"X","M",2001,66.7,176,21.532799586776861,"D",null,"S",null,null,3,null,null,null,null,null,"??","Normopeso"]
[11,null,"X","M",2001,57.3,152,24.80090027700831,"D",null,"I",null,null,4,null,null,null,null,null,"??","Normopeso"]
[12,null,"X","M",2001,44.3,161,17.090390031248791,"D",null,"I",null,null,-2,null,null,null,null,null,"??","Sottopeso"]
[13,null,"X","M",2002,63.2,168,22.39229024943311,"D",null,"S",null,null,5,null,null,null,null,null,"??","Normopeso"]
[14,null,"X","M",2000,68.099999999999994,172,23.019199567333693,"D",null,"S",null,null,20,null,null,null,null,null,"??","Normopeso"]
[15,null,"X","M",1999,59,166,21.410944984758313,"D",null,"S",null,null,-14,null,null,null,null,null,"??","Normopeso"]
[16,null,"X","M",2001,63.4,175,20.70204081632653,"D",null,"P",null,null,2,null,null,null,null,null,"??","Normopeso"]
[17,null,"X","M",2001,68.8,162,26.215515927450078,"D",null,"S",null,null,-5,null,null,null,null,null,"??","Normopeso"]
[18,null,"X","M",2001,47.2,154,{"$f":"IF(C20 = \"X\",F20/(G20/100)^2,\"\")","v":19.902175746331594},"D",null,"S",null,null,-14,null,null,null,null,null,{"$f":"IF(AND(C20<>\"X\",B20<>\"\"),\"Assente\",IF(AND(B20=\"\",C20=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C20=\"X\",D20=\"M\"),IF(H20<>\"\",IF(H20<20.7,\"Sottopeso\",IF(H20>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C20=\"X\",D20=\"F\"),IF(H20<>\"\",IF(H20<19.1,\"Sottopeso\",IF(H20>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[19,null,"X","M",2000,59.1,166,{"$f":"IF(C21 = \"X\",F21/(G21/100)^2,\"\")","v":21.447234722020614},"D",null,"I",null,null,10,null,null,null,null,null,{"$f":"IF(AND(C21<>\"X\",B21<>\"\"),\"Assente\",IF(AND(B21=\"\",C21=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C21=\"X\",D21=\"M\"),IF(H21<>\"\",IF(H21<20.7,\"Sottopeso\",IF(H21>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C21=\"X\",D21=\"F\"),IF(H21<>\"\",IF(H21<19.1,\"Sottopeso\",IF(H21>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[20,null,"X","M",1999,53.5,164,{"$f":"IF(C22 = \"X\",F22/(G22/100)^2,\"\")","v":19.891433670434267},"D",null,"I",null,null,null,null,null,null,null,null,{"$f":"IF(AND(C22<>\"X\",B22<>\"\"),\"Assente\",IF(AND(B22=\"\",C22=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C22=\"X\",D22=\"M\"),IF(H22<>\"\",IF(H22<20.7,\"Sottopeso\",IF(H22>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C22=\"X\",D22=\"F\"),IF(H22<>\"\",IF(H22<19.1,\"Sottopeso\",IF(H22>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[21,null,"X","M",1997,100,170,{"$f":"IF(C23 = \"X\",F23/(G23/100)^2,\"\")","v":34.602076124567475},"D",null,"I",null,null,3,null,null,null,null,null,{"$f":"IF(AND(C23<>\"X\",B23<>\"\"),\"Assente\",IF(AND(B23=\"\",C23=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C23=\"X\",D23=\"M\"),IF(H23<>\"\",IF(H23<20.7,\"Sottopeso\",IF(H23>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C23=\"X\",D23=\"F\"),IF(H23<>\"\",IF(H23<19.1,\"Sottopeso\",IF(H23>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sovrappeso"}]
[22,null,null,null,null,null,null,{"$f":"IF(C24 = \"X\",F24/(G24/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C24<>\"X\",B24<>\"\"),\"Assente\",IF(AND(B24=\"\",C24=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C24=\"X\",D24=\"M\"),IF(H24<>\"\",IF(H24<20.7,\"Sottopeso\",IF(H24>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C24=\"X\",D24=\"F\"),IF(H24<>\"\",IF(H24<19.1,\"Sottopeso\",IF(H24>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""}]
[23,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":0},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2000.3809523809523},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":63.529999999999994},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":166.75},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":22.759903355367619},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.95},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.05},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.35},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.05},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.55000000000000004},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-4.6315789473684212},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.95},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2000.3157894736842},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":64.073684210526309},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":166.63157894736841},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":22.977435175041954},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.94736842105263153},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":5.2631578947368418E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.36842105263157893},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.57894736842105265},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-3.2222222222222223},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.05},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":53.2},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":169},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":18.626798781555269},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":-30},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":20},null,null,null,null,null,null,null,null,null,null,"Record",null,null,null,{"$f":"COUNTIF(R$3:R$32,\"-\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":20},{"$f":"MAX(O3:O32)","v":0},{"$f":"MIN(P3:P32)","v":0},{"$f":"MIN(Q3:Q32)","v":0},{"$f":"COUNTIF(R$3:R$32,\"--\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"--\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":{"$error":"#N/A"}},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":{"$error":"#N/A"}},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":{"$error":"#N/A"}}]

{"sheet":"1LA","index":2,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,8,3,9],[3,10,3,12],[0,0,0,20],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[6,8,6,9],[6,10,6,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[9,8,9,9],[9,10,9,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[31,8,31,9],[31,10,31,12],[38,13,38,16],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12]]}
[]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,null,"X","M",2001,63.6,168,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":22.53401360544218},"S",null,"S",null,null,-14,184,504,2334,"=","++",{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[2,null,"X","F",2001,48,157,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":19.473406629072173},"D",null,"N",null,null,-2,131,603,3087,"=","=",{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[3,null,"X","F",2001,42.9,154,18.089053803339517,"D",null,"I",null,null,1,152,575,2681,"=","++","??","Sottopeso"]
[4,null,"X","F",2001,69.900000000000006,161,26.966552216349676,"D",null,"I",null,null,0,111,656,3347,"-","=","??","Normopeso"]
[5,null,"X","F",2001,54.7,151,23.990175869479408,"D",null,"I",null,null,0,122,590,2910,"+","+","??","Normopeso"]
[6,null,"X","M",2001,52.5,166,19.052112062708666,"D",null,"S",null,null,-10,223,472,2097,"+","=","??","Sottopeso"]
[7,null,"X","F",2001,62.3,160,24.335937499999993,"D",null,"I",null,null,12,163,519,2456,"++","=","??","Normopeso"]
[8,null,"X","F",2001,35.6,149,16.035313724607001,"D",null,"I",null,null,4,150,530,2765,"+","-","??","Sottopeso"]
[9,null,"X","F",2001,32.299999999999997,162,12.307575064776707,"D",null,"I",null,null,-7,123,629,3540,"-","=","??","Sottopeso"]
[10,null,"X","M",2001,57.2,170,19.792387543252598,"D",null,"S",null,null,11,200,475,2306,"+","=","??","Sottopeso"]
[11,null,"X","M",2001,59.3,168,21.010487528344672,"D",null,"S",null,null,-6,178,506,2338,"=","=","??","Normopeso"]
[12,null,null,"F",1999,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[13,null,"X","M",2001,58.7,172,19.841806381828018,"D",null,"N",null,null,0,211,450,2291,"+","+","??","Sottopeso"]
[14,null,"X","M",2001,37.4,158,14.981573465790735,"D",null,"S",null,null,-7,170,591,2482,"+","=","??","Sottopeso"]
[15,null,"X","M",2001,49.4,162,18.823350099070261,"S",null,"S",null,null,3,206,466,2190,"++","+","??","Sottopeso"]
[16,null,"X","M",2000,57.8,173,19.312372615189279,"D",null,"N",null,null,-8,176,503,2384,"=","=","??","Sottopeso"]
[17,null,"X","M",2001,61.2,163,23.034363355790585,"S",null,"I",null,null,3,175,541,2625,"+","=","??","Normopeso"]
[18,null,"X","M",2001,68.900000000000006,174,22.757299511163961,"D",null,"N",null,null,-17,157,540,2806,"-","+","??","Normopeso"]
[19,null,"X","M",2001,43.5,158,17.425092132671043,"D",null,"S",null,null,0,185,550,2316,"+","=","??","Sottopeso"]
[20,null,"X","M",2001,61.8,173,20.648868989942862,"D",null,"S",null,null,8,171,541,2872,"=","++","??","Sottopeso"]
[21,null,"X","M",2000,77.099999999999994,164,28.665972635336111,"D",null,"I",null,null,18,176,534,2512,"=","=","??","Sovrappeso"]
[22,null,"X","M",2001,62.7,176,20.241477272727273,"D",null,"I",null,null,-7,218,457,2263,"+","++","??","Sottopeso"]
[23,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":0},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2000.8181818181818},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":55.085714285714282},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":163.76190476190476},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":20.443771047946797},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.8571428571428571},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.14285714285714285},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.38095238095238093},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.19047619047619047},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.42857142857142855},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-0.8571428571428571},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":170.57142857142858},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":534.85714285714289},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2600.0952380952381},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":9.5238095238095233E-2},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.19047619047619047}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.66666666666666663},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2000.8571428571429},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":57.93571428571429},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":167.5},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":20.580084085661298},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.7857142857142857},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.21428571428571427},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.5714285714285714},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.21428571428571427},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.21428571428571427},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-1.8571428571428572},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":187.85714285714286},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":509.28571428571428},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2415.4285714285716},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.42857142857142855},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.19047619047619047}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.33333333333333331},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":49.385714285714293},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":156.28571428571428},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":20.171144972517784},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.14285714285714285},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.14285714285714285},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":1.1428571428571428},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":136},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":586},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":2969.4285714285716},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.33333333333333331},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.5714285714285714}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":21},null,null,null,null,null,null,null,null,null,null,"Record",null,null,null,{"$f":"COUNTIF(R$3:R$32,\"-\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.14285714285714285},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":4.7619047619047616E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":18},{"$f":"MAX(O3:O32)","v":223},{"$f":"MIN(P3:P32)","v":450},{"$f":"MIN(Q3:Q32)","v":2097},{"$f":"COUNTIF(R$3:R$32,\"--\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0},{"$f":"COUNTIF(S$3:S$32,\"--\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":0}]

{"sheet":"1TB","index":3,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,16],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[9,8,9,9],[9,10,9,12],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[6,8,6,9],[6,10,6,12],[3,8,3,9],[3,10,3,12],[0,0,0,20],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12]]}
["1TB"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,"Aly Zynan El Sayed Moham","X","F",2001,53.2,169,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":18.626798781555269},"D",null,"N",null,null,-30,null,null,null,null,null,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[2,"Bantugan John Andrei","X","M",1999,75.3,172,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":25.452947539210385},"D",null,"I",null,null,0,null,null,null,null,null,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[3,"Cardoso Valdes","X","M",2001,48.7,161,18.787855406813009,"D",null,"S",null,null,-27,null,null,null,null,null,"","Sottopeso"]
[4,"Camerani Alessandro","X","M",1999,59.4,164,22.08506841165973,"D",null,"I",null,null,-2,null,null,null,null,null,"","Normopeso"]
[5,"Coppi Mirko","X","M",2001,65.2,171,22.297459047228209,"D",null,"I",null,null,-5,null,null,null,null,null,"","Normopeso"]
[6,"Crescenzi Simone",null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[7,"De leon John Marlon Dela Cru","X","M",2001,90.7,175,29.616326530612245,"S",null,"I",null,null,-14,null,null,null,null,null,"","Sovrappeso"]
[8,"Dentale Alessio","X","M",2001,69.7,163,26.233580488539278,"D",null,"I",null,null,-15,null,null,null,null,null,"","Normopeso"]
[9,"Di domenico Alessio","X","M",2001,57.8,174,19.091029198044655,"D",null,"I",null,null,-7,null,null,null,null,null,"","Sottopeso"]
[10,"Elyas Abramo","X","M",2001,66.7,176,21.532799586776861,"D",null,"S",null,null,3,null,null,null,null,null,"","Normopeso"]
[11,"Felicioni Dario","X","M",2001,57.3,152,24.80090027700831,"D",null,"I",null,null,4,null,null,null,null,null,"","Normopeso"]
[12,"Ferru Alessio","X","M",2001,44.3,161,17.090390031248791,"D",null,"I",null,null,-2,null,null,null,null,null,"","Sottopeso"]
[13,"Giuseppetti Jacopo","X","M",2002,63.2,168,22.39229024943311,"D",null,"S",null,null,5,null,null,null,null,null,"","Normopeso"]
[14,"Meloni Mirko","X","M",2000,68.099999999999994,172,23.019199567333693,"D",null,"S",null,null,20,null,null,null,null,null,"","Normopeso"]
[15,"Hernandez Ralph","X","M",1999,59,166,21.410944984758313,"D",null,"S",null,null,-14,null,null,null,null,null,"","Normopeso"]
[16,"Pagnotta Lorenzo","X","M",2001,63.4,175,20.70204081632653,"D",null,"P",null,null,2,null,null,null,null,null,"","Normopeso"]
[17,"Pischedda Massimo","X","M",2001,68.8,162,26.215515927450078,"D",null,"S",null,null,-5,null,null,null,null,null,"","Normopeso"]
[18,"Zampieri Matteo","X","M",2001,47.2,154,{"$f":"IF(C20 = \"X\",F20/(G20/100)^2,\"\")","v":19.902175746331594},"D",null,"S",null,null,-14,null,null,null,null,null,{"$f":"IF(AND(C20<>\"X\",B20<>\"\"),\"Assente\",IF(AND(B20=\"\",C20=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C20=\"X\",D20=\"M\"),IF(H20<>\"\",IF(H20<20.7,\"Sottopeso\",IF(H20>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C20=\"X\",D20=\"F\"),IF(H20<>\"\",IF(H20<19.1,\"Sottopeso\",IF(H20>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[19,"Mele Riccardo","X","M",2000,59.1,166,{"$f":"IF(C21 = \"X\",F21/(G21/100)^2,\"\")","v":21.447234722020614},"D",null,"I",null,null,10,null,null,null,null,null,{"$f":"IF(AND(C21<>\"X\",B21<>\"\"),\"Assente\",IF(AND(B21=\"\",C21=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C21=\"X\",D21=\"M\"),IF(H21<>\"\",IF(H21<20.7,\"Sottopeso\",IF(H21>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C21=\"X\",D21=\"F\"),IF(H21<>\"\",IF(H21<19.1,\"Sottopeso\",IF(H21>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[20,"Hernandez Ralph","X","M",1999,53.5,164,{"$f":"IF(C22 = \"X\",F22/(G22/100)^2,\"\")","v":19.891433670434267},"D",null,"I",null,null,null,null,null,null,null,null,{"$f":"IF(AND(C22<>\"X\",B22<>\"\"),\"Assente\",IF(AND(B22=\"\",C22=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C22=\"X\",D22=\"M\"),IF(H22<>\"\",IF(H22<20.7,\"Sottopeso\",IF(H22>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C22=\"X\",D22=\"F\"),IF(H22<>\"\",IF(H22<19.1,\"Sottopeso\",IF(H22>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[21,"Zanitti ","X","M",1997,100,170,{"$f":"IF(C23 = \"X\",F23/(G23/100)^2,\"\")","v":34.602076124567475},"D",null,"I",null,null,3,null,null,null,null,null,{"$f":"IF(AND(C23<>\"X\",B23<>\"\"),\"Assente\",IF(AND(B23=\"\",C23=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C23=\"X\",D23=\"M\"),IF(H23<>\"\",IF(H23<20.7,\"Sottopeso\",IF(H23>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C23=\"X\",D23=\"F\"),IF(H23<>\"\",IF(H23<19.1,\"Sottopeso\",IF(H23>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sovrappeso"}]
[22,null,null,null,null,null,null,{"$f":"IF(C24 = \"X\",F24/(G24/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C24<>\"X\",B24<>\"\"),\"Assente\",IF(AND(B24=\"\",C24=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C24=\"X\",D24=\"M\"),IF(H24<>\"\",IF(H24<20.7,\"Sottopeso\",IF(H24>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C24=\"X\",D24=\"F\"),IF(H24<>\"\",IF(H24<19.1,\"Sottopeso\",IF(H24>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""}]
[23,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":21},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.95238095238095233},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2000.3809523809523},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":63.529999999999994},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":166.75},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":22.759903355367619},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.95},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.05},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.35},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.05},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.55000000000000004},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-4.6315789473684212},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.90476190476190477},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.95},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2000.3157894736842},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":64.073684210526309},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":166.63157894736841},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":22.977435175041954},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.94736842105263153},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":5.2631578947368418E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.36842105263157893},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.57894736842105265},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-3.2222222222222223},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.05},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":53.2},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":169},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":18.626798781555269},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":-30},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":20},null,null,null,null,null,null,null,null,null,null,"Record",null,null,null,{"$f":"COUNTIF(R$3:R$32,\"-\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":20},{"$f":"MAX(O3:O32)","v":0},{"$f":"MIN(P3:P32)","v":0},{"$f":"MIN(Q3:Q32)","v":0},{"$f":"COUNTIF(R$3:R$32,\"--\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"--\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":"Meloni Mirko"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":{"$error":"#N/A"}},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":{"$error":"#N/A"}},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":{"$error":"#N/A"}}]

{"sheet":"1LB","index":4,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,16],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[9,8,9,9],[9,10,9,12],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[6,8,6,9],[6,10,6,12],[3,8,3,9],[3,10,3,12],[0,0,0,20],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12]]}
["1LB"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,null,"X","M",2001,63.7,177,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":20.332599189249578},"D",null,"S",null,null,6,240,462,2222,"+","++",{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[2,null,"X","M",2001,46.8,158,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":18.746995673770225},"D",null,"S",null,null,-9,193,519,2423,"+","++",{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[3,null,"X","M",2001,112.8,175,36.832653061224491,"S",null,"N",null,null,-8,137,678,null,"=","=","??","Sovrappeso"]
[4,null,"X","F",2001,59.3,170,20.519031141868513,"D",null,"N",null,null,21,186,535,2744,"++","++","??","Normopeso"]
[5,null,"X","M",2002,44.8,159,17.720818005616863,"D",null,"S",null,null,-4,182,556,2447,"+","+","??","Sottopeso"]
[6,null,"X","M",2001,62.4,163,23.486017539237459,"D",null,"S",null,null,-13,177,515,2518,"+","=","??","Normopeso"]
[7,null,null,"M",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[8,null,"X","M",2001,61.6,177,19.662293721472118,"D",null,"S",null,null,11,205,498,2304,"=","=","??","Sottopeso"]
[9,null,"X","M",2001,58,166,21.048047612135289,"D",null,"S",null,null,0,180,466,2160,"=","+","??","Normopeso"]
[10,null,"X","M",2001,55.2,163,20.776092438556216,"D",null,"I",null,null,-19,201,509,2538,"-","=","??","Normopeso"]
[11,null,"X","M",2001,43.8,161,16.897496238571041,"D",null,"I",null,null,-10,166,581,2978,"-","=","??","Sottopeso"]
[12,null,"X","M",2001,71.400000000000006,174,23.583036068172813,"D",null,"S",null,null,-14,191,497,2354,"=","+","??","Normopeso"]
[13,null,"X","F",1998,50.9,146,23.878776505911055,"D",null,"I",null,null,-5,130,694,3338,"=","=","??","Normopeso"]
[14,null,"X","M",2001,54.6,161,21.064002160410475,"D",null,"N",null,null,12,241,447,2130,"+","++","??","Normopeso"]
[15,null,"X","M",2001,62.9,173,21.0164054930001,"D",null,"N",null,null,14,201,487,2306,"+","=","??","Normopeso"]
[16,null,"X","M",2001,86.3,174,28.504425947945567,"D",null,"I",null,null,0,150,604,2957,"=","+","??","Sovrappeso"]
[17,null,"X","F",2001,39.200000000000003,156,16.107823800131492,"D",null,"I",null,null,null,150,null,null,"+","+","??","Sottopeso"]
[18,null,"X","M",2001,41.6,160,16.249999999999996,"D",null,"I",null,null,-17,174,590,2650,"=","=","??","Sottopeso"]
[19,null,null,"F",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[20,null,"X","M",2002,52.2,164,19.408090422367643,"D",null,"S",null,null,0,184,512,2257,"=","=","??","Sottopeso"]
[21,null,"X","M",2001,41.7,163,15.69498287477888,"D",null,"I",null,null,-5,200,516,2325,"+","+","??","Sottopeso"]
[22,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[23,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":0},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2000.9473684210527},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":58.378947368421052},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":165.26315789473685},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":21.133136204969464},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.94736842105263153},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":5.2631578947368418E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.42105263157894735},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.21052631578947367},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.36842105263157893},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-2.2222222222222223},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":183.57894736842104},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":537},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2508.8823529411766},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":5.2631578947368418E-2},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.21052631578947367}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.84210526315789469},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.125},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":59.987500000000004},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":166.75},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":21.313997277906797},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.9375},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":6.25E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.5},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.1875},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.3125},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-3.5},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":188.875},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":527.3125},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2437.9333333333334},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.42105263157894735},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.31578947368421051}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.15789473684210525},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2000},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":49.79999999999999},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":157.33333333333334},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":20.168543815970356},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.33333333333333331},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.33333333333333331},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":8},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":155.33333333333334},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":614.5},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":3041},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.42105263157894735},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.47368421052631576}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":19},null,null,null,null,null,null,null,null,null,null,"Record",null,null,null,{"$f":"COUNTIF(R$3:R$32,\"-\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.10526315789473684},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":21},{"$f":"MAX(O3:O32)","v":241},{"$f":"MIN(P3:P32)","v":447},{"$f":"MIN(Q3:Q32)","v":2130},{"$f":"COUNTIF(R$3:R$32,\"--\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0},{"$f":"COUNTIF(S$3:S$32,\"--\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":0}]

{"sheet":"1HA","index":5,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,16],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[9,8,9,9],[9,10,9,12],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[6,8,6,9],[6,10,6,12],[3,8,3,9],[3,10,3,12],[0,0,0,20],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12]]}
[]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,null,"X","F",2001,54.1,156,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":22.230440499671268},"D",null,"N",null,null,4,97,682,3755,"=","=",{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[2,null,"X","F",2001,42.3,151,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":18.551817902723563},"S",null,"N",null,null,6,155,562,2975,"++","=",{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[3,null,"X","F",2000,55.1,159,21.795023931015386,"D",null,"I",null,null,16,175,575,2709,"++","+","??","Normopeso"]
[4,null,"X","M",2001,52.1,150,23.155555555555555,"D",null,"S",null,null,9,149,532,2300,"+","++","??","Normopeso"]
[5,null,"X","M",2000,45.5,161,17.553335133675397,"S",null,"I",null,null,-22,167,544,3001,"++","=","??","Sottopeso"]
[6,null,null,"F",2000,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[7,null,"X","F",2002,70.7,167,25.350496611567287,"S",null,"N",null,null,5,120,706,4305,"+","=","??","Normopeso"]
[8,null,"X","M",1999,53.8,158,21.551033488223037,"D",null,"N",null,null,3,235,472,2209,"+","++","??","Normopeso"]
[9,null,"X","F",2001,49.1,167,17.605507547778696,"D",null,"S",null,null,3,147,535,null,null,null,"??","Sottopeso"]
[10,null,"X","F",2001,45.7,158,18.306361160070498,"D",null,"N",null,null,2,173,575,3700,"+","+","??","Sottopeso"]
[11,null,"X","M",2001,52.5,161,20.253848231163918,"S",null,"I",null,null,-1,82,932,null,"+","+","??","Sottopeso"]
[12,null,"X","F",2000,69,158,27.639801313892001,"D",null,"N",null,null,3,102,682,3505,"+","-","??","Sovrappeso"]
[13,null,null,"F",2000,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[14,null,"X","M",1998,68,174,22.460034350640772,"D",null,"N",null,null,12,229,475,2259,"=","+","??","Normopeso"]
[15,null,"X","F",2002,49.2,154,20.745488277955811,"D",null,"I",null,null,-8,130,719,3705,"-","=","??","Normopeso"]
[16,null,"X","F",2000,53.2,155,22.143600416233088,"D",null,"N",null,null,5,132,650,3304,"+","=","??","Normopeso"]
[17,null,"X","F",2001,41,151,17.981667470724968,"D",null,"S",null,null,7,183,520,2505,"+","++","??","Sottopeso"]
[18,null,"X","M",1997,58.7,159,23.21901823503817,"D",null,"N",null,null,16,222,459,2207,"++","+","??","Normopeso"]
[19,null,"X","F",2001,50,154,21.0828132906055,"D",null,"N",null,null,-3,160,565,2680,"+","-","??","Normopeso"]
[20,null,"X","F",1999,48.2,156,19.806048652202499,"D",null,"S",null,null,-7,147,547,2670,"++","=","??","Normopeso"]
[21,null,"X","F",1999,42.6,162,16.232281664380427,"D",null,"N",null,null,0,159,587,2840,"+","=","??","Sottopeso"]
[22,null,null,"M",1999,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[23,null,"X","M",1998,80.099999999999994,174,26.456599286563613,"D",null,"I",null,null,-11,172,635,null,"+","=","??","Normopeso"]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":0},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2000.0434782608695},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":54.045000000000016},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":159.25},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":21.206038650984073},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.8},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.2},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.55000000000000004},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.25},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":1.95},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":156.80000000000001},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":597.70000000000005},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2978.1764705882351},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.26315789473684209},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.15789473684210525}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.35},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":1999.1428571428571},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":58.671428571428564},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":162.42857142857142},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":22.092774897265777},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.7142857142857143},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.2857142857142857},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.14285714285714285},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.42857142857142855},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.42857142857142855},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":0.8571428571428571},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":179.42857142857142},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":578.42857142857144},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2395.1999999999998},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.57894736842105265},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.26315789473684209}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.65},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2000.6153846153845},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":51.553846153846159},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":157.53846153846155},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":20.728565287601615},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.84615384615384615},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.15384615384615385},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.23076923076923078},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.61538461538461542},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.61538461538461542},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":2.5384615384615383},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":144.61538461538461},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":608.07692307692309},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":3221.0833333333335},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.10526315789473684},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.47368421052631576}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":20},null,null,null,null,null,null,null,null,null,null,"Record",null,null,null,{"$f":"COUNTIF(R$3:R$32,\"-\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":5.2631578947368418E-2},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.10526315789473684}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":16},{"$f":"MAX(O3:O32)","v":235},{"$f":"MIN(P3:P32)","v":459},{"$f":"MIN(Q3:Q32)","v":2207},{"$f":"COUNTIF(R$3:R$32,\"--\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0},{"$f":"COUNTIF(S$3:S$32,\"--\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":0}]

{"sheet":"1TC","index":6,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,8,3,9],[3,10,3,12],[0,0,0,20],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[6,8,6,9],[6,10,6,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[9,8,9,9],[9,10,9,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[31,8,31,9],[31,10,31,12],[38,13,38,16],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12]]}
[]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,null,null,"M",null,null,null,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""}]
[2,null,"X","M",2001,38.1,155,15.858480749219561,"S",null,"I",null,null,-18,142,575,2693,"=","=","??","Sottopeso"]
[3,null,null,"M",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[4,null,"X","M",2000,74,172,25.013520822065985,"D",null,"S",null,null,-7,167,503,2584,"=","+","??","Normopeso"]
[5,null,"X","M",2001,65.599999999999994,149,29.548218548714019,"D",null,"I",null,null,-10,147,622,3063,"-","++","??","Sovrappeso"]
[6,null,"X","M",2001,50.4,170,17.439446366782008,"D",null,"I",null,null,-7,184,525,2425,"+","+","??","Sottopeso"]
[7,null,"X","M",2001,51.3,162,19.547325102880652,"D",null,"S",null,null,0,184,482,2263,"+","=","??","Sottopeso"]
[8,null,"X","M",2001,72.3,174,23.880301228695995,"D",null,"S",null,null,10,225,436,2031,"++","+","??","Normopeso"]
[9,null,null,"M",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[10,null,"X","M",2000,82.5,164,30.673706127305181,"D",null,"I",null,null,-18,151,563,3178,"-","=","??","Sovrappeso"]
[11,null,"X","M",2000,60.6,169,21.217744476734012,"S",null,"I",null,null,6,187,513,2369,"=","=","??","Normopeso"]
[12,null,"X","M",2001,62.7,175,20.473469387755102,"D",null,"I",null,null,-14,184,469,2306,"=","++","??","Sottopeso"]
[13,null,null,"M",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[14,null,"X","M",2002,83.5,161,32.213263377184518,"D",null,"S",null,null,-2,147,600,3028,"+","+","??","Sovrappeso"]
[15,null,null,"M",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[16,null,"X","F",2001,61.7,165,22.662993572084485,"D",null,"N",null,null,2,157,547,2634,"++","=","??","Normopeso"]
[17,null,"X","F",2000,43.7,159,17.285708634943237,"D",null,"I",null,null,-14,132,616,2935,"-","=","??","Sottopeso"]
[18,null,"X","M",2001,70.5,172,23.830448891292594,"D",null,"S",null,null,10,186,487,2600,"+","+","??","Normopeso"]
[19,null,null,"M",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[20,null,"X","M",2000,63.3,164,23.535098155859611,"D",null,"S",null,null,10,null,null,null,null,null,"??","Normopeso"]
[21,null,null,"M",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[22,null,null,"M",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[23,null,null,"M",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[24,null,"X","M",2000,79.400000000000006,173,26.529453038858634,"D",null,"S",null,null,-9,181,489,2412,"+","=","??","Normopeso"]
[25,null,"X","M",2001,68.099999999999994,168,24.12840136054422,"D",null,"S",null,null,0,180,497,2261,"++","+","??","Normopeso"]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":0},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2000.6875},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":64.231250000000003},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":165.75},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":23.364848740057489},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.875},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.125},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.5},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":6.25E-2},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.4375},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-3.8125},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":170.26666666666668},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":528.26666666666665},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2585.4666666666667},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.2},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.13333333333333333}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.875},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2000.7142857142858},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":65.878571428571419},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":166.28571428571428},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":23.849205545278007},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.8571428571428571},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.14285714285714285},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.5714285714285714},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.42857142857142855},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-3.5},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":174.23076923076923},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":520.07692307692309},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2554.8461538461538},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.33333333333333331},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.4}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.125},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2000.5},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":52.7},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":162},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":19.974351103513861},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.5},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.5},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":-6},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":144.5},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":581.5},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":2784.5},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.26666666666666666},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.46666666666666667}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":16},null,null,null,null,null,null,null,null,null,null,"Record",null,null,null,{"$f":"COUNTIF(R$3:R$32,\"-\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.2},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":10},{"$f":"MAX(O3:O32)","v":225},{"$f":"MIN(P3:P32)","v":436},{"$f":"MIN(Q3:Q32)","v":2031},{"$f":"COUNTIF(R$3:R$32,\"--\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0},{"$f":"COUNTIF(S$3:S$32,\"--\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":0}]

{"sheet":"1EA","index":7,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,16],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[9,8,9,9],[9,10,9,12],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[6,8,6,9],[6,10,6,12],[3,8,3,9],[3,10,3,12],[0,0,0,20],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12]]}
["1EA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,null,"X","M",2001,54.4,166,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":19.74161707069241},"D",null,"I",null,null,-13,177,537,2625,"=",null,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[2,null,"X","M",2000,75,174,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":24.772096710265558},"D",null,"S",null,null,-4,160,544,2647,"+",null,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[3,null,"X","F",2000,63.3,152,27.397853185595565,"D",null,"S",null,null,0,123,635,2637,"=",null,"??","Sovrappeso"]
[4,null,"X","M",2000,74.2,181,22.648881291779862,"D",null,"N",null,null,-10,190,500,2637,"=",null,"??","Normopeso"]
[5,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[6,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[7,null,"X","F",2000,62.3,161,24.03456656764785,"D",null,"S",null,null,9,157,593,2787,"+",null,"??","Normopeso"]
[8,null,"X",null,2001,59.5,178,18.779194546143163,"D",null,"I",null,null,-26,209,497,2472,"+",null,"??",""]
[9,null,"X","F",null,43.4,162,16.537113244932172,"D",null,"S",null,null,-3,160,625,3296,"=",null,"??","Sottopeso"]
[10,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[11,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[12,null,"X","F",null,74,170,25.605536332179934,"D",null,"S",null,null,19,153,612,3131,"++",null,"??","Normopeso"]
[13,null,"X","F",null,63.2,162,24.081694863587863,"D",null,"S",null,null,3,158,584,3009,"++",null,"??","Normopeso"]
[14,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[15,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[16,null,"X","F",null,59.9,174,19.78464790593209,"D",null,"S",null,null,-7,163,494,2744,"++",null,"??","Normopeso"]
[17,null,"X","M",null,51.4,173,17.173978415583548,"D",null,"S",null,null,-1,163,493,2353,"+",null,"??","Sottopeso"]
[18,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[19,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[20,null,"X","M",null,48.2,164,17.920880428316483,"D",null,"I",null,null,6,233,484,2054,"+",null,"??","Sottopeso"]
[21,null,"X","M",null,73.599999999999994,165,27.033976124885218,"S",null,"N",null,null,-1,null,null,null,"++",null,"??","Normopeso"]
[22,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[23,null,"X","M",2001,54.6,170,18.892733564013845,"D",null,"I",null,null,-6,208,528,2363,"++",null,"??","Sottopeso"]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":0},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":0.9285714285714286},{"$f":"AVERAGE(E3:E32)","v":2000.4285714285713},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":61.214285714285715},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":168},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":21.743197875111115},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.9285714285714286},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":7.1428571428571425E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.5714285714285714},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.14285714285714285},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.2857142857142857},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-2.4285714285714284},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":173.38461538461539},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":548.15384615384619},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2673.4615384615386},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.35714285714285715},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.5},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2000.5},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":61.628571428571441},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":170.42857142857142},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":21.169166229362418},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.8571428571428571},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.14285714285714285},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.2857142857142857},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.2857142857142857},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.42857142857142855},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-4.1428571428571432},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":188.5},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":514.33333333333337},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2446.5},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.35714285714285715},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.42857142857142855},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2000},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":61.016666666666659},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":163.5},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":22.906902016645915},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":3.5},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":152.33333333333334},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":590.5},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":2934},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.2857142857142857},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":14},null,null,null,null,null,null,null,null,null,null,"Record",null,null,null,{"$f":"COUNTIF(R$3:R$32,\"-\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":19},{"$f":"MAX(O3:O32)","v":233},{"$f":"MIN(P3:P32)","v":484},{"$f":"MIN(Q3:Q32)","v":2054},{"$f":"COUNTIF(R$3:R$32,\"--\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0},{"$f":"COUNTIF(S$3:S$32,\"--\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":0}]

{"sheet":"1EB","index":8,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,16],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[9,8,9,9],[9,10,9,12],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[6,8,6,9],[6,10,6,12],[3,8,3,9],[3,10,3,12],[0,0,0,20],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12]]}
["1EB"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,null,"X","F",2001,64,164,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":23.795359904818564},"D",null,"S",null,null,3,129,659,3485,"+","+",{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[2,null,null,null,null,null,null,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""}]
[3,null,"X","M",2000,97.2,196,25.301957517700959,"D",null,"S",null,null,-15,153,589,2931,"+","=","??","Normopeso"]
[4,null,"X","M",2000,45.4,153,19.394250074757572,"S",null,"S",null,null,-15,211,475,2175,"++","+","??","Sottopeso"]
[5,null,"X","M",2000,54.1,169,18.941913798536469,"D",null,"I",null,null,-2,212,465,2282,"++","+","??","Sottopeso"]
[6,null,"X","M",2001,63.6,156,26.134122287968442,"D",null,"I",null,null,-16,null,null,null,null,null,"??","Normopeso"]
[7,null,"X","M",2000,68.099999999999994,168,24.12840136054422,"D",null,"I",null,null,-3,223,475,2760,"+","++","??","Normopeso"]
[8,null,"X","M",2000,72.099999999999994,185,21.066471877282684,"D",null,"S",null,null,-5,147,606,2138,"++","++","??","Normopeso"]
[9,null,"X","M",2001,55.7,174,18.39741049015722,"D",null,"S",null,null,0,232,469,2175,"++","++","??","Sottopeso"]
[10,null,"X","M",2001,52.3,167,18.752913335006632,"D",null,"S",null,null,-19,180,497,2150,"++","+","??","Sottopeso"]
[11,null,"X","M",2000,56.6,165,20.789715335169884,"D",null,"I",null,null,-11,185,540,2556,"=","+","??","Normopeso"]
[12,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[13,null,"X","M",2000,51.8,164,19.259369422962525,"S",null,"I",null,null,-19,155,562,2438,"=","+","??","Sottopeso"]
[14,null,"X","M",2001,75.8,172,25.621957815035156,"S",null,"N",null,null,-21,140,738,3413,"-","=","??","Normopeso"]
[15,null,"X","M",2001,59.2,182,17.872237652457432,"D",null,"S",null,null,-14,214,487,2450,"++","++","??","Sottopeso"]
[16,null,"X","M",2001,59.8,173,19.980620802566072,"D",null,"I",null,null,-6,166,530,2800,"+","=","??","Sottopeso"]
[17,null,"X","M",2001,56.5,172,19.098161168199027,"S",null,"I",null,null,0,205,503,2365,"+","++","??","Sottopeso"]
[18,null,"X","M",2001,49.3,165,18.108356290174473,"D",null,"I",null,null,-15,200,540,2600,"+","+","??","Sottopeso"]
[19,null,"X","F",2001,42.8,159,16.929710058937538,"D",null,"N",null,null,3,176,513,2546,"+","++","??","Sottopeso"]
[20,null,"X","M",2001,38.700000000000003,147,17.909204498125785,"D",null,"I",null,null,2,154,628,2871,"=","+","??","Sottopeso"]
[21,null,"X","M",2000,53.8,175,17.567346938775508,"D",null,"I",null,null,-21,161,550,2890,"=","+","??","Sottopeso"]
[22,null,"X","F",2000,43.8,167,15.705116712682418,"D",null,"I",null,null,-16,103,609,3162,"=","=","??","Sottopeso"]
[23,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[25,null,"X","M",2001,70.2,188,19.861928474422818,"D",null,"S",null,null,-3,173,503,2440,"++","++","??","Sottopeso"]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":0},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2000.5714285714287},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":58.609523809523807},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":169.57142857142858},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":20.219834562680067},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.80952380952380953},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.19047619047619047},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.38095238095238093},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":9.5238095238095233E-2},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.52380952380952384},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-9.1904761904761898},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":175.95},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":546.9},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2631.35},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.35},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.35}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.8571428571428571},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2000.5555555555557},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":60.011111111111099},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":170.61111111111111},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":20.454796618880167},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.77777777777777779},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.22222222222222221},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.3888888888888889},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":5.5555555555555552E-2},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.55555555555555558},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-10.166666666666666},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":183},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":538.64705882352939},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2554.9411764705883},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.35},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.45}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.14285714285714285},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2000.6666666666667},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":50.199999999999996},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":163.33333333333334},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":18.810062225479506},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.33333333333333331},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.33333333333333331},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.33333333333333331},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":-3.3333333333333335},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":136},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":593.66666666666663},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":3064.3333333333335},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.25},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.2}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":21},null,null,null,null,null,null,null,null,null,null,"Record",null,null,null,{"$f":"COUNTIF(R$3:R$32,\"-\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.05},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":3},{"$f":"MAX(O3:O32)","v":232},{"$f":"MIN(P3:P32)","v":465},{"$f":"MIN(Q3:Q32)","v":2138},{"$f":"COUNTIF(R$3:R$32,\"--\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0},{"$f":"COUNTIF(S$3:S$32,\"--\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":0}]

{"sheet":"1TE","index":9,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,16],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[9,8,9,9],[9,10,9,12],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[6,8,6,9],[6,10,6,12],[3,8,3,9],[3,10,3,12],[0,0,0,20],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12]]}
["1TE"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,null,"X","M",2001,45.9,165,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":16.859504132231407},"D",null,"S",null,null,-2,200,496,2269,"+","++",{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[2,null,"X","M",2000,60.6,162,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":23.090992226794693},"D",null,"S",null,null,0,215,459,2275,"++","++",{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[3,null,"X","M",2001,89.1,166,32.334155900711281,"S",null,"I",null,null,-18,148,578,2906,"=","=","??","Sovrappeso"]
[4,null,"X","M",2001,60.2,171,20.587531206183101,"D",null,"S",null,null,-2,198,515,2590,"-","+","??","Sottopeso"]
[5,null,"X","M",2001,43.5,158,17.425092132671043,"D",null,"S",null,null,-6,202,487,2134,"=","+","??","Sottopeso"]
[6,null,"X","M",2001,66.8,177,21.322097736921062,"D",null,"S",null,null,1,182,609,2694,"=","++","??","Normopeso"]
[7,null,null,"F",1998,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[8,null,"X","M",2001,58,152,25.103878116343491,"S",null,"S",null,null,-15,156,569,2519,"+","++","??","Normopeso"]
[9,null,"X","M",2001,63.6,170,22.006920415224915,"D",null,"S",null,null,6,194,500,2290,"=","++","??","Normopeso"]
[10,null,null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[11,null,"X","M",2001,67.099999999999994,154,28.293135435992578,"D",null,"I",null,null,-9,190,569,2622,"+","+","??","Sovrappeso"]
[12,null,"X","M",2002,65.099999999999994,169,22.793319561640001,"S",null,"S",null,null,-15,145,634,2944,"-","+","??","Normopeso"]
[13,null,"X","M",2001,66.3,174,21.898533491874751,"D",null,"S",null,null,-28,183,547,2768,"=","+","??","Normopeso"]
[14,null,"X","M",2000,80.8,178,25.501830576947352,"S",null,"I",null,null,-13,132,603,2890,"-","=","??","Normopeso"]
[15,null,"X","M",2001,46.5,155,19.354838709677416,"D",null,"S",null,null,-7,203,515,2309,"+","++","??","Sottopeso"]
[16,null,"X","M",2001,54.5,164,20.26323616894706,"D",null,"I",null,null,-5,204,493,2228,"+","+","??","Sottopeso"]
[17,null,"X","M",2001,55.8,174,18.430439952437574,"D",null,"I",null,null,3,225,466,2457,"=","+","??","Sottopeso"]
[18,null,"X","M",2000,57.6,166,20.902888663086081,"D",null,"S",null,null,5,175,504,2225,"+","+","??","Normopeso"]
[19,null,"X","M",2001,43,155,17.898022892819977,"D",null,"I",null,null,-13,183,520,2497,"=","++","??","Sottopeso"]
[20,null,"X","M",2001,65.8,156,27.038132807363574,"D",null,"I",null,null,-7,162,584,2591,"+","++","??","Normopeso"]
[21,null,null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[22,null,null,"M",1999,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[23,null,"X","M",2000,90.1,180,27.808641975308639,"D",null,"I",null,null,-4,173,534,2590,"=","=","??","Sovrappeso"]
[24,null,"X","M",2001,67.2,163,25.292634273024955,"D",null,"S",null,null,8,180,559,2625,"=","+","??","Normopeso"]
[25,null,"X","M",2001,33,147,15.271414688324311,"D",null,"S",null,null,5,172,559,2503,"+","+","??","Sottopeso"]
[26,null,"X","M",2001,50.8,155,21.144640998959414,"S",null,"S",null,null,-6,151,568,2628,"+","+","??","Normopeso"]
[27,null,"X","M",2001,47.7,159,18.867924528301888,"D",null,"S",null,null,-8,219,500,2268,"+","=","??","Sottopeso"]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":0},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2000.7037037037037},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":59.956521739130437},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":163.91304347826087},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":22.151730721382023},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.78260869565217395},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.21739130434782608},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.65217391304347827},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.34782608695652173},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-5.6521739130434785},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":182.2608695652174},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":537.73913043478262},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2514},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":4.3478260869565216E-2},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.34782608695652173}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":1},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2000.8695652173913},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":59.956521739130437},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":163.91304347826087},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":22.151730721382023},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.78260869565217395},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.21739130434782608},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.65217391304347827},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.34782608695652173},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-5.6521739130434785},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":182.2608695652174},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":537.73913043478262},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2514},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.43478260869565216},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.47826086956521741}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.39130434782608697},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.17391304347826086}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":23},null,null,null,null,null,null,null,null,null,null,"Record",null,null,null,{"$f":"COUNTIF(R$3:R$32,\"-\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.13043478260869565},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":8},{"$f":"MAX(O3:O32)","v":225},{"$f":"MIN(P3:P32)","v":459},{"$f":"MIN(Q3:Q32)","v":2134},{"$f":"COUNTIF(R$3:R$32,\"--\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0},{"$f":"COUNTIF(S$3:S$32,\"--\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":0}]

{"sheet":"1TD","index":10,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,16],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[9,8,9,9],[9,10,9,12],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[6,8,6,9],[6,10,6,12],[3,8,3,9],[3,10,3,12],[0,0,0,20],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12]]}
["1TD"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,null,"X","F",2001,53.2,169,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":18.626798781555269},"D",null,"N",null,null,-30,125,606,2938,"=","+",{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[2,null,"X","M",1999,75.3,172,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":25.452947539210385},"D",null,"I",null,null,0,227,484,2413,"++","++",{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[3,null,"X","M",1999,59.4,164,22.08506841165973,"D",null,"I",null,null,-2,226,450,2246,"++","++","??","Normopeso"]
[4,null,"X","M",2001,48.7,161,{"$f":"IF(C6 = \"X\",F6/(G6/100)^2,\"\")","v":18.787855406813009},"D",null,"S",null,null,-27,188,513,2406,"++","++","??","Sottopeso"]
[5,null,"X","M",2001,65.2,171,22.297459047228209,"D",null,"I",null,null,-5,212,469,2200,"+","+","??","Normopeso"]
[6,null,null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[7,null,"X","M",2001,90.7,175,29.616326530612245,"S",null,"I",null,null,-14,131,607,3368,"-","=","??","Sovrappeso"]
[8,null,"X","M",2001,69.7,163,26.233580488539278,"D",null,"I",null,null,-15,153,566,2778,"-","=","??","Normopeso"]
[9,null,"X","M",2001,57.8,174,19.091029198044655,"D",null,"I",null,null,-7,195,516,2565,"+","=","??","Sottopeso"]
[10,null,"X","M",2001,66.7,176,21.532799586776861,"D",null,"S",null,null,3,181,504,2390,"++","+","??","Normopeso"]
[11,null,"X","M",2001,57.3,152,24.80090027700831,"D",null,"I",null,null,4,164,575,2650,"=","-","??","Normopeso"]
[12,null,"X","M",2001,44.3,161,17.090390031248791,"D",null,"I",null,null,-2,170,484,2409,"=","+","??","Sottopeso"]
[13,null,"X","M",2002,63.2,168,22.39229024943311,"D",null,"S",null,null,5,233,500,2543,"+","-","??","Normopeso"]
[14,null,"X","M",1999,53.5,164,{"$f":"IF(C16 = \"X\",F16/(G16/100)^2,\"\")","v":19.891433670434267},"D",null,"I",null,null,null,211,532,2366,"+","++","??","Sottopeso"]
[15,null,"X","M",2000,59.1,166,{"$f":"IF(C17 = \"X\",F17/(G17/100)^2,\"\")","v":21.447234722020614},"D",null,"I",null,null,10,276,466,2203,"++","+","??","Normopeso"]
[16,null,"X","M",2000,68.099999999999994,172,{"$f":"IF(C18 = \"X\",F18/(G18/100)^2,\"\")","v":23.019199567333693},"D",null,"S",null,null,-20,190,472,2366,"+","+","??","Normopeso"]
[17,null,"X","M",2001,63.4,175,20.70204081632653,"D",null,"P",null,null,2,171,528,2791,"+","=","??","Normopeso"]
[18,null,"X","M",2001,68.8,162,26.215515927450078,"D",null,"S",null,null,-5,147,566,2866,"++","=",{"$f":"IF(AND(C20<>\"X\",B20<>\"\"),\"Assente\",IF(AND(B20=\"\",C20=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C20=\"X\",D20=\"M\"),IF(H20<>\"\",IF(H20<20.7,\"Sottopeso\",IF(H20>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C20=\"X\",D20=\"F\"),IF(H20<>\"\",IF(H20<19.1,\"Sottopeso\",IF(H20>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"}]
[19,null,"X","M",2001,47.2,154,{"$f":"IF(C21 = \"X\",F21/(G21/100)^2,\"\")","v":19.902175746331594},"D",null,"S",null,null,-14,163,518,2750,"+","=",{"$f":"IF(AND(C21<>\"X\",B21<>\"\"),\"Assente\",IF(AND(B21=\"\",C21=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C21=\"X\",D21=\"M\"),IF(H21<>\"\",IF(H21<20.7,\"Sottopeso\",IF(H21>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C21=\"X\",D21=\"F\"),IF(H21<>\"\",IF(H21<19.1,\"Sottopeso\",IF(H21>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"}]
[20,null,"X","M",1997,100,170,{"$f":"IF(C22 = \"X\",F22/(G22/100)^2,\"\")","v":34.602076124567475},"D",null,"I",null,null,3,184,531,2560,"++","+",{"$f":"IF(AND(C22<>\"X\",B22<>\"\"),\"Assente\",IF(AND(B22=\"\",C22=\"X\"),\"??\",\"\"))","v":"??"},{"$f":"IF(AND(C22=\"X\",D22=\"M\"),IF(H22<>\"\",IF(H22<20.7,\"Sottopeso\",IF(H22>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C22=\"X\",D22=\"F\"),IF(H22<>\"\",IF(H22<19.1,\"Sottopeso\",IF(H22>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sovrappeso"}]
[21,null,null,null,null,null,null,{"$f":"IF(C23 = \"X\",F23/(G23/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C23<>\"X\",B23<>\"\"),\"Assente\",IF(AND(B23=\"\",C23=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C23=\"X\",D23=\"M\"),IF(H23<>\"\",IF(H23<20.7,\"Sottopeso\",IF(H23>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C23=\"X\",D23=\"F\"),IF(H23<>\"\",IF(H23<19.1,\"Sottopeso\",IF(H23>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""}]
[22,null,null,null,null,null,null,{"$f":"IF(C24 = \"X\",F24/(G24/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C24<>\"X\",B24<>\"\"),\"Assente\",IF(AND(B24=\"\",C24=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C24=\"X\",D24=\"M\"),IF(H24<>\"\",IF(H24<20.7,\"Sottopeso\",IF(H24>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C24=\"X\",D24=\"F\"),IF(H24<>\"\",IF(H24<19.1,\"Sottopeso\",IF(H24>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""}]
[23,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":0},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2000.45},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":63.768421052631588},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":166.78947368421052},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":22.830901164347058},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.94736842105263153},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":5.2631578947368418E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.31578947368421051},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":5.2631578947368418E-2},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.57894736842105265},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-6.333333333333333},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":186.68421052631578},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":520.36842105263156},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2568.8421052631579},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.36842105263157893},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.21052631578947367}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.94736842105263153},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2000.3888888888889},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":64.355555555555554},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":166.66666666666666},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":23.064462407835492},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.94444444444444442},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":5.5555555555555552E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.33333333333333331},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.61111111111111116},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-4.9411764705882355},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":190.11111111111111},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":515.61111111111109},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2548.3333333333335},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.36842105263157893},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.36842105263157893}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":5.2631578947368418E-2},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":53.2},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":169},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":18.626798781555269},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":-30},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":125},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":606},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":2938},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.15789473684210525},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.31578947368421051}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":19},null,null,null,null,null,null,null,null,null,null,"Record",null,null,null,{"$f":"COUNTIF(R$3:R$32,\"-\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.10526315789473684},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.10526315789473684}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":10},{"$f":"MAX(O3:O32)","v":276},{"$f":"MIN(P3:P32)","v":450},{"$f":"MIN(Q3:Q32)","v":2200},{"$f":"COUNTIF(R$3:R$32,\"--\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0},{"$f":"COUNTIF(S$3:S$32,\"--\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":0},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":0}]

{"sheet":"MODELLO","index":11,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,16],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[9,8,9,9],[9,10,9,12],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[6,8,6,9],[6,10,6,12],[3,8,3,9],[3,10,3,12],[0,0,0,20],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12]]}
["MODELLO"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,null,null,null,null,null,null,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""}]
[2,null,null,null,null,null,null,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""}]
[3,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[4,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[5,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[6,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[7,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[8,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[9,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[10,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[11,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[12,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[13,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[14,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[15,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[16,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[17,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[18,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[19,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[20,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[21,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[22,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[23,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":0},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E3:E32)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":0},null,null,null,null,null,null,null,null,null,null,"Record",null,null,null,{"$f":"COUNTIF(R$3:R$32,\"-\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":0},{"$f":"MAX(O3:O32)","v":0},{"$f":"MIN(P3:P32)","v":0},{"$f":"MIN(Q3:Q32)","v":0},{"$f":"COUNTIF(R$3:R$32,\"--\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(S$3:S$32,\"--\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":{"$error":"#N/A"}},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":{"$error":"#N/A"}},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":{"$error":"#N/A"}},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":{"$error":"#N/A"}}]