If you read the OP's request, he does not need complex shapes, only rectangles
from one format.
If it does the work, great,its free, if not "Delete".nothing gain, nothing lost.
Regards
John
"Archimedes' Lever" wrote in message
...
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.