Get Help

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community
- :
- PTC Mathcad
- :
- PTC Mathcad
- :
- Re: How do you put the calculations at the back in...

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

04-30-2018
09:52 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
09:52 AM

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

04-30-2018
11:12 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
11:12 AM

Hmmmm! Everybody stumped??

04-30-2018
11:45 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
11:45 AM

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

04-30-2018
11:50 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
11:50 AM

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

04-30-2018
12:00 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
12:00 PM

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.

04-30-2018
12:26 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
12:26 PM

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

04-30-2018
12:27 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
12:27 PM

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

Luc

04-30-2018
12:31 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
12:31 PM

zip your file, attach the zip.

04-30-2018
12:38 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
12:38 PM

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

04-30-2018
01:10 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
01:12 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
01:12 PM

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

04-30-2018
01:25 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
01:25 PM

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

04-30-2018
01:27 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

05-02-2018
05:33 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

05-02-2018
05:33 AM

@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...

PS The globalization is still hung up

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

04-30-2018
01:31 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
01:31 PM

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 😉

04-30-2018
01:37 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
01:37 PM

EXPRESSO!!

😉

04-30-2018
01:59 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
01:59 PM

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

04-30-2018
03:14 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
03:14 PM

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

04-30-2018
03:53 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
03:53 PM

no f9 does not work

04-30-2018
03:56 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
03:56 PM

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.

04-30-2018
05:56 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
05:56 PM

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

04-30-2018
02:01 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
02:01 PM

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

04-30-2018
12:27 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
12:27 PM

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

04-30-2018
12:37 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
08:44 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

04-30-2018
08:44 PM

PITA is Pain in the ARS*