Excel solver macro help.
November 1, 2009 11:24 AM Subscribe
I have a column of around 100 equations that can only be solved with solver in Excel.
Is there any way to create a macro for this purpose. The layout of the spreadsheet given below.
posted by Lucubrator to Computers & Internet (3 answers total) 1 user marked this as a favorite
........................ |W1|W2|W3| SD
E(Rp1) "|............| 0 | 0 _ |_1|_0
We are seeking to minimize SD by changing W1, W2 and W3, under the constraint E(Rp1)= a certain number: which starts at say 2 and increases by .1 till 20. The question is whether macros can be written for add-ins?
All that weird formatting was to make sure the cells would line up.