Werner Exinger wrote:
...
It sure would be nice if Mathcad could provide the ability to put together a couple of worksheets in a single file which could reference each other.
It would be nice if Mathcad could provide the ability to turn a whole sheet or part of it into a function.
It would be nice if .....
Werner
Alles in Träume, Werner 
?
VladimirN. wrote:
Werner Exinger wrote:
...
It sure would be nice if Mathcad could provide the ability to put together a couple of worksheets in a single file which could reference each other.
It would be nice if Mathcad could provide the ability to turn a whole sheet or part of it into a function.
It would be nice if .....
Werner
Alles in Träume, Werner ?
Hmm ....
и видеть сны?
Вот и ответ.
Какие сны в том смертном сне приснятся,
Когда покров земного чувства снят?
Вот в чем разгадка. Вот что удлиняет
Несчастьям нашим жизнь на столько лет.
But unlike Hamlet, it's because we know we return to the Earthly Veil of Mathcad's limitations. 
The veteran feature requesters amongst us may, however, join with Hamlet in wondering ...
Достойно ль
Смиряться под ударами судьбы,
Иль надо оказать сопротивленье
И в смертной схватке с целым морем бед
Покончить с ними?
I suppose a few of us still live in the hope that our battles against a whole P-T-Sea of troubles may one day do away with these restrictions. 
Stuart
Richard Jackson wrote:
I suppose a few of us still live in the hope that our battles against a whole P-T-Sea of troubles may one day do away with these restrictions.
Maybe. If P-T-Sea of troubles sells Mathcad to another company, that has a very different attitude and way of working.
Or puts in on GitHub and makes it open source...
Stuart
Oh, Werner. Ich würde lieber träumen in der Sächsischen Schweiz, gut zu sein als vor einem Computermonitor zu träumen .
Werner Exinger wrote:
... but you can display a result anywhere if you reference the appropriate cell.
Sure, but check the way that the reference is constructed in excel. For example, try to double click in the image, or change the format where the calculus is done.
Anyway, what about self-referencing. Seems to work:
Just be careful with recursive definitions and similar things.
Best regards.
Alvaro.
Werner Exinger wrote:
> Actually, what Joe ask can be done in Excel very easy,
Sure, because the concept of the two programs (fortunately) is quite different.
Mathcad is oriented towards normal reading style, that is top-> down, left->right. So its hard ans unnatural to display a result before its calculated. We can only do it the hard way by using global assignments (which often is not possible for a calculation sheet) or using scripted components in MC15. Or we can fake it using a collapsed region or a referenced second worksheet.
Excel is oriented towards a rigid and inflexible grid and its addresses. So calculation order is hard to follow but you can display a result anywhere if you reference the appropriate cell.
Two completely different approaches and I would not suggest using Excel for any serious technical calculation, though.
Having a summary at the top of a report is a need which often comes up here and so far no perfect solution could be provided. The collapsed region seems the most appropriate and natural approach for me. And for documentation its quite easy to print just the summary with the collapsed region in a pdf and then append the full sheet with expanded region. Of course you would achieve the same effect if you just print the last page with the summary first and then follow with the full sheet.
Page numbers will not be correct that way, though. As already said - no perfect solution in sight.
It sure would be nice if Mathcad could provide the ability to put together a couple of worksheets in a single file which could reference each other.
It would be nice if Mathcad could provide the ability to turn a whole sheet or part of it into a function.
It would be nice if .....
Another of my feature requests was to have the ability to specify the calculation order of regions to allow such forward referencing. What I had in mind was Mathcad building a "calculation sequence tree" using its normal left-right, top-bottom, but the allowing the user to change a "link" property that would override the default setting. This would allow to, say, you could do the calculations on Page 3, but evaluate the expression on Page 1 by creating a link to some appropriate region on Page 3. Changing a link would, by default, automatically "terminate" the "out of normal sequence" (and put a visual marker in to indicate this), unless the user then made a further link to another region. This would help mitigate any circularity risk, and shouldn't prove too onerous, as most of the time a worksheet should accord with normal order.
The potential for circularity might help with mutual recursion, though ... a feature I've wanted on several occasions. 
This feature was pretty much an obvious extension of my other suggestion for making each region an (accessible) object to allow programmatic control of its properties (eg, font for text regions, plot type and appearance for 3D plots).
Schlafen! Vielleicht auch träumen! Ja, da liegts:
Was in dem Schlaf für Träume von Mathcad kommen mögen,
Wenn wir die PTC Verstrickung lösten,
Das zwingt uns stillzustehn. Das ist die Rücksicht,
Die Elend läßt zu hohen Jahren kommen.
Stuart
Shakespeare already knew it!
Yeah, the wishlist with feature requests, changes in handling things, etc. concerning Mathcad is old and gets longer and longer over time. But nobody seems to care to tackle that list step by step. This was a problem with Mathsoft but seems to be a much bigger problem with PTC.
Werner
