Optimization with Excel Solver
Main.ExcelSolver History
Hide minor edits - Show changes to output
Deleted lines 13-31:
----
(: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:)
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>
Changed line 13 from:
This example problem is from the [[https://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 [[https://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.
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 [[https://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 = '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:)
(: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 [[https://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 = '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:)