Burk TechnoEconomics Blog

Pro Tip: Searchable Excel Stream Tables with VBA

Note: This article was originally published in AIChE's ChEnected blog. The astute process engineer loves building stream tables in Excel. They find nothing so satisfying. Their enthusiasm is squandered, though, as they start using the data in further calculations. Hunting and pecking for the correct cell reference is slow, prone to error, and, in several other ways, uncivilized. It is for times like these that Microsoft gave us VBA. Stream tables in Excel One of the first steps in process and economic modeling in Excel is to build a process stream table based on user input. The stream table neatly aggregates material and energy balance data for use in further calculations, for example, in es

© 20202 by Burk TechnoEconomics

Lee_Site_Logo transparent 2.png