Results 1 to 2 of 2

Math Help - Constrained Optimization Problem - Software that will do it?

  1. #1
    Newbie
    Joined
    Jul 2011
    Posts
    17

    Constrained Optimization Problem - Software that will do it?

    Hello,

    I have a problem with a few hundred variables, which have non-linear relationships, and constraints on their possible values. I'm wanting to set these up in an optimization framework to solve their values.

    Conceptually it's all done -in my head - but I'm not confident that Excel 2010 & my awesome computer are enough to get this one done. Also, I don't have a way to split the problem.

    Would you please recommend a free/open-source program or a technique in Excel that will allow me to put this one to bed? I'm in search of something quick and effective today, so I can't learn any programming languages or do this one by hand.

    Any suggestions from your experience appreciated!

    William
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4

    Re: Constrained Optimization Problem - Software that will do it?

    Quote Originally Posted by Will57 View Post
    Hello,

    I have a problem with a few hundred variables, which have non-linear relationships, and constraints on their possible values. I'm wanting to set these up in an optimization framework to solve their values.

    Conceptually it's all done -in my head - but I'm not confident that Excel 2010 & my awesome computer are enough to get this one done. Also, I don't have a way to split the problem.

    Would you please recommend a free/open-source program or a technique in Excel that will allow me to put this one to bed? I'm in search of something quick and effective today, so I can't learn any programming languages or do this one by hand.

    Any suggestions from your experience appreciated!

    William
    The Excel solver is not up to a non-linear constrained optimisation problem with several hundred variables. You will probably need a technique like simulated annealing or genetic algorithms if there are no further special features of your problem (use Google to search for appropriate software, there may be tools available in Matlab or Octave to help you).

    CB
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Constrained optimization problem : Cost minimisation
    Posted in the Business Math Forum
    Replies: 1
    Last Post: March 29th 2011, 04:25 AM
  2. Constrained Optimization
    Posted in the Calculus Forum
    Replies: 0
    Last Post: May 19th 2010, 01:05 AM
  3. Constrained Optimization again
    Posted in the Calculus Forum
    Replies: 2
    Last Post: April 5th 2010, 04:45 AM
  4. A Question on Constrained Optimization
    Posted in the Advanced Applied Math Forum
    Replies: 2
    Last Post: December 3rd 2009, 07:00 AM
  5. Need help with Constrained Optimization
    Posted in the Calculus Forum
    Replies: 3
    Last Post: December 1st 2006, 11:41 AM

Search Tags


/mathhelpforum @mathhelpforum