Example of a Chemical Engineering Problem Solved Using Goal Seek

Example of a Chemical Engineering Problem Solved Using Goal Seek  

Find the specific volume of n-butane at 500 K and 18 atm using the Redlich-Kwong equation of state. 

Step 1 You must first find the critical temperature and pressure Perry s Chemical Engineers Handbook gives = 425.2 K and p = 37.5 atm. 

Step 4 You enter the parameters in the parameter box. The cells containing the critical parameters and the temperature and pressure can be named T., Pc, T, and p, respectively. That way, the equation for/it ) will be easier to understand. 

Step 5 The lower box gives the equations actually used as well as the results. Use the Goal Seek command to make/(y) (cell F32) equal to zero by changing cell v (F31). 

---