calculate material usage

K

kydco

Knowing the distance from the edges and the distance between parts for a
sheet metal blank, I want to enter the size of the piece and the
quantity needed and have the spreadsheet tell me how many blanks I
need.

Thanks!
 
A

AlfD

Hi!

Can you expand a bit ?

I have a mental picture of a (rectangular? fixed size?) sheet of metal.
I think I see (regular? irregular?) shapes (all alike?) cut out of the
sheet allowing a border of some (minimum?) width and a space between
blanks

But this could be completely wrong...

Alf
 
K

kydco

You have the correct theory. I have a 48 x 48 sheet of material and
know I need 1" from the edges and .75" between each piece for an
scenario. I then figure the length and width of each piece I need t
punch and plug those 2 dimensions into the spreadsheet then the numbe
of sheets that I need displays in another cell.

Thanks for the follow-up.

kydc
 
A

AlfD

Hi!

I wrote you a long note explaining how I got the "solution". My IS
dumped me and the message.

So here goes again, but very briefly. Post back if you want to kno
why.

This formula assumes you will cut your blanks in a rectangular grid (n
material-saving attempts).

If A2 holds the number of blanks you want;
...B2 holds the width of a blank (no borders)
...C2 holds the height of a blank (no borders)

then put this in D2 to get the number of sheets required:

=ROUNDUP(A2/(INT(47.5/(0.75+B2))*INT(47.5/(0.75+C2))),0)

Al
 
Top