cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

How do you put the calculations at the back in an Appendix, and still have MC function as usual.

jdesai-2
11-Garnet

How do you put the calculations at the back in an Appendix, and still have MC function as usual.

Hello,

I have some detailed 2 or 3 page calculations that yield a final stress number. I want to put these detailed calculations at the back of the .mcdx in an Appendix on page 5 or page 6. I would like to keep the end result i.e. the stress on page 1  sort of like this..

S=10ksi    (for details please refer to Appendix A on pages 6 thru 😎

 

I would like S=10ksi value to change if I change something in the Appendix on pages 6 thru 8. Sort of reverse of what happens in a regular .mcdx file where the calculations are before the final value.

 

Is this possible? Any ideas?

24 REPLIES 24

Hmmmm! Everybody stumped??

LucMeekes
23-Emerald III
(To:jdesai-2)

One option would be to make the variable S a global variable. But that is a PITA because it ripples down to all variables needed to calculate S: they must be global as well (Don't know if Prime supports globals at all.).

The other option is to put your appendix in a separate file, that you reference at the beginning of your (main) worksheet, or at least before you need to display S's value. In that way no globals are required.

 

Success!
Luc

Thanks Luc,

What is a PITA? Could you please give me a small example of a global variable.

 

I like the idea of a separate file, but how would I reference it? Another small example would be very helpful

A global variable (available as an operator in Prime) is a three-line equals sign.  When you define it, it becomes available for calculation anywhere in the sheet, no matter where on the sheet you define it.  I like Luc's other suggestion better.

Capture.PNG

How do I attach a small mcdx to this post? I want to show you what I got. The browse says file types don't match or something like that

LucMeekes
23-Emerald III
(To:jdesai-2)

Look at the anouncement text to the right of this column...

 

Luc

zip your file, attach the zip.

please take a look at the attached zipped mcdx. is the sigma (total) to be globalized?

Something like this?

You can also put your calculations in an area, then collapse the area, but your equations won't be visible with the area collapsed

The include command works fine. I do get an exclamation mark in front of it, and it says "Warning PTC MC is using the CWD settings from the other file"" whatever that means.  

 

How do you collapse an area?

 

PS The globalization is still hung up


@jdesai-2 wrote:

 

How do you collapse an area?


Read the help filers for areas. 

Werner_E
25-Diamond I
(To:jdesai-2)


 @jdesai-2 wrote:

How do you collapse an area?


See my example test3.zip here: https://community.ptc.com/t5/PTC-Mathcad-Questions/How-do-you-put-the-calculations-at-the-back-in-an-Appendix-and/m-p/547144/highlight/true#M179991

 


PS The globalization is still hung up

Again look at the same post I just referenced, this time test2.zip 😉

Werner_E
25-Diamond I
(To:jdesai-2)

Yes, its possible, see attachment test2

But you need a lot of global assignments and thats sure not the preferred method.

Apart from putting the calculation in a separate sheet which you reference you may also consider putting it in a collapsed region at the top of the page. See test3

 

EDIT: oops! Seems like this time it was me being too late and Fred was faster 😉

 

 

EXPRESSO!!

 

😉

Oh! Oh! the include just developed a hiccup. When I change the total stress in the Appendix.mcdx, it does not automatically change the final value (revise it) in the top level test.mcdx


 


 

LucMeekes
23-Emerald III
(To:jdesai-2)

You may have to force a recalculation of the entire top level worksheet to see the effect of such changes: press F9.

Hope that helps (I can't try it).

 

Success,

Luc

no f9 does not work

Werner_E
25-Diamond I
(To:jdesai-2)

If you have both worksheets open in the editor you may have to save the edited and referenced worksheet before you recalculate the top level sheet.

 

LucMeekes
23-Emerald III
(To:jdesai-2)

If you intend to frequently change the appendix data, resulting in a new S-value, then maybe a (collapsed) area is a better choice.

An area (leftmost item on the 'Document' tab of the ribbon) is a marked part of the sheet that you can collapse by clicking the - sign to the top-left of it (sort of in the margin of the sheet). Then it turns into a +. To open it click the +.

 

Success!
Luc

So this time its me who has to go for some espresso 😉

LucMeekes
23-Emerald III
(To:jdesai-2)

A PITA is a Pain In The Ass (hope this passes the test...   Ah, it does!).

 

I can't show you how to reference a file, I'm limited to Express. It's called 'Include Worksheet' in the 'PTC Mathcad Worksheets' section of the 'Input/Output' tab of the ribbon. What effectively happens is that the full contents of the included worksheet gets inserted at the inclusion point. So all definitions and calculations as described in that worksheet occur in the main/parent/including worksheet at that point. So any definitions described in the included worksheet are known past the inclusion point.

 

Success!

Luc

 

 

per Luc's direction,  unpack both files to the same folder.

ppal
17-Peridot
(To:jdesai-2)

PITA is Pain in the  ARS*

Announcements

Top Tags