Excel在控制测量计算中的应用

在基于连续运行基准站的数字校园基础构建这个项目背景下,同时也为了使测量技术及其相关专业的学生深刻理解并学会利用Excel对外业测量数据进行处理,从而对相关课程有更好、更深刻的认识.结合项目、教学及学生实际情况介绍了Excel用于控制测量的方法、思路及常用公式,在我校园测量实习场地,布设一附合水准路线和一闭合导线,测量后导入Excel中编辑公式进行处理,经试验可知:Excel在控制测量数据处理方面方便灵活,速度快且具有较高精度,使测量人员的工作量大大减轻,具有一定的实用性.

Excel Application in the Calculation of Control Survey

Under the background of Digital Campus Fundamental Construction Project that is based on the CORS stations,and aiming at a better understanding of application of Excel to process field data among students majoring in the measurement technology and other related specialties,thus to deepen their understating of relevant courses,an experiment,in combination with the project,the teaching and the current situation about students,is conducted which involves the introduction of the various approaches about the use of Excel in control surveying,the train of thought and the commonly used formulas,the set up of a route up to the standard and a closed-on-itself traverse in the campus surveying practice grounds.After the measurement,the data was fed into computer for Excel editing formula treating.The results show that Excel is flexible and fast in processing control surveying data with a relatively high accuracy,and can immensely relieve the workload of the survey crew with much practical value.