On Mon, 19 Oct 2009 11:15:08 -0400, "John" wrote:

Hi Richy
I may have a template for you if you're still interested.
The formula I gave you is incomplete. Post back if you're interested.
HTH
John
"RichyDeeInUK" wrote in message
...
Can Excel accurately calculate the maximum quantity of cut outs from a single
piece of card or metal? This is typically an element of CAD/CAM software.

I don't want or need a CAD/CAM system, I do need to prevent wastage and
limit offcuts.

I know the non-variable - the size of the card to be cut up. 1110 by 810 mm.

I know the variables - the size of the rectangles to be produced. These
sizes are client driven. But exactly how many rectangles can I extract from
one card.

I only require rectangle shapes.

If my variables are, for example, 320 x 320 then the number of rectangles I
can produce is 6.

But what is the ideal formula to calcuate any rectangle shape sized up to
555 x 405? Any size greater than this requires 1 x card per rectangle.

I am not able to mix different sizes of rectables on one card.

Appreciate any help on this conundrum.




This is a reiterative nesting application, and it is likely a bit too
complicated for a simple spreadsheet.

The nesting app on our plasma cutters was on a VAX VMS computer and did
complex shapes.