Creative Commons License 2018 Volume 5 Issue 3

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


Tatiana Mikhailova, Svetlana Mustafina, Vladimir Mikhailov, Sofia Mustafina
Abstract

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.


Share:
References

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.


Entomology and Applied Science Letters is an international double-blind peer reviewed publication which publishes scientific research & review articles related to insects that contain information of interest to a wider audience, e.g. papers bearing on the theoretical, genetic, agricultural, medical and biodiversity issues. Emphasis is also placed on the selection of comprehensive, revisionary or integrated systematics studies of broader biological or zoogeographical relevance. In addition to full-length research articles and reviews, the journal publishes interpretive articles in a Forum section, Short Communications, and Letters to the Editor. The journal publishes reports on all phases of medical entomology and medical acarology, including the systematics and biology of insects, acarines, and other arthropods of public health and veterinary significance.

Announcement and Advertisement
Announcements regarding scientific activities such as conferences, symposium, are published for free. Advertisements can be either published or placed on website as banners.
open access
Entomology and Applied Science Letters supports the submission of entomological papers that contain information of interest to a wider reader groups e. g. papers bearing on taxonomy, phylogeny, biodiversity, ecology, systematic, agriculture, morphology. The selection of comprehensive, revisionary or integrated systematics studies of broader biological or zoogeographical relevance is also important. Distinguished entomologists drawn from different parts of the world serve as honorary members of the Editorial Board. The journal encompasses all the varied aspects of entomological research.