RGL.gg Forums Home
    • Login
    • Search
    • Recent
    • News
    • Popular
    • Tags
    • Users
    • Groups
    • Rules
    • RGL Community Links
      • RGL Homepage
      • RGL-HL Homepage
      • RGL Sixes Homepage
      • RGL Twitch
      • RGL Youtube
      • RGL Twitter
      • RGL Discord
      • RGL Steam Group
  • RGL HL Season 14: Announcing Invite Qualifiers
    RGL News & Updates
    1
  • RGL 6s S11 - Map Pool, Admin List, and Season Changes
    RGL News & Updates
    1
  • RGL HL Season 14: Map Order, Staff Changes, and Reminders
    RGL News & Updates
    2
  • CappingTV TF2 Summer Brawl
    TF2 Blog
    1
  • Season 8 Stopwatch Time Sheet

    General
    7
    12
    392
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Honesty
      Honesty RGL.gg last edited by Honesty

      https://docs.google.com/spreadsheets/d/1nnFxaT0SHJ7COVHF0DPK2O3fC57SNZiMo8x6POkfUUQ/edit?usp=sharing

      This spreadsheet collects data from invite scrims (and eventually matches) in order to give anyone who is curious the information about the average capture times, with a (n assumed) normal distribution to give some sense on what times are good / bad.

      As of right now, only upward is filled with “significant” data, as that is the first week of play, and the data will change overall even by next week as there will be much more data to input.

      You can search by map by clicking on the tabs at the bottom of the page.

      How to read this spreadsheet:

      The offense team column is the team that set the time
      The K column after the offense team is the kills that team got on their attack
      The K:K column gives a ratio between the kills from the attacking team to the defending team. I want to see if there is a straightforward correlation between kill ratios and cap times.
      The K column before the defense team is the kills the defending team got
      The defense team is… the defending team.
      Time is the time the offense team set. (Taken into account for set up time)

      Avg time, Stddev, Slowest, Fastest should be as self explanatory as the other columns

      The Map Rundown gives the setup time, as well as the fastest possible cap times for each point at x3. This should be used in order to help teams realize if they have enough time to push or not and whatever.

      Assuming normal distribution column(s) give the average time, as well as the 1st-3rd standard deviations on both sides of the average to give a sense of what times are good or bad.

      1 Reply Last reply Reply Quote 9
      • 76561198418622751
        minty RGL.gg last edited by

        god damn sand hats off to u for making this, actually cool to look at and im looking forward to seeing more as the season progresses

        1 Reply Last reply Reply Quote 0
        • 76561198046508940
          Willy RGL.gg last edited by

          This is so cool. Love that you made this.

          1 Reply Last reply Reply Quote 0
          • 76561198068104187
            Joey Lemons RGL.gg last edited by

            good work, also lets go i got the slowest time so far last night

            1 Reply Last reply Reply Quote 1
            • 76561198096806703
              scaredy bat RGL.gg last edited by

              I’m not a statistician, so I know nothing about it – is it normal to drop outlier values? What kind of “impossible times” would be produced? 😮

              Honesty 1 Reply Last reply Reply Quote 0
              • 76561198065284779
                Pain Seer RGL.gg last edited by

                Interesting sheet. I’d be really curious to see it for other divs and see the averages between different skill levels

                1 Reply Last reply Reply Quote 0
                • Honesty
                  Honesty RGL.gg @76561198096806703 last edited by

                  @scaredy-bat No, generally it is not a good idea to drop outlier values. I did so only so that the chart that tells what times are good/bad would make sense. For example, the current pl_vigil tab has a negative 2 minute time for “very fast”. Similar things like that happened when the very long rounds were input into the upward tab as well, even with that many data points. I guess I could add them but that table on the right would be totally off

                  1 Reply Last reply Reply Quote 0
                  • Honesty
                    Honesty RGL.gg last edited by

                    Vigil times are updated, use the link in OP and navigate through the maps using the tabs at the bottom of the window

                    1 Reply Last reply Reply Quote 0
                    • Honesty
                      Honesty RGL.gg last edited by

                      Also, I kept the outliers in the data this week, to show what I meant when the normal distribution chart isn’t accurate

                      1 Reply Last reply Reply Quote 0
                      • 76561198096806703
                        scaredy bat RGL.gg last edited by

                        Grazie! Very weird. I wonder how statisticians deal with this kind of thing when analyzing other kinds of things.

                        1 Reply Last reply Reply Quote 0
                        • Honesty
                          Honesty RGL.gg last edited by

                          See the completed tables here : https://docs.google.com/spreadsheets/d/1nnFxaT0SHJ7COVHF0DPK2O3fC57SNZiMo8x6POkfUUQ/edit?usp=sharing

                          Bottom of the page shows tabs for each of the four stopwatch maps played this season.

                          All data came from invite scrims and matches.

                          I will include playoff match times as well when they are played, but as of now you all can see a general list of average times for each of the stopwatch maps.

                          Hope you all find this useful in the future. I wonder now what the average times are between divisions?

                          1 Reply Last reply Reply Quote 3
                          • 76561198103930234
                            ethanf RGL.gg last edited by 76561198103930234

                            interesting how the average times are all very close to a whole number of minutes

                            will make them easier to remember 😁 thank you for your efforts

                            1 Reply Last reply Reply Quote 0

                            • 1 / 1
                            • First post
                              Last post
                            Swiftnode.net Engineer.tf