Hydropower Computation Using Visual Basic for Application Programming

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.