INQUIRE FOR SOLVER CIRCULAR FORMULATION - money wizards
thanks and more power
"JLatham" wrote:
I think you are asking if it can deal with a circular reference, and I
believe the answer is YES, it can. But I do not use solver very often at
all, and I may be wrong.
"romelsb" wrote:
Thanks Jlatham,
Will solver work out when there is one loop of circular formulation and
wherein one of the solver constraints is within the equated loop ?
"JLatham" wrote:
From Excel Help | Excel Specifications and limits
Adjustable cells in Solver: 200
"romelsb" wrote:
I am eager to know the limitation of the standard solver add-ins with the
circular formulation of worksheets in a single workbook. How many
circular-looping formulation is possible in a one set of Solver parameter -
Say the target is for minimum Cost - in one workbook ?
Thanks for any reply !!!
romelsb
|