JP2518189B2 - Numerical data arithmetic device and method - Google Patents

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an arithmetic device and method for numerical data.

[0002]

2. Description of the Related Art When a document is created by a word processor, it is often the case that the text is the same and a plurality of documents are created by replacing only specific numerical values. For example, there is a case where the quantity, unit price, amount of money, etc. of a product are entered in an estimate or the like. In an office computer, of course, it is possible to input numerical values later for calculation, but since the word processor is a "document creation device", it does not have such a function. Therefore, in the conventional word processor, the quantity and the unit price must be substituted for each document, and the amount must be calculated after separately calculating, which is very troublesome.

Further, in the conventional word processor, when inputting each item such as the quantity, unit price, and amount of money as described above, a display area corresponding to each item is set on the display screen, and the display area on the display screen is set. In some cases, each display area was specified and information was input.

[0004]

Further, in the conventional case,
2. Description of the Related Art There is known a spreadsheet processing apparatus capable of performing spreadsheet processing on a table in which a plurality of display areas are arranged in a matrix. In this conventional spreadsheet processing device, it is possible to sequentially and consecutively specify this area with a cursor, but when setting a desired calculation formula for a desired area of the plurality of areas, calculation is performed. It is convenient when there are multiple regions for formula setting and they are adjacent to each other, but when they are in mutually distant regions, when setting the calculation formula by specifying each region. In addition, there is a problem in that the cursor must be repeatedly operated to move to a desired area, which makes the operation extremely complicated. An object of the present invention is not only to perform a sequential designation operation by a predetermined key when directly setting a calculation expression for a desired one of a plurality of tabular areas on a display screen, but also to directly specify the area. This is to be able to specify the desired area by the specifying operation.

[0005]

The means of the present invention are as follows.

According to a first aspect of the present invention, there is provided definition means for defining each of a plurality of areas arranged in a table format in the row and column directions on the display screen by an area name, and each area defined by the area name. And a storage means for storing a storage table,
When continuously specifying each of the above areas,
First designation means for sequentially and sequentially designating a storage table corresponding to a region to be designated, and when the region is designated by the region name, this input is performed when a region name for designating a desired region is inputted. After designating the storage table by the second designating means for searching and designating the storage table corresponding to the area specified by the designated area name, and any one of the first or second designating means. When a calculation formula having a desired region name as a variable is input, setting means for setting this calculation formula as formula data in the calculation formula storage area in the designated storage table, and the calculation formula of the above setting When performing the calculation based on, the numerical data stored in the numerical storage area of the storage table corresponding to the area specified by each area name included in this calculation formula is read, and the read numerical data is updated. Computation means for executing computation by substituting in a calculation formula, and storage control means for storing and controlling numerical data of the calculation result as numerical data in the numerical storage area of the storage table in which the formula data of the calculation formula is set. And display control means for controlling the display of the storage-controlled numerical data as numerical data of an area corresponding to the storage table on the display screen. Further, in claim 2, each of a plurality of areas arranged in a table format in the row and column directions on the display screen is defined by an area name, and prepared in correspondence with each area defined by the area name. A method of calculating numerical data using a storage table, wherein when the above-mentioned respective areas are continuously designated, the storage table corresponding to the designated area is successively consecutively operated every time a predetermined key is operated. In the area designation by the area name, when the area name that specifies the desired area is input, the storage table corresponding to the area specified by the input area name is searched and specified. , When a formula with the desired area name as a variable is input, this formula is
Set as formula data in the calculation formula storage area in the storage table specified by any of the above-mentioned specification methods, and when executing the calculation based on the calculation formula of the above setting, it is specified by each area name included in this calculation formula. The numerical data stored in the numerical storage area of the storage table corresponding to the area to be read is read out, and the read numerical data is substituted into the above formula to execute the calculation.
Storage control as numerical data in the numerical storage area of the storage table in which the formula data of the calculation formula is set,
It is characterized in that the storage-controlled numerical data is displayed on the display screen as numerical data of an area corresponding to the storage table.

[0007]

The operation of the means of the present invention is as follows.

According to the first aspect of the present invention, each of a plurality of areas arranged in a table format in the row and column directions on the display screen is defined by an area name and stored in correspondence with each area defined by the area name. The table is stored. In the continuous designation of each area, the storage table corresponding to the area to be designated is sequentially designated every time a predetermined key is operated. In the area designation by the area name, when an area name that specifies a desired area is input, the storage table corresponding to the area specified by the input area name is searched and specified. After the storage table is specified by any of the above-mentioned specification methods, when a calculation expression with a desired area name as a variable is input, this calculation expression is stored in the calculation expression storage area in the specified storage table. It is set as data. Then, when performing the calculation based on the calculation formula of the above setting, the numerical data stored in the numerical storage area of the storage table corresponding to the region specified by each region name included in this calculation formula is read, The calculation is executed by substituting the read numerical data into the calculation formula, and the numerical data of the calculation result is the numerical data in the numerical storage area of the storage table in which the formula data of the calculation formula is set. The storage control is performed, and the display of the numerical data is controlled on the display screen as the numerical data of the area corresponding to the storage table. Further, in claim 2, when successively designating each of the plurality of regions arranged in the row and column directions in the table format on the display screen, each designated key operation corresponds to the designated region. The storage tables to be specified are sequentially and continuously specified. On the other hand, when specifying a region by region name, when entering the region name that specifies the desired region,
The storage table corresponding to the area specified by the input area name is searched and specified. Then, when a calculation formula having a desired area name as a variable is input, this calculation formula is set as formula data in the calculation formula storage area in the storage table designated by any of the designation methods described above. When performing the calculation based on the calculation formula of the above setting, the numerical data stored in the numerical storage area of the storage table corresponding to the region specified by each region name included in this calculation formula is read, and this reading is performed. The calculation is executed by substituting the numerical data that has been issued into the above calculation formula, and the numerical data of this calculation result is stored as the numerical data in the numerical storage area of the storage table in which the formula data of that calculation formula is set. The storage-controlled numerical data is displayed and controlled on the display screen as the numerical data of the area corresponding to the storage table.

Therefore, in a system in which a storage table is prepared corresponding to each of a plurality of areas arranged in a table format in the row and column directions, when designating a desired area among the above areas, the key is used. Select the designation method according to the operator's wishes, whether the area is designated sequentially and continuously by the operation of or is designated by inputting the area name defined for the desired area. It is possible,
In either case, since the storage table corresponding to the specified area is specified, the calculation formula having the desired area name as a variable can be immediately set and stored in the storage table.

[0010]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment will be described below with reference to the drawings. FIG. 1 shows an external configuration. Reference numeral 1 is a word processor main body, and 2 is a printer connected to the word processor main body 1. The word processor body 1 is provided with floppy disk (FDD) units 3a and 3b, a CRT display unit 4, and a key input device 5. This key input device 5
Is provided with a keyboard 7 for inputting numerical data and various function data, as well as keyboards 6a to 6c for inputting Japanese characters such as Chinese characters. On the keyboard 7, for example, numeric keys, alphabet keys, cursor keys, TAB (tab) keys, calculation instruction keys, total keys, print keys, currency keys such as yen ($), dollar ($), and , “Area”, “execute”, “YES”, “N”
A key having a function such as "O" is provided.

Next, referring to FIG. 2, an electronic circuit provided in the word processor body 1 will be described. In FIG. 2, 11 is a microprogram control circuit, for example, R
It is composed of an OM (Read Only Memory) and stores various control microprograms.
The micro program control circuit 11 includes a key input device 5, an I / O controller 12, a data storage RAM (random access memory) 13, a numerical value table 14 whose details will be described later, an arithmetic circuit 15, and an editing circuit 1.
6, cursor controller 17, message RAM 18
Etc. are connected.

The I / O controller 12 is
Data transfer between the printer 2 and the floppy disk and the RAM 13 is controlled in accordance with a command from the micro program control circuit 11. Further, key input data from the key input data from the key input device 5 is given to the RAM 13. Further, in the RAM 13, data is written in and read out from the numerical table 14 and the arithmetic circuit 15 under the control of the microprogram control circuit 11.

Further, the editing circuit 16 is provided in the document memory 1
9 is edited, and data is written in the document memory 19 from the numerical table 14. And
The data read from the document memory 19 is sent to the display controller 20. Further, the display controller 20 receives the cursor data from the cursor controller 17 and the message read from the message RAM 18. The display controller 20 outputs display data to the CRT display unit 4 via a character generator (not shown) or the like according to the input data.

As shown in FIG. 3, the numerical table 14 is composed of areas A1 to A9. The A1 area has a name, the A2 area has a currency symbol, the A3 area has numerical values, and the A4 area has numerical values. Area start address "fr
om ", the end address" to "of the above numerical value display area in the A5 area, a framed flag in the A6 area, repeated information in the A7 area, an input flag indicating to what extent the A8 area is calculated, and an A9 area in the A9 area. It is designed to store the calculation formula. In this case, the framing flag of the A6 area is written before the name is defined, but is deleted when it is defined. The repetition information in the A7 area is information indicating how many rows the defined name is repeated and how many times.

Next, the operation of the above embodiment will be described. For example, if the estimation table shown in FIG. 4A is created,
First, as shown in Fig. 4 (b), Japanese sentences such as kanji and kana are created one by one from the beginning, but numerical data such as the amount of money is not entered and the Japanese sentence is created or after the completion of the Japanese sentence creation. A process for designating the area or the like is performed. When data is input from the key input device 5 when creating the above document, it is first stored in the RAM 13 and then written in the document memory 19 from the microprogram control circuit 11 through the editing circuit 16.

Then, for example, after the creation of the Japanese sentence is completed, the numerical area is defined. In the case of FIG. 4A, after creating documents up to "Amplifier" ... "Total",
Define the numerical value area for the fixed price "¥ 89,000" of "Amplifier". This numerical value area definition is processed according to the flowcharts shown in FIGS. 5 and 6 by operating the “numerical value” key provided on the keyboard 7. First, as described above, the "numerical value" key is operated, then the cursor is moved to the head of the area to be defined, and then the "area" key is operated as shown in step X1 of FIG. When this "area" key is operated, the process proceeds to step X2, and the address indicated by the cursor is set in the FROM area A4 of the numerical table 14.

Then, as shown in step X3, the cursor is moved to the end of the area to be defined, and then the "area" key is operated as shown in step X4. By operating this "area" key, the next step X5
Then, the process proceeds to step S4 and the address indicated by the cursor is set in the TO area A5 of the numerical table 14. After that, as shown in step X6, flag data is written in the framed flag area A6 of the numerical table 14, the designated area is reversed and the framed image is displayed.

Thereafter, if necessary, the currency symbol as shown in step X7, that is, the yen symbol \ in this case is input. When you input this yen symbol, the currency symbol is written in the currency symbol area A2 of the numerical table 14, and the step X9
In, the currency symbol \ is displayed in the designated area. In step X10, the alphabet key is operated to input a name such as "A". By this key operation, the process proceeds to step X11 to set the name "A" in the name area A1 of the numerical table 14, and in step X12, as shown in FIG. Is displayed.

Then, as shown in step X13 of FIG. 6, the "execute" key is operated. By this key operation, the process proceeds to step X14 to read the message "Repeat?" Stored in the message RAM 18 and display it in the console area 4A of the CRT display unit 4. At this time, if it is not repeated, the "NO" key is operated as shown in step X15. When the "NO" key is operated, the process of designating the numerical area is completed. Also,
When repeating, as shown in step X16, "Y
Operate the "ES" key. If the "YES" key is operated, the process proceeds to step X17, where the message RAM
The message "Please input the number of repeats" is read from 18 and displayed on the CRT display unit 4.

According to the above message, the operator inputs a numerical value n, for example, "4" as shown in step X18, and sets it in the repeat information area A7 of the numerical value table 14.
When the above numerical value n is input, the process proceeds to step X19, and a message "Please input the repetition interval" is displayed. By this display, as shown in step X20, the repetition interval L
Enter, and repeat information area A7 of numerical table 14.
Set to. In the case of FIG. 4, since the document data is displayed every other line, the value of L is “1”. When the repeat interval L is input, the process proceeds to step X21, and the FROM-TO address of the repeat area is calculated by the arithmetic circuit 15. In the address calculation at this time, a numerical area for the product name "tuner" in FIG. 4 is obtained. Then, in step X22, the data obtained in step X21 is set in the FROM area A4 and TO area A5 in the line next to the name A in the numerical table 14.

Next, in step X23, the designated area is highlighted and framed. After that, the process proceeds to step X24, and it is determined whether or not the data set in the FROM-TO area has been completed the number of times of the value n set in step X18. If the result of the above determination is NO, the process returns to step X21 and the same processing is repeated. When the processing of n times is completed, the determination result of step X24 becomes YES and the setting processing of the numerical value area is completed.

In the above process, X1, X3,
In the key input step of X4, X7, X10, X13, X15, X16, X18, X20, etc., a key wait signal is sent from the micro program control circuit 11 to the key input device 5 until the key operation is performed. After defining the numerical area for the fixed price as described above, the numerical area for the multiplication rate, price, total, etc. is similarly defined.

Next, a calculation formula for obtaining prices, totals, etc. will be defined. The definition of this calculation formula is "calculation formula" on the keyboard 7.
The operation is performed according to the flow shown in FIGS. 7 and 8 by operating the keys. First, when the "calculation formula" key is operated, "1. definition" and "2. reference" are displayed in the console area 4A of the CRT display section 4 under the control of the microprogram control circuit 11 as shown in step Y1 of FIG. Message is displayed.

In the case of the calculation formula definition, as shown in step Y2, the numerical key "1" is operated to specify "1. Definition". By the above definition designation, "1. continuous" and "2. individual" are displayed in the console area 4A of the CRT display section 4 as shown in step Y3. In case of continuous operation, the numerical key "1" is operated to specify "1. continuous" as shown in step Y4. By the above continuous designation, as shown in step Y6, the first name, that is, the first name "A" registered in the numerical value table 14 is displayed in the console area 4A. Since it is not necessary to define an expression for this name "A", the "execute" key is operated to pass.

By operating this execution key, the next name "B"
Is read from the numerical table 14 and displayed in the console area 4A. There is no need to define an expression for this "B" either, so the "execute" key is operated to pass. By the operation of this execution key, the next name "C" is read from the numerical value table 14 and displayed in the console area 4A. Since this name "C" is for the price and it is necessary to define the formula, "C = A ×" is calculated in step SY6.
B ”That is, the multiplication formula of“ fixed price ”and“ multiplication rate ”is defined by key operation.

Next, in step Y7, the above formula is written in the formula area A9 of the numerical table 14. After that, the framing flag in the area A6 in the numerical table 14 is reset, and the CRT is set as shown in step Y8.
The frame for the name C on the display unit 4 is released. Then, in a step Y9, it is determined whether or not the process has proceeded to the last name. If the last name is not over,
Returning to step Y5, the same processing is repeated. In the example of FIG. 4, a calculation formula for the name “D”, that is, a calculation formula for summing the values of the respective Cs is defined by key operation, and the numerical table 1
4. Write in the formula area A9 of 4. Then, when the definition of the formulas for all the names is completed, the decision result in the step Y9 becomes YES, and the calculation formula definition flow ends.

On the other hand, in step Y3, in response to the display of "1. continuous" and "2. individual", the numerical key "2" is operated to specify "2. individual" as shown in step Y10. In this case, as shown in step Y11, the name "C" defined by the key operation is input. A search in the numerical value table 14 is performed by designating the name "C". Then, when the formula for "C" is defined as shown in step Y13, the formula is set in the formula area A9 in the numerical table 14 in step Y14.

Then, as shown in step Y15, the process of releasing the frame is performed. Then, when the name "D" to be defined is next designated, the processing of steps Y11 to Y15 is repeated. Then, when the calculation formula definition for the predetermined name is completed, the "execute" key is operated as shown in step Y16. The operation of the "execute" key ends the flow of the calculation formula definition.

When "1. Definition" and "2. Reference" are displayed in step Y1, the numeric key "2" is operated to select "2. If "reference" is designated, the contents of the numerical value table 14 are read in step Y18, and a list display is performed in step Y19 as shown in FIG. As shown in FIG. 9, this list display is performed for four items of "in use", "expression is undefined", "area is undefined", and "repetition number mismatch". The above "in use" is the name "C", "D" where the formula is defined, and the "undefined formula" is the name "A", "B" where the region is defined and does not appear in the formula,
"Area is undefined" is a name that has been defined in the expression and has no area, and "Inconsistency in repeat count" is a name in which the repeat count is inconsistent in the calculation formula for repeats. This "repeat count mismatch"
Is a case where, for example, in “C = A × B”, the number of repetitions of A and B is different. The definition state of the calculation formula is confirmed by the list display in step Y19. If it is not correctly defined, the "execute" key is operated as shown in step Y20 to return to step Y1 and the definition operation is performed again. If it is defined correctly, step Y21
As shown in, the "END" key is operated to end the calculation formula definition flow.

However, the basic document created as described above is stored in the floppy disk. When using, specify the document file name and load it from the floppy disk to the document memory 19, and
The necessary items are loaded into the numerical value table 14. By this document loading, the process proceeds to step Z1 in FIG. 10, and the document including the numerical area is displayed on the CRT display unit 4 as shown in FIG. 4 (b). In this state, the cursor is displayed in the numerical value leading area as shown in step Z2.

After that, as shown in step Z3, a numerical value is input by a key operation. In this example, first, the fixed price "89,000" for the amplifier is input and the "TAB" key is operated. By inputting the above-mentioned numerical value, the process proceeds to step Z4 to erase the reverse display of the area corresponding to the input numerical value and switch to the normal display. Next, the process proceeds to the calculation and the process of setting the numerical value table shown in step Z5, but at this point the calculation is not performed and the numerical value input is written in the numerical value table 14.

Then, in step Z6, the input flag of the A7 area in the numerical table 14 is set. Then, as shown in step Z7, the cursor is moved to the next numerical value area, for example, the multiplication numerical value area, and then it is determined in step Z8 whether or not the data writing to all the numerical value areas is completed. If the writing of data is not completed, the process returns to step Z3 and waits for key input. In this state, a numerical value for the multiplication factor, for example, "0.8" is input and the "TAB" key is operated. By inputting the above numerical values, the process proceeds to step Z5 via step Z4 to calculate "C = A × B", that is, "8.
The calculation "9,000.times.0.8 = 71,200" is performed by the arithmetic circuit 15, and the calculation result is written in the numerical value area A3 in the numerical value table 14. At this time, the calculation of “D = total C” is performed, and the numerical area A in the name D is calculated.
It is written in 3 and displayed on the CRT display section 4.

Similarly, by inputting the fixed price and the multiplication rate for the "tuner", "speaker", and "player", the price and total value of each product are obtained and written in the corresponding numerical area A3. Then, when the input of the fixed price and the multiplication rate for all the products is completed, after the calculation is completed, the process proceeds from step Z8 to step Z9 to wait for the key input. When the "print" key is operated in this state, the contents of the document memory 19 are read out to the I / O controller 12 via the editing circuit 16 by the control of the microprogram circuit 11 and sent to the printer 2 to be sent to the step Z.
The printing process shown in 10 is performed. That is, in step Z10, the contents displayed on the CRT display section 4 are sent from the document memory 19 to the printer 2 and printed, as shown in FIG.

[0034]

According to the present invention, in a system in which a storage table is prepared corresponding to each of a plurality of areas arranged in a table format in the row and column directions, a desired area in each of the above areas can be selected. When designating, whether to designate the regions sequentially and continuously by operating the keys, or by inputting the region name defined for the desired region,
Can be selected according to the operator's request, and in any case, the storage table corresponding to the specified area is specified, so that the desired area for the storage table can be specified. A calculation formula having a name as a variable can be immediately set and stored. Further, by the calculation based on the calculation formula set in this way, the numerical data of the calculation result is stored in a storage area different from the storage area of the calculation formula in the storage table in which the calculation formula is set and stored. Since it is automatically stored and the stored numerical data is displayed as the data corresponding to that area,
When a calculation formula is set in a desired region of a plurality of regions, the calculation result can be immediately confirmed on the region while the stored contents of the calculation formula are held.

[Brief description of drawings]

FIG. 1 is an external perspective view of an electronic display device according to an embodiment of the present invention.

FIG. 2 is a circuit configuration diagram in the embodiment.

FIG. 3 is a diagram showing a storage configuration of a numerical table in FIG.

FIG. 4 is a diagram showing a display example at the time of creating a quotation table.

FIG. 5 is a flowchart illustrating an operation of defining a numerical area.

FIG. 6 is a flowchart illustrating an operation of defining a numerical area.

FIG. 7 is a flowchart showing the operation of defining a calculation formula.

FIG. 8 is a flowchart showing the operation of defining a calculation formula.

FIG. 9 is a view showing a display example when referring to a definition state.

FIG. 10 is a flowchart showing an operation at the time of loading a document.

[Explanation of symbols]

1. Word processor, 2. Printer, 3.
a, 3b ... Floppy disk part, 4 ... CRT display part, 4A ... Console area, 5 ... Key input device, 6a-6c, 7 ... Keyboard, 14 ... Numerical table, 15 ... Arithmetic circuit, 19 ... Document memory.

Claims (2)

(57) [Claims] 1.On the display screenTabular format in rows and columns
Multiple areas arranged inEach of the
Righteous means, The memory table corresponding to each area defined by this area name
Storage means for storing the table, When continuously specifying each of the above areas,
The storage table corresponding to the designated area is sequentially consecutive
To First specifying means for specifying,When specifying the area by the area name above, specify the desired area
When the area name to be entered is entered, this entered area name
Search the storage table corresponding to the area specified by finger
Second specifying means for setting,By any one of the first or second designating means
After specifying the memory table, change the desired area name to a variable.
When the calculation formula to be input is input, this calculation formula is
Formula data in the formula storage area in the fixed storage table
Setting means to set by When executing the calculation based on the above formula, use this formula
Memory corresponding to the area specified by each area name included in
Read the numerical data stored in the numerical storage area of the table.
Find it out and use this read numerical data in the above formula.
By substituting The calculation means for executing the calculation and the numerical data of this calculation resultThe formula data of the formula is
In the numerical storage area of the set storage table
Storage control as numerical dataStorage control means forThe memory-controlled numerical data is stored in the memory table.
On the above display screen as numerical data of the area corresponding to
 A numerical data calculation device comprising: a display control unit for controlling display. 2. A storage that defines each of a plurality of areas arranged in a table format in the row and column directions on a display screen by an area name, and is prepared corresponding to each area defined by the area name. This is a method of calculating numerical data using a table, and when continuously specifying each of the above areas, every time a predetermined key is operated,
When the storage table corresponding to the area to be specified is sequentially and sequentially specified, and when the area is specified by the area name, when the area name that specifies the desired area is input, it is specified by the input area name. When the storage table corresponding to the specified area is searched and specified, and the calculation formula with the desired area name as the variable is input,
This calculation formula is set as formula data in the calculation formula storage area in the storage table specified by any of the above-mentioned specification methods, and when executing the calculation based on the above-mentioned calculation formula, The numerical data stored in the numerical storage area of the storage table corresponding to the area specified by the area name is read, and the read numerical data is substituted into the above calculation formula to execute the calculation. The numerical data of is stored and controlled as numerical data in the numerical storage area of the storage table in which the formula data of the calculation formula is set, and the stored numerical data is stored in the area corresponding to the storage table. The numerical data calculation method is characterized in that the display is controlled on the display screen as above.