JPH06230932A - Difference distribution method - Google Patents

Abstract

PURPOSE:To make the total value of ratios into 100% in ratio calculation. CONSTITUTION:It is specified to mention the ratio upto (m)-th place (digit) in a first process S1, the respective ratios are calculated upto a place smaller than the (m)-th place in a second process S2 and a difference between the total of the values upto the (m)-th places of the respective ratios obtained by the second process and 100% is obtained in a third process S3. The sizes of the place smaller than the (m)-th place by one of the ratios obtained by the second process are compared and a size order is obtained in a forth process S4. In a fifth process S5, the absolute value of the difference obtained in the third process is equally divided, an equal value is subtracted or added successively from the value of the higher ratio obtained in the forth process depending on whether the difference is positive or negative and the total of the respective ratios upto the (m)-th place is made into exactly 100%.

Description

Detailed Description of the Invention

[0001]

[Industrial field of application] This relates to an error distribution method in which when the ratio of each item is calculated as a percentage value in office calculation, etc., the total of these item values is exactly 100%.

[0002]

2. Description of the Related Art Conventionally, in office calculations and the like, when the ratio of each item is expressed as a percentage value, the total ratio (item value) may exceed 100% or may be less than 100%. This is because an error occurs by rounding each ratio to four. For this reason, the error generated by rounding off to the nearest four is appropriately distributed and adjusted so that the total ratio is exactly 100%.

[0003]

However, it is troublesome to correct the obtained ratio to 100%. In addition, it is very unsightly that the sum of the ratios of each item is not exactly 100%.

An object of the present invention is to, when each item value is expressed as a percentage value, automatically divide an error caused by rounding up to the next 4 into each item value and make sure that the total of each item value is 100%.
It is to provide an error distribution method that is exactly the same.

[0005]

In order to achieve the above object, the error distribution method according to claim 1 includes a first step for designating that the ratio of each item value is expressed up to the m-th place, and each item. A second step of calculating the ratio of the values to a position smaller than the m-th place, and a third step of obtaining an error between the sum of the values of the ratios obtained by the second process up to the m-th place and 100%. Fourth step of comparing the step with the magnitude of the order of magnitude smaller than the m-th order of each ratio obtained in the second step to obtain a magnitude order
And the absolute value of the error obtained in the third step are equally divided, and the value obtained in the fourth step is subtracted from the upper ratio in accordance with the positive or negative of the error. The fifth step of addition is provided, and the sum of each ratio up to the m-th place is 1
The feature is that it is exactly 00%.

Further, the error distribution method according to claim 2 further comprises a sixth step of displaying the ratio in which the error is allocated and the ratio in which the error is not allocated in the fifth step, and the error distribution ratio is identified. The feature is that it is possible.

[0007]

In the method of the present invention, the error caused by rounding off to the nearest 4 is automatically distributed to each item value. Therefore, the total of each item value can be exactly 100%. No need to adjust the value. Further, since the method of the present invention is simple, it can be applied to various office processing apparatuses and the like.

[0008]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 shows an example of the configuration of an error calculation / error distribution device that executes an error distribution method according to an embodiment of the present invention.
In FIG. 1, 1 is a control unit, 2 is a display unit, 3 is a data storage unit, 4 is an error processing unit, and 5 is an input unit.

The data storage unit 3 stores, for example, data input from the input unit 5 or processed data, for example, table data as shown in FIG. The control unit 1, for example,
It is composed of a microprocessor and an input / output control device and controls the operation of the entire device. For example, the control unit 1 saves the data input from the input unit 1 such as a keyboard in the data storage unit 3, processes and processes the data stored in the data storage unit 3, and stores the data stored in the data storage unit 3. Etc. are displayed on the display unit 2.

The error processing unit 4 is activated when the result of the percentage calculation by the control unit 1 is not exactly 100%, and executes the error distribution process described later. The error processing unit 4, for example,
It is realized as one function of the microprocessor that constitutes the control unit 1.

Next, referring to the flowchart of FIG. 2, the error distribution method realized by the error calculation / error distribution device according to this embodiment will be described by taking the case of obtaining the ratio of the number of sales by branch office shown in FIG. 3 as an example. And explain.

The ratio of the number of sales at each branch is the
When obtaining up to the digit (digit), the operator inputs that the number is below the decimal point and "m" is input from the input unit 5 (step S
1). Here, "m" is 2.

The control unit 1 calculates the sales number ratio of each branch office to the m + 1th place (one place smaller than the mth place) below the decimal point. Here, calculation is performed up to the third decimal place (step S2). The result of this calculation is shown in the second column of FIG.

Next, the control unit 1 deletes the value of m + 1 place after the decimal point of the obtained sales ratio of each branch office, obtains the sales number ratio up to the mth place after the decimal point, and further obtains it. The sum of sales ratios is calculated, and the difference between the sum and 100% is calculated (step S3). In the case of the example in FIG. 3, the sum of the ratio of the number of sales to the second decimal place which is not rounded to four for each branch is “99.97”. That is, "100.0
"0.03" is insufficient for "0" (error is positive). The error of 0.03 corresponds to an error of three branch offices of 0.01 (corresponding to 10 ^−m = 10 ⁻² ).

Which branch is to be allocated with this error "0.03" is determined in the following process. The control unit 1 includes an error processing unit 4
To start. The error processing unit 4 compares the magnitudes of the m + 1th place below the decimal point of each item value to obtain the magnitude order. Figure 3
In the example of FIG.
As shown in the column, "8" Hokuriku, "7" Shinetsu, "6"
The order is Tokyo, the number 5 is Kanto, and the number 4 is Tokai.

Next, the error processing section 4 reduces the error to 10
^-m (0.01) is added in order from the highest sales ratio obtained in the process of step 4. In the case of this example, since the error obtained in the third step is "0.03", this error is set to 0.
Allocate 01 to 3 branch offices. The target branch offices are the top three branch offices arranged in descending order in the fourth step, namely the Hokuriku branch office, the Shin-Etsu branch office, and the Tokyo branch office. The error processing unit 4 returns to the control unit 1 the sales number ratio after the error is distributed. The control unit 1 displays the obtained sales number ratio. The third column in Figure 3
The result after the error is distributed is shown.

From this, the sum of the values to the second decimal place specified by the operator is exactly 100.00%.

In the above embodiments, the case where the error is positive (the total value of the ratios is less than 100) has been described, but when the error is negative (the total value of the ratios is greater than 100), the number after the decimal point is calculated. Subtract 10 ^m from the largest m + 1.

If the values at the m + 1th place after the decimal point are the same, the order may be determined by obtaining the ratio up to the m + 2th place after the decimal point.

In the above embodiment, the case where the sales number ratio is calculated up to the mth place after the decimal point has been described, but the present invention can be similarly applied to the case where the ratio is calculated up to the integer mth place. Number of sales shown in Fig. 5 (same as the number of sales shown in Fig. 4)
Taking the example of obtaining the ratio of up to tens, the ratio is an integer m
Explain the case where you want up to the rank

First, the operator inputs from the input section 5 that the ratio is to be obtained to the tens (digit) (m = 2) (step S1). The control unit 1 obtains the sales number ratio to a position one rank lower than the designated rank (step S2). In the case of the present embodiment, the sales number ratio is calculated up to the first place (FIG.
Column).

Next, the control unit 1 deletes the first value of the obtained sales number ratio, obtains the sales number ratio to the tens place, and further obtains the sum of the obtained sales number ratios. , The difference between the sum and 100% is obtained (step S3). Figure 3
In the case of the example, the sum of the sales number ratios of the respective branch offices is “80”, and the error is 100−80 = 20 (10 ¹ × 2).

The control unit 1 activates the error processing unit 4. The error processing unit 4 determines the order of magnitude of the ones value of the sales number ratio. In the case of this example, as shown in the fourth column of FIG.
Hokuriku, "5" Shinetsu, "3" Tokyo, "2" Kanto,
The order of "0" Tokai is in order.

The error processing section 4 adds "10" to the respective values of the Hokuriku branch office and the Shin-Etsu branch office. FIG. 5 shows the sales number ratio after the error is distributed. As a result, the second place (tenth place)
The total of the item values up to is 100% exactly.

In the above embodiment, the item value to which the error is distributed and the item value to which the error is not distributed may be displayed separately. In this case, after step S5 of the flowchart shown in FIG. 2, a step (S6 in FIG. 3) of distinguishing and displaying the ratio in which the error is distributed and the ratio in which the error is not distributed is added. This allows the operator to confirm which item ratio is the target of error distribution. For example, the control unit 1 activates step S6 of FIG. 3 only when the operator presses a specific key of the input unit 5 in order to know the progress of the error distribution process.

As a display method, for example, a display method in which a special symbol is added to the ratio to which the error is distributed and displayed, or the display color of the character is changed can be used. The fifth of FIGS.
In the column, an underline is added to the ratio of the items to which the error is allocated to distinguish the ratio to which the error is allocated and the ratio to which the error is not allocated. Further, depending on whether the error is positive or negative, the progress of processing can be clarified by displaying in red in the case of addition distribution and in blue in the case of subtraction distribution.

The method of the present invention can be applied to other than error distribution of percentage values. For example, in surveying at the time of land shape measurement, it is possible to obtain an error for each measured value using the same process as described above and distribute it so that the sum of the internal angles of the quadrangle is exactly 360 degrees. .

In the above-mentioned embodiment, the ratios are calculated up to the position one rank lower than the position designated in step S2. However, the ratio may be calculated to a lower rank. In the above embodiment, the error is evenly distributed by 0.01 or 10; however, it may be evenly distributed by 0.02 or 20, for example, depending on the application.

[0029]

Since the method of the present invention is constructed as described above, the total ratio can be exactly 100%. Moreover, the ratio to which the error is distributed can be confirmed as necessary.

[Brief description of drawings]

FIG. 1 is a diagram showing an example of an apparatus that executes an error distribution method according to an embodiment of the present invention.

FIG. 2 is a flowchart of an error distribution method according to an embodiment of the present invention.

FIG. 3 is a flowchart showing steps added to the flowchart of FIG.

FIG. 4 is a diagram for specifically explaining an error distribution method according to an embodiment of the present invention.

FIG. 5 is a diagram for specifically explaining the error distribution method according to the embodiment of the present invention.

[Explanation of symbols]

1 ... Control unit, 2 ... Display unit, 3 ... Data storage unit, 4 ... Error processing unit, 5 ... Input unit.

Claims (2)

[Claims] 1. A method of obtaining the ratio of each item by a percentage value, wherein a first step is designated to indicate the ratio of each item value up to the m-th place, and the ratio of each item value is smaller than the m-th place. Second to calculate up to
Step, a third step of obtaining an error between the sum of the values up to the m-th place of each ratio obtained by the second step and 100%, and a step of each ratio obtained by the second step. The fourth step of obtaining the order of magnitude by comparing the magnitude of the one place smaller than the m-th place and the absolute value of the error obtained in the third process are equally divided, and depending on whether the error is positive or negative, A fifth step of subtracting or adding equal values in order from the higher ratio of the value obtained in the fourth step is provided, and the sum of the respective ratios up to the m-th place is exactly 100%. Error distribution method. 2. The method according to claim 5, further comprising a sixth step of displaying a ratio in which the error is allocated and a ratio in which the error is not allocated, in a distinguishable manner so that the ratio to which the error is allocated can be identified. The error distribution method described in 1.