Use of Worksheet events in Excel to save solver objective cell value from each iteration
Open Access
- 25 February 2022
- journal article
- Published by Pensoft Publishers in Research Ideas and Outcomes
- Vol. 8, e79006
- https://doi.org/10.3897/rio.8.e79006
Abstract
Solver is a Microsoft Excel add-in program which is used to find an optimal value for a formula in the objective cell. Solver accomplishes this either by maximizing, minimizing or setting the objective cell value to a specific value. The article presents the utility of in built worksheet events in Excel VBA to save the value of objective cell from each iteration when solver is used for optimization.Keywords
This publication has 2 references indexed in Scilit:
- Nonlinear least-squares data fitting in Excel spreadsheetsNature Protocols, 2010
- A step-by-step guide to non-linear regression analysis of experimental data using a Microsoft Excel spreadsheetComputer Methods and Programs in Biomedicine, 2001