System and method for efficiently and flexibly utilizing spreadsheet information

• US 7,251,776 B2
• Filed: 07/11/2002
• Issued: 07/31/2007
• Est. Priority Date: 07/13/2001
• Status: Expired due to Fees

• Current Assignee: Netview Technologies Incorporated
• Original Assignee: Netview Technologies Incorporated
• Inventors: Rasin, Gregory, Handsaker, Robert, Knourenko, Andrey
• Primary Examiner(s): HUTTON JR, WILLIAM D
• Application Number:
  US10/193,015
• Publication Number:
  US 20030110191A1
• Time in Patent Office: 1,846 Days
• Field of Search: 715/503
• US Class Current: 715/212
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

In one aspect, the present invention relates to utilizing a spreadsheet by defining a parameter external to the spreadsheet and associating the parameter with the spreadsheet to define a parameterized workbook. In one embodiment, this utilization further comprises storing a location of the spreadsheet and storing the name of the parameter in the same storage module as the location. In another embodiment, it includes defining a result external to the spreadsheet, the result referencing one or more cells within the spreadsheet. In another embodiment, this utilization further comprises receiving a value for the parameter and generating the result based at least in part on the value and the spreadsheet. In another embodiment, it further comprises associating a type with the parameter. The type can define a range of values or attributes associated with the parameter.

Claims

1. A method for utilizing a spreadsheet, the method comprising:

defining a parameter external to the spreadsheet;

associating the parameter with the spreadsheet at design time to define a parameterized workbook, wherein the parameter applies to the spreadsheet as a whole, thereby allowing any formula in the spreadsheet to reference the parameter;

receiving a value for the parameter at run time;

computing cell values in the spreadsheet that are dependent, directly or indirectly, on parameter; and

rendering an output based on the computed cell values.

2. The method of claim 1, wherein associating the parameter further comprises:

storing a location of the spreadsheet; and

storing a name for the parameter in the same storage module as the location.

3. The method of claim 1, further comprising:

defining a named result external to the spreadsheet, wherein the named result references one or more cells within the spreadsheet.

4. The method of claim 3, further comprising:

generating the named result based at least in part on the received value and the spreadsheet.

5. The method of claim 3, further comprising:

defining a format for the named result.

6. The method of claim 5, wherein the defined format further comprises a visual rendering of the one or more cells referenced by the named result.

7. The method of claim 6, further comprising:

creating a visual rendering of any charts or graphics associated with the one or more cells referenced by the named result.

8. The method of claim 1, further comprising:

associating a type with the parameter at design time, wherein the type defines a range of values that are allowable to be received for the parameter at run time.

9. The method of claim 1, further comprising:

associating a type with the parameter at design time, wherein the type defines attributes associated with the parameter, wherein the attributes are allowable to be used by formulas within the spreadsheet.

10. The method of claim 1, further comprising:

defining a formula within the spreadsheet at design time using the parameter.

11. The method of claim 1, wherein the parameterized workbook is a first parameterized workbook, the method further comprising:

defining a second parameterized workbook; and

referencing a named result from the second parameterized workbook in a formula in the first parameterized workbook.

12. The method of claim 11, wherein values for parameters of the second parameterized workbook are determined by formulas contained in the first parameterized workbook.

13. The method of claim 1, further comprising:

storing, separate from the spreadsheet and after the spreadsheet closes, an intermediate value used in a calculation for the spreadsheet; and

associating the intermediate value with the parameterized workbook and a value of the parameter used to calculate the intermediate value.

14. The method of claim 13, further comprising:

automatically calculating a named result associated with the parameterized workbook without opening the spreadsheet by using the stored intermediate value.

15. The method of claim 1, further comprising:

distributing calculations of the spreadsheet among a plurality of computing devices.

16. The method of claim 15, wherein distributing calculations of the spreadsheet comprises:

distributing the calculations of the spreadsheet among a plurality of computing devices based at least in part on one or more formulas in the spreadsheet.

17. The method of claim 15, wherein distributing calculations of the spreadsheet comprises:

distributing the calculations of the spreadsheet among a plurality of computing devices based at least in part on one or more associations stored in a database associated with the parameterized workbook.

18. The method of claim 1, further comprising:

storing information associated with the parameterized workbook in a parameterized workbook information database that is separate from the parameterized workbook;

storing a location of the spreadsheet; and

storing a list of parameters associated with the spreadsheet.

19. The method of claim 18, further comprising:

storing, separate from the spreadsheet and after the spreadsheet closes, an intermediate value used in a calculation for the spreadsheet; and

associating the intermediate value with the spreadsheet and a list of values for the list of parameters associated with the spreadsheet and used in the calculation of the intermediate value.

20. The method of claim 19, further comprising:

automatically calculating many workbook results by enumerating lists of legal parameter values based on type information associated with each respective parameter.

21. The method of claim 19, further comprising:

automatically calculating a workbook result associated with the spreadsheet without opening the spreadsheet through use of the stored intermediate value.

22. The method of claim 18, further comprising:

storing a list of outputs associated with the spreadsheet.

23. The method of claim 18, further comprising:

storing an association of the spreadsheet to another spreadsheet upon which the spreadsheet depends.

24. The method of claim 23, further comprising:

monitoring the other spreadsheet to detect a change within an output of the other spreadsheet.

25. The method of claim 24, further comprising:

automatically performing a calculation using the spreadsheet in response to detecting the change within the output of the other spreadsheet.

26. The method of claim 18, further comprising:

storing an association of the spreadsheet to a data source upon which a formula in the spreadsheet depends.

27. The method of claim 26, further comprising:

monitoring the data source to detect a change within the data source.

28. The method of claim 27, further comprising:

automatically performing a calculation using the spreadsheet in response to detecting the change within the data source.

29. The method of claim 18, further comprising:

storing version data associated with the spreadsheet.

30. The method of claim 18, wherein the location comprises a network address.

31. The method of claim 18, further comprising:

distributing calculations of the parameterized workbook among a plurality of computing devices based at least in part on one or more stored dependencies of the parameterized workbook on other parameterized workbooks or external data sources.

32. The method of claim 18, further comprising:

distributing calculations of the parameterized workbook among a plurality of computing devices.

33. The method of claim 32, wherein the distribution is based at least in part on one or more formulas in the spreadsheet.

34. The method of claim 32, wherein the distribution is based at least in part on one or more dependencies of the parameterized workbook on other parameterized workbooks or external data sources, wherein the dependencies are stored in a database associated with the parameterized workbook.