计算已知点间的距离、方位角-道路工程Excel计算系列_图文

1、后 视XY计算两点间距离、方位角测 站XY起始方位角象 限 角（°）（°）85.2015086265.201508685.201508685.2015085649678.2549694.283894083.30322709.25322900.13388845.0749694.2849678.25322900.13322709.253894081.691388845.4477-13.212923346.7870773893756.533893590.253893447.283893301.573893159.833892855.543892516.453892040.2338

2、91327.793891092.983891077.103890759.023889907.113889439.373888776.693888562.763888133.563887988.383887540.613886979.093886748.853886262.993885881.993885406.583885341.903884767.333884238.513883896.263883494.103883210.893883009.763882835.78388974.81389183.89389348.60389531.51389687.39389655.58389626.1

3、5389541.66389566.87389506.95389635.53389649.80389503.31389669.85389892.78390031.43390269.04390350.62390274.78390208.08390126.66390047.99389919.70389838.17389655.06389626.43389664.79389625.51389587.45389548.29389612.32389854.053893754.9613893588.7013893445.7483893300.0553893158.3323892854.0793892515.

4、0293892038.8673891326.5123891091.733891075.8523890757.813889906.0023889438.3193888775.7183888561.8143888132.6653887987.5033887539.7863886978.3343886748.1213886262.323885881.3653885406.0123885341.343884766.8393884238.0833883895.8743883493.7623883210.5863883009.483882835.521388975.1721389184.227389348

5、.9173389531.8053389687.6666389655.8604389626.434389541.9541389567.1611389507.2483389635.8128389650.0811389503.6087389670.1287389893.032390031.6653390269.2468390350.817390274.9861390208.2941390126.8839390048.2233389919.9487389838.4285389655.3405389626.7139389665.0693389625.794389587.7386389548.583338

6、9612.6056389854.3066-12.991417347.0085826-12.270147347.7298534-11.698394348.3016056-11.030365348.969635-10.462299349.5377008-10.861386349.1386138-11.304503348.6954966-12.171931347.8280694-12.830808347.1691917-13.423067346.5769328-12.767749347.2322508-13.080712346.9192876-15.092602344.9073978-14.8449

7、345.1551-14.534455345.4655449-13.963564346.0364361-13.013321346.9866787-12.654586347.3454135-14.0477345.9523003-15.806219344.1937806-17.080073342.919927-19.187958340.8120424-21.711202338.2887976-24.48577335.5142296-26.614158333.3858417-30.041891329.9581092-33.164062326.8359383-36.315501323.6844986-4

8、0.48386319.5161404-43.9643316.0356998-45.567266314.4327336-44.722245315.27775513882501.983882360.283881874.303881329.433880676.023880302.023879793.823879523.333879077.25390268.59390553.66391079.68391515.71391992.73392108.91392330.95392935.81393212.343882501.7613882360.0783881874.1563881329.352388067

9、6.043880302.0653879793.9263879523.4683879077.442390268.7969390553.8327391079.7896391515.7672391992.77392108.8961392330.9094392935.6968393212.1937-43.359583-40.514798-37.313551-36.11418563.4349488-17.201314-20.975852-39.300685-37.335436316.6404167319.4852018322.6864492323.8858149243.4349488162.798686

10、3159.0241481140.6993148142.66456363878430.623878070.203877691.203877321.253877256.603877159.723876967.503876871.223876327.5523875948.5273875663.1323875110.6283874805.8243873765.0793873684.4393873612.4483873307.1343873229.1043873083.6813872907.1523872253.3613871775.6083871467.6553870890.8043870487.91

11、33875716.5403875353.6973874137.1683873010.7123872611.0413872124.3573872200.3983871480.7413871023.4323870491.5663870005.4153869535.742393600.88393796.48394076.33394488.15394861.69395243.51395834.62396088.09396469.8427397089.6784397400.2011397852.3968398298.0734398431.2074398919.2888399419.4188400110.

12、6558400659.8399401273.6863401889.5424401901.6509402298.9433402651.251402949.1152403373.5943396856.883397049.123398007.829398927.836399628.264399919.198400556.018401187.506401490.252401800.128402372.190403038.1253878430.8893878070.5133877691.5583877321.6533877257.013877160.1423876967.9453876871.67738

13、76327.033875947.963875662.533875109.963874805.123873764.253873683.603873611.603873306.253873228.213873082.773872906.223872252.353871774.543871466.553870889.633870486.693875717.1353875354.3363874137.9533873011.6323872612.0093872125.3833872201.4153871481.8443871024.593870492.7883870006.6953869537.0793

14、93600.687393796.2636394076.08394487.8506394861.3458395243.12395834.159396087.5986396470.38397090.29397400.85397853.10398298.83398431.98398920.12399420.31400111.63400660.88401274.80401890.73401902.84402300.18402652.53402950.43403374.96396856.2994397048.5163398007.1073398927.0039399627.3478399918.2469

15、400554.9905401186.4028401489.1124401798.9513402370.9446403036.7997-35.61807144.3819297-34.684672145.3153285-34.920011145.0799891-36.643749143.3562507-39.993232140.0067677-42.749974137.2500255-46.011741133.9882592-47.108577132.8914233#DIV/0!FALSE -45.838468314.1615323-47.152014312.847986-47.170921312

16、.8290786-46.479081313.520919-47.046248312.9537522-42.972835317.0271646-44.732425315.267575-46.436377313.5636228-47.769372312.2306275-49.332537310.6674628-50.713955309.2860449-51.867071308.1329286-49.636443310.3635575-49.186484310.8135158-49.174421310.8255791-48.233119311.7668805-48.164505311.8354953

17、-44.441011135.5589892-43.532614136.467386-42.608835137.3911651-42.137269137.8627315-43.434101136.5658994-42.827673137.1723266-45.294253134.7057469-44.997403135.0025967-44.536218135.463782-43.918085136.0819153-44.20834135.7916599-44.754633135.24536733869153.326403343.3173869154.709403341.9551-44.5678

18、63135.4321371 45-71.972653-76.323818-62.524465-17.619883-53.193033-54.545723-66.31178280.525750684.9711111-47.439099-55.290858-51.26825489.713842750.3771663-32.771312-68.23491-31.024301-21.511928-43.040617-68.127489-44.572703-20.56382683.564402-63.883675-58.024616-47.877003-67.497517-73.566196-89.79

19、0098-82.154686-42.860105-40.242124-48.247905-31.436167-4.8354305-27.501561-35.144043-32.515354-49.276743-24.19038-8.5702757-69.045907#DIV/0!-58.803784-58.80378225108.0273472103.6761816117.4755355162.3801174126.806967125.4542767113.688218180.5257506184.97111113132.5609012124.7091418128.731746489.7138

20、427350.37716626327.2286881291.76509328.975699338.4880719136.9593831111.8725111135.4272972159.436173983.56440205116.1163249121.9753835132.1229969112.5024831106.433803990.2099019997.84531355137.1398954139.7578758131.7520954148.5638326175.1645695152.4984393144.8559568147.4846458130.7232565155.809619817

21、1.4297243110.9540926FALSE 121.1962161121.1962202#DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/

22、0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0

23、!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0!FALSE #DIV/0! FALSE#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FAL

24、SE FALSE FALSE FALSE FALSE FALSE FALSE FALSE两点之间距离起（m ）始方位191.556125191.5561.6521.6111.5861.5651.5431.5231.4881.4491.3951.3111.2851.2801.2421.1471.0881.0040.9750.9180.8990.8490.7860.7620.7100.6720.6240.6260.5670.5110.4800.4450.4220.4000.365125起始方位角（° ）265°12585°125 4713346°471303

25、1347°0314347347°4347186348°1865811348°58113216349°3216819349°8194144348°41444941347°4941109347°1093437346°34371356347°1356559549272592057115548173023575041302251627185611124383812432051929945895840346°559344°5427345°918345°27

26、56346°211346°5912347°2043345°578344°1138342°5512340°4843338°1720335°3051333°239329°5729326°509323°414319°3058316°29314°2558315°16400.3010.2660.1810.0970.0450.0470.1130.1790.2410.3310.3800.4370.5020.5360.5750.6410.67

27、10.0000.7490.8340.8850.9701.0341.1331.1811.2301.3161.3711.4391.5101.5611.6341.6901.7631.8330.8340.8811.0661.2401.3331.3991.4461.5601.6251.6961.7861.88238294153264714139221842101559530950493157116331340177214849465033282351331042027447142571196552758525555482324018290425345151438349503105949493218323

28、2846572021950553043316°3825319°297322°4111323°539243°266162°4755159°127140°4158142°3952144°2255145°1855145°448143°2123140°024137°150133°5918132°53290°00314°942312°5053312°4945313°3115312

29、6;5714317°138315°163313°3349312°1350310°403309°1710308°759310°2149310°4849310°4932311°461311°508135°3332136°283137°2328137°5146136°3357137°1020134°4221135°09135°2750136°455135°4730135&#

30、176;14431.9414.243387.309163.91093.944250.624174.444145.826111.569143.733353.49983.293383.13859.08398.711170.937105.131140.32083.42087.438134.675177.921158.15328.44115.452914.565168.436408.299486.801249.753118.740789.749298.640355.364161.861132.477158.078718.329326.822541.911207.54199.073171.806362.

31、9920.0006979.0636979.0682556135°255600225°00138108°1384034103°4034-3734.8136338.182832117°28322248162°22484825126°4825-3734.8132715125°27154118113°4118313380°3133581684°58163339132°33394233124°42334354128°4354425089°425022385

32、0°22381343327°#176;45545833328°58332917338°29175734136°57345221111°52212538135°25382610159°2610335283°3352659116°6595831121°5831723132°723309112°309262106°262123690°1236504397°5043824137°8244528139°4528458131°4583350148°3350952175°9522954152°29545121144°5121295147°2954324130°43244835155°48352547171°25475715110°5715000°001146121°11461146121°11460.00000.00000.00000.00000.0000