Mafia spreadsheets.
-
-
gslamm Goon
- Goon
- Goon
- Posts: 265
- Joined: July 14, 2003
- Location: NW AR, USA
Mafia spreadsheets.
Several people have mentioned using a spreadsheet of some kind to track information on their games. My questions are: What kind of info do you track? Why use a spreadsheet?(isn't that for number crunching) Whats the layout of your sheet look like?
I have a notebook beside the computer that I scratch down important events (who's dead) and statements, vote patterns and claims on. Very disorganized, hardly exhaustive, often wrong. Would appreciate some direction here.
[Disclaimer] The above post refers only to myself as a player. As a mod I'm on top of it. So go sign up for my regular mini. [/disclaimer][size=84]"Hmm, wow.. I'll just sit back and watch the stupidity continue to unfold.. "- genku Mixed Theme [/size]-
-
mole die suck die
- die suck die
- die suck die
- Posts: 825
- Joined: March 28, 2002
- Location: sydney
I really only use a spreadsheet when I'm modding, or if I want to work out some probability of something (say, of Mafia family 1 winning if they have two members and Family 2 has 3...) and I'm too lazy to write a program for it...
I remember a the players using them in Mini 2 (standard dethy^2*), in order to keep track of which combinations of roles fit with all the claims people made.
*For those who don't know standard dethy mafia, it's a five player game with 1 mafia, 4 cops of different sanities. Mini 2 had three mafia, and 9 cops of different sanities.-
-
shelper Moxious
- Moxious
- Moxious
- Posts: 411
- Joined: July 25, 2003
- Location: Netherlands
-
-
MeMe Post or Perish
- Post or Perish
- Post or Perish
- Posts: 10710
- Joined: October 6, 2002
- Location: Missouri
I track role claims, voting patterns, random notes, posting dates...Idefinitelycouldn't mod without one but would feel lost even just as a player without it. I don't know if you're @ all interested, but I could email you the way one of mine looks mid-game.
And as "why the spreadsheet" -- because it has cells of information, you can have a row for each player and even through a long game, the info stays all together (just clicking the pointer on a cell displays the entire contents therein without taking up all the screen space for everything).Remember...It's not a lie if you believe it. -- G. Costanza-
-
Fishbulb Mafia Scum
- Mafia Scum
- Mafia Scum
- Posts: 1322
- Joined: July 15, 2003
- Location: West Virginia, US
Maybe I should try something like that. It takes awhile to re-read the whole thread if a new player seems suspect. Especially helpful near end-game when you need to figure out who is together, and who isn't.
Now I am curious, MeMe. Mind sending me one? I'd like to see how the pros do it.[url=http://fishbulb515.blogspot.com/][b]Fishblog![/b][/url]-
-
mathcam Captain Observant
- Captain Observant
- Captain Observant
- Posts: 6116
- Joined: November 22, 2002
-
-
Macros Fear the Random Hobos
- Fear the Random Hobos
- Fear the Random Hobos
- Posts: 715
- Joined: April 6, 2002
- Location: everywhere
-
-
mathcam Captain Observant
- Captain Observant
- Captain Observant
- Posts: 6116
- Joined: November 22, 2002
-
-
Dragon Slayer It was THIS big!
- It was THIS big!
- It was THIS big!
- Posts: 1509
- Joined: June 15, 2002
- Location: USA (East)
-
-
JereIC Dr. Pants on Fire
- Dr. Pants on Fire
- Dr. Pants on Fire
- Posts: 874
- Joined: January 22, 2003
- Location: Washington, DC
-
-
Stewie Mafia Scum
- Mafia Scum
- Mafia Scum
- Posts: 2567
- Joined: July 16, 2003
- Location: Canada
-
-
shadyforce U-S-E_T-H-E_F-O-R-C-E
- U-S-E_T-H-E_F-O-R-C-E
- U-S-E_T-H-E_F-O-R-C-E
- Posts: 951
- Joined: August 21, 2003
- Location: Dublin
Heh, I'd like to see you keep a spreadsheet on Antrax's Mixed theme.
I do it all from memory except where I compile a list of things like rumours claimed in rumours.[size=75][color=darkblue]I'm never wrong... well I was wrong once but that was when I thought I'd made a mistake but hadn't.[/color][/size]-
-
Sugar moderately caffeinated
- moderately caffeinated
- moderately caffeinated
- Posts: 229
- Joined: September 15, 2002
- Location: Central USA
After seeing one of MeMe's spreadsheets months ago, I started doing the same. Now, I cannot imagine how I'd play without one. As many have said, it's practically impossible to mod without it. But when you're a player, it's great to have all the game info and your thoughts handy, especially to glance at before composing a post.[color=#500000] [size=75]Man! Today is so loopy! - The Tick[/size][/color]-
-
Dourgrim Yep. Again.
- Yep. Again.
- Yep. Again.
- Posts: 875
- Joined: February 12, 2003
- Location: Elkhorn, WI
-
-
PolarBoy Sir Not-Appearing-In-This-Mafia
- Sir Not-Appearing-In-This-Mafia
- Sir Not-Appearing-In-This-Mafia
- Posts: 358
- Joined: February 28, 2003
I've been been experimenting with playing with and without a spreadsheet, and I find that when I have the spreadsheet, I frequently mark things down that turn out to mean nothing later on, or I mark them unclearly and don't know what I was thinking when I wrote it. It's nice to have though to not have to back through the thread every time you want to remember a detail. I found that without the sheet I was more inclined to read the thread several times, which is good practice with or without the sheet, as there's no way you'll mark everything that turns out to be important. So I figure I'm gonna have to strike some happy medium. Just remember that it's dangerous to trust your notes implicitly, as you can make mistakes on them.MUNSCM Delegate for the United Kingdom
Check out the [url=http://www.mafiascum.net/cgi-bin/wiki.pl?HomePage]ScumWiki[/url], and while you're at it, check out [url=http://www.mafiascum.net/cgi-bin/wiki.pl?DocumentModeMafia]DocumentModeMafia[/url]-
-
Samadhi Townie
- Townie
- Townie
- Posts: 37
- Joined: May 3, 2002
- Location: What is A place where something is or could be located, Alex
-
-
mathcam Captain Observant
- Captain Observant
- Captain Observant
- Posts: 6116
- Joined: November 22, 2002
-
-
Quagmire Mafia Scum
- Mafia Scum
- Mafia Scum
- Posts: 2595
- Joined: July 15, 2003
- Location: HEH HEH HEH HEH HEH!!!!
-
-
Wacky Goon
- Goon
- Goon
- Posts: 866
- Joined: July 16, 2003
- Location: Sydney, Australia
I would love to see MeMe's example as well.
I used a spreadsheet when I modded and only for immensely complicated games (read: any game > 12 players) when I'm not mafia. And if its really complicated, I end up with 2 spreadsheets and 1 word document. Usually I get bored and dump it though.
Rereading also helps. More so than a spreadsheet. It's a matter of personal preference really....whatever remains, however improbable, must be the truth.-
-
Dasquian Mafia Scum
- Mafia Scum
- Mafia Scum
- Posts: 1430
- Joined: November 3, 2003
- Location: Guildford, UK
I have a gut feeling that keeping spreadsheets and notepads are usually going to lead you into dead-ends since context is so relevant to Mafia - then again, I don't really keep any notes as a player (as a mod, everything goes down in a big word doc) and, much to my shame, I'm a hideously unobservant player
Part of the problem is that I divide my time between home and work so I can't really keep documents updated that easily... I should try experimenting with notes to see how it goes.-
-
Thoth Not the spot
- Not the spot
- Not the spot
- Posts: 1424
- Joined: August 4, 2003
- Location: The Netherlands
I would like to see one of MeMe's sheets as well, but I can understand that she maybe doesn't want to send it to everyone.
I use a spreadsheet myself as well. 2 rows per player. 7 fixed columns and 4 'daily' columns, giving me 14 fixed cells and 4 cells for each day per player, with each cell a specific category(some categories need 2 cells). I mark down role claims, votes, vote counts, interesting posts, count of 'no content' posts, total posts, suspicious postnumbers(I would really like to see postnumbers get back in the threads, making this more easy), townie posts (hard to get), association and disassociaton with other players, and a few other categories that I'd like to keep to myself .-
-
Gammie Townie
- Townie
- Townie
- Posts: 70
- Joined: October 31, 2003
- Location: On my bum
I love Excel...I use it to keep track of who's suspicious, role claims, last post date, basically exactly everything MeMe said.
If I ever modded, I would probably use a Word Document instead to keep track of roles and make sure I have abigspace inbetween each role[size=75][b][color=gray]You miss 100% of the shots you├óÔé¼Ôäóll never take ├óÔé¼ÔÇ£ Wayne Gretzky
I├óÔé¼Ôäóm not dumb enough to be a goalie ├óÔé¼ÔÇ£ Brad Hull[/color][/b][/size]-
-
Norinel Not Voting (3)
- Not Voting (3)
- Not Voting (3)
- Posts: 1684
- Joined: March 2, 2003
- Location: My computer
-
-
shadyforce U-S-E_T-H-E_F-O-R-C-E
- U-S-E_T-H-E_F-O-R-C-E
- U-S-E_T-H-E_F-O-R-C-E
- Posts: 951
- Joined: August 21, 2003
- Location: Dublin
This is an example of the info I keep on a spreadsheet. I haven't finished a game using this yet, but when I do, I'll show you it.[size=75][color=darkblue]I'm never wrong... well I was wrong once but that was when I thought I'd made a mistake but hadn't.[/color][/size]-
-
Guest I've only played a few mafia games and am now (for the first time) trying to keep info in a spreadsheet. What I now have is digests of posts, so when the game drags on I can easily get a summary of posts. In addition I have a separate page with roleclaims.
I'm still not sure what the ideal is (although I feel a database thing would be better than a spreadsheet). If anyone else wants to post their spreadsheets, please do. I want to improve mine
Copyright © MafiaScum. All rights reserved.