See below: Installing Solver.īesides macros to control Solver there are also examples on how to use Ranges, Arrays and UserForms with ListBoxes, ComboBoxes, TextBoxes, OptionButtons and CommandButtons. The workbook was made in Excel 2003, so you probably need to change the references to Solver. To unzip, right-click and select "decompress all" or whatever Windows suggests. You can download a much simpler version here. how much to use of different raw materials and fuels to get the desired quality. I work at a cement plant and have made an application for raw mix proportioning, i.e. An application can also be used by others that don't know much about Solver. Solver has many uses, and if it is a recurrent task, it can be a big advantage to make an application with VBA macros. How to mix raw materials to get a certain chemical composition at the lowest cost? How much ice cream to produce as a function of the weather forecast and day of the week? What buttons to press (how hard) to maximize profit? This page shows how to control Excel's Solver using VBA macros, and you can download a sample VBA application, that uses Solver.Įxcel's Solver is a strong tool to calculate and/or optimize complex models.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |