Changes

====== End Year ======

====== End Year ======

The end year can be selected from a dropdown list and must be on or after the start year. The maximum possible value for the end year is determined by the ''Length of Analytical Period (Years)'' entered in the Initiative Details tab (but the actual value could depend on the regulatory requirement).   

The end year can be selected from a dropdown list and must be on or after the start year. The maximum possible value for the end year is determined by the ''Length of Analytical Period (Years)'' entered in the [[RCC userguide#Step One: Initiative Details - Initiative Profile|Initiative tab]] (but the actual value could depend on the regulatory requirement).   

Unlike previous versions of the Calculator, the end year is inclusive (n.b. the start year was inclusive in earlier versions and it is still inclusive now). This means impacts are calculated from the beginning of the selected start year to the end of the selected end year. Therefore, the number of years in the Analytical Period may appear one year less than a simple subtraction might indicate. For example a Proposal that is registered in 2025 and has a ''Length of Analytical Period (Years)'' of 10 years, would have a ''Start Year'' of 2025 and ''End Year'' of 2034.  

Unlike previous versions of the Calculator, the end year is inclusive (n.b. the start year was inclusive in earlier versions and it is still inclusive now). This means impacts are calculated from the beginning of the selected start year to the end of the selected end year. Therefore, the number of years in the Analytical Period may appear one year less than a simple subtraction might indicate. For example a Proposal that is registered in 2025 and has a ''Length of Analytical Period (Years)'' of 10 years, would have a ''Start Year'' of 2025 and ''End Year'' of 2034.  

This is the price of one unit.  

This is the price of one unit.  

====== Capital: Price Year of Unit Price ======

====== Capital: Price Year of Unit Price ======

On the Initiative sheet you entered the Price Year to be used in the analysis, which is an important aspect of the units of measurement. If the unit price info was pulled from an older document, then the price may not align with the Price Year on the Initiative sheet. This is normal, but you just need to specify the price year for the unit price information. The RCC will then automatically convert this value to 2012 prices for the one-for-one rule (if applicable), and to the price year selected on the Initiative sheet everywhere else.  

On the [[RCC userguide#Step One: Initiative Details - Initiative Profile|Initiative tab]] you entered the Price Year to be used in the analysis, which is an important aspect of the units of measurement. If the unit price info was pulled from an older document, then the price may not align with the Price Year on the [[RCC userguide#Step One: Initiative Details - Initiative Profile|Initiative tab]]. This is normal, but you just need to specify the price year for the unit price information. The RCC will then automatically convert this value to 2012 prices for the one-for-one rule (if applicable), and to the price year selected on the Initiative sheet everywhere else.  

===== Annual Frequency =====

===== Annual Frequency =====

Custom wages can be added by adding new rows to the table on the Labour sheet, or by simply typing in the wage directly into the Labour: Staff Level (Hourly Wage Without Overhead) column on the Activities table. If you enter a custom wage directly in the table on the Activities sheet then just enter the numerical value only (i.e., don't add a description here).  

Custom wages can be added by adding new rows to the table on the Labour sheet, or by simply typing in the wage directly into the Labour: Staff Level (Hourly Wage Without Overhead) column on the Activities table. If you enter a custom wage directly in the table on the Activities sheet then just enter the numerical value only (i.e., don't add a description here).  

If you enter a custom wage on the Labour sheet you must specify the price year for the wage (e.g., did you get it from a report from 2019?), but if you enter it directly in the Activities table then it is assumed that you've entered it in the price year matching what was selected on the Initiatives sheet. So if your price year on the initiatives sheet is 2024, make sure you enter the custom wage in 2024 prices.  

If you enter a custom wage on the Labour sheet you must specify the price year for the wage (e.g., did you get it from a report from 2019?), but if you enter it directly in the Activities table then it is assumed that you've entered it in the price year matching what was selected on the [[RCC userguide#Step One: Initiative Details - Initiative Profile|Initiative tab]]. So if your price year on the [[RCC userguide#Step One: Initiative Details - Initiative Profile|Initiative tab]] is 2024, make sure you enter the custom wage in 2024 prices.  

===== Error check =====

===== Error check =====

The Error Check column contains a formula that checks for common mistakes and gives you a written explanation of how you could/should fix them. It is simply a series of IF statements joined by the "&" operator. If you accidentally delete this formula then the error check functionality will no longer work. You can resolve this problem by re-downloading the RCC or typing the following formula in the error check column (or a new column entirely if you've deleted the whole thing): "=ErrorCheck".   

The Error Check column contains a formula that checks for common mistakes and gives you a written explanation of how you could/should fix them. It is simply a series of IF statements joined by the "&" operator. If you accidentally delete this formula then the error check functionality will no longer work. You can resolve this problem by re-downloading the RCC or typing the following formula in the error check column (or a new column entirely if you've deleted the whole thing): "=ErrorCheck".   

Orange-shaded error messages indicate that you may want to change something, but you don't necessarily have to. For instance, you will notice an orange error message if you enter a series of inputs that do not result in any incremental impact, since this may be something that you intended to do for completeness or transparency purposes, or maybe it was a mistake. If you manually enter a custom wage directly in the activities table, an orange message will remind you to ensure that the wage you entered is in the same price year as the one specified on the Initiatives sheet. If you've used a high frequency, an orange message will suggest that you consider modelling it a different way (see the explanation of frequency above).  

Orange-shaded error messages indicate that you may want to change something, but you don't necessarily have to. For instance, you will notice an orange error message if you enter a series of inputs that do not result in any incremental impact, since this may be something that you intended to do for completeness or transparency purposes, or maybe it was a mistake. If you manually enter a custom wage directly in the activities table, an orange message will remind you to ensure that the wage you entered is in the same price year as the one specified on the [[RCC userguide#Step One: Initiative Details - Initiative Profile|Initiative tab]].. If you've used a high frequency, an orange message will suggest that you consider modelling it a different way (see the explanation of frequency above).  

All other error messages will be shaded in red, indicating that something is wrong and should be resolved before you submit the RCC to TBS. Try to implement the suggested solution before reaching out for further assistance.  

All other error messages will be shaded in red, indicating that something is wrong and should be resolved before you submit the RCC to TBS. Try to implement the suggested solution before reaching out for further assistance.  

The Annual Breakdown tables show the costs and benefits related to the activities considered within the scope of the One-for-One Rule. Regardless of the Length of Analytical Period (Years) entered into the Initiative tab, the annual break on the One-for-One tab will only show 10 years from the Year of Registration. The only impacts included on these tables are those that are categorized as administrative include impacts on at least one business.                               

 

The Annual Breakdown tables show the costs and benefits related to the activities considered within the scope of the One-for-One Rule. Regardless of the Length of Analytical Period (Years) entered into the [[RCC userguide#Step One: Initiative Details - Initiative Profile|Initiative tab]], the annual break on the One-for-One tab will only show 10 years from the Year of Registration. The only impacts included on these tables are those that are categorized as administrative include impacts on at least one business.                               

Tables are divided in the IN (costs), OUT (benefits, or costs savings), and NET (benefits minus costs).                               

Tables are divided in the IN (costs), OUT (benefits, or costs savings), and NET (benefits minus costs).                               

The aid with error-checking, value are first presented undiscounted using the Price Year of analysis indicated on the Initiative tab. Then it is presented discounted to the same price year and present value base year at indicated on the initiative tab. These values would match those used in the CBA. Then the values are presented undiscounted in 2012 price year and finally discounted to 2012 is 2012 prices. These values are reported in the One-for-One Section of the RIAS.                                 

The aid with error-checking, value are first presented undiscounted using the Price Year of analysis indicated on the [[RCC userguide#Step One: Initiative Details - Initiative Profile|Initiative tab]]. Then it is presented discounted to the same price year and present value base year at indicated on the [[RCC userguide#Step One: Initiative Details - Initiative Profile|Initiative tab]]. These values would match those used in the CBA. Then the values are presented undiscounted in 2012 price year and finally discounted to 2012 is 2012 prices. These values are reported in the One-for-One Section of the RIAS.                                 

==== <big>Small Business Lens</big> ====

==== <big>Small Business Lens</big> ====

==== <big>Labour</big> ====

==== <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 [[RCC userguide#Step One: Initiative Details - Initiative Profile|Initiative tab]], 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.  

==== <big>CPI</big> ====

==== <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 [[RCC userguide#Step One: Initiative Details - Initiative Profile|Initiative tab.]]

There are several different forms of the Consumer Price Index, but the one used in the RCC is the annual average price level for All Goods. Because this is the <u>annual average</u> price level, it is only updated once the full year has elapsed, so the latest available value is always a year behind the current calendar year.  

There are several different forms of the Consumer Price Index, but the one used in the RCC is the annual average price level for All Goods. Because this is the <u>annual average</u> price level, it is only updated once the full year has elapsed, so the latest available value is always a year behind the current calendar year.