I am in the flooring business and have created a spreadsheet that has been a work in progress. I use it to calculate material quantities needed for quoting projects
This sheet was initially for one type of product that is one length. I am trying to make it adaptable to different lengths of material that will be cut into specific lengths. I want to determine how many lengths to order.
J44 is the start point. This is where the length of the material to be cut is entered. All material to be cut is the same length.
J50 is the number of pieces needed cut to the length enter in J51. The number of pieces to order is displayed in K32
Where I get stuck is when additional pieces are needed D53 (the length) & F53 (the number of pieces)
I have looked at some cut optimizer formulas but they are all to complex for what I need.
I just noticed that some of the formulas are point to the wrong cells. I changed the layout and forgot to correct the cells in some of the formulas. If you see this before I repost the corrected sheet my apologies.
Hard surface2.xlsx
Bookmarks