×
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

Partial Quantity in an assembly

Partial Quantity in an assembly

Partial Quantity in an assembly

(OP)
I have a problem with showing partial quantities in BOM and I have searched the forum and not found anything that answers my question.  

Here's the problem.  I have to show 9.5 feet of wire loom in an assembly.  Normally I would make a 1' section of loom and pattern it 9 times so that the quantity would show 9 but adding that extra half foot is ruining my day.  Anybody have experience with this?

RE: Partial Quantity in an assembly

Have you tried making it 1.05555'?
curious

Chris
Sr. Mechanical Designer, CAD
SolidWorks 05 SP3.1 / PDMWorks 05
ctopher's home site (updated 06-21-05)
FAQ559-1100
FAQ559-716

RE: Partial Quantity in an assembly

(OP)
That would make the actual length in the assembly work out, but the BOM would still list a quantity of 9.  In this case it's more important for the BOM to be right than the assembly.

RE: Partial Quantity in an assembly

It won't update automatically for you anymore, but you could just double click in the Cell in your BOM and manually type in the 9.5 value.

RE: Partial Quantity in an assembly

We do it by using the following formula in Excel.

=IF(H2="EA",B2,IF(H2="FT",TEXT(I2/12,".0 FT"),IF(H2="NA",TEXT(,"0"),IF(H2="QTY",TEXT(J2,"0"),IF(H2="%",TEXT(J2,".00"),B2)))))

In the model we create a configuration for each Length which is dimensioned in inches.
We have a property called UoM set to EA or FT.
Whenever we change something we have to double click on the BOM and click outside the BOM to get it to update. I am just waiting for the day SolidWorks improves their BOM.

Once it is set up it is easy for the drafter to set. But getting everything right was a lot of work in the beginning.

Bradley

RE: Partial Quantity in an assembly

See thread559-119580
It tells how to create an Excel BOM with an additional String column and then insert the correct length into your part properties. This eliminates the pattern part of your assembly.

RE: Partial Quantity in an assembly

Why not make it 9 1/2 feet, and link the length to a property?  On your property field, just double-click the length to add it, and it will update whenever you rebuild the part.

Flores

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