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

Richard Jackson wrote:
This is another long-standing feature request from back when Euler were a lad
That late? Are you sure?

Well, I was a bit of a late-comer to the Collaboratory, but I have heard rumours that Apollonius made a similar request when he was beta-testing Mαθκαδ α ... and I'm pretty sure he wanted built-in geometric drawing tools as well.

Hamilton is a bit miffed that he still hasn't got direct quaternion support and I think Ricci is getting tensor every time he thinks about his feature request.

Did you know that Mathcad is the only major mathematical application whose name begins with "M" that doesn't properly support multi-dimensional arrays (MDAs)? Mathematica, Maple and Matlab (including the MuPad symbolic processor) all support MDAs. Do you think anybody's requested MDAs might be a useful feature for Mathcad? (even extended indexing for use with nested arrays and an empty array would be a decent starting point)

Stuart