I have numerious reels of fiber optic and the specs tells me the exact footage to be used.
I would like to have a program add the footages and give me not an exact match but close keeping the extra cable to a minimum.
(A1) is the most I want left on the reel. say 200 feet but a varible.
(B1-B5) The footages on the spools. Say 1,000, 2,000,3000, 4,000 and 5,000
(C1-C10) The spec footage. Say 200, 300,400, 1,200, 1,500, 1,500, 1,500, 1,601, 2,400 and 3,500.
I looked at a accounts receivable program, but it only gives exact matches.