Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...

Articles Figures Tables About

Goal seek

As an alternative to using the eomputer program (PROG 16), Equation 8-162 ean be expressed in a spreadsheet. Using the GOAL-SEEK eommand from the Tools menu (Appendix B) from the Exeel spreadsheet menu to determine the Peelet number gives f(Npg) = 0. This funetion is ineorporated in the spreadsheet. The eomputed Peelet number is Np = 0.8638. [Pg.780]

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. [Pg.44]

The next step is to use the Ergun equation for the determination of the minimum fluidization velocity (eq. 3.451). For this step, we need a goal-seek procedure and the minimum fluidization velocity is found to be equal to 0.0057 cm/s, which is almost 10 times lower than the operation superficial velocity ... [Pg.508]

You can solve for equilibrium concentrations in a chemical reaction by first creating a table of initial and final concentrations of each species. Then find the final concentrations by systemic guessing with a spreadsheet or by using the Excel GOAL SEEK routine. [Pg.116]

Excel s Goal Seek Tool and Naming of Cells... [Pg.176]

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 ... [Pg.176]

L. We use goal seek to vary cell B5 until cell D4 is equal to Ka. [Pg.745]

Use the Goal Seek method described in Appendix D, Section D.l. If you wish, check your answer manually by putting your calculated % S02 oxidized in Eqn... [Pg.128]

This is confirmed by the Excel Goal Seek calculation in Appendix Table J.2. [Pg.149]

The Table J.2 Goal Seek calculation also shows that the intercept gas contains ... [Pg.149]

This is confirmed by a Goal Seek calculation in Table M.2. [Pg.180]

Fig. 19.5. Equilibrium curve, heatup path and heatup path-equilibrium curve intercept for after-intermediate-FESOj-making catalyst bed. Attainment of equilibrium in the catalyst bed gives 98.9% oxidation of the bed s input S02. The lines apply only to the graph s specified inputs and bed pressure. This graph is a blowup of Fig. 19.6. Its intercept is confirmed by a Goal Seek calculation in Appendix T. The S02 and 02 inputs are equivalent to 0.234 volume% S02 and 7.15 volume% 02. Fig. 19.5. Equilibrium curve, heatup path and heatup path-equilibrium curve intercept for after-intermediate-FESOj-making catalyst bed. Attainment of equilibrium in the catalyst bed gives 98.9% oxidation of the bed s input S02. The lines apply only to the graph s specified inputs and bed pressure. This graph is a blowup of Fig. 19.6. Its intercept is confirmed by a Goal Seek calculation in Appendix T. The S02 and 02 inputs are equivalent to 0.234 volume% S02 and 7.15 volume% 02.
Perhaps the simplest way to solve Eqn. (24.9) is by the following small Excel Goal Seek calculation. [Pg.276]

Table 12.1 is most easily interpolated when the equilibrium curve points have integer temperature values. These points are determined with Table D.l by means of Excel s Goal Seek tool, next page. [Pg.307]

The actual intercept value is determined by the Goal Seek calculation in Section J.4. [Pg.328]


See other pages where Goal seek is mentioned: [Pg.83]    [Pg.238]    [Pg.115]    [Pg.115]    [Pg.154]    [Pg.176]    [Pg.176]    [Pg.177]    [Pg.178]    [Pg.178]    [Pg.178]    [Pg.179]    [Pg.179]    [Pg.238]    [Pg.267]    [Pg.267]    [Pg.744]    [Pg.745]    [Pg.794]    [Pg.31]    [Pg.238]    [Pg.276]    [Pg.308]    [Pg.326]    [Pg.327]    [Pg.327]    [Pg.329]    [Pg.330]    [Pg.330]    [Pg.330]    [Pg.330]    [Pg.330]   
See also in sourсe #XX -- [ Pg.198 , Pg.340 ]




SEARCH



Acid temperature control Goal Seek

Efficiency) Goal Seek

Example of a Chemical Engineering Problem Solved Using Goal Seek

Excel goal seek and naming cells

Goal Seek calculations

Goal Seek calculations equilibrium curve

Goal Seek calculations heatup path-equilibrium curve

Goal Seek calculations intercept

Goal-seeking behavior

Industrial data Goal Seek

Solution Using Goal Seek

Solving a Problem Using Goal Seek

Solving equations with Excel goal seek

Spreadsheet Goal Seek

Using Excel to Solve Nonlinear Equations (Goal Seek)

© 2024 chempedia.info