Data processing: financial – business practice – management – or co – Automated electrical financial or business practice or... – Finance
Reexamination Certificate
2008-05-27
2008-05-27
Weisberger, Richard (Department: 3693)
Data processing: financial, business practice, management, or co
Automated electrical financial or business practice or...
Finance
C705S03600T
Reexamination Certificate
active
07379908
ABSTRACT:
A computer-implemented method of populating row and column cells of an electronic financial statement document containing with formulas and data, and related apparatus. A formula for a cell in a financial statement is generated from a row definition for the row and a column definition for the column of the cell, where the row definition defines a term of the statement and the column definition specifies a period of time. The resulting statement is displayed to a user, and new formula expressions can be generated to reflect changes in the statement. The statement can have three kinds of columns, namely base columns, subtotal columns, and grand total columns. Data in columns of an input database corresponds to a database period of time, and the base columns in the statement have statement period unit. For each base column of the statement, a correspondence to more than one column of the input database can be computed dynamically. The cells of the statement column can be populated using data from the corresponding database columns. The cells can be repopulated in response to a change in the statement period unit.
REFERENCES:
patent: 3749892 (1973-07-01), Stenning
patent: 4642767 (1987-02-01), Lerner
patent: 4989141 (1991-01-01), Lyons et al.
patent: 5293615 (1994-03-01), Amado
patent: 5359724 (1994-10-01), Earle
patent: 5537590 (1996-07-01), Amado
patent: 5553215 (1996-09-01), Kaethler
patent: 5644727 (1997-07-01), Atkins
patent: 5701400 (1997-12-01), Amado
patent: 5761508 (1998-06-01), Okuno
patent: 5768158 (1998-06-01), Adler et al.
patent: 6002865 (1999-12-01), Thomsen
patent: 6112199 (2000-08-01), Nelson
patent: 6134563 (2000-10-01), Clancey et al.
patent: 6134564 (2000-10-01), Listou
Benninga, Financial Modeling, 1997, Chapter 1.
Spreadware, “Supporting Macintosh Spreadsheets,” price list, Graham Communications, Hayward, 1989.
M. Jaynes, “Here Comes SAP,”Fortune, Oct. 2, 1995, pp. 122-124.
P. Lyons et al., “AI in Business,” Workshop Program, AAAI, San Jose Convention Center, Jul. 12-16, 1992.
J. Poultney, “Analytica models business,”MacWeek, News Section, p. 6 (Sep. 30, 1996).
“Transactions on Information Systems,”acm Press, vol. 13, No. 1, Jan. 1995.
W. Hamscher, “Model-based reasoning in financial domains,”The Knowledge Engineering Review, vol. 7:4, 1992, pp. 323-343.
W. Hamscher, “Modeling accounting systems to support multiple tasks: A progress report,” Price Waterhouse Technology Centre, Menlo Park, pp. 519-524 (1992).
W. Mossberg, “Excel Spreadsheet Is New and Improved, But Hardly Perfect,” article (1995).
Ch. Seiter, “Smart Spreadsheets,”Macworld, Aug. 1993, p. 77.
Ch. Seiter, “SpreadBase 1.0.1,”Macworld, May 1993, p. 144.
Special Advertising Supplement, “Better Decisions Mean A Better Bottom Line,” CW Custom Publications, Framingham, MA, 10 pgs (Fall 1995).
“Why use CEO*Plan?,” Internet information, 14 pgs. (1995).
“Redefining information access, analysis, and reporting for the Macintosh,” Business Objects™, 1995, 5 pgs.
J.Keyes, “AI in the Big Six,”AI Expert, May 1990, pp. 35-42.
C. Brown, “Where 1-2-3 Makes Deals in a Hurry,”Lotus, Jun. 1989, pp. 52-55.
Lotus, “The Next Lotus spreadsheet is here,” Improv Specifications, Cambridge, MA (circa 1991).
M. Falkner, “CFO Advisor Financial Analysis Beyond Spreadsheets,”PC Magazine, Jun. 27, 1989, pp. 235-243.
“Plan to get ahead in business,” Palo Alto Software, 1994, 5 pgs.
“Introducing Cashe,” Business Matters, Inc., 1995, 7 pgs.
“Would you bet your future on this number?”, DecisioNeering, Inc., product information, 1993.
T. Foulks, “Of Sharks, LANs, and a Crystal Ball,”PC World, Nov. 1993.
J. Dawson, “Business-Plan Templates,”Macworld, Jun. 1995, p. 61.
“Make Me An Offer,” Business Valuation, price list, Baarns Publishing (1995).
“Go Freel Go Figure,” Advertisement,CompUSA. (1995).
Advance 1.0 for Windows, Publsihed by Lighten, Website, 8 pgs. (Oct. 5, 1995).
J. Swartz, “New spreadsheet keeps it simple,” MacWeek, vol. 10, No. 4 (Jan. 29, 1996).
Stultz, Russell A. Learn Microsoft Office 97 Woodware Publishing Inc. ISBN 1556225407. © 1997.
“XL: AppNote XE0210: Creating and Using tables” (Microsoft Tech Support Document). Original text dated Apr. 1997. Last reviewed Dec. 10, 1999. Found online at support.Microsoft.com.
“XL: Using the Lookup Wizard for Microsoft Excel (Lookup.xla)” (Microsoft Tech Support Document). States that information works back to version 5.0 of Excel. Last reviewed Nov. 3, 1999. Found online at support.Microsoft.com.
“XL97: Natural Language Formulas Return Error” (Microsoft Tech Support Document). Last reviewed Oct. 11, 1999. Found online at support.Microsoft.com.
“About Labels and Names in Formulas” (Printout of Excel 97 help topic).
“Microsoft Announces the Immediate Availability of Office 97” (Press Release). Dated Jan. 16, 1997.
“Microsoft Office 97 Released to Manufacturing” (Press Release). Dated Nov. 19, 1996.
“MS Excel 97 Feature List” (Microsoft TechNet Document). Published Oct. 1996.
Coughlan. Kieren L., and Nolan, Paul J. “Developing Special Purposes Simulations Under Microsoft Windows.” Proceedings of the 1995 Winter Simulation Conference (held Dec. 3-6, 1995). ACM. © 1995. pp. 969-976.
Isakowitz, Tomas, Shimon Schocken, Henry C. Lucas. “Toward a Logical/Physical Theory of Spreadsheet Modeling.” ACM Transactions of Information Systems, vol. 13, No. 1 Jan. 1995. ACM © 1995. pp. 1-37.
Ronen, Boaz, Michael A. Palley, Henry C. Lucas. “Spreadsheet Analysis and Design” Communications of the ACM, vol. 32, No. 1 Jan. 1989. ACM © 1989. pp. 84-93.
Canty Edgar P.
Clancey William J.
Hecht Lee
Helfert Erich A.
Wu John
Fish & Richardson P.C.
Modernsoft, Inc.
Weisberger Richard
LandOfFree
Populating cells of an electronic financial statement does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Populating cells of an electronic financial statement, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Populating cells of an electronic financial statement will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2773933