基于高斯积分法高精度获得各密度级平均密度并用Excel实现的方法  

Method of obtaining the average density of each density level with high precision based on Gaussian integral method and realizing it with Excel

作　　者：申永强 Shen Yongqiang(Dongpang Mine,Jizhong Energy Co.,Ltd.,Xingtai 054201,China)

机构地区：[1]冀中能源股份有限公司东庞矿,河北邢台054201

出　　处：《煤炭与化工》2023年第1期112-115,共4页Coal and Chemical Industry

摘　　要：选煤计算中经常要用到各密度级的平均密度,传统取值方法是取各密度级密度范围上下限的算术平均值作为其平均密度,这种取值方法虽然简单,但会带来较大的误差。但若根据质量守恒原则精确计算各密度级的平均密度时,由于平均密度的计算公式中存在积分项,一般需借助于计算机编程进行精确计算,非常繁琐。针对这一情况,本文提供了一种利用高斯积分公式近似法借助Excel即可获得各密度级的平均密度的简单方法。The average density of each density level is often used in coal preparation calculation. The traditional method is to take the arithmetic mean of the upper and lower limits of the density range of each density level as its average density.Although this method is simple, it will bring large errors. However, if the average density of each density level is accurately calculated according to the principle of mass conservation, due to the integral term in the calculation formula of the average density, it is generally necessary to use computer programming for accurate calculation, which is very cumbersome. In view of this situation, this paper provides a simple method to obtain the average density of each density level by using the Gauss integral formula approximation method with the help of Excel.

关 键 词：平均密度 算术平均值 计算机编程 高斯积分公式 

分 类 号：TD92[矿业工程—选矿]