计算俩点间距离、方位角.xls

计算两点间距离、方位角 后 视 测 站 两点之间距离 （m） 起始方位角 （ ′ ″） XYXY 2711593.11449702.062714486.712449727.6262893.71718030′22″ 2717767.33448851.702720093.244447824.962542.45315610′54″ 3894083.30388845.073894081.691388845.44771.65234647′13″ 3893756.53388974.813893754.961388975.17211.6113470′31″ 3893590.25389183.893893588.701389184.2271.58634743′47″ 3893447.28389348.603893445.748389348.91731.56534818′6″ 3893301.57389531.513893300.055389531.80531.54334858′11″ 3893159.83389687.393893158.332389687.66661.52334932′16″ 3892855.54389655.583892854.079389655.86041.4883498′19″ 3892516.45389626.153892515.029389626.4341.44934841′44″ 3892040.23389541.663892038.867389541.95411.39534749′41″ 3891327.79389566.873891326.512389567.16111.31134710′9″ 3891092.98389506.953891091.73389507.24831.28534634′37″ 3891077.10389635.533891075.852389635.81281.28034713′56″ 3890759.02389649.803890757.81389650.08111.24234655′9″ 3889907.11389503.313889906.002389503.60871.14734454′27″ 3889439.37389669.853889438.319389670.12871.0883459′18″ 3888776.69389892.783888775.718389893.0321.00434527′56″ 3888562.76390031.433888561.814390031.66530.9753462′11″ 3888133.56390269.043888132.665390269.24680.91834659′12″ 3887988.38390350.623887987.503390350.8170.89934720′43″ 3887540.61390274.783887539.786390274.98610.84934557′8″ 3886979.09390208.083886978.334390208.29410.78634411′38″ 3886748.85390126.663886748.121390126.88390.76234255′12″ 3886262.99390047.993886262.32390048.22330.71034048′43″ 3885881.99389919.703885881.365389919.94870.67233817′20″ 3885406.58389838.173885406.012389838.42850.62433530′51″ 3885341.90389655.063885341.34389655.34050.62633323′9″ 3884767.33389626.433884766.839389626.71390.56732957′29″ 3884238.51389664.793884238.083389665.06930.51132650′9″ 3883896.26389625.513883895.874389625.7940.48032341′4″ 3883494.10389587.453883493.762389587.73860.44531930′58″ 3883210.89389548.293883210.586389548.58330.4223162′9″ 3883009.76389612.323883009.48389612.60560.40031425′58″ 3882835.78389854.053882835.521389854.30660.36531516′40″ 3882501.98390268.593882501.761390268.79690.30131638′25″ 3882360.28390553.663882360.078390553.83270.26631929′7″ 3881874.30391079.683881874.156391079.78960.18132241′11″ 3881329.43391515.713881329.352391515.76720.09732353′9″ 3880676.02391992.733880676.04391992.770.04524326′6″ 3880302.02392108.913880302.065392108.89610.04716247′55″ 3879793.82392330.953879793.926392330.90940.1131591′27″ 3879523.33392935.813879523.468392935.69680.17914041′58″ 3879077.25393212.343879077.442393212.19370.24114239′52″ 3878430.62393600.883878430.889393600.6870.33114422′55″ 3878070.20393796.483878070.513393796.26360.38014518′55″ 3877691.20394076.333877691.558394076.080.4371454′48″ 3877321.25394488.153877321.653394487.85060.50214321′23″ 3877256.60394861.693877257.01394861.34580.5361400′24″ 3877159.72395243.513877160.142395243.120.57513715′0″ 3876967.50395834.623876967.945395834.1590.64113359′18″ 3876871.22396088.093876871.677396087.59860.67113253′29″ 0.00000′0″ 3876327.552396469.84273876327.03396470.380.7493149′42″ 3875948.527397089.67843875947.96397090.290.83431250′53″ 3875663.132397400.20113875662.53397400.850.88531249′45″ 3875110.628397852.39683875109.96397853.100.97031331′15″ 3874805.824398298.07343874805.12398298.831.03431257′14″ 3873765.079398431.20743873764.25398431.981.1333171′38″ 3873684.439398919.28883873683.60398920.121.18131516′3″ 3873612.448399419.41883873611.60399420.311.23031333′49″ 3873307.134400110.65583873306.25400111.631.31631213′50″ 3873229.104400659.83993873228.21400660.881.37131040′3″ 3873083.681401273.68633873082.77401274.801.43930917′10″ 3872907.152401889.54243872906.22401890.731.5103087′59″ 3872253.361401901.65093872252.35401902.841.56131021′49″ 3871775.608402298.94333871774.54402300.181.63431048′49″ 3871467.655402651.2513871466.55402652.531.69031049′32″ 3870890.804402949.11523870889.63402950.431.76331146′1″ 3870487.913403373.59433870486.69403374.961.83331150′8″ 3875716.540396856.8833875717.135396856.29940.83413533′32″ 3875353.697397049.1233875354.336397048.51630.88113628′3″ 3874137.168398007.8293874137.953398007.10731.06613723′28″ 3873010.712398927.8363873011.632398927.00391.24013751′46″ 3872611.041399628.2643872612.009399627.34781.33313633′57″ 3872124.357399919.1983872125.383399918.24691.39913710′20″ 3872200.398400556.0183872201.415400554.99051.44613442′21″ 3871480.741401187.5063871481.844401186.40281.5601350′9″ 3871023.432401490.2523871024.59401489.11241.62513527′50″ 3870491.566401800.1283870492.788401798.95131.6961364′55″ 3870005.415402372.1903870006.695402370.94461.78613547′30″ 3869535.742403038.1253869537.079403036.79971.88213514′43″ 3869153.326403343.3173869154.709403341.95511.94113525′56″ 13464.2432250′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 0.00000′0″ 计算两点间距离、方位角 后 视 X 后 视 Y 测 站 X 测 站 Y 起始方位角（ ） 两点之间距离 （m） 起始方位角 （ ′ ″） 3894484.66388348.713894483.003388349.1472345.21763321.714345 133 3894367.98388578.393894366.337388578.7997345.99658661.693345 59 48 3894083.30388845.073894081.691388845.4477346.7870771.652346 47 13 3893756.53388974.813893754.961388975.1721347.00858261.611347031 3893590.25389183.893893588.701389184.227347.72985341.586347 43 47 3893447.28389348.603893445.748389348.9173348.30160561.565348 186 3893301.57389531.513893300.055389531.8053348.9696351.543348 58 11 3893159.83389687.393893158.332389687.6666349.53770081.523349 32 16 3892855.54389655.583892854.079389655.8604349.13861381.488349819 3892516.45389626.153892515.029389626.434348.69549661.449348 41 44 3892040.23389541.663892038.867389541.9541347.82806941.395347 49 41 3891327.79389566.873891326.512389567.1611347.16919171.311347 109 3891092.98389506.953891091.73389507.2483346.57693281.285346 34 37 3891077.10389635.533891075.852389635.8128347.23225081.280347 13 56 3890759.02389649.803890757.81389650.0811346.91928761.242346 559 3889907.11389503.313889906.002389503.6087344.90739781.147344 54 27 3889439.37389669.853889438.319389670.1287345.15511.088345918 3888776.69389892.783888775.718389893.032345.46554491.004345 27 56 3888562.76390031.433888561.814390031.6653346.03643610.975346211 3888133.56390269.043888132.665390269.2468346.98667870.918346 59 12 3887988.38390350.623887987.503390350.817347.34541350.899347 20 43 3887540.61390274.783887539.786390274.9861345.95230030.849345 578 3886979.09390208.083886978.334390208.2941344.19378060.786344 11 38 3886748.85390126.663886748.121390126.8839342.9199270.762342 55 12 3886262.99390047.993886262.32390048.2233340.81204240.710340 48 43 3885881.99389919.703885881.365389919.9487338.28879760.672338 17 20 3885406.58389838.173885406.012389838.4285335.51422960.624335 30 51 3885341.90389655.063885341.34389655.3405333.38584170.626333 239 3884767.33389626.433884766.839389626.7139329.95810920.567329 57 29 3884238.51389664.793884238.083389665.0693326.83593830.511326 509 3883896.26389625.513883895.874389625.794323.68449860.480323 414 3883494.10389587.453883493.762389587.7386319.51614040.445319 30 58 3883210.89389548.293883210.586389548.5833316.03569980.42231629 3883009.76389612.323883009.48389612.6056314.43273360.400314 25 58 3882835.78389854.053882835.521389854.3066315.27775510.365315 16 40 3882501.98390268.593882501.761390268.7969316.64041670.301316 38 25 3882360.28390553.663882360.078390553.8327319.48520180.266319 297 3881874.30391079.683881874.156391079.7896322.68644920.181322 41 11 3881329.43391515.713881329.352391515.7672323.88581490.097323 539 3880676.02391992.733880676.02391992.73FALSE0.000000 3880302.02392108.913880302.065392108.8961162.79868630.047162 47 55 3879793.82392330.953879793.926392330.9094159.02414810.113159127 3879523.33392935.813879523.468392935.6968140.69931480.179140 41 58 3879077.25393212.343879077.442393212.1937142.66456360.241142 39 52 3878430.62393600.883878430.889393600.687144.38192970.331144 22 55 3878070.20393796.483878070.513393796.2636145.31532850.380145 18 55 3877691.20394076.333877691.558394076.08145.07998910.437145448 3877321.25394488.153877321.653394487.8506143.35625070.502143 21 23 3877256.60394861.693877257.01394861.3458140.00676770.536140024 3877159.72395243.513877160.142395243.12137.25002550.575137 150 3876967.50395834.623876967.945395834.159133.98825920.641133 59 18 3876871.22396088.093876871.677396087.5986132.89142330.671132 53 29 FALSE0.000000 3876327.552396469.84273876327.03396470.38314.16153230.749314942 3875948.527397089.67843875947.96397090.29312.8479860.834312 50 53 3875663.132397400.20113875662.53397400.85312.82907860.885312 49 45 3875110.628397852.39683875109.96397853.10313.5209190.970313 31 15 3874805.824398298.07343874805.12398298.83312.95375221.034312 57 14 3873765.079398431.20743873764.25398431.98317.02716461.133317138 3873684.439398919.28883873683.60398920.12315.2675751.181315 163 3873612.448399419.41883873611.60399420.31313.56362281.230313 33 49 3873307.134400110.65583873306.25400111.63312.23062751.316312 13 50 3873229.104400659.83993873228.21400660.88310.66746281.371310 403 3873083.681401273.68633873082.77401274.80309.28604491.439309 17 10 3872907.152401889.54243872906.22401890.73308.13292861.510308759 3872253.361401901.65093872252.35401902.84310.36355751.561310 21 49 3871775.608402298.94333871774.54402300.18310.81351581.634310 48 49 3871467.655402651.2513871466.55402652.53310.82557911.690310 49 32 3870890.804402949.11523870889.63402950.43311.76688051.763311 461 3870487.913403373.59433870486.69403374.96311.83549531.833311 508 3875716.540396856.8833875717.135396856.2994135.55898920.834135 33 32 3875353.697397049.1233875354.336397048.5163136.4673860.881136 283 3874137.168398007.8293874137.953398007.1073137.39116511.066137 23 28 3873010.712398927.8363873011.632398927.0039137.86273151.240137 51 46 3872611.041399628.2643872612.009399627.3478136.56589941.333136 33 57 3872124.357399919.1983872125.383399918.2469137.17232661.399137 10 20 3872200.398400556.0183872201.415400554.9905134.70574691.446134 42 21 3871480.741401187.5063871481.844401186.4028135.00259671.56013509 3871023.432401490.2523871024.59401489.1124135.4637821.625135 27 50 3870491.566401800.1283870492.788401798.9513136.08191531.696136455 3870005.415402372.1903870006.695402370.9446135.79165991.786135 47 30 3869535.742403038.1253869537.079403036.7997135.24536731.882135 14 43 3869153.326403343.3173869154.709403341.9551135.43213711.941135 25 56 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 FALSE0.000000 34513′3″ 34559′48″ 34647′13″ 3470′31″ 34743′47″ 34818′6″ 34858′11″ 34932′16″ 3498′19″ 34841′44″ 34749′41″ 34710′9″ 34634′37″ 34713′56″ 34655′9″ 34454′27″ 3459′18″ 34527′56″ 3462′11″ 34659′12″ 34720′43″ 34557′8″ 34411′38″ 34255′12″ 34048′43″ 33817′20″ 33530′51″ 33323′9″ 32957′29″ 32650′9″ 32341′4″ 31930′58″ 3162′9″ 31425′58″ 31516′40″ 31638′25″ 31929′7″ 32241′11″ 32353′9″ 00′0″ 16247′55″ 1591′27″ 14041′58″ 14239′52″ 14422′55″ 14518′55″ 1454′48″ 14321′23″ 1400′24″ 13715′0″ 13359′18″ 13253′29″ 00′0″ 3149′42″ 31250′53″ 31249′45″ 31331′15″ 31257′14″ 3171′38″ 31516′3″ 31333′49″ 31213′50″ 31040′3″ 30917′10″ 3087′59″ 31021′49″ 31048′49″ 31049′32″ 31146′1″ 31150′8″ 13533′32″ 13628′3″ 13723′28″ 13751′46″ 13633′57″ 13710′20″ 13442′21″ 1350′9″ 13527′50″ 1364′55″ 13547′30″ 13514′43″ 13525′56″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″ 00′0″