Problem Solving with Microsoft Excel-UniSim Software for Chemical Engineers
Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.
A. Kayode Coker, PhD, is an engineering consultant for AKC Technology, an honorary research fellow at the University of Wolverhampton, UK, a former engineering coordinator at Saudi Aramco Shell Refinery Company, and chairman of the Department of Chemical Engineering Technology at Jubail Industrial College, Saudi Arabia. He has been a chartered chemical engineer for more than 30 years. He is a fellow of the Institution of Chemical Engineers, UK, and a senior member of the American Institute of Chemical Engineers. He holds a BSc honors degree in chemical engineering, a master of science degree in process analysis and development and PhD in chemical engineering, all from Aston University, Birmingham, UK, and a Teacher's Certificate in Education at the University of London, UK. He has directed and conducted short courses extensively throughout the world and has been a lecturer at the university level. His articles have been published in several international journals. He is an author of seven books in chemical engineering, a contributor to the Encyclopedia of Chemical Processing and Design, Vol 61 and a certified train-the-mentor trainer. He is also a technical report assessor and interviewer for chartered chemical engineers (IChemE) in the U.K. He is a member of the International Biographical Centre in Cambridge, UK, is in "Leading Engineers of the World for 2008." He is also a member of "International Who's Who of ProfessionalsTM" and "Madison Who's Who in the U.S." Rahmat Sotudeh-Gharebaagh, PhD, is a full professor of chemical engineering at the University of Tehran. He teaches process modeling and simulation, transport phenomena, plant design and economics and soft skills. His research interests include computer-aided process design and simulation, fluidization, and engineering education. He holds a BEng degree in chemical engineering from Iran's Sharif University of Technology, plus a MSc and a PhD in fluidization engineering from Canada's Polytechnique. He has been an invited Professor at Qatar University and Polytechnique de Montréal. Professor Sotudeh has more than 300 publications in major international journals and conferences, plus four books and four book chapters. He is the co-founder and editor-in-chief of the journal, Chemical Product and Process Modeling, a member of the Iranian Elite Foundation, and an official expert (OE) on the oil industry with the Iranian Official Expert Organization.
Inhaltsangabe
Preface xvii
Acknowledgments xix
About the Authors xxi
1 Computations with Excel Spreadsheet-UniSim Design Simulation 1
Section I - Numerical Analysis 1
Introduction 1
Excel Spreadsheet 1
Functions 2
Trendline Coefficients 2
Goal Seek 5
Solver 6
Linear Regression 7
Measuring Regression Quality 9
Multiple Regression 9
Polynomial Regression 11
Simultaneous Linear Equations 11
Nonlinear Equations 12
Interpolations 13
Integrations 14
The Trapezoidal Rule 14
Simpson's 1/3 Rule 15
Simpson's 3/8 Rule 15
Differential Equations 15
Nth Order Ordinary Differential Equations 15
Solution of First-Order Ordinary Differential Equations 15
Runge-Kutta Methods 16
Examples and Solutions 17
Section II - Process Simulation 28
Introduction 28
Thermodynamics for Process Simulators 29
UNISIM Design Software 30
Examples and Solutions 31
References 78
2 Physical Property of Pure Components and Mixtures 81
Pure Components 81
Density of Liquid 82
Viscosity of Liquid 83
Heat Capacity of Liquid 85
Thermal Conductivity of Liquid 87
Volumetric Expansion Rate 90
Vapor Pressure 91
Viscosity of Gas 93
Thermal Conductivity of Gas 94
Heat Capacity of Gases 95
Mixtures 97
Surface Tensions 98
Viscosity of Gas Mixture 99
Enthalpy of Formation 101
Enthalpy of Vaporization 103
Gibbs Energy of Reaction 105
Henry's Law Constant for Gases in Water 107
Coefficient of Thermal Expansion of Liquid 108
Diffusion Coefficients 109
Gas-Phase Diffusion Coefficients 109
Liquid-Phase Diffusion Coefficients 110
Compressibility Z-factor 111
Solubility and Adsorption 116
Solubility of Hydrocarbons in Water 116
Solubility of Gases in Water 117
Solubility of Sulfur and Nitrogen Compounds in Water 118
Adsorption on Activated Carbon 119
References 119
3 Fluid Flow 121
Introduction 121
Flow of Fluids in Pipes 121
Equivalent Length of Various Fittings and Valves 123
Excess Head Loss 123
Pipe Reduction and Enlargement 124
Pressure Drop Calculations for Single-phase Incompressible Fluids 124
Friction Factor 127
Overall Pressure Drop 128
Nomenclature 130
Compressible Fluid Flow in Pipes 130
Maximum Flow and Pressure Drop 131
Critical or Sonic Flow and the Mach Number 131
Mach Number 132
Mathematical Model of Compressible Isothermal Flow 134
