Operation domain
1. In the data entry schedule, select the Guide tab
2. If required, select the language in which you want to view the instructions.
Related Topics
•To open a data entry schedule
4.2.15.4 To enter an amount in a cell
The data entered is “validated” as soon as:
• another cell is selected.
• you press Enter.
For thousands and millions, you can enter K or M. Enter 150K euros for 150,000 euros. For example, enter 150M$ for US$150,000,000.
To enter an amount:
1. In the data entry schedule, select the cell in which you want to enter an amount.
A frame appears around the cell.
2. Enter the amount that you want to assign to the cell.
3. Click OK.
4.2.15.5 To display the information on cell data in a schedule
You view the cell data source information in the Information on Data dialog box.
This dialog box contains the following tabs:
• Identification, which displays the data value stored, display format used, data source used, and the dimensions used to define the data. The selection mode and initialization values used are displayed for each dimension.
• Origin, which displays the origin of formulas, like category scenario, cell or rollup, long description of formulas, and full formula expressions.
Note:
The full formula expression will not be displayed for rollup or automatic category scenario formulas.
• Comment, which displays comments linked to the selected cell.
To display the Information on Data dialog box:
1. In the data entry schedule, select the cell whose information you want to display.
2. Do one of the following:
• Select View > Information on Data.
• Right-click the cell and select Information on Data.
The "Information on data" dialog box appears.
4.2.15.6 Data entry schedule cell indicators
There are indicators which enable you to display the following information in the cells of the schedule:
Meaning Description
Indicator
Schedules are linked to this cell.
A blue arrow in the bottom right-hand corner of the cell
Link indicator
Meaning Description
Indicator
You can enter data in the cell.
A blue arrow on the left side of the cell
Data entry indicator
The positive or negative signs (+
or -) are displayed in the left side of cells containing positive or neg-ative amounts in original package audit IDs.
Positive or negative sign Positive or negative indicator
The cell contains a comment.
A solid red triangle in the top right-hand corner of the cell Comment indicator
You can enter a comment in the cell.
A triangle outlined in red in the top right-hand corner of the cell Comment entry indicator
Example:
Indicators in a schedule cell.
4.2.15.6.1 To show or hide an indicator in a data entry schedule
• In the data entry schedule, do one of the following:
• Select View > Schedule and select the indicator you want to show or hide.
• Click one of the following icons in the "Schedule Data Entry" toolbar:
Data Entry indicator Link indicator Comment indicator
4.2.15.7 To enter a comment in a data entry cell
You can associate a comment with an item of data in two ways:
• If the design of the schedule authorizes you to do so in unprotected cells, you can enter a comment directly in the cell containing the data.
• If a Comment column was defined when the schedule was designed. You can enter comments directly in the Comment column. There will be no comment indicators in cells.
To enter a comment:
1. In the data entry schedule, click the button to display the comment indicators.
Note:
If no indicator appears in the cell, comments cannot be associated with this data.
2. Select the cell containing the data where you want to enter a comment.
3. Do one of the following:
• Right-click the cell and select Comment.
• Click View > Comment.
The "Comment" tab in the "Information on data" dialog box appears.
4. Enter the comment.
5. Click to validate.
Related Topics
•Data entry schedule cell indicators
4.2.15.8 Searching in a data entry schedule
You can search for a code or a description in a schedule.
Note:
The Find function does not search the headers, footers or text boxes in the schedule.
Caution:
If you want to find a number in thousands, you must enter the digit grouping symbol defined in your Windows Regional Options. For example, if your digit grouping symbol is a comma, then to search for the number 2000, you enter 2,000.
4.2.15.8.1 To search for a code or description in a data entry schedule 1. In the data entry schedule, select Edit > Find.
The "Find" dialog box appears.
2. Enter the code or description you want to find.
3. Click Find Next.
4.2.15.9 To insert or delete a row in a data entry schedule
1. Select:
• one of the rows belonging to a group in which you want to insert a row.
Tip:
The row header is yellow.
• the row that you want to delete.
2. Select Actions > Schedule > Row > Add/Delete.
The "Addition-deletion of the dimension value" dialog box appears.
3. Add or delete the required rows.
4. Click OK.
Caution:
Formulas that refer to the deleted rows or columns will be incorrect.
4.2.15.10 To insert or delete a column in a data entry schedule
1. In the data entry schedule, select:
• one of the columns belonging to a group in which you want to insert a column.
Tip:
The column header is yellow in color.
• the column that you want to delete.
2. Select Actions > Schedule > Columns > Add/Delete.
The "Addition-deletion of the dimension value" dialog box appears.
3. Add or delete the required columns.
4. Click OK.
Caution:
Formulas that refer to the deleted rows or columns will be incorrect.
4.2.15.11 To define the zoom factor for a data entry schedule
The zoom value is only applied to the body of the schedule. It is independent of the Reduce or Increase options in the print function.
• Select the zoom factor you want to assign to the zoom using the following option in the Schedule Data Entry toolbar:
Related Topics
•The Schedule Data Entry toolbar in the package editor
4.2.15.12 To display the schedule footer in a data entry schedule
• Do one of the following:
• Select View > Schedule > Footer.
• Click in the "Schedule Data Entry" toolbar.
4.2.15.13 To display the schedule header in a data entry schedule
• Do one of the following:
• Select View > Schedule > Header.
• Click in the "Schedule Data Entry" toolbar.
Related Topics
•The Schedule Data Entry toolbar in the package editor
4.2.15.14 To change the amounts retrieval scale in a data entry schedule
Scales are made up of two components:
• the operator, which uses the following values:
• Multiply by, represented by .
• Divide by, represented by .
• the coefficient, which uses the following values: 1 (default value), 10, 100, 1,000, 10,000, 100,000 and 1,000,000.
To change the scale for displaying the database amounts in a data entry schedule:
1. In the Schedule Data Entry toolbar, select an operator.
2. Select a coefficient from the box.
Related Topics
•The Schedule Data Entry toolbar in the package editor
4.2.15.15 To open schedules linked to a cell
Schedule cells can be linked to other schedules.
By default, the breakdown report opens in the same window as the source schedule. You can open it in a separate window by deactivating Linked schedule open in the same window in the View menu.
For example, a cell in an income statement links to an analysis of sales, which in turn links to an analysis of sales by reporting unit, sorted by branch.
To open a linked schedule:
1. In the data entry schedule, select the cell linked to the schedule you want to open.