Portal de Periódicos da CAPES

Hydropower Computation Using Visual Basic for Application Programming

2012; Elsevier BV; Volume: 24; Linguagem: Inglês

10.1016/j.phpro.2012.02.007

1875-3892

Wang Yan, Hu Hongliang,

Power Systems and Renewable Energy

Hydropower computation is essential to determine the operating conditions of hydroelectric station. Among the existing methods for hydropower computation, equal monthly hydropower output and dynamic programming are the most commonly used methods, but both of them are too complex in computation and hard to be finished manually. Taking the advantage of the data processing ability of Microsoft Excel and its attached Visual Basic for Application (VBA) program, the complex hydropower computation can be easily achieved. An instance was analyzed in two methods and all delt with VBA. VBA demonstrates its powerful function in solving problem with complex computation, visualizing, and secondary data processing. The results show that the dynamic programming method was more receptive than the other one.