The Saxo Calculator - 30/08/11 V1.6

  1. #1
    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)
    4 users thanked this post: , , ,
  2. #2
    ill add it to the faqs when im not on the pad geekcheeks
  3. #3
    ta x x x
  4. #4
    i have a vtr.... fix it
  5. #5
    nice =)
  6. #6
    Update...

    Saxo Calculator V1.5
  7. #7
    Excel 2007 has a minor period trying to open it.

    What have you used to publish a .xlsm file?
  8. #8
    I use excel 2010. The 'm' is denoted as the calculator has a macro in it - it's an interpolation algorithm. It might be that 2007 is kicking off as it disables macros automatically. There should be an option box to enable the macro and the calculator should work okay!
    Ads
  9. #9
    No, it's refusing to open it entirely. It's the file format causing it problems, then it redirects me to microsoft.com to 'search for solutions' as it always does when the PC knows it's up shit creek.

    Any chance of saving it & uploading in compatibility mode or similar for those unfortunate enough to still be in the Vista-age?
  10. #10
    Yep no problem at all... I'm trying to debug the speed per gear errors but can't see what's causing that so I'm wondering if it's a compatibility problem.
  11. #11
    V1.51
    http://www.megaupload.com/?d=VXSL4PU3

    Hope that's sorted it, let me know if there are any problems.

    Ads
  12. #12
    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.
  13. #13
    Is there another way to download this?
  14. #14
    i cant open it.