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.
4
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.
5
In the menu bar above, "Tools > Script Editor..." will show you the code for how this works.
6
7
Number of Candidates:3
8
Number of Voters/Groups:12
9
10
--
11
Election Results:TotalAverage Scorevs. Candidate Avs. Candidate Bvs. Candidate C
12
Candidate A343.0957
13
Candidate B302.7346
14
Candidate C242.1845
15
16
Top two are Candidate A, with a score of 34, and Candidate B, with a score of 30, overall.
17
Candidate A was preferred over Candidate B, 5 to 4.
18
19
The winner is: Candidate A
20
Total votes: 11 Total undervotes: 3
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