+ Reply to Thread
Results 1 to 2 of 2

Simple Open Solver Setup Not Working

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007/10
    Posts
    43

    Simple Open Solver Setup Not Working

    This is driving me crazy and I would be your best friend if you could help me out - I am setting up a simple solve that chooses the low cost provider for each lane. I am looking to minimize cost and have one provider selected for each lane. When I run Open Solver for ~5 lanes, it solves correctly. When I run it for all 119 lanes, it returns some lanes with non-optimal cost (ex first one in the snip chooses the 3rd lowest cost).

    Is there something easy I am missing?

    Snip: https://i.imgur.com/2C2hB5K.jpg

  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: Simple Open Solver Setup Not Working

    A picture may by worth a thousand words but when it comes to troubleshooting it's a bit like taking a picture of your car engine and asking at you local garage what is wrong with this engine.

    Try uploading a file with your OpenSolver model as this will give forum members a chance to test and see if they can find a solution to your problem.

    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. Well working simple macro now not working-open folder
    By jomili in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 07-05-2017, 08:24 AM
  2. Solver, goal seek or more simple formula
    By faodavid in forum Excel General
    Replies: 5
    Last Post: 09-16-2015, 10:44 AM
  3. [SOLVED] Simple question: Can I setup a cell to automatically recalculate?
    By merubin75 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-14-2014, 12:56 PM
  4. Can't start Solver. Error message says Solver.xlam already open.
    By DaveHills in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 10-21-2012, 11:02 AM
  5. How to setup excel spreadsheet with SOLVER with data given as below
    By Jello1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2012, 12:32 AM
  6. Solve a simple equation using solver
    By crf1722 in forum Excel General
    Replies: 2
    Last Post: 06-16-2011, 03:30 PM
  7. [SOLVED] page setup feature is not working
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 08-15-2005, 12:13 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