Thought I'd start this one back up as I have an Excel related question.
Toggle Spoiler
I have a piece of plastic that is bought in lengths of 1000mm. I need to cut this plastic into the following lengths (in a variety of quantities).
232.5mm
346.5mm
179mm
533mm
91mm
410mm
851.5mm
335mm
723mm
I have a spread sheet where I've worked out various cutting lists ie.
Cutting List 1 = 232.5, 232.5, 232.5, 232.5mm (930)
Cutting List 2 = 851.5mm, 91mm (942.5)
etc. etc.
I have worked out these lists using predicted usage while trying to keep scrap to a minimum. I've got about 20 lists in total.
I now want to create a formula where I can enter values next to each of the cutting lists and it will tell me the totals of each piece I will get. So for example if I cut the following lists X amount of times
Cutting List 1 = 242 Runs
Cutting List 2 = 12 Runs
Cutting List 3 = 64 Runs
and so on....
When I enter the amount of runs I want it to tell me that I would get XXX amount of 232.5mm etc.
The lists will have cross overs. For example, 232.5mm appears on 7 different lists.
Hope that makes sense. If needed I can send the spreadsheet over.
Going a step further I'm wondering if there's a way I can enter predicted use and then have Excel work out the most efficient cutting lists based on usage / scrap. I imagine that's fairly complex / probably not what excel is for (?)
Thanks guys