Exce l在立井凿井提升悬吊系统选型计算中的应用  

Application of Excel in the selection and calculation of hoisting system for shaft sinking

作　　者：王改侠 贾振刚[1] Wang Gaixia;Jia Zhengang(China Coal First Construction Corporation Ltd.,No.49 Engineering Division,Handan 056003,China)

机构地区：[1]中煤第一建设有限公司第四十九工程处,河北邯郸056003

出　　处：《煤炭与化工》2018年第11期74-77,80,共5页Coal and Chemical Industry

摘　　要：通过在一个excel工作簿中建立设备材料特征参数表、凿井单项设施选型计算表、选型计算(书)一览表等3个基本类别的若干个工作表,设置工作表内和工作表之间的计算公式、条件函数,建立整个工作簿之间数据的有序链接,实现输入拟施工井筒基本参数,快速完成立井凿井提升悬吊系统选型计算,相对人工计算器查表计算更加快捷、准确。By setting up several worksheets of three basic categories in a excel workbook,such as the characteristic parameter table of equipment and materials,the calculation table of single facility selection of sinking shaft,and the list of selection calculation(book),the calculation formulas between worksheets and worksheets were set up.The orderly link of the data between the whole workbook was got,the input of the basic parameters of the shaft was given.After the quick completion of the type selection calculation of the shaft sinking and hoisting suspension system the calculation of the suspension system for shaft sinking was faster and more accurate than that of the manual calculator.

关 键 词：EXCEL 数据库 函数 选型计算 

分 类 号：TD53[矿业工程—矿山机电]