<HTML><FONT FACE=arial,helvetica><HTML><FONT SIZE=2 PTSIZE=10 FAMILY="SANSSERIF" FACE="Arial" LANG="0">Hello List<BR>
<BR>
I've recently been working on a spreadsheet model to compare various different electoral methods. What it does is generate, for a 3 party election, sets of votes for 50 single member districts, based on an inputted set of preferences amongst the electorate and then calculate the results under 11 different electoral systems.<BR>
<BR>
An inputted set of preferences would be something like:<BR>
<BR>
A = 43 B = 21 C = 36<BR>
<BR>
A = 40 A>B = 55 A>C = 5<BR>
<BR>
B = 20 B>A = 30 B>C = 50<BR>
<BR>
C = 10 C>A = 5 C>B = 85<BR>
<BR>
In this example party A has 43 % of the 1st pref vote, party B has 21 % of the 1st pref vote and party C 36 %. Of party A voters 40% give no 2nd preference, 55% give a 2nd preference to B and 5% a second preference to C, etc.<BR>
<BR>
It then calculates the results under the following 5 single member systems:<BR>
<BR>
Plurality<BR>
IRV<BR>
Condorcet (Ranked Pairs winning margins)<BR>
Borda<BR>
Approval<BR>
<BR>
The following 4 proportional systems by combining the single member districts:<BR>
<BR>
D'Hondt Highest Average ( 1 fifty member district)<BR>
D'Hondt Highest Average (5 member districts)<BR>
STV (5 member districts)<BR>
MMP ( 25 single districts, 25 top up seats)<BR>
<BR>
The following 2 semi-proportional systems:<BR>
<BR>
MMP ( 40 single districts, 10 top up seats)<BR>
IRV+ ( 40 single districts, 10 top up seats)<BR>
<BR>
And displays the results in summary and detail with a number of comparisons between the systems.<BR>
<BR>
I would like volunteers to test this model and give their comments on it. If you would like a copy of the model to test E-mail me at <BR>
<BR>
Dgamble997@aol.com<BR>
<BR>
and I will send you one.<BR>
<BR>
David Gamble</FONT></HTML>