Discussion in 'Car Modding' started by thoraxe, Jun 7, 2018.

1. ### thoraxeRegistered

Joined:
Dec 25, 2016
Messages:
128
10
This thread originally started as "are there example spreadsheets other than the FISI?" and it has turned into a detailed FAQ on how to use the physics calculator spreadsheet.

https://docs.studio-397.com/developers-guide/cars/car-physics/physics-calculation-tool

Q: My car has no real aero (no diffuser, no front or rear wing). What do I do?
A: Put in comment or Delete the entry in the HDV (the blocks FRONTWING, REARWING, DIFFUSER, FENDERS if any).

Q: The cartesian coordinates are in reference to what? As an example, when I set X to 0 for the front wheel upper front arm, I see where it ends up in the diagram, but what actually is "0"?
A: With help from Devin on Garage discord (https://discord.gg/q9FVQc3):

So my interpretation/paraphrasing:
• Z is the front-back axis of the car (along center line from absolute center)
• Y is the up-down axis of the car (height above ground)
• X is the left-right axis of the car (distance from center line)
• all in reference to the absolute center of the vehicle
Q: On the Susp tab, what is "pushrod"? In my particular vehicle case, I have a standard coilover shock and spring where the upper is mounted to the chassis and the lower is mounted to the lower control arm. Are these the "pushrod" measurements?
A:
Q: What is the best way to measure a real car to determine the cartesian coordinates (X,Y,Z) of the various suspension pickup points and arms? My best guess right now is to quite literally put the car on a giant piece of graph paper and determine the vehicle absolute center (X=0,Z=0) and then use a plumb bob to measure Y for each point in space. Is there a better/easier way?
A:

Q: On the "Spring" tab, what if I don't want to use N/m for the spring values?

A: Starting on Row 65 there are some spring configurations.
• You can change the unit to kgf/mm
• You can change the min/max values
• You can change the steps
The values in the dropdown (B34/B10) don't end up getting updated to the stepped values, though. They're still showing the calculated SI N/m values, which is not fun. But you can do the math to figure out what you should choose in the dropdown.

Last edited: Jun 16, 2018
patchedupdemon likes this.
2. ### JokeriRegistered

Joined:
May 17, 2014
Messages:
196
31
No shortcut to happiness mate, you need to have realworld measurements/data. Sheets are all the same just with different numbers.

3. ### thoraxeRegistered

Joined:
Dec 25, 2016
Messages:
128
10
I'm mostly trying to figure out what to do with a wingless/undertray-less car on these sheets.

It definitely would be awesome if there was a "simplified" sheet where you could enter much more basic information for getting started.

But, I'll just have to plug away at it.

Joined:
Dec 25, 2016
Messages:
128
10

5. ### thoraxeRegistered

Joined:
Dec 25, 2016
Messages:
128
10
OK, after digging in a bit, the fact that the example spreadsheet is for a Formula car and I'm doing a tintop / standard sedan means there's a lot of quite ridiculous values. Understanding how to back these out for "my" car is going to be quite difficult.

Joined:
Dec 25, 2016
Messages:
128
10
7. ### thoraxeRegistered

Joined:
Dec 25, 2016
Messages:
128
10
Working on my JZZ30 Toyota Soarer/SC300 physics spreadsheet:
https://www.dropbox.com/s/728725dhzybz1yk/rF2-Physics-Calculator-jzz30-V0.33-v0.1-180608.ods?dl=0

The car has no undertrays/diffusers and currently has no wings.

How do I "disable" those features of the spreadsheet? Or do I just delete their entries out of the HDV file and mostly leave whatever?

There are undertray properties on the "General" tab and then five or six sections on the "Aero" tab, some of which are wings/diffusers/fenders.

Again, a regular sedan example spreadsheet would be immensely useful here.

Last edited: Jun 9, 2018

Joined:
Oct 5, 2010
Messages:
1,829
611
Put in comment or Delete the entry in the HDV (the blocks FRONTWING, REARWING, DIFFUSER, FENDERS if any).

9. ### thoraxeRegistered

Joined:
Dec 25, 2016
Messages:
128
10
That's awesome, thanks!

I sent these questions to @Michael Borda but I'll also put them here:

* The cartesian coordinates are in reference to what? As an example, when I set X to 0 for the front wheel upper front arm, I see where it ends up in the diagram, but what actually is "0"? Or are the 0s essentially arbitrary? It's easy for me to measure the arm lengths, but not so easy to figure out how to relate them to these coordinates.

* What is "pushrod"? In my particular vehicle case, I have a standard coilover shock and spring where the upper is mounted to the chassis and the lower is mounted to the lower control arm. Are these the "pushrod" measurements?

10. ### thoraxeRegistered

Joined:
Dec 25, 2016
Messages:
128
10
Answering my own question about the coordinates with help from Devin on Garage discord (https://discord.gg/q9FVQc3):

So my interpretation/paraphrasing:
• Z is the front-back axis of the car (along center line from absolute center)
• Y is the up-down axis of the car (height above ground)
• X is the left-right axis of the car (distance from center line)
• all in reference to the absolute center of the vehicle
Hopefully this helps others.

11. ### thoraxeRegistered

Joined:
Dec 25, 2016
Messages:
128
10
Current/remaining questions:

* On the Susp tab, what is "pushrod"? In my particular vehicle case, I have a standard coilover shock and spring where the upper is mounted to the chassis and the lower is mounted to the lower control arm. Are these the "pushrod" measurements?

* What is the best way to measure a real car to determine the cartesian coordinates (X,Y,Z) of the various suspension pickup points and arms? My best guess right now is to quite literally put the car on a giant piece of graph paper and determine the vehicle absolute center (X=0,Z=0) and then use a plumb bob to measure Y for each point in space. Is there a better/easier way?

12. ### Michael BordaCar Team

Joined:
Oct 21, 2011
Messages:
187
143
Yes, pushrod is just the damper/spring connection (the name is a little misleading, I'll admit).

If the car is symmetrical (which is generally the case), it's often easiest to measure the precise distance between 2 co-ordinates. Once you have a point, you can always measure relative to that point. The 'Z' co-ordinates, don't necessarily have to be from 0 either, the most important is to make sure your points are correct relative to the wheel centre.

13. ### thoraxeRegistered

Joined:
Dec 25, 2016
Messages:
128
10
The recommendation in The Garage discord was to actually just measure everything from the spindle/hub, and then put that into Blender. Then, knowing the wheel base and the track I can actually just do simple math to calculate the distance from center. That *should* work.

If I can borrow some hub/wheel stands I can keep the car at ride height but with the wheels off, which means I can then measure the suspension more easily. Thanks for the suggestions.

14. ### thoraxeRegistered

Joined:
Dec 25, 2016
Messages:
128
10
Added some information on spring rates and updated with some answers from Michael.

Joined:
Dec 28, 2018
Messages:
22