| 基于Excel的电力市场报表管理系统 |
| |
| 引用本文： | 杨争林,宋燕敏,曹荣章,胡俊,张莹.基于Excel的电力市场报表管理系统[J].电力系统自动化,2003,27(1):27-30. |
| |
| 作者姓名： | 杨争林 宋燕敏 曹荣章 胡俊 张莹 |
| |
| 作者单位： | 国家电力公司电力自动化研究院 江苏省南京市210003
(杨争林，宋燕敏，曹荣章，胡俊)，国家电力公司电力自动化研究院 江苏省南京市210003(张莹) |
| |
| 摘 要： | 提出并研制了一种适用于电力市场的新的报表管理系统，提出了数据区管理和Excel商用报表软件相结合的设计思想；采用VBA技术建立了电力市场数据库与Excel的通道，由数据区和Excel分别完成数据挖掘和显示分析，成功地实现了基于Excel的电力市场数据挖掘，该系统已成功应用于电力市场运营系统和发电商竞价辅助决策系统中，具有Excel商用软件的所有功能，扩展性强，生命周期长。
|
| 关 键 词： | Excel 电力市场 报表管理系统 电子表格处理软件 电力系统 计算机 电力工业 |
| 收稿时间： | 1/1/1900 12:00:00 AM |
| 修稿时间： | 1/1/1900 12:00:00 AM |
EXCEL BASED PMOS-2000 STATEMENT MANAGEMENT SYSTEM |
| |
| Yang Zhenglin,Song Yanmin,Cao Rongzhang,Hu Jun,Zhang Ying.EXCEL BASED PMOS-2000 STATEMENT MANAGEMENT SYSTEM[J].Automation of Electric Power Systems,2003,27(1):27-30. |
| |
| Authors: | Yang Zhenglin Song Yanmin Cao Rongzhang Hu Jun Zhang Ying |
| |
| Abstract: | 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. |
| |
| Keywords: | statement management system Excel power market |
| 本文献已被 CNKI 维普 等数据库收录！ |
| 点击此处可从《电力系统自动化》浏览原始摘要信息 |
|
点击此处可从《电力系统自动化》下载全文 |
