I am searching for a formula that will provide a quantity for materials based
on sum of lengths. There will need to be a parameter giving the length of
the base material. For example, if pipe comes in a twenty foot length and I
am cutting this into a 9 foot, 12 foot, and 6 foot length I will need 2
pieces of pipe. Is there a formula that will allow me to automate this? It
will actually be in inches but I used a simplified example. Any help would
be appreciated.