EB Mafia

Professional Engineer & PE Exam Forum

Help Support Professional Engineer & PE Exam Forum:

This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.
I'm fine with you keeping the sheet as is, to keep track of making sure everyone voted, but can you maybe have a tally at the bottom?  Just so I can easily/quickly see what the numbers are?
Ive been toying with a good way to do that in the spreadsheet but it might turn out to be a manual tally. 

 
 


12/15


 


Players


Day 1 Votes


 


tj_PE


 


0


rebecca1


 


0


DuranDuran


EyehatethePEexam


0


vhab49_PE


JayKay PE


0


jean15paul_PE


 


0


NikR_PE


RoarBark


0


chart94


 


0


squaretaper LIT AF PE


fowler


0


JayKay PE


ChebyshevII PE


1


RBHeadge PE


 


0


LyceeFruit PE


RoarBark


1


txjennah PE


 


0


Roarbark


harshaPEAZ


4


Dothracki


 


0


EyehatethePEexam


ChebyshevII PE


0


fowler


LyceeFruit PE


2


ChebyshevII PE


RoarBark


2


CUniverse


 


0


MadamPirate PE


 


0


harshaPEAZ


Roarbark


1


TrickShotG


fowler


0



=SUMPRODUCT(COUNTIF(data,data)) works for the counting.

 
 


12/15


 


Players


Day 1 Votes


 


tj_PE


 


0


rebecca1


 


0


DuranDuran


EyehatethePEexam


0


vhab49_PE


JayKay PE


0


jean15paul_PE


 


0


NikR_PE


RoarBark


0


chart94


 


0


squaretaper LIT AF PE


fowler


0


JayKay PE


ChebyshevII PE


1


RBHeadge PE


 


0


LyceeFruit PE


RoarBark


1


txjennah PE


 


0


Roarbark


harshaPEAZ


4


Dothracki


 


0


EyehatethePEexam


ChebyshevII PE


0


fowler


LyceeFruit PE


2


ChebyshevII PE


RoarBark


2


CUniverse


 


0


MadamPirate PE


 


0


harshaPEAZ


Roarbark


1


TrickShotG


fowler


0



=SUMPRODUCT(COUNTIF(data,data)) works for the counting.
you have zeros where you should have ones.

and a 4 next to someone who should have a 1 

 
Better @LyceeFruit PE?


 


 


12/15


Player Tally


Player


Votes For


0


tj_PE


 


0


rebecca1


 


0


DuranDuran


EyehatethePEexam


0


vhab49_PE


JayKay PE


0


jean15paul_PE


 


0


NikR_PE


RoarBark


0


chart94


Dothracki


0


squaretaper LIT AF PE


fowler


1


JayKay PE


ChebyshevII PE


0


RBHeadge PE


 


1


LyceeFruit PE


RoarBark


0


txjennah PE


 


4


Roarbark


harshaPEAZ


1


Dothracki


 


0


EyehatethePEexam


ChebyshevII PE


2


fowler


LyceeFruit PE


2


ChebyshevII PE


RoarBark


0


CUniverse


 


0


MadamPirate PE


 


1


harshaPEAZ


Roarbark


0


TrickShotG


fowler


 


 


 


 


Projected Town Vote:


Roarbark

 
Ok ok, I'm done playing around with the spreadsheet. Since it's confused a lot of you here's an example for the votes against Roarbark.


 


 


12/15


Vote Count


Player


Votes For


0


tj_PE


 


0


rebecca1


 


0


DuranDuran


EyehatethePEexam


0


vhab49_PE


JayKay PE


0


jean15paul_PE


 


0


NikR_PE


RoarBark


0


chart94


Dothracki


0


squaretaper LIT AF PE


fowler


1


JayKay PE


ChebyshevII PE


0


RBHeadge PE


 


1


LyceeFruit PE


RoarBark


0


txjennah PE


 


5


Roarbark


harshaPEAZ


1


Dothracki


 


1


EyehatethePEexam


ChebyshevII PE


2


fowler


LyceeFruit PE


2


ChebyshevII PE


RoarBark


0


CUniverse


 


0


MadamPirate PE


RoarBark


1


harshaPEAZ


Roarbark


0


TrickShotG


fowler



3rd column is who each player votes for.

So NikR_PE, LyceeFruit PE, ChebyshevII PE, MadamPirate PE, and harshaPEAZ all vote for roarbark. That is added up and is placed in the 1st column beside each players name for a vote count against them. You can see that Roar has 5 highlighted in red,

If at any time you want to know how many votes you have against you, just look to the left of your name.

Sponsored by dominion voting services.

 
Back
Top