Skip to main content
S
SFares14-Alexandrite
14-Alexandrite
June 5, 2014
Solved

Linking mathcad sheets

  • June 5, 2014
  • 2 replies
  • 3140 views

Hello,

Is it possible to link two mathcad sheets where one will be opened and the other is closed. The opened one will be set to a certain variable ( allowable stress design), and the closed one is set to a different variable( Strength Design). i need to import certain values from one sheet to another. the reason why i dont want to have one open becuase each sheet is about 25MB and if i have both opened along with other softwares, mathcad 15 will become extremly slow?

Thanks!

Best answer by Fred_Kohlhepp

If you "insert/reference" of one sheet in another, Mathcad will react as if the entire referenced sheet has been inserted at the point of the reference. All variable definitions, all functions in the referenced sheet become available and defined as they were in that sheet. (You will reassign a variable value if you have the same name in you open sheet.)

2 replies

F
Fred_Kohlhepp23-Emerald IAnswer
23-Emerald I
June 5, 2014

If you "insert/reference" of one sheet in another, Mathcad will react as if the entire referenced sheet has been inserted at the point of the reference. All variable definitions, all functions in the referenced sheet become available and defined as they were in that sheet. (You will reassign a variable value if you have the same name in you open sheet.)

R
RichardJ19-Tanzanite
19-Tanzanite
June 5, 2014

What you want may be possible using a scripted button, but I'm not sure what you mean by "The opened one will be set to a certain variable (allowable stress design), and the closed one is set to a different variable (Strength Design)".

How can they be 25Mb in size? Do you have bitmap images in them?

S
SFares14-AlexandriteAuthor
14-Alexandrite
June 5, 2014

Thank you!

we have two design procedures, one is called Allowable stress design (ASD) and the other is Strength design(SD). each procedure yields different results. i will set one sheet to (ASD) and the other to (SD). So i needed to get certain values from the sheet that is based on ASD and import them to the SD sheet.

the sheet is 25Mb because it has massive number of caclautions. some equations are 8 pages wide.

Thanks agin!

R
RichardJ19-Tanzanite
19-Tanzanite
June 5, 2014

OK. If you use insert reference, then the referenced sheet is effectively embedded in the referencing sheet, so I would expect the memory requirement will be almost identical to having both sheets open.

It sounds like the easiest solution that cuts the memory requirement would be to just write the required values from the ASD sheet to a file, and then the SD sheet reads that file.

Terms & ConditionsAccessibility statement