Excel在通风测试数据处理中的应用

Application of excel in data processing of mine ventilation resistance testing

为了处理矿井通风阻力测试中得到的大量基础性参数,提出了利用Microsoft Excel软件进行相关的数据整理与计算的方法,同时详细的介绍了利用Microsoft Excel软件进行曲线拟合的方法。结果表明,Excel软件可以准确快速地对矿井通风阻力测试基础性参数进行处理,并可以对主要通风机特性曲线进行拟合。该方法对矿井通风阻力测试及矿井通风管理、系统优化等具有理论与实际意义。

To deal with a large number of basic parameters from the mine ventilation resistance test. We proposed a method to use Microsoft Excel software to process the parameters, and introduced a method to use Microsoft Excel software to curve fitting. The result shows Microsoft Excel software can process a large number of basic parameters fast and reliably, and fit characteristic curve to the main fan, The method has important theoretical and practical significance in Mine ventilation resistance test, mine ventilation management and system optimization.