 Excel Solver |
Welcome Guest ( Log In | Click here to Register a free account now! )
Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, 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.
 Jul 3 2009, 12:35 PM
Post
#1
|
|
|
Member  Group: Members Posts: 25 Joined: 11-July 08 Member No.: 222,038  |
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. This post has been edited by stevenc1010: Jul 3 2009, 04:01 PM |
 |
 
|
Posts in this topic
stevenc1010 Excel Solver Jul 3 2009, 12:35 PM
Budapest I don't think you can do this in one go as you... Jul 6 2009, 05:49 PM  |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 26th November 2009 - 12:01 PM |
© 2003-2009 All Rights Reserved Bleeping Computer LLC.