STAR Elections Calculator - Template

	A	B	C	D	E	F
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:	Total	Average Score	vs. Candidate A	vs. Candidate B	vs. Candidate C
11	Candidate A	34	3.09		5	7
12	Candidate B	30	2.73	4		6
13	Candidate C	24	2.18	4	5
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