excl表格形式综合曲线坐标计算程序bata

1、Mail: Site: Time:2012-04-16 11:05说 明 附 属 表一一、简简要要说说明明1、本程序可对单圆曲线、对称缓和曲线、不对称缓和曲线进行中、边桩坐标计算。2、数据输入时应在曲线要素表中有浅黄底色的单元格区内输入、其他均为自动计算。3、当线路az左转时，转角前面加负号；当线路ay右转时，转角为正值输入。4、只需输入坐标计算表的里程桩号、边桩偏距即可自动计算坐标。5、计算边桩时交角均为90。6、放样计算表中可计算出前视方位角和距离，为现场放线人员减少了计算繁琐。二二、使使用用注注明明本表需启用宏方可运行，Office Excel 启用宏方法如下：Office Excel

2、2003版：工具宏安全性选择较低的安全级别重新打开文件即可运行。Office Excel 2007版：Office按钮Excel选项信任中心信任中心设置宏设置启用所有宏。若有疑问请致Email： Mail: Site: Time:2012-04-16 11:05编制:复核：日期：2022/1/9曲曲 线线 要要 素素 表表数据输入数据参考曲线五大桩及坐标前交点X坐标4870208.1520参数名称数据里程桩号X坐标Y坐标前交点Y坐标454361.6540本交点X坐标4870811.7600曲线长L（m）424.6373ZH06+063.8864870714.8747455358.8300本交点

3、Y坐标455549.4900后交点X坐标4872102.0450第一切线长T1（m）213.8644YH06+213.8864870786.9445455490.3152后交点Y坐标456769.3420交点桩号JD6277.750第二切线长T2（m）213.8644QZ06+276.2044870822.2702455541.6353曲线半径R800缓和曲线Ls1150转角角度（dms）az 19.401025194010.25YH06+338.5234870861.4822455590.0509缓和曲线Ls2150转角角度-19.401第一切线方位角（dms）63.034410630344

4、.10HZ06+488.5234870967.1669455696.4141第一切线方位角63.034410Mail: Site: Time:2012-04-16 11:05计算：陈超复核：日期：2022/1/9综合曲线坐标计算表单位名称： 中铁局集团有限公司遂渝铁路线工程指挥部第项目经理部工程名称： 遂渝铁路线第项目部工区里程桩号(DK)中桩坐标（m）左边桩坐标（m）右边桩坐标（m）备注N(X)E(Y)偏距(m)N(X)E(Y)偏距(m)N(X)E(Y)06+063.9804870714.8770455358.384054870719.3749455356.649154870710.4600

5、455361.179306+083.9804870723.9879455376.7391104870732.8953455372.1939104870715.0806455381.284306+103.9804870733.1181455394.5335104870742.0025455389.9436104870724.2336455399.123306+123.9804870742.3669455412.2664104870751.2127455407.6026104870733.5211455416.930306+143.9804870751.7928455429.90585487075

6、6.1882455427.522354870747.3974455432.289206+163.9804870761.4533455447.4177104870770.1715455442.5194104870752.7351455452.316006+183.9804870771.4046455464.76594870771.4046455464.76594870771.4046455464.765906+203.9804870781.7010455481.91144870781.7010455481.91144870781.7010455481.911406+223.9804870792.

7、3939455498.81234870792.3939455498.81234870792.3939455498.812306+243.9804870803.5046455515.44164870803.5046455515.44164870803.5046455515.441606+263.9804870815.0275455531.78804870815.0275455531.78804870815.0275455531.788006+283.9804870826.9553455547.84114870826.9553455547.84114870826.9553455547.841106

8、+303.9804870839.2808455563.59124870839.2808455563.59124870839.2808455563.591206+323.9804870851.9961455579.02814870851.9961455579.02814870851.9961455579.028106+488.5304870967.1722455696.41904870967.1722455696.41904870967.1722455696.4190Mail: Site: Time:2012-04-16 11:05计算：陈超复核：日期：2022/1/9放放 样样 计计 算算 表

9、表单位名称：中铁局集团有限公司遂渝铁路线工程指挥部第项目经理部工程名称：遂渝铁路线第项目部工区里里 程程测测 站站 点点照照 准准 点点水水平平距距（m m）方方位位角角（）XYXY06+063.9804870711.77455349.494870611.76455249.49141.42842245949.706+083.9804870711.77455349.494870723.988455376.739129.8629655058.506+103.9804870711.77455349.494870733.118455394.533549.8463643830.006+123.9804870711.77455349.494870742.367455412.266469.8