This file is capable of exporting the entire physics parameter files for the Formula ISI 2012 car (minus tyres). To be more specific, these files correspond to the HDV, engine.ini, gear.ini (optional), damage.ini and ultra chassis.ini. There is also a headphysics.ini output, but this is purely graphical (cockpit camera) and does not alter the vehicle physics.
It requires LibreOffice.org 4.2.7+ (recommend 4.3.7) available from here.
Once you have that installed, you can open the file. The spreadsheet does make use of some macro's (although most of them are non-essential and you can use the spreadsheet without them), to make use of them, you will have to allow them in the security settings.
Once you open it, you will be greeted with a large bunch of tabs, and on the first sheet, (the "Working" sheet), you will see some basic usage instructions. To summarise, the orange tabs are the 'export tabs'. You still have to manually copy these (ctrl+a, ctrl+c and paste into a text editing software).
To create a new car, is always going to be a bit pain staking. I've attempted to calculate as many things as possible, automatically, and the spreadsheet helps to visualise certain items, work is still on-going in this area too. The spreadsheet still requires a good understanding of vehicle dynamics. While it can help you get a car more accurate, it requires good data and patience.
The general process is to go sheet by sheet, and replace data in white bordered cells with your own numbers. It’s a slow process, but completing each sheet with known quantities is a good process.
rF2 Physics Calculator V0.33 FISI 2012 PUBLIC.ods
A couple more things to note:
- If your locale uses “,” as your decimal symbol, you will need to change this in the LibreOffice settings. View comment to see example screenshot, uncheck the “Decimal separator key” in the Language settings.
- Some cells have detailed comments, be sure to read those (view by mousing over the little red squares).
- This spreadsheet is optimised for a resolution of 2560x1440, more is better.