+ Reply to Thread
Results 1 to 3 of 3

excel solver binary variables

  1. #1
    Registered User
    Join Date
    11-27-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    3

    excel solver binary variables

    Hi guys

    I am having a problem in getting excel solver to solve a linear programming problem.
    Suppose i have binary variables as follows:
    0 1 1 0 1 0 1
    I want to track the change between each variable. eg if there's a change of value from one variable to the next then i want to times it by 15 ie (x2-x1)*15.
    The problem is i want a positive 15 not negative 15 in some cases.
    I tried using absolute value function but it's not linear so i cant use solver with simplex method to solve it.

    Note: I can only use solver simplex method to solve this.
    The above problem is an extract of a bigger problem with more constraints in solver.

    If you have any more questions feel free to ask.

    Thanks

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: excel solver binary variables

    Hi,

    is it an option to square the difference and then take a square root at a later stage?

    Regards
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    11-27-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: excel solver binary variables

    Quote Originally Posted by Richard Buttrey View Post
    Hi,

    is it an option to square the difference and then take a square root at a later stage?

    Regards
    Tried that and it does not work since it's not linear
    Any other suggestions?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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