基于VBA开发的光伏发电经评可视化模型  

Develop Economic Evaluation Visual Model for Photovoltaic Power Plant by VBA

作　　者：王怀斌 胡芳 刘伊雯 WANG Huaibin;Hu Fang;Liu Yiwen(Longyuan(Beijing)Solar Engineering Technology Co.,Ltd.,Beijing 100034,China)

机构地区：[1]龙源(北京)太阳能技术有限公司,北京100034

出　　处：《风力发电》2021年第6期33-39,49,共8页Wind Power

摘　　要：光伏发电经评软件价格高、更新慢、灵活性低等缺陷制约了其使用范围,Excel经评模型也仅限技经专业人员使用。利用VBA,基于Excel经评模型开发经评小软件,具有开发速度快、可视化界面、多种文件类型接口、数据库交互、使用方便、更新维护简单等优点,完美地解决了以上痛点问题,可供行业相关人员广泛使用。Economic evaluation software for photovoltaic power plant have many shortcomings,such as high price,update slow,low flexibility,and Excel modules are limited to used for techno-economic analyst.Economic evaluation softwares which developed by VBA and based on Excel modules have many advantages,such as develop fast,visualized GUI interface,multiple file types connector,database interaction,easy to use,update and maintenance simple,can figure out the problems mentioned above effectively and will be used widely.

关 键 词：VBA 光伏发电 经评 软件 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]