Inserting Section Tables Into Mathcad Prime

[Aiden Wilkins]

Hi all,

I have been looking into this all morning but just cannot figure it out. I am looking for the best way to input steel section tables (sizes and data - I, E, Z etc.) into Mathcad so that I do not have to manually type in every single property for each calc.

I have tried a few things using READEXCEL and copy/pasting excel tables (I have the data in excel already) but nothing is yet to work. I do not have use of the "Excel Component" function.

Any help would be much appreciated. Excel file attached for use/reference.

Aiden.

 

[structSU10]

make sure the path for the excel file is correct and you use the right syntax.

I have my excel file located in the same folder as the mathcad, so my function reads like this READEXCEL(".\aisc-shapes-database-v15.0xlsx","Database v15!A1:CC2092")

if the excel does not live in the same folder you need to define the file path correctly.

After that you have a table - I built a function to query the table for a defined beam size as follows:

I just match the index of my new BEAM table with the property I want to extract and define it.