ExcelAutomat: a tool for systematic processing of files as applied to quantum chemical calculations
Na minha lista:
| Publicado no: | Journal of Computer - Aided Molecular Design vol. 31, no. 7 (Jul 2017), p. 667 |
|---|---|
| Autor principal: | |
| Outros Autores: | , , |
| Publicado em: |
Springer Nature B.V.
|
| Assuntos: | |
| Acesso em linha: | Citation/Abstract Full Text - PDF |
| Tags: |
Sem tags, seja o primeiro a adicionar uma tag!
|
| Resumo: | Abstract 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. Graphical abstract [Figure not available: see fulltext.] |
|---|---|
| ISSN: | 0920-654X 1573-4951 |
| DOI: | 10.1007/s10822-017-0031-8 |
| Fonte: | Science Database |