逐樁坐標(biāo)計(jì)算xls

1、方方位位角角在在公公路路坐坐標(biāo)標(biāo)計(jì)計(jì)算算系系統(tǒng)統(tǒng).exe.exe坐坐標(biāo)標(biāo)正正反反算算中中偏偏角角在在公公路路坐坐標(biāo)標(biāo)計(jì)計(jì)算算系系統(tǒng)統(tǒng).exe.exe三三角角形形夾夾角角中中（分分左左右右）方位角與象限角1區(qū)=R2區(qū)=180-R3區(qū)=180+R4區(qū)=360-R逐逐樁樁坐坐標(biāo)標(biāo)左邊樁角右邊樁角方位角1方位角2pq1.570796327 1.570796327 3.251010253 2.71587485130.6611.388500497 99.97685185交點(diǎn)坐標(biāo)交點(diǎn)樁號(hào)偏角曲線要素XYL或RRLhTLE3421569.791475511.9571059.91-30.393961200200

2、429.327842.16245.715ZHHYQZYHHZ方位角左邊樁距右邊樁距加樁間距630.583830.5831051.6641272.7451472.745186.160922.522.520左邊樁角右邊樁角終點(diǎn)樁號(hào)紫色為已知數(shù)據(jù)，需輸入，黑色為計(jì)算結(jié)果。河北邢臺(tái)-秦廣軍90902200序號(hào)樁號(hào)左側(cè)坐標(biāo)X左側(cè)坐標(biāo)Y中樁坐標(biāo)X中樁坐標(biāo)Y右側(cè)坐標(biāo) X右側(cè)坐標(biāo)Y 方位角(弧度)ZH630.5833421994.094 475581.205 3421996.551 475558.839 3421999.008 475536.4743.251010253HY830.5833421792.968

3、 475564.617 3421797.278 475542.534 3421801.588 475520.4513.334343587QZ1051.6643421568.708 475578.022 3421576.991 475557.101 3421585.273 475536.1813.518577954YH1272.7453421374.065 475631.425 3421363.100 475611.778 3421352.134 475592.1312.632541518HZ1472.7453421188.077 475709.750 3421178.785 475689.25

4、8 3421169.493 475668.7662.715874851起點(diǎn)樁號(hào)16003421072.180 475762.303 3421062.888 475741.811 3421053.597 475721.3192.715874851216203421053.966 475770.562 3421044.674 475750.071 3421035.382 475729.5792.715874851316403421035.751 475778.822 3421026.459 475758.330 3421017.167 475737.8382.7158748514166034210

5、17.536 475787.081 3421008.244 475766.590 3420998.952 475746.0982.715874851516803420999.321 475795.341 3420990.029 475774.849 3420980.737 475754.3572.715874851617003420981.106 475803.600 3420971.814 475783.109 3420962.522 475762.6172.715874851717203420962.891 475811.860 3420953.599 475791.368 3420944

6、.307 475770.8762.715874851817403420944.676 475820.119 3420935.384 475799.628 3420926.093 475779.1362.715874851917603420926.462 475828.379 3420917.170 475807.887 3420907.878 475787.3952.7158748511017803420908.247 475836.638 3420898.955 475816.147 3420889.663 475795.6552.7158748511118003420890.032 475

7、844.898 3420880.740 475824.406 3420871.448 475803.9142.7158748511218203420871.817 475853.157 3420862.525 475832.665 3420853.233 475812.1742.7158748511318403420853.602 475861.417 3420844.310 475840.925 3420835.018 475820.4332.7158748511418603420835.387 475869.676 3420826.095 475849.184 3420816.803 47

8、5828.6932.7158748511518803420817.172 475877.936 3420807.881 475857.444 3420798.589 475836.9522.7158748511619003420798.958 475886.195 3420789.666 475865.703 3420780.374 475845.2122.7158748511719203420780.743 475894.455 3420771.451 475873.963 3420762.159 475853.4712.7158748511819403420762.528 475902.7

9、14 3420753.236 475882.222 3420743.944 475861.7312.7158748511919603420744.313 475910.974 3420735.021 475890.482 3420725.729 475869.9902.7158748512120003420707.883 475927.493 3420698.591 475907.001 3420689.300 475886.5092.7158748512220203420689.669 475935.752 3420680.377 475915.260 3420671.085 475894.

10、7692.7158748512320403420671.454 475944.012 3420662.162 475923.520 3420652.870 475903.0282.7158748512420603420653.239 475952.271 3420643.947 475931.779 3420634.655 475911.2882.7158748512520803420635.024 475960.531 3420625.732 475940.039 3420616.440 475919.5472.7158748512621003420616.809 475968.790 34

11、20607.517 475948.298 3420598.225 475927.8072.7158748512721203420598.594 475977.050 3420589.302 475956.558 3420580.010 475936.0662.7158748512821403420580.379 475985.309 3420571.087 475964.817 3420561.796 475944.3262.7158748512921603420562.165 475993.569 3420552.873 475973.077 3420543.581 475952.5852.

12、7158748513021803420543.950 476001.828 3420534.658 475981.336 3420525.366 475960.8452.7158748513122003420525.735 476010.088 3420516.443 475989.596 3420507.151 475969.1042.715874851#VALUE!#VALUE!#VALUE!#VALUE!2.715874851#VALUE!#VALUE!#VALUE!#VALUE!2.715874851#VALUE!#VALUE!#VALUE!#VALUE!2.715874851#VAL

13、UE!#VALUE!#VALUE!#VALUE!3.251010253樁號(hào)左側(cè)坐標(biāo)X(12m)左側(cè)坐標(biāo)Y中樁坐標(biāo)X中樁坐標(biāo)Y右側(cè)坐標(biāo) X(12m)右側(cè)坐標(biāo)Y方位角(弧度)11003421524.561475576.64353421529.424475565.67313421534.287475554.70273.55885779211203421504.805475580.66683421509.851475569.77893421514.896475558.89113.57552445911403421485.122475585.01263421490.348475574.210434214

14、95.574475563.40823.59219112511603421465.516475589.67993421470.922475578.96633421476.327475568.25263.60885779211803421445.995475594.66733421451.578475584.04523421457.161475573.42323.62552445912003421426.562475599.97343421432.321475589.44593421438.08475578.91833.64219112512203421407.223475605.59683421

15、413.157475595.16673421419.091475584.73663.65885779212403421387.984475611.53593421394.091475601.20613421400.198475590.87643.67552445912603421381.091475617.97623421375.128475607.56253421369.165475597.14872.62158189212803421362.06475624.74683421356.274475614.23383421350.488475603.72082.6384773451300342

16、1343.153475631.80553421337.528475621.20563421331.903475610.60572.65370613113203421324.366475639.12183421318.885475628.44663421313.405475617.77142.66726825113403421305.689475646.6643421300.336475635.92433421294.983475625.18472.67916370413603421287.114475654.40073421281.87475643.60683421276.627475632.

17、8132.6893924913803421268.629475662.30083421263.478475651.46243421258.327475640.62412.6979546114003421250.222475670.33363421245.147475659.463421240.071475648.58642.70485006314203421231.883475678.46853421226.864475667.56853421221.845475656.66852.71007884914403421213.597475686.67523421208.617475675.757

18、43421203.637475664.83952.71364096914603421195.349475694.92493421190.393475683.99593421185.437475673.0672.71587485114803421177.133475703.1833421172.178475692.25413421167.222475681.32522.71587485115003421158.918475711.44253421153.963475700.51363421149.007475689.58472.71587485115203421140.704475719.702

19、3421135.748475708.77313421130.792475697.84422.71587485115403421122.489475727.96153421117.533475717.03263421112.577475706.10372.71587485115603421104.274475736.2213421099.318475725.29213421094.362475714.36322.71587485115803421086.059475744.48053421081.103475733.55163421076.148475722.62272.715874851160

20、03421067.844475752.743421062.888475741.81113421057.933475730.88222.71587485116203421049.629475760.99953421044.674475750.07063421039.718475739.14172.71587485116403421031.414475769.2593421026.459475758.33013421021.503475747.40122.71587485116603421013.2475777.51853421008.244475766.58963421003.288475755

21、.66062.71587485116803420994.985475785.7783420990.029475774.8493420985.073475763.92012.71587485117003420976.77475794.03753420971.814475783.10853420966.859475772.17962.71587485117203420958.555475802.29693420953.599475791.3683420948.644475780.43912.71587485117403420940.34475810.55643420935.384475799.62

22、753420930.429475788.69862.71587485117603420922.125475818.81593420917.17475807.8873420912.214475796.95812.71587485117803420897.644475828.07473420898.955475816265475804.21833.25101025318003420885.696475835.33493420880.74475824.4063420875.784475813.47712.71587485118203420867.481475843.5944

23、3420862.525475832.66553420857.569475821.73662.71587485118403420849.266475851.85393420844.31475840.9253420839.355475829.99612.71587485118603420831.051475860.11343420826.09547584914475838.25562.71587485118803420812.836475868.37293420807.881475857.4443420802.925475846.51512.715874851190034

24、20794.621475876.63243420789.666475865.70353420784.71475854.77462.71587485119203420776.407475884.89193420771.451475873.9633420766.495475863.0342.71587485119403420758.189475893236475882.22193420748.282475871.2922.71606691319603420739.949475901.40343420735.014475890.46553420730.078475879.5

25、2762.71770037619803420721.671475909.61833420716.771475898.66423420711.872475887.712.72100050520003420703.34475917.76573420698.495475906.78743420693.65475895.8092.72596730220203420684.945475925.81473420680.172475914.80443420675.4475903.79412.73260076420403420666.471475933.73393420661.79475922.6844342

26、0657.11475911.63492.74090089420603420647.907475941.49183420643.337475930.39623420638.767475919.30062.7508676920803420629.242475949.05623420624.801475937.90823420620.361475926.76022.76250115221003420610.466475956.39463420606.174475945882475933.98242.77580128221203420591.572475963.4733420

27、587.445475952.20493420583.319475940.93672.79054281221403420572.546475970.26043420568.608475958.9253420564.67475947.58972.80720947821603420553.411475976.73043420549.662475965.3313420545.913475953.93162.82387614521803420534.17475982.88073420530.612475971.42043420527.054475959.96012.8405428122200342050

28、9.427475989.01743420511.463475977.19143420513.499475965.36543.31210114樁號(hào)左側(cè)坐標(biāo)X(21m)左側(cè)坐標(biāo)Y中樁坐標(biāo)X中樁坐標(biāo)Y右側(cè)坐標(biāo) X(22.5m)右側(cè)坐標(biāo)Y方位角(弧度)11003421520.914475584.87133421529.424475565.67313421538.543475545.10363.55885779211203421501.021475588.83273421509.851475569.77893421519.31475549.36433.57552445911403421481.20247

29、5593.11433421490.348475574.21043421500.147475553.95623.59219112511603421461.462475597.71523421470.922475578.96633421481.057475558.87823.60885779211803421441.807475602.63393421451.578475584.04523421462.046475564.12893.62552445912003421422.242475607.86913421432.321475589.44593421443.12475569.70673.642

30、19112512203421402.772475613.41943421413.157475595.16673421424.283475575.61033.65885779212403421383.403475619.28323421394.091475601.20613421405.541475581.83793.67552445912603421385.563475625.78663421375.128475607.56253421363.948475588.03672.62158189212803421366.399475632.63153421356.274475614.2338342

31、1345.425475594.52192.63847734513003421347.372475639.75553421337.528475621.20563421326.981475601.33082.65370613113203421328.477475647.12833421318.885475628.44663421308.609475608.43062.66726825113403421309.705475654.71873421300.336475635.92433421290.298475615.78752.67916370413603421291.046475662.49613

32、421281.87475643.60683421272.039475623.36832.6893924913803421272.492475670.42963421263.478475651.46243421253.82475631.14052.6979546114003421254.029475678.48883421245.147475659.463421235.629475639.0722.70485006314203421235.647475686.64353421226.864475667.56853421217.453475647.1312.71007884914403421217

33、.332475694.86353421208.617475675.75743421199.28475655.28652.71364096914603421199.065475703.12153421190.393475683.99593421181.101475663.50422.71587485114803421180.85475711.37973421172.178475692.25413421162.886475671.76242.71587485115003421162.635475719.63923421153.963475700.51363421144.671475680.0219

34、2.71587485115203421144.42475727.89873421135.748475708.77313421126.456475688.28142.71587485115403421126.205475736533475717.03263421108.241475696.54092.71587485115603421107.991475744.41773421099.318475725.29213421090.026475704.80042.71587485115803421089.776475752.67723421081.103475733.551

35、63421071.811475713.05992.71587485116003421071.561475760.93673421062.888475741.81113421053.597475721.31942.71587485116203421053.346475769.19623421044.674475750.07063421035.382475729.57892.71587485116403421035.131475777.45573421026.459475758.33013421017.167475737.83842.71587485116603421016.916475785.7

36、1523421008.244475766.58963420998.952475746.09792.71587485116803420998.702475793.97463420990.029475774.8493420980.737475754.35732.71587485117003420980.487475802.23413420971.814475783.10853420962.522475762.61682.71587485117203420962.272475810.49363420953.599475791.3683420944.307475770.87632.7158748511

37、7403420944.057475818.75313420935.384475799.62753420926.093475779.13582.71587485117603420925.842475827.01263420917.17475807.8873420907.878475787.39532.71587485117803420896.662475837.02093420898.955475816412475793.78113.25101025318003420889.412475843.53163420880.74475824.4063420871.448475

38、803.91432.71587485118203420871.198475851.79113420862.525475832.66553420853.233475812.17382.71587485118403420852.983475860.05063420844.31475840.9253420835.018475820.43332.71587485118603420834.768475868.31013420826.095475849803475828.69282.71587485118803420816.553475876.56963420807.881475

39、857.4443420798.589475836.95232.71587485119003420798.338475884.82913420789.666475865.70353420780.374475845.21182.71587485119203420780.123475893.08863420771.451475873.9633420762.159475853.47132.715874851樁號(hào)左側(cè)坐標(biāo)X(22.5m)左側(cè)坐標(biāo)Y中樁坐標(biāo)X中樁坐標(biāo)Y右側(cè)坐標(biāo) X(22.5m)右側(cè)坐標(biāo)Y方位角(弧度)16003421072.180475762.3033421062.888475741.81

40、13421053.597475721.3192.71587485116203421053.966475770.5623421044.674475750.0713421035.382475729.5792.71587485116403421035.751475778.8223421026.459475758.3303421017.167475737.8382.71587485116603421017.536475787.0813421008.244475766.5903420998.952475746.0982.71587485116803420999.321475795.3413420990.

41、029475774.8493420980.737475754.3572.71587485117003420981.106475803.6003420971.814475783.1093420962.522475762.6172.71587485117203420962.891475811.8603420953.599475791.3683420944.307475770.8762.71587485117403420944.676475820.1193420935.384475799.6283420926.093475779.1362.71587485117603420926.462475828

42、.3793420917.170475807.8873420907.878475787.3952.71587485117803420908.247475836.6383420898.955475816.1473420889.663475795.6552.71587485118003420890.032475844.8983420880.740475824.4063420871.448475803.9142.71587485118203420871.817475853.1573420862.525475832.6653420853.233475812.1742.71587485118403420853.602475861.4173420844.310475840.9253420835.018475820.4332.71587485118603420835.387475869.676342