Model Based Spreadsheet Scripting Language
First Claim
Patent Images
1. A method of calculating a value using a model based spreadsheet scripting language, comprising the following steps:
- executing a program that defines a value for a second variable based on a value of a first variable, the program written in the model based spreadsheet scripting language whereby the value of the second variable changes repeatedly when the value of the first variable changes repeatedly;
receiving a value for a first variable;
calculating a value for the second variable based on the value of the first variable in the program; and
,generating an output comprising the calculated value of the second variable.
1 Assignment
0 Petitions
Accused Products
Abstract
Techniques for programming using a model based spreadsheet scripting language are disclosed herein, where procedural aspects may be incorporated along with the model based aspects therein. In particular, techniques for performing calculations of a value, and recalculation of interdependent formulas using programs written with the model based spreadsheet scripting language are disclosed.
55 Citations
20 Claims
-
1. A method of calculating a value using a model based spreadsheet scripting language, comprising the following steps:
-
executing a program that defines a value for a second variable based on a value of a first variable, the program written in the model based spreadsheet scripting language whereby the value of the second variable changes repeatedly when the value of the first variable changes repeatedly; receiving a value for a first variable; calculating a value for the second variable based on the value of the first variable in the program; and
,generating an output comprising the calculated value of the second variable. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A method of recalculating values for a plurality of formulas using a model based spreadsheet scripting language, comprising the following steps:
-
executing a program that defines a plurality of formulas, the program written in the model based spreadsheet scripting language whereby the values of the formulas change repeatedly when a first variable in one of the formulas changes repeatedly; receiving a change in value for the first variable; recalculating values for the plurality of formulas based on the change in value for the first variable; and
,generating an output comprising the recalculated values of the formulas. - View Dependent Claims (13, 14, 15, 16, 17)
-
-
18. A method of representing a spreadsheet, comprising the following steps:
-
executing a program that defines a plurality of formulas, the program written in a model based spreadsheet scripting language whereby values of the formulas change repeatedly when a first variable in one of the formulas changes repeatedly; and implementing procedural aspects into the program to define order therein. - View Dependent Claims (19, 20)
-
Specification