Application of hydrological frequency calculation program based on Excel VBA
Yuan Chao · Northwest Hydropower · 2011
The paper presents the development of linear hydrological frequency calculation program for five frequencies based on the second development function of Excel VBA.According to the calculation method of hydrological frequency,VBA language is used to prepare the program and establish the user interface so as to input the parameters and output the calculation results.Tests show that the program has correct calculation results,high calculation efficiency and practical applicability.