nsv

Neighbourhood Shared Voting is a proposed electoral reform which involves transferring, to adjacent electoral districts, ballots which have not already contributed to electing a parliamentary representative in Canada. Simulations were done using the voting patterns of the five Canadian elections between 2004 and 2015. “Neighbourhood Shared Voting” is a primitive, simpler relative of STV (Single Transferable Vote) which uses the existing electoral districts and ballot. As with other PR systems, winners are determined one-by-one. It uses two steps, which are repeated until every seat is filled:1. The candidate with the most votes is declared a winner.2. Votes that were not for the winner are shared equally among the adjacent districts that do not yet have a declared winner (to candidates of the same parties), then step 1 is repeated. (Here “adjacent” is defined as connected by dry land or by an automobile bridge or tunnel.)Instructions:The NSV-YYYY-PP.xls files (NSV-year-province abbreviation.xls) are Excel spreadsheets with a macro which generates the election outcomes that would be obtained using the Canada federal election data from the 2004, 2006, 2008, 2011 and 2015 general elections if the Neighbourhood Shared Voting (NSV) system had been used to count the votes. Although the elections are federal, there is one file for each of the ten provinces for each election. (The results for the single seats in each of the three Canadian territories of Yukon, Northwest Territories and Nunavut are the same as under the existing electoral system, Single Member Plurality or 'First-Past-The-Post'.) The original voting data is from Elections Canada at www.elections.ca.The data input files require Microsoft Excel 2000 or a similar version of Excel. Double-clicking a file will open it in Excel, which will ask if the user wants to enable or disable macros; click "Enable macros". In the spreadsheet at O1 click the button "Click for Result" to generate the output for that province. Do not click the button a second time.