DESENVOLVIMENTO DE SOFTWARE DE SIMULAÇÃO EM LINGUAGEM EXCEL/VBA: PROCESSO DE PRODUÇÃO BIOTECNOLÓGICA DE ETANOL

Abstract

Advances in computational power have achieved great technological feats in the productive world, modeling and simulation of processes is an example of this, as they are efficient and low cost, they serve as an important tool in planning and execution of several processes, as well as a teaching tool. This work aims to provide a program capable of simulating the alcoholic fermentation phenomenon in Visual Basic for Application (VBA) language in Microsoft Excel from a semi-empirical modeling with a simple and accessible interface. The program simulates the alcoholic fermentation process on a CSTR reactor without cell recycling and shows calculations such as mass and energy balance.