N54Tech.com - International Turbo Racing Discussion
(#1)
Old
KnifeEdge87 KnifeEdge87 is offline
Junior Member
 
Posts: 118
Join Date: Aug 2020
Car: BMW G30 520i 2019
Default A nerdy present for you all - 09-22-2020, 05:19 AM

I made this spreadsheet a while back for myself to "simulate" how mods would affect my straight line performance as well as "digitally" compare against other cars.

You plug in HP/Torque figures, the weight of the vehicle, drag coefficient, frontal area, gear ratios, and drive tire radius and out pops your straight-line performance.

Obviously it's not perfect but it's a way to connect real world performance improvements with horsepower/torque improvements.

I have set it up for my G30 520i and initialized two custom tunes which represent a conservative and aggressive Stage1 map (wheel dyno figures copied from somewhere online, use only wheel dyno figures so you don't have to guess drivetrain losses and stuff).

On an interesting sidenote, the peak piston acceleration on B48 and B58 engines is ~3400Gs (@7000rpm, though it's <3000Gs @ 6500 rpm) whereas the peak piston acceleration on the S2000 2.0L is ~4400Gs (@9000rpm) and the S2000 2.2L is 4200 Gs (@8200rpm). So don't get TOO freaked out about the undersquare design.

Meet Google Drive – One place for all your files
Reply With Quote
(#2)
Old
VipinLJ VipinLJ is offline
Junior Member
 
Posts: 108
Join Date: Feb 2020
Car: G20 330i, F25 X3, B9 SQ5, C7.5 A7
Default 09-22-2020, 08:33 AM

I tried to open it but it says unable to access document?


Current:
2020 BMW 330i xDrive
2018 Audi SQ5 Prestige
2017 Audi A7 Prestige
2016 BMW X3 xDrive28i
Reply With Quote
(#3)
Old
KnifeEdge87 KnifeEdge87 is offline
Junior Member
 
Posts: 118
Join Date: Aug 2020
Car: BMW G30 520i 2019
Default 09-22-2020, 08:34 AM

Link enabled now
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump




vBulletin Skin developed by: vBStyles.com
Copyright 2007 - 2020, N54tech.com