公路线元法坐标计算excel

中桩

桩号偏距角度 X Y Z偏距角度 173.0590902739603.137501688.37742085.519590 1800902739596.392501690.01282085.615590 2000902739576.957501694.73552085.889590 2010902739575.986501694.97352085.903590 2200902739557.549501699.56562086.164590 2400902739538.189501704.58092086.428590 2600902739518.879501709.78952086.667590 2800902739499.622501715.19092086.878590 3000902739480.42501720.78462087.062590 3200902739461.276501726.57012087.219590 3400902739442.189501732.54672087.349590 3600902739423.164501738.71392087.453590 3800902739404.201501745.0712087.529590 4000902739385.303501751.61742087.578590 4200902739366.472501758.35252087.6590 4400902739347.708501765.27562087.595590 4600902739329.015501772.38592087.563590 4800902739310.393501779.68282087.507590 5000902739291.846501787.16562087.447590 5200902739273.374501794.83342087.387590 5400902739254.978501802.67892087.327590 5600902739236.627501810.63132087.267590 5800902739218.274501818.58062087.207590 580.4680902739217.844501818.76552087.205590

右边桩

HP X Y Z偏距角度 HP -2.162739601.96501683.5192085.411 5.75090-2.16 -2.12739595.22501685.1532085.509 6.01090-2.1 -22739575.77501689.8792085.7897.38090-2 -22739574.8501690.1172085.803 5.00090-2 -22739556.32501694.7192086.063 5.00090-2 -22739536.91501699.7472086.328 5.00090-2 -22739517.55501704.9692086.56752.68090-2 -22739498.25501710.3842086.77879.21090-2 -22739479501715.9912086.96285.02090-2 -22739459.81501721.7912087.11991.08090-2 -22739440.67501727.7832087.24997.38090-2 -22739421.6501733.9652087.352103.93090-2 -22739402.59501740.3382087.429110.73090-2 -22739383.64501746.9012087.478117.79090-2 -22739364.76501753.6532087.500125.11090-2 -22739345.95501760.5932087.495132.70090-2 -22739327.21501767.7212087.463140.55090-2 -22739308.55501775.0372087.407148.68090-2 -22739289.95501782.5382087.347157.08090-2 -22739271.43501790.2252087.287167.47090-2 -22739253501798.0872087.226179.80090-2 -22739234.63501806.0462087.166191.76090-2 -1.182739216.3501813.9882087.147202.97090-1.18 -1.162739215.87501814.1722087.147203.22090-1.16

挡墙顶

X Y Z

2739601.779501682.792084.914501688.377373686,2739603.13737369,2085.519 2739594.978501684.1722084.835501690.012768894,2739596.39178777,2085.615 2739575.202501687.5672084.201501694.735486849,2739576.95739395,2085.889 2739574.795501690.1172085.803501694.973527055,2739575.98613867,2085.903 2739556.32501694.7192086.063501699.565649105,2739557.54947885,2086.164 2739536.911501699.7472086.328501704.580891657,2739538.18859021,2086.428 2739504.905501658.9972085.613501709.789489108,2739518.8788212,2086.667 2739477.849501639.0322085.294501715.190920604,2739499.62210278,2086.878 2739456.233501639.2782085.362501720.784646006,2739480.42036059,2087.062 2739434.493501639.5172085.398501726.570105948,2739461.2755148,2087.219 2739412.625501639.7632085.402501732.546721889,2739442.18947986,2087.349 2739390.622501640.012085.374501738.713896177,2739423.16416437,2087.453 2739368.481501640.2612085.314501745.071012102,2739404.20147081,2087.529 2739346.192501640.512085.222501751.617433963,2739385.30329543,2087.578 2739323.752501640.7622085.098501758.352507129,2739366.47152802,2087.6 2739301.152501641.0112084.941501765.275558108,2739347.70805171,2087.595 2739278.39501641.272084.752501772.38589461,2739329.0147428,2087.563 2739255.457501641.5252084.533501779.682805621,2739310.39347058,2087.507 2739232.349501641.792084.305501787.165561471,2739291.84609712,2087.447 2739208.395501640.4842084.037501794.833413909,2739273.37447709,2087.387 2739183.81501637.5632083.730501802.678851677,2739254.97755778,2087.327 2739160.2501634.762083.431501810.631287745,2739236.62657906,2087.267 2739138.058501632.1342084.811501818.580610093,2739218.27425507,2087.207 2739137.562501632.0762084.848501818.765531761,2739217.84433884,2087.205

501683.51883061,27

501682.790049149,2739601.77932195,2084.914

501684.171508127,2739594.97765459,2084.835 501685.153150951,2

501687.567375177,2739575.20166759,2084.201 501689.879042627,2

501690.117421209,2739574.79524152,2085.8025524418 501690.117421209,2

501694.71919823,2739556.31987976,2086.06336974949 501694.71919823,27

501699.746978888,2739536.9105889,2086.32832432192 501699.746978888,2

501704.968597833,2

501658.996578636,2739504.90518009,2085.61298746361

501639.032284724,2739477.8485803,2085.29362357828 501710.383532908,2

501639.277614891,2739456.23349889,2085.36163266592 501715.991242624,2

501721.791166215,2

501639.51693978,2739434.4928215,2085.39761472653

501639.763093091,2739412.62492969,2085.40176976012 501727.782723697,2

501640.009906959,2739390.62238488,2085.37389776668 501733.96531592,27

501640.260915458,2739368.48065697,2085.31399874621 501740.338324635,2

501640.510334131,2739346.19196118,2085.22187269871 501746.90111255,27

501640.76202525,2739323.75161848,2085.0975******* 501753.6530234,273

501760.593382006,2

501641.010604357,2739301.1515133,2084.94073952264

501641.26960327,2739278.39043397,2084.75173239406 501767.721494349,2

501641.524651809,2739255.4565346,2084.53299372136 501775.036647637,2

501641.789557874,2739232.34866879,2084.30495655142 501782.538110376,2

501640.483634535,2739208.39489178,2084.0371******* 501790.225132444,2

501637.563081589,2739183.80999165,2083.73048221153 501798.087200674,2

501634.759584093,2739160.19987264,2083.43124504158 501806.045563307,2

501632.134452338,2739138.05797768,2084.81136187164 501813.987661437,2

501632.075561512,2739137.56219009,2084.84765100186 501814.172234589,2