Spreadsheet program which implements alternative range references

Claim 2

A computer programmed to represent a spreadsheet that is displayed to a user, said spreadsheet comprising an array of cells storing user entered data, said programmed computer comprising: computer implemented means for designating a range of one or more cells within said spreadsheet as a group of one or more cells, said group of one or more cells containing a first set of user entered data, said range containing less than all of the cells of said spreadsheet; computer implemented means for creating an alternative for said range of one or more cells in said spreadsheet, said alternative containing a second set of user entered data that is different from said first set of user entered data; and computer implemented means for displaying a list of alternative sources of data that are available for said range in said spreadsheet, said list of alternative sources of data including said alternative; computer implemented means for designating said alternative on said list of alternative sources of data; and computer implemented means for selecting the designated alternative as the source of the data that is used in the range of one or more cells within said spreadsheet.

Claim 3

The programmed computer of claim 1 wherein said group of one or more cells is a range of contiguous cells within said spreadsheet.

Claim 4

The programmed computer of claim 2 further comprising means for generating one or more event objects that are linked to said alternative, said one or more event objects containing historical information about said alternative.

Claim 5

The programmed computer of claim 3 wherein said historical information includes a date of creation of said alternative and a name of a user who created said alternative.

Claim 6

The programmed computer of claim 3 further comprising means for modifying said alternative and wherein said historical information includes a date of modification of said alternative and a name of a user who modified said alternative.

Claim 7

The programmed computer of claim 2 further comprising means for generating a note object that is linked to said alternative, said note object containing userentered annotations.

Claim 8

A computer programmed to represent a spreadsheet that is displayed to a user, said spreadsheet comprising an array of cells storing user entered data, said programmed computer comprising: computer implemented means for designating a range of one or more cells within said spreadsheet as a group of one or more cells, said group of one or more cells containing a first set of user entered data elements, said range containing less than all of the cells of said spreadsheet; computer implemented means for generating a plurality of alternatives for said range of one or more cells in said spreadsheet, each alternative of said plurality of alternatives containing a corresponding set of user entered data elements that is different from said first set of user entered data elements and from the set of user entered data elements for the other of said plurality of alternatives; and computer implemented means for displaying a list of said plurality of alternatives; computer implemented means for designating any alternative among the displayed list; and computer implemented means for selecting the designated alternative as a source of data that is used in said range of one or more cells within said spreadsheet.

Claim 9

A computer programmed to represent a spreadsheet that is displayed to a user, said spreadsheet comprising an array of cells storing user entered data, said programmed computer comprising: computer implemented means for designating a range of one or more cells within said spreadsheet as a group of one or more cells, said group of one or more cells containing a first set of user entered data elements, said range containing less than all of the cells of said spreadsheet; computer implemented means for generating a plurality of alternatives for said range of one or more cells in said spreadsheet, each alternative of said plurality of alternatives containing a corresponding set of user entered data elements that is different from said first set of user entered data elements and from the set of user entered data elements for the other of said plurality of alternatives; and computer implemented means for displaying a list of said plurality of alternatives; computer implemented means for designating any alternative among the displayed list; and computer implemented means for selecting the designated alternative as a source of data that is used in said range of one or more cells within said spreadsheet.

Claim 10

The programmed computer of claim 7 wherein said group of one or more cells is a range of contiguous cells within said spreadsheet.

Claim 11

The programmed computer of claim 7 further comprising means for generating an ordered list for storing the user entered data elements of all the plurality of alternatives.

Claim 12

The programmed computer of claim 9 further comprising means for generating a hash value for the user entered data elements of the plurality of alternatives and wherein the user entered data elements for the plurality of alternatives is stored in the ordered list in order of the generated hash values.

Claim 13

The programmed computer of claim 10 wherein the list includes a plurality of entries each of which stores a unique data element of said user entered data elements of said plurality of alternatives and having a hash value derived for the data element stored therein, the entries in said list being sequentially ordered by said hash values.

Claim 14

A computer programmed to represent a spreadsheet that is displayed to a user, said spreadsheet comprising an array of cells storing user entered data, said programmed computer comprising: computer implemented means for designating a plurality of ranges within said spreadsheet, each of said plurality of ranges in said spreadsheet being a corresponding plurality of cells from said array of cells, each of said plurality of ranges of cells containing an associated set of user entered data, each of the ranges of said plurality of ranges in said spreadsheet containing less than all of the cells of said spreadsheet; computer implemented means for creating an alternative for each of said plurality of ranges in said spreadsheet, each of said alternatives containing an associated set of user entered data that is different from the user entered data associated with the range to which that alternative corresponds; computer implemented means for enabling the user to designate a subset of said plurality of alternatives to form a scenario; and computer implemented means for displaying a list of alternative sources of data that are available for use in said spreadsheet, said list of alternative sources of data including said scenario; computer implemented means for designating said scenario on said list of alternative sources of data; and computer implemented means for selecting the designated scenario as the source of data that is used in said plurality of ranges in said spreadsheet.

Claim 15

A computer programmed to represent a spreadsheet that is displayed to a user, said spreadsheet comprising an array of cells storing user entered data, said programmed computer comprising: computer implemented means for designating a plurality of ranges within said spreadsheet, each of said plurality of ranges in said spreadsheet being a corresponding plurality of cells from said array of cells, each of said plurality of ranges of cells containing an associated set of user entered data, each of the ranges of said plurality of ranges in said spreadsheet containing less than all of the cells of said spreadsheet; computer implemented means for creating an alternative for each of said plurality of ranges in said spreadsheet, each of said alternatives containing an associated set of user entered data that is different from the user entered data associated with the range to which that alternative corresponds; computer implemented means for enabling the user to designate a subset of said plurality of alternatives to form a scenario; and computer implemented means for displaying a list of alternative sources of data that are available for use in said spreadsheet, said list of alternative sources of data including said scenario; computer implemented means for designating said scenario on said list of alternative sources of data; and computer implemented means for selecting the designated scenario as the source of data that is used in said plurality of ranges in said spreadsheet.

Claim 16

The programmed computer of claim 12 further comprising means for generating one or more event objects that are linked to said scenario, said one or more event objects containing historical information about said scenario.

Claim 17

The programmed computer of claim 13 wherein said historical information includes a date of creation of said scenario and a name of a user who created said scenario.

Claim 18

The programmed computer of claim 13 further comprising means for modifying said scenario and wherein said historical information includes a date of modification of said scenario and a name of a user who modified said scenario.

Claim 19

The programmed computer of claim 12 further comprising means for generating a note object that is linked to said scenario, said note object containing user-entered annotations.

Claim 20

A computer programmed to store a plurality of data elements, wherein at least some of said data elements in said plurality of data elements are duplicates, said programmed computer comprising: computer implemented means for generating a hash value for each of said plurality of data elements; and computer implemented means for generating a list of entries, said list of entries storing all of said plurality of data elements, each of said entries holding a unique one of said plurality of data elements and having an associated hash value derived from that corresponding data element by said generating means, the entries in said list being sequentially ordered by said associated hash values.

Claim 21

A computer programmed to store a plurality of data elements, wherein at least some of said data elements in said plurality of data elements are duplicates, said programmed computer comprising: computer implemented means for generating a hash value for each of said plurality of data elements; and computer implemented means for generating a list of entries, said list of entries storing all of said plurality of data elements, each of said entries holding a unique one of said plurality of data elements and having an associated hash value derived from that corresponding data element by said generating means, the entries in said list being sequentially ordered by said associated hash values.

Claim 22

The programmed computer of claim 17 wherein said list is a linked list.

Claim 23

The programmed computer of claim 18 wherein said list is a doubly linked list.

Claim 24

A computer implemented method of representing a spreadsheet, said spreadsheet comprising an array of cells storing user entered data, said computer implemented method comprising: using a computer input device to designate a range of one or more cells within said spreadsheet as a group of one or more cells, said group of one or more cells containing a first set of user entered data; using the computer to create an alternative for said group of one or more cells, said alternative containing a second set of user entered data that is different from said first set of user entered data, said group of one or more cells and said alternative representing user selectable alternative sources of the data that is used in said range of one or more cells within said spreadsheet; and using the computer to store both said spreadsheet and said alternative in a memory as part of a single computer readable file.

Claim 25

A computer implemented method of representing a spreadsheet, said spreadsheet comprising an array of cells storing user entered data, said computer implemented method comprising: using a computer input device to designate a range of one or more cells within said spreadsheet as a group of one or more cells, said group of one or more cells containing a first set of user entered data; using the computer to create an alternative for said group of one or more cells, said alternative containing a second set of user entered data that is different from said first set of user entered data, said group of one or more cells and said alternative representing user selectable alternative sources of the data that is used in said range of one or more cells within said spreadsheet; and using the computer to store both said spreadsheet and said alternative in a memory as part of a single computer readable file.