105
edits
Changes
no edit summary
Be sure to add any assumptions and/or notes that would justify the values you enter for the various input parameters. This will help your future self, your colleagues, and your TBS analyst. An RCC submitted to TBS without notes will delay approvals, since your analyst will have to ask you for an explanation of your assumptions.
Be sure to add any assumptions and/or notes that would justify the values you enter for the various input parameters. This will help your future self, your colleagues, and your TBS analyst. An RCC submitted to TBS without notes will delay approvals, since your analyst will have to ask you for an explanation of your assumptions.
==== One-for-one ====
==== <big>Step 4: Review and Confirm Results</big> ====
Results are shown on the One-for-One, Small Business Lens, Annual Impacts, and CBA Statement Tabs. Do not blindly accept that the RCC has produced the intended result. Check the values on these tabs to make sure that your inputs have been interpreted properly.
==== <big>One-for-one</big> ====
This is where you get the info you'll need to complete the One-for-one rule section of the RIAS. In addition to the numerical values, this version of the RCC also automatically generates some draft text that you can put directly in the RIAS. The extent of the modifications that will be needed will vary according to file complexity and personal preferences (of yourself and of your TBS analyst), but this should get you most of the way there.
This is where you get the info you'll need to complete the One-for-one rule section of the RIAS. In addition to the numerical values, this version of the RCC also automatically generates some draft text that you can put directly in the RIAS. The extent of the modifications that will be needed will vary according to file complexity and personal preferences (of yourself and of your TBS analyst), but this should get you most of the way there.
==== Small Business Lens ====
The One-for_one
==== <big>Small Business Lens</big> ====
As mentioned above, you don't have to use the RCC to do your SBL section, and due to the complexity of what you're tying to model it may not be possible. But if you <u>do</u> want to use the RCC for this, the SBL sheet has all the tables from the RIAS template.
As mentioned above, you don't have to use the RCC to do your SBL section, and due to the complexity of what you're tying to model it may not be possible. But if you <u>do</u> want to use the RCC for this, the SBL sheet has all the tables from the RIAS template.
[[File:Sbl1.png|center|thumb|887x887px|The top of the SBL sheet]]
[[File:Sbl1.png|center|thumb|887x887px|The top of the SBL sheet]]
# Activity (↓za): descending order according to the name of each activity (z first)
# Activity (↓za): descending order according to the name of each activity (z first)
==== Annual Impact ====
==== <big>Annual Impact</big> ====
The Annual Impact sheet provides a breakdown of the discounted and undiscounted costs, benefits, and net impacts for every year in the analytical period.
The Annual Impact sheet provides a breakdown of the discounted and undiscounted costs, benefits, and net impacts for every year in the analytical period.
'''Display years in:''' by default this is set to Rows, but you can change it to Columns if you'd prefer.
'''Display years in:''' by default this is set to Rows, but you can change it to Columns if you'd prefer.
==== Cost-benefit statement ====
==== <big>Cost-benefit statement</big> ====
Like in the Annual Impact sheet, the grey block of values is for your information only. The results will not update if you change these values.
Like in the Annual Impact sheet, the grey block of values is for your information only. The results will not update if you change these values.
[[File:Cbastatementoptions.png|center|Cost-benefit statement options|thumb|831x831px]]
[[File:Cbastatementoptions.png|center|Cost-benefit statement options|thumb|831x831px]]
==== Labour ====
==== <big>Labour</big> ====
This sheet contains a list of employee classifications and their corresponding hourly wages. The source data from this list is from year 2021, but this is automatically inflated to the price year selected on the Initiatives sheet, so you don't really have to worry about that. If you enter a custom hourly wage at the bottom of the list, then you will have to specify the price year for the hourly wage you've entered. For example, if you found a report from 2019 that contains the hourly wage for an employee at a business that is affected by the regulation you're analyzing, you would select 2019 as the price year for the wage (just like how 2021 is specified for the wages from the Statistics Canada data).
This sheet contains a list of employee classifications and their corresponding hourly wages. The source data from this list is from year 2021, but this is automatically inflated to the price year selected on the Initiatives sheet, so you don't really have to worry about that. If you enter a custom hourly wage at the bottom of the list, then you will have to specify the price year for the hourly wage you've entered. For example, if you found a report from 2019 that contains the hourly wage for an employee at a business that is affected by the regulation you're analyzing, you would select 2019 as the price year for the wage (just like how 2021 is specified for the wages from the Statistics Canada data).
Once you enter a custom wage on this sheet, it will appear on the drop-down menu for Labour: Staff Level (Hourly Wage without Overhead) on the Activities sheet. As mentioned above, you can also just enter custom hourly wages directly into the Activities sheet, in which case you don't have to enter anything on the Labour sheet.
Once you enter a custom wage on this sheet, it will appear on the drop-down menu for Labour: Staff Level (Hourly Wage without Overhead) on the Activities sheet. As mentioned above, you can also just enter custom hourly wages directly into the Activities sheet, in which case you don't have to enter anything on the Labour sheet.
==== CPI ====
==== <big>CPI</big> ====
This is the Consumer Price Index table from Statistics Canada, which is used in the RCC to deflate impact estimates to 2012 for the one-for-one section, and to inflate all other estimates to the price year specified on the Initiatives sheet.
This is the Consumer Price Index table from Statistics Canada, which is used in the RCC to deflate impact estimates to 2012 for the one-for-one section, and to inflate all other estimates to the price year specified on the Initiatives sheet.
This table is updated once per year, usually mid-January. A new RCC will likely be updated every January to account for this update, but if you want to update an RCC you're working on the second the data becomes available, feel free to add a new row with the new price level yourself.
This table is updated once per year, usually mid-January. A new RCC will likely be updated every January to account for this update, but if you want to update an RCC you're working on the second the data becomes available, feel free to add a new row with the new price level yourself.
==== All ====
==== <big>All</big> ====
This is where impact estimates are calculated for every period for every activity throughout the analytical period. All output tables pull from information estimated here. This sheet is protected by default, but there's no password. If you want to mess around in here just click Unprotect Sheet in the ribbon (under the Review tab): [[File:Unprotected.png|center|thumb|950x950px|Unprotect Sheet]]
This is where impact estimates are calculated for every period for every activity throughout the analytical period. All output tables pull from information estimated here. This sheet is protected by default, but there's no password. If you want to mess around in here just click Unprotect Sheet in the ribbon (under the Review tab): [[File:Unprotected.png|center|thumb|950x950px|Unprotect Sheet]]
One reason you might want to unprotect the sheet is to create your own custom pivot tables, e.g., if you want to create more output tables that include other filters beyond what is pre-made in the Annual Impact sheet.
One reason you might want to unprotect the sheet is to create your own custom pivot tables, e.g., if you want to create more output tables that include other filters beyond what is pre-made in the Annual Impact sheet.
==== Controls ====
==== <big>Controls</big> ====
This contains drop-down lists and the inner workings of the auto-generated one-for-one RIAS text.
This contains drop-down lists and the inner workings of the auto-generated one-for-one RIAS text.
=== <big>'''TO BE CONTINUED . . .'''</big> ===
=== <big>'''TO BE CONTINUED . . .'''</big> ===