{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Read Me","Initiative Details","Stakeholder Profile","Activities","One-for-one","Small Business Lens","Annual Stakeholder Count","Net Impacts","Net Impacts by Activity","Net Impacts by Stakeholder","Labour","CPI","Full Output","Controls"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":64,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Initiative Details","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Step 1: Initiative Profile"]
[]
[]
[null,null,"Name of Regulatory Change:"]
[null,null,"Type of Regulatory Change:","Amendment"]
[null,null,"Responsible Organization(s):"]
[null,null,"Brief Description of the Regulatory Change:"]
[null,null,"Number of Regulations Repealed:",0]
[null,null,"Number of Regulations Introduced:",{"$f":"Introduced_Formula","v":0}]
[null,null,"Price Year:",2023]
[null,null,"Year of Registration:",2024]
[null,null,"Present Value Base Year:",2024]
[null,null,"Length of Analytical Period (Years):",10]
[null,null,"Discount Rate:",7.0000000000000007E-2]
[null,null,null,"(Click the cells above for more info)"]

{"sheet":"Stakeholder Profile","index":2,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Step 2: Stakeholder Profile"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"TypeHere_Stakeholders","v":""},"Stakeholder Group","Non-business Count","Small Business Count","Med/Large Business Count","Total Business Count","Total Stakeholder Count","Non-business Growth Rate","Small Business Growth Rate","Med/Large Business Growth Rate"]
["Type Here ⮚",null,null,null,null,{"$f":"tbl_Stakeholders[[#This Row],[Small Business Count]]+tbl_Stakeholders[[#This Row],[Med/Large Business Count]]","v":0},{"$f":"tbl_Stakeholders[[#This Row],[Total Business Count]]+tbl_Stakeholders[[#This Row],[Non-business Count]]","v":0}]
[""]

{"sheet":"Activities","index":3,"n_rows":16,"n_cols":21,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Step 3: Activities"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"TypeHere_Activities","v":""},"Activity","Administrative or Compliance","In or Out","Upfront or  Ongoing","Start Year","End Year","Affected Stakeholder Group","Affected Stakeholder Type","Percent Affected","Apply to Existing Stakeholders","Apply to New Entrants","Capital or Labour","Capital: Number of Units","Capital: Unit Price","Capital: Price Year of Unit Price","Annual Frequency","Labour: Time Spent (hours)","Labour: Internal or External Overhead","Labour: Staff Level (Wage Without Overhead)"]
["Type Here ⮚",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Checkblank=0, \"One or more key parameter is missing for this activity. \", \"\")\n&IF(CheckAppliesToNoone=1, \"This activity does not apply to existing stakeholders or new entrants. \", \"\")\n&IF(CheckNonBusiness=1, \"All Non-Businesses were selected as the Affected Stakeholder Type, but there are no non-businesses for the Affected Stakeholder Group that has been selected. \", \"\")\n&IF(CheckSmall=1, \"Small businesses were selected as the Affected Stakeholder Type, but there are no small businesses for the Affected Stakeholder Group that has been selected. \", \"\")\n&IF(CheckMedLarge=1, \"Med/large businesses were selected as the Affected Stakeholder Type, but there are no med/large businesses for the Affected Stakeholder Group that has been selected. \", \"\")\n&IF(CheckStakeholders=0, \"This stakeholder cannot be found on the 'Stakeholder Profile' tab. Re-select a stakeholder group from the drop-down menu. \", \"\")\n&IF(CheckStartEnd=1, \"The start year is after the end year. \", \"\")\n&IF(CheckAdminCapital=1, \"This activity is related to capital, so it should probably be classified as a compliance activity (not administrative). \", \"\")\n&IF(CheckUpfrontFreq=1, \"Upfront activities are always modelled using a frequency of 1, so if you want to use a different frequency, consider using an ongoing activity. \", \"\")\n&IF(CheckWages=1, \"Impact estimates use the updated wage on the Labour tab, which is not reflected here (re-select the wage to update this row). \", \"\")","v":"One or more key parameter is missing for this activity. This activity does not apply to existing stakeholders or new entrants. "}]
[""]

{"sheet":"One-for-one","index":4,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[null,"One-for-one"]
[]
[]
[null,"Business count, time period, units of measurement:"]
[null,"Count of all businesses at the start of the analytical period:",{"$f":"SUM(tbl_Stakeholders[Total Business Count])","v":0}]
[null,"Time (years):",{"$f":"\"10 (\"&YearOfRegistration&\" to \"&YearOfRegistration+10-1&\")\"","v":"10 (2024 to 2033)"}]
[null,"Price year:",2012]
[null,"Discount rate:",7.0000000000000007E-2]
[null,"Discount base year:",2012]
[]
[]
[]
[null,"Results:"]
[null,"Net Present Value Administrative Impact, All Businesses:",{"$f":"$M$47","v":0}]
[null,"Net Present Value Administrative Impact Per Business:",{"$f":"IFERROR($C$15/$C$6, 0)","v":0}]
[null,"Annualized Administrative Impact, All Businesses:",{"$f":"$C$15*AF_7_10","v":0}]
[null,"Annualized Administrative Impact Per Business:",{"$f":"IFERROR($C$17/$C$6, 0)","v":0}]
[null,"Note: negative values represent net costs, positive values represent net benefits"]
[]
[]
[]
[null,"Draft RIAS text (revise as needed)"]
[null,{"$f":"OneforOneText","v":"The one-for-one rule does not apply as there is no impact on business."}]
[]
[null,"Annual breakdown:"]
[]
[null,"IN"]
[null,"CBA Parameter",{"$f":"_xlfn.SEQUENCE(,10, YearOfRegistration)","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,"Total","Annualized"]
[null,{"$f":"\"Undiscounted Impacts (\"&PriceYear&\" price year)\"","v":"Undiscounted Impacts (2023 price year)"},{"$f":"SUMIFS(_xlfn.ANCHORARRAY('Full Output'!Q2),_xlfn.ANCHORARRAY( 'Full Output'!C2), \"Administrative\",_xlfn.ANCHORARRAY( 'Full Output'!D2), \"In\",_xlfn.ANCHORARRAY( 'Full Output'!E2),_xlfn.ANCHORARRAY( C29))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(_xlfn.ANCHORARRAY(C30))","v":0},"N/A"]
[null,{"$f":"\"Discounted Impacts (\"&PriceYear&\" price year, 7% discount rate, \"&PVBaseYear& \" discount base year)\"","v":"Discounted Impacts (2023 price year, 7% discount rate, 2024 discount base year)"},{"$f":"SUMIFS(_xlfn.ANCHORARRAY('Full Output'!X2),_xlfn.ANCHORARRAY( 'Full Output'!D2), \"In\",_xlfn.ANCHORARRAY( 'Full Output'!E2),_xlfn.ANCHORARRAY( C29))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(_xlfn.ANCHORARRAY(C31))","v":0},{"$f":"M31*AF_7_10","v":0}]
[null,"Undiscounted Impacts (2012 price year)",{"$f":"_xlfn.ANCHORARRAY(C30)*OneforOne_CPI_Conversion","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(_xlfn.ANCHORARRAY(C32))","v":0},"N/A"]
[null,"Discounted Impacts (2012 price year, 7% discount rate, 2012 discount base year)",{"$f":"_xlfn.ANCHORARRAY(C31)*OneforOne_CPI_Conversion/(1.07)^Years_since_2012","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(_xlfn.ANCHORARRAY(C33))","v":0},{"$f":"M33*AF_7_10","v":0}]
[]
[null,"OUT"]
[null,"CBA Parameter",{"$f":"_xlfn.SEQUENCE(,10, YearOfRegistration)","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,"Total","Annualized"]
[null,{"$f":"\"Undiscounted Impacts (\"&PriceYear&\" price year)\"","v":"Undiscounted Impacts (2023 price year)"},{"$f":"-SUMIFS(_xlfn.ANCHORARRAY('Full Output'!Q2),_xlfn.ANCHORARRAY( 'Full Output'!C2), \"Administrative\",_xlfn.ANCHORARRAY( 'Full Output'!D2), \"Out\",_xlfn.ANCHORARRAY( 'Full Output'!E2),_xlfn.ANCHORARRAY( C36))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(_xlfn.ANCHORARRAY(C37))","v":0},"N/A"]
[null,{"$f":"\"Discounted Impacts (\"&PriceYear&\" price year, 7% discount rate, \"&PVBaseYear& \" discount base year)\"","v":"Discounted Impacts (2023 price year, 7% discount rate, 2024 discount base year)"},{"$f":"-SUMIFS(_xlfn.ANCHORARRAY('Full Output'!X2),_xlfn.ANCHORARRAY( 'Full Output'!D2), \"Out\",_xlfn.ANCHORARRAY( 'Full Output'!E2),_xlfn.ANCHORARRAY( C36))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(_xlfn.ANCHORARRAY(C38))","v":0},{"$f":"M38*AF_7_10","v":0}]
[null,"Undiscounted Impacts (2012 price year)",{"$f":"_xlfn.ANCHORARRAY(C37)*OneforOne_CPI_Conversion","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(_xlfn.ANCHORARRAY(C39))","v":0},"N/A"]
[null,"Discounted Impacts (2012 price year, 7% discount rate, 2012 discount base year)",{"$f":"_xlfn.ANCHORARRAY(C38)*OneforOne_CPI_Conversion/(1.07)^Years_since_2012","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(_xlfn.ANCHORARRAY(C40))","v":0},{"$f":"M40*AF_7_10","v":0}]
[]
[null,"NET"]
[null,"CBA Parameter",{"$f":"_xlfn.SEQUENCE(,10, YearOfRegistration)","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,"Total","Annualized"]
[null,{"$f":"\"Undiscounted Impacts (\"&PriceYear&\" price year)\"","v":"Undiscounted Impacts (2023 price year)"},{"$f":"_xlfn.ANCHORARRAY(C37)-_xlfn.ANCHORARRAY(C30)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(_xlfn.ANCHORARRAY(C44))","v":0},"N/A"]
[null,{"$f":"\"Discounted Impacts (\"&PriceYear&\" price year, 7% discount rate, \"&PVBaseYear& \" discount base year)\"","v":"Discounted Impacts (2023 price year, 7% discount rate, 2024 discount base year)"},{"$f":"_xlfn.ANCHORARRAY(C38)-_xlfn.ANCHORARRAY(C31)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(_xlfn.ANCHORARRAY(C45))","v":0},{"$f":"M45*AF_7_10","v":0}]
[null,"Undiscounted Impacts (2012 price year)",{"$f":"_xlfn.ANCHORARRAY(C39)-_xlfn.ANCHORARRAY(C32)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(_xlfn.ANCHORARRAY(C46))","v":0},"N/A"]
[null,"Discounted Impacts (2012 price year, 7% discount rate, 2012 discount base year)",{"$f":"_xlfn.ANCHORARRAY(C40)-_xlfn.ANCHORARRAY(C33)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(_xlfn.ANCHORARRAY(C47))","v":0},{"$f":"M47*AF_7_10","v":0}]

{"sheet":"Small Business Lens","index":5,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Small Business Lens"]
[]
[]
[null,"Business count, time period, units of measurement:"]
[null,"Count of small businesses at the start of the analytical period:",{"$f":"SUM(tbl_Stakeholders[Small Business Count])","v":0}]
[null,"Time (years):",{"$f":"Timeperiod&\" (\"&YearOfRegistration&\" to \"&YearOfRegistration+Timeperiod-1&\")\"","v":"10 (2024 to 2033)"}]
[null,"Price year:",{"$f":"PriceYear","v":2023}]
[null,"Discount rate:",{"$f":"TEXT(Discount, \"0%\")","v":"7%"}]
[null,"Discount base year:",{"$f":"PVBaseYear","v":2024}]
[null,"Order of magnitude:","Single"]
[null,"Decimals:",0]
[]
[]
[null,"Note: in the tables below, Benefits are the OUTs and Costs are the INs from the Activities tab."]
[]
[]
[null,{"$f":"_xlfn.LET(\n_xlpm.Magnitude, 1/10^IF($C$11=\"Millions\",6,IF($C$11=\"Billions\",9)),\n_xlpm.Magnitude_text, IF($C$11=\"Millions\", \" ($ millions)\", IF($C$11=\"Billions\", \" ($ billions)\", \"\")),\n_xlpm.AffectedType, INDEX(tbl_Activities[Affected Stakeholder Type], MATCH(_xlfn.ANCHORARRAY('Full Output'!$A$2), ActivityNumber, 0)),\n_xlpm.AffectsSmallBusinesses, --(_xlpm.AffectedType=\"Small Businesses\")+--(_xlpm.AffectedType=\"All Businesses\")+--(_xlpm.AffectedType=\"All Types\"),\n_xlpm.a, IFERROR(_xlfn.VSTACK(INDEX(_xlfn.UNIQUE(_xlfn._xlws.FILTER(_xlfn.ANCHORARRAY('Full Output'!$B$2):_xlfn.ANCHORARRAY('Full Output'!$C$2), (_xlfn.ANCHORARRAY('Full Output'!$D$2)=\"Out\")*(_xlpm.AffectsSmallBusinesses=1))), , 2), \"Total\"),\"\"),\n_xlpm.b, IFERROR(_xlfn.VSTACK(INDEX(_xlfn.UNIQUE(_xlfn._xlws.FILTER(_xlfn.ANCHORARRAY('Full Output'!$B$2):_xlfn.ANCHORARRAY('Full Output'!$C$2), (_xlfn.ANCHORARRAY('Full Output'!$D$2)=\"Out\")*(_xlpm.AffectsSmallBusinesses=1))), , 1), \"Total benefits\"),\"\"),\n_xlpm.c, -_xlfn.LET(_xlpm.x, SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$T$2),_xlfn.ANCHORARRAY( 'Full Output'!$D$2), \"Out\",_xlfn.ANCHORARRAY( 'Full Output'!$B$2), _xlpm.b,_xlfn.ANCHORARRAY( 'Full Output'!$C$2), _xlpm.a), IF(_xlpm.b=\"Total benefits\", SUM(_xlpm.x), _xlpm.x)),\n_xlpm.d, _xlpm.c*AF,\n_xlpm.tbl_SBLBenefits, _xlfn.HSTACK(_xlpm.a, _xlpm.b, DOLLAR(_xlpm.c*_xlpm.Magnitude, $C$12), DOLLAR(_xlpm.d*_xlpm.Magnitude, $C$12)),\n_xlpm.TPV_Benefits, INDEX(_xlpm.tbl_SBLBenefits, ROWS(_xlpm.tbl_SBLBenefits), 3),\n\n_xlpm.f, IFERROR(_xlfn.VSTACK(INDEX(_xlfn.UNIQUE(_xlfn._xlws.FILTER(_xlfn.ANCHORARRAY('Full Output'!$B$2):_xlfn.ANCHORARRAY('Full Output'!$C$2), (_xlfn.ANCHORARRAY('Full Output'!$D$2)=\"In\")*(_xlpm.AffectsSmallBusinesses=1))), , 2), \"Total\"),\"\"),\n_xlpm.g, IFERROR(_xlfn.VSTACK(INDEX(_xlfn.UNIQUE(_xlfn._xlws.FILTER(_xlfn.ANCHORARRAY('Full Output'!$B$2):_xlfn.ANCHORARRAY('Full Output'!$C$2), (_xlfn.ANCHORARRAY('Full Output'!$D$2)=\"In\")*(_xlpm.AffectsSmallBusinesses=1))), , 1), \"Total costs\"),\"\"),\n_xlpm.h, _xlfn.LET(_xlpm.y, SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$T$2),_xlfn.ANCHORARRAY( 'Full Output'!$D$2), \"In\",_xlfn.ANCHORARRAY( 'Full Output'!$B$2), _xlpm.g,_xlfn.ANCHORARRAY( 'Full Output'!$C$2), _xlpm.f), IF(_xlpm.g=\"Total costs\", SUM(_xlpm.y), _xlpm.y)),\n_xlpm.i, _xlpm.h*AF,\n_xlpm.tbl_SBLCosts, _xlfn.HSTACK(_xlpm.f, _xlpm.g, DOLLAR(_xlpm.h*_xlpm.Magnitude, $C$12), DOLLAR(_xlpm.i*_xlpm.Magnitude, $C$12)),\n_xlpm.TPV_Costs, INDEX(_xlpm.tbl_SBLCosts, ROWS(_xlpm.tbl_SBLCosts), 3),\n\n_xlpm.net_11, \"Net impact on all impacted small businesses \"&CHAR(10)&\"[Total benefits minus total costs]\",\n_xlpm.net_12, _xlpm.TPV_Benefits-_xlpm.TPV_Costs,\n_xlpm.net_13, _xlpm.net_12*AF,\n_xlpm.net_21, \"Average net impact on each impacted small business \" &CHAR(10)&\"[Net impact divided by number of impacted small businesses]\",\n_xlpm.net_22, _xlpm.net_12/C6,\n_xlpm.net_23, _xlpm.net_22*AF,\n_xlpm.tbl_SBLNet, _xlfn.VSTACK(_xlfn.HSTACK(_xlpm.net_11, DOLLAR(_xlpm.net_12, $C$12), DOLLAR(_xlpm.net_13, $C$12)), _xlfn.HSTACK(_xlpm.net_21, DOLLAR(_xlpm.net_22, $C$12), DOLLAR(_xlpm.net_23, $C$12))),\n\n_xlpm.BenefitsHeader, _xlfn.HSTACK(\"Administrative or Compliance\", \"Description of benefit\", \"Present value\", \"Annualized Value\"),\n_xlpm.CostsHeader, _xlfn.HSTACK(\"Administrative or Compliance\", \"Description of cost\", \"Present value\", \"Annualized value\"),\n_xlpm.NetHeader, _xlfn.HSTACK(\"Amount\", \"Present value\", \"Annualized value\"),\n\n_xlpm.SBLYearHeader, _xlfn.HSTACK(\"CBA Parameter\", YearHeader_Discounted),\n\n_xlpm.IN_Undiscounted, _xlfn.IFS(YearHeader_Discounted=\"Total\", DOLLAR(SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$O$2),_xlfn.ANCHORARRAY( 'Full Output'!$D$2), \"In\")*_xlpm.Magnitude, $C$12), YearHeader_Discounted=\"Annualized\", \"N/A\", TRUE, DOLLAR(SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$O$2),_xlfn.ANCHORARRAY( 'Full Output'!$E$2), YearHeader_Discounted,_xlfn.ANCHORARRAY( 'Full Output'!$D$2), \"In\")*_xlpm.Magnitude, $C$12)),\n_xlpm.IN_Discounted, DOLLAR(_xlfn.IFS(YearHeader_Discounted=\"Total\", SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$T$2),_xlfn.ANCHORARRAY( 'Full Output'!$D$2), \"In\"), YearHeader_Discounted=\"Annualized\", SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$T$2),_xlfn.ANCHORARRAY( 'Full Output'!$D$2), \"In\")*AF, TRUE, SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$T$2),_xlfn.ANCHORARRAY( 'Full Output'!$E$2), YearHeader_Discounted,_xlfn.ANCHORARRAY( 'Full Output'!$D$2), \"In\"))*_xlpm.Magnitude, $C$12),\n_xlpm.OUT_Undiscounted, _xlfn.IFS(YearHeader_Discounted=\"Total\", DOLLAR(-SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$O$2),_xlfn.ANCHORARRAY( 'Full Output'!$D$2), \"Out\")*_xlpm.Magnitude, $C$12), YearHeader_Discounted=\"Annualized\", \"N/A\", TRUE, DOLLAR(-SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$O$2),_xlfn.ANCHORARRAY( 'Full Output'!$E$2), YearHeader_Discounted,_xlfn.ANCHORARRAY( 'Full Output'!$D$2), \"Out\")*_xlpm.Magnitude, $C$12)),\n_xlpm.OUT_Discounted, DOLLAR(-_xlfn.IFS(YearHeader_Discounted=\"Total\", SUMIFS(_xlfn.ANCHORARRAY('Full Output'!T2),_xlfn.ANCHORARRAY( 'Full Output'!D2), \"Out\"), YearHeader_Discounted=\"Annualized\", SUMIFS(_xlfn.ANCHORARRAY('Full Output'!T2),_xlfn.ANCHORARRAY( 'Full Output'!D2), \"Out\")*AF, TRUE, SUMIFS(_xlfn.ANCHORARRAY('Full Output'!T2),_xlfn.ANCHORARRAY( 'Full Output'!E2), YearHeader_Discounted,_xlfn.ANCHORARRAY( 'Full Output'!D2), \"Out\"))*_xlpm.Magnitude, $C$12),\n_xlpm.NET_Undiscounted, IFERROR(DOLLAR(_xlpm.OUT_Undiscounted-_xlpm.IN_Undiscounted, $C$12), \"N/A\"),\n_xlpm.NET_Discounted, DOLLAR(_xlpm.OUT_Discounted-_xlpm.IN_Discounted, $C$12),\n\n_xlpm.IN, _xlfn.VSTACK(\"IN\"&_xlpm.Magnitude_text, _xlpm.SBLYearHeader, _xlfn.HSTACK(_xlfn.VSTACK(\"Undiscounted\", \"Discounted\"), _xlfn.VSTACK(_xlpm.IN_Undiscounted, _xlpm.IN_Discounted))),\n_xlpm.OUT, _xlfn.VSTACK(\"OUT\"&_xlpm.Magnitude_text, _xlpm.SBLYearHeader, _xlfn.HSTACK(_xlfn.VSTACK(\"Undiscounted\", \"Discounted\"), _xlfn.VSTACK(_xlpm.OUT_Undiscounted, _xlpm.OUT_Discounted))),\n_xlpm.NET, _xlfn.VSTACK(\"NET\"&_xlpm.Magnitude_text, _xlpm.SBLYearHeader, _xlfn.HSTACK(_xlfn.VSTACK(\"Undiscounted\", \"Discounted\"), _xlfn.VSTACK(_xlpm.NET_Undiscounted, _xlpm.NET_Discounted))),\n\nIFERROR(_xlfn.VSTACK(\"Benefits\"&_xlpm.Magnitude_text, _xlpm.BenefitsHeader, _xlpm.tbl_SBLBenefits, \"\", \"\", \"Costs\"&_xlpm.Magnitude_text, _xlpm.CostsHeader, _xlpm.tbl_SBLCosts, \"\", \"\", \"Net Impacts\"&_xlpm.Magnitude_text, _xlpm.NetHeader, _xlpm.tbl_SBLNet, \"\", \"\", \"\", _xlpm.IN, \"\", _xlpm.OUT, \"\", _xlpm.NET),\"\"))","v":""}]

{"sheet":"Annual Stakeholder Count","index":6,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Annual Stakeholder Count"]
[]
[]
[]
[]
[null,null,null,0,{"$f":"_xlfn.SEQUENCE(,Timeperiod)","v":1},2,3,4,5,6,7,8,9,10]
[null,"Group","Type",{"$f":"_xlfn.HSTACK(YearOfRegistration, _xlfn.SEQUENCE(, Timeperiod, YearOfRegistration))","v":2024},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[null,{"$f":"IFERROR(_xlfn._xlws.SORT(_xlfn.TOCOL(IF(_xlfn.SEQUENCE(1, IF(SUM(tbl_Stakeholders[Non-business Count])=0, 3, 5)), _xlfn._xlws.FILTER(tbl_Stakeholders[Stakeholder Group], ISBLANK(tbl_Stakeholders[Stakeholder Group])=FALSE)),,1)), \"\")","v":""},{"$f":"IFERROR(_xlfn.TOCOL( IF(_xlfn.SEQUENCE(COUNTA(tbl_Stakeholders[Stakeholder Group]), 1), IF(SUM(tbl_Stakeholders[Non-business Count])>0, tbl_Stakeholders[[#Headers],[Non-business Count]:[Total Stakeholder Count]], tbl_Stakeholders[[#Headers],[Small Business Count]:[Total Business Count]])), ,FALSE ), \"\")","v":""},{"$f":"IFERROR(INDEX(tbl_Stakeholders[[Non-business Count]:[Total Stakeholder Count]], MATCH(_xlfn.ANCHORARRAY(B9), tbl_Stakeholders[Stakeholder Group], 0), MATCH(_xlfn.ANCHORARRAY(C9), tbl_Stakeholders[[#Headers],[Non-business Count]:[Total Stakeholder Count]], 0)), \"\")","v":""},{"$f":"IF(COUNTA(tbl_Stakeholders[Stakeholder Group])=0, \"\", _xlfn.MAKEARRAY(ROWS(_xlfn._xlws.FILTER(tbl_Stakeholders[], tbl_Stakeholders[Stakeholder Group]<>\"\"))*IF(SUM(tbl_Stakeholders[Non-business Count])>0, 5, 3), Timeperiod, _xlfn.LAMBDA(_xlpm.r,_xlpm.c,\nIFERROR(_xlfn.LET(\n_xlpm.ThisGroup, MATCH(INDEX(_xlfn.ANCHORARRAY($B$9), _xlpm.r), tbl_Stakeholders[Stakeholder Group], 0),\n_xlpm.x, INDEX(tbl_Stakeholders[Non-business Count], _xlpm.ThisGroup)*(1+INDEX(tbl_Stakeholders[Non-business Growth Rate], _xlpm.ThisGroup))^INDEX(_xlfn.ANCHORARRAY($E$7),, _xlpm.c),\n_xlpm.y, INDEX(tbl_Stakeholders[Small Business Count], _xlpm.ThisGroup)*(1+INDEX(tbl_Stakeholders[Small Business Growth Rate], _xlpm.ThisGroup))^INDEX(_xlfn.ANCHORARRAY($E$7),,_xlpm.c),\n_xlpm.z, INDEX(tbl_Stakeholders[Med/Large Business Count], _xlpm.ThisGroup)*(1+INDEX(tbl_Stakeholders[Med/Large Business Growth Rate], _xlpm.ThisGroup))^INDEX(_xlfn.ANCHORARRAY($E$7),,_xlpm.c),\nIF(INDEX(_xlfn.ANCHORARRAY($C$9), _xlpm.r)=\"Non-business Count\", _xlpm.x,\nIF(INDEX(_xlfn.ANCHORARRAY($C$9), _xlpm.r)=\"Small Business Count\", _xlpm.y,\nIF(INDEX(_xlfn.ANCHORARRAY($C$9), _xlpm.r)=\"Med/Large Business Count\", _xlpm.z,\nIF(INDEX(_xlfn.ANCHORARRAY($C$9), _xlpm.r)=\"Total Business Count\", _xlpm.y+_xlpm.z,\nIF(INDEX(_xlfn.ANCHORARRAY($C$9), _xlpm.r)=\"Total Stakeholder Count\", _xlpm.x+_xlpm.y+_xlpm.z)))))), \"\"))))","v":""}]
[null,"",null,""]
[null,"",null,""]

{"sheet":"Net Impacts","index":7,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Net impacts to all stakeholders throughout the analytical period"]
[]
[]
[null,"Price year:",{"$f":"PriceYear","v":2023}]
[null,"Discount rate:",{"$f":"Discount","v":7.0000000000000007E-2}]
[null,"Present value base year:",{"$f":"PVBaseYear","v":2024}]
[null,"Order of magnitude:","Single"]
[null,"Decimals:",0]
[]
[]
[null,"Note: negative values represent net costs and positive values represent net benefits."]
[]
[]
[null,"CBA Parameter",{"$f":"_xlfn.HSTACK(_xlfn.SEQUENCE(, Timeperiod, YearOfRegistration), \"Total\", \"Annualized\")","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,"Total","Annualized"]
[null,{"$f":"\"Discounted Impacts\" & IF($C$8=\"Millions\", \" ($ millions)\", IF($C$8=\"Billions\", \" ($ billions)\", \"\"))","v":"Discounted Impacts"},{"$f":"_xlfn.MAKEARRAY(1,Timeperiod+2,_xlfn.LAMBDA(_xlpm.r,_xlpm.c,\nDOLLAR(\n     IF(INDEX(_xlfn.ANCHORARRAY(C15),, _xlpm.c)=\"Total\",-SUM(_xlfn.ANCHORARRAY('Full Output'!$W$2)),\n     IF(INDEX(_xlfn.ANCHORARRAY(C15),, _xlpm.c)=\"Annualized\",-SUM(_xlfn.ANCHORARRAY('Full Output'!$W$2))*AF,\n     -SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$W$2),_xlfn.ANCHORARRAY('Full Output'!$E$2),INDEX(_xlfn.ANCHORARRAY(C15),, _xlpm.c))))\n/10^IF($C$8=\"Millions\",6,IF($C$8=\"Billions\",9)),\n$C$9)))","v":"$0"},"$0","$0","$0","$0","$0","$0","$0","$0","$0","$0","$0"]
[null,{"$f":"\"Undiscounted Impacts\"& IF($C$8=\"Millions\", \" ($ millions)\", IF($C$8=\"Billions\", \" ($ billions)\", \"\"))","v":"Undiscounted Impacts"},{"$f":"_xlfn.MAKEARRAY(1,Timeperiod+2,_xlfn.LAMBDA(_xlpm.r,_xlpm.c,\n     IF(INDEX(_xlfn.ANCHORARRAY(C15),, _xlpm.c)=\"Total\",DOLLAR(-SUM(_xlfn.ANCHORARRAY('Full Output'!R2))/10^IF($C$8=\"Millions\", 6, IF($C$8=\"Billions\", 9)), $C$9),\n     IF(INDEX(_xlfn.ANCHORARRAY(C15),, _xlpm.c)=\"Annualized\", \"N/A\",\n     DOLLAR(-SUMIFS(_xlfn.ANCHORARRAY('Full Output'!R2),_xlfn.ANCHORARRAY( 'Full Output'!E2), INDEX(_xlfn.ANCHORARRAY(C15),, _xlpm.c))/10^IF($C$8=\"Millions\", 6, IF($C$8=\"Billions\", 9)), $C$9)\n))))","v":"$0"},"$0","$0","$0","$0","$0","$0","$0","$0","$0","$0","N/A"]

{"sheet":"Net Impacts by Activity","index":8,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Net Impacts by Activity"]
[]
[]
[null,"Price year:",{"$f":"PriceYear","v":2023}]
[null,"Discount rate:",{"$f":"Discount","v":7.0000000000000007E-2}]
[null,"Present value base year:",{"$f":"PVBaseYear","v":2024}]
[null,"Order of magnitude:","Single"]
[null,"Decimals:",0]
[]
[]
[null,"Note: negative values represent net costs and positive values represent net benefits."]
[]
[]
[null,{"$f":"_xlfn.LET(\n_xlpm.Activities, _xlfn.UNIQUE(_xlfn._xlws.FILTER(tbl_Activities[Activity], Checkblank)),\n_xlpm.Magnitude, 1/10^IF($C$8=\"Millions\",6,IF($C$8=\"Billions\",9)),\n_xlpm.Magnitude_text, IF($C$8=\"Millions\", \" ($ millions)\",IF($C$8=\"Billions\", \" ($ billions)\", \"\")),\n\n_xlpm.x, -_xlfn.MAKEARRAY(ROWS(_xlpm.Activities), Timeperiod+2, _xlfn.LAMBDA(_xlpm.r,_xlpm.c,\n     IF(INDEX(YearHeader_Discounted,, _xlpm.c)=\"Total\", SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$W$2),_xlfn.ANCHORARRAY('Full Output'!$B$2), INDEX(_xlpm.Activities, _xlpm.r)),\n     IF(INDEX(YearHeader_Discounted,, _xlpm.c)=\"Annualized\", SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$W$2),_xlfn.ANCHORARRAY('Full Output'!$B$2), INDEX(_xlpm.Activities, _xlpm.r))*AF,\n     (SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$W$2),_xlfn.ANCHORARRAY('Full Output'!$E$2), INDEX(YearHeader_Discounted,, _xlpm.c),_xlfn.ANCHORARRAY('Full Output'!$B$2), INDEX(_xlpm.Activities, _xlpm.r))))))),\n_xlpm.Output_Discounted, _xlfn.VSTACK(_xlfn.HSTACK(\"Activity\", YearHeader_Discounted), _xlfn.HSTACK(_xlfn.VSTACK(_xlpm.Activities, \"Total\"), DOLLAR(_xlfn.VSTACK(_xlpm.x, _xlfn.BYCOL(_xlpm.x, _xlfn.LAMBDA(_xlpm.c, SUM(_xlpm.c))))*_xlpm.Magnitude, $C$9))),\n\n_xlpm.y, -_xlfn.MAKEARRAY(ROWS(_xlpm.Activities), Timeperiod+1, _xlfn.LAMBDA(_xlpm.r,_xlpm.c,\n     IF(INDEX(YearHeader_Undiscounted,, _xlpm.c)=\"Total\", SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$R$2),_xlfn.ANCHORARRAY( 'Full Output'!$B$2), INDEX(_xlpm.Activities, _xlpm.r)),\n     SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$R$2),_xlfn.ANCHORARRAY( 'Full Output'!$E$2), INDEX(YearHeader_Undiscounted,, _xlpm.c),_xlfn.ANCHORARRAY( 'Full Output'!$B$2), INDEX(_xlpm.Activities, _xlpm.r))))),\n_xlpm.Output_Undiscounted, _xlfn.VSTACK(_xlfn.HSTACK(\"Activity\", YearHeader_Undiscounted), _xlfn.HSTACK(_xlfn.VSTACK(_xlpm.Activities, \"Total\"), DOLLAR(_xlfn.VSTACK(_xlpm.y, _xlfn.BYCOL(_xlpm.y, _xlfn.LAMBDA(_xlpm.c, SUM(_xlpm.c))))*_xlpm.Magnitude, $C$9))),\n\nIFERROR(_xlfn.VSTACK(\"Discounted\"&_xlpm.Magnitude_text, \"\", _xlpm.Output_Discounted, \"\", \"\", \"Undiscounted\"&_xlpm.Magnitude_text, \"\", _xlpm.Output_Undiscounted), \"\"))","v":""}]

{"sheet":"Net Impacts by Stakeholder","index":9,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Net Impacts by Stakeholder"]
[]
[]
[null,"Price year:",{"$f":"PriceYear","v":2023}]
[null,"Discount rate:",{"$f":"Discount","v":7.0000000000000007E-2}]
[null,"Present value base year:",{"$f":"PVBaseYear","v":2024}]
[null,"Order of magnitude:","Single"]
[null,"Decimals:",0]
[]
[]
[null,"Note: negative values represent net costs and positive values represent net benefits."]
[]
[]
[null,{"$f":"_xlfn.LET(\n\n_xlpm.Magnitude, 1/10^IF($C$8=\"Millions\", 6, IF($C$8=\"Billions\", 9)),\n_xlpm.Magnitude_text, IF($C$8=\"Millions\", \" ($ millions)\", IF($C$8=\"Billions\", \" ($ billions)\", \"\")),\n\n_xlpm.output_discounted,\n     _xlfn.LET(_xlpm.x, TRANSPOSE(_xlfn.MAKEARRAY(Timeperiod, StakeholderCols, _xlfn.LAMBDA(_xlpm.r,_xlpm.c,\n     SUMIFS(INDEX(_xlfn.ANCHORARRAY('Full Output'!$AP$2), ,_xlpm.c+StakeholderCols),_xlfn.ANCHORARRAY( 'Full Output'!$E$2), INDEX(_xlfn.SEQUENCE(Timeperiod, , YearOfRegistration), _xlpm.r,))))),\n     _xlpm.y, _xlfn.BYROW(_xlpm.x, _xlfn.LAMBDA(_xlpm.a, SUM(_xlpm.a))),\n     _xlpm.w, _xlpm.y*AF,\n     _xlpm.z, _xlfn.HSTACK(_xlpm.x, _xlpm.y, _xlpm.w),\n     _xlpm.u, _xlfn.BYCOL(_xlpm.z, _xlfn.LAMBDA(_xlpm.b, SUM(_xlpm.b))),\n     _xlpm.e, DOLLAR(-_xlfn.VSTACK(_xlpm.z, _xlpm.u)*_xlpm.Magnitude, $C$9),\n     _xlfn.HSTACK(StakeholderGroupsTotal, _xlfn.VSTACK(YearHeader_Discounted, _xlpm.e))),\n\n_xlpm.output_undiscounted,\n     _xlfn.LET(_xlpm.x, TRANSPOSE(_xlfn.MAKEARRAY(Timeperiod, StakeholderCols, _xlfn.LAMBDA(_xlpm.r,_xlpm.c,\n     SUMIFS(INDEX(_xlfn.ANCHORARRAY('Full Output'!$AP$2), ,_xlpm.c),_xlfn.ANCHORARRAY( 'Full Output'!$E$2), INDEX(_xlfn.SEQUENCE(Timeperiod, , YearOfRegistration), _xlpm.r,))))),\n     _xlpm.y, _xlfn.BYROW(_xlpm.x, _xlfn.LAMBDA(_xlpm.a, SUM(_xlpm.a))),\n     _xlpm.z, _xlfn.HSTACK(_xlpm.x, _xlpm.y),\n     _xlpm.u, _xlfn.BYCOL(_xlpm.z, _xlfn.LAMBDA(_xlpm.b, SUM(_xlpm.b))),\n     _xlpm.e, DOLLAR(-_xlfn.VSTACK(_xlpm.z, _xlpm.u)*_xlpm.Magnitude, $C$9),\n     _xlfn.HSTACK(StakeholderGroupsTotal, _xlfn.VSTACK(YearHeader_Undiscounted, _xlpm.e))),\n\nIFERROR(_xlfn.VSTACK(\"Discounted\"&_xlpm.Magnitude_text, \"\", _xlpm.output_discounted, \"\", \"\", \"Undiscounted\"&_xlpm.Magnitude_text, \"\", _xlpm.output_undiscounted), \"\"))","v":""}]

{"sheet":"Labour","index":10,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Statistics Canada.Table  14-10-0340-01   Employee wages by occupation, annual, 1997 to 2022"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"TypeHere_Wages","v":""},"National Occupational Classification (NOC)","Price year of data source","Wage in price year of data source (without overhead)","Wage in price year of analysis (without overhead)"]
[null,"","01 Canada average",2021,30.03,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":33.317182203389827}]
[null,"","02 Management occupations",2021,49,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":54.363700564971751}]
[null,"","03 Senior management occupations",2021,57.52,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":63.816327683615818}]
[null,"","04 Specialized middle management occupations",2021,52.98,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":58.779364406779656}]
[null,"","05 Middle management occupations in retail and wholesale trade and customer services",2021,39.28,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":43.579717514124297}]
[null,"","06 Middle management occupations in trades, transportation, production and utilities",2021,46.16,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":51.21282485875706}]
[null,"","07 Business, finance and administration occupations",2021,29.87,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":33.139668079096047}]
[null,"","08 Professional occupations in business and finance",2021,39.11,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":43.391108757062149}]
[null,"","09 Administrative and financial supervisors and administrative occupations",2021,28.89,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":32.052394067796612}]
[null,"","10 Finance, insurance and related business administrative occupations",2021,29.32,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":32.529463276836154}]
[null,"","11 Office support occupations",2021,23.37,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":25.92815677966102}]
[null,"","12 Distribution, tracking and scheduling co-ordination occupations",2021,23.84,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":26.44960451977401}]
[null,"","13 Natural and applied sciences and related occupations",2021,39.99,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":44.36743644067797}]
[null,"","14 Professional occupations in natural and applied sciences",2021,43.84,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":48.638870056497176}]
[null,"","15 Technical occupations related to natural and applied sciences",2021,33.28,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":36.922937853107342}]
[null,"","16 Health occupations",2021,31.85,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":35.336405367231642}]
[null,"","17 Professional occupations in nursing",2021,39.590000000000003,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":43.923651129943501}]
[null,"","18 Professional occupations in health (except nursing)",2021,41.61,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":46.164766949152543}]
[null,"","19 Technical occupations in health",2021,29.79,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":33.050911016949151}]
[null,"","20 Assisting occupations in support of health services",2021,22.16,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":24.585706214689264}]
[null,"","21 Occupations in education, law and social, community and government services",2021,35.36,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":39.23062146892655}]
[null,"","22 Professional occupations in education services",2021,39.97,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":44.345247175141239}]
[null,"","23 Professional occupations in law and social, community and government services",2021,40.03,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":44.411814971751411}]
[null,"","24 Paraprofessional occupations in legal, social, community and education services",2021,23.9,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":26.516172316384178}]
[null,"","25 Occupations in front-line public protection services",2021,44.35,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":49.204696327683621}]
[null,"","26 Care providers and educational, legal and public protection support occupations",2021,23.86,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":26.471793785310734}]
[null,"","27 Occupations in art, culture, recreation and sport",2021,28.38,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":31.486567796610167}]
[null,"","28 Professional occupations in art and culture",2021,32.799999999999997,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":36.390395480225983}]
[null,"","29 Technical occupations in art, culture, recreation and sport",2021,26.58,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":29.489533898305083}]
[null,"","30 Sales and service occupations",2021,19.55,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":21.690007062146893}]
[null,"","31 Retail sales supervisors and specialized sales occupations",2021,25.49,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":28.280218926553673}]
[null,"","32 Service supervisors and specialized service occupations",2021,19.84,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":22.01175141242938}]
[null,"","33 Sales representatives and salespersons - wholesale and retail trade",2021,20.440000000000001,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":22.677429378531077}]
[null,"","34 Service representatives and other customer and personal services occupations",2021,19.670000000000002,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":21.823142655367235}]
[null,"","35 Sales support occupations",2021,15.45,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":17.141207627118643}]
[null,"","36 Service support and other service occupations, n.e.c.",2021,17.54,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":19.459985875706213}]
[null,"","37 Trades, transport and equipment operators and related occupations",2021,28.67,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":31.808312146892654}]
[null,"","38 Industrial, electrical and construction trades",2021,32.07,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":35.580487288135593}]
[null,"","39 Maintenance and equipment operation trades",2021,32.549999999999997,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":36.113029661016945}]
[null,"","40 Other installers, repairers and servicers and material handlers",2021,22.13,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":24.552422316384177}]
[null,"","41 Transport and heavy equipment operation and related maintenance occupations",2021,24.95,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":27.681108757062145}]
[null,"","42 Trades helpers, construction labourers and related occupations",2021,24.09,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":26.726970338983051}]
[null,"","43 Natural resources, agriculture and related production occupations",2021,25.98,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":28.82385593220339}]
[null,"","44 Supervisors and technical occupations in natural resources, agriculture and related production",2021,35.32,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":39.186242937853109}]
[null,"","45 Workers in natural resources, agriculture and related production",2021,20.99,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":23.28763418079096}]
[null,"","46 Harvesting, landscaping and natural resources labourers",2021,21.16,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":23.476242937853108}]
[null,"","47 Occupations in manufacturing and utilities",2021,24.85,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":27.570162429378531}]
[null,"","48 Processing, manufacturing and utilities supervisors and central control operators",2021,35.049999999999997,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":38.88668785310734}]
[null,"","49 Processing and manufacturing machine operators and related production workers",2021,22.37,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":24.818693502824861}]
[null,"","50 Assemblers in manufacturing",2021,22.94,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":25.451087570621471}]
[null,"","51 Labourers in processing, manufacturing and utilities",2021,19.61,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":21.756574858757062}]
[null,"Type Here ⮚",null,null,null,{"$f":"IFERROR(tbl_Wages[[#This Row],[Wage in price year of data source (without overhead)]]*INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(tbl_Wages[[#This Row],[Price year of data source]], tbl_CPI[Year], 0)), \"\")","v":""}]
[null,""]

{"sheet":"CPI","index":11,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Statistics Canada. Table 18-10-0005-01  Consumer Price Index, annual average, not seasonally adjusted"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Year","Index"]
[null,{"$f":"_xlfn.VSTACK(IF(tbl_CPI[Year]=tbl_CPI[Year], \"\"), \"Type Here ⮚\")","v":""},2002,100]
[null,"",2003,102.8]
[null,"",2004,104.7]
[null,"",2005,107]
[null,"",2006,109.1]
[null,"",2007,111.5]
[null,"",2008,114.1]
[null,"",2009,114.4]
[null,"",2010,116.5]
[null,"",2011,119.9]
[null,"",2012,121.7]
[null,"",2013,122.8]
[null,"",2014,125.2]
[null,"",2015,126.6]
[null,"",2016,128.4]
[null,"",2017,130.4]
[null,"",2018,133.4]
[null,"",2019,136]
[null,"",2020,137]
[null,"",2021,141.6]
[null,"",2022,151.19999999999999]
[null,"",2023,157.1]
[null,"Type Here ⮚"]

{"sheet":"Full Output","index":12,"n_rows":2,"n_cols":43,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Activity Number","Activity Description","Administrative/ Compliance","In/Out","Year","Period","Frequency","Affected Group","Percent Affected","Affected Non-businesses Stakeholder Count","Affected Small Businesses Stakeholder Count","Affected Med/Large Businesses Stakeholder Count",{"$f":"\"Cost Per Event (\"&PriceYear&\" CAD)\"","v":"Cost Per Event (2023 CAD)"},"Undiscounted Impacts to Non-Businesses","Undiscounted Impacts to Small Businesses","Undiscounted Impacts to Med/Large Businesses","Undiscounted Impacts to All Businesses","Undiscounted Impacts to All Stakeholders","Discounted Impacts to Non-Businesses","Discounted Impacts to Small Businesses","Discounted Impacts to Med/Large Businesses","Discounted Impacts to All Businesses","Discounted Impacts to All Stakeholders","Discounted Admin Impacts to All Affected Businesses (Fixed at 7%)",null,null,"Start","Affected Type","Activity Type","Exponent","Exponent_P0","Exponent_discounting","Affected Group (Index from Stakeholder Profile)","This Group Starting Non-Business Count","This Group Non-Business Growth Rate","This Group Starting Small Business Count","This Group Small Business Growth Rate","This Group Starting Med/Large Business Count","This Group  Med/Large Business Growth Rate",null,{"$f":"\"{undiscounted, discounted}:\"","v":"{undiscounted, discounted}:"},{"$f":"IFERROR(_xlfn.LET(_xlpm.x, TRANSPOSE(_xlfn._xlws.FILTER(tbl_Stakeholders[Stakeholder Group], tbl_Stakeholders[Stakeholder Group]<>\"\")), _xlfn.HSTACK(_xlpm.x&\" Undiscounted Impacts\", _xlpm.x&\" Discounted Impacts\")), \"\")","v":""}]
[{"$f":"repeat(Periods, ActivityNumber)","v":""},{"$f":"IFERROR(INDEX(tbl_Activities[Activity],_xlfn.ANCHORARRAY( A2)), \"\")","v":""},{"$f":"IFERROR(INDEX(tbl_Activities[Administrative or Compliance],_xlfn.ANCHORARRAY( A2)), \"\")","v":""},{"$f":"IFERROR(INDEX(tbl_Activities[In or Out],_xlfn.ANCHORARRAY( A2)), \"\")","v":""},{"$f":"IFERROR(\nIF(_xlfn.ANCHORARRAY(AA2)=\"Start of Analytical Period\", YearOfRegistration,\nIF(_xlfn.ANCHORARRAY(AA2)=\"End of Analytical Period\", YearOfRegistration+Timeperiod-1,_xlfn.ANCHORARRAY(\nAA2)))\n\n+ROUNDUP(IF(_xlfn.ANCHORARRAY(F2)/_xlfn.ANCHORARRAY(G2)-1<0, 0,_xlfn.ANCHORARRAY( F2)/_xlfn.ANCHORARRAY(G2)-1), 0), \"\")","v":""},{"$f":"IFERROR(\n_xlfn.LET(\n_xlpm.a, _xlfn._xlws.FILTER(Periods, Checkblank),\n_xlpm.b, _xlfn.SEQUENCE(COUNTA(_xlfn._xlws.FILTER(Periods, Checkblank))),\n_xlpm.c, TRANSPOSE(_xlpm.b),\n_xlpm.d, --(_xlpm.b>=_xlpm.c),\n_xlpm.e, MMULT(_xlpm.d, _xlpm.a),\n_xlpm.f, SUM(_xlpm.a),\n_xlpm.g, _xlfn.SEQUENCE(_xlpm.f),\n_xlpm.h, _xlfn.XMATCH(_xlpm.g-1, _xlpm.e,-1),\n_xlpm.I, IFERROR(INDEX(_xlpm.e,_xlpm.h),0),\n_xlpm.j, _xlpm.g - _xlpm.I,\n_xlpm.j)-IF(INDEX(tbl_Activities[Upfront or  Ongoing],_xlfn.ANCHORARRAY( A2))=\"Upfront\", 1, 0),\n\"\")","v":""},{"$f":"IFERROR(IF(INDEX(tbl_Activities[Upfront or  Ongoing],_xlfn.ANCHORARRAY( A2))=\"Ongoing\", INDEX(tbl_Activities[Annual Frequency],_xlfn.ANCHORARRAY( A2)), 1), \"\")","v":""},{"$f":"IFERROR(INDEX(tbl_Activities[Affected Stakeholder Group],_xlfn.ANCHORARRAY( A2)), \"\")","v":""},{"$f":"IFERROR(INDEX(tbl_Activities[Percent Affected],_xlfn.ANCHORARRAY( A2)), \"\")","v":""},{"$f":"_xlfn.MAKEARRAY(OutputRows, 1, _xlfn.LAMBDA(_xlpm.r,_xlpm.c,\n\nIFERROR(IF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"All Businesses\", 0, IF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"Med/Large Businesses\", 0, IF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"Small Businesses\", 0,\n\nINDEX(_xlfn.TAKE(_xlfn.DROP(I:I,MATCH($I$1,I:I,0)),_xlfn.XMATCH(,_xlfn.DROP(I:I,MATCH($I$1,I:I,0)))-1), _xlpm.r)*\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=1, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), SUMPRODUCT(NonBusinessCounts, (1+NonBusinessGrowthRates)^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=1, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), INDEX(_xlfn.ANCHORARRAY(AH2), _xlpm.r)*(1+INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=2, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), SUMPRODUCT(NonBusinessCounts, (1+NonBusinessGrowthRates)^IF(NonBusinessGrowthRates<0, INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r))),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=2, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), INDEX(_xlfn.ANCHORARRAY(AH2), _xlpm.r)*(1+INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r))^IF(INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r)<0, INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r)),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=3, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), SUMPRODUCT(NonBusinessCounts, (1+IF(NonBusinessGrowthRates<0, 0, NonBusinessGrowthRates))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+IF(NonBusinessGrowthRates<0, 0, NonBusinessGrowthRates))^INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r)),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=3, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), IF(INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r)<0, 0, INDEX(_xlfn.ANCHORARRAY(AH2), _xlpm.r)*((1+INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r))),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=4, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, SUMPRODUCT(NonBusinessCounts, (1+NonBusinessGrowthRates)^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)), _xlfn.LET(_xlpm.g, (1+IF(NonBusinessGrowthRates<0, 0, NonBusinessGrowthRates)), SUMPRODUCT(NonBusinessCounts, _xlpm.g^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-_xlpm.g^(INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1))))),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=4, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, INDEX(_xlfn.ANCHORARRAY(AH2), _xlpm.r)*(1+INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), IF(INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r)<0, 0, INDEX(_xlfn.ANCHORARRAY(AH2), _xlpm.r)*((1+INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1)))),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=5, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)>0, 0, SUMPRODUCT(NonBusinessCounts, (1+NonBusinessGrowthRates)^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r))),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=5, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)>0, 0, INDEX(_xlfn.ANCHORARRAY(AH2), _xlpm.r)*(1+INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=6, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, 0, _xlfn.LET(_xlpm.g, (1+IF(NonBusinessGrowthRates<0, 0, NonBusinessGrowthRates)), SUMPRODUCT(NonBusinessCounts, _xlpm.g^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-_xlpm.g^(INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1))))),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=6, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, 0, IF(INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r)<0, 0, INDEX(_xlfn.ANCHORARRAY(AH2), _xlpm.r)*((1+INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+INDEX(_xlfn.ANCHORARRAY(AI2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1)))),\n\n0))))))))))))))), 0)))","v":0},{"$f":"_xlfn.MAKEARRAY(OutputRows, 1, _xlfn.LAMBDA(_xlpm.r,_xlpm.c,\n\nIFERROR(IF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"Med/Large Businesses\", 0, IF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"All Non-Businesses\", 0,\n\nINDEX(_xlfn.TAKE(_xlfn.DROP(I:I,MATCH($I$1,I:I,0)),_xlfn.XMATCH(,_xlfn.DROP(I:I,MATCH($I$1,I:I,0)))-1), _xlpm.r)*\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=1, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), SUMPRODUCT(SmallBusinessCounts, (1+SmallBusinessGrowthRates)^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=1, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), INDEX(_xlfn.ANCHORARRAY(AJ2), _xlpm.r)*(1+INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=2, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), SUMPRODUCT(SmallBusinessCounts, (1+SmallBusinessGrowthRates)^IF(SmallBusinessGrowthRates<0, INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r))),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=2, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), INDEX(_xlfn.ANCHORARRAY(AJ2), _xlpm.r)*(1+INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r))^IF(INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r)<0, INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r)),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=3, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), SUMPRODUCT(SmallBusinessCounts, (1+IF(SmallBusinessGrowthRates<0, 0, SmallBusinessGrowthRates))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+IF(SmallBusinessGrowthRates<0, 0, SmallBusinessGrowthRates))^INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r)),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=3, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), IF(INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r)<0, 0, INDEX(_xlfn.ANCHORARRAY(AJ2), _xlpm.r)*((1+INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r))),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=4, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, SUMPRODUCT(SmallBusinessCounts, (1+SmallBusinessGrowthRates)^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)), _xlfn.LET(_xlpm.g, (1+IF(SmallBusinessGrowthRates<0, 0, SmallBusinessGrowthRates)), SUMPRODUCT(SmallBusinessCounts, _xlpm.g^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-_xlpm.g^(INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1))))),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=4, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, INDEX(_xlfn.ANCHORARRAY(AJ2), _xlpm.r)*(1+INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), IF(INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r)<0, 0, INDEX(_xlfn.ANCHORARRAY(AJ2), _xlpm.r)*((1+INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1)))),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=5, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)>0, 0, SUMPRODUCT(SmallBusinessCounts, (1+SmallBusinessGrowthRates)^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r))),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=5, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)>0, 0, INDEX(_xlfn.ANCHORARRAY(AJ2), _xlpm.r)*(1+INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=6, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, 0, _xlfn.LET(_xlpm.g, (1+IF(SmallBusinessGrowthRates<0, 0, SmallBusinessGrowthRates)), SUMPRODUCT(SmallBusinessCounts, _xlpm.g^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-_xlpm.g^(INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1))))),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=6, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, 0, IF(INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r)<0, 0, INDEX(_xlfn.ANCHORARRAY(AJ2), _xlpm.r)*((1+INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+INDEX(_xlfn.ANCHORARRAY(AK2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1)))),\n\n0)))))))))))))), 0)))","v":0},{"$f":"_xlfn.MAKEARRAY(OutputRows, 1, _xlfn.LAMBDA(_xlpm.r,_xlpm.c,\n\nIFERROR(IF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"Small Businesses\", 0, IF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"All Non-Businesses\", 0,\n\nINDEX(_xlfn.TAKE(_xlfn.DROP(I:I,MATCH($I$1,I:I,0)),_xlfn.XMATCH(,_xlfn.DROP(I:I,MATCH($I$1,I:I,0)))-1), _xlpm.r)*\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=1, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), SUMPRODUCT(MedLargeBusinessCounts, (1+MedLargeBusinessGrowthRates)^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=1, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), INDEX(_xlfn.ANCHORARRAY(AL2), _xlpm.r)*(1+INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=2, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), SUMPRODUCT(MedLargeBusinessCounts, (1+MedLargeBusinessGrowthRates)^IF(MedLargeBusinessGrowthRates<0, INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r))),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=2, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), INDEX(_xlfn.ANCHORARRAY(AL2), _xlpm.r)*(1+INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r))^IF(INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r)<0, INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r)),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=3, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), SUMPRODUCT(MedLargeBusinessCounts, (1+IF(MedLargeBusinessGrowthRates<0, 0, MedLargeBusinessGrowthRates))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+IF(MedLargeBusinessGrowthRates<0, 0, MedLargeBusinessGrowthRates))^INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r)),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=3, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), IF(INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r)<0, 0, INDEX(_xlfn.ANCHORARRAY(AL2), _xlpm.r)*((1+INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r))),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=4, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, SUMPRODUCT(MedLargeBusinessCounts, (1+MedLargeBusinessGrowthRates)^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)), _xlfn.LET(_xlpm.g, (1+IF(MedLargeBusinessGrowthRates<0, 0, MedLargeBusinessGrowthRates)), SUMPRODUCT(MedLargeBusinessCounts, _xlpm.g^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-_xlpm.g^(INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1))))),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=4, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, INDEX(_xlfn.ANCHORARRAY(AL2), _xlpm.r)*(1+INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), IF(INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r)<0, 0, INDEX(_xlfn.ANCHORARRAY(AL2), _xlpm.r)*((1+INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1)))),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=5, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)>0, 0, SUMPRODUCT(MedLargeBusinessCounts, (1+MedLargeBusinessGrowthRates)^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r))),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=5, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)>0, 0, INDEX(_xlfn.ANCHORARRAY(AL2), _xlpm.r)*(1+INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)),\n\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=6, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\"), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, 0, _xlfn.LET(_xlpm.g, (1+IF(MedLargeBusinessGrowthRates<0, 0, MedLargeBusinessGrowthRates)), SUMPRODUCT(MedLargeBusinessCounts, _xlpm.g^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-_xlpm.g^(INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1))))),\nIF(AND(INDEX(_xlfn.ANCHORARRAY(AC2), _xlpm.r)=6, NOT(INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\")), IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, 0, IF(INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r)<0, 0, INDEX(_xlfn.ANCHORARRAY(AL2), _xlpm.r)*((1+INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+INDEX(_xlfn.ANCHORARRAY(AM2), _xlpm.r))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1)))),\n\n0)))))))))))))), 0)))","v":0},{"$f":"IFERROR(\n_xlfn.LET(\n     _xlpm.InternalExternal, INDEX(tbl_Activities[Labour: Internal or External Overhead],_xlfn.ANCHORARRAY( A2)),\n     _xlpm.CapitalLabour, INDEX(tbl_Activities[Capital or Labour],_xlfn.ANCHORARRAY( A2)),\n\nIF(_xlfn.ANCHORARRAY(D2)=\"Out\", -1, 1)*\n\nIF(_xlpm.CapitalLabour=\"Capital\", INDEX(tbl_Activities[Capital: Number of Units],_xlfn.ANCHORARRAY( A2))*INDEX(tbl_Activities[Capital: Unit Price],_xlfn.ANCHORARRAY( A2))\n     *INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(INDEX(tbl_Activities[Capital: Price Year of Unit Price],_xlfn.ANCHORARRAY( A2)), tbl_CPI[Year], 0)),\n\nIF(_xlpm.CapitalLabour=\"Labour\", INDEX(tbl_Wages[Wage in price year of analysis (without overhead)], MATCH(INDEX(_xlfn.TEXTBEFORE(tbl_Activities[Labour: Staff Level (Wage Without Overhead)], \" ($\"),_xlfn.ANCHORARRAY( A2)), tbl_Wages[National Occupational Classification (NOC)], 0))\n          *(1+IF(_xlpm.InternalExternal=\"Internal (25%)\", 0.25, IF(_xlpm.InternalExternal=\"External (50%)\", 0.5, 0)))\n          *(INDEX(tbl_Activities[Labour: Time Spent (hours)],_xlfn.ANCHORARRAY( A2))),\n\n\"\"))),\n\"\")","v":""},{"$f":"_xlfn.LET(\n     _xlpm.AffectedNonBusinesses, _xlfn.TAKE(_xlfn.DROP(J:J,MATCH(J$1,J:J,0)),_xlfn.XMATCH(,_xlfn.DROP(J:J,MATCH(J$1,J:J,0)))-1),\nIFERROR(_xlfn.ANCHORARRAY(M2)*_xlpm.AffectedNonBusinesses, \"\"))","v":""},{"$f":"_xlfn.LET(\n     _xlpm.AffectedSmallBusinesses, _xlfn.TAKE(_xlfn.DROP(K:K,MATCH(K$1,K:K,0)),_xlfn.XMATCH(,_xlfn.DROP(K:K,MATCH(K$1,K:K,0)))-1),\nIFERROR(_xlfn.ANCHORARRAY(M2)*_xlpm.AffectedSmallBusinesses, \"\"))","v":""},{"$f":"_xlfn.LET(\n     _xlpm.AffectedMedLargeBusinesses, _xlfn.TAKE(_xlfn.DROP(L:L,MATCH(L$1,L:L,0)),_xlfn.XMATCH(,_xlfn.DROP(L:L,MATCH(L$1,L:L,0)))-1),\nIFERROR(_xlfn.ANCHORARRAY(M2)*_xlpm.AffectedMedLargeBusinesses, \"\"))","v":""},{"$f":"IFERROR(_xlfn.ANCHORARRAY($O$2)+_xlfn.ANCHORARRAY($P$2),0)","v":0},{"$f":"IFERROR(_xlfn.ANCHORARRAY($Q$2)+_xlfn.ANCHORARRAY($N$2), 0)","v":0},{"$f":"IFERROR(_xlfn.ANCHORARRAY($N$2)/(1+Discount)^_xlfn.ANCHORARRAY($AF$2),0)","v":0},{"$f":"IFERROR(_xlfn.ANCHORARRAY($O$2)/(1+Discount)^_xlfn.ANCHORARRAY($AF$2),0)","v":0},{"$f":"IFERROR(_xlfn.ANCHORARRAY(P2)/(1+Discount)^_xlfn.ANCHORARRAY($AF$2),0)","v":0},{"$f":"IFERROR(_xlfn.ANCHORARRAY($T$2)+_xlfn.ANCHORARRAY($U$2), 0)","v":0},{"$f":"IFERROR(_xlfn.ANCHORARRAY($V$2)+_xlfn.ANCHORARRAY($S$2), 0)","v":0},{"$f":"IFERROR(--(_xlfn.ANCHORARRAY($C$2)=\"Administrative\")*(_xlfn.ANCHORARRAY($O$2)+_xlfn.ANCHORARRAY($P$2))/(1.07)^_xlfn.ANCHORARRAY($AF$2), 0)","v":0},null,null,{"$f":"IFERROR(INDEX(tbl_Activities[Start Year],_xlfn.ANCHORARRAY( $A$2)), \"\")","v":""},{"$f":"IFERROR(INDEX(tbl_Activities[Affected Stakeholder Type],_xlfn.ANCHORARRAY( A2)), \"\")","v":""},{"$f":"IFERROR(INDEX(ActivityType,_xlfn.ANCHORARRAY( A2)), \"\")","v":""},{"$f":"IFERROR(\nIF(_xlfn.ANCHORARRAY(AA2)=\"Start of Analytical Period\",_xlfn.ANCHORARRAY( F2)/_xlfn.ANCHORARRAY(G2),\nIF(_xlfn.ANCHORARRAY(AA2)=\"End of Analytical Period\",Timeperiod-1+_xlfn.ANCHORARRAY(F2)/_xlfn.ANCHORARRAY(G2),_xlfn.ANCHORARRAY(\nAA2)-YearOfRegistration+_xlfn.ANCHORARRAY(F2)/_xlfn.ANCHORARRAY(G2))),\n\"\")","v":""},{"$f":"IFERROR(\nIF(_xlfn.ANCHORARRAY(AA2)=\"Start of Analytical Period\", 0,\nIF(_xlfn.ANCHORARRAY(AA2)=\"End of Analytical Period\", Timeperiod-1,_xlfn.ANCHORARRAY(\nAA2)-YearOfRegistration)),\n\"\")","v":""},{"$f":"IFERROR(\nIF(_xlfn.ANCHORARRAY(AA2)=\"Start of Analytical Period\", (YearOfRegistration-PVBaseYear)+_xlfn.ANCHORARRAY($F$2)/_xlfn.ANCHORARRAY($G$2),\nIF(_xlfn.ANCHORARRAY(AA2)=\"End of Analytical Period\", (YearOfRegistration-PVBaseYear)+Timeperiod-1+_xlfn.ANCHORARRAY($F$2)/_xlfn.ANCHORARRAY($G$2),_xlfn.ANCHORARRAY(\nAA2)-PVBaseYear+_xlfn.ANCHORARRAY($F$2)/_xlfn.ANCHORARRAY($G$2))),\n\"\")","v":""},{"$f":"IFERROR(MATCH(INDEX(tbl_Activities[Affected Stakeholder Group],_xlfn.ANCHORARRAY( 'Full Output'!$A$2)), _xlfn._xlws.FILTER(tbl_Stakeholders[Stakeholder Group], tbl_Stakeholders[Stakeholder Group]<>\"\"), 0), \"\")","v":""},{"$f":"IFERROR(INDEX(NonBusinessCounts,_xlfn.ANCHORARRAY( AG2)), \"\")","v":""},{"$f":"IFERROR(INDEX(NonBusinessGrowthRates,_xlfn.ANCHORARRAY( AG2)), \"\")","v":""},{"$f":"IFERROR(INDEX(SmallBusinessCounts,_xlfn.ANCHORARRAY( AG2)), \"\")","v":""},{"$f":"IFERROR(INDEX(SmallBusinessGrowthRates,_xlfn.ANCHORARRAY( AG2)), \"\")","v":""},{"$f":"IFERROR(INDEX(MedLargeBusinessCounts,_xlfn.ANCHORARRAY( AG2)), \"\")","v":""},{"$f":"IFERROR(INDEX(MedLargeBusinessGrowthRates,_xlfn.ANCHORARRAY( AG2)), \"\")","v":""},null,null,{"$f":"IFERROR(_xlfn.LET(\n_xlpm.nonbusinesscosts_undiscounted, _xlfn.MAKEARRAY(OutputRows,StakeholderCols,_xlfn.LAMBDA(_xlpm.r,_xlpm.c, _xlfn.LET(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\", _xlpm.ThisGroup, IF(_xlpm.c=INDEX(_xlfn.ANCHORARRAY(AG2), _xlpm.r), INDEX(_xlfn.ANCHORARRAY(J2), _xlpm.r), 0),\nIF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"Med/Large Businesses\", 0, IF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"All Businesses\", 0, IF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\" Small Businesses\", 0,\nINDEX(_xlfn.ANCHORARRAY(M2), _xlpm.r)*\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=1, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*INDEX(NonBusinessCounts,_xlpm.c)*(1+INDEX(NonBusinessGrowthRates, _xlpm.c))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=2, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*INDEX(NonBusinessCounts, _xlpm.c)*(1+INDEX(NonBusinessGrowthRates, _xlpm.c))^IF(INDEX(NonBusinessGrowthRates, _xlpm.c)<0, INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r)), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=3, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*INDEX(NonBusinessCounts, _xlpm.c)*((1+MAX(INDEX(NonBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+MAX(INDEX(NonBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r)), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=4, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*IF(INDEX(_xlfn.ANCHORARRAY(F2),_xlpm.r)=0, INDEX(NonBusinessCounts, _xlpm.c)*(1+INDEX(NonBusinessGrowthRates, _xlpm.c))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), INDEX(NonBusinessCounts, _xlpm.c)*(((1+MAX(INDEX(NonBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r))-(1+MAX(INDEX(NonBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1))), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=5, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*IF(INDEX(_xlfn.ANCHORARRAY(F2),_xlpm.r)=0, INDEX(NonBusinessCounts, _xlpm.c)*(1+INDEX(NonBusinessGrowthRates, _xlpm.c))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), 0), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=6, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, 0, INDEX(NonBusinessCounts, _xlpm.c)*(((1+MAX(INDEX(NonBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r))-(1+MAX(INDEX(NonBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1))), AP2),\n0)))))))))))),\n\n_xlpm.smallbusinesscosts_undiscounted, _xlfn.MAKEARRAY(OutputRows,StakeholderCols,_xlfn.LAMBDA(_xlpm.r,_xlpm.c, _xlfn.LET(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\", _xlpm.ThisGroup, IF(_xlpm.c=INDEX(_xlfn.ANCHORARRAY(AG2), _xlpm.r), INDEX(_xlfn.ANCHORARRAY(K2), _xlpm.r), 0),\nIF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"Med/Large Businesses\", 0, IF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"All Non-Businesses\", 0,\nINDEX(_xlfn.ANCHORARRAY(M2), _xlpm.r)*\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=1, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*INDEX(SmallBusinessCounts,_xlpm.c)*(1+INDEX(SmallBusinessGrowthRates, _xlpm.c))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=2, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*INDEX(SmallBusinessCounts, _xlpm.c)*(1+INDEX(SmallBusinessGrowthRates, _xlpm.c))^IF(INDEX(SmallBusinessGrowthRates, _xlpm.c)<0, INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r)), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=3, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*INDEX(SmallBusinessCounts, _xlpm.c)*((1+MAX(INDEX(SmallBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+MAX(INDEX(SmallBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r)), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=4, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*IF(INDEX(_xlfn.ANCHORARRAY(F2),_xlpm.r)=0, INDEX(SmallBusinessCounts, _xlpm.c)*(1+INDEX(SmallBusinessGrowthRates, _xlpm.c))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), INDEX(SmallBusinessCounts, _xlpm.c)*(((1+MAX(INDEX(SmallBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r))-(1+MAX(INDEX(SmallBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1))), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=5, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*IF(INDEX(_xlfn.ANCHORARRAY(F2),_xlpm.r)=0, INDEX(SmallBusinessCounts, _xlpm.c)*(1+INDEX(SmallBusinessGrowthRates, _xlpm.c))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), 0), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=6, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, 0, INDEX(SmallBusinessCounts, _xlpm.c)*(((1+MAX(INDEX(SmallBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r))-(1+MAX(INDEX(SmallBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1))), _xlpm.ThisGroup),\n0))))))))))),\n\n_xlpm.medlargebusinesscosts_undiscounted, _xlfn.MAKEARRAY(OutputRows,StakeholderCols,_xlfn.LAMBDA(_xlpm.r,_xlpm.c, _xlfn.LET(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(H2), _xlpm.r)=\"All Groups\", _xlpm.ThisGroup, IF(_xlpm.c=INDEX(_xlfn.ANCHORARRAY(AG2), _xlpm.r), INDEX(_xlfn.ANCHORARRAY(L2), _xlpm.r), 0),\nIF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"Small Businesses\", 0, IF(INDEX(_xlfn.ANCHORARRAY(AB2), _xlpm.r)=\"All Non-Businesses\", 0,\nINDEX(_xlfn.ANCHORARRAY(M2), _xlpm.r)*\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=1, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*INDEX(MedLargeBusinessCounts,_xlpm.c)*(1+INDEX(MedLargeBusinessGrowthRates, _xlpm.c))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=2, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*INDEX(MedLargeBusinessCounts, _xlpm.c)*(1+INDEX(MedLargeBusinessGrowthRates, _xlpm.c))^IF(INDEX(MedLargeBusinessGrowthRates, _xlpm.c)<0, INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r)), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=3, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*INDEX(MedLargeBusinessCounts, _xlpm.c)*((1+MAX(INDEX(MedLargeBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r)-(1+MAX(INDEX(MedLargeBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AE2), _xlpm.r)), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=4, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*IF(INDEX(_xlfn.ANCHORARRAY(F2),_xlpm.r)=0, INDEX(MedLargeBusinessCounts, _xlpm.c)*(1+INDEX(MedLargeBusinessGrowthRates, _xlpm.c))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), INDEX(MedLargeBusinessCounts, _xlpm.c)*(((1+MAX(INDEX(MedLargeBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r))-(1+MAX(INDEX(MedLargeBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1))), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=5, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*IF(INDEX(_xlfn.ANCHORARRAY(F2),_xlpm.r)=0, INDEX(MedLargeBusinessCounts, _xlpm.c)*(1+INDEX(MedLargeBusinessGrowthRates, _xlpm.c))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r), 0), _xlpm.ThisGroup),\nIF(INDEX(_xlfn.ANCHORARRAY(AC2),_xlpm.r)=6, IF(_xlpm.AllGroups, INDEX(_xlfn.ANCHORARRAY(I2), _xlpm.r)*IF(INDEX(_xlfn.ANCHORARRAY(F2), _xlpm.r)=0, 0, INDEX(MedLargeBusinessCounts, _xlpm.c)*(((1+MAX(INDEX(MedLargeBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r))-(1+MAX(INDEX(MedLargeBusinessGrowthRates, _xlpm.c), 0))^INDEX(_xlfn.ANCHORARRAY(AD2), _xlpm.r-1))), _xlpm.ThisGroup),\n0))))))))))),\n\n_xlpm.x, _xlpm.nonbusinesscosts_undiscounted+_xlpm.smallbusinesscosts_undiscounted+_xlpm.medlargebusinesscosts_undiscounted,\n\n_xlfn.HSTACK(_xlpm.x, _xlpm.x/(1+Discount)^_xlfn.ANCHORARRAY(AF2))), \"\")","v":""},""]

{"sheet":"Controls","index":13,"n_rows":92,"n_cols":116,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
[null,"Stakeholder Drop-down List","Discount Rate Drop-down List","Analytical Timeline Drop-down List","YoR & PV Base Year Drop-down List","Price Year Drop-down List","Activity Start/End Drop-down List","Decimals for Wage Drop-down List","Wage drop-down List",null,null,null,null,null,null,null,null,"Administrative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Activity Number","Activity Description","Administrative/ Compliance","In/Out","Year","Period","Frequency","Affected Group","Percent Affected","Affected Non-businesses Stakeholder Count","Affected Small Businesses Stakeholder Count","Affected Med/Large Businesses Stakeholder Count",{"$f":"\"Cost Per Event (\"&PriceYear&\" CAD)\"","v":"Cost Per Event (2023 CAD)"},"Undiscounted Impacts to Non-Businesses","Undiscounted Impacts to Small Businesses","Undiscounted Impacts to Med/Large Businesses","Undiscounted Impacts to All Businesses","Undiscounted Impacts to All Stakeholders","Discounted Impacts to Non-Businesses","Discounted Impacts to Small Businesses","Discounted Impacts to Med/Large Businesses","Discounted Impacts to All Businesses","Discounted Impacts to All Stakeholders","Discounted Admin Impacts to All Affected Businesses (Fixed at 7%)",null,null,"Start","Affected Type","Activity Type","Exponent","Exponent_P0","Exponent_discounting","Affected Group (Index from Stakeholder Profile)","This Group Starting Non-Business Count","This Group Non-Business Growth Rate","This Group Starting Small Business Count","This Group Small Business Growth Rate","This Group Starting Med/Large Business Count","This Group  Med/Large Business Growth Rate",null,{"$f":"\"{undiscounted, discounted}:\"","v":"{undiscounted, discounted}:"},"Stakeholder 1, Undiscounted Impacts","Stakeholder 1, Discounted Impacts"]
[null,{"$f":"IFERROR(_xlfn.VSTACK(_xlfn.UNIQUE(_xlfn._xlws.FILTER(tbl_Stakeholders[Stakeholder Group], tbl_Stakeholders[Stakeholder Group]<>\"\")), \"All Groups\"), \"\")","v":""},{"$f":"_xlfn.SEQUENCE(11, , 0, 1%)","v":0},{"$f":"_xlfn.SEQUENCE(91, , 10, 1)","v":10},{"$f":"_xlfn.SEQUENCE(2050-2012+1, , 2012)","v":2012},{"$f":"_xlfn._xlws.SORT(tbl_CPI[Year], , -1)","v":2023},{"$f":"_xlfn.VSTACK(\"Start of Analytical Period\", \"End of Analytical Period\", _xlfn.SEQUENCE(Timeperiod, , YearOfRegistration))","v":"Start of Analytical Period"},2,{"$f":"tbl_Wages[National Occupational Classification (NOC)]& IFERROR(\" (\"&DOLLAR(tbl_Wages[Wage in price year of analysis (without overhead)], H2)&\")\", \" (custom wage not added yet)\")","v":"01 Canada average ($33.32)"},null,null,null,null,"Name","Value","Explanation",null,{"$f":"IF(OneForOneLanding=0,R5,R4)","v":"The one-for-one rule does not apply as there is no impact on business."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"repeat(Periods, ActivityNumber)","IFERROR(INDEX(tbl_Activities[Activity], A2#), \"\")","IFERROR(INDEX(tbl_Activities[Administrative or Compliance], A2#), \"\")","IFERROR(INDEX(tbl_Activities[In or Out], A2#), \"\")","IFERROR(\nIF(AA2#=\"Start of Analytical Period\", YearOfRegistration,\nIF(AA2#=\"End of Analytical Period\", YearOfRegistration+Timeperiod-1,\nAA2#))\n\n+ROUNDUP(IF(F2#/G2#-1<0, 0, F2#/G2#-1), 0), \"\")","IFERROR(\nLET(\na, FILTER(Periods, Checkblank),\nb, SEQUENCE(COUNTA(FILTER(Periods, Checkblank))),\nc, TRANSPOSE(b),\nd, --(b>=c),\ne, MMULT(d, a),\nf, SUM(a),\ng, SEQUENCE(f),\nh, XMATCH(g-1, e,-1),\nI, IFERROR(INDEX(e,h),0),\nj, g - I,\nj)-IF(INDEX(tbl_Activities[Upfront or  Ongoing], A2#)=\"Upfront\", 1, 0),\n\"\")","IFERROR(IF(INDEX(tbl_Activities[Upfront or  Ongoing], A2#)=\"Ongoing\", INDEX(tbl_Activities[Annual Frequency], A2#), 1), \"\")","IFERROR(INDEX(tbl_Activities[Affected Stakeholder Group], A2#), \"\")","IFERROR(INDEX(tbl_Activities[Percent Affected], A2#), \"\")","MAKEARRAY(OutputRows, 1, LAMBDA(r,c,\n\nIFERROR(IF(INDEX(AB2#, r)=\"All Businesses\", 0, IF(INDEX(AB2#, r)=\"Med/Large Businesses\", 0, IF(INDEX(AB2#, r)=\"Small Businesses\", 0,\n\nINDEX(TAKE(DROP(I:I,MATCH($I$1,I:I,0)),XMATCH(,DROP(I:I,MATCH($I$1,I:I,0)))-1), r)*\n\nIF(AND(INDEX(AC2#, r)=1, INDEX(H2#, r)=\"All Groups\"), SUMPRODUCT(NonBusinessCounts, (1+NonBusinessGrowthRates)^INDEX(AD2#, r)),\nIF(AND(INDEX(AC2#, r)=1, NOT(INDEX(H2#, r)=\"All Groups\")), INDEX(AH2#, r)*(1+INDEX(AI2#, r))^INDEX(AD2#, r),\n\nIF(AND(INDEX(AC2#, r)=2, INDEX(H2#, r)=\"All Groups\"), SUMPRODUCT(NonBusinessCounts, (1+NonBusinessGrowthRates)^IF(NonBusinessGrowthRates<0, INDEX(AD2#, r), INDEX(AE2#, r))),\nIF(AND(INDEX(AC2#, r)=2, NOT(INDEX(H2#, r)=\"All Groups\")), INDEX(AH2#, r)*(1+INDEX(AI2#, r))^IF(INDEX(AI2#, r)<0, INDEX(AD2#, r), INDEX(AE2#, r)),\n\nIF(AND(INDEX(AC2#, r)=3, INDEX(H2#, r)=\"All Groups\"), SUMPRODUCT(NonBusinessCounts, (1+IF(NonBusinessGrowthRates<0, 0, NonBusinessGrowthRates))^INDEX(AD2#, r)-(1+IF(NonBusinessGrowthRates<0, 0, NonBusinessGrowthRates))^INDEX(AE2#, r)),\nIF(AND(INDEX(AC2#, r)=3, NOT(INDEX(H2#, r)=\"All Groups\")), IF(INDEX(AI2#, r)<0, 0, INDEX(AH2#, r)*((1+INDEX(AI2#, r))^INDEX(AD2#, r)-(1+INDEX(AI2#, r))^INDEX(AE2#, r))),\n\nIF(AND(INDEX(AC2#, r)=4, INDEX(H2#, r)=\"All Groups\"), IF(INDEX(F2#, r)=0, SUMPRODUCT(NonBusinessCounts, (1+NonBusinessGrowthRates)^INDEX(AD2#, r)), LET(g, (1+IF(NonBusinessGrowthRates<0, 0, NonBusinessGrowthRates)), SUMPRODUCT(NonBusinessCounts, g^INDEX(AD2#, r)-g^(INDEX(AD2#, r-1))))),\nIF(AND(INDEX(AC2#, r)=4, NOT(INDEX(H2#, r)=\"All Groups\")), IF(INDEX(F2#, r)=0, INDEX(AH2#, r)*(1+INDEX(AI2#, r))^INDEX(AD2#, r), IF(INDEX(AI2#, r)<0, 0, INDEX(AH2#, r)*((1+INDEX(AI2#, r))^INDEX(AD2#, r)-(1+INDEX(AI2#, r))^INDEX(AD2#, r-1)))),\n\nIF(AND(INDEX(AC2#, r)=5, INDEX(H2#, r)=\"All Groups\"), IF(INDEX(F2#, r)>0, 0, SUMPRODUCT(NonBusinessCounts, (1+NonBusinessGrowthRates)^INDEX(AD2#, r))),\nIF(AND(INDEX(AC2#, r)=5, NOT(INDEX(H2#, r)=\"All Groups\")), IF(INDEX(F2#, r)>0, 0, INDEX(AH2#, r)*(1+INDEX(AI2#, r))^INDEX(AD2#, r)),\n\nIF(AND(INDEX(AC2#, r)=6, INDEX(H2#, r)=\"All Groups\"), IF(INDEX(F2#, r)=0, 0, LET(g, (1+IF(NonBusinessGrowthRates<0, 0, NonBusinessGrowthRates)), SUMPRODUCT(NonBusinessCounts, g^INDEX(AD2#, r)-g^(INDEX(AD2#, r-1))))),\nIF(AND(INDEX(AC2#, r)=6, NOT(INDEX(H2#, r)=\"All Groups\")), IF(INDEX(F2#, r)=0, 0, IF(INDEX(AI2#, r)<0, 0, INDEX(AH2#, r)*((1+INDEX(AI2#, r))^INDEX(AD2#, r)-(1+INDEX(AI2#, r))^INDEX(AD2#, r-1)))),\n\n0))))))))))))))), 0)))","MAKEARRAY(OutputRows, 1, LAMBDA(r,c,\n\nIFERROR(IF(INDEX(AB2#, r)=\"Med/Large Businesses\", 0, IF(INDEX(AB2#, r)=\"All Non-Businesses\", 0,\n\nINDEX(TAKE(DROP(I:I,MATCH($I$1,I:I,0)),XMATCH(,DROP(I:I,MATCH($I$1,I:I,0)))-1), r)*\n\nIF(AND(INDEX(AC2#, r)=1, INDEX(H2#, r)=\"All Groups\"), SUMPRODUCT(SmallBusinessCounts, (1+SmallBusinessGrowthRates)^INDEX(AD2#, r)),\nIF(AND(INDEX(AC2#, r)=1, NOT(INDEX(H2#, r)=\"All Groups\")), INDEX(AJ2#, r)*(1+INDEX(AK2#, r))^INDEX(AD2#, r),\n\nIF(AND(INDEX(AC2#, r)=2, INDEX(H2#, r)=\"All Groups\"), SUMPRODUCT(SmallBusinessCounts, (1+SmallBusinessGrowthRates)^IF(SmallBusinessGrowthRates<0, INDEX(AD2#, r), INDEX(AE2#, r))),\nIF(AND(INDEX(AC2#, r)=2, NOT(INDEX(H2#, r)=\"All Groups\")), INDEX(AJ2#, r)*(1+INDEX(AK2#, r))^IF(INDEX(AK2#, r)<0, INDEX(AD2#, r), INDEX(AE2#, r)),\n\nIF(AND(INDEX(AC2#, r)=3, INDEX(H2#, r)=\"All Groups\"), SUMPRODUCT(SmallBusinessCounts, (1+IF(SmallBusinessGrowthRates<0, 0, SmallBusinessGrowthRates))^INDEX(AD2#, r)-(1+IF(SmallBusinessGrowthRates<0, 0, SmallBusinessGrowthRates))^INDEX(AE2#, r)),\nIF(AND(INDEX(AC2#, r)=3, NOT(INDEX(H2#, r)=\"All Groups\")), IF(INDEX(AK2#, r)<0, 0, INDEX(AJ2#, r)*((1+INDEX(AK2#, r))^INDEX(AD2#, r)-(1+INDEX(AK2#, r))^INDEX(AE2#, r))),\n\nIF(AND(INDEX(AC2#, r)=4, INDEX(H2#, r)=\"All Groups\"), IF(INDEX(F2#, r)=0, SUMPRODUCT(SmallBusinessCounts, (1+SmallBusinessGrowthRates)^INDEX(AD2#, r)), LET(g, (1+IF(SmallBusinessGrowthRates<0, 0, SmallBusinessGrowthRates)), SUMPRODUCT(SmallBusinessCounts, g^INDEX(AD2#, r)-g^(INDEX(AD2#, r-1))))),\nIF(AND(INDEX(AC2#, r)=4, NOT(INDEX(H2#, r)=\"All Groups\")), IF(INDEX(F2#, r)=0, INDEX(AJ2#, r)*(1+INDEX(AK2#, r))^INDEX(AD2#, r), IF(INDEX(AK2#, r)<0, 0, INDEX(AJ2#, r)*((1+INDEX(AK2#, r))^INDEX(AD2#, r)-(1+INDEX(AK2#, r))^INDEX(AD2#, r-1)))),\n\nIF(AND(INDEX(AC2#, r)=5, INDEX(H2#, r)=\"All Groups\"), IF(INDEX(F2#, r)>0, 0, SUMPRODUCT(SmallBusinessCounts, (1+SmallBusinessGrowthRates)^INDEX(AD2#, r))),\nIF(AND(INDEX(AC2#, r)=5, NOT(INDEX(H2#, r)=\"All Groups\")), IF(INDEX(F2#, r)>0, 0, INDEX(AJ2#, r)*(1+INDEX(AK2#, r))^INDEX(AD2#, r)),\n\nIF(AND(INDEX(AC2#, r)=6, INDEX(H2#, r)=\"All Groups\"), IF(INDEX(F2#, r)=0, 0, LET(g, (1+IF(SmallBusinessGrowthRates<0, 0, SmallBusinessGrowthRates)), SUMPRODUCT(SmallBusinessCounts, g^INDEX(AD2#, r)-g^(INDEX(AD2#, r-1))))),\nIF(AND(INDEX(AC2#, r)=6, NOT(INDEX(H2#, r)=\"All Groups\")), IF(INDEX(F2#, r)=0, 0, IF(INDEX(AK2#, r)<0, 0, INDEX(AJ2#, r)*((1+INDEX(AK2#, r))^INDEX(AD2#, r)-(1+INDEX(AK2#, r))^INDEX(AD2#, r-1)))),\n\n0)))))))))))))), 0)))","MAKEARRAY(OutputRows, 1, LAMBDA(r,c,\n\nIFERROR(IF(INDEX(AB2#, r)=\"Small Businesses\", 0, IF(INDEX(AB2#, r)=\"All Non-Businesses\", 0,\n\nINDEX(TAKE(DROP(I:I,MATCH($I$1,I:I,0)),XMATCH(,DROP(I:I,MATCH($I$1,I:I,0)))-1), r)*\n\nIF(AND(INDEX(AC2#, r)=1, INDEX(H2#, r)=\"All Groups\"), SUMPRODUCT(MedLargeBusinessCounts, (1+MedLargeBusinessGrowthRates)^INDEX(AD2#, r)),\nIF(AND(INDEX(AC2#, r)=1, NOT(INDEX(H2#, r)=\"All Groups\")), INDEX(AL2#, r)*(1+INDEX(AM2#, r))^INDEX(AD2#, r),\n\nIF(AND(INDEX(AC2#, r)=2, INDEX(H2#, r)=\"All Groups\"), SUMPRODUCT(MedLargeBusinessCounts, (1+MedLargeBusinessGrowthRates)^IF(MedLargeBusinessGrowthRates<0, INDEX(AD2#, r), INDEX(AE2#, r))),\nIF(AND(INDEX(AC2#, r)=2, NOT(INDEX(H2#, r)=\"All Groups\")), INDEX(AL2#, r)*(1+INDEX(AM2#, r))^IF(INDEX(AM2#, r)<0, INDEX(AD2#, r), INDEX(AE2#, r)),\n\nIF(AND(INDEX(AC2#, r)=3, INDEX(H2#, r)=\"All Groups\"), SUMPRODUCT(MedLargeBusinessCounts, (1+IF(MedLargeBusinessGrowthRates<0, 0, MedLargeBusinessGrowthRates))^INDEX(AD2#, r)-(1+IF(MedLargeBusinessGrowthRates<0, 0, MedLargeBusinessGrowthRates))^INDEX(AE2#, r)),\nIF(AND(INDEX(AC2#, r)=3, NOT(INDEX(H2#, r)=\"All Groups\")), IF(INDEX(AM2#, r)<0, 0, INDEX(AL2#, r)*((1+INDEX(AM2#, r))^INDEX(AD2#, r)-(1+INDEX(AM2#, r))^INDEX(AE2#, r))),\n\nIF(AND(INDEX(AC2#, r)=4, INDEX(H2#, r)=\"All Groups\"), IF(INDEX(F2#, r)=0, SUMPRODUCT(MedLargeBusinessCounts, (1+MedLargeBusinessGrowthRates)^INDEX(AD2#, r)), LET(g, (1+IF(MedLargeBusinessGrowthRates<0, 0, MedLargeBusinessGrowthRates)), SUMPRODUCT(MedLargeBusinessCounts, g^INDEX(AD2#, r)-g^(INDEX(AD2#, r-1))))),\nIF(AND(INDEX(AC2#, r)=4, NOT(INDEX(H2#, r)=\"All Groups\")), IF(INDEX(F2#, r)=0, INDEX(AL2#, r)*(1+INDEX(AM2#, r))^INDEX(AD2#, r), IF(INDEX(AM2#, r)<0, 0, INDEX(AL2#, r)*((1+INDEX(AM2#, r))^INDEX(AD2#, r)-(1+INDEX(AM2#, r))^INDEX(AD2#, r-1)))),\n\nIF(AND(INDEX(AC2#, r)=5, INDEX(H2#, r)=\"All Groups\"), IF(INDEX(F2#, r)>0, 0, SUMPRODUCT(MedLargeBusinessCounts, (1+MedLargeBusinessGrowthRates)^INDEX(AD2#, r))),\nIF(AND(INDEX(AC2#, r)=5, NOT(INDEX(H2#, r)=\"All Groups\")), IF(INDEX(F2#, r)>0, 0, INDEX(AL2#, r)*(1+INDEX(AM2#, r))^INDEX(AD2#, r)),\n\nIF(AND(INDEX(AC2#, r)=6, INDEX(H2#, r)=\"All Groups\"), IF(INDEX(F2#, r)=0, 0, LET(g, (1+IF(MedLargeBusinessGrowthRates<0, 0, MedLargeBusinessGrowthRates)), SUMPRODUCT(MedLargeBusinessCounts, g^INDEX(AD2#, r)-g^(INDEX(AD2#, r-1))))),\nIF(AND(INDEX(AC2#, r)=6, NOT(INDEX(H2#, r)=\"All Groups\")), IF(INDEX(F2#, r)=0, 0, IF(INDEX(AM2#, r)<0, 0, INDEX(AL2#, r)*((1+INDEX(AM2#, r))^INDEX(AD2#, r)-(1+INDEX(AM2#, r))^INDEX(AD2#, r-1)))),\n\n0)))))))))))))), 0)))","IFERROR(\nLET(\n     InternalExternal, INDEX(tbl_Activities[Labour: Internal or External Overhead], A2#),\n     CapitalLabour, INDEX(tbl_Activities[Capital or Labour], A2#),\n\nIF(D2#=\"Out\", -1, 1)*\n\nIF(CapitalLabour=\"Capital\", INDEX(tbl_Activities[Capital: Number of Units], A2#)*INDEX(tbl_Activities[Capital: Unit Price], A2#)\n     *INDEX(tbl_CPI[Index], MATCH(PriceYear, tbl_CPI[Year], 0))/INDEX(tbl_CPI[Index], MATCH(INDEX(tbl_Activities[Capital: Price Year of Unit Price], A2#), tbl_CPI[Year], 0)),\n\nIF(CapitalLabour=\"Labour\", INDEX(tbl_Wages[Wage in price year of analysis (without overhead)], MATCH(INDEX(TEXTBEFORE(tbl_Activities[Labour: Staff Level (Wage Without Overhead)], \" ($\"), A2#), tbl_Wages[National Occupational Classification (NOC)], 0))\n          *(1+IF(InternalExternal=\"Internal (25%)\", 0.25, IF(InternalExternal=\"External (50%)\", 0.5, 0)))\n          *(INDEX(tbl_Activities[Labour: Time Spent (hours)], A2#)),\n\n\"\"))),\n\"\")","LET(\n     AffectedNonBusinesses, TAKE(DROP(J:J,MATCH(J$1,J:J,0)),XMATCH(,DROP(J:J,MATCH(J$1,J:J,0)))-1),\nIFERROR(M2#*AffectedNonBusinesses, \"\"))","LET(\n     AffectedSmallBusinesses, TAKE(DROP(K:K,MATCH(K$1,K:K,0)),XMATCH(,DROP(K:K,MATCH(K$1,K:K,0)))-1),\nIFERROR(M2#*AffectedSmallBusinesses, \"\"))","LET(\n     AffectedMedLargeBusinesses, TAKE(DROP(L:L,MATCH(L$1,L:L,0)),XMATCH(,DROP(L:L,MATCH(L$1,L:L,0)))-1),\nIFERROR(M2#*AffectedMedLargeBusinesses, \"\"))","IFERROR($O$2#+$P$2#,0)","IFERROR($Q$2#+$N$2#, 0)","IFERROR($N$2#/(1+Discount)^$AF$2#,0)","IFERROR($O$2#/(1+Discount)^$AF$2#,0)","IFERROR(P2#/(1+Discount)^$AF$2#,0)","IFERROR($T$2#+$U$2#, 0)","IFERROR($V$2#+$S$2#, 0)","IFERROR(--($C$2#=\"Administrative\")*($O$2#+$P$2#)/(1.07)^$AF$2#, 0)",null,null,"INDEX(tbl_Activities[Start Year], $A$2#)","INDEX(tbl_Activities[Affected Stakeholder Type], A2#)","INDEX(ActivityType, A2#)","IFERROR(\nIF(AA2#=\"Start of Analytical Period\", F2#/G2#,\nIF(AA2#=\"End of Analytical Period\",Timeperiod-1+F2#/G2#,\nAA2#-YearOfRegistration+F2#/G2#)),\n\"\")","IFERROR(\nIF(AA2#=\"Start of Analytical Period\", 0,\nIF(AA2#=\"End of Analytical Period\", Timeperiod-1,\nAA2#-YearOfRegistration)),\n\"\")","IFERROR(\nIF(AA2#=\"Start of Analytical Period\", (YearOfRegistration-PVBaseYear)+$F$2#/$G$2#,\nIF(AA2#=\"End of Analytical Period\", (YearOfRegistration-PVBaseYear)+Timeperiod-1+$F$2#/$G$2#,\nAA2#-PVBaseYear+$F$2#/$G$2#)),\n\"\")","IFERROR(MATCH(INDEX(tbl_Activities[Affected Stakeholder Group], 'Full Output'!$A$2#), FILTER(tbl_Stakeholders[Stakeholder Group], tbl_Stakeholders[Stakeholder Group]<>\"\"), 0), \"\")","IFERROR(INDEX(NonBusinessCounts, AG2#), \"\")","IFERROR(INDEX(NonBusinessGrowthRates, AG2#), \"\")","IFERROR(INDEX(SmallBusinessCounts, AG2#), \"\")","IFERROR(INDEX(SmallBusinessGrowthRates, AG2#), \"\")","IFERROR(INDEX(MedLargeBusinessCounts, AG2#), \"\")","IFERROR(INDEX(MedLargeBusinessGrowthRates, AG2#), \"\")",null,null,"IFERROR(LET(\nnonbusinesscosts_undiscounted, MAKEARRAY(OutputRows,StakeholderCols,LAMBDA(r,c, LET(AllGroups, INDEX(H2#, r)=\"All Groups\", ThisGroup, IF(c=INDEX(AG2#, r), INDEX(J2#, r), 0),\nIF(INDEX(AB2#, r)=\"Med/Large Businesses\", 0, IF(INDEX(AB2#, r)=\"All Businesses\", 0, IF(INDEX(AB2#, r)=\" Small Businesses\", 0,\nINDEX(M2#, r)*\nIF(INDEX(AC2#,r)=1, IF(AllGroups, INDEX(I2#, r)*INDEX(NonBusinessCounts,c)*(1+INDEX(NonBusinessGrowthRates, c))^INDEX(AD2#, r), ThisGroup),\nIF(INDEX(AC2#,r)=2, IF(AllGroups, INDEX(I2#, r)*INDEX(NonBusinessCounts, c)*(1+INDEX(NonBusinessGrowthRates, c))^IF(INDEX(NonBusinessGrowthRates, c)<0, INDEX(AD2#, r), INDEX(AE2#, r)), ThisGroup),\nIF(INDEX(AC2#,r)=3, IF(AllGroups, INDEX(I2#, r)*INDEX(NonBusinessCounts, c)*((1+MAX(INDEX(NonBusinessGrowthRates, c), 0))^INDEX(AD2#, r)-(1+MAX(INDEX(NonBusinessGrowthRates, c), 0))^INDEX(AE2#, r)), ThisGroup),\nIF(INDEX(AC2#,r)=4, IF(AllGroups, INDEX(I2#, r)*IF(INDEX(F2#,r)=0, INDEX(NonBusinessCounts, c)*(1+INDEX(NonBusinessGrowthRates, c))^INDEX(AD2#, r), INDEX(NonBusinessCounts, c)*(((1+MAX(INDEX(NonBusinessGrowthRates, c), 0))^INDEX(AD2#, r))-(1+MAX(INDEX(NonBusinessGrowthRates, c), 0))^INDEX(AD2#, r-1))), ThisGroup),\nIF(INDEX(AC2#,r)=5, IF(AllGroups, INDEX(I2#, r)*IF(INDEX(F2#,r)=0, INDEX(NonBusinessCounts, c)*(1+INDEX(NonBusinessGrowthRates, c))^INDEX(AD2#, r), 0), ThisGroup),\nIF(INDEX(AC2#,r)=6, IF(AllGroups, INDEX(I2#, r)*IF(INDEX(F2#, r)=0, 0, INDEX(NonBusinessCounts, c)*(((1+MAX(INDEX(NonBusinessGrowthRates, c), 0))^INDEX(AD2#, r))-(1+MAX(INDEX(NonBusinessGrowthRates, c), 0))^INDEX(AD2#, r-1))), AP2),\n0)))))))))))),\n\nsmallbusinesscosts_undiscounted, MAKEARRAY(OutputRows,StakeholderCols,LAMBDA(r,c, LET(AllGroups, INDEX(H2#, r)=\"All Groups\", ThisGroup, IF(c=INDEX(AG2#, r), INDEX(K2#, r), 0),\nIF(INDEX(AB2#, r)=\"Med/Large Businesses\", 0, IF(INDEX(AB2#, r)=\"All Non-Businesses\", 0,\nINDEX(M2#, r)*\nIF(INDEX(AC2#,r)=1, IF(AllGroups, INDEX(I2#, r)*INDEX(SmallBusinessCounts,c)*(1+INDEX(SmallBusinessGrowthRates, c))^INDEX(AD2#, r), ThisGroup),\nIF(INDEX(AC2#,r)=2, IF(AllGroups, INDEX(I2#, r)*INDEX(SmallBusinessCounts, c)*(1+INDEX(SmallBusinessGrowthRates, c))^IF(INDEX(SmallBusinessGrowthRates, c)<0, INDEX(AD2#, r), INDEX(AE2#, r)), ThisGroup),\nIF(INDEX(AC2#,r)=3, IF(AllGroups, INDEX(I2#, r)*INDEX(SmallBusinessCounts, c)*((1+MAX(INDEX(SmallBusinessGrowthRates, c), 0))^INDEX(AD2#, r)-(1+MAX(INDEX(SmallBusinessGrowthRates, c), 0))^INDEX(AE2#, r)), ThisGroup),\nIF(INDEX(AC2#,r)=4, IF(AllGroups, INDEX(I2#, r)*IF(INDEX(F2#,r)=0, INDEX(SmallBusinessCounts, c)*(1+INDEX(SmallBusinessGrowthRates, c))^INDEX(AD2#, r), INDEX(SmallBusinessCounts, c)*(((1+MAX(INDEX(SmallBusinessGrowthRates, c), 0))^INDEX(AD2#, r))-(1+MAX(INDEX(SmallBusinessGrowthRates, c), 0))^INDEX(AD2#, r-1))), ThisGroup),\nIF(INDEX(AC2#,r)=5, IF(AllGroups, INDEX(I2#, r)*IF(INDEX(F2#,r)=0, INDEX(SmallBusinessCounts, c)*(1+INDEX(SmallBusinessGrowthRates, c))^INDEX(AD2#, r), 0), ThisGroup),\nIF(INDEX(AC2#,r)=6, IF(AllGroups, INDEX(I2#, r)*IF(INDEX(F2#, r)=0, 0, INDEX(SmallBusinessCounts, c)*(((1+MAX(INDEX(SmallBusinessGrowthRates, c), 0))^INDEX(AD2#, r))-(1+MAX(INDEX(SmallBusinessGrowthRates, c), 0))^INDEX(AD2#, r-1))), ThisGroup),\n0))))))))))),\n\nmedlargebusinesscosts_undiscounted, MAKEARRAY(OutputRows,StakeholderCols,LAMBDA(r,c, LET(AllGroups, INDEX(H2#, r)=\"All Groups\", ThisGroup, IF(c=INDEX(AG2#, r), INDEX(L2#, r), 0),\nIF(INDEX(AB2#, r)=\"Small Businesses\", 0, IF(INDEX(AB2#, r)=\"All Non-Businesses\", 0,\nINDEX(M2#, r)*\nIF(INDEX(AC2#,r)=1, IF(AllGroups, INDEX(I2#, r)*INDEX(MedLargeBusinessCounts,c)*(1+INDEX(MedLargeBusinessGrowthRates, c))^INDEX(AD2#, r), ThisGroup),\nIF(INDEX(AC2#,r)=2, IF(AllGroups, INDEX(I2#, r)*INDEX(MedLargeBusinessCounts, c)*(1+INDEX(MedLargeBusinessGrowthRates, c))^IF(INDEX(MedLargeBusinessGrowthRates, c)<0, INDEX(AD2#, r), INDEX(AE2#, r)), ThisGroup),\nIF(INDEX(AC2#,r)=3, IF(AllGroups, INDEX(I2#, r)*INDEX(MedLargeBusinessCounts, c)*((1+MAX(INDEX(MedLargeBusinessGrowthRates, c), 0))^INDEX(AD2#, r)-(1+MAX(INDEX(MedLargeBusinessGrowthRates, c), 0))^INDEX(AE2#, r)), ThisGroup),\nIF(INDEX(AC2#,r)=4, IF(AllGroups, INDEX(I2#, r)*IF(INDEX(F2#,r)=0, INDEX(MedLargeBusinessCounts, c)*(1+INDEX(MedLargeBusinessGrowthRates, c))^INDEX(AD2#, r), INDEX(MedLargeBusinessCounts, c)*(((1+MAX(INDEX(MedLargeBusinessGrowthRates, c), 0))^INDEX(AD2#, r))-(1+MAX(INDEX(MedLargeBusinessGrowthRates, c), 0))^INDEX(AD2#, r-1))), ThisGroup),\nIF(INDEX(AC2#,r)=5, IF(AllGroups, INDEX(I2#, r)*IF(INDEX(F2#,r)=0, INDEX(MedLargeBusinessCounts, c)*(1+INDEX(MedLargeBusinessGrowthRates, c))^INDEX(AD2#, r), 0), ThisGroup),\nIF(INDEX(AC2#,r)=6, IF(AllGroups, INDEX(I2#, r)*IF(INDEX(F2#, r)=0, 0, INDEX(MedLargeBusinessCounts, c)*(((1+MAX(INDEX(MedLargeBusinessGrowthRates, c), 0))^INDEX(AD2#, r))-(1+MAX(INDEX(MedLargeBusinessGrowthRates, c), 0))^INDEX(AD2#, r-1))), ThisGroup),\n0))))))))))),\n\nx, nonbusinesscosts_undiscounted+smallbusinesscosts_undiscounted+medlargebusinesscosts_undiscounted,\n\nHSTACK(x, x/(1+Discount)^AF2#)), \"\")"]
[null,null,0.01,11,2013,2022,"End of Analytical Period",null,"02 Management occupations ($54.36)",null,null,null,null,"AF_7_10",{"$f":"0.07/(1-(1.07)^(-10))","v":0.14237750272736471},"Annualization factor locked at the parameters needed for one-for-one section",null,null,null,null,null,"Individual Break Down"]
[null,null,0.02,12,2014,2021,2024,null,"03 Senior management occupations ($63.82)",null,null,null,null,"AF",{"$f":"Discount/(1-(1+Discount)^(-Timeperiod))","v":0.14237750272736471},"Annualization factor that adjusts with discount rate and analytical period length",null,{"$f":"_xlfn.CONCAT(R12, R13)","v":"The one for one rule does not apply as the changes in adminitrative burden on business offset each other, and no regulatory titles are repealed or introduced. The amendments would result in an annualized administrative total cost savings of $0. \nAs per the Red Tape Reduction Regulations, the assessment of administrative impacts was conducted for a period of ten years commencing from registration. All values listed in this section are presented in 2012 dollars, discounted to 2012 at a rate of 7%.\nThe amendments related to Activity Name Not Enteredrepresent an annualized total  of $0. \n"},null,null,null,"Activity Number","Activity Name","IN / OUT","Labour / Capital","Frequency","Capital Units","Capital Unit Price ($2012)","Labour Hours","Labour Wage with overhead in $2012","Annual Labour Hours","Annual Labour Cost ($2012)","Total Annual Capital Units","Total Annual Capital Cost ($2012)","Annualized Impact, in $2012, discounted to 2012","Max Businesses",null,null,"Activity Roll Up","Annualized Labour IN","Annualized Labour OUT","Annualized Capital In","Annualized Capital Out","Net or Total","Business Labour IN","Businesses Labour OUT","Businesses Capital In","Businesses Capital Out","Average Time IN","Average Time OUT","UNIT Capital IN","UNIT Capital Out","Frequency Labour IN","Frequency Labour OUT","Frequency Capital In","Frequency Capital Out","Average Wage In","Average Wage Out","Average Capital Unit Cost In","Weighted Capital Unit Cost OUT","General Text",null,null,null,null,{"$f":"_xlfn.CONCAT(BN5:BN88)","v":"The amendments related to Activity Name Not Enteredrepresent an annualized total  of $0. \n"}]
[null,null,0.03,13,2015,2020,2025,null,"04 Specialized middle management occupations ($58.78)",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(tbl_Stakeholders[Small Business Count])+SUM(tbl_Stakeholders[Med/Large Business Count])=0,Controls!R7,IF(AND(Controls!S36=0,'Initiative Details'!D9=0,'Initiative Details'!D10=0),Controls!R8,IF(AND(Controls!S36=0,'Initiative Details'!D9='Initiative Details'!D10),Controls!R9,R10)))","v":"The one-for-one rule does not apply as there is no impact on business."},null,null,null,{"$f":"IFERROR(_xlfn._xlws.FILTER(ActivityNumber,tbl_Activities[Administrative or Compliance]=\"Administrative\"),\"\")","v":""},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($V5),ActivityNumber,tbl_Activities[Activity],\"Activity Name Not Entered\",0,1)","v":"Activity Name Not Entered"},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($V5),ActivityNumber,tbl_Activities[In or Out],0,1)","v":0},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($V5),ActivityNumber,tbl_Activities[Capital or Labour],\"Activity Name Not Entered\",0,1)","v":"Activity Name Not Entered"},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($V5),ActivityNumber,tbl_Activities[Annual Frequency],\"Activity Name Not Entered\",0,1)","v":"Activity Name Not Entered"},{"$f":"IF(_xlfn.ANCHORARRAY($Y5)=\"Labour\", 0, _xlfn.XLOOKUP(_xlfn.ANCHORARRAY($V5),ActivityNumber,tbl_Activities[Capital: Number of Units],\"Activity Name Not Entered\",0,1))","v":"Activity Name Not Entered"},{"$f":"IFERROR(IF(_xlfn.ANCHORARRAY($Y5)=\"Labour\", 0, _xlfn.XLOOKUP(_xlfn.ANCHORARRAY($V5),ActivityNumber,tbl_Activities[Capital: Unit Price],\"Activity Name Not Entered\",0,1)) * _xlfn.LET(_xlpm.CapPriceYear,_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($V5),ActivityNumber,tbl_Activities[Capital: Price Year of Unit Price],\"2012\",0,1),CPI!$D$25/_xlfn.XLOOKUP(_xlpm.CapPriceYear,tbl_CPI[Year],tbl_CPI[Index])),0)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(Y5)=\"Labour\",_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($V5),ActivityNumber,tbl_Activities[Labour: Time Spent (hours)],0,1),0)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(Y5)=\"Labour\",_xlfn.LET(_xlpm.IntExt,_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($V5),ActivityNumber,tbl_Activities[Labour: Internal or External Overhead],0,1),IF(_xlpm.IntExt=\"Internal (25%)\",1.25,1.5)) *\n_xlfn.LET(_xlpm.WageClass,_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($V5),ActivityNumber,tbl_Activities[Labour: Staff Level (Wage Without Overhead)],0,1),_xlfn.XLOOKUP(_xlpm.WageClass,tbl_Wages[National Occupational Classification (NOC)],tbl_Wages[Wage in price year of analysis (without overhead)],\"No\",-1,1))*\nOneforOne_CPI_Conversion,0)","v":0},{"$f":"IFERROR(_xlfn.ANCHORARRAY(Z5)*_xlfn.ANCHORARRAY(AC5),\"\")","v":""},{"$f":"IFERROR(_xlfn.ANCHORARRAY(AE5)*_xlfn.ANCHORARRAY(AD5),\"\")","v":""},{"$f":"IFERROR(_xlfn.ANCHORARRAY(Z5)*_xlfn.ANCHORARRAY(AA5),\"\")","v":""},{"$f":"IFERROR(_xlfn.ANCHORARRAY(AG5)*_xlfn.ANCHORARRAY(AB5),\"\")","v":""},{"$f":"(((SUMIFS(_xlfn.ANCHORARRAY('Full Output'!$X2),_xlfn.ANCHORARRAY('Full Output'!$A2),_xlfn.ANCHORARRAY($V5),_xlfn.ANCHORARRAY('Full Output'!$E2),\"<\"&YearOfRegistration+\"10\")*OneforOne_CPI_Conversion)*1.07^-Years_since_2012)*0.07)/(1-(1+'One-for-one'!$C$9)^-10)","v":0},{"$f":"_xlfn.MAXIFS(_xlfn.ANCHORARRAY('Full Output'!$K2),_xlfn.ANCHORARRAY('Full Output'!$A2),_xlfn.ANCHORARRAY($V5))+_xlfn.MAXIFS(_xlfn.ANCHORARRAY('Full Output'!$L2),_xlfn.ANCHORARRAY('Full Output'!$A2),_xlfn.ANCHORARRAY($V5))","v":0},null,null,{"$f":"_xlfn.UNIQUE(_xlfn.ANCHORARRAY(W5))","v":"Activity Name Not Entered"},{"$f":"SUMIFS(_xlfn.ANCHORARRAY($AI5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($Y5),\"Labour\",_xlfn.ANCHORARRAY($X5),\"In\")","v":0},{"$f":"SUMIFS(_xlfn.ANCHORARRAY($AI5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($Y5),\"Labour\",_xlfn.ANCHORARRAY($X5),\"Out\")","v":0},{"$f":"SUMIFS(_xlfn.ANCHORARRAY($AI5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($Y5),\"Capital\",_xlfn.ANCHORARRAY($X5),\"In\")","v":0},{"$f":"SUMIFS(_xlfn.ANCHORARRAY($AI5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($Y5),\"Capital\",_xlfn.ANCHORARRAY($X5),\"Out\")","v":0},{"$f":"$U$21&_xlfn.ANCHORARRAY(AM5)&\"represent \"&IF(--(_xlfn.ANCHORARRAY(AN5)+_xlfn.ANCHORARRAY(AP5)=0)+--(_xlfn.ANCHORARRAY(AO5)+_xlfn.ANCHORARRAY(AQ5)=0)>0,\"an annualized total \",\"an annualized net \")&IF((_xlfn.ANCHORARRAY(AN5)+_xlfn.ANCHORARRAY(AO5)+_xlfn.ANCHORARRAY(AP5)+_xlfn.ANCHORARRAY(AQ5))>0,\"cost\",IF((_xlfn.ANCHORARRAY(AN5)+_xlfn.ANCHORARRAY(AO5)+_xlfn.ANCHORARRAY(AP5)+_xlfn.ANCHORARRAY(AQ5))<0,\"cost savings\",\"\"))\n&\" of \"&DOLLAR(ABS(_xlfn.ANCHORARRAY($AN5)+_xlfn.ANCHORARRAY(AO5)+_xlfn.ANCHORARRAY(AP5)+_xlfn.ANCHORARRAY(AQ5)),0)&\". \"","v":"The amendments related to Activity Name Not Enteredrepresent an annualized total  of $0. "},{"$f":"_xlfn.LET(_xlpm.BizCount, _xlfn.MAXIFS(_xlfn.ANCHORARRAY($AJ5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($X5),\"In\",_xlfn.ANCHORARRAY($Y5),\"Labour\",_xlfn.ANCHORARRAY(AJ5),\">0\"),IF(_xlpm.BizCount=1,\"One Business would spend \",IF(_xlpm.BizCount=0,\"\", IF(_xlpm.BizCount<10, \"Up to \" &INDEX(tbl_NumberWord[],_xlpm.BizCount,2)  & \" businesses would spend \", \"Up to \" & ROUND(_xlpm.BizCount,0) & \" businesses would spend \"))))","v":""},{"$f":"_xlfn.LET(_xlpm.BizCount, _xlfn.MAXIFS(_xlfn.ANCHORARRAY($AJ5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($X5),\"out\",_xlfn.ANCHORARRAY($Y5),\"Labour\"),IF(_xlpm.BizCount=1,\"One Business would save \",IF(_xlpm.BizCount=0,\"\", IF(_xlpm.BizCount<10, \"Up to \" &INDEX(tbl_NumberWord[],_xlpm.BizCount,2)  & \" businesses would save \", \"Up to \" & ROUND(_xlpm.BizCount,0) & \" businesses would save \"))))","v":""},{"$f":"_xlfn.LET(_xlpm.BizCount, _xlfn.MAXIFS(_xlfn.ANCHORARRAY($AJ5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($X5),\"In\",_xlfn.ANCHORARRAY($Y5),\"Capital\"),IF(_xlpm.BizCount=1,\"One Business would spend \",IF(_xlpm.BizCount=0,\"\", IF(_xlpm.BizCount<10, \"Up to \" &INDEX(tbl_NumberWord[],_xlpm.BizCount,2)  & \" businesses would spend \", \"Up to \" & ROUND(_xlpm.BizCount,0) & \" businesses would spend \"))))","v":""},{"$f":"_xlfn.LET(_xlpm.BizCount, _xlfn.MAXIFS(_xlfn.ANCHORARRAY($AJ5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($X5),\"out\",_xlfn.ANCHORARRAY($Y5),\"Capital\"),IF(_xlpm.BizCount=1,\"One Business would save \",IF(_xlpm.BizCount=0,\"\", IF(_xlpm.BizCount<10, \"Up to \" &INDEX(tbl_NumberWord[],_xlpm.BizCount,2)  & \" businesses would save \", \"Up to \" & ROUND(_xlpm.BizCount,0) & \" businesses would save \"))))","v":""},{"$f":"_xlfn.LET(_xlpm.AVGLabHours, SUMIFS(_xlfn.ANCHORARRAY($AC5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($X5),\"in\",_xlfn.ANCHORARRAY(AJ5),\">0\"), IF(_xlpm.AVGLabHours=0,\"\",IF(_xlpm.AVGLabHours<1,_xlpm.AVGLabHours * 60 & \" minutes\",IF(_xlpm.AVGLabHours=1, \"one hour\",IF(_xlpm.AVGLabHours<10,INDEX(tbl_NumberWord[],_xlpm.AVGLabHours,2) & \" hours\",_xlpm.AVGLabHours &\" hours\"))) & \" to complete the task \"))","v":""},{"$f":"_xlfn.LET(_xlpm.AVGLabHours, SUMIFS(_xlfn.ANCHORARRAY($AC5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($X5),\"out\",_xlfn.ANCHORARRAY(AJ5),\">0\"), IF(_xlpm.AVGLabHours=0,\"\",IF(_xlpm.AVGLabHours<1,_xlpm.AVGLabHours * 60 & \" minutes\",IF(_xlpm.AVGLabHours=1, \" one hour \",IF(_xlpm.AVGLabHours<10,INDEX(tbl_NumberWord[],_xlpm.AVGLabHours,2) & \" hours\",_xlpm.AVGLabHours &\" hours\"))) & \" to complete the task \"))","v":""},{"$f":"_xlfn.LET(_xlpm.CapUnits, SUMIFS(_xlfn.ANCHORARRAY($AA5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($X5),\"In\",_xlfn.ANCHORARRAY(AJ5),\">0\"),IF(_xlpm.CapUnits=0,\"\",IF(_xlpm.CapUnits <1, _xlpm.CapUnits & \" units \",IF(_xlpm.CapUnits =1, \" one unit \",IF(_xlpm.CapUnits<10,INDEX(tbl_NumberWord[],_xlpm.CapUnits,2) & \" units \", _xlpm.CapUnits &\" units \")))))","v":""},{"$f":"_xlfn.LET(_xlpm.CapUnits, SUMIFS(_xlfn.ANCHORARRAY($AA5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($X5),\"out\",_xlfn.ANCHORARRAY(AJ5),\">0\"),IF(_xlpm.CapUnits=0,\"\",IF(_xlpm.CapUnits <1, _xlpm.CapUnits & \" units \",IF(_xlpm.CapUnits =1, \" one unit \",IF(_xlpm.CapUnits<10,INDEX(tbl_NumberWord[],_xlpm.CapUnits,2) & \" units\", _xlpm.CapUnits &\" units \")))))","v":""},{"$f":"_xlfn.LET(_xlpm.LabFreq, _xlfn.MAXIFS(_xlfn.ANCHORARRAY($Z5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($X5),\"In\",_xlfn.ANCHORARRAY($Y5),\"Labour\",_xlfn.ANCHORARRAY(AJ5),\">0\"),IF(_xlpm.LabFreq=0,\"\",IF(_xlpm.LabFreq<1, \"Every \" & ROUND(1/_xlpm.LabFreq,0) & \" years. \",IF(_xlpm.LabFreq=1, \"once per year. \",IF(_xlpm.LabFreq<10,INDEX(tbl_NumberWord[],_xlpm.LabFreq,2),_xlpm.LabFreq & \" times per year. \"))) ))","v":""},{"$f":"_xlfn.LET(_xlpm.LabFreq, _xlfn.MAXIFS(_xlfn.ANCHORARRAY($Z5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($X5),\"out\",_xlfn.ANCHORARRAY($Y5),\"Labour\",_xlfn.ANCHORARRAY(AJ5),\">0\"),IF(_xlpm.LabFreq=0,\"\",IF(_xlpm.LabFreq<1, \"Every \" & ROUND(1/_xlpm.LabFreq,0) & \" years. \",IF(_xlpm.LabFreq=1, \" once per year. \",IF(_xlpm.LabFreq<10,INDEX(tbl_NumberWord[],_xlpm.LabFreq,2),_xlpm.LabFreq& \" times per year. \"))) ))","v":""},{"$f":"_xlfn.LET(_xlpm.LabFreq, _xlfn.MAXIFS(_xlfn.ANCHORARRAY($Z5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($X5),\"in\",_xlfn.ANCHORARRAY($Y5),\"Capital\",_xlfn.ANCHORARRAY(AJ5),\">0\"),IF(_xlpm.LabFreq=0,\"\",IF(_xlpm.LabFreq<1, \"every \" & ROUND(1/_xlpm.LabFreq,0) & \" years. \",IF(_xlpm.LabFreq=1, \" once per year. \",IF(_xlpm.LabFreq<10,INDEX(tbl_NumberWord[],_xlpm.LabFreq,2)& \" times per year. \",_xlpm.LabFreq& \" times per year. \"))) ))","v":""},{"$f":"_xlfn.LET(_xlpm.LabFreq, _xlfn.MAXIFS(_xlfn.ANCHORARRAY($Z5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($X5),\"out\",_xlfn.ANCHORARRAY($Y5),\"Capital\",_xlfn.ANCHORARRAY(AJ5),\">0\"),IF(_xlpm.LabFreq=0,\"\",IF(_xlpm.LabFreq<1, \"every \" & ROUND(1/_xlpm.LabFreq,0) & \" years. \",IF(_xlpm.LabFreq=1, \" once per year. \",IF(_xlpm.LabFreq<10,INDEX(tbl_NumberWord[],_xlpm.LabFreq,2)& \" times per year. \",_xlpm.LabFreq& \" times per year. \"))) ))","v":""},{"$f":"_xlfn.LET(_xlpm.AvgWage, IFERROR(SUMIFS(_xlfn.ANCHORARRAY($AF5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($Y5),\"Labour\",_xlfn.ANCHORARRAY($X5),\"In\",_xlfn.ANCHORARRAY(AJ5),\">0\")/SUMIFS(_xlfn.ANCHORARRAY($AE5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($Y5),\"Labour\",_xlfn.ANCHORARRAY($X5),\"In\",_xlfn.ANCHORARRAY(AJ5),\">0\"),0), IF(_xlpm.AvgWage=0,\"\", \"The average wage (including overhead) of the responsible individual is estimated to be \" & DOLLAR(_xlpm.AvgWage,2) & \". \"))","v":""},{"$f":"_xlfn.LET(_xlpm.AvgWage, IFERROR(SUMIFS(_xlfn.ANCHORARRAY($AF5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($Y5),\"Labour\",_xlfn.ANCHORARRAY($X5),\"out\",_xlfn.ANCHORARRAY(AJ5),\">0\")/SUMIFS(_xlfn.ANCHORARRAY($AE5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($Y5),\"Labour\",_xlfn.ANCHORARRAY($X5),\"out\",_xlfn.ANCHORARRAY(AJ5),\">0\"),0), IF(_xlpm.AvgWage=0,\"\", \"The average wage (including overhead) of the responsible individual is estimated to be \" & DOLLAR(_xlpm.AvgWage,2)& \". \"))","v":""},{"$f":"_xlfn.LET(_xlpm.AvgCapCost, IFERROR(SUMIFS(_xlfn.ANCHORARRAY($AH5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($Y5),\"capital\",_xlfn.ANCHORARRAY($X5),\"In\",_xlfn.ANCHORARRAY(AJ5),\">0\")/SUMIFS(_xlfn.ANCHORARRAY($AG5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($Y5),\"Capital\",_xlfn.ANCHORARRAY($X5),\"In\",_xlfn.ANCHORARRAY(AJ5),\">0\"),0), IF(_xlpm.AvgCapCost=0,\"\",\" an average of \" & DOLLAR(_xlpm.AvgCapCost,2) & \" per unit to purchase\"))","v":""},{"$f":"_xlfn.LET(_xlpm.AvgCapCost, IFERROR(SUMIFS(_xlfn.ANCHORARRAY($AH5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($Y5),\"capital\",_xlfn.ANCHORARRAY($X5),\"out\",_xlfn.ANCHORARRAY(AJ5),\">0\")/SUMIFS(_xlfn.ANCHORARRAY($AG5),_xlfn.ANCHORARRAY($W5),_xlfn.ANCHORARRAY($AM5),_xlfn.ANCHORARRAY($Y5),\"Capital\",_xlfn.ANCHORARRAY($X5),\"out\",_xlfn.ANCHORARRAY(AJ5),\">0\"),0), IF(_xlpm.AvgCapCost=0,\"\",\"an average of \" & DOLLAR(_xlpm.AvgCapCost,2) & \" per unit. To purchase\"))","v":""},{"$f":"_xlfn.ANCHORARRAY(AR5)&_xlfn.ANCHORARRAY(AS5)&_xlfn.ANCHORARRAY(AW5)&_xlfn.ANCHORARRAY(BA5)&_xlfn.ANCHORARRAY(BE5)&_xlfn.ANCHORARRAY(AT5)&_xlfn.ANCHORARRAY(AX5)&_xlfn.ANCHORARRAY(BB5)&_xlfn.ANCHORARRAY(BF5)&_xlfn.ANCHORARRAY(AU5)&_xlfn.ANCHORARRAY(BG5)&_xlfn.ANCHORARRAY(AY5)&_xlfn.ANCHORARRAY(BC5)&_xlfn.ANCHORARRAY(AV5)&_xlfn.ANCHORARRAY(BH5)&_xlfn.ANCHORARRAY(AZ5)&_xlfn.ANCHORARRAY(BD5)&CHAR(10)","v":"The amendments related to Activity Name Not Enteredrepresent an annualized total  of $0. \n"},null,{"$f":"_xlfn.ANCHORARRAY(AN5)+_xlfn.ANCHORARRAY(AO5)+_xlfn.ANCHORARRAY(AP5)+_xlfn.ANCHORARRAY(AQ5)","v":0},{"$f":"_xlfn.ANCHORARRAY(BI5)","v":"The amendments related to Activity Name Not Enteredrepresent an annualized total  of $0. \n"},{"$f":"_xlfn._xlws.SORT(_xlfn.ANCHORARRAY(BK5):_xlfn.ANCHORARRAY(BL5),1,-1)","v":0},"The amendments related to Activity Name Not Enteredrepresent an annualized total  of $0. \n"]
[null,null,0.04,14,2016,2019,2026,null,"05 Middle management occupations in retail and wholesale trade and customer services ($43.58)",null,null,null,null,null,null,null,null,"The one-for-one rule does not apply as the regulation is made by an independent regulatory authority and is outside of the scope of the rule."]
[null,null,0.05,15,2017,2018,2027,null,"06 Middle management occupations in trades, transportation, production and utilities ($51.21)",null,null,null,null,null,null,null,null,"The one-for-one rule does not apply as there is no impact on business."]
[null,null,6.0000000000000005E-2,16,2018,2017,2028,null,"07 Business, finance and administration occupations ($33.14)",null,null,null,null,null,null,null,null,"The one-for-one rule does not apply as there is no incremental change in administrative burden on business and no regulatory titles are repealed or introduced."]
[null,null,7.0000000000000007E-2,17,2019,2016,2029,null,"08 Professional occupations in business and finance ($43.39)",null,null,null,null,null,null,null,null,"The one-for-one rule does not apply as there is no incremental change in administrative burden on business. The proposal repeals an existing regulation and replaces it with a new regulatory title, which results in no net increase or decrease in regulatory titles."]
[null,null,0.08,18,2020,2015,2030,null,"09 Administrative and financial supervisors and administrative occupations ($32.05)",null,null,null,null,null,null,null,null,{"$f":"\"The one-for-one rule applies. There is no incremental change in administrative burden on business. The proposal repeals \"\n& IF('Initiative Details'!D9>1, 'Initiative Details'!D9 & \" existing regulations \",\"an existing regulation \")\n& \"and adds \" & IF('Initiative Details'!D10>1, 'Initiative Details'!D10& \" new regulatory titles, \", \"a new regulatory title, \") & \"which results in \" & IF('Initiative Details'!D10-'Initiative Details'!D9<0, \"a net decrease \",IF('Initiative Details'!D10-'Initiative Details'!D9>0, \"a net increase \", \"no net increase or decrease in regulatory titles.\" )) & \"of \" & ABS('Initiative Details'!D9-'Initiative Details'!D10) & \" regulatory titles.\"","v":"The one-for-one rule applies. There is no incremental change in administrative burden on business. The proposal repeals an existing regulation and adds a new regulatory title, which results in no net increase or decrease in regulatory titles.of 0 regulatory titles."}]
[null,null,0.09,19,2021,2014,2031,null,"10 Finance, insurance and related business administrative occupations ($32.53)"]
[null,null,9.9999999999999992E-2,20,2022,2013,2032,null,"11 Office support occupations ($25.93)",null,null,null,null,null,null,null,null,{"$f":"IF(OneForOneLanding<0,\"The one-for-one rule applies since there is an incremental increase in administrative burden on business. The proposal is considered burden IN under the rule, and \",IF(OneForOneLanding>0,\"The one-for-one rule applies since there is an incremental decrease in administrative burden on business. The proposal is considered burden IOUT under the rule, and \",\n\"The one for one rule does not apply as the changes in adminitrative burden on business offset each other, and \")) &\n_xlfn.XLOOKUP('Initiative Details'!$D$6,Controls!$P$22:$P$26,Controls!$S$22:$S$26,\"There is no change in the number of titles\",0,1)","v":"The one for one rule does not apply as the changes in adminitrative burden on business offset each other, and no regulatory titles are repealed or introduced. "}]
[null,null,null,21,2023,2012,2033,null,"12 Distribution, tracking and scheduling co-ordination occupations ($26.45)",null,null,null,null,null,null,null,null,{"$f":"IF('Initiative Details'!$D$6=$P$22, \"The amendments \", \"The regulations \") & \"would result in an annualized administrative \"\n& IF(AND(COUNTIF(tbl_Activities[In or Out],\"out\")>0,COUNTIF(tbl_Activities[In or Out],\"in\")>0),\"net \",\"total \")\n&IF(OneForOneLanding<0,\"cost of \",\"cost savings of \")\n&DOLLAR(ABS(OneForOneLanding),0)\n& \". \" & CHAR(10) & R14 & CHAR(10)\n&IF(COUNTIF(tbl_Activities[In or Out],\"out\")>0, \"The total annualized cost savings from reduced administrative burden is estimated to be \" & DOLLAR('One-for-one'!N40,0) & \". \" & CHAR(10),  \"\")\n& IF(COUNTIF(tbl_Activities[In or Out],\"in\")>0, \"The total annualized cost of the incremental administrative burden is estimated to be \" & DOLLAR('One-for-one'!N33,0) & \". \" & CHAR(10), \"\")\n&BN4","v":"The amendments would result in an annualized administrative total cost savings of $0. \nAs per the Red Tape Reduction Regulations, the assessment of administrative impacts was conducted for a period of ten years commencing from registration. All values listed in this section are presented in 2012 dollars, discounted to 2012 at a rate of 7%.\nThe amendments related to Activity Name Not Enteredrepresent an annualized total  of $0. \n"}]
[null,null,null,22,2024,2011,null,null,"13 Natural and applied sciences and related occupations ($44.37)",null,null,null,null,null,null,null,null,{"$f":"\"As per the Red Tape Reduction Regulations, the assessment of administrative impacts was conducted for a period of ten years commencing from registration. All values listed in this section are presented in 2012 dollars, discounted to 2012 at a rate of 7%.\"","v":"As per the Red Tape Reduction Regulations, the assessment of administrative impacts was conducted for a period of ten years commencing from registration. All values listed in this section are presented in 2012 dollars, discounted to 2012 at a rate of 7%."}]
[null,null,null,23,2025,2010,null,null,"14 Professional occupations in natural and applied sciences ($48.64)"]
[null,null,null,24,2026,2009,null,null,"15 Technical occupations related to natural and applied sciences ($36.92)",null,null,null,null,null,null,null,null,"increase"]
[null,null,null,25,2027,2008,null,null,"16 Health occupations ($35.34)",null,null,null,null,null,null,null,null,"decrease"]
[null,null,null,26,2028,2007,null,null,"17 Professional occupations in nursing ($43.92)"]
[null,null,null,27,2029,2006,null,null,"18 Professional occupations in health (except nursing) ($46.16)"]
[null,null,null,28,2030,2005,null,null,"19 Technical occupations in health ($33.05)"]
[null,null,null,29,2031,2004,null,null,"20 Assisting occupations in support of health services ($24.59)",null,null,null,null,null,null,null,"Repealed ","Introduced",null,null,{"$f":"_xlfn.XLOOKUP('Initiative Details'!$D$6,Controls!$P$22:$P$26,Controls!$U$22:$U$26,0,0,1)","v":"The amendments related to "}]
[null,null,null,30,2032,2003,null,null,"21 Occupations in education, law and social, community and government services ($39.23)",null,null,null,null,null,null,"Amendment",0,0,"no regulatory titles are repealed or introduced. ",null,{"$f":"\"The amendments related to \"","v":"The amendments related to "}]
[null,null,null,31,2033,2002,null,null,"22 Professional occupations in education services ($44.35)",null,null,null,null,null,null,"New Regulation",0,1,"a new regulatory title (title in) is introduced. ",null,{"$f":"\"The new administrative requirements related to \"","v":"The new administrative requirements related to "}]
[null,null,null,32,2034,null,null,null,"23 Professional occupations in law and social, community and government services ($44.41)",null,null,null,null,null,null,"Repeal Only",1,0,"an existing regulatory title is repealed (title out). ",null,{"$f":"\" The repeal of administrative requirements related to \"","v":" The repeal of administrative requirements related to "}]
[null,null,null,33,2035,null,null,null,"24 Paraprofessional occupations in legal, social, community and education services ($26.52)",null,null,null,null,null,null,"Repeal and Replace",1,1,"the proposal repeals an existing regulation and replaces it with a new regulatory title, which results in no net increase or decrease in regulatory titles. ",null,{"$f":"\"The administrative requirements related to \"","v":"The administrative requirements related to "}]
[null,null,null,34,2036,null,null,null,"25 Occupations in front-line public protection services ($49.20)",null,null,null,null,null,null,"Multiple Repeal and Replace (One New title)","?",1,{"$f":"_xlfn.CONCAT(\"the proposal repeals \", _xlfn.XLOOKUP('Initiative Details'!$D$9,$P$34:$P$43,Q34:Q43,'Initiative Details'!$D$9,0,1), \" existing regulatory titles and adds \", _xlfn.XLOOKUP('Initiative Details'!$D$10,$P$34:$P$43,Q34:Q43,'Initiative Details'!$D$10,0,1), \" new regulatory title; as a result, a net of \",_xlfn.XLOOKUP(ABS('Initiative Details'!$D$9 -'Initiative Details'!$D$10),$P$34:$P$43,Q34:Q43,ABS('Initiative Details'!$D$9 -'Initiative Details'!$D$10),0,1),\" titles \", IF('Initiative Details'!$D$9 -'Initiative Details'!$D$10<0,\"in\",\"out\"), \" is counted under the rule. \")","v":"the proposal repeals 0 existing regulatory titles and adds 0 new regulatory title; as a result, a net of 0 titles out is counted under the rule. "},null,{"$f":"\"The administrative requirements related to \"","v":"The administrative requirements related to "}]
[null,null,null,35,2037,null,null,null,"26 Care providers and educational, legal and public protection support occupations ($26.47)"]
[null,null,null,36,2038,null,null,null,"27 Occupations in art, culture, recreation and sport ($31.49)"]
[null,null,null,37,2039,null,null,null,"28 Professional occupations in art and culture ($36.39)"]
[null,null,null,38,2040,null,null,null,"29 Technical occupations in art, culture, recreation and sport ($29.49)"]
[null,null,null,39,2041,null,null,null,"30 Sales and service occupations ($21.69)"]
[null,null,null,40,2042,null,null,null,"31 Retail sales supervisors and specialized sales occupations ($28.28)"]
[null,null,null,41,2043,null,null,null,"32 Service supervisors and specialized service occupations ($22.01)",null,null,null,null,null,null,"Numeral","Word"]
[null,null,null,42,2044,null,null,null,"33 Sales representatives and salespersons - wholesale and retail trade ($22.68)",null,null,null,null,null,null,1,"one"]
[null,null,null,43,2045,null,null,null,"34 Service representatives and other customer and personal services occupations ($21.82)",null,null,null,null,null,null,2,"two"]
[null,null,null,44,2046,null,null,null,"35 Sales support occupations ($17.14)",null,null,null,null,null,null,3,"three"]
[null,null,null,45,2047,null,null,null,"36 Service support and other service occupations, n.e.c. ($19.46)",null,null,null,null,null,null,4,"four"]
[null,null,null,46,2048,null,null,null,"37 Trades, transport and equipment operators and related occupations ($31.81)",null,null,null,null,null,null,5,"five"]
[null,null,null,47,2049,null,null,null,"38 Industrial, electrical and construction trades ($35.58)",null,null,null,null,null,null,6,"six"]
[null,null,null,48,2050,null,null,null,"39 Maintenance and equipment operation trades ($36.11)",null,null,null,null,null,null,7,"seven"]
[null,null,null,49,null,null,null,null,"40 Other installers, repairers and servicers and material handlers ($24.55)",null,null,null,null,null,null,8,"eight"]
[null,null,null,50,null,null,null,null,"41 Transport and heavy equipment operation and related maintenance occupations ($27.68)",null,null,null,null,null,null,9,"nine "]
[null,null,null,51,null,null,null,null,"42 Trades helpers, construction labourers and related occupations ($26.73)",null,null,null,null,null,null,10,"ten"]
[null,null,null,52,null,null,null,null,"43 Natural resources, agriculture and related production occupations ($28.82)",null,null,null,null,null,null,20,"twenty"]
[null,null,null,53,null,null,null,null,"44 Supervisors and technical occupations in natural resources, agriculture and related production ($39.19)",null,null,null,null,null,null,30,"thrity"]
[null,null,null,54,null,null,null,null,"45 Workers in natural resources, agriculture and related production ($23.29)",null,null,null,null,null,null,40,"forty"]
[null,null,null,55,null,null,null,null,"46 Harvesting, landscaping and natural resources labourers ($23.48)",null,null,null,null,null,null,50,"fifty"]
[null,null,null,56,null,null,null,null,"47 Occupations in manufacturing and utilities ($27.57)",null,null,null,null,null,null,100,"one hundred"]
[null,null,null,57,null,null,null,null,"48 Processing, manufacturing and utilities supervisors and central control operators ($38.89)"]
[null,null,null,58,null,null,null,null,"49 Processing and manufacturing machine operators and related production workers ($24.82)"]
[null,null,null,59,null,null,null,null,"50 Assemblers in manufacturing ($25.45)"]
[null,null,null,60,null,null,null,null,"51 Labourers in processing, manufacturing and utilities ($21.76)"]
[null,null,null,61,null,null,null,null," (custom wage not added yet)"]
[null,null,null,62]
[null,null,null,63]
[null,null,null,64]
[null,null,null,65]
[null,null,null,66]
[null,null,null,67]
[null,null,null,68]
[null,null,null,69]
[null,null,null,70]
[null,null,null,71]
[null,null,null,72]
[null,null,null,73]
[null,null,null,74]
[null,null,null,75]
[null,null,null,76]
[null,null,null,77]
[null,null,null,78]
[null,null,null,79]
[null,null,null,80]
[null,null,null,81]
[null,null,null,82]
[null,null,null,83]
[null,null,null,84]
[null,null,null,85]
[null,null,null,86]
[null,null,null,87]
[null,null,null,88]
[null,null,null,89]
[null,null,null,90]
[null,null,null,91]
[null,null,null,92]
[null,null,null,93]
[null,null,null,94]
[null,null,null,95]
[null,null,null,96]
[null,null,null,97]
[null,null,null,98]
[null,null,null,99]
[null,null,null,100]