Development of a Spreadsheet for the Design and Optimization of a Batch Distillation System

U radu je proveden razvoj proračunske tablice kao platforme za preliminarno projektiranje i optimizaciju industrijskog pogona temeljenog na šaržnom destilacijskom sustavu. Proračuni obuhvaćaju termoenergetsku analizu procesa te postupak dimenzioniranja šaržnog destilacijskog sustava i pomoćne opreme. Projektiranje destilacijskog sustava provedeno je pomoću McCabe-Thiele metode uz interpolaciju ravnotežnih podataka primjenom kubičnog B-spline. Interpolacija podataka, tipa B-spline, konstruirana je pomoću Visual Basic Aplikacije (VBA) unutar Microsoft Excela®. Provedeni proračuni nadograđeni su shemom destilacijskog procesa s provedenom rekuperacijom topline te shemom recirkulacije kondenzata u sustavu za proizvodnju ogrjevne pare. Razvijena proračunska tablica omogućava optimizaciju i simulaciju procesa u preliminarnoj fazi projektiranja čime se značajno unaprjeđuje proces izrade Tehnološkog projekta pogona za proizvodnju destilata.The objective of this work was to create a spreadsheet as a platform for preliminary design and optimisation of the industrial plant based on a batch distillation system. Also, a detailed thermo-energetic analysis, dimensioning of the batch distillation system and auxiliary equipment were performed. System dimensioning was performed using the McCabe-Thiele method with data interpolation of the equilibrium curve with cubic B-spline. The data interpolation of the cubic B-spline was performed using the Visual Basic Application (VBA) in Microsoft Excel®. The calculation was extended to include a process scheme performed with heat recovery and a scheme of condensate recirculation in the heating steam generation system. The spreadsheet allows for optimal design and simulation of the process and improvement in the development of the technological project of the plant for the production of distillates