Automation of processing the results of Laboratory studies of frozen and thawed soils soil research

Abstract

The work was carried out to create a computational system based on interconnected Excel workbooks for automating the processing of laboratory test data for frozen and thawed soils. An analysis was conducted of the software used in engineering surveys, which revealed their advantages and disadvantages, as well as the key requirements for the new system. Several factors negatively affecting or complicating workflows were identified: high labor intensity of manual operations, the risk of data entry errors, and low information processing speed. Based on the findings, comparisons were made between existing software solutions and the developed system, allowing for the identification of optimal automation approaches. As a result, an integrated automated system was developed, significantly improving the accuracy and speed of laboratory data processing while reducing the likelihood of errors in manual entry and calculations. The article details the key stages of system development, its structure, functionality, and user interface. Testing was performed using real laboratory research data, confirming the effectiveness of the proposed approach. The results demonstrate significant advantages of implementing the automated system in practice, enhancing the quality, reliability, and efficiency of frozen and thawed soil studies. In the future, the system's functionality is expected to be expanded for comprehensive data analysis.