1
Bill - Short TitleMember for Dickson's VoteDickson VoteImportanceAvg. ImportUrgencyAvg. UrgConfidenceYesUnd. - YesUndecidedUnd. - NoNoConsensus ShortfallFinalisedParliament Vote DueBill IntroducedBill TypeSponsorIntro HousePassed HouseIntro SenatePassed Senate
2
Australian Security Intelligence Organisation Amendment Bill 2020NoHigh3.00000Low1.36364Low0.00%0.00%0.00%0.00%100.00%-69.09%Notba20200513GovtHome Affairs
3
Australian Business Growth Fund 2019
Undecided - Yes
High3.00000Medium2.00000Medium0.00%100.00%0.00%0.00%0.00%-51.00%Notba20190512GovtTreasury5/12
4
Federal Circuit and Family Court of Australia (Consequential Amendments and Transitional Provisions) 2019
Undecided - Yes
High3.00000Medium2.00000Medium0.00%100.00%0.00%0.00%0.00%-51.00%Notba20190512PrivateAttorney-General5/12
5
Federal Circuit and Family Court of Australia 201920191205GovtAttorney-General5/12
6
National Consumer Credit Protection Amendment (Mandatory Credit Reporting and Other Measures) 201920191205GovtTreasury5/12
7
Treasury Laws Amendment (2019 Measures No. 3) 201920191205GovtTreasury5/12
8
Treasury Laws Amendment (Research and Development Tax Incentive) 201920191205GovtTreasury5/12
9
Marine Safety (Domestic Commercial Vessel) National Law Amendment (Improving Safety) 2019S20191205PrivateSTERLE, Sen Glenn5/12
10
Business Names Registration (Fees) Amendment (Registries Modernisation) 201920191204GovtTreasury4/12
11
Commonwealth Registers 201920191204GovtTreasury4/12
12
Corporations (Fees) Amendment (Registries Modernisation) 201920191204GovtTreasury4/12
13
Export Charges (Imposition—Customs) Amendment 201920191204GovtAgriculture4/12
14
Export Charges (Imposition—Excise) Amendment 201920191204GovtAgriculture4/12
15
Export Charges (Imposition—General) Amendment 201920191204GovtAgriculture4/12
16
Export Control (Consequential Amendments and Transitional Provisions) 201920191204GovtAgriculture4/12
17
Export Control 201920191204GovtAgriculture4/12
18
National Consumer Credit Protection (Fees) Amendment (Registries Modernisation) 201920191204GovtTreasury4/12
19
National Vocational Education and Training Regulator Amendment 201920191204Govt
Employment, Skills, Small and Family Business
4/12
20
Offshore Petroleum and Greenhouse Gas Storage (Regulatory Levies) Amendment (Miscellaneous Measures) 201920191204GovtIndustry, Innovation and Science4/12
21
Offshore Petroleum and Greenhouse Gas Storage Amendment (Cross-boundary Greenhouse Gas Titles and Other Measures) 201920191204GovtIndustry, Innovation and Science4/12
22
Student Identifiers Amendment (Higher Education) 201920191204GovtEducation4/12
23
Tertiary Education Quality and Standards Agency Amendment (Prohibiting Academic Cheating Services) 201920191204GovtEducation4/12
24
Transport Security Amendment (Testing and Training) 201920191204GovtHome Affairs4/12
25
Treasury Laws Amendment (Registries Modernisation and Other Measures) 201920191204GovtTreasury4/12
26
Telecommunications Amendment (Repairing Assistance and Access) 2019S20191204PrivateKENEALLY, Sen Kristina4/12
27
Agriculture Legislation Amendment (Streamlining Administration) 201920191202GovtAgriculture2/12
28
Crimes Legislation Amendment (Combatting Corporate Crime) 201920191202GovtAttorney-General2/12
29
Wine Australia Amendment (Label Directory) 201920191202GovtAgriculture2/12
30
Australian Banks (Government Audit) 2019P20191202PrivateKATTER, Bob, Jnr, MP2/12
31
Climate Change Authority Amendment (Impact of 3 Degrees of Global Warming on Australia) 2019P20191202PrivateBANDT, Adam, MP2/12
32
Commonwealth Electoral Amendment (Lowering the Donation Disclosure Threshold) 2019P20191202PrivateSHARKIE, Rebekha, MP2/12
33
Live Animal Export Prohibition (Ending Cruelty) 2019P20191202PrivateWILKIE, Andrew, MP2/12
34
National Consumer Credit Protection Amendment (Small Amount Credit Contract and Consumer Lease Reforms) 2019 (No. 2)S20191202PrivateGRIFF, Sen Stirling2/12
35
Public Governance, Performance and Accountability Amendment (Waiver of Debt and Act of Grace Payments) 2019S20191202PrivateGALLAGHER, Sen Katy2/12
36
Saving Australian Dairy 2019S20191202PrivateHANSON, Sen Pauline2/12
37
Financial Sector Reform (Hayne Royal Commission Response—Protecting Consumers (2019 Measures)) 201920191128GovtTreasury28/11
38
Financial Sector Reform (Hayne Royal Commission Response—Stronger Regulators (2019 Measures)) 201920191128GovtTreasury28/11
39
Student Identifiers Amendment (Enhanced Student Permissions) 201920191128Govt
Employment, Skills, Small and Family Business
28/11
40
Telecommunications (Regional Broadband Scheme) Charge 201920191128GovtCommunications, Cyber Safety and the Arts28/11
41
Telecommunications Legislation Amendment (Competition and Consumer) 201920191128GovtCommunications, Cyber Safety and the Arts28/11
42
Trade Support Loans Amendment (Improving Administration) 201920191128Govt
Employment, Skills, Small and Family Business
28/11
43
Family Law Amendment (Western Australia De Facto Superannuation Splitting and Bankruptcy) 201920191127GovtAttorney-General27/11
44
Migration Agents Registration Application Charge Amendment (Rates of Charge) 201920191127GovtHome Affairs27/11
45
Migration Amendment (Regulation of Migration Agents) 201920191127GovtHome Affairs27/11
46
Treasury Laws Amendment (Your Superannuation, Your Choice) 201920191127GovtTreasury27/11
47
Australian Cannabis Agency 2018S,N20191127PrivateDI NATALE, Sen Richard27/11
48
Commonwealth Electoral Amendment (Lowering the Donation Disclosure Threshold) 2019S20191127PrivateSHARKIE, Rebekha, MP27/11
49
Commonwealth Electoral Amendment (Transparency Measures—Real Time Disclosure) 2019S20191127PrivateFARRELL, Sen Don27/11
50
Private Health Insurance Legislation Amendment (Fairer Rules for General Treatments) 2019P20191125PrivateWILKIE, Andrew, MP25/11
51
Governor-General Amendment (Cessation of Allowances in the Public Interest) 2019S20191113PrivateSIEWERT, Sen Rachel13/11
52
Public Governance, Performance and Accountability Amendment (Tax Transparency in Procurement and Grants) 2019S20191113PrivatePATRICK, Sen Rex13/11
53
Official Development Assistance Multilateral Replenishment Obligations (Special Appropriation) 201920191024GovtForeign Affairs and Trade24/10
54
Transport Security Amendment (Serious Crime) 201920191023GovtHome Affairs23/10
55
Commonwealth Electoral Amendment (Lowering Voting Age and Increasing Voter Participation) 2019P20191021PrivateBANDT, Adam, MP21/10
56
Refugee Protection 2019P20191021PrivateWILKIE, Andrew, MP21/10
57
Anti-Money Laundering and Counter-Terrorism Financing and Other Legislation Amendment 201920191017GovtHome Affairs17/10
58
Native Title Legislation Amendment 201920191017GovtAttorney-General17/10
59
National Integrity (Parliamentary Standards) 2019S20191017PrivateWATERS, Sen Larissa17/10
60
Coal Prohibition (Quit Coal) 2019P20191014PrivateBANDT, Adam, MP14/10
61
Crimes Legislation Amendment (Age of Criminal Responsibility) 2019P20191014PrivateSHARKIE, Rebekha, MP14/10
62
Australian Citizenship Amendment (Citizenship Cessation) 201920190918GovtHome Affairs19/9
63
Australian Bill of Rights 2019P20190916PrivateWILKIE, Andrew, MP16/9
64
Commonwealth Electoral Amendment (Real Time Disclosure of Political Donations) 2019P20190916PrivateSHARKIE, Rebekha, MP16/9
65
Fair Work Amendment (Stop Work to Stop Warming) 2019P20190916PrivateBANDT, Adam, MP16/9
66
National Consumer Credit Protection Amendment (Small Amount Credit Contract and Consumer Lease Reforms) 2019P20190916PrivateSHARKIE, Rebekha, MP16/9
67
Protecting Australian Dairy 2019S20190916PrivateHANSON, Sen Pauline16/10
2°negatived
11/11
68
Family Law (Self-Assessment) 2019S20190912PrivateHANSON, Sen Pauline12/9
69
Social Services Legislation Amendment (Better Targeting Student Payments) 201920190911GovtSocial Services11/9
70
Product Stewardship Amendment (Packaging and Plastics) 2019S20190911PrivateWHISH-WILSON, Sen Peter11/9
71
Customs Amendment (Safer Cladding) 2019S20190910PrivatePATRICK, Sen Rex10/9
72
National Integrity Commission 2019P20190909PrivateBANDT, Adam, MP9/9
73
Australian Passports Amendment (Identity-matching Services) 201920190731GovtForeign Affairs and Trade31/7
74
Identity-matching Services 201920190731GovtHome Affairs31/7
75
Australian Broadcasting Corporation Amendment (Rural and Regional Measures) 201920190731PrivateSHARKIE, Rebekha, MP31/7
76
Constitution Alteration (Freedom of Expression and Freedom of the Press) 2019 [No. 2]P20190729PrivateSHARKIE, Rebekha, MP29/7
77
Constitution Alteration (Water Resources) 2019 [No. 2]P20190729PrivateSHARKIE, Rebekha, MP29/7
78
Intellectual Property Laws Amendment (Productivity Commission Response Part 2 and Other Measures) 201920190725GovtIndustry, Innovation and Science16/1025/716/10A
79
Great Australian Bight Environment Protection 2019S20190725PrivateHANSON-YOUNG, Sen Sarah25/7
80
Human Rights (Parliamentary Scrutiny) Amendment (Australian Freedoms) 2019S20190723PrivateBERNARDI, Sen Cory23/7
81
Aged Care Amendment (Staffing Ratio Disclosure) 2019P20190722PrivateSHARKIE, Rebekha, MP22/7
82
Aged Care Quality and Safety Commission Amendment (Worker Screening Database) 2019P20190722PrivateSHARKIE, Rebekha, MP22/7
83
Banking Amendment (Rural Finance Reform) 2019P20190722PrivateSHARKIE, Rebekha, MP22/7
84
Coal-Fired Power Funding Prohibition 2019P20190722PrivateBANDT, Adam, MP22/7
85
Environment Protection and Biodiversity Conservation Amendment (Heritage Listing for the Bight) 2019P20190722PrivateSHARKIE, Rebekha, MP22/7
86
Live Sheep Long Haul Export Prohibition 2019P20190722PrivateSHARKIE, Rebekha, MP22/7
87
Migration Legislation Amendment (Regional Processing Cohort) 201920190704GovtHome Affairs4/7
88
Australian Institute of Health and Welfare Amendment (Assisted Reproductive Treatment Statistics) 2019S20190704PrivateFARUQI, Sen Mehreen4/7
89
Constitution Alteration (Freedom of Expression and Freedom of the Press) 2019S20190704PrivateGRIFF, Sen Stirling PATRICK, Sen Rex4/7
90
Constitution Alteration (Water Resources) 2019S20190704PrivatePATRICK, Sen Rex4/7
91
Live Animal Export (Slaughter) Prohibition 2019S20190704PrivateFARUQI, Sen Mehreen4/7
92
Agriculture Legislation Repeal 2019Z20190702GovtPrime Minister2/7
93
Human Services Amendment (Photographic Identification and Fraud Prevention) 2019S,N20190213PrivateHANSON, Sen Pauline 13/2
94
Murray-Darling Basin Commission of Inquiry 2019S,N20190213PrivateHANSON-YOUNG, Sen Sarah13/2
95
Telecommunications Legislation Amendment (Unsolicited Communications) 2019S,N20190213PrivateGRIFF, Sen Stirling13/2
96
Broadcasting Services Amendment (Audio Description) 2019S,N20190212PrivateSTEELE-JOHN, Sen Jordon12/2
97
Competition and Consumer Amendment (Prevention of Exploitation of Indigenous Cultural Expressions) 2019S,N20190212PrivateHANSON-YOUNG, Sen Sarah12/2
98
Ministers of State (Checks for Security Purposes) 2019S,N20190212PrivatePATRICK, Sen Rex12/2
99
Fair Work Amendment (Restoring Penalty Rates) 2018 [No. 2]S,N20181411PrivateCAMERON, Sen Doug14/11
100
National Integrity Commission 2018 (No. 2)S,N20181129PrivateWATERS, Sen Larissa10/929/119/9
101
Australian Research Council Amendment (Ensuring Research Independence) 2018S,N20181115PrivateFARUQI, Sen Mehreen15/11
102
Discrimination Free Schools 2018S,N20181016PrivateDI NATALE, Sen Richard16/10
103
Social Services Legislation Amendment (Ending the Poverty Trap) 2018S,N20180910PrivateSIEWERT, Sen Rachel10/9
104
Australian Multicultural 2018S,N20180823PrivateDI NATALE, Sen Richard23/8
105
Freedom of Information Legislation Amendment (Improving Access and Transparency) 2018S,N20180822PrivatePATRICK, Sen Rex22/8
106
Plebiscite (Future Migration Level) 2018S,N20180815PrivateHANSON, Sen Pauline15/8
2°negatived
29/7
107
Intelligence Services Amendment (Enhanced Parliamentary Oversight of Intelligence Agencies) 2018S,N20180814PrivatePATRICK, Sen Rex14/8
108
Commonwealth Electoral Amendment (Lowering Voting Age and Increasing Voter Participation) 2018S,N20180618PrivateSTEELE-JOHN, Sen Jordon18/6
109
Air Services Amendment 2018S,N20180327PrivateRICE, Sen Janet27/3
110
Nuclear Fuel Cycle (Facilitation) 2017S,N20171411PrivateBERNARDI, Sen Cory14/11
111
Productivity Commission Amendment (Addressing Inequality) 2017S,N20171406PrivateMCALLISTER, Sen Jenny14/6
112
Coal-Fired Power Funding Prohibition 2017S,N20171017PrivateDI NATALE, Sen Richard17/10
113
Regional Forest Agreements Legislation (Repeal) 2017S,N20170907PrivateRICE, Sen Janet7/9
114
Competition and Consumer Amendment (Truth in Labelling—Palm Oil) 2017S,N20170621PrivateXENOPHON, Sen Nick21/6
115
Environment and Infrastructure Legislation Amendment (Stop Adani) 2017S,N20170613PrivateWATERS, Sen Larissa13/6
116
Landholders’ Right to Refuse (Gas and Coal) 2015S,N20150831PrivateWATERS, Sen Larissa31/8
1
House Bills In Play - Australian Parliament46Govt Bills131
2
Final for 201968Private 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 TitleIntroducedBill TypeSponsorIntro HousePassed HouseIntro SenatePassed SenateAssent DateAct No.Seq No.filter???Footnote RefVoteWrap
5
Australian Business Growth Fund 201920191205GovtTreasury5/12013Intro House8xYes
6
Federal Circuit and Family Court of Australia (Consequential Amendments and Transitional Provisions) 2019
20191205GovtAttorney-General5/12067Intro House3333xYes
7
Federal Circuit and Family Court of Australia 201920191205GovtAttorney-General5/12066Intro House3232x
8
National Consumer Credit Protection Amendment (Mandatory Credit Reporting and Other Measures) 2019
20191205GovtTreasury5/12089Intro House42x
9
Treasury Laws Amendment (2019 Measures No. 3) 201920191205GovtTreasury5/120131Intro House60x
10
Treasury Laws Amendment (Research and Development Tax Incentive) 201920191205GovtTreasury5/120143Intro House62x
11
Marine Safety (Domestic Commercial Vessel) National Law Amendment (Improving Safety) 2019S20191205PrivateSTERLE, Sen Glenn5/120188Coming from Senate94x
12
Business Names Registration (Fees) Amendment (Registries Modernisation) 201920191204GovtTreasury4/12022Intro House12x
13
Commonwealth Registers 201920191204GovtTreasury4/12030Intro House19x
14
Corporations (Fees) Amendment (Registries Modernisation) 201920191204GovtTreasury4/12034Intro House22x
15
Export Charges (Imposition—Customs) Amendment 201920191204GovtAgriculture4/12051Intro House2521x
16
Export Charges (Imposition—Excise) Amendment 201920191204GovtAgriculture4/12052Intro House2622x
17
Export Charges (Imposition—General) Amendment 201920191204GovtAgriculture4/12053Intro House2723x
18
Export Control (Consequential Amendments and Transitional Provisions) 201920191204GovtAgriculture4/12055Intro House2925x
19
Export Control 201920191204GovtAgriculture4/12054Intro House2823x
20
National Consumer Credit Protection (Fees) Amendment (Registries Modernisation) 201920191204GovtTreasury4/12091Intro House44x
21
National Vocational Education and Training Regulator Amendment 201920191204Govt
Employment, Skills, Small and Family Business
4/120197Coming from Senate100x
22
Offshore Petroleum and Greenhouse Gas Storage (Regulatory Levies) Amendment (Miscellaneous Measures) 2019
20191204GovtIndustry, Innovation and Science4/120105Intro House4949x
23
Offshore Petroleum and Greenhouse Gas Storage Amendment (Cross-boundary Greenhouse Gas Titles and Other Measures) 2019
20191204GovtIndustry, Innovation and Science4/120102Intro House4846x
24
Student Identifiers Amendment (Higher Education) 201920191204GovtEducation4/120120Intro House54x
25
Tertiary Education Quality and Standards Agency Amendment (Prohibiting Academic Cheating Services) 2019
20191204GovtEducation4/120124Intro House57x
26
Transport Security Amendment (Testing and Training) 201920191204GovtHome Affairs4/120212Coming from Senate11325x
27
Treasury Laws Amendment (Registries Modernisation and Other Measures) 201920191204GovtTreasury4/120142Intro House61x
28
Telecommunications Amendment (Repairing Assistance and Access) 2019S20191204PrivateKENEALLY, Sen Kristina4/120209Coming from Senate111x
29
Agriculture Legislation Amendment (Streamlining Administration) 201920191202GovtAgriculture2/120151Coming from Senate641x
30
Crimes Legislation Amendment (Combatting Corporate Crime) 201920191202GovtAttorney-General2/120170Coming from Senate798x
31
Wine Australia Amendment (Label Directory) 201920191202GovtAgriculture2/120213Coming from Senate114x
32
Australian Banks (Government Audit) 2019P20191202PrivateKATTER, Bob, Jnr, MP2/12010Intro House5x
33
Climate Change Authority Amendment (Impact of 3 Degrees of Global Warming on Australia) 2019P20191202PrivateBANDT, Adam, MP2/12023Intro House13x
34
Commonwealth Electoral Amendment (Lowering the Donation Disclosure Threshold) 2019P20191202PrivateSHARKIE, Rebekha, MP2/12027Intro House16x
35
Live Animal Export Prohibition (Ending Cruelty) 2019P20191202PrivateWILKIE, Andrew, MP2/12079Intro House37x
36
National Consumer Credit Protection Amendment (Small Amount Credit Contract and Consumer Lease Reforms) 2019 (No. 2)S
20191202PrivateGRIFF, Sen Stirling2/120191Coming from Senate9717x
37
Public Governance, Performance and Accountability Amendment (Waiver of Debt and Act of Grace Payments) 2019S
20191202PrivateGALLAGHER, Sen Katy2/120204Coming from Senate107x
38
Saving Australian Dairy 2019S20191202PrivateHANSON, Sen Pauline2/120207Coming from Senate10923x
39
Financial Sector Reform (Hayne Royal Commission Response—Protecting Consumers (2019 Measures)) 2019
20191128GovtTreasury28/11068Intro House34x
40
Financial Sector Reform (Hayne Royal Commission Response—Stronger Regulators (2019 Measures)) 2019
20191128GovtTreasury28/11069Intro House35x
41
Student Identifiers Amendment (Enhanced Student Permissions) 201920191128Govt
Employment, Skills, Small and Family Business
28/110119Intro House5353x
42
Telecommunications (Regional Broadband Scheme) Charge 201920191128Govt
Communications, Cyber Safety and the Arts
28/110122Intro House55x
43
Telecommunications Legislation Amendment (Competition and Consumer) 201920191128Govt
Communications, Cyber Safety and the Arts
28/110123Intro House5654x
44
Trade Support Loans Amendment (Improving Administration) 201920191128Govt
Employment, Skills, Small and Family Business
28/110126Intro House58x
45
Family Law Amendment (Western Australia De Facto Superannuation Splitting and Bankruptcy) 201920191127GovtAttorney-General27/11062Intro House3130x
46
Migration Agents Registration Application Charge Amendment (Rates of Charge) 201920191127GovtHome Affairs27/11082Intro House39x
47
Migration Amendment (Regulation of Migration Agents) 201920191127GovtHome Affairs27/11083Intro House4038x
48
Treasury Laws Amendment (Your Superannuation, Your Choice) 201920191127GovtTreasury27/110146Intro House6363x
49
Australian Cannabis Agency 2018S,N20191127PrivateDI NATALE, Sen Richard27/110154Coming from Senate66x
50
Commonwealth Electoral Amendment (Lowering the Donation Disclosure Threshold) 2019S20191127PrivateSHARKIE, Rebekha, MP27/110162Coming from Senate72
51
Commonwealth Electoral Amendment (Transparency Measures—Real Time Disclosure) 2019S20191127PrivateFARRELL, Sen Don27/110164Coming from Senate74x
52
Private Health Insurance Legislation Amendment (Fairer Rules for General Treatments) 2019P20191125PrivateWILKIE, Andrew, MP25/110108Intro House50x
53
Governor-General Amendment (Cessation of Allowances in the Public Interest) 2019S20191113PrivateSIEWERT, Sen Rachel13/110178Coming from Senate86x
54
Public Governance, Performance and Accountability Amendment (Tax Transparency in Procurement and Grants) 2019S
20191113PrivatePATRICK, Sen Rex13/110203Coming from Senate10622x
55
Official Development Assistance Multilateral Replenishment Obligations (Special Appropriation) 201920191024GovtForeign Affairs and Trade24/100101Intro House47x
56
Transport Security Amendment (Serious Crime) 201920191023GovtHome Affairs23/100127Intro House5955x
57
Commonwealth Electoral Amendment (Lowering Voting Age and Increasing Voter Participation) 2019P20191021PrivateBANDT, Adam, MP21/10028Intro House17x
58
Refugee Protection 2019P20191021PrivateWILKIE, Andrew, MP21/100110Intro House51x
59
Anti-Money Laundering and Counter-Terrorism Financing and Other Legislation Amendment 201920191017GovtHome Affairs17/1006Intro House42x
60
Native Title Legislation Amendment 201920191017GovtAttorney-General17/10099Intro House4644x
61
National Integrity (Parliamentary Standards) 2019S20191017PrivateWATERS, Sen Larissa17/100194Coming from Senate9819x
62
Coal Prohibition (Quit Coal) 2019P20191014PrivateBANDT, Adam, MP14/10025Intro House15x
63
Crimes Legislation Amendment (Age of Criminal Responsibility) 2019P20191014PrivateSHARKIE, Rebekha, MP14/10037Intro House23x
64
Australian Citizenship Amendment (Citizenship Cessation) 201920190918GovtHome Affairs19/9014Intro House93x
65
Australian Bill of Rights 2019P20190916PrivateWILKIE, Andrew, MP16/9011Intro House6x
66
Commonwealth Electoral Amendment (Real Time Disclosure of Political Donations) 2019P20190916PrivateSHARKIE, Rebekha, MP16/9029Intro House189x
67
Fair Work Amendment (Stop Work to Stop Warming) 2019P20190916PrivateBANDT, Adam, MP16/9056Intro House30x
68
National Consumer Credit Protection Amendment (Small Amount Credit Contract and Consumer Lease Reforms) 2019P
20190916PrivateSHARKIE, Rebekha, MP16/9090Intro House43x
69
Protecting Australian Dairy 2019S20190916PrivateHANSON, Sen Pauline16/10
2°negatived
11/11
0202Coming from Senate105d
70
Family Law (Self-Assessment) 2019S20190912PrivateHANSON, Sen Pauline12/90176Coming from Senate84x
71
Social Services Legislation Amendment (Better Targeting Student Payments) 201920190911GovtSocial Services11/90114Intro House52x
72
Product Stewardship Amendment (Packaging and Plastics) 2019S20190911PrivateWHISH-WILSON, Sen Peter11/90200Coming from Senate10321x
73
Customs Amendment (Safer Cladding) 2019S20190910PrivatePATRICK, Sen Rex10/90171Coming from Senate80x
74
National Integrity Commission 2019P20190909PrivateBANDT, Adam, MP9/9095Intro House45x
75
Australian Passports Amendment (Identity-matching Services) 201920190731GovtForeign Affairs and Trade31/7016Intro House104x
76
Identity-matching Services 201920190731GovtHome Affairs31/7077Intro House3637x
77
Australian Broadcasting Corporation Amendment (Rural and Regional Measures) 201920190731PrivateSHARKIE, Rebekha, MP31/7012Intro House7x
78
Constitution Alteration (Freedom of Expression and Freedom of the Press) 2019 [No. 2]P20190729PrivateSHARKIE, Rebekha, MP29/7032Intro House20x
79
Constitution Alteration (Water Resources) 2019 [No. 2]P20190729PrivateSHARKIE, Rebekha, MP29/7033Intro House21x
80
Intellectual Property Laws Amendment (Productivity Commission Response Part 2 and Other Measures) 2019
20190725GovtIndustry, Innovation and Science16/1025/716/10A0184Coming from Senate9013x
81
Great Australian Bight Environment Protection 2019S20190725PrivateHANSON-YOUNG, Sen Sarah25/70179Coming from Senate87x
82
Human Rights (Parliamentary Scrutiny) Amendment (Australian Freedoms) 2019S20190723PrivateBERNARDI, Sen Cory23/70181Coming from Senate88x
83
Aged Care Amendment (Staffing Ratio Disclosure) 2019P20190722PrivateSHARKIE, Rebekha, MP22/702Intro House1x
84
Aged Care Quality and Safety Commission Amendment (Worker Screening Database) 2019P20190722PrivateSHARKIE, Rebekha, MP22/703Intro House2x
85
Banking Amendment (Rural Finance Reform) 2019P20190722PrivateSHARKIE, Rebekha, MP22/7021Intro House117x
86
Coal-Fired Power Funding Prohibition 2019P20190722PrivateBANDT, Adam, MP22/7024Intro House14x
87
Environment Protection and Biodiversity Conservation Amendment (Heritage Listing for the Bight) 2019P
20190722PrivateSHARKIE, Rebekha, MP22/7050Intro House24x
88
Live Sheep Long Haul Export Prohibition 2019P20190722PrivateSHARKIE, Rebekha, MP22/7080Intro House38x
89
Migration Legislation Amendment (Regional Processing Cohort) 201920190704GovtHome Affairs4/7087Intro House4141x
90
Australian Institute of Health and Welfare Amendment (Assisted Reproductive Treatment Statistics) 2019S
20190704PrivateFARUQI, Sen Mehreen4/70155Coming from Senate673x
91
Constitution Alteration (Freedom of Expression and Freedom of the Press) 2019S20190704PrivateGRIFF, Sen Stirling PATRICK, Sen Rex4/70167Coming from Senate77x
92
Constitution Alteration (Water Resources) 2019S20190704PrivatePATRICK, Sen Rex4/70168Coming from Senate787x
93
Live Animal Export (Slaughter) Prohibition 2019S20190704PrivateFARUQI, Sen Mehreen4/70187Coming from Senate93x
94
Agriculture Legislation Repeal 2019Z20190702GovtPrime Minister2/705Intro House3x
95
Human Services Amendment (Photographic Identification and Fraud Prevention) 2019S,N20190213PrivateHANSON, Sen Pauline 13/20182Coming from Senate8912x
96
Murray-Darling Basin Commission of Inquiry 2019S,N20190213PrivateHANSON-YOUNG, Sen Sarah13/20190Coming from Senate9616x
97
Telecommunications Legislation Amendment (Unsolicited Communications) 2019S,N20190213PrivateGRIFF, Sen Stirling13/20210Coming from Senate11224x
98
Broadcasting Services Amendment (Audio Description) 2019S,N20190212PrivateSTEELE-JOHN, Sen Jordon12/20159Coming from Senate70x
99
Competition and Consumer Amendment (Prevention of Exploitation of Indigenous Cultural Expressions) 2019S,N
20190212PrivateHANSON-YOUNG, Sen Sarah12/20165Coming from Senate755x
100
Ministers of State (Checks for Security Purposes) 2019S,N20190212PrivatePATRICK, Sen Rex12/20189Coming from Senate9515x
101
Fair Work Amendment (Restoring Penalty Rates) 2018 [No. 2]S,N20181411PrivateCAMERON, Sen Doug14/110175Coming from Senate83x
102
National Integrity Commission 2018 (No. 2)S,N20181129PrivateWATERS, Sen Larissa10/929/119/90195Coming from Senate9920x
103
Australian Research Council Amendment (Ensuring Research Independence) 2018S,N20181115PrivateFARUQI, Sen Mehreen15/110157Coming from Senate69x
104
Discrimination Free Schools 2018S,N20181016PrivateDI NATALE, Sen Richard16/100173Coming from Senate81x
105
Social Services Legislation Amendment (Ending the Poverty Trap) 2018S,N20180910PrivateSIEWERT, Sen Rachel10/90208Coming from Senate110x
106
Australian Multicultural 2018S,N20180823PrivateDI NATALE, Sen Richard23/80156Coming from Senate68x
107
Freedom of Information Legislation Amendment (Improving Access and Transparency) 2018S,N20180822PrivatePATRICK, Sen Rex22/80177Coming from Senate8511x
108
Plebiscite (Future Migration Level) 2018S,N20180815PrivateHANSON, Sen Pauline15/82°negatived
29/7
0199Coming from Senate102d
109
Intelligence Services Amendment (Enhanced Parliamentary Oversight of Intelligence Agencies) 2018S,N
20180814PrivatePATRICK, Sen Rex14/80185Coming from Senate9114x
110
Commonwealth Electoral Amendment (Lowering Voting Age and Increasing Voter Participation) 2018S,N
20180618PrivateSTEELE-JOHN, Sen Jordon18/60163Coming from Senate735x
111
Air Services Amendment 2018S,N20180327PrivateRICE, Sen Janet27/30152Coming from Senate652x
112
Nuclear Fuel Cycle (Facilitation) 2017S,N20171411PrivateBERNARDI, Sen Cory14/110198Coming from Senate101x
113
Productivity Commission Amendment (Addressing Inequality) 2017S,N20171406PrivateMCALLISTER, Sen Jenny14/60201Coming from Senate104x
114
Coal-Fired Power Funding Prohibition 2017S,N20171017PrivateDI NATALE, Sen Richard17/100161Coming from Senate714x
115
Regional Forest Agreements Legislation (Repeal) 2017S,N20170907PrivateRICE, Sen Janet7/90205Coming from Senate108x
116
Competition and Consumer Amendment (Truth in Labelling—Palm Oil) 2017S,N20170621PrivateXENOPHON, Sen Nick21/60166Coming from Senate76x
117
Environment and Infrastructure Legislation Amendment (Stop Adani) 2017S,N20170613PrivateWATERS, Sen Larissa13/60174Coming from Senate8210x
118
Landholders’ Right to Refuse (Gas and Coal) 2015S,N20150831PrivateWATERS, Sen Larissa31/80186Coming from Senate92x
119
Aged Care Amendment (Movement of Provisionally Allocated Places) 201924/711/911/917/920/9711
120
Aged Care Legislation Amendment (New Commissioner Functions) 20195/125/1216/105/1211/12116150
121
Agricultural and Veterinary Chemicals Legislation Amendment (Australian Pesticides and Veterinary Medicines Authority Board and Other Improvements) 2019
18/9[1]3/125/1204No Jurisdictionx
122
ANL Legislation Repeal 201915/1016/1011/914/1028/1088153
123
Appropriation (No. 1) 2019-2020B25/719/919/911/1112/111007
124
Appropriation (No. 2) 2019-2020B25/719/919/911/1112/111018
125
Appropriation (Parliamentary Departments) (No. 1) 2019-2020B25/719/919/911/1112/111029
126
Australian Crime Commission Amendment (Special Operations and Special Investigations) 201928/113/125/125/1210/1211415
127
Australian Research Council Amendment 201918/926/1127/11017No Jurisdictionx
128
Australian Security Intelligence Organisation Amendment (Sunsetting of Special Powers Relating to Terrorism Offences) 2019
4/730/731/71/812/86118
129
Australian Sports Anti-Doping Authority Amendment (Enhancing Australia’s Anti-Doping Capability) 201917/10[5]4/125/12019No Jurisdictionx
130
Australian Sports Anti-Doping Authority Amendment (Sport Integrity Australia) 201917/10[6]5/125/12020No Jurisdictionx
131
Australian Veterans’ Recognition (Putting Veterans and Their Families First) 201930/722/104/729/7A30/1096158
132
Civil Aviation Amendment 201924/724/104/722/76/1199160
133
Combatting Child Sexual Exploitation Legislation Amendment 201924/7[8]12/912/917/920/97226
134
Communications Legislation Amendment (Deregulation and Other Measures) 201916/1025/1127/115/1212/1212031
135
Counter-Terrorism (Temporary Exclusion Orders) (Consequential Amendments) 20194/723/724/725/730/75436
136
Counter-Terrorism (Temporary Exclusion Orders) 20194/723/724/725/730/75335
137
Counter-Terrorism Legislation Amendment (2019 Measures No. 1) 20194/124/121/8[8]4/12A11/12119169
138
Crimes Legislation Amendment (Police Powers at Airports) 20194/712/912/914/10A[10]28/108938
139
Crimes Legislation Amendment (Sexual Crimes Against Children and Community Protection Measures) 201911/9[11]15/1017/10039No Jurisdictionx
140
Criminal Code Amendment (Agricultural Protection) 20194/7[12]1/89/912/9A[13]19/96740
141
Currency (Restrictions on the Use of Cash) 201919/9[14]24/1011/11041No Jurisdictionx
142
Customs Amendment (Growing Australian Export Opportunities Across the Asia-Pacific) 201916/1021/1011/1126/113/1210842
143
Customs Amendment (Immediate Destruction of Illicit Tobacco) 20194/7[15]9/99/919/92/107643
144
Customs Amendment (Product Specific Rule Modernisation) 201912/9[16]24/1011/11044No Jurisdictionx
145
Customs Tariff Amendment (Growing Australian Export Opportunities Across the Asia-Pacific) 201916/1021/1011/1126/113/1210945
146
Defence Service Homes Amendment 201925/1128/1119/914/119/12112172
147
Education Legislation Amendment (2019 Measures No. 1) 201916/1024/1011/1114/1128/1110346
148
Education Legislation Amendment (Tuition Protection and Other Measures) 201918/9[17]24/1011/115/126/1211147
149
Emergency Response Fund (Consequential Amendments) 201911/9[20]17/918/917/1028/109149
150
Emergency Response Fund 201911/9[18]17/918/9R[19]17/1028/109048
151
Fair Work (Registered Organisations) Amendment (Ensuring Integrity No. 2) 20194/125/125/12059No Jurisdictionx
152
Fair Work (Registered Organisations) Amendment (Ensuring Integrity) 20194/7[27]31/731/7
Negatived in Committee of the Whole 28/11
058No Jurisdiction
153
Fair Work Laws Amendment (Proper Use of Worker Benefits) 20194/7[26]10/911/9057No Jurisdictionx
154
Family Assistance Legislation Amendment (Building on the Child Care Package) 201918/9[28]25/11H27/115/1212/1212560
155
Family Assistance Legislation Amendment (Extend Family Assistance to ABSTUDY Secondary School Boarding Students Aged 16 and Over) 2019
31/7[29]10/911/918/920/97361
156
Farm Household Support Amendment (Relief Measures) (No. 1) 201917/10[31]23/1011/1112/1128/1110464
157
Farm Household Support Amendment (Relief Measures) (No. 2) 201927/113/125/125/1211/1211765
158
Farm Household Support Amendment 20194/729/730/730/77/86063
159
Foreign Acquisitions and Takeovers Fees Imposition Amendment (Near-new Dwelling Interests) 201923/1027/1127/115/1212/1212670
160
Future Drought Fund (Consequential Amendments) 201922/722/723/724/730/75672
161
Future Drought Fund 201922/722/723/724/7A[34]30/75571
162
Health Insurance Amendment (Bonded Medical Programs Reform) 201931/711/94/731/719/970180
163
Health Legislation Amendment (Data-matching and Other Matters) 201923/1027/112/125/1212/1212173
164
Higher Education Support (Charges) 20194/711/911/915/1028/108576
165
Higher Education Support (HELP Tuition Protection Levy) 201918/9[35]24/1011/11R[36]074No Jurisdictionx
166
Higher Education Support Amendment (Cost Recovery) 20194/711/911/915/1028/108675
167
Inspector-General of Live Animal Exports 201911/918/931/710/9A2/1081183
168
Interactive Gambling Amendment (National Self-exclusion Register) 201927/113/125/125/1212/1212778
169
Medical and Midwife Indemnity Legislation Amendment 201918/916/1017/1014/1128/1110581
170
Migration Amendment (Repairing Medical Transfers) 20194/7[39]25/729/74/124/1211084
171
Migration Amendment (Streamlining Visa Processing) 20194/711/911/9085No Jurisdictionx
172
Migration Amendment (Strengthening the Character Test) 20194/7[40]19/919/9086No Jurisdictionx
173
Military Rehabilitation and Compensation Amendment (Single Treatment Pathway) 20194/716/916/95/1212/1212288
174
National Disability Insurance Scheme Amendment (Streamlined Governance) 201925/1127/1125/7[18]14/11A9/12113192
175
National Disability Insurance Scheme Amendment (Worker Screening Database) 201923/719/94/722/72/1082193
176
National Health Amendment (Pharmaceutical Benefits) 20194/711/911/919/92/107792
177
National Health Amendment (Safety Net Thresholds) 201911/915/1017/1014/1128/1110693
178
National Housing Finance and Investment Corporation Amendment 201912/9[42]17/918/914/10A[43]18/108394
179
National Rental Affordability Scheme Amendment 201924/717/104/722/7A30/1097196
180
National Self-exclusion Register (Cost Recovery Levy) 201927/113/125/125/1212/1212896
181
National Sports Tribunal (Consequential Amendments and Transitional Provisions) 201924/79/99/911/919/96998
182
National Sports Tribunal 201924/79/99/911/919/96897
183
New Skilled Regional Visas (Consequential Amendments) 201931/7[45]14/1017/100100No Jurisdictionx
184
Offshore Petroleum and Greenhouse Gas Storage (Regulatory Levies) Amendment 201925/7[48]11/911/916/1028/1093104
185
Offshore Petroleum and Greenhouse Gas Storage Amendment (Miscellaneous Amendments) 201925/7[47]11/911/916/1028/1092103
186
Paid Parental Leave Amendment (Work Test) 201911/919/919/917/1028/1084106
187
Passenger Movement Charge Amendment (Timor Sea Maritime Boundaries Treaty) 20194/725/729/729/77/858107
188
Protection of the Sea (Prevention of Pollution from Ships) Amendment (Air Pollution) 201918/916/1017/105/1212/12123109
189
Road Vehicle Standards Legislation Amendment 201923/79/94/722/713/966206
190
Royal Commissions Amendment (Private Sessions) 201925/731/731/710/9A[50]13/964111
191
Social Security (Administration) Amendment (Cashless Welfare) 201925/730/731/71/812/862112
192
Social Security (Administration) Amendment (Income Management to Cashless Debit Card Transition) 201911/9[51]27/11H2/120113No Jurisdictionx
193
Social Services Legislation Amendment (Drug Testing Trial) 201911/9[52]17/1017/100115No Jurisdictionx
194
Social Services Legislation Amendment (Overseas Welfare Recipients Integrity Program) 201925/79/9H10/917/920/974117
195
Social Services Legislation Amendment (Payment Integrity) 201911/92/123/120116No Jurisdictionx
196
Special Recreational Vessels 201927/113/12H5/125/1211/12118118
197
Telecommunications (Interception and Access) Amendment (Assistance and Access Amendments Review) 201917/1025/1127/115/1212/12124121
198
Tertiary Education Quality and Standards Agency Amendment 201916/923/1025/712/930/1098211
199
Timor Sea Maritime Boundaries Treaty Consequential Amendments 20194/725/7H29/729/77/857125
200
Treasury Laws Amendment (2018 Measures No. 2) 20194/715/1017/100128No Jurisdictionx
201
Treasury Laws Amendment (2018 Superannuation Measures No. 1) 201924/712/912/919/92/1078129
202
Treasury Laws Amendment (2019 Measures No. 2) 201918/916/1017/1017/1028/1094130
203
Treasury Laws Amendment (2019 Tax Integrity and Other Measures No. 1) 201924/7[56]1/81/816/10A[57]28/1095132
204
Treasury Laws Amendment (Combating Illegal Phoenixing) 20194/727/1127/110133No Jurisdictionx
205
Treasury Laws Amendment (Consumer Data Right) 201924/730/731/71/812/863134
206
Treasury Laws Amendment (Ending Grandfathered Conflicted Remuneration) 20191/810/911/914/1028/1087135
207
Treasury Laws Amendment (International Tax Agreements) 201919/924/1011/1114/1128/11107136
208
Treasury Laws Amendment (Making Sure Multinationals Pay Their Fair Share of Tax in Australia and Other Measures) 2019
4/731/71/89/913/965137
209
Treasury Laws Amendment (Prohibiting Energy Market Misconduct) 201918/9[58]23/10H11/1112/11A[59]10/12115138
210
Treasury Laws Amendment (Putting Members’ Interests First) 20194/7[60]16/916/919/9A[61]2/1079139
211
Treasury Laws Amendment (Recovering Unpaid Superannuation) 201918/9[62]28/112/120140No Jurisdictionx
212
Treasury Laws Amendment (Reducing Pressure on Housing Affordability Measures) 201923/1027/1127/115/1212/12129141
213
Treasury Laws Amendment (Tax Relief So Working Australians Keep More Of Their Money) 20192/72/74/74/75/752144
214
Treasury Laws Amendment (Timor Sea Maritime Boundaries Treaty) 201924/725/729/729/77/859145
215
VET Student Loans (VSL Tuition Protection Levy) 201918/9[64]24/1011/11R[65]0148No Jurisdictionx
216
Veterans’ Affairs Legislation Amendment (Partner Service Pension and Other Measures) 20191/812/912/917/920/975147
217
Water Amendment (Indigenous Authority Member) 20194/711/912/919/92/1080149
218
219
1
Process to Add a New Bill
h1
2
RefItemFlagr6474r6554
3
1Copy Bill Templateh2xx
4
2Open Bill Templatelinkdd
5
3Make 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.fdd
6
4
idd
7
5In the 'Copy Document' popup turn On 'Copy comments' and click OKfdd
8
6A copy of the Google Sheet and it's associated Form will be saved to the VoteWrap WebApp folderfdd
9
7
idd
10
8The Google Sheet will be renamed with System ID + Title.
But the Form will still be named Copy of Legislation VoteWrap Template.
fdd
11
9Rename Form.idd
12
10Rename the Form to the same, System ID + Title.fdd
13
11Add Bill LongTitle to Sheet & Form.h2dd
14
12In the Bill home page follow link 'Text of Bill'fdd
15
13
idd
16
14Find and copy the Long Title:fdd
17
15
idd
18
16Go to the 'Calc' sheet and the add the Long Title to cell A3fdd
19
17
idd
20
18Link to example Clac sheetlinkdd
21
19Open the Form in edit mode and add the Long Title to the top description.fdd
22
20
idd
23
21Update Form ID in updateForm()H2dd
24
22From the Google sheet Tools menu select Script Editor.fdd
25
23
idd
26
24To display the AppScript that populates the Representtives dropdown.fdd
27
25
idd
28
26In the URL for the Form find the Form IDfdd
29
27
idd
30
28Copy and paste the Form ID from the Google form to the AppScript function updateForm() and Click Savefdd
31
29Add Trigger to Copied AppScriptH2dd
32
30In the AppScript click on Triggers.fdd
33
31
idd
34
32To display the Triggers page.fdd
35
33Add blank trigger page imagedd
36
34Add a Trigger to updateForm on Form submit.fdd
37
35
idd
38
36Select 'Save'd
39
37Add message about connecting to account is displayedfdd
40
38
idd
41
39After connecting to account message 'This app isn't verified' appears.fdd
42
40
idd
43
41Select 'Go to VoteWrap (unsafe)'fdd
44
42
idd
45
43Page 'Sign in with Google' page appears.fdd
46
44
idd
47
45Trigger is added to update reps dropdown list with reps from the new copied Google Sheetfdd
48
46
idd
49
47Create Prefilled Formh2dd
50
48From the Google Form in edit mode select 'Get pre-filled link'fdd
51
49
idd
52
50Set the following values for the following fields:fdd
53
51Set '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.' = Nofdd
54
52Set 'Representation' = Selffdd
55
53Set 'Secret Ballot' = Nofdd
56
54Set 'Finalised' = Nofdd
57
55Set '1. Importance High / Urgency Low' = 70fdd
58
56Set '2. Importance High / Urgency High = 60fdd
59
57Set '3. Importance Low / Urgency Low = 60fdd
60
58Set '4. Importance Low / Urgency High = 50fdd
61
59Set '1. Importance High / Urgency - Low' = Compulsoryfdd
62
60Set '2. Importance High / Urgency - Medium' = Compulsoryfdd
63
61Set '3. Importance High / Urgency - High' = Voluntaryfdd
64
62Set '4. Importance Medium / Urgency - Low' = Compulsoryfdd
65
63Set '5. Importance Medium / Urgency - Medium' = Voluntaryfdd
66
64Set '6. Importance Medium / Urgency - High' = Voluntaryfdd
67
65Set '7. Importance Low / Urgency - Low' = Voluntaryfdd
68
66Set '8. Importance Low / Urgency - Medium' = Voluntaryfdd
69
67Set '9. Importance Low / Urgency - High = Voluntaryfdd
70
68THEN click 'Get link'fdd
71
69
idd
72
70THEN click 'COPY LINK'fdd
73
71
idd
74
72THEN update the hyperlink in the Google Sheet 'Pre Calc' with the copied form url to provide access to the prefilled form.fdd
75
73
idd
76
74Add new DR Website Bill PageH2id
77
75Open the DR website Jiggsy in Edit mode.fdd
78
76Open the Legislation Template Page.fdd
79
77Copy the Legislation Template Page and name it with System ID + Titlefdd
80
78
idd
81
79Add the Titlefdd
82
80
idd
83
81
idd
84
82Link the Title to the Bill on the Parliament of Australia website.fdd
85
83
idd
86
84Update the 'Click here for Details' link with the same link above.fdd
87
85
idd
88
86Add the Summary text from the PofA Bill page.fdd
89
87
idd
90
88
idd
91
89Create & Add SquareUp Donation Linkd
92
90Link for Bill r6554 ASIO Amendments: https://checkout.square.site/pay/863ddf76cbbb46398afb218546cafcced
93
91Publish new Bill To WebH2dd
94
92Open the New Bill Google sheet at the Dashboard sheet.fdd
95
93
idd
96
94Select File/Publish to Web and select the Embed tabfdd
97
95
idd
98
96Click Publishfdd
99
97
idd
100
98Copy the HTML code to clipboard.fdd
101
99Go to the new Bill page in the DR Jiggsy Editor.fdd
102
100Open the Dashboard element in Editfdd
103
101
idd
104
102Replace the existing HTML block with the one you copied above.fdd
105
103
idd
106
104After <iframe Add height="1050" width="950" fdd
107
105Before headers=false; add chrome=false&amp;fdd
108
106Change widget=true&amp; to widget=false&amp;fdd
109
107Click Save to display updated Dashboard.fdd
110
108Repeat the above process for Reps.fdd
111
109Get the html to embed the Export Google sheet tab in the 'Dickson Representatives for this Bill' page.dd
112
110
idd
113
111In Jigsy Edit the 'Dickson Representatives for this Bill' page.fdd
114
112
idd
115
113Paste the new html script.fdd
116
114
idd
117
115After <iframe Add width="950" height="1200" fdd
118
116Before headers=false; add chrome=false&amp;fdd
119
117Click Save to display updated Dashboard.fdd
120
118Add New Bill to the DR 'Bills to Vote on' pageH2id
121
119Copy the Title to 'Bill - Long Title'fdd
122
120Click here for info on Titlelinkdd
123
121
idd
124
122Hyperlink 'Bill - Long Title' to the DR Bill page.fdd
125
123EG: =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")fdd
126
124
idd
127
125To display the Bill's VoteWrap values .......fdd
128
126
idd
129
127..... use the following function:fdd
130
128=IMPORTRANGE("url_of_bill_goggle_sheet"Export!A4:P4")")fdd
131
129Example of "url_of_bill_goggle_sheet" shown below:dd
132
130
dd
133
131If this message appears:fdd
134
132
idd
135
133THEN click 'Allow access'fdd
136
134The VoteWrap values for the Bill are populated.fdd
137
135
idd
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 Votersh2
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
ItemFlag
2
Process to Update Data-Item-IDh
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 IDf
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: viewitemcardrootf
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 Sheeth
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.