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!
Bookmarks