Skip to main content
11-Garnet
Sep 10, 2025 8:28 AM UTC
Solved

Excel data in mathcad

I have the excel in that some type are there for e.g. frame size and its W,A etc. is there, I am trying to create this in Mathcad when I type the frame name it will automatically shows the all parameters related to that how this is possible in Mathcad for this I am using lookup function if anyone done this in past or have any suggestion how to achieve this pls comment on this I also attached the sheet and excel file.

23-Emerald V
Sep 10, 2025 9:56 AM UTC

2025 09 10 A.png

 

Mathcad Prime 11 worksheet attached.

 

Stuart

5 replies

23-Emerald V
Sep 10, 2025 9:56 AM UTC

2025 09 10 A.png

 

Mathcad Prime 11 worksheet attached.

 

Stuart

Translate
11-Garnet
Sep 10, 2025 10:01 AM UTC

Hi Stuartbruff,

Thanks a lot for sharing this solution. Could you please share the Mathcad sheet as well? It would really help me to see and understand the approach more clearly.

Translate
terryhendicott
21-Topaz II
Sep 10, 2025 10:27 AM UTC

For the entire AISC database both imperial and metric I use the following:

Select the section and the column of a variable then assign it below for use in calculations.

You can check the assigned value against the row and column value each time.

Capture.JPG

See files 220618-Sections Option 3 and database version 15. for above.

Alternately a poster to the community did this.

Capture2.JPG

see AISC v16 sheet and excel for above

Cheers

Terry

Translate