Location structure for a multi-dimensional spreadsheet

Claim 2

A computer system for storing, structuring, manipulating and viewing data in the cells of a spreadsheet, the data selected from a plurality of locators, each locator having at least one resolution and each resolution of each locator having at least one position, said system comprising: processor means for controlling the storage, retrieval, structuring, manipulating and viewing of the data; storing means electrically coupled to said processor means for storing the data to addresses assigned to the data by said processor means, said storing means comprising data structuring means for structuring the data in a data structure wherein each resolution and position combination of each locator defines an ordered pair of an n-tuple location within the data structure that corresponds to a cell of the spreadsheet; interface means electrically coupled to said processor means for manipulating the data in the data structure; and viewing means electrically coupled to said processor means for viewing the contents of the cells of the spreadsheet.

Claim 3

The computer system of claim 1 wherein at least one locator has a plurality of resolutions, the resolutions related to each other by increasing or decreasing levels of scale.

Claim 4

The computer system of claim 1 wherein the data structure of said storing means comprises: a location structure comprising the n-tuple locations defined by the ordered pairs of resolution and position combinations of each locator; a content structure operably coupled to said location structure and comprising variables which define data items; and mapping means operably coupled to said location structure and said content structure for mapping each location of said location structure to at least one of the variables of said content structure.

Claim 5

The computer system of claim 3 further comprising instantiating means for instantiating each of the mapped variables with a value that represents the data item defined by the variable.

Claim 6

The computer system of claim 4 wherein said mapping means comprises navigating means for navigating within said location structure and within said content structure.

Claim 7

The computer system of claim 5 wherein said navigating means comprises: intra-resolution navigation means for moving from a first position in a resolution to a second position in the resolution; inter-resolution navigation means for moving from a first position in a first resolution to a second position in a second resolution; and inter-location navigation means for moving from a first value in a cell to a second value in the cell.

Claim 8

The computer system of claim 3 wherein each data item is selected from the group consisting of a numeric quantity, text, an alphanumeric string, a file, an external data source and an object used in object oriented programming.

Claim 9

The computer system of claim 1 wherein the cells of the spreadsheet are multivariate.

Claim 10

The computer system of claim 1 wherein at least one of the locators is a time locator and at least one of the locators is a space locator.

Claim 11

The computer system of claim 1 further comprising a power supply electrically coupled to said processor means and wherein said processor means comprises a microcomputer bus for communicating address, data and control signals between said processor means and said storing means, said interface means and said viewing means.

Claim 14

The method of claim 11 wherein at least one locator of the location structure has resolutions related to each other by increasing or decreasing levels of scale.

Claim 15

The method of claim 11 further comprising the step of instantiating each of the mapped variables with a value that represents the data item defined by the variable.

Claim 16

The method of claim 11 wherein the step of mapping comprises the further step of navigating within the location structure and within the content structure.

Claim 17

The method of claim 14 wherein the step of navigating comprises the further steps of: moving from a first position in a resolution to a second position in the resolution; moving from a first position in a first resolution to a second position in a second resolution; and moving from a first value in a cell of the spreadsheet to a second value in the cell.

Claim 18

The method of claim 11 wherein the steps of storing, structuring, mapping and viewing are controlled by the processor means.

Claim 19

A computer implemented process for storing, structuring, manipulating and viewing data in the cells of a spreadsheet using a computer system comprising processor means, storing means, interface means and viewing means, said process comprising the steps of: controlling the storing, structuring, mapping and viewing of the data using the processor means to communicate between the storing means, the interface means, the viewing means and the processor means; storing data input by the interface means to addresses in the storing means assigned by the processor means; structuring the data in the storing means in a data structure including a location structure and a content structure, the location structure comprising a plurality of locators, each locator having at least one resolution and each resolution of each locator having at least one position, each resolution and position combination of each locator defining an ordered pair of an n-tuple location within the data structure that corresponds to a cell of a spreadsheet, the content structure comprising variables which define data items; mapping each location of the location structure to at least one of the variables of the content structure; instantiating each of the mapped variables with a value that represents the data item defined by the variable; viewing the mapped variables in the cells of the spreadsheet on the viewing means.

Claim 20

A computer implemented process for storing, structuring, manipulating and viewing data in the cells of a spreadsheet using a computer system comprising processor means, storing means, interface means and viewing means, said process comprising the steps of: controlling the storing, structuring, mapping and viewing of the data using the processor means to communicate between the storing means, the interface means, the viewing means and the processor means; storing data input by the interface means to addresses in the storing means assigned by the processor means; structuring the data in the storing means in a data structure including a location structure and a content structure, the location structure comprising a plurality of locators, each locator having at least one resolution and each resolution of each locator having at least one position, each resolution and position combination of each locator defining an ordered pair of an n-tuple location within the data structure that corresponds to a cell of a spreadsheet, the content structure comprising variables which define data items; mapping each location of the location structure to at least one of the variables of the content structure; instantiating each of the mapped variables with a value that represents the data item defined by the variable; viewing the mapped variables in the cells of the spreadsheet on the viewing means.

Claim 21

The computer implemented process of claim 17 wherein at least one locator of the location structure has resolutions related to each other by increasing or decreasing levels of scale.

Claim 22

The computer implemented process of claim 17 wherein the step of mapping comprises the further steps of: navigating within the location structure and within the content structure by moving from a first position in a resolution to a second position in the resolution; moving from a first position in a first resolution to a second position in a second resolution; and moving from a first value in a cell of the spreadsheet to a second value in the cell.