Partial quantity for a part

[darnell]

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

 

[drawoh]

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

 

[Standing]

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


Bradley

 

[darnell]

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