MathCad Prime: Select data from different tables in different sheets

Forum|Forum|5 years ago
April 13, 2021
1 reply
3445 views

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

Mathcad Usage

Best answer by MSheykman

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.

W

Werner_E

25-Diamond I

There is no screenshot visible in your posting.

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

J

JG_9899277

Author

1-Visitor

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.

1_HEA.zip

3_HEB.zip

2_Selection-of-section-data.zip