Numerical Methods (E)

← ChE 555: Applied Mathematics & Modeling for Chemical Engineers

  • Solution of balances (simultaneous equations) on spreadsheet using EXCEL's SOLVER. 555 03a A: Select "Solver" from the "Tools" menu. Clear contents of all boxes, if they are not empty. Press the "Add" button to specify the right-hand sides (RHS) of the balance equations to zero (constraints). 555 03b B: Select each RHS cell by mouse. Select "=" as the constraint type (middle box). Set RHS value to zero (key in). Press the "Add" button for each equation, however, when you enter the last equation, press "OK". 555 03c C: Specify the variables (unknowns) by first having the cursor in the "By Changing Cells" box. Then, select cells B16 through E16 by mouse. 555 03d D: Fill in the suggested Solver Options (optional). 555 03do E: Press the "Solve" button to start the solver iterations. Check the RHS values; are they all zero (or very close to zero) ? See the final (converged) values of the variables (values of the unknowns); are they reasonable ? 555 03e