Hello,

I made an excel sheet to simulate Fresnel diffraction patterns. I used
a 2 way data table to generate the "infinitesimal" contributions from
the EM field. After summation of the contributions in the 2D tables,
a have one result cell (that holds |E|) and three input cells
(variables) for x-, y-, and z- coordinate for the observation point.
When I change the coordinates manually, the results seem OK.

The idea was to use another table (one way table) to plot |E| versus
one of the input cells. However, I cannot get the table working. I
tried "scenarios" (filling in each scenario by hand), but Excel stores
the individual worksheets, so I ran out of the EXCEL 2000 internal
memory limit (I think of about 60MB). I also tried the offset
function, in combination with a one-way table. This also didn't work.

It seems that once you use a data table that uses one (or two) of your
variables, you cannot use another table to manipulate a third variable
(parameter).

Does somebody know a solution for this (I do not prefer a VB one)?

Best regards,

Wim
PA3DJS
www.tetech.nl
The PM is valid when you don't forget to take out abc.