NZ 2017 election calculator

	B	C	E	F
1	Feel free to change the assumptions (in orange) or make a copy of this to edit yourself
2	N.B. Don't use 'cut' on the orange cells or you will break the calculation!
3	INPUT		RESULT
4	Valid special votes	350,000
5		% of special votes	% total vote	num seats
6	National	38.3	45.0	56
7	Labour	40.9	36.5	46
8	NZ First		6.5	8
9	Green	15	7.1	9
10	ACT	0.2	0.5	1
11	Other	5.7	4.5	0
12				120
13
14
15	For reference:
16		2017 provisional vote %	2014 provisional vote %	2014 special vote %
17	National	46.0	48.1	40.0
18	Labour	35.8	24.7	28.2
19	NZ First	7.5	8.8	7.4
20	Green	5.9	10.0	15.4
21	ACT	0.5	0.7	0.7
22	Other	4.3	7.7	8.4
23
24		2017 special vote if scaled by same ratio as 2014
25	National	38.3
26	Labour	40.9
27	NZ First	6.2
28	Green	9.0
29	ACT	0.5
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