a nested mathcad worksheets

Forum|Forum|10 years ago
September 2, 2015
3 replies
2233 views

Hi,

Is it possible to call from within a worksheet, with parameters, to another worksheet that takes in as input the parameters of the call function and then runs and calculates the whole called sheet.

Thanks in advance,

Hussein

.

Other

L

LucMeekes

23-Emerald IV

Yes, that's no problem.

Example:

Define CalledSheet with:

Define CallingSheet with:

You can expand this of course.

Success!

Luc

T

tietjee

15-Moonstone

I use the reference worksheet to store function and programs. The reference worksheet is placed at the beginning of the "CallingSheet". This does a several things:

1. Functions call be used anywhere in the "CallingSheet". Documentation for the function will not clutter the "CallingSheet"

2. Programs take up a lot space and need documentation.

3. Consistent data and function between worksheets used in a single project.

The reference worksheet can also include unique constants (density air, seawater, etc.) listing of style examples, data...

Reference worksheets can be placed at the end of the "CallingSheet", all definitions have to globally defined.

R

RichardJ

19-Tanzanite

I assume you want to repeatedly call the worksheet, with different input parameters. If you have only one set of input parameters then you can just reference one worksheet in the other, as Luc shows. If you want to call the worksheet multiple times with different input parameters it's possible, but more difficult. You can use a scripted component in one worksheet to call the other worksheet via the automation interface. See the attached example.

1_Controller_v2-3-mcd.zip

2_Dummy-mcd.zip