The bad: the total Solver solution will be sub optimized i.e. The good: this is an easy model to work with as you don't need to set up a table with all the different combinations of list lengths. This macro is build using Excel 2010 so I would recommend you to use it in an Excel 2013 environment (can be modefied to Excel 2007) You specify up to 8 different cut length at the moment, more is possible but then the macro has to be rewritten a bit. The cut length can be changed by changing the values in range C2:J2. The master rod length can be changed by changing F12 value. In range C4 to J4 you specify the number of cut list you wish to make. So select "Developers" tab, click "Visual Basic" icon, click "Tools", then "References" and tick box marked Solver. This requiresĢ) A reference to Solver must be set in "Visual Basic". I've added another file where Solver is run in a loop using a macro. If Solver not found in "Data" tab install Solver. If so you clear range K6:K22, then click Solver -> Solve -> OK Solver is not installed by default when you install Excel so you need to check under the "Data" tab if Solver is installed. repeat the above 5 steps until list is finished" get the next length needed from the cut-list if a length of stock is used then up the tally of lengths required cut the piece of scrap if you find one, else cut a piece of stock look in the scrap bin for the shortest piece that'll do the job The hands on approach I think is perfect (but how to translate to Excel is the question now!): Anyway i will continue with my research until i find something good. I found these steps while searching other pages but it is not the best approach for least waste but still a good solution, if somebody can come up with something else it will help me a lot. There are add in for excel that can do this like '1DCutX' but i just wanted to understand the mathematics behind it so that i can do a custom made workbook. Wow., i thought there was a more simple approach to this but thanks anyway MrShorty.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |