公路工程曲線要素計算表

1、公 路 工 程 曲 線 要 素 計 算 表交點交點坐標轉(zhuǎn)角緩和曲線長度編號樁號XY度分秒（左-，右+）LS1起點K20+254.257 3615363.903500259.347JD87K20+415.345 3615472.936500379.36855.0601740JD88K20+736.705 3615398.423500706.101-17.3616340JD89K21+328.767 3615447.634501297.377-20.5003660JD90K21+825.791 3615645.854501711.24247.5408435JD91終點豎曲線數(shù)據(jù)輸入序號頂點樁號頂點

2、高程前坡坡度%后坡坡度%圓曲線半徑1K20+479.160317.132-612.57431.1782K20+600.000332.32512.573.98937.2823K20+736.533337.763.980.555004K21+582.641341.990.5-2.051100005678超高線性選擇（線性輸 1，三次拋物線輸 2）1挖填方數(shù)據(jù)輸入計算內(nèi)容（正算輸 1，反算輸 2，）1說明：1、凡是角度輸入均用小數(shù)輸入法，如：123度23分12.9秒輸成123.23129 2、凡是樁號輸入均直接輸入，如：K20+560.234輸成20560.2343、在進行開挖線或回填線計算時，先用

3、反算計算出樁號，再將該樁號填入正算的“待算樁號”中，再在上面“計算內(nèi)容”中輸入“1”進行正算，才是正確結(jié)果。 黃色單元格為計算結(jié)果顯示區(qū)， 白色單元格為數(shù)據(jù)輸入?yún)^(qū)。 坐 標 正 算 左邊樁距中4左邊樁夾角901.57079633待算樁號右邊樁距中8右邊樁夾角901.57079633左 邊 樁中 樁右 邊 樁XYXYXK20+820.0003615409.439500790.0143615405.454500790.3633615397.484 坐 標 反 算 待 算 坐 標估計里程反 算 結(jié) 果XYZ里程K+距中（左-右+）3615410.914500690.106340K20+925.000

4、K20+719.068-4.951二公共點坐標轉(zhuǎn)換（大地坐標與施工坐標轉(zhuǎn)換）點號轉(zhuǎn)換前坐標（大地坐標）轉(zhuǎn)換后坐標（施工坐標）XYZ（高程）XY基點3615414.145500895.001338.7020.0000.000附和點3615414.560500899.98410.0000.000點號待轉(zhuǎn)換點坐標（大地坐標）計算輸出（施工坐標）XYZ（高程）XY13615406.172500895.665235.5000.0008.00123615363.903500259.347-637.631-2.68833615472.936500379.368-508.975-101.38443615398

5、.423500706.101-189.553-0.01053615447.634501297.377403.7670.02263615645.854501711.242832.656-163.1657-799231.1483561368.3918-799231.1483561368.3919-799231.1483561368.39110-799231.1483561368.391本程序是本人花了大量的時間編成的，為了表示對勞動成果的尊重，請你付點小費，你不會介意吧！ 創(chuàng)作人：徐明忠 QQ ：337699117 郵箱： 開戶行： 中國工商銀行 卡號：6222022403005702661 開戶

6、名：徐明忠 付費100元整 付完費請將你的郵箱地址發(fā)到我的郵箱中，我會在一天內(nèi)將密碼發(fā)到你的郵箱中。謝謝合作！ 歡迎你使用！請加我的QQ：337699117，我還有大量的測量方面資料和軟件，免費的喲！歡迎使用！WSKEZ2M1102.8469986-1-20666.37151 611774.1266 85.24241819611859.3691-0.967755757-1-508.767064.407880485.2423248501-1005.7910112.310203864.40798160#DIV/0!#DIV/0!#DIV/0!187.8999832#DIV/0!#DIV/0!#DI

7、V/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!WSKEZ2M1102.8469986#VALUE!-185.24241819-1-449.3940918064.407880485.24232485#VALUE!1-946.41809180112.310203864.4079816#VALUE!#DIV/0!#DIV/0!#DIV/0!187.8999832#DIV/0!0#DIV/0!#DIV/0

8、!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!WSKEZ2M1102.8469986#VALUE!-17.0223644997.022364499 85.2424181995.824498140-1-608.2242069064.407880485.242324851-1105.2482070112.310203864.4079816#DIV/0!#DIV/0!#DIV/0!187.8999832#DIV/0!#VALUE!#DIV/0!#DIV/0!#DI

9、V/0!#DIV/0!#DIV/0!#VALUE!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!WSKEZ2M1102.8469986-16.8549806546.854980654 85.2424181995.99188198#VALUE!-1-609.6849065064.407880485.24232485#VALUE!1-1106.7089070112.310203864.4079816#VALUE!#DIV/0!#DIV/0!#DIV/0!187.8999832#DIV/0!#VALUE!#

10、DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#VALUE!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!WSKEZ2M1102.8469986#VALUE!-16.8533228386.853322838 85.2424181995.9935398#VALUE!-1-609.6993737064.407880485.242324851-1106.7233740112.310203864.4079816#VALUE!#DIV/0!#DIV/0!#DIV

11、/0!187.8999832#DIV/0!#VALUE!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!TFSGC0.005RAbs(I-J)H+0.01(Z-L)J+(I-J)(Z+T-L)2(2RAbs(I-J)336.508454840.034877340.256261995.7338.164336.5084548127.55338.177337.67213310000施施工工坐坐標標與

12、與大大地地坐坐標標轉(zhuǎn)轉(zhuǎn)換換EXCELEXCEL表表格格EXCELEXCEL表表格格計計算算方方位位角角距距離離轉(zhuǎn)換前原坐標方位角轉(zhuǎn)換后坐標方位角 角度差值85.23921306085.23921306851421.17 000X03615414.1450.000YO500895.0010.000X13615414.56010.000M3615414.145Y1500899.9840.000N500895.001成成果果輸輸出出點號需轉(zhuǎn)換R需轉(zhuǎn)換V轉(zhuǎn)換后X轉(zhuǎn)換后Y13615406.172500895.665-1.6599E-058.0006015423615363.903500259.347-6

13、37.630803 -2.68796965733615472.936500379.368-508.974604 -101.383552243615398.423500706.101-189.553136 -0.01015429153615447.634501297.377403.76720770.02206949363615645.854501711.242832.6557627 -163.1649827700-799231.1483561368.391800-799231.1483561368.391900-799231.1483561368.3911000-799231.148356136

14、8.391曲線要素圓曲線切線長度外距曲線總長LS2半徑（R)長度T1T2EL40163.519117.254105.507105.50721.373197.25440500113.62897.44497.4446.094193.6286035067.27094.41794.4176.301187.2703510048.60562.12962.1299.980118.605#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#

15、DIV/0!#DIV/0!#DIV/0!#DIV/0!密碼線性超高橫坡數(shù)據(jù)輸入（繞中軸旋轉(zhuǎn)）前超高緩和段起點樁號前超高緩和段長度后超高緩和段長度全超高段橫坡%全超高長度起訖點的橫坡%337699117K20+349.83840.0040.004.00117.25-2.00K20+679.26140.0040.004.00113.63-2.00K21+294.35060.0060.003.0067.27-2.00K21+798.66235.0035.004.0048.61-2.00歡迎使用！變化點樁號邊溝寬度一級挖方邊坡二級挖方邊坡碎落臺寬度坡度(1:x) 高度臺階寬坡度(1:x)K20+925

16、.0000.500.50010.0002.0000.500公 路 工 程 曲 線 要 素 計 算 表緩和曲線長度K20+820.000中樁切線方位角設(shè) 計 高 程橫 坡 %中樁左邊樁右邊樁左邊樁 右邊樁Y500791.059850015.7 338.164338.004338.484-4.004.00設(shè)計高程路面高程邊坡開挖線超-，欠+超-，欠+i336.3113.6890.802100.4050990.00002561.57079677Z（高程）0.000Z（高程）-103.202-338.702-338.702-338.702-338.702-338.702-338.702-338.702

17、-338.702-338.702 坐 標 正 算 右 邊 樁 坐 標 反 算 二公共點坐標轉(zhuǎn)換（大地坐標與施工坐標轉(zhuǎn)換）轉(zhuǎn)換后坐標（施工坐標）計算輸出（施工坐標）本程序是本人花了大量的時間編成的，為了表示對勞動成果的尊重，請你付點小費，你不會介意吧！ 創(chuàng)作人：徐明忠 QQ ：337699117 郵箱： 開戶行： 中國工商銀行 卡號：6222022403005702661 開戶名：徐明忠 付費100元整 付完費請將你的郵箱地址發(fā)到我的郵箱中，我會在一天內(nèi)將密碼發(fā)到你的郵箱中。謝謝合作！ 159.42635.1644425P4.951433DS4.951411755.100556#VALUE!#V

18、ALUE!#VALUE!-17.60444 10678.961 59.372908280.9693718-20.83444 1.4877592-99.458194-13.7567847.902222 1.1241313-88.062051-48.2312820#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!59.372908280.9693718PDS55.100556#VALUE!#VALUE!#VALUE!-17.60444#VALUE!#VALUE!#VALUE!

19、-20.83444 1.4877592-158.83012-13.77461447.902222 1.1241313-143.54546-69.3645960#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!-158.83012-13.774614PDS55.100556#VALUE!#VALUE!#VALUE!-17.60444 1.672453-1.4606996-4.9535667-20.83444 1.4877592-0.5261565-5.1375747.902

20、222 1.1241313 1.33551278-4.98877460#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!-1.4606996-4.9535667PDS55.100556#VALUE!#VALUE!#VALUE!-17.60444 1.6753744-0.0144672-4.9514119-20.83444 1.4877592 0.90930643-4.867222147.902222 1.1241313 2.58096072-4.22555680#DIV/

21、0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!-0.0144672-4.9514119PDS55.100556#VALUE!#VALUE!#VALUE!-17.60444 1.6754033-0.0001433-4.9514117-20.83444 1.4877592 0.92351969-4.864523547.902222 1.1241313 2.59328481-4.21797950#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#

22、DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!-0.0001433-4.9514117ZPYPFZPFYPk-0.01068-44-3.9903263.97097862#DIV/0!-2-2-2-2#DIV/0!-2-2-2-2#VALUE!#DIV/0!#DIV/0!#DIV/0!#DIV/0!000-44-3.9903263.97097862轉(zhuǎn)換前原坐標方位角轉(zhuǎn)換后坐標方位角0.415104.983012.007228910象限角1.487704920方位角弧度表示 1.487704920方位角度表示85.239213060度、分、秒表示 851421

23、.17 000距離5.00010.000EXCELEXCEL表表格格計計算算方方位位角角距距離離曲線要素樁號ZHZY(HY)QZ度分秒樁號方位角樁號方位角樁號474447.2K20+309.838474447.2 K20+349.838 544515.4K20+408.4641025048.7K20+639.261 1025048.7 K20+679.261 1050819.3 K20+736.075851432.4K21+234.350851432.4 K21+294.350 900912.2K21+327.985642428.7K21+763.662642428.7 K21+798.662

24、 742605.1K21+822.9641875359.9#DIV/0!1875359.9#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!三次拋物線超高橫坡數(shù)據(jù)輸入（繞中軸旋轉(zhuǎn)）半幅路基加寬（漸變段）數(shù)據(jù)輸入（不包含水溝，路肩）轉(zhuǎn)向 （左-1，右+1）橫坡變化段起點樁號橫坡變化段起點橫坡橫坡變化段終點樁號橫坡變化段終點橫坡加寬（漸變）段起點樁號1K20

25、+600.000K20+700.000-1K20+720.000-1K20+740.0001K20+760.0001K20+780.0001K20+800.0001K20+820.0001K20+840.000三級挖方邊坡一級填方邊坡高度臺階寬度坡度(1:x)高度路緣石寬度坡度(1:x)1020.5101.51.5公 路 工 程 曲 線 要 素 計 算 表線性超高橫坡數(shù)據(jù)輸入（繞中軸旋轉(zhuǎn)）二級挖方邊坡歡迎你使用！請加我的QQ：337699117，我還有大量的測量方面資料和軟件，免費的喲！路基設(shè)計寬度左邊樁右邊樁 4.254.25#VALUE! 坐 標 正 算 10678.960551.4877

26、59231DJ#VALUE!#VALUE!10678.96055-10680.476941.487759231-3.004147531.124131343-2.640519642#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!D#VALUE!#VALUE!#VALUE!#VALUE!1.487759231-3.0550836551.124131343-2.691455768#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!D#VALUE!#VALUE!1.6724529

27、97-1.8575477711.487759231-1.6728540051.124131343-1.309226118#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!D#VALUE!#VALUE!1.675374396-1.5737181461.487759231-1.386102981.124131343-1.022475093#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!D#VALUE!#VALUE!1.67540333-1.5708252611.487759

28、231-1.3831811621.124131343-1.019553274#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!zp2YP2KFXPDWzWy4.25337.9937308338.33373084.25-17.3616304.25-20.5003604.2547.540844.25#DIV/0!4.25#DIV/0!4.25#DIV/0!4.25#DIV/0!4.25-20.50036直線長度YZ(YH)HZ樁號方位角樁號方位角751748.0 K20+467.091955020.7K20+507.091 102504

29、8.9 161.0881113856.9 K20+792.890825701.8K20+832.890851432.4132.170953934.2 K21+361.620592948.9K21+421.620642428.8401.461882132.9 K21+847.267 1021700.8 K21+882.267 1121837.1 342.042#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#

30、DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!加寬（漸變）段起點寬度加寬（漸變）段終點寬度加寬（漸變）段長度標準寬度4.254.25404.254.254.25404.254.254.25404.254.254.25404.254.254.25404.254.254.25404.254.254.25404.254.254.25404.25二級填方邊坡高度臺階寬度坡度(1:x)高度101.51.5公 路 工 程 曲 線 要 素 計 算 表曲線要素樁號QZ半幅路基加寬（漸變段）數(shù)據(jù)輸入（不包含水溝，路肩）一級填方邊坡歡迎你使用！請加我的QQ：337

31、699117，我還有大量的測量方面資料和軟件，免費的喲！zyTZTY5.7531346045.5831346045.7531346045.5831346045.7531346040.802#VALUE!計算參數(shù)0.4074542180.4074542180.1333247430.1333247430.4284446360.4284446360.509787210.50978721#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!55.1004722219.9900268519.990026851.795017273xy17.6045277819.9989333319.998933331.487759379#VALUE!#VALUE!20.8343333329.9926530629.992653061.1241314713615409.439500790.01447.90233333