液压支架工作阻力监测和数据处理在Excel中的实现
|
摘要
液压支架工作阻力监测与处理是分析采场矿压的重要组成部分。数据处理结果不仅能够直观反映工作面矿压显现规律,还能进一步分析支架-围岩关系的特征,同时也是支架设计和选型的数据支撑,可使监测成果得到充分利用,因此快速精确地进行数据处理是非常必要的。Excel表格操作简单、数据处理功能强大、处理结果直观性好。结合Excel的优点,实现了液压支架监测数据的计算和图形输出。
Monitor and analysis on working resistance of hydraulic support is an important component of analyzing ground pressure in mining field. The results of data processing can not only reflect the law of rock pressure in working face, but also analyze the characteristics of relationship between support and the surrounding rock. Meanwhile, it is also the data support for the design and selection of the hydraulic support. To make full use of monitoring results, it is necessary to process data quickly and accurately.There are more characteristics in Excel such as simple operation, powerful data processing function, good intuitiveness in processing results and so on. Based on advantages of Excel, the calculation and graphic output of hydraulic support monitoring data are realized.
Monitor and analysis on working resistance of hydraulic support is an important component of analyzing ground pressure in mining field. The results of data processing can not only reflect the law of rock pressure in working face, but also analyze the characteristics of relationship between support and the surrounding rock. Meanwhile, it is also the data support for the design and selection of the hydraulic support. To make full use of monitoring results, it is necessary to process data quickly and accurately.There are more characteristics in Excel such as simple operation, powerful data processing function, good intuitiveness in processing results and so on. Based on advantages of Excel, the calculation and graphic output of hydraulic support monitoring data are realized.
引文
[1]钱鸣高,石平五.矿山压力与岩层控制[M].徐州:中国矿业大学出版社,2008.
[2]钱鸣高.20年来采场围岩控制理论与实践的回顾[J].中国矿业大学学报,2000,29(1):1-4.
[3]鲁忠良,肖亚宁,唐中华.煤矿液压支架的实用安全理论及技术[M].徐州:中国矿业大学出版社,2009.
[4]彭赐灯.矿山压力与岩层控制研究热点最新进展评述[J].中国矿业大学学报,2015,44(1):1-8.
[5]宋高峰,刘新杰,杨敬虎.现场矿压观测技术现状及展望[J].煤矿安全,2014,45(9):200-202.
[6]刘月文.大采高工作面的矿压显现规律分析[J].山西煤炭,2014,34(10):15-16.
[7]徐玉学.彭庄煤矿深部首采工作面矿压规律分析[J].煤矿安全,2011,42(10):139-140.
[8]刘双跃.矿压观测的数据处理[J].煤矿安全,2001,32(6):25-27.
[9]葛胜文.复杂地质条件下综采工作面矿压显现规律研究[J].煤炭工程,2007(1):65-66.
[10]汤建全,栗才全,李英德.现场矿压观测方案设计[J].煤矿开采,2008,13(1):71-74.
[11]宋建国.大采高综采面矿压显现规律研究[J].矿山压力与顶板管理,2005(2):19-21.
[12]胡国伟,靳钟铭.大采高综采工作面矿压观测及其显现规律研究[J].太原理工大学学报,2006,37(2):127-130.
[13]王爱午,王继树.软岩下浅埋煤层大采高综采面矿压显现规律研究[J].同煤科技,2016(4):20-24.
[14]张金虎,王国法,侯刚.布尔台煤矿厚煤层大采高液压支架适应性分析[J].煤炭科学技术,2014,42(9):95-98.
[2]钱鸣高.20年来采场围岩控制理论与实践的回顾[J].中国矿业大学学报,2000,29(1):1-4.
[3]鲁忠良,肖亚宁,唐中华.煤矿液压支架的实用安全理论及技术[M].徐州:中国矿业大学出版社,2009.
[4]彭赐灯.矿山压力与岩层控制研究热点最新进展评述[J].中国矿业大学学报,2015,44(1):1-8.
[5]宋高峰,刘新杰,杨敬虎.现场矿压观测技术现状及展望[J].煤矿安全,2014,45(9):200-202.
[6]刘月文.大采高工作面的矿压显现规律分析[J].山西煤炭,2014,34(10):15-16.
[7]徐玉学.彭庄煤矿深部首采工作面矿压规律分析[J].煤矿安全,2011,42(10):139-140.
[8]刘双跃.矿压观测的数据处理[J].煤矿安全,2001,32(6):25-27.
[9]葛胜文.复杂地质条件下综采工作面矿压显现规律研究[J].煤炭工程,2007(1):65-66.
[10]汤建全,栗才全,李英德.现场矿压观测方案设计[J].煤矿开采,2008,13(1):71-74.
[11]宋建国.大采高综采面矿压显现规律研究[J].矿山压力与顶板管理,2005(2):19-21.
[12]胡国伟,靳钟铭.大采高综采工作面矿压观测及其显现规律研究[J].太原理工大学学报,2006,37(2):127-130.
[13]王爱午,王继树.软岩下浅埋煤层大采高综采面矿压显现规律研究[J].同煤科技,2016(4):20-24.
[14]张金虎,王国法,侯刚.布尔台煤矿厚煤层大采高液压支架适应性分析[J].煤炭科学技术,2014,42(9):95-98.