Results 1 to 7 of 7

How to "Solve" Solver Optimization Mix Problem Errors

Threaded View

  1. #1
    Registered User
    Join Date
    10-14-2015
    Location
    East Coast
    MS-Off Ver
    2013
    Posts
    69

    How to "Solve" Solver Optimization Mix Problem Errors

    Hello all,

    I'm a little new to solver, so i'm probably missing something very simple, but here's my problem.

    I have a list of technologies with associated capabilities (score of 1-5). I have a set of requirements for said capabilities (score of 1-5). I have costs associated with each technology.

    I would like to run solver to find the most optimal combination of capabilities such to maximize the total score, given a cost constraint.

    However, when I run Solver in the attached, I keep getting either a linearity error or a "solver cant find solution". I know there's at least a feasible solution (I've done it myself).

    Please help!

    Best,
    Chris
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help to solve =IF(LINEST(Data!X:X)>0,"↑","↓") formula
    By excelnabb in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 01-28-2018, 01:11 PM
  2. Problem with Solver: "Can't find a feasible solution"
    By whoamiquestionmark in forum Excel General
    Replies: 7
    Last Post: 10-23-2017, 12:58 PM
  3. [SOLVED] VBA Solver - Stuck at "Setting up Problem"
    By Optra00 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-27-2017, 11:21 AM
  4. Master Summary sheet to "remember" formulae and not do "REF!" errors? (EXCEL 2003)
    By elizabethchilver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2016, 07:08 PM
  5. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  6. How to solve same date problem in "Summary List"?
    By peri1224 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2012, 12:25 PM
  7. Solver VBA - Problem - How to rid of Dialog Box "Single Step"
    By hahnchen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2008, 01:40 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