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 38:
Line 38:
'''Figure 1: Diagram of the Main Components of the Standard Cost Model'''
'''Figure 1: Diagram of the Main Components of the Standard Cost Model'''
−[[File:RCC UserGuide Figure 1.jpg|center|frame|Figure 1 Diagram of the Main Components of the Standard Cost Model]]''The SCM estimates the costs of completing each activity on the basis of a couple of cost parameters:''
+[[File:RCC UserGuide Figure 1.jpg|center|Figure 1 Diagram of the Main Components of the Standard Cost Model|alt=|thumb|900x900px]]''The SCM estimates the costs of completing each activity on the basis of a couple of cost parameters:''
* ''Price: Price consists:''
* ''Price: Price consists:''
Line 57:
Line 57:
===== 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.
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]]
+[[File:Security Warning.jpg|center|Security Warning with Enable Content button|alt=|thumb|900x900px]]
===== Checking for New Versions =====
===== Checking for New Versions =====
Line 65:
Line 65:
===== 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. 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|alt=|thumb|600x600px]]
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:
[[File:Alternate Method.png|center|frame]]
[[File:Alternate Method.png|center|frame]]
Line 82:
Line 82:
==== Implementation Overview ====
==== 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.
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]]
+[[File:Steps to Implement the Calculator.jpg|center|Steps to Implement the Calculator|alt=|thumb|900x900px]]
==== Step One: Initiative Details - Initiative Profile ====
==== Step One: Initiative Details - Initiative Profile ====
