Bills before Parliament


1	House Bills In Play - Australian Parliament		46	Govt Bills											131
2	Final for 2019		68	Private Bills
3	The Bills in this list are those that the Federal Member for Dickson still has to vote on in the House of Reps. So as far as the voters of Dickson are concerned we still have the opportunity to tell our Elected Rep how we want them to vote for us on these Bills.		114
4	Short Title	Introduced	Bill Type	Sponsor	Intro House	Passed House	Intro Senate	Passed Senate	Assent Date	Act No.	Seq No.	filter	???	Footnote Ref		VoteWrap
5	Australian Business Growth Fund 2019	20191205	Govt	Treasury	5/12					0	13	Intro House	8		x	Yes
6	Federal Circuit and Family Court of Australia (Consequential Amendments and Transitional Provisions) 2019	20191205	Govt	Attorney-General	5/12					0	67	Intro House	33	33	x	Yes
7	Federal Circuit and Family Court of Australia 2019	20191205	Govt	Attorney-General	5/12					0	66	Intro House	32	32	x
8	National Consumer Credit Protection Amendment (Mandatory Credit Reporting and Other Measures) 2019	20191205	Govt	Treasury	5/12					0	89	Intro House	42		x
9	Treasury Laws Amendment (2019 Measures No. 3) 2019	20191205	Govt	Treasury	5/12					0	131	Intro House	60		x
10	Treasury Laws Amendment (Research and Development Tax Incentive) 2019	20191205	Govt	Treasury	5/12					0	143	Intro House	62		x
11	Marine Safety (Domestic Commercial Vessel) National Law Amendment (Improving Safety) 2019S	20191205	Private	STERLE, Sen Glenn			5/12			0	188	Coming from Senate	94		x
12	Business Names Registration (Fees) Amendment (Registries Modernisation) 2019	20191204	Govt	Treasury	4/12					0	22	Intro House	12		x
13	Commonwealth Registers 2019	20191204	Govt	Treasury	4/12					0	30	Intro House	19		x
14	Corporations (Fees) Amendment (Registries Modernisation) 2019	20191204	Govt	Treasury	4/12					0	34	Intro House	22		x
15	Export Charges (Imposition—Customs) Amendment 2019	20191204	Govt	Agriculture	4/12					0	51	Intro House	25	21	x
16	Export Charges (Imposition—Excise) Amendment 2019	20191204	Govt	Agriculture	4/12					0	52	Intro House	26	22	x
17	Export Charges (Imposition—General) Amendment 2019	20191204	Govt	Agriculture	4/12					0	53	Intro House	27	23	x
18	Export Control (Consequential Amendments and Transitional Provisions) 2019	20191204	Govt	Agriculture	4/12					0	55	Intro House	29	25	x
19	Export Control 2019	20191204	Govt	Agriculture	4/12					0	54	Intro House	28	23	x
20	National Consumer Credit Protection (Fees) Amendment (Registries Modernisation) 2019	20191204	Govt	Treasury	4/12					0	91	Intro House	44		x
21	National Vocational Education and Training Regulator Amendment 2019	20191204	Govt	Employment, Skills, Small and Family Business			4/12			0	197	Coming from Senate	100		x
22	Offshore Petroleum and Greenhouse Gas Storage (Regulatory Levies) Amendment (Miscellaneous Measures) 2019	20191204	Govt	Industry, Innovation and Science	4/12					0	105	Intro House	49	49	x
23	Offshore Petroleum and Greenhouse Gas Storage Amendment (Cross-boundary Greenhouse Gas Titles and Other Measures) 2019	20191204	Govt	Industry, Innovation and Science	4/12					0	102	Intro House	48	46	x
24	Student Identifiers Amendment (Higher Education) 2019	20191204	Govt	Education	4/12					0	120	Intro House	54		x
25	Tertiary Education Quality and Standards Agency Amendment (Prohibiting Academic Cheating Services) 2019	20191204	Govt	Education	4/12					0	124	Intro House	57		x
26	Transport Security Amendment (Testing and Training) 2019	20191204	Govt	Home Affairs			4/12			0	212	Coming from Senate	113	25	x
27	Treasury Laws Amendment (Registries Modernisation and Other Measures) 2019	20191204	Govt	Treasury	4/12					0	142	Intro House	61		x
28	Telecommunications Amendment (Repairing Assistance and Access) 2019S	20191204	Private	KENEALLY, Sen Kristina			4/12			0	209	Coming from Senate	111		x
29	Agriculture Legislation Amendment (Streamlining Administration) 2019	20191202	Govt	Agriculture			2/12			0	151	Coming from Senate	64	1	x
30	Crimes Legislation Amendment (Combatting Corporate Crime) 2019	20191202	Govt	Attorney-General			2/12			0	170	Coming from Senate	79	8	x
31	Wine Australia Amendment (Label Directory) 2019	20191202	Govt	Agriculture			2/12			0	213	Coming from Senate	114		x
32	Australian Banks (Government Audit) 2019P	20191202	Private	KATTER, Bob, Jnr, MP	2/12					0	10	Intro House	5		x
33	Climate Change Authority Amendment (Impact of 3 Degrees of Global Warming on Australia) 2019P	20191202	Private	BANDT, Adam, MP	2/12					0	23	Intro House	13		x
34	Commonwealth Electoral Amendment (Lowering the Donation Disclosure Threshold) 2019P	20191202	Private	SHARKIE, Rebekha, MP	2/12					0	27	Intro House	16		x
35	Live Animal Export Prohibition (Ending Cruelty) 2019P	20191202	Private	WILKIE, Andrew, MP	2/12					0	79	Intro House	37		x
36	National Consumer Credit Protection Amendment (Small Amount Credit Contract and Consumer Lease Reforms) 2019 (No. 2)S	20191202	Private	GRIFF, Sen Stirling			2/12			0	191	Coming from Senate	97	17	x
37	Public Governance, Performance and Accountability Amendment (Waiver of Debt and Act of Grace Payments) 2019S	20191202	Private	GALLAGHER, Sen Katy			2/12			0	204	Coming from Senate	107		x
38	Saving Australian Dairy 2019S	20191202	Private	HANSON, Sen Pauline			2/12			0	207	Coming from Senate	109	23	x
39	Financial Sector Reform (Hayne Royal Commission Response—Protecting Consumers (2019 Measures)) 2019	20191128	Govt	Treasury	28/11					0	68	Intro House	34		x
40	Financial Sector Reform (Hayne Royal Commission Response—Stronger Regulators (2019 Measures)) 2019	20191128	Govt	Treasury	28/11					0	69	Intro House	35		x
41	Student Identifiers Amendment (Enhanced Student Permissions) 2019	20191128	Govt	Employment, Skills, Small and Family Business	28/11					0	119	Intro House	53	53	x
42	Telecommunications (Regional Broadband Scheme) Charge 2019	20191128	Govt	Communications, Cyber Safety and the Arts	28/11					0	122	Intro House	55		x
43	Telecommunications Legislation Amendment (Competition and Consumer) 2019	20191128	Govt	Communications, Cyber Safety and the Arts	28/11					0	123	Intro House	56	54	x
44	Trade Support Loans Amendment (Improving Administration) 2019	20191128	Govt	Employment, Skills, Small and Family Business	28/11					0	126	Intro House	58		x
45	Family Law Amendment (Western Australia De Facto Superannuation Splitting and Bankruptcy) 2019	20191127	Govt	Attorney-General	27/11					0	62	Intro House	31	30	x
46	Migration Agents Registration Application Charge Amendment (Rates of Charge) 2019	20191127	Govt	Home Affairs	27/11					0	82	Intro House	39		x
47	Migration Amendment (Regulation of Migration Agents) 2019	20191127	Govt	Home Affairs	27/11					0	83	Intro House	40	38	x
48	Treasury Laws Amendment (Your Superannuation, Your Choice) 2019	20191127	Govt	Treasury	27/11					0	146	Intro House	63	63	x
49	Australian Cannabis Agency 2018S,N	20191127	Private	DI NATALE, Sen Richard			27/11			0	154	Coming from Senate	66		x
50	Commonwealth Electoral Amendment (Lowering the Donation Disclosure Threshold) 2019S	20191127	Private	SHARKIE, Rebekha, MP			27/11			0	162	Coming from Senate	72
51	Commonwealth Electoral Amendment (Transparency Measures—Real Time Disclosure) 2019S	20191127	Private	FARRELL, Sen Don			27/11			0	164	Coming from Senate	74		x
52	Private Health Insurance Legislation Amendment (Fairer Rules for General Treatments) 2019P	20191125	Private	WILKIE, Andrew, MP	25/11					0	108	Intro House	50		x
53	Governor-General Amendment (Cessation of Allowances in the Public Interest) 2019S	20191113	Private	SIEWERT, Sen Rachel			13/11			0	178	Coming from Senate	86		x
54	Public Governance, Performance and Accountability Amendment (Tax Transparency in Procurement and Grants) 2019S	20191113	Private	PATRICK, Sen Rex			13/11			0	203	Coming from Senate	106	22	x
55	Official Development Assistance Multilateral Replenishment Obligations (Special Appropriation) 2019	20191024	Govt	Foreign Affairs and Trade	24/10					0	101	Intro House	47		x
56	Transport Security Amendment (Serious Crime) 2019	20191023	Govt	Home Affairs	23/10					0	127	Intro House	59	55	x
57	Commonwealth Electoral Amendment (Lowering Voting Age and Increasing Voter Participation) 2019P	20191021	Private	BANDT, Adam, MP	21/10					0	28	Intro House	17		x
58	Refugee Protection 2019P	20191021	Private	WILKIE, Andrew, MP	21/10					0	110	Intro House	51		x
59	Anti-Money Laundering and Counter-Terrorism Financing and Other Legislation Amendment 2019	20191017	Govt	Home Affairs	17/10					0	6	Intro House	4	2	x
60	Native Title Legislation Amendment 2019	20191017	Govt	Attorney-General	17/10					0	99	Intro House	46	44	x
61	National Integrity (Parliamentary Standards) 2019S	20191017	Private	WATERS, Sen Larissa			17/10			0	194	Coming from Senate	98	19	x
62	Coal Prohibition (Quit Coal) 2019P	20191014	Private	BANDT, Adam, MP	14/10					0	25	Intro House	15		x
63	Crimes Legislation Amendment (Age of Criminal Responsibility) 2019P	20191014	Private	SHARKIE, Rebekha, MP	14/10					0	37	Intro House	23		x
64	Australian Citizenship Amendment (Citizenship Cessation) 2019	20190918	Govt	Home Affairs	19/9					0	14	Intro House	9	3	x
65	Australian Bill of Rights 2019P	20190916	Private	WILKIE, Andrew, MP	16/9					0	11	Intro House	6		x
66	Commonwealth Electoral Amendment (Real Time Disclosure of Political Donations) 2019P	20190916	Private	SHARKIE, Rebekha, MP	16/9					0	29	Intro House	18	9	x
67	Fair Work Amendment (Stop Work to Stop Warming) 2019P	20190916	Private	BANDT, Adam, MP	16/9					0	56	Intro House	30		x
68	National Consumer Credit Protection Amendment (Small Amount Credit Contract and Consumer Lease Reforms) 2019P	20190916	Private	SHARKIE, Rebekha, MP	16/9					0	90	Intro House	43		x
69	Protecting Australian Dairy 2019S	20190916	Private	HANSON, Sen Pauline			16/10	2°negatived 11/11		0	202	Coming from Senate	105		d
70	Family Law (Self-Assessment) 2019S	20190912	Private	HANSON, Sen Pauline			12/9			0	176	Coming from Senate	84		x
71	Social Services Legislation Amendment (Better Targeting Student Payments) 2019	20190911	Govt	Social Services	11/9					0	114	Intro House	52		x
72	Product Stewardship Amendment (Packaging and Plastics) 2019S	20190911	Private	WHISH-WILSON, Sen Peter			11/9			0	200	Coming from Senate	103	21	x
73	Customs Amendment (Safer Cladding) 2019S	20190910	Private	PATRICK, Sen Rex			10/9			0	171	Coming from Senate	80		x
74	National Integrity Commission 2019P	20190909	Private	BANDT, Adam, MP	9/9					0	95	Intro House	45		x
75	Australian Passports Amendment (Identity-matching Services) 2019	20190731	Govt	Foreign Affairs and Trade	31/7					0	16	Intro House	10	4	x
76	Identity-matching Services 2019	20190731	Govt	Home Affairs	31/7					0	77	Intro House	36	37	x
77	Australian Broadcasting Corporation Amendment (Rural and Regional Measures) 2019	20190731	Private	SHARKIE, Rebekha, MP	31/7					0	12	Intro House	7		x
78	Constitution Alteration (Freedom of Expression and Freedom of the Press) 2019 [No. 2]P	20190729	Private	SHARKIE, Rebekha, MP	29/7					0	32	Intro House	20		x
79	Constitution Alteration (Water Resources) 2019 [No. 2]P	20190729	Private	SHARKIE, Rebekha, MP	29/7					0	33	Intro House	21		x
80	Intellectual Property Laws Amendment (Productivity Commission Response Part 2 and Other Measures) 2019	20190725	Govt	Industry, Innovation and Science	16/10		25/7	16/10A		0	184	Coming from Senate	90	13	x
81	Great Australian Bight Environment Protection 2019S	20190725	Private	HANSON-YOUNG, Sen Sarah			25/7			0	179	Coming from Senate	87		x
82	Human Rights (Parliamentary Scrutiny) Amendment (Australian Freedoms) 2019S	20190723	Private	BERNARDI, Sen Cory			23/7			0	181	Coming from Senate	88		x
83	Aged Care Amendment (Staffing Ratio Disclosure) 2019P	20190722	Private	SHARKIE, Rebekha, MP	22/7					0	2	Intro House	1		x
84	Aged Care Quality and Safety Commission Amendment (Worker Screening Database) 2019P	20190722	Private	SHARKIE, Rebekha, MP	22/7					0	3	Intro House	2		x
85	Banking Amendment (Rural Finance Reform) 2019P	20190722	Private	SHARKIE, Rebekha, MP	22/7					0	21	Intro House	11	7	x
86	Coal-Fired Power Funding Prohibition 2019P	20190722	Private	BANDT, Adam, MP	22/7					0	24	Intro House	14		x
87	Environment Protection and Biodiversity Conservation Amendment (Heritage Listing for the Bight) 2019P	20190722	Private	SHARKIE, Rebekha, MP	22/7					0	50	Intro House	24		x
88	Live Sheep Long Haul Export Prohibition 2019P	20190722	Private	SHARKIE, Rebekha, MP	22/7					0	80	Intro House	38		x
89	Migration Legislation Amendment (Regional Processing Cohort) 2019	20190704	Govt	Home Affairs	4/7					0	87	Intro House	41	41	x
90	Australian Institute of Health and Welfare Amendment (Assisted Reproductive Treatment Statistics) 2019S	20190704	Private	FARUQI, Sen Mehreen			4/7			0	155	Coming from Senate	67	3	x
91	Constitution Alteration (Freedom of Expression and Freedom of the Press) 2019S	20190704	Private	GRIFF, Sen Stirling PATRICK, Sen Rex			4/7			0	167	Coming from Senate	77		x
92	Constitution Alteration (Water Resources) 2019S	20190704	Private	PATRICK, Sen Rex			4/7			0	168	Coming from Senate	78	7	x
93	Live Animal Export (Slaughter) Prohibition 2019S	20190704	Private	FARUQI, Sen Mehreen			4/7			0	187	Coming from Senate	93		x
94	Agriculture Legislation Repeal 2019Z	20190702	Govt	Prime Minister	2/7					0	5	Intro House	3		x
95	Human Services Amendment (Photographic Identification and Fraud Prevention) 2019S,N	20190213	Private	HANSON, Sen Pauline			13/2			0	182	Coming from Senate	89	12	x
96	Murray-Darling Basin Commission of Inquiry 2019S,N	20190213	Private	HANSON-YOUNG, Sen Sarah			13/2			0	190	Coming from Senate	96	16	x
97	Telecommunications Legislation Amendment (Unsolicited Communications) 2019S,N	20190213	Private	GRIFF, Sen Stirling			13/2			0	210	Coming from Senate	112	24	x
98	Broadcasting Services Amendment (Audio Description) 2019S,N	20190212	Private	STEELE-JOHN, Sen Jordon			12/2			0	159	Coming from Senate	70		x
99	Competition and Consumer Amendment (Prevention of Exploitation of Indigenous Cultural Expressions) 2019S,N	20190212	Private	HANSON-YOUNG, Sen Sarah			12/2			0	165	Coming from Senate	75	5	x
100	Ministers of State (Checks for Security Purposes) 2019S,N	20190212	Private	PATRICK, Sen Rex			12/2			0	189	Coming from Senate	95	15	x
101	Fair Work Amendment (Restoring Penalty Rates) 2018 [No. 2]S,N	20181411	Private	CAMERON, Sen Doug			14/11			0	175	Coming from Senate	83		x
102	National Integrity Commission 2018 (No. 2)S,N	20181129	Private	WATERS, Sen Larissa	10/9		29/11	9/9		0	195	Coming from Senate	99	20	x
103	Australian Research Council Amendment (Ensuring Research Independence) 2018S,N	20181115	Private	FARUQI, Sen Mehreen			15/11			0	157	Coming from Senate	69		x
104	Discrimination Free Schools 2018S,N	20181016	Private	DI NATALE, Sen Richard			16/10			0	173	Coming from Senate	81		x
105	Social Services Legislation Amendment (Ending the Poverty Trap) 2018S,N	20180910	Private	SIEWERT, Sen Rachel			10/9			0	208	Coming from Senate	110		x
106	Australian Multicultural 2018S,N	20180823	Private	DI NATALE, Sen Richard			23/8			0	156	Coming from Senate	68		x
107	Freedom of Information Legislation Amendment (Improving Access and Transparency) 2018S,N	20180822	Private	PATRICK, Sen Rex			22/8			0	177	Coming from Senate	85	11	x
108	Plebiscite (Future Migration Level) 2018S,N	20180815	Private	HANSON, Sen Pauline			15/8	2°negatived 29/7		0	199	Coming from Senate	102		d
109	Intelligence Services Amendment (Enhanced Parliamentary Oversight of Intelligence Agencies) 2018S,N	20180814	Private	PATRICK, Sen Rex			14/8			0	185	Coming from Senate	91	14	x
110	Commonwealth Electoral Amendment (Lowering Voting Age and Increasing Voter Participation) 2018S,N	20180618	Private	STEELE-JOHN, Sen Jordon			18/6			0	163	Coming from Senate	73	5	x
111	Air Services Amendment 2018S,N	20180327	Private	RICE, Sen Janet			27/3			0	152	Coming from Senate	65	2	x
112	Nuclear Fuel Cycle (Facilitation) 2017S,N	20171411	Private	BERNARDI, Sen Cory			14/11			0	198	Coming from Senate	101		x
113	Productivity Commission Amendment (Addressing Inequality) 2017S,N	20171406	Private	MCALLISTER, Sen Jenny			14/6			0	201	Coming from Senate	104		x
114	Coal-Fired Power Funding Prohibition 2017S,N	20171017	Private	DI NATALE, Sen Richard			17/10			0	161	Coming from Senate	71	4	x
115	Regional Forest Agreements Legislation (Repeal) 2017S,N	20170907	Private	RICE, Sen Janet			7/9			0	205	Coming from Senate	108		x
116	Competition and Consumer Amendment (Truth in Labelling—Palm Oil) 2017S,N	20170621	Private	XENOPHON, Sen Nick			21/6			0	166	Coming from Senate	76		x
117	Environment and Infrastructure Legislation Amendment (Stop Adani) 2017S,N	20170613	Private	WATERS, Sen Larissa			13/6			0	174	Coming from Senate	82	10	x
118	Landholders’ Right to Refuse (Gas and Coal) 2015S,N	20150831	Private	WATERS, Sen Larissa			31/8			0	186	Coming from Senate	92		x
119	Aged Care Amendment (Movement of Provisionally Allocated Places) 2019				24/7	11/9	11/9	17/9	20/9	71	1
120	Aged Care Legislation Amendment (New Commissioner Functions) 2019				5/12	5/12	16/10	5/12	11/12	116	150
121	Agricultural and Veterinary Chemicals Legislation Amendment (Australian Pesticides and Veterinary Medicines Authority Board and Other Improvements) 2019				18/9[1]	3/12	5/12			0	4	No Jurisdiction			x
122	ANL Legislation Repeal 2019				15/10	16/10	11/9	14/10	28/10	88	153
123	Appropriation (No. 1) 2019-2020B				25/7	19/9	19/9	11/11	12/11	100	7
124	Appropriation (No. 2) 2019-2020B				25/7	19/9	19/9	11/11	12/11	101	8
125	Appropriation (Parliamentary Departments) (No. 1) 2019-2020B				25/7	19/9	19/9	11/11	12/11	102	9
126	Australian Crime Commission Amendment (Special Operations and Special Investigations) 2019				28/11	3/12	5/12	5/12	10/12	114	15
127	Australian Research Council Amendment 2019				18/9	26/11	27/11			0	17	No Jurisdiction			x
128	Australian Security Intelligence Organisation Amendment (Sunsetting of Special Powers Relating to Terrorism Offences) 2019				4/7	30/7	31/7	1/8	12/8	61	18
129	Australian Sports Anti-Doping Authority Amendment (Enhancing Australia’s Anti-Doping Capability) 2019				17/10[5]	4/12	5/12			0	19	No Jurisdiction			x
130	Australian Sports Anti-Doping Authority Amendment (Sport Integrity Australia) 2019				17/10[6]	5/12	5/12			0	20	No Jurisdiction			x
131	Australian Veterans’ Recognition (Putting Veterans and Their Families First) 2019				30/7	22/10	4/7	29/7A	30/10	96	158
132	Civil Aviation Amendment 2019				24/7	24/10	4/7	22/7	6/11	99	160
133	Combatting Child Sexual Exploitation Legislation Amendment 2019				24/7[8]	12/9	12/9	17/9	20/9	72	26
134	Communications Legislation Amendment (Deregulation and Other Measures) 2019				16/10	25/11	27/11	5/12	12/12	120	31
135	Counter-Terrorism (Temporary Exclusion Orders) (Consequential Amendments) 2019				4/7	23/7	24/7	25/7	30/7	54	36
136	Counter-Terrorism (Temporary Exclusion Orders) 2019				4/7	23/7	24/7	25/7	30/7	53	35
137	Counter-Terrorism Legislation Amendment (2019 Measures No. 1) 2019				4/12	4/12	1/8[8]	4/12A	11/12	119	169
138	Crimes Legislation Amendment (Police Powers at Airports) 2019				4/7	12/9	12/9	14/10A[10]	28/10	89	38
139	Crimes Legislation Amendment (Sexual Crimes Against Children and Community Protection Measures) 2019				11/9[11]	15/10	17/10			0	39	No Jurisdiction			x
140	Criminal Code Amendment (Agricultural Protection) 2019				4/7[12]	1/8	9/9	12/9A[13]	19/9	67	40
141	Currency (Restrictions on the Use of Cash) 2019				19/9[14]	24/10	11/11			0	41	No Jurisdiction			x
142	Customs Amendment (Growing Australian Export Opportunities Across the Asia-Pacific) 2019				16/10	21/10	11/11	26/11	3/12	108	42
143	Customs Amendment (Immediate Destruction of Illicit Tobacco) 2019				4/7[15]	9/9	9/9	19/9	2/10	76	43
144	Customs Amendment (Product Specific Rule Modernisation) 2019				12/9[16]	24/10	11/11			0	44	No Jurisdiction			x
145	Customs Tariff Amendment (Growing Australian Export Opportunities Across the Asia-Pacific) 2019				16/10	21/10	11/11	26/11	3/12	109	45
146	Defence Service Homes Amendment 2019				25/11	28/11	19/9	14/11	9/12	112	172
147	Education Legislation Amendment (2019 Measures No. 1) 2019				16/10	24/10	11/11	14/11	28/11	103	46
148	Education Legislation Amendment (Tuition Protection and Other Measures) 2019				18/9[17]	24/10	11/11	5/12	6/12	111	47
149	Emergency Response Fund (Consequential Amendments) 2019				11/9[20]	17/9	18/9	17/10	28/10	91	49
150	Emergency Response Fund 2019				11/9[18]	17/9	18/9R[19]	17/10	28/10	90	48
151	Fair Work (Registered Organisations) Amendment (Ensuring Integrity No. 2) 2019				4/12	5/12	5/12			0	59	No Jurisdiction			x
152	Fair Work (Registered Organisations) Amendment (Ensuring Integrity) 2019				4/7[27]	31/7	31/7	Negatived in Committee of the Whole 28/11		0	58	No Jurisdiction
153	Fair Work Laws Amendment (Proper Use of Worker Benefits) 2019				4/7[26]	10/9	11/9			0	57	No Jurisdiction			x
154	Family Assistance Legislation Amendment (Building on the Child Care Package) 2019				18/9[28]	25/11H	27/11	5/12	12/12	125	60
155	Family Assistance Legislation Amendment (Extend Family Assistance to ABSTUDY Secondary School Boarding Students Aged 16 and Over) 2019				31/7[29]	10/9	11/9	18/9	20/9	73	61
156	Farm Household Support Amendment (Relief Measures) (No. 1) 2019				17/10[31]	23/10	11/11	12/11	28/11	104	64
157	Farm Household Support Amendment (Relief Measures) (No. 2) 2019				27/11	3/12	5/12	5/12	11/12	117	65
158	Farm Household Support Amendment 2019				4/7	29/7	30/7	30/7	7/8	60	63
159	Foreign Acquisitions and Takeovers Fees Imposition Amendment (Near-new Dwelling Interests) 2019				23/10	27/11	27/11	5/12	12/12	126	70
160	Future Drought Fund (Consequential Amendments) 2019				22/7	22/7	23/7	24/7	30/7	56	72
161	Future Drought Fund 2019				22/7	22/7	23/7	24/7A[34]	30/7	55	71
162	Health Insurance Amendment (Bonded Medical Programs Reform) 2019				31/7	11/9	4/7	31/7	19/9	70	180
163	Health Legislation Amendment (Data-matching and Other Matters) 2019				23/10	27/11	2/12	5/12	12/12	121	73
164	Higher Education Support (Charges) 2019				4/7	11/9	11/9	15/10	28/10	85	76
165	Higher Education Support (HELP Tuition Protection Levy) 2019				18/9[35]	24/10	11/11R[36]			0	74	No Jurisdiction			x
166	Higher Education Support Amendment (Cost Recovery) 2019				4/7	11/9	11/9	15/10	28/10	86	75
167	Inspector-General of Live Animal Exports 2019				11/9	18/9	31/7	10/9A	2/10	81	183
168	Interactive Gambling Amendment (National Self-exclusion Register) 2019				27/11	3/12	5/12	5/12	12/12	127	78
169	Medical and Midwife Indemnity Legislation Amendment 2019				18/9	16/10	17/10	14/11	28/11	105	81
170	Migration Amendment (Repairing Medical Transfers) 2019				4/7[39]	25/7	29/7	4/12	4/12	110	84
171	Migration Amendment (Streamlining Visa Processing) 2019				4/7	11/9	11/9			0	85	No Jurisdiction			x
172	Migration Amendment (Strengthening the Character Test) 2019				4/7[40]	19/9	19/9			0	86	No Jurisdiction			x
173	Military Rehabilitation and Compensation Amendment (Single Treatment Pathway) 2019				4/7	16/9	16/9	5/12	12/12	122	88
174	National Disability Insurance Scheme Amendment (Streamlined Governance) 2019				25/11	27/11	25/7[18]	14/11A	9/12	113	192
175	National Disability Insurance Scheme Amendment (Worker Screening Database) 2019				23/7	19/9	4/7	22/7	2/10	82	193
176	National Health Amendment (Pharmaceutical Benefits) 2019				4/7	11/9	11/9	19/9	2/10	77	92
177	National Health Amendment (Safety Net Thresholds) 2019				11/9	15/10	17/10	14/11	28/11	106	93
178	National Housing Finance and Investment Corporation Amendment 2019				12/9[42]	17/9	18/9	14/10A[43]	18/10	83	94
179	National Rental Affordability Scheme Amendment 2019				24/7	17/10	4/7	22/7A	30/10	97	196
180	National Self-exclusion Register (Cost Recovery Levy) 2019				27/11	3/12	5/12	5/12	12/12	128	96
181	National Sports Tribunal (Consequential Amendments and Transitional Provisions) 2019				24/7	9/9	9/9	11/9	19/9	69	98
182	National Sports Tribunal 2019				24/7	9/9	9/9	11/9	19/9	68	97
183	New Skilled Regional Visas (Consequential Amendments) 2019				31/7[45]	14/10	17/10			0	100	No Jurisdiction			x
184	Offshore Petroleum and Greenhouse Gas Storage (Regulatory Levies) Amendment 2019				25/7[48]	11/9	11/9	16/10	28/10	93	104
185	Offshore Petroleum and Greenhouse Gas Storage Amendment (Miscellaneous Amendments) 2019				25/7[47]	11/9	11/9	16/10	28/10	92	103
186	Paid Parental Leave Amendment (Work Test) 2019				11/9	19/9	19/9	17/10	28/10	84	106
187	Passenger Movement Charge Amendment (Timor Sea Maritime Boundaries Treaty) 2019				4/7	25/7	29/7	29/7	7/8	58	107
188	Protection of the Sea (Prevention of Pollution from Ships) Amendment (Air Pollution) 2019				18/9	16/10	17/10	5/12	12/12	123	109
189	Road Vehicle Standards Legislation Amendment 2019				23/7	9/9	4/7	22/7	13/9	66	206
190	Royal Commissions Amendment (Private Sessions) 2019				25/7	31/7	31/7	10/9A[50]	13/9	64	111
191	Social Security (Administration) Amendment (Cashless Welfare) 2019				25/7	30/7	31/7	1/8	12/8	62	112
192	Social Security (Administration) Amendment (Income Management to Cashless Debit Card Transition) 2019				11/9[51]	27/11H	2/12			0	113	No Jurisdiction			x
193	Social Services Legislation Amendment (Drug Testing Trial) 2019				11/9[52]	17/10	17/10			0	115	No Jurisdiction			x
194	Social Services Legislation Amendment (Overseas Welfare Recipients Integrity Program) 2019				25/7	9/9H	10/9	17/9	20/9	74	117
195	Social Services Legislation Amendment (Payment Integrity) 2019				11/9	2/12	3/12			0	116	No Jurisdiction			x
196	Special Recreational Vessels 2019				27/11	3/12H	5/12	5/12	11/12	118	118
197	Telecommunications (Interception and Access) Amendment (Assistance and Access Amendments Review) 2019				17/10	25/11	27/11	5/12	12/12	124	121
198	Tertiary Education Quality and Standards Agency Amendment 2019				16/9	23/10	25/7	12/9	30/10	98	211
199	Timor Sea Maritime Boundaries Treaty Consequential Amendments 2019				4/7	25/7H	29/7	29/7	7/8	57	125
200	Treasury Laws Amendment (2018 Measures No. 2) 2019				4/7	15/10	17/10			0	128	No Jurisdiction			x
201	Treasury Laws Amendment (2018 Superannuation Measures No. 1) 2019				24/7	12/9	12/9	19/9	2/10	78	129
202	Treasury Laws Amendment (2019 Measures No. 2) 2019				18/9	16/10	17/10	17/10	28/10	94	130
203	Treasury Laws Amendment (2019 Tax Integrity and Other Measures No. 1) 2019				24/7[56]	1/8	1/8	16/10A[57]	28/10	95	132
204	Treasury Laws Amendment (Combating Illegal Phoenixing) 2019				4/7	27/11	27/11			0	133	No Jurisdiction			x
205	Treasury Laws Amendment (Consumer Data Right) 2019				24/7	30/7	31/7	1/8	12/8	63	134
206	Treasury Laws Amendment (Ending Grandfathered Conflicted Remuneration) 2019				1/8	10/9	11/9	14/10	28/10	87	135
207	Treasury Laws Amendment (International Tax Agreements) 2019				19/9	24/10	11/11	14/11	28/11	107	136
208	Treasury Laws Amendment (Making Sure Multinationals Pay Their Fair Share of Tax in Australia and Other Measures) 2019				4/7	31/7	1/8	9/9	13/9	65	137
209	Treasury Laws Amendment (Prohibiting Energy Market Misconduct) 2019				18/9[58]	23/10H	11/11	12/11A[59]	10/12	115	138
210	Treasury Laws Amendment (Putting Members’ Interests First) 2019				4/7[60]	16/9	16/9	19/9A[61]	2/10	79	139
211	Treasury Laws Amendment (Recovering Unpaid Superannuation) 2019				18/9[62]	28/11	2/12			0	140	No Jurisdiction			x
212	Treasury Laws Amendment (Reducing Pressure on Housing Affordability Measures) 2019				23/10	27/11	27/11	5/12	12/12	129	141
213	Treasury Laws Amendment (Tax Relief So Working Australians Keep More Of Their Money) 2019				2/7	2/7	4/7	4/7	5/7	52	144
214	Treasury Laws Amendment (Timor Sea Maritime Boundaries Treaty) 2019				24/7	25/7	29/7	29/7	7/8	59	145
215	VET Student Loans (VSL Tuition Protection Levy) 2019				18/9[64]	24/10	11/11R[65]			0	148	No Jurisdiction			x
216	Veterans’ Affairs Legislation Amendment (Partner Service Pension and Other Measures) 2019				1/8	12/9	12/9	17/9	20/9	75	147
217	Water Amendment (Indigenous Authority Member) 2019				4/7	11/9	12/9	19/9	2/10	80	149
218
219


1	Process to Add a New Bill		h1
2	Ref	Item	Flag	r6474	r6554

3	1	Copy Bill Template	h2	x	x
4	2	Open Bill Template	link	d	d
5	3	Make a Copy of the Bill Template naming it with the Bill's System ID + Title found in the Explanatory memorandum. Only use the third part of the System ID which is r6463 in the example below.	f	d	d
6	4		i	d	d
7	5	In the 'Copy Document' popup turn On 'Copy comments' and click OK	f	d	d
8	6	A copy of the Google Sheet and it's associated Form will be saved to the VoteWrap WebApp folder	f	d	d
9	7		i	d	d
10	8	The Google Sheet will be renamed with System ID + Title. But the Form will still be named Copy of Legislation VoteWrap Template.	f	d	d
11	9	Rename Form.	i	d	d
12	10	Rename the Form to the same, System ID + Title.	f	d	d
13	11	Add Bill LongTitle to Sheet & Form.	h2	d	d
14	12	In the Bill home page follow link 'Text of Bill'	f	d	d
15	13		i	d	d
16	14	Find and copy the Long Title:	f	d	d
17	15		i	d	d
18	16	Go to the 'Calc' sheet and the add the Long Title to cell A3	f	d	d
19	17		i	d	d
20	18	Link to example Clac sheet	link	d	d
21	19	Open the Form in edit mode and add the Long Title to the top description.	f	d	d
22	20		i	d	d
23	21	Update Form ID in updateForm()	H2	d	d
24	22	From the Google sheet Tools menu select Script Editor.	f	d	d
25	23		i	d	d
26	24	To display the AppScript that populates the Representtives dropdown.	f	d	d
27	25		i	d	d
28	26	In the URL for the Form find the Form ID	f	d	d
29	27		i	d	d
30	28	Copy and paste the Form ID from the Google form to the AppScript function updateForm() and Click Save	f	d	d
31	29	Add Trigger to Copied AppScript	H2	d	d
32	30	In the AppScript click on Triggers.	f	d	d
33	31		i	d	d
34	32	To display the Triggers page.	f	d	d
35	33	Add blank trigger page image		d	d
36	34	Add a Trigger to updateForm on Form submit.	f	d	d
37	35		i	d	d
38	36	Select 'Save'			d
39	37	Add message about connecting to account is displayed	f	d	d
40	38		i	d	d
41	39	After connecting to account message 'This app isn't verified' appears.	f	d	d
42	40		i	d	d
43	41	Select 'Go to VoteWrap (unsafe)'	f	d	d
44	42		i	d	d
45	43	Page 'Sign in with Google' page appears.	f	d	d
46	44		i	d	d
47	45	Trigger is added to update reps dropdown list with reps from the new copied Google Sheet	f	d	d
48	46		i	d	d
49	47	Create Prefilled Form	h2	d	d
50	48	From the Google Form in edit mode select 'Get pre-filled link'	f	d	d
51	49		i	d	d
52	50	Set the following values for the following fields:	f	d	d
53	51	Set 'I offer myself as a Representative and declare that I'll faithfully represent the will of the voters who select me to represent them on this matter.' = No	f	d	d
54	52	Set 'Representation' = Self	f	d	d
55	53	Set 'Secret Ballot' = No	f	d	d
56	54	Set 'Finalised' = No	f	d	d
57	55	Set '1. Importance High / Urgency Low' = 70	f	d	d
58	56	Set '2. Importance High / Urgency High = 60	f	d	d
59	57	Set '3. Importance Low / Urgency Low = 60	f	d	d
60	58	Set '4. Importance Low / Urgency High = 50	f	d	d
61	59	Set '1. Importance High / Urgency - Low' = Compulsory	f	d	d
62	60	Set '2. Importance High / Urgency - Medium' = Compulsory	f	d	d
63	61	Set '3. Importance High / Urgency - High' = Voluntary	f	d	d
64	62	Set '4. Importance Medium / Urgency - Low' = Compulsory	f	d	d
65	63	Set '5. Importance Medium / Urgency - Medium' = Voluntary	f	d	d
66	64	Set '6. Importance Medium / Urgency - High' = Voluntary	f	d	d
67	65	Set '7. Importance Low / Urgency - Low' = Voluntary	f	d	d
68	66	Set '8. Importance Low / Urgency - Medium' = Voluntary	f	d	d
69	67	Set '9. Importance Low / Urgency - High = Voluntary	f	d	d
70	68	THEN click 'Get link'	f	d	d
71	69		i	d	d
72	70	THEN click 'COPY LINK'	f	d	d
73	71		i	d	d
74	72	THEN update the hyperlink in the Google Sheet 'Pre Calc' with the copied form url to provide access to the prefilled form.	f	d	d
75	73		i	d	d
76	74	Add new DR Website Bill Page	H2	i	d
77	75	Open the DR website Jiggsy in Edit mode.	f	d	d
78	76	Open the Legislation Template Page.	f	d	d
79	77	Copy the Legislation Template Page and name it with System ID + Title	f	d	d
80	78		i	d	d
81	79	Add the Title	f	d	d
82	80		i	d	d
83	81		i	d	d
84	82	Link the Title to the Bill on the Parliament of Australia website.	f	d	d
85	83		i	d	d
86	84	Update the 'Click here for Details' link with the same link above.	f	d	d
87	85		i	d	d
88	86	Add the Summary text from the PofA Bill page.	f	d	d
89	87		i	d	d
90	88		i	d	d
91	89	Create & Add SquareUp Donation Link			d
92	90	Link for Bill r6554 ASIO Amendments: https://checkout.square.site/pay/863ddf76cbbb46398afb218546cafcce			d
93	91	Publish new Bill To Web	H2	d	d
94	92	Open the New Bill Google sheet at the Dashboard sheet.	f	d	d
95	93		i	d	d
96	94	Select File/Publish to Web and select the Embed tab	f	d	d
97	95		i	d	d
98	96	Click Publish	f	d	d
99	97		i	d	d
100	98	Copy the HTML code to clipboard.	f	d	d
101	99	Go to the new Bill page in the DR Jiggsy Editor.	f	d	d
102	100	Open the Dashboard element in Edit	f	d	d
103	101		i	d	d
104	102	Replace the existing HTML block with the one you copied above.	f	d	d
105	103		i	d	d
106	104	After <iframe Add height="1050" width="950"	f	d	d
107	105	Before headers=false; add chrome=false&	f	d	d
108	106	Change widget=true& to widget=false&	f	d	d
109	107	Click Save to display updated Dashboard.	f	d	d
110	108	Repeat the above process for Reps.	f	d	d
111	109	Get the html to embed the Export Google sheet tab in the 'Dickson Representatives for this Bill' page.		d	d
112	110		i	d	d
113	111	In Jigsy Edit the 'Dickson Representatives for this Bill' page.	f	d	d
114	112		i	d	d
115	113	Paste the new html script.	f	d	d
116	114		i	d	d
117	115	After <iframe Add width="950" height="1200"	f	d	d
118	116	Before headers=false; add chrome=false&	f	d	d
119	117	Click Save to display updated Dashboard.	f	d	d
120	118	Add New Bill to the DR 'Bills to Vote on' page	H2	i	d
121	119	Copy the Title to 'Bill - Long Title'	f	d	d
122	120	Click here for info on Title	link	d	d
123	121		i	d	d
124	122	Hyperlink 'Bill - Long Title' to the DR Bill page.	f	d	d
125	123	EG: =HYPERLINK("http://www.dicksonreps.net/test-legislation","A Bill for an Act about Commonwealth investment in the Australian Business Growth Fund, and for related purposes")	f	d	d
126	124		i	d	d
127	125	To display the Bill's VoteWrap values .......	f	d	d
128	126		i	d	d
129	127	..... use the following function:	f	d	d
130	128	=IMPORTRANGE("url_of_bill_goggle_sheet"Export!A4:P4")")	f	d	d
131	129	Example of "url_of_bill_goggle_sheet" shown below:		d	d
132	130			d	d
133	131	If this message appears:	f	d	d
134	132		i	d	d
135	133	THEN click 'Allow access'	f	d	d
136	134	The VoteWrap values for the Bill are populated.	f	d	d
137	135		i	d	d
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170		Email Form to Reps & Self Representing Voters	h2


1	Proxy Voting
2	#	Step
3
4
5		IF Vote Exists FOR Voter Name THEN VLOOKUP Voter's Represented for this Leg FOR Voter Name ELSE Blank
6		=IF(F2>0,VLOOKUP(B2, 'All Voters'!A$2:K101,11,FALSE),"")
7
8
9
10
11		IF Vote IS "assign proxy vote to representative" THEN Vote IS Zero ELSE IF There are Votes FOR Vote State if($F2<>PreCalc!AD$1,0, if($Z2="yes",COUNTIF(PreCalc!$AI:$AI,$B2)+AJ2,1)))
12		=if($F2="assign proxy vote to representative",0, if($F2<>PreCalc!AD$1,0, if($Z2="yes",COUNTIF(PreCalc!$AI:$AI,$B2)+AJ2,1)))


1	Bill - Short Title	Member for Dickson's Vote	Dickson Vote	Importance	Avg. Import	Urgency	Avg. Urg	Confidence	Yes	Und. - Yes	Undecided	Und. - No	No	Consensus Shortfall	Finalised	Parliament Vote Due	Bill Introduced	Bill Type	Sponsor	Intro House	Passed House	Intro Senate	Passed Senate
2	Australian Security Intelligence Organisation Amendment Bill 2020		No	High	3.00000	Low	1.36364	Low	0.00%	0.00%	0.00%	0.00%	100.00%	-69.09%	No	tba	20200513	Govt	Home Affairs
3	Australian Business Growth Fund 2019		Undecided - Yes	High	3.00000	Medium	2.00000	Medium	0.00%	100.00%	0.00%	0.00%	0.00%	-51.00%	No	tba	20190512	Govt	Treasury	5/12
4	Federal Circuit and Family Court of Australia (Consequential Amendments and Transitional Provisions) 2019		Undecided - Yes	High	3.00000	Medium	2.00000	Medium	0.00%	100.00%	0.00%	0.00%	0.00%	-51.00%	No	tba	20190512	Private	Attorney-General	5/12
5	Federal Circuit and Family Court of Australia 2019																20191205	Govt	Attorney-General	5/12
6	National Consumer Credit Protection Amendment (Mandatory Credit Reporting and Other Measures) 2019																20191205	Govt	Treasury	5/12
7	Treasury Laws Amendment (2019 Measures No. 3) 2019																20191205	Govt	Treasury	5/12
8	Treasury Laws Amendment (Research and Development Tax Incentive) 2019																20191205	Govt	Treasury	5/12
9	Marine Safety (Domestic Commercial Vessel) National Law Amendment (Improving Safety) 2019S																20191205	Private	STERLE, Sen Glenn			5/12
10	Business Names Registration (Fees) Amendment (Registries Modernisation) 2019																20191204	Govt	Treasury	4/12
11	Commonwealth Registers 2019																20191204	Govt	Treasury	4/12
12	Corporations (Fees) Amendment (Registries Modernisation) 2019																20191204	Govt	Treasury	4/12
13	Export Charges (Imposition—Customs) Amendment 2019																20191204	Govt	Agriculture	4/12
14	Export Charges (Imposition—Excise) Amendment 2019																20191204	Govt	Agriculture	4/12
15	Export Charges (Imposition—General) Amendment 2019																20191204	Govt	Agriculture	4/12
16	Export Control (Consequential Amendments and Transitional Provisions) 2019																20191204	Govt	Agriculture	4/12
17	Export Control 2019																20191204	Govt	Agriculture	4/12
18	National Consumer Credit Protection (Fees) Amendment (Registries Modernisation) 2019																20191204	Govt	Treasury	4/12
19	National Vocational Education and Training Regulator Amendment 2019																20191204	Govt	Employment, Skills, Small and Family Business			4/12
20	Offshore Petroleum and Greenhouse Gas Storage (Regulatory Levies) Amendment (Miscellaneous Measures) 2019																20191204	Govt	Industry, Innovation and Science	4/12
21	Offshore Petroleum and Greenhouse Gas Storage Amendment (Cross-boundary Greenhouse Gas Titles and Other Measures) 2019																20191204	Govt	Industry, Innovation and Science	4/12
22	Student Identifiers Amendment (Higher Education) 2019																20191204	Govt	Education	4/12
23	Tertiary Education Quality and Standards Agency Amendment (Prohibiting Academic Cheating Services) 2019																20191204	Govt	Education	4/12
24	Transport Security Amendment (Testing and Training) 2019																20191204	Govt	Home Affairs			4/12
25	Treasury Laws Amendment (Registries Modernisation and Other Measures) 2019																20191204	Govt	Treasury	4/12
26	Telecommunications Amendment (Repairing Assistance and Access) 2019S																20191204	Private	KENEALLY, Sen Kristina			4/12
27	Agriculture Legislation Amendment (Streamlining Administration) 2019																20191202	Govt	Agriculture			2/12
28	Crimes Legislation Amendment (Combatting Corporate Crime) 2019																20191202	Govt	Attorney-General			2/12
29	Wine Australia Amendment (Label Directory) 2019																20191202	Govt	Agriculture			2/12
30	Australian Banks (Government Audit) 2019P																20191202	Private	KATTER, Bob, Jnr, MP	2/12
31	Climate Change Authority Amendment (Impact of 3 Degrees of Global Warming on Australia) 2019P																20191202	Private	BANDT, Adam, MP	2/12
32	Commonwealth Electoral Amendment (Lowering the Donation Disclosure Threshold) 2019P																20191202	Private	SHARKIE, Rebekha, MP	2/12
33	Live Animal Export Prohibition (Ending Cruelty) 2019P																20191202	Private	WILKIE, Andrew, MP	2/12
34	National Consumer Credit Protection Amendment (Small Amount Credit Contract and Consumer Lease Reforms) 2019 (No. 2)S																20191202	Private	GRIFF, Sen Stirling			2/12
35	Public Governance, Performance and Accountability Amendment (Waiver of Debt and Act of Grace Payments) 2019S																20191202	Private	GALLAGHER, Sen Katy			2/12
36	Saving Australian Dairy 2019S																20191202	Private	HANSON, Sen Pauline			2/12
37	Financial Sector Reform (Hayne Royal Commission Response—Protecting Consumers (2019 Measures)) 2019																20191128	Govt	Treasury	28/11
38	Financial Sector Reform (Hayne Royal Commission Response—Stronger Regulators (2019 Measures)) 2019																20191128	Govt	Treasury	28/11
39	Student Identifiers Amendment (Enhanced Student Permissions) 2019																20191128	Govt	Employment, Skills, Small and Family Business	28/11
40	Telecommunications (Regional Broadband Scheme) Charge 2019																20191128	Govt	Communications, Cyber Safety and the Arts	28/11
41	Telecommunications Legislation Amendment (Competition and Consumer) 2019																20191128	Govt	Communications, Cyber Safety and the Arts	28/11
42	Trade Support Loans Amendment (Improving Administration) 2019																20191128	Govt	Employment, Skills, Small and Family Business	28/11
43	Family Law Amendment (Western Australia De Facto Superannuation Splitting and Bankruptcy) 2019																20191127	Govt	Attorney-General	27/11
44	Migration Agents Registration Application Charge Amendment (Rates of Charge) 2019																20191127	Govt	Home Affairs	27/11
45	Migration Amendment (Regulation of Migration Agents) 2019																20191127	Govt	Home Affairs	27/11
46	Treasury Laws Amendment (Your Superannuation, Your Choice) 2019																20191127	Govt	Treasury	27/11
47	Australian Cannabis Agency 2018S,N																20191127	Private	DI NATALE, Sen Richard			27/11
48	Commonwealth Electoral Amendment (Lowering the Donation Disclosure Threshold) 2019S																20191127	Private	SHARKIE, Rebekha, MP			27/11
49	Commonwealth Electoral Amendment (Transparency Measures—Real Time Disclosure) 2019S																20191127	Private	FARRELL, Sen Don			27/11
50	Private Health Insurance Legislation Amendment (Fairer Rules for General Treatments) 2019P																20191125	Private	WILKIE, Andrew, MP	25/11
51	Governor-General Amendment (Cessation of Allowances in the Public Interest) 2019S																20191113	Private	SIEWERT, Sen Rachel			13/11
52	Public Governance, Performance and Accountability Amendment (Tax Transparency in Procurement and Grants) 2019S																20191113	Private	PATRICK, Sen Rex			13/11
53	Official Development Assistance Multilateral Replenishment Obligations (Special Appropriation) 2019																20191024	Govt	Foreign Affairs and Trade	24/10
54	Transport Security Amendment (Serious Crime) 2019																20191023	Govt	Home Affairs	23/10
55	Commonwealth Electoral Amendment (Lowering Voting Age and Increasing Voter Participation) 2019P																20191021	Private	BANDT, Adam, MP	21/10
56	Refugee Protection 2019P																20191021	Private	WILKIE, Andrew, MP	21/10
57	Anti-Money Laundering and Counter-Terrorism Financing and Other Legislation Amendment 2019																20191017	Govt	Home Affairs	17/10
58	Native Title Legislation Amendment 2019																20191017	Govt	Attorney-General	17/10
59	National Integrity (Parliamentary Standards) 2019S																20191017	Private	WATERS, Sen Larissa			17/10
60	Coal Prohibition (Quit Coal) 2019P																20191014	Private	BANDT, Adam, MP	14/10
61	Crimes Legislation Amendment (Age of Criminal Responsibility) 2019P																20191014	Private	SHARKIE, Rebekha, MP	14/10
62	Australian Citizenship Amendment (Citizenship Cessation) 2019																20190918	Govt	Home Affairs	19/9
63	Australian Bill of Rights 2019P																20190916	Private	WILKIE, Andrew, MP	16/9
64	Commonwealth Electoral Amendment (Real Time Disclosure of Political Donations) 2019P																20190916	Private	SHARKIE, Rebekha, MP	16/9
65	Fair Work Amendment (Stop Work to Stop Warming) 2019P																20190916	Private	BANDT, Adam, MP	16/9
66	National Consumer Credit Protection Amendment (Small Amount Credit Contract and Consumer Lease Reforms) 2019P																20190916	Private	SHARKIE, Rebekha, MP	16/9
67	Protecting Australian Dairy 2019S																20190916	Private	HANSON, Sen Pauline			16/10	2°negatived 11/11
68	Family Law (Self-Assessment) 2019S																20190912	Private	HANSON, Sen Pauline			12/9
69	Social Services Legislation Amendment (Better Targeting Student Payments) 2019																20190911	Govt	Social Services	11/9
70	Product Stewardship Amendment (Packaging and Plastics) 2019S																20190911	Private	WHISH-WILSON, Sen Peter			11/9
71	Customs Amendment (Safer Cladding) 2019S																20190910	Private	PATRICK, Sen Rex			10/9
72	National Integrity Commission 2019P																20190909	Private	BANDT, Adam, MP	9/9
73	Australian Passports Amendment (Identity-matching Services) 2019																20190731	Govt	Foreign Affairs and Trade	31/7
74	Identity-matching Services 2019																20190731	Govt	Home Affairs	31/7
75	Australian Broadcasting Corporation Amendment (Rural and Regional Measures) 2019																20190731	Private	SHARKIE, Rebekha, MP	31/7
76	Constitution Alteration (Freedom of Expression and Freedom of the Press) 2019 [No. 2]P																20190729	Private	SHARKIE, Rebekha, MP	29/7
77	Constitution Alteration (Water Resources) 2019 [No. 2]P																20190729	Private	SHARKIE, Rebekha, MP	29/7
78	Intellectual Property Laws Amendment (Productivity Commission Response Part 2 and Other Measures) 2019																20190725	Govt	Industry, Innovation and Science	16/10		25/7	16/10A
79	Great Australian Bight Environment Protection 2019S																20190725	Private	HANSON-YOUNG, Sen Sarah			25/7
80	Human Rights (Parliamentary Scrutiny) Amendment (Australian Freedoms) 2019S																20190723	Private	BERNARDI, Sen Cory			23/7
81	Aged Care Amendment (Staffing Ratio Disclosure) 2019P																20190722	Private	SHARKIE, Rebekha, MP	22/7
82	Aged Care Quality and Safety Commission Amendment (Worker Screening Database) 2019P																20190722	Private	SHARKIE, Rebekha, MP	22/7
83	Banking Amendment (Rural Finance Reform) 2019P																20190722	Private	SHARKIE, Rebekha, MP	22/7
84	Coal-Fired Power Funding Prohibition 2019P																20190722	Private	BANDT, Adam, MP	22/7
85	Environment Protection and Biodiversity Conservation Amendment (Heritage Listing for the Bight) 2019P																20190722	Private	SHARKIE, Rebekha, MP	22/7
86	Live Sheep Long Haul Export Prohibition 2019P																20190722	Private	SHARKIE, Rebekha, MP	22/7
87	Migration Legislation Amendment (Regional Processing Cohort) 2019																20190704	Govt	Home Affairs	4/7
88	Australian Institute of Health and Welfare Amendment (Assisted Reproductive Treatment Statistics) 2019S																20190704	Private	FARUQI, Sen Mehreen			4/7
89	Constitution Alteration (Freedom of Expression and Freedom of the Press) 2019S																20190704	Private	GRIFF, Sen Stirling PATRICK, Sen Rex			4/7
90	Constitution Alteration (Water Resources) 2019S																20190704	Private	PATRICK, Sen Rex			4/7
91	Live Animal Export (Slaughter) Prohibition 2019S																20190704	Private	FARUQI, Sen Mehreen			4/7
92	Agriculture Legislation Repeal 2019Z																20190702	Govt	Prime Minister	2/7
93	Human Services Amendment (Photographic Identification and Fraud Prevention) 2019S,N																20190213	Private	HANSON, Sen Pauline			13/2
94	Murray-Darling Basin Commission of Inquiry 2019S,N																20190213	Private	HANSON-YOUNG, Sen Sarah			13/2
95	Telecommunications Legislation Amendment (Unsolicited Communications) 2019S,N																20190213	Private	GRIFF, Sen Stirling			13/2
96	Broadcasting Services Amendment (Audio Description) 2019S,N																20190212	Private	STEELE-JOHN, Sen Jordon			12/2
97	Competition and Consumer Amendment (Prevention of Exploitation of Indigenous Cultural Expressions) 2019S,N																20190212	Private	HANSON-YOUNG, Sen Sarah			12/2
98	Ministers of State (Checks for Security Purposes) 2019S,N																20190212	Private	PATRICK, Sen Rex			12/2
99	Fair Work Amendment (Restoring Penalty Rates) 2018 [No. 2]S,N																20181411	Private	CAMERON, Sen Doug			14/11
100	National Integrity Commission 2018 (No. 2)S,N																20181129	Private	WATERS, Sen Larissa	10/9		29/11	9/9
101	Australian Research Council Amendment (Ensuring Research Independence) 2018S,N																20181115	Private	FARUQI, Sen Mehreen			15/11
102	Discrimination Free Schools 2018S,N																20181016	Private	DI NATALE, Sen Richard			16/10
103	Social Services Legislation Amendment (Ending the Poverty Trap) 2018S,N																20180910	Private	SIEWERT, Sen Rachel			10/9
104	Australian Multicultural 2018S,N																20180823	Private	DI NATALE, Sen Richard			23/8
105	Freedom of Information Legislation Amendment (Improving Access and Transparency) 2018S,N																20180822	Private	PATRICK, Sen Rex			22/8
106	Plebiscite (Future Migration Level) 2018S,N																20180815	Private	HANSON, Sen Pauline			15/8	2°negatived 29/7
107	Intelligence Services Amendment (Enhanced Parliamentary Oversight of Intelligence Agencies) 2018S,N																20180814	Private	PATRICK, Sen Rex			14/8
108	Commonwealth Electoral Amendment (Lowering Voting Age and Increasing Voter Participation) 2018S,N																20180618	Private	STEELE-JOHN, Sen Jordon			18/6
109	Air Services Amendment 2018S,N																20180327	Private	RICE, Sen Janet			27/3
110	Nuclear Fuel Cycle (Facilitation) 2017S,N																20171411	Private	BERNARDI, Sen Cory			14/11
111	Productivity Commission Amendment (Addressing Inequality) 2017S,N																20171406	Private	MCALLISTER, Sen Jenny			14/6
112	Coal-Fired Power Funding Prohibition 2017S,N																20171017	Private	DI NATALE, Sen Richard			17/10
113	Regional Forest Agreements Legislation (Repeal) 2017S,N																20170907	Private	RICE, Sen Janet			7/9
114	Competition and Consumer Amendment (Truth in Labelling—Palm Oil) 2017S,N																20170621	Private	XENOPHON, Sen Nick			21/6
115	Environment and Infrastructure Legislation Amendment (Stop Adani) 2017S,N																20170613	Private	WATERS, Sen Larissa			13/6
116	Landholders’ Right to Refuse (Gas and Coal) 2015S,N																20150831	Private	WATERS, Sen Larissa			31/8


1	Item	Flag
2	Process to Update Data-Item-ID	h
3	To be used to dynamicaly populate a Drop Down List for a new Google Form from values in a Google Sheet.	f
4	From the Google sheet Tools menu select Script Editor.	f
5		i
6	To display the AppScript for that populates the Representtives dropdown.	f
7		i
8	In the URL for the Form in Edit mode find the Form ID	f
9		i
10	Copy and paste the Form ID from the Google form to the AppScript function updateForm()	f
11	In the Form in Edit mode Right click on dropdown item Representation and select Inspect.	f
12		i
13	Ctrl/F and search for: viewitemcardroot	f
14		i
15	Then click through the search items.	f
16		i
17	Until the Representation drop down element is highlighted. Locate the data-item-id and copy it to the updateForm() function.	f
18		i
19	Delete Data from Sheet	h
20	Go to the Form Response 1 sheet and delete all the copied entries.	f
21		i
22
23	Publish the Google Sheets 'Reps' page to the Web as a link.
24	Copy the Link.
25	Update the 'Representatives' hyperlink on the 'Mobile' & 'Dashboard' pages.