Simulating AMS in Australia.xlsx

	A	B	C	D	E	F	G	H	I	J	L	M
1	2022 Federal Election Senate First Preferences By Group By Vote Type [Event:27966 Phase:FinalResults Generated:2022-07-19T10:30:16 Cycle:06578790-03c6-4cf4-b786-103cfb915abd Created:2022-07-19T10:24:10 Environment:PROD Site:CANBERRA Server:TALLYROOM Version:10.9.9.0]
2	GroupAb	GroupNm	Votes	%	Quota	PR	Seats	AMS	Total	%	MMM (Parallel voting)
3	LP	Liberal	5148028	34.24	69.13844395	70	58	14	72	35.82089552	18	76
4	ALP	Australian Labor Party	4525598	30.09	60.77915731	61	77	4	81	40.29850746	16	93
5	GRN	The Greens	1903403	12.66	25.5628605	27	4	17	21	10.44776119	7	11
6	ON	Pauline Hanson's One Nation	644744	4.29	8.658965511	10		5	5	2.487562189	2	2
7	UAPP	United Australia Party	520520	3.46	6.990626866	8		3	3	1.492537313	2	2
8	HMP	Legalise Cannabis Australia	501421	3.33	6.734125708	8		4	4	1.990049751	2	2
9	LDP	Liberal Democrats	340132	2.26	4.568001032	5		2	2	0.9950248756	1	1
10	AJP	Animal Justice Party	240696	1.6	3.232567287	3		1	1	0.4975124378	1	1
11	ASP	Shooters, Fishers and Farmers Party	147737	0.98	1.98412019	2					1	1
12	GAP	The Great Australian Party	82237	0.55	1.104449746	1
13	SPP	Sustainable Australia Party - Stop Overdevelopment / Corruption	78181	0.52	1.049977328	1
14	REAS	Reason Australia	74223	0.49	0.9968210594	1
15	IAP	Indigenous - Aboriginal Party of Australia	71811	0.48	0.9644276989	1
16	AUD	Australian Democrats	65532	0.44	0.880100207	1
17	DAVI	David Pocock	60406	0.4	0.811257601	1
18	DHJP	Derryn Hinch's Justice Party	54366	0.36	0.7301398989	1
19	SOPA	FUSION: Science, Pirate, Secular, Climate Emergency	51676	0.34	0.6940129753	0
20	IMO	Informed Medical Options Party	48830	0.32	0.6557909588	0
21	AUVA	Australian Values Party	41351	0.27	0.5553473671	0
22	CYA	Australian Federation Party	33551	0.22	0.4505927188	0
23	AUC	Australian Christians	33143	0.22	0.4451132449	0
24	JLN	Jacqui Lambie Network	31203	0.21	0.4190588836	0
25	CEC	Citizens Party	29799	0.2	0.4002030469	0
26	SAL	Socialist Alliance	28057	0.19	0.3768078421	0
27	WAP	WESTERN AUSTRALIA PARTY	26555	0.18	0.3566358573	0
28	RPT	Rex Patrick Team	23425	0.16	0.3145996971	0
29	VNS	Victorian Socialists	21739	0.14	0.291956577	0
30	FIN	Federal ICAC Now	18508	0.12	0.2485639784	0
31	TNL	TNL	13217	0.09	0.1775054086	0
32	SUN	Seniors United Party of Australia	12790	0.09	0.1717707631	0
33	KCBR	Kim for Canberra	12622	0.08	0.1695145091	0
34	TLOC	The Local Party of Australia	7605	0.05	0.1021357821	0
35	AUP	Australian Progressives	5932	0.04	0.07966725307	0
36	DPDA	Drew Pavlou Democratic Alliance	5566	0.04	0.07475184265	0
37	UNAM	Unendorsed/Ungrouped Amalgamated	136054	0.9	1.827216529	0	12		12	5.970149254		12
38		Sum	15040658			201	151	50	201		50	201
39		Total number of seats	201			✅	✅	✅	✅
40		Quota	74459.70297
41		Threshold	0.4950561536				https://public.flourish.studio/visualisation/18646274/
42
43		Sum of excluded ballots	516434
44		Needed for a majority	101
45
46			Seats	Total	AMS
47		#VALUE!	5	7	2
48		#VALUE!	39	52	13
49		#VALUE!	3	4	1
50		#VALUE!	47	62	15
51		#VALUE!	30	40	10
52		#VALUE!	10	13	3
53		#VALUE!	2	3	1
54		#VALUE!	15	20	5
55		Seats	151	201	50
56		Seat Multiplier	1.324503311
57
58
59		Using Scotland's system of AMS as inspiration.
60		Threshold is just for me, to help me determine what gets excluded
61
62		https://en.wikipedia.org/wiki/Elections_in_Scotland
63		https://en.wikipedia.org/wiki/Additional-member_system
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100