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

MathCad Prime: Select data from different tables in different sheets

JG_9899277
5-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

ACCEPTED SOLUTION

Accepted Solutions

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
Werner_E
25-Diamond I
(To:JG_9899277)

There is no screenshot visible in your posting.

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

JG_9899277
5-Regular Member
(To:Werner_E)

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.

You have circular references between these worksheets:

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

JG_9899277
5-Regular Member
(To:MSheykman)

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.

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.

JG_9899277
5-Regular Member
(To:MSheykman)

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.

JG_9899277
5-Regular Member
(To:MSheykman)

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.

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

Top Tags