complicated excel template

  • Thread starter Thread starter joshdoc
  • Start date Start date
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheet metal estimating problem 3
Insert row(s) with vba 3
Calculate quantity of shapes inside another shape 8
Importing data from Excel worksheet into Excel template 2
automating use of complicated formula 4
Sumproduct with multiple criteria 8
What formula do I use for this? 1
Complicated Point Plotting 1

Back
Top