O'Reilly logo

Separation Process Engineering: Includes Mass Transfer Analysis, Third Edition by Phillip C. Wankat

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix 4.B. Part 1. Introduction to Spreadsheets and VBA

Most engineering students are familiar with the use of spreadsheets, but they may not be familiar with the power of spreadsheets when they are coupled with VBA. VBA is an extremely useful programming language for controlling spreadsheets, Word, and other Microsoft programs. This short introduction focuses on use of VBA for spreadsheet calculations. The particular example is binary distillation, but the VBA programming method is applicable to many of the separation methods in this book. Readers interested in more information on VBA are referred to Microsoft (1999) or McFedries (2004).

Once you have learned to program with any language (MATLAB, Mathematica, FORTRAN, C, C++, or whatever) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required