ios-personmd-notifications md-help-circle

Profile

  • Guest
    medal 0
  • Posts: 21
  • Post Likes: 3764

Notifications

  • No Unread Notifications

Strategy Tool

warning
This thread is closed. Threads older than 6 weeks are closed automatically. To continue this discussion, create a new thread.
medal 5130
6 years 193 days ago
That's some of my data, so you can see how and where to input your data. You can clean it or just add/replace as you go along.

In the last section you have the data to prepare the strategy for the race (fuel, tyre wear, pit-stops...). Especially fuel data is very important, so you should put in your medium fuel usage (the formula on the sheet that calculates fuel/laps/pit-stops uses this fuel number to make his calculations).

In the section "Car Configuration", is where you put the input your drivers teel you when they do the 5 test-runs (data for future reference).

The section "Qualification & Race" is pretty obvious, you put the positions/times/points you've got on the races.

The section above this last one is just information over each GP track, as it's in iGP Manager.

The first section is where it all happens: tells you the fuel you need, how many laps you're gonna do and when you're going to pit. Also gives you the maximum nº of laps to do with any given tyre, total GP laps, fuel p/ lap and total fuel (to calculate some of this, first you must have/input the fuel and tyre wear data on the last section).

How does it work:
On the green cells you put the nº of the GP (it's above the country flag), nº of league laps (25% to 100%), and fuel safety net (this is for having sure that the driver won't stop in track without fuel - i always leave this cell with 1 on it, that means it's a extra litre - or more if you put 2 or 3 - per stint, not per lap).

On the blue and pink cells, you put the nº of laps you want to do, or in which lap you wanto to pit, and it calculates the rest automatically.

Once you've tried it, you'll see it's very easy to use. But ask away if you have questions...
md-quotelink
medal 5099
6 years 190 days ago
Bom dia Ricardo

Estou a tentar utilizar a tua folha de ajuda que desde já penso estar mto fixe , mas preciso ajustar o consumo médio previsto ( EX: Brasil , na folha diz um consumo médio de 3.5lts mas a informação do meu diretor é de 3.6lts e alem disso já reparei que o modo de corrida escolhido pode fazer alterar os consumos ; e desgaste de pneus ) por este motivo queria poder alterar a celula C8 , D9 , D10, mas está protegida , podes desproteger essa célula e enviar a tabela para mim alterada ou dar-me a palavra passe para poder desbloquear . podes enviar para : mariolteixeira@gmail.com
Esta é a minha 1ª época e estou a gostar ,  pretendo começar a fazer uma tabela na proxima .
Aproveito para perguntar o seguinte , com o fim desta época tenho um piloto com 25% de saude  quando começar a proxima o valor sobe para os 100% ? se não como faço ?
Abraços
Mário
md-quotelink
medal 5195
6 years 124 days ago
Here's a new version (3.1) of my Race Tool.
It already contains spaces to fill data when the new Super Softs and Medium tyres arrive at IGP.

Perfect for everybody to plan their race strategy... just download it:

http://www.fileswap.com/dl/52QPMtiHC5/
http://www.filedropper.com/xixaigpmanagerracetoolv31

Hope you'll like it.
Any doubts/questions, feel free to ask.
Ricardo Patrese/SpeedKing

md-quotelink
medal 5195
6 years 122 days ago
Here's the file image link (can't post image):

http://imgur.com/HOWYYw7
md-quotelink
medal 5195
6 years 121 days ago
Here's how it works:

First, on top, in the green cells, you put the league laps % (25% to 100%) and the nº of the GP (it's above the country flag - from 1 to 17).

The cells below automatically gives you some information related to laps, fuel and tyre (total GP track laps, lap/total fuel needed, tyre wear and the maximum nº of laps to do with tyre).
- to give you such information, first you must have the section "Fuel, Tyres and Pit-Stops" filled with values (right now those are filled with my personal data, you can change it to fit your case).

Still on top, there's the driver section.
On the blue cells, you put the nº of laps you want to do for every stint (this will give you the fuel you need and in what lap you will stop), or the amount of fuel you want to go with (this gives you how many laps you can do with that fuel).
Again, the last section, "Fuel, Tyres and Pit-Stops" must be filled with values, so it can calculate automatically.

Below that, there are 4 sections:

1st one is "Grand Prix Circuit Data". This one is just information about each GP track, as it's in iGP Manager.

2nd is "Qualification & Race", where you put the positions/times/points you've got on the races.

3rd is "Car Configuration", where you put the input your drivers tell you when they do the 5 test-runs (you can keep this data for future reference).

Last one, but not the least, is the section "Fuel, Tyres and Pit-Stops". This is where you have the data to prepare the strategy for the race (fuel, tyre wear, pit-stops...). Especially fuel data is very important, so you should put in your medium fuel usage or what your tecnhical director says - only if he's normally right - (the formulas in the spreadsheet that calculates fuel/laps/pit-stops uses this fuel number to make his calculations).
In here you can save also your previous strategy or future strategy (laps to do, tyre to use, amount of fuel, in what lap to pit, nº of pit-stops - i reduced it to, for example: 9s37 - that is 9 laps, soft tyre, 37L)

I think it's easy to work with it, just try it and give me some feedback...
RIC

md-quotelink
medal 5195
6 years 120 days ago

md-quotelink
medal 5195
6 years 109 days ago (edited 6 years 109 days ago)
New version !!!
The 3.1 had a formula error in QUALIFICATION & RACE section when the driver didn't finish the race in the top 10 places.
In this version (3.2) no longer happens.

The links are:
http://www.fileswap.com/dl/35CMwhq0AH/
http://www.filedropper.com/xixaigpmanagerracetoolv32

Good races to you all.
md-quotelink
medal 5078
6 years 108 days ago
HI Ricardo 

i trided downloading it and i get this error message whenthe file opens up in excel.


<br /><b>Warning</b>:  gzopen() [<a href='function.gzopen'>function.gzopen</a>]: Filename cannot be empty in <b>/home/filedrop/public_html/processing/filedownload.php</b> on line <b>166</b><br /><br /><b>Warning</b>:  gzclose() expects parameter 1 to be resource, boolean given in <b>/home/filedrop/public_html/processing/filedownload.php</b> on line <b>176</b><br />
md-quotelink
medal 5195
6 years 108 days ago
Hi Nathan.
I´ve tried and it gives me no error. Did you tried both links?
If you cannot download it, please send me your e-mail by PM, and i'll send it to you.

RIC

Anyone else is having problems with the download?
md-quotelink
medal 5033
6 years 107 days ago
How do you do the Tire part


md-quotelink
medal 5033
6 years 107 days ago
What do you put in for the Tire setting

md-quotelink
medal 5210
6 years 102 days ago
been using this for most of my first season, its an amazing tool, and ive been slowly updating my data in preperation for season 2.
however, the new tyres update made all those numbers a bit weird. trying to adjust them as i learn the new tyre values.
hopefully season 3 ill have a fully updated accurate sheet :D
thx Ricardo.

looking forward to the next version ;)
md-quotelink
medal 5000
6 years 95 days ago
with the suppliers part of your strategy tool do you use this at all
md-quotelink
medal 5195
6 years 93 days ago
If i understand correctly what you mean (you're talking about the "suppliers" sheet, right?), no.
I'ts just informative values for us to choose "wisely" the suppliers to use.

To calculate some type of strategy, using all the suppliers available, would be far too exaustive, and i don't think the outcome would bring the "ultimate perfect strategy to beat everyone", if you know what i mean (although it can be possible, maybe, who knows?).
So i just made a table where everybody could see and compare the suppliers values and choose acordingly, simple as that.
md-quotelink
medal 5000
6 years 92 days ago
very good strategy tool you have made ricardo made my life a hell of a lot easier. thanks for putting in the time and effort to design it
md-quotelink
medal 5000
6 years 92 days ago
"Ricardo
If i understand correctly what you mean (you're talking about the "suppliers" sheet, right?), no.
I'ts just informative values for us to choose "wisely" the suppliers to use.

To calculate some type of strategy, using all the suppliers available, would be far too exaustive, and i don't think the outcome would bring the "ultimate perfect strategy to beat everyone", if you know what i mean (although it can be possible, maybe, who knows?).
So i just made a table where everybody could see and compare the suppliers values and choose acordingly, simple as that.


thanks fo answering my questn ricardo  that's wha i wa talkng about and thought that it was jus an info page. with colleting your daa for fuel and tyre use perlap at the end o the race what is te mot accurate wy to do tis asi have dne it a couple of ways and ge difrentanswers for each way but the answers a clse to each othe.

I ally love his stratgytool you made thanks fr puttin the effrt into it
md-quotelink
medal 5195
6 years 90 days ago
Still working to make it better...

Now i'm introducing a column with Push Level (PL) for every stint, that will affect the amount of fuel needed in every stint.
So if you're going with SS tyres in 1st stint and presumebly use PL1 (take-it-easy) for the entire stint, the fuel needed is less 0,2L per lap than if you were in M tyres with PL3.
But if in stint 2, you will use Hard Tyres with PL5, you will spend more 0,2L of fuel per lap than the normal (PL3).
The formula will calculate, for every PL you use, a different amount of fuel.

When it's finished (almost is, just tweaking some stuff), you can put the PL desired for each stint and the fuel indication for that stint will be more exact than ever.
md-quotelink
medal 5063
6 years 90 days ago
"Ricardo
Still working to make it better...

Now i'm introducing a column with Push Level (PL) for every stint, that will affect the amount of fuel needed in every stint.
So if you're going with SS tyres in 1st stint and presumebly use PL1 (take-it-easy) for the entire stint, the fuel needed is less 0,2L per lap than if you were in M tyres with PL3.
But if in stint 2, you will use Hard Tyres with PL5, you will spend more 0,2L of fuel per lap than the normal (PL3).
The formula will calculate, for every PL you use, a different amount of fuel.

When it's finished (almost is, just tweaking some stuff), you can put the PL desired for each stint and the fuel indication for that stint will be more exact than ever.

Wow - presume you're not getting paid for this either!?
md-quotelink
medal 5210
6 years 89 days ago

the new extras sound great Ricardo,

can we start getting excited about the new version in the next few days? :)
those new tyre values will be a god-send!
md-quotelink
medal 5195
6 years 82 days ago
I have it ready but i'm waiting to complete the 17 races after the tyres have changed. It will be released in 24th of August.
Those who can't wait, just say and i'll send it as it is now...
md-quotelink

You must be logged in to post a reply.