Patent ID: 7783966
Filing Date: 2010-08-24
Classification: G06F

Abstract:
1. A method for performing a calculation processing for each cell in a sheet by setting a calculation formula to calculate values for the cell using a computer, comprising; a storing step where the computer stores a first sheet, a second sheet and a correspondence information allowing a cell in the first sheet and a cell in the second sheet to correspond to each other in a memory unit of the computer, the first sheet and second sheets including data with a queue structure for managing the updating and re-calculating of cells in the first sheet and the second sheet; an associating step of using associating information to associate cells in the first sheet and the second sheet with the associating information including an association type; a further associating step of associating the values of each of the cells in both the first sheet and the second sheet, the value of each of the cells in the second sheet being an array of values, and the value of each of the cells in the first sheet being one of the elements of the array of values corresponding to the value of one of the cells in the second sheet; an input data step where the computer sequentially selects a respective plurality of input data as values for cells within the first sheet, in response to deciding that the cells where a plurality of input data are recorded within the first sheet correspond to the array of values of the cells within the second sheet, according to the correspondence information; a further input data step of generating temporary sheets corresponding to the input data, and generating additional temporary sheets equivalent to an increase in the input data; a calculation step where the computer performs, in response to respective input data selected as values for the cells within the first sheet in the input data selection step, a calculation with a calculation formula set in a cell in the first sheet other than the cells containing the input data and referring to the cells within the first sheet corresponding to one of the elements of the array of values of the cells in the second sheet; a further calculation step of extracting cells in the temporary sheets and recalculating values of the cells in the temporary sheets, the temporary sheets forming an iterative calculation without control variables; a modification step for modifying intermediate states of iterations of the recalculating of the values of the cells in the first sheet, the second sheet, and the temporary sheets by interactively viewing and changing values of one of the cells in the first sheet, second sheet, and temporary sheets; a further calculation step of the computer finding all cells that refer to one of the cells in the temporary sheets and adding the cells that refer to one of the cells in the temporary sheets to a queue for calculating the contents of one of the cells in the temporary sheets when a value is stored in one of the cells in the temporary sheets; and a data output step where the computer outputs calculated results calculated with the calculation formula obtained in the calculation step for the respective input data, as one or more values of second cells within the second sheet corresponding to the cell in the first sheet where the calculation formula is set, according to the correspondence information.