摘要
广州地区电网调度集控自动化系统采用了两套不同的异构系统,厂站接入和数据维护工作量很庞大。自动化系统厂家所提供的Excel信息点表数据需要进行格式转换,同时在接入系统之前需要审查信息点表数据,以尽可能提高数据的质量。针对原有审查和转换方法过多地依赖于人工操作,存在效率不高和质量难于保证的缺点,利用VC++开发了数据处理软件,接入Excel数据并进行校核及转换,并生成所需的格式文件。实践证明该软件能大幅度提高点表数据质量和接入工作效率。
As two heterogeneous integrated dispatching and central-control automation systems are adopted in Guangzhou Power Grid,it is a hard work to integrate data from substations or power plants to the systems and to maintain the database.Data of information points tables from suppliers in Excel format must be changed to specific format,and undergo the examination in order to improve the data quality before they imported into the database.The original format transformation and examinaion depend highly on manual labour,and thus the efficiency and data quality cannot be assured.A software for examining and processing the original data is developed with VC++ in this paper to undertake the reading,examination,processing of data from Excel files,and generate file with specific format.This software works so well practically as to obviously improve the data quality and data-integrated efficiency.
出处
《南方电网技术》
2011年第1期22-24,共3页
Southern Power System Technology
关键词
调度集控自动化系统
远动信息
软件
EXCEL
integrated dispatching and central-control automatic system
telecontrol data
software
Excel