基于Excel的矿井涌(排)水量数据在煤矿防治水中的应用

Application of water-inflow data in water prevention and control work of coal mine based on Excel

为充分利用矿井长期积累的涌(排)水量数据指导防治水工作,采用Excel表格设计涌(排)水量台账对数据进行管理,并将数据应用在判定突(涌)水水源、评价注浆堵水效果、预计涌水量等方面。应用结果表明,涌(排)数据可以用来预测、评价、判定有关防治水技术问题。

In order to made full use of the long-term accumulation data of M i n e water inflow （ r o w） to guide the work of water-disaster prevention,using Excel table designed water inflow （ r o w） account to m a n a g e the data,through the data in the decision process（ burst）, evaluation of grouting water shutoff effect, expected water content and so o n ,application results to predict, evaluate and determine the relevant problems of water prevention and control technology.