I would like to use Excel's Solver to minimize the sum of the square errors between observed data and a model. I know how to do this if the model is an Excel function in cells in the worksheet. However, I am working with a very complicated series of functions that I would like to be user-designed functions (UDF) written in VBA. Is it possible to use Solver to optimize a cell in an Excel file that is a function of a VBA UDF? I have attached a very simple model illustrating what I am trying to do, where "model" is a VBA UDF, and I would like to use Solver to minimize D9 by changing the parameters G4 and G5.
Thanks very much for any help you can provide.
Red Flag Submitted
Thank you for helping keep Eng-Tips Forums free from inappropriate posts. The Eng-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Eng-Tips forums is a member-only feature.
Lean integrators are leveling the playing field for SMEs in highly innovative and cost-effective ways. This white paper discusses how developments in robotics technology has led to a rise in lean integrators, whose unique structures and focused areas of expertise are critical to delivering automation benefits for small to medium enterprises (SMEs). Download Now
Asset lifecycles of capital assets like manufacturing or utility plants are decades-long. But economic shifts and trade policy disruption mean executives must make rapid adjustment to asset portfolios. Download Now
Traceability is increasingly important in the food and beverage sector due to strict regulations and rising consumer demand for corporate social responsibility. Three technological advancements are key to cost-efficient, reliable traceability measuresâ€”Big Data, the Internet of Things and Cloud solutions. Download Now
Why do aviation and defense (A&D) manufacturers need enterprise resource planning (ERP) with built-in estimate at completion (EAC) and estimate to completion (ETC) capabilities? Because it's all about project manufacturing and project accounting. Download Now