Barry123
11th July 2011, 00:37
Hello!
Some of you may have seen this before but I haven't really 'released' it as such since it was pretty nasty to use.... It's still pretty nasty to use but I've tried to make it less messy and a bit more user-friendly.
Latest version is here:
V1.6
http://www.megaupload.com/?d=1N2T0HNM
Changes -
Included Quaife Close Ratio and FIA Homologated MA gear ratios.
General tidy of excel sheets.
V1.51
http://www.megaupload.com/?d=VXSL4PU3
Changes -
Saved to 2000-2003 version
V1.5
http://www.megaupload.com/?d=I04IZ6I2
Changes -
more flexible in terms of rev limit (so now suitable for VTRs, Furios etc)
Corrections to minor mistakes.
V1.0
http://www.megaupload.com/?d=UDL13L75
Here's a FAQ to get you started:
What's a 'Saxo Calculator'?
It's an excel based spreadsheet that calculates a range of performance parameters like:
Top Speed
0-60
1/4 mile times
and other things
Why?
I got bored basically - I'm never going to do VMax or a full on standing start but always wondered what changes mods would do to the car, so this calculator filled the gap without getting 3 points or a bumming in jail.
How does it work?
It works by taking power figures from a rolling road, then computes using other factors such as weight, wheels size, brake size, gear ratios, even the air temperature to work out the acceleration rates and top speed for the vehicle.
How do I use it for my car?
Firstly, you need a rolling road print out of your vehicle. Enter the wheel power figures from across the entire rev range into the first sheet and the car will calculate the rest if your car is standard in every other way.
If you've changed the brakes, the weight, the gearbox, wheels dimensions, the flywheel etc then you can change those and the calculator will again do the rest.
You can fiddle with different aspects (even your weight) and see how much if affects the performance of vehicle.
Limitations?
LOTS I'm afraid, it assumes NO TYRE SLIP - so if your car is particularly powerful the calculator will lie in terms of 0-60 and 1/4 mile times but in every other respect should be okay.
It's not perfect either. But it's accurate enough for most people.
Oh yeah, it has a macro which does a 'least squares interpolation' - so if excel claims it's a security risk, it isn't. But at the same time I accept no responsibility for any data lost or anything nasty towards your pc or your family through running it.
Any problems or requests or mistakes that you've spotted then please post away and I'll try to help.
cheers,
Ads
EDIT:
List of things to add amend:
Support for various rev limits - done
Support for earlier versions of excel
add tractive force limits/tyre slip conditions (important for high horsepower saxos, otherwise acceleration value are excessive)
Some of you may have seen this before but I haven't really 'released' it as such since it was pretty nasty to use.... It's still pretty nasty to use but I've tried to make it less messy and a bit more user-friendly.
Latest version is here:
V1.6
http://www.megaupload.com/?d=1N2T0HNM
Changes -
Included Quaife Close Ratio and FIA Homologated MA gear ratios.
General tidy of excel sheets.
V1.51
http://www.megaupload.com/?d=VXSL4PU3
Changes -
Saved to 2000-2003 version
V1.5
http://www.megaupload.com/?d=I04IZ6I2
Changes -
more flexible in terms of rev limit (so now suitable for VTRs, Furios etc)
Corrections to minor mistakes.
V1.0
http://www.megaupload.com/?d=UDL13L75
Here's a FAQ to get you started:
What's a 'Saxo Calculator'?
It's an excel based spreadsheet that calculates a range of performance parameters like:
Top Speed
0-60
1/4 mile times
and other things
Why?
I got bored basically - I'm never going to do VMax or a full on standing start but always wondered what changes mods would do to the car, so this calculator filled the gap without getting 3 points or a bumming in jail.
How does it work?
It works by taking power figures from a rolling road, then computes using other factors such as weight, wheels size, brake size, gear ratios, even the air temperature to work out the acceleration rates and top speed for the vehicle.
How do I use it for my car?
Firstly, you need a rolling road print out of your vehicle. Enter the wheel power figures from across the entire rev range into the first sheet and the car will calculate the rest if your car is standard in every other way.
If you've changed the brakes, the weight, the gearbox, wheels dimensions, the flywheel etc then you can change those and the calculator will again do the rest.
You can fiddle with different aspects (even your weight) and see how much if affects the performance of vehicle.
Limitations?
LOTS I'm afraid, it assumes NO TYRE SLIP - so if your car is particularly powerful the calculator will lie in terms of 0-60 and 1/4 mile times but in every other respect should be okay.
It's not perfect either. But it's accurate enough for most people.
Oh yeah, it has a macro which does a 'least squares interpolation' - so if excel claims it's a security risk, it isn't. But at the same time I accept no responsibility for any data lost or anything nasty towards your pc or your family through running it.
Any problems or requests or mistakes that you've spotted then please post away and I'll try to help.
cheers,
Ads
EDIT:
List of things to add amend:
Support for various rev limits - done
Support for earlier versions of excel
add tractive force limits/tyre slip conditions (important for high horsepower saxos, otherwise acceleration value are excessive)