Skip to main content
fward10-Marble
10-Marble
May 29, 2015 9:39 AM UTC
Question

Referenced Mathcad 15 sheet won't 'import' array

Hi, Can anyone out there help?  I have a fairly basic calculation sheet, in which I want to use results from another worksheet.  I have done the insert reference, saved, saved again, hit F9, hit it again, opened, closed, re-opened, re-closed etc, but simply cannot get the recipient worksheet to find the array results that are generated in the referenced sheet.  It will happily find 'simpler' results (single numbers, single column arrays), but will not find the larger 2 dimension arrays.  The arrays I admit are large, 130 x 500, but that is what we use expensive software for isn't it?

4 replies

StuartBruff23-Emerald V
23-Emerald V
May 29, 2015 10:29 AM UTC

Frank Ward wrote:

Hi, Can anyone out there help?  I have a fairly basic calculation sheet, in which I want to use results from another worksheet.  I have done the insert reference, saved, saved again, hit F9, hit it again, opened, closed, re-opened, re-closed etc, but simply cannot get the recipient worksheet to find the array results that are generated in the referenced sheet.  It will happily find 'simpler' results (single numbers, single column arrays), but will not find the larger 2 dimension arrays.

What results do you get? Or error messages, if any?

Any chance you could post the offending worksheets (or cut-down versions thereof)?  ....

The arrays I admit are large, 130 x 500, but that is what we use expensive software for isn't it?

A mere 65000 elements?  Molest Mathcad not with this mere pocket-calculator stuff.

The attached worksheets (A Referer / Reference pair) show that Mathcad 15 will pick up a reference to a 1 000 000 element array without problem.

Stuart

Translate
fward10-MarbleAuthor
10-Marble
May 29, 2015 10:47 AM UTC

Hi Stuart,

Thanks for replying.

The error is that the array (on of a few) in the referenced worksheet, when used in calculations in the referencing worksheet, reports as variable not defined.  Or, if I simply want to display it on screen, eg pvf_sl=, just goes to pvf_sl=:, ie tries to define the variable.

I have worked out that the problem is somehow with the referenced sheet, by creating a new, blank referencing sheet, inserting the reference and trying to access the arrays.  The same result occurs.

The offending sheet is attached.  Arrays I am interested in getting out are pvl_sl, pvf_sl, Pvf_sq etc

Regards

Frank

Translate
fward10-MarbleAuthor
10-Marble
May 29, 2015 11:07 AM UTC

I think I have found the problem.  Mathcad is vindicated,  I had missed adding the array subscript in some calculations at the top of the sheet.  Added those, and it seems to work

Translate
Terms & ConditionsAccessibility statement