基于Excel VBA水文频率计算程序的开发应用  

Application of hydrological frequency calculation program based on Excel VBA

作　　者：袁超[1] 

机构地区：[1]中国水电顾问集团西北勘测设计研究院,西安710065

出　　处：《西北水电》2011年第5期1-3,共3页Northwest Hydropower

摘　　要：基于Excel VBA二次开发功能,进行5种频率线型水文频率计算程序开发;根据水文频率计算方法,采用VBA语言编写程序,建立用户界面进行参数的输入和计算成果的输出。经检验,本程序计算结果正确,计算效率高,实用性强。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.

关 键 词：EXCEL VBA GUI 水文频率 计算程序 

分 类 号：TP311.11[自动化与计算机技术—计算机软件与理论] P333.9[自动化与计算机技术—计算机科学与技术]