+ Reply to Thread
Results 1 to 2 of 2

Solver 2013 Constraints Management

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    Long Beach, WA
    MS-Off Ver
    Excel 2013
    Posts
    87

    Solver 2013 Constraints Management

    I've built an analysis tool that requires Solver. It works but it's hard to reconfigure. (This is for Excel 2013).
    The problems have to do with Solver constraints. In this case there are quite a few of them (20 to 30).
    - There doesn't seem to be any rhyme, reason or control over the order in which they are displayed. How might one get them in some order?
    (For example, I have constraints like this:
    $A$3<=20
    $A$3>=0
    $A$3 integer
    $B$3<=20
    $B$3>=0
    $B$3 integer

    and they show up randomly on the list more like this - which makes it hard to check for consistency, errors, etc.
    $B$3 integer
    $A$3<=20
    $B$3>=0
    $A$3 integer
    $A$3>=0
    $B$3<=20

    And, I believe the order doesn't even stay the same from time to time.


    - If one tries to add a constraint cell to the list, a right or left arrow ADDS the current cell to the list wherever the cursor lies in the list. So, it could be in the middle of a cell reference and one would go from $A3 to $A$B43. How to enter new cell references without strange behavior like this?
    - I can read the contents of the saved model but don't know any tricks yet for listing the constraint cells as text. I'm beginning to believe that best practice would be to list all the constraint cells in one contiguous list so that this latter issue could be addressed.

    If you don't know the answers directly, some links to good information would be helpful.

  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: Solver 2013 Constraints Management

    As I've never seen that problem nor do I have access to Solver (Excel 2013) I can only help you with a link to "FrontlineSolvers"

    http://www.solver.com/excel-solver-help

    You could also try discussing this problem with their support department.

    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. Solver constraints help
    By Rogeo in forum Excel General
    Replies: 0
    Last Post: 01-11-2014, 04:56 PM
  2. How to use Solver constraints : dif
    By alee001 in forum Excel General
    Replies: 0
    Last Post: 06-06-2012, 02:36 PM
  3. Solver constraints shall be OR // Solver target cell
    By Cunner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2009, 04:28 AM
  4. Solver Constraints
    By jason0625 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 06-02-2007, 04:11 PM
  5. Solver Constraints
    By Rick in forum Excel General
    Replies: 15
    Last Post: 03-09-2005, 01:06 PM

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