Spreadsheet for Votecounts

[camn]

Hi guys.
I like spreadsheets.

This probably has been done- but I made this for my game and I thought I would post it here.
If you take the next post- QUOTE IT, then remove the quote tags...you have a tab-seperated txt file. If you paste it into any spreadsheet program, it will make you a little page. I use google sheets

You then cut and paste the players from the NOT VOTING row to the row where they are voting.. and fill in the countdown time.. and it will do all the adding and stuff for you. You just copy and paste whenever you want a count

A couple quirks-
--if you want Votecount Numbers up top (1.1, 1.2, etc).. you gotta change that manually.
--you have to adjust box D19 if you delete or add NUMBERS of players... so at the beginning of every day. Deadline too.
--mind the close-parenth in M17.. move it to M16 once half the players are voting.

You are Welcome!

[camn]

VOTE COUNT 1 . 1

Player

- =COUNTA(F3:L3) ( )

Player

- =COUNTA(F4:L4) ( )

Player

- =COUNTA(F5:L5) ( )

Player

- =COUNTA(F6:L6) ( )

Player

- =COUNTA(F7:L7) ( )

Player

- =COUNTA(F8:L8) ( )

Player

- =COUNTA(F9:L9) ( )

Player

- =COUNTA(F10:L10) ( )

Player

- =COUNTA(F11:L11) ( )

Player

- =COUNTA(F12:L12) ( )

Player

- =COUNTA(F13:L13) ( )

Player

- =COUNTA(F14:L14) ( )

Not Voting

- =COUNTA(F16:K17) ( Player, Player, Player, Player, Player, Player, Player,
Player, Player, Player, Player, Player, Player, )

With =COUNTA(B3:B14) alive, it takes =ROUNDUP((D19+0.5)/2) to Lynch
Deadline is in (expired on 2020-04-11 12:00:00)

[zoraster]

This is the one I've used for ages with some minor changes: https://docs.google.com/spreadsheets/d/ ... sp=sharing

The reason the counta thing didn't work was copy and pasting names, which was the quickest way I figured out to do it, messes with the formula.

Day 1

AngryPidgeon ( 0 )

[/color]

(L - 5 )

Blue Yoshi ( 0 )

[/color]

(L - 5 )

chkflip ( 0 )

[/color]

(L - 5 )

*** Deltabacon ( 4 ) ***

Blue Yoshi

chkflip

Deltabacon

Kid A

[/color]

(L - 1 )

GuyInFreezer ( 0 )

[/color]

(L - 5 )

Kid A ( 0 )

[/color]

(L - 5 )

PimHel ( 1 )

GuyINFreezer

[/color]

(L - 4 )

RandomYoshi ( 0 )

[/color]

(L - 5 )

thenewearth ( 0 )

[/color]

(L - 5 )

No Lynch ( 0 )

Not Voting ( 4 )

AngryPidgeon PimHel RandomYoshi thenewearth

Total Votes ( 9 )

Needed to Lynch [ 5 ]

Deadline: April 4th at 20:00 EDT

Normally, I don't copy the unvoted lines unless it's the start of the day.

[Cheery Dog]

Yeah the formula getting messed up by dragging names around is annoying.

I'll have to see if I can find the Macro I attempted to make that reset all the counta. I think it was failing because I also attempted to have the vote count number change (archived copies of the vote count - and be done by copying it down in the spreadsheet), sorting by votes and hiding those with none.

I'll recreate one for resetting counta

[Cheery Dog]

While it's not really that important, as both excel and google sheets would automatically update to include inserted/deleted rows in the 3-14 range
If you'd rather just hide the people as they die (and keep the lynch wagon or something) this formula will still work for B19

=SUBTOTAL(103,B3:B14)

Obviously don't use this if you're not copying the whole votecount.

[Cheery Dog]

okay my counta() actually seem to be working with the drag and drop approach today. I will assume that happened since I changed computers and now have 2013 excel, since the last time I did anything like it was an older version of excel.

Spoiler: basic Marco for older versions of excel

Sub CountA()
'
' CountA Macro
'

'
Range("D3").Select
ActiveCell.FormulaR1C1 = "=COUNTA(RC[1]:RC[9])"
Range("D3").Select
Selection.AutoFill Destination:=Range("D3:D14"), Type:=xlFillDefault
Range("D3:D15").Select
Range("D18").Select
ActiveCell.FormulaR1C1 = "=COUNTA(RC[1]:R[1]C[9])"
End Sub

Adjust as needed. I've already inserted a row because it's meant to have been made for 13 players.

I have no idea how to implement the similar thing in google sheets, it doesn't have a record function as far as I can see. (and I don't actually know how to code)

[Flubbernugget]

I wonder if this could be at all integrated into Thesp's automatic vote counter.

[camn]

I could try. Where is it? ill look.

[Flubbernugget]

I would have to search for it. To my knowledge the only front end to it is a text bar for a url. You would probably have to contact Thesp directly if you were interested in source code.

[camn]

K