JPH0561894A - Tabulator - Google Patents

Abstract

(57) [Summary] [Purpose] To provide a tabulation device that can eliminate the need for editing work by an operator when creating a table based on data and efficiently perform tabulation processing. [Structure] The tabulation device 10 stores a replacement condition for replacing item data with replacement data and the replacement data in the work memory 14, and whether the item data read from the data file 16 conforms to the replacement condition. And the item data read when it is determined that the replacement condition is satisfied is replaced with the replacement data.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a tabulation device, and more particularly to a tabulation device for creating a table based on item data.

[0002]

2. Description of the Related Art As a conventional tabulation device, there is a spreadsheet type tabulation device. This tabulation device is of a type centered on a tabulation calculation function, and has many commands as a tabulation function such as copying from item to item, deleting and replacing items. For calculation, it has a wide range of functions from numerical calculation to financial calculation. Further, the card type database type tabulation device is a type that mainly considers one screen as one card and manages data on a card-by-card basis. As a function, it is powerful in terms of conditional search and sorting of data in card units.

[0003]

However, in such a conventional tabulation device, when a table is created from a data file, only calculation or condition search for the item (field) data of the table is performed. Since it is configured, the item data is not displayed in a different expression format although the condition search can be performed. For example, a field in a data file as shown in FIG. 4 described later (for example, English)
There is no such function even when trying to add “excellent”, “good”, “acceptable”, or “impossible” according to the score, so the operator had to use an editor or the like to correct the data in each field. In this case, if the number of items in the table to be created is small, it does not take much time even if it is done manually, but if the number of items increases and the conditions of each item become more complicated, it will take a lot of time. In addition, there is a drawback that when data or conditions are changed, they must be reedited one by one. Then, it is obvious that if the condition for replacing the data is stored and the data is replaced according to the condition, the editing process becomes unnecessary. An object of the present invention is to enable data replacement according to replacement conditions.

[0004]

The means of the present invention are as follows. The item data reading means 1 (see the functional block diagram of FIG. 1, the same applies hereinafter) reads out the item data of the table in record units from a data file storing the record data of the table, for example. The replacement condition storage means 2 is a RAM or the like that stores replacement conditions for replacing item data with replacement data and the replacement data. The discriminating means 3 discriminates whether or not the item data read by the item data reading means 1 conforms to the replacement condition stored in the replacement condition storage means 2, and is judged by, for example, a CPU. The replacing means 4 replaces the item data read out when the judging means 3 judges that the replacing condition is satisfied, with the replacing data and the item data tabulated and executed by the CPU, for example. It is output to a display device such as a CRT or a printing device such as a printer.

[0005]

The operation of the means of the present invention is as follows. First,
The replacement condition storage means 2 stores the replacement condition corresponding to each item and the replacement data replaced by the delay process. In this state, when the item data of the table is read by the item data reading means 1, it is judged whether the item data read by the judging means 3 conforms to the replacement condition stored in the replacement condition storing means 1, When it is determined that the replacement condition is satisfied, the item data read by the replacement unit 4 is replaced with the replacement data. Therefore, it is not necessary to edit the data of each item in the table using a table editor or the like, and the table can be efficiently created.

[0006]

EXAMPLES Examples will be described below with reference to FIGS. 2 to 4 are views showing an embodiment of the tabulation device.
First, the configuration will be described. FIG. 2 is a block diagram of the tabulation device 10. In this figure, 11 is a CPU that controls the entire apparatus and performs various data processes including a data replacement process described later, and the CPU 11 is a program R described later.
Various operations of the tabulation device are controlled according to a microprogram stored in the AM 13. The CPU 11 includes an input device 12 including a keyboard having various data input keys and function keys, a program RAM 13 for storing processing procedures such as input control, file control, data processing control in the form of a program and fixed data. Work data 14 for temporarily storing replacement data and replacement conditions used for calculation, data being processed, input buffer 15 for temporarily storing character codes keyed from input device 12, A data file 16 for storing data in record units, a display device 17 for displaying input data, edited data, etc., and a printing device 18 for printing out a tabulation result are connected.

The program RAM 13, the work memory 14, and the input buffer 15 are used, for example, by dividing a RAM storage area. The input device 12 is an operation panel on which keys for inputting alphanumeric characters, hiragana, etc., and function keys such as a cursor movement key, an execution key, and a stop key are arranged, and any key on the operation panel is operated. In this case, a control unit (not shown) converts the key code into a predetermined key code corresponding to the key and outputs it to the CPU 11.

Next, the operation of this embodiment will be described. FIG. 3 is a flowchart showing the data replacement process. In this flow process, data is read in record units and replaced.
In the figure, reference numeral Sn (n = 1, 2, ...) Shows each step of the flow.

When the program is started, first, one record of office work data is read from the office work data file 16 in step S1, and the field i of the record read in step S2 is set to 1 (i = 1). Here, this processing is processing for each record, and one record is composed of a plurality of fields (items). For example, in the paperwork data 21 shown in FIG. 4, one record consists of three fields of "name", "English", and "mathematical". Then, the replacement condition for each field i is checked in order from the first field (“name”).

In step S3, it is determined whether or not the replacement condition for the field i is set. The replacement condition is a condition for replacing the read field data with replacement data when the field data has a certain condition, and can be set for each field. In this embodiment, the replacement condition 22 is set in the "English" field as shown in FIG. The replacement condition 22 is replaced with "excellent" when the data in the field of "English" is 80 or more, "good" when it is 70 or more, "good" when it is 60 or more, and "not good" when it is 59 or less. It is a replacement condition. It should be noted that this replacement condition is an example, and it goes without saying that the replacement condition and the replacement data can be set arbitrarily, and it goes without saying that similar replacement conditions can be set in other fields (for example, mathematics). is there.

When the replacement condition for the field i is not set (for example, in the case of the first "name" field), the contents of the field i (name "AAA" in the above example) are left unchanged in step S6. If the replacement condition for the field i is output, it is checked in step S4 whether or not the data in the field i conforms to the replacement condition, and in step S5 the corresponding field data is designated by the replacement condition. Replace with replacement data. If the read field data does not match any of the replacement conditions, the process proceeds to step S6 without replacement. For example, when processing the "English" field of the first record, this field data is "90", and the replacement condition 22 as shown in FIG. 4 is set in this "English" field. Therefore, the field data “90” is replaced with “excellent” which is a replacement condition of 80 or more.

In step S6, the field data and the replacement data obtained by the data replacement are output as a table output 23 as shown in FIG. The table output 23 may be output on the display screen of the display device 17, or may be printed by the printing device 18. Next, in step S7, it is determined whether or not it is the final field. For example, when the field is "English" as shown in FIG. 4, it is not the final field. In this case, therefore, increment is performed to add 1 to the field i in step S8. Specify the next field and return to step S3. Also, FIG.
If it is the last field such as the "mathematical" field, it is determined in step S9 whether all the records have been processed. If all the records have not been processed, step S1
Then, the above process is repeated until all records are processed. By executing the above processing, the table output 23 shown in FIG. 4 is created.

As described above, the tabulation device 10 of this embodiment stores the replacement conditions for replacing item data with replacement data and the replacement data in the work memory 14, and reads the items from the data file 16. Since it is determined whether or not the data conforms to the replacement condition, and the item data read when it is determined that the replacement condition is satisfied, the replacement data is replaced with the replacement data. The field data is automatically “Excellent” or “Good” according to the score.
The table output 23 will be made by replacing "possible" and "impossible", and the operator does not need to use an editor or the like to modify the data in each field. In particular, the number of items has increased
When the conditions of each item become more complicated, the work efficiency can be significantly improved.

Further, if the specification for creating a table from the data for office processing is stored, the tabulation process when updating the data can be made smoother.

In this embodiment, the replacement data is "excellent".
Character data such as “good” and “OK” is used, but any data that replaces item data with predetermined data, such as rounding (or rounding off) the numerical value of item data, can be replaced with numerical data. It may be one.

Needless to say, the number of items, the number of lines, the type of data and the like shown in this embodiment are not limited to those in the above embodiment.

[0017]

According to the present invention, the item data is replaced with the replacement data in accordance with the replacement condition. Therefore, when the table is created based on the item data, the editing work by the operator can be eliminated. , The tabulation process can be performed efficiently.

[Brief description of drawings]

FIG. 1 is a functional block diagram of the present invention.

FIG. 2 is a block configuration diagram of a tabulation device.

FIG. 3 is a flowchart showing a data replacement process of the tabulation device.

FIG. 4 is a diagram for explaining a tabulation process of a tabulation device.

[Explanation of symbols]

 10 Tabulation device 11 CPU 12 Input device 13 Program RAM 14 Work memory 15 Input buffer 16 Data file 17 Display device 18 Printing device 21 Office work data 22 Substitution condition 23 Table output

Claims (1)

[Claims] 1. An item data reading means for reading item data in a table, a replacement condition for replacing the item data with replacement data and a replacement condition storage means for storing the replacement data, and the item data reading means for reading. Discriminating means for discriminating whether the issued item data conforms to the substitution condition stored in the substitution condition storage means, and item data read out when the discrimination means discriminates that the substitution condition matches. And a replacement unit that replaces the replacement data with the replacement data.