Results 1 to 5 of 5

Thread: two number combos in excel

  1. #1

    two number combos in excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    i have two number lengths. 2560mm and 3405mm. I need to know how to get best combination for a given length..say 8500mm. so answer will give answer of 2 x 3405 and 1 x 2560mm. Answer must be equal or longer than set target length.

  2. #2
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    324
    Articles
    0
    How will you set your constraints? my best answer for 8500mm would be 1x7499 & 1x1....see what i mean?, there are around 35,000,000+ possible combinations of giving 1+1 of something let alone 2+1 or 2+3+1...etc!!!!!!
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

  3. #3
    Im not sure. the combination would be the smallest number over the set target length though.

  4. #4
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    324
    Articles
    0
    Ok, just to throw a spanner in the works then the smallest numeber of pieces over the target length will always be 1 , it will never be 2 or 3, therefore, your example would be 1 x 8500mm (smallest possible) after that you start having to choose from many millions of combinations.

    I feel you're missing my point, you need to draw up a table of sizes for whatever it is your working with, same sizes across the top as down the side (like a mileage chart) so you can always intersect for two pieces so your first column would be 1 down to 8500 your first row would be the same. Now your thinking that you need to have more pieces, so how long is a piece? where does it not fit in with the equation before you need another piece?

    It's a lot more complicated that you think, but until you can come up with some parameters on when another piece should be selected and repeated until the size requirement is complete we'll be unable to help.
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

  5. #5
    I will always only have two sizes: 3405 and 2560.

    If target length is 6500, then I know that two 3405 lengths is the answer as it totals 6810, which is the smallest combination that is ≥
    number over target length of 6500.

    A target of 5000 would give result of two 2560 lengths (2560+2560=5120)
    A target of 8500 would give result of one 3405 and two 2560 lengths (3405+2560+2560=8525)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •