Main

Optimization with Excel Solver

Main.ExcelSolver History

Hide minor edits - Show changes to output

May 03, 2014, at 09:41 PM by 23.255.240.62 -
Changed line 10 from:
<iframe width="560" height="315" src="//www.youtube.com/embed/FaAgXMnt0QI?list=PLLBUgWXdTBDi-E--rwBujaNkTejLNI6ap" frameborder="0" allowfullscreen></iframe>
to:
<iframe width="560" height="315" src="//www.youtube.com/embed/BZmSH8Y8_fc?list=PLLBUgWXdTBDi-E--rwBujaNkTejLNI6ap" frameborder="0" allowfullscreen></iframe>
May 03, 2014, at 09:25 PM by 23.255.240.62 -
Changed line 13 from:
This example problem is from the [[http://apmonitor.com/wiki/index.php/Apps/HockSchittkowski|Hock-Schittkowski benchmark test suite]]. This tutorial can also be completed with scripting programming languages like [[Main/MatlabOptimization|MATLAB]] and [[Main/PythonOptimization|Python]]. Click on the appropriate link for additional information and source code.
to:
This example problem is from the [[http://apmonitor.com/wiki/index.php/Apps/HockSchittkowski|Hock-Schittkowski benchmark test suite]]. This tutorial can also be completed with nonlinear programming optimizers that are available with the [[Main/MatlabOptimization|MATLAB optimization toolbox]] and the [[Main/PythonOptimization|Python optimization packages]] in APMonitor. Click on the appropriate link for additional information and source code.
May 03, 2014, at 09:22 PM by 23.255.240.62 -
Added lines 1-32:
(:title Optimization with Excel Solver:)
(:keywords Optimization, Nonlinear Programming, Microsoft Excel, spreadsheet, nonlinear, optimization, engineering optimization, Excel, university course:)
(:description Optimization with Excel Solver - Problem-Solving Techniques for Chemical Engineers at Brigham Young University:)

Microsoft Excel solver is a powerful add-on tool to solve and analyze optimization problems. Optimization deals with selecting the best option among a number of possible choices that are feasible or don't violate constraints. Solver can be used to adjust parameters in a model to best fit data, increase profitability of a potential engineering design, or meet some other type of objective that can be described mathematically in a spreadsheet.

* [[Attach:ExcelSolver_hs71.zip|Download Spreadsheet with HS71 Example Problem]]

(:html:)
<iframe width="560" height="315" src="//www.youtube.com/embed/FaAgXMnt0QI?list=PLLBUgWXdTBDi-E--rwBujaNkTejLNI6ap" frameborder="0" allowfullscreen></iframe>
(:htmlend:)

This example problem is from the [[http://apmonitor.com/wiki/index.php/Apps/HockSchittkowski|Hock-Schittkowski benchmark test suite]]. This tutorial can also be completed with scripting programming languages like [[Main/MatlabOptimization|MATLAB]] and [[Main/PythonOptimization|Python]]. Click on the appropriate link for additional information and source code.

----

(:html:)
 <div id="disqus_thread"></div>
    <script type="text/javascript">
        /* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
        var disqus_shortname = 'apmonitor'; // required: replace example with your forum shortname

        /* * * DON'T EDIT BELOW THIS LINE * * */
        (function() {
            var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;
            dsq.src = 'http://' + disqus_shortname + '.disqus.com/embed.js';
            (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
        })();
    </script>
    <noscript>Please enable JavaScript to view the <a href="http://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
    <a href="http://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>
(:htmlend:)