竖曲线高程计算表格.xls

1、荆州区龙海路新建工程一期变坡点桩号变坡点高程竖曲线半径坡度起点桩号前坡后坡ZK0+353.7661014.249-1.200%353.766ZK0+483.0001012.69822000-1.200%5.000%421.0044635ZK0+890.0001033.048222005.000%-0.700%827.3782284ZK1+100.0001031.57823000-0.700%3.933%1030.503703ZK1+363.0001041.922522003.933%-3.000%1286.793923ZK1+700.0001031.81253500-3.000%1.700%1

2、617.786988ZK2+015.0001037.167580001.700%-0.300%1935.011557ZK2+360.0001036.13259000-0.300%-1.800%2292.500304ZK2+600.0001031.81255600-1.800%0.500%2535.61043ZK2+880.0001033.2125140000.500%1.409%2816.364795ZK3+100.0001036.312535001.409%-3.000%3022.848659ZK3+750.0001016.81252200-3.000%3.333%3680.364329ZK

3、4+200.0001031.812535003.333%-0.500%4132.954237ZK4+500.0001030.312510000-0.500%-2.000%4425.000937ZK4+900.0001022.31254000-2.000%2.091%4818.188361ZK5+500.0001034.860840002.091%-4.600%5366.201258ZK6+180.0001003.58085200-4.600%-2.200%6117.665915ZK6+355.000999.73083000-2.200%0.300%6317.510071ZK6+431.7429

4、99.9610.300%15.547%6431.74215.547%#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!#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!

5、#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!#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!荆州区龙海路

6、新建工程一期#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!#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!

7、#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!#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!#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!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!荆州区龙海路新建工程一期终点桩号控制桩号变坡桩号TE0超出K线范围353.7660#DIV/0!353.766353.766544.922645620.961129.234421.0054635483952.698463962.70.893475407827.37922848901169.44430669.4980.8049953

9、342101030.50470311001439.23070476.2651.3218977782631286.79492313631782.23811782.250.96643753371617.78798817002094.99964800.43151935.01255720152427.48906867.50.2531253452292.50130423602664.39919564.40.37032402535.6114326002943.62968363.6360.1446264462802816.36579528803177.12430277.1590.85050161222030

10、22.84965931003819.62832869.6671.1030661116503680.36532937504267.08216167.0830.6428755564504132.95523742004574.985004750.281253004425.00193745004981.81011181.8280.8369776984004818.18936149005633.686634133.8282.2387416986005366.20225855006242.38490562.40.37446806117.66691561806392.49883137.4990.234362

11、51756317.51107163556431.7420#DIV/0!76.7426431.7436431.742#DIV/0!#DIV/0!#DIV/0!-6431.742#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DI

12、V/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DI

13、V/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0荆州区龙海路新建工程一期#DIV/0!#DIV/0

14、!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0

15、!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0

16、!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0

17、!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0荆州区龙海路新建工程一期半径前坡后坡高程超出K线范围超出K线范围超出K线范围超出K线范围00.000%-1.200%1014.2492000-1.200%5.000%1012.69822005.000%-0.700%1033.0483000-0.700%3.933%1031.57822003.933%-3.000%1041.

18、9233500-3.000%1.700%1031.81380001.700%-0.300%1037.1689000-0.300%-1.800%1036.1335600-1.800%0.500%1031.813140000.500%1.409%1033.21335001.409%-3.000%1036.3132200-3.000%3.333%1016.81335003.333%-0.500%1031.81310000-0.500%-2.000%1030.3134000-2.000%2.091%1022.31340002.091%-4.600%1034.8615200-4.600%-2.200%1

19、003.5813000-2.200%0.300%999.73100.300%15.547%999.961015.547%#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!

20、#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.000荆州区龙海路新建

21、工程一期0#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0

22、.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0

23、.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!#DIV/0!0.0000#DIV/0!0.000%0.000荆州区龙海路新建工程一期变坡点桩号变坡点高程竖曲线半径坡度起点桩号前坡后坡K0+000.0001012.9701.000%0K0+250.0001015.47056001.000%-1.176%189.0660466K0+440.0001013.23515000-1.176%-0.359%378.7202396K0+835.0001011.81613500-0.359%0.550%773.6

24、303959K1+065.0001013.08145000.550%-2.270%1001.55096K1+290.0001007.9744000-2.270%0.900%1226.616328K1+535.0001010.179182000.900%1.560%1474.942432K1+790.0001014.15732001.560%-2.400%1726.647708K2+080.0001007.1973400-2.400%1.400%2015.418597K2+470.0001012.65750001.400%-1.280%2403.006565K2+868.0001007.5627

25、700-1.280%0.300%2807.174983K3+270.0001008.768160000.300%1.180%3199.600317K3+791.0001014.91635001.180%-2.382%3728.66634K4+306.5001002.6365486.149-2.382%0.400%4230.204645K4+464.0001003.26614760.5460.400%-0.700%4382.817649K4+830.0001000.7044200-0.700%2.280%4767.430533K5+055.0001005.83333502.280%-1.380%

26、4993.71792K5+700.000996.9324600-1.380%2.400%5613.068277K6+020.0001004.61231002.400%-2.050%5951.044856K6+260.000999.6925600-2.050%0.300%6194.213822K6+535.0001000.51730500.300%-3.944%6470.282291K6+760.000991.6444000-3.944%-0.742%6696.013741K7+040.000989.56612500-0.742%0.300%6974.878792K7+320.000990.40

27、6180000.300%-0.550%7243.500344K7+770.000987.93181000-0.550%-0.336%7683.37631K8+850.000984.30113000-0.336%0.750%8779.403399K9+220.000987.076450000.750%0.450%9152.501898K9+910.000990.18146000.450%3.200%9846.75064K10+385.0001005.38121003.200%-2.619%10323.93626K10+600.000999.7511800-2.619%4.350%10537.30

28、449K10+820.0001009.32122004.350%-1.238%10758.59107K11+110.0001005.7314900-1.238%-3.700%11049.68362K11+475.000992.2262300-3.700%4.178%11384.46495K12+035.0001015.62353004.178%1.850%11973.36078K12+230.0001019.231170001.850%2.610%12165.41105K12+506.0001026.43420002.610%-3.456%12445.36365K12+855.8501014.

29、3451600-3.456%4.000%12796.24058K13+340.0001033.71125004.000%-1.382%13272.77576K13+880.0001026.2472500-1.382%4.000%13812.72843K14+850.0001065.047120004.000%2.650%14769.06472K15+470.0001081.47760002.650%4.900%15402.52369K15+800.0001097.64765004.900%2.700%15728.58568K16+242.0001109.58155852.700%4.850%1

30、6181.98287K16+800.0001136.64480004.850%2.800%16718.09627K17+200.0001147.84460002.800%5.000%17134.02586荆州区龙海路新建工程一期K17+710.0001173.34463005.000%2.900%17643.93253K18+000.0001181.75460002.900%5.000%17937.02647K18+630.0001213.25463005.000%2.900%18563.93253K18+920.0001221.66460002.900%5.000%18857.02647K1

31、9+500.0001250.66460005.000%2.850%19435.58047K19+850.0001260.63957202.850%5.000%19788.53496K20+450.0001290.63947505.000%2.348%20387.0826K21+782.0001321.90818202.348%-4.300%21721.52466K22+180.0001304.7943800-4.300%-0.750%22112.61227K22+860.0001299.6943200-0.750%3.300%22795.20182K23+100.0001307.6142600

32、3.300%-2.740%23021.52272K23+740.0001290.0787300-2.740%-4.800%23664.83821K24+400.0001258.3985400-4.800%-1.625%24314.38557K24+950.0001249.4584600-1.625%-4.950%24873.5451K25+255.0001234.3606500-4.950%-2.900%25188.45647K25+620.0001223.7756800-2.900%-4.850%25553.72786K26+150.0001198.07012000-4.850%-2.800

33、%26027.14441K26+520.0001187.71012000-2.800%-4.000%26448.02821K27+020.0001167.7103600-4.000%0.600%26937.26616K28+000.0001173.59031000.600%4.850%27934.12619K28+430.0001194.44555004.850%2.600%28368.19764K28+760.0001203.02536002.600%-1.900%28679.02736K29+900.0001181.3655000-1.900%-4.900%29825.01353K30+290.0001162.2555200-4.900%-2.500%30227.67478K30+530.0001156.2558700-2.500%-3.900%30469.11902K31+100.0