Fitting lengths into a longer length

  • Thread starter Thread starter Chisel
  • Start date Start date
C

Chisel

I have a number measurments that I need to get put in the most efficien
order to use the least amount of wood.

The wood can come in increments of 30cm such as 30cm, 60cm
90cm.....2.1m, 2.4m and so on. I need lots of little lengths (and som
longer) which on their own do not fit exactly with the 30cm increments.
I need to find the best fit within the lengths available to me.

Is anyone aware of anything I can do in Excel to put the small length
in the best order to fit within parameters given above?

This may seem complicated, due to my poor explaination
 
Chisel,

Send me an email, and I will send you a workbook that should help you. It
will work on a piece-by-piece basis, not on a multi-piece basis, but it
should help point you in the right direction.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max Length in a row 1
Excel Find length of side of triangle in Excel 12
How to fit each cell into a perfect square? 3
Would an 8800 fit? 42
Page length 8
Limiting text length 4
Defining a variable length area for output. 2
Fixed length string of text 7

Back
Top