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

Variables and data table

Variables and data table

Variables and data table

I want to start using Mathcad instead of Excel but I am having trouble figuring out how to do something in Mathcad.

Usually in Excel, I have several variables that have a lot of data associated with each one. For instance, I would create a table that looks like this in excel:

SHAPE:             Ag     rx      ry     rz
L3x3x3/16    1.090    0.933    0.933    0.596        
L3x3x1/4    1.440    0.926    0.926    0.592    
L4x4x1/4    1.930    1.250    1.250    0.795        
L4x4x5/16    2.400    1.240    1.240    0.791    

Then I would have a pulldown menu that contains the variables: L3x3x3/16  L3x3x1/4  L4x4x1/4  L4x4x5/16.

Then based on the variable I choose, all the other properties are automatically assigned somewhere in the spreadsheet(Ag, rx, ry, rz) from the "index" and "match" functions.

Is there something equivalent to this in Mathcad? I don't want to have to type in all the different properties each time for each variable.

RE: Variables and data table

Okay, I inserted my data as an "input table" which is being read from an outside text file. So I am just getting raw numbers which are in the form of an array which I am able to access each number indiviudally wherever I need to. So that is great.

But I need to assign units to each data value that I am getting from the array, and the units will vary (some numbers represent areas, others weights, etc.) Everytime I try to assign a unit value I get a new converted number that comes out unitless.

For example I am trying to place "in" (inches) in the placeholder behind the data number "3" that I am accessing from the array. I put "in" in the placeholder and the number turns into "36 in/ft".

RE: Variables and data table

If units don't convert correctly, it's most likely that you've redefined a built-in unit somewhere in your sheet that's honking up the unit conversion.


RE: Variables and data table

I think I figured out what to do. When I access a number from the array, I have to multiply the dimension out to the side.

For example, my data table is an array named "A". I am trying to access the number "5" from the array which is in position (1,1).

Then A(1,1)*IN^2=5IN^2  

I mulitiplied the expression A(1,1) by IN^2 to get 5IN^2.

RE: Variables and data table

Sounds right.


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