Results 1 to 10 of 10

Solver/Goal Seek HARD Optimization Issue

Threaded View

  1. #1
    Registered User
    Join Date
    07-01-2013
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    43

    Solver/Goal Seek HARD Optimization Issue

    Thanks for taking the time to help - I will lay out what my data looks like, what I am trying to do, and what I have attempted already - The short and sweet of it, however, is that I am looking to use some type of optimization feature. I have also included a sample file of my problem!!

    WHAT MY DATA LOOKS LIKE:
    I am analyzing food as nutrition compares to user enjoyment -- I have a list of different types of food in Column A, in Column B is a numerical score that I have given the food based on nutrition (Nutrition Rating). In Column C I have a numeric score given to each food based on how much people enjoy eating it (Enjoyment Rating).

    WHAT I AM TRYING TO DO:
    I would like to run an optimization analysis to find how to maximize the Enjoyment Rating given that I constrain the number of food options (say there can only be 5 foods) and that I constrain the Nutrition Rating (nutrition rating cannot exceed 100).

    THE TROUBLE AND WHAT I HAVE DONE:
    I have not been able to find a way to optimize while keeping the nutrition value of each food the same and selecting the best combination of 5 foods from a list of 100 foods. I have attempted to use Goal Seek and the add-in Solver, however, I am having trouble setting this up to use the list of foods and keep the nutrition value the same in order to maximize the sum of Enjoyment Rating which also stays the same. In other words, I do not know what to use as the variable that goal seek and/or Solver changes.

    All help is extremely appreciated and welcome!

    Thanks!
    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. Solver or Goal Seek Question
    By ljochmann in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2014, 04:57 PM
  2. Goal Seek, Solver, and an IRR Workaround
    By Jakila2 in forum Excel General
    Replies: 7
    Last Post: 08-21-2013, 03:48 PM
  3. [SOLVED] Using Solver vs Goal Seek
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2013, 08:18 AM
  4. [SOLVED] Solve formula with another way than solver/goal seek
    By keis386 in forum Excel General
    Replies: 6
    Last Post: 08-02-2012, 10:21 AM
  5. Goal Seek and SOLVER
    By dalebirrell in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 04-22-2010, 05:59 AM
  6. [SOLVED] Excel Goal Seek vs. Solver
    By Adrian T in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2005, 10:40 AM
  7. [SOLVED] goal seek vs solver
    By neoschenker in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-03-2005, 12: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