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

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

《EXCEL带批量计算的坐标表格(曲线段)表格文件下载.xls》由会员分享，可在线阅读，更多相关《EXCEL带批量计算的坐标表格(曲线段)表格文件下载.xls（130页珍藏版）》请在冰点文库上搜索。

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（度）（弧度）RLS1LS2842807.6623808109.863515299.822-139324039.544508330.6901818719000490490393240.2基基本本要要素素结结果果表表内移值内移值切线增值切线增值ZH至JD方位角缓和曲线角缓和曲线角切线长p1p2q1q2（度）（弧度）12T11.1121.112244.994244.9942392018239.33821114.177239810.0270.0273480.671#ZH至HY支矩坐标切线长圆曲线长曲线长JD至ZH方位角JD至HZ方位角HZ至JD方位角N（x）E（y）T2LyL（弧度）（弧度）（弧度）（度）（度）489.9644.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备备注注：

此此程程序序适适用用于于对对称称、不不对对称称缓缓和和曲曲线线以以及及圆圆曲曲线线，当当为为对对称称缓缓和和曲曲线线时时，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-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.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.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.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.7900000.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.43808987.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.228841418.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.2540000.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.43808983.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.326841470.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.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.706516347.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.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.122845103.39385286.4020000.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.5902959381.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.557512752.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.836845160.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.88025343.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.6090000.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-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.43809103.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.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.63991292.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.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.43809074.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.935516657.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.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.43809263.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.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-1.43809252.960517086.921840697.025880.0340000.097781505-1.43809250.367517080.962840703.525886.5340000.098503727-1.43809247.777517075.001840710.05893.0590000.099228727-1.438092