BOM-steel shapes

[dpiengineering]

Is there a way to get a total quantity of stock for something like a steel beam. (This is based on the "New user-How should I handle standard steel shapes question). For example, if i have 3 beams that are 24in and 2 beams that are 36in, is there a way in which to pace the total lenght of beam I would need for the entire assembly in the BOM? I have created a custom property with "length" for each beam, now can I add a formula to the BOM to multiply the quantity by the lenght?
Thanks

[Anonymous]

Hi

I've just placed an example (part+assembly+drawing)
using VBA to accomplice this task in the customer files group (same subject at
this)

The code is a quick modification on my Total Mass
in part list macro.

The way it works is after placing the parts list
you must save the drawing or run the macro updating QTYxLenght in the Total
Length column. One new drawback is that R6 changes the colour of the parts list
icon to red (normally after changes made to a part etc.) after running the
macro.

The VBA code is in the Drawing and it is executed
automatically every time the drawing is saved.

The code can easily be copied to your
template.

Take a look at it.

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"dpiengineering" <
href="mailto:dpi@sbcglobal.net">dpi@sbcglobal.net> wrote in message
href="news:f127bb0.-1@WebX.maYIadrTaRb">news:f127bb0.-1@WebX.maYIadrTaRb...

Is
there a way to get a total quantity of stock for something like a steel beam.
(This is based on the "New user-How should I handle standard steel shapes
question). For example, if i have 3 beams that are 24in and 2 beams that are
36in, is there a way in which to pace the total lenght of beam I would need
for the entire assembly in the BOM? I have created a custom property with
"length" for each beam, now can I add a formula to the BOM to multiply the
quantity by the lenght?
Thanks