Forum Mafia Spreadsheets

[ValeforRaine]

If you put different types on different pages, you just don't put players on that page who haven't been in one. Pretty simple, really. Then we could have a "master stats" page which could have just wins/loses/draws, which is mostly what I care about, personally. I usually just want to see my overall stats and have to check 3 different spreadsheets for it.

[MarcoTheRed]

Currently discussed topics:
Please answer with Yes/No and suggest your ideas.

1) Do you want a Master Stats page with the score of all games, regardless of their type?
2) Do you want all the Spreadsheets to be merged in a single one?
>> If you answered Yes, do you want a page for each type of FM Game (FM/CFM/SFM/TFM/GFM), instead of keeping them all in the same page?
3) Should UFM be removed?
4) Should all the Spreadsheets be formatted in the same way?

[ValeforRaine]

1) Yes, absolutely. This should exist 100%.
2) Yes, on separate pages. Or, at the very least, episodic games in one spreadsheet, everything else in another. 4 spreadsheets is excessive.
3) Yes; I never want to see Scraf's UFM game on my record again. (4 SPIES.)
4) Yes, I find some of them confusing currently and think that having the same formatting will make it easier for everyone to read.

[LeScraf]

1) Yes, absolutely. This should exist 100%.
2) Yes, on separate pages. Or, at the very least, episodic games in one spreadsheet, everything else in another. 4 spreadsheets is excessive.
3) Yes; I never want to see Scraf's UFM game on my record again. (4 SPIES.)
4) Yes, I find some of them confusing currently and think that having the same formatting will make it easier for everyone to read.

YOU WON, WHY ARE YOU UPSET

[MarcoTheRed]

We're currently working on the master score spreadsheet.
It's not complete yet.

-FM
Updated with VII C
Removed SFM from the spreadsheet.
Removed the score (It's on the master score)

-SFM
Added new spreadsheet

TFM
Updated with tfm 11
Removed the score (It's on the master score)

[edit as of 24/07/2015]

[MarcoTheRed]

-FM
Updated with Episode VII A

[Neasans]

That master score shows me as having lost a TFM, but I didn't.

[Gobln]

definitely should have that FM7 win.

[MarcoTheRed]

That master score shows me as having lost a TFM, but I didn't.

Should be fixed now

[MarcoTheRed]

Added Episode VII D

[Neasans]

Jacob replaced out of 7D, iirc.

[MarcoTheRed]

Added TFM 12
Added SFM 7
Moved the SFM info to the right spreadsheet (It was still on the FM one)

[FMLSheWas12]

I get two slots because I'm special.

[MarcoTheRed]

I get two slots because I'm special.

I'm blind lol.
Fixed.

[MarcoTheRed]

Updated with
-FM VII E; F; R
-SFM 8
-TFM 13

[SirCakez]

Slightly off topic question; what is UFM?

[MarcoTheRed]

UFM (unofficial forum mafia) were games that normal players hosted in the Forum Games section to play with new roles.
After a bit these games were banned by the mods because too many people were opening them (If I remember correctly), so CFM was born to achieve the same goal in a more organized way.

[MarcoTheRed]

Since Santa decided he doesn't want to update the CFM Spreadsheet anymore, we're looking for someone to replace him.
If you want to apply, please send me a PM.

A general guideline for the applications:
What's needed?
-Knowledge of FM official roles and rules.
-A basic understanding of simple formulas and page layout for Google Spreadsheets.
-Time. Each game takes about 30 minutes to update.
-Perseverance. You'll need to check the Game Threads every now and then to see if you need to update anything. Real life problems happen, so it's ok to take a break, as long as it doesn't take you months to update a game everytime.

If you made a Spreadsheet in the past, send the link(s) in the PM too.

Santa and I are going to judge who's the best candidate.

[MarcoTheRed]

atoonlinktothepast (who already had the GFM sheet) is going to keep the CFM sheet from now on and he'll take the NFM sheet too.
The link in the OP will be updated when he's done.

[atoonlinktothepast]

atoonlinktothepast (who already had the GFM sheet) is going to keep the CFM sheet from now on and he'll take the NFM sheet too.
The link in the OP will be updated when he's done.

On that subject - The New CFM Spreadsheet

CFM
- Added CFM7 - CFM9

OFM / Master Score
-Corrected CFM stats
-Added NFM

Let me know if there are any errors

[atoonlinktothepast]

CFM
- Added CFM10

OFM / Master Score
- Updated results under CFM

Let me know if there are any errors

[atoonlinktothepast]

NFM
- Added NFM1

OFM / Master Score
- Updated results under NFM

[Metrion]

CFM 10 is in the SFM spreadsheet.

[atoonlinktothepast]

CFM 10 is in the SFM spreadsheet.

That should be fixed now

[Metrion]

As well, TheCow won in SFM10 and LordofFail automatically lost as his slot was modkilled.

Keep up the great work guys.