利用Excel表格计算煤层瓦斯含量

Using means of excel tabulation to calculate gas content in coal seam

为了提高煤层瓦斯含量测定数据处理的工作效率和准确度,根据GB/T23249—2009《地勘时期煤层瓦斯含量测定方法》规定的计算公式和Excel内置函数设计了计算表格,并结合实例进行了验证。该Excel计算表格具有录入简单、自动计算、结果准确、修改容易、便于推广的特点。

In order to improve efficiency and accuracy of data processing in measurement of the coalbed gas content, this paper according to the calculation formula from the GB/T23249-2009《Coalbed gas content measurement methods in geological exploration period》 and the built-in function from the excel designs the calculation form,and combines the instance to verification,shows the form the timeliness and accuracy,this excel calculation form has the characteristics such as simple recording,automatic calculation,accurate results,easy modification,easy popularization.