Numerical Calculations for Process Engineering Using Excel VBA

Chi M. Phan

Informasi Umum

Kode

24.21.164

Klasifikasi

670.285 - Data Processing and Analysis of Manufacturing

Jenis

Buku - Elektronik (E-Book)

Subjek

Production Engineering

No. Rak

Tel-U Bandung - Gedung Manterawu Lantai 5 : Rak 23
Tel-U Purwokerto : Rak 8

Dilihat

179 kali

Informasi Lainnya

Abstraksi

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.