JPH0281226A - Calculation processor - Google Patents

Abstract

PURPOSE:To correct data so that no contradiction is generated in a result of calculation by providing a rounding error detecting part for detecting a contradiction of a result of calculation caused by a rounding error and a rounding error correcting part. CONSTITUTION:A rounding error detecting part 9 brings an intermediate result of calculation and a final result of calculation to rounding processing, respectively by a data display part 7 and outputs them to a display device 8, and also, detects the end of a calculating operation and executes a recalculation of display data in the display device 8, and detects generation of a rounding error in the display data. In such a way, when a contradiction of a result of calculation is generated, a rounding error correcting part 10 can correct automatically a part of the display data so that no contradiction is generated in a result of calculation.

Description

DETAILED DESCRIPTION OF THE INVENTION Field of Industrial Application The present invention relates to a calculation processing device that executes calculations in financial and accounting systems.

Conventional technical calculation processing programs have evolved with the birth of computers, but especially in the field of office automation, with the birth of spreadsheet-type software, the user base has expanded, and programs with simpler user interfaces have expanded. Spreadsheet-type software has been born one after another. The calculation processing device, which consists of a calculation processing program and the hardware that executes it, is designed for applications such as financial calculations and budget management, where errors of even 1 yen or 0.1% are not allowed, and calculation errors are avoided. It is designed to prevent this from occurring as much as possible.

FIG. 4 shows a conventional calculation processing device. When data is input from a keyboard 1, a data input unit 2 stores the data in a data buffer 3. When a calculation formula is input from the keyboard 1, the calculation formula registration unit 4 stores the calculation formula in the calculation formula buffer 5. The calculation formula execution unit 6 is the data buffer 3
Calculations are performed based on the input data in and the calculation formula in the calculation formula buffer 5, and the results are stored in the data buffer 3. This data buffer 3 is designed to be able to hold a sufficient amount of significant digits. The data display unit 7 performs rounding processing such as truncating, rounding up, or rounding to the specified digit in order to display the data in the data buffer 3 in a format previously specified by another means, and displays the data on the display 8. to be displayed. All calculations are done on the data, not on the display 8.
Since the data in the buffer 3 with sufficient significant digits is used, even if rounding is performed to display one, no loss of digits will occur in the final calculation result.

Problem to be Solved by the Invention In such a conventional configuration, the percentage in the middle of calculation on the display 8! A problem arises in that the sum of 1 and the percentage of 1 total ■ do not match. Specifically, the sum of percentage I (31,3+33.3+
35.3) is "99.9", but 1 total is calculated using unrounded data in data buffer 3, so the percentage of 1 total ■ is "
100.0", each value is the correct value due to rounding, but the result is (31,3 + 33.3
+35.3) = 100, which is an invalid formula. Conversely, if the total ■ is displayed as 99.9, the invalid formula is "150/150 x 100 tonnage 99.9". This becomes a big problem if it is used to create a budget balance sheet or budget allocation table within a company.

In other words, even though the budget and actual calculations match, this calculation processing system causes a phenomenon in which the budget and actual calculations do not match.However, since this example is simple, this error can be easily corrected. However, as the number of data and calculation formulas increases, it becomes extremely difficult to detect errors due to rounding.

When the user notices the rounding error as described above, he or she recalculates it on a desktop calculator and changes "35.3" to "3", for example.
5.4" data, and the operation had to be performed to make sure that one set matched, which had the problem of requiring a lot of effort.

An object of the present invention is to provide a calculation processing device that can automatically correct rounding errors that occur in display data.

Means for Solving the Problems The calculation processing device of the present invention rounds the intermediate results of calculation and the final result of calculation in a data display section and outputs them to a display device, and also detects and displays the end of calculation operation. The present invention is characterized in that it includes a rounding error detection section that recalculates display data in the device and detects the occurrence of rounding errors in the display data, and a rounding error correction section that corrects the display data according to instructions from the rounding error detection section.

Effect: According to this configuration, when the calculation is completed, the rounding error detection unit recalculates the display data, and if there is a discrepancy in the calculation results, the rounding error correction unit displays the display data.

Automatically correct part of the data so that there are no inconsistencies in the calculation results.

EXAMPLE Hereinafter, an example of the present invention will be described based on FIGS. 1 to 3. Components having the same functions as those in FIG. 4 showing the conventional example will be described with the same reference numerals.

FIG. 1 shows a calculation processing device of the present invention, and FIG. 2 shows its flowchart. FIG. 1 shows a rounding error detection section 9 that detects discrepancies in calculation results due to rounding errors, and a rounding error correction section 10 that corrects the rounding errors. It differs from Fig. 4 in that it has been added.

When keys on keyboard 1 are operated [step S1],
The data input unit 2 determines whether the data is data to be subjected to calculation processing or a calculation formula [step 52]L, and if it is data, the data is stored in the data buffer 3 [
Step S3] and determine whether the calculation should be performed [
Step S4].

If the calculation is not to be performed, the process returns to step S1 via [step S9). If it is determined in step S2 that it is a calculation formula, the calculation formula is stored in the calculation formula registration unit 4.
is stored in the calculation formula buffer 5 (step 5s), and (step S4) is executed. When it is determined in step 34 that the calculation formula should be executed, the calculation formula execution unit 6 performs calculation based on the data in the data buffer 3 and the calculation formula in the calculation formula buffer 5. Step S6].

Next, the calculation result of the display data rounded by the rounding error detection unit 9 is compared with the calculation result of the data in the data buffer 3 to determine whether a contradiction has occurred [step S7].

If no contradiction occurs, display the display data [
Step S93. If it is determined in [Step S7] that a contradiction has occurred, the rounding error correction unit IO automatically detects and corrects the display data to be corrected [Step S8].

[Step S9) The data display unit 7 displays the result on the display 8, and the process returns to [Step Sl].

FIG. 3 is a diagram illustrating a specific example. 11 is a conventional data display state before rounding error correction; 12 is a data state in the data buffer 3; and 13 is a data display state after rounding error correction according to the present invention.

Data in data buffer 3, here data state 12
is displayed as data state 11, with the second decimal place rounded off as shown in the figure, according to the format specified by the user. The rounding error detection unit 9 performs the following in [step S7]. That is, calculate the total value of the rounded data on display 8 and obtain the value "99.9" 6 Then search for the total value in data buffer 3,
A value of "100.0" is obtained, and it is detected that the data on the display 8 has been truncated by "0, 1" too much.

Therefore, the rounding error correction unit 10 compares each data rounded off in [step S8) with each data in the data state 12 before rounding, which is the data in the data buffer 3, and compares each data rounded off with the data in the data state 12 before rounding, and among them, the rounded-off value is the largest. “31
．． Correct the value of "4" to "31.5".

Display as data state 13. In this case, when rounding is too high, an algorithm is used to round down the data with the largest rounding value, and a means is provided to notify the user that a rounding error has occurred without automatically correcting it. The rounding error may be automatically corrected, or a means for the user to specify the data to be corrected may be provided and the user may be allowed to specify it.Furthermore, if the rounding error is automatically corrected, which data has been corrected? A means for notifying the user may be provided.

Effects of the Invention As described above, according to the present invention, a rounding error detection section that detects discrepancies in calculation results due to rounding errors and a rounding error correction section that corrects the rounding errors are provided, so that display contents can be easily viewed and displayed by rounding processing. It is possible to detect discrepancies in calculation results due to rounding processes such as rounding, and correct the data to avoid discrepancies in calculation results, so it is possible to correct discrepancies between budget and actual calculations when creating a budget-actual balance sheet within a company. This is an excellent and highly practical product that can prevent such troubles.

[Brief explanation of the drawing]

Fig. 1 is a schematic configuration diagram of an embodiment of the calculation processing device of the present invention, Fig. 2 is a flowchart of the same device, Fig. 3 is an explanatory diagram of error correction in the same device, and Fig. 4 is a conventional calculation processing. It is a block diagram of a device. 1...Keyboard, 2...Data input section, 3...
Data buffer, 4... Calculation formula registration section, 5... Calculation formula buffer, 6... Calculation formula execution section, 7... Data display section, 8... Display, 9... Rounding error detection 10... Rounding error correction unit, 11... Data display state according to the conventional method before rounding error correction, 12... Data state in the data buffer, 13... Data display after rounding error correction according to the present invention situation. Agent Yoshihiro Morimoto! Figure 3? -9 buffer Figure 3 Figure 2 Figure 4

Claims (1)

[Claims] 1. The intermediate results of calculation and the final result of calculation are each rounded in the data display section and output to the display device, and the end of the calculation operation is detected and the display data on the display device is recalculated, and the display data is A calculation processing device comprising: a rounding error detection section that detects occurrence of a rounding error; and a rounding error correction section that corrects display data according to instructions from the rounding error detection section.