Asee peer logo

Visual Basic Software For Design And Performance Problems

Download Paper |

Conference

2008 Annual Conference & Exposition

Location

Pittsburgh, Pennsylvania

Publication Date

June 22, 2008

Start Date

June 22, 2008

End Date

June 25, 2008

ISSN

2153-5965

Conference Session

ChE Poster Session

Tagged Division

Chemical Engineering

Page Count

18

Page Numbers

13.1388.1 - 13.1388.18

Permanent URL

https://peer.asee.org/3156

Download Count

99

Request a correction

Paper Authors

biography

Noah Brak West Virginia University

visit author page

Noah Brak is an undergraduate student studying chemical engineering at West Virginia University.

visit author page

biography

Joseph Shaeiwitz West Virginia University

visit author page

Joseph A. Shaeiwitz received his B.S. degree from the University of Delaware and his M.S. and Ph.D. degrees from Carnegie Mellon University. His professional interests are in design, design education, and outcomes assessment. Joe is an associate editor of the Journal of Engineering Education, and he is a co-author of the text Analysis, Synthesis, and Design of Chemical Processes (2nd ed.), published by Prentice Hall in 2003.

visit author page

biography

Richard Turton West Virginia University

visit author page

Richard Turton received his B.S. degree from the University of Nottingham and his M.S. and Ph.D. degrees from Oregon State University. His research interests are include fluidization and particle technology and their application to particle coating for pharmaceutical applications. Dick is a co-author of the text Analysis, Synthesis, and Design of Chemical Processes (2nd ed.), published by Prentice Hall in 2003.

visit author page

Download Paper |

Abstract
NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract

Visual Basic Software for Design and Performance Problems Introduction

Most chemical engineering textbooks still show graphical solutions for certain routine design calculations. The Moody plot for friction factors, which is based on experimental data, and the corresponding plots for flow past submerged objects are examples. However, in recent years, curve fits for these have yielded equations that are at least as accurate as reading a graph. Graphs of the Kremser and Colburn equations for separations in dilute systems are another example; although, these equations were derived in order to construct the plots. For heat exchangers, the log-mean-temperature-difference (LMTD) correction factor is generally read from a graph since most textbooks do not provide the appropriate equations, even though the graphs are obtained from these equations.

If the equations are used, it is possible to obtain the information found on the graph and to do design and performance calculations more accurately by means of a computer program. In this paper, we describe Visual Basic for Applications (VBA) programs written for the following design problems: flow in pipes, flow past submerged objects (including packed and fluidized beds), separation in dilute systems, and heat exchangers. The programs not only find the parameters usually obtained from a graph (friction factor, drag coefficient, absorption or stripping factor, LMTD correction factor) but they also perform routine design and performance calculations. The definitions used here are that a design calculation is used to determine the size of a unit with a given input and a desired output, and a performance calculation is used to determine the output of a unit with a given input and a given size.

These programs are not meant to replace process simulators; they are meant to be teaching tools that are more accessible to students than process simulators.

Description of Programs

Table 1 summarizes the programs that will be available for demonstration. Additional details of each program follow.

Separation in Dilute Systems

The relationships used are the Kremser equation1

y A,out − y* , out A 1− A = (1) y A,in − y* ,out A 1 − A N +1

if A = 1

y A,out − y* , out A 1 = (2) y A,in − y* , out A N +1

Brak, N., & Shaeiwitz, J., & Turton, R. (2008, June), Visual Basic Software For Design And Performance Problems Paper presented at 2008 Annual Conference & Exposition, Pittsburgh, Pennsylvania. https://peer.asee.org/3156

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2008 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015