Skip to main content
  • Textbook
  • © 2018

A Step by Step Approach to the Modeling of Chemical Engineering Processes

Using Excel for simulation

  • Teaches even lower undergraduate students how to develop mathematical models by using an easy step-by-step approach

  • Uses the basic yet powerful tool Excel to simulate Chemical Engineering Processes

  • Shows how to model and simulate either simple or complex systems in a very straightforward way compared to what is available in competing literature

Buy it now

Buying options

eBook USD 49.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 64.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book USD 89.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (8 chapters)

  1. Front Matter

    Pages i-xvii
  2. Introduction

    • Liliane Maria Ferrareso Lona
    Pages 1-3
  3. The Recipe to Build a Mathematical Model

    • Liliane Maria Ferrareso Lona
    Pages 5-11
  4. Lumped-Parameter Models

    • Liliane Maria Ferrareso Lona
    Pages 13-48
  5. Distributed-Parameter Models

    • Liliane Maria Ferrareso Lona
    Pages 49-87
  6. Solving an Algebraic Equations System

    • Liliane Maria Ferrareso Lona
    Pages 89-111
  7. Solving an Ordinary Differential Equations System

    • Liliane Maria Ferrareso Lona
    Pages 113-144
  8. Solving a Partial Differential Equations System

    • Liliane Maria Ferrareso Lona
    Pages 145-169
  9. Back Matter

    Pages 171-173

About this book

This book treats modeling and simulation in a simple way, that builds on the existing knowledge and intuition of students. They will learn how to build a model and solve it using Excel.

Most chemical engineering students feel a shiver down the spine when they see a set of complex mathematical equations generated from the modeling of a chemical engineering system. This is because they usually do not understand how to achieve this mathematical model, or they do not know how to solve the equations system without spending a lot of time and effort.

Trying to understand how to generate a set of mathematical equations to represent a physical system (to model) and solve these equations (to simulate) is not a simple task. A model, most of the time, takes into account all phenomena studied during a Chemical Engineering course. In the same way, there is a multitude of numerical methods that can be used to solve the same set of equations generated from the modeling, and many different computational languages can be adopted to implement the numerical methods. As a consequence of this comprehensiveness and combinatorial explosion of possibilities, most books that deal with this subject are very extensive and embracing, making need for a lot of time and effort to go through this subject. 

It is expected that with this book the chemical engineering student and the future chemical engineer feel motivated to solve different practical problems involving chemical processes, knowing they can do that in an easy and fast way, with no need of expensive software.

Authors and Affiliations

  • School of Chemical Engineering, University of Campinas, Campinas, Brazil

    Liliane Maria Ferrareso Lona

About the author

Liliane Lona has degree (1991), master's (1994) and PhD (1996) in Chemical Engineering from the University of Campinas (Unicamp). She developed postdoctoral studies at the Institute for Polymer Research at the University of Waterloo - Canada (2002). Her master's and PhD were related to modelling and simulation of petrochemical processes and her post-doctoral studies in the area of modelling, simulation and optimization of polymerization reactors. In 1996 Liliane became professor at School of Chemical Engineering - Unicamp and in 2010 she became full professor in the area of analysis and simulation of chemical process. Liliane Lona taught for more than 20 times an undergraduate course related to the area of this book. She supervised dozens of grade and undergraduate students in the modeling and simulation area, and many of this works received awards, such as i) BRASKEM/ Brazilian Association of Chemical Engineering Award (2007), ii) Petrobras Award Pipeline Technology (2000 and 2003), iii) Regional Council of Chemistry Award (2000). Liliane published many scientific papers in qualified journals and was postgraduate coordinator (2006-2010) and Director (2010-2014) of the Chemical Engineering School – Unicamp.

Bibliographic Information

Buy it now

Buying options

eBook USD 49.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 64.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book USD 89.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access