摘要
调洪计算在尾矿库设计和运行管理中都是非常重要的,水量平衡是常用计算方法,涉及较多的插值计算与试算。为了提高计算效率和计算质量,在利用Excel强大数据处理功能的同时,采用VBA编程方法实现计算过程自动化。降低了人工插值和试算对计算结果的影响,提高了工作效率。计算过程清晰,通用性强。
Flood regulartion calculation is very important in the design and operation management of tailings pond,and water balance is regarded as a common calculation method which involves many interpolation calculations and trial calculations.In order to improve the computational efficiency and quality,by using Excel's powerful data processing capabilities and VBA programming method,it can achieve the calculation process automatically.It's the way to reduce the influence of labor in interpolation and trial calculations and improve the work efficiency.Moreover,the calculation process is clear and versatile.
作者
苏伟强
Su Weiqiang(Sichuan Xiye Engineering Design Consulting Co.,Ltd.)
出处
《现代矿业》
CAS
2020年第7期88-91,共4页
Modern Mining
关键词
尾矿库
调洪计算
水量平衡
VBA编程
Tailings pond
Flood regulation calculation
Water balance
VBA programming