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