Reluctant Hero Posted November 27, 2019 Share Posted November 27, 2019 If anyone is looking for a spreadsheet for Election Night (and before), then look no further. You’ll need Excel 2016 to use the file and it is 7MB, so may take some time to download. Download Election Spreadsheet The first tab has various information about every UK seat for the last 3 elections, including count finishing times, trends, postal votes etc. You choose the seat you want to view from the menu down the left-hand side. It has a forecast which you can change by changing the figures of the Opinion Polls tab. I even had a box for interesting facts/info about the seat, but I quickly got bored of doing that lol, so only some seats have that. The second tab has a prediction of the 2019 election. This is based on a very basic calculation of using the percentage of the last election and applying the swing based on the latest opinion polls for each country. The opinion polls can be changed via the Opinion Polls tab. (Tonight, YouGov are producing a forecast for every single seat, so will be interesting to see if this is close lol) The third tab shows the seats each party holds and orders them based on majority (smallest to largest). The fourth tab shows the 2019 status once you start entering the results as they come in. You can enter the results and electorates on the Data Entry tab, which lists all the candidates standing in each seat. If you update anything in the spreadsheet, you need to go to the Refresh Page tab and refresh the table for all the graphs/tables in the spreadsheet to update. I think all the data is correct, but if you are using the file for any other purpose than just a bit of fun, then make sure you double check the data with verified sources. All the best 0 Quote Link to comment Share on other sites More sharing options...
Reluctant Hero Posted December 12, 2019 Author Share Posted December 12, 2019 Just bumping this in case anyone is looking for something like it! 1 Quote Link to comment Share on other sites More sharing options...
DeeTillEhDeh Posted December 12, 2019 Share Posted December 12, 2019 Just bumping this in case anyone is looking for something like it!I'm not that anal!! 1 Quote Link to comment Share on other sites More sharing options...
welshbairn Posted December 12, 2019 Share Posted December 12, 2019 Haven't got Excel 2016 but I appreciate the effort! 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.