+ Reply to Thread
Results 1 to 7 of 7

Checking the minimum of iterative calculations:

Hybrid View

rajeshrajagopal Checking the minimum of... 04-06-2016, 06:53 AM
LordLoki Re: Checking the minimum of... 04-06-2016, 06:57 AM
rajeshrajagopal Re: Checking the minimum of... 04-06-2016, 07:07 AM
zbor Re: Checking the minimum of... 04-06-2016, 07:11 AM
rajeshrajagopal Re: Checking the minimum of... 04-07-2016, 01:57 AM
LordLoki Re: Checking the minimum of... 04-07-2016, 03:16 AM
rajeshrajagopal Re: Checking the minimum of... 04-07-2016, 07:17 AM
  1. #1
    Forum Contributor
    Join Date
    04-20-2015
    Location
    Switzerland
    MS-Off Ver
    2010
    Posts
    312

    Re: Checking the minimum of iterative calculations:

    Ok thats already a good base but i am not sure if i understand the need so let me try to summarize it my way.

    1. You Hit F9 and Recalculation happens
    2. You want to Check if the Yellow FN is lower than the Blue FN
    3. if yellow is lower than blue all the yellow values are stored in the blue area
    4. if yellow is bigger than blue blue stays untouched

    This way blue always holds the optimal parameters

    Is that correct so far?

    Edit: I made a sheet based on my assumptions so if i am right you already have something to work with.
    Some information about it.

    1. i set the Calculation mode of the Sheet to Manual so Calculation only happens if you press F9 this way it will not always be triggered when you change a cell.
    2. I see in Column AF you have some Circula Reference Formula to count itereations that should be removed ( i did not remove it)
    3. I added a counter for iterations in B252 which adds 1 every time calculation happens
    4. i wrote a small script that is linked with the button "auto Iterate" it will ask you how many iterations you want to be done then calculate the sheet that many times
    when it is finished it tells you in a message box how often the blue fn changed while doing the iterations and at wich iteration it changed the last time so if you do 1000 iterations for example it says
    "Minfn changed 20 times in 1000 Iterations and the last change happend in Iteration 459"

    Thats about it hope i understood your request correctly :D
    edit2: you can remove the last msgbox from the code used it to check how long it runs with and without screen update :D
    Attached Files Attached Files
    Last edited by LordLoki; 04-07-2016 at 04:36 AM.

  2. #2
    Registered User
    Join Date
    04-06-2016
    Location
    Trivandrum, India
    MS-Off Ver
    2010
    Posts
    4

    Re: Checking the minimum of iterative calculations:

    Exactly the same as you mentioned is needed for calculation. Thank you so much

+ 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. Iterative Formula
    By kathrynreno in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2016, 09:23 PM
  2. Replies: 7
    Last Post: 04-17-2013, 03:53 PM
  3. Replies: 4
    Last Post: 12-10-2012, 06:22 PM
  4. Fixing a divide by 0 error with iterative calculations
    By jrm0523 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2012, 02:30 PM
  5. [SOLVED] Need a formula to find the minimum value in an array, then perform calculations on ....
    By jschneider92 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-06-2012, 12:59 AM
  6. Replies: 3
    Last Post: 04-01-2012, 05:37 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