JPH0619788B2 - Table processor - Google Patents

Description

Description: TECHNICAL FIELD OF THE INVENTION The present invention relates to a table processing apparatus for an electronic device that creates a table on a display screen and performs tabulation processing.

[Prior Art and its Problems] Conventionally, in an electronic device such as a personal computer having a tabulation function, it is generally possible to set a column-based spreadsheet. For example, by setting gross profit, sales, and expenses in each column and entering sales and expenses data in each row, gross profit (A) = sales (B) -expenses (C), The gross profit is automatically calculated from sales and expenses. By the way, as a modification of the above calculation formula, two formulas of sales (B) = gross profit (A) + expense (C) expense (C) = sales (B) -gross profit (A) can be considered. If any one of the three values of gross profit, sales, and expense is unknown, the unknown value can be obtained by using any one of these three expressions.

However, the fixing and operation of the calculation formula in the conventional table processing apparatus as described above are fixed, and the variable term (A) is substituted for the left side and numerical data is substituted as shown in the first formula. Position the variable terms (B) and (C) on the right side, and set to obtain the value of the variable term (A) on the left side by substituting numerical data for the variable terms (B) and (C) on the right side. It is like this. Therefore, as described above, when the value of any one of the three variable terms (A), (B), and (C) is unknown, the second and third expressions are newly changed. There is a problem in that calculation has to be executed after setting and it takes time to register the calculation formula.

[Object of the Invention] The present invention has been made in view of the above circumstances.
An object of the present invention is to provide a table processing device having a function of obtaining one of the values of each item of the input-set calculation formula when it is unknown.

[Embodiment of the Invention] 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 includes a numeric key, an alphabetic key, and the like, a search key for searching for a desired calculation formula, and a set key for setting the desired calculation formula when the search key is searched. The input signals by these key operations are sent to the control unit 2. The control unit 2 performs a control operation according to a signal sent from the key input unit 1, and includes a table creating unit 3, a calculating unit 4, a substituting unit 5, a transformation formula selecting unit 6, and a searching unit 7 inside. The table creation unit 3 creates a table and performs an editing operation after creation, and the table data is output to the table memory 8. The table memory 8 stores and holds data for displaying a table by the data input from the table creation unit 3 and the calculation unit 4, and the stored contents are the calculation unit 4 and the display unit 9 described above.
Is output to. The calculation unit 4 executes table calculation in table processing, and receives data from the table memory 8, the transformation buffer 10 and the variable memory 11. This variable memory
As shown in FIG. 2, reference numeral 11 is composed of two areas 11A and 11B, and stores data corresponding to the items in the table at positions "M1" to "M8". Numerical data is stored in area 11A, and data representing item positions in the table is stored in area 11B. The substituting unit 5 is for substituting numerical data at the time of spreadsheet calculation, and based on the official data input from the official buffer 12, the variable memory
Write numerical data to 11. The transformation type selection unit 6
Selects a desired transformation formula in accordance with the numerical data input from the variable memory 11, and the output data thereof is sent to the transformation buffer 10. The search unit 7 inputs and outputs data to and from a formula dictionary memory 13 that stores a large number of formulas used in spreadsheets and their modified formulas, searches for a desired formula, and stores the searched formulas in the modified formula buffer 10. , And the modified formulas are sent to the formula buffer 12 respectively. The formula buffer 12 stores and holds the formula data from the search unit 7, and outputs the stored contents to the display unit 9 together with the substitution unit 5 described above. The display unit 9 displays the table and the formula used for the table calculation on the display screen according to the display data from the table memory 8 and the formula buffer 12 and the display control data from the control unit 2.

Next, the operation of the above embodiment will be described. FIG. 3 is a flow chart showing the overall operation processing of this table processing apparatus. At the beginning of the operation, the table creation unit 3 first writes the table data in the table memory 8 as shown in step A01. FIG. 4 exemplifies the created table. The number of rows (hereinafter referred to as “records”) is three, the number of columns (hereinafter referred to as “item”) is four, and item 1 (in the figure, “ IT1 "
Represents. The same shall apply hereinafter), “FV”, “PV” for item 2, “I” for item 3, and “N” for item 4. This is the compound interest formula FV = PV × (1 + I) ↑ N (“(1 + I) ↑ N” represents (1 + I) Nth power) (FV = total principal interest, PV: present price, I: interest rate , N: period). Record 1
(Indicated as "RC1" in the figure. Same below) A is 50
This is to calculate the total amount of principal and interest after 7 years with compound interest of 6% per year at an annual interest of 6%.
%, It is to find out how many years later the total interest amount will be 1 million yen. Also, C of Record 3 has an annual interest rate of 8% and the total amount of 1 million yen in 5 years Is to ask. Since the detailed operation required for this table creation process is a known technique, its description is omitted.

Next, in step A02, the retrieval unit 7 retrieves a desired formula required for spreadsheet calculation from the contents stored in the formula dictionary memory 13. FIG. 5 shows the detailed operation of this formal search. As shown in step B01, the formal search is started by operating the search key provided in the key input unit 1. When the official search is started, first, in the next step B02, the search unit 7 specifies the start address of the official dictionary memory 13. As shown in FIG. 6, the official dictionary memory 13 has the formula FA = PV × (1 + I) ↑ N, followed by variables corresponding to the stored contents of the variable memory 11 with each variable term of the formula as the left side. Formula M1 = M2 × (1 + M3) ↑ M4 M2 = M1 / (1 + M3) ↑ M4 M3 = (M1 / M2) ↑ (1 / M4) -1 M4 = LOG (M1 / M2) / LOG (1 + M3) A plurality of sets of official data are stored, and the specification of the start address means that the formula located at the start address is specified. Then, in step B03, the formula located at the specified start address is changed to the formula buffer.
Read to 12. Along with this, the formula is displayed on the lower portion of the display screen on the display unit 9 as shown in the next step B04. In step B05, which follows the displayed formula, the user operates the set key if the displayed formula is the desired formula required for spreadsheet calculation, and operates the search key if it is not the desired formula. Here, if the search key is operated, it means that the displayed formula is not the desired formula necessary for the spreadsheet, so the process proceeds to step B06, and the designated address of the official dictionary memory 13 is updated. Set
The operation from step B03 is repeated again. If the operated key is the set key, it means that the displayed formula was a desired formula necessary for spreadsheet calculation, so the process proceeds to step B07 and corresponds to the displayed formula. The modified formula is read into the modified buffer 10 and the process of this official search is terminated.

When the official search process is complete, the next step is A in Fig. 3.
As shown in 03, the substituting unit 5 assigns items for associating the input variable terms with the table items by the variable memory 11
To be done. FIG. 7 shows the operation of this item substitution in detail. When the operation is started, first, the official first variable displayed on the display unit 9 is highlighted in step C01. Therefore, in the next step C02, the item of the table corresponding to the highlighted variable is input by the key input unit 1. FIG. 8 shows the display unit 9 when this item substitution is performed. In the state where the first variable “FV” of the above formula FV = PV × (1 + I) ↑ N is highlighted, this “FV” is displayed. Corresponding to "(Item 1 (" IT in the figure
1) will be substituted. When the item is input, the item data input in the area 11B at the M1 position of the variable memory 11 is registered and set in step C03. The above operations from step C01 to step C03 are similarly performed for the second and subsequent variables in step C04, and when the item substitution and registration for all variables are completed, this item substitution process is terminated. It will be.

When the item substituting process is completed, next step A in FIG.
As shown in 04, the calculation unit 4 mainly performs the calculation related to the non-input items in the table. FIG. 9 shows the detailed processing of the calculation. When the operation is started, first, at step D01, the calculation formula M1 = M2 × input and set in the official buffer 12 at step B03 of the above-mentioned official search. (1 + M3) ↑ M4 is read into the calculation formula 4. Then, as shown in step D02, the item corresponding to the read formula is read. Here, the variable memory 11 has "IT1" to "IT" as items by the above item substituting process at the "M1" to "M4" positions of the area 11B as shown in FIG. 10 (A).
4 ”are input and set, the above calculation formula can be rewritten as the formula IT1 = IT2 × (1 + IT3) ↑ IT4. Next, in step D03, the first record, record 1 (“RC
1) is designated, correspondingly, in step D04, the numerical data (RC1, IT1) (RC1, IT1) of each item input to the record 1 from the table memory 8 (RC1, IT
2) (RC1, IT3) (RC1, IT4) is read. Then, of the four item data read in the next step D05, the item for which a numerical value has not been input is determined. If there is no data in the item, see Fig. 10 (B).
If it is "IT1" as shown in FIG. 11, the process proceeds to step D06, and the calculation is performed as it is in accordance with the calculation formula rewritten from the official buffer 12 in step D01 to the corresponding item in step D02. Then, the calculation result is written in the table memory 8 in the next step D07. If it is determined in step D05 that the item having no data is "IT2" as shown in FIG. 10 (C), the process proceeds to step D08, in which the first modification formula M2 = M1 from the modification formula buffer 10 is entered. / (1 + M3) ↑ M4 is read out, each variable term is rewritten to the corresponding item as in step D02 above, and then the calculation is performed in accordance with the calculation formula in step D09. Write to 9. In addition, the above step D05
When it is determined that the item having no data is “IT3” in step S10, the process proceeds to step D10, and the variable buffer
To read the second modified equation M3 = (M1 / M2) ↑ (1 / M4) −1, then rewrite each variable term to the corresponding item, and perform the calculation according to the calculation formula in step D11.
Then, the calculation result is written in the display unit 9 in step D07. In step D05 above, the item with no data is "I
If it is determined to be “T4”, then in step D12, the third modified expression M4 = LOG (M1 / M2) / LOG (1 + M3) is read from the modified buffer 10 and then each variable term is associated with the corresponding item. , And calculate according to the formula in step D13,
Then, the calculation result is written in the display unit 9 in step D07. At the time when the result of the calculation formula is written in the table memory 8 in step D07 as the data of the item that has not been input, the table processing in record 1 is completed. D04
The same processing as D13 is performed, and the operation of this table processing device is completed.

In the above embodiment, the calculation formula is set for each item and the non-input data in each record is calculated. However, the present invention is not limited to this, and the non-input data in each item may be calculated. May be.

Further, it is conceivable that the official dictionary memory 13 is composed of, for example, a RAM so that the official data to be stored can be rewritten instead of storing a plurality of official data.

〔The invention's effect〕

According to the present invention, even if the value of any one of the items of the table is unknown, it is not necessary to re-specify the calculation formula each time, it is possible to obtain an unknown value, Highly efficient table processing can be performed.

[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 diagram showing a configuration of a variable memory, and FIG. 3 is a flowchart showing an entire operation process,
FIG. 4 is a diagram showing the structure of the created table, FIG. 5 is a flow chart showing the detailed operation processing of the official search, FIG. 6 is a view showing the structure of the official dictionary memory, and FIG. 7 is the details of item substitution. FIG. 8 is a flowchart showing the display state of the display unit, FIG. 9 is a flowchart showing detailed operation processing of calculation, and FIG. 10 is a variable memory corresponding to the calculation processing of FIG. It is a figure which shows a memory state. 1 ... Key input section, 2 ... Control section, 3 ... Table creation section, 4
…… Calculator, 5 …… Substitute, 6 …… Transformation formula selector, 7 ・ ・ ・
… Search section, 8 …… table memory, 9 …… display section, 10 …… variable buffer, 11 …… variable memory, 12 …… formal buffer,
13 ... Official dictionary memory.

Continuation of front page (56) References JP-A-58-192144 (JP, A) JP-A-59-68038 (JP, A)

Claims (1)

[Claims] 1. A table processing device having a tabulation function, wherein a formula storage means for storing a formula required for table calculation of a created table, and an item for which numerical data of the table is not set are detected. And a numerical data input to the item detected by the detecting device, the numerical data input to the detected item is calculated by modifying the calculation formula stored in the calculation formula storage unit. A table processing device comprising: a calculating unit that calculates based on a calculation formula for performing the calculation; and a numerical data input unit that inputs the numerical data calculated by the calculating unit into the detected item. .