JPH0512315A - Table processor - Google Patents

Abstract

PURPOSE:To improve the utilization value of a table by evaluating data displayed in a specific item of the table by referring to a stored reference value and displaying the evaluation result corresponding to the specific item of the table. CONSTITUTION:The correspondence relation between calculation expressions and items is so set that the capital profit rate in an item IT5 of the table is calculated from the ordinary income in an item 1(IT1) and the capital in an item IT1. When a record(RC) 1 in the table is specified, the numeric data of the items 'IT1' and 'IT2' of the RC1 are read out of a table memory and calculated. After the calculation, the calculation result is inputted to a variable memory. Then the calculation result is compared with the reference value in a specific location of the variable memory and the calculation result is inputted to and set in an 'IT6' of the table memory according to the 'IT6' specified in the variable memory with a symbol code corresponding to the comparison result and also displayed at a display part 6.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table processing apparatus for electronic equipment which creates a table on a display screen and performs tabulation processing.

[0002]

2. Description of the Related Art Conventionally, in a table processing device of an electronic device having a work function, when a table is created on a display screen and a totaling process is performed, first the number of rows of the table, that is, the number of records,
A table is created by designating columns, that is, the number of items and the number of digits of each item area defined by this record and item, and then the tabulation is performed. That is, in this type of table processing device, by inputting a calculation formula, the item data of the table can be calculated according to the calculation formula.

[0003]

By the way, in the table processing apparatus as described above, the calculated item data of the table may be evaluated and the evaluation result may be displayed in a predetermined item of the table. In such a case, the calculation result must be evaluated based on a certain value, and the evaluation must be manually filled in the specified items in the table, which requires complicated work and requires a lot of time. I was trying.

The present invention has been made in view of the above circumstances, and an object of the present invention is to provide a table processing device capable of displaying evaluations of calculation results together with calculation results in correspondence with predetermined items in a table. ..

[0005]

According to the present invention, reference value storage means for storing a reference value for evaluating data displayed in a predetermined item of a created table, and the above-mentioned reference value are used to refer to the reference value storage means. The evaluation means for evaluating the data displayed in the predetermined item of the table and the evaluation result display means for displaying the evaluation result by the evaluation means in correspondence with the predetermined item of the table are provided.

[0006]

According to the above construction, the evaluation means refers to the reference value stored in the reference value storage means and evaluates the data displayed in the predetermined item of the table. The evaluation result is displayed by the evaluation result display means in correspondence with the predetermined items in the table. Therefore, the evaluation of the calculation result can be displayed along with the calculation result in correspondence with a predetermined item.

[0007]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 shows the circuit configuration thereof, and 1 is a key input section. The key input unit 1 is provided with a keyboard having various keys. When the various keys are operated, the key operation signals are input to the control unit 2.

The control unit 2 performs a control operation of the entire apparatus by a signal from the key input unit 1, and a table forming unit 3, a substituting unit 4, a calculating unit 5 and a searching unit 6 are provided therein. The tabulation unit 3 writes data for creating a table in the table memory 7, and the table memory 7 stores data having a configuration as shown in FIG. The calculation unit 5 appropriately reads out variable data from the variable memory 8 to perform calculation, and sends the calculation result data to the table memory 7 and the variable memory 8. The retrieval unit 6 retrieves and reads the official data from the official dictionary memory 9 storing a large number of official data as shown in FIG. 4 in a timely manner. The read official data is stored in the official buffer 10. Sent.

The official buffer 10 stores and holds the official data from the retrieval unit 6, and also outputs the official data to the variable memory 8, the calculation unit 5, and the display control unit 11. The variable memory 8 stores a large number of variable data as shown in FIG. 8, and the variable data is input and set by the signal input from the substituting unit 4.

The display control section 11 is operation-controlled by input signals from the key input section 1 and the control section 2, and displays the table data stored in the table memory 7 and the official data stored in the official buffer 10 on the display section 12. The display will be driven.

Next, the operation of the above embodiment will be described. FIG. 2 is a flow chart showing the operation of the entire table processing. At the beginning of the operation, first, a table is created as shown in step A01. This table creation is performed by the table creation unit 3, and for example, a table as shown in FIG. 3 (A) is created, but since the technique is known, the description thereof is omitted.

FIG. 3A shows a record ("R" in the figure).
It is a table in which the number of items C (referred to as “C”) is 3 and the number of items (referred to as “IT” in the drawing) is 10. Records 1-3
Represents the respective companies A, B, and C, and items 1 to 10 corresponding thereto are ordinary (profit), capital, total capital, equity capital, return rate of capital and its evaluation, equity capital, respectively. It shows the rate of return and its evaluation, and the rate of return on total capital and its evaluation. These table data are stored in the table memory 7.

When the table creation is completed, the next step is A02.
An official search is performed as shown in. By operating the search key and set key of the key input unit 1,
The search unit 6 appropriately searches for official data from the official dictionary memory 9 and inputs and sets it in the official buffer 10.

The official dictionary memory 9 stores data as shown in FIG.
Area 9 is composed of three areas A, 9B and 9C.
The formula is written in A, the formula corresponding to the stored contents of the variable memory 8 is written in the area 9B, and the reference value and the up / down judgment code for the evaluation are written in the area 9C.
This indicates that, for example, when the data “30 ↑” is written, if the reference value is “30” or more, the evaluation is “◯”. Further, when the up / down determination code is “↓”, the evaluation is “◯” when it is less than the reference value.

FIG. 5 shows the detailed operation processing of this official search. First, when the search key is operated as shown in step B01, the leading address of the official dictionary memory 9 is designated in the following step B02. .. Then step B
As shown in 03, the official data at the designated start address, for example, Sihon Riekiritsu = (Katsune / Sihon) × 100, is read and input to the official buffer 10.

In the next step B04, the formula input to the formula buffer 10 by the display control unit 11 is displayed at the bottom of the table on the display screen of the display unit 12. Display 12
When the formula is displayed on the screen, the user follows the step B05.
At, the search key or the set key of the key input unit 1 is operated. This is to operate the set key when the displayed formula is the desired formula and to operate the search key when the displayed formula is not the desired formula. When the set key is operated, the official search process ends. Also,
When the search key is operated, the process proceeds to step B06, the designated address of the official dictionary memory 9 is updated, and then the operation from step B03 is repeated to search for another formula.

When the official search is completed, the next step A0
In step 3, each item is substituted. FIG. 6 is a flowchart showing the detailed operation processing of the item substitution, and the operation control is performed by the substitution unit 4.

At the beginning of the operation, first, as shown in step C01, the first official variable, for example, "Shonri Ekiritsu" is highlighted on the display unit 12. Next, when the item corresponding to the variable highlighted in step C02, for example, "IT5" is input, the data indicating the item is input to the variable memory 8 in the next step C03.

In this case, on the display unit 12, as shown in FIG. 7, the official first variable "Siphon Riekitsu" displayed at the bottom of the table and the corresponding item "I"
Both "T5" will be highlighted.
The variable memory 8 into which items are input is 8 as shown in FIG.
It is composed of areas A and 8B, and M1, M2, and M used for the area 9B of the official dictionary memory 9 in the area 8A.
Numerical data of variables corresponding to 3, ... Is input, and data indicating the items in the table corresponding to the variable data of area 8A is input to area 8B. "IT5" entered above is , Is stored in a position corresponding to M1 in area 8B.

Then, in step C04, items for the second and subsequent variables of the formula are substituted in the variable memory 8 in the same manner as in steps C01 to C03. When the item for each variable is completed, next, in step C05, "Evaluation?" Is displayed on the display unit 12 in order to prompt input of an item for evaluating the formula calculation result. When the item to be evaluated is input in the next step C06, this input data is written in the position corresponding to M8 in the area 8B of the variable memory 8 in the following step C07, and the official item input is completed. finish.

When the above item input processing is completed, the table is calculated as shown in the next step A04. 9 for the detailed operation of this calculation, and FIG. 10 for the state of the variable memory 8 at that time.

FIG. 10 (A) shows the storage state of the variable memory 8 after the above item substitution is completed. For the calculation of "Siphonri Equiritsu" shown in FIG. 4, "IT5" is added to the M1 position. , M2 position is "IT1" and M3 position is "I".
"T2" is set, and "IT6" is set at the M8 position. Here, as shown in step D01 of FIG. 9, the formula M1 = (M2 / M3) × 100 is calculated from the formula buffer 10.

Is read out and written in the calculation unit 5. Based on this calculation formula, the calculation unit 5 calculates the item "I" at the position of M1, M2, M3 from the variable memory 8 in the next step D02.
T5, "IT1" and "IT2" are read and the correspondence between the calculation formula and the item is set. That is, IT5 = (IT1 / IT2) × 100

As a result, the capital profit ratio of item 5 is calculated from the numerical data of the ordinary (profit) of item 1 and the capital of item 2 in the table. In the following Step D03, first, the record 1 in the table
Is specified. According to the designated record 1, numerical data are read out from the table memory 7 from the items "IT1" and "IT2" of the record 1 in the next step D04, and calculation is performed.

In this case, the variable memory 8 is stored in FIG.
As shown in 0 (B), "IT1" is placed at the positions of M2 and M3.
As numerical data of “IT2”, for example, “06” [20
0 "is input, and the data" 50 "is input to the position of M8 as the reference value of" IT6 ".

When the calculation is completed, the calculation result "30"
Is input to the M1 position of the variable memory 8 as shown in FIG. Thereafter, in step D05, the calculation result is compared with the reference value at the position M8 of the variable memory 8 from now on. Then, according to the comparison result, as shown in the next step D06, the symbol code of "○" or "x" indicates that the item "I" designated by M8 of the variable memory 8 is "I".
According to "T6", the information is input and set in "IT6" of the table memory 7 and displayed on the display unit 12. In this case, since the calculation result is “30” and the reference value is “30 ↑”,
It becomes "○".

Since the table calculation in the record 1 of the formula is completed as described above, in the next step D07, the above steps D01 to D are performed for the records 2 and below.
The same processing as 06 is performed.

Then, at the time when the table calculation is completed for the record 2 and the record 3, as shown in FIG. 10 (D), the variable memory 8 is subjected to the table calculation according to the following formula.
When a new item is set and the spreadsheet calculation and the evaluation of the result are completed in the same manner, the display unit 12 is displayed as shown in FIG.
The table as shown in (B) is completed. In addition, in the above-described embodiment, the calculation is performed for the items in one record,
You may perform the calculation regarding the record in 1 item.

[0029]

As described above in detail, according to the present invention, when a spreadsheet is performed, the evaluation according to the computation result can be displayed together, so that the utility value of the spreadsheet calculation result is increased.

[Brief description of drawings]

FIG. 1 is a block diagram showing a circuit configuration according to an embodiment of the present invention.

FIG. 2 is a flowchart showing the overall operation processing contents mainly by the control unit of FIG.

FIG. 3 is a diagram showing stored contents of a table memory shown in FIG.

FIG. 4 is a diagram showing the contents of the official dictionary memory of FIG.

5 is a flowchart showing the operation contents of the official search of FIG.

FIG. 6 is a flowchart showing the operation contents of item substitution in FIG.

FIG. 7 is a diagram showing a display state of a display unit when an item is assigned.

FIG. 8 is a diagram showing a configuration of a variable memory shown in FIG.

9 is a flowchart showing the operation contents of the calculation of FIG.

FIG. 10 is a diagram showing changes in the contents of a variable memory with respect to spreadsheet calculation.

[Explanation of symbols]

1 ... Key input section, 2 ... Control section, 3 ... Table creation section, 4 ... Substitution section, 5 ... Calculation section, 6 ... Search section, 7 ... Table memory, 8 ... Variable memory, 9 ... Official dictionary memory, 10 ... Official buffer, 1
1 ... Display control unit, 12 ... Display unit.

Claims (1)

Claim: What is claimed is: 1. A table processing device having a tabulation function, a reference value storage means for storing a reference value for evaluating data displayed in a predetermined item of a created table, An evaluation means for evaluating the data displayed in the predetermined items of the table with reference to the reference value; and an evaluation result display means for displaying the evaluation results of the evaluation means in correspondence with the predetermined items of the table. A table processing device comprising: