JPH0612430A - Table processor - Google Patents

Abstract

PURPOSE:To simplify a setting operation of a calculating expression at the time of table calculation. CONSTITUTION:At the time of executing a calculation, based on data of a table stored in a table memory 7, a formula is retrieved successively from a formula dictionary memory 9, and displayed successively on a display part 12 through a formula buffer 10. When a desired formula in these displayed formulas is selected and this formula and an item of the table in the table memory 7 are allowed to correspond to each other, its corresponding relation is stored in a variable memory 8. Subsequently, table data corresponding to a variable of the formula is read out of the corresponding position of the table memory 7, an operation conforming to the formula is executed, and a result of its operation is displayed in a desired position of the table.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table processing device for processing table data composed of a plurality of rows and a plurality of columns.

[0002]

2. Description of the Related Art In conventional table processing, it is known that an arbitrary calculation formula can be input and set at an arbitrary position in the table, and the table calculation can be performed according to the input and set calculation formula. There is.

[0003]

In order to perform the table calculation in the above table, conventionally, it is necessary to set a calculation formula in advance for a desired position in the table, and the calculation formula is required every time. Since it is necessary to manually input the calculation formula itself, there is a problem that the input setting operation becomes quite complicated. An object of the present invention is to make it possible to simplify the setting operation of the calculation formula in the spreadsheet.

[0004]

The means of the present invention are as follows. Table data storage means for storing table data composed of a plurality of rows and a plurality of columns, calculation formula storage means for storing a plurality of calculation formulas, display means for displaying each calculation formula stored in the calculation formula storage means, and Selection means for selecting any of the calculation expressions displayed by the display means, and reading the corresponding data in the table data based on the calculation expression selected by this selection means, and the selected calculation expression And a calculation means for performing calculation according to the above.

[0005]

The operation of the means of the present invention is as follows. The display means displays each calculation formula stored in the calculation formula storage means in order to perform the table calculation based on the table data stored in the table data storage means. When any one of the formulas displayed by the display means is selected by the selecting means, the corresponding data in the table data is read based on the selected formula and the selected one is selected. Performs calculation according to the calculation formula.

Therefore, when performing a table calculation based on table data, the table calculation can be performed only by selecting a previously stored calculation formula, and the setting operation of the calculation formula in the table calculation is simplified. Can be converted.

[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 controls the entire apparatus by a signal from the key input unit 1, and has a table forming unit 3, a substituting unit 4, a calculating unit 5 and a searching unit 6 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 and performs calculation, and the calculated result data is stored in the table memory 7 described above.
And to 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, and 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 unit 11 is operation-controlled by input signals from the key input unit 1 and the control unit 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 unit 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 creates a table as shown in FIG. 3 (A), for example, but since the technique is well known, its description 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
Represent companies A, B, and C, respectively, and items 1 to 10 corresponding thereto are ordinary (profit), capital, total capital, equity capital, return on equity and its evaluation, and 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 9 as shown in FIG.
Area 9 is composed of three areas A, 9B and 9C.
The formula is written in A, the calculation 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 means that, for example, when the data “30 ↑” is written, if the reference value is “30” or more, the evaluation is “◯”. In addition, 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 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, "Siphon Riekitsu" 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, in the display section 12, as shown in FIG. 7, the official first variable "Siphonri Ekiritsu" 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 in the area 8A, M1, M2 and M used for the area 9B of the official dictionary memory 9 are formed.
Numerical data of variables corresponding to 3, ... Is input, and data indicating items in the table corresponding to the variable data of area 8A is input to area 8B. “IT5” entered above is , Is stored in the area 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. On the other hand, if the item to be evaluated is input in the next step C06, this input data is written in a position corresponding to M8 in the area 8B of the variable memory 8 in the following step C07. finish.

When the above item input processing is completed, the table is calculated as shown in the next step A04. Refer to FIG. 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, and "IT5" is added to the M1 position for the calculation of "Siphonry Ekiritsu" shown in FIG. , 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 read from the formula buffer 10 and written in the calculator 5. According to this calculation formula, the calculation unit 5 calculates the items "IT5" and "IT" at the positions of M1, M2 and M3 from the variable memory 8 in the next step D02.
Read "1""IT2" and set the correspondence between the calculation formula and the item. That is, IT5 = (IT1 / IT2) × 100, whereby the capital profit ratio of item 5 can be calculated by the ordinary data (profit) of item 1 and the numerical data of the capital of item 2 in the table. Becomes In the following step D03, first, record 1 in the table is designated. According to this designated record 1, the next step D
04, each item of the record 1 from the table memory 7 "IT
Numerical data is read from "1" and "IT2", 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 numerical data" 50 "is input to the position of M8 as a 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 this formula is completed as described above, in the next step D07, the steps D01 to D for the records 2 and below are also performed.
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. 10D, in order to perform the table calculation by the following formula in the variable memory 8,
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-mentioned embodiment, although the calculation is performed for the items in one record,
You may perform the calculation regarding the record in 1 item.

[0027]

According to the present invention, when performing a table calculation based on table data, the table calculation can be performed only by selecting a previously stored calculation formula. The formula setting operation can be simplified.

[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 contents of the entire operation processing according to the embodiment.

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. 1.

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 the display unit at the time of item substitution according to the embodiment.

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 the variable memory with respect to the table calculation according to the embodiment.

[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)

[Claims] 1. A table data storage unit for storing table data consisting of a plurality of rows and a plurality of columns, a calculation formula storage unit for storing a plurality of calculation formulas, and each calculation formula stored in the calculation formula storage unit. Display means, selection means for selecting an arbitrary calculation formula from the calculation formulas displayed by this display means, and reading the corresponding data in the table data based on the calculation formula selected by this selection means, A table processing device comprising: a calculation unit that performs calculation according to the selected calculation formula.