EXCEL计算坐标的程序

1、测站点坐标：定向点坐标：X=Y=X=Y=2724036.495018386319.37202724027.017018386360.9590注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！地物代码：斜距：水平角：垂直角：39.504149.172699.154040.611135.2524103.181641.850130.3152104.094761.485122.480798.204872.896130.452795.041692.857128.555496.1855110.936126.32369

2、5.2611118.828120.475695.0602142.024120.305994.1508171.230120.033593.2807174.468110.003893.271249.653130.503399.4341ZK834.023120.1724106.3458ZK429.61982.0135109.230231.54880.4220109.140739.41645.3748104.294946.07132.0241100.185847.27341.3551102.435763.49150.100699.284773.79351.072698.045980.80149.285

3、897.190988.26349.065896.453797.34348.482396.1154109.24148.404795.3029123.63350.031694.3043174.468110.003893.2712122.66951.11194.5353120.95859.295494.5540127.83466.575294.3815139.94574.300394.1334ZK1095.843259.2714105.3558ZK1194.768274.5841105.2710ZK530.918280.1104108.0343ZK933.046239.1515105.1210ZK6

4、65.441176.475089.4322ZK125.026179.552789.2944ZK24.5870.170989.4720ZK334.419359.593189.5030ZK774.508359.454389.565075.24530.392690.312292.58740.402590.1423107.00041.281290.1108129.97543.574890.0115137.46847.084689.5048137.45150.065089.5813133.22958.350190.1310144.04468.540390.092192.58740.402590.1423

5、方位角：距离：测距方式：测站高程：102.838858942.6533831856.167标高：编号水平角：地物代码：纯度角Y=X=弧度角高程：方位角1.6347 149.2905555618386282.2642724024.5302.605611741849.6544.400488421.6348 135.4233333318386285.7612724015.7062.363583051846.6664.158459741.6349 130.5311111118386286.8082724012.2842.278197671845.7724.073074352.6350 122.8019

6、444418386275.8782723993.9632.143298261846.0873.938174951.6351 130.7575000018386260.9312723993.4032.282148901849.5694.077025581.6352 128.9316666718386246.8722723979.3832.250282091845.7984.045158781.6353 126.5433333318386235.5432723964.5992.208597811845.5024.003474501.6354 120.7988888918386237.6942723

7、950.8382.108338341845.4483.903215031.6355 120.5163888918386222.1382723933.5122.103407791845.4813.898284481.6356 120.0597222218386203.0292723911.2892.095437451845.6523.890314141.6357 110.0105555618386224.9072723890.1911.92004641注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！184

8、5.5033.714923091.6358 130.8425000018386279.9402724007.5102.283632431847.6224.078509111.6359ZK8120.2900000018386297.0802724012.6972.099456561846.3023.894333241.6360ZK482.0263888918386317.0022724008.6561.431630561846.1823.226507251.6361 80.7055555618386317.5312724006.7651.408577671845.6193.203454361.6

9、362 45.6300000018386339.3292724003.9680.796393741846.1452.591270431.6363 32.0447222218386351.4882724004.5100.559285911847.7622.354162601.6364 41.5975000018386346.1902723998.9850.726013341845.5932.520890021.6365 50.1683333318386347.7962723980.6930.875602601845.5552.670479281.6366 51.1238888918386351.

10、4422723970.8500.892280191845.6362.687156871.6367 49.4827777818386356.5992723965.5230.863637401845.7182.658514081.6368 49.1161111118386360.5822723959.1380.857237851845.6222.652114541.6369 48.8063888918386365.3332723951.3320.851832181845.5022.646708871.6370 48.6797222218386371.2262723940.9190.84962143

11、1845.5262.644498121.6371 50.0544444418386375.5312723926.7830.873614861846.2862.668491551.61.6372 51.1850000018386372.9042723926.6210.893346781845.5382.688223461.6373 59.4983333318386355.9372723921.6651.038441821845.6222.833318501.6374 66.9644444418386341.9282723911.0921.168750041845.6762.963626721.6

12、375 74.5008333318386325.8502723897.0811.300284841845.6993.095161521.6376ZK10259.4538888918386323.0652724128.7344.528324621830.2390.040016001.6377ZK11274.9780555618386347.3212724123.4564.799272441830.7620.310963821.6378ZK5280.1844444418386330.8682724063.5484.890141071846.4260.401832452.6379ZK9239.254

13、1666718386309.5672724066.8404.175772961846.3465.970649641.6380ZK6176.7972222218386254.8552724047.4493.085693641856.3294.880570321.6381ZK1179.9241666718386294.9652724042.0243.140269111856.2324.935145801.6382ZK20.2858333318386323.8392724035.4530.004988731856.0291.799865421.6383ZK3359.9919444418386352.

14、9312724028.8526.283044711856.1071.794736091.6384ZK7359.7619444418386392.0852724020.2416.279030451856.0811.790721831.6385 30.6572222218386373.9542723984.7060.535069471855.3252.329946151.6386 40.6736111118386374.4282723962.0570.709888431855.6252.504765121.6387 41.4700000018386381.7972723949.5930.72378

15、8041855.6652.518664731.6388 43.9633333318386390.5372723927.7340.767304921855.9652.562181601.6389 47.1461111118386388.1372723917.4630.822854871856.3802.617731561.6390 50.1138888918386381.8742723914.0770.874652361856.0832.669529051.6391 58.5836111118386361.8172723910.2091.022476901855.5022.817353591.6

16、392 68.9008333318386340.0672723893.9461.202546401855.6202.99742309 1.6 仪器高：(m)1.445垂直角：编号， 地物代码 ，Y=，纯度角弧度角347, ,18386282.264,99.261111111.73243321-0.16163688348, ,18386285.761,103.304444441.80300269-0.23220636349, ,18386286.808,104.163055561.81798828-0.24719195350, ,18386275.878,98.346666671.7164731

17、4-0 ,18386260.931,95.071111111.65930391-0.08850759352, ,18386246.872,96.315277781.68101872-0.11022239353, ,18386235.543,95.436388891.66567921-0.09488289354, ,18386237.694,95.100555561.65981781-0.08902149355, ,18386222.138,94.252222221.64501161-0.07421528356, ,18386203.029,93.468611111.6

18、3133501-0.06053868357, ,18386224.907,93.453333331.63106836-0.06027204358, ,18386279.940,99.728055561.74058293-0.16978660359,ZK8,18386297.080,106.582777781.86022040-0.28942407360,ZK4,18386317.002,109.383888891.90910901-0.33831268361, ,18386317.531,109.235277781.90651526-0.33571893362, ,18386339.329,1

19、04.496944441.82381574-0.25301941363, ,18386351.488,100.316111111.75084643-0 ,18386346.190,102.732500001.79302037-0.22222405365, ,18386347.796,99.479722221.73624869-0.16545236366, ,18386351.442,98.083055561.71187226-0 ,18386356.599,97.319166671.69853988-0.12774356368, ,18386

20、360.582,96.760277781.68878543-0.11798911369, ,18386365.333,96.198333331.67897765-0.10818132370, ,18386371.226,95.508055561.66693003-0.09613370371, ,18386375.531,94.511944441.64954461-0.07874829357, ,18386224.907,372, ,18386372.904,94.898055561.65628352-0.08548720373, ,18386355.937,94.927777781.65680

21、227-0.08600595374, ,18386341.928,94.637500001.65173597-0.08093964375, ,18386325.850,94.226111111.64455588-0.07375955376,ZK10,18386323.065,105.599444441.84305799-0.27226167377,ZK11,18386347.321,105.452777781.84049818-0.26970185378,ZK5,18386330.868,108.061944441.88603673-0.31524040379,ZK9,18386309.567

22、,105.202777781.83613485-0.26533853380,ZK6,18386254.855,89.722777781.565957890.00483844381,ZK1,18386294.965,89.495555561.561992110.00880422382,ZK2,18386323.839,89.788888891.567111740.00368458383,ZK3,18386352.931,89.841666671.568032890.00276344384,ZK7,18386392.085,89.947222221.569875180.00092115385, ,

23、18386373.954,90.522777781.57992052-0.00912419386, ,18386374.428,90.239722221.57498027-0.00418394387, ,18386381.797,90.185555561.57403488-0.00323856388, ,18386390.537,90.020833331.57115994-0.00036361389, ,18386388.137,89.846666671.568120160.00267617390, ,18386381.874,89.970277781.570277580.0005187539

24、1, ,18386361.817,90.219444441.57462635-0.00383003392, ,18386340.067,90.155833331.57351613-0.00271980 386, ,18386374.428, X=，H=2724024.530,1849.6542724015.706,1846.6662724012.284,1845.7722723993.963,1846.0872723993.403,1849.5692723979.383,1845.7982723964.599,1845.5022723950.838,1845.4482723933.512,18

25、45.4812723911.289,1845.6522723890.191,1845.5032724007.510,1847.6222724012.697,1846.3022724008.656,1846.1822724006.765,1845.6192724003.968,1846.1452724004.510,1847.7622723998.985,1845.5932723980.693,1845.5552723970.850,1845.6362723965.523,1845.7182723959.138,1845.6222723951.332,1845.5022723940.919,18

26、45.5262723926.783,1846.2862723890.191,1845.5032723926.621,1845.5382723921.665,1845.6222723911.092,1845.6762723897.081,1845.6992724128.734,1830.2392724123.456,1830.7622724063.548,1846.4262724066.840,1846.3462724047.449,1856.3292724042.024,1856.2322724035.453,1856.0292724028.852,1856.1072724020.241,18

27、56.0812723984.706,1855.3252723962.057,1855.6252723949.593,1855.6652723927.734,1855.9652723917.463,1856.3802723914.077,1856.0832723910.209,1855.5022723893.946,1855.620 2723962.057,1855.625 测站点坐标：定向点坐标：X=Y=X=Y=2724036.495018386319.37202724027.017018386360.9590注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只

28、需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！地物代码：斜距：水平角：垂直角：ZK1297.57835.000089.5231方位角：距离：测距方式：测站高程：102.838858942.6533831856.167标高：编号水平角：地物代码：纯度角Y=X=弧度角高程：方位角1.6393ZK1235.0000000018386384.8682723964.1650.610865241856.3482.40574193 注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！ 仪器高：(m)1.569垂

29、直角：编号， 地物代码 ，Y=，纯度角弧度角393,ZK12,18386384.868,89.875277781.568619510.00217681 X=，H=2723964.165,1856.348 测站点坐标：定向点坐标：X=Y=X=Y=2723969.59918386408.3592724036.495018386319.372注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！地物代码：斜距：水平角：垂直角：ZK1316.67871.3929118.1254ZK1460.16771.3929101

30、.140655.14571.3929102.434555.10571.3929103.163347.38071.3929105.292646.98571.3929104.592734.33271.3929108.182524.00771.3929113.152813.46971.3929118.09246.38171.3929116.42432.25371.3929103.12215.902301.4115100.555110.700301.4115102.062212.028301.4115106.262215.057301.4115103.421226.857301.4115104.505

31、22.25371.3929103.1221方位角：距离：测距方式：测站高程：306.9340244111.3272701867.555标高：编号水平角：地物代码：纯度角Y=X=弧度角高程：方位角2.6394ZK1371.6580555618386413.0452723983.5281.250669011858.6280.324493011.6395ZK1471.6580555618386427.1742724025.5331.250669011855.7900.324493011.6396 71.6580555618386425.5092724020.5821.250669011855.362

32、0.324493012.6397 71.6580555618386425.4592724020.4321.250669011853.8590.324493012.6398 71.6580555618386422.9162724012.8751.250669011853.8590.324493011.6399 71.6580555618386422.8292724012.6161.250669011855.3600.324493011.6400 71.6580555618386418.7512724000.4921.250669011856.7290.324493011.6401 71.6580

33、555618386415.3912723990.5041.250669011858.0330.324493013.6402 71.6580555618386412.1452723980.8541.250669011859.1570.324493011.6403 71.6580555618386410.1762723975.0021.250669011864.6450.324493011.6404 71.6580555618386409.0582723971.6781.25066901注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏

34、中中输输入入1 1即即可可！1866.9980.324493011.6405 301.6875916718386402.9632723967.4875.265441791866.3944.339265791.6406 301.6875916718386398.6172723965.7855.265441791865.2694.339265792.6407 301.6875916718386397.6162723965.3945.265441791863.1094.339265792.6408 301.6875916718386394.7372723964.2675.265441791862.9

35、464.339265793.6409 301.6875916718386384.1852723960.1365.265441791858.6314.33926579 1.6 仪器高：(m)1.558垂直角：编号， 地物代码 ，Y=，纯度角弧度角394,ZK13,18386413.045,118.215000002.06324098-0.49244465395,ZK14,18386427.174,101.235000001.76688407-0.19608774396, ,18386425.509,102.729166671.79296220-0.22216587397, ,18386425.4

36、59,103.275833331.80250333-0.23170700398, ,18386422.916,105.490555561.84115752-0.27036120399, ,18386422.829,104.990833331.83243573-0.26163940400, ,18386418.751,108.306944441.89031278-0.31951646401, ,18386415.391,113.257777781.97672113-0.40592480402, ,18386412.145,118.156666672.06222287-0.49142654403,

37、 ,18386410.176,116.711944442.03700771-0.46621138404, ,18386409.058,103.205833331.80128160-0.23048527405, ,18386402.963,100.930833331.76157536-0.19077903406, ,18386398.617,102.106111111.78208783-0.21129150407, ,18386397.616,106.439444441.85771876-0.28692243408, ,18386394.737,103.703333331.80996461-0.

38、23916829409, ,18386384.185,104.847777781.82993894-0.25914261 404, ,18386409.058, X=，H=2723983.528,1858.6282724025.533,1855.7902724020.582,1855.3622724020.432,1853.8592724012.875,1853.8592724012.616,1855.3602724000.492,1856.7292723990.504,1858.0332723980.854,1859.1572723975.002,1864.6452723971.678,18

39、66.9982723967.487,1866.3942723965.785,1865.2692723965.394,1863.1092723964.267,1862.9462723960.136,1858.631 2723971.678,1866.998 测站点坐标：定向点坐标：X=Y=X=Y=2724027.37918386427.7952723969.59918386408.359注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！地物代码：斜距：水平角：垂直角：7.368180.0000106.143

40、7z150.975180.000092.3859方位角：距离：测距方式：测站高程：198.591877660.9613521856.026标高：编号水平角：地物代码：纯度角Y=X=弧度角高程：方位角3.6410 180.0000000018386430.0502724034.0843.141592651851.8870.324489481.6411z1180.0000000018386444.0302724075.6423.141592651853.5910.32448948 注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏中中输

41、输入入1 1即即可可！ 仪器高：(m)1.522垂直角：编号， 地物代码 ，Y=，纯度角弧度角410, ,18386430.050,106.243611111.85430082-0.28350450411,z1,18386444.030,92.649722221.61704270-0.04624638 X=，H=2724034.084,1851.8872724075.642,1853.591 测站点坐标：定向点坐标：X=Y=X=Y=2724075.64218386444.0302724027.37918386427.795注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视

42、距距法法只只需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！地物代码：斜距：水平角：垂直角：25.9750.0000119.291823.8620.0000122.0110方位角：距离：测距方式：测站高程：198.591877650.9204991853.591标高：编号水平角：地物代码：纯度角Y=X=弧度角高程：方位角1.6412 0.0000000018386436.8212724054.2120.000000001840.8183.466082133.6413 0.0000000018386437.5792724056.4660.000000001838.9523.4660821

43、3 注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！ 仪器高：(m)1.613垂直角：编号， 地物代码 ，Y=，纯度角弧度角412, ,18386436.821,119.488333332.08546483-0.51466851413, ,18386437.579,122.019444442.12964106-0.55884473 X=，H=2724054.212,1840.8182724056.466,1838.952 测站点坐标：定向点坐标：X=Y=X=Y=注注意意：默默认认的的测测距距方方式式为为

44、测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！地物代码：斜距：水平角：垂直角：方位角：距离：测距方式：测站高程：是同一点，方位角不存在0.0000000标高：编号水平角：地物代码：纯度角Y=X=弧度角高程：方位角168 注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！ 仪器高：(m)垂直角：编号， 地物代码 ，Y=，纯度角弧度角168 X=，H= 测站点坐标：定向点坐标：X=Y=X=Y=注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为

45、为视视距距法法只只需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！地物代码：斜距：水平角：垂直角：方位角：距离：测距方式：测站高程：是同一点，方位角不存在标高：编号水平角：地物代码：纯度角Y=X=弧度角高程：方位角94 注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！ 仪器高：(m)垂直角：编号， 地物代码 ，Y=，纯度角弧度角94 X=，H= 测站点坐标：定向点坐标：X=Y=X=Y=注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏

46、中中输输入入1 1即即可可！地物代码：斜距：水平角：垂直角：方位角：距离：测距方式：测站高程：是同一点，方位角不存在标高：编号水平角：地物代码：纯度角Y=X=弧度角高程：方位角610 注注意意：默默认认的的测测距距方方式式为为测测距距法法，要要变变为为视视距距法法只只需需在在测测距距方方式式栏栏中中输输入入1 1即即可可！ 仪器高：(m)垂直角：编号， 地物代码 ，Y=，纯度角弧度角610 X=，H= 347 18386282.2642724024.5301849.654348 18386285.7612724015.7061846.666349 18386286.8082724012.284

47、1845.772350 18386275.8782723993.9631846.087351 18386260.9312723993.4031849.569352 18386246.8722723979.3831845.798353 18386235.5432723964.5991845.502354 18386237.6942723950.8381845.448355 18386222.1382723933.5121845.481356 18386203.0292723911.2891845.652357 18386224.9072723890.1911845.503358 18386279

48、.9402724007.5101847.622359ZK818386297.0802724012.6971846.302360ZK418386317.0022724008.6561846.182361 18386317.5312724006.7651845.619362 18386339.3292724003.9681846.145363 18386351.4882724004.5101847.762364 18386346.1902723998.9851845.593365 18386347.7962723980.6931845.555366 18386351.4422723970.8501

49、845.636367 18386356.5992723965.5231845.718368 18386360.5822723959.1381845.622369 18386365.3332723951.3321845.502370 18386371.2262723940.9191845.526371 18386375.5312723926.7831846.286372 18386372.9042723926.6211845.538373 18386355.9372723921.6651845.622374 18386341.9282723911.0921845.676375 18386325.

50、8502723897.0811845.699376ZK1018386323.0652724128.7341830.239377ZK1118386347.3212724123.4561830.762378ZK518386330.8682724063.5481846.426379ZK918386309.5672724066.8401846.346380ZK618386254.8552724047.4491856.329381ZK118386294.9652724042.0241856.232382ZK218386323.8392724035.4531856.029383ZK318386352.93

51、12724028.8521856.107384ZK718386392.0852724020.2411856.081385 18386373.9542723984.7061855.325386 18386374.4282723962.0571855.625387 18386381.7972723949.5931855.665388 18386390.5372723927.7341855.965389 18386388.1372723917.4631856.380390 18386381.8742723914.0771856.083391 18386361.8172723910.2091855.5

52、02392 18386340.0672723893.9461855.620393ZK1218386384.8682723964.1651856.348394ZK1318386413.0452723983.5281858.628395ZK1418386427.1742724025.5331855.790396 18386425.5092724020.5821855.362397 18386425.4592724020.4321853.859398 18386422.9162724012.8751853.859399 18386422.8292724012.6161855.360400 18386

53、418.7512724000.4921856.729401 18386415.3912723990.5041858.033402 18386412.1452723980.8541859.157403 18386410.1762723975.0021864.645404 18386409.0582723971.6781866.998405 18386402.9632723967.4871866.394406 18386398.6172723965.7851865.269407 18386397.6162723965.3941863.109408 18386394.7372723964.26718

54、62.946409 18386384.1852723960.1361858.631410 18386430.0502724034.0841851.887411z118386444.0302724075.6421853.591412 18386436.8212724054.2121840.818413 18386437.5792724056.4661838.952414坝右18386360.962724027.0171856.113415坝中18386319.3722724036.4951856.034416坝左18386288.3162724043.5731856.176417隧洞进口1838

55、6375.5232723956.7451855.398418隧洞转角18386408.3592723969.5991867.422419隧洞出口18386427.7952724027.3791855.893 168 394ZK1318386413.0452723983.5281858.628395ZK1418386427.1742724025.5331855.790396 18386425.5092724020.5821855.362397 18386425.4592724020.4321853.859398 18386422.9162724012.8751853.859399 1838642

56、2.8292724012.6161855.360400 18386418.7512724000.4921856.729401 18386415.3912723990.5041858.033402 18386412.1452723980.8541859.157403 18386410.1762723975.0021864.645404 18386409.0582723971.6781866.998405 18386402.9632723967.4871866.394406 18386398.6172723965.7851865.269407 18386397.6162723965.3941863

57、.109408 18386394.7372723964.2671862.946409 18386384.1852723960.1361858.631 393ZK1218386384.8682723964.1651856.348 410 18386430.0502724034.0841851.887411z118386444.0302724075.6421853.591 412 18386436.8212724054.2121840.818413 18386437.5792724056.4661838.952 1 18386360.9622724027.0161856.1132 18386300

58、.1622724012.7271846.1043 18386323.7532724008.7341846.0034 18386344.8692724007.9861847.4115 18386353.8842723980.7531849.5316 18386336.5302723973.2471836.8997 18386321.1582723981.9441837.0198 18386308.7452723990.3801839.1019 18386283.8282723982.0231837.31510 18386271.3022723957.1741836.30411 18386285.

59、4882723938.9061830.69712 18386323.7962723929.0941835.97113 18386330.3902723959.1521832.92314 18386332.1222723971.8271835.91115 18386334.5142723984.5491839.21916 18386339.9082724007.2791846.92817 18386279.5662724033.7821852.92318 18386296.1142724030.6651852.95919 18386324.2412724024.8741852.86620 183

60、86343.0502724020.8991852.98321 18386367.6322724013.8131852.94522 18386400.5772724013.4481856.10023 18386405.1242724015.0841855.88824 18386401.7322724023.5471856.25925 18386395.2102724016.1511856.17926 18386385.0302724025.9751856.32727 18386379.1482724019.9951856.20628 18386377.8722724027.2121856.291