批量经纬度距离计算工具

序号,,经纬度A(原始经纬度),,经纬度B（新位置经纬度）,,,,"相差直线距离

(米)"

,,"经度

（十进制）","纬度

（十进制）","经度

（十进制）","纬度

（十进制）","经度

（十进制）","纬度

（十进制）",

1,7DF-后坝村香樟组LZHV,105.97124,27.27258,105.974038,27.268754,#REF!,#REF!,507.413403

2,7DF-马场沙田村LZHV,105.519239,26.989331,105.519239,26.989331,#REF!,#REF!,0

3,7DF-马场大荒地LZHV,105.502962,26.987617,105.502962,26.987617,#REF!,#REF!,0

4,7DF-鼎新风景村LZHV,105.390836,27.024074,105.390836,27.024074,#REF!,#REF!,0

5,7DF-水洞2站LZHV,105.534412,27.358651,105.543109,27.362242,#REF!,#REF!,947.1625509

6,7DF-安乐上寨村LZHV,105.671557,27.267659,105.671557,27.267659,#REF!,#REF!,0

7,7DF-鼎新麻窝组LZHV,105.451292,27.00609,105.451292,27.00609,#REF!,#REF!,0

8,7DF-羊场坝桶井村LZHV,105.687598,27.068459,105.687598,27.068459,#REF!,#REF!,0

9,7DF-达溪大湾村LZHV,105.65892,27.368557,105.65892,27.368557,#REF!,#REF!,0

10,7DF-大山解放村LZHV,105.811333,27.454288,105.811333,27.454288,#REF!,#REF!,0

11,7DF-绿塘周家寨2LZHV,105.400208,27.069153,105.400208,27.069153,#REF!,#REF!,0

12,7DF-大山柏杉村LZHV,105.793453,27.438738,105.793453,27.438738,#REF!,#REF!,0

13,7DF-响水青山村LZHV,105.541639,27.279056,105.541639,27.279056,#REF!,#REF!,0

14,7DF-理化法乐村LZHV,105.684593,26.982473,105.684593,26.982473,#REF!,#REF!,0

15,7DF-绿塘庙山LZHV,105.470519,27.047786,105.470519,27.047786,#REF!,#REF!,0

16,7DF-三元群丰村LZHV,105.751503,27.329216,105.752615,27.329438,#REF!,#REF!,112.5869702

17,7DF-三元2站LZHV,105.79513,27.32375,105.79513,27.32375,#REF!,#REF!,0

18,7DF-马场撮箕湾LZHV,105.563131,26.989487,105.563131,26.989487,#REF!,#REF!,0

19,7DF-马场老塘2组LZHV,105.465814,26.921337,105.465814,26.921337,#REF!,#REF!,0

20,7DF-竹园歹鸡村三组LZHV,105.562376,27.264318,105.562376,27.264318,#REF!,#REF!,0

21,7DF-黄泥塘化眉井LZHV,105.73628,27.101041,105.736286,27.100995,#REF!,#REF!,5.149313397

22,7DF-马场宋家寨LZHV,105.463808,26.905748,105.463808,26.905748,#REF!,#REF!,0

23,7DF-马场镇新丰村LZHV,105.524409,26.947224,105.524409,26.947224,#REF!,#REF!,0

24,7DF-响水以拉村LZHV,105.525894,27.258307,105.525959,27.258337,#REF!,#REF!,7.23940461

25,7DF-响水柯家桥LZHV,105.526094,27.26664,105.526488,27.266279,#REF!,#REF!,55.92740136

26,7DF-果瓦村LZHV,105.823433,27.568765,105.823437,27.569054,#REF!,#REF!,32.13782708

27,7DF-石艳小学LZHV,105.628323,27.275885,105.628323,27.275885,#REF!,#REF!,0

28,7DF-黄泥塘安平路口LZHV,105.797987,27.053808,105.797987,27.053808,#REF!,#REF!,0

29,7DF-文阁玉米组LZHV,105.435317,27.172623,105.434403,27.173328,#REF!,#REF!,119.6674398

30,,106.435317,28.172623,106.434403,28.173328,#REF!,#REF!,119.0462508

31,,107.435317,29.172623,107.434403,29.173328,#REF!,#REF!,118.4070758

32,,108.435317,30.172623,108.434403,30.173328,#REF!,#REF!,117.7504254

33,,109.435317,31.172623,109.434403,31.173328,#REF!,#REF!,117.0767756

34,,110.435317,32.172623,110.434403,32.173328,#REF!,#REF!,116.386683

35,,111.435317,33.172623,111.434403,33.173328,#REF!,#REF!,115.6807102

36,,112.435317,34.172623,112.434403,34.173328,#REF!,#REF!,114.9593879

37,,113.435317,35.172623,113.434403,35.173328,#REF!,#REF!,114.2233722

38,,114.435317,36.172623,114.434403,36.173328,#REF!,#REF!,113.4732906

39,,115.435317,37.172623,115.434403,37.173328,#REF!,#REF!,112.7097018

40,,116.435317,38.172623,116.434403,38.173328,#REF!,#REF!,111.933336

41,,117.435317,39.172623,117.434403,39.173328,#REF!,#REF!,111.1448984

42,,118.435317,40.172623,118.434403,40.173328,#REF!,#REF!,110.3450287

43,,119.435317,41.172623,119.434403,41.173328,#REF!,#REF!,109.534505

44,,120.435317,42.172623,120.434403,42.173328,#REF!,#REF!,108.7140839

45,,121.435317,43.172623,121.434403,43.173328,#REF!,#REF!,107.8845838

46,,122.435317,44.172623,122.434403,44.173328,#REF!,#REF!,107.0467619

47,,123.435317,45.172623,123.434403,45.173328,#REF!,#REF!,106.201482

48,,124.435317,46.172623,124.434403,46.173328,#REF!,#REF!,105.3495913

49,,125.435317,47.172623,125.434403,47.173328,#REF!,#REF!,104.4919631

50,,126.435317,48.172623,126.434403,48.173328,#REF!,#REF!,103.6295856

51,,127.435317,49.172623,127.434403,49.173328,#REF!,#REF!,102.7633039

52,,128.435317,50.172623,128.434403,50.173328,#REF!,#REF!,101.8941684

53,,129.435317,51.172623,129.434403,51.173328,#REF!,#REF!,101.0231759

54,,130.435317,52.172623,130.434403,52.173328,#REF!,#REF!,100.1513129

55,,131.435317,53.172623,131.434403,53.173328,#REF!,#REF!,99.27960055

56,,132.435317,54.172623,132.434403,54.173328,#REF!,#REF!,98.40918755

57,,133.435317,55.172623,133.434403,55.173328,#REF!,#REF!,97.54117132

58,,134.435317,56.172623,134.434403,56.173328,#REF!,#REF!,96.67668852

59,,135.435317,57.172623,135.434403,57.173328,#REF!,#REF!,95.81686946

60,,136.435317,58.172623,136.434403,58.173328,#REF!,#REF!,94.96293229

61,,137.435317,59.172623,137.434403,59.173328,#REF!,#REF!,94.1160426

62,,138.435317,60.172623,138.434403,60.173328,#REF!,#REF!,93.27755184

63,,139.435317,61.172623,139.434403,61.173328,#REF!,#REF!,92.44861469

64,,140.435317,62.172623,140.434403,62.173328,#REF!,#REF!,91.63052321

65,,141.435317,63.172623,141.434403,63.173328,#REF!,#REF!,90.82461243

66,,142.435317,64.172623,142.434403,64.173328,#REF!,#REF!,90.03221051

67,,143.435317,65.172623,143.434403,65.173328,#REF!,#REF!,89.25468702

68,,144.435317,66.172623,144.434403,66.173328,#REF!,#REF!,88.49329986

69,,145.435317,67.172623,145.434403,67.173328,#REF!,#REF!,87.74944481

70,,146.435317,68.172623,146.434403,68.173328,#REF!,#REF!,87.02455533

71,,147.435317,69.172623,147.434403,69.173328,#REF!,#REF!,86.3198923

72,,148.435317,70.172623,148.434403,70.173328,#REF!,#REF!,85.63695486

73,,149.435317,71.172623,149.434403,71.173328,#REF!,#REF!,84.97695621

74,,150.435317,72.172623,150.434403,72.173328,#REF!,#REF!,84.34139663

75,,151.435317,73.172623,151.434403,73.173328,#REF!,#REF!,83.73153227

76,,152.435317,74.172623,152.434403,74.173328,#REF!,#REF!,83.1486331

77,,153.435317,75.172623,153.434403,75.173328,#REF!,#REF!,82.59414301

78,,154.435317,76.172623,154.434403,76.173328,#REF!,#REF!,82.06913201

79,,155.435317,77.172623,155.434403,77.173328,#REF!,#REF!,81.57499792

80,,156.435317,78.172623,156.434403,78.173328,#REF!,#REF!,81.11274951

81,,157.435317,79.172623,157.434403,79.173328,#REF!,#REF!,80.68360504

82,,158.435317,80.172623,158.434403,80.173328,#REF!,#REF!,80.28860048

83,,159.435317,81.172623,159.434403,81.173328,#REF!,#REF!,79.92874942

84,,160.435317,82.172623,160.434403,82.173328,#REF!,#REF!,79.60492485

85,,161.435317,83.172623,161.434403,83.173328,#REF!,#REF!,79.31796572

86,,162.435317,84.172623,162.434403,84.173328,#REF!,#REF!,79.06861538

87,,163.435317,85.172623,163.434403,85.173328,#REF!,#REF!,78.85757346

88,,164.435317,86.172623,164.434403,86.173328,#REF!,#REF!,78.68543455

89,,165.435317,87.172623,165.434403,87.173328,#REF!,#REF!,78.55256916

90,,166.435317,88.172623,166.434403,88.173328,#REF!,#REF!,78.45940653

91,,167.435317,89.172623,167.434403,89.173328,#REF!,#REF!,78.40620315

92,,168.435317,90.172623,168.434403,90.173328,#REF!,#REF!,78.39309786

93,,169.435317,91.172623,169.434403,91.173328,#REF!,#REF!,78.42005329

94,,170.435317,92.172623,170.434403,92.173328,#REF!,#REF!,78.48714301

95,,171.435317,93.172623,171.434403,93.173328,#REF!,#REF!,78.59403488

96,,172.435317,94.172623,172.434403,94.173328,#REF!,#REF!,78.74056682

97,,173.435317,95.172623,173.434403,95.173328,#REF!,#REF!,78.92623255

98,,174.435317,96.172623,174.434403,96.173328,#REF!,#REF!,79.15058588

99,,175.435317,97.172623,175.434403,97.173328,#REF!,#REF!,79.4130152

100,,176.435317,98.172623,176.434403,98.173328,#REF!,#REF!,79.71280525

101,,177.435317,99.172623,177.434403,99.173328,#REF!,#REF!,80.04919852

102,,178.435317,100.172623,178.434403,100.173328,#REF!,#REF!,80.42134344

103,,179.435317,101.172623,179.434403,101.173328,#REF!,#REF!,80.82830018

104,,180.435317,102.172623,180.434403,102.173328,#REF!,#REF!,81.26899129

105,,181.435317,103.172623,181.434403,103.173328,#REF!,#REF!,81.74237501

106,,182.435317,104.172623,182.434403,104.173328,#REF!,#REF!,82.24733894

107,,183.435317,105.172623,183.434403,105.173328,#REF!,#REF!,82.78270639

108,,184.435317,106.172623,184.434403,106.173328,#REF!,#REF!,83.34713456

109,,,,,,#REF!,#REF!,0

110,,,,,,#REF!,#REF!,0

111,,,,,,#REF!,#REF!,0

112,,,,,,#REF!,#REF!,0

113,,,,,,#REF!,#REF!,0

114,,,,,,#REF!,#REF!,0

115,,,,,,#REF!,#REF!,0

116,,,,,,#REF!,#REF!,0

117,,,,,,#REF!,#REF!,0

118,,,,,,#REF!,#REF!,0

119,,,,,,#REF!,#REF!,0

120,,,,,,#REF!,#REF!,0

121,,,,,,#REF!,#REF!,0

122,,,,,,#REF!,#REF!,0

123,,,,,,#REF!,#REF!,0

124,,,,,,#REF!,#REF!,0

125,,,,,,#REF!,#REF!,0

126,,,,,,#REF!,#REF!,0

127,,,,,,#REF!,#REF!,0

128,,,,,,#REF!,#REF!,0

129,,,,,,#REF!,#REF!,0

130,,,,,,#REF!,#REF!,0

131,,,,,,#REF!,#REF!,0

132,,,,,,#REF!,#REF!,0

133,,,,,,#REF!,#REF!,0

134,,,,,,#REF!,#REF!,0

135,,,,,,#REF!,#REF!,0

136,,,,,,#REF!,#REF!,0

137,,,,,,#REF!,#REF!,0

138,,,,,,#REF!,#REF!,0

139,,,,,,#REF!,#REF!,0

140,,,,,,#REF!,#REF!,0

141,,,,,,#REF!,#REF!,0

142,,,,,,#REF!,#REF!,0

143,,,,,,#REF!,#REF!,0

144,,,,,,#REF!,#REF!,0

145,,,,,,#REF!,#REF!,0

146,,,,,,#REF!,#REF!,0

147,,,,,,#REF!,#REF!,0

148,,,,,,#REF!,#REF!,0

149,,,,,,#REF!,#REF!,0

150,,,,,,#REF!,#REF!,0

151,,,,,,#REF!,#REF!,0

152,,,,,,#REF!,#REF!,0

153,,,,,,#REF!,#REF!,0

154,,,,,,#REF!,#REF!,0

155,,,,,,#REF!,#REF!,0

156,,,,,,#REF!,#REF!,0

157,,,,,,#REF!,#REF!,0

158,,,,,,#REF!,#REF!,0

159,,,,,,#REF!,#REF!,0

160,,,,,,#REF!,#REF!,0

161,,,,,,#REF!,#REF!,0

162,,,,,,#REF!,#REF!,0

163,,,,,,#REF!,#REF!,0

164,,,,,,#REF!,#REF!,0

165,,,,,,#REF!,#REF!,0

166,,,,,,#REF!,#REF!,0

167,,,,,,#REF!,#REF!,0

168,,,,,,#REF!,#REF!,0

169,,,,,,#REF!,#REF!,0

170,,,,,,#REF!,#REF!,0

171,,,,,,#REF!,#REF!,0

172,,,,,,#REF!,#REF!,0

173,,,,,,#REF!,#REF!,0

174,,,,,,#REF!,#REF!,0

175,,,,,,#REF!,#REF!,0

176,,,,,,#REF!,#REF!,0

177,,,,,,#REF!,#REF!,0

178,,,,,,#REF!,#REF!,0

179,,,,,,#REF!,#REF!,0

180,,,,,,#REF!,#REF!,0

181,,,,,,#REF!,#REF!,0

182,,,,,,#REF!,#REF!,0

183,,,,,,#REF!,#REF!,0

184,,,,,,#REF!,#REF!,0

185,,,,,,#REF!,#REF!,0

186,,,,,,#REF!,#REF!,0

187,,,,,,#REF!,#REF!,0

188,,,,,,#REF!,#REF!,0

189,,,,,,#REF!,#REF!,0

190,,,,,,#REF!,#REF!,0

191,,,,,,#REF!,#REF!,0

192,,,,,,#REF!,#REF!,0

193,,,,,,#REF!,#REF!,0

194,,,,,,#REF!,#REF!,0

195,,,,,,#REF!,#REF!,0

196,,,,,,#REF!,#REF!,0

197,,,,,,#REF!,#REF!,0

198,,,,,,#REF!,#REF!,0

199,,,,,,#REF!,#REF!,0

200,,,,,,#REF!,#REF!,0

201,,,,,,#REF!,#REF!,0

202,,,,,,#REF!,#REF!,0

203,,,,,,#REF!,#REF!,0

204,,,,,,#REF!,#REF!,0

205,,,,,,#REF!,#REF!,0

206,,,,,,#REF!,#REF!,0

207,,,,,,#REF!,#REF!,0

208,,,,,,#REF!,#REF!,0

209,,,,,,#REF!,#REF!,0

210,,,,,,#REF!,#REF!,0

211,,,,,,#REF!,#REF!,0

212,,,,,,#REF!,#REF!,0

213,,,,,,#REF!,#REF!,0

214,,,,,,#REF!,#REF!,0

215,,,,,,#REF!,#REF!,0

216,,,,,,#REF!,#REF!,0

217,,,,,,#REF!,#REF!,0

218,,,,,,#REF!,#REF!,0

219,,,,,,#REF!,#REF!,0

220,,,,,,#REF!,#REF!,0

221,,,,,,#REF!,#REF!,0

222,,,,,,#REF!,#REF!,0

223,,,,,,#REF!,#REF!,0

224,,,,,,#REF!,#REF!,0

225,,,,,,#REF!,#REF!,0

226,,,,,,#REF!,#REF!,0

227,,,,,,#REF!,#REF!,0

228,,,,,,#REF!,#REF!,0

229,,,,,,#REF!,#REF!,0

230,,,,