Solution Using Goal Seek

Step 1 Open a spreadsheet and put the following statement in cell B1  

Cell BI is the equation that should be zero, and cell Al contains the variable that is adjusted to make this happen. 

Step 2 Under Tools choose Goal Seek. When a smaU screen appears, fiU in the spaces to show the following  

Thus the solution found is -2, with a tiny error - a small fraction of a percent. The test of whether the calculation is correct is shown in cell BI, which is 4.1 x 10 . This is not zero, but it is smaU enough for most purposes. 

Step 4 If you want to decrease the tolerance to make the solution more accurate, under Tools and Options choose Calculation. Then, in Maximum Change add a few zeros in the middle (changing it from 0.001 to 0.000001), add a zero to the maximum number of iterations, choose OK, and repeat the Goal Seek. This time the answer is 

---

The Wegstein method is a secant method applied to g(x) = x - Fix). In Microsoft Excel, roots are found by using Goal Seek or Solver. Assign one cell to be x, put the equation for/(x) in another cell, and let Goal Seek or Solver find the value of x that makes the equation cell zero. In MATLAB, the process is similar except that a function (m-file) is defined and the command fzeroCf .xO) provides the solution x, starting from the initial guess xO. 

This equation can conveniendy be solved for for any specified value of using the formula for solution of quadratic equations, or by using Goal Seek or Solver in a spreadsheet. Note that the effective equilibrium parameter in Eq. 118-431 is (K g Crj/Ct). Since the total concentration in the fluid can easily be changed, this effective equilibrium parameter can be changed. This behavior is illustrated in Exanple 18-8 and Figure 18-19. 

Table F.l shows the preliminary steps for this solution. From Figure 10.8 we see that this temperature and pressme correspond to a point on the vapor-liquid equilibrium curve for propane, so we should look for three solutions to Eq.F. 13. Table F.2 shows all of those. The procedure is to guess a value of z, and then numerically solve Eq. F.13 (using goal seek on a spreadsheet or any other suitable...

We saw in Section 6-8 that GOAL SEEK finds solutions to numerical equations. In setting up Equation 9-22, we made the (superb) approximation [H+] [OH ] and neglected [OH ]. With goal SEEK, it is easy to use Equations 9-20 and 9-21 without approximations ... 

It is solved by selecting values of proton activities at given partial pressure of CO. In MS Excel for this purpose are used programs Goal Seek or Solver (Data). The solution of this equation for different values... 

Since the use of the simulator requires the solution of different problems, several different problems are formulated in the Problem Solution Visual Basic Module. Their solution is based on the simplest problem of the process model worksheet above, and uses the Solver or the Goal Seek utilities of Excel via a Visual Basic program, to obtain a solution for the alternative problems. 

So-called multidimensional NMR techniques can provide important information about macromolecular conformation. In these cases, the sequence of a protein is aheady known, and establishing covalent connectivity between atoms is not the goal. Rather, one seeks through-space information that can reveal the solution conformation of a protein or other macromolecule. Two-or three-dimensional techniques use pulses of radiation at different nuclear frequencies, and the response of the spin system is then recorded as a free-induction decay (FID). Techniques like COSY and NOESY allow one to deduce the structure of proteins with molecular weights less than 20,000-25,000. 

All pesticide chemists liave their own objectives and ways to accomplish them. The ultimate objective on a broad basis is to seek the truth and to understand the nature of chemicals and their interaction with living systems, the most important of which is the human being. Tliis broad ultimate goal is represented by a governmental (people) effort to regulate chemicals. This has been applied to chemicals used as drugs, chemicals used as pesticides, and now, all chemicals. The problems that are discussed for pesticides exist for all chemicals, and the solutions to solve problems in the biochemistry of pesticides will apply to other chemicals as well. 

Products should be such that users can build tacit knowledge with respect to needs and solutions. This is important as I seek to explore how employees leverage knovdedge that they acquired by use inside the producer firm. High product involvement, intensive and extensive use, and moderate technological complexity are favorable to this goal (Raasch et al. 2008). 

---