GT7 Tuning Calculator - Download v3.3 all new cars added!!

[hookedonturbo]

All I need now is time to play the game! 😂

 

[Techlet]

@Techlet
Actually all the GT-R race cars (the two GT3s, the Gr.4, and the Gr.B) share the same values as other road cars. Is that intended?

This is pure coincidence the race cars and road cars have different lever ratios, weight, downforce, weight distribution.

Let me know if you discover anything else.

Thanks! Just a few lingering bugs that I've noticed with 1.91.

The 959 errors out in the Expert calc (but is fine in the Lite version):

The spring values for the GT-R GT500s is still a little strange. In the Lite version, it's loaded in the calculator by default, and shows the below values (which are the same as the other GT500s):

But if I switch to a different car and then switch back to the GT-R, it shows the road car values instead:

And in the Expert calc, it always shows the road car values as above.

 

[hookedonturbo]

Thanks! Just a few lingering bugs that I've noticed with 1.91.

The 959 errors out in the Expert calc (but is fine in the Lite version):
View attachment 1254020

The spring values for the GT-R GT500s is still a little strange. In the Lite version, it's loaded in the calculator by default, and shows the below values (which are the same as the other GT500s):
View attachment 1254021

But if I switch to a different car and then switch back to the GT-R, it shows the road car values instead:
View attachment 1254022

What???
This is rediculous, I checked it twice! 🤯

Only thing I can think of is that the vlookup is picking up a different value. It can be fickle that function. I’ll see if I can use index match or something instead. Apologies once again,

 

[Techlet]

What???
This is rediculous, I checked it twice! 🤯

Only thing I can think of is that the vlookup is picking up a different value. It can be fickle that function. I’ll see if I can use index match or something instead. Apologies once again,

Isn't Excel just wonderful.

 

[bapexxx]

Hi hookedonturbo thank you for your hard work!
However I am having problem with setting the dyno plot
After I plat the graph the gear ratio keeps throwing error

 

[hookedonturbo]

Hi hookedonturbo thank you for your hard work!
However I am having problem with setting the dyno plot
After I plat the graph the gear ratio keeps throwing error
View attachment 1254182
View attachment 1254183

Hi bapexxx,

Your lowest speed is out of range for the max torque of 1st gear.

Try lowering the RPM at max power and using a higher mph for 1st gear, also why are you using user input final drive setting?

 

[hookedonturbo]

@bapexxx

What value did you put in the RPM max power?

 

[bapexxx]

Hi bapexxx,

Your lowest speed is out of range for the max torque of 1st gear.

Try lowering the RPM at max power and using a higher mph for 1st gear, also why are you using user input final drive setting?

Hi,

Still the same. Increased to 55mph but still throw error after I pressed the calculate button.
What do you mean lowering RPM at max power? Whenever I press the calculate button it was replaced by "#value!".

Thanks,

 

[hookedonturbo]

Hi,

Still the same. Increased to 55mph but still throw error after I pressed the calculate button.
What do you mean lowering RPM at max power? Whenever I press the calculate button it was replaced by "#value!".

Thanks,

Okay bear with I’ll find a solution, what’s the RPM at max power?

 

[bapexxx]

Okay bear with I’ll find a solution, what’s the RPM at max power?

9200

 

[hookedonturbo]

Right okay, because this car has max power and wheel torque right up to max revs there is no crossover of Tractive force from one gear to the next, litterally the only need to change gear is running out of revs! I need to make a new equation for this.

 

[tharealquest]

Good Morning, All.
I just purchased the Tuning Calculator and I'm having issues where I can only select a vehicle, change lbs to kg. I'm unable to input any of my vehicles values to formulate a calculation. I'm on a PC using the spreadsheet from V1.9. Can anyone one help me figure out the correct way to solve my issue?

Thank You

 

[hookedonturbo]

Good Morning, All.
I just purchased the Tuning Calculator and I'm having issues where I can only select a vehicle, change lbs to kg. I'm unable to input any of my vehicles values to formulate a calculation. I'm on a PC using the spreadsheet from V1.9. Can anyone one help me figure out the correct way to solve my issue?

Thank You

Sorry, what value are you unable to input?

 

[hookedonturbo]

9200
View attachment 1254191

If you just use the lite version for this car for the minute and rev it out to redline…

I’ll make a fix for this.

 

[tharealquest]

Sorry, what value are you unable to input?

Example: I choose 98 Civic and i want to put my car's weight(2041 lbs) and power(499hp)etc in, I'm unable to change your default value to mine. Same with gearing Example: its shows 6 gears by default but the Civic has 5 gears. The only thing I'm able to do is a pick a car from the drop menu and use the the default values for each car.

Thank you for any help.

 

[hookedonturbo]

9200
View attachment 1254191

Use these ratios see if they any good for now…

 

[JoelS]

Right okay, because this car has max power and wheel torque right up to max revs there is no crossover of Tractive force from one gear to the next, litterally the only need to change gear is running out of revs! I need to make a new equation for this.

I think I ran into the same problem.

Runtime error 1004: reference invalid.

EDIT: Ok maybe it is not the same problem...

 

[hookedonturbo]

It think it probably is, the Tractive force curves do not overlap

 

[hookedonturbo]

I’ll input another formula: if no match of Tractive force/speed then max revs until shift….

 

[hookedonturbo]

Example: I choose 98 Civic and i want to put my car's weight(2041 lbs) and power(499hp)etc in, I'm unable to change your default value to mine. Same with gearing Example: its shows 6 gears by default but the Civic has 5 gears. The only thing I'm able to do is a pick a car from the drop menu and use the the default values for each car.

Thank you for any help.

This is very odd, I’ve not come across this issue before or even know what would cause this, what version of excel are you using?

 

[tharealquest]

This is very odd, I’ve not come across this issue before or even know what would cause this, what version of excel are you using?

The standard one that comes with Windows 11. I’m wondering if it’s because I never used it before. Each time I open it in excel they ask me to buy/activate the premium version and some features are disabled. Probably why I can’t click on any of the edit buttons to add my values.

 

[Abarth_71]

Interested in buying this but I'm a Mac user. I don't have Excel, or want to buy it just to use this, so has anyone tried to run it in Numbers on Mac?

 

[hookedonturbo]

If you want to use the dyno plotter, it will only work in excel due to macros and vba. The lite version will work on excel online or mobile free edition.

 

[Abarth_71]

If you want to use the dyno plotter, it will only work in excel due to macros and vba. The lite version will work on excel online or mobile free edition.

Ok thanks for the quick reply. I do run windows on my Mac via bootcamp to update my Fanatec stuff so I'll have a look and see if I can "obtain" Excel from somewhere 🤣.

 

[hookedonturbo]

Ok thanks for the quick reply. I do run windows on my Mac via bootcamp to update my Fanatec stuff so I'll have a look and see if I can "obtain" Excel from somewhere 🤣.

Excel can run on Mac as well, I am a Mac user…

 

[Abarth_71]

Excel can run on Mac as well, I am a Mac user…

I know, just don't want to pay for it 😂.

Edit:Managed to acquire Office for Mac so I'm good to go.

 

[hookedonturbo]

I know, just don't want to pay for it 😂.

Edit:Managed to acquire Office for Mac so I'm good to go.

Don’t know what to offer you I’m afraid, until we get to the point when the app is available…

 

[Abarth_71]

Don’t know what to offer you I’m afraid, until we get to the point when the app is available…

It's all good now, I've acquired Office for the Mac without it costing me anything.

 

[hookedonturbo]

Uploading V1.92 now, bug fixes done.
Gear ratios/dyno plot fixed for car with max power at max revs done.

 

[hookedonturbo]

Let me know your diagnosis @Techlet 😂