Solver with Multiple Target Cells

    Is it possible to run a solver on multiple target cells, i.e. to solve cells A1:A10 to all equal 100 by changing all of B1:B10?


    To make matters worse, this is a [deliberately] circular model...


    Any suggestions gratefully received.


    Unfortunately, I can't attach the file, so this will have to be an abstract question.

    This seems like a Goal Programming Application. You might want to consult a basic OR (Operations Research) book (Hillier & Lieberman or similar).

    Re: Solver with Multiple Target Cells


    I have the same problem.
    Would like to use solver on multiple target cells, i.e. to solve cells A1:A10 to equal 0 by changing B1:B10.


    Anyone knows how to do it? Is it possible?
    I can attach the file, but don't know how do it. I'm new here...

    Re: Solver with Multiple Target Cells


    InfoCHD,
    First open your own thread and make reference to this one if you need.
    Secondly to attach a file see the "Go Advanced "button at the bottom of the thread window and follow the instructions
    PCI

    Triumph without peril brings no glory: Just try

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login