excl表格形式綜合曲線坐標計算程序bata

1、Mail: Site: Time:2012-04-16 11:05說 明 附 屬 表一一、簡簡要要說說明明1、本程序可對單圓曲線、對稱緩和曲線、不對稱緩和曲線進行中、邊樁坐標計算。2、數(shù)據(jù)輸入時應在曲線要素表中有淺黃底色的單元格區(qū)內(nèi)輸入、其他均為自動計算。3、當線路az左轉(zhuǎn)時，轉(zhuǎn)角前面加負號；當線路ay右轉(zhuǎn)時，轉(zhuǎn)角為正值輸入。4、只需輸入坐標計算表的里程樁號、邊樁偏距即可自動計算坐標。5、計算邊樁時交角均為90。6、放樣計算表中可計算出前視方位角和距離，為現(xiàn)場放線人員減少了計算繁瑣。二二、使使用用注注明明本表需啟用宏方可運行，Office Excel 啟用宏方法如下：Office Excel

2、2003版：工具宏安全性選擇較低的安全級別重新打開文件即可運行。Office Excel 2007版：Office按鈕Excel選項信任中心信任中心設置宏設置啟用所有宏。若有疑問請致Email： Mail: Site: Time:2012-04-16 11:05編制:復核：日期：2022/1/9曲曲 線線 要要 素素 表表數(shù)據(jù)輸入數(shù)據(jù)參考曲線五大樁及坐標前交點X坐標4870208.1520參數(shù)名稱數(shù)據(jù)里程樁號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轉(zhuǎn)角角度（dms）az 19.401025194010.25YH06+338.5234870861.4822455590.0509緩和曲線Ls2150轉(zhuǎn)角角度-19.401第一切線方位角（dms）63.034410630344

4、.10HZ06+488.5234870967.1669455696.4141第一切線方位角63.034410Mail: Site: Time:2012-04-16 11:05計算：陳超復核：日期：2022/1/9綜合曲線坐標計算表單位名稱： 中鐵局集團有限公司遂渝鐵路線工程指揮部第項目經(jīng)理部工程名稱： 遂渝鐵路線第項目部工區(qū)里程樁號(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、表單位名稱：中鐵局集團有限公司遂渝鐵路線工程指揮部第項目經(jīng)理部工程名稱：遂渝鐵路線第項目部工區(qū)里里 程程測測 站站 點點照照 準準 點點水水平平距距（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