Exporting from Polymath to Excel

See Also: Nonlinear Equations Solver  Differential Equations  Regression Package 

The Polymath programs listed below currently have the capability to export problems directly to Excel 2000 and later.  In all cases, the equations are automatically translated into the appropriate equations within Excel and utilize the available functions within Excel.  Error messages are given when needed functions are not available.  The exporting process results in a well-documented program that is ready to solve completely within Excel.  The Excel problem will be setup and provide results in a very similar way to that of the Polymath program.  In every case, the "Export to Excel" command from the Program menu or pressing the  button.  Instructions for the use of Excel with exported problems the Polymath programs are discussed below.

Nonlinear Equations Solver

The Excel "Solver" Add-In or software from some other vendor must be used to solve the system of nonlinear equations.  In the automated exporting process, a sum-of-squares of the functions that are to be zero at the solution is formed.  Then you must use "Solver" to minimize this sum-of-squares function by altering the variables.  The "Export to Excel" keypress opens up the problem in the Excel spreadsheet.  The problem is translated to the first sheet in a workbook, and solutions are generated on additional workbook sheets.  Details are available.

Differential Equations Solver

Polymath Software has created an ODE_Solver Add-In for Excel that is able to solve simultaneous ordinary differential equations.  In the automated exporting process, these differential equations, their initial conditions are arranged for easy access and use by the Polymath ODE_Solver.  You must use this Add-In to solve the problem by indicating the initial and final values for the independent variable.  The problem is translated to the first sheet in a workbook, and solutions are generated on additional workbook sheets.  Details are available.

Regression Program

Linear & Polynomial Regression and Multiple Linear Regression

 

The exporting process for the regression program listed above generates Excel programs that are completely executed at the time of export.  These regressions and the associated statistics are produced through the use of Excel's LINEST function which yields and output array that is used in the spreadsheet area that report the results.  Details of Excel use with Linear, Polynomial, and Multiple Linear Regression are available.

 

Nonlinear Regression

 

The exporting of a nonlinear regression program creates a problem in Excel that must be solver with the "Solver" Add-In that is available to users. Details of Excel use with Nonlinear Regression are available.