Abstract: The present disclosure provides a method, an apparatus, and a computer program product which communicate with a programming interface of a spreadsheet software application for computing a value of a spreadsheet formula depending on at least one variable cell explicitly or implicitly through interdependence on additional nested formulas, for a supplied value of the variable cell, and without storing or modifying any stored value in the spreadsheet application. In one aspect, the present disclosure teaches a method for computing a numerical value of a single or multiple integral equation using a pure integration function of the spreadsheet application.

Abstract: The present disclosure provides a method, an apparatus, and a computer program product to interact with a programming interface of a spreadsheet software application for computing the value of a formula that depends explicitly or implicitly on one or more cells designated as variables for the formula, based on supplied values for the variables, and without modifying any values or content of the spreadsheet software application. In a first utility, the method is utilized in pure solver functions of the spreadsheet application for computing numerical solution of an equation system modeled by at least one or more formulas and variables in the spreadsheet software application. In a second utility, the method is utilized in an optimization process executed by pure solver functions of the spreadsheet application for computing optimal parameters for a parameterized equation system modeled by at least one or more formulas, variables, and parameters.

Abstract: The present disclosure provides a method, an apparatus, and a computer program product to interact with a spreadsheet application for computing the value of a formula that depends explicitly or implicitly on one or more cells designated as variables, based on provided values for the variables, and without modifying any data of the spreadsheet application. In one aspect, the present disclosure provides a method for computing numerical solution of an equation system modelled by one or more variables, parameters, and dependent formulas in a spreadsheet application, using a spreadsheet function of the spreadsheet application.

Abstract: The present disclosure provides a method, an apparatus, and a computer program product to interact with a spreadsheet application for computing the value of a formula that depends explicitly or implicitly on one or more cells designated as variables, based on provided values for the variables, and without modifying any data of the spreadsheet application. In one aspect, the present disclosure provides an optimization process executed by spreadsheet functions of a spreadsheet application, and arranged in a functional paradigm for computing optimal parameters for a parameterized system modelled by variables, parameters, and dependent formulas.