道路工程計算表格直線、曲線轉角表.xls

《道路工程計算表格直線、曲線轉角表.xls》由會員上傳分享，免費在線閱讀，更多相關內容在行業(yè)資料-天天文庫。

交點樁號交點號交點樁號pj（度）XYp1P2Q1Q2T1T2ERls1ls2直線長度交點間距L圓曲線長曲線總長1175.7543.30610.680224730.6802247334.9841203734.98412037154.35154.3523.51300.0070.0070.0021.40175.751156.75296.752937.31223.6878000096.5896.581.553000.000.000.00522.59773.522193.09193.0931915.1862.6053000079.5979.590.903500.000.000.00801.77977.943159.15159.1542381.27826.19940.680224730.6802247334.9841203734.98412037104.95104.958.71300.0070.0070.00281.58466.12467.18207.1852788.36233.05800.8160950.81609534.9771333334.97713333109.41109.4111.63250.0070.0070.00195.45409.81574.24214.2463130.46434.73060.8481098690.84810986917.4503761617.4503761636.4836.483.7560.0035.0035.00200.79346.6861.3771.3773194.37730.8997000029.0229.023.94105.000.000.000.0065.5756.6356.6383282.98310.5458000061.0061.002.81661.000.000.00-0.0090.028121.66121.6693419.47843.58560.3504521650.35045216517.4915695817.4915695875.8375.8311.58145.5735.0035.000.00136.84975.74145.74103543.91736.41420.5031806552.61701959917.482601339.792230154.5470.425.87101.3335.0080.00-0.00130.37106.90121.90113678.12752.74112.0532364932.05323649329.8292936729.8292936766.8466.8410.7372.6160.0060.000.00137.27116.84126.84123923.15546.04220.4396567090.43965670917.486723717.486723766.9666.9610.52116.0035.0035.00118.07251.881258.22128.22134082.07515.46670.086129053017.49949129097.6680.805.53592.6035.000.000.00164.6313142.47177.47144211.37671.937500.758832689017.4603221849.4965.9115.8167.100.0035.00-0.00130.291466.75101.75154395.83254.83080.7832235720.78322357217.4577169617.4577169651.5851.589.1165.0035.0035.0080.62198.111527.2097.20164526.44732.62920.5091005770.50910057724.9875459124.9875459184.9984.999.11204.5050.0050.00-0.00136.571666.46166.46174652.68123.96360.3981240750.39812407517.4891167417.4891167444.7644.763.26128.1235.0035.000.00129.761718.5988.59184872.47923.1319000051.1651.165.18250.000.000.00124.81220.7418100.93100.93195260.58549.80920.255138550.2551385517.4955338517.49553385110.47110.4720.79200.0035.0035.00227.87389.519138.87208.87205558.84152.43420.6657142860.66571428619.9733333319.9733333369.5469.5412.21100.0040.0040.00130.32310.332051.51131.51215736.54855.81690.7544604920.30570176927.4751134817.49358672115.73106.6022.82166.9055.0035.000.00185.2821117.59207.59226060.01880.12810.7028746140.70287461424.9762380624.97623806150.08150.0846.32148.0550.0050.0081.53338.2122157.05257.05236249.39993.74670.8481098690.84810986917.4503761617.4503761682.4182.4129.0160.0035.0035.00-0.00232.492363.17133.17246511.384127.07970.9246748220.92467482217.4409435317.44094353129.80129.8070.5155.0035.0035.0081.42293.642486.99156.99256627.79378.87140.5881974890.58819748917.4762066417.4762066489.2389.2326.3086.6535.0035.000.00219.032584.28154.28266808.44215.66180.3912106810.08800001236.8950214617.49946895115.5998.405.85580.0073.8035.00-0.00204.8226104.14212.94276969.27782.35110.9837925470.98379254717.4330861617.4330861663.4963.4918.2851.6735.0035.00-0.00161.892739.27109.27287394.39562.85170.7275390630.72753906317.4635416717.4635416760.6860.6812.8970.0035.0035.00318.66442.832841.79111.79297486.46436.65390.7254755360.72547553617.4637491117.4637491140.9640.964.5270.2035.0035.000.00101.64299.9179.91 切曲差DZHHYQZYHHZ11.9621.4091.40169.77248.15318.150.07840.73840.73937.281033.831033.830.031835.601835.601915.171994.751994.752.732276.332346.332379.922413.502483.504.582678.952748.952786.072823.192893.191.593093.993128.993129.673130.363165.361.413165.363165.363193.673221.983221.980.343221.983221.983282.813343.643343.645.933343.643378.643416.513454.383489.383.063489.383524.383527.833531.283611.286.853611.283671.283674.703678.123738.125.713856.193891.193920.303949.413984.410.993984.414019.414090.654161.884161.8813.654161.884161.884195.264228.634263.635.954344.254379.254392.854406.464441.463.534441.454491.454524.684557.914607.910.944607.924642.924652.214661.504696.501.394821.324821.324871.784922.254922.2512.075150.115185.115254.555323.985358.987.575489.305529.305555.055580.815620.8114.745620.815675.815734.615793.415828.4143.115909.945959.946038.466116.996166.9931.666166.996201.996233.576265.166300.16102.626381.586416.586460.076503.576538.5724.176538.576573.576615.716657.856692.851.066692.856766.656818.726870.796905.7917.716905.796940.796960.426980.057015.059.577333.727368.727389.617410.507445.502.017445.517480.517485.467490.427525.42 直線、曲線及轉角表新縣縣城至河鋪公路改建工程施工圖設計第5頁共頁曲線要素值曲線位置直線長度及方向交點交點樁號交點坐標轉角值緩和第一緩和第二緩和交點計算方位角備注切線曲線第一緩和曲線終點第二緩和直線長度號半徑曲線外距校正值曲線中點曲線或圓間距或長度長度曲線起點或圓曲線曲線終點（米）長度曲線終點（米）計算方向角xy起點1234567891011121314151617181920起點k0+00091444.612103224.57396.04216.63529°49′18″43K0+216.6491632.560103332.306右6°54′04″2000.00120.59240.903.630.29K0+096.04K0+096.04K0+216.49K0+336.94K0+336.94-58.33139.19936°43′22″44K0+355.5491744.133103415.539左7°59′34″600.0070.0076.94153.701.80.18K0+278.60K0+348.60K0+355.45K0+362.31K0+432.31-34.27106.30128°43′48″45K0+461.6791837.348103466.636左9°20′33″350.0070.0063.63127.071.750.20K0+398.03K0+468.03K0+461.57K0+455.10K0+525.1065.91129.54619°23′14″K3997+222.46K0+591.0191959.548103509.639右0°14′52″237.11459.6933.450.00K0+591.01K0+591.01K0+591.01K0+000.0080730.02139.00719°38′06″K3998+972.47K0+730.0292090.472103556.349右15°43′54″147.39294.751.090.00K0+730.02K0+730.02K0+730.02K0+000.0077831.81101.78435°21′60″K3999+974.48K0+831.8192173.473103615.262左8°29′43″111.78223.560.620.00K0+831.81K0+831.81K0+831.81K0+000.0069952.67120.86326°52′17″K4001+296.49K0+952.6792281.286103669.891右4°13′54″170.08335.6015.350.00K0+952.67K0+952.67K0+952.67K0+000.00011120.07167.39731°06′11″K4002+872.50K1+120.0792424.618103756.365左28°44′23″270.98528.8034.320.00K1+120.07K1+120.07K1+120.07K0+000.00191263.68143.6132°21′48″K4003+946.51K1+263.6892568.109103762.287右61°49′35″101.00201.403.960.00K1+263.68K1+263.68K1+263.68K0+000.00411501.06237.38564°11′23″K3786+571.52K1+501.0692671.465103975.990右60°14′33″115.27230.530.660.00K1+501.06K1+501.06K1+501.06K0+000.00241638.47137.411124°25′55″K3787+388.53K1+638.4792593.769104089.326左31°42′44″280.47556.5820.090.00K1+638.47K1+638.47K1+638.47K0+000.004419456.13108.19592°43′11″K3788+398.54K19+456.1392588.635104197.399右16°33′44″367.34699.7966.520.00K19+456.13K19+456.13K19+456.13K0+000.000219608.55152.421109°16′55″K3789+092.55K19+608.5592538.303104341.270右12°48′15″273.31531.3337.210.00K19+608.55K19+608.55K19+608.55K0+000.004019743.37134.817122°05′10″K3790+958.56K19+743.3792466.689104455.494右45°19′44″364.73706.8853.150.00K19+743.37K19+743.37K19+743.37K0+000.009819847.20103.167167°24′54″K3793+672.57K19+847.2092366.001104477.973左21°09′38″460.01909.8441.970.00K19+847.20K19+847.20K19+847.20K0+000.006020012.23165.025146°15′15″K3796+067.58K20+012.2392228.781104569.646左10°59′60″578.231136.4866.000.00K20+012.23K20+012.23K20+012.23K0+000.008920124.25112.024135°15′15″K3797+271.59K20+124.2592149.217104648.507右14°47′02″468.17863.81109.970.00K20+124.25K20+124.25K20+124.25K0+000.002620232.35108.104150°02′17″K3801+302.60K20+232.3592055.560104702.497左11°51′11″1043.721977.46209.120.00K20+232.35K20+232.35K20+232.35K0+000.006220330.4598.096138°11′06″61K20+330.4591982.449104767.900右23°44′39″0.00K20+330.45K20+330.45K20+330.45K0+000.0020433.37102.917161°55′45″62K20+433.3791884.608104799.824左31°09′56″0.00K20+433.37K20+433.37K20+433.37K0+000.0020634.93201.558130°45′50″63K20+634.9391753.002104952.486右31°00′36″0K20+634.93K20+634.93K20+634.93K0+000.00202.09161°46′26″6491561.049105015.694編制：復核：