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	Ref	Item	Flag	r6474
2		Process to Add a New Bill	h1

3		Copy Bill Template	h2	d
4		Open Bill Template	link	d
5		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
6			i	d
7		In the 'Copy Document' popup turn On 'Copy comments' and click OK	f	d
8		A copy of the Google Sheet and it's associated Form will be saved to the VoteWrap WebApp folder	f	d
9			i	d
10		The Google Sheet will be renamed with System ID + Title. But the Form will still be named Copy of Legislation VoteWrap Template.	f	d
11		Rename Form.	i	d
12		Rename the Form to the same, System ID + Title.	f	d
13		Add Bill LongTitle to Sheet & Form.	h2	d
14		In the Bill home page follow link 'Text of Bill'	f	d
15			i	d
16		Find and copy the Long Title:	f	d
17			i	d
18		Go to the 'Calc' sheet and the add the Long Title to cell A3	f	d
19			i	d
20		Link to example Clac sheet	link	d
21		Open the Form in edit mode and add the Long Title to the top description.	f	d
22			i	d
23		Update Form ID in updateForm()	H2	d
24		From the Google sheet Tools menu select Script Editor.	f	d
25			i	d
26		To display the AppScript for that populates the Representtives dropdown.	f	d
27			i	d
28		In the URL for the Form find the Form ID	f	d
29			i	d
30		Copy and paste the Form ID from the Google form to the AppScript function updateForm()	f	d
31		Add Trigger to Copied AppScript	H2	d
32		In the AppScript click on Triggers.	f	d
33			i	d
34		To display the Triggers page.	f	d
35			i	d
36		Add a Trigger to updateForm on Form submit.	f	d
37			i	d
38		Add message about connecting to account	f	d
39			i	d
40		After connecting to account message 'This app isn't verified' appears.	f	d
41			i	d
42		Select 'Go to VoteWrap (unsafe)'	f	d
43			i	d
44		Page 'Sign in with Google' page appears.	f	d
45			i	d
46		Select 'Save'	d	d
47			i	d
48		Trigger is added to update reps dropdown list with reps from the new copied Google Sheet	f	d
49		Add new DR Website Bill Page	H2	i
50		Open the DR website Jiggsy in Edit mode.	f	d
51		Open the Legislation Template Page.	f	d
52		Copy the Legislation Template Page and name it with System ID + Title	f	d
53			i	d
54		Add the Title	f	d
55			i	d
56			i	d
57		Link the Title to the Bill on the Parliament of Australia website.	f	d
58			i	d
59		Update the 'Click here for Details' link with the same link above.	f	d
60			i	d
61		Add the Summary text from the PofA Bill page.	f	d
62			i	d
63			i	d
64		Publish new Bill To Web	H2	d
65		Open the New Bill Google sheet at the Dashboard sheet.	f	d
66			i	d
67		Select File/Publish to Web and select the Embed tab	f	d
68			i	d
69		Click Publish	f	d
70			i	d
71		Copy the HTML code to clipboard.	f	d
72		Go to the new Bill page in the DR Jiggsy Editor.	f	d
73		Open the Dashboard element in Edit	f	d
74			i	d
75		Replace the existing HTML block with the one you copied above.	f	d
76			i	d
77		After <iframe Add height="1050" width="950"	f	d
78		Before headers=false; add chrome=false&	f	d
79		Change widget=true& to widget=false&	f	d
80		Click Save to display updated Dashboard.	f	d
81		Repeat the above process for Reps.	f	d
82		Get the html to embed the Export Google sheet tab in the 'Dickson Representatives for this Bill' page.		d
83			i	d
84		In Jigsy Edit the 'Dickson Representatives for this Bill' page.	f	d
85			i	d
86		Paste the new html script.	f	d
87			i	d
88		After <iframe Add width="950" height="1200"	f	d
89		Before headers=false; add chrome=false&	f	d
90		Click Save to display updated Dashboard.	f	d
91		Add New Bill to the DR 'Bills to Vote on' page	H2	i
92		Copy the Title to 'Bill - Long Title'	f	d
93		Click here for info on Title	link	d
94			i	d
95		Hyperlink 'Bill - Long Title' to the DR Bill page.	f	d
96		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
97			i	d
98		To display the Bill's VoteWrap values .......	f	d
99			i	d
100		..... use the following function:	f	d
101		=IMPORTRANGE("url_of_bill_goggle_sheet"Export!A4:P4")")	f	d
102		Example of "url_of_bill_goggle_sheet" shown below:		d
103				d
104		If this message appears:	f	d
105			i	d
106		THEN click 'Allow access'	f	d
107		The VoteWrap values for the Bill are populated.	f	d
108			i	d
109		Create Prefilled Form	h2	d
110		From the Google Form in edit mode select 'Get pre-filled link'	f	d
111			i	d
112		Set the following values fpr the following fields:	f	d
113		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
114		Set 'Representation' = Self	f	d
115		Set 'Secret Ballot' = No	f	d
116		Set 'Finalised' = No	f	d
117		Set '1. Importance High / Urgency Low' = 51	f	d
118		Set '2. Importance High / Urgency High = 51	f	d
119		Set '3. Importance Low / Urgency Low = 51	f	d
120		Set '4. Importance Low / Urgency High = 51	f	d
121		Set '1. Importance High / Urgency - Low' = Compulsory	f	d
122		Set '2. Importance High / Urgency - Medium' = Compulsory	f	d
123		Set '3. Importance High / Urgency - High' = Voluntary	f	d
124		Set '4. Importance Medium / Urgency - Low' = Compulsory	f	d
125		Set '5. Importance Medium / Urgency - Medium' = Voluntary	f	d
126		Set '6. Importance Medium / Urgency - High' = Voluntary	f	d
127		Set '7. Importance Low / Urgency - Low' = Voluntary	f	d
128		Set '8. Importance Low / Urgency - Medium' = Voluntary	f	d
129		Set '9. Importance Low / Urgency - High = Voluntary	f	d
130		THEN click 'Get link'	f	d
131			i	d
132		THEN click 'COPY LINK'	f	d
133			i	d
134		THEN update the hyperlink in the Google Sheet 'Pre Calc' with the copied form url to provide access to the prefilled form.	f	d
135			i	d
136
137
138
139
140
141		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	Vote Status	Importance	Avg. Import	Urgency	Avg. Urg	Confidence	Yes	Und. - Yes	Undecided	Und. - No	No	Consensus Shortfall	Finalised	Parliament Vote Due	Bill Introduced	Dutton's Vote	Bill Type	Sponsor	Intro House	Passed House	Intro Senate	Passed Senate
2	Australian Business Growth Fund 2019	Undecided - Yes	Medium	2.10000	Medium	2.10000	Medium	10.00%	50.00%	40.00%	0.00%	0.00%	-41.00%	No	tba	20190512		Govt	Treasury	5/12
3	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
4	Federal Circuit and Family Court of Australia 2019															20191205		Govt	Attorney-General	5/12
5	National Consumer Credit Protection Amendment (Mandatory Credit Reporting and Other Measures) 2019															20191205		Govt	Treasury	5/12
6	Treasury Laws Amendment (2019 Measures No. 3) 2019															20191205		Govt	Treasury	5/12
7	Treasury Laws Amendment (Research and Development Tax Incentive) 2019															20191205		Govt	Treasury	5/12
8	Marine Safety (Domestic Commercial Vessel) National Law Amendment (Improving Safety) 2019S															20191205		Private	STERLE, Sen Glenn			5/12
9	Business Names Registration (Fees) Amendment (Registries Modernisation) 2019															20191204		Govt	Treasury	4/12
10	Commonwealth Registers 2019															20191204		Govt	Treasury	4/12
11	Corporations (Fees) Amendment (Registries Modernisation) 2019															20191204		Govt	Treasury	4/12
12	Export Charges (Imposition—Customs) Amendment 2019															20191204		Govt	Agriculture	4/12
13	Export Charges (Imposition—Excise) Amendment 2019															20191204		Govt	Agriculture	4/12
14	Export Charges (Imposition—General) Amendment 2019															20191204		Govt	Agriculture	4/12
15	Export Control (Consequential Amendments and Transitional Provisions) 2019															20191204		Govt	Agriculture	4/12
16	Export Control 2019															20191204		Govt	Agriculture	4/12
17	National Consumer Credit Protection (Fees) Amendment (Registries Modernisation) 2019															20191204		Govt	Treasury	4/12
18	National Vocational Education and Training Regulator Amendment 2019															20191204		Govt	Employment, Skills, Small and Family Business			4/12
19	Offshore Petroleum and Greenhouse Gas Storage (Regulatory Levies) Amendment (Miscellaneous Measures) 2019															20191204		Govt	Industry, Innovation and Science	4/12
20	Offshore Petroleum and Greenhouse Gas Storage Amendment (Cross-boundary Greenhouse Gas Titles and Other Measures) 2019															20191204		Govt	Industry, Innovation and Science	4/12
21	Student Identifiers Amendment (Higher Education) 2019															20191204		Govt	Education	4/12
22	Tertiary Education Quality and Standards Agency Amendment (Prohibiting Academic Cheating Services) 2019															20191204		Govt	Education	4/12
23	Transport Security Amendment (Testing and Training) 2019															20191204		Govt	Home Affairs			4/12
24	Treasury Laws Amendment (Registries Modernisation and Other Measures) 2019															20191204		Govt	Treasury	4/12
25	Telecommunications Amendment (Repairing Assistance and Access) 2019S															20191204		Private	KENEALLY, Sen Kristina			4/12
26	Agriculture Legislation Amendment (Streamlining Administration) 2019															20191202		Govt	Agriculture			2/12
27	Crimes Legislation Amendment (Combatting Corporate Crime) 2019															20191202		Govt	Attorney-General			2/12
28	Wine Australia Amendment (Label Directory) 2019															20191202		Govt	Agriculture			2/12
29	Australian Banks (Government Audit) 2019P															20191202		Private	KATTER, Bob, Jnr, MP	2/12
30	Climate Change Authority Amendment (Impact of 3 Degrees of Global Warming on Australia) 2019P															20191202		Private	BANDT, Adam, MP	2/12
31	Commonwealth Electoral Amendment (Lowering the Donation Disclosure Threshold) 2019P															20191202		Private	SHARKIE, Rebekha, MP	2/12
32	Live Animal Export Prohibition (Ending Cruelty) 2019P															20191202		Private	WILKIE, Andrew, MP	2/12
33	National Consumer Credit Protection Amendment (Small Amount Credit Contract and Consumer Lease Reforms) 2019 (No. 2)S															20191202		Private	GRIFF, Sen Stirling			2/12
34	Public Governance, Performance and Accountability Amendment (Waiver of Debt and Act of Grace Payments) 2019S															20191202		Private	GALLAGHER, Sen Katy			2/12
35	Saving Australian Dairy 2019S															20191202		Private	HANSON, Sen Pauline			2/12
36	Financial Sector Reform (Hayne Royal Commission Response—Protecting Consumers (2019 Measures)) 2019															20191128		Govt	Treasury	28/11
37	Financial Sector Reform (Hayne Royal Commission Response—Stronger Regulators (2019 Measures)) 2019															20191128		Govt	Treasury	28/11
38	Student Identifiers Amendment (Enhanced Student Permissions) 2019															20191128		Govt	Employment, Skills, Small and Family Business	28/11
39	Telecommunications (Regional Broadband Scheme) Charge 2019															20191128		Govt	Communications, Cyber Safety and the Arts	28/11
40	Telecommunications Legislation Amendment (Competition and Consumer) 2019															20191128		Govt	Communications, Cyber Safety and the Arts	28/11
41	Trade Support Loans Amendment (Improving Administration) 2019															20191128		Govt	Employment, Skills, Small and Family Business	28/11
42	Family Law Amendment (Western Australia De Facto Superannuation Splitting and Bankruptcy) 2019															20191127		Govt	Attorney-General	27/11
43	Migration Agents Registration Application Charge Amendment (Rates of Charge) 2019															20191127		Govt	Home Affairs	27/11
44	Migration Amendment (Regulation of Migration Agents) 2019															20191127		Govt	Home Affairs	27/11
45	Treasury Laws Amendment (Your Superannuation, Your Choice) 2019															20191127		Govt	Treasury	27/11
46	Australian Cannabis Agency 2018S,N															20191127		Private	DI NATALE, Sen Richard			27/11
47	Commonwealth Electoral Amendment (Lowering the Donation Disclosure Threshold) 2019S															20191127		Private	SHARKIE, Rebekha, MP			27/11
48	Commonwealth Electoral Amendment (Transparency Measures—Real Time Disclosure) 2019S															20191127		Private	FARRELL, Sen Don			27/11
49	Private Health Insurance Legislation Amendment (Fairer Rules for General Treatments) 2019P															20191125		Private	WILKIE, Andrew, MP	25/11
50	Governor-General Amendment (Cessation of Allowances in the Public Interest) 2019S															20191113		Private	SIEWERT, Sen Rachel			13/11
51	Public Governance, Performance and Accountability Amendment (Tax Transparency in Procurement and Grants) 2019S															20191113		Private	PATRICK, Sen Rex			13/11
52	Official Development Assistance Multilateral Replenishment Obligations (Special Appropriation) 2019															20191024		Govt	Foreign Affairs and Trade	24/10
53	Transport Security Amendment (Serious Crime) 2019															20191023		Govt	Home Affairs	23/10
54	Commonwealth Electoral Amendment (Lowering Voting Age and Increasing Voter Participation) 2019P															20191021		Private	BANDT, Adam, MP	21/10
55	Refugee Protection 2019P															20191021		Private	WILKIE, Andrew, MP	21/10
56	Anti-Money Laundering and Counter-Terrorism Financing and Other Legislation Amendment 2019															20191017		Govt	Home Affairs	17/10
57	Native Title Legislation Amendment 2019															20191017		Govt	Attorney-General	17/10
58	National Integrity (Parliamentary Standards) 2019S															20191017		Private	WATERS, Sen Larissa			17/10
59	Coal Prohibition (Quit Coal) 2019P															20191014		Private	BANDT, Adam, MP	14/10
60	Crimes Legislation Amendment (Age of Criminal Responsibility) 2019P															20191014		Private	SHARKIE, Rebekha, MP	14/10
61	Australian Citizenship Amendment (Citizenship Cessation) 2019															20190918		Govt	Home Affairs	19/9
62	Australian Bill of Rights 2019P															20190916		Private	WILKIE, Andrew, MP	16/9
63	Commonwealth Electoral Amendment (Real Time Disclosure of Political Donations) 2019P															20190916		Private	SHARKIE, Rebekha, MP	16/9
64	Fair Work Amendment (Stop Work to Stop Warming) 2019P															20190916		Private	BANDT, Adam, MP	16/9
65	National Consumer Credit Protection Amendment (Small Amount Credit Contract and Consumer Lease Reforms) 2019P															20190916		Private	SHARKIE, Rebekha, MP	16/9
66	Protecting Australian Dairy 2019S															20190916		Private	HANSON, Sen Pauline			16/10	2°negatived 11/11
67	Family Law (Self-Assessment) 2019S															20190912		Private	HANSON, Sen Pauline			12/9
68	Social Services Legislation Amendment (Better Targeting Student Payments) 2019															20190911		Govt	Social Services	11/9
69	Product Stewardship Amendment (Packaging and Plastics) 2019S															20190911		Private	WHISH-WILSON, Sen Peter			11/9
70	Customs Amendment (Safer Cladding) 2019S															20190910		Private	PATRICK, Sen Rex			10/9
71	National Integrity Commission 2019P															20190909		Private	BANDT, Adam, MP	9/9
72	Australian Passports Amendment (Identity-matching Services) 2019															20190731		Govt	Foreign Affairs and Trade	31/7
73	Identity-matching Services 2019															20190731		Govt	Home Affairs	31/7
74	Australian Broadcasting Corporation Amendment (Rural and Regional Measures) 2019															20190731		Private	SHARKIE, Rebekha, MP	31/7
75	Constitution Alteration (Freedom of Expression and Freedom of the Press) 2019 [No. 2]P															20190729		Private	SHARKIE, Rebekha, MP	29/7
76	Constitution Alteration (Water Resources) 2019 [No. 2]P															20190729		Private	SHARKIE, Rebekha, MP	29/7
77	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
78	Great Australian Bight Environment Protection 2019S															20190725		Private	HANSON-YOUNG, Sen Sarah			25/7
79	Human Rights (Parliamentary Scrutiny) Amendment (Australian Freedoms) 2019S															20190723		Private	BERNARDI, Sen Cory			23/7
80	Aged Care Amendment (Staffing Ratio Disclosure) 2019P															20190722		Private	SHARKIE, Rebekha, MP	22/7
81	Aged Care Quality and Safety Commission Amendment (Worker Screening Database) 2019P															20190722		Private	SHARKIE, Rebekha, MP	22/7
82	Banking Amendment (Rural Finance Reform) 2019P															20190722		Private	SHARKIE, Rebekha, MP	22/7
83	Coal-Fired Power Funding Prohibition 2019P															20190722		Private	BANDT, Adam, MP	22/7
84	Environment Protection and Biodiversity Conservation Amendment (Heritage Listing for the Bight) 2019P															20190722		Private	SHARKIE, Rebekha, MP	22/7
85	Live Sheep Long Haul Export Prohibition 2019P															20190722		Private	SHARKIE, Rebekha, MP	22/7
86	Migration Legislation Amendment (Regional Processing Cohort) 2019															20190704		Govt	Home Affairs	4/7
87	Australian Institute of Health and Welfare Amendment (Assisted Reproductive Treatment Statistics) 2019S															20190704		Private	FARUQI, Sen Mehreen			4/7
88	Constitution Alteration (Freedom of Expression and Freedom of the Press) 2019S															20190704		Private	GRIFF, Sen Stirling PATRICK, Sen Rex			4/7
89	Constitution Alteration (Water Resources) 2019S															20190704		Private	PATRICK, Sen Rex			4/7
90	Live Animal Export (Slaughter) Prohibition 2019S															20190704		Private	FARUQI, Sen Mehreen			4/7
91	Agriculture Legislation Repeal 2019Z															20190702		Govt	Prime Minister	2/7
92	Human Services Amendment (Photographic Identification and Fraud Prevention) 2019S,N															20190213		Private	HANSON, Sen Pauline			13/2
93	Murray-Darling Basin Commission of Inquiry 2019S,N															20190213		Private	HANSON-YOUNG, Sen Sarah			13/2
94	Telecommunications Legislation Amendment (Unsolicited Communications) 2019S,N															20190213		Private	GRIFF, Sen Stirling			13/2
95	Broadcasting Services Amendment (Audio Description) 2019S,N															20190212		Private	STEELE-JOHN, Sen Jordon			12/2
96	Competition and Consumer Amendment (Prevention of Exploitation of Indigenous Cultural Expressions) 2019S,N															20190212		Private	HANSON-YOUNG, Sen Sarah			12/2
97	Ministers of State (Checks for Security Purposes) 2019S,N															20190212		Private	PATRICK, Sen Rex			12/2
98	Fair Work Amendment (Restoring Penalty Rates) 2018 [No. 2]S,N															20181411		Private	CAMERON, Sen Doug			14/11
99	National Integrity Commission 2018 (No. 2)S,N															20181129		Private	WATERS, Sen Larissa	10/9		29/11	9/9
100	Australian Research Council Amendment (Ensuring Research Independence) 2018S,N															20181115		Private	FARUQI, Sen Mehreen			15/11
101	Discrimination Free Schools 2018S,N															20181016		Private	DI NATALE, Sen Richard			16/10
102	Social Services Legislation Amendment (Ending the Poverty Trap) 2018S,N															20180910		Private	SIEWERT, Sen Rachel			10/9
103	Australian Multicultural 2018S,N															20180823		Private	DI NATALE, Sen Richard			23/8
104	Freedom of Information Legislation Amendment (Improving Access and Transparency) 2018S,N															20180822		Private	PATRICK, Sen Rex			22/8
105	Plebiscite (Future Migration Level) 2018S,N															20180815		Private	HANSON, Sen Pauline			15/8	2°negatived 29/7
106	Intelligence Services Amendment (Enhanced Parliamentary Oversight of Intelligence Agencies) 2018S,N															20180814		Private	PATRICK, Sen Rex			14/8
107	Commonwealth Electoral Amendment (Lowering Voting Age and Increasing Voter Participation) 2018S,N															20180618		Private	STEELE-JOHN, Sen Jordon			18/6
108	Air Services Amendment 2018S,N															20180327		Private	RICE, Sen Janet			27/3
109	Nuclear Fuel Cycle (Facilitation) 2017S,N															20171411		Private	BERNARDI, Sen Cory			14/11
110	Productivity Commission Amendment (Addressing Inequality) 2017S,N															20171406		Private	MCALLISTER, Sen Jenny			14/6
111	Coal-Fired Power Funding Prohibition 2017S,N															20171017		Private	DI NATALE, Sen Richard			17/10
112	Regional Forest Agreements Legislation (Repeal) 2017S,N															20170907		Private	RICE, Sen Janet			7/9
113	Competition and Consumer Amendment (Truth in Labelling—Palm Oil) 2017S,N															20170621		Private	XENOPHON, Sen Nick			21/6
114	Environment and Infrastructure Legislation Amendment (Stop Adani) 2017S,N															20170613		Private	WATERS, Sen Larissa			13/6
115	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.