84
edits
Important: The GCConnex decommission will not affect GCCollab or GCWiki. Thank you and happy collaborating!
Changes
Jump to navigation
Jump to search
no edit summary
Line 64:
Line 64:
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
===== Adjusting the Calculated Columns Excel User Setting =====
===== Adjusting the Calculated Columns Excel User Setting =====
−There is a default user setting in Excel that makes using the RCC worse, if people ever want to put formulas into table inputs. You saw this before I think, if you put a formula in the first row and the subsequent rows are blank, it auto-fills the formula all the way down. It's called "calculated columns" and the setting is in Options > Proofing > Autocorrect Options > AutoFormat as you type
+There is a default user setting in Excel that makes using the RCC worse, if people ever want to put formulas into table inputs. If you put a formula in the first row and the subsequent rows are blank, it auto-fills the formula all the way down. It's called "calculated columns" and the setting is in Options > Proofing > Autocorrect Options > AutoFormat as you type
[[File:Excel User Setting.png|center|frame]]
[[File:Excel User Setting.png|center|frame]]
The last box should be unchecked. But when that undesirable behaviour happens, a little box also pops up, and the setting can be changed there:
The last box should be unchecked. But when that undesirable behaviour happens, a little box also pops up, and the setting can be changed there:
Line 78:
Line 78:
===== Deleting Rows =====
===== Deleting Rows =====
−Collections of inputs in the Calculator appear in rows with user input and pre-set functions. This can make it difficult to manually delete an entry. When rows entered in the '''''Stakeholder Profile''''' table or the '''''Activities''''' tables need to be deleted, users should right click on the so we recommend that collections be deleted using a form control. The form control will remove all data points in a collection without creating errors in cell references used by protected content. More information on how to do this will be discussed in this manual.
+Collections of inputs in the Calculator appear in rows with user input and pre-set functions. This can make it difficult to manually delete an entry. When rows entered in the '''''Stakeholder Profile''''' table or the '''''Activities''''' tables need to be deleted, users should right click on any cell in the row and select <u>D</u>elete -> Table <u>R</u>ow.
+==== Implementation Overview ====
+The best way to implement the Standard Cost Model with the Calculator is to follow a series of logical steps, as laid out below in the '''Steps to implement the Calculator''' image. The following sections of the guide contain further details on how to complete each of these steps and how to enter the associated information into the Calculator.
+[[File:Steps to Implement the Calculator.jpg|center|frame|Steps to Implement the Calculator]]
+==== Step One: Initiative Details - Initiative Profile ====
+When using the Calculator, information that sets the regulatory context should be entered on the tab named '''''Initiative Details'''''.
+This information is entered directly on the spreadsheet. If you wish to copy and paste from another document, it is best to click on the appropriate cell and press “F2”. The F2 key is a short-cut in Excel to edit the selected cell’s contents. By doing this you will retain formatting such as carriage returns, which if pasted directly into a spreadsheet adds content over multiple rows. If you are typing the results directly into the cell you can enter a carriage return in a cell by pressing “alt-enter”.
+[[File:Initiative Details Tab.png|alt=Initiative Details Tab|border|left|frameless|645x645px|Initiative Details Tab]]
+The first information to provide (Cell '''D5''') is the official name of the Regulatory Change. The title the regulation will be given when published within the Canada Gazette. Since multiple proposals may have the same name (for example Amendments to the Canadian Aviation Regulations), a distinct nickname should be added in parentheses. '''For reference purposes it is advised that you add the Statutory Orders and Regulation number (SOR number) to this field after the regulation has been registered'''. The SOR number will allow cross-referencing Calculators to regulations in the future.
+The '''Type of Regulation''' is a selection from a drop down list. It’s either an amendment, a new regulation, a repeal and replace or repeal multiple to replace with a new one. When a selection is made here, The '''Number of Regulations Repealed''' and the '''Number of Regulations Introduced''' cells automatically update.
+'''Responsible Organization.''' This is the name of the department or agency that will recommend, make, and/or approve the regulation. '''When a regulation is jointly managed by several departments, this should be mentioned in the assumptions and notes area as well as any information relevant in support of the decision of which the minister is responsible'''.
+'''Brief description of the regulatory change''': Put in a '''clear and concise description''' so TBS analysts and future analysts can look at this and understand. The RCC does not use this information. Because the Calculator is designed to measure incremental business impacts, this description should focus on how the regulations would cause businesses to change the way they operate. For context purposes, the user may also wish to briefly describe the objectives of the regulation. Never assume that a second party, who may review the Calculator, has access to supplemental documents such as the Regulatory Impact Analysis Statement. To the extent possible, make the RCC a stand-alone product that is easy to follow. In summary, the regulatory context should briefly describe:
+1. what the regulation does;
+2. what is its intended outcome; and
+3. how it will impact businesses.
+•'''Number of regulations repealed.''' This is a drop-down list. It is only filled if the regulatory changes selected is Multiple Repeal and Replace.
+•'''Number of Regulations Introduced'''. The automatically when the regulatory change is selected. If the proposal is introducing more than one regulation, a separate calculator should be used for each regulation.
+•'''Price Year.''' The year of prices (cost of labour, cost of units) used in the analysis. Prices used to estimate impacts on the ''Activities'' are all converted to the same year on the reporting tabs. Prices for labour cost data in the Calculator are from 2021. If a different price year is selected the calculator will deflate or inflate these values using the Consumer Price Index to the selected price level. The price year for the one-for-one rule is determined by the [[/laws-lois.justice.gc.ca/eng/regulations/SOR-2015-202/index.html|Red Tape Reduction Regulations]] (currently 2012), it is not affected by this selection.
+•'''Year of Registration'''. The year that your department anticipates the regulation will be registered. This is the ''Start Year of Analysis'' when entering periods in the the Activities Sheet.
+•'''Present Value Base Year'''. The is the year that impacts are discounted back to. Typically, this is the same as the registration year, but there is a option to use something different.
+•'''Length of Analytical Period.''' This is the number of years over which you will estimate impacts. The Calculator can accommodate analyses up to 98 years. TBS policy requires a minimum ten years for Cost Benefit Analysis (CBA). The Red Tape Reduction Regulations require a ten-year period for INs and OUTs under the one-for-one Rule and cost estimates.
+•'''Discount Rate'''. The percent per year that the value of future impacts will be reduced. This value should normally be set to 7% (real discount rate), as required by TBS CBA policy and the one-for-one rule and small business lens analysis. However, other discount rates can be used. This does not affect the One-for-One Rule calculation. By default, that uses 7%.
+==== Identify Regulated Community – Setting Stakeholder Groups ====
+The next step in the process is to identify, group and estimate the number of businesses that the regulatory proposal will affect.
+Unlike earlier iterations, Version 4 does not have built-in information from Statistics Canada on counts of businesses using categories from the North American Industrial Classification System (NAICS).
+This information is available at: [[/ised-isde.canada.ca/app/ixb/cis/search-recherche#brwseinds|Canadian Industry Statistics - Innovation, Science and Economic Development Canada]]
+Users would need to enter stakeholder counts manually.
<big>'''TO BE CONTINUED . . .'''</big>
<big>'''TO BE CONTINUED . . .'''</big>
