Announcement

Collapse
No announcement yet.

TWD Activity

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • TWD Activity

    I want to make a chart of twd activity, to see which divisions are active during which hours of the day.

    Please could someone dump some twd data for me into a google sheet?

    1 row per match.

    columns:
    - start timestamp
    - division (wb/jav/base)

    I don't need loads of historic data, a couple of months worth is sufficient.

  • #2
    nice idea

    Comment


    • #3
      I've gathered all TWD matches from January 1st 2018 till now. Let me know if you want data from further back, might be helpful to see older patterns.

      https://1drv.ms/u/s!AmO-KNg7hhFfiadCxr7Y9rXc4ig2Kg

      P.S.
      (FnMatchTypeID) TWDD = type 4, TWJD = type 5, TWBD = type 6
      (FnMatchStateID) Finished = 3, Canceled = 5, Bot crash = 2

      Comment


      • #4
        Thanks BIET.
        Assuming the dates at UTC unless told otherwise.
        Last edited by Rab; 03-11-2019, 12:54 PM.

        Comment


        • #5


          Comment


          • #6
            so what youre saying is... peak times are 4-10pm EST... and jav vs wb are fairly even... basing is rare, but it looks to happen when eastern and western US coincide at reasonable times. in conclusion it appears as if more games are played when the zone population is at its daily peak. except base, people stick around longer to try and convince the dders and jders to deign to play a game of bd after a couple rounds of dd and jd
            sigpic

            1996 Minnesota State Pooping Champion

            Comment


            • #7
              I'm mainly looking at how dead BD is if you're a Euro who likes to go to bed at a decent time.

              Within the busiest hour of the day for each division.
              The chance there's a DD occurring is 42%
              The chance there's a JD occurring is 43%
              The chance there's a BD occurring is 7%

              Within any of the hours betwen 5PM and 5AM.
              The chance there's a DD occurring is 24%
              The chance there's a JD occurring is 21%
              The chance there's a BD occurring is 3%

              Comment


              • #8
                i mean, in order for a bd to be remotely fun, you need at least 7. in general it just takes way more people in order to have a game. on top of that, it takes people somewhat specialized in order to have ters and sharks. i dont think theres any magic answer to this other than more people online at those times.
                sigpic

                1996 Minnesota State Pooping Champion

                Comment


                • #9
                  this is because basers stacked on 3 teams since 2015 or something. nothing new to see here. just let it die
                  TWDTJ & TWDTB FINALIST 2019

                  Comment


                  • #10
                    Originally posted by Jones View Post
                    this is because basers stacked on 3 teams since 2015 or something. nothing new to see here. just let it die
                    so what youre saying is that all the basers need to stack on 2 teams so that they might actually be able to support a twbd more often
                    sigpic

                    1996 Minnesota State Pooping Champion

                    Comment


                    • #11
                      Originally posted by Zeebu View Post

                      so what youre saying is that all the basers need to stack on 2 teams so that they might actually be able to support a twbd more often
                      1 squad, 1 go base arena and a whitelist
                      TWDTJ & TWDTB FINALIST 2019

                      Comment

                      Working...
                      X