RomRaider

Heya all,

I've attached a spreadsheet that I created to help estimate potential quartermile ET based on TRAP. It will also allow you to backwards calculate estimated whp from your trap speed, as well as ET from WHP.


Instructions:
To use this spreadsheet, all that is required is to select one of the tabs and then enter your vehicle weight (in lbs) in the very black cell of the "weight" column. Once the vehicle weight has been entered, find the line that corresponds to your vehicle's current WHP and you can then see what ET and MPH potential your car has down the quartermile. You can then also find the line of the ET you want and see what whp is required for that ET.


Calculations:
oem: ET = ((weight / chp)^(1/3)) x 5.825
fwd: ET = ((weight / chp)^(1/3)) x 6.38151246
rwd: ET = ((weight / chp)^(1/3)) x 6.31633243
wrx: ET = ((weight / chp)^(1/3)) x AverageFactor
mph: MPH = ((CHP / Weight)^(1/3) x 234
man: CHP = WHP x 1.204819277108434
auto: CHP = WHP x 1.282051282051282


Notes:
oem: refers to the standard ET calculation created by John Lawlor based on tests conducted by Patrick Hale
fwd & rwd: refers to modified calculations by web-cars.com based on the results they gathered
wrx: refers to my modified calculation based on results posted on NASIOC and REXNET Subaru enthusiast forums.
mph: is the standard Mile per hour calculation
man: is a crank horsepower calculation created for manual cars
auto: is a crank horsepower calculation created for manual cars


Your Help:
I'm still working on the calculations used, and will be updating the spreadsheet to make it more accurate as I gather more quartermile results. What I need are WRX/STi quartermile results that include accurate vehicle weight. The more accurate the vehicle weight, the more accurate the spreadhseet will be - so post your timeslip and vehicle weight if you can.


Revision 21-09-2009:

• Updated "actual-results" tab, adding a guesstimate track weight based on the vehicle model's rated curb weight plus average driver/excess weight for cars that didn't list their track weight.
• Removed "wrx-auto" column, as not enough auto data has been found
• Renamed "wrx-manual" tab to "wrx-averaged" and now dynamically link the averaged factor to the calulation for easier updates in future

Revision 10-09-2009:

• Added averaged and calulated factors to "actual-results" page, based on averaged and calculated chp and cube root column data for more accurate estimates.

Enjoy
Leslie.

Why is it password protected?

Just a habit to limit confusion of modified spreadsheets so changes made are specific to revision. It shouldn't limit the usability of the spreadsheet though.

For the next revision, I will be modifying the "actual-results" tab and unlocking that tab so users can enter results they have gathered as well.

Leslie

OK, I tried it but cannot get anything to open an .xlsx file. Per the last post the suffix relates to it being password protected but Excel won't recognize it even to advise that it is pwd protected.

Since I am not an Excel pro, what do I use to open it and or how do I un-password protect it??

Format invalid in Excel, and invalid in/out with Open Office.

I believe xlsx is a EXCEL 2007 format.

Yes, it is an EXCEL 07 format. If using Excel 03 you have to go microsoft update and download the update that allows EXCEL 03 to open 07 version spreadsheets...

That being done, and the spreadsheet opened, one still needs the password to unlock or open it so you can enter your own info...otherwise it is just a good read with reference info but no way to calculate using your own info.

Password??

Thanks-

The password is not needed to use the spreadsheet - you can enter your own data in the designated spots on each TAB. When I have time I will also be modifying the last tab so ppl can update the reference data on their own as well.


Leslie