Strategy Tool

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.

You can find the download here http://dl.dropbox.com/u/23593073/priv/iGPStrategy_Tool_final1.0.zip (And updated v1.5 at the bottom of this post)



UPDATE: V1.5 Download link here
http://www.filedropper.com/igpstrategytool15-empty

Thanks for sharing Marius

Thanks for sharing, I'll try it out and will report back to you

Thanks for sharing Marius. Great Work

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.

I'd be interested if for sure.

+1 for me as well.

Thanks

sounds good.

I'll upload it 2morrow then once i delete all my data from it lol

http://www.filedropper.com/igpstrategytool15-empty
Also if anyone can upload it anywhere better, please do so and post the link, its late and I cant be bothered searching the internet

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 :)

Being a noob to IGP I am really interested in this but when I go to the link it shows up busted.

Indeed it does.... try [v1.3]

updated again to 1.4/1.5 thanks to Martin for some idea's will upload again later and update 1st post with new links when done

Links now in first post

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?

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

http://www.filedropper.com/igpstrategytool15-empty

Will update links in first post as well

I've been trying to use this sheet, but I'm stuck on the Tyre Wear part. How do I know what's the tyre wear for my next race?

I'm refering to the part where it says: <----- change the box in black to the tyre wear % per lap

The tire wear part is up to you to figure out.

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.

Might even be persuaded to share it, maybe :P


*Updated with latest pic

how much u want for it?

Just going to clean up the spreadsheet, and save it in excel format (hopefully), since I use OpenOffice, then I might share with the world ;)