摘要
提出并研制了一种适用于电力市场的新的报表管理系统。提出了数据区管理和 Excel商用报表软件相结合的设计思想 ;采用 VBA技术建立了电力市场数据库与 Excel的通道 ;由数据区和Excel分别完成数据挖掘和显示分析。成功地实现了基于 Excel的电力市场数据挖掘。该系统已成功应用于电力市场运营系统和发电商竞价辅助决策系统中 ,具有 Excel商用软件的所有功能 ,扩展性强 。
A new statement management system suitable for the power market is proposed and developed. A design idea that combines the data area management with the commercial Excel statement is proposed. The channels between the power market database and the Excel are built with the VBA (Visual Basic for Application) technique. Data mining and display analysis are performed by the data area and Excel, respectively. Based on the Excel, the data mining of the power market is successfully realized. The system has been satisfactorily applied to the power market operation system and an auxiliary decision system for a power supplier in setting a competitive price, and it has all the functions of the Excel software with strong expandability and a long lifecycle.
出处
《电力系统自动化》
EI
CSCD
北大核心
2003年第1期27-30,共4页
Automation of Electric Power Systems