MANIPULATING OF LABELLED DATA FOR DATA ENTRY IN MANAGEMENT APPLICATIONS

摘要

A method and system for entry of data into content of cells belonging to an output field. Entered into cells of a multidimensional table located within a header record in the table are: input field labels respectively corresponding to input fields in the table entered into a respective unique cell within the header record; and an output label corresponding to the output field entered into a specifically unique cell within the header record and expressed as a mathematical expression of input field labels. The mathematical expressions are translated into the cell address of the cell containing each input field label and then pasted in each cell of the output field. The cell address of the cell containing each input field label is replaced in the pasted mathematical expression by the corresponding cell address of each input field in the same record that contains each cell of the output field.

主权项

1. A method for entry of data into content of cells belonging to an output field, said method comprising:
entering, by a processor of a computer system, into cells of a multidimensional table located within a header record in the table: (i) at least one input field label respectively corresponding to at least one input field in the table such that each input field label is entered into a respective unique cell within the header record and (ii) an output label corresponding to the output field such that the output label is entered into a specifically unique cell within the header record, said output label being expressed as a mathematical expression of one or more labels of the at least one input field label; said processor parsing the output label to identify each input field label; said processor translating the mathematical expression of the one or more labels such that each identified input field label is translated into the cell address of the cell containing each identified input field label; and said processor pasting in said each cell of the output field the translated mathematical expression and replacing in said pasted mathematical expression the cell address of the cell containing each input field label by the corresponding cell address of each input field in the same record that contains said each cell of the output field.