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

程序目录曲线主点桩号与坐标计算!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曲线计算要素 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf (已知条件)交点桩号交点坐标转角值方向转角值曲线半径缓和曲线长缓和曲线长JDN(X)E(Y)左+1,右-1°′″α（度）α（弧度）RLS1LS2842807.6623808109.863515299.822-1393240.2339.54450833330.69018187159000490490[h]°mm′ss1.6″基本要素结果表内移值内移值切线增值切线增值ZH至JD方位角缓和曲线角缓和曲线角切线长p1p2q1q2°′″（度）（弧度）β1β2T1842807.6621.1121.112244.994244.9942392017.56239.33821111114.17723980970.0270.0273480.671[h]°mm′ss10.0″ZH至HY支矩坐标切线长圆曲线长曲线长JD至ZH方位角JD至HZ方位角HZ至JD方位角HY至JD方位角N(x)E(y)T2LyL（弧度）（弧度）（弧度）（度）（度）（弧度）489.9644.4463480.6715721.6376701.6371.03564715614.86742168121.725829027698.88271944444.1201133101851854.2044620319曲线主点桩号、坐标结果表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)E(Y)3809884.898518293.8693809638.856517870.1383808576.058512345.6713808647.322511860.897备注：此程序适用于对称、不对称缓和曲线以及圆曲线，当为对称缓和曲线时，LS1=LS2;当为圆曲线时，LS1=LS2=0。涂红处输入变量K839326.991+至K846028.628+任意点桩号里程差W支矩x坐标支矩y坐标至起点距离切线角距中桩距离待求点坐标WCD√(C^2+D^2)E左+,右-N(X)E(Y)844697.63105999984880.6400000.5422932895-3.63808511.560513183.723844704.00988499984887.0180000.5430020478-3.63808511.782513177.351844710.51378499984893.5220000.5437247034-3.63808512.012513170.854844717.01768499994900.0260000.5444473589-3.63808512.247513164.357844723.52158499994906.5300000.5451700145-3.63808512.487513157.860844730.05049999994913.0590000.5458954495-3.63808512.732513151.338844697.63105999984880.6400000.5422932895-6.43808514.359513183.820844704.00988499984887.0180000.5430020478-6.43808514.580513177.449844710.51378499984893.5220000.5437247034-6.43808514.810513170.954844717.01768499994900.0260000.5444473589-6.43808515.045513164.459844723.52158499994906.5300000.5451700145-6.43808515.285513157.964844730.05049999994913.0590000.5458954495-6.43808515.530513151.444844664.89105999984847.9000000.5386555117-3.63808510.495513216.433844671.26988499984854.2780000.53936427-3.63808510.693513210.060844677.77378499994860.7820000.5400869256-3.63808510.900513203.562844684.27768499994867.2860000.5408095811-3.63808511.111513197.0644398158.840500769.4934844690.78158499994873.7900000.5415322367-3.63808511.328513190.566844697.31049999994880.3190000.5422576717-3.63808511.549513184.0444398438.795499810.1582844664.89105999984847.9000000.5386555117-6.43808513.294513216.519844671.26988499984854.2780000.53936427-6.43808513.492513210.148844677.77378499994860.7820000.5400869256-6.43808513.699513203.652844684.27768499994867.2860000.5408095811-6.43808513.910513197.156844690.78158499994873.7900000.5415322367-6.43808514.126513190.660844697.31049999994880.3190000.5422576717-6.43808514.348513184.140841398.631581.6390000.17573761611.43808993.349516428.313841405.0051588.0140000.17644594951.43808991.272516422.285841411.5051594.5140000.17716817171.43808989.158516416.137841418.0051601.0140000.17789039391.43808987.049516409.988841424.5051607.5140000.17861261611.43808984.945516403.837841431.031614.0390000.17933761611.43808982.836516397.661841398.631581.6390000.1757376161-1.43808995.996516427.400841405.0051588.0140000.1764459495-1.43808993.919516421.374841411.5051594.5140000.1771681717-1.43808991.807516415.228841418.0051601.0140000.1778903939-1.43808989.698516409.081841424.5051607.5140000.1786126161-1.43808987.594516402.932841431.031614.0390000.1793376161-1.43808985.487516396.757841431.371614.3790000.17937539391.43808982.727516397.339841437.7451620.7540000.18008372731.43808980.671516391.304841444.2451627.2540000.18080594951.43808978.580516385.148841450.7451633.7540000.18152817171.43808976.494516378.991841457.2451640.2540000.18225039391.43808974.411516372.832841463.771646.7790000.18297539391.43808972.326516366.649841431.371614.3790000.1793753939-1.43808985.377516396.436841437.7451620.7540000.1800837273-1.43808983.322516390.402841444.2451627.2540000.1808059495-1.43808981.232516384.248841450.7451633.7540000.1815281717-1.43808979.146516378.093841457.2451640.2540000.1822503939-1.43808977.064516371.937841463.771646.7790000.1829753939-1.43808974.979516365.755841464.111647.1190000.18301317171.43808972.217516366.326841470.4851653.4940000.1837215051.43808970.184516360.283841476.9851659.9940000.18444372731.43808968.115516354.120841483.4851666.4940000.18516594951.43808966.051516347.956841489.9851672.9940000.18588817171.43808963.991516341.790841496.511679.5190000.18661317171.43808961.928516335.598841464.111647.1190000.1830131717-1.43808974.871516365.433841470.4851653.4940000.183721505-1.43808972.838516359.391841476.9851659.9940000.1844437273-1.43808970.770516353.230841483.4851666.4940000.1851659495-1.43808968.706516347.068841489.9851672.9940000.1858881717-1.43808966.647516340.903841496.511679.5190000.1866131717-1.43808964.585516334.714845090.51105999975273.5200000.58594662281.43808528.630512791.262845096.88988499975279.8980000.58665538111.43808529.130512784.902845103.39378499975286.4020000.58737803671.43808529.644512778.417845109.89768499975292.9060000.58810069231.43808530.162512771.933845116.40158499985299.4100000.58882334781.43808530.686512765.449845122.93049999985305.9390000.58954878281.43808531.216512758.941845090.51105999975273.5200000.5859466228-1.43808531.422512791.480845096.88988499975279.8980000.5866553811-1.43808531.921512785.122845103.39378499975286.4020000.5873780367-1.43808532.435512778.639845109.89768499975292.9060000.5881006923-1.43808532.953512772.157845116.40158499985299.4100000.5888233478-1.43808533.477512765.675845122.93049999985305.9390000.5895487828-1.43808534.006512759.169845123.25105999975306.2600000.58958440061.43808531.242512758.621845129.65489999975312.6630000.59029593841.43808531.767512752.238845136.15879999975319.1670000.59101859391.43808532.304512745.755845142.66269999985325.6710000.59174124951.43808532.846512739.273845147.66569999985330.6740000.59229713841.43808533.267512734.287845123.25105999975306.2600000.58958440061.43808531.242512758.621845129.65489999975312.6630000.5902959384-1.43808534.557512752.468845136.15879999975319.1670000.5910185939-1.43808535.094512745.987845142.66269999985325.6710000.5917412495-1.43808535.637512739.507845147.66569999985330.6740000.5922971384-1.43808536.057512734.523845147.97503999995330.9840000.5923315095-1.43808536.083512734.214845154.37765337.3860000.593042905-1.43808536.625512727.836845160.88025343.8890000.5937654161-3.63808539.372512721.547845167.38285350.3910000.5944879273-3.63808539.931512715.071845172.38485355.3930000.595043705-3.63808540.365512710.090845147.97503999995330.9840000.5923315095-6.43808541.065512734.636845154.37765337.3860000.593042905-6.43808541.607512728.261845160.88025343.8890000.5937654161-6.43808542.161512721.787845167.38285350.3910000.5944879273-6.43808542.721512715.313845172.38485355.3930000.595043705-6.43808543.154512710.333845172.695045355.7040000.5950781761-3.63808540.392512709.781845179.09760000015362.1060000.5957895717-3.63808540.951512703.405845185.60020000015368.6090000.5965120828-3.63808541.524512696.930845192.10280000015375.1110000.5972345939-3.63808542.101512690.456845197.10480000015380.1130000.5977903717-3.63808542.549512685.476845172.695045355.7040000.5950781761-6.43808543.181512710.024845179.09760000015362.1060000.5957895717-6.43808543.740512703.651845185.60020000015368.6090000.5965120828-6.43808544.313512697.178845192.10280000015375.1110000.5972345939-6.43808544.890512690.706845197.10480000015380.1130000.5977903717-6.43808545.337512685.727841070.52105999991253.5300000.1392810673-1.43809108.609516735.505841076.8998851259.9080000.1399898256-1.43809106.312516729.555841083.4037851266.4120000.1407124811-1.43809103.976516723.486841089.9076851272.9160000.1414351367-1.43809101.643516717.416841096.4115851279.4200000.1421577923-1.43809099.315516711.344841102.94051285.9490000.1428832273-1.43809096.983516705.247841103.26105999991286.2700000.1429188451.43809094.253516705.947841109.6398851292.6480000.14362760341.43809091.977516699.987841116.1437851299.1520000.14435025891.43809089.662516693.908841122.6476851305.6560000.14507291451.43809087.351516687.828841129.1515851312.1600000.145795571.43809085.044516681.745841135.68051318.6890000.1465210051.43809082.733516675.638841103.26105999991286.2700000.142918845-1.43809096.868516704.948841109.6398851292.6480000.1436276034-1.43809094.594516698.989841116.1437851299.1520000.1443502589-1.43809092.279516692.912841122.6476851305.6560000.1450729145-1.43809089.969516686.834841129.1515851312.1600000.14579557-1.43809087.663516680.754841135.68051318.6890000.146521005-1.43809085.352516674.648841127.99105999991311.0000000.14566662281.43809085.455516682.831841134.36988499991317.3780000.14637538111.43809083.197516676.864841140.8737851323.8820000.14709803671.43809080.898516670.779841147.3776851330.3860000.14782069231.43809078.603516664.692841153.8815851336.8900000.14854334781.43809076.314516658.604841160.41051343.4190000.14926878281.43809074.019516652.490841127.99105999991311.0000000.1456666228-1.43809088.074516681.839841134.36988499991317.3780000.1463753811-1.43809085.816516675.874841140.8737851323.8820000.1470980367-1.43809083.518516669.791841147.3776851330.3860000.1478206923-1.43809081.224516663.706841153.8815851336.8900000.1485433478-1.43809078.935516657.619841160.41051343.4190000.1492687828-1.43809076.641516651.507840644.91827.9190000.09199094951.43809268.721517129.818840651.285834.2940000.09269928281.43809266.147517123.985840657.785840.7940000.0934215051.43809263.526517118.035840664.285847.2940000.09414372731.43809260.910517112.084840670.785853.7940000.09486594951.43809258.298517106.131840677.31860.3190000.09559094951.43809255.681517100.153840644.91827.9190000.0919909495-1.43809271.282517128.687840651.285834.2940000.0926992828-1.43809268.709517122.855840657.785840.7940000.093421505-1.43809266.089517116.908840664.285847.2940000.0941437273-1.43809263.474517110.958840670.785853.7940000.0948659495-1.43809260.863517105.007840677.31860.3190000.0955909495-1.43809258.246517099.030840677.65860.6590000.09562872731.43809255.545517099.841840684.025867.0340000.09633706061.43809252.992517093.998840690.525873.5340000.09705928281.43809250.393517088.039840697.025880.0340000.0977815051.43809247.799517082.079840703.525886.5340000.09850372731.43809245.209517076.116840710.05893.0590000.09922872731.43809242.613517070.128840677.65860.6590000.0956287273-1.43809258.110517098.719840684.025867.0340000.0963370606-1.43809255.558517092.878840690.525873.5340000.0970592828-1.43809252.960517086.921840697.025880.0340000.097781505-1.43809250.367517080.962840703.525886.5340000.0985037273-1.43809247.777517075.001840710.05893.0590000.0992287273-1.43809245.182517069.015840710.39893.3990000.0992665051.43809242.478517069.816840716.765899.7740000.09997483841.43809239.946517063.964840723.265906.2740000.10069706061.43809237.369517057.996840729.765912.7740000.10141928281.43809234.797517052.026840736.265919.2740000.1021415051.43809232.228517046.053840742.79925.7990000.1028665051.43809229.654517040.056840710.39893.3990000.099266505-1.43809245.047517068.703840716.765899.7740000.0999748384-1.43809242.516517062.853840723.265906.2740000.1006970606-1.43809239.940517056.887840729.765912.7740000.1014192828-1.43809237.368517050.918840736.265919.2740000.102141505-1.43809234.801517044.948840742.79925.7990000.102866505-1.43809232.228517038.953840743.13926.1390000.10290428281.43809229.520517039.744840749.505932.5140000.10361261611.43809227.010517033.883840756.005939.0140000.10433483841.43809224.455517027.905840762.505945.5140000.10505706061.43809221.904517021.925840769.005952.0140000.10577928281.43809219.357517015.944840775.53958.5390000.10650428281.43809216.805517009.938840743.13926.1390000.1029042828-1.43809232.094517038.641840749.505932.5140000.1036126161-1.43809229.584517032.781840756.005939.0140000.1043348384-1.43809227.030517026.805840762.505945.5140000.1050570606-1.43809224.480517020.828840769.005952.0140000.1057792828-1.43809221.934517014.848840775.53958.5390000.1065042828-1.43809219.382517008.844840775.87958.8790000.10654206061.43809216.672517009.625840782.245965.2540000.10725039391.43809214.183517003.755840788.745971.7540000.10797261611.43809211.650516997.767840795.245978.2540000.10869483841.43809209.120516991.779840801.745984.7540000.10941706061.43809206.596516985.788840808.27991.2790000.11014206061.43809204.065516979.772840775.87958.8790000.1065420606-1.43809219.250517008.531840782.245965.2540000.1072503939-1.43809216.761517002.662840788.745971.7540000.1079726161-1.43809214.229516996.677840795.245978.2540000.1086948384-1.43809211.700516990.690840801.745984.7540000.1094170606-1.43809209.176516984.701840808.27991.2790000.1101420606-1.43809206.647516978.688843256.563439.5690000.38217428282.53808571.236514621.943843272.733455.7390000.3839709495-1.43808573.092514605.412843272.733455.7390000.38397094952.53808569.222514605.894843273.133456.1390000.3840153939-1.43808573.042514605.015843273.133456.1390000.38401539392.53808569.172514605.497843289.33472.3090000.3858120606-1.43808571.059514588.970843289.33472.3090000.38581206062.53808567.188514589.445843305.473488.4790000.3876087273-1.43808569.104514572.921843305.473488.4790000.38760872732.53808565.232514573.389843305.873488.8790000.3876531717-1.43808569.056514572.524843305.873488.8790000.38765317172.53808565.184514572.992843322.043505.0490000.3894498384-1.43808567.130514556.472843322.043505.0490000.38944983842.53808563.258514556.933843338.213521.2190000.391246505-1.43808565.234514540.416843338.213521.2190000.3912465052.53808561.360514540.870843338.613521.6190000.3912909495-1.43808565.187514540.018843338.613521.6190000.39129094952.53808561.314514540.472843354.783537.7890000.3930876161-1.43808563.320514523.959843354.783537.7890000.39308761612.53808559.446514524.406843370.953553.9590000.3948842828-1.43808561.482514507.897843370.953553.9590000.39488428282.53808557.607514508.336843371.353554.3590000.3949287273-1.43808561.437514507.499843371.353554.3590000.39492872732.53808557.562514507.939843387.523570.5290000.3967253939-1.43808559.628514491.433843387.523570.5290000.39672539392.53808555.752514491.866843403.693586.6990000.3985220606-1.43808557.849514475.364843403.693586.6990000.39852206062.53808553.972514475.790843404.093587.0990000.398566505-1.43808557.805514474.966843404.093587.0990000.3985665052.53808553.928514475.392843420.263603.2690000.4003631717-1.43808556.055514458.894843420.263603.2690000.40036317172.53808552.177514459.313843436.433619.4390000.4021598384-1.43808554.333514442.818843436.433619.4390000.40215983842.53808550.455514443.230843436.833619.8390000.4022042828-1.43808554.291514442.421843436.833619.8390000.40220428282.53808550.413514442.8328434533636.0090000.4040009495-1.43808552.600514426.3428434533636.0090000.40400094952.53808548.721514426.746843469.173652.1790000.4057976161-1.43808550.937514410.260843469.173652.1790000.40579761612.53808547.057514410.658843469.573652.5790000.4058420606-1.43808550.896514409.862843469.573652.5790000.40584206062.53808547.016514410.260843485.743668.7490000.4076387273-1.43808549.263514393.777843485.743668.7490000.40763872732.53808545.383514394.168843501.913684.9190000.4094353939-1.43808547.659514377.690843501.913684.9190000.40943539392.53808543.778514378.073843502.313685.3190000.4094798384-1.43808547.619514377.292843502.313685.3190000.40947983842.53808543.738514377.675843518.483701.4890000.411276505-1.43808546.045514361.201843518.483701.4890000.4112765052.53808542.163514361.577843534.653717.6590000.4130731717-1.43808544.499514345.108843534.653717.6590000.41307317172.53808540.617514345.477843535.053718.0590000.4131176161-1.43808544.461514344.710843535.053718.0590000.41311761612.53808540.579514345.079843551.223734.2290000.4149142828-1.43808542.945514328.613843551.223734.2290000.41491428282.53808539.062514328.976843567.393750.3990000.4167109495-1.43808541.458514312.514843567.393750.3990000.41671094952.53808537.574514312.870843567.793750.7990000.4167553939-1.43808541.422514312.116843567.793750.7990000.41675539392.53808537.538514312.471843583.963766.9690000.4185520606-1.43808539.964514296.014843583.963766.9690000.41855206062.53808536.080514296.363843600.133783.1390000.4203487273-1.43808538.535514279.910843600.133783.1390000.42034872732.53808534.650514280.251843600.533783.5390000.4203931717-1.43808538.501514279.512843600.533783.5390000.42039317172.53808534.615514279.853843616.73799.7090000.4221898384-1.43808537.102514263.405843616.73799.7090000.42218983842.53808533.216514263.739843632.873815.8790000.423986505-1.43808535.732514247.296843632.873815.8790000.4239865052.53808531.845514247.623843633.273816.2790000.4240309495-1.43808535.698514246.897843633.273816.2790000.42403094952.53808531.812514247.224843649.443832.4490000.4258276161-1.43808534.358514230.785843649.443832.4490000.42582761612.53808530.471514231.105843665.613848.6190000.4276242828-1.43808533.046514214.671843665.613848.6190000.42762428282.53808529.159514214.984843666.013849.0190000.4276687273-1.43808533.014514214.272843666.013849.0190000.42766872732.53808529.127514214.585843682.183865.1890000.4294653939-1.43808531.733514198.156843682.183865.1890000.42946539392.53808527.845514198.461843698.353881.3590000.4312620606-1.43808530.480514182.037843698.353881.3590000.43126206062.53808526.591514182.336843698.753881.7590000.431306505-1.43808530.449514181.638843698.753881.7590000.4313065052.53808526.561514181.937843714.923897.9290000.4331031717-1.43808529.226514165.517843714.923897.9290000.43310317172.53808525.337514165.809843731.093914.0990000.4348998384-1.43808528.032514149.394843731.093914.0990000.43489983842.53808524.142514149.678843731.493914.4990000.4349442828-1.43808528.003514148.995843731.493914.4990000.43494428282.53808524.113514149.279843747.663930.6690000.4367409495-1.43808526.839514132.869843747.663930.6690000.43674094952.53808522.948514133.147843763.833946.8390000.4385376161-1.43808525.703514116.742843763.833946.8390000.43853761612.53808521.812514117.012843764.233947.2390000.4385820606-1.43808525.675514116.343843764.233947.2390000.43858206062.53808521.785514116.613843780.43963.4090000.4403787273-1.43808524.570514100.213843780.43963.4090000.44037872732.53808520.678514100.476843796.573979.5790000.4421753939-1.43808523.493514084.082843796.573979.5790000.44217539392.53808519.601514084.338843796.973979.9790000.4422198384-1.43808523.467514083.682843796.973979.9790000.44221983842.53808519.575514083.939843813.143996.1490000.444016505-1.43808522.420514067.549843813.143996.1490000.4440165052.53808518.527514067.798843829.314012.3190000.4458131717-1.43808521.401514051.414843829.314012.3190000.44581317172.53808517.509514051.656843829.714012.7190000.4458576161-1.43808521.377514051.014843829.714012.7190000.44585761612.53808517.484514051.256843841.8754024.8840000.4472092828-1.43808520.630514038.874843841.8754024.8840000.44720928282.53808516.738514039.111843854.044037.0490000.4485609495-1.43808519.900514026.733843854.044037.0490000.44856094952.53808516.007514026.964843854.444037.4490000.4486053939-1.43808519.877514026.334843854.444037.4490000.44860539392.53808515.984514026.565843866.6054049.6140000.4499570606-1.43808519.164514014.192843866.6054049.6140000.44995706062.53808515.270514014.418843878.774061.7790000.4513087273-1.43808518.467514002.048843878.774061.7790000.45130872732.53808514.574514002.269843879.174062.1790000.4513531717-1.43808518.445514001.649843879.174062.1790000.45135317172.53808514.551514001.870843895.344078.3490000.4531498384-1.43808517.545513985.507843895.344078.3490000.45314983842.53808513.651513985.720843911.514094.5190000.454946505-1.43808516.674513969.363843911.514094.5190000.4549465052.53808512.780513969.569843911.914094.9190000.4549909495-1.43808516.653513968.963843911.914094.9190000.45499094952.53808512.759513969.170843928.084111.0890000.4567876161-1.43808515.812513952.818843928.084111.0890000.45678761612.53808511.917513953.017843944.254127.2590000.4585842828-1.43808515.000513936.671843944.254127.2590000.45858428282.53808511.105513936.863843944.654127.65854532180000.4586287273843944.65843960.82843960.82843976.99843976.9