Hi All,
In need of help with complex Solver functionality - please reach out and I can send sheet with explanation.
Thank you
Hi All,
In need of help with complex Solver functionality - please reach out and I can send sheet with explanation.
Thank you
Please take a few minutes to read and ingest the forum rules, and then post your question here. That's the purpose of a forum.
Last edited by shg; 10-26-2016 at 11:54 PM.
Entia non sunt multiplicanda sine necessitate
Attached is the document I am working on.
I have values in col. I&J that I need to solve for using values in columns F&G. Needs to be broken out by the segments in column B.
Please message for more info. Thx all
Your workbook has external links that return errors, and no explanation of what you're trying to do.
Here is unlinked workbook - my mistake.
Explanation is in email text.
Attached is the document I am working on.
I have values in col. I&J that I need to solve for using values in columns F&G. Needs to be broken out by the segments in column B.
Please message for more info. Thx all
I do not see any functions that connect columns F & G to column I & J.
Some generic steps to setting up a Solver model (no matter how simple or complex)
1) You need an objective function -- the function in the "set target cell". Solver will generally work best if this function is smooth and continuous rather than discontinuous. [INT(), ROUND(), COUNT(), IF() are examples of functions that tend to create discontinuities).
2) You need to identify the "decision variables" -- the values to be changed in the "by changing" field.
3) Build the string of formulas that will accurately connect your decision variables with your objective function. While doing this, I like to use a set of input values for which I know the final solution. Program and debug these formulas -- making sure that there are no errors or other problems over the range of expected trial values as Solver works from the initial guesses to finding the desired solution.
4) Run several known scenarios until convinced that the spreadsheet formulas and Solver model are working as expected.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks