TWD Activity

[Rab]

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.

[zidane]

nice idea

[BIET]

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

[Rab]

Thanks BIET.
Assuming the dates at UTC unless told otherwise.

[Rab]

[Zeebu]

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

[Rab]

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%

[Zeebu]

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.

[Jones]

this is because basers stacked on 3 teams since 2015 or something. nothing new to see here. just let it die

[Zeebu]

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

[Jones]

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