×
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 for a part

Partial quantity for a part

Partial quantity for a part

(OP)
We have a system where a part number represents a part. I'll use a 10' bar stock for example. In our BOM in the AS400, we'll use .25 as a qty for that part number so we can get the length we need.

How can I (without configurations) get my SW BOM to match up with the partial quantities?

Thanks in advance

RE: Partial quantity for a part

darnell,

   I cannot solve your problem directly.

   I designed a welded steel tube space frame recently.  I tabulated my steel tube model by length, and I embedded the lengths into the part description.  This is straight forward Microsoft Excel abuse.

Cell A3:  =$D3&"LG"
Cell B3:  ="STEEL TUBE "&$D3&"SQ "&$E4&"THK" &$A3
Cell C3:  120
Cell D3:  1.5
Cell E3:  0.062

   In the above example, Column_B is your BOM description.  column_C is your length, column_D is your square dimension and column_E is your wall thickness.  You do not absolutely need to put the $ in front of the column specifiers, but your life will be less weird if you do.

   With this process, you may have more than one 10' piece of steel, but so what.  

   You can create sketches at the assembly level and do cut-extrudes to trim the ends.  This feature is more powerful than it appears to be.  You must play with it a little.  This allows you to make all your lengths slightly oversize, eliminating some unpleasant surprises.

                          JHG

RE: Partial quantity for a part

darnell,
   Are you totally against using MS Excel for the BOM?

Bradley

RE: Partial quantity for a part

(OP)
Bradley, no, we have been generating the BOM within the drawing. I would like to eventually take that back to Excel. I was trying to figure out how to work a model to show .25 in the quantity field. I have not looked at (and tried) what drawoh said, but that might work

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