+ Reply to Thread
Results 1 to 6 of 6

Solver - complex functionality

  1. #1
    Registered User
    Join Date
    11-12-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    40

    Solver - complex functionality

    Hi All,

    In need of help with complex Solver functionality - please reach out and I can send sheet with explanation.

    Thank you

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Solver - complex functionality

    Please take a few minutes to read and ingest the forum rules, and then post your question here. That's the purpose of a forum.
    Last edited by shg; 10-26-2016 at 11:54 PM.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-12-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Solver - complex functionality

    Attached is the document I am working on.

    I have values in col. I&J that I need to solve for using values in columns F&G. Needs to be broken out by the segments in column B.

    Please message for more info. Thx all
    Attached Files Attached Files

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Solver - complex functionality

    Your workbook has external links that return errors, and no explanation of what you're trying to do.

  5. #5
    Registered User
    Join Date
    11-12-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Solver - complex functionality

    Here is unlinked workbook - my mistake.

    Explanation is in email text.
    Attached is the document I am working on.

    I have values in col. I&J that I need to solve for using values in columns F&G. Needs to be broken out by the segments in column B.

    Please message for more info. Thx all
    Attached Files Attached Files

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,416

    Re: Solver - complex functionality

    I do not see any functions that connect columns F & G to column I & J.

    Some generic steps to setting up a Solver model (no matter how simple or complex)

    1) You need an objective function -- the function in the "set target cell". Solver will generally work best if this function is smooth and continuous rather than discontinuous. [INT(), ROUND(), COUNT(), IF() are examples of functions that tend to create discontinuities).
    2) You need to identify the "decision variables" -- the values to be changed in the "by changing" field.
    3) Build the string of formulas that will accurately connect your decision variables with your objective function. While doing this, I like to use a set of input values for which I know the final solution. Program and debug these formulas -- making sure that there are no errors or other problems over the range of expected trial values as Solver works from the initial guesses to finding the desired solution.
    4) Run several known scenarios until convinced that the spreadsheet formulas and Solver model are working as expected.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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] Complex If Statement without using goal seek or solver
    By cartica in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2016, 04:01 PM
  2. Replies: 0
    Last Post: 07-20-2014, 12:45 PM
  3. Complex VLookup and then adding drop down functionality
    By Excel Dumbo in forum Excel General
    Replies: 1
    Last Post: 08-17-2012, 01:54 AM
  4. Complex simultaneous equation, smart solver help
    By Cirion in forum Excel General
    Replies: 6
    Last Post: 12-07-2009, 03:32 PM
  5. Use of Excel's Solver Functionality
    By AccountantCost in forum Excel General
    Replies: 3
    Last Post: 10-24-2009, 11:43 PM
  6. Need help with functionality more complex than VLOOKUP offers
    By cswale in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2006, 05:49 AM
  7. Even more Complex COUNTIF functionality
    By rob.manger@gmail.com in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-21-2005, 01:05 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