- Messages
- 3,923
Hey everyone,
First off if someone wants to punt this thread elsewhere as it's not a game, that's cool, I just wanted to hit the target audience.
I've played a couple of Wolf games now, although not to great effect. My time just isn't conducive to reading the myriad shitposts and trying to determine what's an in-joke or not. Regardless, I still enjoy them and it's been stuck in my head for a while.
So I decided to go another angle and see whether I could build out some kind of statistic tracking to give a visual layout of the games and how they'd played out. I've tried a few different methods, one being @Crystal being awesome and giving me a way to export the threads as CSV files and then trying to scrape the "I vote for", etc. out of the post bodies. This hasn't proven very accurate in so far as the outcome of the game though, as people mentioning other's voting and stuff gives false positive results on the searches.
I have a first version I started working with using that fuzzy method, but I've noticed a couple of spots where it got the data wrong. I started trying to correct it ad hoc, but it'd probably be better to fix the input rather than continue to deal with it after. One or two things might have broken in the live version I have up as I was tweaking the data but didn't go back through to correct things in the layout afterwards. I think it's probably around Alu or Raine, who I'd tried to group/rename other usernames under just the one. Still, it gives the general idea of what I'm going for. You should still be able to click on most elements and filter the other sections down based on that data point, like clicking a username to get their played roles, posts in each game, etc.
Preliminary workup of what I'm going for (https://public.tableau.com/app/profile/benjamin.talbot/viz/GWF_Wolf/Dashboard1):
That's why I'm asking for help in cleaning this up and making sure the data is accurate, so that the dashboard items are on point. I've made a couple of Google Sheets which aim to track the major data around these games. I've only so far entered some data from @Zell 17 games but I tried to build it with forethought to include any @Fire Queen Mafia games, or any others people have or will run.
I am tracking;
Game
This is where I really need the most help. My intent is for this page to track the general flow and results of the game phases. I entered a couple of items from the first thread, but I haven't had time to crawl through them all and fill this in.
Role
I copied in everything from Zell's dictionary and then tried to separate out the different actions each role could do, though I did take a few liberties to try to differentiate a couple. The seer roles for instance, I defined as "Sense Team", "Sense Karma", and "Sense Role" to convey what information they were gathering. I also adjusted all the Wolf roles to be "Berserk Wolf", "Seer Wolf", "Trickster Wolf", etc.
Player
This one tracks all the players who participated in each game and their win/tie/loss/MVP stats. It's pretty straight forward; the only real caveat is that Alu should just be entered as Alu and not whatever fanciful name he's been burdened with at that time.
Action
This is perhaps the workhorse of the setup. I've tried to set it up to essentially read as a statement defining what that player did during that phase. The orange columns are ones that shouldn't be edited, although after a new entry is submitted via the form some of the formula may need to be copied over onto blank cells.
I'm not going to drop the links to the Google Sheets directly, but I'd like to give @Zell 17 and @Fire Queen access to begin with, as these are their games and it might potentially help track running the games a little easier. I could use perhaps another 2 people who'd be down to do some data entry and crawl through the old game threads to make sure they're tracked correctly. I think for Zell's games, the majority of the work would revolve around identifying the votes everyone made, either on an individual basis or at least the team votes for each phase. I have nothing tracked for Mafia though so all of those roles, etc. will need to be defined too.
If you'd like to take a look and help out with the data, please drop me a PM and I'll share the sheet links.
I imagine the layout is going to change some from what I've got shown above, just because I'd be changing the data source and would have to tweak some things anyway. I'm hoping I could get more granular on the details too but I honestly need to play with the data once it's standardized to see what I can make work. If anyone has any thoughts or ideas of what would be interesting to track for these games, please feel free to drop the suggestion to me and I'll see what I can make happen.
Any other thoughts are welcome too!
Thanks!
First off if someone wants to punt this thread elsewhere as it's not a game, that's cool, I just wanted to hit the target audience.
I've played a couple of Wolf games now, although not to great effect. My time just isn't conducive to reading the myriad shitposts and trying to determine what's an in-joke or not. Regardless, I still enjoy them and it's been stuck in my head for a while.
So I decided to go another angle and see whether I could build out some kind of statistic tracking to give a visual layout of the games and how they'd played out. I've tried a few different methods, one being @Crystal being awesome and giving me a way to export the threads as CSV files and then trying to scrape the "I vote for", etc. out of the post bodies. This hasn't proven very accurate in so far as the outcome of the game though, as people mentioning other's voting and stuff gives false positive results on the searches.
I have a first version I started working with using that fuzzy method, but I've noticed a couple of spots where it got the data wrong. I started trying to correct it ad hoc, but it'd probably be better to fix the input rather than continue to deal with it after. One or two things might have broken in the live version I have up as I was tweaking the data but didn't go back through to correct things in the layout afterwards. I think it's probably around Alu or Raine, who I'd tried to group/rename other usernames under just the one. Still, it gives the general idea of what I'm going for. You should still be able to click on most elements and filter the other sections down based on that data point, like clicking a username to get their played roles, posts in each game, etc.
Preliminary workup of what I'm going for (https://public.tableau.com/app/profile/benjamin.talbot/viz/GWF_Wolf/Dashboard1):
That's why I'm asking for help in cleaning this up and making sure the data is accurate, so that the dashboard items are on point. I've made a couple of Google Sheets which aim to track the major data around these games. I've only so far entered some data from @Zell 17 games but I tried to build it with forethought to include any @Fire Queen Mafia games, or any others people have or will run.
I am tracking;
Game
This is where I really need the most help. My intent is for this page to track the general flow and results of the game phases. I entered a couple of items from the first thread, but I haven't had time to crawl through them all and fill this in.
Role
I copied in everything from Zell's dictionary and then tried to separate out the different actions each role could do, though I did take a few liberties to try to differentiate a couple. The seer roles for instance, I defined as "Sense Team", "Sense Karma", and "Sense Role" to convey what information they were gathering. I also adjusted all the Wolf roles to be "Berserk Wolf", "Seer Wolf", "Trickster Wolf", etc.
Player
This one tracks all the players who participated in each game and their win/tie/loss/MVP stats. It's pretty straight forward; the only real caveat is that Alu should just be entered as Alu and not whatever fanciful name he's been burdened with at that time.
Action
This is perhaps the workhorse of the setup. I've tried to set it up to essentially read as a statement defining what that player did during that phase. The orange columns are ones that shouldn't be edited, although after a new entry is submitted via the form some of the formula may need to be copied over onto blank cells.
I'm not going to drop the links to the Google Sheets directly, but I'd like to give @Zell 17 and @Fire Queen access to begin with, as these are their games and it might potentially help track running the games a little easier. I could use perhaps another 2 people who'd be down to do some data entry and crawl through the old game threads to make sure they're tracked correctly. I think for Zell's games, the majority of the work would revolve around identifying the votes everyone made, either on an individual basis or at least the team votes for each phase. I have nothing tracked for Mafia though so all of those roles, etc. will need to be defined too.
If you'd like to take a look and help out with the data, please drop me a PM and I'll share the sheet links.
I imagine the layout is going to change some from what I've got shown above, just because I'd be changing the data source and would have to tweak some things anyway. I'm hoping I could get more granular on the details too but I honestly need to play with the data once it's standardized to see what I can make work. If anyone has any thoughts or ideas of what would be interesting to track for these games, please feel free to drop the suggestion to me and I'll see what I can make happen.
Any other thoughts are welcome too!
Thanks!
