GTS S8 - Fastest Laps & Race Times

Discussion in 'GTLOZ Past Seasons' started by Matthyus, Jul 30, 2019.

  1. emmo46

    emmo46 Steward Team Raceonoz Gold Member Super ROOZ

    Posts:
    11,983
    Likes:
    7,533
    PSN ID
    emmo46
    I cut and paste from excel into Paint. I configure the cells so that a small border is created around the relevant cell range.
  2. Matthyus

    Matthyus GTLOZ Results Steward Team Raceonoz Gold Member Super ROOZ

    Posts:
    3,577
    Likes:
    4,351
    PSN ID
    Johnnoclint
    I had never thought of it tbh...
  3. Matthyus

    Matthyus GTLOZ Results Steward Team Raceonoz Gold Member Super ROOZ

    Posts:
    3,577
    Likes:
    4,351
    PSN ID
    Johnnoclint
    You can also just remove gridlines from excel.
  4. Matthyus

    Matthyus GTLOZ Results Steward Team Raceonoz Gold Member Super ROOZ

    Posts:
    3,577
    Likes:
    4,351
    PSN ID
    Johnnoclint
    Round 5 updated
  5. Matthyus

    Matthyus GTLOZ Results Steward Team Raceonoz Gold Member Super ROOZ

    Posts:
    3,577
    Likes:
    4,351
    PSN ID
    Johnnoclint
    Round 6 posted
  6. LE_bananajosh

    LE_bananajosh Team Driver

    Posts:
    492
    Likes:
    301
    PSN ID
    GT_bananajosh1
    I’m ahead of all Division 2 drivers (FBI OPEN UP)
  7. T F Eccles

    T F Eccles Professional Gold Member

    Posts:
    1,355
    Likes:
    2,141
    PSN ID
    tfeccles
    @Matthyus one thousandth of a sec...must be a timing error.
    Matthyus likes this.
  8. Hatfield

    Hatfield GT7 League & Teams Championship Organiser Team Raceonoz Gold Member Super ROOZ

    Posts:
    18,109
    Likes:
    17,585
    PSN ID
    DRZ-Hatfield
    you almost beat my total time too! time for div 1 next season perhaps?
    Apex_64 likes this.
  9. LE_bananajosh

    LE_bananajosh Team Driver

    Posts:
    492
    Likes:
    301
    PSN ID
    GT_bananajosh1
    Hahaha I’ll see you in Division 1
    Hatfield likes this.
  10. emmo46

    emmo46 Steward Team Raceonoz Gold Member Super ROOZ

    Posts:
    11,983
    Likes:
    7,533
    PSN ID
    emmo46
    I on the other hand had one of my slowest nights. No practice and a fluttering throttle.
  11. Apex_64

    Apex_64 Professional

    Posts:
    660
    Likes:
    1,097
    PSN ID
    apex_64
    Considering you have the Div3 title wrapped up, and you are ahead of all the Div2 drivers.
    It only makes sense Le_bananajosh, that you should have a drive in Div1 this week ;)
  12. Hatfield

    Hatfield GT7 League & Teams Championship Organiser Team Raceonoz Gold Member Super ROOZ

    Posts:
    18,109
    Likes:
    17,585
    PSN ID
    DRZ-Hatfield
    to be honest @LE_bananajosh if you would like to we will have the space for you to run in div 1 this week if you wanted to try it
    Matthyus and emmo46 like this.
  13. LE_bananajosh

    LE_bananajosh Team Driver

    Posts:
    492
    Likes:
    301
    PSN ID
    GT_bananajosh1
    Too soon I’ll wait till next season
    Apex_64 likes this.
  14. T F Eccles

    T F Eccles Professional Gold Member

    Posts:
    1,355
    Likes:
    2,141
    PSN ID
    tfeccles
    You might as well, the rain is going to be a great leveller.
    LE_bananajosh likes this.
  15. LE_bananajosh

    LE_bananajosh Team Driver

    Posts:
    492
    Likes:
    301
    PSN ID
    GT_bananajosh1
    Ok fine I’m racing in Division 1 this week
    Apex_64 and Hatfield like this.
  16. Matthyus

    Matthyus GTLOZ Results Steward Team Raceonoz Gold Member Super ROOZ

    Posts:
    3,577
    Likes:
    4,351
    PSN ID
    Johnnoclint
    Round 7 posted
    Hatfield and Noxrai like this.
  17. Matthyus

    Matthyus GTLOZ Results Steward Team Raceonoz Gold Member Super ROOZ

    Posts:
    3,577
    Likes:
    4,351
    PSN ID
    Johnnoclint
    As I like to do at the end of a season and to prepare for the next seasons Division placement is to see how everyone compared to each other. As well as the trend in how the group of racers performed in the car across the board.

    To view the spreadsheet correctly, you need to Download it.
    https://drive.google.com/open?id=15KDzbpGB-_ipUfrQEJRtTMzcXrhrVCey

    For starters, there is a lot of information at your fingertips.
    To filter the chart down, on the chart itself there is a drop down called 'driver'
    Click this and then scroll through the list to choose only the racers you wish to look at.
    This data is created by comparing your FL and RT (broken down into Milliseconds) to the fastest achieved, using some fancy Excel work.
    The higher the number, the slower you were.

    Some stand out info, We mostly sucked in Season 2 :D
    Personally, I've been getting better, but this season saw me not perform as well as I could have, however it was better than our last GR3 car, so points there.
    As a group, it was all over the shop in regards to the group, some improved, others didn't.

    We had 51 racers compete across the 7 events.
    Race 4 had the most on track with 39
    Race 7 had the least with 26.

    Division 1 had the most diverse range of podium winners with 10 different racers earning a podium
    Division 2 had 8
    Division 3 had 5

    If you have any questions..Fire away.

    The below picture is an example of a few drivers selected.
    [​IMG]
    emmo46, Hatfield and LE_bananajosh like this.
  18. Hatfield

    Hatfield GT7 League & Teams Championship Organiser Team Raceonoz Gold Member Super ROOZ

    Posts:
    18,109
    Likes:
    17,585
    PSN ID
    DRZ-Hatfield
    @Viperzed pipped me in the battle for 3rd in the championship, and @JonoStan96 had a deserved 2nd. How would you interpret our 3 lines of data?
  19. Matthyus

    Matthyus GTLOZ Results Steward Team Raceonoz Gold Member Super ROOZ

    Posts:
    3,577
    Likes:
    4,351
    PSN ID
    Johnnoclint
    So, your question got me thinking in that I can easily create a Season round breakdown.
    Like so

    https://drive.google.com/open?id=192PK9siZ3NDrjEQy3zeM5rfSGKtsY663

    Given your question here is a screenshot of how each race went for the 3 racers mentioned.
    [​IMG]
    You attended all races over each of the others, however Jono's pace was superior in all races.
    You only pipped Viper once in Round 5.
    There was close competition in Round 2 & 3.
    4 was well,lets not talk about that shall we :)
    In saying that the Endro round inflates the differences between all racers, so Keeden is just too fast!!
    5 you bounced back or Viper had a crap race.
    Jono raced out of his skin in Round 6, the one he won I believe, GG mate!!
    Round 7 saw Viper race to close to his best all season and Jono had his worst outing.

    For division comparsion sake
    [​IMG]
    Comparing Division winners with Division stablemates
    Apex would have had a solid mid pack to possible podium season in D1.
    Josh would have had a solid mid pack season in D1, but would have put up a fight for podium finishes in D2
    Keeden, well did what Keeden does :) :alien:
    LE_bananajosh and Hatfield like this.
  20. Hatfield

    Hatfield GT7 League & Teams Championship Organiser Team Raceonoz Gold Member Super ROOZ

    Posts:
    18,109
    Likes:
    17,585
    PSN ID
    DRZ-Hatfield
    Love it!
    however my question was misinterpreted, but I'm not complaining. (it's my fault for not being specific)

    Good to see that despite being beaten pretty much every round by both of them, I was so close to them with 2 rounds remaining.

    I was actually wondering on the pace growth/fall looking at all previous seasons data
    Matthyus likes this.