Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

[MathCAD 15] Importing AISC Shapes Table and Pulling Properties

[MathCAD 15] Importing AISC Shapes Table and Pulling Properties

[MathCAD 15] Importing AISC Shapes Table and Pulling Properties

Hi all, I'm a total newbie to MathCAD 15 but I am wondering if anyone could provide some guidance on how to insert an Excel file into MathCAD that would then allow me to define a certain cell in that file and have MathCAD return values from other cells. Basically what I am trying to do is link an excel file that I have that lists tons of different steel shapes and their properties. I want to be able to define a member (like W44X335) and have MathCAD return the properties of that member (such as A, d, or Sx). I have tried to import it as a component but honestly I do not understand the input/output parts, which is probably why I cannot get it to work. I have tried to do more research so as to better understand the input/output functions but none of it seems to be dumbed down enough for me lol. I have attached the Excel file that I am trying to link. Thanks for your assistance.

RE: [MathCAD 15] Importing AISC Shapes Table and Pulling Properties

Here is what I did for the AISC steel properties.

RE: [MathCAD 15] Importing AISC Shapes Table and Pulling Properties

Thanks so much for your help. I was able to replicate your reply in my own file. Do you know if there is a way to automate the properties part tho? So that it would give me the properties immediately after defining a member rather than having to repeat each vlookup command?

RE: [MathCAD 15] Importing AISC Shapes Table and Pulling Properties

You can always hide the vlookup part if you do not want to see it. I am not sure what you mean by automate... you could copy out whole row for the member you are interested in from the "beam table" but you still need a command to define the variables like "Hcol" if you are using them in a calculation. Unless you call out the value using the row and column from the "beam table" but the aesthetics of that would be messy.

RE: [MathCAD 15] Importing AISC Shapes Table and Pulling Properties

RE: [MathCAD 15] Importing AISC Shapes Table and Pulling Properties

Thanks again. I have one last question. All my values for the properties get returned with parenthesis around them. Is there a way to get rid of this? I notice that it does not happen with yours.

RE: [MathCAD 15] Importing AISC Shapes Table and Pulling Properties

I dont think I have seen that but MathCAD has a lot of quirks in it. Can you post a snip and I can try to replicate it on my end? It might be some setting on how the value is being classified. Does it cause any issue if you use the value in a calculation?

RE: [MathCAD 15] Importing AISC Shapes Table and Pulling Properties

It adds parenthesis around any calculation done using those values. IRstuff was correct about the matrix and I found that I could get rid of the parenthesis just by adding [0 to my vlookup formulas. When I first recreated your formulas I left out the subscript 1 (or [1 ) that you had because I couldn't figure out how to place it there and didn't think it mattered, obviously it did matter.
Thanks to both of you for all the assistance!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close