Hello everyone,
Wondering if there is a solution in excel to help make things quicker and simpler.
Often times, I need to determine how many materials I need to make certain quantities of smaller items.
I would first have to find out the total material required and then the distribution.
Is there a way in Excel, both with just formulae (Solver?) or using VBA?
Including an illustration of what I need help with below.
Also, where do folks usually go to learn about all this?
Thank you so much everyone.
All the best.
It would be nice to be able to just enter the sizes and quantities I need, and it'll auto calcualte how many bars are required and the distribution.
Wondering if there is a solution in excel to help make things quicker and simpler.
Often times, I need to determine how many materials I need to make certain quantities of smaller items.
I would first have to find out the total material required and then the distribution.
Is there a way in Excel, both with just formulae (Solver?) or using VBA?
Including an illustration of what I need help with below.
Also, where do folks usually go to learn about all this?
Thank you so much everyone.
All the best.
It would be nice to be able to just enter the sizes and quantities I need, and it'll auto calcualte how many bars are required and the distribution.
| FULL BAR | CUT | CUT | CUT | CUT | CUT | CUT | CUT | CUT | REMAINING | Size: | 38.79 | 37.04 | 29.04 | 26.79 | ||||
| Bar # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Qty: | 14 | 42 | 28 | 14 | |||||
1 | 240 | 38.79 | 38.79 | 38.79 | 38.79 | 38.79 | 38.79 | 7.26 | 6 | |||||||||
2 | 240 | 38.79 | 38.79 | 38.79 | 38.79 | 38.79 | 38.79 | 7.26 | 6 | |||||||||
3 | 240 | 38.79 | 38.79 | 37.04 | 37.04 | 29.04 | 29.04 | 29.04 | 1.22 | 2 | 2 | 3 | ||||||
4 | 240 | 37.04 | 37.04 | 37.04 | 37.04 | 37.04 | 26.79 | 26.79 | 1.22 | 5 | 2 | |||||||
5 | 240 | 37.04 | 37.04 | 37.04 | 37.04 | 37.04 | 26.79 | 26.79 | 1.22 | 5 | 2 | |||||||
6 | 240 | 37.04 | 37.04 | 37.04 | 37.04 | 37.04 | 26.79 | 26.79 | 1.22 | 5 | 2 | |||||||
7 | 240 | 37.04 | 37.04 | 37.04 | 37.04 | 37.04 | 26.79 | 26.79 | 1.22 | 5 | 2 | |||||||
8 | 240 | 37.04 | 37.04 | 37.04 | 37.04 | 37.04 | 26.79 | 26.79 | 1.22 | 5 | 2 | |||||||
9 | 240 | 37.04 | 37.04 | 37.04 | 37.04 | 37.04 | 26.79 | 26.79 | 1.22 | 5 | 2 | |||||||
10 | 240 | 37.04 | 37.04 | 37.04 | 37.04 | 37.04 | 26.79 | 26.79 | 1.22 | 5 | 2 | |||||||
11 | 240 | 37.04 | 37.04 | 37.04 | 37.04 | 29.04 | 29.04 | 29.04 | 4.72 | 4 | 3 | |||||||
12 | 240 | 37.04 | 29.04 | 29.04 | 29.04 | 29.04 | 29.04 | 29.04 | 28.72 | 1 | 3 | |||||||
13 | 240 | 29.04 | 29.04 | 29.04 | 29.04 | 29.04 | 29.04 | 29.04 | 29.04 | 7.68 | 8 | |||||||
14 | 240 | 29.04 | 29.04 | 29.04 | 29.04 | 29.04 | 29.04 | 29.04 | 29.04 | 7.68 | 8 | |||||||
15 | 240 | 29.04 | 29.04 | 29.04 | 152.88 | 3 | ||||||||||||
