Google Form Vote Counter

[zoraster]

Okay, so I've built a google form and spreadsheet that will do vote counts. Before the game each player gives a pin code to the mod who enters it in.

Votes are submitted by a google form here: https://docs.google.com/forms/d/e/1FAIp ... Q/viewform

It then allows the mod to output something like this every so often:

VOTING FORM

Current Vote Count

Please note that votes are not listed chronologically here.

Most Up to Date Votes

Previous 25 Vote Transcript

Spoiler: 25 Vote Transcript

Text Vote Count

Spoiler: Text Vote Count (For Vote Analysis)

Name Votes
Zoraster 2 Vi hitogoroshi
Vi 1 Zoraster
SpyreX 0
Gordon 0
Frank 0
hitogoroshi 0
Melvin 0
Sherry 0
Equinox 0
Untrod Tripod 0
Cameron 0
Elway 0
William 0

VOTING FORM

Two major problems at the moment and one minor one I'd like help with:

Major:
1. When the hammer is reached, the mod won't know about it if a vote is changed. The mod could go back and figure it out from the transcript, but this is designed to make life easier and be foolproof. Is there a google spreadsheet thing I can do to have a switch go if a certain value is reached that won't go back if the number goes down? In other words, I'd like Cell A1 (or whatever) to contain the # needed to lynch. IF Vote Total Cell is ever equal to or greater than A1, B1="Yes" EVEN IF Vote Total Cell is currently below A1.

2. The charts will automatically update based on current votes. The solution is to provide each time a text version of the vote count, which isn't hard to do (just a copy and paste job into the vote count post template), but it's not elegant. Not sure there's a good solution to this.

Minor:

The vote count doesn't show chronological votes. In the example, Vi will ALWAYS be to the left of hitogoroshi. This isn't a huge problem as time stamps and transcripts are provided, but it does remove one nice feature of hand-done vote counts.

---

It can work for up to 30 players with minor adjustments.

[zoraster]

yeah the problem isn't the if formula. it's that it'll display "Hammer" or whatever I want if and only if the value CURRENTLY is at hammer. Given that the vote count is in real time, anyone who votes off the hammered person will cause it not to read "Hammer" even though the hammer has been reached.

[zoraster]

can you walk me through those? I'm not much of a coder. I can give access to the current spreadsheet iteration.

Where I'd like to put the hammer trigger is in a sheet called

Vote Count Sheet 2

Cell C3.

---
I'm not sure what you mean by "straightforward string manipulation formulas"

[zoraster]

Right now my hammer trigger (that only shows when it is CURRENTLY hammer) formula is:

=IF(COUNTIF(B4:B34,">"&'Player Names'!E1)=0,"No Hammer","HAMMER HAMMER HAMMER")

Where B3:B34 is the vote per person, 'Player Names'!B1 is a cell that gives the number required to lynch (defaults to Players Alive/2 but can be manually set to something else).

[zoraster]

What are you trying to do to solve 2? Becuase I feel like #2's problem is very similar to #1s in that it's about capturing a certain point in time.

[zoraster]

Google Spreadsheets uses Google Apps script, which is based on Javascript

[zoraster]

Yeah. That's not what I'm looking for

[zoraster]

Why I feel that using this idea, there is a higher chance of accidental hammering?

Oh, there absolutely is if for no other reason than MS's post system stops you from posting when there's another post.

But that can be addressed in game rules.

[zoraster]

eh, probably not. Part of the reason to do this is to make vote counts more accurate and nearly instant. I suspect people would OFTEN vote both places but the only official one would be through the form.

What I meant by "rule" is you could put into place a rule that if a vote is the hammer placed within 5 minutes of the L-1 vote, a certain amount of time is given for the hammer voter to move off. Or some such. If that's a concern.

One other way to address it would simply be to use a different style of game, which is to make hammers not automatically end the day. Perhaps ending 24 hours after the Hammer is noted by the mod or something if and only if the hammer is still there.

[zoraster]

Major:
1. When the hammer is reached, the mod won't know about it if a vote is changed. The mod could go back and figure it out from the transcript, but this is designed to make life easier and be foolproof. Is there a google spreadsheet thing I can do to have a switch go if a certain value is reached that won't go back if the number goes down? In other words, I'd like Cell A1 (or whatever) to contain the # needed to lynch. IF Vote Total Cell is ever equal to or greater than A1, B1="Yes" EVEN IF Vote Total Cell is currently below A1.

Simple just make it so when hammer is reached it changes the cell that contains the formula that detects when the hammer is reached so it won't change the cell back if someone unvotes

i.e. in cell C6 put the formula that if any of cells B4:B34 becomes greater than the hammer number then delete the formula in c6 and change cell c6 to the word hammer, or even simpler just have it write the word hammer in cell c7 if any B4:B34 ever reaches the hammer number

how do I accompish that? Specifically get one formula to delete and replace another