Page 1 of 21

Forum Mafia Spreadsheets

PostPosted: Tue Jul 15, 2014 7:31 am
by atoonlinktothepast
The spreadsheets contain spoilers! Ongoing games: Don't discuss them until after they finish.

The Master Spreadsheet is where the W/L/D tallies from all games are listed. The spreadsheets will be updated when a game ends (with a delay depending on how much free time we have). Please check them in case there are any mistakes.

Ongoing:
Spoiler: Original (FM)- Amnesiacs, Executioners and Mafia (not Godfather) are listed with their starting roles, and conversions noted on a cell i.e. Framer to Mafioso.

Newcomer (NFM) - For those new to Forum Mafia, with inclusion of some veteran players.

Special (SFM) - May contain experimental roles, be hosted for special occasions or did not qualify for other game modes.

Vanilla (VFM) - Small games, minimal flavour text for rolecards.

Inactive / Infrequent:
Spoiler: Community (CFM) - Game ideas were pitched by players, with assistance and co-hosting from an FM Mod. Role changes are noted by: Original role | Converted role.
This game type has been retired.

Giant (GFM) - Games with multiple starting threads or a high player count. Games have been listed by cell colours, and each game has its own notes page.
Infrequent due to the high number of players required.

Tiny (TFM) - Games with smaller than standard player numbers.
This game type has been merged into SFM.

Who's hosting/editing the spreadsheets:
Spoiler: atoonlinktothepast - Master (hosting), Community, Giant, Vanilla
Parallax7 - Newcomer, Special
ICECLIMBERS - Original
non271103 - Tiny
All of the above - Master (editing)

Special mentions go to the previous editors (inc. Master): Santa07 [Community], Kirize12 [Vanilla], MarcoTheRed [Original, Special, Tiny], moonbird [Special, Tiny], EvanManManMan [Special], TorqueRxF [Newcomer], chitownmvp01 [Vanilla]

Re: Forum Mafia Spreadsheet

PostPosted: Tue Jul 15, 2014 8:06 am
by Rickdaily12
I like the spreadsheet. :) Just a couple things I think you should revise:

1. In Episode 1, Eevee the Executioner lost.
2. In Episode 3, Duck the Duck won? :P
3. Also in Episode 3, Icebolt's Jester win was revoked due to being hung in absentia and not choosing a Jester kill.

4. Lastly, you can just leave the Episodes (1A, 2A, 3A and so on), without the "A" bit, since they ARE the actual episodes that a Game B ends up following.


As far as a points system? There aren't any real rewards to winning that we are discussing at the moment, aside from the titles and the hall of fame (which now extends to this neat spreadsheet). However, a possible Victor's Village reaping may be in order... ;) ;) :mrgreen: :mrgreen:

Re: Forum Mafia Spreadsheet

PostPosted: Tue Jul 15, 2014 8:17 am
by MarcoTheRed
Rickdaily12 wrote:I like the spreadsheet. :) Just a couple things I think you should revise:

1. In Episode 1, Eevee the Executioner lost.
2. In Episode 3, Duck the Duck won? :P
3. Also in Episode 3, Icebolt's Jester win was revoked due to being hung in absentia and not choosing a Jester kill.

4. Lastly, you can just leave the Episodes (1A, 2A, 3A and so on), without the "A" bit, since they ARE the actual episodes that a Game B ends up following.


As far as a points system? There aren't any real rewards to winning that we are discussing at the moment, aside from the titles and the hall of fame (which now extends to this neat spreadsheet). However, a possible Victor's Village reaping may be in order... ;) ;) :mrgreen: :mrgreen:


1 Fixed
2 Fixed
3 Added a note. She tecnically won, even if she was prodded.
4 I made it like that for OCD :lol:

As for the point system, I know it doesn't award you anything, it's just to see who's the best player (like if we didn't know it's you <.<).

Re: Forum Mafia Spreadsheet

PostPosted: Tue Jul 15, 2014 8:21 am
by Rickdaily12
This one also slipped me by :P

SailorNeptune's original role in Game 2B was Executioner. Her target was Guzame/datdownie, but of course, they died, and she got jestered.

Re: Forum Mafia Spreadsheet

PostPosted: Tue Jul 15, 2014 4:05 pm
by LeScraf
Who will count for replacements? The replaced player or the replacer?

Re: Forum Mafia Spreadsheet

PostPosted: Tue Jul 15, 2014 4:09 pm
by MarcoTheRed
LeScraf wrote:Who will count for replacements? The replaced player or the replacer?


The replacer.

Re: Forum Mafia Spreadsheet

PostPosted: Tue Jul 15, 2014 4:19 pm
by Arckas
Love this . :)

But at the end of the games, if a mafia must replace the mafioso and become the mafioso, its not shown at the end of the game.

Re: Forum Mafia Spreadsheet

PostPosted: Tue Jul 15, 2014 4:32 pm
by LeScraf
MarcoTheRed wrote:
LeScraf wrote:Who will count for replacements? The replaced player or the replacer?


The replacer.


Then put me in there.
2D I was Doctor.
3C I was (I cannot disclose this information)

Re: Forum Mafia Spreadsheet

PostPosted: Tue Jul 15, 2014 5:52 pm
by TurdPile
You may want to stagger the rows for readability, IE every other row has a light gray background

Re: Forum Mafia Spreadsheet

PostPosted: Tue Jul 15, 2014 5:58 pm
by LeScraf
You should also put dead roles from current games on there, except maybe in grey since neither side has won yet.
BillyJoe won as Exe on 3B, so you'd put that one in green.
If someone is cleaned leave it blank or put (Cleaned)

Re: Forum Mafia Spreadsheet

PostPosted: Tue Jul 15, 2014 6:34 pm
by Veeena
Damn you Rick, having a 3-0 while I rock an 0-2

Re: Forum Mafia Spreadsheet

PostPosted: Tue Jul 15, 2014 6:46 pm
by Finn
Xfector might tie with Rick if town wins the game Rick is hosting D:

Re: Forum Mafia Spreadsheet

PostPosted: Wed Jul 16, 2014 5:09 am
by MarcoTheRed
Arckas wrote:Love this . :)

But at the end of the games, if a mafia must replace the mafioso and become the mafioso, its not shown at the end of the game.


On the first page there's always the graveyard. Some hosts, at the end of the game, transform any dead mafioso in their original role, some others don't. On IIB LoF didn't transform them, so I had to read the Mafia Night chat to understand the roles, for IIC I just asked to M4x, KTC and primorix.

M4xwell wrote:Damn you Rick, having a 3-0 while I rock an 0-2


Mafia is probably going to win Game IID so I'm going to join the 0-2 party. And you are going to join the 0-3 party :P

LeScraf wrote:
MarcoTheRed wrote:
LeScraf wrote:Who will count for replacements? The replaced player or the replacer?


The replacer.


Then put me in there.
2D I was Doctor.
3C I was (I cannot disclose this information)


LeScraf wrote:You should also put dead roles from current games on there, except maybe in grey since neither side has won yet.
BillyJoe won as Exe on 3B, so you'd put that one in green.
If someone is cleaned leave it blank or put (Cleaned)


It's just a bunch of extra work hahaha :P As soon as one of the games finishes I'm going to update the spreadsheet

TurdPile wrote:You may want to stagger the rows for readability, IE every other row has a light gray background


Thanks for the suggestion. I think it's much more readable now. :D

I also added a new page with some more information about the games.

Re: Forum Mafia Spreadsheet

PostPosted: Wed Jul 16, 2014 9:07 pm
by Alicitzen
Why is Metrion Amnesiac squared?
Seems odd.

Re: Forum Mafia Spreadsheet

PostPosted: Wed Jul 16, 2014 9:21 pm
by Metrion
Sarah Thorpe wrote:Why is Metrion Amnesiac squared?
Seems odd.


Because I became an Amnesiac, I forget?


(That used to go with a legend saying I turned to an invest, I can't find it anymore)

Re: Forum Mafia Spreadsheet

PostPosted: Thu Jul 17, 2014 1:07 am
by MarcoTheRed
Metrion wrote:
Sarah Thorpe wrote:Why is Metrion Amnesiac squared?
Seems odd.


Because I became an Amnesiac, I forget?


(That used to go with a legend saying I turned to an invest, I can't find it anymore)


I removed the legend and instead I put comments. Hover your mouse over your amnesiac cell.

Re: Forum Mafia Spreadsheet

PostPosted: Thu Jul 17, 2014 8:02 am
by MarcoTheRed
Updated with Ep III B!

Re: Forum Mafia Spreadsheet

PostPosted: Thu Jul 17, 2014 8:34 am
by Xfector
My Games Played and Wins is still 2.
I was in Ep III B D:

Re: Forum Mafia Spreadsheet

PostPosted: Thu Jul 17, 2014 8:57 am
by MarcoTheRed
Xfector wrote:My Games Played and Wins is still 2.
I was in Ep III B D:


Fixed. You are 3-0 like Rick!

Re: Forum Mafia Spreadsheet

PostPosted: Thu Jul 17, 2014 9:02 am
by Xfector
MarcoTheRed wrote:
Xfector wrote:My Games Played and Wins is still 2.
I was in Ep III B D:


Fixed. You are 3-0 like Rick!


Do i get a Trophy? :D

Re: Forum Mafia Spreadsheet

PostPosted: Thu Jul 17, 2014 9:18 am
by LeScraf
MarcoTheRed wrote:
Xfector wrote:My Games Played and Wins is still 2.
I was in Ep III B D:


Fixed. You are 3-0 like Rick!


Daaaaaamn Fector!

Re: Forum Mafia Spreadsheet

PostPosted: Thu Jul 17, 2014 9:32 am
by MarcoTheRed
Xfector wrote:
MarcoTheRed wrote:
Xfector wrote:My Games Played and Wins is still 2.
I was in Ep III B D:


Fixed. You are 3-0 like Rick!


Do i get a Trophy? :D


Not really :?

Re: Forum Mafia Spreadsheet

PostPosted: Thu Jul 17, 2014 11:51 am
by ObiWan
Can you add on there who the moderator was for each episode?

Re: Forum Mafia Spreadsheet

PostPosted: Thu Jul 17, 2014 12:03 pm
by Alicitzen
Am I seriously the only one on that spreadsheet to have been citizen twice :cry:
The jokes were right... :cry:

Re: Forum Mafia Spreadsheet

PostPosted: Thu Jul 17, 2014 12:07 pm
by MarcoTheRed
ObiWan wrote:Can you add on there who the moderator was for each episode?

Done!

Sarah Thorpe wrote:Am I seriously the only one on that spreadsheet to have been citizen twice :cry:
The jokes were right... :cry:

At least you won once :P