EXCEL带批量计算的坐标表格(曲线段)表格文件下载.xls

1、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）E（Y）左+1,右-1 （度）（弧度）RLS1LS2842

2、807.6623808109.863515299.822-139324039.544508330.6901818719000490490393240.2基基本本要要素素结结果果表表内移值内移值切线增值切线增值ZH至JD方位角缓和曲线角缓和曲线角切线长p1p2q1q2 （度）（弧度）1 2T11.1121.112244.994244.9942392018239.33821114.177239810.0270.0273480.671#ZH至HY支矩坐标切线长圆曲线长曲线长JD至ZH方位角JD至HZ方位角HZ至JD方位角N（x）E（y）T2LyL（弧度）（弧度）（弧度）（度）（度）489.9644.

3、4463480.6715721.6376701.6371.0356471564.8674216811.72582902898.88271944985258曲曲线线主主点点桩桩号号、坐坐标标结结果果表表ZH桩号HY桩号路线方向QZ桩号YH桩号HZ桩号839326.991839816.991左+1,右-1842677.810845538.628846028.628N（X）E（Y）N（X）E（Y）-1N（X）E（Y）N（X）E（Y）N（X）3809884.898518293.8693809638.856517870.1383808576.058512345.6713808647.322备备注注：此此

4、程程序序适适用用于于对对称称、不不对对称称缓缓和和曲曲线线以以及及圆圆曲曲线线，当当为为对对称称缓缓和和曲曲线线时时，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.63114880.6400000.542293289-3.63808511.560513183.723844704.00994887.0180000.543002048-

5、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.545895449-3.63808512.732513151.338844697.63114880.6400000.542293289-6.43808514

6、.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-6.43808515.285513157.964844730.05054913.0590000.545895449-6.43808515.530513151

7、.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.111513197.064844690.78164873.7900000.541532237-3.63808511.328513190.566844697.

8、31054880.3190000.542257672-3.63808511.549513184.044844664.89114847.9000000.538655512-6.43808513.294513216.519844671.26994854.2780000.53936427-6.43808513.492513210.148844677.77384860.7820000.540086926-6.43808513.699513203.652844684.27774867.2860000.540809581-6.43808513.910513197.156844690.78164873.79

9、00000.541532237-6.43808514.126513190.660844697.31054880.3190000.542257672-6.43808514.348513184.140841398.631581.6390000.1757376161.43808993.349516428.313841405.0051588.0140000.1764459491.43808991.272516422.285841411.5051594.5140000.1771681721.43808989.158516416.137841418.0051601.0140000.1778903941.4

10、3808987.049516409.988841424.5051607.5140000.1786126161.43808984.945516403.837841431.031614.0390000.1793376161.43808982.836516397.661841398.631581.6390000.175737616-1.43808995.996516427.400841405.0051588.0140000.176445949-1.43808993.919516421.374841411.5051594.5140000.177168172-1.43808991.807516415.2

11、28841418.0051601.0140000.177890394-1.43808989.698516409.081841424.5051607.5140000.178612616-1.43808987.594516402.932841431.031614.0390000.179337616-1.43808985.487516396.757841431.371614.3790000.1793753941.43808982.727516397.339841437.7451620.7540000.1800837271.43808980.671516391.304841444.2451627.25

12、40000.1808059491.43808978.580516385.148841450.7451633.7540000.1815281721.43808976.494516378.991841457.2451640.2540000.1822503941.43808974.411516372.832841463.771646.7790000.1829753941.43808972.326516366.649841431.371614.3790000.179375394-1.43808985.377516396.436841437.7451620.7540000.180083727-1.438

13、08983.322516390.402841444.2451627.2540000.180805949-1.43808981.232516384.248841450.7451633.7540000.181528172-1.43808979.146516378.093841457.2451640.2540000.182250394-1.43808977.064516371.937841463.771646.7790000.182975394-1.43808974.979516365.755841464.111647.1190000.1830131721.43808972.217516366.32

14、6841470.4851653.4940000.1837215051.43808970.184516360.283841476.9851659.9940000.1844437271.43808968.115516354.120841483.4851666.4940000.1851659491.43808966.051516347.956841489.9851672.9940000.1858881721.43808963.991516341.790841496.511679.5190000.1866131721.43808961.928516335.598841464.111647.119000

15、0.183013172-1.43808974.871516365.433841470.4851653.4940000.183721505-1.43808972.838516359.391841476.9851659.9940000.184443727-1.43808970.770516353.230841483.4851666.4940000.185165949-1.43808968.706516347.068841489.9851672.9940000.185888172-1.43808966.647516340.903841496.511679.5190000.186613172-1.43

16、808964.585516334.714845090.51115273.5200000.5859466231.43808528.630512791.262845096.88995279.8980000.5866553811.43808529.130512784.902845103.39385286.4020000.5873780371.43808529.644512778.417845109.89775292.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