Excel's solver like tool for Linux

  • Thread starter Thread starter The-herod
  • Start date Start date
  • Tags Tags
    Linux
Click For Summary

Discussion Overview

The discussion revolves around finding a tool similar to Excel's Solver for Linux users. Participants explore various software options that can handle optimization problems, including nonlinear equations, and express their preferences for ease of use compared to programming solutions in Maxima.

Discussion Character

  • Exploratory
  • Technical explanation
  • Debate/contested

Main Points Raised

  • One participant inquires about existing tools like Excel's Solver for Linux, expressing a preference for a generic tool over programming specific solutions in Maxima.
  • Another participant suggests OpenOffice and Gnumeric as alternatives, noting that OpenOffice has solver add-ons and Gnumeric includes a built-in solver.
  • A participant shares their experience with OpenOffice and Gnumeric, mentioning difficulties in solving even basic problems and expressing a need for more advanced capabilities.
  • One reply mentions the possibility of using extensions in OpenOffice to access different solvers, highlighting a specific solver extension that worked for them.
  • Another participant expresses interest in the solver plug-ins for OpenOffice and plans to explore them further.

Areas of Agreement / Disagreement

Participants generally agree on the need for a tool similar to Excel's Solver but express differing experiences and opinions regarding the effectiveness of suggested alternatives. The discussion remains unresolved regarding the best solution for complex problems.

Contextual Notes

Some participants note challenges with specific software tools, including installation issues and the complexity of use, which may affect their ability to solve problems effectively.

The-herod
Messages
23
Reaction score
0
Hello,

Does anyone know about a tool like the Solver of Excel for linux?

Of course it's possible to program one for each task with Maxima, though, it's pretty comfortable to use a generic existing tool like the Solver...

Thanks.
 
Computer science news on Phys.org
If we stick to similar tools as excel's solver openoffice has some solver add-ons which work with nonlinear eqs and it has a sort of a goal seek feature by default. Gnumeric being very similar to these 2 has a built in solver. KDE's office suite probably has something similar (? gnome man myself). And can install office using wine if want to "contaminate" your linux.
 
Thanks. I rather to stick to a similar tool, but it's not necessary. Everything that will be easier (and faster) then programming it for a specific problem each time in Maxima.

Actually I tried OOo and gnumeric. Maybe I didn't operate it very well (though it's hard for me to believe it can be too much complicated), but it didn't succeed to solve even basic problems (like abs(exp(x)-1)), while I need it for more complicated problems (like Hohmann transfers).

Anyhow, thanks a lot!
 
In Oo you can play around with different solvers via extensions, like http://kohei.us/ooo/solver/ got running on mine now (got a non-distro version of Oo 2.4 so that doesn't mess my install since it doesn't have a solver installed by default), one cool thing about Oo.
 
Nice! I didn't know about the solver plug-ins.
I'll check it tomorrow (I have to install OO, my copy is from the distribution repositories...)
Thanks!:)
 

Similar threads

Replies
4
Views
3K
  • · Replies 18 ·
Replies
18
Views
3K
  • · Replies 21 ·
Replies
21
Views
3K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 14 ·
Replies
14
Views
4K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 1 ·
Replies
1
Views
3K
Replies
10
Views
5K