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	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:	Total	Average Score	vs. Candidate A	vs. Candidate B	vs. Candidate C
11	Candidate A	25	2.08		4	4
12	Candidate B	33	2.75	7		5
13	Candidate C	34	2.83	5	7
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