全站仪导线测量中Excel计算公式的应用  

Application of Excel Calculation Formula of Total Station Traverse Survey

作　　者：王会渠 

机构地区：[1]灵宝黄金股份有限公司鸿鑫矿业有限责任公司,河南灵宝472500

出　　处：《河南科技》2016年第15期50-52,共3页Henan Science and Technology

摘　　要：随着科学技术的发展,全站仪在矿山坑道测量中应用越来越广泛,如何把全站仪观测数据和计算机Excel软件强大的函数计算能力结合起来,更好地提高工作效率,已成为现代测量技术人员的必备技能之一。虽然全站仪自动记录数据的功能很强大,但在实际实践操作环境中坑道内光线很暗又潮湿,系统操作反而不方便,手工记录现场观测数据,内业后期Excel函数计算反而效率很高。基于此,结合生产实际设计的Excel工作表,可以将外业数据在Excel表格中把全站仪照准点的方位角、坐标和高程快速计算出来。W ith the developm ent o f scien ce and technology, total station is finding w ider and w ider application in them ine tunnel m easurem ent, how to put the total station observation data and com puter powerful function o f E x cel softwarecom puting capacity, to better im prove the work efficien cy, has becom e one o f the essential sk ill requirem ents ofthe m odem m easuring technology personnel. A lth ough the function o f the total station autom atic recording into datais very strong, but in the actu al practice in the operating environm ent w ithin the tunnel light is very dark and damp,system operation is not convenient, instead the field observation data, the m anual record late E x cel function insteado f com puting e fficien cy is also high in the industry. B ased on this, this paper designed E x cel w orksheets com binedwith the actu al production, w hich can q u ick ly calcu late the sighting point o f the azim uth, coordinates and elevation ofthe field data in E x c e l spreadsheet azim uth angle.

关 键 词：全站仪 Excel函数计算 方位角 坐标 高程 

分 类 号：TD17[矿业工程—矿山地质测量]