Spreadsheet for Votecounts
- camn
-
camn soundtracker
- camn
- soundtracker
- soundtracker
- Posts: 7530
- Joined: April 14, 2008
- Location: GMT +9
Spreadsheet for Votecounts
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!Last edited by camn on Wed Mar 30, 2016 3:56 am, edited 2 times in total."if you weren't trying to be so unnecessarily mysterious all the time we wouldn't have these misunderstandings" - Yosarian2- camn
-
camn soundtracker
- camn
- soundtracker
- soundtracker
- Posts: 7530
- Joined: April 14, 2008
- Location: GMT +9
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)Last edited by camn on Wed Mar 30, 2016 3:55 am, edited 2 times in total."if you weren't trying to be so unnecessarily mysterious all the time we wouldn't have these misunderstandings" - Yosarian2- zoraster
-
zoraster He/HimDisorganized Crime
- zoraster
He/Him- Disorganized Crime
- Disorganized Crime
- Posts: 21680
- Joined: June 10, 2008
- Pronoun: He/Him
- Location: Belmont, CA
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.
Normally, I don't copy the unvoted lines unless it's the start of the day..- Cheery Dog
-
Cheery Dog Kayak
- Cheery Dog
- Kayak
- Kayak
- Posts: 8036
- Joined: June 30, 2012
- Location: OMG BALL!
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 countaHolder of the Longest Continuous Weekly Mafiascum Post Record. 1 July 2012 - 16 Feb 2023
*It may be held by someone else if you discount the major downtime in 2012 and 2014, I'm not doing the research.- Cheery Dog
-
Cheery Dog Kayak
- Cheery Dog
- Kayak
- Kayak
- Posts: 8036
- Joined: June 30, 2012
- Location: OMG BALL!
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.Last edited by Cheery Dog on Wed Mar 30, 2016 12:58 pm, edited 1 time in total.Holder of the Longest Continuous Weekly Mafiascum Post Record. 1 July 2012 - 16 Feb 2023
*It may be held by someone else if you discount the major downtime in 2012 and 2014, I'm not doing the research.- Cheery Dog
-
Cheery Dog Kayak
- Cheery Dog
- Kayak
- Kayak
- Posts: 8036
- Joined: June 30, 2012
- Location: OMG BALL!
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
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)Holder of the Longest Continuous Weekly Mafiascum Post Record. 1 July 2012 - 16 Feb 2023
*It may be held by someone else if you discount the major downtime in 2012 and 2014, I'm not doing the research.- Flubbernugget
-
Flubbernugget Survivor
- Flubbernugget
- Survivor
- Survivor
- Posts: 11751
- Joined: June 26, 2014
- camn
-
camn soundtracker
- camn
- soundtracker
- soundtracker
- Posts: 7530
- Joined: April 14, 2008
- Location: GMT +9
- Flubbernugget
-
Flubbernugget Survivor
- Flubbernugget
- Survivor
- Survivor
- Posts: 11751
- Joined: June 26, 2014
Copyright © MafiaScum. All rights reserved.
- Flubbernugget
- camn
- Flubbernugget
- Cheery Dog
- Cheery Dog
- Cheery Dog
- zoraster
- camn
- camn