中文摘要：

EXCEL软件是最常用的办公软件之一，本文介绍一种利用EXCEL软件规划求解功能计算开采沉陷预计概率积分法预计参数的方法，很方便地得到了预计参数的优化解，通过实例验证，运用该方法得到的这些参数的解满足开采沉陷预计精度的要求，有很好的应用价值。

英文摘要：

EXCEL is a commonly used office software. The paper used the programming function of EXCEL to compute the parameters of probability integral method of mining subsidence prediction, and conveniently got the optimal solution of the parameters. It was Showed by examples that the computed parameters could meet the precision of mining subsidence prediction.