基于VBA与MYSQL的电力设备电气试验数据自动处理与报告生成应用研究

Research on Automatic Processing and Report Generation Application of Electrical Equipment Test Data Based on VBA and Mysql

电力设备电气试验在电力系统中肩负着举足轻重的作用,随着电力基础设施的兴建,试验部门面临着数量可观而又重复的电力设备电气试验工作。针对试验工作人员在现场数据处理换算,以及大批量重复性报告工作存在困难,本文基于ExcelVBA建立试验数据现场自动处理模板,以及基于MYSQL建立数据库存储数据。使用该方法试验人员现场即可输入大量试验数据,自动换算与生成报告,并存入数据库,为设备状态分析提供了借鉴参考。

Electrical test of electrical equipment plays an important role in the power system. With the construction of power infrastructure, the test department is faced with a considerable and repeated electrical test of electrical equipment. It is difficult for the test staff to perform on-site data processing conversion and large-scale repetitive report work. This paper builds experimental data onsite automatic processing template based on EXCEL VBA, and builds database storage data based on Mysql. Using this method, the test personnel input a large amount of test data on site, automatically convert and survive the report, and store it in the database, which provides reference for equipment state analysis.