Re: Calc solvers - what to say in the Calc Guide

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hmm - there are bits and pieces here and there.

For example the first two choices (DEPS & SCO) have some explanation over at AOO wiki
https://wiki.openoffice.org/wiki/NLPSolver
If that is still relevant for LibreOffice I can't say, but likely.
CoinMD (which I assume here is type of Coin-MP) has a lot of generalized references, even a wiki page with a paragraph or two that might be worth drafting for service here:
https://en.wikipedia.org/wiki/COIN-OR

anyway - I'm just using DDG to search for info on the different solver types, and you get the idea.

There is a couple of examples of tutorials the reference solvers in Calc (one of which actually uses the same example data to show how to solve both in Excel and Calc), but the couple I reviewed only use one as an example.

I did find one for Excel that has an over view which I thought was a decent balance of information on the three solver models available there at:
https://www.tutorialspoint.com/excel_data_analysis/advanced_data_analysis_optimization_with_excel_solver.htm

IDK if any of the helps, hope it does.

Best wishes,




On Thu, May 14, 2020 at 7:19 PM Kohei Yoshida <kohei@xxxxxxxxxxxxxxx> wrote:
On 10.05.2020 10:59, Stephen Fanning wrote:

> What guidance can I insert into the Calc Guide to help the user if he
> wonders which algorithm to select?

This is strictly my personal opinion.

Which optimization solver to pick really depends on the characteristics
of the data being optimized, how (well) the algorithm is implemented in
the versions included in Calc, the accuracy goal etc. etc.  It's more an
art than science, and each user really needs to experiment with various
solvers to see which one works best for his or her optimization cases. 
My personal opinion is that it is probably beyond the scope of Calc user
guide to provide any sort of guidance on how to select a solver.

Feel free to disagree with me on this.  I'm not an expert. :-)

Kohei
_______________________________________________
LibreOffice mailing list
LibreOffice@xxxxxxxxxxxxxxxxxxxxx
https://lists.freedesktop.org/mailman/listinfo/libreoffice
_______________________________________________
LibreOffice mailing list
LibreOffice@xxxxxxxxxxxxxxxxxxxxx
https://lists.freedesktop.org/mailman/listinfo/libreoffice

[Index of Archives]     [LARTC]     [Bugtraq]     [Yosemite Forum]     [Photo]

  Powered by Linux