JPH0786889B2 - Table processor - Google Patents

Description

Description: TECHNICAL FIELD The present invention relates to a table processing device for performing table calculation on table data in which table items are arranged in a plurality of rows and a plurality of columns.

[Prior Art] Conventionally, in a table processing device of an electronic device having a tabulation function,
When creating a table on the display screen and performing totalization processing, first specify the number of rows in the table, that is, the number of records, the number of columns, that is, the number of items, and the number of digits in each item area defined by this record and item. As a result, a table was created, and then the table was tabulated.

That is, in the table processing apparatus of this type, by inputting the calculation formula using the item name of the created table, the item data of the table can be calculated according to the calculation formula.

[Problems to be Solved by the Invention] However, in the above-described table processing device, the spreadsheet formula used for the calculation is often determined according to the work content of each user, and a large number of tables are required. When a spreadsheet is calculated using a formula, the spreadsheet formula must be entered each time, which is very troublesome.

Also, there is a table calculation formula that allows you to easily set a calculation formula using a function, but only the function commands (@AVE, @SUM, etc.) can be automatically input here, so the table data A spreadsheet formula in which variable names for specifying individual table items in are combined by various arithmetic operators, for example, a spreadsheet formula such as "C20 + D20" or "A1 +
In order to input a spreadsheet formula in the form of a formula, such as @SUM (B1: D2) ”, not only the variable name, but also“ + ”,
It was necessary to manually input all four arithmetic operators such as "-", "/", and "*".

Also, in the case where the calculation formula by the above function can be set easily, how to input the parameter (variable name) as the parameter (variable name) to be input after the function command, and how many Is it okay? A specific rule for parameter input (For example, in the case of a function command of "@SUM", if you want to "take the total from A1 to G1", immediately after the above function command, "( The operator had to know in advance all the rules such as "A1: G1)".

An object of the present invention is to confirm the contents of a spreadsheet formula that is stored in advance by a variable name and four arithmetic operators and then easily set a new formula using the spreadsheet formula. To do so.

[Means for Solving the Problems] Means of the present invention are as follows.

Display means for displaying table data in which table items are arranged in a plurality of rows and a plurality of columns on a display screen, and a variable name for designating each table item in the above table data in a one-to-one correspondence , Storage means for storing a spreadsheet formula in a form of expression in which these individual variable names are appropriately combined by various four arithmetic operators, and a spreadsheet formula stored in the storage device according to a predetermined operation. So that the formula form of the spreadsheet formula can be understood, an expression guidance display means for displaying guidance for each variable name and each of the four arithmetic operators included in the spreadsheet formula in the combined state of the above settings, and In each table item included in the table data, the designation means for specifying the table item that should display the calculation result according to the above table calculation formula, and each variable name included in the above table calculation formula, the individual variable name For each, the number of calculation objects in the above table data Data on the individual table entry that stores 1
When executing the calculation according to the above-mentioned spreadsheet and the associating means associated with one-to-one correspondence, the numerical data in the table items associated by the above-mentioned associating means are read in the above-mentioned table data, and the numerical data Is used as data corresponding to a variable name included in the spreadsheet formula, and a computing means for performing a computation in accordance with the formula form in the spreadsheet formula, and a computation result by the computing means are arbitrarily designated by the designating means. And display control means for controlling the data to be displayed on the display screen as data corresponding to the table item.

[Operation] The operation of the means of the present invention is as follows.

The formula guidance display means reads out the spreadsheet formula stored in the storage means in response to a predetermined operation, and the individual variable names and individual four rules included in the spreadsheet formula are identified so that the formula form of the spreadsheet formula can be understood. Guidance is displayed for the operator in the combined state of the above settings. Then, the calculation means, when executing the calculation according to the above spreadsheet formula, reads the numerical data in the table item associated with each variable of the above spreadsheet formula in the above spreadsheet data, and reads this numerical data as described above. As the data corresponding to the variable name included in the spreadsheet formula, the operation according to the formula form in the above spreadsheet formula is executed. Then, the calculation result is displayed on the display screen as data corresponding to the arbitrary table item designated by the designating means.

Therefore, a pre-stored formula-based spreadsheet (ie,
After confirming the contents of the table calculation formula, which is set by combining the variable names for individually specifying the individual table items in the table data with various quaternary operators, on the guidance display, display the table of the formula form. You can easily set a new spreadsheet formula for the above table data using the formula as it is, and you can immediately perform the spreadsheet calculation based on this simple setting. The calculation result display target can be displayed at the position of the table item.

[Embodiment] An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 shows a circuit configuration of the table processing device of the present invention.
Reference numeral 1 is a key input unit. 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 section 2 controls the apparatus by a signal from the key input section 1, and has a table section 3,
An assignment unit 4, a calculation unit 5, and a search unit 6 are provided. The tabulation unit 3 writes data for creating a table in the table memory 7, and the table memory 7 stores the tabular data having a structure 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.
The read official data is sent to the official buffer 10.
The formula buffer 10 stores and holds the formula data from the search unit 6, and also outputs the formula data to the variable memory 8, the calculation unit 5, and the display control unit 11. Variable memory 8
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 drives the display unit 12 to display the table data stored in the table memory 7 and the official data stored in the official buffer 10. It is something you will come to do.

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, for example, as shown in FIG. 3 (A), but since the technique is known, the description thereof is omitted. Figure 3 (A)
Is a table in which the number of records (called “RC” in the figure) is 3 and the number of items (called “IT” in the figure) is 10. Records 1 to 3 represent company A, company B, and company C, respectively, and items 1 to 10 corresponding thereto are ordinary (profit), capital, total capital, equity capital, return on capital, and their evaluation, respectively. , Return on equity and its evaluation, return on total capital and its evaluation. These table data are stored in the table memory 7.

When the table creation is completed, an official search is next performed as shown in step A02. In this, by operating the search key and the set key of the key input unit 1, the search unit 6 appropriately searches the official dictionary memory 9 for official data, and inputs and sets it in the official buffer 10. As shown in FIG. 4, the official dictionary memory 9 is composed of three areas 9A, 9B and 9C. The area 9A contains the formula and the area 9B contains the formula corresponding to the stored contents of the variable memory 8. In the area 9C, a reference value for evaluation and its up / down judgment code are written. This indicates 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 check key is operated as shown in step B01, the leading address of the official dictionary memory 9 is designated in the following step B02. Next, as shown in step B03, the official data at the designated start address, for example, Sihon Rieki Kiritsu = (Katsune / Sihon) × 100, is read out and input to the official buffer 10. In the next step B04, the display control unit 11 causes the official buffer 10
The formula entered in is displayed at the bottom of the table on the display screen of the display unit 12. When the formula is displayed on the display unit 12, the user operates the search key or the set key of the key input unit 1 in the following step B05. 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 therewith. If 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 process proceeds to step A03, and each item is substituted. FIG. 6 is a flow chart 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. Then step C0
The item corresponding to the variable highlighted in 2, eg "IT5"
If you enter, the data indicating the item will be displayed in the next step C0.
It is input to the variable memory 8 at 3. In this case, in the display unit 12, as shown in FIG. 7, both the official first variable “Sihon Riekitsu” displayed at the bottom of the table and the corresponding “IT5” entered in the item are highlighted. It comes to be.

The variable memory 8 into which items are input is as shown in FIG.
It is composed of two areas, 8A and 8B. Numerical data of variables corresponding to M ₁ , M ₂ , M ₃ ... used in area 9B of the official dictionary memory 9 is input to area 8A, and area 8B is filled with numerical data.
Data indicating the items in the table corresponding to the variable data of 8A is input, and "IT5" entered in the above item
Is stored in a position corresponding to M ₁ in area 8B. Next, in step C04, items for the second and following official variables are substituted into the variable memory 8 in the same manner as in steps C01 to C03. Then, when the item input for each variable is completed, in step C05, the display unit 12 is prompted in order to prompt the user to input the item for evaluating the formula calculation result.
Is displayed on the screen. On the other hand, if the item to be evaluated is input in the next step C06, this input data will be stored in the area 8 of the variable memory 8 in the following step C07.
It is written in the position corresponding to M ₈ of B, and the official item input is completed.

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. For the calculation of “Siphonry Ekiritsu” shown in FIG. 4, “IT5” is added to the M ₁ position. , IT ₂ in the M ₂ position, IT _{2 in} the M ₃ position and IT in the M ₈ position.
6 ”is set. Here, as shown in step D01 of FIG. 9, the formula M ₁ = (M ₂ / M ₃ ) × 100 is read from the formula buffer 10 and written in the calculator 5. According to this calculation formula, the calculation unit 5 stores M in the variable memory 8 in the next step D02.
Read the items "IT5", "IT1", and "IT2" at the positions of ₁ , M ₂ , M ₃ and set the correspondence between the calculation formula and the items. That is, IT5 = (IT1 / IT2) × 100, which allows the return on capital of item 5 to be calculated from the numerical data of the ordinary (profit) of item 1 and the capital of item 2 in the table. Becomes In the following step D03, first, record 1 in the table is designated.
According to the designated record 1, in the next step D04, the items “IT1” and “I
Numerical data is read from "T2" and calculation is performed. In this case, in the variable memory 8, as shown in FIG. 10 (B), for example, “60” and “200” are input as the numerical data of “IT1” and “IT2” at the positions of M ₂ and M ₃ , and Numerical data “50” is input to the position of M ₈ as a reference value of “IT 6”. When the calculation is completed, the calculation result "30" is
It is input to the M ₁ position of the variable memory 8 as shown in FIG. Thereafter, in step D05, in turn compared with a reference value in the M ₈ position of the calculation result and the variable memory 8 is performed. Then, depending on the comparison result, the next step D06
As shown in, the symbol code of “○” or “×” is input and set in “IT6” of the table memory 7 and displayed on the display unit 12 according to the item “IT6” specified by M ₈ of the variable memory 8. To be done. In this case, the calculation result is "30" and the reference value is "30 ↑", so "○" is obtained. With the above, the table calculation in the record 1 of this formula is completed, and in the next step D07, the same processing as the above steps D01 to D06 is performed for the records 2 and below. Then, at the time when the table calculation for the record 2 and the record 3 is finished, a new item is set in the variable memory 8 to perform the table calculation by the following formula as shown in FIG. Similarly, when the table calculation and the evaluation of the result are completed, the table as shown in FIG. 2B is completed on the display unit 12.

In addition, in the above embodiment, the calculation is performed for the item in one record, but the calculation for the record in one item may be performed.

〔The invention's effect〕

According to the present invention, when setting a new spreadsheet formula for spreadsheet data, one desired spreadsheet formula is selected from a plurality of pre-stored spreadsheet formulas and the contents of the spreadsheet formula are set. It can be specified by switching as appropriate while checking, and while checking the specified spreadsheet formula on the display screen, correspondence between each variable name included in the spreadsheet formula and each desired table item of the above table data By specifying the suffix, it is possible to newly store and set the correspondence relationship between each variable name in the spreadsheet formula and the table item of the table data.

Then, the spreadsheet calculation process according to the newly stored spreadsheet formula can be immediately executed.

[Brief description of drawings]

The drawings show one embodiment of the present invention. FIG. 1 is a block diagram showing a circuit configuration, FIG. 2 is a flow chart showing the operation contents of the whole, and FIG. 3 is a diagram showing the storage contents of a table memory. FIG. 4 is a diagram showing the contents of the official dictionary memory, FIG. 5 is a flowchart showing the operation contents of the official search, FIG. 6 is a flowchart showing the operation contents of the item substitution, and FIG. 7 is the display of the display section at the time of the item substitution. FIG. 8 is a diagram showing a state, FIG. 8 is a diagram showing a configuration of a variable memory, FIG. 9 is a flowchart showing operation contents of calculation, and FIG. 10 is a diagram showing changes in contents of the variable memory with respect to table calculation. 1 ... key input section, 2 ... control section, 3 ... table creation section, 4 ...
... Substitution unit, 5 ... Calculation unit, 6 ... Search unit, 7 ... Table memory, 8 ... Variable memory, 9 ... Official dictionary memory, 10 ...
Official buffer, 11 …… Display control section, 12 …… Display section.

 ─────────────────────────────────────────────────── ─── Continuation of the front page (56) References JP-A-58-155468 (JP, A) JP-A-58-66150 (JP, A) "EPOCALC-J User's Guide (V2)" (1982) ) Panafacom Co., Ltd. P. 91-P. 92

Claims (1)

[Claims] 1. A display means for displaying table data in which table items are arranged in a plurality of rows and a plurality of columns on a display screen, and for specifying each table item in the table data individually in a one-to-one correspondence. A storage means for storing a plurality of table calculation formulas having variable names, which are set by appropriately combining these individual variable names by various arithmetic operators, and a plurality of table calculation formulas stored in the storage means. Of these, one table calculation formula to be read, and a spreadsheet calculation designating means for designating switching of the spreadsheet calculation formula to be read, and when one spreadsheet calculation formula is designated by the spreadsheet calculation formula designating means, The specified spreadsheet formula is read from the storage means, and the individual variable names and individual arithmetic operators included in the spreadsheet formula are read so that the formula form of the spreadsheet formula can be understood.
Displayed on the above display screen in the combined state of the above settings,
Every time the spreadsheet calculation formula designating means designates switching of the spreadsheet formula to be read, the spreadsheet formula designated after the switching is read from the storage means, and the read spreadsheet formula is switched. In place of the spreadsheet formula previously displayed on the above display screen, when the formula display means to be displayed on the above display screen and the confirmation of the spreadsheet formula to be set are specified, then on the above display screen at that time. Confirming means for confirming the spreadsheet calculation formula displayed in the table as the setting target spreadsheet formula, and the spreadsheet calculation formula confirmed by the confirming device are displayed on the display screen. Calculation result table that specifies the variable name corresponding to the above in the table calculation formula and arbitrarily specifies which table item among the table items included in the above table data the variable name corresponds to Item designation means, above In the state where the spreadsheet formula confirmed by the fixed means is displayed on the display screen, each variable name to be calculated is sequentially specified on the spreadsheet formula, and the individual variable names are Calculation target table item specifying means for arbitrarily specifying which table item corresponds to each table item included in the above table data, and the above calculation result table item specifying means, calculation target table item specification The correspondence relation storing means for storing the correspondence relation between each variable name designated by the means and each table item, and the above-mentioned table data among The numerical data in the table items associated by the calculation target table item specifying means is read, and this numerical data is replaced as the data corresponding to the variable name included in the spreadsheet formula of the above setting, and in the spreadsheet formula of the above setting. Performs operations according to formula form And a display control means for controlling to display the calculation result by the calculation means on the display screen as data corresponding to the table item associated by the calculation result table item designating means. A table processing device characterized by the above.