 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 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 |
 |
 
|
|
Jul 6 2009, 05:49 PM
Post
#2
|
|
 Bleepin' Cynic Group: BC Advisor Posts: 10,441 Joined: 11-November 06 Member No.: 94,959 |
I don't think you can do this in one go as you have more than one possible solution to the problem, and I don't think the SOLVE function can deal with this.
What you could do is break it down into 5 separate SOLVE functions for the different ranges: 13.5, 14.0, 14.5 14.0, 14.5, 15.0 14.5, 15.0, 15.5 15.0, 15.5, 16.0 15.5, 16.0, 16.5 These could be saved as different macros. Then, once you have your 5 different solutions you could choose which one is best (presumably by selecting which one has the lowest CM value). -------------------- The power of accurate observation is commonly called cynicism by those who haven't got it.
—George Bernard Shaw |
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 8th November 2009 - 08:36 AM |
© 2003-2009 All Rights Reserved Bleeping Computer LLC.