JPH1125198A - Table calculation device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a table calculation device capable of easily executing trial calculation without losing information related to a value previously allowed to correspond to a cell. SOLUTION: Basically a storing means 5 stores value-related information correspondingly to a cell and a table calculation means 6 calculates a value to be displayed on the cell based on the value-related information stored in the means 5. When a changing means 7 changes the value-related information stored in the means 5, a saving means 8 saves the value-related information changed by the means 7, a control means 9 allows the means 6 to calculate a value to be displayed on the cell based on the changed value-related information, and then a restoring means 10 restores the changed value-related information based on the value-related information saved in the means 8. Thereby the value-related information stored in the means 5 and allowed to correspond to the cell can be changed and easily utilized, and after using the information, the changed information can be restored to the original information.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a spreadsheet apparatus for calculating a numerical value to be displayed in a cell based on information relating to a numerical value associated with the cell. Related to a computing device.

[0002]

2. Description of the Related Art Conventionally, in a process such as sales management of a company, cash management of money, profit and loss management of stock trading, credit evaluation management of stocks, totalization of experimental data, and the like, a spreadsheet process has been used to improve work efficiency. Is being done. As an example of a spreadsheet device that performs such a spreadsheet process, a spreadsheet device used in a securities sales support system is shown in FIG.
This will be described with reference to FIG. This spreadsheet apparatus includes a client 13 connected to a server 11 via a network 12.
The numerical value of the customer information or securities market information stored in the server 11 is received via the network 12 and can be used for spreadsheet processing.

A table including a plurality of cells as shown in FIG. 1 is displayed on a display screen 14 of the spreadsheet apparatus. Here, A, B, C,... Arranged vertically on the display screen 14 represent cell row numbers, and 1, 2, 3,... Arranged horizontally represent cell column numbers. Each cell is given an identification name of a set of a row number and a column number (for example, “A1”, “B2”, etc.). In the following, a cell is represented by the identifier.

A cell is associated with information on a numerical value, and the spreadsheet calculates a numerical value to be displayed in the cell based on the information on the numerical value. The information related to a numerical value associated with a cell includes information such as a numerical value, a calculation expression including an identifier of another cell, an expression including an identifier representing a numerical value in a server, and, for example, information associated with the cell. If the information about the numerical value is a formula that includes the distinguished name of another cell, it means that the numerical value displayed in the cell is a numerical value obtained by applying the numerical value displayed in the cell of the distinguished name to the formula, In the case of a formula including an identifier representing a numerical value in the server, it means that the numerical value displayed in the cell is a numerical value obtained by applying the numerical value of the identifier to the formula.

[0005] In some cells of the display screen 14 shown in FIG. 8, information relating to numerical values associated with the cells is displayed. For example, a cell "B3" has a cell "B3".
The identifier “i2” is associated with the cell “B5”, and a calculation formula including the identifiers of the cells “B2”, “B3”, and “B4” is associated with the cell “B5”. In "", the numerical value obtained from the server is displayed, and the cell "B3"
Displays the same numerical value as the numerical value displayed in cell "i2", cell "B4" displays the same numerical value as the numerical value displayed in cell "i3", and cell "B5" displays the cell. "B
2 "," B3 ", a numerical value obtained by adding the numerical values displayed in" B4 "are displayed. In a cell" B6 ", a numerical value obtained by multiplying the numerical value displayed in the cell" B5 "by 0.5 is displayed. It should be noted that the cell can be associated with information for managing input or output of information on the cell in addition to information on the numerical value, for example, limiting input of information on the cell. And so on.

Next, the spreadsheet processing in the above-mentioned conventional spreadsheet apparatus will be described. When a predetermined task is performed using a spreadsheet device, there are usually cells to which information related to numerical values are associated in advance and cells to which the user should input information related to numerical values. Then, when the spreadsheet device receives the input of the numerical value for the cell to be input by the user,
A numerical value to be displayed in each cell is calculated based on a numerical value input to the cell and information on a numerical value previously associated with the cell. As a result, the user can easily obtain the numerical values necessary for the job.

[0007]

Here, problems in the conventional spreadsheet apparatus will be described with reference to FIG. In addition,
FIGS. 9A and 9B each show a part of the display screen 14 in FIG. For example, as shown in FIG. 9A, when a numerical value associated with the cell “B2” is set to a certain numerical value, when performing a trial calculation as to what numerical value is displayed in the cell “B5”, the user needs By inputting a numerical value into the cell “B2”, the result of the trial calculation is displayed in the cell “B5” based on the input numerical value. However, as described above, if a numerical value is input to a cell in which information relating to a numerical value is previously associated, information relating to a numerical value associated with the cell in advance is overwritten and lost. Become.

Further, in order to prevent the information relating to the numerical value associated with the cell from being lost, it is necessary to restrict the user's input to the cell associated with the information relating to the numerical value in advance. In some cases, a trial calculation cannot be performed. Therefore, in the conventional spreadsheet apparatus, in order to secure information on the numerical value associated with the cell in advance, and to be able to perform the trial calculation, a new cell is created and a numerical value is assigned to the created cell. There is a problem that it is necessary to correspond information on the information.

Further, as shown in FIG. 9B, the cell "B"
When the numerical value displayed in 5 "becomes a certain numerical value, the same problem as described above also occurs in the reverse calculation such as what numerical value is displayed in cell" B2 ".

The present invention has been made in view of the above-mentioned conventional circumstances, and provides a spreadsheet apparatus capable of easily performing a trial calculation without losing information on a numerical value previously associated with a cell. It is an object.

[0011]

In order to achieve the above object, a spreadsheet apparatus according to the present invention includes a plurality of cells as an input area or a display area, and based on information related to numerical values associated with the cells. In a spreadsheet apparatus for calculating a numerical value to be displayed in a cell, a holding unit for holding information relating to the numerical value in association with the cell, and a table for calculating a numerical value to be displayed in the cell based on the information regarding the numerical value held in the holding unit Calculating means, changing means for changing the information on the numerical value held in the holding means, saving means for saving and storing the information on the numerical value changed by the changing means in association with the cell, based on the information on the changed numerical value Control means for calculating a numerical value to be displayed in the cell by the spreadsheet means, and information changed by the information on the numerical value stored and saved in the saving means. And restoring means for restoring the information relating to comprising the. Here, the information related to a numerical value includes information such as a numerical value itself, a calculation formula using a numerical value displayed in another cell, and the like.

In the above-mentioned spreadsheet apparatus, basically, the holding means holds information relating to numerical values in association with cells,
The table calculation means calculates a numerical value to be displayed in the cell based on the information on the numerical value held in the holding means. When the changing means changes the information on the numerical value held in the holding means, the saving means saves the information on the numerical value changed by the changing means in association with the cell, and the control means saves the changed numerical value. Then, the numerical value to be displayed in the cell is calculated by the spreadsheet based on the information about the numerical value, and thereafter, the restoring means restores the information about the changed numerical value based on the information about the numerical value saved and stored in the saving means. Therefore, the information related to the numerical value associated with the cell held in the holding means can be changed and used easily, and after the use, the changed information can be restored to its original state.

[0013]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A spreadsheet apparatus according to one embodiment of the present invention will be described with reference to FIG. This spreadsheet apparatus is constituted by a client 3 connected to a server 2 via a network 1, and includes a display unit 4, a holding unit 5, a spreadsheet unit 6, a change unit 7, and a save unit 8
, Control means 9 and restoration means 10.

The display means 4 is constituted by a display device such as a display device, and has a display screen as shown in FIG. 1. The input means (not shown) such as a keyboard and a mouse from a user together with a display output. It is an interface that accepts input by. The screen has the following functions.

The cell S receives input of information on a numerical value associated with the cell, and displays and outputs a numerical value calculated by the spreadsheet means 6 based on the information on the numerical value associated with the cell. The cell contains
It is possible to associate input restriction information that rejects input of information related to numerical values, and a cell associated with the input restriction information does not accept input of information related to numerical values.

Here, some cells in the display screen will be described in detail. The cell “B2” is associated with an identifier representing a numerical value in the market information held in the server, and the numerical value (10 in this embodiment) in the corresponding market information is displayed. The cell “B3” is associated with “i2”, and when the calculation by the spreadsheet unit 6 is performed based on this association, the same numerical value as the numerical value displayed in the cell “i2” is displayed. The cell “B4” is associated with “i3”, and when the calculation by the spreadsheet unit 6 is performed based on this association, the same numerical value as the numerical value displayed in the cell “i3” is displayed.

In the cell "B5", "= B2 + B3 + B
4 "are associated with each other, and when the calculation by the spreadsheet 6 is performed based on this association, the sum of the numerical values displayed in the cells" B2 "," B3 ", and" B4 "is displayed. The cell “B6” is associated with “= B5 * 0.5”, and when the calculation by the spreadsheet unit 6 is performed based on this association, the numerical value displayed in the cell “B5” is obtained. The result obtained by multiplying by 0.5 is displayed.Input restriction information is associated with the above-mentioned cells "B2" to "B6". This prevents a user from inputting information, thereby preventing a situation in which information on numerical values is accidentally lost.

When the trial calculation button 4a is pressed, an instruction to perform a trial calculation process, which will be described later, is notified to the changing means 7. Thereby, the user can, for example, select cell “B2” and cell “B”.
It is possible to perform a trial calculation such that a numerical value is input to at least one of the 3 "cells" B4 "and the numerical value is displayed in the cell" B5 ". The user is notified of an instruction to perform one process to the changing unit 7. Thereby, for example, the user inputs a numerical value to the cell “B5” and the input numerical value is changed to the cell “B”.
A trial calculation (back calculation) of displaying a numerical value displayed in the cell "B2" when it is displayed in "5" can be performed.

When the back calculation 2 button 4c is pressed, an instruction to perform a back calculation second process, which will be described later, is sent to the changing means 7.
Thus, the user inputs a numerical value in cell “B6”, for example, and displays a numerical value displayed in cell “B3” when the input numerical value is displayed in cell “B6” (back calculation). It can be performed. Normal button 4d
Is pressed, the restoration unit 10 is notified of an instruction to perform a restoration process described later. Thereby, the information on the numerical value displayed in the cell and the numerical value associated with the cell can be restored to the initial state before the trial calculation. The normal button 4d is displayed after any one of the trial calculation process, the reverse calculation first process, and the reverse calculation second process is performed.

The holding means 5 holds information on numerical values associated with the cells and input restriction information associated with the cells. The table calculation means 6 calculates a numerical value to be displayed in each cell based on the information on the numerical value held in the holding means 5, and displays the result in the cell.

Upon receiving an instruction to perform the trial calculation process from the display unit 4, the change unit 7 removes the input restriction information associated with the cell from the holding unit 5. Here, as the target cell, in the present embodiment, a cell to which the identification name of the server information is associated, or a cell to which only the identification name of another cell is associated, The cells “B2”, “B3”, and “B4” shown in FIG. 1 correspond to this. The present invention is not limited to this, and all cells may be targeted. In short, the numerical value displayed on the target may include cells used by other cells. Next, the input of the information on the numerical value corresponding to the cell from which the input restriction information has been removed is received from the user, and the information on the numerical value corresponding to the cell held in the holding unit 5 is changed to the information received from the cell. I do.

When the change unit 7 receives an instruction to perform the first operation or the second operation from the display unit 4, the change unit 7 removes the input restriction information associated with the cell from the holding unit 5. Here, as the target cell, in the present embodiment, a cell to which a calculation formula including the identification name of a plurality of cells is associated, and a calculation expression such as a cell identification name and another numerical value are associated. In the case of the first operation, the cell "B5" shown in FIG. 1 is targeted, and in the case of the second operation, the cell "B6" shown in FIG. 1 is targeted. The present invention is not limited to this, and all cells may be targeted.

Next, the information related to the numerical value stored in the holding means 5 in association with the predetermined cell is changed into a predetermined reverse formula and stored. Here, as the predetermined cell,
The cell in which the numerical value displayed by the cell from which the input restriction information has been removed is used. For example, in the case of the first operation, the cell "B2" shown in FIG. 1 is used. Are the cells "B3" and "B" shown in FIG.
5 ".

[0024] Further, the predetermined reverse calculation formula is a calculation formula which can calculate the numerical value displayed in the predetermined cell from the numerical value displayed in the cell from which the input control information has been removed. The inverse formula for the cell "B2" in the case of one process is "= B5-B3-B4".
In the case of the second operation, the reverse calculation formula for the cell "B3" is "= B5-B2-B4", and the reverse calculation formula for the cell "B5" is "= B6 / 0.5". Then, the input of the numerical value corresponding to the cell from which the input restriction information has been removed is received from the cell, and the information on the numerical value corresponding to the cell stored in the holding unit 5 is changed to the received information.

The evacuation means 8 changes at least one of the information on the numerical value associated with the cell stored in the holding means 5 and the input restriction information associated with the cell. At this time, the information to be changed is saved and stored in association with the cell.

After the information on the numerical value associated with the cell held by the holding means 5 is changed by the changing means 7, the control means 9 sends the information to the table calculation means 6 based on the information on the changed numerical value. Calculate and display in cell. Upon receiving the instruction of the restoration process from the display unit 4, the restoration unit 10 restores the information held in the holding unit 5 based on the information about the numerical value saved and stored in the storage unit 5 and the input restriction information, and restores the information. The calculation is performed by the spreadsheet means 6 based on the obtained information, and the result is displayed in the cell.

Next, the operation of the above spreadsheet apparatus will be described. In this spreadsheet apparatus, as an initial operation, the spreadsheet means 6 calculates a numerical value to be displayed in each cell on the basis of information on a numerical value associated with a cell stored by the holding means 5, Is displayed in a cell on the display screen. When the trial calculation button 4a is pressed, the following trial calculation processing is performed. When the reverse calculation 1 button 4b is pressed, the reverse calculation first processing described below is performed, and the reverse calculation 2 button 4c is pressed. When the button is pressed, a second trial calculation process described below is performed. In the following description, a process for the cells “B2” to “B6” in the B row will be described as an example.

In the trial calculation process, as shown in FIG. 2, the changing means 7 removes the input restriction information associated with the cells "B2", "B3", "B4" from the holding means 5, and the evacuation means 8 Cells "B2", "B3", "B4" to be removed
Is saved in association with the cell.

Next, the changing means 7 sets the cells "B2", "B2"
The user's numerical input to at least one of the cells B3 "and" B4 "is accepted, the information on the numerical value associated with the corresponding cell in the holding means 5 is changed to the accepted numerical value, and the evacuation means 8 is changed. The information relating to the numerical value associated with the cell is saved and stored in association with the cell, and thereafter, the control means 9 is changed by the spreadsheet means 6 to the retaining means 5 based on the information relating to the retained numerical value. The cell is calculated and the result is displayed in the cell, whereby the cells “B2”, “B3”, “B4”
When you associate various numbers with, what number is
It is possible to make a trial calculation as to whether it is displayed in B5 ".

In the first operation of the back calculation, as shown in FIG. 3, the changing means 7 removes the input restriction information associated with the cell "B5" from the holding means 5 and the saving means 8 replaces the input restriction information with the cell "B5" to be removed. The associated input restriction information is saved in association with the cell. Then, the changing means 7 changes the information on the numerical value stored in the holding means 5 in association with the cell "B2" to the inverse formula "= B5-B3-B4", and the evacuation means 8 changes the cell to be changed. Saves information related to the associated numerical value.

Next, the changing means 7 receives the user's numerical input to the cell "B5", and as shown in FIG.
= B2 + B3 + B4 "is changed to the accepted numerical value, and the save unit 8 converts the calculation formula" = B2 + B3 + B4 "into the cell" B5 ".
Is saved in association with.

Thereafter, the control means 9 causes the spreadsheet means 6 to calculate the numerical value to be displayed in the cell based on the information on the numerical value changed and stored in the storing means 5, and displays the result in the cell. For example, in the cell “B2”, the numerical value associated with the cell “B5” and the cell “B”
The numerical value calculated based on the inverse calculation formula “= B5-B3-B4” associated with 2 ”is displayed.
When a desired numerical value is displayed in the cell “B5”, a trial calculation can be performed by back calculation as to what numerical value is displayed in the cell “B2”.

In the second operation of the back calculation, the changing means 7 sets the cell "B"
The input restriction information associated with the cell "B6" is removed from the holding means 5, and the input restriction information associated with the cell "B6" to be removed is saved and stored in association with the cell "B6". The changing means 7 changes the information about the numerical value stored in the holding means 5 in association with the cell "B3" to the inverse formula "= B5-B2-B4", and in association with the cell "B5". The calculation formula “= B2 + B3 + B4” stored in the holding means 5 is converted to the inverse calculation formula “=
B6 / 0.5 ", and the evacuation means 8 saves the information on the numerical values associated with the cells" B3 "and" B5 "to be changed in association with the cells.

Next, the changing means 7 receives the user's numerical input to the cell "B6", and as shown in FIG. 5, the calculation formula "corresponding to the cell" B6 "of the holding means 5
= B5 * 0.5 "to the accepted numerical value, and the save unit 8 saves the calculation formula" = B5 * 0.5 "in association with the cell" B6 ".

Thereafter, the control means 9 causes the spreadsheet means 6 to calculate the numerical value to be displayed in the cell based on the information on the numerical value changed and stored in the storing means 5, and displays the result in the cell. For example, in the cell “B5”, the numerical value associated with the cell “B6” and the cell “B”
The numerical value calculated based on the inverse calculation formula “= B6 / 0.5” associated with “5” is displayed. In cell “B3”, the numerical value displayed in cell “B5” and the cell “B3” are displayed. The numerical value calculated based on the associated inverse formula “= B5-B2-B4” is displayed, whereby the cell “B6” is displayed.
If the desired numerical value is displayed in the cell "B3" or the cell "B5", it is possible to perform a trial calculation based on the back calculation of what numerical value is displayed in the cell "B3" or the cell "B5".

After the trial calculation, the first calculation, and the second calculation, the normal button 4d can be pressed. When the user presses the normal button 4d, the following restoration processing is performed. . That is, in the restoration processing, the restoration unit 10 reflects the information related to the numerical value and the input restriction information associated with the cell stored and saved by the saving unit 8 in the information related to the numerical value and the input restriction information held in the holding unit 5. Let it. As a result, the state of the information related to the numerical value and the input restriction information held by the holding unit 5 can be restored to a state in which the trial calculation process, the first back calculation process, and the second back calculation process are not performed.

Then, the restoring means 10 causes the spreadsheet means 6 to calculate a numerical value to be displayed in the cell based on the restored information, displays the result in the cell, and performs a trial calculation process and a reverse calculation on the numerical value displayed in the cell. The state before the first processing and the back calculation second processing are performed is restored.

An example in which the above spreadsheet apparatus is applied to a securities business support system will be described with reference to FIGS. FIG. 6 shows a display screen of the display means 4 in the case of performing profit and loss calculation in stock trading. Normally, for example, a user enters "limit" and calculates "profit". "Profit" to "limit price"
It is also possible to perform a back calculation process such as back calculation.

In this spreadsheet apparatus, the formula for calculating “profit” from “limit price” in the ordinary spreadsheet processing is Expression A shown in FIG.
"Limit price" in back calculation process to calculate "limit price" from
Is a formula B shown in FIG.

FIG. 7 shows a display screen of the display means 4 when a credit evaluation calculation of a certain customer is performed. For a cell indicating cash, a cell indicating elapsed cost, and a cell indicating a market value of a certain brand, The user can perform various trial calculations by inputting numerical values.

In the above embodiment, the retracting means 10
Saves only the information related to the numerical value associated with the cell to be changed and the input restriction information associated with the cell to be changed, thereby reducing the storage capacity required for the evacuation storage and processing the evacuation storage. Although the efficiency is improved, information on numerical values and input restriction information associated with all cells may be saved and stored. In the above-described embodiment, the spreadsheet device is configured by a client (information processing device) connected via a network, but may be configured by a single information processing device not connected to a network.

[0042]

As described above, the spreadsheet apparatus according to the present invention changes the information relating to the numerical values held in advance in association with the cells and performs the trial calculation. Is saved and after the calculation is completed,
Based on the information on the numerical value saved and stored, the information on the numerical value previously associated with the cell is restored, so that the information on the numerical value associated with the cell in advance can be used without deteriorating, and the trial calculation can be easily performed. It can be carried out.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of a spreadsheet apparatus according to an embodiment of the present invention.

FIG. 2 is a diagram illustrating a trial calculation process of a spreadsheet apparatus according to an embodiment of the present invention.

FIG. 3 is a first diagram illustrating a back calculation first process of the spreadsheet apparatus according to one embodiment of the present invention;

FIG. 4 is a second diagram illustrating a first process of back calculation of the spreadsheet apparatus according to one embodiment of the present invention.

FIG. 5 is a diagram illustrating a second process of back calculation of the spreadsheet apparatus according to one embodiment of the present invention.

FIG. 6 is a first example in which a spreadsheet device according to an embodiment of the present invention is applied to a securities business support system.

FIG. 7 is a second example in which the spreadsheet device according to one embodiment of the present invention is applied to a securities business support system.

FIG. 8 is a configuration diagram of a spreadsheet device according to a conventional example.

FIG. 9 is a diagram illustrating a spreadsheet calculation by a spreadsheet apparatus according to a conventional example.

[Explanation of symbols]

1. server, 2. network, 3. client, 4. display means, 5. holding means, 6. spreadsheet means, 7. change means, 8.
Evacuation means, 9 control means, 10
..Restoration means.

Claims (1)

[Claims] 1. A spreadsheet apparatus comprising a plurality of cells as an input area or a display area, and calculating a numerical value to be displayed in a cell based on information on a numerical value associated with the cell. Holding means for associating and holding; table calculation means for calculating a numerical value to be displayed in a cell based on information about the numerical value held in the holding means; changing means for changing information about the numerical value held in the holding means; Evacuation means for evacuation-storing information related to the numerical value changed by the changing means in association with the cell; control means for causing the spreadsheet means to calculate the numerical value to be displayed in the cell based on the information related to the changed numerical value; Restoring means for restoring information related to the changed numerical value based on the information related to the numerical value stored and stored. Calculation apparatus.