Calculate Approximate Lengths Keeping Waste To A Minimum

  • 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.

    For example:

    (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.


  • Re: Calculate Approximate Lengths Keeping Waste To A Minimum

    Quote from Dave Hawley

    Not too sure I know what you mean but have you tried Goal Seek and/or Solver?

    (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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!