Need help for Optimization technique

[develaavi]

Hello all,
I have a set of values which depict the length of steel rods. But manufacturer has default values of 40feet, 50feet and 60feet. I need to find how many 40', 50', 60' units shall come. The wastage should be minimum.
I have done it manually, but have lot of data.
wastage is about 6.9 feet when done manually. The groups were (14.8,25.3); (15.2,174.7); (17.7,57.8); (91.6,389.8); (104.4,16.4)
[TABLE="width: 145"]
<colgroup><col></colgroup><tbody>[TR]
[TD]
[TABLE="width: 500"]
<tbody>[TR]
[TD]14.8[/TD]
[/TR]
[TR]
[TD]15.2[/TD]
[/TR]
[TR]
[TD]17.7[/TD]
[/TR]
[TR]
[TD]174.7[/TD]
[/TR]
[TR]
[TD]57.8[/TD]
[/TR]
[TR]
[TD]25.3[/TD]
[/TR]
[TR]
[TD]91.6[/TD]
[/TR]
[TR]
[TD]104.4[/TD]
[/TR]
[TR]
[TD]16.4[/TD]
[/TR]
[TR]
[TD]389.8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Could anyone help me how to move ahead with this in vba?

 

[develaavi]

Ozgrid - http://www.ozgrid.com/forum/showthread.php?t=188669&p=714808#post714808