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

MathCad Prime: Select data from different tables in different sheets

SOLVED
JG_9899277
Regular Member

MathCad Prime: Select data from different tables in different sheets

Hello all,

 

I am planning on making my Mathcad sheets more efficient and wanted the sheets to select by themselves from tables the properties of steel sections as shown in my screenshot. And recieve an output in my calculation sheet.

 

Unfortunately I have not come to a good solution. I managed to reference for example three different sheets with for 3 section types (each sheet has one table with all the section properties), but once Mathcad discovers the desired section in a row ( lets say row "x") it also goes into the following referenced sheets and reads the line x in all tables and gives me the output from the last sheet I referenced.

How can I make Mathcad stop reading tables once it found the right table? Or do I have a completely wrong approach to it?

Thank you very much already for your help,

Joe

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: MathCad Prime: Select data from different tables in different sheets

I think you have a wrong concept in mind about how it works.

When you include a region it is nearly equivalent to placing all calculatable regions in the main document in same order.

You are supposed to have a "main" document with included region and an included document.

If you want to pass something from main to the included - you should define it in main above the include region.

If you want to get something from the included region - just use variable that is defined in the included worksheet.

View solution in original post

8 REPLIES 8

Re: MathCad Prime: Select data from different tables in different sheets

There is no screenshot visible in your posting.

Furthermore its always better to post the worksheet and not just a pic.

Re: MathCad Prime: Select data from different tables in different sheets

Good afternoon,

 

sorry I attached the worksheets now. As additional explanation: I want to make the " selection of section data" sheet go into the HEA and HEB sheet and give me the right dimensions.

 

Hope this is some help.

Re: MathCad Prime: Select data from different tables in different sheets

You have circular references between these worksheets:

HEA and HEB include "Selection of Section Data" and "Selection of Section Data" includes HEA and HEB.

Re: MathCad Prime: Select data from different tables in different sheets

I realised this, but if I remove the reference "Selection of Section Data" in the HEA and HEB sheets, I don't receive the output in the "Selection of Section data" sheet.

Re: MathCad Prime: Select data from different tables in different sheets

I think you have a wrong concept in mind about how it works.

When you include a region it is nearly equivalent to placing all calculatable regions in the main document in same order.

You are supposed to have a "main" document with included region and an included document.

If you want to pass something from main to the included - you should define it in main above the include region.

If you want to get something from the included region - just use variable that is defined in the included worksheet.

View solution in original post

Re: MathCad Prime: Select data from different tables in different sheets

Ogh, okay, thank you very much. Will try 🙂 Yes, I am pretty new to Mathcad and I am not doing to well with such things. Thank you a lot for your help.

Re: MathCad Prime: Select data from different tables in different sheets

OKay so i tried making it as easy as possible now, just to get the sheets working. My problem is now, that once i reference both HEA and HEB sheets, it crashes.

 

I feel like I need sth in between, which controls that MathCad is just trying to read one sheet and not trying to access both.

Re: MathCad Prime: Select data from different tables in different sheets

Does not crash for me.

But returns the following error message on one of the regions:

MSheykman_0-1618387832511.png

Which is correct. You do not have return values for this input in your program:

MSheykman_1-1618387903343.png

And the argument that you pass in is

MSheykman_2-1618387927238.png

Regarding the crash please turn to out tech support and provide the details about what you do and what you observe.

 

 

Announcements
Check out the latest
Mathcad Tip
"PTC Mathcad 15 / Prime 1-6 Update."