JPH045757A - Table calculating formula automatic discriminating system - Google Patents

Abstract

PURPOSE:To attain the high speed of a calculating processing by assigning plural formulas as functions as a copying source and using a result to analyze the regularity of the plural calculating formulas for the calculation processing of other coordinates. CONSTITUTION:When a copying indication is inputted to a processor 10, a copy processing part 11 and a calculating formula copying means 110 are actuated. When the means 110 receives a regularity function including the coordinates of plural calculating formulas in which the calculating formulas are stored in advance as the input of a copying source, it stores the function in the assigned copying source with the calculating formula of a table 12. When copying is finished, an analyzing means 111 is started, the calculating formula stored in the plural coordinates included in the regularity function to represent the regularity of the copying source is taken out from the table 12 and the regularity including relation with a coordinate value is led from the plural calculating formulas. A calculating means 113 calculates the coordinates of the copying source based on the regularity and stores a calculated result in the table 12.

Description

[Detailed Description of the Invention] [Summary] To provide an automatic spreadsheet discrimination method in an information processing device that does not require a user to input for correction when copying a calculation formula. The purpose is to provide a table with coordinates for storing multiple parameter values for spreadsheet calculations, calculation formulas, and coordinates for storing calculation results. The copy processing unit stores functions including coordinate values in advance and is activated upon receiving a copy start instruction.

calculation formula copying means that, when the coordinates where the function is stored as a copy source is specified, extracts the function from the copy source and copies the function to the coordinates of each copy destination specified by inputting a copy destination instruction; an analysis means that analyzes whether or not coordinate correction is necessary for a plurality of coordinate calculation formulas included in the function; a calculation formula generation means that generates a general formula that does not include coordinate values based on the results of the analysis means; and a total of one means for executing calculations of each calculation formula copied to each copy destination based on the general formula obtained.

[Industrial Field of Application] The present invention relates to a spreadsheet automatic discrimination method in an information processing device.

In recent years, spreadsheet calculations have been widely used in small-sized information processing devices such as personal computers. Therefore, when using regular calculation formulas in other places, a method is used in which a calculation formula that has already been registered is copied.

However, the operation becomes complicated because the user is required to specify whether or not to correct the coordinates where the variables to be actually referenced are stored.

[Conventional technology] The function of copying calculation formulas in conventional spreadsheet calculations will be explained.

FIG. 5 is an explanatory diagram of a conventional example, and FIG. 6 shows a processing flow of the conventional example.

In the table of Figure 5, 1 to 51 (00
Numerical values or characters are stored in each line (displayed as 01 to 0051) as shown in the figure (only some are shown). In the diagram A
The second row of the column (referred to as coordinate A2) contains the numerical value of the standard amount, and the coordinate C
4 (column C, row 4) ~ Coordinate C50 is the unit price value, coordinate D4
~Coordinates D50 each store a numerical value of the number of objects.

In the example shown in the figure, the last column E has coordinates E4 and A2+ as shown in the figure.
A calculation formula that refers to the value stored in another coordinate called (C4 water D4) as a variable is stored in 1 other row E5
．． It is assumed that no calculation formula is stored in E6.

Note that this column E is provided with an area for storing calculation formulas and an area for storing the results of calculations to be executed later.

The copying function and calculation process flow for calculation formulas of E5 and below will be explained with reference to FIG. 6 for the table shown in FIG.

In FIG. 6, Ml is a calculation formula storage unit, M2 is a calculation result storage unit, and a copy function is used to copy the calculation formula currently stored in a part of the calculation formula storage unit M1 to other coordinates. is started by operating the copy key. First, the copy source is designated (FIG. 6, 70). In the example of FIG. 6, the location @E4 is designated as the copy source.

Next, calculation formula retrieval is performed, and the calculation formula (formula A) for the coordinates designated as the copy source is retrieved from the calculation formula storage section M1 (71). Next, a process is performed in which the user specifies the copy destination of the calculation formula (72). In the example of FIG. Ru.

When this copy destination is specified, the calculation formula retrieved from the copy source first refers to bonds stored at other coordinates, so the user must check whether or not correction is necessary for that coordinate. Coordinate correction can be specified by specifying (73). To explain this process using the example of FIG. 6, the copy source (formula A) is A
2+C4XD4, and the values of each coordinate A2C4 and D4 included in this copy source formula are displayed on one display. For each of these coordinate values, the user specifies for each copy destination whether correction is necessary or not and whether correction is necessary.

For example, when the copy destination is E5, A2 makes an input indicating that no correction is necessary, and C4 and D4 make inputs indicating that correction is necessary.

Correction processing corresponding to this coordinate correction input is performed and C4→
Coordinate correction of C5, D4 → D5 is performed (74)
When the corrected formula (8) is obtained, it is stored in the calculation formula storage section M1 (75). Below, each other copy destination E
Similarly, for coordinates 6 to E50, the coordinates are corrected by correction input and the corrected equations are stored.

When the copying of the calculation formulas is completed, calculations using each calculation formula are executed first (see 76). This calculation involves taking out numerical values at the coordinates designated by the calculation formulas and performing calculations according to the formulas. The calculation result is stored in the calculation result storage section M2 (77). The calculation result is displayed on the display device (step 78) and the process ends.

[Problem R1 to be Solved by the Invention According to the above-described conventional method, it is necessary for the user to input coordinate correction designation. In other words, the user must judge whether or not it is necessary to correct other coordinates (A2, C4, D4, etc.) referenced in the copy source formula, but the meaning of "correction" in this case is However, there was a problem in that the operation was extremely complicated, even in cases where the user did not understand.

SUMMARY OF THE INVENTION In order to solve the above-mentioned problems, it is an object of the present invention to provide an automatic spreadsheet formula discrimination method that does not require the user to input correction information when copying a calculation formula.

[Means to solve the problem] FIG. 1 is a diagram showing the basic configuration of the present invention.

In FIG. 1, 10 is a processing device, 11 is a copying processing unit that is activated upon input of a copying instruction, 110 is a calculation formula copying means for copying a calculation formula from a designated copying source to a designated copying destination, and 111 is a copying unit. Analysis means for analyzing the original function, 11
2 is a calculation formula generating means for generating a calculation formula including a (variable) term that requires correction and a song that does not require correction based on the analysis result; 11
3 is a calculation means for executing numerical calculations for each calculation formula of the copy source and copy destination; 12 is a parameter area in which characters and numbers for spreadsheet calculation are stored corresponding to each coordinate; an area for storing each calculation formula; This is a table (memory) consisting of an area where calculation results are stored.

The present invention specifies a plurality of calculation formulas as functions as copy sources, analyzes the regularity of the plurality of calculation formulas, and makes it possible to use the results in other coordinate calculation processes.

[Operation] In FIG. 1, when a copy instruction is input to the processing device IO, ? j[Ear processing section 11 starts up. When activated, the calculation formula copying means 110 operates. Calculation formula copying means 110
receives a regularity function including the coordinates of a plurality of calculation formulas whose calculation formulas are stored in advance as an input to a copy source, and stores the function in the copy source designated by the calculation formula in table 12.

This regularity function is a function that can be converted into a calculation formula, and the conversion result differs depending on the coordinates where the calculation formula including this function is stored, and the coordinates to be referred to are determined by the calculation means. The method of use is as follows.

When a copy destination is specified following a regularity function (coordinate a, coordinate b [, ... coordinate n]), the regularity function stored in the copy source is sequentially transferred to each copy destination as is. Store(
Copy).

When the copying is completed, the analysis means 111 is activated, retrieves from the table 12 the calculation formulas stored in the plurality of coordinates included in the regularity function representing the regularity of the copy source, and calculates the relationship between the coordinate values and the plurality of calculation formulas. Deriving regularities including relationships. That is, it is analyzed whether the numerical value in the calculation formula changes depending on the coordinates (a numerical value that requires correction according to the coordinates) or is unrelated to the coordinates (a constant numerical value (a numerical value that does not require correction according to the coordinates).

Through this analysis, if regularity is found from a plurality of calculation formulas, then calculation formula generation means 112 generates a calculation formula representing the regularity. The calculation formula obtained by the calculation formula generation means 112 is 9
Next, it is input to calculation means 113 and a half-speed calculation is executed. In that case, first, the coordinates of the copy source are calculated using a regularity calculation formula. In other words, 5 each variable of the plurality of coordinates of the copy source is extracted from the corresponding coordinate in the table 12, calculation is performed, stored in the coordinate of the calculation result in the table 12, and the calculation result is displayed on the display unit (not shown). be done.

[Example] Fig. 2 is a processing flow diagram of an embodiment, Fig. 3 is a detailed flow of regularity analysis processing, and Fig. 4 is an example of operation in a specific example and a display example of calculation results.

In FIG. 2, in a spreadsheet, for example, when copying is started by operating the copy key J, the designated manual input of the copying source is first performed. In this case, the user specifies the coordinates where the regularity function is stored as the copy source by key operation (Fig. 2, 20). This copy source function of order 0, which is a function consisting of Then (same 22
), the function is sequentially stored in the calculation formula storage section m1 of each coordinate of the copy destination by the calculation formula storage process (23).

To explain the flow up to now using a specific example shown in Fig. 4, in the table shown in Fig. 4, A
2+ (C4*D4) is stored, and A2+ is stored at the coordinate E5.
(C5*D5) is stored, and as a regularity function including coordinates E4 and E5 where these multiple calculation formulas are stored,
A function (name) "rRULE(E4.E5)" is stored at the coordinate E6.

In the second state, if you input to specify E6 as the copy source, the function of E6 will be extracted and the function will be assigned to E7 to E5 as the copy destination.
is specified, the function rl? ULE (E4, E5)
J is stored in the formula storage section for each coordinate E7 to E50.

Next, when the one calculation formula storage process is completed in FIG. 2, it is determined whether the stored calculation formula is a regularity function or not (FIG. 2 24). If it is a regularity function, analyze its regularity and determine which items are related to the coordinates and which items are not related to the coordinates (constants).
), once the results of this analysis are obtained, a calculation formula generation process is performed (26). This calculation formula generation process generates items representing the bonds of parameters according to the coordinates of the calculation formula, based on the results of the regularity analysis process. For items that do not change, the coordinates in which the fixed values are stored are used, and for items that change, an expression is generated that expresses the change in the form of a general expression.

The details of the regularity analysis process in step 25 in FIG. 2 are shown in FIG. 3 and will be described below.

First, set 1 to specific register 1 (Figure 3, 30)
1 of multiple calculation formulas specified by the 0th order regularity function
31) Determine whether A holds true for the item (32). This A is shown in the lower part of Figure 3, and the i-th item is a constant value, or the i-th item of the calculation formula stored in the first reference coordinate and the second reference coordinate are stored. This is to determine whether the first item of the calculation formulas are the same. If it holds true, it is treated as no correction (because it is a constant). If it does not hold true (no), then in the next step 33, determination of B is made. In this B, as shown in FIG. 9, 1. At the same time that the row number of the first reference coordinate and the row number of the first item of the calculation formula stored in the first reference coordinate match, the second
It is determined whether the row number of the reference coordinates and the row number of the i-th item of the calculation formula stored in the second reference coordinates match.

If this is true, the first item is processed as a row correction (correction corresponding to the row number of the table). If the judgment in step 33 is not established (in case of no), 1
Next, in step 34, a determination of C is made.

As shown in Figure 1, the judgment of C in this step 34 is that the column number of the first reference coordinate is different from the column number of the first item of the calculation formula stored in the first reference coordinate, and at the same time the second reference coordinate is It is determined whether the column number of the coordinates matches the column number of the first item of the calculation formula stored in the first and second reference coordinates. If this is true, the first item is processed as column correction (correction corresponding to the column number of the table).

In step 35, i is incremented by 1 and the processing from step 31 onward is repeated for the next item.

Applying the process shown in FIG. 3 to the specific example shown in FIG.
The two functions are E4. E5, and each calculation formula is
The first item A2 is 1-
1 (first item), the first of the calculation formulas stored in the first reference coordinate E4 and the first of the calculation formulas stored in the second reference coordinate E5 in the judgment of A in step 32. Since both are "A2", it is processed as an item without correction. Next, in the case of 1-2, the line number (-4) of the first reference coordinate E4 and the line number (-4) of the second item (C4) of the calculation formula stored in the first reference coordinate are the same. Then, the row number (=5) of the second reference coordinate E5 and the second reference coordinate (E5
), the line number (-5) of the second item (C5) of the formula stored in the formula matches the line number (-5), so it is processed as requiring one line correction. Hereinafter, in the case of 1-3, the third item D4. D5 is also judged in the same way and processed as a 3-line correction.

When analysis is performed in this way, calculation formula generation processing (second
In 26) of the figure, the following calculation formula is generated as a general formula.

En=A2+ (Cn*Dn) Returning to the second part, when a calculation formula is generated by the calculation formula generation process, the primary calculation process is executed. This calculation process extracts the numerical data of the coordinates of each item from the corresponding coordinate position in the table (see Figure 4) according to the calculation formulas stored in the coordinates of the calculation formula of the copy source and the coordinates of the calculation formula of the copy destination. Calculations are made (Figure 2, 27).

To explain the example in Figure 4, in the case of the copy source coordinate E6, the function rRULE(E4.E5) J is r
Each coordinate A2. The coordinate values of C6 and D6 are taken out from the table, r5000+(3000XIO)J is calculated, and the result is stored in the calculation result storage section. Also, for each copy destination E7 to E50, calculations using rRULE(E4.E5)J stored in each calculation formula storage section are executed using the above general formula, and the calculation results are converted to It is stored in the storage section m2. When the calculation is completed, the result is displayed (29) and the process ends.

[Effects of the Invention] According to the present invention, it is possible to automatically determine coordinate correction without inputting an instruction for coordinate correction, which was conventionally specified by a user, and to speed up spreadsheet calculation.

[Brief explanation of drawings]

Part 1 is a diagram of the principle configuration of the present invention, Figure 2 is a processing flow diagram of an embodiment, Figure 3 is a detailed flow of regularity analysis processing, and Figure 4 is a table of operation examples and calculation results based on specific examples. As an example, FIG. 5 is an explanatory diagram of a conventional example, and FIG. 6 is a processing flow of the conventional example. 10 in Figure 1: Processing device 11: Copy processing section 110: 1 Summer type copying means 111: Analysis means 112: Calculation formula generation means 113: Calculation means 12: Table Patent creator: Bfn Co., Ltd. (one other person) Representative Patent Attorney Kazuo Hosaka Fig. 2 Processing flow diagram of the embodiment Example of operation and display of calculation results in a concrete example Tube diagram Explanation diagram of the conventional example Fig. Judgment B Judgment C Detailed flow of regularity analysis processing of the conventional example Processing flow section 6

Claims (1)

[Scope of Claim] A spreadsheet automatic discrimination method in an information processing device, comprising a table (with coordinates storing a plurality of parameter values for spreadsheets, calculation formulas, and coordinates storing calculation results).
12), a copy processing unit (11) which stores in advance a function including the coordinate values of a plurality of calculation formulas at a coordinate position from which the calculation formulas are to be copied, and which is activated by a copy start instruction, uses the above-mentioned function as a copy source. When the coordinates where are stored are specified,
calculation formula copying means (110) for extracting the function from the copy source and copying the function to the coordinates of each copy destination designated by inputting a copy destination instruction; Analysis means (
111), calculation formula generation means (112) for generating a general formula that does not include coordinate values based on the results of the analysis means;
1. A spreadsheet automatic discrimination method, comprising: calculation means (113) for calculating each calculation formula copied to each copy destination based on the generated general formula.