Results 1 to 8 of 8

Using Solver With Another Iterative Routine

Threaded View

  1. #3
    Registered User
    Join Date
    07-31-2008
    Location
    Australia
    Posts
    12
    Hi, thanks for your help and suggestion.

    The number of iterations made by the integrator is not known in advance. It is highly dependent on the integrand, and on the specified precision, both of which are changeable, and are passed as arguments.

    The integrator does not use any previously calculated values for its initial data. The sequence of X values is recalculated all over again, and the integrator simply repeats its process and exits with the same result.

    When the integrator converges, it puts its final result into a cell. I'm trying to get Solver to (then) use that cell as the Target cell, and to then change two other cells used by the integrand expression.

    It does seem that Solver has to be "put on hold" while it waits for the integrator to complete its iterative work, and to then exit its code. Only then should Solver read the target cell (the calculated integral value provided by the integrator), and make its changes to the changing cells as required.

    Then, the integrator has to be called again, to calculate the integral using the new changing cells data, while Solver rests up for a while... etc, etc, until the Solver exits.

    Any ideas appreciated.
    Last edited by kubota1000; 08-20-2008 at 10:11 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Looping and Solver
    By junejaja in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2008, 11:53 AM
  2. Solver Package and VBA Macros
    By junejaja in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2008, 09:02 PM
  3. Excel Solver giving wrong optimal solution
    By gtg430i in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2008, 02:29 PM
  4. Solver and Worksheet events
    By whuahu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2007, 09:38 AM
  5. SOLVER add-on problems
    By fl4sh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2007, 12:10 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