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
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.