Skip to main content
MySchizoBuddy1-Visitor
1-Visitor
December 7, 2012
Question

How to manage large worksheets?

I have 3 sun position calculator and 5 solar radiation model all of them in one worksheet. More radiation model will be added later. It is already over 100 pages.

At one time I only use 1 position calculator with 1-2 radiation models. Right now I have them under collapsed regions so I hide the ones I'm not using. But because they are still in the worksheet they still get re-calculated. making it unnecessarily slow. not to mention variable name hell

Is there a better way to manage large worksheets. Like a workbook with multiple worksheets and then I can reference the worksheets I want to use. Similar to how programmers do it. They split their code in multiple files and then include them when and where they want them.

7 replies

ValeryOchkov24-Ruby IV
24-Ruby IV
December 7, 2012

Ziyad, Welcome to PlanetPTC.

1. Can you send us the sheet?

2. Did you use references for the solving this problem?

Translate
MySchizoBuddy1-VisitorAuthor
1-Visitor
December 7, 2012

cannot share the worksheet.

But what are references?

Translate
ValeryOchkov24-Ruby IV
24-Ruby IV
December 7, 2012

Ziyad Saeed wrote:

But what are references?

You can insert in your sheet a reference on other Mathcad-sheet in your computer, a local net or Internet.

Translate
Raiko17-Peridot
17-Peridot
December 7, 2012

Hello Ziyad,

I've got a similar problem. I do pressure vessel design on a regular basis (MC 15 on a WIN 7 machine). Apart from being quite confusing it sometimes appears to be too much of a burden for a single woprksheet. Hence I adopted two approaches:

  1. One chapter per worksheet. Export only the main results to an Excel file for reporting.
  2. One chapter per worksheet. In this all is packed into one function. I have a master sheet from which I call these functions (Reference) to collect them in the master sheet

Works fine for me

Raiko

Translate
ELSID1-Visitor
1-Visitor
December 7, 2012

As Raiko mentioned, use the reference feature and break out your calculation into smaller tasks. I'm in the process of doing this to better "convert" to Prime when it becomes more usable for my needs. I figure it would be faster (calculation wise), easier to trace, and make finding conversions easier (to find where it breaks).

Translate
MySchizoBuddy1-VisitorAuthor
1-Visitor
December 8, 2012

See my responce above

Translate
Terms & ConditionsAccessibility statement