在Excel中进行断面数据的计算与输出

Calculate and Output Section Data in Excel Automaticly

在进行断面测量时通常使用水准仪配水准尺来测量高程,使用轻便卷尺来丈量距离,根据前后视的读数和后视点的高程来计算出断面点的高程。本文介绍了在Excel中制作断面记录模板,只需输入观测数据即可实现断面数据的自动计算和输出,减少了出错几率,提高了工作效率。

In surveying section data we usually survey superelevation by levelling instrument and levelling staff, measure distance by band tape, and calculate section data on readings and back elevation. Finally we need to input section data to electronic file in fixed form. In the course of calculating and inputting it not only makes mistakes in figure and form, but also inefficient. This paper explains how to make a template in excel to calculate and output section data auto-maticly,thus the above problem can be settled