Constraint based graphics system

Claim 2

In a spreadsheet application program, a method for graphically displaying spreadsheet cell data, said method comprising the steps of: creating a graphic format within said spreadsheet application program using at least one instance of at least one graphical object for graphically representing said spreadsheet cell data; and displaying said graphic format by operation of said spreadsheet application program; wherein said step of creating said graphic format comprises the steps of: accepting user input, wherein said user input comprises a definition of said at least one graphical object end a specification of a respective number for quantifying instances desired of said at least one graphical object; assigning an index for identifying each instance of said at least one graphical object; receiving user entry, wherein said user entry comprises at least one user designated expression for designating a relationship between at least one attribute of each instance of said at least one graphical object, by means of said index, and said spreadsheet cell data; and evaluating said expressions to determine said attributes of said instances of said at least one graphical object.

Claim 3

The method of claim 1, wherein for each of said at least one user designated expression being evaluated, said evaluating step comprises the steps of: determining whether a first type of data structure has been created for said at least one user designated expression being evaluated; creating one of said first types of data structure for said at least one user designated expression being evaluated when said determining step determines that one of said first types of data structure has not been created for said at least one user designated expression; inspecting said first type of data structure of said at least one user designated expression being evaluated to determine if a solution to said at least one user designated expression has been stored in any of at least one of a second type of data structure; calculating said solution to said at least one user designated expression being evaluated when said inspecting step reveals that none of said second types of data structure contain said solution; storing said solution in at least one of said second types of data structure when said calculating step calculates said solution to said at least one user designated expression being evaluated; and retrieving said solution to said at least one user designated expression being evaluated when said inspecting step reveals that one of said second types of data structure contains said solution.

Claim 4

In a spreadsheet application program, a method for graphically displaying spreadsheet cell data, said method comprising the steps of: creating a graphic format within said spreadsheet application program using at least one instance of at least one graphical object for graphically representing said spreadsheet cell data; and displaying said graphic format by operation of said spreadsheet application program; wherein said step of creating said graphic format comprises the steps of: accepting user input, wherein said user input comprises a definition of at least one instance of at least one source object; assigning an index for identifying each instance of said at least one source object; receiving user entry, wherein said user entry comprises at least one user designated expression for designating a relationship between at least one attribute of each instance of said at least one graphical object, at least one attribute of at least one instance of said at least one source object, and said spreadsheet cell data; and evaluating said expressions to determine said attributes of said instances of said at least one graphical object.

Claim 5

In a spreadsheet application program, a method for graphically displaying spreadsheet cell data, said method comprising the steps of: creating a graphic format within said spreadsheet application program using at least one instance of at least one graphical object for graphically representing said spreadsheet cell data; and displaying said graphic format by operation of said spreadsheet application program; wherein said step of creating said graphic format comprises the steps of: accepting user input, wherein said user input comprises a definition of at least one instance of at least one source object; assigning an index for identifying each instance of said at least one source object; receiving user entry, wherein said user entry comprises at least one user designated expression for designating a relationship between at least one attribute of each instance of said at least one graphical object, at least one attribute of at least one instance of said at least one source object, and said spreadsheet cell data; and evaluating said expressions to determine said attributes of said instances of said at least one graphical object.

Claim 6

The method of claim 3 wherein said source object is a single valued object.

Claim 7

The method of claim 3 wherein said source object is a graphical object.

Claim 8

The method of claim 3 wherein said source object is a list valued object.

Claim 9

The method of claim 3, wherein for each of said at least one user designated expression being evaluated, said evaluating step comprises the steps of: determining whether a first type of data structure has been created for said at least one user designated expression being evaluated; creating one of said first types of data structure for said at least one user designated expression being evaluated when said determining step determines that one of said first types of data structure has not been created for said at least one user designated expression; inspecting said first type of data structure of said at least one user designated expression being evaluated to determine if a solution to said at least one user designated expression has been stored in any of at least one of a second type of data structure; calculating said solution to said at least one user designated expression being evaluated when said inspecting step reveals that none of said second types of data structure contain said solution; storing said solution in at least one of said second types of data structure when said calculating step calculates said solution to said at least one user designated expression being evaluated; and retrieving said solution to said at least one user designated expression being evaluated when said inspecting step reveals that one of said second types of data structure contains said solution.

Claim 10

In a spreadsheet application program, a method for graphically displaying spreadsheet cell data, said method comprising the steps of: creating a graphic format within said spreadsheet application program using at least one instance of at least one graphical object for graphically representing said spreadsheet cell data, by: accepting user input, wherein said user input comprises; a definition of said at least one instance of said at least one graphical object, and a definition of at least one instance of at least one source object related to at least one instance of said at least one graphical object, designating a first index for identifying each instance of said at least one graphical object, designating an additional index for identifying each instance of said at least one source object, receiving user entry, wherein said user entry comprises at least one user designated constraint hierarchy, wherein each of said at least one user designated constraint hierarchy comprises a rule base relating at least one attribute of each instance of said at least one graphical object, by means of said first index, to said spreadsheet cell date and at least one attribute of at least one instance of said at least one source object, by means of said additional index, and determining said attributes of said instances of said at least one graphical object according to said rule base in said constraint hierarchy; and displaying said instances of said at least one graphical object according to said attributes.

Claim 11

In a spreadsheet application program, a method for graphically displaying spreadsheet cell data, said method comprising the steps of: creating a graphic format within said spreadsheet application program using at least one instance of at least one graphical object for graphically representing said spreadsheet cell data, by: accepting user input, wherein said user input comprises; a definition of said at least one instance of said at least one graphical object, and a definition of at least one instance of at least one source object related to at least one instance of said at least one graphical object, designating a first index for identifying each instance of said at least one graphical object, designating an additional index for identifying each instance of said at least one source object, receiving user entry, wherein said user entry comprises at least one user designated constraint hierarchy, wherein each of said at least one user designated constraint hierarchy comprises a rule base relating at least one attribute of each instance of said at least one graphical object, by means of said first index, to said spreadsheet cell date and at least one attribute of at least one instance of said at least one source object, by means of said additional index, and determining said attributes of said instances of said at least one graphical object according to said rule base in said constraint hierarchy; and displaying said instances of said at least one graphical object according to said attributes.

Claim 12

The method of claim 8 wherein said step of determining said attributes of said instances of said graphical object comprises the steps of: identifying, using said first index and said additional index, each attribute of each instance of said source object required to evaluate said attributes of said instances of said graphical object; and determining, according to said rule base, only attributes of instances of said source object identified as being required to determine said attributes of said instances of said graphical object.

Claim 13

The method of claim 8 wherein said attributes of each of said instances of said graphical object are determined in a sequential fashion.

Claim 14

The method of claim 8, wherein for each said rule base being used to determine each of said at least one attribute, said determining step comprises the steps of: determining whether a first type of data structure has been created for said rule base; creating one of said first types of data structure for said rule base when said determining step determines that one of said first types of data structure has not been created for said rule base; inspecting said first type of data structure of said rule base to determine if a solution to said rule base has been stored in any of at least one of a second type of data structure; calculating said solution to said rule base when said inspecting step reveals that none of said second types of data structure contain said solution; storing said solution in at least one of said second types of data structure when said calculating step calculates said solution to said rule base; and retrieving said solution to said rule base when said inspecting step reveals that one of said second types of data structure contains said solution.

Claim 15

Apparatus for graphically displaying spreadsheet cell data in a spreadsheet application program, said apparatus comprising: a graphics formatter operating under the control of said spreadsheet application program for creating a graphic format for graphically representing said spreadsheet cell data using at least one instance of at least one graphical object, said graphics formatter comprising: a user input mechanism for receiving user input, wherein said user input comprises e definition of said at least one instance of said at least one graphical object end a specification of the a number of instances desired of said at least one graphical object, an index generator for generating an index number for each instance of said at least one graphical object, an index identifier for identifying said index number of each instance of said at least one graphical object, a user input receiver for accepting user instructions, wherein said user instructions comprise at least one expression designating a relationship between at least one attribute of each instance of said at least one graphical object, by said index number, and said spreadsheet cell data, and an expression evaluator for evaluating said expressions to determine said attributes of said instances of said at least one graphical object; and a display operating under the control of said spreadsheet application program for displaying said instances of said at least one graphical object according to said attributes.

Claim 16

Apparatus for graphically displaying spreadsheet cell data in a spreadsheet application program, said apparatus comprising: a graphics formatter operating under the control of said spreadsheet application program for creating a graphic format for graphically representing said spreadsheet cell data using at least one instance of at least one graphical object, said graphics formatter comprising: a user input mechanism for receiving user input, wherein said user input comprises e definition of said at least one instance of said at least one graphical object end a specification of the a number of instances desired of said at least one graphical object, an index generator for generating an index number for each instance of said at least one graphical object, an index identifier for identifying said index number of each instance of said at least one graphical object, a user input receiver for accepting user instructions, wherein said user instructions comprise at least one expression designating a relationship between at least one attribute of each instance of said at least one graphical object, by said index number, and said spreadsheet cell data, and an expression evaluator for evaluating said expressions to determine said attributes of said instances of said at least one graphical object; and a display operating under the control of said spreadsheet application program for displaying said instances of said at least one graphical object according to said attributes.

Claim 17

The apparatus of claim 12, wherein said expression evaluator comprises: a storage device for storing at least one first type of data structure and an at least one second type of data structure; a determiner for determining whether one of said first types of data structure has been created for said at least one expression being evaluated; a creator for creating one of said first types of data structure for said at least one expression being evaluated when said determiner determines that one of said first types of data structure has not been created for said at least one expression; an inspector for inspecting said first type of data structure of said at least one expression being evaluated to determine if a solution to said at least one expression has been stored in any of said second types of data structure; a calculator for calculating said solution to said at least one expression being evaluated when said inspector reveals that none of said second type of data structures contain said solution; memory for storing said solution in at least one of said second types of data structure when said calculator step calculates said solution to said at least one expression being evaluated; and a retriever for retrieving said solution to said at least one expression being evaluated when said inspector reveals that one of said second types of data structure contains said solution.

Claim 18

Apparatus for graphically displaying spreadsheet cell data in a spreadsheet application program, said apparatus comprising: a graphics formatter operating under the control of said spreadsheet application program for creating a graphic format for graphically representing said spreadsheet cell data using at least one instance of at least one graphical object, said graphics formatter comprising: a user input mechanism for receiving user input, wherein said user input comprises a definition of at least one instance of at least one source object, an index generator for generating an index number for each instance of said at least one source object, an index identifier for identifying said index number of each instance of said at least one source object, a user input receiver for accepting user instructions, wherein said user instructions comprise at least one expression designating a relationship between at least one attribute of each instance of said at least one graphical object, said spreadsheet cell date, and at least one attribute of at least one instance of said at least one source object, and an expression evaluator for evaluating said expressions to determine said attributes of said instances of said at least one graphical object; and a display operating under the control of said spreadsheet application program for displaying said instances of said at least one graphical object according to said attributes.

Claim 19

Apparatus for graphically displaying spreadsheet cell data in a spreadsheet application program, said apparatus comprising: a graphics formatter operating under the control of said spreadsheet application program for creating a graphic format for graphically representing said spreadsheet cell data using at least one instance of at least one graphical object, said graphics formatter comprising: a user input mechanism for receiving user input, wherein said user input comprises a definition of at least one instance of at least one source object, an index generator for generating an index number for each instance of said at least one source object, an index identifier for identifying said index number of each instance of said at least one source object, a user input receiver for accepting user instructions, wherein said user instructions comprise at least one expression designating a relationship between at least one attribute of each instance of said at least one graphical object, said spreadsheet cell date, and at least one attribute of at least one instance of said at least one source object, and an expression evaluator for evaluating said expressions to determine said attributes of said instances of said at least one graphical object; and a display operating under the control of said spreadsheet application program for displaying said instances of said at least one graphical object according to said attributes.

Claim 20

The apparatus of claim 14, wherein said source object is a single valued object.

Claim 21

The apparatus of claim 14, wherein said source object is a graphical object.

Claim 22

The apparatus of claim 14, wherein said source object is a list valued object.

Claim 23

The apparatus of claim 14, wherein said expression evaluator comprises: a storage device for storing at least one first type of data structure and an at least one second type of data structure; a determiner for determining whether one of said first types of data structure has been created for said at least one expression being evaluated; a creator for creating one of said first types of data structure for said at least one expression being evaluated when said determiner determines that one of said first types of data structure has not been created for said at least one expression; an inspector for inspecting said first type of data structure of said at least one expression being evaluated to determine if a solution to said at least one expression has been stored in any of said second types of data structure; a calculator for calculating said solution to said at least one expression being evaluated when said inspector reveals that none of said second type of data structures contain said solution; memory for storing said solution in at least one of said second types of data structure when said calculator step calculates said solution to said at least one expression being evaluated; and a retriever for retrieving said solution to said at least one expression being evaluated when said inspector reveals that one of said second types of data structure contains said solution.

Claim 24

Apparatus for graphically displaying spreadsheet cell data in a spreadsheet application program, said apparatus comprising: a graphics formatter operating under the control of said spreadsheet application program for creating a graphic format for graphically representing said spreadsheet cell data using at least one instance of at least one graphical object, said graphics formatter comprising: a user input mechanism for receiving user input, said user input comprising: a definition of said at least one instance of said at least one graphical object, end a definition of at least one instance of at least one source object related to at least one instance of said at least one graphical object, an index generator for generating a first index for each instance of said at least one graphical object and a second index for each instance of said at least one source object, a user input receiver for accepting at least one user designated constraint hierarchy, wherein each of said at least one user designated constraint hierarchy comprises a rule base designating a relationship between at least one attribute of each instance of said at least one graphical object, by means of said first index, said spreadsheet cell data, and at least one attribute of at least one instance of said at least one source object, by means of said second index, end a processor for determining said attributes of said instances of said at least one graphical object according to said rule base in said constraint hierarchy; and a display for displaying said instances of said at least one graphical object according to said attributes.

Claim 25

Apparatus for graphically displaying spreadsheet cell data in a spreadsheet application program, said apparatus comprising: a graphics formatter operating under the control of said spreadsheet application program for creating a graphic format for graphically representing said spreadsheet cell data using at least one instance of at least one graphical object, said graphics formatter comprising: a user input mechanism for receiving user input, said user input comprising: a definition of said at least one instance of said at least one graphical object, end a definition of at least one instance of at least one source object related to at least one instance of said at least one graphical object, an index generator for generating a first index for each instance of said at least one graphical object and a second index for each instance of said at least one source object, a user input receiver for accepting at least one user designated constraint hierarchy, wherein each of said at least one user designated constraint hierarchy comprises a rule base designating a relationship between at least one attribute of each instance of said at least one graphical object, by means of said first index, said spreadsheet cell data, and at least one attribute of at least one instance of said at least one source object, by means of said second index, end a processor for determining said attributes of said instances of said at least one graphical object according to said rule base in said constraint hierarchy; and a display for displaying said instances of said at least one graphical object according to said attributes.

Claim 26

The apparatus of claim 19, wherein said processor for determining said attributes of said instances of said graphical object comprises: an identifier for identifying, using said first index and said second index, each attribute of each instance of said source object required to evaluate said attributes of said instances of said graphical object; and an evaluator for determining, according to said rule base, only attributes of instances of said source object identified as being required to determined said attributes of said instances of said graphical object.

Claim 27

The apparatus of claim 19, wherein, for determining each of said at least one attribute according to said rule base of each of said at least one constraint hierarchy, said processor comprises: a storage device for storing at least one first type of data structure and an at least one second type of data structure; a determiner for determining whether one of said first types of data structure has been created for said rule base; a creator for creating one of said first types of data structure for said rule base when said determiner determines that one of said first types of data structure has not been created for said rule base; an inspector for inspecting said rule base said first type of data structure to determine if a solution to said rule base has been stored in any of said second types of data structure; a calculator for calculating said solution to said rule base when said inspector reveals that none of said second type of data structures contain said solution; memory for storing said solution in at least one of said second types of data structure when said calculator step calculates said solution to said rule base; and a retriever for retrieving said solution to said rule base when said inspector reveals that one of said second types of data structure contains said solution.