Help
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.
I am trying to solve a problem using the solver in excel. I am close to what I want but I am not sure how to do a certain constraint.
I want for the constraint to be only a couple sizes allowed.
ex. I can't have a 13.5 size wire and a 16.5 wire at the same time. There is to much of a margin with the size. It has to be atleast within 1. So I could use a size 14.5, 15, and 15.5 or a 15, 15.5, 16.
This link has a screen shot, which I thought would be easier than explaining my spreadsheet.
http://docs.google.com/View?id=ddm7njsk_0cbb8tbdv
I appreciate any help you guys can give.
I want for the constraint to be only a couple sizes allowed.
ex. I can't have a 13.5 size wire and a 16.5 wire at the same time. There is to much of a margin with the size. It has to be atleast within 1. So I could use a size 14.5, 15, and 15.5 or a 15, 15.5, 16.
This link has a screen shot, which I thought would be easier than explaining my spreadsheet.
http://docs.google.com/View?id=ddm7njsk_0cbb8tbdv
I appreciate any help you guys can give.
This post has been edited by stevenc1010: 03 July 2009 - 04:01 PM
Back to top
