输电线路弧垂角度法观测(自动计算公式表格) 1.0

档侧角度法检查弧垂,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

"1、公式计算：

注意：蓝色区域为自动计算结果，请勿修改",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

"序

号","耐张段

塔号","耐张

档距

m","观测

档号",,"温度

℃","相

别","方向

（单回

无需

填，

双回

延线

路方

向填

左右）","实测远近之间挂点

水平距离

",观测角度（水平角角度与仰角角度）,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"近侧挂点相对远侧挂点高差

h","观测弧

垂值

f"

,,,,,,,,,近侧挂点（A）,,,,,,,,,,,导线最低位置切点(C),,,,,,,,,,,自动计算参考,,,,,远侧挂点(B),,,,,,,,,,,,

,,,,,,,,,仰角φA,,,,,水平角αA,,,,,"挂点至测站N

水平距离

",仰角θ,,,,,水平角αC,,,,,"切点

至测站N

水平距离

",水平角∠B1A1N,,,,,仰角φB,,,,,水平角αB,,,,,"挂点

至测站N

水平距离

",,

,,,近侧塔号,"远侧

塔号",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,(m),度,分,秒,度数,弧度,度,分,秒,度数,弧度,(m),度,分,秒,度数,弧度,度,分,秒,度数,弧度,(m),弧度,角度,度,分,秒,度,分,秒,度数,弧度,度,分,秒,度数,弧度,(m),(m),(m)

示例计算,,,,,,,,448.55,8,10,30,8.175000,0.142681,0,0,0,0.000000,0.000000,238.96,16,46,13,16.770278,0.292697,69,6,34,69.109444,1.206187,106.62,0.46022,26.36876,26,22,8,9,56,48,9.946667,0.173602,129,16,33,129.275833,2.256289,257.36,10.80,7.60

1,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

2,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

3,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

4,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

5,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

6,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

7,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

8,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

9,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

10,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

11,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

12,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

13,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

14,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

15,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

16,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

17,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

18,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

19,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

20,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

21,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

22,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

23,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

24,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

25,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

26,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

27,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

28,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

29,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

30,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

31,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

32,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

33,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

34,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

35,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

36,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

37,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

38,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

39,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

40,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

41,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

42,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

43,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

44,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

45,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

46,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

47,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

48,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

49,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

50,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

51,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

52,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

53,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,0.000000,0.000000,,,,0.000000,0.000000,,0.00,#DIV/0!

54,,,,,,,,0.00,,,,0.000000,0.000000,,,,0.000000,0.000000,,,,,0.000000,0.000000,,,,0.000000,0.000000,#DIV/0!,#D