Hacker News new | ask | show | jobs
by jhammerb 6018 days ago
Excel has incorporated software from Frontline Systems, rebranded as "Solver", for many years. Most heavy Excel users use it every day. I couldn't dig through the marketing speak entirely, but this product appears to be a port of Solver to C# and not open source. Of limited interest to HN readers, I'd expect.
1 comments

I strongly disagree. This has very little to do with Excel Solver. This seems to be Microsoft's take at large-scale, real-world optimization problems, possibly with millions of variables and constraints. Can you do that with Excel? I doubt it. This Solver Foundation framework can do Constraint Programming, Quadratic Programming, and Mixed-Integer Programming. This is serious optimization, not the kiddie stuff Excel users deal with. SF seems to be based on commercial C++ solvers such as MOSEK.

I would say that open-source is not of great interest in optimization software. The idea is to write as little code as possible, and to trust that everything performance-critical has been optimized. Even speed is not the main issue for me. I want something that is flexible. I want to write little code because the less I write the less bugs there are. Correctness trumps everything else.

If I am using SF to allocate investments, I want to make sure an optimal solution is found, even if it takes a little longer. Computer time is cheap. Buy a bigger computer. Developer time is more precious. There are only 24 hours in a day.

You want to change the source code? With all due respect, but I would speculate that 99,9999% of HN users are not qualified to write numerical optimization code. Looking at it is of little use unless you have a PhD in Applied Math and years and years of experience.

Of limited use to HN readers? To those writing web-apps, perhaps. Those doing Machine Learning will probably be ecstatic to find this.

This is the guy from the hanselminutes interview...

Solver Foundation is not a port of Excel Solver - it is a ground-up implementation in managed code (C#). As TriinT said, the focus is on addressing optimization problems that commonly occur in finance, engineering, supply chain, etc. It's fair to say that there are things that Excel Solver offers that Solver Foundation currently does not (e.g. nonlinear programming), and things Solver Foundation offers that Excel Solver does not. In particular, there is a roster of solvers that are all accessible from a consistent, .Net friendly API.

It's not open source, but there is a solver plug-in model which allows you to use other solvers in place of the ones supplied by our team. In particular, open-source solvers such as lp_solve are supported.

Nathan