Re: Calculate Approximate Lengths Keeping Waste To A Minimum
Quote from Dave Hawley
(See attachment) In column (B) are my spec requirements. The VB Code for solving is in the VB sheet.
(F2) is the answer to match(reel footage) and it gives me the answers in column (H) if they are an exact match.
My problem is the reel footage (F2) and the specs very seldom match so I get nothing in column(H)
What I would like is to input into (C1) a variance amount which would allow the program to give me results within that variance but not exceed the value in(F2). For example -200 feet in (C1) would give me answers up to my reel footage (F2) but not exceed it.
Thanks for your suggestion of using Solver. I am trying to learn the mechanics of it now.