将腾讯地图或高德地图采集的经纬度存至EXCEL.如下图所示
C2格计算公式:A2*2-(A2 + ((-100.0 + 2.0 * (B2- 105.0) + 3.0 * (A2- 35.0) + 0.2 * (A2 - 35.0)* (A2- 35.0) +0.1 * (B2- 105.0) * (A2- 35.0) + 0.2 * sqrt(abs(B2- 105.0))+(20.0 * sin(6.0 *(B2- 105.0)* 3.1415926535897932384626) + 20.0 *sin(2.0 *(B2- 105.0) *3.1415926535897932384626)) * 2.0 / 3.0+(20.0 * sin((A2- 35.0) *3.1415926535897932384626) + 40.0 *sin((A2- 35.0) / 3.0 *3.1415926535897932384626)) * 2.0 / 3.0+(160.0 *sin((A2- 35.0)/ 12.0 *3.1415926535897932384626) + 320 *sin((A2- 35.0) *3.1415926535897932384626 / 30.0)) * 2.0 / 3.0) * 180.0) / (( 6378245.0* (1 -0.00669342162296594323)) / ((1 - 0.00669342162296594323 * sin(A2/ 180.0 * 3.1415926535897932384626)*sin(A2/ 180.0 *3.1415926535897932384626)) * sqrt(1-0.006