Career in GP3

Posted by AFaustini 
Career in GP3
Date: March 20, 2015 11:42AM
Posted by: AFaustini
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?
Re: Career in GP3
Date: March 20, 2015 03:26PM
Posted by: ipswich2007
Sounds good, and should be possible. What do you mean Qual position x1? Would 20th place get 20 points and 1st place 1 point?

Re: Career in GP3
Date: March 23, 2015 12:38PM
Posted by: AFaustini
Sorry. The Points for the qual position will be inverted.
Sorry, only registered users may post in this forum.

Click here to login

Maintainer: mortal, stephan | Design: stephan, Lo2k | Moderatoren: mortal, TomMK, Noog, stephan | Downloads: Lo2k | Supported by: Atlassian Experts Berlin | Forum Rules | Policy