用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.