ABCDEFGHIJKL
1
Welcome to Jamin's Election Tracker Spreadsheet!
2
What is the point of this?
3
On election night, media will often not touch on the party list and the different factors that impact it. This spreadsheet takes into account electorate winners and party vote to give you the outcome of the list MPs within our parliament. By using this spreadsheet, we can find these outcomes much more easily, especially this election, where overhangs are going to play a big part of how our parliament is shaped.
4
How does it work?
5
This spreadsheet has 3 main tabs.
6
Input & OutcomeElectorate WinnersWho are the MPs?
7
This is where you input the percentages for each party's party vote. The spreadsheet will then allocate all of the 120 seats in parliament to each party. The tab also has a government builder where you can select parties to from a majority to create a government and the number of seats that will be needed to do so.This is where you select the winner of each of Aotearoa's 71 electorate winners. This tab has all the incumbants listed and you can see which party each candidate is from.This is where we find out how the MPs in Parliament and going to be. This will take the factors from the previous two tabs showing who actually gets in from each party.
8
How do I use it?
9
There are two options!
10
1. Be a viewer on the live version of the google sheet and watch me update as election night goes on
11
2. Make a copy of this google sheet (this is the template version!) and fill in the results yourself
12
Please message @jamin.fountain on instagram or email fountainjamin@gmail.com if you have any other pātai!
13
All credit goes to Jamin Fountain, please credit for any use!
14
Happy spreadsheeting and Up the Tahs!
15
https://linktr.ee/jamin.fountain