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.

I'm not sure this answers your question, but give it a try

Look he

http://www.solver.com/solutions/procutstock.htm

and then go to the home page of solver for more details

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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.

Hi Richy
Just for testing, try this, you can change the cell reference in the formula
Type your 1110 dimension in C2 and place
this formula D2 =IF(AND(C2555,C3405),1,INT(1110/C2)),
your 810 dimension in C3 and place this formula in D3
=IF(AND(C2555,C3405),1,INT(810/C3)), multiply the 2 to get number of sheets
"Cuts"
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.

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.

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.

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.