Correcting Spreadsheet Entries

Section: 5. MAKING CORRECTIONS
Subsection: 5.1 Correcting the Spreadsheet
Topic: Correcting Spreadsheet Entries

Correcting any data on the spreadsheet is simply a matter of directly editing the data in the Excel spreadsheet. Follow these steps:

File Open

2. Select the DataEntry page

3. Make corrections in the given monthly column (blue areas only!).

4. Check to make sure any unavailable data is set to =NA().

5. Goto the Scorecard page and enter the monthend for the data you just corrected.

6. Press F9 to recalculate.

7. Select File Print Report to reprint any of the reports or graphs you wish.