Changes

m
Line 348: Line 348:  
===== Error check =====
 
===== Error check =====
   −
The Error Check column contains a formula that checks for common mistakes and gives you a written explanation of how you could/should fix them. It is simply a series of IF statements joined by the "&" operator. If you accidentally delete this formula then the error check functionality will no longer work. You can resolve this problem by re-downloading the RCC or typing the following formula in the error check column (or a new column entirely if you've deleted the whole thing): "=ErrorCheck". Try to implement the suggested solution before reaching out for further assistance.
+
The Error Check column contains a formula that checks for common mistakes and gives you a written explanation of how you could/should fix them. It is simply a series of IF statements joined by the "&" operator. If you accidentally delete this formula then the error check functionality will no longer work. You can resolve this problem by re-downloading the RCC or typing the following formula in the error check column (or a new column entirely if you've deleted the whole thing): "=ErrorCheck".
    
Orange-shaded error messages indicate that you may want to change something, but you don't necessarily have to. For instance, you will notice an orange error message if you enter a series of inputs that do not result in any incremental impact, since this may be something that you intended to do for completeness or transparency purposes, or maybe it was a mistake. If you manually enter a custom wage directly in the activities table, an orange message will remind you to ensure that the wage you entered is in the same price year as the one specified on the Initiatives sheet. If you've used a high frequency, an orange message will suggest that you consider modelling it a different way (see the explanation of frequency above).  
 
Orange-shaded error messages indicate that you may want to change something, but you don't necessarily have to. For instance, you will notice an orange error message if you enter a series of inputs that do not result in any incremental impact, since this may be something that you intended to do for completeness or transparency purposes, or maybe it was a mistake. If you manually enter a custom wage directly in the activities table, an orange message will remind you to ensure that the wage you entered is in the same price year as the one specified on the Initiatives sheet. If you've used a high frequency, an orange message will suggest that you consider modelling it a different way (see the explanation of frequency above).  
   −
All other error messages will be shaded in red, indicating that something is wrong and should be resolved before you submit the RCC to TBS.  
+
All other error messages will be shaded in red, indicating that something is wrong and should be resolved before you submit the RCC to TBS. Try to implement the suggested solution before reaching out for further assistance.  
    
===== Assumptions/Notes =====
 
===== Assumptions/Notes =====
136

edits