Numerical Calculations for Process Engineering Using Excel VBA

By: Chi M. Phan

Write A Review

Paperback | 27 November 2025 | Edition Number 1

At a Glance

Paperback
160 Pages

Dimensions(cm)
23.4 x 15.6 x 0.86

Paperback

RRP $112.00

$97.75

13%OFF

or 4 interest-free payments of $24.44 with

Ships in 3 to 5 business days

Numerical Calculations for Process Engineering Using Excel VBA provides numerical treatment of process engineering problems with VBA programming and Excel spreadsheets. The problems are solving material and energy balances, optimising reactors and modelling multiple-factor processes. The book includes both basic and advanced codes for numerical calculations. The basic methods are presented in different variations tailored to particular applications. Some macros are combined with each other to solve engineering problems. Examples include combining the bisection method and binary search to optimise an implicit correlation, combining golden section search with Euler's method to optimise a reactor and combining bisection code and Euler's method to solve steady-state heat distribution. The text also includes nonconventional examples such as harmony search and network analysis. The examples include solutions to common engineering problems such as adiabatic flame temperature, plug flow reactor conversion, batch reactor, heat diffusion and pinch analysis of heat exchanger networks. The VBA code is presented with mathematical equations and flowcharts, enabling the audience to adopt the solutions to different problems. The book contains many demonstrations of numerical techniques to guide users. It also includes useful summaries of VBA commands/functions and Excel-predefined functions accessible in VBA.

While the book is developed primarily for undergraduate students, the book is a helpful resource for postgraduate students and engineers.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.