用Excel的“日期/时间”格式进行角度测量数据的存储及处理

Angle Measure Data′s Storage and Processing by Using “Date/Time” Format in Excel

在工程测量中,我们都习惯使用六十进制的度分秒形式来进行角度的记录和计算。Microsoft Excel电子表格软件在测量数值计算中应用广泛,而Excel只能使用十进制角度和弧度两种角度形式。该文中利用"日期/时间"格式,实现了角度在一个单元格中六十进制的度分秒格式的输入、输出显示,以及在六十进制、十进制和弧度之间的相互转换计算,且可保证0.01秒的角度计算精度。

In the engineering measurement works, we are used to record and compute angle by sexagesimal degree/minute/second format. The software of Microsoft Excel is widely used in measure data＇s computation, but in Excel, only two angle formats can be used： decimal and radian angles. In this paper, by using ＂date/ time＂ format,the input and output with sexagesimal degree/minute/second format in unit cell, and the angle transformation computation among sexagesimal, decimal and radian angles are all realized with the precision accuracy of 0.01 second.