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

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

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

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

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