+ Reply to Thread
Results 1 to 2 of 2

Problem with a non-linear model

  1. #1
    Registered User
    Join Date
    12-22-2013
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Problem with a non-linear model

    Okay so I have a model which is currently non-linear. I have a problem in that the model exceeds the maximum number of constraints for the non-linear solver (100). So I have a couple options.

    1. Is there a free to use non-linear solvers which allows more than the 100 constraints the standard offers?
    2. Is there a way to make the model linear (have been told it's possible, but I don't see how)?

    Right now, what causes it to be non-linear is:
    - The objective cell is a MAX of all variable cells.
    - One of my set of constraints involves a multiplication. Basically:
    5 -2 -10
    0 4 0
    2 -1 -2
    One of the cells in each row needs to be <= 0. So currently I multiply the cells and then make sure the result is <= 0.
    - Another constraint which involves the subtraction of Max(0, result of 1 variable cell minus another)

    Rather vague and hard to explain but appreciate any help.

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Problem with a non-linear model

    Rather vague and hard to explain but appreciate any help.
    Perhaps an uploaded file would make it easier to understand?

    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. I Can't Model This Problem for a Dynamic Sheet
    By TKin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-19-2014, 05:54 AM
  2. Transportation model, linear programming and Solver
    By GregDP in forum Excel General
    Replies: 6
    Last Post: 12-07-2013, 04:56 AM
  3. Population Model - Can you find the problem here?
    By AngelIn in forum Excel General
    Replies: 3
    Last Post: 04-06-2013, 01:33 PM
  4. Create a model that will generate a column of numbers based on model parameters
    By tncanoeguy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 05:47 PM
  5. [SOLVED] linear model with solver
    By vert in forum Excel General
    Replies: 1
    Last Post: 04-04-2006, 11:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1