<div class="xblock xblock-public_view xblock-public_view-vertical" data-request-token="5c94f8085af511ee8f44162ded714679" data-has-score="False" data-runtime-version="1" data-usage-id="block-v1:MITx+15.053x+3T2016+type@vertical+block@43055ec0f9444ae294b7cd38b697913a" data-course-id="course-v1:MITx+15.053x+3T2016" data-runtime-class="LmsRuntime" data-init="VerticalStudentView" data-graded="False" data-block-type="vertical">
<h2 class="hd hd-2 unit-title">OpenSolver</h2>
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:MITx+15.053x+3T2016+type@problem+block@34fe1ec67b084376919a13bc83a6805e">
<div class="xblock xblock-public_view xblock-public_view-problem xmodule_display xmodule_ProblemBlock" data-request-token="5c94f8085af511ee8f44162ded714679" data-has-score="True" data-runtime-version="1" data-usage-id="block-v1:MITx+15.053x+3T2016+type@problem+block@34fe1ec67b084376919a13bc83a6805e" data-course-id="course-v1:MITx+15.053x+3T2016" data-runtime-class="LmsRuntime" data-init="XBlockToXModuleShim" data-graded="False" data-block-type="problem">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "Problem"}
</script>
<div id="problem_34fe1ec67b084376919a13bc83a6805e" class="problems-wrapper" role="group"
aria-labelledby="34fe1ec67b084376919a13bc83a6805e-problem-title"
data-problem-id="block-v1:MITx+15.053x+3T2016+type@problem+block@34fe1ec67b084376919a13bc83a6805e" data-url="/courses/course-v1:MITx+15.053x+3T2016/xblock/block-v1:MITx+15.053x+3T2016+type@problem+block@34fe1ec67b084376919a13bc83a6805e/handler/xmodule_handler"
data-problem-score="0"
data-problem-total-possible="0"
data-attempts-used="0"
data-content="
<h3 class="hd hd-3 problem-header" id="34fe1ec67b084376919a13bc83a6805e-problem-title" aria-describedby="block-v1:MITx+15.053x+3T2016+type@problem+block@34fe1ec67b084376919a13bc83a6805e-problem-progress" tabindex="-1">
OpenSolver validation
</h3>
<div class="problem-progress" id="block-v1:MITx+15.053x+3T2016+type@problem+block@34fe1ec67b084376919a13bc83a6805e-problem-progress"></div>
<div class="problem">
<div><h1>Google Sheets</h1><p>This isn't really an "exercise". Ignore "final check" and "save" at the bottom. The purpose is to let you download OpenSolver for Google Sheets so that you are ready when we explain how to use the software. We also give you a spreadsheet here that you should use to test whether OpenSolver is working properly on Google Sheets. If you want, you can "play" with the software so that you can understand it better. But it is not necessary to do so. </p><ol><li>Install the OpenSolver add-on <a class="modal-content" href="https://chrome.google.com/webstore/detail/opensolver/hfikolkpdcamjmmpoamebnahmiinpbfm?hl=en"> here</a></li><li>Open the Google sheets test<a class="modal-content" href="/assets/courseware/v1/cb610a426df027b27642d56525ae90cf/asset-v1:MITx+15.053x+3T2016+type@asset+block/OpenSolver_Test_Google.xlsx"> here</a></li><li>File &gt; Import</li><li>Add-ons &gt; OpenSolver &gt; Open sidebar</li><li>Ensure that the Solver is set to GLPK</li><li>Click solve</li></ol>
Expected output in cell C4:
<pre><code>
5
</code></pre>
<p/>
<h2>Troubleshooting</h2>
<ul><li>Does your browser allow for cookies from Google?</li><li>Was the Add-on installed properly?</li></ul>
</div>
<div class="action">
<input type="hidden" name="problem_id" value="OpenSolver validation" />
<div class="submit-attempt-container">
<button type="button" class="submit btn-brand" data-submitting="Submitting" data-value="Submit" data-should-enable-submit-button="True" aria-describedby="submission_feedback_34fe1ec67b084376919a13bc83a6805e" >
<span class="submit-label">Submit</span>
</button>
<div class="submission-feedback" id="submission_feedback_34fe1ec67b084376919a13bc83a6805e">
<span class="sr">Some problems have options such as save, reset, hints, or show answer. These options follow the Submit button.</span>
</div>
</div>
<div class="problem-action-buttons-wrapper">
</div>
</div>
<div class="notification warning notification-gentle-alert
is-hidden"
tabindex="-1">
<span class="icon fa fa-exclamation-circle" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="34fe1ec67b084376919a13bc83a6805e-problem-title">
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
<div class="notification warning notification-save
is-hidden"
tabindex="-1">
<span class="icon fa fa-save" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="34fe1ec67b084376919a13bc83a6805e-problem-title">None
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
<div class="notification general notification-show-answer
is-hidden"
tabindex="-1">
<span class="icon fa fa-info-circle" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="34fe1ec67b084376919a13bc83a6805e-problem-title">Answers are displayed within the problem
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
</div>
"
data-graded="False">
<p class="loading-spinner">
<i class="fa fa-spinner fa-pulse fa-2x fa-fw"></i>
<span class="sr">Loading…</span>
</p>
</div>
</div>
</div>
<div class="vert vert-1" data-id="block-v1:MITx+15.053x+3T2016+type@problem+block@a7d283b113dd4de4b5a01da03ceca24a">
<div class="xblock xblock-public_view xblock-public_view-problem xmodule_display xmodule_ProblemBlock" data-request-token="5c94f8085af511ee8f44162ded714679" data-has-score="True" data-runtime-version="1" data-usage-id="block-v1:MITx+15.053x+3T2016+type@problem+block@a7d283b113dd4de4b5a01da03ceca24a" data-course-id="course-v1:MITx+15.053x+3T2016" data-runtime-class="LmsRuntime" data-init="XBlockToXModuleShim" data-graded="False" data-block-type="problem">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "Problem"}
</script>
<div id="problem_a7d283b113dd4de4b5a01da03ceca24a" class="problems-wrapper" role="group"
aria-labelledby="a7d283b113dd4de4b5a01da03ceca24a-problem-title"
data-problem-id="block-v1:MITx+15.053x+3T2016+type@problem+block@a7d283b113dd4de4b5a01da03ceca24a" data-url="/courses/course-v1:MITx+15.053x+3T2016/xblock/block-v1:MITx+15.053x+3T2016+type@problem+block@a7d283b113dd4de4b5a01da03ceca24a/handler/xmodule_handler"
data-problem-score="0"
data-problem-total-possible="0"
data-attempts-used="0"
data-content="
<h3 class="hd hd-3 problem-header" id="a7d283b113dd4de4b5a01da03ceca24a-problem-title" aria-describedby="block-v1:MITx+15.053x+3T2016+type@problem+block@a7d283b113dd4de4b5a01da03ceca24a-problem-progress" tabindex="-1">
OpenSolver validation
</h3>
<div class="problem-progress" id="block-v1:MITx+15.053x+3T2016+type@problem+block@a7d283b113dd4de4b5a01da03ceca24a-problem-progress"></div>
<div class="problem">
<div><h1>Microsoft Excel</h1><p>This isn't really an "exercise". Ignore "final check" and "save" at the bottom. The purpose is to let you download OpenSolver for Microsoft Excel so that you are ready when we explain how to use the software. We also give you a spreadsheet here that you should use to test whether OpenSolver is working properly with Excel. If you want, you can "play" with the software so that you can understand it better. But it is not necessary to do so. After opening the <a class="modal-content" href="/assets/courseware/v1/2ca2c5a5418a64ba25115f91d156de2c/asset-v1:MITx+15.053x+3T2016+type@asset+block/Recitation0.xlsx"> Excel workbook,</a></p>
Mac
<ol><li>Install OpenSolver <a class="modal-content" href="https://opensolver.org/installing-opensolver/"> here</a></li><li>Ensure that OpenSolver and the file above are in the same directory, i.e. downloads</li><li>Open OpenSolver.xlam </li><li>On the top ribbon, OpenSolver &gt; solve</li></ol>
Windows
<ol><li>Install OpenSolver <a class="modal-content" href="https://opensolver.org/installing-opensolver/"> here</a></li><li>Ensure that OpenSolver and the file above are in the same directory, i.e. downloads</li><li>Open OpenSolver.xlam </li><li>Data &gt; OpenSolver &gt; solve</li></ol>
Expected output in cell C4:
<pre><code>
5
</code></pre>
<h2>Troubleshooting</h2>
<ul><li>Did you install the latest version for OpenSolver for the correct platform, i.e. iOS vs. Windows?</li><li>Are macros enabled in Excel? Check tools &gt; Macro &gt; Macros</li><li>Is your version of Excel compatible with OpenSolver?</li></ul>
</div>
<div class="action">
<input type="hidden" name="problem_id" value="OpenSolver validation" />
<div class="submit-attempt-container">
<button type="button" class="submit btn-brand" data-submitting="Submitting" data-value="Submit" data-should-enable-submit-button="True" aria-describedby="submission_feedback_a7d283b113dd4de4b5a01da03ceca24a" >
<span class="submit-label">Submit</span>
</button>
<div class="submission-feedback" id="submission_feedback_a7d283b113dd4de4b5a01da03ceca24a">
<span class="sr">Some problems have options such as save, reset, hints, or show answer. These options follow the Submit button.</span>
</div>
</div>
<div class="problem-action-buttons-wrapper">
</div>
</div>
<div class="notification warning notification-gentle-alert
is-hidden"
tabindex="-1">
<span class="icon fa fa-exclamation-circle" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="a7d283b113dd4de4b5a01da03ceca24a-problem-title">
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
<div class="notification warning notification-save
is-hidden"
tabindex="-1">
<span class="icon fa fa-save" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="a7d283b113dd4de4b5a01da03ceca24a-problem-title">None
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
<div class="notification general notification-show-answer
is-hidden"
tabindex="-1">
<span class="icon fa fa-info-circle" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="a7d283b113dd4de4b5a01da03ceca24a-problem-title">Answers are displayed within the problem
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
</div>
"
data-graded="False">
<p class="loading-spinner">
<i class="fa fa-spinner fa-pulse fa-2x fa-fw"></i>
<span class="sr">Loading…</span>
</p>
</div>
</div>
</div>
</div>
</div>
<div class="xblock xblock-public_view xblock-public_view-vertical" data-request-token="5c94f8085af511ee8f44162ded714679" data-has-score="False" data-runtime-version="1" data-usage-id="block-v1:MITx+15.053x+3T2016+type@vertical+block@b6021620451840f0a4179b9691d46367" data-course-id="course-v1:MITx+15.053x+3T2016" data-runtime-class="LmsRuntime" data-init="VerticalStudentView" data-graded="False" data-block-type="vertical">
<h2 class="hd hd-2 unit-title">Julia</h2>
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:MITx+15.053x+3T2016+type@problem+block@30cb764620ca46198fdbebe3e8be5b88">
<div class="xblock xblock-public_view xblock-public_view-problem xmodule_display xmodule_ProblemBlock" data-request-token="5c94f8085af511ee8f44162ded714679" data-has-score="True" data-runtime-version="1" data-usage-id="block-v1:MITx+15.053x+3T2016+type@problem+block@30cb764620ca46198fdbebe3e8be5b88" data-course-id="course-v1:MITx+15.053x+3T2016" data-runtime-class="LmsRuntime" data-init="XBlockToXModuleShim" data-graded="False" data-block-type="problem">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "Problem"}
</script>
<div id="problem_30cb764620ca46198fdbebe3e8be5b88" class="problems-wrapper" role="group"
aria-labelledby="30cb764620ca46198fdbebe3e8be5b88-problem-title"
data-problem-id="block-v1:MITx+15.053x+3T2016+type@problem+block@30cb764620ca46198fdbebe3e8be5b88" data-url="/courses/course-v1:MITx+15.053x+3T2016/xblock/block-v1:MITx+15.053x+3T2016+type@problem+block@30cb764620ca46198fdbebe3e8be5b88/handler/xmodule_handler"
data-problem-score="0"
data-problem-total-possible="0"
data-attempts-used="0"
data-content="
<h3 class="hd hd-3 problem-header" id="30cb764620ca46198fdbebe3e8be5b88-problem-title" aria-describedby="block-v1:MITx+15.053x+3T2016+type@problem+block@30cb764620ca46198fdbebe3e8be5b88-problem-progress" tabindex="-1">
JuliaBox Verification
</h3>
<div class="problem-progress" id="block-v1:MITx+15.053x+3T2016+type@problem+block@30cb764620ca46198fdbebe3e8be5b88-problem-progress"></div>
<div class="problem">
<div><p>This isn't really an "exercise". The purpose is to let you get started with the software JuliaBox, which was developed at MIT. Here we let you get started with JuliaBox. JuliaBox does not require you to download any software directly to your computer. </p><p> If you do not have enough network bandwidth , you may find that JuliaBox runs too slowly, and that it is frustrating to use. An alternative is to download Julia (rather than JuliaBox) directly to your computer. The directions for doing so follow this "exercise". However, we should warn you in advance that Julia is a big file. It is approximately 300 megs. It may take a long time to download. </p><p> We believe that JuliaBox (or Julia) with JuMP is a valuable part of 15.053x. While we highly recommend that you do the exercises that rely on JuliaBox and JuMP, it is not a requirement of 15.053x. There are no points in the subject assigned for the exercises that rely on JuliaBox. </p><p> Here we will test proper functionality in JuliaBox. After opening <a class="modal-content" href="http://juliabox.com"> juliabox.com </a>, and signing in,</p><ol><li>Select new &gt; Julia 0.4</li><li>Wait for the kernel to load</li><li>Run the following</li></ol><pre><code>a=2+3
</code></pre>
Expected output:
Expected output:
<pre><code>
5
</code></pre>
<p>Next, we will test JuMP functionality. </p>
<ol><li>On the home window, select upload</li><li>Upload <a class="modal-content" href="/assets/courseware/v1/541c88c61cad22838c62a6b53d12f0fa/asset-v1:MITx+15.053x+3T2016+type@asset+block/Diet_Problem.ipynb"> this</a> file</li><li>Open the notebook</li><li>On the top ribbon, select cell &gt; run</li></ol>
Expected output:
<pre><code>
variable values: x: 1 dimensions, 4 entries:
[ brownies] = 0.0
[cheese cake] = 0.0
[ cola] = 0.9999999999999998
[ ice cream] = 3.0000000000000004
Objetive value: 0.9
</code></pre>
<p/>
<h2>Troubleshooting</h2>
<ul><li>Does your browser allow for cookies from juliabox?</li><li>Did your kernel fail? Kernel &gt; Restart kernel</li></ul>
</div>
<div class="action">
<input type="hidden" name="problem_id" value="JuliaBox Verification" />
<div class="submit-attempt-container">
<button type="button" class="submit btn-brand" data-submitting="Submitting" data-value="Submit" data-should-enable-submit-button="True" aria-describedby="submission_feedback_30cb764620ca46198fdbebe3e8be5b88" >
<span class="submit-label">Submit</span>
</button>
<div class="submission-feedback" id="submission_feedback_30cb764620ca46198fdbebe3e8be5b88">
<span class="sr">Some problems have options such as save, reset, hints, or show answer. These options follow the Submit button.</span>
</div>
</div>
<div class="problem-action-buttons-wrapper">
</div>
</div>
<div class="notification warning notification-gentle-alert
is-hidden"
tabindex="-1">
<span class="icon fa fa-exclamation-circle" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="30cb764620ca46198fdbebe3e8be5b88-problem-title">
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
<div class="notification warning notification-save
is-hidden"
tabindex="-1">
<span class="icon fa fa-save" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="30cb764620ca46198fdbebe3e8be5b88-problem-title">None
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
<div class="notification general notification-show-answer
is-hidden"
tabindex="-1">
<span class="icon fa fa-info-circle" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="30cb764620ca46198fdbebe3e8be5b88-problem-title">Answers are displayed within the problem
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
</div>
"
data-graded="False">
<p class="loading-spinner">
<i class="fa fa-spinner fa-pulse fa-2x fa-fw"></i>
<span class="sr">Loading…</span>
</p>
</div>
</div>
</div>
<div class="vert vert-1" data-id="block-v1:MITx+15.053x+3T2016+type@problem+block@0b894e5fe4bf4cb7803c62bae05d06b5">
<div class="xblock xblock-public_view xblock-public_view-problem xmodule_display xmodule_ProblemBlock" data-request-token="5c94f8085af511ee8f44162ded714679" data-has-score="True" data-runtime-version="1" data-usage-id="block-v1:MITx+15.053x+3T2016+type@problem+block@0b894e5fe4bf4cb7803c62bae05d06b5" data-course-id="course-v1:MITx+15.053x+3T2016" data-runtime-class="LmsRuntime" data-init="XBlockToXModuleShim" data-graded="False" data-block-type="problem">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "Problem"}
</script>
<div id="problem_0b894e5fe4bf4cb7803c62bae05d06b5" class="problems-wrapper" role="group"
aria-labelledby="0b894e5fe4bf4cb7803c62bae05d06b5-problem-title"
data-problem-id="block-v1:MITx+15.053x+3T2016+type@problem+block@0b894e5fe4bf4cb7803c62bae05d06b5" data-url="/courses/course-v1:MITx+15.053x+3T2016/xblock/block-v1:MITx+15.053x+3T2016+type@problem+block@0b894e5fe4bf4cb7803c62bae05d06b5/handler/xmodule_handler"
data-problem-score="0"
data-problem-total-possible="0"
data-attempts-used="0"
data-content="
<h3 class="hd hd-3 problem-header" id="0b894e5fe4bf4cb7803c62bae05d06b5-problem-title" aria-describedby="block-v1:MITx+15.053x+3T2016+type@problem+block@0b894e5fe4bf4cb7803c62bae05d06b5-problem-progress" tabindex="-1">
Julia Verification
</h3>
<div class="problem-progress" id="block-v1:MITx+15.053x+3T2016+type@problem+block@0b894e5fe4bf4cb7803c62bae05d06b5-problem-progress"></div>
<div class="problem">
<div><p>We recommend that you use JuliaBox rather than Julia. If you have been successful in using JuliaBox, and if you continue to be successful in the future, then you can skip this "exercise." However, if you find that JuliaBox is too slow to use because of your network connection, Julia is a very good alternative. </p><p>Here we provide information that will let you test proper functionality in Julia. The first step is to install Julia and jupyter notebook on your computer. Be forewarned that Julia is a very big file and it may take a long time to download to your computer. You may prefer doing so right before taking a break from using your computer. You will need to follow the instructions <a class="modal-content" href="/assets/courseware/v1/7e8e83a9c4250a00caf20dfb0afd1a4d/asset-v1:MITx+15.053x+3T2016+type@asset+block/JuliaTutorial.pdf"> here. </a></p><ol><li>From your terminal/command line, run <pre><code>jupyter notebook </code></pre></li><li>Select new &gt; Julia 0.4</li><li>Wait for the kernel to load</li><li>Run the following</li></ol><pre><code>a=2+3
</code></pre>
Expected output:
Expected output:
<pre><code>
5
</code></pre>
<p>Next, we will test JuMP functionality. </p>
<ol><li>On the home window, select upload</li><li>Upload <a class="modal-content" href="/assets/courseware/v1/541c88c61cad22838c62a6b53d12f0fa/asset-v1:MITx+15.053x+3T2016+type@asset+block/Diet_Problem.ipynb"> this</a> file</li><li>Open the notebook</li><li>Type the following on a new cell, and run <pre><code>Pkg.add("JuMP")</code></pre></li><li>On the top ribbon, select cell &gt; run</li></ol>
Expected output:
<pre><code>
variable values: x: 1 dimensions, 4 entries:
[ brownies] = 0.0
[cheese cake] = 0.0
[ cola] = 0.9999999999999998
[ ice cream] = 3.0000000000000004
Objetive value: 0.9
</code></pre>
<p/>
<h2>Troubleshooting</h2>
<ul><li>Did you install Julia/JuMP properly?</li><li>Did your kernel fail? Kernel &gt; Restart kernel</li><li>Is your computer compatible with Julia?</li></ul>
</div>
<div class="action">
<input type="hidden" name="problem_id" value="Julia Verification" />
<div class="submit-attempt-container">
<button type="button" class="submit btn-brand" data-submitting="Submitting" data-value="Submit" data-should-enable-submit-button="True" aria-describedby="submission_feedback_0b894e5fe4bf4cb7803c62bae05d06b5" >
<span class="submit-label">Submit</span>
</button>
<div class="submission-feedback" id="submission_feedback_0b894e5fe4bf4cb7803c62bae05d06b5">
<span class="sr">Some problems have options such as save, reset, hints, or show answer. These options follow the Submit button.</span>
</div>
</div>
<div class="problem-action-buttons-wrapper">
</div>
</div>
<div class="notification warning notification-gentle-alert
is-hidden"
tabindex="-1">
<span class="icon fa fa-exclamation-circle" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="0b894e5fe4bf4cb7803c62bae05d06b5-problem-title">
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
<div class="notification warning notification-save
is-hidden"
tabindex="-1">
<span class="icon fa fa-save" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="0b894e5fe4bf4cb7803c62bae05d06b5-problem-title">None
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
<div class="notification general notification-show-answer
is-hidden"
tabindex="-1">
<span class="icon fa fa-info-circle" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="0b894e5fe4bf4cb7803c62bae05d06b5-problem-title">Answers are displayed within the problem
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
</div>
"
data-graded="False">
<p class="loading-spinner">
<i class="fa fa-spinner fa-pulse fa-2x fa-fw"></i>
<span class="sr">Loading…</span>
</p>
</div>
</div>
</div>
<div class="vert vert-2" data-id="block-v1:MITx+15.053x+3T2016+type@html+block@dd3ac0851d38408889cefdfcc35bc3c5">
<div class="xblock xblock-public_view xblock-public_view-html xmodule_display xmodule_HtmlBlock" data-request-token="5c94f8085af511ee8f44162ded714679" data-has-score="False" data-runtime-version="1" data-usage-id="block-v1:MITx+15.053x+3T2016+type@html+block@dd3ac0851d38408889cefdfcc35bc3c5" data-course-id="course-v1:MITx+15.053x+3T2016" data-runtime-class="LmsRuntime" data-init="XBlockToXModuleShim" data-graded="False" data-block-type="html">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "HTMLModule"}
</script>
<li><a class="modal-content" href="/assets/courseware/v1/2c55d5fc0aea3e453661c8438e69fc68/asset-v1:MITx+15.053x+3T2016+type@asset+block/overview_of_julia_and_jump.docx"> Overview of Julia and JuMP</a></li>
<li><a class="modal-content" href="/assets/courseware/v1/fd83febb05440dd84b88a220793d3218/asset-v1:MITx+15.053x+3T2016+type@asset+block/julia_basics.docx"> Julia Basics</a></li>
<li><a class="modal-content" href="/assets/courseware/v1/90c8040ad214292b2066a2dabff67df2/asset-v1:MITx+15.053x+3T2016+type@asset+block/knapsack_walkthrough.docx"> Knapsack Walkthrough</a></li>
<li><a class="modal-content" href="/assets/courseware/v1/f247f6141fa6859a0bed208ced6b25f2/asset-v1:MITx+15.053x+3T2016+type@asset+block/diet_problem_julia_walkthrough.docx"> Diet Problem Walkthrough</a></li>
<li><a class="modal-content" href="/assets/courseware/v1/2c207a817cf337956b7f474f25861498/asset-v1:MITx+15.053x+3T2016+type@asset+block/knapsack_problem_walkthrough.ipynb"> Knapsack Walkthrough Notebook</a></li>
<li><a class="modal-content" href="/assets/courseware/v1/bbbee46582406bd3cef533060c1e5dbf/asset-v1:MITx+15.053x+3T2016+type@asset+block/diet_problem_walkthrough.ipynb"> Diet Problem Walkthrough Notebook</a></li>
</div>
</div>
</div>
</div>
<div class="xblock xblock-public_view xblock-public_view-vertical" data-request-token="5c94f8085af511ee8f44162ded714679" data-has-score="False" data-runtime-version="1" data-usage-id="block-v1:MITx+15.053x+3T2016+type@vertical+block@953367dae213479b9ce1935e2a7d12c6" data-course-id="course-v1:MITx+15.053x+3T2016" data-runtime-class="LmsRuntime" data-init="VerticalStudentView" data-graded="False" data-block-type="vertical">
<h2 class="hd hd-2 unit-title">Solver</h2>
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:MITx+15.053x+3T2016+type@problem+block@c7e371945dc64392961e417c1fcf8f3d">
<div class="xblock xblock-public_view xblock-public_view-problem xmodule_display xmodule_ProblemBlock" data-request-token="5c94f8085af511ee8f44162ded714679" data-has-score="True" data-runtime-version="1" data-usage-id="block-v1:MITx+15.053x+3T2016+type@problem+block@c7e371945dc64392961e417c1fcf8f3d" data-course-id="course-v1:MITx+15.053x+3T2016" data-runtime-class="LmsRuntime" data-init="XBlockToXModuleShim" data-graded="False" data-block-type="problem">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "Problem"}
</script>
<div id="problem_c7e371945dc64392961e417c1fcf8f3d" class="problems-wrapper" role="group"
aria-labelledby="c7e371945dc64392961e417c1fcf8f3d-problem-title"
data-problem-id="block-v1:MITx+15.053x+3T2016+type@problem+block@c7e371945dc64392961e417c1fcf8f3d" data-url="/courses/course-v1:MITx+15.053x+3T2016/xblock/block-v1:MITx+15.053x+3T2016+type@problem+block@c7e371945dc64392961e417c1fcf8f3d/handler/xmodule_handler"
data-problem-score="0"
data-problem-total-possible="0"
data-attempts-used="0"
data-content="
<h3 class="hd hd-3 problem-header" id="c7e371945dc64392961e417c1fcf8f3d-problem-title" aria-describedby="block-v1:MITx+15.053x+3T2016+type@problem+block@c7e371945dc64392961e417c1fcf8f3d-problem-progress" tabindex="-1">
Solver Verification
</h3>
<div class="problem-progress" id="block-v1:MITx+15.053x+3T2016+type@problem+block@c7e371945dc64392961e417c1fcf8f3d-problem-progress"></div>
<div class="problem">
<div><h1>Microsoft Excel</h1><p>Here we will test proper functionality of the Solver Add-In in Microsoft Excel. After opening the <a class="modal-content" href="/assets/courseware/v1/2ca2c5a5418a64ba25115f91d156de2c/asset-v1:MITx+15.053x+3T2016+type@asset+block/Recitation0.xlsx"> Excel workbook,</a></p>
Mac
<ol><li>Enable solver via Tools &gt; Add-Ins &gt; check off Solver</li><li>On the top ribbon, Data &gt; Solver &gt; Solve</li></ol>
Windows
<ol><li>Enable Solver via File &gt; Options &gt; Add-Ins &gt; Excel Add-Ins &gt; Check off Solver &gt; OK </li><li>On the toolbar, Data &gt; Solver &gt; Solve</li></ol>
Expected output in cell C4:
<pre><code>
5
</code></pre>
<h2>Troubleshooting</h2>
<ul><li>Are macros enabled in Excel? Check tools &gt; Macro &gt; Macros</li><li>Does the model show up in your solver window?</li></ul>
</div>
<div class="action">
<input type="hidden" name="problem_id" value="Solver Verification" />
<div class="submit-attempt-container">
<button type="button" class="submit btn-brand" data-submitting="Submitting" data-value="Submit" data-should-enable-submit-button="True" aria-describedby="submission_feedback_c7e371945dc64392961e417c1fcf8f3d" >
<span class="submit-label">Submit</span>
</button>
<div class="submission-feedback" id="submission_feedback_c7e371945dc64392961e417c1fcf8f3d">
<span class="sr">Some problems have options such as save, reset, hints, or show answer. These options follow the Submit button.</span>
</div>
</div>
<div class="problem-action-buttons-wrapper">
<span class="problem-action-button-wrapper">
<button type="button" class="show problem-action-btn btn-default btn-small" aria-describedby="c7e371945dc64392961e417c1fcf8f3d-problem-title"><span class="icon fa fa-info-circle" aria-hidden="true"></span><span class="show-label">Show Answer</span></button>
</span>
</div>
</div>
<div class="notification warning notification-gentle-alert
is-hidden"
tabindex="-1">
<span class="icon fa fa-exclamation-circle" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="c7e371945dc64392961e417c1fcf8f3d-problem-title">
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
<div class="notification warning notification-save
is-hidden"
tabindex="-1">
<span class="icon fa fa-save" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="c7e371945dc64392961e417c1fcf8f3d-problem-title">None
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
<div class="notification general notification-show-answer
is-hidden"
tabindex="-1">
<span class="icon fa fa-info-circle" aria-hidden="true"></span>
<span class="notification-message" aria-describedby="c7e371945dc64392961e417c1fcf8f3d-problem-title">Answers are displayed within the problem
</span>
<div class="notification-btn-wrapper">
<button type="button" class="btn btn-default btn-small notification-btn review-btn sr">Review</button>
</div>
</div>
</div>
"
data-graded="False">
<p class="loading-spinner">
<i class="fa fa-spinner fa-pulse fa-2x fa-fw"></i>
<span class="sr">Loading…</span>
</p>
</div>
</div>
</div>
</div>
</div>
© All Rights Reserved