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 62:
Line 62:
+
The Centre of Regulatory Expertise continuously responds to feedback from users to improve the Calculator. So, when starting a new analysis, you should check if a new version is available. You can do this by right-clicking on the “''Right-click and Refresh this box to check for a new version''” button located toward the top of the “Read Me''”'' tab. Right-clicking this button open an options menu. Users should click Refresh to have the Calculator compare the upload date of the active RCC with the most recent version on the webpage. If a newer version is available, the text in cell D24 will read "A new version is available. Go get it now!". Users would then need to access the [[/wiki.gccollab.ca/Regulatory Costing Calculator - Calculateur des coûts de la réglementation|Regulatory Costing Calculator - Calculateur des coûts de la réglementation - wiki]] to download the new version. If a new version is not available, the text in cell D24 will read "This is the current version, based on the last time the box was refreshed."
The Centre of Regulatory Expertise continuously responds to feedback from users to improve the Calculator. So, when starting a new analysis, you should check if a new version is available. You can do this by right-clicking on the “''Right-click and Refresh this box to check for a new version''” button located toward the top of the “Read Me''”'' tab. Right-clicking this button open an options menu. Users should click Refresh to have the Calculator compare the upload date of the active RCC with the most recent version on the webpage. If a newer version is available, the text in cell D24 will read "A new version is available. Go get it now!". Users would then need to access the [[/wiki.gccollab.ca/Regulatory Costing Calculator - Calculateur des coûts de la réglementation|Regulatory Costing Calculator - Calculateur des coûts de la réglementation - wiki]] to download the new version. If a new version is not available, the text in cell D24 will read "This is the current version, based on the last time the box was refreshed."
[[File:Check for New Version.jpg|border|490x490px|Right Click on the box labelled "Right-click and Refresh this box to check for a new version"|alt=|center]]
[[File:Check for New Version.jpg|border|490x490px|Right Click on the box labelled "Right-click and Refresh this box to check for a new version"|alt=|center]]
+
+===== 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
+[[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:
+[[File:Alternate Method.png|center|frame]]
+
===== Language Selection =====
===== Language Selection =====
This version of the RCC is not configured to switch between English and French.
This version of the RCC is not configured to switch between English and French.
Line 70:
Line 77:
Users can enter inputs to the Calculator directly in the cells of the spreadsheet as one would do in a traditional Excel file. Cells for user input are formatted with a white fill (see below) on worksheet with blue tabs (Initiative Details, Stakeholder Profile, Activities). For tables that automatically expand as data is entered a cell with "'''''Type Here ⮚'''''" on the left edge of the table indicates the row where values should be inputted. Cells that are shaded grey contain formulas or pre-set parameters. Although they are not protected and the user should not change them.
Users can enter inputs to the Calculator directly in the cells of the spreadsheet as one would do in a traditional Excel file. Cells for user input are formatted with a white fill (see below) on worksheet with blue tabs (Initiative Details, Stakeholder Profile, Activities). For tables that automatically expand as data is entered a cell with "'''''Type Here ⮚'''''" on the left edge of the table indicates the row where values should be inputted. Cells that are shaded grey contain formulas or pre-set parameters. Although they are not protected and the user should not change them.
−===== 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.
<big>'''TO BE CONTINUED . . .'''</big>
<big>'''TO BE CONTINUED . . .'''</big>
