{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Durchzugsrechner","RollwidRechner","GeschwRechner","Zeit-Interpolation"],"not_rendered":{"charts":0,"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":"Durchzugsrechner","index":0,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[53,0,53,9]],"flags":["formulas_cached_only"]}
["Berechnung der Durchzugszeit von 2000 bis 4000 Motor- /min"]
["Nur die Werte in den gelben Feldern eintragen, der Rest wird automatisch berechnet. Die Drehmomentspalte nicht vergessen!"]
[]
["Motorleistung original um 4.000 / min",null,null,null,96,"kW laut Kfz-Schein"]
["Höchstgeschw. Vmax original",null,null,null,206,"km/h laut Kfz-Schein"]
["Motorleistung bei Vmax original",null,null,null,95.5,"kW (falls nicht bekannt: kW laut Kfz-Schein)"]
["tatsächliches Fahrzeuggewicht",null,null,null,1250,"kg - Achtung: incl. Sonderausstattung, Gepäck, Insassen!!"]
["Geschwindigkeit bei 2.000 / min (Anhalt: Tacho - 5%)",null,null,null,55.7,"km/h  oder von Blatt GeschwRechner übernehmen:",{"$nulls":4},"Normreifen","min",54.368701596454365]
["Außentemperatur",null,null,null,20,"°C ","Normwert = 20°",null,null,null,55.76277086815833,"max",56.599212431180696]
["Luftdruck",null,null,null,981,"mbar","Normwert = 981 mbar (=hPa)"]
["Motor Mehrleistung (Tuning usw.)",null,null,null,0,"%"]
["Motor Minderleistung (Defekte usw.)",null,null,null,0,"%"]
["Gesamtverluste Reifen + Getriebe bei Vmax",null,null,null,17,"% (Richtwert: 17%)"]
["Verluste durch Zahnflankenreibung unter Volllast",null,null,null,4,"% (Richtwert: 4%  Bei AWD 7%)"]
["Verzögerung beim freien Ausrollen ohne Luftwid.",null,null,null,0.13,"m/sec²  / Richtwert: 0,13 oder vom RollwidRechner übernehmen:",{"$nulls":5},0.1337466548576374]
["Gegenwind",null,null,null,0,"km/h","Bei schrägem Windeinfall"]
["Rückenwind",null,null,null,0,"km/h","Anteil in Fahrtrichtung"]
["Steigung",null,null,null,0,"%","(100% entsprechen"]
["Gefälle",null,null,null,0,"%","einem Winkel von 45°)"]
["Faktor für Reifenschlupf",null,null,null,0.06,null,"linearisiert ca. 0,12 bei FWD   0,10 bei RWD und 0,06 bei AWD"]
[]
[{"$nulls":8},"reale Geschw = theoret. Geschw. x (1- (Zugkraft /Gewichtskraft) x Reifenschlupf-Faktor)"]
[null,"Motorleistung real",null,null,130.56,"PS   ",96,"kW"]
[null,"Leistungsbedarf für Luftwiderstand bei Vmax",{"$nulls":4},79.265,"kW","Schlupfkorrektur Zugkraft: Zugkraft real x (1- (Zugkraft / Gewichtskraft) x Reifenschlupf-Faktor)"]
[null,"Rollwiderstand",{"$nulls":4},170.3177039834317,"N"]
[null,"Luftwiderstand bei Vmax",null,"(100 km/h =",326.4241663288269,"N )",1385.2135922330096,"N"]
[null,"Gewichtszuschlag für rotierende Massen incl. Motor",{"$nulls":4},96.7010123138308,"kg"]
[null,"Gewichtszuschlag für rotierende Massen ohne Motor",{"$nulls":4},60.13618448793623,"kg"]
[null,"Korrekturfaktor Außentemp.",{"$nulls":4},1]
[null,"Korrekturfaktor Luftwiderstand",{"$nulls":4},1]
[null,"Korrekturfaktor Leistung",{"$nulls":4},1]
[null,"Korrekturfaktor Getriebeverluste",{"$nulls":4},0.96,null,null,"Interpolierte Zeit"]
[{"$nulls":9},"mit VAGCOM-Messung"]
["Zeit von 2000 bis 4000 /min",{"$nulls":5},6.884607200074153,"sec",null,6.625242764888783,"sec"]
["entspricht Fahrgeschwindigkeit von",null,null,null,54.61272333116825,"bis",109.77793904128683,"km/h"]
["mittlere Beschleunigung",{"$nulls":5},8.012834154071188,"km/h pro sec"]
[]
["Drehzahl","Drehmoment","Drehmoment","Zugkraft","Zugkraft","Fahr-","Geschw. für","Luftwider-","Rollwider-","Korr. Steig","Zugkraft für","Beschleu-","mittl.Beschl.","Zeitbedarf"]
[null,"original","korrigiert","theoretisch","real","Geschw.","Luftwiderst.","stand","stand","Gefälle","Beschleun.","nigung","im Intervall","für Intervall"]
["1 / min","Nm","Nm","N","N","km/h","km/h","N","N","N","N","m/sec²","m/sec²","sec"]
[2000,307,307,4155.67342146339,3989.446484604854,54.61272333116825,54.61272333116825,97.35762502778513,170.3177039834317,0,3649.121336128503,2.7096744583705146]
[2200,298,298,4033.8458618765153,3872.4920274014544,60.10905768064154,60.10905768064154,117.94027686331846,170.3177039834317,0,3516.320075816483,2.6110621761358352,2.660368317253175,0.5738902886562472]
[2400,293,293,3966.1638843282512,3807.5173289551212,65.59476717667347,65.59476717667347,140.4496604008172,170.3177039834317,0,3431.6053231757564,2.548156785951882,2.5796094810438586,0.5907127433589608]
[2600,284,284,3844.3363247413768,3690.5628717517216,71.10243470315088,71.10243470315088,165.02557246756808,170.3177039834317,0,3294.6317109460274,2.446446301607337,2.497301543779609,0.6126243144543302]
[2800,276,276,3736.045160664155,3586.6033542375885,76.61151887675378,76.61151887675378,191.58894627841875,170.3177039834317,0,3168.1060837194527,2.352494024101296,2.3994701628543167,0.6377662798331079]
[3000,269,269,3641.290392096586,3495.6387764127226,82.12095721213808,82.12095721213808,220.13561407617522,170.3177039834317,0,3052.0742329284208,2.266333956105452,2.309413990103374,0.6626787332912307]
[3200,262,262,3546.5356235290164,3404.6741985878557,87.63535381246166,87.63535381246166,250.69229859531075,170.3177039834317,0,2933.9594644842077,2.178627206526884,2.222480581316168,0.6892194452903105]
[3400,254,254,3438.2444594517947,3300.7146810737227,93.16072942800797,93.16072942800797,283.30097177381117,170.3177039834317,0,2801.114590842232,2.0799825389820596,2.1293048727544717,0.7208110869950347]
[3600,247,247,3343.4896908842256,3209.7501032488567,98.68539671999154,98.68539671999154,317.8982127640333,170.3177039834317,0,2678.7919497497433,1.989151211186204,2.0345668750841317,0.754278378421605]
[3800,238,238,3221.662131297351,3092.795646045457,104.22848042460677,104.22848042460677,354.6133782114661,170.3177039834317,0,2529.0052104917263,1.877926271211843,1.9335387411990235,0.7963354654840817]
[4000,229,229,3099.834571710476,2975.841188842057,109.77793904128683,109.77793904128683,393.3801574972651,170.3177039834317,0,2377.020854128565,1.7650694789665995,1.8214978750892212,0.846290464289243]
[]
[]
["Nm-Tabellen -> in B42 bis B55 kopieren"]
[null,"90 PS","90 PS","100 PS","110 PS","115 PS","115 PS","130 PS ","130 PS ","150 PS"]
["rpm","1Z u.ä.","ALH u.ä.","ATD u.ä.","AFN u.ä.","AJM u.ä.","ATJ u.ä.","AWX u.ä. ","ASZ u.ä. ","ARL"]
[2000,202,208,240,234,285,310,285,307,320]
[2200,198,206,240,233,276,296,277,298,315]
[2400,195,203,240,231,266,288,270,293,310]
[2600,192,198,238,229,257,269,265,284,305]
[2800,188,194,233,227,247,255,259,276,300]
[3000,184,189,225,225,239,243,255,269,293]
[3200,180,184,219,221,231,233,249,262,286]
[3400,176,179,209,215,224,225,244,254,279]
[3600,172,173,196,208,217,217,238,247,272]
[3800,165,166,187,199,209,209,233,238,268]
[4000,158,155,176,193,201,201,229,229,263]

{"sheet":"RollwidRechner","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,0,17,4]],"flags":["formulas_cached_only"]}
["automatische Übernahmen von anderen Blättern / nicht überschreiben!"]
["Höchstgeschw. Vmax original",null,null,206,"km/h laut Kfz-Schein"]
["tatsächliches Fahrzeuggewicht",null,null,1250,"kg "]
["Motorleistung bei Vmax original",null,null,95.5,"kW"]
["Luftwiderstand bei Vmax",null,null,1385.2135922330096,"N"]
["rotierende Massen",null,null,60.13618448793623,"kg  ohne Motor und Getriebeeingang"]
[]
[]
["Ausrollversuch auf der Durchzugs-Teststrecke (Intervall: ca 10 km/h) im Getriebeleerlauf"]
[]
["Nur die gelben Felder ausfüllen bzw. überschreiben!"]
["Beginn bei",null,null,50,"km/h","Anhalt: Tachoanzeige"]
["Ende bei",null,null,40,"km/h","minus 5 %"]
["Dauer",null,null,16,"sec"]
["Gegenwind",null,null,0,"km/h","Bei schrägem Windeinfall:"]
["Rückenwind",null,null,5,"km/h","Anteil in Fahrtrichtung"]
[]
["Interne Berechnungen"]
[]
["Mittlere Verzögerung",null,null,0.1736111111111111,"m/sec²"]
["Mittlerer Luftwiderstand ",null,null,52.227866612612296,"N"]
["Verzögerung wegen Luftwiderstand",null,null,0.039864456253473714,"m/sec²"]
["Verzögerung ohne Luftwid.",null,null,0.1337466548576374,"m/sec²"]

{"sheet":"GeschwRechner","index":2,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[22,0,22,4]],"flags":["formulas_cached_only"]}
["Berechnung der Fahrgeschwindigkeit"]
["Nur die  Werte in den gelben Feldern eintragen / überschreiben, der Rest wird automatisch berechnet"]
[]
["Motordrehzahl",null,"1 /min",2000]
["Ganguntersetzung 1 :",null,null,1.324]
["Achsuntersetzung 1 :",null,null,2.955]
[]
["Reifengröße","Breite","mm",195]
[null,"Querschnittsverh.",null,55]
[null,"Felgengröße","Zoll",15]
["Norm-Abrollumfang",null,"mm",1818.0615,"Radius",0.2893534745700659,"m"]
[]
["Norm-Geschw.",null,"km/h",55.76277086815833,"( für Blattt 1)"]
["Streubereich wegen",null,"min. km/h",54.368701596454365]
["Reifentoleranzen",null,"max. km/h",56.599212431180696]
[]
[]
["Massenträgheitsmomente"]
["Motor - Getriebeeingang",null,0.2,"kgm²","Anhalt: 0,2"]
["Getriebe - Achsübersetzung",null,0.004,"kgm²","Anhalt: 0,004"]
["Achsen + Räder",null,5,"kgm²  (auch nicht angetriebene Räder)",null,null,"Anhalt: 5"]
[]
["interne Berechnung von Massenträgheitsmomenten"]
["Gesamt:",null,96.7010123138308,"kg  (auf Radumfang reduziert)"]
["ohne Motor u. Getriebe:",null,60.13618448793623,"kg  (auf Radumfang reduziert)"]

{"sheet":"Zeit-Interpolation","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Interpolation der 2000 - 4000 rpm Zeit mit VAGCOM-Logdaten"]
["Eingaben nur in den gelben Feldern!"]
[null,null,"Time Stamp"]
[null,"rpm","(sec)"]
["Letzte rpm < 2000 und Time Stamp",1932,1.4]
["Erste rpm > 2000 und Time Stamp",2045,1.95]
[]
["letzte rpm < 4000 und Time Stamp",3984,8.3]
["erste rpm > 4000 und Time Stamp",4058,8.56]
[]
["Berechnungen","2000 rpm bei",1.7309734513274335]
[null,"4000 rpm bei",8.356216216216216]
["Zeit für 2000 - 4000 rpm ","sec",6.625242764888783]