Important: The GCConnex decommission will not affect GCCollab or GCWiki. Thank you and happy collaborating!

File:RCCV4 Beta.xlsx

From wiki
Revision as of 13:51, 13 September 2024 by Timothy.wieclawski (talk | contribs) (Timothy.wieclawski uploaded a new version of File:RCCV4 Beta.xlsx)
Jump to navigation Jump to search

RCCV4_Beta.xlsx(file size: 306 KB, MIME type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)

Warning: This file type may contain malicious code. By executing it, your system may be compromised.

File history

Click on a date/time to view the file as it appeared at that time.

(newest | oldest) View (newer 10 | ) (10 | 20 | 50 | 100 | 250 | 500)
Date/TimeDimensionsUserComment
current14:02, 4 April 2025 (306 KB)Andrew.reid (talk | contribs)fixed an error on the Annual Impact sheet
17:46, 3 April 2025 (306 KB)Andrew.reid (talk | contribs)4. Custom hourly wages can now be entered directly in the input table on the Activities sheet (the units of measurement for wages entered this way must match the Price Year on the Initiative sheet). 5. Custom function added: =CONV(Value, OriginYear) converts a value from a price in a previous year (the “Origin year”) to prices that match the Price Year on the Initiative sheet. This can be used to quickly enter a custom hourly wage directly in the input table on the Activities sheet.
17:41, 3 April 2025 (306 KB)Andrew.reid (talk | contribs)1. Changed the user input from In/ Out to Cost/Benefit on the Activities sheet. For the One-for-one rule, an Administrative Cost is an In and an Administrative Benefit is an Out. 2. Minor updates to the Error Check column regarding the treatment of blank rows and activities with high frequencies. 3. Streamlined yellow sheets: several output tables that were on separate sheets in previous RCC versions are now accessible by selecting from a drop-down menu on the “Annual Impact” sheet. The for...
16:39, 20 March 2025 (327 KB)Andrew.reid (talk | contribs)fixed magnitude switch on SBL sheet
18:21, 18 March 2025 (327 KB)Andrew.reid (talk | contribs)- Improved the estimation of ongoing costs with frequency less than 1 (costs now apply to each annual cohort of new entrants if stakeholder growth > 0%; the first year with costs is now the selected Start Year). - Fixed 2 yellow output sheets to handle cases where 2 rows on the Activities sheet have the same Activity name but different Affected Stakeholder Groups.
13:37, 21 January 2025 (321 KB)Andrew.reid (talk | contribs)2024 prices, version check button on Read Me, new and improved output tabs
13:32, 21 January 2025 (212 KB)Andrew.reid (talk | contribs)Reverted to version as of 16:25, 3 December 2024 (EST)
13:27, 21 January 2025 (321 KB)Andrew.reid (talk | contribs)2024 prices, version check button on Read Me, new and improved output tabs
17:25, 3 December 2024 (212 KB)Andrew.reid (talk | contribs)- Now works for users who have thousands separated by spaces and decimals separated by a comma in their MS Office settings - Changed the user input options from TRUE/FALSE to Yes/No for two fields on the Activities tab - Fixed a minor error in the Annual Impacts by Stakeholder - Minor edits to the auto-generated 141 text - Minor improvements to the Error Check (simplified wording, added a new warning, named the formula "ErrorCheck")
12:18, 13 November 2024 (209 KB)Timothy.wieclawski (talk | contribs)
(newest | oldest) View (newer 10 | ) (10 | 20 | 50 | 100 | 250 | 500)

There are no pages that use this file.