+ Reply to Thread
Results 1 to 2 of 2

Solver Issues

  1. #1
    Registered User
    Join Date
    02-28-2017
    Location
    Cambridge, England
    MS-Off Ver
    Mac OS 07
    Posts
    1

    Solver Issues

    Hi , I am trying to use solver to minimise the difference between a guessed temperature value and a calculated temperature value in order to find the actual value. I have two formulas. one which calculates x from the guessed temperature value. this value of x is then used to calculated the calculated temperature. So far I have made a column with the formula (T guess - T calculated)^2 and using solver i set this column to 0 by varying the T guess column and also using the constraints Tguess <= 333 and Tguess>= 283. However, when I click solve I get the error "run- time error '1004' Application - defined or object - defined error". Any ideas what is going wrong? i've attached some of the screen shots of my spreadsheet as well, the value for q is just a constant which is given to me.

    Screen Shot 2017-02-28 at 22.53.05.pngScreen Shot 2017-02-28 at 22.53.43.pngScreen Shot 2017-02-28 at 22.53.52.png

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

    Re: Solver Issues

    Welcome to the board.

    You're more likely to get useful assistance if you post a workbook rather than a picture.

    This might be a good time to read the section of the forum rules about "how to get your question answered quickly"
    Entia non sunt multiplicanda sine necessitate

+ 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. Solver issues
    By milesy in forum Excel General
    Replies: 15
    Last Post: 09-19-2016, 12:50 AM
  2. Replies: 1
    Last Post: 04-27-2016, 03:05 PM
  3. Replies: 0
    Last Post: 07-20-2014, 12:45 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. solver macro + simulation code + not updating solver values
    By sabinemaria in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2012, 11:37 AM
  6. Add-in with Solver Reference Issues
    By Stacy35216 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2005, 12:20 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