excel计算大全道桥公路坐标计算程序.xls

资源描述

excel计算大全道桥公路坐标计算程序.xls

《excel计算大全道桥公路坐标计算程序.xls》由会员分享，可在线阅读，更多相关《excel计算大全道桥公路坐标计算程序.xls（9页珍藏版）》请在冰点文库上搜索。

excel计算大全道桥公路坐标计算程序.xls

平曲线要素计算说明：

白色区域为输入区域交点号交点坐标交点桩号偏角（度分秒）曲线要素值（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.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交点号曲线控制桩号直线长度（m）及方向（度分秒）ZHHYQZYHHZ直线长交点间距方位角（度）备注11193.391193.391193.391193.391193.39249.391193.39329.523121442.781442.781442.781442.781442.78437.2603251.155213.6945931880.0403231960.123321999.9139481999.9142079.542142.7093593.190826.4914842222.2512732301.879272341.6698992341.672421.298109.4734346.407757.749552530.7712732610.399272650.4169962650.4172730.5893.81346.4077355.233563624.313624.313624.313624.313624.311387.73997.030726.4914775012.045012.045012.045012.045012.041258.681422.394352.936686270.726270.72#VALUE!

#VALUE!

1359.6141.88964说明：

桩号输入按正常输入即可，如“K10+234.56”、“K3+000”平曲线要素计算说明：

白色区域为输入区域交点号交点坐标交点桩号偏角（度分秒）曲线要素值（m）XY左（-）、右（+）RLh1Lh2A1A2q1q2LY2E190486.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.3932685.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!

1193.39329.52312#REF!

#REF!

251.155213.694593#REF!

#REF!

593.190826.491484#REF!

#REF!

346.407757.74955#REF!

#REF!

346.4077355.233563624.313624.313624.313624.313624.311387.73997.030726.4914775012.045012.045012.045012.045012.041258.681422.394352.936686270.726270.72#VALUE!

#VALUE!

1359.6141.88964说明：

桩号输入按正常输入即可，如“K10+234.56”、“K3+000”平曲线要素计算说明：

#VALUE!

1359.6141.88964说明：

桩号输入按正常输入即可，如“K10+234.56”、“K3+000”逐桩坐标计算说明：

白色区域为输入区域桩号中桩法线方位角左-右（度分秒）左边桩右边桩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

展开阅读全文