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

Develop Economic Evaluation Visual Model for Photovoltaic Power Plant by VBA

光伏发电经评软件价格高、更新慢、灵活性低等缺陷制约了其使用范围,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.