Changes

===== Deleting Rows =====

===== Deleting Rows =====

Collections of inputs in the Calculator appear in rows with user input and pre-set functions. For example, the business counts and growth rates for a particular stakeholder group will be contained in a single row in the table on the Stakeholders sheet, and various details of a particular activity will be contained in a single row in a table on the Activities sheet. There are two ways delete rows.  

Collections of inputs in the Calculator appear in rows with user input and pre-set functions. For example, the business counts and growth rates for a particular stakeholder group will be contained in a single row in the table on the [[RCC userguide#Step Two: Identify Regulated Community .E2.80.93 Stakeholder Profile|Stakeholders]] tab, and various details of a particular activity will be contained in a single row in a table on the Activities sheet. There are two ways delete rows.  

The preferred way: users can right click on any cell in the row and select <u>D</u>elete -> Table <u>R</u>ow.

The preferred way: users can right click on any cell in the row and select <u>D</u>elete -> Table <u>R</u>ow.

====== Growth Rates ======

====== Growth Rates ======

To estimate regulatory impacts, you need to know how many stakeholders are in the market at any given time. The RCC takes the initial stakeholder counts from the Stakeholders tab, and applies the growth rates in every year throughout the analytical period.

To estimate regulatory impacts, you need to know how many stakeholders are in the market at any given time. The RCC takes the initial stakeholder counts from the [[RCC userguide#Step Two: Identify Regulated Community .E2.80.93 Stakeholder Profile|Stakeholders]] tab, and applies the growth rates in every year throughout the analytical period.

'''Annual growth rates:''' At the moment there is only an option to exponential growth. Users should enter the average annual growth rate as a percentage of each stakeholder. If the growth rate is left blank, then it is assumed to be zero.  In a future version you may be able to model growth in different ways, and if that sounds like something you’d like to work on, feel free to reach out to TBS CORE and offer your services!

'''Annual growth rates:''' At the moment there is only an option to exponential growth. Users should enter the average annual growth rate as a percentage of each stakeholder. If the growth rate is left blank, then it is assumed to be zero.  In a future version you may be able to model growth in different ways, and if that sounds like something you’d like to work on, feel free to reach out to TBS CORE and offer your services!

====== Annual Breakdown ======

====== Annual Breakdown ======

You can view the '''Annual Stakeholder Count''' which is broken down further to the right on the Stakeholders sheet, as shown in the image below. This breakdown is an output only, meaning that if you delete it / override it with different information, that will not affect the cost estimates on subsequent sheets.

You can view the '''Annual Stakeholder Count''' which is broken down further to the right on the [[RCC userguide#Step Two: Identify Regulated Community .E2.80.93 Stakeholder Profile|Stakeholders]] sheet, as shown in the image below. This breakdown is an output only, meaning that if you delete it / override it with different information, that will not affect the cost estimates on subsequent sheets.

It is recommended that users view the annual stakeholder count to validate that the growth rates were entered correctly. For example, if you try to enter 3% annual growth but accidentally entered 300% annual growth, the estimated stakeholder counts towards the end of the analytical period will be so high that you should realize something is wrong.  

It is recommended that users view the annual stakeholder count to validate that the growth rates were entered correctly. For example, if you try to enter 3% annual growth but accidentally entered 300% annual growth, the estimated stakeholder counts towards the end of the analytical period will be so high that you should realize something is wrong.  

====== '''Activity''': ======

====== '''Activity''': ======

This is a description of the activity. The description should be clear and easy to cross-reference requirements described in the Regulatory Impact Analysis Statement. The Activity description will be used in the auto-generated text on the One-for-One Tab. Unlike in the Stakeholders input table where group names must be unique, the same activity name can be used on multiple rows. On the Annual Impact sheet, when the breakdown method is "By Activity", multiple rows of activities with the same name will be bundled together.  

This is a description of the activity. The description should be clear and easy to cross-reference requirements described in the Regulatory Impact Analysis Statement. The Activity description will be used in the auto-generated text on the One-for-One Tab. Unlike in the [[RCC userguide#Step Two: Identify Regulated Community .E2.80.93 Stakeholder Profile|Stakeholders]] input table where group names must be unique, the same activity name can be used on multiple rows. On the Annual Impact sheet, when the breakdown method is "By Activity", multiple rows of activities with the same name will be bundled together.  

====== '''Administrative or Compliance:''' ======

====== '''Administrative or Compliance:''' ======

====== Affected Stakeholder Group ======

====== Affected Stakeholder Group ======

All Activities must have an affected stakeholder group. The affected stakeholder group must be one of the groups listed on your stakeholder profile sheet. If you select a particular stakeholder group on the Activities sheet and then modify its group name on the Stakeholders sheet, you will have to re-select the affected stakeholder group.   

All Activities must have an affected stakeholder group. The affected stakeholder group must be one of the groups listed on your stakeholder profile sheet. If you select a particular stakeholder group on the Activities sheet and then modify its group name on the [[RCC userguide#Step Two: Identify Regulated Community .E2.80.93 Stakeholder Profile|Stakeholders]] sheet, you will have to re-select the affected stakeholder group.   

If the Calculator is being used to calculate impacts for government, then a Government stakeholder group should be created with a Non-Business Count equal to one.   

If the Calculator is being used to calculate impacts for government, then a Government stakeholder group should be created with a Non-Business Count equal to one.   

Users can select a specific group from the dropdown list or select "All Groups." Selecting "All Groups" will apply the activity to each group entered on the Stakeholders sheet, and the impacts will be disaggregated appropriately on the yellow output sheets (when sorting impacts "By Stakeholder Group"). Alternatively, sometimes you may want to apply an activity to all stakeholders and see a distinct row for each one on the Activities tab. Having a distinct row for the same activity applied to each stakeholder group may be necessary if different stakeholders would incur different impacts to conduct the activity (e.g., the different groups may have different baseline compliance rates).   

Users can select a specific group from the dropdown list or select "All Groups." Selecting "All Groups" will apply the activity to each group entered on the [[RCC userguide#Step Two: Identify Regulated Community .E2.80.93 Stakeholder Profile|Stakeholders]] sheet, and the impacts will be disaggregated appropriately on the yellow output sheets (when sorting impacts "By Stakeholder Group"). Alternatively, sometimes you may want to apply an activity to all stakeholders and see a distinct row for each one on the Activities tab. Having a distinct row for the same activity applied to each stakeholder group may be necessary if different stakeholders would incur different impacts to conduct the activity (e.g., the different groups may have different baseline compliance rates).   

====== Affected Stakeholder Type ======

====== Affected Stakeholder Type ======

The stakeholder type, specifying whether it applies to businesses, non-businesses, small businesses, or large businesses.

The stakeholder type, specifying whether it applies to businesses, non-businesses, small businesses, or large businesses.

At the top of the One-for-One tab, the grey-shaded block contains the analytical parameters for the results on this sheet. These are not input variables. According to the Red Tape Reduction Regulations values in the One-for-One section must be reported in 2012 dollars, discounted to 2012 using a rate of 7% and considered over a period of 10 years from registration.     

At the top of the One-for-One tab, the grey-shaded block contains the analytical parameters for the results on this sheet. These are not input variables. According to the Red Tape Reduction Regulations values in the One-for-One section must be reported in 2012 dollars, discounted to 2012 using a rate of 7% and considered over a period of 10 years from registration.     

The Results box shows the Net Present Value of Administrative Impacts on All Business, and on a per business basis. The per business calculation is based on the total number of businesses entered into the Stakeholder Table on the Stakeholders tab. The per business result is an imprecise calculation and should be used with discretion. The ''Annualized Administrative Impact, All Businesses'' value is what is reported in the one-for-one rule section of the RIAS. A positive value represents a cost savings, a negative value represents a cost.         

The Results box shows the Net Present Value of Administrative Impacts on All Business, and on a per business basis. The per business calculation is based on the total number of businesses entered into the Stakeholder Table on the [[RCC userguide#Step Two: Identify Regulated Community .E2.80.93 Stakeholder Profile|Stakeholders]] tab. The per business result is an imprecise calculation and should be used with discretion. The ''Annualized Administrative Impact, All Businesses'' value is what is reported in the one-for-one rule section of the RIAS. A positive value represents a cost savings, a negative value represents a cost.         

The Draft RIAS text box is suggested text that may be used in the RIAS. It is generated using a simple if / then algorithm. This text should be considered a starting point. It would need to be proofread and adjusted to ensure it is accurately reflecting the intent of what was entered in the activities sheet.         

The Draft RIAS text box is suggested text that may be used in the RIAS. It is generated using a simple if / then algorithm. This text should be considered a starting point. It would need to be proofread and adjusted to ensure it is accurately reflecting the intent of what was entered in the activities sheet.         

'''Breakdown:''' this allows you to select whether you want a simple breakdown (costs, benefits, net), or a breakdown by activity, by stakeholder, or by activity and stakeholder.  

'''Breakdown:''' this allows you to select whether you want a simple breakdown (costs, benefits, net), or a breakdown by activity, by stakeholder, or by activity and stakeholder.  

'''Sort tables by:''' this allows you to sort the values in the tables in different ways. When the breakdown is set to simple, the only sorting option is "Default." But if the breakdown is anything else, you can sort by the magnitude of the impact, by the activity name, or by the stakeholder group name, as applicable. In general, "Default" sorting aligns with the order in which activities and stakeholders were entered on their respective sheets.  

'''Sort tables by:''' this allows you to sort the values in the tables in different ways. When the breakdown is set to simple, the only sorting option is "Default." But if the breakdown is anything else, you can sort by the magnitude of the impact, by the activity name, or by the stakeholder group name, as applicable. In general, "Default" sorting aligns with the order in which activities and [[RCC userguide#Step Two: Identify Regulated Community .E2.80.93 Stakeholder Profile|Stakeholders]] were entered on their respective sheets.  

'''Group tables by:''' by default this is set to "Discounting", meaning that it will first produce the Discounted Costs, Discounted Benefits and Discounted Net Impacts, then the Undiscounted Costs, Undiscounted Benefits, and Undiscounted Net Impacts. Changing this to "Costs | Benefits | Net" means that the output will look like: Discounted Costs, Undiscounted Costs, then Discounted Benefits, Undiscounted Benefits, then Discounted Net, Undiscounted Net.

'''Group tables by:''' by default this is set to "Discounting", meaning that it will first produce the Discounted Costs, Discounted Benefits and Discounted Net Impacts, then the Undiscounted Costs, Undiscounted Benefits, and Undiscounted Net Impacts. Changing this to "Costs | Benefits | Net" means that the output will look like: Discounted Costs, Undiscounted Costs, then Discounted Benefits, Undiscounted Benefits, then Discounted Net, Undiscounted Net.