Excel data in mathcad

[AK_10948685]

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.

[StuartBruff · Accepted solution]

Mathcad Prime 11 worksheet attached.

Stuart

[AK_10948685]

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.

[terryhendicott]

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.

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

Alternately a poster to the community did this.

see AISC v16 sheet and excel for above

Cheers

Terry

[StuartBruff]

Sorry.  I thought I had attached the worksheet.  As I said, it's Mathcad Prime 11.

Stuart

[Catalina]

Hi @AK_10948685,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution or please feel free to detail in a reply what has helped you and mark it as the Accepted Solution. It will help other members who may have the same question.

Of course, if you have more to share on your issue, please pursue the conversation.

Thanks,