View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RickB RickB is offline
external usenet poster
 
Posts: 5
Default How to Determine group of numbers best fit into 1 number

I am trying to determine the following:

I have 3 sizes of product I need to cut from different width sheets of
aluminum. (the lenght is all the same so length is not needed in formula).

Blank size width:

10 inches
15 inches
20 inches

Available aluminum Sheet widths:

36 inches
48 inches
60 inches

What I want to determine is when I put in width sizes the program would
automatically figure the quantity of the optimal size sheets to use in order
to cut down on waste since aluminum is expensive. The width size of the
blanks will vary from job to job. The available aluminum sheet widths are
always the sizes I have above.