[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
kalil
Newbie

Joined: 28 Jul 2012
Posts: 1

 Posted: Sat Jul 28, 2012 5:07 pm    Post subject: A solver puzzle (solver ignoring conditions?) So, I've been trying to solve a puzzle. I've got a series of conitionals - X can be present in the group so long as neither Y or Z is present, or so long as W is present and only one of Y and Z are. I want to maximize the size of the group. I've set this up in OO.o using a set of formulas, so that in a given row J is positive or 0 so long as the conditions are met, and F is either 1 or 0 depending on wether that member is present. I then set 'solver' to maximize the sum of column F by varying the values in column F, with the conditions that values in column F must be binary and that values in column J must be greater then or equal to 0. Solver then spits out '1' for all values in column F, ignoring that this makes all the values in J negative. I'm not sure that there is only one 'best' solution to this problem, but there are valid solutions (the simplest one being to leave all values at 0, and the largest I've found manually giving a sum of 13). I don't know why Solver is giving me invalid solutions. I downloaded the non-linear solver extension, and those did not perform any better. You can find my document here. Thanks for any assistance.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum