The processing of the input and output files of quantum chemical calculations often necessitates a spreadsheet as a key component of the workflow. Spreadsheet packages with a built-in programming language editor can automate the steps involved and thus provide a direct link between processing files and the spreadsheet. This helps to reduce user-interventions as well as the need to switch between different programs to carry out each step. The ExcelAutomat tool is the implementation of this method in Microsoft Excel (MS Excel) using the default Visual Basic for Application (VBA) programming language. The code in ExcelAutomat was adapted to work with the platform-independent open-source LibreOffice Calc, which also supports VBA. ExcelAutomat provides an interface through the spreadsheet to automate repetitive tasks such as merging input files, splitting, parsing and compiling data from output files, and generation of unique filenames. Selected extracted parameters can be retrieved as variables which can be included in custom codes for a tailored approach. ExcelAutomat works with Gaussian files and is adapted for use with other computational packages including the non-commercial GAMESS. ExcelAutomat is available as a downloadable MS Excel workbook or as a LibreOffice workbook.

The distortion/interaction-activation strain model (D/I-ASM), a fragment analysis method, is applied to study the structure-reactivity relationship in reactions. The application of D/I-ASM involves the generation of input files for points along a reaction profile, submission of input files to a quantum software package, processing of parameters from the resulting output files and generation of graphical plots. The ExcelAutomat tool (Laloo et al., J. Comput. Aided Mol. Des. 2017, 31, 667) provides a framework and library in Visual Basic for Application programming language to process such files. New routines were written in ExcelAutomat 1.3 to facilitate processing of files for D/I-ASM. The worksheet "ASM" was included where initial parameters needed can be defined. The routines for D/I-ASM were tested successfully on bimolecular nucleophilic substitution, cycloaddition, and barrierless reactions. The automation of fragment analysis by ExcelAutomat 1.3 is compatible with Microsoft Excel and LibreOffice Calc. The extensible tool processes files from Gaussian and GAMESS-US packages.