Transcription of Excel Solutions to the Chemical Engineering Problem Set
{{id}} {{{paragraph}}}
Example: bachelor of science
Excel Solutions to the Chemical Engineering Problem Set
Page EX-1 Excel Solutions to the Chemical EngineeringProblem SetEdward M. RosenEMR Technology Group13022 Musket Ct. St. Louis, Mo. 63146E-mail: 314-434-5498 IntroductionThese Solutions are to the problems given in Reference (1) which were presented at the ASEEC hemical Engineering Summer School held in Snowbird, Utah on August 13, version (part of Microsoft s Office 95) was used to solve all the use was made of Visual Basic for Applications which is part of Excel . User definedfunction were written (in VBA) to carry a number of functions including the numerical integrationof differential equations (4th order Runge-Kutta method). Use was also made of the solver andGoal Seek programs routines that are supplied as add-ins with Excel EX-2 Excel Problem 1 Solution(a)Use was made of Goal Seek to find the value of V to force the difference between the right andleft sides of Ex_Eq (1-1) to zero.(P + a/V2)(V-b) - RT = 0 Ex_Eq (1-1)wherea = (27/64) (R2Tc2/Pc) Ex_Eq (1-2)b = (RTc)/(8Pc) Ex_Eq (1-3)(b) and (c)Changing the value of Pr changes the value of P = Pr*Pc.
Page EX- 6 Excel Problem 4 Solution EX Spreadsheet (4-1) was set up so that the problem could be solved using Solver. The objective function was taken (arbitrarily) as the sum of squares of the three equilibrium equations:
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: