Learn Programming

<iframe width="560" height="315" src="//www.youtube.com/embed/BZmSH8Y8_fc?list=PLLBUgWXdTBDi-E--rwBujaNkTejLNI6ap" frameborder="0" allowfullscreen></iframe>

This example problem is from the Hock-Schittkowski benchmark test suite. This tutorial can also be completed with nonlinear programming optimizers that are available with the MATLAB optimization toolbox and the Python optimization packages in APMonitor. Click on the appropriate link for additional information and source code.

(: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.

• 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 Hock-Schittkowski benchmark test suite. This tutorial can also be completed with scripting programming languages like MATLAB and 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 = 'https://' + 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="https://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
    <a href="https://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>

(:htmlend:)