Method and system for the graphical modeling of data and...

Details Method and system for the graphical modeling of data and... Method and system for the graphical modeling of data and...

2011-07-19

2011-07-19

Nguyen, Maikhanh (Department: 2176)

Data processing: presentation processing of document, operator i

Presentation processing of document

Spreadsheet

C715S215000, C715S234000, C715S255000, C715S761000, C707S778000, C707S805000

Reexamination Certificate

active

07984371

ABSTRACT:
A method and system for the graphical modeling of calculations in a spreadsheet that provides a graphical representation of formulas and data contained in a spreadsheet. The graphical representation consists of nodes and edges connected in a tree or graph structure. The nodes represent operators and operands of a formula and are arranged in an expression hierarchy based on operational precedence. Formulas containing cell references are represented through a compound expression hierarchy consisting of an expression hierarchy that includes a descendant expression hierarchy representing the contents of each referenced cell. Expression hierarchies that share similar nodes can be represented through a shared graphical representation to reduce the number of items displayed concurrently within a view and to simplify multiple formula edits. The expression hierarchies and the formulas they represent are kept consistent so that changes made to either can be reflected in both the spreadsheet and graphical representation.

REFERENCES:
patent: 5603021 (1997-02-01), Spencer et al.
patent: 5880742 (1999-03-01), Rao et al.
patent: 5987481 (1999-11-01), Michelman et al.
patent: 2002/0099743 (2002-07-01), Workman et al.
patent: 2006/0085386 (2006-04-01), Thanu et al.
Smedley et al., “Expanding the Utility of Spreadsheets Through the Integration of Visual Programming and User Interface Objects”, ACM, 1996, pp. 148-155.
Jones et al., “A User-Centred Approach to Functions in Excel”, ACM, Aug. 2003, pp. 165-176.

Affiliated with

Also associated with

Rating

Method and system for the graphical modeling of data and... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and system for the graphical modeling of data and..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for the graphical modeling of data and... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2707184