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)
<colgroup><col></colgroup><tbody>
</tbody>
Could anyone help me how to move ahead with this in vba?
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)
<tbody> </tbody> |
<colgroup><col></colgroup><tbody>
</tbody>
Could anyone help me how to move ahead with this in vba?