Results 1 to 12 of 12

Linearity condition not satisfied with Solver when including binary variables

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2022
    Location
    uganda
    MS-Off Ver
    365
    Posts
    3

    Linearity condition not satisfied with Solver when including binary variables

    Hi, I'm trying to model a stock selection portfolio using binary variables for the selection of stocks and the variables for weighing the stocks themselves, but Solver refuses to solve my model when i use the simplex method and pops out the error of 'linearity condition by this solver LP is not satisfied'. I tried nonlinear model like GRG but it generated illegal variables like '1' in stock selection but 0% weight.
    The linearity report states that the weight variables and the objective function are not linear but I'm not sure how they aren't.

    Would much appreciate any help regarding this problem. Attached is my worksheet with the linearity report.
    Attached Files Attached Files
    Last edited by kthedead; 04-02-2022 at 03:20 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Solver error - Linearity condition not satisfied
    By tapaspanda1321 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-25-2021, 03:55 AM
  2. Excel Solver - linearity requirements not met in binary variable
    By tiredandconfused in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2020, 09:34 PM
  3. [SOLVED] Solver assignment problem with binary variables
    By fdghj in forum Excel General
    Replies: 6
    Last Post: 06-29-2019, 12:56 AM
  4. Replies: 5
    Last Post: 08-18-2016, 09:13 AM
  5. Function to input binary variables depending on larger/smaller than condition
    By Frederik_S in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-03-2015, 02:48 AM
  6. excel solver binary variables
    By kingkong123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2011, 01:59 PM
  7. Excel Solver: linearity and MOLP
    By fboehlandt in forum Excel General
    Replies: 1
    Last Post: 12-16-2010, 03:07 PM

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