Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
Arrhythmia
Jul 22, 2011

Could we get this updated for the great 2019/2020 Forums Drama Wildfire?

Adbot
ADBOT LOVES YOU

Arrhythmia
Jul 22, 2011

Jeffrey of YOSPOS posted:

lmao that there's a 200,000 post gap between trump/anime and everything else

Here's a challenge: could you find out which thread has the highest reply count / time open ratio?

Arrhythmia
Jul 22, 2011

In Training posted:

People should stop posting about Trump so much IMO.

I agree.

Arrhythmia
Jul 22, 2011

Jeffrey of YOSPOS posted:

This is a hack job and I used the time between the first post and the first post on the last page for expediency:
pre:
+----------+--------+------------+---------------------------------------------------------------------------+----------+
| datespan | rate   | replycount | title                                                                     | threadid |
+----------+--------+------------+---------------------------------------------------------------------------+----------+
|     8636 | 0.4515 |       3899 | Sony E3 2014 Conference: Kaz Hirai's Twitter is Real                      |  3641829 |
|    20595 | 0.4358 |       8975 | Super Bowl 50 Official GDT: Poop and toenail fungus                       |  3763436 |
|    20450 | 0.3867 |       7909 | GB@SEA NFCCG GDT: Don't listen to 'em Marshawn, wear the gold cleats!     |  3695380 |
|     2577 | 0.3353 |        864 | Hello, posters of cspam.                                                  |  3909802 |
|    17306 | 0.3304 |       5718 | [Wildcard GDT] Pittsburgh Steelers vs. Cincinnati Bengals                 |  3759446 |
|    18962 | 0.3300 |       6258 | Super Bowl LIV GDT - You want the ball?                                   |  3913180 |
|    25152 | 0.3090 |       7772 | NFL Draft Game Day Thread 1st round ONLY                                  |  3632643 |
|    12717 | 0.2954 |       3757 | NFL Week 7: EARLY GAME MEGATHREAD GDT                                     |  3674327 |
|    18392 | 0.2875 |       5288 | The Ultimate Geezer Showdown: PV=nRT @ C39H60N8O13, AFC Championship Game |  3761457 |
|    19063 | 0.2810 |       5357 | NFL Week 1 Early GDT - CBS hopes you wanted to watch the Texans           |  3741616 |
+----------+--------+------------+---------------------------------------------------------------------------+----------+
It makes sense that they're mostly like, event threads focused on short times where one might post a lot on the same subject, and also the ppj drama thread in gbs??? Rate is in posts per second. That E3 thread has 98 pages and was open for like, 2.5 hours.

Lol that was the overlong cspam IK resignation letter

Arrhythmia
Jul 22, 2011

Athanatos posted:

8. SA-Mart › SA Goon specials-Big John's Beef Jerky

Lol

Arrhythmia
Jul 22, 2011
Here's one: what day(s) saw the most posts made?

Arrhythmia
Jul 22, 2011
What's the median posts per day? Could we get a timeline of it?

e: posts per USER per day, durr

Arrhythmia fucked around with this message at 23:00 on Apr 23, 2020

Arrhythmia
Jul 22, 2011

TheAardvark posted:

Any way to calculate who has had the most time on probation outside of 100k hour probes?

BurgerQuest posted:

erm I think I did this sort of right. I took the top 20 users by probe count first, then turned it into hours. assumed '1 month' probes are 30 days so yeah. could be tweaked.


Arrhythmia
Jul 22, 2011

Julias posted:

I don't have an exact number, but they've had nearly 50 accounts so far.

:eyepop:

Adbot
ADBOT LOVES YOU

Arrhythmia
Jul 22, 2011
Here's another one: # of threads goldmined per year?

  • 1
  • 2
  • 3
  • 4
  • 5