Skip to main content
F
fward10-Marble
10-Marble
May 29, 2015
Question

Referenced Mathcad 15 sheet won't 'import' array

  • May 29, 2015
  • 1 reply
  • 1473 views

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?

1 reply

S
StuartBruff23-Emerald V
23-Emerald V
May 29, 2015

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

F
fward10-MarbleAuthor
10-Marble
May 29, 2015

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

F
fward10-MarbleAuthor
10-Marble
May 29, 2015

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

Terms & ConditionsCookie settingsAccessibility statement