tabulating results of non-linear function

  • Thread starter Thread starter windsurferLA
  • Start date Start date
W

windsurferLA

In Excel'97, a complex spread sheet computes y = f(u, v) where y is the
answer and u and v are variables. There are other variables as well,
so really

y = f( u, v, x, w) , but lets assume x and w are constant.

I want to tabulate y as a function of u for several values of v, so they
can be graphed.

I can do this by manually sequentially entering the values for u and v
and recording the value of each corresponding y. I can also write a
macro to sequentially substitute a set of values for u and v, and in
turn enter the computed value of y into a second spread sheet, so the
u, v, and y relationship can later be graphed.

MY QUESTION I have a vague recollection that there is a simpler way. Am
I right that there is a simpler way, and if so, what is it?
 
There is a simpler way: the Data>Table command. You can set up a 2-dimensional table with your variables u and v and have Excel
fill the table with results, using your existing spreadsheet.

Look in HELP for how to do this. It takes a bit of time and is not very straightforward, but it works.

Post again in this thread if you can't get it done

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| In Excel'97, a complex spread sheet computes y = f(u, v) where y is the
| answer and u and v are variables. There are other variables as well,
| so really
|
| y = f( u, v, x, w) , but lets assume x and w are constant.
|
| I want to tabulate y as a function of u for several values of v, so they
| can be graphed.
|
| I can do this by manually sequentially entering the values for u and v
| and recording the value of each corresponding y. I can also write a
| macro to sequentially substitute a set of values for u and v, and in
| turn enter the computed value of y into a second spread sheet, so the
| u, v, and y relationship can later be graphed.
|
| MY QUESTION I have a vague recollection that there is a simpler way. Am
| I right that there is a simpler way, and if so, what is it?
 
Thanks for pointer.. I solved my problem with Data Table, but after
looking at the link you suggested, I ordered a copy of Bovey's book.
 
Back
Top