Automating Excel Tasks with Generative AI: Supporting Innovation in Mass Transfer Separations Education

Abstract

VBA (Visual Basic for Applications) macro creation assisted by AI (Artificial Intelligence) can enhance the teaching of Mass Transfer Separations. The code can be iteratively refined until the desired functionality is achieved. This is not only intended to improve computational efficiency and accuracy but also to boost student engagement. To showcase the full potential of VBA scripting within spreadsheets, a simulator with an appealing interface was designed using Excel, such that optimal and limiting operating conditions were identified in an equilibrium-staged distillation column. Moreover, to underscore the pedagogical value of the approach at this exploratory stage of evaluating its educational scope, a much simpler classroom exercise was used to illustrate the hands-on integration of GenAI (Generative AI) into the learning process.