The Kellow Miscellany

Excel Webster/Sainte-Laguë Calculator

Download

Looking for a D’Hondt calculator? Try here.


This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, which allows you to share and adapt the material for non-commercial purposes as long as attribution is provided and that the same license applies to your work.

The Webster/Sainte-Laguë method is used in many electoral systems around the world, most notably in Germany, New Zealand, Norway and Sweden.  But as with most proportional systems, although they produce fairer results they can be very difficult to figure out without some complex calculations.

This calculator can help you calculate the number of seats to award by proportional representation for an election using the Webster/Sainte-Laguë method.

This method uses the formula:

Co-efficient = Votes / ( (2 * Seats Earned) + 1 )

This makes it slightly more complicated than the D’Hondt formula (which you can find a calculator for here), but this calculator will help you award seats at the click of a button.

It also features support for an electoral threshold, which is a certain percentage (often 5%) of the vote that a party must win before it is awarded any proportional seats.

Click here to download the Webster/Sainte-Laguë calculator (in Microsoft Excel Macro-Enabled format)

Has this resource been helpful to you? It would be greatly appreciated if you could donate a couple of dollars to keep the site up and running!

Donate via PayPal

UPDATE 14th April 2019: Code fixes and improvements

UPDATE: 9th March 2021 – Added Creative Commons license to allow for adaptation of the work

Exit mobile version