INQUIRE FOR SOLVER CIRCULAR FORMULATION - money wizards
 

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

INQUIRE FOR SOLVER CIRCULAR FORMULATION - money wizards
 

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

INQUIRE FOR SOLVER CIRCULAR FORMULATION - money wizards
 

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

INQUIRE FOR SOLVER CIRCULAR FORMULATION - money wizards
 

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

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