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.
Red Flag Submitted
Thank you for helping keep Eng-Tips Forums free from inappropriate posts. The Eng-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Eng-Tips forums is a member-only feature.