[Libreoffice-bugs] [Bug 100916] Solver does not find the optimal solution

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=100916

Luiz <moura_lf at yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #11 from Luiz <moura_lf at yahoo.com> ---
Excel's Sover uses a deterministic method to estimate a solution and Calc's
does not (DEPS uses heuristics). Well, how I circunvented the problem? My limit
conditions were $B$9 >= 999.9999 and $B$9 <= 1000.0001. For initial guess I
forced radius value 5 and height was guessed with a GoalSeek to V = 1000. Why
that? Because even an excelent "root finder" depends on the initial guesses.
And the same solution was found with a bit more higher number of interations
when compared to Excel.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200330/20bb1391/attachment-0001.htm>