How to Run a Championship

#1 by jakesanson , Thu Nov 11, 2010 1:42 pm

DerKlon asked me an intersting question which some of you may want to know the answer to.

Basically he wanted to know how to calculate individual driver values for each team in a series.

This is a bit of a tricky one. I sort of based it on several things.

Firstly I did a test session where everyone had equal driving value (16000) and based it on the results.

Secondly I looked at previous results and career history which was provided by people last year when they signed each driver.

Thirdly I looked at how likely drivers were with their specific backgrounds, nationalities and experience were likely to get on in a particular series with a particular team and engine combination.

To be honest, a lot of it is guess work. Perhaps there should be a better method of working it out. Any suggestions, I'd be happy to hear them.

jakesanson  
jakesanson
Posts: 99
Date registered 10.19.2010


RE: How to Run a Championship

#2 by Hawke , Sun Dec 05, 2010 11:56 am

I think it would be better to make a list (perhaps in WRL Competitors) with all the values of the drivers.....

And A-class driver could have a value between 16000-17000 a B-Class driver between 15000-16000........ down to D-Class drivers.....

For a championship they could get 500 point more.... a second place 300 points and a third place 100 points or so......

Hawke  
Hawke
Posts: 125
Date registered 10.21.2010


RE: How to Run a Championship

#3 by Klon , Sun Dec 05, 2010 12:17 pm

I have developed an Excel sheet to do this for me, but I still want to improve it a bit. Maybe I will post it in a week or so.

Klon  
Klon
Posts: 114
Date registered 10.20.2010


RE: How to Run a Championship

#4 by jakesanson , Fri Dec 10, 2010 3:09 pm

I really like Hawke's suggestion. That would make determining driver skill much easier.

jakesanson  
jakesanson
Posts: 99
Date registered 10.19.2010


RE: How to Run a Championship

#5 by Klon , Fri Dec 10, 2010 4:37 pm

Well, here is my proposal. I did not change anything really, this ain't supposed to be rocket science.

It is quite simple. First off, enter the name. The RANK is simply the one in the driver's table. SKILL will be shown automaticly. POS is the position in the last season. For new drivers in a series, enter "100", that should be fine. LUCK is a randomly generated number, leave that field alone (due to the number you will need to do all strenghts in one session or else these numbers will change). PRIDE is simply when a driver has the same nation as his team. Write "YES" (without the inverted commas) or "NO" ... then you should be done. You may need to change engine power of the series though if you need to get more realistic lap time.


Attachment:
GPWC - Race Grip - 11.11.10.xls
Klon  
Klon
Posts: 114
Date registered 10.20.2010

Last edited 12.10.2010 | Top

RE: How to Run a Championship

#6 by Hawke , Sat Dec 11, 2010 11:50 am

I've tested it but there happens nothing in the LUCK-cell..... and there for it doesn't calculate GRIP......

But it's a good program.... if you can make in work in the LUCK-cells

Hawke  
Hawke
Posts: 125
Date registered 10.21.2010


RE: How to Run a Championship

#7 by Klon , Sat Dec 11, 2010 5:29 pm

I have found out that ZUFALLSBEREICH is not used in actual excel, so you might need to try change it into Excel's name for that (idk what it is), get yourself a random number any other way or just have a higher grip range.

Klon  
Klon
Posts: 114
Date registered 10.20.2010


RE: How to Run a Championship

#8 by Hawke , Sun Dec 12, 2010 11:54 am

oke....

And the random numbers shoud be between witch numbers??

Witch are you using or between witch numbers youre system calculates the LUCK?
So we can use the same formula-numbers.

I like you're system, its great.... thats what i needed for my series

Hawke  
Hawke
Posts: 125
Date registered 10.21.2010


RE: How to Run a Championship

#9 by Klon , Sun Dec 12, 2010 4:22 pm

I have them between 150 and 350, that should be enough.

Klon  
Klon
Posts: 114
Date registered 10.20.2010


RE: How to Run a Championship

#10 by jakesanson , Mon Dec 13, 2010 10:01 pm

DerKlon, you're a ruddy genius!!

jakesanson  
jakesanson
Posts: 99
Date registered 10.19.2010


   

Say hello to me and answer to my questions guys;
Real Life?

Xobor Create your own Forum with Xobor