System and methods for improved scenario management in an electronic spreadsheet

Claim 2

An electronic spreadsheet system for processing different versions of a spreadsheet model comprising: (a) a processor and a storage means; (b) means for maintaining a base version of said spreadsheet model as ordered information on said storage means, said ordered information including a first type of information that includes data values and a second type of information that depends on other portions of said ordered information; (c) means for creating a new version of said spreadsheet model in response to user input specifying modification of at least one portion of said ordered information; (d) comparison means for determining portions of said new version which have changed when compared against said base version, said comparison means being responsive to said at least one portion of said ordered information that changed in direct response to said user input, and further responsive to information of said second type that changed as a result of changes to said at least one portion of said ordered information; and (e) versioning means for maintaining said new version by storing additional information for only those portions determined to have changed.

Claim 3

The system of claim 1, wherein: said spreadsheet model maintains information in a plurality of information cells; said ordered information includes a first set of data records describing information cells of said base version; and said additional information includes a second set of data records describing information cells for only those portions of said new version determined to have changed.

Claim 4

The system of claim 2, wherein each data record of said second set which describes an information cell is a version record storing a changed value for its cell.

Claim 5

The system of claim 3, wherein each version record further includes a cell location.

Claim 6

The system of claim 2, further comprising: means for creating an additional new version of said spreadsheet model; and means for storing additional information for said additional new version as a subsequent subset of said second set of data records.

Claim 7

The system of claim 5, wherein: each data record of said second set which describes an information cell is a version record storing a changed value for its cell; and each version record further includes an identifier associating the record with a specific new version.

Claim 8

The system of claim 5, wherein: each data record of said second set which describes an information cell is a version record storing a changed value for its cell; and version records for each new version are stored so that a specific new version may be inferred.

Claim 9

The system of claim 7, wherein version records for a particular new version are grouped as a discrete subset so that the version may be inferred from the ordinal position of the subset relative to other subsets.

Claim 10

The system of claim 8, further comprising: means for grouping desired ones of the new versions into discrete subgroups, each said subgroup having a user-supplied group name.

Claim 11

The system of claim 9, further comprising: group selection means for selecting a desired one of said subgroups, whereby only those new versions within a selected subgroup are immediately available for display.

Claim 12

The system of claim 5, further comprising: means for associating each new version with a user-supplied descriptive label.

Claim 13

The system of claim 11, further comprising: means for displaying a list of all user-supplied descriptive labels; input means for selecting a desired version by choosing one of said user-supplied descriptive labels from said list; and means for displaying a version whose descriptive label has been selected with said input means.

Claim 14

The system of claim 12, wherein each said descriptive label includes textual information describing a version.

Claim 15

The system of claim 11, wherein said spreadsheet model maintains information in a plurality of information cells, and wherein said comparison means includes means for comparing each information cell of said new version against a corresponding information cell of said base version, whereby a difference in value between the two cells is identified as a change.

Claim 16

The system of claim 14 further comprising: user feedback means for automatically highlighting any changes between said new version and said base version.

Claim 19

The system of claim 16, further comprising: means for selectively disabling cell highlighting for cells whose changes are not of interest to the user.

Claim 20

In an electronic spreadsheet system for modeling user-specified information in a data model comprising a plurality of information cells, a method for automatically identifying modifications to the data model by a user, the method comprising: (a) specifying a reference set of information cells for the system to track user modifications against, said reference set of information cells including a first subset of information cells that store data and a second subset of information cells which directly or indirectly reference at least one information cell in said first subset; (b) creating a new scenario of said data model in response to user input specifying modification of at least one of said information cells from said reference set, said new scenario having information cells corresponding to said information cells in said reference set, said new scenario including (i) said at least one of said information cells, so modified, and (ii) information cells in said second subset which directly or indirectly reference said at least one of said information cells; (c) comparing information cells in said new scenario against corresponding information cells in said reference set; and (d) indicating to the user information cells in said new scenario which have changed when compared against corresponding ones in said reference set.

Claim 21

In an electronic spreadsheet system for modeling user-specified information in a data model comprising a plurality of information cells, a method for automatically identifying modifications to the data model by a user, the method comprising: (a) specifying a reference set of information cells for the system to track user modifications against, said reference set of information cells including a first subset of information cells that store data and a second subset of information cells which directly or indirectly reference at least one information cell in said first subset; (b) creating a new scenario of said data model in response to user input specifying modification of at least one of said information cells from said reference set, said new scenario having information cells corresponding to said information cells in said reference set, said new scenario including (i) said at least one of said information cells, so modified, and (ii) information cells in said second subset which directly or indirectly reference said at least one of said information cells; (c) comparing information cells in said new scenario against corresponding information cells in said reference set; and (d) indicating to the user information cells in said new scenario which have changed when compared against corresponding ones in said reference set.

Claim 22

The method of claim 18, wherein step (d) includes: highlighting any changes between said new scenario and said reference version.

Claim 23

The method of claim 19, wherein information cells modified by the user in step (b) are highlighted with a first screen color, and wherein information cells which directly or indirectly reference said information cells modified by the user are highlighted with a second screen color.

Claim 24

The method of claim 20, wherein said first screen color is yellow, and wherein said second screen color is green.

Claim 25

The method of claim 18, wherein step (b) includes entering new values into at least one of the information cells from said reference set.

Claim 26

The method of claim 18, wherein step (c) includes: comparing non-formula information cells in said new scenario against corresponding ones in said reference set, whereby ones of said new scenario which have changed in value are identified as changing cells; and comparing formula information cells in the said scenario against corresponding ones in said reference set, whereby ones of said new scenario which have changed in value are identified as result cells.

Claim 27

The method of claim 18, wherein step (c) includes: (i) comparing non-formula information cells in the new scenario against corresponding ones in the reference set, whereby ones of the new scenario which have changed in value are identified as changing cells; and (ii) of the information cells which are not changing cells, determining ones which change value as a result of the changes in the changing cells, whereby ones which have changed value are identified as result cells.

Claim 28

The method of claim 24, wherein each said result cell includes a direct or an indirect reference to at least one changing cell.

Claim 29

The method of claim 24, wherein the determination of result cells in substep (ii) is limited to examining only cells which store formulas.

Claim 30

In an electronic spreadsheet system for modeling user-specified information in a data model comprising a plurality of cells, a method for automatically identifying modifications to the data model by a user, the method comprising: specifying a reference set of cells for the system to track user modifications against, said reference set of cells including a first subset of cells that store data and a second subset of cells which directly or indirectly reference at least one cell in said first subset; creating a scenario of said data model by modifying at least one of said cells in said first subset of said reference set, said scenario having corresponding first and second subsets of cells corresponding to said first and second subsets of cells in said reference set; comparing cells in said scenario against corresponding cells in said reference set; indicating to the user cells in said first subset of said scenario that have been found to have changed when compared against corresponding cells in said first subset of cells in said reference set; and indicating to the user cells in said second subset of said scenario that have been found to have changed when compared against corresponding cells in said second subset of cells in said reference set.

Claim 31

In an electronic spreadsheet system for modeling user-specified information in a data model comprising a plurality of cells, a method for automatically identifying modifications to the data model by a user, the method comprising: specifying a reference set of cells for the system to track user modifications against, said reference set of cells including a first subset of cells that store data and a second subset of cells which directly or indirectly reference at least one cell in said first subset; creating a scenario of said data model by modifying at least one of said cells in said first subset of said reference set, said scenario having corresponding first and second subsets of cells corresponding to said first and second subsets of cells in said reference set; comparing cells in said scenario against corresponding cells in said reference set; indicating to the user cells in said first subset of said scenario that have been found to have changed when compared against corresponding cells in said first subset of cells in said reference set; and indicating to the user cells in said second subset of said scenario that have been found to have changed when compared against corresponding cells in said second subset of cells in said reference set.

Claim 32

The method of claim 27, wherein said indicating steps include: displaying, with a first highlight color, cells in said first subset of said scenario that have been found to have changed when compared against corresponding cells in said first subset of cells in said reference set; and displaying, with a second highlight color, cells in said second subset of said scenario that have been found to have changed when compared against corresponding cells in said second subset of cells in said reference set.

Claim 33

In an electronic spreadsheet system for modeling user-specified information in a data model comprising a plurality of cells, a method for automatically identifying modifications to the data model by a user, the method comprising: specifying a reference set of cells for the system to track user modifications against, said reference set of cells including a first subset of cells that store data and a second subset of cells which directly or indirectly reference at least one cell in said first subset; creating a scenario of said data model by modifying at least one of said cells in said first subset of said reference set, said scenario having corresponding first and second subsets of cells corresponding to said first and second subsets of cells in said reference set; comparing cells in said scenario against corresponding cells in said reference set; and in response to a request for a scenario summary report, (a) displaying a first list of cells in said first subset of said scenario that have been found to have changed when compared against corresponding cells in said first subset of cells in said reference set, and (b) displaying a second list of cells in said second subset of said scenario that have been found to have changed when compared against corresponding cells in said second subset of cells in said reference set.

Claim 34

In an electronic spreadsheet system for modeling user-specified information in a data model comprising a plurality of cells, a method for automatically identifying modifications to the data model by a user, the method comprising: specifying a reference set of cells for the system to track user modifications against, said reference set of cells including a first subset of cells that store data and a second subset of cells which directly or indirectly reference at least one cell in said first subset; creating a scenario of said data model by modifying at least one of said cells in said first subset of said reference set, said scenario having corresponding first and second subsets of cells corresponding to said first and second subsets of cells in said reference set; comparing cells in said scenario against corresponding cells in said reference set; and in response to a request for a scenario summary report, (a) displaying a first list of cells in said first subset of said scenario that have been found to have changed when compared against corresponding cells in said first subset of cells in said reference set, and (b) displaying a second list of cells in said second subset of said scenario that have been found to have changed when compared against corresponding cells in said second subset of cells in said reference set.

Claim 35

The method of claim 29, and further comprising the steps of displaying the values of said cells in said first and second lists.

Claim 36

The method of claim 29 and further comprising the steps of: creating an additional scenario of said data model by modifying at least one of said cells in said first set of said reference set, said additional scenario having corresponding first and second subsets of cells corresponding to said first and second subsets of cells in said reference set; comparing cells in said additional scenario against corresponding cells in said reference set; and in response to said request for a scenario summary report, (c) displaying a third list of cells in said first subset of said additional scenario that have been found to have changed when compared against corresponding cells in said first subset of cells in said reference set, and (d) displaying a fourth list of cells in said second subset of said additional scenario that have been found to have changed when compared against corresponding cells in said second subset of cells in said reference set.

Claim 37

The method of claim 29, and further comprising thee steps of displaying the values of said cells in said third and fourth lists.