Setup >  Configurator >  Calculation table >  Double-entry  

Display all Hide all

This function is used to carry out allocations of values to a variable depending on the value of two indexes or axes: the X axis (abscissa) and the Y axis (ordinate).

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

 

Entry screen

Presentation

Header entry

Calculator and title : This is the name of the calculator over a maximum of 8 characters and its title defined over a maximum of 30 characters.

Blocking not found : This setup is used, if it is ticked, to interrupt the scenario if the value in the grid from the X & Y coordinates is not found to correspond with the transferred setups. It is then necessary to correct it in the Configuration questions window.

Abscissa/ordinate result format : It is necessary to specify the numeric, alphanumeric, or date format of the X and Y-axes, as well as the class used It is also necessary to indicate whether to use value ranges for the X and or Y axes in the description of the cross table that is referenced.

X axis/ Y axis / result title: It is possible to personalize the title of the X-axis, Y-axis and result columns in the grid, this is to facilitate the reading of the calculator grid.

X-axis and Y axis grid : It is necessary to enter for each X-axis/Y-axis cross-reference, the result to be used in the scenario. This table must be entered in ascending values order and for the same X-axis value in ascending order of the Y-axis value. When entering numeric Y-axis values, the system suggests the next value according to the value at the previous step.

Close

 

Fields

The following fields are present on this tab :

Block number 1

Build the array code.
An array is a grid matching any value to a bracket of reference values.





  • field ABQAXX

 
  • Block not found (field RESFLG)

To be ticked if, in the event of a negative search, the scenario should be interrupted.

In this case the variable will be initialized according to its type :

Zero if numerical.

Empty if alphanumerical.

0/0/0 if date.

X-value

  • Description (field ABSAXX)

 
  • field FIL001

 
  • Range of values (field ABSCOD)
  • Format (field ABQTYP)

Choose the format for the ranges of values
- Alphanumerical
- Numerical
- Date
The format can only be modified if the table is empty.


.
  • Character (field ABQCHA)

Choose:
- Capital letters for automatic conversion in capital letters.
- Lowercase letters for automatic conversion in lowercase letters.
- Capital and lowercase letters to enter without conversion.

Y-value

  • Description (field ORDAXX)

 
  • field FIL002

 
  • Range of values (field ORDCOD)
  • Format (field ABQTYPY)

Choose the format for the ranges of values
- Alphanumerical
- Numerical
- Date
The format can only be modified if the table is empty.


.
  • Character (field ABQCHAY)

Choose:
- Capital letters for automatic conversion in capital letters.
- Lowercase letters for automatic conversion in lowercase letters.
- Capital and lowercase letters to enter without conversion.

Result

  • Description (field RESAXX)

 
  • Format (field RESTYP)

Choose the format for the ranges of values
- Alphanumerical
- Numerical
- Date
The format can only be modified if the table is empty.
  • Character (field RESCHA)

Choose:
- Capital letters for automatic conversion in capital letters.
- Lowercase letters for automatic conversion in lowercase letters.
- Capital and lowercase letters to enter without conversion.

Grid

  • field STRVAL

Enter the start value (excluded value) conforming to the predefined format.
  • field ENDVAL

 
  • field STRVALY

Enter the end value (included value) conforming to the predefined format.
  • field ENDVALY

 
  • field RESVAL

Enter the resulting value according to the predefined resulting format.

Close

 

Reports

By default, the following reports are associated with this function :

  PRTSCR : Screen print

This can be changed using a different setup.

Menu Bar

This button is used to recopy a two dimension calculation table to another folder.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation