Chemical Process Engineering: Design, Analysis, Simulation and Integration, and Problem Solving With Microsoft Excel – UniSim Design Software, Volume 1: Computation, Physical Property, Fluid Flow, Equipment and Instrument Sizing, Pumps and Compressors, Ma

531 Pages·2022·130.399 MB·English

by  A. Kayode Coker, Rahmat Sotudeh-Gharebagh

Volume 1
Chemical Process Engineering
Design, Analysis, Simulation and Integration, and Problem
Solving With Microsoft Excel – UniSim Design Software
Computation, Physical Property, Fluid Flow, Equipment &
Instrument Sizing, Pumps & Compressors, Mass Transfer
Scrivener Publishing
100 Cummings Center, Suite 541J
Beverly, MA 01915-6106
Publishers at Scrivener
Martin Scrivener ([e-mail])
Phillip Carmical ([e-mail])
Volume 1
Chemical Process Engineering
Design, Analysis, Simulation and Integration, and Problem
Solving With Microsoft Excel – UniSim Design Software
Computation, Physical Property, Fluid Flow, Equipment &
Instrument Sizing, Pumps & Compressors, Mass Transfer
A. Kayode Coker and Rahmat Sotudeh-Gharebagh
This edition first published 2022 by John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, USA and Scrivener Publishing LLC, 100 Cummings Center,
Suite 541J, Beverly, MA 01915, USA
© 2022 Scrivener Publishing LLC
For more information about Scrivener publications please visit www.scrivenerpublishing.com.
All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechan-
ical, photocopying, recording, or otherwise, except as permitted by law. Advice on how to obtain permission to reuse material from this title is available at http://
www.wiley.com/go/permissions.
Wiley Global Headquarters
111 River Street, Hoboken, NJ 07030, USA
For details of our global editorial offices, customer services, and more information about Wiley products visit us at www.wiley.com.
Limit of Liability/Disclaimer of Warranty
While the publisher and authors have used their best efforts in preparing this work, they make no rep resentations or warranties with respect to the accuracy
or completeness of the contents of this work and specifically disclaim all warranties, including without limitation any implied warranties of merchant-a bility
or fitness for a particular purpose. No warranty may be created or extended by sales representa tives, written sales materials, or promotional statements for this
work. The fact that an organization, website, or product is referred to in this work as a citation and/or potential source of further informa tion does not mean
that the publisher and authors endorse the information or services the organiza tion, website, or product may provide or recommendations it may make. This
work is sold with the understanding that the publisher is not engaged in rendering professional services. The advice and strategies contained herein may not be
suitable for your situation. You should consult with a specialist where appropriate. Neither the publisher nor authors shall be liable for any loss of profit or any
other commercial damages, including but not limited to special, incidental, consequential, or other damages. Further, readers should be aware that websites
listed in this work may have changed or disappeared between when this work was written and when it is read.
Library of Congress Cataloging-in-Publication Data
ISBN 9781119510185
Cover image: Chemical Plant - Slidezero | Dreamstime.com
Cover background: Flowing Image - Mikhail Sheleh | Dreamstime.com
Cover design by Kris Hackerott
Set in size of 11pt and Minion Pro by Manila Typesetting Company, Makati, Philippines
Printed in the USA
10 9 8 7 6 5 4 3 2 1
Companion Web Page
This 2-volume set includes access to its companion web page, from which can be downloaded useful software,
spreadsheets, and other value-added products related to the books. To access it, follow the instructions below:
1. Go to https://scrivenerpublishing.com/coker_volume_one/
2. Enter your email in the username field
3. Enter “Refining” in the password field

Gratitude
To the Almighty father for providing us with the abundance of nature, so that human beings can further develop and
make use of the many things in nature for our well-being and for the world.
To all process/chemical engineers worldwide utilizing this abundance of nature for the good of mankind.
Keep the heart of your thoughts pure, by so doing you will bring peace and be happy
To honour God in all things and to perform everything solely to the glory of God
Abd-ru-shin
(In the Light of Truth)
A. Kayode Coker
Dedication
“I am always obliged to a person who has taught me a single word.”
In memory of my late father and to my respected family for their endless support
To engineers and scientists for their commitment to inclusion and sustainability
R. Sotudeh-Gharebagh

Contents
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
ix