Re: Puzzle solving with solver

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I should get answer as 116 which fits the equations.

I may be wrong, but on the first division...

38*3+1 = 115
or
39*3+1 = 118

I don't show 116 as a possible solution.
Again, I may not have understood the question.
Or did you mean 106, as that's a possible solution?

With Solver, if your model is set up with a lot of equality constraints (ie
x = y)
you may be having problems with precision. Solver's "Integers" are not true
integers, but close.
Solver may not be recognizing that x=y due to precision.
You may want to start by going to Solver's options, and increasing both
Tolerance & Precision.

--
HTH :>)
Dana DeLouis
Windows XP & Office 2003


"Dinesh" <Dinesh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B8F9482C-2880-44C0-8EEC-1FBB2C93D658@xxxxxxxxxxxxxxxx
The puzzle goes like this. Try to solve it with solver.
3 Robbers rob some mangoes. Since the mongoes are green, they hide it at
one
place for ripening and decide to meet after 10 days for equal
distribution.
However on the 5th day first robber comes to the place alone and divides
all
the mongoes into 3 equal shares. After division there remains one mongo
extra
which he eats and goes away taking one part of the share. Now there
remains
two shares only. On the 6th day second robber comes to the place alone and
divides the remaining mongoes again into 3 equal shares. After division
there
remains one mongo which he eats and goes away taking one part of the
share.
Now there remains again two shares only. Then on the 7th day third robber
comes to the place alone and divides the remaining mongoes again into 3
equal
shares. After division there remains one mongo extra which he eats and
goes
away taking one part of the share. Now again there remains two shares
only.
On the 10th day all the three come, divide the reamaining mangoes equally
into 3 shares. Each one takes their own share and goes away. So what was
the
initial quantity of mangoes?

Now this puzzle has many solutions ie for the initial quantity. So I
specified the maximum and minimum values for this in constraints by
specifying these numbers in two different cells. So when I give the
constraints for the initial quantity of mangoes ie min 100 and maximum
120,
I should get answer as 116 which fits the equations. But solver says it
did
not find a feasible solution. However if I put the maximum as 200 and
minimum
as 100 solver gives answer as 116. Why is it so?



"Harlan Grove" wrote:

Dinesh wrote...
I used solver to solve a mathemathical puzzle but it is not giving the
sam
answer everytime. I can mail the excel file to anyone who can help.
Anyone
willing to help may please give your email address.

If there are multiple feasible solutions or the problem depends on
volatile functions, there's no guarantee Solver will always arrive at
the same solution.

That said, please don't consider this an invitation to e-mail your file
to me. Just describe the problem in plain text.




.

Relevant Pages

  • Re: Puzzle solving with solver
    ... But I got the reply as solver could ... After 1st robber split, the total is q ... the mongoes into 3 equal shares. ... specifying these numbers in two different cells. ...
    (microsoft.public.excel)
  • Re: Puzzle solving with solver
    ... I don't know how much you know about the method Solver uses ... After 1st robber split, the total is q ... in Solver we cannot specify intermediate results (calculated ... the mongoes into 3 equal shares. ...
    (microsoft.public.excel)
  • Re: Simple puzzle ...help please!
    ... I am having problems working out this percentage problem, ... Five partners receive shares in the following splits: ... equal shares of 1.5X. ...
    (uk.education.maths)