simple worksheet question

[Doug Brown]

trying to get a worksheet to add up the total length of all the polys in my drawing - =length(t=poly) does not work - is length only lines and walls ?

thanks

[michaelk]

Try =PERIM((T=POLY))

hth

mk

[Doug Brown]

michaelk

thanks that works - makes a bit more math since trying to find the total length of 1by3's in my frames - but better then adding lines to everything

thanks

doug

[michaelk]

Doug

Here's a 2D version of the method I find useful. See attached.

Find the area of the the poly and divide by the width of the 1x3.

(I like to do this in 3D: find the volume and divide by the area of the cross section. If you use a class for each kind of stock, you can just drop your set piece into your "cut list generator" an it will spit out a cut list for each kind of lumber, steel, and sheet good.)

But your idea of finding the perimeter, subtracting the length of the ends and dividing by 2 also works.

Both methods fail when the stock has a mitered cut in the end. Or a notch (ie. for a half-lap joint). I've never been able to come up with a good method for generating a cut list that takes miters into account.

hth

mk