{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Information","AthletInnen","IFT 30-15 Testprotokoll","HIIT mit fixer Geschwindigkeit","HIIT mit % aus VIFT"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":4,"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":"Information","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AthletInnen","index":1,"n_rows":46,"n_cols":37,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,33,2,33],[1,34,2,34],[1,35,2,35],[1,36,2,36],[1,28,2,28],[1,29,2,29],[1,30,2,30],[1,31,2,31],[1,32,2,32],[1,13,2,13],[1,14,2,14],[1,25,2,25],[1,26,2,26],[1,27,2,27],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[45,0,45,7],[0,27,0,36],[43,0,43,2],[0,3,0,9],[1,23,1,24],[1,15,1,16],[1,17,1,18],[1,19,1,20],[1,21,1,22],[0,0,0,2],[0,11,0,14],[0,15,0,24],[0,25,0,26],[1,0,2,0],[1,1,2,1],[1,2,2,2]]}
["Spieler",null,null,"Körperdaten",null,null,null,null,null,null,null,"Metobalische Daten",null,null,null,"Herzfrequenzzonen",null,null,null,null,null,null,null,null,null,"Aerob / Anaerobe Schwelle",null,"Geschwindigkeitsempfehlungen ausgehend vom 30-15 IFT-Test"]
["NR","Name, Vorname","Geb.Datum","Alter","Größe [m]","Gewicht [kg]","Körperfett","Fettfreier Masse Index","Ruhepuls [S/min]","max.Puls [S/min]","max. km/h VIFT \n30-15","vVO2max [km/h]\n\nGeschwindigkeit in km/h bei welcher der \nVO2max-Wert erreicht wird","vANAEROB (VT2)\n4mmol Schwelle [km/h]\n\nGeschwindigkeit in km/h bei welcher die \n4mmol/L Laktat-Schwelle erreicht wird\n","vANAEROB (VT2)\n4mmol Schwelle [m/S]","VO2max [ml/min/kg] maximale Sauerstoffaufnahme in ml/min/kg Körpergewicht","64-71 [%] von HFmax\n",null,"72-78 [%] von HFmax\n",null,"79-84 [%] von         HFmax\n",null,"85-91 [%] von         HFmax\n",null,"92-100 [%] von             HFmax\n",null,"AEROBE\nSchwelle","ANAEROBE\nSchwelle","REG\nkm/h","AEROB\nkm/h","EXT ANE\nkm/h","INT ANE\nkm/h","ANAER\nkm/h","REG\nmin/km","AEROB\nmin/km","EXT ANE\nmin/km","INT ANE\nmin/km","ANAER\nmin/km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,71,72,78,79,87,85,91,92,100]
[1,"Test1",null,{"$f":"IF(ISNUMBER(C4),DATEDIF(C4,TODAY(),\"Y\"),\"\")","v":""},null,null,null,{"$f":"IF(ISNUMBER(E4),(F4-(F4*G4)/100)/(E4*E4),\"\")","v":""},null,null,{"$f":"'IFT 30-15 Testprotokoll'!L4","v":""},{"$f":"IF(ISNUMBER(K4),K4/1.2,\"\")","v":""},{"$f":"IF(ISNUMBER(L4),L4*0.85,\"\")","v":""},{"$f":"IF(ISNUMBER(M4),M4/3.6,\"\")","v":""},{"$f":"IF(ISNUMBER(K4),28.3-(2.15*1)-(0.741*D4)-(0.0357*F4)+(0.0586*D4*K4)+(1.03*K4),\"\")","v":""},{"$f":"IF(ISNUMBER(J4),P$3*J4/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J4),Q$3*J4/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J4),R$3*J4/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J4),S$3*J4/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J4),T$3*J4/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J4),U$3*J4/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J4),V$3*J4/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J4),W$3*J4/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J4),X$3*J4/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J4),Y$3*J4/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J4),(J4-I4)*0.5+I4,\"\")","v":""},{"$f":"IF(ISNUMBER(J4),(J4-I4)*0.7+I4,\"\")","v":""},{"$f":"IF(ISNUMBER(AC4),AC4*0.9,\"\")","v":""},{"$f":"IF(ISNUMBER(AD4),AD4*0.9,\"\")","v":""},{"$f":"IF(ISNUMBER(AE4),AE4*0.9,\"\")","v":""},{"$f":"IF(ISNUMBER(M4),M4,\"\")","v":""},{"$f":"IF(ISNUMBER(AE4),AE4*1.1,\"\")","v":""},{"$f":"IF(ISNUMBER(AB4),TIME(0,0,1/(AB4/3600)),\"\")","v":""},{"$f":"IF(ISNUMBER(AC4),TIME(0,0,1/(AC4/3600)),\"\")","v":""},{"$f":"IF(ISNUMBER(AD4),TIME(0,0,1/(AD4/3600)),\"\")","v":""},{"$f":"IF(ISNUMBER(AE4),TIME(0,0,1/(AE4/3600)),\"\")","v":""},{"$f":"IF(ISNUMBER(AF4),TIME(0,0,1/(AF4/3600)),\"\")","v":""}]
[2,"Test2",null,{"$f":"IF(ISNUMBER(C5),DATEDIF(C5,TODAY(),\"Y\"),\"\")","v":""},null,null,null,{"$f":"IF(ISNUMBER(E5),(F5-(F5*G5)/100)/(E5*E5),\"\")","v":""},null,null,{"$f":"'IFT 30-15 Testprotokoll'!L5","v":""},{"$f":"IF(ISNUMBER(K5),K5/1.2,\"\")","v":""},{"$f":"IF(ISNUMBER(L5),L5*0.85,\"\")","v":""},{"$f":"IF(ISNUMBER(M5),M5/3.6,\"\")","v":""},{"$f":"IF(ISNUMBER(K5),28.3-(2.15*1)-(0.741*D5)-(0.0357*F5)+(0.0586*D5*K5)+(1.03*K5),\"\")","v":""},{"$f":"IF(ISNUMBER(J5),P$3*J5/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J5),Q$3*J5/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J5),R$3*J5/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J5),S$3*J5/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J5),T$3*J5/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J5),U$3*J5/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J5),V$3*J5/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J5),W$3*J5/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J5),X$3*J5/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J5),Y$3*J5/100,\"\")","v":""},{"$f":"IF(ISNUMBER(J5),(J5-I5)*0.5+I5,\"\")","v":""},{"$f":"IF(ISNUMBER(J5),(J5-I5)*0.7+I5,\"\")","v":""},{"$f":"IF(ISNUMBER(AC5),AC5*0.9,\"\")","v":""},"","",{"$f":"IF(ISNUMBER(M5),M5,\"\")","v":""},{"$f":"IF(ISNUMBER(AE5),AE5*1.1,\"\")","v":""},{"$f":"IF(ISNUMBER(AB5),TIME(0,0,1/(AB5/3600)),\"\")","v":""},{"$f":"IF(ISNUMBER(AC5),TIME(0,0,1/(AC5/3600)),\"\")","v":""},{"$f":"IF(ISNUMBER(AD5),TIME(0,0,1/(AD5/3600)),\"\")","v":""},{"$f":"IF(ISNUMBER(AE5),TIME(0,0,1/(AE5/3600)),\"\")","v":""},{"$f":"IF(ISNUMBER(AF5),TIME(0,0,1/(AF5/3600)),\"\")","v":""}]
[3,"Test3",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L6","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC6),AC6*0.9,\"\")","v":""},"","","","","","","","",""]
[4,"Test4",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L7","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC7),AC7*0.9,\"\")","v":""},"","","","","","","","",""]
[5,"Test5",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L8","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC8),AC8*0.9,\"\")","v":""},"","","","","","","","",""]
[6,"Test6",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L9","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC9),AC9*0.9,\"\")","v":""},"","","","","","","","",""]
[7,"Test7",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L10","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC10),AC10*0.9,\"\")","v":""},"","","","","","","","",""]
[8,"Test8",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L11","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC11),AC11*0.9,\"\")","v":""},"","","","","","","","",""]
[9,"Test9",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L12","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC12),AC12*0.9,\"\")","v":""},"","","","","","","","",""]
[10,"Test10",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L13","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC13),AC13*0.9,\"\")","v":""},"","","","","","","","",""]
[11,"Spieler 11",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L14","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC14),AC14*0.9,\"\")","v":""},"","","","","","","","",""]
[12,"Spieler 12",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L15","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC15),AC15*0.9,\"\")","v":""},"","","","","","","","",""]
[13,"Spieler 13",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L16","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC16),AC16*0.9,\"\")","v":""},"","","","","","","","",""]
[14,"Spieler 14",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L17","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC17),AC17*0.9,\"\")","v":""},"","","","","","","","",""]
[15,"Spieler 15",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L18","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC18),AC18*0.9,\"\")","v":""},"","","","","","","","",""]
[16,"Spieler 16",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L19","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC19),AC19*0.9,\"\")","v":""},"","","","","","","","",""]
[17,"Spieler 17",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L20","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC20),AC20*0.9,\"\")","v":""},"","","","","","","","",""]
[18,"Spieler 18",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L21","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC21),AC21*0.9,\"\")","v":""},"","","","","","","","",""]
[19,"Spieler 19",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L22","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC22),AC22*0.9,\"\")","v":""},"","","","","","","","",""]
[20,"Spieler 20",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L23","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC23),AC23*0.9,\"\")","v":""},"","","","","","","","",""]
[21,"Spieler 21",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L24","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC24),AC24*0.9,\"\")","v":""},"","","","","","","","",""]
[22,"Spieler 22",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L25","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC25),AC25*0.9,\"\")","v":""},"","","","","","","","",""]
[23,"Spieler 23",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L26","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC26),AC26*0.9,\"\")","v":""},"","","","","","","","",""]
[24,"Spieler 24",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L27","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC27),AC27*0.9,\"\")","v":""},"","","","","","","","",""]
[25,"Spieler 25",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L28","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC28),AC28*0.9,\"\")","v":""},"","","","","","","","",""]
[26,"Spieler 26",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L29","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC29),AC29*0.9,\"\")","v":""},"","","","","","","","",""]
[27,"Spieler 27",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L30","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC30),AC30*0.9,\"\")","v":""},"","","","","","","","",""]
[28,"Spieler 28",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L31","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC31),AC31*0.9,\"\")","v":""},"","","","","","","","",""]
[29,"Spieler 29",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L32","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC32),AC32*0.9,\"\")","v":""},"","","","","","","","",""]
[30,"Spieler 30",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L33","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC33),AC33*0.9,\"\")","v":""},"","","","","","","","",""]
[31,"Spieler 31",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L34","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC34),AC34*0.9,\"\")","v":""},"","","","","","","","",""]
[32,"Spieler 32",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L35","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC35),AC35*0.9,\"\")","v":""},"","","","","","","","",""]
[33,"Spieler 33",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L36","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC36),AC36*0.9,\"\")","v":""},"","","","","","","","",""]
[34,"Spieler 34",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L37","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC37),AC37*0.9,\"\")","v":""},"","","","","","","","",""]
[35,"Spieler 35",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L38","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC38),AC38*0.9,\"\")","v":""},"","","","","","","","",""]
[36,"Spieler 36",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L39","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC39),AC39*0.9,\"\")","v":""},"","","","","","","","",""]
[37,"Spieler 37",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L40","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC40),AC40*0.9,\"\")","v":""},"","","","","","","","",""]
[38,"Spieler 38",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L41","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC41),AC41*0.9,\"\")","v":""},"","","","","","","","",""]
[39,"Spieler 39",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L42","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC42),AC42*0.9,\"\")","v":""},"","","","","","","","",""]
[40,"Spieler 40",null,"",null,null,null,"",null,null,{"$f":"'IFT 30-15 Testprotokoll'!L43","v":""},"",{"$f":"IF(ISNUMBER(L43),L43*0.85,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(ISNUMBER(AC43),AC43*0.9,\"\")","v":""},"","","","","","","","",""]
["Mittelwerte",null,null,{"$f":"AVERAGE(IF(D4:D43<>0,D4:D43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(E4:E43<>0,E4:E43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(F4:F43<>0,F4:F43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(G4:G43<>0,G4:G43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IFERROR(H4:H43,\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(I4:I43<>0,I4:I43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(J4:J43<>0,J4:J43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(K4:K43<>0,K4:K43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(L4:L43<>0,L4:L43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(M4:M43<>0,M4:M43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(N4:N43<>0,N4:N43))","v":{"$error":"#DIV/0!"}},"",{"$f":"AVERAGE(IF(P4:P43<>0,P4:P43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(Q4:Q43<>0,Q4:Q43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(R4:R43<>0,R4:R43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(S4:S43<>0,S4:S43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(T4:T43<>0,T4:T43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(U4:U43<>0,U4:U43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(V4:V43<>0,V4:V43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(W4:W43<>0,W4:W43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(X4:X43<>0,X4:X43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(Y4:Y43<>0,Y4:Y43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(Z4:Z43<>0,Z4:Z43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(AA4:AA43<>0,AA4:AA43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(AB4:AB43<>0,AB4:AB43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(AC4:AC43<>0,AC4:AC43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(AD4:AD43<>0,AD4:AD43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(AE4:AE43<>0,AE4:AE43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IF(AF4:AF43<>0,AF4:AF43))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IFERROR(AG4:AG43,\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IFERROR(AH4:AH43,\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IFERROR(AI4:AI43,\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IFERROR(AJ4:AJ43,\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(IFERROR(AK4:AK43,\"\"))","v":{"$error":"#DIV/0!"}}]
[]
[" © by Rexhep Kushutani Msc (VfL Bochum) & Florian Maierhofer MSc (MFT) (nach der Idee von Martin Buchheit)"]

{"sheet":"IFT 30-15 Testprotokoll","index":2,"n_rows":408,"n_cols":37,"rows_kept":408,"cut":false,"hidden":false,"merged":[[58,32,58,34],[58,36,58,38],[45,8,45,11],[44,8,44,11],[47,8,47,9],[48,8,48,9],[49,8,49,9],[50,8,50,9],[47,12,47,15],[48,12,48,15],[49,12,49,15],[50,12,50,15],[55,36,55,38],[56,32,56,34],[56,36,56,38],[57,32,57,34],[57,36,57,38],[52,24,52,25],[52,28,52,32],[53,24,53,25],[53,28,53,32],[55,32,55,34],[55,5,55,9],[50,20,50,22],[44,12,44,16],[45,12,45,16],[47,20,47,22],[48,20,48,22],[49,20,49,22]]}
[null,null,null,null,null,"Starting speed [km/h]",8,"Starting time","08:56:04"]
[null,null,null,null,null,"Speed Increment [km/h]",0.5]
[null,"Raw Speed","Final Speed","T(s)","Time",null,"Name","Finishing time","Running time (s)","Peak velocity ",null,"max. VIFT [km/h]","Average","Ranking"]
[null,{"$f":"G$1","v":8},{"$f":"(((D4-D$4)/45)*G$2)+B$4","v":8},0,{"$f":"D4*1/(3600*24)","v":"00:00:00"},null,{"$f":"AthletInnen!B4","v":"Test1"},null,{"$f":"IF(H4=\"\",\"\",(H4/(1/(3600*24)))-(I$1/(1/(3600*24))))","v":""},{"$f":"IF(I4=\"\",\"\",LOOKUP(I4,D$4:D$320,C$4:C$320))","v":""},{"$f":"IF(J4=\"\",\"\",ROUNDDOWN(J4,0))","v":""},{"$f":"IF(K4=\"\",\"\",IF(J4-K4<=0.1,K4-0.5,IF(J4-K4>=0.5,K4+0.5,K4)))","v":""},{"$f":"IF(ISNUMBER(L4),AVERAGE(IF($L$4:$L$43<>0,$L$4:$L$43)),\"\")","v":""},{"$f":"IF(ISNUMBER(L4),_xlfn.RANK.EQ(L4,L4:L43,0),\"\")","v":""}]
[null,8,8.0555555555555554,5,{"$f":"D5*1/(3600*24)","v":"00:00:05"},null,{"$f":"AthletInnen!B5","v":"Test2"},null,{"$f":"IF(H5=\"\",\"\",(H5/(1/(3600*24)))-(I$1/(1/(3600*24))))","v":""},"","",{"$f":"IF(K5=\"\",\"\",IF(J5-K5<=0.1,K5-0.5,IF(J5-K5>=0.5,K5+0.5,K5)))","v":""},{"$f":"IF(ISNUMBER(L5),AVERAGE(IF($L$4:$L$43<>0,$L$4:$L$43)),\"\")","v":""},{"$f":"IF(ISNUMBER(L5),_xlfn.RANK.EQ(L5,L5:L44,0),\"\")","v":""}]
[null,8,8.1111111111111107,10,{"$f":"D6*1/(3600*24)","v":"00:00:10"},null,{"$f":"AthletInnen!B6","v":"Test3"},null,"","","","","",""]
[null,8,8.1666666666666661,15,"00:00:15",null,{"$f":"AthletInnen!B7","v":"Test4"},null,"","","","","",""]
[null,8,8.2222222222222214,20,"00:00:20",null,{"$f":"AthletInnen!B8","v":"Test5"},null,"","","","","",""]
[null,8,8.2777777777777786,25,"00:00:25",null,{"$f":"AthletInnen!B9","v":"Test6"},null,"","","","","",""]
[null,8,8.3333333333333339,30,"00:00:30",null,{"$f":"AthletInnen!B10","v":"Test7"},null,"","",{"$f":"IF(J10=\"\",\"\",ROUNDDOWN(J10,0))","v":""},"","",""]
[null,8,8.3888888888888893,35,"00:00:35",null,{"$f":"AthletInnen!B11","v":"Test8"},null,"","",{"$f":"IF(J11=\"\",\"\",ROUNDDOWN(J11,0))","v":""},"","",""," "]
[null,8,8.4444444444444446,40,"00:00:40",null,{"$f":"AthletInnen!B12","v":"Test9"},null,"","","","","",""]
[null,{"$f":"B4+G$2","v":8.5},8.5,45,"00:00:45",null,{"$f":"AthletInnen!B13","v":"Test10"},null,{"$f":"IF(H13=\"\",\"\",(H13/(1/(3600*24)))-(I$1/(1/(3600*24))))","v":""},"","","","",""]
[null,8.5,8.5555555555555554,50,"00:00:50",null,{"$f":"AthletInnen!B14","v":"Spieler 11"},null,{"$f":"IF(H14=\"\",\"\",(H14/(1/(3600*24)))-(I$1/(1/(3600*24))))","v":""},"","","","",""]
[null,8.5,8.6111111111111107,55,"00:00:55",null,{"$f":"AthletInnen!B15","v":"Spieler 12"},null,"","","","","",""]
[null,8.5,8.6666666666666661,60,"00:01:00",null,{"$f":"AthletInnen!B16","v":"Spieler 13"},null,"","","",{"$f":"IF(K16=\"\",\"\",IF(J16-K16<=0.1,K16-0.5,IF(J16-K16>=0.5,K16+0.5,K16)))","v":""},"",""]
[null,8.5,8.7222222222222214,65,"00:01:05",null,{"$f":"AthletInnen!B17","v":"Spieler 14"},null,"","","","","",""]
[null,8.5,8.7777777777777786,70,"00:01:10",null,{"$f":"AthletInnen!B18","v":"Spieler 15"},null,"","","","","",""]
[null,8.5,8.8333333333333339,75,"00:01:15",null,{"$f":"AthletInnen!B19","v":"Spieler 16"},null,"","","","","",""]
[null,8.5,8.8888888888888893,80,"00:01:20",null,{"$f":"AthletInnen!B20","v":"Spieler 17"},null,"","","","","",""]
[null,8.5,8.9444444444444446,85,"00:01:25",null,{"$f":"AthletInnen!B21","v":"Spieler 18"},null,"","","","","",""]
[null,9,9,90,"00:01:30",null,{"$f":"AthletInnen!B22","v":"Spieler 19"},null,"","","","","",""]
[null,9,9.0555555555555554,95,"00:01:35",null,{"$f":"AthletInnen!B23","v":"Spieler 20"},null,"","","","","",""]
[null,9,9.1111111111111107,100,"00:01:40",null,{"$f":"AthletInnen!B24","v":"Spieler 21"},null,"","","","","",""]
[null,9,9.1666666666666661,105,"00:01:45",null,{"$f":"AthletInnen!B25","v":"Spieler 22"},null,"","","","","",""]
[null,9,9.2222222222222214,110,"00:01:50",null,{"$f":"AthletInnen!B26","v":"Spieler 23"},null,"","","",{"$f":"IF(K26=\"\",\"\",IF(J26-K26<=0.1,K26-0.5,IF(J26-K26>=0.5,K26+0.5,K26)))","v":""},"",""]
[null,9,9.2777777777777786,115,"00:01:55",null,{"$f":"AthletInnen!B27","v":"Spieler 24"},null,"","","","","",""]
[null,9,9.3333333333333339,120,"00:02:00",null,{"$f":"AthletInnen!B28","v":"Spieler 25"},null,"","","","","",""]
[null,9,9.3888888888888893,125,"00:02:05",null,{"$f":"AthletInnen!B29","v":"Spieler 26"},null,{"$f":"IF(H29=\"\",\"\",(H29/(1/(3600*24)))-(I$1/(1/(3600*24))))","v":""},"","","","",""]
[null,9,9.4444444444444446,130,"00:02:10",null,{"$f":"AthletInnen!B30","v":"Spieler 27"},null,"","","","","",""]
[null,9.5,9.5,135,"00:02:15",null,{"$f":"AthletInnen!B31","v":"Spieler 28"},null,"","","","","",""]
[null,9.5,9.5555555555555554,140,"00:02:20",null,{"$f":"AthletInnen!B32","v":"Spieler 29"},null,"","","","","",""]
[null,9.5,9.6111111111111107,145,"00:02:25",null,{"$f":"AthletInnen!B33","v":"Spieler 30"},null,"","","","","",""]
[null,9.5,9.6666666666666661,150,"00:02:30",null,{"$f":"AthletInnen!B34","v":"Spieler 31"},null,"","","","","",""]
[null,9.5,9.7222222222222214,155,"00:02:35",null,{"$f":"AthletInnen!B35","v":"Spieler 32"},null,"","","","","",""]
[null,9.5,9.7777777777777786,160,"00:02:40",null,{"$f":"AthletInnen!B36","v":"Spieler 33"},null,"","","","","",""]
[null,9.5,9.8333333333333339,165,"00:02:45",null,{"$f":"AthletInnen!B37","v":"Spieler 34"},null,"","","","","",""]
[null,9.5,9.8888888888888893,170,"00:02:50",null,{"$f":"AthletInnen!B38","v":"Spieler 35"},null,"","","","","",""]
[null,9.5,9.9444444444444446,175,"00:02:55",null,{"$f":"AthletInnen!B39","v":"Spieler 36"},null,"","","","","",""]
[null,10,10,180,"00:03:00",null,{"$f":"AthletInnen!B40","v":"Spieler 37"},null,"","","","","",""]
[null,10,10.055555555555555,185,"00:03:05",null,{"$f":"AthletInnen!B41","v":"Spieler 38"},null,"","","","","",""]
[null,10,10.111111111111111,190,"00:03:10",null,{"$f":"AthletInnen!B42","v":"Spieler 39"},null,"","","","","",""]
[null,10,10.166666666666666,195,"00:03:15",null,{"$f":"AthletInnen!B43","v":"Spieler 40"},null,"","","","","",""]
[]
[null,{"$f":"B35+G$2","v":10},10.222222222222221,200,"00:03:20",null,"Mittelwert",{"$f":"AVERAGE(IF($L$4:$L$43<>0,$L$4:$L$43))","v":{"$error":"#DIV/0!"}},"zeigt den Durchschnitt aller Werte"]
[null,null,null,null,null,null,"Standardabweichung",{"$f":"_xlfn.STDEV.P(IF($L$4:$L$43<>0,$L$4:$L$43))","v":{"$error":"#DIV/0!"}},"zeigt die Streuung der Werte um den Mittelwert"]
[null,{"$f":"B36+G$2","v":10},{"$f":"(((D47-D$4)/45)*G$2)+B$4","v":10.277777777777779},205,"00:03:25"]
[null,10,10.333333333333334,210,"00:03:30",null,"10% Quartil",{"$f":"_xlfn.PERCENTILE.INC($L$4:$L$43,0.1)","v":{"$error":"#NUM!"}},"10% der Wert sind >",null,null,{"$f":"H48","v":{"$error":"#NUM!"}},"10% der AtlethInnen sind  besser als",null,null,null,{"$f":"L48","v":{"$error":"#NUM!"}}]
[null,10,10.388888888888889,215,"00:03:35",null,"0,25 Quartil",{"$f":"_xlfn.PERCENTILE.INC($L$4:$L$43,0.25)","v":{"$error":"#NUM!"}},"25% der Werte sind >",null,null,{"$f":"H49","v":{"$error":"#NUM!"}},"25% der AtlethInnen sind  besser als",null,null,null,{"$f":"L49","v":{"$error":"#NUM!"}}]
[null,10,10.444444444444445,220,"00:03:40",null,"0,50 Quartil",{"$f":"_xlfn.PERCENTILE.INC($L$4:$L$43,0.5)","v":{"$error":"#NUM!"}},"50% der Werte sind >",null,null,{"$f":"H50","v":{"$error":"#NUM!"}},"50% der AtlethInnen sind  besser als",null,null,null,{"$f":"L50","v":{"$error":"#NUM!"}}]
[null,10.5,10.5,225,"00:03:45",null,"0,75 Quartil ",{"$f":"_xlfn.PERCENTILE.INC($L$4:$L$43,0.75)","v":{"$error":"#NUM!"}},"75% der Werte sind >",null,null,{"$f":"H51","v":{"$error":"#NUM!"}},"75% der AtlethInnen sind  besser als",null,null,null,{"$f":"L51","v":{"$error":"#NUM!"}}]
[null,10.5,10.555555555555555,230,"00:03:50"]
[null,10.5,10.611111111111111,235,"00:03:55",null,"Minimun",{"$f":"MIN($L$4:$L$43)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mittelwert der max. VIFT",null,null,{"$f":"AVERAGE(IF($L$4:$L$43<>0,$L$4:$L$43))","v":{"$error":"#DIV/0!"}},"zeigt den Durchschnitt aller Werte"]
[null,10.5,10.666666666666666,240,"00:04:00",null,"Maximum",{"$f":"MAX($L$4:$L$43)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standardabweichung",null,null,{"$f":"_xlfn.STDEV.P(IF($L$4:$L$43<>0,$L$4:$L$43))","v":{"$error":"#DIV/0!"}},"zeigt die Streuung der Werte um den Mittelwert"]
[null,{"$f":"B45+G$2","v":10.5},10.722222222222221,245,"00:04:05"]
[null,{"$f":"B47+G$2","v":10.5},10.777777777777779,250,"00:04:10"," © by Rexhep Kushutani Msc (VfL Bochum) & Florian Maierhofer MSc (MFT) (nach der Idee von Martin Buchheit)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10% Quartil","0,1 Quartil",null,{"$f":"_xlfn.PERCENTILE.INC(AB12:AB51,0.1)","v":{"$error":"#NUM!"}},"10% der Werte sind kleiner als ",null,null,{"$f":"AB56","v":{"$error":"#NUM!"}},"AthletInnen mit einem Wert >= ",null,null,{"$f":"AB56","v":{"$error":"#NUM!"}},"sind besser als 10% der Gruppe"]
[null,10.5,10.833333333333334,255,"00:04:15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Quartil","0,25 Quartil",null,{"$f":"_xlfn.PERCENTILE.INC(AB12:AB51,0.25)","v":{"$error":"#NUM!"}},"25% der Werte sind kleiner als ",null,null,{"$f":"AB57","v":{"$error":"#NUM!"}},"AthletInnen mit einem Wert >= ",null,null,{"$f":"AB57","v":{"$error":"#NUM!"}},"sind besser als 25% der Gruppe"]
[null,10.5,10.888888888888889,260,"00:04:20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Quartil","0,50 Quartil",null,{"$f":"_xlfn.PERCENTILE.INC(AB12:AB51,0.5)","v":{"$error":"#NUM!"}},"50% der Werte sind kleiner als",null,null,{"$f":"AB58","v":{"$error":"#NUM!"}},"AthletInnen mit einem Wert >= ",null,null,{"$f":"AB58","v":{"$error":"#NUM!"}},"sind besser als 50% der Gruppe"]
[null,10.5,10.944444444444445,265,"00:04:25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Quartil ","0,75 Quartil",null,{"$f":"_xlfn.PERCENTILE.INC(AB12:AB51,0.75)","v":{"$error":"#NUM!"}},"75% der Werte sind kleiner als",null,null,{"$f":"AB59","v":{"$error":"#NUM!"}},"AthletInnen mit einem Wert >= ",null,null,{"$f":"AB59","v":{"$error":"#NUM!"}},"sind besser als 75% der Gruppe"]
[null,11,11,270,"00:04:30"]
[null,11,11.055555555555555,275,"00:04:35",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum",{"$f":"MIN(AB12:AB33)","v":0}]
[null,11,11.111111111111111,280,"00:04:40",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum",{"$f":"MAX(AB12:AB33)","v":0}]
[null,11,11.166666666666666,285,"00:04:45"]
[null,11,11.222222222222221,290,"00:04:50"]
[null,11,11.277777777777779,295,"00:04:55"]
[null,11,11.333333333333334,300,"00:05:00"]
[null,11,11.388888888888889,305,"00:05:05"]
[null,11,11.444444444444445,310,"00:05:10"]
[null,11.5,11.5,315,"00:05:15"]
[null,11.5,11.555555555555555,320,"00:05:20"]
[null,11.5,11.611111111111111,325,"00:05:25"]
[null,11.5,11.666666666666666,330,{"$f":"D72*1/(3600*24)","v":"00:05:30"}]
[null,11.5,11.722222222222221,335,"00:05:35"]
[null,11.5,11.777777777777779,340,"00:05:40"]
[null,11.5,11.833333333333334,345,"00:05:45"]
[null,11.5,11.888888888888889,350,"00:05:50"]
[null,11.5,11.944444444444445,355,"00:05:55"]
[null,12,12,360,"00:06:00"]
[null,12,12.055555555555555,365,"00:06:05"]
[null,12,12.111111111111111,370,"00:06:10"]
[null,12,12.166666666666668,375,"00:06:15"]
[null,12,12.222222222222221,380,"00:06:20"]
[null,12,12.277777777777779,385,"00:06:25"]
[null,12,12.333333333333332,390,"00:06:30"]
[null,12,12.388888888888889,395,"00:06:35"]
[null,12,12.444444444444445,400,"00:06:40"]
[null,12.5,12.5,405,"00:06:45"]
[null,12.5,12.555555555555555,410,"00:06:50"]
[null,12.5,12.611111111111111,415,"00:06:55"]
[null,12.5,12.666666666666668,420,"00:07:00"]
[null,12.5,12.722222222222221,425,"00:07:05"]
[null,12.5,12.777777777777779,430,"00:07:10"]
[null,12.5,12.833333333333332,435,"00:07:15"]
[null,12.5,12.888888888888889,440,"00:07:20"]
[null,12.5,12.944444444444445,445,"00:07:25"]
[null,13,13,450,"00:07:30"]
[null,13,13.055555555555555,455,"00:07:35"]
[null,13,13.111111111111111,460,"00:07:40"]
[null,13,13.166666666666668,465,"00:07:45"]
[null,13,13.222222222222221,470,"00:07:50"]
[null,13,13.277777777777779,475,"00:07:55"]
[null,13,13.333333333333332,480,"00:08:00"]
[null,13,13.388888888888889,485,"00:08:05"]
[null,13,13.444444444444445,490,"00:08:10"]
[null,13.5,13.5,495,"00:08:15"]
[null,13.5,13.555555555555555,500,"00:08:20"]
[null,13.5,13.611111111111111,505,"00:08:25"]
[null,13.5,13.666666666666668,510,"00:08:30"]
[null,13.5,13.722222222222221,515,"00:08:35"]
[null,13.5,13.777777777777779,520,"00:08:40"]
[null,13.5,{"$f":"(((D111-D$4)/45)*G$2)+B$4","v":13.833333333333332},525,"00:08:45"]
[null,13.5,13.888888888888889,530,"00:08:50"]
[null,13.5,13.944444444444445,535,"00:08:55"]
[null,14,14,540,"00:09:00"]
[null,14,14.055555555555555,545,"00:09:05"]
[null,14,14.111111111111111,550,"00:09:10"]
[null,14,14.166666666666668,555,"00:09:15"]
[null,14,14.222222222222221,560,"00:09:20"]
[null,14,14.277777777777779,565,"00:09:25"]
[null,{"$f":"B111+G$2","v":14},14.333333333333332,570,"00:09:30"]
[null,14,14.388888888888889,575,"00:09:35"]
[null,14,14.444444444444445,580,"00:09:40"]
[null,14.5,14.5,585,"00:09:45"]
[null,14.5,14.555555555555555,590,"00:09:50"]
[null,14.5,14.611111111111111,595,"00:09:55"]
[null,14.5,14.666666666666668,600,"00:10:00"]
[null,14.5,14.722222222222221,605,"00:10:05"]
[null,14.5,14.777777777777779,610,"00:10:10"]
[null,14.5,14.833333333333332,615,"00:10:15"]
[null,14.5,14.888888888888889,620,"00:10:20"]
[null,14.5,14.944444444444445,625,"00:10:25"]
[null,15,15,630,"00:10:30"]
[null,15,15.055555555555555,635,"00:10:35"]
[null,15,15.111111111111111,640,"00:10:40"]
[null,15,15.166666666666668,645,"00:10:45"]
[null,15,15.222222222222221,650,{"$f":"D136*1/(3600*24)","v":"00:10:50"}]
[null,15,15.277777777777779,655,"00:10:55"]
[null,15,15.333333333333332,660,"00:11:00"]
[null,15,15.388888888888889,665,"00:11:05"]
[null,15,15.444444444444445,670,"00:11:10"]
[null,15.5,15.5,675,"00:11:15"]
[null,15.5,15.555555555555555,680,"00:11:20"]
[null,15.5,15.611111111111111,685,"00:11:25"]
[null,15.5,15.666666666666668,690,"00:11:30"]
[null,15.5,15.722222222222221,695,"00:11:35"]
[null,15.5,15.777777777777779,700,"00:11:40"]
[null,15.5,15.833333333333332,705,"00:11:45"]
[null,15.5,15.888888888888889,710,"00:11:50"]
[null,15.5,15.944444444444445,715,"00:11:55"]
[null,16,16,720,"00:12:00"]
[null,16,16.055555555555557,725,"00:12:05"]
[null,16,16.111111111111111,730,"00:12:10"]
[null,16,16.166666666666664,735,"00:12:15"]
[null,16,16.222222222222221,740,"00:12:20"]
[null,16,16.277777777777779,745,"00:12:25"]
[null,16,16.333333333333336,750,"00:12:30"]
[null,16,16.388888888888889,755,"00:12:35"]
[null,16,16.444444444444443,760,"00:12:40"]
[null,16.5,16.5,765,"00:12:45"]
[null,16.5,16.555555555555557,770,"00:12:50"]
[null,16.5,16.611111111111111,775,"00:12:55"]
[null,16.5,16.666666666666664,780,"00:13:00"]
[null,16.5,16.722222222222221,785,"00:13:05"]
[null,16.5,16.777777777777779,790,"00:13:10"]
[null,16.5,16.833333333333336,795,"00:13:15"]
[null,16.5,16.888888888888889,800,"00:13:20"]
[null,16.5,16.944444444444443,805,"00:13:25"]
[null,17,17,810,"00:13:30"]
[null,17,17.055555555555557,815,"00:13:35"]
[null,17,17.111111111111111,820,"00:13:40"]
[null,17,17.166666666666664,825,"00:13:45"]
[null,17,17.222222222222221,830,"00:13:50"]
[null,17,17.277777777777779,835,"00:13:55"]
[null,17,17.333333333333336,840,"00:14:00"]
[null,17,{"$f":"(((D175-D$4)/45)*G$2)+B$4","v":17.388888888888889},845,"00:14:05"]
[null,17,17.444444444444443,850,"00:14:10"]
[null,17.5,17.5,855,"00:14:15"]
[null,17.5,17.555555555555557,860,"00:14:20"]
[null,17.5,17.611111111111111,865,"00:14:25"]
[null,17.5,17.666666666666664,870,"00:14:30"]
[null,17.5,17.722222222222221,875,"00:14:35"]
[null,17.5,17.777777777777779,880,"00:14:40"]
[null,17.5,17.833333333333336,885,"00:14:45"]
[null,{"$f":"B175+G$2","v":17.5},17.888888888888889,890,"00:14:50"]
[null,17.5,17.944444444444443,895,"00:14:55"]
[null,18,18,900,"00:15:00"]
[null,18,18.055555555555557,905,"00:15:05"]
[null,18,18.111111111111111,910,"00:15:10"]
[null,18,18.166666666666664,915,"00:15:15"]
[null,18,18.222222222222221,920,"00:15:20"]
[null,18,18.277777777777779,925,"00:15:25"]
[null,18,18.333333333333336,930,"00:15:30"]
[null,18,18.388888888888889,935,"00:15:35"]
[null,18,18.444444444444443,940,"00:15:40"]
[null,18.5,18.5,945,"00:15:45"]
[null,18.5,18.555555555555557,950,"00:15:50"]
[null,18.5,18.611111111111111,955,"00:15:55"]
[null,18.5,18.666666666666664,960,"00:16:00"]
[null,18.5,18.722222222222221,965,"00:16:05"]
[null,18.5,18.777777777777779,970,{"$f":"D200*1/(3600*24)","v":"00:16:10"}]
[null,18.5,18.833333333333336,975,"00:16:15"]
[null,18.5,18.888888888888889,980,"00:16:20"]
[null,18.5,18.944444444444443,985,"00:16:25"]
[null,19,19,990,"00:16:30"]
[null,19,19.055555555555557,995,"00:16:35"]
[null,19,19.111111111111111,1000,"00:16:40"]
[null,19,19.166666666666664,1005,"00:16:45"]
[null,19,19.222222222222221,1010,"00:16:50"]
[null,19,19.277777777777779,1015,"00:16:55"]
[null,19,19.333333333333336,1020,"00:17:00"]
[null,19,19.388888888888889,1025,"00:17:05"]
[null,19,19.444444444444443,1030,"00:17:10"]
[null,19.5,19.5,1035,"00:17:15"]
[null,19.5,19.555555555555557,1040,"00:17:20"]
[null,19.5,19.611111111111111,1045,"00:17:25"]
[null,19.5,19.666666666666664,1050,"00:17:30"]
[null,19.5,19.722222222222221,1055,"00:17:35"]
[null,19.5,19.777777777777779,1060,"00:17:40"]
[null,19.5,19.833333333333336,1065,"00:17:45"]
[null,19.5,19.888888888888889,1070,"00:17:50"]
[null,19.5,19.944444444444443,1075,"00:17:55"]
[null,20,20,1080,"00:18:00"]
[null,20,20.055555555555557,1085,"00:18:05"]
[null,20,20.111111111111111,1090,"00:18:10"]
[null,20,20.166666666666664,1095,"00:18:15"]
[null,20,20.222222222222221,1100,"00:18:20"]
[null,20,20.277777777777779,1105,"00:18:25"]
[null,20,20.333333333333336,1110,"00:18:30"]
[null,20,20.388888888888889,1115,"00:18:35"]
[null,20,20.444444444444443,1120,"00:18:40"]
[null,20.5,20.5,1125,"00:18:45"]
[null,20.5,20.555555555555557,1130,"00:18:50"]
[null,20.5,20.611111111111111,1135,"00:18:55"]
[null,20.5,20.666666666666664,1140,"00:19:00"]
[null,20.5,20.722222222222221,1145,"00:19:05"]
[null,20.5,20.777777777777779,1150,"00:19:10"]
[null,20.5,20.833333333333336,1155,"00:19:15"]
[null,20.5,20.888888888888889,1160,"00:19:20"]
[null,20.5,{"$f":"(((D239-D$4)/45)*G$2)+B$4","v":20.944444444444443},1165,"00:19:25"]
[null,21,21,1170,"00:19:30"]
[null,21,21.055555555555557,1175,"00:19:35"]
[null,21,21.111111111111111,1180,"00:19:40"]
[null,21,21.166666666666664,1185,"00:19:45"]
[null,21,21.222222222222221,1190,"00:19:50"]
[null,21,21.277777777777779,1195,"00:19:55"]
[null,21,21.333333333333336,1200,"00:20:00"]
[null,21,21.388888888888889,1205,"00:20:05"]
[null,{"$f":"B239+G$2","v":21},21.444444444444443,1210,"00:20:10"]
[null,21.5,21.5,1215,"00:20:15"]
[null,21.5,21.555555555555557,1220,"00:20:20"]
[null,21.5,21.611111111111111,1225,"00:20:25"]
[null,21.5,21.666666666666664,1230,"00:20:30"]
[null,21.5,21.722222222222221,1235,"00:20:35"]
[null,21.5,21.777777777777779,1240,"00:20:40"]
[null,21.5,21.833333333333336,1245,"00:20:45"]
[null,21.5,21.888888888888889,1250,"00:20:50"]
[null,21.5,21.944444444444443,1255,"00:20:55"]
[null,22,22,1260,"00:21:00"]
[null,22,22.055555555555557,1265,"00:21:05"]
[null,22,22.111111111111111,1270,"00:21:10"]
[null,22,22.166666666666664,1275,"00:21:15"]
[null,22,22.222222222222221,1280,"00:21:20"]
[null,22,22.277777777777779,1285,"00:21:25"]
[null,22,22.333333333333336,1290,{"$f":"D264*1/(3600*24)","v":"00:21:30"}]
[null,22,22.388888888888889,1295,"00:21:35"]
[null,22,22.444444444444443,1300,"00:21:40"]
[null,22.5,22.5,1305,"00:21:45"]
[null,22.5,22.555555555555557,1310,"00:21:50"]
[null,22.5,22.611111111111111,1315,"00:21:55"]
[null,22.5,22.666666666666664,1320,"00:22:00"]
[null,22.5,22.722222222222221,1325,"00:22:05"]
[null,22.5,22.777777777777779,1330,"00:22:10"]
[null,22.5,22.833333333333336,1335,"00:22:15"]
[null,22.5,22.888888888888889,1340,"00:22:20"]
[null,22.5,22.944444444444443,1345,"00:22:25"]
[null,23,23,1350,"00:22:30"]
[null,23,23.055555555555557,1355,"00:22:35"]
[null,23,23.111111111111111,1360,"00:22:40"]
[null,23,23.166666666666664,1365,"00:22:45"]
[null,23,23.222222222222221,1370,"00:22:50"]
[null,23,23.277777777777779,1375,"00:22:55"]
[null,23,23.333333333333336,1380,"00:23:00"]
[null,23,23.388888888888889,1385,"00:23:05"]
[null,23,23.444444444444443,1390,"00:23:10"]
[null,23.5,23.5,1395,"00:23:15"]
[null,23.5,23.555555555555557,1400,"00:23:20"]
[null,23.5,23.611111111111111,1405,"00:23:25"]
[null,23.5,23.666666666666664,1410,"00:23:30"]
[null,23.5,23.722222222222221,1415,"00:23:35"]
[null,23.5,23.777777777777779,1420,"00:23:40"]
[null,23.5,23.833333333333336,1425,"00:23:45"]
[null,23.5,23.888888888888889,1430,"00:23:50"]
[null,23.5,23.944444444444443,1435,"00:23:55"]
[null,24,24,1440,"00:24:00"]
[null,24,24.055555555555557,1445,"00:24:05"]
[null,24,24.111111111111111,1450,"00:24:10"]
[null,24,24.166666666666668,1455,"00:24:15"]
[null,24,24.222222222222221,1460,"00:24:20"]
[null,24,24.277777777777779,1465,"00:24:25"]
[null,24,24.333333333333332,1470,"00:24:30"]
[null,24,24.388888888888889,1475,"00:24:35"]
[null,24,24.444444444444443,1480,"00:24:40"]
[null,24.5,{"$f":"(((D303-D$4)/45)*G$2)+B$4","v":24.5},1485,"00:24:45"]
[null,24.5,24.555555555555557,1490,"00:24:50"]
[null,24.5,24.611111111111111,1495,"00:24:55"]
[null,24.5,24.666666666666668,1500,"00:25:00"]
[null,24.5,24.722222222222221,1505,"00:25:05"]
[null,24.5,24.777777777777779,1510,"00:25:10"]
[null,24.5,24.833333333333332,1515,"00:25:15"]
[null,24.5,24.888888888888889,1520,"00:25:20"]
[null,24.5,24.944444444444443,1525,"00:25:25"]
[null,{"$f":"B303+G$2","v":25},25,1530,"00:25:30"]
[null,25,25.055555555555557,1535,"00:25:35"]
[null,25,25.111111111111111,1540,"00:25:40"]
[null,25,25.166666666666668,1545,"00:25:45"]
[null,25,25.222222222222221,1550,"00:25:50"]
[null,25,25.277777777777779,1555,"00:25:55"]
[null,25,25.333333333333332,1560,"00:26:00"]
[null,25,25.388888888888889,1565,"00:26:05"]
[null,25,25.444444444444443,1570,"00:26:10"]
[null,25.5,25.5,1575,"00:26:15"]
[null,25.5,25.555555555555557,1580,"00:26:20"]
[null,25.5,25.611111111111111,1585,"00:26:25"]
[null,25.5,25.666666666666668,1590,"00:26:30"]
[null,25.5,25.722222222222221,1595,"00:26:35"]
[null,25.5,25.777777777777779,1600,"00:26:40"]
[null,25.5,25.833333333333332,1605,"00:26:45"]
[null,25.5,25.888888888888889,1610,{"$f":"D328*1/(3600*24)","v":"00:26:50"}]
[null,25.5,25.944444444444443,1615,"00:26:55"]
[null,26,26,1620,"00:27:00"]
[null,26,26.055555555555557,1625,"00:27:05"]
[null,26,26.111111111111111,1630,"00:27:10"]
[null,26,26.166666666666668,1635,"00:27:15"]
[null,26,26.222222222222221,1640,"00:27:20"]
[null,26,26.277777777777779,1645,"00:27:25"]
[null,26,26.333333333333332,1650,"00:27:30"]
[null,26,26.388888888888889,1655,"00:27:35"]
[null,26,26.444444444444443,1660,"00:27:40"]
[null,26.5,26.5,1665,"00:27:45"]
[null,26.5,26.555555555555557,1670,"00:27:50"]
[null,26.5,26.611111111111111,1675,"00:27:55"]
[null,26.5,26.666666666666668,1680,"00:28:00"]
[null,26.5,26.722222222222221,1685,"00:28:05"]
[null,26.5,26.777777777777779,1690,"00:28:10"]
[null,26.5,26.833333333333332,1695,"00:28:15"]
[null,26.5,26.888888888888889,1700,"00:28:20"]
[null,26.5,26.944444444444443,1705,"00:28:25"]
[null,27,27,1710,"00:28:30"]
[null,27,27.055555555555557,1715,"00:28:35"]
[null,27,27.111111111111111,1720,"00:28:40"]
[null,27,27.166666666666668,1725,"00:28:45"]
[null,27,27.222222222222221,1730,"00:28:50"]
[null,27,27.277777777777779,1735,"00:28:55"]
[null,27,27.333333333333332,1740,"00:29:00"]
[null,27,27.388888888888889,1745,"00:29:05"]
[null,27,27.444444444444443,1750,"00:29:10"]
[null,27.5,27.5,1755,"00:29:15"]
[null,27.5,27.555555555555557,1760,"00:29:20"]
[null,27.5,27.611111111111111,1765,"00:29:25"]
[null,27.5,27.666666666666668,1770,"00:29:30"]
[null,27.5,27.722222222222221,1775,"00:29:35"]
[null,27.5,27.777777777777779,1780,"00:29:40"]
[null,27.5,27.833333333333332,1785,"00:29:45"]
[null,27.5,27.888888888888889,1790,"00:29:50"]
[null,27.5,27.944444444444443,1795,"00:29:55"]
[null,28,28,1800,"00:30:00"]
[null,28,{"$f":"(((D367-D$4)/45)*G$2)+B$4","v":28.055555555555557},1805,"00:30:05"]
[null,28,28.111111111111111,1810,"00:30:10"]
[null,28,28.166666666666668,1815,"00:30:15"]
[null,28,28.222222222222221,1820,"00:30:20"]
[null,28,28.277777777777779,1825,"00:30:25"]
[null,28,28.333333333333332,1830,"00:30:30"]
[null,28,28.388888888888889,1835,"00:30:35"]
[null,28,28.444444444444443,1840,"00:30:40"]
[null,28.5,28.5,1845,"00:30:45"]
[null,{"$f":"B367+G$2","v":28.5},28.555555555555557,1850,"00:30:50"]
[null,28.5,28.611111111111111,1855,"00:30:55"]
[null,28.5,28.666666666666668,1860,"00:31:00"]
[null,28.5,28.722222222222221,1865,"00:31:05"]
[null,28.5,28.777777777777779,1870,"00:31:10"]
[null,28.5,28.833333333333332,1875,"00:31:15"]
[null,28.5,28.888888888888889,1880,"00:31:20"]
[null,28.5,28.944444444444443,1885,"00:31:25"]
[null,29,29,1890,"00:31:30"]
[null,29,29.055555555555557,1895,"00:31:35"]
[null,29,29.111111111111111,1900,"00:31:40"]
[null,29,29.166666666666668,1905,"00:31:45"]
[null,29,29.222222222222221,1910,"00:31:50"]
[null,29,29.277777777777779,1915,"00:31:55"]
[null,29,29.333333333333332,1920,"00:32:00"]
[null,29,29.388888888888889,1925,"00:32:05"]
[null,29,29.444444444444443,1930,{"$f":"D392*1/(3600*24)","v":"00:32:10"}]
[null,29.5,29.5,1935,"00:32:15"]
[null,29.5,29.555555555555557,1940,"00:32:20"]
[null,29.5,29.611111111111111,1945,"00:32:25"]
[null,29.5,29.666666666666668,1950,"00:32:30"]
[null,29.5,29.722222222222221,1955,"00:32:35"]
[null,29.5,29.777777777777779,1960,"00:32:40"]
[null,29.5,29.833333333333332,1965,"00:32:45"]
[null,29.5,29.888888888888889,1970,"00:32:50"]
[null,29.5,29.944444444444443,1975,"00:32:55"]
[null,30,30,1980,"00:33:00"]
[null,30,30.055555555555557,1985,"00:33:05"]
[null,30,30.111111111111111,1990,"00:33:10"]
[null,30,30.166666666666668,1995,"00:33:15"]
[null,30,30.222222222222221,2000,"00:33:20"]
[null,30,30.277777777777779,2005,"00:33:25"]
[null,30,30.333333333333332,2010,"00:33:30"]

{"sheet":"HIIT mit fixer Geschwindigkeit","index":3,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[23,8,23,9],[8,1,8,2],[13,1,13,2],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[11,1,11,7],[15,1,15,2],[15,3,15,5],[9,1,9,2],[12,1,12,2],[0,0,1,7],[2,2,2,5],[5,8,5,9],[6,8,6,9],[7,8,7,9],[3,1,3,2],[5,1,5,2],[6,1,6,2],[6,4,7,4],[6,5,7,5],[7,1,7,2],[4,1,4,2]]}
["HIIT CALCULATOR mit fixer Geschwindigkeit"]
[]
[null,null," © by Rexhep Kushutani Msc (VfL Bochum) & Florian Maierhofer MSc (MFT) (nach der Idee von Martin Buchheit)"]
[null,"gewünschte Geschwindigkeit [km/h]",null,18]
[null,"Serien an HIIT Intervallen [n]",null,1]
[null,"Anzahl der Intervalle [n]",null,6,null,{"$f":"(D7+D8)*(D6*D5)/60","v":4.5}]
[null,"Dauer eines Intervalls in [sek]",null,15,"Dauer [hh:mm:ss]",{"$f":"F6/60/24","v":"00:04:30"}]
[null,"Dauer der Pause in [sek]",null,30]
[null,"Anzahl an Richtungswechsel [n]",null,2]
[null,"Winkel Richtungswechsel [45°/90°/180°]",null,180]
[]
[null,"GRUPPENTRAINING"]
[null,"Empfehlung für die",null,"Distanz HIIT [m]","Distanz Teilstrecke [m]","Zeit pro Teilstrecke [sek]","gerundet","min/km"]
[null,"gesamte Gruppe",null,{"$f":"(D$4/3.6)*(D$7-(D9*(IF(D10=180,0.7,IF(D10=90,0.4,IF(D10=45,0.5))))))","v":68},{"$f":"D14/(D9+1)","v":22.666666666666668},{"$f":"(E14/(D4/3.6))","v":4.5333333333333332},{"$f":"ROUND(F14,0)","v":5},{"$f":"TIME(0,0,1/(D4/3600))","v":"00:03:20"}]
[]
[null,"INDIVIDUALTRAINING",null,"gib jedem Athlet/ jeder Athletin eine eigene Geschwindigkeit"]
["Nr","Spieler","individuelle vorgegeben km/h","Distanz HIIT [m]","Distanz der Teilstrecken [m]","Zeit pro Teilstrecke [sek]","gerundet","min/km"]
[{"$f":"AthletInnen!A4","v":1},{"$f":"AthletInnen!B4","v":"Test1"},16,{"$f":"IF(ISNUMBER(C18),(C18/3.6)*(D$7-(D$9*(IF(D$10=180,0.7,IF(D$10=90,0.4,IF(D$10=45,0.5)))))),\"\")","v":60.444444444444443},{"$f":"IF(ISNUMBER(D18),D18/(D$9+1),\"\")","v":20.148148148148149},{"$f":"IF(ISNUMBER(C18),(E18/(C18/3.6)),\"\")","v":4.5333333333333332},{"$f":"ROUND(F18,0)","v":5},{"$f":"IF(ISNUMBER(C18),TIME(0,0,1/(C18/3600)),\"\")","v":"00:03:45"}]
[{"$f":"AthletInnen!A5","v":2},{"$f":"AthletInnen!B5","v":"Test2"},16,{"$f":"IF(ISNUMBER(C19),(C19/3.6)*(D$7-(D$9*(IF(D$10=180,0.7,IF(D$10=90,0.4,IF(D$10=45,0.5)))))),\"\")","v":60.444444444444443},{"$f":"IF(ISNUMBER(D19),D19/(D$9+1),\"\")","v":20.148148148148149},{"$f":"IF(ISNUMBER(C19),(E19/(C19/3.6)),\"\")","v":4.5333333333333332},{"$f":"ROUND(F19,0)","v":5},{"$f":"IF(ISNUMBER(C19),TIME(0,0,1/(C19/3600)),\"\")","v":"00:03:45"}]
[{"$f":"AthletInnen!A6","v":3},{"$f":"AthletInnen!B6","v":"Test3"},16,60.444444444444443,20.148148148148149,4.5333333333333332,5,"00:03:45"]
[{"$f":"AthletInnen!A7","v":4},{"$f":"AthletInnen!B7","v":"Test4"},16,60.444444444444443,20.148148148148149,4.5333333333333332,5,"00:03:45"]
[{"$f":"AthletInnen!A8","v":5},{"$f":"AthletInnen!B8","v":"Test5"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A9","v":6},{"$f":"AthletInnen!B9","v":"Test6"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A10","v":7},{"$f":"AthletInnen!B10","v":"Test7"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A11","v":8},{"$f":"AthletInnen!B11","v":"Test8"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A12","v":9},{"$f":"AthletInnen!B12","v":"Test9"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A13","v":10},{"$f":"AthletInnen!B13","v":"Test10"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A14","v":11},{"$f":"AthletInnen!B14","v":"Spieler 11"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A15","v":12},{"$f":"AthletInnen!B15","v":"Spieler 12"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A16","v":13},{"$f":"AthletInnen!B16","v":"Spieler 13"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A17","v":14},{"$f":"AthletInnen!B17","v":"Spieler 14"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A18","v":15},{"$f":"AthletInnen!B18","v":"Spieler 15"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A19","v":16},{"$f":"AthletInnen!B19","v":"Spieler 16"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A20","v":17},{"$f":"AthletInnen!B20","v":"Spieler 17"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A21","v":18},{"$f":"AthletInnen!B21","v":"Spieler 18"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A22","v":19},{"$f":"AthletInnen!B22","v":"Spieler 19"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A23","v":20},{"$f":"AthletInnen!B23","v":"Spieler 20"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A24","v":21},{"$f":"AthletInnen!B24","v":"Spieler 21"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A25","v":22},{"$f":"AthletInnen!B25","v":"Spieler 22"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A26","v":23},{"$f":"AthletInnen!B26","v":"Spieler 23"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A27","v":24},{"$f":"AthletInnen!B27","v":"Spieler 24"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A28","v":25},{"$f":"AthletInnen!B28","v":"Spieler 25"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A29","v":26},{"$f":"AthletInnen!B29","v":"Spieler 26"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A30","v":27},{"$f":"AthletInnen!B30","v":"Spieler 27"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A31","v":28},{"$f":"AthletInnen!B31","v":"Spieler 28"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A32","v":29},{"$f":"AthletInnen!B32","v":"Spieler 29"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A33","v":30},{"$f":"AthletInnen!B33","v":"Spieler 30"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A34","v":31},{"$f":"AthletInnen!B34","v":"Spieler 31"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A35","v":32},{"$f":"AthletInnen!B35","v":"Spieler 32"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A36","v":33},{"$f":"AthletInnen!B36","v":"Spieler 33"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A37","v":34},{"$f":"AthletInnen!B37","v":"Spieler 34"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A38","v":35},{"$f":"AthletInnen!B38","v":"Spieler 35"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A39","v":36},{"$f":"AthletInnen!B39","v":"Spieler 36"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A40","v":37},{"$f":"AthletInnen!B40","v":"Spieler 37"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A41","v":38},{"$f":"AthletInnen!B41","v":"Spieler 38"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A42","v":39},{"$f":"AthletInnen!B42","v":"Spieler 39"},null,"","","",{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A43","v":40},{"$f":"AthletInnen!B43","v":"Spieler 40"},null,"","","",{"$error":"#VALUE!"},""]

{"sheet":"HIIT mit % aus VIFT","index":4,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[54,6,54,7],[54,8,54,9],[55,6,55,7],[55,8,55,9],[56,6,56,7],[56,8,56,9],[51,6,51,7],[51,8,51,9],[52,6,52,7],[52,8,52,9],[53,6,53,7],[53,8,53,9],[60,1,60,5],[4,1,4,2],[45,6,45,7],[45,8,45,9],[46,6,46,7],[46,8,46,9],[47,6,47,7],[47,8,47,9],[48,6,48,7],[48,8,48,9],[43,6,43,7],[43,8,43,9],[44,6,44,7],[44,8,44,9],[58,1,58,5],[59,1,59,5],[49,6,49,7],[49,8,49,9],[50,6,50,7],[50,8,50,9],[40,6,40,7],[40,8,40,9],[41,6,41,7],[41,8,41,9],[42,6,42,7],[42,8,42,9],[37,6,37,7],[37,8,37,9],[38,6,38,7],[38,8,38,9],[39,6,39,7],[39,8,39,9],[34,6,34,7],[34,8,34,9],[35,6,35,7],[35,8,35,9],[36,6,36,7],[36,8,36,9],[31,6,31,7],[31,8,31,9],[32,6,32,7],[32,8,32,9],[33,6,33,7],[33,8,33,9],[28,6,28,7],[28,8,28,9],[29,6,29,7],[29,8,29,9],[30,6,30,7],[30,8,30,9],[25,6,25,7],[25,8,25,9],[26,6,26,7],[26,8,26,9],[27,6,27,7],[27,8,27,9],[22,6,22,7],[22,8,22,9],[23,6,23,7],[23,8,23,9],[24,6,24,7],[24,8,24,9],[19,6,19,7],[19,8,19,9],[20,6,20,7],[20,8,20,9],[21,6,21,7],[21,8,21,9],[15,1,15,2],[16,6,16,7],[16,8,16,9],[17,6,17,7],[17,8,17,9],[18,6,18,7],[18,8,18,9],[13,1,13,2],[13,6,13,7],[13,8,13,9],[6,1,6,2],[6,5,7,5],[6,6,7,7],[7,1,7,2],[8,1,8,2],[9,1,9,2],[0,0,1,11],[2,2,2,9],[5,12,5,13],[6,12,6,13],[7,12,7,13],[11,1,11,11],[3,1,3,2],[5,1,5,2],[12,1,12,2],[12,6,12,7],[12,8,12,9]]}
["HIIT CALCULATOR mit % aus VIFT"]
[]
[null,null," © by Rexhep Kushutani Msc (VfL Bochum) & Florian Maierhofer MSc (MFT) (nach der Idee von Martin Buchheit)"]
[null,"gewünschte Geschwindigkeit des VIFT [%]",null,100]
[null,"Serien an Intervallen [n]",null,2]
[null,"Anzahl der Intervalle [n]",null,2,null,null,{"$f":"(D7+D8)*(D6*D5)/60","v":4}]
[null,"Dauer eines Intervalls in [sek]",null,30,null,"Dauer [hh:mm:ss]",{"$f":"G6/60/24","v":"00:04:00"}]
[null,"Dauer der Pause in [sek]",null,30]
[null,"Anzahl an Richtungswechsel [n]",null,2]
[null,"Winkel Richtungswechsel [45°/90°/180°]",null,90]
[]
[null,"GRUPPENTRAINING"]
[null,"Empfehlung für die",null,"km/h","gerundet","Distanz gesamt [m]","Distanz der Teilstrecke [m]",null,"Zeit pro Teilstrecke [sek]",null,"gerundet","min/km"]
[null,"gesamte Gruppe ",null,{"$f":"(D$4*G59)/100","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D14,0)","v":{"$error":"#DIV/0!"}},{"$f":"(D$14/3.6)*(D$7-(D$9*(IF(D10=180,0.7,IF(D10=90,0.4,IF(D10=45,0.5))))))","v":{"$error":"#DIV/0!"}},{"$f":"F14/(D9+1)","v":{"$error":"#DIV/0!"}},null,{"$f":"(G14/(E14/3.6))","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(I14,0)","v":{"$error":"#DIV/0!"}},{"$f":"TIME(0,0,1/(D14/3600))","v":{"$error":"#DIV/0!"}}]
[]
[null,"INDIVIDUALTRAINING"]
["Nr","Spieler","Geschwindigkeit in [km/h] aus IFT","v in [km/h]","gerundet","Distanz HIIT [m]","Distanz der Teilstrecken [m]",null,"Zeit pro Teilstrecke [sek]",null,"gerundet","min/km"]
[{"$f":"AthletInnen!A4","v":1},{"$f":"AthletInnen!B4","v":"Test1"},{"$f":"'IFT 30-15 Testprotokoll'!L4","v":""},{"$f":"IF(ISNUMBER(C18),(D$4*C18)/100,\"\")","v":""},{"$f":"ROUND(D18,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(E18),(E18/3.6)*(D$7-(D$9*(IF(D$10=180,0.7,IF(D$10=90,0.4,IF(D$10=45,0.5)))))),\"\")","v":""},{"$f":"IF(ISNUMBER(F18),F18/(D$9+1),\"\")","v":""},null,{"$f":"IF(ISNUMBER(G18),(G18/(D18/3.6)),\"\")","v":""},null,{"$f":"ROUND(I18,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(D18),TIME(0,0,1/(D18/3600)),\"\")","v":""}]
[{"$f":"AthletInnen!A5","v":2},{"$f":"AthletInnen!B5","v":"Test2"},{"$f":"'IFT 30-15 Testprotokoll'!L5","v":""},{"$f":"IF(ISNUMBER(C19),(D$4*C19)/100,\"\")","v":""},{"$f":"ROUND(D19,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(E19),(E19/3.6)*(D$7-(D$9*(IF(D$10=180,0.7,IF(D$10=90,0.4,IF(D$10=45,0.5)))))),\"\")","v":""},{"$f":"IF(ISNUMBER(F19),F19/(D$9+1),\"\")","v":""},null,{"$f":"IF(ISNUMBER(G19),(G19/(D19/3.6)),\"\")","v":""},null,{"$f":"ROUND(I19,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(D19),TIME(0,0,1/(D19/3600)),\"\")","v":""}]
[{"$f":"AthletInnen!A6","v":3},{"$f":"AthletInnen!B6","v":"Test3"},{"$f":"'IFT 30-15 Testprotokoll'!L6","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A7","v":4},{"$f":"AthletInnen!B7","v":"Test4"},{"$f":"'IFT 30-15 Testprotokoll'!L7","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A8","v":5},{"$f":"AthletInnen!B8","v":"Test5"},{"$f":"'IFT 30-15 Testprotokoll'!L8","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A9","v":6},{"$f":"AthletInnen!B9","v":"Test6"},{"$f":"'IFT 30-15 Testprotokoll'!L9","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A10","v":7},{"$f":"AthletInnen!B10","v":"Test7"},{"$f":"'IFT 30-15 Testprotokoll'!L10","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A11","v":8},{"$f":"AthletInnen!B11","v":"Test8"},{"$f":"'IFT 30-15 Testprotokoll'!L11","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A12","v":9},{"$f":"AthletInnen!B12","v":"Test9"},{"$f":"'IFT 30-15 Testprotokoll'!L12","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A13","v":10},{"$f":"AthletInnen!B13","v":"Test10"},{"$f":"'IFT 30-15 Testprotokoll'!L13","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A14","v":11},{"$f":"AthletInnen!B14","v":"Spieler 11"},{"$f":"'IFT 30-15 Testprotokoll'!L14","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A15","v":12},{"$f":"AthletInnen!B15","v":"Spieler 12"},{"$f":"'IFT 30-15 Testprotokoll'!L15","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A16","v":13},{"$f":"AthletInnen!B16","v":"Spieler 13"},{"$f":"'IFT 30-15 Testprotokoll'!L16","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A17","v":14},{"$f":"AthletInnen!B17","v":"Spieler 14"},{"$f":"'IFT 30-15 Testprotokoll'!L17","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A18","v":15},{"$f":"AthletInnen!B18","v":"Spieler 15"},{"$f":"'IFT 30-15 Testprotokoll'!L18","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A19","v":16},{"$f":"AthletInnen!B19","v":"Spieler 16"},{"$f":"'IFT 30-15 Testprotokoll'!L19","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A20","v":17},{"$f":"AthletInnen!B20","v":"Spieler 17"},{"$f":"'IFT 30-15 Testprotokoll'!L20","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A21","v":18},{"$f":"AthletInnen!B21","v":"Spieler 18"},{"$f":"'IFT 30-15 Testprotokoll'!L21","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A22","v":19},{"$f":"AthletInnen!B22","v":"Spieler 19"},{"$f":"'IFT 30-15 Testprotokoll'!L22","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A23","v":20},{"$f":"AthletInnen!B23","v":"Spieler 20"},{"$f":"'IFT 30-15 Testprotokoll'!L23","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A24","v":21},{"$f":"AthletInnen!B24","v":"Spieler 21"},{"$f":"'IFT 30-15 Testprotokoll'!L24","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A25","v":22},{"$f":"AthletInnen!B25","v":"Spieler 22"},{"$f":"'IFT 30-15 Testprotokoll'!L25","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A26","v":23},{"$f":"AthletInnen!B26","v":"Spieler 23"},{"$f":"'IFT 30-15 Testprotokoll'!L26","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A27","v":24},{"$f":"AthletInnen!B27","v":"Spieler 24"},{"$f":"'IFT 30-15 Testprotokoll'!L27","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A28","v":25},{"$f":"AthletInnen!B28","v":"Spieler 25"},{"$f":"'IFT 30-15 Testprotokoll'!L28","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A29","v":26},{"$f":"AthletInnen!B29","v":"Spieler 26"},{"$f":"'IFT 30-15 Testprotokoll'!L29","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A30","v":27},{"$f":"AthletInnen!B30","v":"Spieler 27"},{"$f":"'IFT 30-15 Testprotokoll'!L30","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A31","v":28},{"$f":"AthletInnen!B31","v":"Spieler 28"},{"$f":"'IFT 30-15 Testprotokoll'!L31","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A32","v":29},{"$f":"AthletInnen!B32","v":"Spieler 29"},{"$f":"'IFT 30-15 Testprotokoll'!L32","v":""},"",{"$f":"ROUND(D46,0)","v":{"$error":"#VALUE!"}},"","",null,"",null,{"$f":"ROUND(I46,0)","v":{"$error":"#VALUE!"}},""]
[{"$f":"AthletInnen!A33","v":30},{"$f":"AthletInnen!B33","v":"Spieler 30"},{"$f":"'IFT 30-15 Testprotokoll'!L33","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A34","v":31},{"$f":"AthletInnen!B34","v":"Spieler 31"},{"$f":"'IFT 30-15 Testprotokoll'!L34","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A35","v":32},{"$f":"AthletInnen!B35","v":"Spieler 32"},{"$f":"'IFT 30-15 Testprotokoll'!L35","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A36","v":33},{"$f":"AthletInnen!B36","v":"Spieler 33"},{"$f":"'IFT 30-15 Testprotokoll'!L36","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A37","v":34},{"$f":"AthletInnen!B37","v":"Spieler 34"},{"$f":"'IFT 30-15 Testprotokoll'!L37","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A38","v":35},{"$f":"AthletInnen!B38","v":"Spieler 35"},{"$f":"'IFT 30-15 Testprotokoll'!L38","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A39","v":36},{"$f":"AthletInnen!B39","v":"Spieler 36"},{"$f":"'IFT 30-15 Testprotokoll'!L39","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A40","v":37},{"$f":"AthletInnen!B40","v":"Spieler 37"},{"$f":"'IFT 30-15 Testprotokoll'!L40","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A41","v":38},{"$f":"AthletInnen!B41","v":"Spieler 38"},{"$f":"'IFT 30-15 Testprotokoll'!L41","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A42","v":39},{"$f":"AthletInnen!B42","v":"Spieler 39"},{"$f":"'IFT 30-15 Testprotokoll'!L42","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[{"$f":"AthletInnen!A43","v":40},{"$f":"AthletInnen!B43","v":"Spieler 40"},{"$f":"'IFT 30-15 Testprotokoll'!L43","v":""},"",{"$error":"#VALUE!"},"","",null,"",null,{"$error":"#VALUE!"},""]
[]
[null,"maximale Durchschnittsgeschwindigkeit der gesamten Gruppe aus Test (km/h)",null,null,null,null,{"$f":"AVERAGE(IF(C18:C57<>0,C18:C57))","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(G59,0)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Geschwindigkeit für die gesamte Gruppe mit den gewünschten % des VIFT (km/h)",null,null,null,null,{"$f":"D14","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(G61,0)","v":{"$error":"#DIV/0!"}}]