hI-OOPS-CAPS Posted October 16, 2012 Report Share Posted October 16, 2012 I am allocating hoses. For example we have 10 orders of the same hose but at different lengths, common lengths are 18.15m, 19.50m, 22.50m and 24.15m. If I add all these lengths up the total is, for example, 190m We buy the hose in lengths of 61.0m. So If I divide 190 by 61 we get 3.1. Ideally thats how much I would use but but there's scrap hose which needs to be kept to a minimum. I want to know if there is a formula I can use on Excel (or anywhere for that matter) to allocate the hose in the most efficient way. Thanks Quote Link to comment Share on other sites More sharing options...
Tony Harrison Posted October 16, 2012 Report Share Posted October 16, 2012 I'm not sure you'll find a formula to do it, but a macro could be written using VBA (Visual Basic for Applications). The algorithm wouldn't need to be too complicated - you could have a list of orders on one tab and a list of hose stock on the other, and the macro would fit them in the best it could. I'd do it for you but I don't have MS Office anymore, plus it'll probably take a few hours. But it is possible using Excel... Quote Link to comment Share on other sites More sharing options...
anzo Posted October 16, 2012 Report Share Posted October 16, 2012 Might take a look later if I'm bored/not busy Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.