Can I loop through input variables, or calculate with a list of inputs?

[dazz]

Hi
I have a complex problem to solve. It is an electronic filter. I need to step through a list of input frequencies, and for each input, record the output value. I want to chart these output values.

I’d like to do something like:
From 1 to 1000, Step=10 do
Calculate something and store it in a list of x,y
Loop.

[Villeroy]

1. Enter 1 into A1.
2. Do the calculations for the first row in the first row.
3. Select all the cells in the first row and drag the cell handle in cell’s the lower-right corner down by 999 rows.

Column A will get a sequence 1,2,3,…,1000, the other columns get the right formulas relative to their rows.
All you have to know is the difference between absolute and relative referencing in spreadsheets.

[koyotak]

maybe something like the exponential function for natural physical values such as frequencies
00000_LO-CALC_sukzessive approximation_v0002_024925.ods (69.4 KB)