×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

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!
  • Students Click Here

*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

Jobs

Advanced Linking and Math

Advanced Linking and Math

Advanced Linking and Math

(OP)
Picture a cube with rectangle flanges on top and bottom.  I have drawn this cube and the insulation that covers it.  I have 4 differnt sizes of insualtion (drawn as spearate parts) and two of each of them to cover this cube for a total of 8 peices of insualtion.  The Length and width of each piece are linked dimensions. I need to have a single line in the BOM whos description reads "Insulation, 3" thk, xxSq Ft".  I can take care of the single line, but how do I link the area of all 4 peices of insulation then multiply by 2 and divide by 144 (to get Sq ft) and put that end value into the description of the BOM?  This value needs to be rounded up to the nearest ft.

For instance, lets say I need this value for two peices.
Peice 1 is 12x24
Peice 2 is 14x18
That's 540 in^2 or 3.75ft^2  I need the 3.75sq ft to appear in the description, but maybe round it up to 4.

Thanks!

J.D.

RE: Advanced Linking and Math

I don't have time right now to test, but i think you can do this with a design table & custom properties.

Have Excel calculate the area - name that a custom property.

In your BOM, have a column that lists square feet - link to that custom property.

The help menu explains more about the custom properties & linking them to a design table.

-ejc

RE: Advanced Linking and Math

(OP)
I'll do some research, thanks!

J.D.

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!


Resources