+ Reply to Thread
Results 1 to 4 of 4

Solver If Function workaround

  1. #1
    Registered User
    Join Date
    07-17-2019
    Location
    Rotterdam, Netherlands
    MS-Off Ver
    365
    Posts
    2

    Solver If Function workaround

    Hi!

    I want to use piecewise linearization on quadratic equation on my linear programming. I have Wij as a decision variable and would like to incorporated it to 1/(Wij)^2 as a dependent variable. I know I can use a certain range to make the quadratic equation linear, but I am not sure on how to do that in Excel.


    I attached my work below, the specified problem located in sheet "correct".

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-13-2004
    Location
    Gothenburg/Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2007 & reluctant Excel 2010 user
    Posts
    4,501

    Re: Solver If Function workaround

    Looks like you are working with OpenSolver. Perhaps you could contacted the developers, University of Auckland NZ and see if they can offer some help.

    Alf

  3. #3
    Registered User
    Join Date
    07-17-2019
    Location
    Rotterdam, Netherlands
    MS-Off Ver
    365
    Posts
    2

    Re: Solver If Function workaround

    Hi Alf,

    I tried to do it in Solver as well, but the problem persists because I include non-linear equation in linear programming. One of the solution is that I make the non-linear equation into linear equation by using piecewise linearization, but I dont know how to do it given my described problem.

    Cheers.

  4. #4
    Forum Expert
    Join Date
    03-13-2004
    Location
    Gothenburg/Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2007 & reluctant Excel 2010 user
    Posts
    4,501

    Re: Solver If Function workaround

    I tried to do it in Solver as well
    I think that the number of cells to change is to big for the excel solver so you need a more powerful solver.

    Frontline the makers of the Excel Solver do have a number of more powerful solver that they sell but it's possible to download a trial model of their most advanced models for free and test it for 15 days.

    See link below

    https://www.solver.com/fls-register

    The other option is if you are a student then may have the possibility to download an advanced solver model much more powerful than the excel model. See link "welcome-students"

    https://www.solver.com/welcome-students

    You could also try to contact the Frontline help desk and see if they have any suggestion on how to solve your problem.

    Alf
    Last edited by Alf; 07-23-2019 at 05:16 PM.

+ 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. [SOLVED] MATCH function workaround/documentation
    By johnnymac in forum Excel General
    Replies: 3
    Last Post: 02-01-2017, 02:33 PM
  2. MATCH() function help and/or workaround
    By johnnymac in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-31-2017, 08:13 PM
  3. [SOLVED] Solver Constraint If statement workaround
    By tdanner1993 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-22-2016, 05:30 PM
  4. Goal Seek, Solver, and an IRR Workaround
    By Jakila2 in forum Excel General
    Replies: 7
    Last Post: 08-21-2013, 03:48 PM
  5. [SOLVED] Workaround for Excel's VBA Rnd function
    By lunch_bracketeer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2013, 11:11 AM
  6. [SOLVED] MATCH function workaround - nesting ADDRESS function?
    By BishBosh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2013, 03:45 AM
  7. [SOLVED] Is there a workaround for no IFERROR function in 2003?
    By mrvp in forum Excel General
    Replies: 7
    Last Post: 07-22-2012, 11:46 AM

Tags for this Thread

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