Well, i'm not really shure ....

but what about the formular:
int(quantity * length / 6,5) + 1 = count of 6,5 pieces.

Implement this formular in your spreadsheet.
Does it meet your ideas ?

Manfred


-----Original Message-----
Hello, from maths pygmy.

I can describe this problem in words, but not put it into
any mathematical
form. Can someone help by suggesting a method for solving
it with xl
spreadsheet?

A client of mine sells lengths of aluminium window parts
at 6.5 m length.
He has customers who want to buy it at various lengths,
in various
quantities, and want to reduce the amount of wastage.
E.g.:
30 lengths at 1 m, 25 at 1.5, 25 at 2. How can you work
out the smallest
amount of 6.5 m lengths to buy to achieve this? (i.e. the
least amount of
wastage)


Sorry for the lameness of the question, but he's a good
client and thinks
I'm a whizz with computers just because I design his web-
site. I hate to
disappoint.

--
Ben
(check my email address before sending)
.