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 ([email protected]) Phillip Carmical ([email protected]) 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