Unformatted text preview: Set the constraints as the other equations, i.e. cell C21=1, and cell C22=1.2 Equation RHS of equation 0.25 1 y+z=1.2 1.2 Values of the unknowns (must provide initial guesses to start the process): x y z 0.46 0.78 0.42 these are the final iterated values, which satisfy the constraints. Verify: First equation: 0.25 Second equation: 1 Third equation: 1.2 Tools-Add-Ins-Solver Add-in-OK Tools-Solver . Solve , and OK (the Keep Solver Solution option should be the default). x-cos(2 π y) = 0.25 x 2 +y 2 +z 2 =1...
View Full Document
- Fall '07
- Equations, Expression, Elementary algebra, J. M. Cimbala, simultaneous equation solver