Anyone have a spreadsheet to manage career in GP3?
I had an idea to create an spreadsheet to do this. The rules that i imagined are:
Qualifying points = Qual position x 1
Race points = Race position x 3
Race combativeness points = Qualifying position - Race position x 0,5
Event points = Qual points + race points - Race combativeness points
Failure = Qual position + race position/2 x 4
Crash = Qual position + race position/2 x 4 +16
Morale = always divide total of event points by number of races, if result equal 4 = 100%, if the result are equal the number of drivers x4 plus 16 by race = 0%, difference between these two values divide by 100 to calculate the actual morale.
Team Contracts = divide 100 by the number of teams of the next season, the result will be the morale tier for every team
Team positions for contracts = Actual season team position, new teams in the bottom, teams replacing another teams take the position of these old teams
Contract offering First quarter of Season = no offerings
Second quarter of Season= the bottom third of teams, if had achieved the necessary points
Third quarter of Season = the middle third of teams, if had achieved the necessary points
First quarter of Season = the top third of teams, if had achieved the necessary points
What do you think about this?