ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This sheet calculates a STAR Voting election. Of the two highest-scoring candidates overall, STAR elects the one scored higher by more voters.
2
Copy sheet to create new election by going to "File > Make A Copy"
3
At the bottom tab, see the "BallotData" sheet - that's where you input all the ballot data. Each ballot can have a "Voter Count" if it represents a group of voters.
You'll need to fill in the fields below for number of candidates and voters/groups, then press "Run Election" to see the results below.
In the menu bar above, "Tools > Script Editor..." will show you the code for how this works.
4
5
6
Number of Candidates:3
7
Number of Voters/Groups:12
8
9
--
10
Election Results:TotalAverage Scorevs. Candidate Avs. Candidate Bvs. Candidate C
11
Candidate A252.0844
12
Candidate B332.7575
13
Candidate C342.8357
14
15
Top two are Candidate C, with a score of 34, and Candidate B, with a score of 33, overall.
16
Candidate C was preferred over Candidate B, 7 to 5.
17
18
The winner is: Candidate C
19
Total votes: 12 Total undervotes: 0
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100