Results 1 to 6 of 6

Excel Solver - variables not changing or solution not correct

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2021
    Location
    Sydney, Australia
    MS-Off Ver
    2010
    Posts
    2

    Excel Solver - variables not changing or solution not correct

    Hi

    I am trying to solve an equation using Excel Solver. I am new to this function and have been self teaching but I think I'm at an impasse and looking for some help.

    In the attached file there are 9 variables in row 2 - these are what I am looking to solve. The formula is in column E. It is the variables multiplied by a value + the next variable multiplied by the next value....

    Like so....OA = (CON*A)+(TAL*B)+(EXP*C)....

    I Know the values for OA, CON, TAL, as these are in the data set. I am trying to calculate A, B, C... I know most of the variables (H2:O2) are between 0.05 and 0.20 and that the variable in R2 is between -0.05 and -0.20.

    So Far I have tried using solver to find a value of 0 when we subtract the calculated OA using my formula from the actual OA. I believe this should work in theory but solver is saying it has a solution and that solution doesn't end up being close to 0. I have tried different solving methods and I understand the solution is linear so mainly trying the LP Simplex engine with constraints added but either the solution isn't near 0 or the variable values don't change.

    Please let me know your thoughts and / or any other information that could help you help me
    Attached Files Attached Files
    Last edited by CaptainCow; 04-03-2021 at 11:00 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Solver - Multiple By Changing Variables
    By PingPongYeah in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2018, 02:20 PM
  2. Replies: 4
    Last Post: 01-01-2017, 07:38 PM
  3. Excel Solver - help getting it to produce the correct solution
    By adodson in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-09-2015, 01:59 AM
  4. Use Solver in excel to find a solution to this set of equations.
    By lovejohn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-01-2014, 11:11 AM
  5. Replies: 11
    Last Post: 10-30-2013, 02:11 PM
  6. [SOLVED] Why is excel solver saying that there is not a feasible solution?
    By jt13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2006, 01:30 PM
  7. Solver does not find correct solution???
    By experiment626 in forum Excel General
    Replies: 5
    Last Post: 08-18-2005, 07:05 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