Bay 12 Games Forum

Finally... => General Discussion => Topic started by: My Name is Immaterial on April 30, 2014, 11:31:07 pm

Title: Bay12's posting history.
Post by: My Name is Immaterial on April 30, 2014, 11:31:07 pm
Some of you are familiar with the statistics center (http://www.bay12forums.com/smf/index.php?action=stats) at the bottom of the main page. Most of you aren't, probably, because it's tucked away. Go check it out before continuing.

With me? Good! Do you like data? No? Too bad! Here's a ton of it!
Spreadsheet (https://docs.google.com/spreadsheets/d/1o7rk4oGTGNEJ4wD2NJJvjpg-da6s3nB90wPOiv4anNQ/edit#gid=1222546767)!

That spreadsheet is the collection of the data from the very bottom of the statistics center, in Excel format with "fancy" graphs. Topics per day/month, Posts per day/month, New members per day/month and Most members online at once per day/month. It's all there, from 6/15/2008 up to last month. I'm even working on some side projects, like an automated updating system and a predictive algorithm. If you'd like to help out with that, just play around with it, or have any questions, please feel free to ask!

I thought that you all might be interested, so here you go.
By the way, the early 2010 and 2012 spikes are undoubtedly DF2010 and DF2012, incase you were wondering. December 8th, 2010 is still a mystery to me, however.
That said, Haspen did some digging and came back with this:
According to devlog, that day Toady posted a bunch FotF reply links... and that's it v:
Title: Re: Bay12's posting history, a spreadsheet.
Post by: mastahcheese on May 01, 2014, 12:50:35 am
I actually check those stats fairly regularly, when I'm not stalking the "recent users" section, or browsing the calander section to see when people's birthdays are.




...What?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 01, 2014, 01:30:51 am
Ah! A like minded fellow!
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 06, 2014, 03:38:32 pm
As a bump, I've added a third sheet to check out, with some statistical information, like monthly means, standard deviation and variance. I will at some point add graphs too.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Haspen on May 06, 2014, 03:43:28 pm
Why your months only have 12 days? v:

DERP NEVERMIND ._.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: 10ebbor10 on May 06, 2014, 03:44:30 pm
It's the google standard, if you're wondering. Which is kind of annoying.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 06, 2014, 04:01:16 pm
It is very annoying, but eh. It suits my purpose.

@ Who ever commented r/mildly interesting.
Thank you! I try.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Loud Whispers on May 06, 2014, 04:03:56 pm
I'm being taken off the top 10 post count by FG&RPers. I must tell myself, it isn't worth it, that we don't need another wave of LW spam...
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Haspen on May 06, 2014, 04:05:43 pm
I'm being taken off the top 10 post count by FG&RPers. I must tell myself, it isn't worth it, that we don't need another wave of LW spam...

Too late. You will never reclaim your previous glory. Now all you can bask is the leftover aftertaste.

/me gives LW a supportive hug.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Loud Whispers on May 06, 2014, 04:08:48 pm
Too late. You will never reclaim your previous glory. Now all you can bask is the leftover aftertaste.
/me gives LW a supportive hug.
/me holds a box of post count enhancing steroids, labeled FG&RP.

DON'T TEMPT ME
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Aklyon on May 06, 2014, 06:49:27 pm
Its less FG and more RP, actually. Realm of the mad god Rise of the magic girls has a ridiculous amount of posts for something that isn't a huge rtd or in general discussion, it has somewhere in the rage of 40-50% of the posts the happy thread has according the the bars in the stats center.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Tawa on May 06, 2014, 07:26:29 pm
Yeah, it's disproportionately big.

Now, if only my D & D campaign could be that big...

Right, David? :P

Anyway, more on topic...

Really, there was a crazy members-online jump back in late 2010? What happened back there?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 06, 2014, 07:29:17 pm
Now, if only my D & D campaign could be that big...

Right, David? :P
Your game is already got 7 people. That's a ton. Seriously. I've got like 5 players in my game, and it's a ton of work keeping them all busy.

Really, there was a crazy members-online jump back in late 2010? What happened back there?
By the way, the early 2010 and 2012 spikes are undoubtedly DF2010 and DF2012, incase you were wondering.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Tawa on May 06, 2014, 07:33:54 pm
Now, if only my D & D campaign could be that big...

Right, David? :P
Your game is already got 7 people. That's a ton. Seriously. I've got like 5 players in my game, and it's a ton of work keeping them all busy.

Really, there was a crazy members-online jump back in late 2010? What happened back there?
By the way, the EARLY 2010 and 2012 spikes are undoubtedly DF2010 and DF2012, incase you were wondering.

Yeah, I do have a lot of people in my game.

Still, if I could have half the amount of posts that game has...
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Haspen on May 06, 2014, 07:36:05 pm
Make a FEF; ton of waitlisters and RP posts guaranteed with moderate posting pace included :P
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 06, 2014, 07:40:02 pm
Really, there was a crazy members-online jump back in late 2010? What happened back there?
December 8th, 2010 is still a mystery to me, however.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Haspen on May 06, 2014, 07:45:37 pm
According to devlog, that day Toady posted a bunch FotF reply links... and that's it v:
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 06, 2014, 07:55:59 pm
Added to the OP. Thank you.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Glloyd on May 06, 2014, 08:05:08 pm
What I'm getting is that due to the lack of a new release, there are less new members joining, and less new topics made. In addition, the amount of new members in 2012 may have something to due with all the press coverage of DF at the time, including the MoMA stuff. Members online is mostly steady, with brief spikes around releases. In addition, the amount of posts per month is experiencing a steady increase over time, tripling since the start of 2009.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 06, 2014, 08:37:57 pm
That's the same impression I had. I suspect that we are becoming a smaller but more active forum.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Toady One on May 06, 2014, 08:51:02 pm
Starting in roughly 2014 we changed how members were registered because of the love bots -- about 2/3rds (very approximately) of the signups before then starting especially around 2011 were spammers.  Now they only get in every once in a while.  I'm still cleaning that up (I've deleted at least ten thousand accounts over the last couple years, and there's a lot left to go).  So total member counts are basically useless, though members online isn't really affected by spammers (except maybe that weird day).  As far as I can tell, the actual-people membership slowly increases, as does the people online, with the release spikes.  Everything else seems to track with that as well, though I haven't done much with it.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 06, 2014, 09:20:03 pm
That's actually really interesting. Thanks!
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Xantalos on May 07, 2014, 12:34:18 am
Its less FG and more RP, actually. Realm of the mad god Rise of the magic girls has a ridiculous amount of posts for something that isn't a huge rtd or in general discussion, it has somewhere in the rage of 40-50% of the posts the happy thread has according the the bars in the stats center.
It's stupid huge.
Like the primary reason I'm not second highest post count on the forum right now huge.

I vary my FG&RP steroids.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Loud Whispers on May 07, 2014, 01:43:21 am
Starting in roughly 2014 we changed how members were registered because of the love bots -- about 2/3rds (very approximately) of the signups before then starting especially around 2011 were spammers.  Now they only get in every once in a while.  I'm still cleaning that up (I've deleted at least ten thousand accounts over the last couple years, and there's a lot left to go).  So total member counts are basically useless, though members online isn't really affected by spammers (except maybe that weird day).  As far as I can tell, the actual-people membership slowly increases, as does the people online, with the release spikes.  Everything else seems to track with that as well, though I haven't done much with it.
Christ, how do you even find that many bots?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: hops on May 07, 2014, 02:12:06 am
Sweet! I don't normally have time to check the stats since I'm usually only just refreshing some certain people's post history obsessively.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: i2amroy on May 07, 2014, 02:19:14 am
Christ, how do you even find that many bots?
It was pretty bad for a while. :P (And it wasn't helped that a fair share of the bots/bot-people would sign-up, and then wait for quite a while before actually posting anything).

IIRC it messed with the male:female report for the stats quite a bit as well. For some reason a huge chunk of the bots were declaring that they were female, and we got almost to a 3:1 male to female ratio for a while.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Toady One on May 07, 2014, 10:51:44 am
The vast (Vast) majority of the bots (or people-bot combos, or zombie crowd-sourced captcha or whatever undead cyborgey thing they are) never post.  They just set their website and/or their signature to link some place and never come back.  Then I get emails from either the person that did it or somebody that ends up with that domain two years later complaining about being black-listed by google and threatening me.  I find the largest groups of them when they fail to vary their IP addresses much.  The forum lets me do searches with IP wildcards, and zero posts, and hasn't logged on for a year, then I feel pretty confident just deleting page after page of random lowercase letter-number user names with the same variants on an email address.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: mastahcheese on May 08, 2014, 11:58:42 am
I have a much better question:

How do you find time to work on DF if you have to delete that many spambot accounts!?
From what I understand, he spends the first part of his day at home programming dwarf fortress pretty much with minimal interuption, and then later in the day he goes over to his brother Threetoe's place, and that's when he moderates on the forums, without being distracted by programming.
He just divides up his day, and manages his time really well.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Muz on May 08, 2014, 10:32:31 pm
I have a much better question:

How do you find time to work on DF if you have to delete that many spambot accounts!?

Probably wouldn't take long, like mopping the house or doing laundry. When you've deleted a thousand spambots, you learn to delete 10 thousand pretty quick :P
Title: Re: Bay12's posting history, a spreadsheet.
Post by: i2amroy on May 09, 2014, 02:10:17 am
On a slightly related note it appears that the post count for the DF Wiki discussion board is broken. The forum seems convinced that the board only has 3 total posts (despite having 152 topics) and thus anyone who has posted 3+ times in it automatically gets this:
Spoiler (click to show/hide)
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Putnam on May 14, 2014, 01:34:37 am
On a slightly related note it appears that the post count for the DF Wiki discussion board is broken. The forum seems convinced that the board only has 3 total posts (despite having 152 topics) and thus anyone who has posted 3+ times in it automatically gets this:
Spoiler (click to show/hide)

it's not just that one. (http://www.bay12forums.com/smf/index.php?action=profile;area=statistics;u=41416)  The new modding boards have the same issue.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Sappho on May 14, 2014, 01:49:17 am
Shame we don't have the older data, from before the forum switch. That was 2008, right? I'm curious how many members there were regularly online back when I joined...
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 18, 2014, 05:08:09 pm
I have switched the graphs from line graphs to scatter plots, because I think that it's a better representation of the data. What do you all think?
Edit: And yes, I am adding trendlines.

Shame we don't have the older data, from before the forum switch. That was 2008, right? I'm curious how many members there were regularly online back when I joined...
Yes, it would be pre-June 15th, 2008.
As a note about 2008 data, it's not on the sheet. Should I include it too?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on June 01, 2014, 01:53:51 pm
It's June 1st, which means last month's data has been solidified. Check it out!
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on July 07, 2014, 01:17:40 pm
Finally got around to entering June's data. (By which I mean that it's almost done, but I need to polish it up first.)
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on July 08, 2014, 01:45:50 am
holycrapwejustbeatthemostmembersonlineatoncerecord
itshouldbeuntouchable
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Putnam on July 08, 2014, 01:55:13 am
holycrapwejustbeatthemostmembersonlineatoncerecord
itshouldbeuntouchable

Biggest dwarf fortress update ever when the playerbase is the largest ever?

Yeah, I don't see why it wouldn't get broken.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on July 08, 2014, 02:01:12 am
Well, there has been no significant similar occurrence, so... eh?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on August 01, 2014, 01:30:29 pm
July's data is up. Except for stats.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: MaximumZero on August 07, 2014, 10:34:57 am
Ptw.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Dutchling on August 07, 2014, 11:44:46 am
Ptw.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on September 03, 2014, 11:52:58 am
Updated.

This month I tried to mess around in the Statistic Center's source code to see if I could automate the process, but I don't know shit about HTML. Does anyone know if it's possible to grab that data? Google and the SMF manual is being uncooperative.

In other news, what do you guys think of this project? Should I continue? Should I stop? Should I ramp it up? Do you want to contribute?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Dutchling on September 03, 2014, 12:16:32 pm
it's ok. sure. nah. maybe. lolnope.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on October 18, 2014, 10:05:42 am
Can someone yell at me in five hours to update this?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Tawa on October 18, 2014, 03:03:50 pm
<IT'S BEEN FIVE HOURS>
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on October 18, 2014, 03:34:30 pm
Thank you! Updated.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on November 03, 2014, 05:59:29 pm
Oh, ya. I updated it yesterday.
Also, I finally got around to adding the 2008 daily data. Still waiting for some time to do the monthly, though.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: MaximumZero on November 03, 2014, 06:02:52 pm
When is a graph updoot coming?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on November 03, 2014, 06:07:23 pm
The graph automatically updates the actual data, but I have to manually go in and change the dates. So graph update is here. Aesthetic update is when I get off my ass.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: MaximumZero on November 03, 2014, 06:19:18 pm
Why not write a script to do it for you?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on November 03, 2014, 06:23:00 pm
Because I haven't coded for years.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on January 01, 2015, 03:20:16 am
It's a new year, and I'd like to know if I should continue this.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: TheDarkStar on January 01, 2015, 09:34:18 am
Go ahead and continue this; it's interesting to see.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Yourmaster on January 01, 2015, 02:17:28 pm
Even in death, or lord GWG lives on! Hail the top post count!
Title: Re: Bay12's posting history, a spreadsheet.
Post by: USEC_OFFICER on January 01, 2015, 02:41:52 pm
Ia! Ia! GWG Fthagn! Ph'n- Eh, you get the joke. Though GWG's postcount will probably be topped by KJ before the year is out. So... he should enjoy it while he can?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Aklyon on January 01, 2015, 03:40:27 pm
Meanwhile, land of Lost Dimensions is still somehow stubbornly hanging onto its claim to a spot in the top 10 threads by posts. Good grief.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Doomblade187 on January 01, 2015, 05:49:58 pm
Do continue. It is very interesting.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on February 01, 2015, 05:02:43 pm
Updated.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on March 03, 2015, 03:41:51 pm
Can someone yell at me to update this tomorrow? Thanks.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Orange Wizard on March 03, 2015, 03:46:26 pm
Is it tomorrow yet?

Anyway, I find it really interesting how the "topics per month" is decreasing fairly rapidly, compared to posts, members, etc. which are all increasing steadily.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on March 03, 2015, 03:49:02 pm
Not for another 11 hours here.
Relevant. (https://www.youtube.com/watch?v=YuOBzWF0Aws)
Title: Re: Bay12's posting history, a spreadsheet.
Post by: penguinofhonor on March 03, 2015, 03:53:29 pm
.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Zrk2 on March 03, 2015, 04:57:18 pm
Anyway, I find it really interesting how the "topics per month" is decreasing fairly rapidly, compared to posts, members, etc. which are all increasing steadily.

I feel like that's because the amount of megathreads is increasing, and those cut down on new topics.

Also new users looks like it's been on a steady decline these past few years. That's probably part of it too - new topics seem to correlate with new members better than any of the other graphs.

Yeah. it's a tendency I don't like. I'd like to see the mega-thread die out because I find they kill off other interesting conversation because people always just say "stick it in the megathread" and then it does out after a page or two and that's that.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Orange Wizard on March 03, 2015, 05:16:59 pm
At the same time, though, those topics probably would have died out pretty quickly even if we didn't have the megathread thing. And discussions in the megathreads that people find interesting will spawn their own topics, which continue the conversation a while before - again - dying out because people no longer find it interesting.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Aklyon on March 04, 2015, 08:56:18 am
Can someone yell at me to update this tomorrow? Thanks.
Hey, update the thing.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on March 04, 2015, 05:26:41 pm
Right, updated the thing.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on April 04, 2015, 09:53:10 pm
April update. (https://docs.google.com/spreadsheets/d/1o7rk4oGTGNEJ4wD2NJJvjpg-da6s3nB90wPOiv4anNQ/edit?usp=sharing)


Observation: Daily data from New Members (Monthly too, but to a lesser, vaguer, extent) show a serious decline, now worth making "HMMMM" noises over.
Our lowest ever New Members in one day was October 23rd, 2008, with just one. There have been 2094 days between our last occurrence of only 4 new members in a day, June 28th, 2009 and March 23rd, 2015. The rest of the recent new member counts are back down to 2008/2009 levels. I realize this is mostly due to the lack of major releases, but it's still interesting.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Orange Wizard on April 04, 2015, 10:27:49 pm
You're right, new members is plummeting with the force of a thousand suns. Any ideas what's going on there?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: 4maskwolf on April 04, 2015, 10:50:20 pm
You're right, new members is plummeting with the force of a thousand suns. Any ideas what's going on there?
I'm... not entirely sure.  Maybe DF has reached it's publicity limit?  Maybe we're less inclusive than we used to be?  idk
Title: Re: Bay12's posting history, a spreadsheet.
Post by: i2amroy on April 05, 2015, 12:29:21 am
My guess is that since Toady implemented the requirement for accounts to be approved we're finally cutting out all of the many spam accounts that are joining the forum.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on April 05, 2015, 12:50:33 am
This is interesting. Toady, if you follow this thread, can you confirm this?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Flying Dice on April 05, 2015, 01:35:54 am
That'd be my guess as well. Remember, the dive started back around late 2013-early 2014ish regarding this:
Starting in roughly 2014 we changed how members were registered because of the love bots -- about 2/3rds (very approximately) of the signups before then starting especially around 2011 were spammers.  Now they only get in every once in a while.  I'm still cleaning that up (I've deleted at least ten thousand accounts over the last couple years, and there's a lot left to go).  So total member counts are basically useless, though members online isn't really affected by spammers (except maybe that weird day).  As far as I can tell, the actual-people membership slowly increases, as does the people online, with the release spikes.  Everything else seems to track with that as well, though I haven't done much with it.
combined with the relative length of time since a major update.

Basically I'd say that we're probably just approaching the point of being able to observe the effective member join rate. There probably won't be trustworthy data on that particular point until the new restrictions have been in place for enough time to generate sufficient points (so ~6-8 months probably), and when it's been that long I'd be willing to be that what it will look like will be fairly stable at lowish levels. Sort of what it looked like before the 2012 spike and at the moment, except with a bit fewer members; the curve on that graph is somewhat misleading, given that the spike is much sharper and either temporal end much flatter than it indicates.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 01, 2015, 01:45:41 am
Updated.
Nothing to report this month, it was kinda quiet.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Skyrunner on May 01, 2015, 04:31:19 am
Did someone say automation? I can automation.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 01, 2015, 01:18:27 pm
That's what I was trying to do with the sandbox tab, but I can't figure out how to remove the unfinished months and the year entries. Also, the data is displayed latest first, which isn't what I wanted, and I can't get the daily data.
If you want to try and automate it, I'll give you editing permission.
In fact, if anyone wants to just poke it, PM me a gmail address, and I'll give you editing permission.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Cryxis, Prince of Doom on May 10, 2015, 10:30:36 pm
Ptw
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 12, 2015, 05:29:59 am
I'm working on a new prediction algorithm to figure out how many posts will be submitted in a day.

Based on historical data and current trends, I'd give 60/40 odds that today's (May 12) post count will be between 2089 and 2489.

The way my algorithm works is by taking the differences in post count day by day from the last 6 years, turning them into a percentage of that day's posts, then averaging 4 days worth of those percentages over 6 years. This is intended to help accommodate for seasonal shifts. Then that average is multiplied by the previous day's post count, and used to predict the coming day's post count.

I can give a +-500 range of posts with 97.6% certainty, and a +-200 range of posts with a 58.3% certainty.
This translates to a 98.4% likelihood of predicting it within +-25%, and a 62.99% likelihood of predicting it within +-10%
It should be mentioned that these percentages are based off a 127 test sample, which is pretty small. I also screwed up some numbers, and after rerunning them in hopes of making it better, my certainty dropped. Hmm. I might need to peel off the 2014 data; it's the wrench in the works.

TL:DR and in plain English: I can guess how many posts are going to be made, but I can't tell you with much certainty. I can give you a 1000 post range for (almost) certain, but so can anyone else who takes 5 minutes to look at the data. It's the fact that I can predict a ~500 post range correctly 60% of the time has me really excited. It may not sound like much, but it's a start!

It's still being refined, but I have high hopes! I don't see getting much more than 75% certainty with my more precise criteria, but that alone would amaze me.

There's no reason this couldn't be applied to the other data sets, but I started with Posts/Day, since it's a much more tangible metric.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Cryxis, Prince of Doom on May 12, 2015, 07:08:37 am
This is almost encouraging me to post more or less by the end of the day or convincing others to do the same :p
Nah I'm not that mean
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 12, 2015, 07:17:24 am
I'm not worried. It would take considerable effort to influence the numbers enough. You could do it with 10 reasonably active posters doubling their average count for a day, but that's not an easy feat.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Zrk2 on May 12, 2015, 07:34:36 am
-snip-

Huh. That's pretty neat. Is the data more or less exponential?

I'm not worried. It would take considerable effort to influence the numbers enough. You could do it with 10 reasonably active posters doubling their average count for a day, but that's not an easy feat.

Challenge accepted?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 12, 2015, 07:38:58 am
-snip-

Huh. That's pretty neat. Is the data more or less exponential?
Not sure what you mean. There are no exponents involved, if that's what you're asking.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 13, 2015, 12:29:42 am
My algorithm predicted that we would make ~2289, give or take 200, posts on May 12th, and there were...

*Drumroll*

2204! 85 posts off is 3.7% off! That's good!

Tomorrow's estimate is 2179 posts. I'm expecting a range of +-218 posts, since that's 10%.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Orange Wizard on May 13, 2015, 04:41:01 am
Wow, cool.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 14, 2015, 02:28:58 am
1930 posts. Damn. That's 11% off, or 249 posts, but I was only 63% certain. I'll need to refine this, and compensate for different days of the week and months.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: mastahcheese on May 14, 2015, 04:47:29 pm
These calculations excite me.

I demand more predictions.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Pancakes on May 14, 2015, 05:39:33 pm
*The following is a demented view on how I think stats work

  I suppose one could calculate the average growth or decay rate of posts of an individual, particular board, make a prediction based on previous trends of that board, and sum them all to get a more precise prediction?

  Also, it might make it more accurate to claim (for example) that the announcements board will have 1 new post per month, with 100% accuracy, but other boards, like...DF Adventure Mode Discussion, might not be as reliable for post count records. To get rid of that problem, I assume, day-by-day variance should be analyzed to see which boards are most faithfully being posted in.

And, uh.... STANDARD DEVIATION! Right? Am I statistics now?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 14, 2015, 08:00:34 pm
These calculations excite me.

I demand more predictions.
I'm glad that they excite you! They excite me too!
May 14th's prediction is 1865. With 4 hours left in the day by the forum's count, and only 1662 posts made today, the prediction is probably going to a little low, but who knows?

  I suppose one could calculate the average growth or decay rate of posts of an individual, particular board, make a prediction based on previous trends of that board, and sum them all to get a more precise prediction?
Indeed you could, if the forum displayed stats like that. Sadly, it simply cumulates the data from all of the boards to give us blanket stats. If it gave individual board stats, then I would jump on that in an instant. I've looked for a way to make that work, but I've come back empty handed. This is what the stats look like, for reference. (http://www.bay12forums.com/smf/index.php?action=stats)
  Also, it might make it more accurate to claim (for example) that the announcements board will have 1 new post per month, with 100% accuracy, but other boards, like...DF Adventure Mode Discussion, might not be as reliable for post count records. To get rid of that problem, I assume, day-by-day variance should be analyzed to see which boards are most faithfully being posted in.
I already track day-by-day variance to make these predictions, but again, being able to access the individual board stats would be amazing.
And, uh.... STANDARD DEVIATION! Right? Am I statistics now?
You're pretty close! I'm not using Standard Deviations in this, because I don't find it really useful. It might work better with that, though. I'll have to try it out. Thanks for the idea!
Title: Re: Bay12's posting history, a spreadsheet.
Post by: TheDarkStar on May 14, 2015, 08:08:03 pm
You might not be able to get stats for all the threads, but the postcounts for the ten most posted-in boards are available.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 14, 2015, 08:19:55 pm
You might not be able to get stats for all the threads, but the postcounts for the ten most posted-in boards are available.
Yes, their total post count. However, I'm looking at daily posts, not total. THEORETICALLY, I could check them every 24 hours and figure the difference to get the daily posts in a board, but that's more maintenance work than I want to handle. Alternatively, it could be automated, but I don't have the skills to make that happen.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: penguinofhonor on May 14, 2015, 08:56:35 pm
.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 14, 2015, 11:20:26 pm
That's what I already do, sorta. I pull the data from 365 days prior, and then compare daily change. What I should do is pull data from 364 days, not counting leap years, of course, but that's a next step I'm not ready to put my brain to work on.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 15, 2015, 02:13:39 am
May 14th's prediction is 1865. With 4 hours left in the day by the forum's count, and only 1662 posts made today, the prediction is probably going to a little low, but who knows?
2065, exactly 200 off. :P 10% off aint bad.
May 15's prediction is 2035.7, but I'm expecting between 1875 and 2195, with about 50% certainty.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 16, 2015, 12:31:50 am
2018 posts! 18 posts off! .88% off!
May 16th, we should see ~2054 posts.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Zrk2 on May 16, 2015, 01:32:22 am
-snip-

Huh. That's pretty neat. Is the data more or less exponential?
Not sure what you mean. There are no exponents involved, if that's what you're asking.

That if one were to just plot the number of registrants/day it would form an exponential curve.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 16, 2015, 01:47:30 am
-snip-

Huh. That's pretty neat. Is the data more or less exponential?
Not sure what you mean. There are no exponents involved, if that's what you're asking.

That if one were to just plot the number of registrants/day it would form an exponential curve.
You mean just the New Members/Day, sans prediction? I've graphed that. (https://docs.google.com/spreadsheets/d/1o7rk4oGTGNEJ4wD2NJJvjpg-da6s3nB90wPOiv4anNQ/pubchart?oid=943924740&format=interactive) Or are you referring to something else?
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 17, 2015, 03:01:12 am
May 16th, we should see ~2054 posts.
2186 posts! I'm loving this accuracy.
~2164 posts on the 17th.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 18, 2015, 12:59:15 am
~2164 posts on the 17th.
1954. 9.7% off.

1951 for the 18th.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 19, 2015, 02:58:02 pm
1951 for the 18th.
2872 is very off.

So, what do you all want me to do with this predictive program? Continue to post predictions like this every day? Let it run in the background, gathering more data? I don't mind continuing, and I don't mind stopping.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Skyrunner on May 19, 2015, 11:58:27 pm
Collect data and do predictions for longer periods at a time.

Try developing better models.

Stuff like that. :v
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on May 20, 2015, 12:11:58 am
I can do that.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on June 01, 2015, 03:12:50 am
Updated!
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Orange Wizard on June 01, 2015, 03:43:45 am
Woo
Title: Re: Bay12's posting history, a spreadsheet.
Post by: Zrk2 on June 01, 2015, 01:10:19 pm
Huh, so growth has slowed? Intredasting.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on June 01, 2015, 01:18:48 pm
Well, that large hump is probably due to lots of spam bots. It's hard/impossible to tell how many of those are real.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: TheDarkStar on June 01, 2015, 04:25:55 pm
It's interesting to note that the forums membership is starting to go up at a faster rate.
Title: Re: Bay12's posting history.
Post by: Araph on July 02, 2015, 01:17:09 am
This tickles my morbid fascination with statistics. I don't fully understand all of those numbers, but I'm inexorably drawn to them.

So, what do you all want me to do with this predictive program? Continue to post predictions like this every day? Let it run in the background, gathering more data? I don't mind continuing, and I don't mind stopping.
Collect data and do predictions for longer periods at a time.

Try developing better models.

Stuff like that. :v

I second this motion.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on July 02, 2015, 02:59:28 am
Updated to June.
This tickles my morbid fascination with statistics. I don't fully understand all of those numbers, but I'm inexorably drawn to them.
I can explain them to you. That's half of why I'm here.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on August 02, 2015, 01:06:07 pm
I'll update when I get back home.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on August 09, 2015, 12:19:37 am
Updated the July.
Title: Re: Bay12's posting history.
Post by: Generally me on August 09, 2015, 05:58:02 am
Oh great Jifodus the lurker, Reveal thy self.
Title: Re: Bay12's posting history.
Post by: Graknorke on August 09, 2015, 06:36:03 am
Woo, fancy statistics. Definitely gonna be keeping track of what you do with them.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on September 01, 2015, 11:44:17 pm
Updated.
Title: Re: Bay12's posting history.
Post by: Zanzetkuken The Great on September 02, 2015, 12:14:01 am
You know, I really don't like the look of that decline.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on September 02, 2015, 09:50:50 am
Which one? They're all in decline. It's normal for it to have a downturn after a major release.
Title: Re: Bay12's posting history.
Post by: Zanzetkuken The Great on September 02, 2015, 03:43:24 pm
Which one? They're all in decline. It's normal for it to have a downturn after a major release.

The generalized decline of the line of best fit across nearly all charts.
Title: Re: Bay12's posting history.
Post by: PTTG?? on September 02, 2015, 10:33:37 pm
Good to know I'm still up there despite a substantial drop-off in activity.
Title: Re: Bay12's posting history, a spreadsheet.
Post by: My Name is Immaterial on September 03, 2015, 12:37:38 am
It's already been brought up. Here's what's been said.
Observation: Daily data from New Members (Monthly too, but to a lesser, vaguer, extent) show a serious decline, now worth making "HMMMM" noises over.
Our lowest ever New Members in one day was October 23rd, 2008, with just one. There have been 2094 days between our last occurrence of only 4 new members in a day, June 28th, 2009 and March 23rd, 2015. The rest of the recent new member counts are back down to 2008/2009 levels. I realize this is mostly due to the lack of major releases, but it's still interesting.
You're right, new members is plummeting with the force of a thousand suns. Any ideas what's going on there?
I'm... not entirely sure.  Maybe DF has reached it's publicity limit?  Maybe we're less inclusive than we used to be?  idk
My guess is that since Toady implemented the requirement for accounts to be approved we're finally cutting out all of the many spam accounts that are joining the forum.
That'd be my guess as well. Remember, the dive started back around late 2013-early 2014ish regarding this:
Starting in roughly 2014 we changed how members were registered because of the love bots -- about 2/3rds (very approximately) of the signups before then starting especially around 2011 were spammers.  Now they only get in every once in a while.  I'm still cleaning that up (I've deleted at least ten thousand accounts over the last couple years, and there's a lot left to go).  So total member counts are basically useless, though members online isn't really affected by spammers (except maybe that weird day).  As far as I can tell, the actual-people membership slowly increases, as does the people online, with the release spikes.  Everything else seems to track with that as well, though I haven't done much with it.
combined with the relative length of time since a major update.

Basically I'd say that we're probably just approaching the point of being able to observe the effective member join rate. There probably won't be trustworthy data on that particular point until the new restrictions have been in place for enough time to generate sufficient points (so ~6-8 months probably), and when it's been that long I'd be willing to be that what it will look like will be fairly stable at lowish levels. Sort of what it looked like before the 2012 spike and at the moment, except with a bit fewer members; the curve on that graph is somewhat misleading, given that the spike is much sharper and either temporal end much flatter than it indicates.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on October 04, 2015, 06:39:41 pm
Things have been updated.
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on November 09, 2015, 09:21:03 pm
PTW.
And did you put up the October stats?
Title: Re: Bay12's posting history.
Post by: Edmus on November 09, 2015, 10:21:06 pm
PTW, also. Those are some sexy graphs.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on November 10, 2015, 03:09:53 am
I haven't put October's data yet, because I totally forgot. Expect them soon*.
Those are some sexy graphs.
Someone who shares my wierd fetish!

*Soon may not refer to a time that is in the immediate future. Soon may refer to when OP decides to not be a bundle of sticks and get of his ass.
Title: Re: Bay12's posting history.
Post by: Dirst on November 10, 2015, 11:58:27 am
It looks like the prediction model is using a one-day trend.  Have you tried using more lags to build the estimate, and maybe dummy variables for the day of the week?  It would a pain in the ass to derive the coefficients with spreadsheet formulas, but the XL Miner add-on is free and should be able to handle at least linear regression.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on December 02, 2015, 12:13:09 am
*Clears throat*
AHHHHHHHHHHHHHHHHHHHHHH FINALS
AHHHHHHHHHHHHHHHHHHHHHH NO UPDATE UNTIL AFTER
AHHHHHHHHHHHHHHHHHHHHHH
Title: Re: Bay12's posting history.
Post by: Dirst on December 02, 2015, 12:39:10 am
I remember those.  Good luck!
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on December 07, 2015, 06:37:43 am
*prods*
Title: Re: Bay12's posting history.
Post by: SolarShado on December 11, 2015, 12:10:16 am
*prods*

Did you miss:
*Clears throat*
AHHHHHHHHHHHHHHHHHHHHHH FINALS
AHHHHHHHHHHHHHHHHHHHHHH NO UPDATE UNTIL AFTER
AHHHHHHHHHHHHHHHHHHHHHH
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on December 11, 2015, 12:14:55 am
No.

They've been active elsewhere.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on December 11, 2015, 01:06:08 am
Yeah, I'm just lazy, sorry. Update incoming.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on December 11, 2015, 01:52:25 am
And there's your update. (https://docs.google.com/spreadsheets/d/1o7rk4oGTGNEJ4wD2NJJvjpg-da6s3nB90wPOiv4anNQ/edit#gid=1222546767)
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on January 03, 2016, 12:05:51 am
I damaged my computer screen, so I'm afraid there'll be no updates until Monday or Tuesday.
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on January 03, 2016, 12:06:30 am
I will avoid repeating myself. (http://www.bay12forums.com/smf/index.php?topic=147892.msg6710756#msg6710756)
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on January 03, 2016, 01:44:02 am
Or Sunday, depending on whether the campus library is open
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on January 04, 2016, 01:02:25 am
Campus library wasn't open, computer isn't totally boned, so I found a work around. Updated.
Title: Re: Bay12's posting history.
Post by: Flying Dice on January 04, 2016, 10:31:15 pm
We're starting to see the expected uptick in activity due to the new version, it seems.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on January 04, 2016, 10:49:16 pm
Yep, that's the normal trend. It really throws a wrench into the gears of my prediction algorithms. I should probably try and exclude them from the data set.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: chaotic skies on January 31, 2016, 12:08:08 pm
I'm almost waiting for someone to come in and turn this into a learning AI. Then we're boned. Hard.

Also: Updoot plox?
Title: Re: Bay12's posting history.
Post by: Flying Dice on January 31, 2016, 12:23:00 pm
Yep, that's the normal trend. It really throws a wrench into the gears of my prediction algorithms. I should probably try and exclude them from the data set.
I'unno, once we've got enough points to reliably predict new versions it becomes less a problem and more a curious data feature. It wouldn't do to scrub data just because what we do see interferes with what we want to see.

Especially because we can look at stuff beyond new users to get a good idea of how many of those new users stick around.

By the by, your spreadsheets are all down.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on January 31, 2016, 01:11:33 pm
(I should have posted this right after I changed the title. :P)

The Statistics Center is a lie.

At the very top, it claims that this forum has an impressive 3,441,288 posts on it, but when you look deeper into the evidence, a horrible truth is revealed.

There is a massive post coverup.


Do you know how many total posts the top 1% of posters have? 3,804,342. Yeah, that's right.

The top 1% controls 110% of the Forum's posts.

But, if you dig into the secrets they don't want you to find (ie. the raw data), you'll find that the post count is actually a staggering 6,578,298 posts. Where did three million posts go? I don't know.

But I'm 110% sure the Illuminati is behind it.

Here's the raw proof. (https://docs.google.com/spreadsheets/d/1RBJ59b8CAiPs_gP59KJkJlZIozJT3tmwsA6SBK91huk/edit?usp=sharing)



Well, that's enough of that.

I'm almost waiting for someone to come in and turn this into a learning AI. Then we're boned. Hard.

Also: Updoot plox?
We won't die in a hail of nuclear fire, we'll die from heart attacks from too many cool graphs.
I don't update until the forum's internal date/time ticks over to February. We've still got about 11 hours left on the clock till then.

Yep, that's the normal trend. It really throws a wrench into the gears of my prediction algorithms. I should probably try and exclude them from the data set.
I'unno, once we've got enough points to reliably predict new versions it becomes less a problem and more a curious data feature. It wouldn't do to scrub data just because what we do see interferes with what we want to see.
It should be easier to just use the release log, instead of the post count to make predictions. I'll try and run up something to figure that out.
Especially because we can look at stuff beyond new users to get a good idea of how many of those new users stick around.
While I would love to figure out that, what should I use as a metric? The closest I can think is Users Online/Day. Maybe comparing the Posts/Day with the UO/D would give me a picture of that.
By the by, your spreadsheets are all down.
Really? Huh. Try this. (https://docs.google.com/spreadsheets/d/1o7rk4oGTGNEJ4wD2NJJvjpg-da6s3nB90wPOiv4anNQ/edit?usp=sharing)
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Graknorke on January 31, 2016, 01:26:33 pm
I am simultaneously disgusted and not at all surprised. This is exactly the kind of thing we'd expect from the capitalist wasteland of Bay12.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on January 31, 2016, 01:30:41 pm
I think it's more that SMF might just be unable to count.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Zanzetkuken The Great on January 31, 2016, 01:35:34 pm
Wonder if subboards, Armok 1 and the various nonsense would account for the discrepancy.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Flying Dice on January 31, 2016, 01:36:30 pm
There's likely some error due to hidden/locked boards and such. Maybe deleted threads/posts as well, I'm not sure how SMF stats handles those.

That's what I was thinking. Work out the new registered users/month for a given period of time--I'd probably count the 6mo after a release as being a release spike, since that roughly matches the spikes in registration. Then look at the average unique users online for the month prior to the period you're examining, compare that to the AUUO (say) one month after the end of a release spike. That'd probably give a decent read on how many regular users the forum picks up from each release. Maybe get your best numbers by comparing from 1mo prior to a given release against 1mo prior to the release after the first one, to get as close as possible to discounting people who eventually wander away.

Granted it's pretty much impossible to get a pinpoint accurate estimate on any of these various extrapolated statistics because of the sheer number of variables involved.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on January 31, 2016, 01:41:21 pm
I think it's more that SMF might just be unable to count.
That's just what they want you to think.
Wonder if subboards, Armok 1 and the various nonsense would account for the discrepancy.
[srs]I'm not seeing all of the subboards adding up to 3 million, but if you could check, I'd appreciate it.[/srs]
snip
I'll take a crack at it in a bit.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Loud Whispers on January 31, 2016, 02:03:07 pm
No no, it's fine, the post counts will trickle down to the escaped lunatics
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Shadowlord on January 31, 2016, 02:04:10 pm
What is this "statistics center" of which you speak?
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on January 31, 2016, 02:05:01 pm
The thing at the bottom of the top of the boards.


http://www.bay12forums.com/smf/index.php
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: wierd on January 31, 2016, 03:21:36 pm
Another potential source of the error is moderator deleted posts.

If the counter increments when they are posted, but does not de-increment when they are culled, then the values will quickly diverge.

If that is the case though, the descrepency would itself be an interesting data point.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on January 31, 2016, 03:22:28 pm
That doesn't add up.

50% of all posts having been deleted just doesn't make sense.

We must test this theory...
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Glloyd on January 31, 2016, 03:28:41 pm
tfw not in the top 1%.

Gotta start shitposting.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on January 31, 2016, 03:29:33 pm
tfw not in the top 1%.

Gotta start shitposting.
Good luck, dude.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Graknorke on January 31, 2016, 03:35:07 pm
We are the 1%. Tremble before our shitposts.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Aklyon on January 31, 2016, 04:07:20 pm
We are the 1%. Tremble before our shitposts.
And/or forum games.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Shadowlord on January 31, 2016, 04:33:40 pm
I appear to be halfway through the list there.

Are most of the people not on the list people who just posted a few things and then never came back?
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Zanzetkuken The Great on January 31, 2016, 04:49:31 pm
How long ago did ElfCollaborator bypass GreatWyrmGold?
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on January 31, 2016, 04:55:41 pm
Months or less.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Sacasco on January 31, 2016, 04:57:53 pm
Could it also be to do with how edits are handled?
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheDarkStar on January 31, 2016, 04:59:31 pm
How long ago did ElfCollaborator bypass GreatWyrmGold?

A few weeks ago.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Calidovi on January 31, 2016, 05:05:17 pm
Imagine what would happen if TBF's 64 post-per-day rate consisted of just shitposts from now on.

Spoiler (click to show/hide)
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on January 31, 2016, 05:08:16 pm
I appear to be halfway through the list there.

Are most of the people not on the list people who just posted a few things and then never came back?
Basically, but the list is thousands of people long, so it's hard to make sweeping statements about them.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on January 31, 2016, 05:08:31 pm
Aaaaa ha ha ha ha no.

Not gonna happen, I like posts with content in.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheDarkStar on January 31, 2016, 05:32:40 pm
Aaaaa ha ha ha ha no.

Not gonna happen, I like posts with content in.

I don't
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Orange Wizard on January 31, 2016, 05:53:11 pm
Aaaaa ha ha ha ha no.

Not gonna happen, I like posts with content in.
Dude you need to step up your shitposting game

have you considered participating in the Religion thread?
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on January 31, 2016, 05:53:51 pm
I already PTW'd there.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Orange Wizard on January 31, 2016, 06:00:17 pm
That doesn't count as shitposting
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Flying Dice on January 31, 2016, 06:19:06 pm
We are the 1%. Tremble before our shitposts.
And/or forum games.
You say that as if FFRP wasn't one of the several points of the pinnacle of shitposting.  :P
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on January 31, 2016, 06:23:18 pm
We are the 1%. Tremble before our shitposts.
And/or forum games.
You say that as if FG&RP wasn't one of the several points of the pinnacle of shitposting.  :P
Indeed.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Shadowlord on January 31, 2016, 06:32:18 pm
I already PTW'd there.

I wonder, if Toady made post count pay to win, would anyone pay for it? E.G $1/mo to inflate your post count by 1 each day. Want 1000 per day without having to make those posts? That'd be $1000.

This sounds more like a feature which you'd expect to find on Something Awful. I wonder if they already have it.  :P
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on January 31, 2016, 06:35:59 pm
Haaa ha ha ha.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Orange Wizard on January 31, 2016, 06:38:36 pm
I like posts with content in.
Indeed.
Haaa ha ha ha.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on January 31, 2016, 06:39:38 pm
I didn't say how much content.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheDarkStar on January 31, 2016, 07:01:59 pm
I didn't say how much content.

2/10 too much content in this post
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Glloyd on January 31, 2016, 11:48:42 pm
Looking through that list, I'm not too surprised by it. It's the people that I've seen all the time for the last 5 years or so since I started lurking here. Minus GWG naturally. But I'm surprised that people like GlyphGryph are still so high when they haven't frequented this forum in quite a while.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on January 31, 2016, 11:54:32 pm
It's really just everyone over 3k posts. It's about a year of solid posting.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Shadowlord on February 01, 2016, 12:12:34 am
You've just been posting for a long time. :P
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on February 01, 2016, 03:33:33 am
If anyone cares about the other work I do, here's my normal updates. (https://docs.google.com/spreadsheets/d/1o7rk4oGTGNEJ4wD2NJJvjpg-da6s3nB90wPOiv4anNQ/edit?usp=sharing)
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: ShadowHammer on February 02, 2016, 02:13:28 am
I don't remember if I've already said this, but this is super cool stats work, Immaterial! For some reason, I just love looking at those graphs. They're just so interesting!
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on February 02, 2016, 02:23:03 am
Thanks, man! I really appreciate it!
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Flying Dice on February 02, 2016, 03:15:51 am
MNiI does the work we're too lazy to do.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on February 02, 2016, 03:40:46 am
It's literally copying and pasting some lines of data. :P
If I wanted to be not lazy, I'd write a script to automate it.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: MaximumZero on February 07, 2016, 10:26:23 pm
RE: The List.

Oh, shit, I fell out of the top 30.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Flying Dice on February 07, 2016, 10:39:01 pm
Quick, start shitposting! It's the only way to save your e-peen!
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on February 07, 2016, 10:48:40 pm
The list is not live. Check the Members tab for the actual live list. You're still #30, MZ.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on February 08, 2016, 12:10:37 am
I'm creeping up the second page...Buwahahaha!
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Orange Wizard on February 08, 2016, 12:13:47 am
Quote
Posts: 15710 (70.134 per day)
Holy shit, why. What do you even do besides Bay12?
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on February 08, 2016, 12:14:49 am
School, life, etc.?

Although I will admit I don't get out much.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: SirQuiamus on February 08, 2016, 07:35:53 am
Hello
my name is
TheBiggerFish
and I
never
inflate my
postcounts.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on February 08, 2016, 07:58:05 am
Hello
my name is
TheBiggerFish
and I
never
inflate my
postcounts.
/me LOLs dismissively.  All posts made are real posts.

Nice trick with the timestamps though.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: MaximumZero on February 08, 2016, 09:40:14 am
The list is not live. Check the Members tab for the actual live list. You're still #30, MZ.
Ok. I'm okay with that, I guess. I've been the gatekeeper to the first page for a while now.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on February 08, 2016, 01:11:00 pm
Hello
my name is
TheBiggerFish
and I
never
inflate my
postcounts.
/me LOLs dismissively.  All posts made are real posts.

Nice trick with the timestamps though.
however, it's unrealistic: you can only make a post every fifteen seconds
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheDarkStar on February 08, 2016, 10:33:14 pm
Hello
my name is
TheBiggerFish
and I
never
inflate my
postcounts.
/me LOLs dismissively.  All posts made are real posts.

Nice trick with the timestamps though.
however, it's unrealistic: you can only make a post every fifteen seconds

It occurs to me that the 15-second limit sets the maximum number of posts per day per person to 5760.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on February 08, 2016, 10:44:33 pm
And that's with perfect accuracy.  I don't think I'm that good.  Or that prolific.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Glloyd on February 08, 2016, 10:51:50 pm
It occurs to me that the 15-second limit sets the maximum number of posts per day per person to 5760.

That's a whole other level of shitposting.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on February 08, 2016, 10:52:41 pm
Indeed.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Orange Wizard on February 08, 2016, 11:48:28 pm
Indeed.
All posts made are real posts.
see this is why people complain
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Glloyd on February 09, 2016, 04:34:37 am
Indeed.
All posts made are real posts.
see this is why people complain

Gotta start somewhere if you wanna get dat 5760.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: chaotic skies on February 13, 2016, 02:40:47 am
Now I'm waiting for their to be an unofficial thread where everyone has a bot auto-posting every 15 seconds exactly :P
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Orange Wizard on February 13, 2016, 03:26:47 am
We tried to make a Shitpost Thread, it was nuked almost immediately.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on February 13, 2016, 11:19:24 am
Darn.

Make it in FG&RP, it's more likely to slide under the radar?
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Arx on February 13, 2016, 11:51:36 am
http://www.bay12forums.com/smf/index.php?topic=37811.msg1086440#msg1086440

COUNTERPOINT
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Aklyon on February 13, 2016, 12:01:48 pm
Thats the sort of forum game that shows up anywhere though. We have ones that actually have a point, even if that point is just 'freeform themed rp in...this direction. With stats?'
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Zanzetkuken The Great on February 13, 2016, 01:19:44 pm
Now I'm waiting for their to be an unofficial thread where everyone has a bot auto-posting every 15 seconds exactly :P

Sourced from this tool? (http://www.bay12forums.com/smf/index.php?topic=155912.0)
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on February 13, 2016, 04:40:34 pm
Now I'm waiting for their to be an unofficial thread where everyone has a bot auto-posting every 15 seconds exactly :P

Sourced from this tool? (http://www.bay12forums.com/smf/index.php?topic=155912.0)
Yes, probably.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: chaotic skies on February 13, 2016, 05:32:17 pm
Probably quite easy, all things considered.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheDarkStar on February 13, 2016, 07:42:36 pm
What if someone makes a new account/a new person shows up and marathon-posts for 24 hours?
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Shadowlord on February 13, 2016, 10:55:41 pm
Is that who MoonyTheHuman is? (Except, over ~24 days instead of 24 hours, and no, I didn't count them, so I'm probably off by a few days)
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: chaotic skies on February 13, 2016, 11:00:02 pm
That's a damn impressive amount of caffiene, or a very sneaky bot. You might be able to do it by making a thread, and then using several bots all at once to simulate traffic and posts on the thread. Would look wierd as hell on the logs though.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: TheBiggerFish on February 13, 2016, 11:07:39 pm
MoonyTheHuman isn't a bot, they can respond intelligently.

What about them, again?
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: SirQuiamus on February 14, 2016, 09:59:08 am
Drunks and teenagers are indistinguishable from bots.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Orange Wizard on February 22, 2016, 02:57:31 am
I often mix up /r/circlejerk and /r/SubredditSimulator, FWIW.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Putnam on February 22, 2016, 03:13:04 am
circlejerk_SS is indistinguishable from the real thing, yeah.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on March 04, 2016, 12:26:45 am
Updated with February data.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Zanzetkuken The Great on March 04, 2016, 02:30:05 pm
I wonder what the chart displaying donated income would look like...
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on March 04, 2016, 02:54:27 pm
I'll put that together once I finish donating blood.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on March 04, 2016, 05:45:35 pm
Graph. (https://docs.google.com/spreadsheets/d/1eAZuOMhq4DrMRhBwyBm8rJIrqInM0HgGoaHd6GeV8TM/pubchart?oid=1328878545&format=interactive) Raw Data. (https://docs.google.com/spreadsheets/d/1eAZuOMhq4DrMRhBwyBm8rJIrqInM0HgGoaHd6GeV8TM/edit?usp=sharing)

Sorry about the delay. I tried to go and declare a minor, but it turns out that there are two versions of the minor, so I went to go get advice on which minor to take.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: Orange Wizard on March 04, 2016, 07:07:17 pm
Seems to be going up pretty steadily. Neat.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: chaotic skies on March 29, 2016, 09:26:43 pm
Hey! Update maybe? Soonish. Not quite the end of the month yet. :P
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on March 29, 2016, 10:04:28 pm
Soon. (http://www.timeanddate.com/countdown/generic?month=4&day=1&p0=64&font=cursive) I don't update until Forum time ticks over to the next month.
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: chaotic skies on March 29, 2016, 10:30:52 pm
That's cool, just wanted to know when I can expect the possibility of more statistics :)
Title: Re: Bay12's posting history: Toady is lying to us! WAKE UP, SHEEPLE!
Post by: My Name is Immaterial on March 29, 2016, 10:34:23 pm
49.5 hours or so.
Title: Re: Bay12's posting history: Shutting Down.
Post by: My Name is Immaterial on April 01, 2016, 10:54:21 am
Please ignore, misclick.
Title: Re: Bay12's posting history: Shutting down.
Post by: My Name is Immaterial on April 01, 2016, 11:14:40 am
After almost two years, I've come to a difficult conclusion. Providing this service is kind of tedious, frankly. Recently, I've just lost interest. I don't think I can maintain this any longer. Lots of people enjoy this, I know, but dropping it is what's best for me.
Feel free to run this in my stead, just shoot me a PM. Otherwise, let it languish, it's what's best. Obviously, it's not easy putting this down; it's occupied the last two years of my life. Lately, I've been reading Descartes, and I thought that this quote really resonated with me. "Sometimes, you have to read the first letter of every sentence."
Title: Re: Bay12's posting history: Shutting down.
Post by: Elephant Parade on April 01, 2016, 11:18:32 am
After almost two years, I've come to a difficult conclusion. Providing this service is kind of tedious, frankly. Recently, I've just lost interest. I don't think I can maintain this any longer. Lots of people enjoy this, I know, but dropping it is what's best for me.
Feel free to run this in my stead, just shoot me a PM. Otherwise, let it languish, it's what's best. Obviously, it's not easy putting this down; it's occupied the last two years of my life. Lately, I've been reading Descartes, and I thought that this quote really resonated with me. "Sometimes, you have to read the first letter of every sentence."
Spoiler (click to show/hide)
Title: Re: Bay12's posting history: Shutting down.
Post by: My Name is Immaterial on April 01, 2016, 11:22:21 am
Spoiler (click to show/hide)
Spoiler (click to show/hide)
Title: Re: Bay12's posting history: Shutting down.
Post by: TheBiggerFish on April 01, 2016, 11:46:38 am
It's April 1st...
Title: Re: Bay12's posting history: Shutting down.
Post by: Shadowlord on April 01, 2016, 11:49:02 am
Personally, I'm only surprised you didn't stop sooner.
Title: Re: Bay12's posting history: Shutting down.
Post by: Dirst on April 01, 2016, 01:13:31 pm
Personally, I'm only surprised you didn't stop sooner.
It's still April 1st :)

But I can see someone losing interest in a project after a while, particularly someone who has gotten busier recently (not sure if those exam-related interruptions were present from the start).
Title: Re: Bay12's posting history: Shutting down.
Post by: chaotic skies on April 01, 2016, 04:53:51 pm
Guys. Read the first letter of every sentence. Do it. Do it right now.
Title: Re: Bay12's posting history: Shutting down.
Post by: Orange Wizard on April 01, 2016, 04:55:52 pm
Top kek
Title: Re: Bay12's posting history: Shutting down.
Post by: Flying Dice on April 01, 2016, 06:34:50 pm
Spoiler (click to show/hide)
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on April 03, 2016, 01:53:22 pm
With the April fooling, I totally forgot to update. Fixed.
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on April 03, 2016, 02:42:16 pm
Link?
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on April 03, 2016, 02:50:39 pm
It's the same as always, and in the OP, but included for convenience. (https://docs.google.com/spreadsheets/d/1o7rk4oGTGNEJ4wD2NJJvjpg-da6s3nB90wPOiv4anNQ/edit#gid=1222546767)
Title: Re: Bay12's posting history.
Post by: TheDarkStar on April 03, 2016, 05:01:34 pm
Interesting. I wonder why there's a sudden spike in members online - I can't see anything obvious like a major release.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on April 03, 2016, 05:07:21 pm
It is curious, actually. It doesn't seem to match up with the release of 0.42.06 at all. Anyone have any ideas?
Title: Re: Bay12's posting history.
Post by: Elephant Parade on April 03, 2016, 05:14:55 pm
It is curious, actually. It doesn't seem to match up with the release of 0.42.06 at all. Anyone have any ideas?
If it's still going on, you might be able to get a clue by looking through the member list—you could see if they're upper-boarders, or lower-boarders, or spambots, or whatever.

Maybe DF was in the news again?
Title: Re: Bay12's posting history.
Post by: smirk on April 03, 2016, 05:17:59 pm
Looking in the data center, the spikes were on 2-17 and 3-13. Numbers jumped up, fell lower on 2-18 and 3-14 respectively, and were back to normal by 2-19 and 3-15. And it's just members online; there's no correlating spikes in new topics, new posts or new members (except for new posts on 3-13, which went up a paltry few hundred above normal).

DFhack or LNP releases, maybe?
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on April 03, 2016, 06:04:07 pm
The 3-14 might be thanks to LNP, but I can't speak for 2-19. It's still strange.
Title: Re: Bay12's posting history.
Post by: Dirst on April 03, 2016, 06:16:29 pm
Is it just that some activity got pulled forward by less than a day?  Any indication that posting patterns around midnight were odd?
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on April 03, 2016, 06:30:01 pm
Is it just that some activity got pulled forward by less than a day?  Any indication that posting patterns around midnight were odd?
IDK. All I know is that forum time is UTC-6.
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on May 02, 2016, 01:43:57 pm
Hey, it's May 2nd and all.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on May 02, 2016, 01:45:04 pm
So it is. Update in 6 hours.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on May 02, 2016, 06:41:40 pm
Updated.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on June 01, 2016, 01:37:44 pm
Updated. (https://docs.google.com/spreadsheets/d/1o7rk4oGTGNEJ4wD2NJJvjpg-da6s3nB90wPOiv4anNQ/edit?usp=sharing)

I've also started to poke around with the prediction algorithms again. Doing a field test today: the algorithm suggests that there should be between 1400 and 1746 posts today. The low number of posts on the 29th is weighting the data weirdly, but it's actually not affecting the prediction too much.

I've run the algorithm over the data for about a year and a half, and its margin of error is about +/- 225 posts, and an average of +/- 11% off. That's not really great yet. I'm still working on refining it; I'd really like to see the margin get down to +/- 100 posts.
Title: Re: Bay12's posting history.
Post by: chaotic skies on June 01, 2016, 02:04:08 pm
If you try hard enough and give the algorithm enough data you might be able to get the exact number a time or two
Title: Re: Bay12's posting history.
Post by: Dirst on June 01, 2016, 02:22:53 pm
Updated. (https://docs.google.com/spreadsheets/d/1o7rk4oGTGNEJ4wD2NJJvjpg-da6s3nB90wPOiv4anNQ/edit?usp=sharing)

I've also started to poke around with the prediction algorithms again. Doing a field test today: the algorithm suggests that there should be between 1400 and 1746 posts today. The low number of posts on the 29th is weighting the data weirdly, but it's actually not affecting the prediction too much.

I've run the algorithm over the data for about a year and a half, and its margin of error is about +/- 225 posts, and an average of +/- 11% off. That's not really great yet. I'm still working on refining it; I'd really like to see the margin get down to +/- 100 posts.
Right now your algorithm is averaging the past N daily differences to predict today's daily difference.  I suggest adding a couple low-hanging-fruit improvements to see if they help.  Statisticians call these control variables and data scientists call it feature augmentation.

Using the Sheets functions MONTH(date) and WEEKDAY(date), you can put the raw dates into categories.  Work out the average effect for all dates in that category, subtract out those expected effects, do your prediction on the residuals, then add the expected effects back in.  There is some art and some science to this.

I would expect the MONTH category to affect the average posting volume, but the WEEKDAY category might affect the average posting volume or the average difference.

Once you have one or two controls/features working, you'll find it much easier to test-drive others that might occur to you (release dates, FOTF replies, whatever).
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on June 01, 2016, 05:20:28 pm
Those are really good suggestions. Thank you! I'm going to slowly work towards rebuilding the algorithms to accommodate those.
Title: Re: Bay12's posting history.
Post by: MoonyTheHuman on June 01, 2016, 10:29:05 pm
Well, i might, for laughs, try and use a neural network to predict the contents of posts
Title: Re: Bay12's posting history.
Post by: chaotic skies on June 01, 2016, 10:33:05 pm
Dear god, I don't even want to hear about that thing in action.
Title: Re: Bay12's posting history.
Post by: Zanzetkuken The Great on June 01, 2016, 11:04:41 pm
Well, i might, for laughs, try and use a neural network to predict the contents of posts

Just feed everything in a relevant thread/board into the shitpost simulator and you should get some fairly accurate results, with some proofreading.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on June 01, 2016, 11:48:09 pm
Do it.
Title: Re: Bay12's posting history.
Post by: Aklyon on June 02, 2016, 01:09:10 am
Dear god, I don't even want to hear about that thing in action.
Depends on the source. Mafia posts would be much different from rp posts or emotion thread posts. FotF posts would probably be weird but interesing.
Title: Re: Bay12's posting history.
Post by: MoonyTheHuman on June 02, 2016, 01:16:05 am
Well, i might, for laughs, try and use a neural network to predict the contents of posts

Just feed everything in a relevant thread/board into the shitpost simulator and you should get some fairly accurate results, with some proofreading.
Sounds even better, and indont have to r program my network!
Title: Re: Bay12's posting history.
Post by: Orange Wizard on June 02, 2016, 01:25:38 am
Dear god, I don't even want to hear about that thing in action.
Depends on the source. Mafia posts would be much different from rp posts or emotion thread posts. FotF posts would probably be weird but interesing.
Posts from the politics threads, however, will be indistinguishable.
Title: Re: Bay12's posting history.
Post by: MoonyTheHuman on June 02, 2016, 01:31:41 am
Dear god, I don't even want to hear about that thing in action.
Depends on the source. Mafia posts would be much different from rp posts or emotion thread posts. FotF posts would probably be weird but interesing.
Posts from the politics threads, however, will be indistinguishable.
I bow down to you, master of colors and wizards
Bow down to the orange wizard! Bow!
Title: Re: Bay12's posting history.
Post by: Orange Wizard on June 02, 2016, 01:39:54 am
Fetch me some tea
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on June 02, 2016, 01:44:15 am
You have no power here, Citrus Mage! This is my realm, where I am like God!

Spoiler (click to show/hide)
Title: Re: Bay12's posting history.
Post by: MoonyTheHuman on June 02, 2016, 01:48:48 am
Yes, sir, Whos the bad man?
Title: Re: Bay12's posting history.
Post by: Orange Wizard on June 02, 2016, 02:01:03 am
You have no power here, Citrus Mage! This is my realm, where I am like God!

Spoiler (click to show/hide)
nur nur nur

nuuuuuuur
Title: Re: Bay12's posting history.
Post by: Arx on June 02, 2016, 03:28:14 am
Well, i might, for laughs, try and use a neural network to predict the contents of posts

Been there, done that, regrettably don't have the hardware to make a really stronk net. But I do have the software to!
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on June 02, 2016, 07:20:44 am
What.  What is this.  Is this.  Shitposting.  In this thread.
Title: Re: Bay12's posting history.
Post by: Aklyon on June 02, 2016, 07:40:08 am
Well, i might, for laughs, try and use a neural network to predict the contents of posts

Been there, done that, regrettably don't have the hardware to make a really stronk net. But I do have the software to!
You can't just 'done that' to us and not give us an example.
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on June 02, 2016, 07:43:25 am
There is a Bay12_SS thread somewhere.
Title: Re: Bay12's posting history.
Post by: Arx on June 02, 2016, 01:33:27 pm
Well, i might, for laughs, try and use a neural network to predict the contents of posts

Been there, done that, regrettably don't have the hardware to make a really stronk net. But I do have the software to!
You can't just 'done that' to us and not give us an example.

Here. (http://www.bay12forums.com/smf/index.php?topic=155912.msg6831214#msg6831214)

If I can unbreak the Linux on my gamingish machine I can CUDA it onto the GPU, but I haven't felt motivated to do that of late. I might give it another shot tomorrow, maybe.
Title: Re: Bay12's posting history.
Post by: Zanzetkuken The Great on June 03, 2016, 01:53:08 pm
Just noticed the 'gatekeeper' of the first page on the members list, based on post count, has shifted from Maximum Zero to HugoLuman.  Unless, of course, you count that position as the top of page 2.
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on June 03, 2016, 04:37:36 pm
700 posts or so to go until I make top ten posters.  Whoo-ee.
Title: Re: Bay12's posting history.
Post by: Elephant Parade on June 03, 2016, 04:43:37 pm
700 posts or so to go until I make top ten posters.  Whoo-ee.
If you hurry, you'll have made it there within one year of joining.
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on June 03, 2016, 04:47:42 pm
Yes, that's the point.
Title: Re: Bay12's posting history.
Post by: Zanzetkuken The Great on June 03, 2016, 04:49:48 pm
700 posts or so to go until I make top ten posters.  Whoo-ee.
If you hurry, you'll have made it there within one year of joining.

how the fuck...
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on June 03, 2016, 04:54:24 pm
700 posts or so to go until I make top ten posters.  Whoo-ee.
If you hurry, you'll have made it there within one year of joining.

how the fuck...
From the looks of it, an average of 83 posts per day.
That would be it, yes.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on June 03, 2016, 05:01:01 pm
More like 2000...
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on June 03, 2016, 05:13:08 pm
Not anywhere near 2000...
Title: Re: Bay12's posting history.
Post by: Dirst on June 03, 2016, 05:19:18 pm
Not anywhere near 2000...
It does help when you reply to every single thing that anyone ever says to you :)
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on June 03, 2016, 05:24:21 pm
Well yeah, but that's what one does, is it not?
Title: Re: Bay12's posting history.
Post by: Aklyon on June 03, 2016, 06:12:01 pm
Well yeah, but that's what one does, is it not?
Sometimes.
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on June 03, 2016, 06:22:24 pm
Well yeah, but that's what one does, is it not?
Sometimes.
I suppose there are times when one wouldn't want to reply.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on June 03, 2016, 09:25:27 pm
Not anywhere near 2000...
Depends on whether you count GWG (http://www.bay12forums.com/smf/index.php?action=stats) or not (http://www.bay12forums.com/smf/index.php?action=mlist;sort=posts;start=0;desc).
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on June 03, 2016, 10:24:33 pm
So I click the first link...
Quote
Total Posts:   3694444
This must have numerological significance...

Oh, I see.  You mean I need 2000 posts, not that I post 2000 posts per day :v
Title: Re: Bay12's posting history.
Post by: Dirst on June 06, 2016, 12:47:22 pm
I just noticed that the Bay 12 board (the one that's mostly monthly announcements) reports 49 posts in 100 topics.  This bothers me :(
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on June 07, 2016, 12:33:25 am
I just noticed that the Bay 12 board (the one that's mostly monthly announcements) reports 49 posts in 100 topics.  This bothers me :(
Uhhhh....Yeah, that's very strange.
Title: Re: Bay12's posting history.
Post by: Elephant Parade on June 07, 2016, 08:23:54 am
IIRC board postcounts got reset to 0 at some point; that's also the reason for the unusually high percentage-of-board's-posts values everyone has. I might be wrong, though.
Title: Re: Bay12's posting history. On Hiatus. Looking for Collaborators.
Post by: My Name is Immaterial on June 10, 2016, 11:50:58 pm
I have a job at a summer camp in the kitchen this year. There is no wifi within miles, much less a computer that I can actually use Google Sheets on properly. This means that I cannot update until that work is over. Apologies, but I will have to put this project on hiatus until mid-August.

HOWEVER, if anyone is interested in performing the updates in my stead, I'd welcome the help! The sooner you can reach out, the better.

[briefsentimentaldetour]
I also just wanted to say thanks for everyone's support/interest! I really enjoy being able to share my interest for this stuff with ya'll, and I wouldn't/couldn't do it without you.
[/briefsentimentaldetour]
Title: Re: Bay12's posting history. On Hiatus. Looking for Collaborators.
Post by: Orange Wizard on June 10, 2016, 11:57:31 pm
I'm torn between congratulating you on the job and cursing you for not providing me with delicious datas
Title: Re: Bay12's posting history. On Hiatus. Looking for Collaborators.
Post by: My Name is Immaterial on June 11, 2016, 12:07:50 am
(https://memecrunch.com/meme/2TZ37/why-not-both/image.jpg?w=479&c=1)
Title: Re: Bay12's posting history. On Hiatus. Looking for Collaborators.
Post by: chaotic skies on June 12, 2016, 03:32:39 am
I honestly have no idea how you're doing any of this, I just like looking at numbers and making assumptions that are entirely off by a mile. If I did know what's going on behind the scenes, I'd try to help.
Title: Re: Bay12's posting history. On Hiatus. Looking for Collaborators.
Post by: TheBiggerFish on June 12, 2016, 11:43:28 am
Well I'd offer but I have no clue what the carp you did, so yeah.
Title: Re: Bay12's posting history. On Hiatus. Looking for Collaborators.
Post by: My Name is Immaterial on June 12, 2016, 01:01:39 pm
Quote from: How to maintain the datasheet:
  • Go to the Statistics Center (http://www.bay12forums.com/smf/index.php?action=stats) after the end of the month in forum time. A new month should have started by now.
  • Scroll down to Forum History.
  • Copy the Summary for the month you want to input. This is the "[month] 2016" line, followed by the totals for the month.
  • Open the Spreadsheet (https://docs.google.com/spreadsheets/d/1o7rk4oGTGNEJ4wD2NJJvjpg-da6s3nB90wPOiv4anNQ/edit#gid=1222546767).
  • Open the Monthly Tab, and scroll down to the bottom.
  • Paste the data you just copied from the Statistics Center at the end of the data.
  • Open the Daily Tab, and scroll down to the bottom: ~2900
  • Expand the monthly summary in the Statistics Center.
  • Copy all of the data for the individual days.
  • Paste that data at the end of the data in the Daily Tab.
  • ???
  • Profit!
  • The charts should have automatically updated! Thank you for your help!

I've set the spreadsheet to allow anyone to edit, so go for it! Shoot me an email if you have any questions!
Title: Re: Bay12's posting history. On Hiatus. Looking for Collaborators.
Post by: TheBiggerFish on June 14, 2016, 01:25:51 am
I wonder how I'm doing on the making the top 10 front...

E:Or I could check for myself.  Less than 100 posts to displace Darvi.  That's not counting GWG.
Title: Re: Bay12's posting history. On Hiatus. Looking for Collaborators.
Post by: My Name is Immaterial on July 08, 2016, 09:53:32 pm
Briefly back in wifi. Just wanted to see if anyone had updated the spreadsheet in my absence.
Title: Re: Bay12's posting history. On Hiatus. Looking for Collaborators.
Post by: My Name is Immaterial on August 14, 2016, 10:48:29 pm
Well, time to blow the cobwebs off the old spreadsheets...
Updated.
Title: Re: Bay12's posting history. On Hiatus. Looking for Collaborators.
Post by: TheBiggerFish on August 15, 2016, 09:56:09 am
WB!
Title: Re: Bay12's posting history. Looking for Collaborators.
Post by: My Name is Immaterial on September 23, 2016, 01:21:59 am
Updated. Sorry about the lateness!
The update definitely doesn't have anything to do with the fact that I'm using it in a job application. Definitely not. Nooooooope. Nothing. Nada.

ohgodihopethisworks
Title: Re: Bay12's posting history. Looking for Collaborators.
Post by: TheBiggerFish on September 23, 2016, 07:55:38 am
Updated. Sorry about the lateness!
The update definitely doesn't have anything to do with the fact that I'm using it in a job application. Definitely not. Nooooooope. Nothing. Nada.

ohgodihopethisworks
That's cool!
Title: Re: Bay12's posting history. Looking for Collaborators.
Post by: Glloyd on September 25, 2016, 09:30:55 pm
Odd. I wonder why posts per month has been dropping so much even though new members and most members online are remaining relatively stable. The forum doesn't seem much less active to me from a year ago, but I never really go to the upper boards so I can't really say.
Title: Re: Bay12's posting history. Looking for Collaborators.
Post by: My Name is Immaterial on September 25, 2016, 09:39:28 pm
Those big spikes come from the upper boards. Almost anytime it crosses the red line, it's because Toady released an update, and it boosted the posts up. Things slowly cool down after an update, and then surge back up as soon as he updates it again.
Title: Re: Bay12's posting history. Looking for Collaborators.
Post by: Aklyon on September 25, 2016, 11:35:33 pm
Which makes sense for a board based on said game and its updates.
Title: Re: Bay12's posting history. Looking for Collaborators.
Post by: Dozebôm Lolumzalìs on September 26, 2016, 01:10:53 am
How steady are the lower boards, and do long-term trends in each board match?
Title: Re: Bay12's posting history. Looking for Collaborators.
Post by: My Name is Immaterial on September 26, 2016, 01:40:17 am
How steady are the lower boards, and do long-term trends in each board match?
You're asking questions about data that I can't access. The data is stored as a sum of all boards, I'm afraid. There's no breakdown by board, as much as I wish there was.
Title: Re: Bay12's posting history. Looking for Collaborators.
Post by: My Name is Immaterial on November 11, 2016, 01:11:45 am
Updated!
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on December 01, 2016, 02:39:43 pm
Updated!


I'm planning on making this update automatically, if I can. I've got winter break coming up, and that's on the to-do list. I'm also planning on asking Toady if there's a way to get a by board breakdown of the stats.
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on December 01, 2016, 09:13:15 pm
Whew!
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on January 05, 2017, 05:09:36 pm
Updated (https://docs.google.com/spreadsheets/d/1o7rk4oGTGNEJ4wD2NJJvjpg-da6s3nB90wPOiv4anNQ/edit?usp=sharing)!

2016 in review: Since the release of DF2014 0.42.01 in December 2015, activity has generally been slowing down. Certain metrics have been slowing much more than others:

I'm most concerned about Posts per Month, because most of the other metrics return to a floor, one set by activity on the lower boards, after the rush of DF discussion posts after updates. I don't know what the floor is here, so I'm getting worried as to how low the floor is for Posts per month.

In other news, Toady is on a 7 month ban-streak. C-c-c-combo!
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on January 06, 2017, 05:28:24 am
I believe it might have something to do with the rise in Discord use for idle chatter in FG&RP.
Title: Re: Bay12's posting history.
Post by: Inarius on January 06, 2017, 07:42:35 am
I'm happy to find this tread, I have been doing the same stats about the data for something like 2 years :)
It has more sense when you add a 365-day trend (less "accidents" like new versions or special events).


Perhaps you should add the donation data (published, each month, by Toady), that's (I think) really interesting, too.
There is a quite strong correlation between donations and activity (in general) until patreon came. After that, activity fell, and donations progressed.
Title: Re: Bay12's posting history.
Post by: Loud Whispers on January 06, 2017, 07:56:55 am
Hahaha I wonder if you can correlate ban streaks with world events
Title: Re: Bay12's posting history.
Post by: Skyrunner on January 06, 2017, 12:40:19 pm
I believe it might have something to do with the rise in Discord use for idle chatter in FG&RP.
Who's using discord for fgrp chatter?
Title: Re: Bay12's posting history.
Post by: Aklyon on January 06, 2017, 01:11:31 pm
Also, is it *a* discord for fgrp, or several little ones for individual rps?
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on January 06, 2017, 01:32:28 pm
I believe it might have something to do with the rise in Discord use for idle chatter in FG&RP.
Who's using discord for fgrp chatter?
Also, is it *a* discord for fgrp, or several little ones for individual rps?
Lots of the prolific posters, and several little ones.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on January 06, 2017, 05:48:52 pm
I believe it might have something to do with the rise in Discord use for idle chatter in FG&RP.
That's an interesting hypothesis. I'll have to look into it.

I'm happy to find this tread, I have been doing the same stats about the data for something like 2 years :)
It has more sense when you add a 365-day trend (less "accidents" like new versions or special events).


Perhaps you should add the donation data (published, each month, by Toady), that's (I think) really interesting, too.
There is a quite strong correlation between donations and activity (in general) until patreon came. After that, activity fell, and donations progressed.
That's awesome! Can I look at your data, to compare our methodologies?
I'll look into including that too! Thank you!

Hahaha I wonder if you can correlate ban streaks with world events
Almost certainly. I just don't really want to go there, ya know? That gets me a little too close to the action, which I like to stay far away from.
Title: Re: Bay12's posting history.
Post by: Zanzetkuken The Great on January 06, 2017, 06:20:41 pm
Here's a potential hypothesis:
The reduction in post count is a result a combination of the lower amount of new members, as those are the ones who would need the most help in learning the game and would make posts asking for it, combined with two factors from FG&RP: the utilization of discord for OOC chat for forum games, as well as some of the major players of RPs having started to burn out a bit.  A fair number of them have been around for quite some time and their post counts are in the tens of thousands with average counts in the dozens per day.  At those numbers, we should be seeing a bit of burnout eventually, and if there are few of similar disposition coming in, the high will start to drop off.
Title: Re: Bay12's posting history.
Post by: Inarius on January 08, 2017, 06:18:16 am
Quote
That's awesome! Can I look at your data, to compare our methodologies?
I'll look into including that too! Thank you!

Of course (and with pleasure ^^). I'll send it to you tomorrow.
When looking to the data, I felt it has some correlation with the number of people (weirdly, the better correlation was with the max online) on the forum.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on January 21, 2017, 12:03:41 am
Hahaha I wonder if you can correlate ban streaks with world events
Well, now's an excellent time to test this hypothesis. I didn't know BFEL very well, but I'm going to guess he was banned thanks to something to do with the inauguration?
Title: Re: Bay12's posting history.
Post by: itisnotlogical on January 21, 2017, 12:16:10 am
Flaming in the Ameripol thread, yeah. It's all deleted now.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on January 21, 2017, 12:44:24 am
Then, in this case, I think we can safely say yes, there is a correlation. We will have to conduct further research into this subject.
Title: Re: Bay12's posting history.
Post by: Inarius on January 22, 2017, 06:27:02 am
Oh, I forgot to send you my data :) I'll try not to forget a second time...
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on January 22, 2017, 06:46:34 am
No worries. When ever you get the chance would be great!
Title: Re: Bay12's posting history.
Post by: Aklyon on January 22, 2017, 08:42:48 pm
I woudn't be surprised if a significant percent of recent bans are ameripol-related.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on January 22, 2017, 09:08:36 pm
I woudn't be surprised if a significant percent of recent bans are ameripol-related.

Quote
Xeron      November 9, 2016      Ban      Trolling
Codician      November 9, 2016      Ban      Trolling
Vendayn      November 11, 2016      Ban      Trolling

I'm going to go with yes, they are.
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on January 23, 2017, 01:22:19 am
Also BFEL.
Title: Re: Bay12's posting history.
Post by: Elephant Parade on January 28, 2017, 10:37:53 pm
And mainiac, too.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on April 02, 2017, 07:38:29 pm
Oh jeez, I missed a few months.
General Update:

No major news from this front. An unexpected spike in new topics on the 27th of March, along with an odd increase in online members around that time. Any ideas as to what that could be? Did the forums get hit by spammers?


In other news, I took a class on how to run statistical regressions and model building, so:
I'm proud to reveal the first model of B12 Posting Trends!

Based on a regression of daily post counts from 1/1/2015 to 12/31/2016, the equation determining how many posts are expected on a given day is:
Quote
Posts =  2506.71 + 2.18*Days since last update + -283.18*February + -576.60*March + -615.83*April + -676.63*May + -762.90*June + -928.52*July + -1077.16*August + -1415.67*September +  -1341.61*October + -1552.25*November + -1115.57*December + 120.98*Monday + -101.43*Saturday + -11.37*Sunday + 65.69*Thursday + 121.15*Tuesday + 96.09*Wednesday
R2 = .5074
All variable except Sunday and Thursday are statistically significant at the 95% level.



So what the actual fuck did you just read?
I've created a statistical model to determine what factors affected the number of posts on a given day. I looked at a lot of factors, including ban records, update history, day of the week, and a dozen other variables that the math decided wasn't a significant factor. I settled on three variables that are able to predicted 50.74% of the variation in this data set: 1. Days since the last update. 2. Month of the year. 3. Day of the week.
The second two are broken up into what are called fixed effects, or binary variables: it is either Monday (Monday=1), or it is not (Monday=0). This is why there are 17 random variables sitting around; each one is 1 or 0 depending on the day or month you are trying to look at. You may also notice that January and Friday are omitted. This is because Stata, the program I am using, chooses a variable from the set of fixed variables, and sets all the other variables to be compared to that one. Basically, if you're looking at a Friday in January, just look at the constant term, and ignore the month/week variables.
THIS DOES NOT PREDICTED THE RIGHT NUMBER WITH 50% ACCURACY!!! R2 is a term used to determine how accurately a regression explains the variance of a data set. If I add a very significant variable that explains a lot of the variation, R2 will increase sharply. This model isn't a great one, because there are so many variables that I can't actually measure and include.


I also came up with a model for Monthly totals, but it's not great, and has poor predictive powers, so I'm not going to be talking about it until I've come up with a better one.


If you want to learn more, shoot me a PM, and I can walk you through it. Alternatively, you can check out the Excel sheets, Sandboxes 5 & 6, where I setup the models. I can also send over the raw Stata files if you want to take a look at them.
Title: Re: Bay12's posting history.
Post by: TheBiggerFish on April 02, 2017, 07:58:28 pm
Yes, there was a spambot in GD on that date.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on April 02, 2017, 08:33:31 pm
I guess that answers my unasked about whether or not deleted posts count towards the total. It seems that they do.
Title: Re: Bay12's posting history.
Post by: Elephant Parade on April 02, 2017, 10:39:32 pm
Yes, there was a spambot in GD on that date.
I guess that answers my unasked about whether or not deleted posts count towards the total. It seems that they do.
Has the Mystery of December Eighth finally been solved?!
Title: Re: Bay12's posting history.
Post by: Inarius on April 03, 2017, 02:16:57 am
The general trend is to have fewer and fewer posts, so I'm surprised that the "days" are with a positive coef, but I hadn't taken into account the "since last release" thing. I'm not sure if you could have a better r² with others coef. Good job for the "day-related" thing, anyway ! That's smart.
Title: Re: Bay12's posting history.
Post by: My Name is Immaterial on May 15, 2017, 08:53:00 pm
Updated (https://docs.google.com/spreadsheets/d/1o7rk4oGTGNEJ4wD2NJJvjpg-da6s3nB90wPOiv4anNQ/edit?usp=sharing)!

Updates on my side: my efforts to learn how to scrape the stats page with Python have been thwarted by pip refusing to update/install modules. Please send help.