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 56:
Line 56:
===== Security Issues =====
===== Security Issues =====
+Unlike earlier iterations of the RCC, Version 4 of the Calculator does '''not''' use customized visual basic code and functions to complete calculations and automate features. This makes the calculator more accessible depending on the security settings of user departments or agencies. The calculator does make use of the [https://support.microsoft.com/en-us/office/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a Power Query] function to refence a [[:en:RCC_CPI_Table|CGWiki page]] to check for the most recent version of the Calculator and for CPI updates. This will trigger a security warnings the first time Calculator is opened and the data connections will be disabled (as shown below). Enabling content will permit the calculator to reference the GC Wiki when users refresh the version and CPI queries, otherwise the calculator will function as normal, even when the data connections are disabled.
+[[File:Security Warning.jpg|center|frame|Security Warning with Enable Content button]]
+
+===== Checking for New Versions =====
+[[File:Check for New Version.jpg|border|left|490x490px|Right Click on the box labelled "Right-click and Refresh this box to check for a new version"]]
+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."
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+===== Language Selection =====
+This version of the RCC is not configured to switch between English and French.
+
+===== User Input =====
+While the Calculator is an Excel application, a user can enter, edit, and delete almost all inputs.
+
+User can also 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 teal borders and white fill (see below). Most other cells in the Calculator, contain formulas or pre-set parameters, are protected and the user may not change them. If you have need to examine these cells please contact TBS-RAS for instructions on how to unlock the Calculator.
<big>'''TO BE CONTINUED . . .'''</big>
<big>'''TO BE CONTINUED . . .'''</big>
