Results 1 to 13 of 13

Looping Excel Formulas

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    7

    Looping Excel Formulas

    I had written a rather complicated excel spreadsheet previously.
    Now, I need to loop it.

    I have attached the spreadsheet and it works like this
    1) Input: I enter flow rate between 0.036 to 1.61 into the red box
    2) The spreadsheet does some lengthy calculations
    3) Output: The spreadsheet produces 2 output values in the yellow boxes - frequency and amplitude.

    Now, I need to repeat this procedure many times for different inputs to plot an input vs. output graph.

    I.e. I need to have inputs from 0.036 to 1.61 in steps of 0.001, and get the corresponding output.
    In the attached "To Plot" worksheet is the sample result which I should get.

    If it was C, the loop would go something like this.

    int x = 0.036;
    while (x < 1.61) {

    //(read input, calculate, produce output, save to file)

    x=x+0.001;
    }


    So how can I implement this? Thanks in advance for your replies!
    Attached Files Attached Files
    Last edited by boiledbeans; 04-25-2012 at 10:28 AM.

Thread Information

Users Browsing this Thread

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

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