Forum Discussion
Material Leftovers
sg2021 I liked Riny_van_Eekelen approach but thought we could do a bit better in some cases where the left over has enough scrap to rotate is and cut additional product at a 90 degree from the originals. Here is the updated formula and sheet. You'll notice the formula gets a bit longer but it is all based on Riny's orginal formula and named ranges:
=MAX(INT(MatW/ProdW)*INT(MatL/ProdL)+INT(MOD(MatW,ProdW)/ProdL)*INT(MatL/ProdW)+INT(MOD(MatL,ProdL)/ProdW)*INT(MatW/ProdL),INT(MatW/ProdL)*INT(MatL/ProdW)+INT(MOD(MatW,ProdL)/ProdW)*INT(MatL/ProdL)+INT(MOD(MatL,ProdW)/ProdL)*INT(MatW/ProdW))
What about the below? Doesn't seem like I can really get 39 pieces out of this material. Can you please confirm this formula works for this scenario? Thanks!
W L
Mat 47 156
Prod 3.5 48.5
Max 39
Max/Rotation 39
sg2021 Since the Max and the Max/Rot are the same you know a solution is with all them in same direction. The product L x 3 = 145.5 which is < 156 and then the product W x 13 = 45.5 is < 47 so you can get a grid of 3 x 13 (39) product out of that material all in the same direction.
BTW I wanted to mention that my solution is not the optimized solution in all cases. It will catch some cases that Riny's orig solution didn't but not all. For example if you have a square piece 48"x48" (1/2 sheet of plywood) and you want product that is 23"x25" (not counting loss from cuts) then the original equation would say 2, my improved version 3, but you could get 4 if you cut each piece from a corner of the material and rotate 90deg each time.
I figured out the #value issue, but now have another request that needs to be added into this formula.
How do I add a .03" blade cut for each value? For example, original piece would be 19x36 and need a piece that is 13x16 with a .03" adder for the cut itself?
sg2021 as mathetes said, the easiest way is to add it to the product size dimensions and an easy way to do that is using the NAMES defined by Riny_van_Eekelen . So in the Name Manager just add 0.03 to them there.
Out of curiosity, what was that #Value issue you were having and how did you solve it?
I tried to attach the file but it is just getting stuck when I try. But you can see what I did in the image above.
- This is noted and appreciate the feedback.
Can you maybe tell me why others see a #Value instead of the answer? I see the answer on my end, but when shared through office 365 they sometimes see a #value instead of the number the formula provides. Thoughts?
W L
Mat 48.5 144.5
Prod 30.5 67.75
Max #VALUE
Max/Rotation #VALUE