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