Transcription of Excel Solutions to the Chemical Engineering Problem Set
{{id}} {{{paragraph}}}
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).
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:
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}