Entering Data in Worksheets

About data entry

You enter financial data by opening a worksheet, inputting individual data values into the worksheet's cells, and saving the data to your personal database. You can then submit the data to the shared database, making your work available to other users.

Note: Zero values in worksheets

Zero values entered into budget worksheets are stored in the database as NA values. Zero values entered into worksheets through a data reader are stored as zeros.

Recalculating data

If you enter new data in a worksheet or change data used to calculate other values, you can use the recalculate feature to refresh all the data in the worksheet.

If you are recalculating data along a hierarchy or according to a model, you need to specify the appropriate recalculation options before you use the recalculate feature. The options that you specify are retained in the worksheet until you change them.

Note: Data affected by recalculating

When you recalculate data in a worksheet, the recalculation affects only the data slice that is currently selected for display in the worksheet. To recalculate data beyond the boundaries of the worksheet, use a solve definition or a group solve definition. For information about solving data, refer to Chapter 9.

Saving data

If you want to save data without saving the worksheet, from the toolbar choose:

or choose Worksheet Tools from the Worksheet menu nd then choose Save Data.

Resetting data

If you decide not to keep changes that you make to data in a worksheet, but you want to continue using the worksheet, you can reset its data. You can only reset data that has not been saved. Once data is saved in a worksheet, you cannot reset it.

To reset data, choose Reset Data from the Worksheet Tools menu.

Related information

For more information about entering data in worksheets, search for the following topics in the Financial Analyzer Help system:

"Calculating Worksheet Data"

"Entering Data into Worksheets"

"Resetting Worksheet Data"

"Saving Worksheet Data"