Worksheet to display extruded length of objects and meterial

oliver.williams · August 25, 2023

Hello,

Im in VW 23 windows. I am creating a worksheet for a steel cutting list. I have a frame made out of many peices of steel box section. However I can't get the extruded length in one column to sort them by size. if i do depth, height, width, length i dont get the desired result as in the design layer, the mebers are in differeing orientations. Is there a way to diplay the maximum dimension or the true length of each of the steel sections?

Another question about this worksheet. I have applied a component material to all of these steel sections in the object info: shape window, ticket use material and selected steel. However here on the worksheet the material doesnt display. How do i get the worksheet to display the component material?

Many thanks,

Tom W. · August 25, 2023

32 minutes ago, oliver.williams said:

Im in VW 23 windows. I am creating a worksheet for a steel cutting list. I have a frame made out of many peices of steel box section. However I can't get the extruded length in one column to sort them by size. if i do depth, height, width, length i dont get the desired result as in the design layer, the mebers are in differeing orientations. Is there a way to diplay the maximum dimension or the true length of each of the steel sections?

Have a look at this + see if it helps:

Otherwise you could use Structural Members instead of Extrudes for the box section.

33 minutes ago, oliver.williams said:

Another question about this worksheet. I have applied a component material to all of these steel sections in the object info: shape window, ticket use material and selected steel. However here on the worksheet the material doesnt display. How do i get the worksheet to display the component material?

If you click on cell G2 what formula is displayed in the data bar? 'ComponentMaterial' relates to Materials assigned to Wall/Slab/Roof/etc components which isn't applicable in your case so you probably want to replace whatever the formula is with =MATERIALNAME.

michaelk · August 25, 2023

As you are finding out, the reported length, width, and height of extrudes depends on the orientation when the object was created.

But no matter what the orientation, the volume is constant! And for each piece of stock you know the cross section. So if you divide the volume by the known area of the cross section, you are left with he length.

I'll post an example that's in feet and inches, so there will be some unnecessary math to handle the feet to inches problem. Looks like you're working in a sensible system of measurement. Let me know if the Imperial math is getting in your way and I'll post an example in metric.

Should be pointed out that this all falls apart when one end of the extrude is mitered. 🙂

Cut List.vwx