The solver is essentially an iterative technique used to find roots of functions. Depending on the particular form of the function that you are trying to find a root of, you can roll your own or use existing implementations of the bisection method or Newton's method (or many other iterative root-finding techniques). If you post more about the specific problem that you are trying to solve, I might be able to point you to a more specific technique. Alternatively, you can read about root-finding and look at the Extreme Optimization library.
You might like to take a look at this, I haven't looked too closely.
Eureqa is a software tool for detecting equations and hidden mathematical relationships in your data. Its primary goal is to identify the simplest mathematical formulas which could describe the underlying mechanisms that produced the data. Eureqa is free to download and use.
You might be interested in the open source OpenSolver we have developed for Excel; it's available from http://www.opensolver.org. This uses the free COIN-OR CBC solver, and can solve linear and integer problems (but not non-linear models). It installs as an Excel add-in. It can solve much larger problems, and typically does so faster than Solver. Hope you find it useful.
OpenOffice has a new nonlinear solver plugin which uses completely different methods of finding solutions to optimization problems than the steepest-descent methods used in Excel's solver.
From your description it sounds like your data has a lot of outliers. For that you need some sort of robust fitting.
Matlab is the best program to do all these things, and it can be linked from .NET
gretl, the Gnu Regression Econometrics and Time-series Library, does the sort of things you need, and is highly efficient and well documented. I doubt there is a .NET API, but you can control it via scripting if necessary.
I've automated the solver interface for different projects. Have you considered some-sort of VBA macro? This support article from MS goes through the whole VBA interface: http://support.microsoft.com/kb/843304. I'd assume it's accessible through .NET as well.
One of the MAJOR BUGS in the Solver/Excel VBA interface is not visible until you take your Excel Spreadsheet (which references the Solver Interface) to another machine.
There you will get an error that basically says that the Solver add-in is not loaded. You must go in to VBA and into Tools, References and re-establish the reference to the Solver library.
发布评论
评论（9）
求解器本质上是一种用于查找函数根的迭代技术。 根据您尝试求根的函数的特定形式，您可以自行推出或使用二分法或牛顿法（或许多其他迭代求根技术）的现有实现。 如果您发布更多有关您试图解决的具体问题的信息，我也许可以向您指出更具体的技术。 或者，您可以阅读root-finding 并查看极限优化库。
The solver is essentially an iterative technique used to find roots of functions. Depending on the particular form of the function that you are trying to find a root of, you can roll your own or use existing implementations of the bisection method or Newton's method (or many other iterative root-finding techniques). If you post more about the specific problem that you are trying to solve, I might be able to point you to a more specific technique. Alternatively, you can read about root-finding and look at the Extreme Optimization library.
查看 Microsoft Solver Foundation
他们提供.Net 库来解决不同类型的优化问题
http://code.msdn.microsoft.com/solverfoundation
您可以将其集成到您的代码中非常简单地
Check out Microsoft Solver Foundation
they provide .Net libraries to solve different kind of optimization problems
http://code.msdn.microsoft.com/solverfoundation
You can integrate it into your code very easily
Netlib 提供了用于各种目的的开源求解器的完整列表。 您可能会找到一些您喜欢的。
Netlib offers a comprehensive list of open-source solvers for various purposes. You may find some that you like.
你可能想看一下这个，我还没有仔细看过。
You might like to take a look at this, I haven't looked too closely.
您可能对我们为 Excel 开发的开源 OpenSolver 感兴趣； 它可以从 http://www.opensolver.org 获取。 这使用免费的 COIN-OR CBC 求解器，可以解决线性和整数问题（但不能解决非线性模型）。 它作为 Excel 加载项安装。 它可以解决更大的问题，并且通常比求解器更快。 希望你觉得它有用。
You might be interested in the open source OpenSolver we have developed for Excel; it's available from http://www.opensolver.org. This uses the free COIN-OR CBC solver, and can solve linear and integer problems (but not non-linear models). It installs as an Excel add-in. It can solve much larger problems, and typically does so faster than Solver. Hope you find it useful.
OpenOffice 有一个新的非线性求解器插件，它使用与 Excel 求解器中使用的最速下降方法完全不同的方法来寻找优化问题的解决方案。
从你的描述来看，你的数据似乎有很多异常值。 为此，您需要某种坚固的配件。
Matlab 是完成所有这些事情的最佳程序，并且可以从 .NET 链接它
OpenOffice has a new nonlinear solver plugin which uses completely different methods of finding solutions to optimization problems than the steepest-descent methods used in Excel's solver.
From your description it sounds like your data has a lot of outliers. For that you need some sort of robust fitting.
Matlab is the best program to do all these things, and it can be linked from .NET
gretl，Gnu 回归计量经济学和时间序列库，可以做您需要的事情，并且非常有用高效且有据可查。 我怀疑是否有 .NET API，但如果需要，您可以通过脚本来控制它。
gretl, the Gnu Regression Econometrics and Time-series Library, does the sort of things you need, and is highly efficient and well documented. I doubt there is a .NET API, but you can control it via scripting if necessary.
我已经为不同的项目实现了求解器界面的自动化。 您考虑过某种 VBA 宏吗？ MS 的这篇支持文章介绍了整个 VBA 界面： http://support.microsoft.com/kb/ 843304。 我认为它也可以通过 .NET 访问。
I've automated the solver interface for different projects. Have you considered some-sort of VBA macro? This support article from MS goes through the whole VBA interface: http://support.microsoft.com/kb/843304. I'd assume it's accessible through .NET as well.
Solver/Excel VBA 界面中的一个主要错误是不可见的，除非您将 Excel 电子表格（引用了 Solver 界面）带到另一台机器上。
在那里你会得到一个错误，基本上表明 Solver 插件未加载。 您必须进入 VBA 并进入“工具”、“参考”并重新建立对 Solver 库的参考。
很烦人。
One of the MAJOR BUGS in the Solver/Excel VBA interface is not visible until you take your Excel Spreadsheet (which references the Solver Interface) to another machine.
There you will get an error that basically says that the Solver add-in is not loaded. You must go in to VBA and into Tools, References and re-establish the reference to the Solver library.
VERY ANNOYING.