道路设计-坐标放样Excel计算表
曲线道路坐标计算(Excel)
曲线道路坐标计算§1 曲线要素计算缓和曲线是在不改变直线段方向和保持圆曲线半径不变的条件下，插入到直线段和圆曲线之间的。
其曲率半径ρ从直线的曲率半径∞（无穷大）逐渐变化到圆曲线的半径R ，在缓和曲线上任意一点的曲率半径ρ与缓和曲线的长度l 成反比，以公式表示为：l1∝ρ 或 C l =⋅ρ（C 为常数，称曲线半径变更率）。
当o l l =时，R =ρ，应有o l R l C ⋅=⋅=ρ以上几式是缓和曲线必要的前提条件。
在实际应用中，可采取符合这一前提条件的曲线作为缓和曲线。
常用的有辐射螺旋线及三次抛物线，我国采用辐射螺旋线。
为了在圆曲线与直线之间加入一段缓和曲线o l ，原来的圆曲线需要在垂直于其切线的方向移动一段距离p ，因而圆心就由'O 移到O ，而原来的半径R 保持不变，如图。
由图中可看出，缓和曲线约有一半的长度是靠近原来的直线部分，而另一半是靠近原来的圆曲线部分，原来圆曲线的两端其圆心角o β相对应的那部分圆弧，现在由缓和曲线所代替，因而圆曲线只剩下缓圆点(HY )到圆缓点(YH )这段长度即y l 。
o β为缓和曲线的切线角，即缓圆点或圆缓点切线与直缓点或缓直点切线的交角，亦即圆曲线HY→YH 两端各延长2ol 部分所对应的圆心角。
γ为缓和曲线总偏角，即从直缓点(ZH )测设缓圆点(HY )或从缓直点(HZ )测设圆缓点(YH )的偏角。
q 为切线增量(切垂距)，即ZH (或HZ )到从圆心O 向ZH (或HZ )的切线作垂线垂足的距离。
p 为圆曲线内移值，即垂线(从圆心O 向ZH (或HZ )的切线作垂线)长与圆曲线半径R 之差。
§1.1 不等长缓和曲线要素计算：在铁路曲线测设中，线路曲线一般是由相等的两条缓和曲线中间加一个圆曲线构成，有时还会出现由两个不等长的缓和曲线中间加一个圆曲线构成的特殊情况，如图：缓和曲线长分别为1o l 、2o l ， 切线长分别为1T 、2T ，曲线偏角(线路转角)为α，圆曲线半径为R ，圆曲线长为y l ，曲线长为L ，外矢距为E ，切曲差为J ，(缓和曲线后)圆曲线内移值分别为1p 、2p ，(缓和曲线)切线增量分别为1q 、2q ，缓和曲线偏角分别为1o β、2o β ， 回旋线参数分别为121o Rl A =、222o Rl A =各曲线要素计算公式如下：231112402R ll q o o -=232222402Rll q o o -=341211268824R lR l p o o -=342222268824RlR l p o o -=ααsin )(2)(12111p p tgp R q T -+++=ααsin )(2)(21222p p tgp R q T -+++=Rl R l o o o ππβ111901802=⋅=Rl R l o o o ππβ222901802=⋅=︒--++=180)(2121Rl l L o o o o πββα从以上公式可以看出，当21o o l l =时，就是等长(对称)缓和曲线的情况。
道路放样坐标计算
全站仪道路放样、方位角及左右偏移坐标计算（直线、缓与曲线<南方NTS-362R6L>）一、根据直线、曲线要素表列1：JD5—x=4340430、518 JD6—x=4339782、179y=441418、4621 y=441651、8123方位角计算=POl（4339782、179-4340430、518，441651、8123-441418、4621 r=689、0543Θ=160、2051794 转160°12″18、65′∴JD5—JD6直线段长689、0543m,方位角=160°12″18、65′，已知JD5半径=1500，曲线长度248、7908;(JD5桩号K3+328、548，JD6桩号K4+017、030）利用全站仪进行道路放样：选择程序——道路——水平定线——（新建水平定线文件）——起始点（输入桩号3328、548，坐标JD5）——水平定线（1、直线-方位角160°12′19″ 2、圆弧—半径1500，弧长497、58 3、缓与曲线-半径1500，弧长497、58）——道路放样——选择文件（水平定线）——设置放样点（依次输入起始桩号-桩间距-左偏差-右偏差）——放样《DHR角度值，HD 水平距离》（编辑可以桩号可放样任意一点坐标，编辑偏差左右偏移“左负右正”）见附图二、道路坐标计算(列1）JD5——JD6坐标计算{x+Cos(方位角)*距离} {y+Sin(方位角)*距离JD6X=4340430、518+Cos（160、2052）*689、0543=4339782、179JD6Y=441418、4621+Sin(160、2052)*689、0543=441651、8121三、坐标距离计算2（列1）JD5—JD6其之间得距离计算【根号下{（JD6Y-JD5Y）²+（JD6X-JD5X）²}】如下：（441651、8123-441418、4621）+（4339782、179 -4340430、518 ）=233、3502 =-648、339=（233、3502²+648、339²）=689、0543m四、坐标左右偏移计算（列1）公式=x+Cos（角度+-90°）*距离 y+Sin（角度+-90°）*距离JD5-JD6之间K3+700—x=4340081、014Y=441544、255右偏13、5坐标X=4340081、014+cos（160°12″18、65′+90°）*13、5=4340076、445Y=441544、255+sin（160°12″18、65′+90°）*13、5=441531、553左偏8、15m坐标X=4340081、014+cos（160°12″18、65′-90°）*8、15=4340083、774Y=441544、255+sin（160°12″18、65′-90°）*8、15=441551、923（左负右正）五、假设坐标假设A1x=1000 y=1000 z=1000 自由定点假如A1-A2实际尺量为4、525m，则A2坐标为X=1000， Y=1004、525六、钢管重量计算列：无缝钢管DN100，壁厚4mm，外径￠108（计算公式=外径—壁厚）*壁厚*系数∴dn100无缝钢管每米重量=（108-4）*4*0、02466=10、26kg七、钢板重量计算（计算公式=厚度*宽度*长度*系数）列：钢板厚20mm，宽2000mm，长10000mm则重量等于：0、02*2*10*7、85=3、14t本文档仅限于各位同行交流与学习，如有不足之处还望与各位互相探讨、交流、、、微信、qq号：583159136 雷2017年8月28日附图。
EXCEL电子表格在公路测量施工中的应用——海滨大道路基、桥梁中桩坐标计算及放样
为ｉ 点
求 出 ｉ 的路 线 坐 标 后 ，根 据 ｏ 在 线 路 坐 标 系 中 的 方 点 轴 位角 Ｔ 和 Ｚ 。 Ｙ点 的坐 标 对 、ｙ进 行 平 移 、旋 转 ， 即 ： ）ｉＸ ＋ ｉ ｏ Ｔ ＋ｙ ×ｓｎ ０ （ 转取 上 面 符号 ） ； （ 。 ｘ Ｘｃ ｓ ｏ ｉ ｉＴ 右 ＝ Ｙ＝ ｏｘ ｉＴ ±ｙ ×ｃ ｓ ０ （ 转 取 下 面符 号 ） 。 ｉＹ ＋ ｉ ｓｎ ｏ Ｘ ｉ ｏｔ 左
徐 刚 ， 王 继 刚
（ 中交 一航 局 第 一 工 程 有 限 公 司 ， 天 津 ３ ０ ５ ０ ４ ６）
摘
要：以海滨大道路基 、桥梁施工为范例 ，通过计算机的应用简化施 工放样计 算的方法 。
文献 标 识 码 ：Ａ 文章 编 号 ： １０ — ９ ３ （ ０ ２ ４ ０ ２— ２ ０ ６ ７ ７ ２ １ ）０ — ２ ３ ０ 方 法 二 ：用 积 分 坐 标 方 程直 接 求 圆 曲线 上 任 意 ｉ点 的 线 路坐标 ，即：
ｘ＝ｉ １／ Ｒ ）＋ （ １ ０ ｉｌ ｉ ６ 。 一（３ １ ／ Ｒ ）； ｉ ２
Ｙ＝ （２ ２ ｉ １／ Ｒ）一 （ ２ Ｒ ） ＋ （ｉ ７ ０ ５ ； ｉ １／ ４ ３ ｉ １／ ２ Ｒ ） ６
坐标 系下 的坐标 ，转换公式与 圆曲线类 同。
缓 和 曲线 上任 意 一 点 ｉ 的切 线 方 位 角 可 用 下 式 求 得 ： Ｔ＝ ０ （ ／ ＲＬ ） × （ ８ ） ， ｉＴ ＋ １ ２ ｏ ２ １ Ｏ／
式中：， ＿ 特定坐标系 ｘ轴 的方 位角。 ｒ＿ ０一
同 上 ，可 根 据 Ｔ 求 得 任 意 一 点 ｉ的法 线 方 向上 的 距 离 点 ｉ 的坐 标 。
道路坐标计算表(有公式)
逐 桩 坐 标 表ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离8525.8823590080.3521849.9370.000173.78-909083.8263.780 3.033 1.46 4.60412 8525.8823590080.3521849.93714.120.324173.78-909083.8263.780.0056 3.033 1.46 4.60412 8525.8823590080.3521849.93734.120.782173.78-909083.8263.780.0136 3.033 1.46 4.60412 8525.8823590080.3521849.93754.12 1.24173.78-909083.8263.780.0216 3.033 1.46 4.60412 8525.8823590080.3521849.93774.12 1.699173.78-909083.8263.780.0296 3.033 1.46 4.60412 8525.8823590080.3521849.93794.12 2.157173.78-909083.8263.780.0376 3.033 1.46 4.60412 8525.8823590080.3521849.937114.12 2.615173.78-909083.8263.780.0456 3.033 1.46 4.60412 8525.8823590080.3521849.937134.12 3.074173.78-909083.8263.780.0536 3.033 1.46 4.60412 8525.8823590080.3521849.937154.12 3.532173.78-909083.8263.780.0616 3.033 1.46 4.60412 8525.8823590080.3521849.937174.12 3.99173.78-909083.8263.780.0696 3.033 1.46 4.60412 8525.8823590080.3521849.937194.12 4.449173.78-909083.8263.780.0776 3.033 1.46 4.60412 8525.8823590080.3521849.937214.12 4.907173.78-909083.8263.780.0856 3.033 1.46 4.60412 8525.8823590080.3521849.937234.12 5.366173.78-909083.8263.780.0936 3.033 1.46 4.60412 8525.8823590080.3521849.937254.12 5.824173.78-909083.8263.780.1016 3.033 1.46 4.60412 8525.8823590080.3521849.937274.12 6.282173.78-909083.8263.780.1096 3.033 1.46 4.60412 8525.8823590080.3521849.937294.12 6.741173.78-909083.8263.780.1176 3.033 1.46 4.60412 8525.8823590080.3521849.937314.127.199173.78-909083.8263.780.1256 3.033 1.46 4.60412 8525.8823590080.3521849.937334.127.657173.78-909083.8263.780.1336 3.033 1.46 4.60412 8525.8823590080.3521849.937354.128.116173.78-909083.8263.780.1416 3.033 1.46 4.60412 8525.8823590080.3521849.937374.128.574173.78-909083.8263.780.1496 3.033 1.46 4.6047.995 8525.8823590080.3521849.937394.129.033173.78-909083.8263.780.1576 3.033 1.46 4.6047.995 8525.8823590080.3521849.937414.129.491173.78-909083.8263.780.1656 3.033 1.46 4.6047.995 8525.8823590080.3521849.937434.129.949173.78-909083.8263.780.1736 3.033 1.46 4.6047.995 8525.8823590080.3521849.937454.1210.41173.78-909083.8263.780.1816 3.033 1.46 4.6047.995 8525.8823590080.3521849.937474.1210.87173.78-909083.8263.780.1896 3.033 1.46 4.6047.995ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离8525.8823590080.3521849.937494.1211.32173.78-909083.8263.780.1976 3.033 1.46 4.6047.995 8525.8823590080.3521849.937514.1211.78173.78-909083.8263.780.2056 3.033 1.46 4.6047.995 8525.8823590080.3521849.937534.1212.24173.78-909083.8263.780.2136 3.033 1.46 4.6047.995 8525.8823590080.3521849.937554.1212.7173.78-909083.8263.780.2216 3.033 1.46 4.6047.995 8525.8823590080.3521849.937574.1213.16173.78-909083.8263.780.2296 3.033 1.46 4.6047.995 8525.8823590080.3521849.937594.1213.62173.78-909083.8263.780.2376 3.033 1.46 4.6047.995 8525.8823590080.3521849.937614.1214.07173.78-909083.8263.780.2456 3.033 1.46 4.6047.995 8525.8823590080.3521849.937634.1214.53173.78-909083.8263.780.2536 3.033 1.46 4.6047.995 8525.8823590080.3521849.937654.1214.99173.78-909083.8263.780.2616 3.033 1.46 4.6047.995 8525.8823590080.3521849.937674.1215.45173.78-909083.8263.780.2696 3.033 1.46 4.6047.995 8525.8823590080.3521849.937694.1215.91173.78-909083.8263.780.2776 3.033 1.46 4.6047.995 8525.8823590080.3521849.937714.1216.37173.78-909083.8263.780.2856 3.033 1.46 4.6047.995 8525.8823590080.3521849.937734.1216.82173.78-909083.8263.780.2936 3.033 1.46 4.6047.995 8525.8823590080.3521849.937754.1217.28173.78-909083.8263.780.3016 3.033 1.46 4.6047.995 8525.8823590080.3521849.937774.1217.74173.78-909083.8263.780.3096 3.033 1.46 4.6047.995 8525.8823590080.3521849.937775.4817.77173.78-909083.8263.780.3102 3.033 1.46 4.6047.995 ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离9301.3663589309.378521933.927300018.6340.356173.781-909084.1264.140.0062 3.033 1.47 4.617.995 9301.3663589309.378521933.927300038.6340.738173.781-909084.5264.520.0129 3.033 1.48 4.6177.995 9301.3663589309.378521933.927300058.634 1.12173.781-909084.9264.90.0195 3.033 1.48 4.6237.995 9301.3663589309.378521933.927300078.634 1.502173.781-909085.3265.280.0262 3.033 1.49 4.637.995 9301.3663589309.378521933.927300098.634 1.884173.781-909085.7265.670.0329 3.033 1.5 4.6377.995 9301.3663589309.378521933.9273000118.634 2.266173.781-909086266.050.0395 3.033 1.5 4.6437.995 9301.3663589309.378521933.9273000138.634 2.648173.781-909086.4266.430.0462 3.033 1.51 4.657.995 9301.3663589309.378521933.9273000158.634 3.03173.781-909086.8266.810.0529 3.033 1.52 4.6577.995ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离9301.3663589309.378521933.9273000178.634 3.412173.781-909087.2267.190.0595 3.033 1.52 4.6637.995 9301.3663589309.378521933.9273000198.634 3.794173.781-909087.6267.580.0662 3.033 1.53 4.677.995 9301.3663589309.378521933.9273000218.634 4.176173.781-909088267.960.0729 3.033 1.54 4.6777.995 9301.3663589309.378521933.9273000238.634 4.558173.781-909088.3268.340.0795 3.033 1.54 4.6837.995 9301.3663589309.378521933.9273000258.634 4.94173.781-909088.7268.720.0862 3.033 1.55 4.697.995 9301.3663589309.378521933.9273000278.634 5.322173.781-909089.1269.10.0929 3.033 1.56 4.6977.995 9301.3663589309.378521933.9273000298.634 5.703173.781-909089.5269.490.0995 3.033 1.56 4.7037.995 9301.3663589309.378521933.9273000318.634 6.085173.781-909089.9269.870.1062 3.033 1.57 4.717.995 9301.3663589309.378521933.9273000338.634 6.467173.781-909090.2270.250.1129 3.033 1.58 4.7177.995 9301.3663589309.378521933.9273000353.727 6.756173.781-909090.5270.540.1179 3.033 1.58 4.7227.995 9655.0933588956.29521951.441 4.910.112180.54-909090.5270.540.002 3.151 1.58 4.7227.995 9655.0933588956.29521951.44124.910.571180.54-909090.5270.540.01 3.151 1.58 4.7227.995 9655.0933588956.29521951.44144.91 1.029180.54-909090.5270.540.018 3.151 1.58 4.7227.995 9655.0933588956.29521951.44164.91 1.488180.54-909090.5270.540.026 3.151 1.58 4.7227.995 9655.0933588956.29521951.44184.91 1.946180.54-909090.5270.540.034 3.151 1.58 4.7227.995 9655.0933588956.29521951.441104.91 2.404180.54-909090.5270.540.042 3.151 1.58 4.7227.995 9655.0933588956.29521951.441124.91 2.863180.54-909090.5270.540.05 3.151 1.58 4.7227.995 9655.0933588956.29521951.441144.91 3.321180.54-909090.5270.540.058 3.151 1.58 4.7227.995 9655.0933588956.29521951.441164.91 3.779180.54-909090.5270.540.066 3.151 1.58 4.7227.995 9655.0933588956.29521951.441171.51 3.931180.54-909090.5270.540.0686 3.151 1.58 4.7227.995 9826.6083588784.782521949.831150013.392-0.02180.54-1-909090.5270.56201.67-0.01 1.58 4.7227.995 9826.6083588784.782521949.831150033.392-0.11180.54-1-909090.4270.64201.67-0.04 1.58 4.7247.995 9826.6083588784.782521949.831150053.392-0.27180.54-1-909090.3270.81201.67-0.09 1.58 4.7267.995 9826.6083588784.782521949.831150073.392-0.51180.54-1-909090271.05201.67-0.17 1.57 4.7317.995 9826.6083588784.782521949.831150093.392-0.83180.54-1-909089.7271.36201.67-0.28 1.57 4.7367.995 9826.6083588784.782521949.8311500113.392-1.22180.54-1-909089.3271.76201.67-0.41 1.56 4.7437.995 9826.6083588784.782521949.8311500133.392-1.69180.54-1-909088.9272.22201.67-0.56 1.55 4.7517.995ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离9826.6083588784.782521949.8311500153.392-2.23180.54-1-909088.3272.77201.67-0.74 1.54 4.7617.995 9826.6083588784.782521949.8311500173.392-2.85180.54-1-909087.7273.39201.67-0.95 1.53 4.7717.995 9826.6083588784.782521949.8311500193.392-3.54180.54-1-909087274.08201.67-1.18 1.52 4.7847.995 9826.6083588784.782521949.8311500201.667-3.85180.54-1-909086.7274.39201.67-1.28 1.51 4.7897.995 ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离10028.2753588583.173521952.455150011.7250.448176.69-1-909086.2266.240.0078 3.084 1.51 4.6477.995 10028.2753588583.173521952.455150031.725 1.212176.69-1-909085.5265.470.0212 3.084 1.49 4.6337.995 10028.2753588583.173521952.455150051.725 1.976176.69-1-909084.7264.710.0345 3.084 1.48 4.627.995 10028.2753588583.173521952.455150071.725 2.74176.69-1-909083.9263.950.0478 3.084 1.47 4.6077.995 10028.2753588583.173521952.455150091.725 3.504176.69-1-909083.2263.180.0612 3.084 1.45 4.5937.995 10028.2753588583.173521952.4551500111.725 4.268176.69-1-909082.4262.420.0745 3.084 1.44 4.587.995 10028.2753588583.173521952.4551500131.725 5.032176.69-1-909081.7261.650.0878 3.084 1.43 4.5677.995 10028.2753588583.173521952.4551500151.725 5.795176.69-1-909080.9260.890.1012 3.084 1.41 4.5537.995 10028.2753588583.173521952.4551500171.725 6.559176.69-1-909080.1260.130.1145 3.084 1.4 4.547.995 10028.2753588583.173521952.4551500191.7257.323176.69-1-909079.4259.360.1278 3.084 1.39 4.5277.995 10028.2753588583.173521952.4551500211.7258.087176.69-1-909078.6258.60.1412 3.084 1.37 4.5137.995 10028.2753588583.173521952.4551500231.7258.851176.69-1-909077.8257.840.1545 3.084 1.36 4.57.995 10028.2753588583.173521952.4551500251.7259.615176.69-1-909077.1257.070.1678 3.084 1.35 4.4877.995 10028.2753588583.173521952.4551500269.1610.28176.69-1-909076.4256.410.1794 3.084 1.33 4.4757.995 9301.3663589309.378521933.9273000998.63419.07173.781-9090103282.850.3329 3.033 1.8 4.9377.995 9301.3663589309.378521933.92730001018.63419.45173.781-9090103283.240.3395 3.033 1.8 4.9437.995 9301.3663589309.378521933.92730001038.63419.84173.781-9090104283.620.3462 3.033 1.81 4.957.9959301.3663589309.378521933.9271098.63420.98173.78-909083.8263.780.3662 3.033 1.46 4.6047.995 9301.3663589309.378521933.9271118.63421.36173.78-909083.8263.780.3729 3.033 1.46 4.6047.995 9301.3663589309.378521933.9271138.63421.75173.78-909083.8263.780.3795 3.033 1.46 4.6047.995 9301.3663589309.378521933.9271158.63422.13173.78-909083.8263.780.3862 3.033 1.46 4.6047.995ZY点或YZ点RL E N 左右偏左侧右侧F F弧度E 弧度N 弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离ZY点或YZ点坐标9301.3663589309.378521933.9271178.63422.51173.78-909083.8263.780.3929 3.033 1.46 4.6047.9959301.3663589309.378521933.9271197.73622.88173.78-909083.8263.780.3992 3.033 1.46 4.6047.995ZY点或YZ点R LEN左右偏左侧右侧FF弧度E 弧度N 弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离10499.1023588123.637522048.0980.900.021162.55-909072.6252.550.0004 2.837 1.27 4.4087.99510499.1023588123.637522048.09820.900.479162.55-909072.6252.550.0084 2.837 1.27 4.4087.99510499.1023588123.637522048.09840.900.937162.55-909072.6252.550.0164 2.837 1.27 4.4087.99510499.1023588123.637522048.09860.90 1.396162.55-909072.6252.550.0244 2.837 1.27 4.4087.99510499.1023588123.637522048.09880.90 1.854162.55-909072.6252.550.0324 2.837 1.27 4.4087.99510499.1023588123.637522048.098100.90 2.312162.55-909072.6252.550.0404 2.837 1.27 4.4087.99510499.1023588123.637522048.098120.90 2.771162.55-909072.6252.550.0484 2.837 1.27 4.4087.99510499.1023588123.637522048.098140.90 3.229162.55-909072.6252.550.0564 2.837 1.27 4.4087.99510499.1023588123.637522048.098160.90 3.688162.55-909072.6252.550.0644 2.837 1.27 4.4087.99510499.1023588123.637522048.098180.90 4.146162.55-909072.6252.550.0724 2.837 1.27 4.4087.99510499.1023588123.637522048.098200.90 4.604162.55-909072.6252.550.0804 2.837 1.27 4.4087.99510499.1023588123.637522048.098220.90 5.063162.55-909072.6252.550.0884 2.837 1.27 4.4087.99510499.1023588123.637522048.098240.90 5.521162.55-909072.6252.550.0964 2.837 1.27 4.4087.99510499.1023588123.637522048.098260.90 5.979162.55-909072.6252.550.1044 2.837 1.27 4.4087.99510499.1023588123.637522048.098280.90 6.438162.55-909072.6252.550.1124 2.837 1.27 4.4087.99510499.1023588123.637522048.098300.90 6.896162.55-909072.6252.550.1204 2.837 1.27 4.4087.99510499.1023588123.637522048.098320.907.354162.55-909072.6252.550.1284 2.837 1.27 4.4087.99510499.1023588123.637522048.098340.907.813162.55-909072.6252.550.1364 2.837 1.27 4.4087.99510499.1023588123.637522048.098360.908.271162.55-909072.6252.550.1444 2.837 1.27 4.4087.99510499.1023588123.637522048.098380.908.73162.55-909072.6252.550.1524 2.837 1.27 4.4087.99510499.1023588123.637522048.098387.998.892162.55-909072.6252.550.1552 2.837 1.27 4.4087.995ZY点或YZ点RLEN左右偏左侧右侧FF弧度E 弧度N 弧度F 弧度F SZY点或YZ点坐标ZY点或YZ点坐标ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离10887.0963587753.491522164.423270012.9040.274162.551-909072.8252.830.0048 2.837 1.27 4.4137.995 10887.0963587753.491522164.423270032.9040.698162.551-909073.3253.250.0122 2.837 1.28 4.427.995 10887.0963587753.491522164.423270052.904 1.123162.551-909073.7253.680.0196 2.837 1.29 4.4277.995 10887.0963587753.491522164.423270072.904 1.547162.551-909074.1254.10.027 2.837 1.29 4.4357.995 10887.0963587753.491522164.423270092.904 1.971162.551-909074.5254.530.0344 2.837 1.3 4.4427.995 10887.0963587753.491522164.4232700112.904 2.396162.551-909074.9254.950.0418 2.837 1.31 4.457.995 10887.0963587753.491522164.4232700132.904 2.82162.551-909075.4255.370.0492 2.837 1.32 4.4577.995 10887.0963587753.491522164.4232700152.904 3.245162.551-909075.8255.80.0566 2.837 1.32 4.4657.995 10887.0963587753.491522164.4232700172.904 3.669162.551-909076.2256.220.064 2.837 1.33 4.4727.995 10887.0963587753.491522164.4232700192.904 4.094162.551-909076.6256.650.0714 2.837 1.34 4.4797.995 10887.0963587753.491522164.4232700212.904 4.518162.551-909077.1257.070.0789 2.837 1.35 4.4877.995 10887.0963587753.491522164.4232700232.904 4.942162.551-909077.5257.50.0863 2.837 1.35 4.4947.995 10887.0963587753.491522164.4232700252.904 5.367162.551-909077.9257.920.0937 2.837 1.36 4.5027.995 10887.0963587753.491522164.4232700272.904 5.791162.551-909078.3258.350.1011 2.837 1.37 4.5097.995 10887.0963587753.491522164.4232700292.904 6.216162.551-909078.8258.770.1085 2.837 1.37 4.5167.995 10887.0963587753.491522164.4232700312.904 6.64162.551-909079.2259.190.1159 2.837 1.38 4.5247.995 10887.0963587753.491522164.4232700332.9047.064162.551-909079.6259.620.1233 2.837 1.39 4.5317.995 10887.0963587753.491522164.4232700352.9047.489162.551-909080260.040.1307 2.837 1.4 4.5397.995 10887.0963587753.491522164.4232700372.9047.913162.551-909080.5260.470.1381 2.837 1.4 4.5467.995 10887.0963587753.491522164.4232700392.9048.338162.551-909080.9260.890.1455 2.837 1.41 4.5537.995 10887.0963587753.491522164.4232700412.9048.762162.551-909081.3261.320.1529 2.837 1.42 4.5617.995 10887.0963587753.491522164.4232700432.9049.187162.551-909081.7261.740.1603 2.837 1.43 4.5687.995 10887.0963587753.491522164.4232700452.9049.611162.551-909082.2262.160.1677 2.837 1.43 4.5767.995 10887.0963587753.491522164.4232700470.4139.982162.551-909082.5262.540.1742 2.837 1.44 4.5827.995 ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离11357.5093587294.73522265.75 2.490.057172.54-909082.5262.540.001 3.011 1.44 4.5827.995ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离11357.5093587294.73522265.7522.490.515172.54-909082.5262.540.009 3.011 1.44 4.5827.995 11357.5093587294.73522265.7542.490.974172.54-909082.5262.540.017 3.011 1.44 4.5827.995 11357.5093587294.73522265.7562.49 1.432172.54-909082.5262.540.025 3.011 1.44 4.5827.995 11357.5093587294.73522265.7582.49 1.891172.54-909082.5262.540.033 3.011 1.44 4.5827.995 11357.5093587294.73522265.75102.49 2.349172.54-909082.5262.540.041 3.011 1.44 4.5827.995 11357.5093587294.73522265.75122.49 2.807172.54-909082.5262.540.049 3.011 1.44 4.5827.995 11357.5093587294.73522265.75142.49 3.266172.54-909082.5262.540.057 3.011 1.44 4.5827.995 11357.5093587294.73522265.75162.49 3.724172.54-909082.5262.540.065 3.011 1.44 4.5827.995 11357.5093587294.73522265.75182.49 4.182172.54-909082.5262.540.073 3.011 1.44 4.5827.995 11357.5093587294.73522265.75202.49 4.641172.54-909082.5262.540.081 3.011 1.44 4.5827.995 11357.5093587294.73522265.75222.49 5.099172.54-909082.5262.540.089 3.011 1.44 4.5827.995 11357.5093587294.73522265.75242.49 5.557172.54-909082.5262.540.097 3.011 1.44 4.5827.995 11357.5093587294.73522265.75262.49 6.016172.54-909082.5262.540.105 3.011 1.44 4.5827.995 11357.5093587294.73522265.75282.49 6.474172.54-909082.5262.540.113 3.011 1.44 4.5827.995 11357.5093587294.73522265.75302.49 6.933172.54-909082.5262.540.121 3.011 1.44 4.5827.995 11357.5093587294.73522265.75322.497.391172.54-909082.5262.540.129 3.011 1.44 4.5827.995 11357.5093587294.73522265.75342.497.849172.54-909082.5262.540.137 3.011 1.44 4.5827.995 11357.5093587294.73522265.75362.498.308172.54-909082.5262.540.145 3.011 1.44 4.5827.995 11357.5093587294.73522265.75382.498.766172.54-909082.5262.540.153 3.011 1.44 4.5827.995 11357.5093587294.73522265.75402.499.224172.54-909082.5262.540.161 3.011 1.44 4.5827.995 11357.5093587294.73522265.75422.499.683172.54-909082.5262.540.169 3.011 1.44 4.5827.995 11357.5093587294.73522265.75442.4910.14172.54-909082.5262.540.177 3.011 1.44 4.5827.995 11357.5093587294.73522265.75462.4910.6172.54-909082.5262.540.185 3.011 1.44 4.5827.995 11357.5093587294.73522265.75482.4911.06172.54-909082.5262.540.193 3.011 1.44 4.5827.995 11357.5093587294.73522265.75502.4911.52172.54-909082.5262.540.201 3.011 1.44 4.5827.995ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离11357.5093587294.73522265.75522.4911.97172.54-909082.5262.540.209 3.011 1.44 4.5827.995 11357.5093587294.73522265.75542.4912.43172.54-909082.5262.540.217 3.011 1.44 4.5827.995 11357.5093587294.73522265.75562.4912.89172.54-909082.5262.540.225 3.011 1.44 4.5827.995 11357.5093587294.73522265.75582.4913.35172.54-909082.5262.540.233 3.011 1.44 4.5827.995 11357.5093587294.73522265.75602.4913.81172.54-909082.5262.540.241 3.011 1.44 4.5827.995 11357.5093587294.73522265.75609.0113.96172.54-909082.5262.540.2436 3.011 1.44 4.5827.995 11966.5183586690.881522344.859260013.4820.297172.541-909082.8262.830.0052 3.011 1.45 4.5877.995 11966.5183586690.881522344.859260033.4820.738172.541-909083.3263.270.0129 3.011 1.45 4.5957.995 11966.5183586690.881522344.859260053.482 1.179172.541-909083.7263.710.0206 3.011 1.46 4.6037.995 11966.5183586690.881522344.859260073.482 1.619172.541-909084.2264.160.0283 3.011 1.47 4.617.995 11966.5183586690.881522344.859260093.482 2.06172.541-909084.6264.60.036 3.011 1.48 4.6187.995 11966.5183586690.881522344.8592600113.482 2.501172.541-909085265.040.0436 3.011 1.48 4.6267.995 11966.5183586690.881522344.8592600133.482 2.942172.541-909085.5265.480.0513 3.011 1.49 4.6337.995 11966.5183586690.881522344.8592600153.482 3.382172.541-909085.9265.920.059 3.011 1.5 4.6417.995 11966.5183586690.881522344.8592600173.482 3.823172.541-909086.4266.360.0667 3.011 1.51 4.6497.995 11966.5183586690.881522344.8592600193.482 4.264172.541-909086.8266.80.0744 3.011 1.51 4.6577.995 11966.5183586690.881522344.8592600213.482 4.704172.541-909087.2267.240.0821 3.011 1.52 4.6647.995 11966.5183586690.881522344.8592600233.482 5.145172.541-909087.7267.680.0898 3.011 1.53 4.6727.995 11966.5183586690.881522344.8592600253.482 5.586172.541-909088.1268.120.0975 3.011 1.54 4.687.995 11966.5183586690.881522344.8592600273.482 6.027172.541-909088.6268.560.1052 3.011 1.55 4.6877.995 11966.5183586690.881522344.8592600293.482 6.467172.541-9090892690.1129 3.011 1.55 4.6957.995 11966.5183586690.881522344.8592600313.482 6.908172.541-909089.4269.440.1206 3.011 1.56 4.7037.995 11966.5183586690.881522344.8592600333.4827.349172.541-909089.9269.890.1283 3.011 1.57 4.717.995 11966.5183586690.881522344.8592600353.4827.79172.541-909090.3270.330.136 3.011 1.58 4.7187.995 11966.5183586690.881522344.8592600373.4828.23172.541-909090.8270.770.1436 3.011 1.58 4.7267.995 11966.5183586690.881522344.8592600393.4828.671172.541-909091.2271.210.1513 3.011 1.59 4.7337.995 11966.5183586690.881522344.8592600413.4829.112172.541-909091.6271.650.159 3.011 1.6 4.7417.995 11966.5183586690.881522344.8592600433.4829.553172.541-909092.1272.090.1667 3.011 1.61 4.7497.995ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离11966.5183586690.881522344.8592600453.4829.993172.541-909092.5272.530.1744 3.011 1.61 4.7577.995 11966.5183586690.881522344.8592600457.85710.09172.541-909092.6272.630.1761 3.011 1.62 4.7587.995 12424.3753586234.023522364.15815.630.358182.63-909092.6272.630.0063 3.187 1.62 4.7587.995 12424.3753586234.023522364.15835.630.816182.63-909092.6272.630.0143 3.187 1.62 4.7587.995 12424.3753586234.023522364.15855.63 1.275182.63-909092.6272.630.0223 3.187 1.62 4.7587.995 12424.3753586234.023522364.15875.63 1.733182.63-909092.6272.630.0303 3.187 1.62 4.7587.995 12424.3753586234.023522364.15895.63 2.192182.63-909092.6272.630.0383 3.187 1.62 4.7587.995 12424.3753586234.023522364.158115.63 2.65182.63-909092.6272.630.0463 3.187 1.62 4.7587.995 12424.3753586234.023522364.158135.63 3.108182.63-909092.6272.630.0543 3.187 1.62 4.7587.995 12424.3753586234.023522364.158155.63 3.567182.63-909092.6272.630.0623 3.187 1.62 4.7587.995 12424.3753586234.023522364.158175.63 4.025182.63-909092.6272.630.0703 3.187 1.62 4.7587.995 12424.3753586234.023522364.158195.63 4.483182.63-909092.6272.630.0783 3.187 1.62 4.7587.995 12424.3753586234.023522364.158215.63 4.942182.63-909092.6272.630.0863 3.187 1.62 4.7587.995 12424.3753586234.023522364.158235.63 5.4182.63-909092.6272.630.0943 3.187 1.62 4.7587.995 12424.3753586234.023522364.158255.63 5.858182.63-909092.6272.630.1023 3.187 1.62 4.7587.995 12424.3753586234.023522364.158275.63 6.317182.63-909092.6272.630.1103 3.187 1.62 4.7587.995 12424.3753586234.023522364.158295.63 6.775182.63-909092.6272.630.1183 3.187 1.62 4.7587.995 12424.3753586234.023522364.158315.637.234182.63-909092.6272.630.1263 3.187 1.62 4.7587.995 12424.3753586234.023522364.158335.637.692182.63-909092.6272.630.1343 3.187 1.62 4.7587.995 12424.3753586234.023522364.158355.638.15182.63-909092.6272.630.1423 3.187 1.62 4.7587.995 12424.3753586234.023522364.158375.638.609182.63-909092.6272.630.1503 3.187 1.62 4.7587.995 12424.3753586234.023522364.158395.639.067182.63-909092.6272.630.1583 3.187 1.62 4.7587.995 12424.3753586234.023522364.158415.639.525182.63-909092.6272.630.1663 3.187 1.62 4.7587.995 12424.3753586234.023522364.158435.639.984182.63-909092.6272.630.1743 3.187 1.62 4.7587.995 12424.3753586234.023522364.158455.6310.44182.63-909092.6272.630.1823 3.187 1.62 4.7587.995ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离12424.3753586234.023522364.158475.6310.9182.63-909092.6272.630.1903 3.187 1.62 4.7587.995 12424.3753586234.023522364.158495.6311.36182.63-909092.6272.630.1983 3.187 1.62 4.7587.995 12424.3753586234.023522364.158515.6311.82182.63-909092.6272.630.2063 3.187 1.62 4.7587.995 12424.3753586234.023522364.158535.6312.28182.63-909092.6272.630.2143 3.187 1.62 4.7587.995 12424.3753586234.023522364.158555.6312.73182.63-909092.6272.630.2223 3.187 1.62 4.7587.995 12424.3753586234.023522364.158575.6313.19182.63-909092.6272.630.2303 3.187 1.62 4.7587.995 12424.3753586234.023522364.158595.6313.65182.63-909092.6272.630.2383 3.187 1.62 4.7587.995 12424.3753586234.023522364.158615.6314.11182.63-909092.6272.630.2463 3.187 1.62 4.7587.995 12424.3753586234.023522364.158635.6314.57182.63-909092.6272.630.2543 3.187 1.62 4.7587.995 12424.3753586234.023522364.158655.6315.03182.63-909092.6272.630.2623 3.187 1.62 4.7587.995 12424.3753586234.023522364.158675.6315.48182.63-909092.6272.630.2703 3.187 1.62 4.7587.995 12424.3753586234.023522364.158695.6315.94182.63-909092.6272.630.2783 3.187 1.62 4.7587.995 12424.3753586234.023522364.158715.6316.4182.63-909092.6272.630.2863 3.187 1.62 4.7587.995 12424.3753586234.023522364.158735.6316.86182.63-909092.6272.630.2943 3.187 1.62 4.7587.995 12424.3753586234.023522364.158755.6317.32182.63-909092.6272.630.3023 3.187 1.62 4.7587.995 12424.3753586234.023522364.158775.6317.78182.63-909092.6272.630.3103 3.187 1.62 4.7587.995 12424.3753586234.023522364.158795.6318.23182.63-909092.6272.630.3183 3.187 1.62 4.7587.995 12424.3753586234.023522364.158815.6318.69182.63-909092.6272.630.3263 3.187 1.62 4.7587.995 12424.3753586234.023522364.158835.6319.15182.63-909092.6272.630.3343 3.187 1.62 4.7587.995 12424.3753586234.023522364.158855.6319.61182.63-909092.6272.630.3423 3.187 1.62 4.7587.995 12424.3753586234.023522364.158875.6320.07182.63-909092.6272.630.3503 3.187 1.62 4.7587.995 12424.3753586234.023522364.158895.6320.53182.63-909092.6272.630.3583 3.187 1.62 4.7587.995 12424.3753586234.023522364.158915.6320.98182.63-909092.6272.630.3663 3.187 1.62 4.7587.995 12424.3753586234.023522364.158935.6321.44182.63-909092.6272.630.3743 3.187 1.62 4.7587.995 12424.3753586234.023522364.158955.6321.9182.63-909092.6272.630.3823 3.187 1.62 4.7587.995ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离12424.3753586234.023522364.158975.6322.36182.63-909092.6272.630.3903 3.187 1.62 4.7587.995 12424.3753586234.023522364.158995.6322.82182.63-909092.6272.630.3983 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,015.6323.28182.63-909092.6272.630.4063 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,035.6323.73182.63-909092.6272.630.4143 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,055.6324.19182.63-909092.6272.630.4223 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,075.6324.65182.63-909092.6272.630.4303 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,095.6325.11182.63-909092.6272.630.4383 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,115.6325.57182.63-909092.6272.630.4463 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,135.6326.03182.63-909092.6272.630.4543 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,155.6326.48182.63-909092.6272.630.4623 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,175.6326.94182.63-909092.6272.630.4703 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,195.6327.4182.63-909092.6272.630.4783 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,215.6327.86182.63-909092.6272.630.4863 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,235.6328.32182.63-909092.6272.630.4943 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,255.6328.78182.63-909092.6272.630.5023 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,275.6329.24182.63-909092.6272.630.5103 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,295.6329.69182.63-909092.6272.630.5183 3.187 1.62 4.7587.995 12424.3753586234.023522364.1581,302.9729.86182.63-909092.6272.630.5212 3.187 1.62 4.7587.995 13727.343584932.426522304.462260012.660.279182.631-909092.9272.90.0049 3.187 1.62 4.7637.995 13727.343584932.426522304.462260032.660.72182.631-909093.3273.350.0126 3.187 1.63 4.7717.995 13727.343584932.426522304.462260052.66 1.16182.631-909093.8273.790.0203 3.187 1.64 4.7787.995 13727.343584932.426522304.462260072.66 1.601182.631-909094.2274.230.0279 3.187 1.64 4.7867.995 13727.343584932.426522304.462260092.66 2.042182.631-909094.7274.670.0356 3.187 1.65 4.7947.995 13727.343584932.426522304.4622600112.66 2.483182.631-909095.1275.110.0433 3.187 1.66 4.8027.995 13727.343584932.426522304.4622600132.66 2.923182.631-909095.5275.550.051 3.187 1.67 4.8097.995 13727.343584932.426522304.4622600152.66 3.364182.631-909096275.990.0587 3.187 1.68 4.8177.995ZY点或YZ点坐标ZY点或YZ点R L E N左右偏左侧右侧F F弧度E弧度N弧度F弧度F S 桩号X Y半径长度切线角方位角方向左侧右侧左侧右侧横向距离13727.343584932.426522304.4622600172.66 3.805182.631-909096.4276.430.0664 3.187 1.68 4.8257.995 13727.343584932.426522304.4622600192.66 4.246182.631-909096.9276.870.0741 3.187 1.69 4.8327.995 13727.343584932.426522304.4622600212.66 4.686182.631-909097.3277.310.0818 3.187 1.7 4.847.995 13727.343584932.426522304.4622600232.66 5.127182.631-909097.8277.750.0895 3.187 1.71 4.8487.995 13727.343584932.426522304.4622600252.66 5.568182.631-909098.2278.190.0972 3.187 1.71 4.8557.995 13727.343584932.426522304.4622600272.66 6.009182.631-909098.6278.630.1049 3.187 1.72 4.8637.995 13727.343584932.426522304.4622600292.66 6.449182.631-909099.1279.080.1126 3.187 1.73 4.8717.995 13727.343584932.426522304.4622600312.66 6.89182.631-909099.5279.520.1203 3.187 1.74 4.8787.995 13727.343584932.426522304.4622600332.667.331182.631-9090100279.960.1279 3.187 1.74 4.8867.995 13727.343584932.426522304.4622600352.667.772182.631-9090100280.40.1356 3.187 1.75 4.8947.995 13727.343584932.426522304.4622600372.668.212182.631-9090101280.840.1433 3.187 1.76 4.9027.995 13727.343584932.426522304.4622600392.668.653182.631-9090101281.280.151 3.187 1.77 4.9097.995 13727.343584932.426522304.4622600412.669.094182.631-9090102281.720.1587 3.187 1.78 4.9177.995 13727.343584932.426522304.4622600432.669.534182.631-9090102282.160.1664 3.187 1.78 4.9257.995 13727.343584932.426522304.4622600452.669.975182.631-9090103282.60.1741 3.187 1.79 4.9327.995 13727.343584932.426522304.4622600472.6610.42182.631-9090103283.040.1818 3.187 1.8 4.947.995 13727.343584932.426522304.4622600492.6610.86182.631-9090103283.480.1895 3.187 1.81 4.9487.995 13727.343584932.426522304.4622600512.6611.3182.631-9090104283.920.1972 3.187 1.81 4.9557.995 13727.343584932.426522304.4622600532.6611.74182.631-9090104284.360.2049 3.187 1.82 4.96312 13727.343584932.426522304.4622600552.6612.18182.631-9090105284.80.2126 3.187 1.83 4.97112 13727.343584932.426522304.4622600572.6612.62182.631-9090105285.250.2203 3.187 1.84 4.97812 13727.343584932.426522304.4622600592.6613.06182.631-9090106285.690.2279 3.187 1.84 4.98612 13727.343584932.426522304.4622600612.6613.5182.631-9090106286.130.2356 3.187 1.85 4.99412 13727.343584932.426522304.4622600632.6613.94182.631-9090107286.570.2433 3.187 1.86 5.00212 13727.343584932.426522304.4622600652.6614.38182.631-9090107287.010.251 3.187 1.87 5.00912 13727.343584932.426522304.4622600672.6614.82182.631-9090107287.450.2587 3.187 1.88 5.01712 13727.343584932.426522304.4622600692.6615.26182.631-9090108287.890.2664 3.187 1.88 5.02512 13727.343584932.426522304.4622600712.6615.7182.631-9090108288.330.2741 3.187 1.89 5.03212 13727.343584932.426522304.4622600732.6616.15182.631-9090109288.770.2818 3.187 1.9 5.0412。
道路工程测量计算excel(功能齐全)
本程序是本人花了大量的时间编成的，为了表示对劳动成果的尊重，请你付点小费，你不会忠 QQ：337699117 邮箱：337699117@ 开户行： 中国工商银行 卡号：622202240300户名：徐明忠 付费100元整 付完费请将你的邮箱地址发到我的邮箱中，我会在一天内将密码发。
谢谢合作！！！！！！欢迎你使用！请加我的QQ：欢迎使用！！W S K E Z2M1102.8469986-1-20666.3715611774.126685.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!#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!W S K E Z2M1102.8469986#VALUE!-185.24241819-1-449.394092064.407880485.24232485#VALUE!1-946.4180920112.310203864.4079816#VALUE! #DIV/0!#DIV/0!#DIV/0!187.8999832#DIV/0!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!W S K E Z2M 1102.8469986#VALUE!-17.022*******.022********.2424181995.824498140 -1-608.224207064.407880485.242324851-1105.248210112.310203864.4079816#DIV/0!#DIV/0!#DIV/0!187.8999832#DIV/0!#VALUE! #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!W S K E Z2M 1102.8469986-1 6.854980654 6.85498065485.2424181995.99188198#VALUE!-1-609.684907064.407880485.24232485#VALUE!1-1106.708910112.310203864.4079816#VALUE! #DIV/0!#DIV/0!#DIV/0!187.8999832#DIV/0!#VALUE! #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!W S K E Z2M 1102.8469986#VALUE!-1 6.853322838 6.853********.2424181995.9935398#VALUE!-1-609.699374064.407880485.242324851-1106.723370112.310203864.4079816#VALUE! #DIV/0!#DIV/0!#DIV/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!TFSGC 0.005RAbs(I-J)H+0.01(Z-L)J+(I-336.508454840.034877340.256261995.7338.164336.5084548127.55338.177337.672133100转换前原坐标方位角转换后坐标方位角角度差值85.23921306085.2392130685°14′21.17″0°0′0″X0###########0.000YO500895.0010.000X1###########10.000M 3615414.145方位Y1500899.9840.000N 500895.001方度、点号需转换R 需转换V转换后X 转换后Y 13615406.172500895.665-1.6599E-058.0006015423615363.903500259.347-637.630803-2.687969657EX 施工坐标与大地坐标转换EXCEL表格成果输出33615472.936500379.368-508.974604-101.3835522 43615398.423500706.101-189.553136-0.010154291 53615447.634501297.377403.76720770.022069493 63615645.854501711.242832.6557627-163.1649827 700-799231.1483561368.391 800-799231.1483561368.391 900-799231.1483561368.391 1000-799231.1483561368.391）你不会介意吧！ 创作人：徐明银行 卡号：622202************* 开中，我会在一天内将密码发到你的邮箱中159.42635.1644425P 4.951433D S4.951411755.100556#VALUE!#VALUE!#VALUE! -17.6044410678.96159.37290880.969372 -20.834441.4877592-99.45819-13.75678 47.9022221.1241313-88.06205-48.231280#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.37290880.969372P D S55.100556#VALUE!#VALUE!#VALUE! -17.60444#VALUE!#VALUE!#VALUE! -20.834441.4877592-158.8301-13.77461 47.9022221.1241313-143.5455-69.36460#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.8301-13.77461P D S 55.100556#VALUE!#VALUE!#VALUE! -17.60444 1.672453-1.4607-4.953567 -20.834441.4877592-0.526157-5.13757 47.9022221.1241313 1.3355128-4.9887750#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.4607-4.953567P D S 55.100556#VALUE!#VALUE!#VALUE! -17.604441.6753744-0.014467-4.951412 -20.834441.48775920.9093064-4.867222 47.9022221.1241313 2.5809607-4.2255570#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!-0.014467-4.951412P D S 55.100556#VALUE!#VALUE!#VALUE! -17.604441.6754033-0.000143-4.951412 -20.834441.48775920.9235197-4.864523 47.9022221.1241313 2.5932848-4.217980#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!-0.000143-4.951412ZP YP FZP FYP k-0.01068 -44-3.990326 3.9709786#DIV/0!-2-2-2-2#DIV/0!-2-2-2-2#VALUE!#DIV/0!#DIV/0!#DIV/0!#DIV/0!000-44-3.990326 3.9709786EXCEL表格计算方位角距离转换后坐标方位角转换前原坐标方位角0.415104.983012.007228910象限角 1.487704920方位角弧度表示 1.487704920方位角度表示85.239213060度、分、秒表示85°14′21.17″0°0′0″距离 5.00010.000一哟！！10678.960551.487759231D J#VALUE!#VALUE! 10678.96055-10680.47694 1.487759231-3.00414753 1.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.055083655 1.124131343-2.691455768#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!D#VALUE!#VALUE! 1.672452997-1.857547771 1.487759231-1.672854005 1.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.573718146 1.487759231-1.38610298 1.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.570825261 1.487759231-1.383181162 1.124131343-1.019553274#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!zp2YP2K FXPD Wz4.25337.99373084.25-17.361634.25-20.500364.2547.540844.25#DIV/0!4.25#DIV/0!4.25#DIV/0!4.25#DIV/0!4.25-20.50036HZWy z y TZ TY 338.3337308 5.753134604 5.5831346045.753134604 5.5831346045.7531346040.802#VALUE!。