I sincerely appreciate your generosity in making this program freely available. I wanted to alert you to a bug involving named ranges. I added an OpenSolver worksheet to a financial spreadsheet that tracks my stocks and assets and has a few dozen named ranges. When OpenSolver runs, it replaces a lot of named ranges in pre-existing formulas (not OpenSolver related) in the workbook with OpenSolver-related named ranges. Perhaps if I protected those pre-existing formulas this wouldn’t happen.
OpenSolver does not change any formulae. Perhaps Excel is changing how the formulae are being displayed? Could you email us a screenshot, and the text from About OpenSolver giving the Excel version etc, to email hidden; JavaScript is required . Thanks, Andrew
Cool project. I’m using it with an Excel model written in VBA which runs much slower in Excel 2016. This lets me use the NOMAD non-linear solver with the faster Excel 2007 VBA.
How does OpenSolver evaluate derivatives for non-linear problems? Does it use finite-differencing or algorithmic differentiation, like, e.g., CasADi does?
If we parse the formulae then they are differentiated by the solver, eg by using chain rule I think. The Nomad solver does not use derivatives; it uses a grid style search. Andrew
hello i want to deactivate the opensolver msg box when the solution is not optimal.
I sincerely appreciate your generosity in making this program freely available. I wanted to alert you to a bug involving named ranges. I added an OpenSolver worksheet to a financial spreadsheet that tracks my stocks and assets and has a few dozen named ranges. When OpenSolver runs, it replaces a lot of named ranges in pre-existing formulas (not OpenSolver related) in the workbook with OpenSolver-related named ranges. Perhaps if I protected those pre-existing formulas this wouldn’t happen.
OpenSolver does not change any formulae. Perhaps Excel is changing how the formulae are being displayed? Could you email us a screenshot, and the text from About OpenSolver giving the Excel version etc, to email hidden; JavaScript is required . Thanks, Andrew
Cool project. I’m using it with an Excel model written in VBA which runs much slower in Excel 2016. This lets me use the NOMAD non-linear solver with the faster Excel 2007 VBA.
Andrew may you please create a solver plugin for onlyoffice?
D
Best regards
How does OpenSolver evaluate derivatives for non-linear problems? Does it use finite-differencing or algorithmic differentiation, like, e.g., CasADi does?
If we parse the formulae then they are differentiated by the solver, eg by using chain rule I think. The Nomad solver does not use derivatives; it uses a grid style search. Andrew