Tag Archives: Solver

Use Excel Solver to solve non-linear problem – solution of general neural network

Excel is a powerful application. With additional Add-ons, it can be used to solve very complicated problem. Recently, one of my friends ask me how to solve neural network problem in Excel. Sure it can do the job. I will … Continue reading

Posted in Excel | Tagged , , , , , , | 3 Comments

Use VBA script to control Solver

We usually use Excel to store a lot of data. To process these data, especially fit nonlinear model, is complicated. Excel provides a optimization tool called Solver that can be utilized to solve nonlinear problem numerically. In the past, we … Continue reading

Posted in Excel, VBA/ASP | Tagged , , | 1 Comment

Simple way to utilize Excel Solver

Excel Solver is a powerful tool to solve any nonlinear problem in Excel. Excel provide a interface to allow use to select options and fill target and parameters. If you only work on one set of data and explore multiple … Continue reading

Posted in Excel, VBA/ASP | Tagged , , , , | 2 Comments