cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to treat an excel table as a variable

How to treat an excel table as a variable

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) = ...

4 REPLIES 4

Re: How to treat an excel table as a variable

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

Re: How to treat an excel table as a variable

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 :

Untitled.png

after this notation i fix my "function" :

Untitled.png

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

Re: How to treat an excel table as a variable

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

Re: How to treat an excel table as a variable

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

Announcements