Chemical Process Engineering Volume 1

Design, Analysis, Simulation, Integration, and Problem Solving with Microsoft Excel-UniSim Software for Chemical Engineers Computation, Physical Property, Fluid Flow, Equipment and Instrument Sizing

Rahmat Sotudeh-Gharebagh, A. Kayode Coker

• Publisher: Wiley-Scrivener
• Year: 2022
• ISBN:
  9781119510222
• Edition: 1
• Topic: Technologie et ingénierie
• Subtopic: Ingénierie

Written by two of the most prolific and respected chemical engineers in the world, this groundbreaking two-volume set is the "new standard" in the industry, offering engineers and students alike the most up-do-date, comprehensive, and state-of-the-art coverage of processes and best practices in the field today.

This first new volume in a two-volume set explores and describes integrating new tools for engineering education and practice for better utilization of the existing knowledge on process design. Useful not only for students, professors, scientists and practitioners, especially process, chemical, mechanical and metallurgical engineers, it is also a valuable reference for other engineers, consultants, technicians and scientists concerned about various aspects of industrial design.

The text can be considered as a complementary text to process design for senior and graduate students as well as a hands-on reference work or refresher for engineers at entry level. The contents of the book can also be taught in intensive workshops in the oil, gas, petrochemical, biochemical and process industries.

The book provides a detailed description and hands-on experience on process design in chemical engineering, and it is an integrated text that focuses on practical design with new tools, such as Excel spreadsheets and UniSim simulation software.

Written by two industry and university's most trustworthy and well-known authors, this book is the new standard in chemical, biochemical, pharmaceutical, petrochemical and petroleum refining. Covering design, analysis, simulation, integration, and, perhaps most importantly, the practical application of Microsoft Excel-UniSim software, this is the most comprehensive and up-to-date coverage of all of the latest developments in the industry. It is a must-have for any engineer or student's library.

1
Computations with Excel Spreadsheet-UniSim Design Simulation

Engineers, technologists, and scientists have employed numerical techniques to solve a wide range of steady-state and transient problems, and energy and material balance equations. The fundamentals are essential in the basic operations of these techniques and the requirements are greater when new processes are designed. Engineers also need theoretical information and data from the literature to construct mathematical models with proper hypotheses. These mathematical models, which consist of a massive set of linear and non-linear equations, can be solved using established numerical analysis tools and process simulators. Furthermore, developing mathematical models sometimes involves experimental plans to obtain the required data for the models. Preparing an experimental plan is strongly dependent on the knowledge of the process with theory, where the whole modification can be produced by some form of mathematical models or regression analyses. This chapter deals with these important issues for chemical and process engineers in two sections:

Section I: This section covers the modeling and numerical analysis with the Excel spreadsheet program which deals with curve fitting, approximation, interpolation, numerical solutions of simultaneous linear and nonlinear equations, and numerical differentiation and integration.

Section II: This section covers process simulation using UniSim Design software which deals with the property estimation, equipment and process design, and case studies.

These two tools (the Excel spreadsheet and UniSim Design software) are introduced in this chapter and are used throughout the book to ease calculations related to process design and analysis. In this way, students and engineers can save time by using hands-on tools to ease the calculations and concentrate on the fundamental understanding of the phenomena occurring in the process design sequences.

SECTION I - NUMERICAL ANALYSIS

INTRODUCTION

Excel Spreadsheet

Microsoft Excel is part of the Microsoft Office. The Excel spreadsheet is today’s leading software for problem solving which enables a chemical engineer to make computations and visualizations in the easiest way. Most people often use the Excel spreadsheet program for business or financial purposes, but it is also a powerful and versatile tool that can be used for a wide variety of chemical engineering applications and numerical analysis. One of its key benefits is bringing techno-economic information together. Process engineers can use the Excel spreadsheet for equipment and process design, modeling, simulation and optimization. Databases and pivot tables can be easily designed with the Excel sprea...