Mathcad worksheet as a function

Forum|Forum|13 years ago
July 4, 2012
2 replies
13857 views

Hi forum

I was wondering if anyone know if it is possible to use a worksheet in a similar way as m-flies functions (Matlab) e.g. turn worksheet "alfa.xmcd" into a function which can be called from another worksheet?

Best regards Dan

Other

V

VladimirN

24-Ruby III

Hello,

In main menu select "Insert" -> "Reference" and then choose your worksheet with prepared function:

D

DanMadsen

Author

1-Visitor

Thanks Vladimir

The functionality I'm after isn't a single function in the worksheet, but the opportunity to use it as a function for an itterative analysis e.g. for monte carlo analysis which is seeded with random values every time the worksheet is called.

I've resently found out that the worksheet can be added as a scripted component (VBscript), but sofar I've only been able to assign a static value to the component output... I'm looking into this.

Btw. havn't written a single line of VBscript before, so if anyone know in advance that this is impossible to do with a scripted component, then please let me know

D

DanMadsen

Author

1-Visitor

Yup, I've made an ultra light version of a component by:

1) Making a simple worksheet and save

2) Inserting a component into a blank worksheet, choosen scriptable object (VBscript) and just chose my previous worksheet (no format selected)

3) Defined an output in the VBscript

Edit:

I've tried to run it again and now suddenly I get the bad region error. It even started happening in the worksheet which was working flawlessly (opened at least 30 times without any signs of trouble).

The original worksheet was created on M15 M005.

1_Mat(hcad)ryoshka_doll-xmcd.zip