Excel Solver Template. Click the by changing cells box and then point to the range d2:i2, which contains the pounds produced of each drug. Furthermore, it includes a shannon entropy example that can be extended for your problem up to 250 criteria and 250 alternatives.
The template provided in this course is required by excel for solver to work proerly. Step 3 select cell $b$11 to $f$11 to fill the field by changing variable cells. Solve linear programming through excel solver to apply solver, go to the data tab and click on “solver” we will see below the window.