bootlegend
Structural
- Mar 1, 2005
- 289
Is there an easier way to access a large table of values compiled in Excel and use it in Mathcad Prime. For example, I would like to be able to input the name of a wide flange steel shape and then have the different values (section properties) pulled into Mathcad so that I can write calculations in them. The examples I've found use fairly small tables for the Excel Component and Read Excel functions, but to pull in all of the WF shapes you need a very large table or Excel component and it becomes cumbersome. As of now I have a sheet that I manually overwrite the input from the AISC tables. For example if I want to check a W10x45 column I have to manually look up the section properties and enter them in Mathcad. In Excel I've used the VLOOKUP function to do what I'm trying to do now in Mathcad Prime.