Automation of Control's Process of Macro of Microsoft Excel File for Data Processing of Chemical Experiments

In this paper, an approach for experimental data processing using Microsoft Excel was proposed. The experimental data was automatically transferred to a common file using the developed macro. An application was developed to accelerate the operation of the macro and reuse it. The structure of the macro was described in the paper. The created approach can be applied in tasks that require the storage of a large statistical data volume. Testing of approach was carried out on the results of chemical experiments.

Mustafina S., Miftakhov E. and Mikhailova T. Solving the direct problem of butadiene-styrene copolymerization. International Journal of Chemical Sciences 2014; 12(2): 564-572.

Mustafina S., Miftakhov E. and Mikhailova T. Mathematical Simulation Study of Copolymer Composition and Compositional Heterogeneity during The Synthesis of Emulsion-type Butadiene-Styrene Rubber. International Journal of Chemical Sciences 2014; 12(4): 1135-1144.

Mustafina S., Mikhailova T. and Miftakhov E. Mathematical Study of the butadiene-styrene copolymerization product by the Monte-Carlo method // International Journal of Chemical Sciences 2015; 13(2): 849-856.

Mikhailova T., Miftakhov E. and Mustafina S. Mathematical Simulation of the Styrene-Butadiene Rubber’s Production in the Cascade of Reactors by the Monte-Carlo Method. International Journal of Chemical Sciences 2016; 14(4): 1865-1876.

Rawlings J.B., Ekerdt J.G. Chemical Reactor Analysis and Design Fundamentals. Nob Hill Publishing: Madison, 2012.

Automate tasks with the Macro Recorder: [Electronic resource] // Office Help & Traning. URL: https://support.office.com/en-us/article/automate-tasks-with-the-macro-recorder-974ef220-f716-4e01-b015-3ea70e64937b?ui (date of the application: 15.08.2018).

Getting Started with VBA in Excel 2010 [Electronic resource] // Microsoft Docs. URL: https://docs.microsoft.com/en-us/previous-versions/office/developer/office-2010/ee814737(v=office.14) (date of the application: 15.08.2018).

Microsoft.Office.Interop.Excel Namespace [Electronic resource] // Microsoft Docs. URL: https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.interop.excel?view=excel-pia (date of the application: 15.08.2018).

Mikhailova T., Miftakhov E. and Mustafina S. Study of the chain transfer agent's effect on the butadiene-styrene copolymer's properties based on the Monte-Carlo method. CEUR Workshop Proceedings. Proceedings of the Mathematical Modeling Session at the International Conference Information Technology and Nanotechnology (MM-ITNT 2017), 2017; V. 1904: 289-292.