ITT We remind thesunfan that he hasn't finished the stat sheet
 

I deserve* to know just how statistically shit I am at the game.




*does not actually deserve shit

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

I’m definitely 0/6? This year lmao

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

hi sunfang whats up

see I added an n now its badass I hope you like it

finish the stats now

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

money on me having a higher winrate than you, the viewer

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

my money is on being at least slightly more likable.

I could win if it was that

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Finna bet I did the best outta all-y'all this year.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

hi im bad

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

look
its
going to happen
someday

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

please finish the stats sunfan

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Worst player ever, right here.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

If I can work my butt off to judge an entire batch in less than a week, you have the power to gib stat sheet before September. :^)

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

TWG should be a forum that you need to request access to so people dont see this smut on the main site

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

So is this a project that is already in progress? I like making charts and lists and things.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

I think he said at one point he had like the early games done and that he would get back to it and like

Never went back to it

And then everyone was sad because of it

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Aye, shut up ya poofter.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

I think at least part of it is to get new players occasionally; if it requires a bunch of extra steps, new people are less likely to play. I actually collapsed the FFR tab as I usually don’t read those threads myself, but I realize this might not be a viable option for all boards classed under “gaming.” I also don’t read sports but what I usually do is just, get this, ignore it and not click it.

Maybe try not clicking it instead of expecting an entire subset to move to seclusion for you.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

If the rest of the site has to deal with ur shit, I'm sure they can handle not clicking a thread they arent interested in

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Daaaaaaaaaaaaaaaaaaaaamn

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

I'd read twg smut over some of the gbin shit every day of the year

fucking awful

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

So what would be the desired amount of granularity?

Wolf wins/losses
Town wins/losses
3p wins/losses

Percentages for all of those individually and combined?

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

its not hard to make the threads not appear on the homepage sidebar of new threads, they already do that with the Ask me anything forum which makes alot less sense than them doing it for this subforum

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

LOL SUNFAN WITH THE ROAST IN A THREAD CALLING OUT SUNFAN

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Solution, make Ask Me Anything forum visible in sidebar.

Seriously, why are you trying to start something?

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

you're just mad because twg is popular
you're literally saying "it popular so it bad"
how about you fuck off out of twg subforum
or set your password to a random string and logout so we don't need to see your posts ever again

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Why would I want to make TWG threads not show up in the sidebar?

I actively want to continue to advertise TWG, not hide it.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Yesssssssssss

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

it was going to be something like

games played (not counting times you subbed out)
games subbed out
total wins
wins as each alignment

something like that for the baseline

EDIT:
games subbed out is a really hard stat to track, so maybe not even that
games finished would be more accurate at this point

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

where is games mislynched D0 ?

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

So uh

https://docs.google.com/spreadsheets...it?usp=sharing

(That covers all the games which are done, but not in the history for regular TWG. Now I can work backwards through the history thread.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

so is devonin doing the stats...........?

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Well, I'm doing some stats. What gets done with it after is *shrug*

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Thanks for stepping up for this. Are you able to do some ETL stuff, just to prepare the game results in a parseable/queryable format? If we have a repository or DB with the game outcomes, that would enable us to collaboratively conduct statistical analysis.

I tried in the past but parsing and cleaning the data was too strenuous to normalize, esp. when you consider oddball or bastard games.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

I mean...fundamentally no I can't really do much ETL stuff with this particular spreadsheet. I'm doing what it looked like was wanted which was just individual player stats for town, wolf, and 3p.

Depending on the kind of data you want access to, making another spreadsheet that was more easily used as a source for data extraction wouldn't be super hard to do.

Basically it would be a spreadsheet that had everything -but- individual player stats. Total players, size of each faction, which faction won, total phases etc. That could be pretty extractable for various bits of analysis.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Mfw

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Oh no, I was just suggesting that if you were calculating the stats from a parse you did already, it would be good to make that public

The harsh reality is that someone is gonna have to manually clean the dataset to have a robust, scalable stats potential. I might take a look at that this weekend to gauge how hard that would be. I might devise a simple schema that captures like, win/lose for each player, color, role, modkill, etc.

EDIT: But yeah the principle is as you described. Having a spreadsheet that has raw data means that you can make as many stats as you want, just query the spreadsheet when needed

DOUBLE EDIT: I might just straight-up ask the MafiaUniverse mods what schema they use for their native stats system. No need to reinvent the wheel

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

"A parse I did already"

*Is going manually game by game through the archive because that's the only way to get at ANY player stats at all*

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Yeah sorry I realized this afterwards ^^;;

thanks for this work, I'll see if I can extract the game data over the next few days and we can work together to get stats done

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

The problem is that this data isn't actually grabbable even if you were somehow trying to just extract it from a big text dump out of the archives, because it will say "Town wins" up at the top, but then for each individual player in the list, it doesn't say 'won' or 'lost' unless they survived to the endgame, otherwise it says 'killed' or 'lynched' and each line only says 'vanilla town' or 'wolf' if the game is basic. Often the role names in the archive are themed and so not clear whether they are town or wolf roles unless you're also checking whether there's any green or red text in the line etc etc.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

I will pay u to do this btw

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

paypal.me/devonin

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Savage.


On topic, wasn't Xiz doing stats for games way back when? I know when I was actively playing there was a TWG spreadsheet in google docs that showed things like win rate and etc.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

This is why my past attempts failed basically. I promised sunfan in the past that I would try to parse the game records and do the statistics entirely computationally. But there were too many edge cases in game design, as well as missing data from the history thread (I relied on BBCode color tags for alignment, for example, but this was unreliable because of ill-structured data)

To be clear, my suggestion is that I would manually tidy and collect the data and fit them to a specific schema, which then serves as a structured database which makes computational analysis easier

EDIT: MafiaUniverse has a fairly robust stats system built into the forum. This isn't possible for us, obviously, but I would like to see their schemas to inform a schema that we could adapt/steal for our own use on FFR

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Once I've passed through it all to do the player win/loss stats page, it would be easy to give you TWG local mod for the purpose of editing the threads in the archive to bring everything into line in terms of tagging and so on to make it easier to parse.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

The tidying doesn't have to be in-place, I was imagining just performing transcription on a text document or something. And then operating on the local transcription to produce database records.

Not that I'd ever pass up the chance to be a local mod fumu

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Between Game 161 and now there've been ~81 unique players (I assume several names are just weird other accounts of other people somebody will have to go clarify for me who they are)

Of the players who have 10+ games in that span, the top player so far is inDheart with a 71.43% winrate in 14 games. And the bottom player so far is wayward_vagabond with an 18.18% winrate in 11 games.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Talk to AA about that, he used to/does some stats stuff for MU

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

The best part of parsing the results is when the archive has results like this:
I have no idea who "Clownpiece heidy" and "27ninjabunnies the lone bunny" are.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

I love how in that game Yosh just gets to be himself lol

Edit: for what it's worth I have never used another account/name for TWG, so nothing in question is me.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Clownpiece heidy is probably clownpiece aka dude

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

similarly, 27ninjabunnies is 27ninjabunnies

makaze is the person to ask about the schema

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

"clownpiece aka dude" that still doesn't actually tell me much of anything.

Also: For weird non-standard games (Like CXIII: Capture, where everybody was on 2-person teams with no real factions) should those get logged as 3p or town do you think? I assume 3p.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

user Clownpiece here is someone that he also knows as Dude from other venues

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

Im happy nobody will know its me when i go on my alt Storn43.

Re: ITT We remind thesunfan that he hasn't finished the stat sheet
 

"StirGuruLar"