EXCEL带批量计算的坐标表格(曲线段)

1、程序目录曲线主点桩号与坐标计算!A1直线段坐标计算!A1方位角计算及随机!A1卵型曲线隐藏计算!A1卵型曲线主点桩号计算!A1附合导线平差!A1水准平差!A1四等水准!A1四等水准数据反推!A1自由测站!A1圆曲线圆心法!A1竖曲线!A1前方交会!A1参考椭球与高斯投影计算!A1高斯平面距离值!A1高斯投影坐标正算!A1坐标换带计算!A1缓和曲线-1!A1圆曲线支矩法!A1缓和曲线-2!A1工程、国家坐标换算!A1超高横坡计算!A1求弦长或弧长!A1不完整缓和曲线!A1曲曲线线计计算算要要素素表表( (已已知知条条件件) )交点桩号交点坐标转角值方向转角值曲线半径缓和曲线长缓和曲线长JDN(X

2、)E(Y)左+1,右-1 （度）（弧度）RLS1LS2842807.6623808109.863515299.822-139324039.544508330.6901818719000490490393240.2基基本本要要素素结结果果表表内移值内移值切线增值切线增值ZH至JD方位角缓和曲线角缓和曲线角切线长p1p2q1q2 （度）（弧度） 1 2T11.1121.112244.994244.9942392018239.33821114.177239810.0270.0273480.6712392017.6ZH至HY支矩坐标切线长圆曲线长曲线长JD至ZH方位角JD至HZ方位角 HZ至JD方位角

3、HY至JD方位角N(x)E(y)T2LyL（弧度）（弧度）（弧度）（度）（度）（弧度）489.9644.4463480.6715721.6376701.6371.0356471564.8674216811.72582902898.882719449852584.204462032曲曲线线主主点点桩桩号号、坐坐标标结结果果表表ZH桩号HY桩号路线方向QZ桩号YH桩号HZ桩号839326.991839816.991 左+1,右-1842677.810845538.628846028.628N(X)E(Y)N(X)E(Y)-1 N(X)E(Y)N(X)E(Y)N(X)E(Y)3809884.8985

4、18293.8693809638.856517870.1383808576.058512345.6713808647.322511860.897备备注注：此此程程序序适适用用于于对对称称、不不对对称称缓缓和和曲曲线线以以及及圆圆曲曲线线，当当为为对对称称缓缓和和曲曲线线时时，LS1=LS2;LS1=LS2;当当为为圆圆曲曲线线时时，LS1=LS2=0LS1=LS2=0。涂涂红红处处输输入入变变量量K839+326.991 至K846+028.628任意点桩号里程差W支矩x坐标支矩y坐标至起点距离切线角距中桩距离待求点坐标WCD(C2+D2)E左+,右-N(X)E(Y)844697.631148

5、80.6400000.542293289-3.63808511.560513183.723844704.00994887.0180000.543002048-3.63808511.782513177.351844710.51384893.5220000.543724703-3.63808512.012513170.854844717.01774900.0260000.544447359-3.63808512.247513164.357844723.52164906.5300000.545170014-3.63808512.487513157.860844730.05054913.0590000

6、.545895449-3.63808512.732513151.338844697.63114880.6400000.542293289-6.43808514.359513183.820844704.00994887.0180000.543002048-6.43808514.580513177.449844710.51384893.5220000.543724703-6.43808514.810513170.954844717.01774900.0260000.544447359-6.43808515.045513164.459844723.52164906.5300000.545170014

7、-6.43808515.285513157.964844730.05054913.0590000.545895449-6.43808515.530513151.444844664.89114847.9000000.538655512-3.63808510.495513216.433844671.26994854.2780000.53936427-3.63808510.693513210.060844677.77384860.7820000.540086926-3.63808510.900513203.562844684.27774867.2860000.540809581-3.63808511

8、.111513197.0644398158.840844690.78164873.7900000.541532237-3.63808511.328513190.566844697.31054880.3190000.542257672-3.63808511.549513184.0444398438.795844664.89114847.9000000.538655512-6.43808513.294513216.519844671.26994854.2780000.53936427-6.43808513.492513210.148844677.77384860.7820000.540086926

9、-6.43808513.699513203.652844684.27774867.2860000.540809581-6.43808513.910513197.156844690.78164873.7900000.541532237-6.43808514.126513190.660844697.31054880.3190000.542257672-6.43808514.348513184.140841398.631581.6390000.1757376161.43808993.349516428.313841405.0051588.0140000.1764459491.43808991.272

10、516422.285841411.5051594.5140000.1771681721.43808989.158516416.137841418.0051601.0140000.1778903941.43808987.049516409.988841424.5051607.5140000.1786126161.43808984.945516403.837841431.031614.0390000.1793376161.43808982.836516397.661841398.631581.6390000.175737616-1.43808995.996516427.400841405.0051

11、588.0140000.176445949-1.43808993.919516421.374841411.5051594.5140000.177168172-1.43808991.807516415.228841418.0051601.0140000.177890394-1.43808989.698516409.081841424.5051607.5140000.178612616-1.43808987.594516402.932841431.031614.0390000.179337616-1.43808985.487516396.757841431.371614.3790000.17937

12、53941.43808982.727516397.339841437.7451620.7540000.1800837271.43808980.671516391.304841444.2451627.2540000.1808059491.43808978.580516385.148841450.7451633.7540000.1815281721.43808976.494516378.991841457.2451640.2540000.1822503941.43808974.411516372.832841463.771646.7790000.1829753941.43808972.326516

13、366.649841431.371614.3790000.179375394-1.43808985.377516396.436841437.7451620.7540000.180083727-1.43808983.322516390.402841444.2451627.2540000.180805949-1.43808981.232516384.248841450.7451633.7540000.181528172-1.43808979.146516378.093841457.2451640.2540000.182250394-1.43808977.064516371.937841463.77

14、1646.7790000.182975394-1.43808974.979516365.755841464.111647.1190000.1830131721.43808972.217516366.326841470.4851653.4940000.1837215051.43808970.184516360.283841476.9851659.9940000.1844437271.43808968.115516354.120841483.4851666.4940000.1851659491.43808966.051516347.956841489.9851672.9940000.1858881

15、721.43808963.991516341.790841496.511679.5190000.1866131721.43808961.928516335.598841464.111647.1190000.183013172-1.43808974.871516365.433841470.4851653.4940000.183721505-1.43808972.838516359.391841476.9851659.9940000.184443727-1.43808970.770516353.230841483.4851666.4940000.185165949-1.43808968.70651

16、6347.068841489.9851672.9940000.185888172-1.43808966.647516340.903841496.511679.5190000.186613172-1.43808964.585516334.714845090.51115273.5200000.5859466231.43808528.630512791.262845096.88995279.8980000.5866553811.43808529.130512784.902845103.39385286.4020000.5873780371.43808529.644512778.417845109.8

17、9775292.9060000.5881006921.43808530.162512771.933845116.40165299.4100000.5888233481.43808530.686512765.449845122.93055305.9390000.5895487831.43808531.216512758.941845090.51115273.5200000.585946623-1.43808531.422512791.480845096.88995279.8980000.586655381-1.43808531.921512785.122845103.39385286.40200

18、00.587378037-1.43808532.435512778.639845109.89775292.9060000.588100692-1.43808532.953512772.157845116.40165299.4100000.588823348-1.43808533.477512765.675845122.93055305.9390000.589548783-1.43808534.006512759.169845123.25115306.2600000.5895844011.43808531.242512758.621845129.65495312.6630000.59029593

19、81.43808531.767512752.238845136.15885319.1670000.5910185941.43808532.304512745.755845142.66275325.6710000.5917412491.43808532.846512739.273845147.66575330.6740000.5922971381.43808533.267512734.287845123.25115306.2600000.5895844011.43808531.242512758.621845129.65495312.6630000.590295938-1.43808534.55

20、7512752.468845136.15885319.1670000.591018594-1.43808535.094512745.987845142.66275325.6710000.591741249-1.43808535.637512739.507845147.66575330.6740000.592297138-1.43808536.057512734.523845147.9755330.9840000.592331509-1.43808536.083512734.214845154.37765337.3860000.593042905-1.43808536.625512727.836

21、845160.88025343.8890000.593765416-3.63808539.372512721.547845167.38285350.3910000.594487927-3.63808539.931512715.071845172.38485355.3930000.595043705-3.63808540.365512710.090845147.9755330.9840000.592331509-6.43808541.065512734.636845154.37765337.3860000.593042905-6.43808541.607512728.261845160.8802

22、5343.8890000.593765416-6.43808542.161512721.787845167.38285350.3910000.594487927-6.43808542.721512715.313845172.38485355.3930000.595043705-6.43808543.154512710.333845172.6955355.7040000.595078176-3.63808540.392512709.781845179.09765362.1060000.595789572-3.63808540.951512703.405845185.60025368.609000

23、0.596512083-3.63808541.524512696.930845192.10285375.1110000.597234594-3.63808542.101512690.456845197.10485380.1130000.597790372-3.63808542.549512685.476845172.6955355.7040000.595078176-6.43808543.181512710.024845179.09765362.1060000.595789572-6.43808543.740512703.651845185.60025368.6090000.596512083

24、-6.43808544.313512697.178845192.10285375.1110000.597234594-6.43808544.890512690.706845197.10485380.1130000.597790372-6.43808545.337512685.727841070.52111253.5300000.139281067-1.43809108.609516735.505841076.89991259.9080000.139989826-1.43809106.312516729.555841083.40381266.4120000.140712481-1.4380910

25、3.976516723.486841089.90771272.9160000.141435137-1.43809101.643516717.416841096.41161279.4200000.142157792-1.43809099.315516711.344841102.94051285.9490000.142883227-1.43809096.983516705.247841103.26111286.2700000.1429188451.43809094.253516705.947841109.63991292.6480000.1436276031.43809091.977516699.

26、987841116.14381299.1520000.1443502591.43809089.662516693.908841122.64771305.6560000.1450729141.43809087.351516687.828841129.15161312.1600000.145795571.43809085.044516681.745841135.68051318.6890000.1465210051.43809082.733516675.638841103.26111286.2700000.142918845-1.43809096.868516704.948841109.63991

27、292.6480000.143627603-1.43809094.594516698.989841116.14381299.1520000.144350259-1.43809092.279516692.912841122.64771305.6560000.145072914-1.43809089.969516686.834841129.15161312.1600000.14579557-1.43809087.663516680.754841135.68051318.6890000.146521005-1.43809085.352516674.648841127.99111311.0000000

28、.1456666231.43809085.455516682.831841134.36991317.3780000.1463753811.43809083.197516676.864841140.87381323.8820000.1470980371.43809080.898516670.779841147.37771330.3860000.1478206921.43809078.603516664.692841153.88161336.8900000.1485433481.43809076.314516658.604841160.41051343.4190000.1492687831.438

29、09074.019516652.490841127.99111311.0000000.145666623-1.43809088.074516681.839841134.36991317.3780000.146375381-1.43809085.816516675.874841140.87381323.8820000.147098037-1.43809083.518516669.791841147.37771330.3860000.147820692-1.43809081.224516663.706841153.88161336.8900000.148543348-1.43809078.9355

30、16657.619841160.41051343.4190000.149268783-1.43809076.641516651.507840644.91827.9190000.0919909491.43809268.721517129.818840651.285834.2940000.0926992831.43809266.147517123.985840657.785840.7940000.0934215051.43809263.526517118.035840664.285847.2940000.0941437271.43809260.910517112.084840670.785853.

31、7940000.0948659491.43809258.298517106.131840677.31860.3190000.0955909491.43809255.681517100.153840644.91827.9190000.091990949-1.43809271.282517128.687840651.285834.2940000.092699283-1.43809268.709517122.855840657.785840.7940000.093421505-1.43809266.089517116.908840664.285847.2940000.094143727-1.4380

32、9263.474517110.958840670.785853.7940000.094865949-1.43809260.863517105.007840677.31860.3190000.095590949-1.43809258.246517099.030840677.65860.6590000.0956287271.43809255.545517099.841840684.025867.0340000.0963370611.43809252.992517093.998840690.525873.5340000.0970592831.43809250.393517088.039840697.

33、025880.0340000.0977815051.43809247.799517082.079840703.525886.5340000.0985037271.43809245.209517076.116840710.05893.0590000.0992287271.43809242.613517070.128840677.65860.6590000.095628727-1.43809258.110517098.719840684.025867.0340000.096337061-1.43809255.558517092.878840690.525873.5340000.097059283-

34、1.43809252.960517086.921840697.025880.0340000.097781505-1.43809250.367517080.962840703.525886.5340000.098503727-1.43809247.777517075.001840710.05893.0590000.099228727-1.43809245.182517069.015840710.39893.3990000.0992665051.43809242.478517069.816840716.765899.7740000.0999748381.43809239.946517063.964

35、840723.265906.2740000.1006970611.43809237.369517057.996840729.765912.7740000.1014192831.43809234.797517052.026840736.265919.2740000.1021415051.43809232.228517046.053840742.79925.7990000.1028665051.43809229.654517040.056840710.39893.3990000.099266505-1.43809245.047517068.703840716.765899.7740000.0999

36、74838-1.43809242.516517062.853840723.265906.2740000.100697061-1.43809239.940517056.887840729.765912.7740000.101419283-1.43809237.368517050.918840736.265919.2740000.102141505-1.43809234.801517044.948840742.79925.7990000.102866505-1.43809232.228517038.953840743.13926.1390000.1029042831.43809229.520517

37、039.744840749.505932.5140000.1036126161.43809227.010517033.883840756.005939.0140000.1043348381.43809224.455517027.905840762.505945.5140000.1050570611.43809221.904517021.925840769.005952.0140000.1057792831.43809219.357517015.944840775.53958.5390000.1065042831.43809216.805517009.938840743.13926.139000

38、0.102904283-1.43809232.094517038.641840749.505932.5140000.103612616-1.43809229.584517032.781840756.005939.0140000.104334838-1.43809227.030517026.805840762.505945.5140000.105057061-1.43809224.480517020.828840769.005952.0140000.105779283-1.43809221.934517014.848840775.53958.5390000.106504283-1.4380921

39、9.382517008.844840775.87958.8790000.1065420611.43809216.672517009.625840782.245965.2540000.1072503941.43809214.183517003.755840788.745971.7540000.1079726161.43809211.650516997.767840795.245978.2540000.1086948381.43809209.120516991.779840801.745984.7540000.1094170611.43809206.596516985.788840808.2799

40、1.2790000.1101420611.43809204.065516979.772840775.87958.8790000.106542061-1.43809219.250517008.531840782.245965.2540000.107250394-1.43809216.761517002.662840788.745971.7540000.107972616-1.43809214.229516996.677840795.245978.2540000.108694838-1.43809211.700516990.690840801.745984.7540000.109417061-1.

41、43809209.176516984.701840808.27991.2790000.110142061-1.43809206.647516978.688843256.563439.5690000.3821742832.53808571.236514621.943843272.733455.7390000.383970949-1.43808573.092514605.412843272.733455.7390000.3839709492.53808569.222514605.894843273.133456.1390000.384015394-1.43808573.042514605.0158

42、43273.133456.1390000.3840153942.53808569.172514605.497843289.33472.3090000.385812061-1.43808571.059514588.970843289.33472.3090000.3858120612.53808567.188514589.445843305.473488.4790000.387608727-1.43808569.104514572.921843305.473488.4790000.3876087272.53808565.232514573.389843305.873488.8790000.3876

43、53172-1.43808569.056514572.524843305.873488.8790000.3876531722.53808565.184514572.992843322.043505.0490000.389449838-1.43808567.130514556.472843322.043505.0490000.3894498382.53808563.258514556.933843338.213521.2190000.391246505-1.43808565.234514540.416843338.213521.2190000.3912465052.53808561.360514

44、540.870843338.613521.6190000.391290949-1.43808565.187514540.018843338.613521.6190000.3912909492.53808561.314514540.472843354.783537.7890000.393087616-1.43808563.320514523.959843354.783537.7890000.3930876162.53808559.446514524.406843370.953553.9590000.394884283-1.43808561.482514507.897843370.953553.9

45、590000.3948842832.53808557.607514508.336843371.353554.3590000.394928727-1.43808561.437514507.499843371.353554.3590000.3949287272.53808557.562514507.939843387.523570.5290000.396725394-1.43808559.628514491.433843387.523570.5290000.3967253942.53808555.752514491.866843403.693586.6990000.398522061-1.4380

46、8557.849514475.364843403.693586.6990000.3985220612.53808553.972514475.790843404.093587.0990000.398566505-1.43808557.805514474.966843404.093587.0990000.3985665052.53808553.928514475.392843420.263603.2690000.400363172-1.43808556.055514458.894843420.263603.2690000.4003631722.53808552.177514459.31384343

47、6.433619.4390000.402159838-1.43808554.333514442.818843436.433619.4390000.4021598382.53808550.455514443.230843436.833619.8390000.402204283-1.43808554.291514442.421843436.833619.8390000.4022042832.53808550.413514442.8328434533636.0090000.404000949-1.43808552.600514426.3428434533636.0090000.4040009492.

48、53808548.721514426.746843469.173652.1790000.405797616-1.43808550.937514410.260843469.173652.1790000.4057976162.53808547.057514410.658843469.573652.5790000.405842061-1.43808550.896514409.862843469.573652.5790000.4058420612.53808547.016514410.260843485.743668.7490000.407638727-1.43808549.263514393.777

49、843485.743668.7490000.4076387272.53808545.383514394.168843501.913684.9190000.409435394-1.43808547.659514377.690843501.913684.9190000.4094353942.53808543.778514378.073843502.313685.3190000.409479838-1.43808547.619514377.292843502.313685.3190000.4094798382.53808543.738514377.675843518.483701.4890000.4

50、11276505-1.43808546.045514361.201843518.483701.4890000.4112765052.53808542.163514361.577843534.653717.6590000.413073172-1.43808544.499514345.108843534.653717.6590000.4130731722.53808540.617514345.477843535.053718.0590000.413117616-1.43808544.461514344.710843535.053718.0590000.4131176162.53808540.579

51、514345.079843551.223734.2290000.414914283-1.43808542.945514328.613843551.223734.2290000.4149142832.53808539.062514328.976843567.393750.3990000.416710949-1.43808541.458514312.514843567.393750.3990000.4167109492.53808537.574514312.870843567.793750.7990000.416755394-1.43808541.422514312.116843567.79375

52、0.7990000.4167553942.53808537.538514312.471843583.963766.9690000.418552061-1.43808539.964514296.014843583.963766.9690000.4185520612.53808536.080514296.363843600.133783.1390000.420348727-1.43808538.535514279.910843600.133783.1390000.4203487272.53808534.650514280.251843600.533783.5390000.420393172-1.4

53、3808538.501514279.512843600.533783.5390000.4203931722.53808534.615514279.853843616.73799.7090000.422189838-1.43808537.102514263.405843616.73799.7090000.4221898382.53808533.216514263.739843632.873815.8790000.423986505-1.43808535.732514247.296843632.873815.8790000.4239865052.53808531.845514247.6238436

54、33.273816.2790000.424030949-1.43808535.698514246.897843633.273816.2790000.4240309492.53808531.812514247.224843649.443832.4490000.425827616-1.43808534.358514230.785843649.443832.4490000.4258276162.53808530.471514231.105843665.613848.6190000.427624283-1.43808533.046514214.671843665.613848.6190000.4276

55、242832.53808529.159514214.984843666.013849.0190000.427668727-1.43808533.014514214.272843666.013849.0190000.4276687272.53808529.127514214.585843682.183865.1890000.429465394-1.43808531.733514198.156843682.183865.1890000.4294653942.53808527.845514198.461843698.353881.3590000.431262061-1.43808530.480514

56、182.037843698.353881.3590000.4312620612.53808526.591514182.336843698.753881.7590000.431306505-1.43808530.449514181.638843698.753881.7590000.4313065052.53808526.561514181.937843714.923897.9290000.433103172-1.43808529.226514165.517843714.923897.9290000.4331031722.53808525.337514165.809843731.093914.09

57、90000.434899838-1.43808528.032514149.394843731.093914.0990000.4348998382.53808524.142514149.678843731.493914.4990000.434944283-1.43808528.003514148.995843731.493914.4990000.4349442832.53808524.113514149.279843747.663930.6690000.436740949-1.43808526.839514132.869843747.663930.6690000.4367409492.53808

58、522.948514133.147843763.833946.8390000.438537616-1.43808525.703514116.742843763.833946.8390000.4385376162.53808521.812514117.012843764.233947.2390000.438582061-1.43808525.675514116.343843764.233947.2390000.4385820612.53808521.785514116.613843780.43963.4090000.440378727-1.43808524.570514100.213843780

59、.43963.4090000.4403787272.53808520.678514100.476843796.573979.5790000.442175394-1.43808523.493514084.082843796.573979.5790000.4421753942.53808519.601514084.338843796.973979.9790000.442219838-1.43808523.467514083.682843796.973979.9790000.4422198382.53808519.575514083.939843813.143996.1490000.44401650

60、5-1.43808522.420514067.549843813.143996.1490000.4440165052.53808518.527514067.798843829.314012.3190000.445813172-1.43808521.401514051.414843829.314012.3190000.4458131722.53808517.509514051.656843829.714012.7190000.445857616-1.43808521.377514051.014843829.714012.7190000.4458576162.53808517.484514051.