System and method for efficiently and flexibly utilizing spreadsheet information
First Claim
1. A method for utilizing a spreadsheet, the method comprising:
- defining a parameter external to the spreadsheet; and
associating the parameter with the spreadsheet to define a parameterized workbook.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
81 Claims
-
1. A method for utilizing a spreadsheet, the method comprising:
-
defining a parameter external to the spreadsheet; and
associating the parameter with the spreadsheet to define a parameterized workbook. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. A system for utilizing a spreadsheet, the system comprising:
-
a spreadsheet comprising one or more associated formulas; and
a list of parameters associated with the spreadsheet, the list of parameters being external to the spreadsheet and one or more parameters within the list referenced in the one or more associated formulas of the spreadsheet. - View Dependent Claims (17, 18, 19, 20, 21)
-
-
22. A method for utilizing a plurality of spreadsheets, the method comprising:
-
defining a parameter; and
defining a set of one or more selection rules to select a first spreadsheet from a plurality of spreadsheets based at least in part on a value of the parameter, thereby defining a virtual workbook. - View Dependent Claims (23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39)
-
-
40. A system for utilizing a plurality of spreadsheets comprising:
-
a list of parameters; and
a selection module to select a first spreadsheet from a plurality of spreadsheets. - View Dependent Claims (41, 42, 43, 44, 45)
-
-
46. A method for storing information associated with a spreadsheet, the method comprising:
-
storing a location of a reference spreadsheet; and
storing a list of parameters associated with the reference spreadsheet. - View Dependent Claims (47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62)
-
-
63. A method for utilizing a spreadsheet, the method comprising:
-
defining a parameter associated with the spreadsheet; and
generating a data query based at least in part on the parameter. - View Dependent Claims (64)
-
-
65. A method for utilizing a spreadsheet, the method comprising:
-
defining a template within the spreadsheet; and
generating an output based at least in part on the template. - View Dependent Claims (66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77)
-
-
78. A method for utilizing a spreadsheet, the method comprising:
-
defining an output range within the spreadsheet;
rendering the output range; and
allowing a user to modify the rendered output range. - View Dependent Claims (79, 80, 81)
-
Specification