Forum Discussion
Material Leftovers
Hello, I have possibly an unusual Formula request, but necessary for our company. We have material that is being cut and would like to see if there is a formula that I can use to figure out how ...
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))