17 Create Versions with Cell Specifications

This chapter contains the topic:

17.1 Creating Versions with Cell Specifications

You use cell specifications to define the values for individual cells within your version. With a cell, you can define a calculation without using an entire row or column. For example, you might define a percent calculation for a cell within a percent column.

You define each cell by row number and column number, for example, R2C2.

From the FASTR menu (G83), choose Financial Statements

To create a version with cell specifications

On Financial Statements

  1. Access FASTR Definition Options.

  2. On FASTR Definition Options, select Cell Specifications, in addition to selecting the functions you use to create a version with row specifications.

  3. Follow the steps for creating a version with row specifications.

    See Section 10.1, "Creating Versions with Row Specifications."

  4. Complete each screen until Cell Specifications appears.

    Figure 17-1 Cell Specifications screen

    Description of Figure 17-1 follows
    Description of "Figure 17-1 Cell Specifications screen"

  5. On Cell Specifications, complete the following fields:

    • Row Number

    • Column Number

    • Cell Calculations

  6. Choose Display Additional Calculations to access the detail area on Cell Specifications.

  7. Complete the following fields:

    • Ledger Type

    • Display Decimals

    • Recalculation

Field Explanation
Cell Calculations Identifies a fixed value to be used in a calculation. A cell is identified by the row and column number, for example, R10C2.
Ledger Type A user defined code (system 09/type LT) that specifies the type of ledger, such as AA (Actual Amount), BA (Budget Amount), or AU (Actual Units). You can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.
Dsp Dec Specifies the number of decimals to be displayed for a column or row. The default value is based on the division factor (for cells with calculations) and default decimals (for cells with division calculations only) from the Override Default Information screen.
Rcalc (Y/N) Determines if a cell calculation is done in conjunction with column and row calculations or after all column and row calculations have been completed. Values are:

N – Calculate with column and row calculations.

Y – Calculate after column and row calculations are complete.

17.1.1 What You Should Know About

Topic Description
Cell specifications You cannot specify a cell for a calculation and then use that cell in the calculation itself. For example, R4C5 = R4C5/R3C6 is invalid.
Cell calculations When an entire column is overridden with cell calculations, it does not matter how that column is defined in Column Specifications.
Recalculation options If you are uncertain whether to choose Yes or No for recalculation, start with No. If No does not work, use Yes. Remember that if either choice works in a test environment, it will work on your version. Be consistent with your version. If you choose No, continue to use No for every submission of the version.