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

**XelNya** · 08-22-2019, 10:39 AM

Quote:

Originally Posted by Dinglesberry

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

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

fucking awful

**devonin** · 08-22-2019, 10:49 AM

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?

**Dinglesberry** · 08-22-2019, 12:20 PM

Quote:

Originally Posted by the sun fan

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

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

**Funnygurl555** · 08-22-2019, 01:46 PM

Quote:

Originally Posted by the sun fan

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

LOL SUNFAN WITH THE ROAST IN A THREAD CALLING OUT SUNFAN

**Charu** · 08-22-2019, 01:51 PM

Quote:

Originally Posted by Dinglesberry

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

Solution, make Ask Me Anything forum visible in sidebar.

Seriously, why are you trying to start something?

choof · 08-22-2019, 02:02 PM

Quote:

Originally Posted by Dinglesberry

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

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

**devonin** · 08-22-2019, 02:34 PM

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.

**MixMasterLar** · 08-23-2019, 12:30 AM

Quote:

Originally Posted by devonin

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?

Yesssssssssss

the sun fan · 08-23-2019, 12:56 AM

Quote:

Originally Posted by devonin

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?

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

**storn42** · 08-23-2019, 01:27 AM

where is games mislynched D0 ?

**devonin** · 08-23-2019, 01:24 PM

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.

**Funnygurl555** · 08-23-2019, 01:57 PM

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

**devonin** · 08-23-2019, 02:04 PM

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

DaBackpack · 08-23-2019, 02:22 PM

Quote:

Originally Posted by devonin

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

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.

**devonin** · 08-23-2019, 02:24 PM

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.

the sun fan · 08-23-2019, 02:51 PM

**Charu** · 08-23-2019, 02:53 PM

Quote:

Originally Posted by the sun fan

Mfw

DaBackpack · 08-23-2019, 02:57 PM

Quote:

Originally Posted by devonin

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.

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

**devonin** · 08-23-2019, 03:00 PM

"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*

DaBackpack · 08-23-2019, 03:03 PM

Quote:

Originally Posted by devonin

"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*

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

08-22-2019, 10:49 AM	#22
devonin Very Grave Indeed Join Date: Apr 2004 Location: Ontario, Canada Age: 42 Posts: 10,120	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?

08-22-2019, 02:34 PM	#27
devonin Very Grave Indeed Join Date: Apr 2004 Location: Ontario, Canada Age: 42 Posts: 10,120	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.

08-23-2019, 01:24 PM	#31
devonin Very Grave Indeed Join Date: Apr 2004 Location: Ontario, Canada Age: 42 Posts: 10,120	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.

08-23-2019, 02:04 PM	#33
devonin Very Grave Indeed Join Date: Apr 2004 Location: Ontario, Canada Age: 42 Posts: 10,120	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

08-23-2019, 02:24 PM	#35
devonin Very Grave Indeed Join Date: Apr 2004 Location: Ontario, Canada Age: 42 Posts: 10,120	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. Last edited by devonin; 08-23-2019 at 02:33 PM..

08-23-2019, 02:51 PM	#36
the sun fan FFR Player Join Date: Mar 2017 Age: 31 Posts: 445	Re: ITT We remind thesunfan that he hasn't finished the stat sheet Mfw __________________ TWG Stats: https://docs.google.com/spreadsheets...it?usp=sharing FFR is a pretty good place somehow.

08-23-2019, 03:00 PM	#39
devonin Very Grave Indeed Join Date: Apr 2004 Location: Ontario, Canada Age: 42 Posts: 10,120	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

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)