GTS S14 - End of Season / Total Overall Pace

Discussion in 'GTLOZ Past Seasons' started by Matthyus, Mar 27, 2021.

  1. Matthyus

    Matthyus GTLOZ Results Steward Team Raceonoz Gold Member Super ROOZ

    Posts:
    3,582
    Likes:
    4,353
    PSN ID
    Johnnoclint
    So as an added bonus, here are the Season 14 pace breakdown and overall Pace for all of GTS.

    WARNING - Download the file from Google Drive, Excel online doesn't like Pivots..
    Season 14 pace
    https://drive.google.com/file/d/1eviAH56A6GTICI076INLNq-IJqIL6Zj2/view?usp=sharing
    Overall Pace
    https://drive.google.com/file/d/17aRTRH72DkY8HSoach0FLdvcaZDgKjCR/view?usp=sharing

    How to use
    Don't be daunted by the sheer amount of data, we can trim that down.
    Using the drop down arrow above the driver name in the chart itself, choose the Select All option which will unselect everyone. Now just scroll through the list to find the drivers you would like to compare too. Select as many as you would like.
    Example
    [​IMG]

    What does it mean & How is the data obtained
    First up, the second question.
    I take the FL and RT from the Fastest Lap data we obtain and break each time down to milliseconds using some Excel wizardary. I then compare those numbers to the Fastest achieved on the night. This gives you a figure.
    The closer you are to 1 the faster you are.

    You've linked 2 files, what's the second one for
    That Overall Pace file stores ALL 14 Seasons of GTS data, allowing to see how you are going over your racing career. Obviously you know if you are doing well in a certain car, etc. But this allows you to compare to other drivers and see the good or bad in a pretty little chart.

    Why?
    I like data. I offered Hat and co my assistance in an attempt to even out the divisions so that the competition could be closer. I've in the past solely used the Overall pace to initially place racers, alongside the promotion / regulation system, however over the last couple of seasons I decided to change things up a bit and only choose cars of the type we are using (GR4, N400, etc) to seed the divisions better. There was a pretty big shakeup in divisions 2 - 4, which I believe led to some closer racing.
    This season however we decided to again refine our qualification system, based off of the actual pace in the season car from the R1Q session. This led to some very interesting placements and with the benefit of hindsight, it needs some tweaking (of which we'll do for S15). As you can see, this is a constantly evolving beast, but we are constantly trying to get it as close as possible.

    Personally
    With the changes to how the divisions were seeded, combined with the Round 1 Qualifying (with me landing back in D3 from D2) the competition was going to be interesting with the few people I knew. I knew from the outset that I could be a front runner but everyone in the division had the ability / chance to stand on the podium, if they put in the time to practise. Especially given the R1Q results.
    I had set myself 2 goals this season.
    1. To continue to improve my pace and stay below the '20' figure. I nailed that this season by hitting a 14. This is getting very close to the top of Div 2...
    2. Beat Emmo / Saturn:)

    Given both Emmo and I were regulated to D3 given our less than stellar qualification times, I knew from the outset that he was going to be a serious contender. And all lordy, what a battle did we have :)
    For the Championship decider to come down to the last race (which doesn't happen very often) and a mis calculation on my own behalf thinking that a First and 4th was enough to outright win a Sprint round, well, we all know how it turned out..
    So close to finally nabbing that D3 Championship to go alongside my D4 to finally fully graduate to the smelting pot that is D2.
    I'm stoked with again hitting the sub 20 mark (not by a small margin either). I did manage to beat Emmo in overall pace, but by the smallest of margins. Saturn got me once again :)

    Anyhow, if you have any questions, fire away.

    PS - No more s/sheets from me until next Season now. Signing off for the Season.
    Last edited: Mar 27, 2021
  2. Stew Wilson

    Stew Wilson Rookie Gold Member

    Posts:
    151
    Likes:
    163
    PSN ID
    Stew_Wilson72
    It keeps asking for permission to view the docs, I have requested, can someone approve please.
  3. Matthyus

    Matthyus GTLOZ Results Steward Team Raceonoz Gold Member Super ROOZ

    Posts:
    3,582
    Likes:
    4,353
    PSN ID
    Johnnoclint
    I've modified the share link so you should be able to download it now.
    My bad. I don't use Google Drive that often..
    Let me know how you go.
  4. CaptainRisky21

    CaptainRisky21 World Champion Gold Member

    Posts:
    2,041
    Likes:
    2,394
    PSN ID
    CaptainRisky21
    razor4797, Matthyus and Hatfield like this.
  5. UrsineSaturn9

    UrsineSaturn9 World Champion Gold Member

    Posts:
    2,127
    Likes:
    3,152
    PSN ID
    UrsineSaturn9
  6. CaptainRisky21

    CaptainRisky21 World Champion Gold Member

    Posts:
    2,041
    Likes:
    2,394
    PSN ID
    CaptainRisky21
    Appears that way
  7. Max Gassit

    Max Gassit Team Driver

    Posts:
    300
    Likes:
    282
    PSN ID
    Max_Gassit_28
    How about a 10 season club. Which means it becomes more inclusive.
    Are there stat's available on the number of races that a driver does in official seasons?
    Then have a system of recognition for those that reach certain milestones. eg 100 club, 200 club etc
    UrsineSaturn9 likes this.
  8. Matthyus

    Matthyus GTLOZ Results Steward Team Raceonoz Gold Member Super ROOZ

    Posts:
    3,582
    Likes:
    4,353
    PSN ID
    Johnnoclint
    They are there in the raw data, but not easily presented.
    It would require time and effort to pull that out.
    On top of that, RQ, DSC, DSQ or lapped people don't have their times included.
    UrsineSaturn9 likes this.
  9. UrsineSaturn9

    UrsineSaturn9 World Champion Gold Member

    Posts:
    2,127
    Likes:
    3,152
    PSN ID
    UrsineSaturn9
    Too much work for one person, but perhaps a shared gsheet where people could opt in to enter their own data could work, it is all readily available in the past seasons threads race results etc
    Matthyus likes this.