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

S

StuartBruff

23-Emerald V

This is another long-standing feature request from back when Euler were a lad ... in fact, so far back that the original (Mathsoft Collaboratory) requests are no longer available.

I have a vague recollection of one of the more detailed requests mentioning in it the context of 'rectangular' Areas (rather than the current document wide Areas - see http://communities.ptc.com/message/183988#183988 for a more recent mention of the idea and a demo worksheet). I think one of the proposals took it up as part of a suggestion for an Object Oriented form of Mathcad, whereby a plot or Area, say, could be named and parameters got/set.

Stuart

PS. I did manage to create a Mathcad Component in M15 and to get a variable value from it (using ScriptObj.Worksheet.GetValue(varname)) but attempts to load the worksheet resulted in bad region errors.