Marius Golombeck 5000 13 years 141 days ago (edited 13 years 20 days ago)
I have created a simple excel sheet to help you calculate fuel & tyre usage and come up with the best strategy. It is currently empty, so you have to fill the tyre values by experience.
It might take a while to come up with the perfect values so i attached a preview screen with my values for Malaysia as example.
Took me a while to find this thread, but it should be seen, and would be really useful for a lot of new users
Not sure if you mind or not but i have built on this/updated [V1.3 i'm on now] & added a bit for merchandise, training, driver comparison & car design i'll remove all my data from it and upload it if any1 is interested.
Left most of the information for australia in it so you have a rough idea of how it works, although the screenshot is actually from a different version{ooooops}
Removed the calculations from below the drivers stats [although once u figure out what trains what it should be easy enough for you to add back and end up with similar to below... and before any1 gets any idea's on copying me, i'm pretty sure 2 or 3 of the 4 drivers are the same person [at different points in there career/estimated development/atrophy]
Removed design % data [work it out on your own and then add it back in]
Removed data from all other tracks [input your own fuel/tyre strategy data]
Removed my actual merchandise info [although the calculation still works]
Any questions on how it works, i suppose you should post in here
Anything you want added to it, reply here or give me a pm [any1 with a genuinly amazing idea will win a copy of the spreadsheet without everything removed lol]
Thanks to Marius for the original spreadsheet, I kept your name/link etc there, just changed version to 1.3
& whoever stickied it before me :)
Great I idea. This is one of the first things I had to create and it has been a big help. Mine is pretty similar however I've added another tab that has a count down of the percentage fuel remaining at the end of each lap. So that I can hopefully understand how the driver decides when to pit. I've got it down to somewhere between 2.04 and 2.8 laps of fuel before pitting on the next lap.
Great tool but i may be being a bit thick here, can you please explain the diffrent areas, like field C8,9,10 and 11 what are those figures and where did you get the reading from and also what is the point of c 15 and 16 not sure what they are for?
David Brady 5000 13 years 34 days ago (edited 13 years 34 days ago)
"Colin
Great tool but i may be being a bit thick here, can you please explain the diffrent areas, like field C8,9,10 and 11 what are those figures and where did you get the reading from and also what is the point of c 15 and 16 not sure what they are for?
My bad i did update this the other week with a massive guide for the first page i just never uploaded it
V1.5 with changelog & guide as initial page
It is currently empty, so you have to fill the tyre values by experience.
The tire wear part is up to you to figure out.
Matt Dellit 5000 12 years 365 days ago (edited 12 years 365 days ago)
This tool inspired me to make my own, much simpler tool (doesn't bother with the setup info, since that changes a fair bit from driver to driver). Contained entirely on one page/sheet, so all I have to do is feed in my own data from races (how much was left in the tyres and the tank, over how many laps) and the sheet does all the hard work for me there.
Then I just put in how many laps I want to do in a stint, and the sheet will tell me the rest (best tyre to use, how much fuel to put in). Also an option for how much of a 'safety net' worth of fuel I want to put in the cars.
