{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Eingabe","Berechnung","Ergebnis"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Eingabe","index":0,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[35,1,35,6],[10,1,10,6],[1,7,1,8],[2,7,2,8],[3,1,3,6]],"flags":["formulas_cached_only"]}
[]
["Bezeichnung","90PS","100PS PD","110PS","115PS PD","130PS PD","150PS PD","Steigung in %",null,0]
["MKB Beispiel","ALH","AXR","AFN","AJM","ASZ","ARL","Gegenwind in km/h",null,0]
[null,"Gangdefinition"]
["rpm",2000,2000,2000,2000,2000,2000,"irgendeine Drehzahl in diese Zeile eingeben"]
["bei km/h",50,50,50,50,50,50,"dazugehörige Geschwindigkeit im darzustellenden Gang eingeben"]
[{"$nulls":7},"(z.B. 2000 U/min und 50km/h für den 3.Gang)."]
["Gewicht [kg]",1280,1291,1286,1307,1309,1343,"Gesamtgewicht incl. Insassen, Zubehör, Gepäck usw. eingeben"]
["Nm Abweich %",0,0,0,0,0,0,"Mehr- oder Minderleistung (= negative Zahlen) eingeben"]
[]
["Drehzahl [1/min]","Drehmoment [Nm]",{"$nulls":5},"Alternativ kann ein Gang auch durch Übersetzung und Reifenradius"]
[1000,120,130,120,120,120,120,"definiert werden. Zuerst Übersetzungen jeweils hier eintragen:",null,"Gangübersetzung:",null,1.348]
[1200,138,148,135,140,140,140,null,null,"Achsübersetzung:",null,3.158]
[1400,145,188,155,160,175,175,{"$nulls":4},11.292000771051816]
[1600,170,230,180,180,240,240,"Dann diesen Wert oben statt rpm eintragen:"]
[1800,200,240,215,240,300,300,"Und den Radius (in Meter) statt der km/h eingeben     z.b: 0,281"]
[2000,210,240,235,285,310,320]
[2200,205,240,233.37592897499997,276,300,315]
[2400,201,240,231.43359245,266,290,310,"Ein reiner Motorenvergleich ohne Getriebeeinfluß ergibt sich "]
[2600,197,238,229.40799042499998,257,283,305,"wenn man identische Geschwindigkeiten und Gewichte angibt"]
[2800,192,233,227.2991229,247,274,300,"und die jeweilige Drehzahl bei Höchstleistung."]
[3000,187,225,225.32117350000001,239,267,293]
[3200,182,219,221.3614489,231,259,286]
[3400,177,209,215.12064337499996,224,251,279]
[3600,175,196,208.9547768,217,243,272]
[3800,168,187,201.67866602499996,209,235,268]
[4000,158,176,193.36724999999998,201,229,263]
[4200,145,155,180,193,212,235]
[4400,120,140,150,182,192,215]
[4600,45,112,120,160,170,185]
[4800,0,30,40,60,95,140]
[5000]
[5200]
[]
[]
["rpm","Original-Nm-Werte"]
[1000,120,130,120,120,120,120]
[1200,138,148,135,140,140,140]
[1400,145,188,155,160,175,175]
[1600,170,230,180,180,240,240]
[1800,200,240,215,240,300,300]
[2000,210,240,235,285,310,320]
[2200,205,240,233.37592897499997,276,300,315]
[2400,201,240,231.43359245,266,290,310]
[2600,197,238,229.40799042499998,257,283,305]
[2800,192,233,227.2991229,247,274,300]
[3000,187,225,225.32117350000001,239,267,293]
[3200,182,219,221.3614489,231,259,286]
[3400,177,209,215.12064337499996,224,251,279]
[3600,175,196,208.9547768,217,243,272]
[3800,168,187,201.67866602499996,209,235,268]
[4000,158,176,193.36724999999998,201,229,263]
[4200,145,155,180,193,212,235]
[4400,120,140,150,182,192,215]
[4600,45,112,120,160,170,185]
[4800,null,30,40,60,95,140]

{"sheet":"Berechnung","index":1,"n_rows":32,"n_cols":25,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,17,0,20],[0,21,0,24],[0,1,0,4],[0,5,0,8],[0,9,0,12],[0,13,0,16]],"flags":["formulas_cached_only"]}
[null,"90PS",null,null,null,"100PS PD",null,null,null,"110PS",null,null,null,"115PS PD",null,null,null,"130PS PD",null,null,null,"150PS PD"]
[]
[null,"geschätzt","korrektur","verwendet",null,"geschätzt","korrektur","verwendet",null,"geschätzt","korrektur","verwendet",null,"geschätzt","korrektur","verwendet",null,"geschätzt","korrektur","verwendet",null,"geschätzt","korrektur","verwendet"]
["Wirkungsgrad Antriebsstrang",0.94,1,0.94,null,0.94,1,0.94,null,0.94,1,0.94,null,0.94,1,0.94,null,0.94,1,0.94,null,0.94,1,0.94]
["Fahrwiderstand (Rollwiderst.)",179.20000000000002,1,179.20000000000002,"N",180.74,1,180.74,"N",180.04000000000002,1,180.04000000000002,"N",182.98000000000002,1,182.98000000000002,"N",183.26000000000002,1,183.26000000000002,"N",188.02,1,188.02,"N"]
["Luftwiderstand bei 100 km/h",null,null,330,"N",null,null,330,"N",null,null,330,"N",null,null,330,"N",null,null,330,"N",null,null,330,"N"]
["Massenträgheitsmoment Motor",null,null,0.2,"kgm²",null,null,0.2,"kgm²",null,null,0.2,"kgm²",null,null,0.2,"kgm²",null,null,0.2,"kgm²",null,null,0.2,"kgm²"]
["Massenzuschlag Räder (rotat.)",null,null,65,"kg",null,null,65,"kg",null,null,65,"kg",null,null,65,"kg",null,null,65,"kg",null,null,65,"kg"]
[]
[null,"km/h","N","km/h /s",null,"km/h","N","km/h /s",null,"km/h","N","km/h /s",null,"km/h","N","km/h /s",null,"km/h","N","km/h /s",null,"km/h","N","km/h /s"]
[null,25,1501.1589263596575,3.8865539156830864,null,25,1641.3675868896291,4.216204976916786,null,25,1500.3189263596576,3.8676898146774836,null,25,1497.3789263596575,3.802923086401446,null,25,1497.0989263596575,3.79685477165994,null,25,1492.3389263596575,3.696248537620568]
[null,30,1747.231515313606,4.52364461097707,null,30,1887.4401758435774,4.8482952426911154,null,30,1703.8669171546148,4.392418575319006,null,30,1771.8012474196,4.499878921568622,null,30,1771.5212474196,4.492828618692229,null,30,1766.7612474196,4.3759420609829665]
[null,35,1835.7305776845865,4.752771834852237,null,35,2443.709817963464,6.2771932252923115,null,35,1976.639238214558,5.09560155152081,null,35,2044.5735684795434,5.19264421886853,null,35,2256.9165592745003,5.723859830797242,null,35,2252.1565592745005,5.5781768080106415]
[null,40,2177.7272290095148,5.638213343421029,null,40,3026.6791921893437,7.774675201075045,null,40,2318.6358895394865,5.977238743282893,null,40,2315.6958895394864,5.881218978301168,null,40,3165.907852719315,8.029190406583226,null,40,3161.1478527193153,7.829580748334778]
[null,45,2588.9482105994293,6.702879108081319,null,45,3154.402852719315,8.102760839842265,null,45,2800.7312013943865,7.220037920581267,null,45,3152.162852719315,8.005610786740862,null,45,4002.374815899144,10.15058901596427,null,45,3997.614815899144,9.901355286149274]
[null,50,2715.021871129401,7.029288304598242,null,50,3138.727852719315,8.06249623760383,null,50,3068.553522454329,7.9104602335358845,null,50,3774.3568251041866,9.58580921223541,null,50,4128.448476429115,10.470329663115638,null,50,4265.437136959086,10.564701825648022]
[null,55,2626.8225408644157,6.80093709781877,null,55,3121.402852719316,8.017993256182404,null,55,3028.207533214401,7.806451833118658,null,55,3629.4580306272123,9.217806857582353,null,55,3969.374815899144,10.066896345253825,null,55,4177.237806694101,10.346248336462217]
[null,60,2551.1480766524264,6.605013215253213,null,60,3102.4278527193146,7.9692518955779805,null,60,2981.700173142681,7.686559962332639,null,60,3468.7343700972406,8.809613775390165,null,60,3808.6511553691716,9.65927839385649,null,60,4087.3884764291142,10.123708101310497]
[null,65,2473.8236124404384,6.404817423932183,null,65,3053.4531206133215,7.843449783426037,null,65,2932.3625357616265,7.559371886366709,null,65,3320.5355756202666,8.433230345002565,null,65,3688.802092998193,9.355324208645282,null,65,3995.8891461641288,9.897081120192869]
[null,70,2380.6742821754524,6.163650490886281,null,70,2960.3037903483355,7.604175733544297,null,70,2880.1946210712363,7.424887605220864,null,70,3156.5119150902956,8.016656187075839,null,70,3538.953298521218,8.975286456750784,null,70,3902.739815899145,9.666367393109331]
[null,75,2285.8749519104663,5.918211649084903,null,75,2822.9798619243575,7.251429745932764,null,75,2828.2324532666307,7.290933721392927,null,75,3019.187986666318,7.6678918706255565,null,75,3415.804236150238,8.66296300446853,null,75,3779.5907535281635,9.36134985744238]
[null,80,2189.4256216454814,5.66850089852805,null,80,2712.3556656063747,6.967267751502773,null,80,2746.5288874548723,7.080309137672109,null,80,2880.2140582423413,7.314937016308006,null,80,3276.830307726261,8.310505452076871,null,80,3654.7916911571842,9.052245575809524]
[null,85,2091.3262913804947,5.414518239215717,null,85,2543.3820050764034,6.533222633160724,null,85,2630.841305075192,6.782076757747248,null,85,2753.764995871361,6.993791813795041,null,85,3136.206379302283,7.953863266149689,null,85,3528.3426287862035,8.739054548210751]
[null,90,2034.1015592745005,5.266361370056094,null,90,2330.23374638744,5.985705577088881,null,90,2514.565972273915,6.4823292090944316,null,90,2625.66593350038,6.668456073414806,null,90,2993.932450878306,7.5930364466869875,null,90,3400.243566415224,8.42177677464607]
[null,95,1904.352496903521,4.9304364272940235,null,95,2172.134951910466,5.579594886563113,null,95,2380.903076651521,6.137758057643726,null,95,2481.742005076404,6.302929605495446,null,95,2850.008522454329,7.228024993688762,null,95,3313.0191022032354,8.205737849041714]
[null,100,1730.4288363735495,4.4801418768682915,null,100,1984.0364253274975,5.096423444489817,null,100,2230.9148677864123,5.751101689082901,null,100,2336.168076652426,5.933212599708812,null,100,2732.784326136346,6.93072784030278,null,100,3209.96977193825,7.950503646162699]
[null,105,1512.3305776845864,3.9154777187788987,null,105,1652.5392382145578,4.244901761410868,null,105,2007.6108895394866,5.175443735918111,null,105,2188.9441482284496,5.559305056054912,null,105,2457.9866032353957,6.233801921068566,null,105,2779.2485224543298,6.883686477216618]
[null,110,1122.4839263596577,2.9061508563012963,null,110,1404.4412474196006,3.607608816242522,null,110,1546.889907949572,3.9877456961238966,null,110,1997.5456216454807,5.073206405518164,null,110,2139.014282175452,5.424842968577176,null,110,2460.2762013943866,6.093650812774591]
[null,115,22.243972384871597,0.05759043659848731,null,115,970.4199979356806,2.492732071521721,null,115,1084.5189263596576,2.7957941019139545,null,115,1648.5735684795438,4.186915130723708,null,115,1790.042229009515,4.5398004494025,null,115,1997.9052198044722,4.948443089279194]
[null,120,-654.4,-1.6942649027779597,null,120,-230.69401841008562,-0.5925871062244511,null,120,-88.24535788011417,-0.22748874647180778,null,120,192.31196317982875,0.4884185236570453,null,120,688.1522750347285,1.7452515682764973,null,120,1321.2612474196,3.272520650186697]
[null,125,-694.825,-1.7989266672871271,null,125,-696.365,-1.7887629816757709,null,125,-695.665,-1.7933629894652245,null,125,-698.605,-1.7742610344025609,null,125,-698.885,-1.772471277862686,null,125,-703.645,-1.7427990092025607]
[null,130,-736.9000000000001,-1.907860340551771,null,130,-738.44,-1.896841650842096,null,130,-737.74,-1.901828627066296,null,130,-740.6800000000001,-1.8811197500179484,null,130,-740.96,-1.8791794330185023,null,130,-745.72,-1.84701103133332]

{"sheet":"Ergebnis","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}