complicated excel template

J

joshdoc

I am on the beginning phases of a manufacturing template. Hopefully som
of you can help me out. I need to determine how many parts of a certai
item I can obtain from a determined square foot of material. Fo
example: how many parts of 1" x 1.5" widgets can I get from a 48" x 96
sheet
 
J

Jason Morin

You could use something simple like:

=INT(C1/A1)*INT(D1/B1)

where A1 = part width, B1 = part length, C1 = sheet width,
D1 = sheet length. Of course this does not take into
account any unique cutting patterns that minimize scrap.
It's assumes simple grid pattern cutting.

HTH
Jason
Atlanta, GA
 
J

joshdoc

Yeah,
That is how far I got. The issue with the scrap. I figure the way to g
is subtract the area used by the parts by the area of the sheet. The
take the difference and calculate the yield again. However, puttin
that all down in a formula is confusing. Little help
 
Top