Hey y'all, recently I've been putting a lot of effort into automating my vote count process and I wanted to share the result of that for anyone who might get some use out of it.
Here is a template which you can copy.
https://docs.google.com/spreadsheets/d/ ... sp=sharing
Cliffnotes:
-This sheet will take your input of player votes in the vcEdit sheet and generate a vote count with bbcode formatting which is sorted and removes all players without votes in the formatted tab. You can then simply copy/paste that formatted sheet into a post and hit enter.
-This is specifically for games with 13 players. You can edit the sheet and the code to make it work with more or fewer players but it will not work out of the box.
-You can change the formatting or headers by putting your own inputs into the 1 or 3 row or the bottom 2 rows which are currently populated.
If you want to see a demo and hear me ramble on in much too much detail you can watch this video.
Hope this is of some help to people, just wanted to share it.
Vote Counting Google Sheet Automation
- Thestatusquo
-
Thestatusquo He/HimShea
- Thestatusquo
He/Him- Shea
- Shea
- Posts: 14371
- Joined: July 27, 2006
- Pronoun: He/Him
- Location: Chicago!
Vote Counting Google Sheet Automation
tout comprendre c'est tout pardonner- Firebringer
-
Firebringer Trail Blazer
- Firebringer
- Trail Blazer
- Trail Blazer
- Posts: 52591
- Joined: June 28, 2015
- Location: woofbringer
- Contact:
cool toolShow"You are the Joker of mafia players" - Oversoul
"last time I was scum with Firebringer
his first post in the scum PT was "yes I rolled scum!"
I decided to post "haha just don't post that in the main thread", but to get up to date on the main thread first.
His first post in the main thread was "yes I rolled scum!" -popsofctown- Thestatusquo
-
Thestatusquo He/HimShea
- Thestatusquo
He/Him- Shea
- Shea
- Posts: 14371
- Joined: July 27, 2006
- Pronoun: He/Him
- Location: Chicago!
- Firebringer
-
Firebringer Trail Blazer
- Firebringer
- Trail Blazer
- Trail Blazer
- Posts: 52591
- Joined: June 28, 2015
- Location: woofbringer
- Contact:
spreadsheetShow"You are the Joker of mafia players" - Oversoul
"last time I was scum with Firebringer
his first post in the scum PT was "yes I rolled scum!"
I decided to post "haha just don't post that in the main thread", but to get up to date on the main thread first.
His first post in the main thread was "yes I rolled scum!" -popsofctown - Firebringer
Copyright © MafiaScum. All rights reserved.
- Thestatusquo
- Firebringer
- Thestatusquo