Tool: Automatic vote tally

[Myrddraal]

Hello all,

I've made an excel sheet which is stuffed to the eyeball with formulas which automatically tallys votes for mafia game hosts.



As you can see the first thing the host has to do is insert the names of the players in the first column in alphabetical order. Then the host makes a copy of this template sheet each round. Each round the host notes down the votes of the players in the second column (being careful to use the same spelling as the first column).

The sheet then does the rest, creates a tally and lists who voted for the top 6 candidates automatically.

Hope this is useful.

http://www.filefactory.com/file/ah3g...TallySheet_xls


EDIT: note the intentional mistake in my screenshot: player 11's vote is not spelt correctly and so has not been tallied.