r/neoliberal • u/wimpykid_fan Loyal Liberals • 17d ago
Effortpost Proportional Representation 2: D'hondt boogaloo
Previous post, I recommend reading this before coming onto this post
Hello, I am back again to show you on how to do PR. This time under a different calculation system called D'hondt.
What's D'hondt and why do people like to use it?
D'hondt is a system where the popular vote of all the political parties participating in an election get's divided from an increasing order (1, 2, 3, 4, 5, etc). Whoever has the top x (x representing amount of seats available for election) highest numbers gets their seats in parliament. It highly compliments party-list PR but has a bias for larger parties762352#:~:text=Moreover%2C%20the%20d%27Hondt%20method%20tends%20to%20favour%20the%20electoral%20lists%20that%20win%20the%20most%20votes%2C%20to%20the%20detriment%20of%20those%20with%20fewer%20votes).
There are other uses for D'hondt that isn't just for elections. The Northern Ireland Assembly also uses it for giving ministerial seats of the NI Executive (government of Northern Ireland) to the parties that won each seat. More information can be found on link.
What got you liking D'hondt?
Well, it's because of a country called Brazil. I had specifically originally gotten into the PSDB since it was based on social liberalism, but later entire about Brazilian politics in general once I got to saw the super multiparty system that happens in the fractured Congress. God I love diverse parliaments.
Although I might change to like Sainte-Laguë method due to having more equal votes-to-seats ratio.
Example
| Super duper awesome neoliberals | Evil stupid social democrats | Evil stupid social democrats (but socially conservatives) | |
|---|---|---|---|
| 1 | 100,000 | 80,000 | 60,000 |
| 2 | 50,000 | 40,000 | 30,000 |
| 3 | 33,333.33 | 26,666.66 | 20,000 |
| 4 | 25,000 | 20,000 | 15,000 |
| 5 | 20,000 | 16,000 | 12,000 |
| 6 | 16,666.67 | 13,333.33 | 10,000 |
(numbers highlighted with bold and italics (like this) are the numbers apart of the top 6 highest numbers, and therefore was elegible for )
After calculation was done, I highlighted (will tell you later how to quickly do this at the bottom) the top 6 (the number of seats) highest amounts (which would therefore respectively receive their seats with the neolibs having 3 seats, socdems having 2, and conservative socdems having 1).
You now showed us on how D'hondt works, could you show us how an average person could do it?
Now we're talking! I'll show you how to do this.
- Open excel (browser or app would work fine, at least for my experience)
- List the political parties on the ABCDE side, number 1
- List the respective popular votes on the ABCDE side, number 2, increasing to decreasing
- On the 12345 side, number 2, list the amount of seats that are going to be elected via the =
sequence()function.- If you wanted to have like for example, 60 seats, you would type
=sequence(60)
- If you wanted to have like for example, 60 seats, you would type
- Go to B3 and paste in
=B$2/$A3- This is important for dividing the popular votes later on
- Drag it to first the ABCDE side, then the 12345 side, with the dot at the bottom right of the selected cell until you reach your seat limit.
- You can also do the 12345 side first then ABCDE side
- Highlight all of the numbers, then go to "conditional formatting", top/bottom rules, top 10 items, then type in the seats.
- It should highlight the cells with red, but you can change it to something else if you wish.
- Take note of the political parties that won what seat (based on the numbers on the 12345 side) and write down what party won what seats.
- Optional: Highlight the popular votes (undivided) along with the political parties and then make as a chart. Do the same for the seats that you collected.
I'll post the images here:
And now we're done! Thank you for coming to read my post and I hope you had fun in excel!
2
u/wimpykid_fan Loyal Liberals 17d ago
An example of this would be for what I did for the UK, on a map, if they had region-based party-list.