The Syndicate's Master Spreadsheet (W/L Record and P-Scores)
Posted: Mon Jun 29, 2015 12:09 pm
Hello, members of The Syndicate!
I have constructed and populated a spreadsheet, with much help from Epignosis and thellama73, that tracks everyone's games for P-Score and Hall of Fame purposes.
Orange games are Current Jobs (full games).
Yellow games are Side Missions (speed games).
Purple games are Special Games.
On the Hall of Fame tab, you can see which games you have played, but also which games you have won and lost:
"2" designates a win, color coded roughly to represent civilians, mafia, and independent/SK/other
"1" designates a loss
blank cell is not played or replaced out of the game
On the P-Score tab, you can see your P-Score and which games you have played:
"1" designates played and met the participation criteria
"0" designates played and failed to meet the host's participation criteria
blank cell is not played or replaced out of the game
For the Hall of Fame, I had to make exceptions for I believe two games to date, where hosts allowed players who replaced out to still win the game, so there is a slight discrepancy between P-Score and HoF for that reason. In addition, we decided not to count Minimalism or Omerta for P-Score purposes, since both games were designed to be more informal and encourage a lack of heavy participation.
This thread is really just for informative purposes, for anyone wanting detail on P-Scores or additional detail beyond what is shown in the Hall of Fame, as well as for those who are nerdy and love spreadsheets like me, and for other nerdy types with less spreadsheet love and more just all around mafia statistics love wanting to discuss win % and other statistics. On that note, I have created some filters that highlight the Win %, Win % for people who have played at least 2, 5, 10 games, etc. If any of you would like to see any others, let me know.
I have constructed and populated a spreadsheet, with much help from Epignosis and thellama73, that tracks everyone's games for P-Score and Hall of Fame purposes.
Orange games are Current Jobs (full games).
Yellow games are Side Missions (speed games).
Purple games are Special Games.
On the Hall of Fame tab, you can see which games you have played, but also which games you have won and lost:
"2" designates a win, color coded roughly to represent civilians, mafia, and independent/SK/other
"1" designates a loss
blank cell is not played or replaced out of the game
On the P-Score tab, you can see your P-Score and which games you have played:
"1" designates played and met the participation criteria
"0" designates played and failed to meet the host's participation criteria
blank cell is not played or replaced out of the game
For the Hall of Fame, I had to make exceptions for I believe two games to date, where hosts allowed players who replaced out to still win the game, so there is a slight discrepancy between P-Score and HoF for that reason. In addition, we decided not to count Minimalism or Omerta for P-Score purposes, since both games were designed to be more informal and encourage a lack of heavy participation.
This thread is really just for informative purposes, for anyone wanting detail on P-Scores or additional detail beyond what is shown in the Hall of Fame, as well as for those who are nerdy and love spreadsheets like me, and for other nerdy types with less spreadsheet love and more just all around mafia statistics love wanting to discuss win % and other statistics. On that note, I have created some filters that highlight the Win %, Win % for people who have played at least 2, 5, 10 games, etc. If any of you would like to see any others, let me know.