道路工程测量计算excel(功能齐全)

1、公 路 工 程 曲 线 要 素 计 算 表交点交点坐标转角缓和曲线长度编号桩号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终点竖曲线数据输入序号顶点桩号顶点

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挖填方数据输入计算内容（正算输 1，反算输 2，）1说明：1、凡是角度输入均用小数输入法，如：123度23分12.9秒输成123.23129 2、凡是桩号输入均直接输入，如：K20+560.234输成20560.2343、在进行开挖线或回填线计算时，先用

3、反算计算出桩号，再将该桩号填入正算的“待算桩号”中，再在上面“计算内容”中输入“1”进行正算，才是正确结果。 黄色单元格为计算结果显示区， 白色单元格为数据输入区。 坐 标 正 算 左边桩距中4左边桩夹角901.57079633待算桩号右边桩距中8右边桩夹角901.57079633左 边 桩中 桩右 边 桩XYXYXK20+820.0003615409.439500790.0143615405.454500790.3633615397.484 坐 标 反 算 待 算 坐 标估计里程反 算 结 果XYZ里程K+距中（左-右+）3615410.914500690.106340K20+925.000

4、K20+719.068-4.951二公共点坐标转换（大地坐标与施工坐标转换）点号转换前坐标（大地坐标）转换后坐标（施工坐标）XYZ（高程）XY基点3615414.145500895.001338.7020.0000.000附和点3615414.560500899.98410.0000.000点号待转换点坐标（大地坐标）计算输出（施工坐标）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本程序是本人花了大量的时间编成的，为了表示对劳动成果的尊重，请你付点小费，你不会介意吧！ 创作人：徐明忠 QQ ：337699117 邮箱： 开户行： 中国工商银行 卡号：6222022403005702661 开户

6、名：徐明忠 付费100元整 付完费请将你的邮箱地址发到我的邮箱中，我会在一天内将密码发到你的邮箱中。谢谢合作！ 欢迎你使用！请加我的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、与大大地地坐坐标标转转换换EXCELEXCEL表表格格EXCELEXCEL表表格格计计算算方方位位角角距距离离转换前原坐标方位角转换后坐标方位角 角度差值85.23921306085.23921306851421.17 000X03615414.1450.000YO500895.0010.000X13615414.56010.000M3615414.145Y1500899.9840.000N500895.001成成果果输输出出点号需转换R需转换V转换后X转换后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!密码线性超高横坡数据输入（绕中轴旋转）前超高缓和段起点桩号前超高缓和段长度后超高缓和段长度全超高段横坡%全超高长度起讫点的横坡%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中桩切线方位角设 计 高 程横 坡 %中桩左边桩右边桩左边桩 右边桩Y500791.059850015.7 338.164338.004338.484-4.004.00设计高程路面高程边坡开挖线超-，欠+超-，欠+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 坐 标 正 算 右 边 桩 坐 标 反 算 二公共点坐标转换（大地坐标与施工坐标转换）转换后坐标（施工坐标）计算输出（施工坐标）本程序是本人花了大量的时间编成的，为了表示对劳动成果的尊重，请你付点小费，你不会介意吧！ 创作人：徐明忠 QQ ：337699117 邮箱： 开户行： 中国工商银行 卡号：6222022403005702661 开户名：徐明忠 付费100元整 付完费请将你的邮箱地址发到我的邮箱中，我会在一天内将密码发到你的邮箱中。谢谢合作！ 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转换前原坐标方位角转换后坐标方位角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!三次抛物线超高横坡数据输入（绕中轴旋转）半幅路基加宽（渐变段）数据输入（不包含水沟，路肩）转向 （左-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公 路 工 程 曲 线 要 素 计 算 表线性超高横坡数据输入（绕中轴旋转）二级挖方边坡欢迎你使用！请加我的QQ：337699117，我还有大量的测量方面资料和软件，免费的哟！路基设计宽度左边桩右边桩 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半幅路基加宽（渐变段）数据输入（不包含水沟，路肩）一级填方边坡欢迎你使用！请加我的QQ：337

31、699117，我还有大量的测量方面资料和软件，免费的哟！zyTZTY5.7531346045.5831346045.7531346045.5831346045.7531346040.802#VALUE!计算参数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