Get Help

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community
- :
- PTC Mathcad
- :
- PTC Mathcad
- :
- How to treat an excel table as a variable

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

05-04-2011
10:51 AM

05-04-2011
10:51 AM

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

Labels:

4 REPLIES 4

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

05-04-2011
11:00 AM

05-04-2011
11:00 AM

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

05-05-2011
11:48 AM

05-05-2011
11:48 AM

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 :

after this notation i fix my "function" :

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

05-05-2011
03:23 PM

05-05-2011
03:23 PM

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

05-06-2011
06:52 AM

05-06-2011
06:52 AM

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