公路坐标计算程序-自动计算表格.xls

《公路坐标计算程序-自动计算表格.xls》由会员分享，可在线阅读，更多相关《公路坐标计算程序-自动计算表格.xls（9页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、平曲线要素计算说明：白色区域为输入区域交点号交点坐标交点桩号偏角(度分秒)曲线要素值(m)XY左(-)、右(+)RLh1Lh2A1A2q1q2LY2E190486.747663115.07791191525.186963703.15151193.39-15.49426410002191769.202163762.61161442.7812.47487910003192300.108364027.21312035.0431.15288930080.08379.628155.000154.55940.01839.7914192484.95964320.17812376.81-62.30577730

2、079.62879.628154.559154.55939.79139.7915192830.168764291.3932685.3331.15288630079.62880.083154.559155.00039.79140.0186193722.511964736.13313624.31-33.33176620007195134.11164561.22395012.0448.57110518008196146.248465469.03256270.72交点号曲线控制桩号直线长度(m)及方向(度分秒)ZHHYQZYHHZ直线长交点间距方位角(度)备注11193.391193.391193.3

3、91193.391193.39249.391193.39329.523121442.781442.781442.781442.781442.78 437.2603 251.1552 13.6945931880.0403231960.12332 1999.913948 1999.914 2079.542 142.7093 593.1908 26.4914842222.2512732301.87927 2341.6698992341.67 2421.298 109.4734 346.407757.749552530.7712732610.39927 2650.416996 2650.4172730

4、.5893.81346.4077 355.233563624.313624.313624.313624.313624.311387.73 997.0307 26.4914775012.045012.045012.045012.045012.041258.68 1422.394 352.936686270.726270.72#VALUE!#VALUE!#VALUE!1359.6141.88964说明：桩号输入按正常输入即可，如“K10+234.56”、“K3+000”平曲线要素计算说明：白色区域为输入区域交点号交点坐标交点桩号偏角(度分秒)曲线要素值(m)XY左(-)、右(+)RLh1Lh2A1

5、A2q1q2LY2E190486.747663115.07791191525.186963703.15151193.39-15.4942641000#REF!2191769.202163762.61161442.7812.4748791000#REF!3192300.108364027.21312035.0431.15288930080.08379.628#REF!154.55940.01839.7914192484.95964320.17812376.81-62.30577730079.62879.628#REF!154.55939.79139.7915192830.168764291.39

6、32685.3331.15288630079.62880.083#REF!155.00039.79140.0186193722.511964736.13313624.31-33.33176620007195134.11164561.22395012.0448.57110518008196146.248465469.03256270.72交点号曲线控制桩号直线长度(m)及方向(度分秒)ZHHYQZYHHZ直线长交点间距方位角(度)备注1#REF!#REF!#REF!#REF!#REF!#REF!1193.39329.52312#REF!#REF!#REF!#REF!#REF!#REF!251.1

7、552 13.694593#REF!#REF!#REF!#REF!#REF!#REF!593.1908 26.491484#REF!#REF!#REF!#REF!#REF!#REF!346.407757.74955#REF!#REF!#REF!#REF!#REF!#REF!346.4077 355.233563624.313624.313624.313624.313624.311387.73 997.0307 26.4914775012.045012.045012.045012.045012.041258.68 1422.394 352.936686270.726270.72#VALUE!#V

8、ALUE!#VALUE!1359.6141.88964说明：桩号输入按正常输入即可，如“K10+234.56”、“K3+000”平曲线要素计算说明：白色区域为输入区域交点号交点坐标交点桩号偏角(度分秒)曲线要素值(m)XY左(-)、右(+)RLh1Lh2A1A2q1q2LY2E190486.747663115.07791191525.186963703.15151193.39-15.49426410002191769.202163762.61161442.7812.47487910003192300.108364027.21312035.0431.15288930080.08379.62815

9、5.000154.55940.01839.7914192484.95964320.17812376.81-62.30577730079.62879.628154.559154.55939.79139.7915192830.168764291.3932685.3331.15288630079.62880.083154.559155.00039.79140.0186193722.511964736.13313624.31-33.33176620007195134.11164561.22395012.0448.57110518008196146.248465469.03256270.72交点号曲线控

10、制桩号直线长度(m)及方向(度分秒)ZHHYQZYHHZ直线长交点间距方位角(度)备注11193.391193.391193.391193.391193.39249.391193.39329.523121442.781442.781442.781442.781442.78 437.2603 251.1552 13.6945931880.0403231960.12332 1999.913948 1999.914 2079.542 142.7093 593.1908 26.4914842222.2512732301.87927 2341.6698992341.67 2421.298 109.473

11、4 346.407757.749552530.7712732610.39927 2650.416996 2650.4172730.5893.81346.4077 355.233563624.313624.313624.313624.313624.311387.73 997.0307 26.4914775012.045012.045012.045012.045012.041258.68 1422.394 352.936686270.726270.72#VALUE!#VALUE!#VALUE!1359.6141.88964说明：桩号输入按正常输入即可，如“K10+234.56”、“K3+000”逐

12、桩坐标计算说明：白色区域为输入区域桩号中桩法线方位角左-右(度分秒)左边桩右边桩XY距离(S)XLYLS说明：桩号输入按正常输入即可，如“K10+234.56”、“K3+000”XRYR说明：白色区域为输入区域右边桩桥梁及涵洞放样计算桩号中桩法线方位角左-右(度分秒)偏角(度分秒)左边桩XY距离(S)XLYL说明：桩号输入按正常输入即可，如“K10+234.56”、“K3+000”偏角为涵洞的水流方向与路线前进方向的右偏角说明：白色区域为输入区域右边桩SXRYR边桩放样(坡口线或坡脚线)测量数据假定中桩桩号对应中桩桩号左边桩XYZ距离(S)XLYL说明：桩号输入按正常输入即可，如“K10+234.56”、“K3+000”偏角为涵洞的水流方向与路线前进方向的右偏角说明：白色区域为输入区域右边桩SXRYR