{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["1TA","1TB","1TC","1TD","1TE","1LA","1LB","1EB","1HA","1HB","MODELLO"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1TA","index":0,"n_rows":41,"n_cols":29,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,25,0,28],[7,25,8,28],[5,26,5,27],[6,26,6,27],[1,26,1,27],[2,26,2,27],[3,26,3,27],[4,26,4,27],[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],[0,0,0,21],[3,8,3,9],[3,10,3,12],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12]]}
["1TA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note",null,"Sport",null,null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"BAGGIO CRISTIAN","X","M",2003,63.3,159,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":25.038566512400614},"D",null,"S",null,null,5,180,535,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":"Normopeso"},null,null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"BARTOCCI MATTEO","X","M",2001,70.400000000000006,176,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":22.72727272727273},"D",null,"S",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":"Normopeso"},null,null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"CONTU FLAMINIA","X","F",2002,42.8,161,16.511708653215535,"D",null,"N",null,null,3,155,700,null,"++","=","","Sottopeso",null,null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"DORE DENNIS","X","M",2002,85.6,164,31.826293872694826,"S",null,"N",null,null,0,160,588,null,"++","++","","Sovrappeso",null,null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"FALCONE SIMONE","X","M",2002,52.1,169,18.241658205244917,"D",null,"I",null,null,-3,196,475,null,"+","++","","Sottopeso"]
[6,"FIORELLI LORENZO","X","M",2002,55.7,163,20.964281681659077,"D",null,"S",null,null,-21,152,507,null,"+","=","","Normopeso",null,null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"HAREB MHD ABDUL ","X","M",2001,61.6,176,19.886363636363637,"D",null,"S",null,null,0,234,450,null,"+","+","","Sottopeso"]
[8,"IEBBA FEDERICO","X","M",2002,69,172,23.323418063818284,"D",null,"N",null,null,-5,178,594,null,"=","+","","Normopeso"]
[9,"INGOGLIA LUCA","X","M",2002,62.7,166,22.753665263463496,"S",null,"N",null,null,-16,157,572,null,"=","+","","Normopeso"]
[10,"LAPICIUS OCTAVIAN","X","M",2001,59.3,164,22.047888161808451,"D",null,"S",null,null,11,204,520,null,"++","++","","Normopeso"]
[11,"LORENZI MATTEO","X","M",2002,75,175,24.489795918367346,"S",null,"S",null,null,-13,151,null,null,"+","+","","Normopeso"]
[12,"MARCELLA VINCENZO","X","M",2002,63.2,171,21.613487910810168,"S",null,"I",null,null,-28,182,462,null,"=","+","","Normopeso"]
[13,"MONALDO FEDERICO","X","M",2002,81.900000000000006,172,27.683883180097354,"D",null,"S",null,null,-8,162,515,null,"++","+","","Normopeso"]
[14,"PACIOTTI DANIEL","X","M",2002,74.5,180,22.993827160493826,"D",null,"S",null,null,11,215,427,null,"=","+","","Normopeso"]
[15,"PALERMO ANDREA","X","M",2002,47.7,172,16.123580313683075,"D",null,"N",null,null,-11,204,464,null,"+","++","","Sottopeso"]
[16,"PASTORIN LAWRENCE IVAN","X","M",2003,53.2,163,20.023335466144758,"D",null,"S",null,null,8,211,453,null,"+","+","","Sottopeso"]
[17,"RUELLO NICOLÒ",null,"M",2000,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[18,"SCIPIONI SIMONE","X","M",2001,108.4,170,37.50865051903115,"D",null,"N",null,null,10,131,null,null,"+","+","","Sovrappeso"]
[19,"SIUM MOHAMMED","X","M",2001,54.7,167,19.613467675427589,"D",null,"S",null,null,0,240,434,null,"=","=","","Sottopeso"]
[20,"TANARA MATTIA","X","M",2002,70.2,178,22.15629339729832,"D",null,"S",null,null,2,152,544,null,"++","=","","Normopeso"]
[21,"TENSI FEDERICO","X","M",2002,76.599999999999994,175,25.012244897959182,"D",null,"I",null,null,-18,151,null,null,"=","=","","Normopeso"]
[22,"ULLAH JAHID","X","M",2000,74.2,170,25.674740484429069,"D",null,"S",null,null,10,170,541,null,"+","=","","Normopeso"]
[23,"ZANNINO FABIO","X","M",2002,63.3,157,25.680554992088926,"D",null,"I",null,null,-10,169,530,null,"++","+","","Normopeso","X"]
[24,"SOCA VALERIA","X","F",1999,null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,588,null,null,null,"",{"$error":"#DIV/0!"}]
[25,"MARCU CIOBANU","X","M",null,null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#DIV/0!"}]
[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":25},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.96},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.5833333333333},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":66.609090909090909},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":169.09090909090909},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.75},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.16666666666666666},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.5},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.25},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.16666666666666666},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-3.4761904761904763},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":178.76190476190476},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":521},{"$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":0.36363636363636365},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.27272727272727271}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.88},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.91666666666666663},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.7619047619048},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":67.742857142857147},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":169.47619047619048},{"$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":0.77272727272727271},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.18181818181818182},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.54545454545454541},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.22727272727272727},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.18181818181818182},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-3.8},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":179.95},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":506.52941176470586},{"$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":0.36363636363636365},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.45454545454545453}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.08},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":8.3333333333333329E-2},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2000.5},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":42.8},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":161},{"$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":0.5},{"$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,\"I\",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},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":155},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":644},{"$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.27272727272727271},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.27272727272727271}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":24},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":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":11},{"$f":"MAX(O3:O32)","v":240},{"$f":"MIN(P3:P32)","v":427},{"$f":"MIN(Q3:Q32)","v":0},{"$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":"LAPICIUS OCTAVIAN"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"SIUM MOHAMMED"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"PACIOTTI DANIEL"},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":{"$error":"#N/A"}}]

{"sheet":"1TB","index":1,"n_rows":41,"n_cols":29,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,8,2,9],[2,10,2,12],[2,26,2,27],[0,0,0,22],[0,25,0,28],[1,8,1,9],[1,10,1,12],[1,26,1,27],[3,8,3,9],[3,10,3,12],[3,26,3,27],[4,8,4,9],[4,10,4,12],[4,26,4,27],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,26,5,27],[6,8,6,9],[6,10,6,12],[6,26,6,27],[7,8,7,9],[7,10,7,12],[7,25,8,28],[8,8,8,9],[8,10,8,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]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note",null,"Sport","Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"ASTROLOGO ANGELO",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":"Assente"},{"$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":""},null,null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"BERTOLOTTI FABIO",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":"Assente"},{"$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":""},null,null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"CARINO GIAN CARLO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente","",null,null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"CONTI ALESSIO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente","",null,null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"DAOU CARLO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[6,"DE NAPOLI MATTIA",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente","",null,null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"DI IACOVO UMBERTO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[8,"DI PORTO DAVIDE",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[9,"DRAGOS DAVIDE ",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[10,"GAETA MATTIA",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[11,"IURICH NICOLAS",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[12,"LANZI RICCARDO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[13,"MAISANO MINO MICHELE",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[14,"MALAFARINA RICCARDO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[15,"MIRABASSO ALESSIO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[16,"PAOLA FRANCESCO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[17,"PERUGINI SIMONE",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[18,"POLITI FRANCESCO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[19,"RIMA ALBERTO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[20,"SAURO DANIEL",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[21,"SCANU MIRKO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[22,"SCARANO GABRIELE",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[23,"TAM DANIELE",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[24,"TERRACINA SAMUEL",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[25,"VASTOLA TOMMASO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[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":25},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":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":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":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,\"I\",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"}}]

{"sheet":"1TC","index":2,"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]]}
["CLASSE: "]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,"BUGAY KIM EDWARD DE JESUS","X","M",2002,81.7,162,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":31.130925163846971},"D",null,"S",null,null,-7,164,486,2556,"++*","+",{"$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":"Sovrappeso"}]
[2,"CELLI MARTINA","X","F",2001,61.8,161,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":23.841672774970096},"D",null,"I",null,null,7,104,511,2269,"-","=",{"$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,"CESE RICCARDO","X","M",2002,71,179,22.15910864205237,"D",null,"N",null,null,-13,164,515,2459,"=","+","","Normopeso"]
[4,"COLUCCIA DAMIANO","X","M",2002,72.3,175,23.608163265306121,"S",null,"S",null,null,1,202,450,2118,"++*","+","","Normopeso"]
[5,"DAMBA AMARA","X","M",2002,51.7,165,18.989898989898993,"D",null,"S",null,null,-15,189,515,2510,"=","=","","Sottopeso"]
[6,"DI GAETANO DARIO","X","M",2003,80.599999999999994,174,26.621746597965384,"D",null,"N",null,null,-14,183,509,2322,"-","=","","Normopeso"]
[7,"DI TONDO LUCA","X","M",2003,60.8,174,20.081913066455275,"D",null,"S",null,null,0,182,465,2331,"++","+","","Sottopeso"]
[8,"DIVIZIA CLAUDIO","X","M",2003,49.4,163,18.593097218562988,"D",null,"I",null,null,9,177,488,2669,"++","+","","Sottopeso"]
[9,"FERRANTE ROBERTO","X","M",2002,58.7,169,20.552501663107037,"D",null,"I",null,null,-3,181,496,2460,"+","=","","Sottopeso"]
[10,"HOFFMANN FRANCESCO","X","M",2001,65.3,171,22.331657604049109,"D",null,"S",null,null,-7,195,490,2355,"++","+","","Normopeso"]
[11,"IANCU LUIGI GABRIEL","X","M",2002,35,171,11.969494887315756,"S",null,"S",null,null,1,175,506,2450,"+","+","","Sottopeso"]
[12,"INCELLI CRISTIAN",null,null,2000,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[13,"LAQUINDANUM BERNARD JR JUAN","X","M",2002,41,158,16.423650056080753,"D",null,"I",null,null,6,217,495,2490,"+","+","","Sottopeso"]
[14,"LATTARI ANDREA","X","M",2002,47.3,166,17.16504572506895,"D",null,"S",null,null,-15,220,470,2388,"+","+","","Sottopeso"]
[15,"LUPI FEDERICA","X","F",2002,67.599999999999994,160,26.406249999999993,"D",null,"N",null,null,-12,157,500,2504,"=","+","","Normopeso"]
[16,"MARCHETTI LUKAS OLLVER","X","M",2001,58.4,172,19.740400216333153,"D",null,"N",null,null,-13,174,556,2496,"++","=","","Sottopeso"]
[17,"MARUCCI ANDREA","X","M",2002,62.1,178,19.599798005302361,"D",null,"S",null,null,6,217,478,2378,"+","+","","Sottopeso"]
[18,"NUNZI YURI","X","M",2002,82,183,24.485652005136011,"D",null,"I",null,null,3,211,490,2501,"++","+","","Normopeso"]
[19,"PESCETELLI MANUEL","X","M",2002,51.4,170,17.785467128027683,"D",null,"S",null,null,9,212,465,2465,"+","=","","Sottopeso"]
[20,"PRASAD NAKUL","X","M",1999,58.4,166,21.193206561184496,"D",null,"N",null,null,3,176,510,2513,"-","+","","Normopeso"]
[21,"PUTELLI GUGLIELMO",null,null,2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[22,"SORDILLI EDOARDO ","X","M",2002,62.7,162,23.891175125743022,"S",null,"S",null,null,-1,201,484,2405,"+","+","","Normopeso"]
[23,"VICANÒ GABRIEL","X","M",2001,50,164,18.590124925639504,"D",null,"I",null,null,-5,194,460,2390,"++","+","","Sottopeso"]
[24,"ABATE MARTINA","X","F",2002,52.8,159,20.885249792334161,"S",null,"I",null,null,-14,145,537,2548,"=","=","","Normopeso"]
[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":24},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.91666666666666663},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.7083333333333},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":60.090909090909101},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":168.27272727272728},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":21.183918155199098},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.81818181818181823},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.18181818181818182},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.45454545454545453},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.22727272727272727},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.31818181818181818},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-3.3636363636363638},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":183.63636363636363},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":494.36363636363637},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2435.318181818182},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.27272727272727271},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.79166666666666663},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.86363636363636365},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.8421052631579},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":59.989473684210523},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":169.57894736842104},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":20.784896149846102},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.84210526315789469},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.15789473684210525},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.52631578947368418},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.21052631578947367},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.26315789473684209},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-2.8947368421052633},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":191.26315789473685},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":490.94736842105266},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2434.5263157894738},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.31818181818181818},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.68181818181818177}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.125},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.13636363636363635},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001.6666666666667},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":60.733333333333327},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":160},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":23.711057522434754},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.66666666666666663},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.33333333333333331},{"$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":-6.333333333333333},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":135.33333333333334},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":516},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":2440.3333333333335},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.18181818181818182},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.31818181818181818}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":22},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.13636363636363635},{"$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":9},{"$f":"MAX(O3:O32)","v":220},{"$f":"MIN(P3:P32)","v":450},{"$f":"MIN(Q3:Q32)","v":2118},{"$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":"DIVIZIA CLAUDIO"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"LATTARI ANDREA"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"COLUCCIA DAMIANO"},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":"COLUCCIA DAMIANO"}]

{"sheet":"1TD","index":3,"n_rows":41,"n_cols":29,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,8,2,9],[2,10,2,12],[2,26,2,27],[0,0,0,22],[0,25,0,28],[1,8,1,9],[1,10,1,12],[1,26,1,27],[3,8,3,9],[3,10,3,12],[3,26,3,27],[4,8,4,9],[4,10,4,12],[4,26,4,27],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,26,5,27],[6,8,6,9],[6,10,6,12],[6,26,6,27],[7,8,7,9],[7,10,7,12],[7,25,8,28],[8,8,8,9],[8,10,8,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]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note",null,"Sport","Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"ALY ZYNAB MOHAM","X","M",2001,54,167,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":19.362472659471475},"D",null,"N",null,null,-12,124,625,2856,"+","=",{"$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"},null,null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"CASTILLO MARK LOUIE","X","M",2001,75,169,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":26.259584748433181},"D",null,"N",null,null,-1,194,496,2912,"+","+",{"$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"},null,null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"COPPI MIRKO","X","M",2001,72.400000000000006,174,23.913330690976352,"D",null,"I",null,null,-15,224,469,2313,"+","+","","Normopeso",null,null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"DE CAPOA LUCA","X","M",2002,43.8,169,15.335597493084977,"S",null,"I",null,null,-27,174,547,2725,"+","=","","Sottopeso",null,null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"DI CONSIGLIO SAMUEL","X","M",2002,59.6,163,22.43215777786142,"D",null,"N",null,null,-18,130,571,3728,"=","=","","Normopeso"]
[6,"FALCIANI FEDERICO","X","M",2003,45,162,17.146776406035663,"D",null,"S",null,null,-13,177,522,2406,"=","+","","Sottopeso",null,null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"GADALLA YOUSSEF","X","M",2002,69.5,174,22.955476284846082,"S",null,"N",null,null,-13,187,544,2425,"=","=","","Normopeso"]
[8,"GENNA MATTEO","X","M",2002,43.5,156,17.874753451676526,"D",null,"N",null,null,-8,210,522,2316,"++","+","","Sottopeso"]
[9,"GISTI ALESSIO","X","M",2000,72.400000000000006,166,26.273769777906811,"D",null,"I",null,null,0,188,471,3016,"+","+","","Normopeso"]
[10,"GRANDE CHRISTIAN DYLAN","X","M",2001,69.400000000000006,172,23.4586262844781,"D",null,"I",null,null,-1,195,506,2534,"+","+","","Normopeso"]
[11,"ILAGAN ZAKI HUDSON","X","M",2003,76.599999999999994,166,27.797938742923503,"D",null,"N",null,null,1,203,453,2238,"++","+","","Normopeso"]
[12,"MEZZINI LORENZO","X","M",2001,42.1,164,15.652885187388462,"S",null,"S",null,null,-9,180,494,2484,"=","+","","Sottopeso"]
[13,"PISTOLA ANDREA","X","M",2001,54.6,171,18.67241202421258,"D",null,"S",null,null,13,235,481,2060,"+","++","","Sottopeso"]
[14,"RATEANU REBECCA","X","F",2002,57.3,169,20.062322747802948,"D",null,"S",null,null,12,184,469,2378,"++","++","","Normopeso"]
[15,"RIOTTO ROSARIO",null,"M",2002,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[16,"ROSSI GIACOMO","X","M",2002,61.2,169,21.427821154721478,"D",null,"S",null,null,0,180,557,2810,"++","++","","Normopeso"]
[17,"SANTINI ALESSIO","X","M",2002,53.9,170,18.650519031141869,"D",null,"S",null,null,0,212,497,2562,"=","+","","Sottopeso"]
[18,"TAREK HUSSEIN RAHMA",null,"M",2002,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[19,"TUCCI ROBERTO","X","M",2002,52.6,165,19.320477502295688,"D",null,"S",null,null,16,209,469,2166,"+","+","","Sottopeso"]
[20,"URETA MUCHA WALTER","X","M",2001,53.2,163,20.023335466144758,"D",null,"N",null,null,0,204,509,2422,"=","+","","Sottopeso"]
[21,"VENTURA FABRIZIO","X","M",2002,54.1,168,19.168083900226762,"D",null,"S",null,null,6,232,556,2225,"+","=","","Sottopeso"]
[22,"VETTURINI MIRKO","X","M",2001,63.5,180,19.598765432098766,"D",null,"S",null,null,9,193,485,2235,"++","+","","Sottopeso"]
[23,"VINCENTINI ORGNANI MATTEO",null,"M",2002,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[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":23},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.86956521739130432},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.6521739130435},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":58.685000000000002},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":167.85},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":20.769355338186372},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.85},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.15},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.45},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.35},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.2},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-3},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":191.75},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":512.15},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2540.5500000000002},{"$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.15}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.82608695652173914},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.95},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.578947368421},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":58.757894736842111},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":167.78947368421052},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":20.806567579785497},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.84210526315789469},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.15789473684210525},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.42105263157894735},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.36842105263157893},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.21052631578947367},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-3.7894736842105261},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":192.15789473684211},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":514.42105263157896},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2549.1052631578946},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.45},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.6}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":4.3478260869565216E-2},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.05},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2002},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":57.3},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":169},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":20.062322747802948},{"$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,\"I\",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":12},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":184},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":469},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":2378},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.3},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.25}]
[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":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":"MAX(N3:N32)","v":16},{"$f":"MAX(O3:O32)","v":235},{"$f":"MIN(P3:P32)","v":453},{"$f":"MIN(Q3:Q32)","v":2060},{"$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":"TUCCI ROBERTO"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"PISTOLA ANDREA"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"ILAGAN ZAKI HUDSON"},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":"PISTOLA ANDREA"}]

{"sheet":"1TE","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]]}
[]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,"APPOLLONI RICCARDO","X","M",2003,56,168,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":19.841269841269845},"D",null,"S",null,null,-24,158,534,2615,"=",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,"BONTEMPO FILIPPO","X","M",2002,44.4,161,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":17.128968789784341},"D",null,"I",null,null,-14,203,491,2696,"+",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":"Sottopeso"}]
[3,"BRANCIAMORE RICCARDO","X","M",2002,62.8,170,21.730103806228374,"D",null,"S",null,null,8,191,468,2225,"++*",null,"","Normopeso"]
[4,"BRUTTI RICCARDO","X","M",2002,69,164,25.654372397382513,"D",null,"S",null,null,-19,181,553,2753,"++",null,"","Normopeso"]
[5,"CALVA ALESSANDRO","X","M",2002,57,176,18.401342975206614,"D",null,"I",null,null,0,190,482,2304,"++",null,"","Sottopeso"]
[6,"CAPRA PIERFRANCESCO","X","M",2002,54.6,172,18.455922120064901,"D",null,"S",null,null,-11,210,469,2378,"+",null,"","Sottopeso"]
[7,"CECATI ALEX","X","M",2002,81.599999999999994,164,30.339083878643667,"D",null,"I",null,null,-4,180,513,2537,"+",null,"","Sovrappeso"]
[8,"DE ZULIANI MIRKO","X","M",2002,101,176,32.605888429752071,"D",null,"S",null,null,-2,155,597,3156,"+",null,"","Sovrappeso"]
[9,"GIZZI ANDREA","X","M",2002,54,165,19.834710743801654,"D",null,"I",null,null,-3,204,481,2503,"++",null,"","Sottopeso"]
[10,"GUARNONI LUCA",null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[11,"LECCISOTTO STEFANO",null,"M",2002,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[12,"MAGTIBAY JOHN KERBY VILLANUEVA",null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[13,"MICHETTI LORENZO","X","M",2003,52,166,18.870663376397157,"D",null,"I",null,null,-4,200,525,2407,"+",null,"","Sottopeso"]
[14,"MOSCA FEDERICO",null,"M",2002,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[15,"PARISI ANDREA","X","M",2002,75.2,173,25.126131845367368,"D",null,"S",null,null,-17,204,468,2294,"++",null,"","Normopeso"]
[16,"PARISI CHIARA","X","F",2003,53,158,21.230572023714146,"D",null,"I",null,null,4,161,582,2963,"=",null,"","Normopeso"]
[17,"SALOMONE MARCO","X","M",2001,51.6,165,18.953168044077138,"D",null,"S",null,null,3,190,484,2322,"+",null,"","Sottopeso"]
[18,"SPALLETTI MATTEO","X","M",2002,41.4,156,17.011834319526624,"D",null,"I",null,null,-15,143,550,2410,"+",null,"","Sottopeso"]
[19,"STELLA SIMONE","X","M",2002,52.2,163,19.646956979939031,"D",null,"S",null,null,-16,184,535,2496,"+",null,"","Sottopeso"]
[20,"TEDESCO SARIO","X","M",2002,59.2,173,19.780146346353035,"D",null,"I",null,null,-22,168,582,3147,"=",null,"","Sottopeso"]
[21,"TRIPODI ALESSIO","X","M",2002,53.1,165,19.504132231404963,"D",null,"S",null,null,17,232,444,2265,"+",null,"","Sottopeso"]
[22,"VENESELLI DANIELE","X","M",2002,49,165,17.998163452708908,"D",null,"I",null,null,9,212,471,2478,"=",null,"","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":22},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.81818181818181823},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2002},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":59.283333333333339},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":166.66666666666666},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":21.228523977867908},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.5},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.5},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-6.1111111111111107},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":187},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":512.72222222222217},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2552.7222222222222},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.22222222222222221},{"$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.77272727272727271},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.94444444444444442},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2002.0588235294117},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":59.652941176470598},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":167.1764705882353},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":21.228403504582836},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.52941176470588236},{"$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.47058823529411764},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-6.7058823529411766},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":188.52941176470588},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":508.64705882352939},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2528.5882352941176},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.5},{"$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":4.5454545454545456E-2},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":5.5555555555555552E-2},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2003},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":53},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":158},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":21.230572023714146},{"$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},{"$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":4},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":161},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":582},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":2963},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.22222222222222221},{"$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":18},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":17},{"$f":"MAX(O3:O32)","v":232},{"$f":"MIN(P3:P32)","v":444},{"$f":"MIN(Q3:Q32)","v":2225},{"$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":"TRIPODI ALESSIO"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"TRIPODI ALESSIO"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"TRIPODI ALESSIO"},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":"BRANCIAMORE RICCARDO"}]

{"sheet":"1LA","index":5,"n_rows":41,"n_cols":29,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,8,2,9],[2,10,2,12],[2,26,2,27],[0,0,0,21],[0,25,0,28],[1,8,1,9],[1,10,1,12],[1,26,1,27],[3,8,3,9],[3,10,3,12],[3,26,3,27],[4,8,4,9],[4,10,4,12],[4,26,4,27],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,26,5,27],[6,8,6,9],[6,10,6,12],[6,26,6,27],[7,8,7,9],[7,10,7,12],[7,25,8,28],[8,8,8,9],[8,10,8,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]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note",null,"Sport",null,null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"ASTROLOGO ANGELO",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":"Assente"},{"$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":""},null,null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"BERNABE DONALINE",null,"M",2001,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":"Assente"},{"$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":""},null,null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"BIANCHI ALESSANDRO","X","M",2001,73.400000000000006,169,25.699380273799942,"D",null,"S",null,null,0,182,478,2566,"++","++","","Normopeso",null,null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"CALO' REBECCA","X","F",2003,60.6,153,25.887479174676407,"D",null,"I",null,null,-22,110,662,3750,"-","=","","Normopeso",null,null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"CAPONE ANDREA","X","M",2002,56.9,172,19.233369388858844,"D",null,"S",null,null,-2,223,517,2600,"+","+","","Sottopeso"]
[6,"COLASANTI DAMIANO","X","M",2002,60.6,170,20.968858131487892,"D",null,"S",null,null,3,193,484,2343,"+","+","","Normopeso",null,null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"CRISTIANI LORENZO","X","M",2002,47.2,157,19.148849851920971,"D",null,"S",null,null,0,203,502,2331,"+","+","","Sottopeso"]
[8,"D'ALO' LORENZO","X","M",2002,51.5,168,18.246882086167805,"D",null,"I",null,null,-6,204,481,2313,"++","-","","Sottopeso"]
[9,"D'ATTINO EDOARDO","X","M",2002,47.4,162,18.061271147690896,"D",null,"I",null,null,-1,183,587,2672,"=","+","","Sottopeso"]
[10,"FRANELLI PIETRO","X","M",2002,52.9,167,18.968051920111872,"D",null,"I",null,null,-5,163,540,2593,"++","+","","Sottopeso"]
[11,"GAGLIARDINI DAVIDE","X","M",2002,55.4,168,19.628684807256239,"D",null,"S",null,null,8,211,475,2506,"++","++","","Sottopeso"]
[12,"GROSSI SALVATORE","X","M",2002,52.6,168,18.636621315192748,"D",null,"I",null,null,-14,182,488,2332,"=","=","","Sottopeso"]
[13,"MAGGI GIORGIA","X","F",2002,49.4,165,18.145087235996328,"D",null,"S",null,null,-10,153,566,2960,"=","=","","Sottopeso"]
[14,"NAPPI GIULIO","X","M",2003,40.6,153,17.343756674783204,"D",null,"S",null,null,-15,180,537,2672,"/","/","","Sottopeso"]
[15,"ORSOLA RICCARDO","X","M",2002,45.3,155,18.855359001040579,"D",null,"I",null,null,-21,140,615,2987,"+","=","","Sottopeso"]
[16,"PICHINI LEONARDO","X","M",2003,60.3,167,21.621427803076482,"D",null,"I",null,null,-15,165,560,2547,"+","+","","Normopeso"]
[17,"SANGERMANO ANDREA",null,"M",2003,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[18,"SANTOPADRE LEONARDO","X","M",2002,65.5,165,24.058769513314971,"S",null,"I",null,null,-20,169,559,2775,"+","+","","Normopeso"]
[19,"SCAFETTA LETIZIA","X","F",2002,49.2,151,21.578000964869965,"S",null,"I",null,null,15,130,618,3031,"=","=","","Normopeso"]
[20,"SENTINELLI TOMMASO","X","M",2001,55.3,165,20.312213039485769,"D",null,"I",null,null,0,172,550,2737,"+","+","","Sottopeso"]
[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":20},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.85},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2002.0526315789473},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":54.358823529411751},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":163.23529411764707},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":20.376121313513579},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.88235294117647056},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.11764705882352941},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.41176470588235292},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.58823529411764708},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-6.1764705882352944},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":174.29411764705881},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":542.29411764705878},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2689.1176470588234},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.23529411764705882},{"$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":0.7},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.82352941176470584},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2002},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":54.635714285714279},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":164.71428571428572},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":20.055963925299153},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.9285714285714286},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":7.1428571428571425E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.42857142857142855},{"$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.5714285714285714},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-6.2857142857142856},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":183.57142857142858},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":526.64285714285711},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2569.5714285714284},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.41176470588235292},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.47058823529411764}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.15},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.17647058823529413},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2002.3333333333333},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":53.066666666666663},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":156.33333333333334},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":21.8701891251809},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.66666666666666663},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.33333333333333331},{"$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},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.66666666666666663},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":-5.666666666666667},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":131},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":615.33333333333337},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":3247},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.23529411764705882},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.29411764705882354}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":17},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.8823529411764705E-2},{"$f":"COUNTIF(S$3:S$32,\"-\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":5.8823529411764705E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":15},{"$f":"MAX(O3:O32)","v":223},{"$f":"MIN(P3:P32)","v":475},{"$f":"MIN(Q3:Q32)","v":2313},{"$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":"SCAFETTA LETIZIA"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"CAPONE ANDREA"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"GAGLIARDINI DAVIDE"},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":"D'ALO' LORENZO"}]

{"sheet":"1LB","index":6,"n_rows":41,"n_cols":29,"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],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,26,5,27],[6,8,6,9],[6,10,6,12],[6,26,6,27],[7,8,7,9],[7,10,7,12],[7,25,8,28],[8,8,8,9],[8,10,8,12],[3,8,3,9],[3,10,3,12],[3,26,3,27],[4,8,4,9],[4,10,4,12],[4,26,4,27],[2,8,2,9],[2,10,2,12],[2,26,2,27],[0,0,0,22],[0,25,0,28],[1,8,1,9],[1,10,1,12],[1,26,1,27]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note",null,"Sport","Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"BELLONI VITTORIO","X","M",2002,45.6,161,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":17.591913892210947},"D",null,"S",null,null,-15,142,553,2678,"+","=",{"$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"},null,null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"BERNABE","X","F",2002,48.3,157,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":19.595115420503873},"D",null,"N",null,null,-19,150,644,3322,"=","=",{"$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"},null,null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"BRUGNOLI","X","M",2002,59.6,153,25.460293049681749,"D",null,"N",null,null,-17,138,616,3428,"=","=","","Normopeso",null,null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"CANTONE","X","M",2002,60.3,170,20.865051903114189,"D",null,"I",null,null,0,204,468,2188,"+","+","","Normopeso",null,null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"CAPORALI",null,"M",2001,null,null,"","D",null,"S",null,null,null,null,null,null,null,null,"Assente",""]
[6,"CHITI","X","M",2002,64.5,170,22.318339100346023,"D",null,"S",null,null,0,"-","-","-","++","+","","Normopeso",null,null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"COEN","X","M",2001,44.8,161,17.283283823926542,"D",null,"I",null,null,-17,187,525,2621,"=","=","","Sottopeso"]
[8,"D’ALESSANDRO","X","F",2002,58.6,172,19.808004326663063,"D",null,"I",null,null,"23 cm",154,556,3238,"+","++","","Normopeso"]
[9,"DE VINCENZI","X","M",2002,80.099999999999994,175,26.155102040816324,"D",null,"S",null,null,-2,195,486,2478,"++*","++*","","Normopeso"]
[10,"EMIGLI","X","M",2001,59.2,174,19.553441669969612,"D",null,"S",null,null,-22,192,493,2431,"+","+","","Sottopeso"]
[11,"FIORETTO","X","M",2002,49.4,157,20.041380989086775,"D",null,"I",null,null,"-5 cm","160cm","5’’41","25’’03","+","++","","Sottopeso"]
[12,"GASPARRI",null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[13,"MANGIONE","X","M",2003,40.200000000000003,153,17.17288222478534,"D",null,"I",null,null,-23,122,703,3659,"-","=","","Sottopeso"]
[14,"MELITO","X","F",2002,56.7,154,23.907910271546637,"D",null,"I",null,null,"6 cm",138,579,3872,"+","+","","Normopeso"]
[15,"MINNEI","X","M",2002,52.6,150,23.37777777777778,"S",null,"S",null,null,0,152,594,2778,"=","=","","Normopeso"]
[16,"NURUL",null,"F",2000,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[17,"PERONI","x","F",2002,40.9,153,17.471912512281602,"D",null,"I",null,null,"25 cm",145,572,2762,"=","=","","Sottopeso"]
[18,"RENCRICCA","X","M",2003,56.5,158,22.632590930940552,"D",null,"S",null,null,-7,170,557,2691,"++","+","","Normopeso"]
[19,"ROMEO","X","M",2002,43.2,155,17.981269510926118,"D",null,"S",null,null,0,161,559,2281,"+","++","","Sottopeso"]
[20,"RULLO","X","M",2003,45.9,163,17.275772516842938,"D",null,"S",null,null,-15,179,515,2472,"+","+","","Sottopeso"]
[21,"",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,"",""]
[23,"",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,"",""]
[25,"",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,"",""]
[27,"",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,"",""]
[29,"",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,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":30},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.56666666666666665},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.85},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":53.317647058823539},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":160.94117647058823},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":20.499531880083534},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.94117647058823528},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":5.8823529411764705E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.47058823529411764},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.11764705882352941},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.41176470588235292},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-10.538461538461538},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":161.93333333333334},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":561.33333333333337},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2859.9333333333334},{"$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,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.43333333333333335},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.76470588235294112},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2002.0769230769231},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":53.992307692307691},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":161.53846153846155},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":20.593007648494222},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.92307692307692313},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":7.6923076923076927E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.61538461538461542},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":7.6923076923076927E-2},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.30769230769230771},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-9.8333333333333339},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":167.45454545454547},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":551.72727272727275},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2700.4545454545455},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.47058823529411764},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.35294117647058826}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.13333333333333333},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.23529411764705882},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2002},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":51.125000000000007},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":159},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":20.195735632748796},{"$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.25},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.75},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":-19},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":146.75},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":587.75},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":3298.5},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.29411764705882354},{"$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":17},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.8823529411764705E-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":0},{"$f":"MAX(O3:O32)","v":204},{"$f":"MIN(P3:P32)","v":468},{"$f":"MIN(Q3:Q32)","v":2188},{"$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":"CANTONE"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"CANTONE"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"CANTONE"},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":"CANTONE"}]

{"sheet":"1EB","index":7,"n_rows":41,"n_cols":29,"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],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,26,5,27],[6,8,6,9],[6,10,6,12],[6,26,6,27],[7,8,7,9],[7,10,7,12],[7,25,8,28],[8,8,8,9],[8,10,8,12],[3,8,3,9],[3,10,3,12],[3,26,3,27],[4,8,4,9],[4,10,4,12],[4,26,4,27],[2,8,2,9],[2,10,2,12],[2,26,2,27],[0,0,0,21],[0,25,0,28],[1,8,1,9],[1,10,1,12],[1,26,1,27]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note",null,"Sport",null,null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"BARBERIS GIULIA",null,"F",2002,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":"Assente"},{"$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":""},null,null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"CARDILLI LAVINIA","X","F",2002,49.3,162,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":18.785246151501291},"D",null,"S",null,null,-12,168,481,2572,"++","++",{"$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"},null,null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"CHIERICONI ANDREADANTE","X","M",2002,49.6,169,17.366338713630476,"D",null,"N",null,null,-30,197,528,null,null,null,"","Sottopeso",null,null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"CLEMENTI MARCO","X","M",2002,63,167,22.589551436050055,"D",null,"S",null,null,8,222,463,2213,"++","=","","Normopeso",null,null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"CONTINI JACOPO","X","M",2003,54,163,20.324438255109339,"D",null,"S",null,null,-3,165,493,2237,"++","+","","Sottopeso"]
[6,"D'ALENA VLADIMIR","X","M",2001,37.5,150,16.666666666666668,"D",null,"S",null,null,-11,171,544,2496,"+","=","","Sottopeso",null,null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"DE TORRES ARTHIANN","X","M",2000,64.599999999999994,176,20.854855371900825,"D",null,"N",null,null,-19,177,547,2765,"+","+","","Normopeso"]
[8,"DI NEPI SAUL","X","M",2001,59.9,159,23.693683003045763,"D",null,"S",null,null,-22,134,731,4000,"=","+","","Normopeso"]
[9,"FALASCA MICHELA",null,"F",2002,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[10,"GUANZON JESTEN","X","F",2001,57.3,151,25.130476733476602,"D",null,"S",null,null,-16,null,null,null,null,null,"","Normopeso"]
[11,"HERNANDEZ INGRID",null,"F",1997,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[12,"MANALO KRISTINE","X","F",2002,38.700000000000003,142,19.192620511803216,"D",null,"N",null,null,-12,null,null,null,null,null,"","Normopeso"]
[13,"MARZIALE LUDOVICO","X","M",2002,72.2,170,24.982698961937722,"D",null,"S",null,null,4,183,478,2281,"=","+","","Normopeso"]
[14,"MATTIACCI FEDERICO","X","M",2002,71.7,173,23.956697517457982,"D",null,"S",null,null,4,200,435,null,"++","=","","Normopeso"]
[15,"MELONI SABRINA","X","F",2001,56.1,155,23.350676378772111,"D",null,"N",null,null,-18,113,594,4200,"+","+","","Normopeso"]
[16,"MORETTI GIULIA",null,"F",2002,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[17,"PAULE GENE ANGELO",null,"M",1997,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[18,"PIETROLATI RICCARDO","X","M",2002,73.7,176,23.792613636363637,"D",null,"S",null,null,9,198,494,2450,"+","+","","Normopeso"]
[19,"POGGESI ROBERTA",null,"F",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[20,"PRUNESTI' COSTANTINO","X","M",2001,64.7,177,20.651792269143606,"D",null,"N",null,null,16,249,462,2131,"+","+","","Sottopeso"]
[21,"RAINALDI FRANCESCO","X","M",2002,55.1,164,20.486317668054735,"D",null,"S",null,null,1,188,525,2342,"+","=","","Sottopeso"]
[22,"RIPANI LETIZIA","X","F",2002,49,158,19.62826470116968,"S",null,"S",null,null,5,168,522,2562,"++","+","","Normopeso","X"]
[23,"SONNINO ANGELO",null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[24,"VALENTINI ANDREA","X","M",2001,50.7,161,19.559430577524015,"D",null,"S",null,null,12,239,465,2300,"+","+","","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":24},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.70833333333333337},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.2083333333333},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":56.888235294117663},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":163.11764705882354},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":21.236021679623981},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.94117647058823528},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":5.8823529411764705E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.70588235294117652},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.29411764705882354},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-4.9411764705882355},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":184.8},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":517.4666666666667},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2657.6153846153848},{"$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":7.1428571428571425E-2}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.5},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.70588235294117652},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.5833333333333},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":59.725000000000001},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":167.08333333333334},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":21.243757006407069},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.75},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.25},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-2.5833333333333335},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":193.58333333333334},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":513.75},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2521.5},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.5},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.6428571428571429}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.20833333333333334},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.29411764705882354},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001.6},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":50.08},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":153.6},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":21.217456895344579},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.8},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.6},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.4},{"$f":"(COUNTIFS(K3:K32,\"I\",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":-10.6},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":149.66666666666666},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":532.33333333333337},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":3111.3333333333335},{"$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":0.2857142857142857}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":17},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":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":16},{"$f":"MAX(O3:O32)","v":249},{"$f":"MIN(P3:P32)","v":435},{"$f":"MIN(Q3:Q32)","v":2131},{"$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":"PRUNESTI' COSTANTINO"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"PRUNESTI' COSTANTINO"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"MATTIACCI FEDERICO"},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":"PRUNESTI' COSTANTINO"}]

{"sheet":"1HA","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]]}
["CLASSE: "]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"Sportivo-Nsportivo-Intermedio",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note"]
[1,"ABD EL MALAK ANGELA HANY YACOUBHI ","X","F",2002,93.5,162,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":35.627190976985212},"D",null,"N",null,null,-17,145,653,3840,"=","+",{"$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":"Sovrappeso"}]
[2,"BARRECA BENEDETTA",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":"Assente"},{"$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,"BONIZIO ELISA ","X","F",2002,49.2,155,20.478668054110301,"D",null,"I",null,null,8,124,613,3088,"=","+","","Normopeso"]
[4,"DE STEFANO SALVATORE","X","M",2001,64,160,24.999999999999996,"D",null,"S",null,null,-11,153,593,3135,"=","++","","Normopeso"]
[5,"DI TERLIZZI ARIANNA ","X","F",2002,50.6,160,19.765624999999996,"D",null,"S",null,null,0,155,528,2684,"++*","++","","Normopeso"]
[6,"FARRO IYCEE ROSE CASTILLO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[7,"GALUPPI RICCARDO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[8,"GUILLEN FAJARDO SANTIAGO JOSUE","X","M",1999,54.4,168,19.274376417233562,"S",null,"I",null,null,null,null,null,null,null,null,"","Sottopeso"]
[9,"HABIB EISSA PAOLO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[10,"HOWLADAR RABBI","X","M",2001,53.2,168,18.849206349206352,"D",null,"S",null,null,-9,210,null,2903,"=","=","","Sottopeso"]
[11,"LUONGO KEVIN","X",null,2001,68.7,178,21.682868324706476,"S",null,"S",null,null,0,180,481,2469,"O","O","",""]
[12,"MARIANI VALERIO",null,"M",2002,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[13,"MATURANA RIVADERA SARA NICOLE","X","F",2001,51.4,164,19.110648423557407,"D",null,"N",null,null,2,138,669,3200,"+","+","","Normopeso"]
[14,"MELIS NADIN","X","F",2002,53.4,156,21.942800788954631,"D",null,"S",null,null,-5,160,597,2791,"+","+","","Normopeso"]
[15,"MONTRONE CLARA","X","F",2001,48.4,161,18.672119131206355,"D",null,"N",null,null,0,153,581,3015,"=","+","","Sottopeso"]
[16,"PERUGINI GAIA","X","F",2003,52,162,19.814052735863431,"D",null,"S",null,null,17,147,594,2972,"++","++","","Normopeso"]
[17,"RICCI FLAVIO","X","M",2002,54,169,18.906901018871892,"D",null,"S",null,null,-12,214,462,2325,"++","+","","Sottopeso"]
[18,"SGRULLETTI BEATRICE","X","F",2002,57.1,161,22.028471123799235,"D",null,"S",null,null,10,169,534,2440,"++*","++","","Normopeso"]
[19,"STANICI EMANUELE","X","M",2002,43,160,16.796874999999996,"D",null,"S",null,null,3,179,509,2328,"+","++","","Sottopeso"]
[20,"TROVATO JACOPO","X","M",2002,64.8,174,21.403091557669441,"D",null,"I",null,null,-19,171,547,2562,"+","+","","Normopeso"]
[21,"VALATOVICH DARYA","X","F",2002,60.8,170,21.038062283737027,"S",null,"N",null,null,13,null,null,null,"=","+","","Normopeso"]
[22,"VIVO GEYZEFF REI","X","F",2002,47.1,155,19.604578563995837,"D",null,"N",null,null,2,134,600,2700,"+","+","","Normopeso"]
[23,"YUZON KIMBERLY JOI CORRAI",null,"F",2001,null,null,"",null,null,null,null,null,null,178,538,2631,"+","+","Assente",""]
[24,"POP MALINA","X","F",2000,60.2,158,24.114725204294182,"D",null,"N",null,null,6,155,584,2850,"+","+","","Normopeso"]
[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":24},null,null,null,null,null,"Dx","Sx","S","NS","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.75},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":0.94444444444444442},{"$f":"AVERAGE(E3:E32)","v":2001.5},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":56.988888888888887},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":163.38888888888889},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":21.339458941899522},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.83333333333333337},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.16666666666666666},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.5},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.33333333333333331},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.16666666666666666},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-0.70588235294117652},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":161.6875},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":569.66666666666663},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2831.375},{"$f":"COUNTIF(R$3:R$32,\"=++\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.1111111111111111},{"$f":"COUNTIF(S$3:S$32,\"=++\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.27777777777777779}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.25},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.33333333333333331},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.1666666666667},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":55.56666666666667},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":166.5},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":20.038408390496873},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.83333333333333337},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.16666666666666666},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.66666666666666663},{"$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.33333333333333331},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-9.6},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":185.4},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":527.75},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2650.6},{"$f":"COUNTIF(R$3:R$32,\"=+\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.3888888888888889},{"$f":"COUNTIF(S$3:S$32,\"=+\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.61111111111111116}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.41666666666666669},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.61111111111111116},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001.7272727272727},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":56.7},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":160.36363636363637},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":22.017903844227604},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.90909090909090906},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":9.0909090909090912E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.36363636363636365},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.54545454545454541},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.54545454545454541},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":3.2727272727272729},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":148},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":595.29999999999995},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":2958},{"$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":5.5555555555555552E-2}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":18},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":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":17},{"$f":"MAX(O3:O32)","v":214},{"$f":"MIN(P3:P32)","v":462},{"$f":"MIN(Q3:Q32)","v":2325},{"$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":"PERUGINI GAIA"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"RICCI FLAVIO"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"RICCI FLAVIO"},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":"RICCI FLAVIO"}]

{"sheet":"1HB","index":9,"n_rows":41,"n_cols":29,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,8,2,9],[2,10,2,12],[2,26,2,27],[0,0,0,22],[0,25,0,28],[1,8,1,9],[1,10,1,12],[1,26,1,27],[3,8,3,9],[3,10,3,12],[3,26,3,27],[4,8,4,9],[4,10,4,12],[4,26,4,27],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,26,5,27],[6,8,6,9],[6,10,6,12],[6,26,6,27],[7,8,7,9],[7,10,7,12],[7,25,8,28],[8,8,8,9],[8,10,8,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]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note",null,"Sport","Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"ALLOCCA CLARA",null,"F",2001,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":"Assente"},{"$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":""},null,null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"AMORI MARCELLO","X","M",2002,48.8,167,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":17.497938255226074},"D",null,"I",null,null,0,197,494,2347,"=","=",{"$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"},null,null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"BALBOA JULLETTA","X","F",2001,56,157,22.718974400584202,"S",null,"N",null,null,4,136,590,3200,"=","=","","Normopeso",null,null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"BIGETTI GIULIA","X","F",2003,93.6,173,31.274015169233849,"D",null,"N",null,null,-2,148,619,null,"++","+","","Sovrappeso","X",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"CASINI NICOLO'","X","M",2002,69.8,171,23.870592660989708,"D",null,"I",null,null,0,196,478,2600,"++","+","","Normopeso"]
[6,"CHAVEZ OBILITAS",null,"F",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente","",null,null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"CHIARADONNA LUDOVICA",null,"F",2002,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[8,"DE VINCENTI SARA",null,"F",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[9,"DI IACOVO UMBERTO","X","M",2002,81,176,26.149276859504134,"D",null,"S",null,null,9,183,469,2466,"++","+","","Normopeso"]
[10,"EBAID MIRA",null,"F",2002,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[11,"FURCINTI MARIA LAURA",null,"F",2002,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[12,"GRANDE CHRISTIAN ",null,"M",1998,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[13,"GUANZON MAHR","X","F",2000,54.6,150,24.266666666666666,"D",null,"S",null,null,0,157,625,2966,"+","=","","Normopeso"]
[14,"LEUZZI MARCANTONIO","X","M",2002,55,163,20.700816741315069,"D",null,"I",null,null,-5,166,516,2503,"++","+","","Normopeso","X"]
[15,"MUCCI ALESSIO",null,"M",2000,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[16,"MARTINEZ CHAMUL DAYANA","X","F",2000,47.6,157,19.311128240496572,"D",null,"S",null,null,7,173,587,2644,"++","+","","Normopeso"]
[17,"OLARASU RAMONA ",null,"F",2001,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[18,"PACIONI ELEONORA","X","F",2002,55.3,170,19.134948096885815,"D",null,"S",null,null,-4,185,494,2256,"+","++","","Normopeso"]
[19,"PAOLUCCI ALESSIA","X","F",2002,81,160,31.640624999999993,"S",null,"N",null,null,-3,136,594,2709,"=","++","","Sovrappeso"]
[20,"ROSSI EDOARDO FRANCESCO","X","M",2002,68.8,176,22.210743801652892,"D",null,"I",null,null,0,186,500,2525,"+","=","","Normopeso"]
[21,"SOCA THOMAS VALERINE",null,"M",1999,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"Assente",""]
[22,"SOFFIATINI CLAUDIO","X","M",2001,92,185,26.880934989043094,"D",null,"I",null,null,0,166,506,2485,"++","=","","Normopeso"]
[23,"SPIZZICHINI DAVIDE ","X","M",2002,53.7,163,20.211524709247623,"D",null,"S",null,null,null,182,500,2472,"+","+","","Sottopeso"]
[24,"YOWAKIM GASMAN FAHMY","X","F",2002,56.4,165,20.716253443526174,"D",null,"N",null,null,7,137,619,2797,"  ",null,"","Normopeso"]
[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":24},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.58333333333333337},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.25},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":65.257142857142853},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":166.64285714285714},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":23.327459931026564},{"$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.35714285714285715},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.2857142857142857},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.35714285714285715},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":1},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":167.71428571428572},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":542.21428571428567},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\")","v":2613.0769230769229},{"$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.15384615384615385}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.29166666666666669},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.5},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.8571428571429},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":67.014285714285705},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":171.57142857142858},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":22.503118288139799},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$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},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.7142857142857143},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":0.66666666666666663},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":182.28571428571428},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":494.71428571428572},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"M\")","v":2485.4285714285716},{"$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":0.46153846153846156}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.29166666666666669},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.5},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001.4285714285713},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":63.499999999999993},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":161.71428571428572},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":24.151801573913325},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.7142857142857143},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.2857142857142857},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.42857142857142855},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.5714285714285714},{"$f":"(COUNTIFS(K3:K32,\"I\",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":1.2857142857142858},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":153.14285714285714},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":589.71428571428567},{"$f":"AVERAGEIFS(Q3:Q32,C3:C32,\"X\",D3:D32,\"F\")","v":2762},{"$f":"COUNTIF(R$3:R$32,\"==\")/COUNTIFS(R$3:R$32,\"<>X\",R$3:R$32,\"<>\")","v":0.21428571428571427},{"$f":"COUNTIF(S$3:S$32,\"==\")/COUNTIFS(S$3:S$32,\"<>X\",S$3:S$32,\"<>\")","v":0.38461538461538464}]
[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":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":9},{"$f":"MAX(O3:O32)","v":197},{"$f":"MIN(P3:P32)","v":469},{"$f":"MIN(Q3:Q32)","v":2256},{"$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":"DI IACOVO UMBERTO"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"AMORI MARCELLO"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"DI IACOVO UMBERTO"},{"$f":"INDEX(B3:B32,MATCH(Q40,Q3:Q32,0),1)","v":"PACIONI ELEONORA"}]

{"sheet":"MODELLO","index":10,"n_rows":41,"n_cols":28,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,25,5,26],[6,25,6,26],[7,24,8,27],[0,24,0,27],[1,25,1,26],[2,25,2,26],[3,25,3,26],[4,25,4,26],[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],[24,8,24,9],[24,10,24,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,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],[18,8,18,9],[18,10,18,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,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],[12,8,12,9],[12,10,12,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,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],[6,8,6,9],[6,10,6,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[0,0,0,21],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[3,8,3,9],[3,10,3,12],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Destrezza","Volley","Basket","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"",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":""},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"",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":""},null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"",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,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"",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,"",""]
[9,"",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,"",""]
[11,"",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,"",""]
[13,"",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,"",""]
[15,"",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,"",""]
[17,"",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,"",""]
[19,"",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,"",""]
[21,"",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,"",""]
[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":22},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":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":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":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,\"I\",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"}}]