Help on how to create material usage.

[warlock666999]

I have a cutlist that consist of pine. Length varies in size. I want to know how much meterial is needed per cutlist. The pine comes in 96 inches length. And I have different sizes I use like 23 1/4,, 78 7/8,, 23 1/16,, etc.
So I want to know how many 96 inch pines it takes per list.
Thanks for the help.

 

[HalfAce]

Hello warlock666999, welcome to the board.
Here's a way you could do that.
Say your list of lengths were in column A (your example: A1:A3)
Format that range as Fractions > as sixteenths.

For the total board length - in inches - (say in cell A5):
=SUM(A1:A3) (formatted as you like.)

For how many (96") boards it'll take:
=A5/96 (formatted as Number > 2 decimal places.)

- Or you can just go straight to how many boards (ignoring the total length) by using:
=SUM(A1:A3)/96 (formatted as Number > 2 decimal places.)

 

[warlock666999]

THANKS ALLOT, THIS REALLY HELPED ME.

 

[HalfAce]

Most welcome. Glad it helped.