How Do You Use Google Sheets To Do Row Operations For The Simplex Method?

In an earlier post, I showed how to set up a standard minimization problem from an application. In another post, I demonstrated how to find the corresponding dual maximization problem and to solve it with the Simplex Method. This algorithm is tedious and prone to arithmetic errors.

In the video below, the steps in the Simplex Methods are carried out in Google Sheets. The same steps can also be carried out in other spreadsheets such as Microsoft Excel.

Please note that there is a typo in the original matrix in the process. The cell in D2 should be a 1 instead of a zero to account for the slack variable in the first constraint.

Matrices with Technology

wolfram_01As you may have noticed, some matrix operations are very tedious by hand. In particular, matrix multiplication and matrix inverses are much easier to do using a graphing calculator or WolframAlpha. In the Weekly Learning Plan, I put several handouts to help you use your calculator to do these problems.

However, some of you do not have a graphing calculator…you’ll need to use WolframAlpha to carry out these operations.

Continue reading “Matrices with Technology”