Skip to main content
A
AK_1094868511-Garnet
11-Garnet
September 10, 2025
Solved

Excel data in mathcad

  • September 10, 2025
  • 1 reply
  • 919 views

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.

Best answer by StuartBruff

2025 09 10 A.png

 

Mathcad Prime 11 worksheet attached.

 

Stuart

1 reply

S
StuartBruff23-Emerald VAnswer
23-Emerald V
September 10, 2025

2025 09 10 A.png

 

Mathcad Prime 11 worksheet attached.

 

Stuart

A
AK_1094868511-GarnetAuthor
11-Garnet
September 10, 2025

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.

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
September 10, 2025

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

    Terms & ConditionsCookie settingsAccessibility statement