JPH07160786A - Table data preparation method - Google Patents

Abstract

PURPOSE:To input plural pieces of data in a single piece of table data by permitting plural pieces of data to be inputted in a single item concerning the different part of data and controlling them by providing identifiers. CONSTITUTION:As data of a first row is common data, data is inputted without defining the identifier but at the time of inputting data of a second row, data of a table 1 is inputted to define the identifier. When the definition of the identifier is instructed, the identifier is defined and the value of an inputted identifier is stored in an identifier storage area. Next, while inputting data of the second row, the identifier is gained. When the identifier finish inputting all the pieces of data of '1', the identifier is defined again. This time, an identifier is redefined to be '2', '2' is set to the identifier storage area and data of the second row in a table 2 is inputted. Thereby, in each item of the second row, data of the identifier '1' ('100' '200'...) and data of the indentifier '2' ('12' '-15'...) are stored.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to reduction of data input operation when creating a table data processing device composed of a collection of item data defined by rows and columns, and a method of creating a table data document, Regarding reduction of document capacity.

[0002]

2. Description of the Related Art When creating a tabular data document that has the same format (same table format, key line, calculation formula) or only some columns and rows of data, create different patterns of input data. Had to do.

In order to efficiently create a tabular data document, a tabular table data document is created, only different parts of input data are re-input, and each tabular data document is created and registered. .

[0004]

When the above method is used, it is necessary to create a tabular data document for different data patterns, which is troublesome to create and the documents for that amount must be registered. A storage medium is needed.

Further, when the data of the common portion is changed, the data of all related tabular data documents must be corrected (updated, corrected, registered), which causes an input error.

[0006]

[Means for Solving the Problems] When creating a document in which the same format or data of some columns or rows are different, only one part of the same data is necessary, and only different parts are input. However, it should be possible to store the data separately.

Therefore, regarding different parts of the data,
Multiple items of data can be entered in one item, and an identifier is provided to manage the distinction between the multiple items of data.

When a plurality of data are input to one item, the identifier and the data paired with the identifier are stored together in the item.

In the case of displaying or processing, the necessary display or data processing can be performed by designating the identifier of the required data and taking out the data matching the designated identifier.

[0010]

By the above means, a plurality of patterns of data can be held in one table data document. Also, by specifying the display conditions, any input data can be taken out and processed.

[0011]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a first example of a data input flow chart. FIG. 2 is the second column of the data entry flow diagram. FIG. 3 is a data display flow chart. FIG. 4 is an example of a screen of an identifier designating method. FIG. 5 is a screen example of a display condition designation method.
FIG. 6 is an explanatory diagram of the structure of table data. FIG. 7 shows a first example of data storage. FIG. 8 shows a second example of data storage. FIG. 9 is an example of table data. FIG. 10 shows a condition value storage area. FIG. 11 shows an example of the identifier designation screen. FIG. 12 shows an example of the data designation screen. FIG. 13 is a hardware configuration diagram.

When the table data as shown in FIG. 9 is created, Table 1 (table data showing the sales quantity of each product) and Table 2 (the increase and decrease of the sales quantity from the previous day of each product are shown). In the case of (table data), two table data documents exist as table data even though the values in the second row are different and the other items are the same.

Create the above two documents as one document,
An example of the table data shown in FIG. 9 will be described for processing.

First, the processing method of the data input flow chart of FIG. 1 will be described.

Since the data on the first line is common data,
Enter data without defining the identifier. When inputting the data of the second line, the data of Table 1 is input first. In that case, the identifier is defined in block 11 of FIG. When the instruction for defining the identifier is received, the identifier is defined in the step of block 13.

To define an identifier, the condition setting window shown in FIG. 4 is displayed, and the identifier is entered in the field a. In this case, "1" is input.

The value of the identifier input in block 13 is
In block 14, it is stored in the identifier storage area of FIG.

Then, the data on the second line is input.
During the data input of the second line, the block 16 acquires the identifier. Here, the value of the identifier “1” is acquired from the identifier storage area of FIG. 10, and the information of the identifier “1” is written as the item data together with the input data. 1
Similarly, while inputting the data of the line, the identifier is obtained,
At this time, since the identifier is not defined, it is written as undefined.

When all the data having the identifier "1" have been input, the identifier is defined again. This time, the identifier is redefined as "2". At this time, "2" is set in the identifier storage area of FIG. Then, the data in the second row of Table 2 is input.

By doing so, in each item on the second line, data (“100”, “200” ...) With an identifier of “1”,
The data of "2"("12","-50" ...) Is stored.

As another method, a processing method of the data input flow chart of FIG. 2 will be described. This method is a method of defining an identifier for an item after inputting data.

For example, in the data input of Table 1, the data of "100", "200", and "150" are input in the second line.
After that, the definition of the identifier is instructed.

In block 23 of FIG. 2, an item defining an identifier is designated. At this time, all items in the second line are specified.
In block 24, the condition setting window shown in FIG. 4 is displayed, and the identifier is input. For the item specified in block 25, an identifier is added to the currently stored data.

When inputting the data of the identifier "2",
Input the values of "12", "-50", and "60". afterwards,
The identifier is defined and the identifier "2" is set in the entire two lines. There are two possible data storage methods.
First, as shown in FIG. 7, the item data is paired with the data and the identifier is stored as the item data. When inputting with the input method of FIG. 1, the identifier and the data are written simultaneously. In the method of FIG. 2, only the data is written first, and the value of the identifier input when the identifier is specified is written.

As another method, as shown in FIG. 8, a data area for storing item data for each identifier is provided and stored in that area. In the input method of FIG. 1, data is written in a designated buffer while referring to the identifier storage area. In the input method of FIG. 2, a process of moving data stored in a buffer without an identifier to a designated buffer is performed.

By the above method, data with an identifier can be input and stored as internal data.

Next, as a display method, it is necessary to set display conditions.

There are two possible display conditions, an identifier and data.

Here, description will be made with reference to FIG. Display the window that specifies the display conditions. Enter the conditions for the data you want to display on this condition specification screen. In FIG. 5, an example in which a range can be specified is given as an example of the specifying method.

[B] ≤identifier≤ [c] in the first line is a condition that the identifiers whose identifier is from b to c are displayed.

For example, when it is desired to display a condition that the identifier is "1", enter [1] ≤identifier≤ [1].

The third line is a field for inputting data display conditions, and the specification method is the same as the method for specifying the identifiers, and the condition is to display items of d or more and e or less.

If you want to display positive data

Input [0] ≦ data ≦ []. OR / A on the second line
ND is a condition that links the identifier and the data display condition. If it is OR, it is displayed if either the identifier or the data satisfies the condition.

AND is a designation to display when both are satisfied.

In FIG. 5, the condition can be specified by the range, but there is also a method of not specifying the range. Also, a method of separately designating the identifier and the data may be considered. Examples of these are shown in FIGS.

11 and 12 have the same input condition. In the columns of f and h, operators (<,>, =, ≠,
Enter ≦, ≧). Enter the condition value (numerical value or character) in the g and i fields.

The means for displaying the item data according to the conditions specified by the display condition specification will be described with reference to FIG. In block 31, the item data requested to be displayed is read. At block 32, it is checked whether the item has data with an identifier. If there is no identifier, block 34 is entered. If the identifier is defined, block 33 checks the display condition and the identifier. If the conditions are met, block 34 converts the data of the corresponding item into a displayable format. If the condition is not met, block 35 sets null data for displaying nothing. At block 36, the display data created at blocks 34 and 35 are displayed.

When a condition for displaying the identifier "1" is input as the display condition, the corresponding data is extracted from the data shown in FIGS. 7 and 8, and the table of Table 1 of FIG. 9 is displayed. By the above method, a plurality of data can be stored in one tabular data document, and arbitrary data can be displayed and processed by designating display conditions.

[0040]

According to the present invention, in the same format,
Even in a tabular data document whose tabular data is partially different, a plurality of data can be input in one tabular data document.

Therefore, the common data need only be input once, and there is no need to have the data redundantly, so that the document capacity can be reduced.

Further, even if the data of the common part is changed,
Only one table data document needs to be modified, and an efficient table data document can be created.

[Brief description of drawings]

FIG. 1 is a data input flow chart.

FIG. 2 is a data input flow chart.

FIG. 3 is a data display flow chart.

FIG. 4 is a diagram showing a screen example of an identifier designating method.

FIG. 5 is a diagram showing a screen example of a display condition designating method.

FIG. 6 is a diagram showing tabular data.

FIG. 7 is a diagram showing an example of data storage.

FIG. 8 is a diagram showing an example of data storage.

FIG. 9 is a diagram showing an example of table data.

FIG. 10 is a diagram showing a condition storage area.

FIG. 11 is a diagram showing an example of an identifier designation screen.

FIG. 12 is a diagram showing an example of a data designation screen.

FIG. 13 is a hardware configuration diagram.

[Explanation of symbols]

1 ... Control device, 2 ... Input device, 3 ... Display device, 4 ... Storage device, 11-17 ... Data input flow 1, 21-27 ...
Data input flow 2, 31-36 ... Data display flow,
a ... Identifier value input field, b to e ... Display condition value input field, f, h ... Operator input field, g, i ... Condition value input field.

Claims (2)

[Claims] 1. A table data processing device comprising an input device, a storage device, a display device for displaying information input from the input device and stored contents of the storage device, and a control device for controlling these devices. 2. A method for creating table data, wherein a plurality of combinations of data and an identifier paired with the data are stored in one item data. 2. A table data processing device comprising an input device, a storage device, a display device for displaying information input from the input device and stored contents of the storage device, and a control device for controlling these devices. In the table data creating method, according to the display condition, only the item data satisfying the condition is displayed.