How do I Override a Value?

Follow

Manual Override

Please note, before you can edit any of the Excel worksheets, please make sure to "enable editing" usually located at the top of the Microsoft Excel program, as shown below:

 

Simply click on    first and then you may proceed with the instructions below.

 

Manual override columns are provided on all sheets.  These may be used to amend or remove numbers. The figures entered in the Manual Override column will show up in the column for Annual Figures adjusting the Monthly Figures (wherever applicable) accordingly. 

There are three ways to use the Manual Override:

1. Input a specified dollar amount

2. Input $ 0 to force a zero dollar amount

3. Delete an override to return to the original amount

 
Important:

 Never change the data in the CY and PY columns. When a user changes a number in the current year or prior year columns, the formulas in those cells will be corrupted, creating a potential disconnect with the rest of the calculation.

Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    Bruce

    Does not show every step, needs to say "click Editing" at the top of the screen.