{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cockpit","TCX Commuter","Parameter","CdA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Cockpit","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Bike",{"$f":"Parameter!C2","v":"Create\nnormal"}]

{"sheet":"TCX Commuter","index":1,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"A1","v":0},"Parameter verformelt","Parameter verformelt","Watt gleitender Durchschnitt","Watt Berechnung","P(rolling resistance)","P(wind)","P(gravity)","P(acceleration)"]
[null,{"$f":"A2","v":0}]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0,{"$f":"RIGHT(LEFT(A15,31),8)","v":""}]
[null,0]
[null,0,{"$f":"RIGHT(LEFT(A17,34),10)","v":""}]
[null,0,{"$f":"RIGHT(LEFT(A18,34),9)","v":""}]
[null,0]
[null,0,{"$f":"RIGHT(LEFT(A20,26),4)","v":""},null,{"$f":"IF(AND(E23>0,D23<=5),D23/Parameter!$G$11*60,IF(AND(E23>0,D23>5),D23/Parameter!$G$12*60,0))","v":0}]
[null,0]
[null,0]
[null,{"$f":"A23","v":0},{"$f":"IF(LEN(A23)=26,RIGHT(LEFT(A23,18),3),RIGHT(LEFT(A23,19),4))","v":""},null,{"$f":"F23","v":0},{"$f":"IF(SUM(G23:J23)<=0,0,SUM(G23:J23))","v":0}]
[null,{"$f":"A24","v":0}]
[null,{"$f":"A25","v":0}]
[null,0]
[null,0]
[null,0,{"$f":"RIGHT(LEFT(A28,31),8)","v":""},null,null,{"$f":"HOUR(D28)*60*60+MINUTE(D28)*60+SECOND(D28)-(HOUR(D15)*60*60+MINUTE(D15)*60+SECOND(D15))","v":0}]
[null,0]
[null,0,{"$f":"RIGHT(LEFT(A30,34),10)","v":""}]
[null,0,{"$f":"RIGHT(LEFT(A31,34),9)","v":""},null,null,{"$f":"6371.1*((2*ASIN(SQRT((SIN((RADIANS(D17)-RADIANS(D30))/2)^2)+COS(RADIANS(D17))*COS(RADIANS(D30))*(SIN((RADIANS(D18)-RADIANS(D31))/2)^2)))))*1000","v":0}]
[null,0]
[null,0,{"$f":"RIGHT(LEFT(A33,26),4)","v":""}]
[null,0]
[null,0]
[null,{"$f":"A36","v":0},{"$f":"IF(LEN(A36)=26,RIGHT(LEFT(A36,18),3),RIGHT(LEFT(A36,19),4))","v":""},null,{"$f":"AVERAGE(F23*1,F36*1,F49*1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(SUM(G36:J36)<=0,0,SUM(G36:J36))","v":{"$error":"#DIV/0!"}},{"$f":"Parameter!$C$6*(Parameter!$C$3+Parameter!$C$4)*Parameter!$C$8*D36","v":0},{"$f":"0.5*Parameter!$C$7*D36^3*Parameter!$C$9","v":0},{"$f":"IFERROR((Parameter!$C$3+Parameter!$C$4)*Parameter!$C$6*(D33-D20)/F31*D36,0)","v":0},{"$f":"(Parameter!$C$3+Parameter!$C$4)*(D36-D23)/F28","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"A37","v":0}]
[null,{"$f":"A38","v":0}]
[null,0]

{"sheet":"Parameter","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,"Bike","Treckingrad","Treckingrad","Treckingrad","Rennrad","Rennrad","MTB"]
[null,null,{"$f":"G2","v":"Create\nnormal"},"Commuter \nOberlenker","Commuter \nBremsgriffe","Commuter\nUnterlenker","Create\nnormal","Create\nTT","MTB"]
["Gewicht Fahrrad","kg",{"$f":"G3","v":13.8},17.7,17.7,17.7,13.8,13.8]
["Gewicht Fahrer","kg",74.099999999999994,73.099999999999994,73.099999999999994,73.099999999999994,74.099999999999994,74.099999999999994]
["Größe Fahrer","m",1.86,1.86,1.86,1.86,1.86,1.86,1.86]
["Gravitationskonstante","m/s2",9.8066999999999993,9.8066999999999993,9.8066999999999993,9.8066999999999993,9.8066999999999993,9.8066999999999993,9.8066999999999993]
["Luftdichte ρ ","kg/m³",1.226,1.226,1.226,1.226,1.226,1.226,1.226]
["Rollwiderstand Crr ",null,3.3E-3,4.0000000000000001E-3,4.0000000000000001E-3,4.0000000000000001E-3,3.3E-3,3.3E-3,4.5999999999999999E-3]
["Luftwiderstand Cd * A",null,0.27706195659613753,0.38188692462103591,0.32585358187654229,0.28011837581338028,0.27706195659613753,0.2467570124565848,0.57110000000000005]
[]
["Tempo bis 18 km/h",null,null,null,null,null,4.25]
["Tempo größer 18 km/h",null,null,null,null,null,5.79]

{"sheet":"CdA","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Create normal","Create TT","Commuter OL","Commuter BG","Commuter UL"]
["Größe",1.86,1.86,1.86,1.86,1.86]
["Gewicht",74,74,74,74,74]
["Neigung Öberkörper",29,9,46,38,30]
["Neigung Sitzrohr",71,71,74,74,74]
["Schulterbreite",0.4,0.4,0.4,0.4,0.4]
[]
["A1",{"$f":"0.0293*B2^0.725*B3^0.425+0.0604","v":0.34661209710343599},{"$f":"0.0293*C2^0.725*C3^0.425+0.0604","v":0.34661209710343599},{"$f":"0.0293*D2^0.725*D3^0.425+0.0604","v":0.34661209710343599},0.34661209710343599,0.34661209710343599]
["A2",{"$f":"0.00215*B2+0.18964*B3-0.07861","v":13.958749000000001},{"$f":"0.00215*C2+0.18964*C3-0.07861","v":13.958749000000001},{"$f":"0.00215*D2+0.18964*D3-0.07861","v":13.958749000000001},13.958749000000001,13.958749000000001]
["A3",{"$f":"0.00433*B5^0.172*B4^0.096*B3^0.762","v":0.33086369122276471},{"$f":"0.00433*C5^0.172*C4^0.096*C3^0.762","v":0.29571011738681025},{"$f":"0.00433*D5^0.172*D4^0.096*D3^0.762","v":0.34831732339533567},0.34198696093024145,0.33431353751210119]
["A4",{"$f":"0.00653*B5^0.183*B4^0.099*B3^0.493*B2^1.163","v":0.3415432076461804},{"$f":"0.00653*C5^0.183*C4^0.099*C3^0.493*C2^1.163","v":0.30418532583475366},{"$f":"0.00653*D5^0.183*D4^0.099*D3^0.493*D2^1.163","v":0.36022214110439443},0.35347276245860787,0.34529666369549766]
["A5",{"$f":"0.0148*B5^0.184*B4^0.099*B3^0.408*B2^0.925*B6^0.426","v":0.3148431324956108},{"$f":"0.0148*C5^0.184*C4^0.099*C3^0.408*C2^0.925*C6^0.426","v":0.28040569597339182},{"$f":"0.0148*D5^0.184*D4^0.099*D3^0.408*D2^0.925*D6^0.426","v":0.33207558662698777},0.32585358187654229,0.31831633615156851]
[]
["CD",0.88,0.88,1.1499999999999999,1,0.88]
[]
["CD*A",{"$f":"B14*B12","v":0.27706195659613753},{"$f":"C14*C12","v":0.2467570124565848},{"$f":"D14*D12","v":0.38188692462103591},0.32585358187654229,0.28011837581338028]