Results 1 to 9 of 9

Solver GRG doesn’t take 10 variables

Threaded View

  1. #1
    Registered User
    Join Date
    08-08-2019
    Location
    Prague
    MS-Off Ver
    Excel 365
    Posts
    2

    Solver GRG doesn’t take 10 variables

    Hi, I am working on school project trying to construct equation which describes tabulated data.
    So far I’ve gotten to final form of the equation and am applying nonlinear GRG to obtain better coefficients for the equation.
    The problem is that Excel does not accept full set of variables that appear in the equation (10 variables a2->d) for the regression process.
    I have got to feed it manually "per partes" until I get to acceptable solution. So far got to SSE of approx. 266, but with correctly working solver it would probably got better.
    Any idea what is done wrong? Thank you, Excel file is attached, hope it is descriptive enough
    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 doesn't return a result
    By cavalieregiuseppe in forum Excel General
    Replies: 1
    Last Post: 08-10-2018, 01:44 AM
  2. Replies: 7
    Last Post: 12-31-2016, 12:29 PM
  3. Solver doesn't find the best solution
    By waldymar in forum Excel General
    Replies: 1
    Last Post: 02-10-2016, 11:46 AM
  4. solver doesn't search
    By yangbo07520 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2013, 04:34 PM
  5. Solver doesn't find the right answer
    By yangbo07520 in forum Excel General
    Replies: 1
    Last Post: 10-09-2013, 02:24 PM
  6. solver doesn't find all solutions
    By Alexander_Golinsky in forum Excel General
    Replies: 4
    Last Post: 05-26-2012, 06:13 PM
  7. Solver checked but doesn't appear
    By charles_weaver@post.harvard.edu in forum Excel General
    Replies: 1
    Last Post: 02-06-2005, 05:05 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