I have been working on this for some time and at the same time working with various community members including feuerdog.

And now I release it to you guys. Have fun and feedback will be appreciated. Thanks.

FEATURES

• Supports both imperial and metric units
• Print area enabled so you can print out your setup and make notes
• FM3 suspension dynamics by Feuerdog
• Tire pressure settings based on curb weight/load on tire
• An all new optional automatic transmission sheet
• Integrated transmission calc with calculated final drive ratio and individual gear ratios based on The vehicles power to weight ratio and tire diameter to make sure it is tuned for ideal acceleration
• NEW! Option of selecting between 4 – 6 gear transmissions
• NEW! Automatic gear spreader formula that actually works!
• NEW! The ability to tune the last gear to match drag limited top speed to gear limited top speed (vehicle’s redline on overdrive)
• Automatically calculates optimal shift points.
• Suspension input modifiers for tweaking the strength and front bias for individual suspension parts that will get you one step closer to that perfect tune.
• Full car list with performance figures and prices
• Full rim list with weight loss percentages
• Stiff suspension values for the ADVANCED tab for a stiffer suspension and mostly likely faster lap times
• Aerodynamics sheet still under construction
• NEW! Tire dynamics sheet for tuning tire pressures for grip where you need it
• NEW! Aero front bias modifier

UPCOMING

• Upgrade shop sheet to keep track of what class and PI your vehicle is in as well as the upgrades it has.

SCREENSHOTS

REQUIREMENTS 

• Excel 97-2003
• Excel 2007
• Analysis Toolpak enabled
  Excel 97-2003: Tools>add-ins>enable analysis toolpak
  Excel 2007: office button>excel options>add-ins>manage: excel add-ins GO> check analysis toolpak>press OK.

INSTRUCTIONS

To tune any car make sure you are in it and go to:

1. Main Menu>cars>my cars
2. press y to toggle.
3. input that data into FM3 Main (ie; power, torque, weight, front) 
4. press x (car list)
5. Hold the LB until you reach the data needed (ex: power rpm, torque rpm, redline rpm, front and rear tire sizes)
6. Enter required data into FM3 Main
7. If aero parts are installed, write the default values into advanced>aero>default down force.
8. If using the stiff suspension values, make sure you recheck these numbers for any change you make in weight and down force.
9. Follow the comments inside the modifier cells for guidance to that tweak you are looking for.
10. anything else, ask here or figure it out amongst yourselves.

DOWNLOAD NOW (Excel 97-2003)(Excel 2007)

F.A.Q.

• can i message you over xbox live?
  no. please no more blind friend requests just post here. someone will help you i'm sure.
• will you answer a question that has already been answered?
  no. any questions that need a repeated answer will be ignored.
• what is wrong with the aerodynamic sheet? i want to use it but i can't. please help me.
  the aerodynamics sheet is under construction and will most likely be deleted. stay tuned if something happens.
• i can't believe this isn't error free. i'm getting #NAME? errors all over the place. come on i really want to use this. what gives?
  what gives is that #NAME? appears when excel 97-2003 can't read excel 2007 new formula statements.

  in this case your spreadsheet gets an error when it encounters the MROUND function.

  if i find out you don't have the analysis toolpak add-in enabled like i said countless of times in this thread, i'm gonna be a little dissapointed.

  goto this link for more details:
  http://office.microsoft.com/en-us/excel/HP052091851033.aspx

---

NEW! Suspension + Transmission Tuning Calc v2.1 MARCH2010 RELEASED

downloaded and saved to my Flash drive... will take it home and test it tonight and let you know the outcome.

---

TiE2000

I have been playing around with FD's new release,  and have been pretty happy with the results...  I will give this one a go and try to provide some feedback.  (if wanted.  lol)

---

GT same as my username

I just tried it with a no aero C425 Genesis and it made the car much more balanced.

I get an error every time I open the sheet saying "The reference is not valid. References for titles,values or sizes must be a single cell, row or column." It seems to be affecting the aero sheet only, with drag force, downforce and theoretical top speed and overdrive as #Ref! errors.

 

Edit: I can't access the Google Doc version, I do not have permission. I am going to try the gear and aero tuning on a different car now.

ajanu:

I just tried it with a no aero C425 Genesis and it made the car much more balanced.

I get an error every time I open the sheet saying "The reference is not valid. References for titles,values or sizes must be a single cell, row or column." It seems to be affecting the aero sheet only, with drag force, downforce and theoretical top speed and overdrive as #Ref! errors.

 

Edit: I can't access the Google Doc version, I do not have permission. I am going to try the gear and aero tuning on a different car now.

ignore it. the aero sheet is still under contruction.

---

NEW! Suspension + Transmission Tuning Calc v2.1 MARCH2010 RELEASED

At first glimpse I thought it was excellent, sadly, I soon realised that, like the other tuning calcs, I still had to drive the car..!!

Seriously.... It is great.. still tampering with it.

Looks clean, and organized. Will test it once I get home :)

Thanks for your hard work! 

---

Thanks bud, will give it a shot and give some feedback.

---

If a cluttered desk signs a cluttered mind, of what, then, is an empty desk a sign - Albert Einstein
http://www.simpleperfectionracing.com/

Just had a quick look - will have a proper test tomorrow, but I've only just noticed it and it's getting late

 

Only thing that stands out are that some of the rim weights look to be out. A few of the rims show up with negative results, and some of the other values look like they might not be in the right order. Stupidly I forgot to make a note of the ones I noticed when I was checking for different wheels a minute ago, but I'll have another look through it tomorrow when I'm a bit more awake.

 

 Good effort though - looks very impressive so far!

I don't know if it is because I have a mac, but it says the format is wrong.

---

Clutch
100% FREE
Rear-wheel Drive Specialist

greghauck:

I don't know if it is because I have a mac, but it says the format is wrong.

what version of excel are you using?

i haven't touched a mac since i was editing films not much for word processing.

i'll update a link for a 2007 workbook.

---

NEW! Suspension + Transmission Tuning Calc v2.1 MARCH2010 RELEASED

great work on this, its very in depth. I will try this tomorrow when I'm not tired 

---

Sig made by J Moelhave |

First of all thanks, this is helping me learn a little bit about tuning and getting my cars setup properly.

 I don't really know anything about tuning but I think I have filled in all the values correctly but I am getting 0.0 for lb/in on both spring rates, am I missing something? and I am not sure how to use the aero section to get downforce. i'm working on a veyron that I use for cat & mouse on nuremberg, it is R3 798 with all upgrades except weight reduction. this is quite hard to find a premade tune for so I am hoping to use the help of you calculator.

thank you, and everything else has worked perfectly

xx j easy xx:

I don't really know anything about tuning but I think I have filled in all the values correctly but I am getting 0.0 for lb/in on both spring rates, am I missing something?

you probably are.

do me a favor and goto tools>add-ins> enable analysis toolpak

if that doesn't work, i might need a screenshot.

---

NEW! Suspension + Transmission Tuning Calc v2.1 MARCH2010 RELEASED

looks good. ill give it a try in the next few days, and let you know how it goes.

---

i ♥ haters.

I have the new mac book pro if that helps.

greghauck:

I have the new mac book pro if that helps.

i'm afraid it doesn't.

at least tell me you have this

http://www.apple.com/iwork/numbers/

if you don't have any software capable of opening spreadsheets then oh well i'm sorry dude. i'm only one man.

---

NEW! Suspension + Transmission Tuning Calc v2.1 MARCH2010 RELEASED

I also tried the newer version you put up and it didn't work once again. As I said in my other post i have the new macbook pro. Thanks

Slave Munky:

xx j easy xx:

I don't really know anything about tuning but I think I have filled in all the values correctly but I am getting 0.0 for lb/in on both spring rates, am I missing something?

you probably are.

do me a favor and goto tools>add-ins> enable analysis toolpak

if that doesn't work, i might need a screenshot.

I was using open office, I tried using google docs and that works fine and gives me the spring data, so i'll just use that from now on, thanks