JPH06161963A - Computer - Google Patents

Abstract

PURPOSE:To provide a computer which can easily know the values of other computing items when the computing result is changed into an optional value. CONSTITUTION:A computing means 111 calculates a computing expression set previously when the value is set to each of plural computing items included in the computing expression. A display device 12 has the display columns to show the executing result values of the computing items and the computing expression. Then a computing result rewriting means 101 is added to rewrite the executing result value in a state where the executing results of the computing items and the computing expression are shown in each display column of the device 12 together with a computing item designating means 102 which designates the optional one of those computing items, an inverse computing expression producing means 113 which produces a computing expression that uses the value rewritten by the means 101 as a known quantity and the computing item designated by the means 102 as an unknown quantity respectively, and an inverse computing means 112 which carries out the computing expression produced by the means 113 and shows the computing result in the display column for the computing item designated by the means 102.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a computer. More specifically, the calculation result obtained by calculating the value input to each of a plurality of calculation items according to a specified calculation procedure is changed to an arbitrary value. In this case, the present invention relates to a computer that can obtain the value of any of the calculation items in correspondence with the value of the calculation result after the change.

[0002]

2. Description of the Related Art Some items called "cells" are prepared for a function of performing spreadsheet using a computer, and some items called "fields" are prepared for a calculation function used in a database. Is automatically calculated after the operator sets the relationship between the items and items, such as addition and subtraction.

The process of such calculation will be specifically described below. As shown in the schematic diagram of FIG. 1, several items (item 1 to item 4 in this example) are to be processed.
Is prepared on the computer.

Here, the operator can set in advance the value output to a certain item to be a calculation result based on the value input to another item. Here, for example, the setting is made so that the calculation result is output to "item 4" and the calculation of "item 1 + item 2 + item 3" is performed when a value is input to each of the other items. And

In such a state, if values are input to "item 1", "item 2", and "item 3", "item 4" is entered.
The calculation result is output to. For example, as shown in FIG. 2, when “20” is input to “item 1”, “30” is input to “item 2”, and “40” is input to “item 3”, A value "90" obtained by adding them is output to "item 4".

By the way, as shown in FIG. 3, for example, ten items "item 1" to "item 10" are prepared on the computer, and "item 8" has the following calculation formula. Is set. ("Item 1" + "item 2" + "item 3") ÷ "item 4" Here, "item 1" is "10" and "item 2" is "2".
"0", "30" for "item 3", and "6" for "item 4"
When each is input, the above calculation formula is executed, and as a result, as shown in FIG. 4, “10” is output to “item 8”.

[0007]

By the way, as described above, the conventional computer outputs the calculation result by setting the calculation formula and the value of each item, but the calculation result becomes another value. If you want to know the value of such a calculation item,
The operator had to set a new calculation formula and recalculate.

The present invention has been made in view of the above circumstances, and when the calculation result is changed to an arbitrary value after the result of the calculation formula is obtained, the other calculation items have different values. The purpose is to provide a computer that makes it easy to know what will happen.

[0009]

SUMMARY OF THE INVENTION According to the present invention, a calculation means for executing a calculation formula when a value is set for each of a plurality of calculation items in a predetermined calculation formula, and each calculation item and the calculation formula. In a computer provided with a display means having a display field for displaying the respective values of the executed results, the results are displayed in a state where the respective display fields of the display means respectively display the values of the respective calculation items and the results of executing the calculation formulas. Specify any one of a plurality of calculation items with the calculation result rewriting unit that rewrites the value of and the value of the result of executing each calculation item and calculation formula in each display column of the display unit. And an inverse calculation formula creating means for creating a calculation formula in which the value rewritten by the operation result rewriting means is a known number and the operation item specified by the operation item designating means is an unknown number. Run a formula created by calculating equation generating means is characterized in that a reverse calculation means for displaying on the display section of the operation items specified by operand specifying means the results.

[0010]

In the computer of the present invention, the result values are rewritten by the operation result rewriting means in a state in which the values of the results of executing the respective calculation items and the calculation formulas are displayed in the respective display columns of the display means, A calculation in which any one of the calculation items of is calculated by the calculation item designating means, and the value rewritten by the calculation result rewriting means is a known number, and the calculation item designated by the calculation item designating means is an unknown number. The formula is created by the inverse calculation formula creating means, the calculation formula created by the inverse calculation formula creating means is executed, and the result is displayed in the display box of the calculation item designated by the calculation item designating means.

[0011]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described below in detail with reference to the drawings showing the embodiments thereof.

FIG. 5 is a functional block diagram showing a configuration example of a computer according to the present invention. The computer of the present invention, like an ordinary computer, has an arithmetic circuit 11 as a main body, a keyboard 10 for inputting various instructions, numerical values, etc., and an arithmetic unit.
It is composed of a display device (for example, a CRT display) 12 for displaying the calculation result and the like by 11.

Functionally, the arithmetic circuit 11 determines an arithmetic means 111 for executing a normal calculation and a result of an ordinary arithmetic expression executed by the arithmetic means 111 as a known number, and obtains one of the arithmetic items as an unknown number. Inverse calculation formula creating means 113 for creating a calculation formula (hereinafter referred to as inverse calculation formula) and inverse calculation means for executing the inverse calculation formula created by the inverse calculation formula creating means 113.
It is composed of 112 and.

The keyboard 10 is functionally provided with a numeric keypad for inputting numerical values, a cursor moving key, etc., as in a normal keyboard, but a display device using these is provided. Calculation result rewriting means 101 for rewriting the calculation result displayed in 12,
Calculation item specifying means for specifying any calculation item
102 and are provided.

The basic operation of the computer of the present invention having such a functional configuration will be described below with reference to the flowchart of FIG. Note that the procedure for performing normal calculations is the same as that of a conventional computer.First, the operator sets a calculation formula (step S11), and operates the keyboard 10 for each calculation item of this calculation formula to input a numerical value (step S12),
Calculation is performed by the calculation means 111 of the calculation circuit 11 and the result is displayed on the display device 12 (step S13).

This state is, for example, the state shown in FIG. 4 described above. Next, for example, the operation result “10” output to “item 8” displayed on the screen of the display device 12 is displayed in high brightness as shown in FIG. 7 by operating the keyboard 10. Further, when a predetermined key (hereinafter referred to as a value adjustment key) is operated, a message "What value should be changed?" Is displayed as shown in FIG. 8 (step S14).

Here, the operator operates the keyboard 10 to change the "item 8" to "1" by the operation result rewriting means 101.
When changed to "5", this value is read by the inverse calculation formula creating means 113 of the arithmetic circuit 11 and "item 1", "item 2", "item 3" and "item" displayed on the screen of the display device 12 are displayed. 4 "is displayed in high-intensity on the screen of the display device 12 as shown in FIG. The operator uses the keyboard to select the item to be changed from the items displayed in high brightness in Fig. 9.
When the operation item designating means 102 is operated to designate 10 as shown in FIG. 10, it is assumed here that "item 3" is designated as shown in FIG. 10, for example. The inverse calculation formula creating means 113 of the arithmetic circuit 11 detects that this "item 3" has been designated (step S16), reads this value and creates an inverse calculation formula for deriving "item 3" (step S16).
S17). Then, the inverse calculation means 112 executes calculation according to the inverse calculation formula created by the inverse calculation formula creating means 113,
As a result, the value of "item 3" is obtained, and "60" is displayed as the value of "item 3" on the display device as shown in FIG.
It is displayed on 12 (step S18).

Next, as a specific calculation example of the computer of the present invention, a case where the standard price of a product is determined based on the material cost, personnel cost, etc. will be described.

Now, for example, as shown in FIG. 12 on the screen of the display device 12, each item such as material cost, labor cost, profit and each multiplication rate necessary for calculating the standard price of the product is displayed. It is displayed, and it is assumed that the following calculation formulas (1) to (5) are set in the arithmetic unit 10.

Standard price = material cost + labor cost + profit (1) Material cost multiplication rate = material cost / (material cost + labor cost + profit)
× 100… (2) Personnel cost multiplication rate = Personnel cost ÷ (Material cost + Personnel cost + Profit)
× 100… (3) Profit multiplication rate = Profit ÷ (Material cost + Labor cost + Profit)
× 100… (4) Standard price multiplication rate = Material cost multiplication rate + Labor cost multiplication rate + Profit multiplication rate… (5)

Here, when the operator operates the keyboard 10 to input the following data, the arithmetic means 111 of the arithmetic circuit 11 performs the calculation according to the above-mentioned calculation formulas, and the calculation result is shown in FIG. As shown on the screen of the display device 12.

Material cost = 3000 Personnel cost = 1000 Profit = 1000

If the result shown in FIG. 13 is calculated, it is found that the multiplication factor of the material cost is 60%, but the operator adjusts the multiplication factor of the material cost to adjust the profit. Consider the case of reducing to 50% by doing. First, the operator operates the value adjustment key of the keyboard 10 to move the cursor on the screen of the display device 12 to the item “multiplying rate of material cost” and activates the “value adjustment” process. As a result, as shown in FIG. 14, all the items necessary for calculating the material cost multiplication rate are highlighted, and the operator operates the keyboard 10 to operate the calculation result rewriting means 101 to Rewrite the value of the item “Multiplying rate of material cost” to “60”.

Since the profit is adjusted here,
As shown in 15, when the operator operates the keyboard 10 to move the cursor to the “profit” item and then operates the value adjustment key to execute the “value adjustment” process,
The inverse calculation formula creating means 113 of the arithmetic circuit 11 reads the value of the item in which the result of the previously executed calculation is displayed. Also, since the values of all items other than “profit” are fixed, the inverse calculation formula creating means 113 detects the specified item (in this case, the item of “material cost multiplication rate”) and writes it first. Create an inverse calculation formula in which the value of the result item is a known number and the newly detected item is an unknown number, specifically, the inverse calculation formula (2). The inverse calculation means 112 executes the inverse calculation expression of the calculation expression (2) created by the inverse calculation expression creating means 113 to display the result on the display device 12.

Specifically, the calculation is performed when the "material cost multiplying ratio" in the above calculation formula (2) is set to 60% and the "profit" is an unknown number. In this case, “material cost”, “labor cost”, and “material cost multiplying ratio” are fixed, so the calculation of “profit” is actually performed from the following formula (6).

50 = 3000 / (3000 + 1000 + profit) × 100 (6) From this calculation formula (6), “2000” is obtained as “profit”.
Then, according to this calculation result, the other calculation formula (1),
(3), (4), and (5) are also executed again by the computing means 111, and
As shown in 6, “2000” is output in the profit column, and the values displayed in the other columns are adjusted.

[0027]

As described in detail above, according to the computer of the present invention, the value of another calculation item in that case can be obtained by rewriting the calculation result to a different value after the calculation result is obtained. Since it becomes possible, it is very effective for practical calculation such as cost calculation of goods.

[Brief description of drawings]

FIG. 1 is a schematic diagram showing an arrangement state of calculation items to be processed by a computer on a display device.

FIG. 2 is a schematic diagram showing an arrangement state of calculation items to be processed by a computer on a display device.

FIG. 3 is a schematic diagram showing a state displayed on a display device in an actual calculation example by a conventional computer and a computer of the present invention.

FIG. 4 is a schematic diagram showing a state displayed on a display device in an actual calculation example by a computer of the related art and the present invention.

FIG. 5 is a functional block diagram showing a configuration example of a computer according to the present invention.

FIG. 6 is a flowchart showing a basic operation procedure of the computer of the present invention.

FIG. 7 is a schematic diagram showing a state displayed on a display device in an actual calculation example by the computer of the present invention.

FIG. 8 is a schematic diagram showing a state displayed on the display device in an actual calculation example by the computer of the present invention.

FIG. 9 is a schematic diagram showing a state displayed on a display device in an actual calculation example by the computer of the present invention.

FIG. 10 is a schematic diagram showing a state displayed on the display device in an actual calculation example by the computer of the present invention.

FIG. 11 is a schematic diagram showing a state displayed on the display device in an actual calculation example by the computer of the present invention.

FIG. 12 is a schematic diagram showing a state displayed on the display device in an actual calculation example by the computer of the present invention.

FIG. 13 is a schematic diagram showing a state displayed on the display device in an actual calculation example by the computer of the present invention.

FIG. 14 is a schematic diagram showing a state displayed on the display device in an actual calculation example by the computer of the present invention.

FIG. 15 is a schematic diagram showing a state displayed on the display device in an actual calculation example by the computer of the present invention.

FIG. 16 is a schematic diagram showing a state displayed on the display device in an actual calculation example by the computer of the present invention.

[Explanation of symbols]

 12 display device 101 calculation result rewriting means 102 calculation item designation means 111 calculation means 112 inverse calculation means 113 inverse calculation formula creation means

Claims (1)

[Claims] 1. A calculation means for executing the calculation formula when a value is set for each of a plurality of calculation items in a predetermined calculation formula, and a value of a result of executing each calculation item and the calculation formula. In a computer provided with a display means having a display column for respectively displaying, in a state in which the value of the result of executing each of the calculation items and the calculation formula is displayed in each display column of the display means, A calculation result rewriting unit that rewrites a value, and an arbitrary one of the plurality of calculation items in a state in which each calculation item and the value of the result of executing the calculation formula are displayed in each display column of the display unit. And a calculation formula that specifies the value rewritten by the calculation result rewriting unit as a known number and the calculation item specified by the calculation item designation unit as an unknown number. Inverse calculation formula creating means, and inverse calculation means for executing the calculation formula created by the inverse calculation formula creating means and displaying the result in the display box of the calculation item designated by the calculation item designating means. A calculator characterized by