Spreadsheet error checker

Details Spreadsheet error checker Spreadsheet error checker

2006-10-03

2006-10-03

Huynh, Cong-Lac (Department: 2178)

Data processing: presentation processing of document, operator i

Presentation processing of document

Layout

C715S252000

Reexamination Certificate

active

07117430

ABSTRACT:
An error checker identifies spreadsheet errors by traversing a spreadsheet cell-by-cell and comparing each cell's contents to a list of error rules. When a cell's contents satisfy an error rules, then the cell is identified as containing a potential spreadsheet error. The error checker identifies potential spreadsheet errors and marks the cells containing the potential errors with an error indicator. A drop-down menu is provided that includes an element identifying the error rule that was invoked by the cell's contents and may include one or more recommended actions to resolve the identified error.

REFERENCES:
patent: 5247611 (1993-09-01), Norden-Paul et al.
patent: 5418902 (1995-05-01), West et al.
patent: 5603021 (1997-02-01), Spencer et al.
patent: 5633998 (1997-05-01), Schlafly
patent: 5657259 (1997-08-01), Davis et al.
patent: 5721847 (1998-02-01), Johnson
patent: 5842180 (1998-11-01), Khanna et al.
patent: 5852824 (1998-12-01), Brown
patent: 6225996 (2001-05-01), Gibb et al.
patent: 6256649 (2001-07-01), Mackinlay et al.
patent: 6317758 (2001-11-01), Madsen et al.
patent: 6336590 (2002-01-01), Kubitz
patent: 6460059 (2002-10-01), Wisniewski
patent: 6473523 (2002-10-01), Newman et al.
patent: 6549878 (2003-04-01), Lowry et al.
patent: 6592626 (2003-07-01), Bauchot et al.
patent: 6631380 (2003-10-01), Cason et al.
patent: 6631497 (2003-10-01), Jamshidi et al.
patent: 6640234 (2003-10-01), Coffen et al.
patent: 6986099 (2006-01-01), Todd
patent: 2001/0007988 (2001-07-01), Bauchot et al.
patent: 2002/0004801 (2002-01-01), Todd
patent: 2002/0010713 (2002-01-01), Egilsson
patent: 2002/0023105 (2002-02-01), Wisniewski
patent: 2004/0225957 (2004-11-01), Egilsson
patent: 2005/0182709 (2005-08-01), Belcsak et al.
patent: 2006/0101326 (2006-05-01), Todd
Boyce et al., Using Microsoft Office 97, Que Corporation 1997, pp. 242-243, 305-306, 328-330.
Anonymous, Use Excel's Auditing Tools to Check Formulas and Track down Errors, Inside Microsoft Excel, Oct. 2000, vol. p. 7, 5 pgs.
Rothermel et al., WYSIWYT Testing in the Spreadsheet Paradigm: An Empirical Evaluation, ACM 2000, pp. 230-239.
Cox et al., Using Visual Programming to Extend the Power of Spreadsheet Computation, ACM 1994, pp. 153-161.
Rothermael et al., WYSIWYT Testing in the Spreadsheet Paradigm: An Empirical Evaluation, ACM 2000, pp. 230-239.
Brown et al., An Experimental Study of People Creating Spreadsheets, ACM 1987, p. 258-272.
Modeling spreadsheet audit: A rigorous approach to automatic visualization; J. Sajaniemi;Journal of Visual Languages and Computing, 2000, vol. 11, No. 1 (Feb.) pp. 49-82.
Efficient methods for checking integrity: an integrated spreadsheet engineering methodology(ISHEM); K. Rajalingham, D. Chadwick, B. Knight and D. Edwards;Integrity and Internal Control in Information Systems: Strategic Views on the Need for Control(Proceedings of 3rdInternational Working Conference on Integrity and Internal Control in Information Systems), 2000, pp. 41-58.
Spreadsheet model verification; A.W. Wakelin;Proceedings of the 4thSoftware Quality Conference, 1995, pp. 310-317 vol. 2.
Unspoken nightmare: ‘Stupid’ spreadsheets; R. Moskowitz,Software News, May 1997, vol. 7, No. 5, p. 51.
Bug-proofing your spreadsheets; M. Bryan;Business Software, Dec. 1986, vol. 4, No. 12, pp. 38-41.
Reviewing electronic spreadsheets; L. Beitman;EDPACS, Apr. 1986, vol. 13, No. 10, pp. 8.

Affiliated with

Also associated with

Rating

Spreadsheet error checker does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Spreadsheet error checker, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Spreadsheet error checker will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3627191