How to treat an excel table as a variable

[WladimirKazantz]

Hello everybody

I don not know if the title is good enough for my question.

Ok, I have several excel tables in several worksheets. On every of these tables I have several output variables.

I would like to put all these tables in one worksheet, but to treat every of these tables as variables.

EXAMPLE

I want to use something like a function and when I type f(170) it will use the one table and when f(180) another.

Because I am sure that nobody understand this, I'll attach two worksheets which I want to make them one.

Every table refer to different angle. I want to use the angle as a variable for a function : volume(Energy,angle) = ...

[MikeArmstrong]

Your worksheet is very complicated and messy (hard to follow).

If you have all your Excel sheets situated in one Excel sheet on different tabs you could then call them up at will. You could also have them all on a single sheet with Excel and pre-define the regions.

Mike

[WladimirKazantz]

I think i fixed it

I gave a different name for every output variable of every excel table i.e

EnergyAu ⇒ EnergyAu170 , EnergyAu165 and so on...

and then i fixed a vector with 8 rows and 1 column, named Energy_Au =

So I have :

after this notation i fix my "function" :

I think I was clear. If not let me explain better.

[MikeArmstrong]

There are many ways to achieve exactly what you where asking.

Can you provide the worksheet so I can see what you have done.

Mike

[WladimirKazantz]

Hello,

I have some problems on programs in "Au programs" area.

Exactly I have problems in program named "enau"

but when i made this worksheet was the first time i experienced with program ability in mathcad so

it may have problems.

I think I'll fix it.

wladimir