坐标自动计算表格
根据坐标自动计算两点距离和高差
根据坐标自动计算两点距离和高差在数学和几何学中，我们经常需要计算两点之间的距离和高差。
这些计算可以在三维空间或二维平面中进行。
本文将介绍一些常见的方法来计算两点之间的距离和高差。
首先，让我们考虑在二维平面上计算两点之间的距离。
假设我们有两个点A和B，坐标分别为(Ax,Ay)和(Bx,By)。
我们可以使用勾股定理来计算它们之间的距离。
勾股定理可以表示为：距离=√((Bx-Ax)^2+(By-Ay)^2)这个公式可以通过计算两点在水平和垂直方向上的差值的平方和，再进行平方根运算来得到。
请注意，在计算平方根之前，我们要先计算平方和。
例如，如果A(0,0)和B(3,4)是两个点的坐标，我们可以使用上述公式计算它们之间的距离：距离=√((3-0)^2+(4-0)^2)=√(9+16)=√25=5因此，点A和点B之间的距离为5个单位。
接下来，我们来考虑在三维空间中计算两点之间的距离和高差。
假设我们有两个点A和B，坐标分别为(Ax,Ay,Az)和(Bx,By,Bz)。
我们可以使用三维勾股定理来计算它们之间的距离。
三维勾股定理可以表示为：距离=√((Bx-Ax)^2+(By-Ay)^2+(Bz-Az)^2)与二维情况类似，我们首先计算两点在三个方向上的差值的平方和，然后进行平方根运算。
例如，如果A(0,0,0)和B(3,4,5)是两个点的坐标，我们可以使用上述公式计算它们之间的距离：距离=√((3-0)^2+(4-0)^2+(5-0)^2)=√(9+16+25)=√50≈7.07因此，点A和点B之间的距离约为7.07个单位。
除了计算两点之间的距离，我们还可以计算它们之间的高差。
高差可以表示为两个点在垂直方向上的差值。
在二维平面上，高差为By-Ay；在三维空间中，高差为Bz-Az。
例如，在上面的例子中，点A和点B之间的高差为Bz-Az=5-0=5个单位。
综上所述，通过使用勾股定理，我们可以计算二维平面上两点之间的距离，并通过计算垂直方向上的差值来得到高差。
教你如何通过Excel VBA编写测量坐标计算程序
教你如何通过Excel VBA编写测量坐标计算程序发布日期：2013-01-11 来源：网络作者：未知浏览次数：1704摘要：认识VBA、理解VBA，并利用Office Excel VBA编写测量坐标计算程序。
关键词：Excel VBA 程序坐标编写了解：VBA是什么？简单的说就是一种自动化语言，它可以使常用的程序自动化,可以创建自定义的解决方案。
可以用Excel的宏语言来使Excel自动化运行等……Microsoft让它开发出来的应用程序共享一种通用的自动化语言——Visual Basic For Application(VB A)，可以认为VBA是非常流行的应用程序开发语言Visual Basic的子集，事实上VBA是V B应用程序的版本，尽管存在有些不同VBA和VB在结构上仍然十分相似。
如果你已经了解VB会发现学习VBA非常快。
相应的学完VBA会给学习VB打下坚实的基础。
理由：选择Excel VBA编程的理由是因为它的计算功能非常强大，是现今任何编程计算器无法逾越的。
它运用范围广，计算速度快，计算精度高，合理化显示等。
或许很多测量人员对Excel VBA还有些陌生，主要是大家寄托于计算器、电脑、手机PDA等系列软件使用。
Excel VBA对于大多数测量人员而没有系统学过计算机语言程序设计的人群来讲有一定含糊，不过只要有基本数学知识、测量常识和逻辑理解的人，都能通过Excel VBA编写设计出称心如意的测量程序。
目标：基于Excel VBA的测量坐标计算程序的设计目标是将繁琐计算过程转入到计算机中，利用程序语言的重复性原理，在计算机中可将坐标计算得出更精确的结果，使坐标计算更加可靠。
最终目标是让用户可以通过Excel VBA自行完成坐标计算程序设计。
认识：学习VBA到底需要什么基础和了解些什么？学习VBA需要认识英文字母、一般的单词（如：函数所用的过程）、数学基础知识、测量常识、逻辑性思维即可。
EXCEL计算坐标
Excel在导线计算中的应用李海军摘要：目前在一些小地区的大比例尺测图中，做控制用的较多的是导线测量的方法。
由于全站仪的广泛应用给导线的外业测量带来不少方便，但导线的内业计算如采用手工计算工作量大，本文就介绍用Ecxcl进行导线计算的方法。
关键词：Excel 导线计算1前言Execl是目前最为流行的电子表格制作软件，它是微软公司开发的在Windows下运行的一个重要应用软件，一般也称Microsoft Execl。
它同MicrosoftWord、 Microsoft PowerPoint、Microsoft FrontPage等合称Microsoft office。
Execl具有强大的运算功能，它能按照用户的意图进行各种复杂的运算（包括编写公式、调用函数等）。
Execl同样具有强大的数据管理和处理功能，能够根据用户的要求将输入的数据生成各种各样的图表，可以对数据按照各种复杂的条件进行排序、查找、替换、编辑和筛选。
最后，Execl能把用户制作的文件保存起来，用户可以随时调出来进行补充和修改，也方便打印和复制。
2 Execl在导线计算中的应用目前，随着测绘技术的不断发展，在一些小地区的大比例尺测图中，做控制应用较多的依然是导线测量的方法。
在导线测量中，野外数据的采集用全站仪可以说方便快捷，但是其内业的计算用手工却比较麻烦，而且费时费力。
本文就着重介绍一下Excel在导线计算方面的应用。
3．实例现在就以某一测区测得一条附合导线为例，讲解用Excel对其进行计算的方法。
导线图如下所示：已知A,B,C,D四点的坐标，在测量时测出了导线的左转折角以及相邻导线点之间的水平距离。
现在我们就看如何用Excel快速计算出1，2，3，4点的坐标。
计算各导线点的坐标3.1.1输入首先我们在A列输入点号，然后在B列输入观测角（在这里我们观测的是左角），以度分秒的格式输入，度和分之间用小数点隔开，在S2T2单元格中输入B点的x，y坐标，S3T3单元格中输入A点的x，y坐标， S8T8单元格中输入C点的x，y坐标， S9T9单元格中输入D点的x，y坐标，最后在H列输入各条导线边的长度。
Excel表格自动计算技巧
Excel表格自动计算技巧Excel表格自动计算技巧一、显示单元格例有计算式的结果的设置方法首先：插入-名称-定义在弹出的对话框“当前工作薄的名称”中输入: X或“结果”的自定义名称，再在“引用位置”处粘贴＝EVALUATE(SUBSTITUT E(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(计算!$C$1,"[","("),"]",")"),"×","*"),"÷","/"))公式(注意要有“＝”号。
再对公式中“计算!$C$1”选择上，然后再到需要做公式的单元格中点击即可。
如要相对引用，则要删除$字符。
已经OK，你在C1输入表达式比如15+5×3 ，在D1中输入=x 看看(应该是30)。
二、如何在Excel中输入计算式后另一单元显示计算结果菜单--插入--名称--定义：输入AA(任意取名)，在下面输入公式:=EVALUATE($A$1)然后在B1单元格输入公式：=AA但本式不能识别如：[、×、÷等符号进行计算，使用第一种较好。
三、如何在Excel中编写自定义函数，象在表格中调用SUM()一样？第一种情况：单元格A1 = 2；单元格B1 = 2；单元格C1 = 2单元格D1=(A1+B1)×C1 显示结果为8 ；那么如何才能在单元格E1中显示(2+2)×2的计算表达式，并且建立关联，当单元格D1变成=(A1+BA)^C1 计算式后，显示结果为16；那么E1也就自动显示为(2+2)^2的计算表达式，也就是说随着单元格D1的计算公式变化，单元格E1显示的计算表达式也随之变化。
第二种情况：是当计算的单元格任意变化时，怎么办？比如说计算式E1=A1+B1+C1+D 1，也有D2=A2+B2+C2，还有F3=A1+B1+C1+D1+E1时。
GPS坐标放样、平面位置(自动计算)
合同号：编 号：日 期：
桩号及工程部位：K0+697～K0+797(左)基础边线
监理单位：北京华路捷公路工程技术咨询有限公司承包单位：雅安交建集团路桥有限责任公司工程名称：小脚护肩墙工程
合同号：编 号：日 期：
承包单位：雅安交建集团路桥有限责任公司工程名称：小脚护肩墙工程
监理单位：北京华路捷公路工程技术咨询有限公司桩号及工程部位：K0+813～K1+024(左)基础边线
合同号：编 号：日 期：
承包单位：雅安交建集团路桥有限责任公司监理单位：北京华路捷公路工程技术咨询有限公司工程名称：小脚护肩墙工程
桩号及工程部位：K1+060～K1+199.2(左)基础边线
合同号：编 号：日 期：
桩号及工程部位：K1+249～K1+451.5(左)基础边线
承包单位：雅安交建集团路桥有限责任公司监理单位：北京华路捷公路工程技术咨询有限公司工程名称：小脚护肩墙工程
在这下面进行选择性粘贴
在这下面进行选择性粘贴
在这下面进行选择性粘贴
在这下面进行选择性粘贴。
教你如何通过ExcelVBA编写测量坐标计算程序
教你如何通过Excel VBA编写测量坐标计算程序发布日期：2013-01-11来源：网络作者：未知浏览次数：1704摘要：认识VBA、理解VBA，并利用Office Excel VBA编写测量坐标计算程序。
关键词：Excel VBA程序坐标编写了解：VBA是什么？简单的说就是一种自动化语言，它可以使常用的程序自动化,可以创建自定义的解决方案。
可以用Excel的宏语言来使Excel自动化运行等……Microsoft让它开发出来的应用程序共享一种通用的自动化语言——Visual Basic For Application(VB A)，可以认为VBA是非常流行的应用程序开发语言Visual Basic的子集，事实上VBA是V B应用程序的版本，尽管存在有些不同VBA和VB在结构上仍然十分相似。
如果你已经了解VB会发现学习VBA非常快。
相应的学完VBA会给学习VB打下坚实的基础。
理由：选择Excel VBA编程的理由是因为它的计算功能非常强大，是现今任何编程计算器无法逾越的。
它运用范围广，计算速度快，计算精度高，合理化显示等。
或许很多测量人员对Excel VBA还有些陌生，主要是大家寄托于计算器、电脑、手机PDA等系列软件使用。
Excel VBA对于大多数测量人员而没有系统学过计算机语言程序设计的人群来讲有一定含糊，不过只要有基本数学知识、测量常识和逻辑理解的人，都能通过Excel VBA编写设计出称心如意的测量程序。
目标：基于Excel VBA的测量坐标计算程序的设计目标是将繁琐计算过程转入到计算机中，利用程序语言的重复性原理，在计算机中可将坐标计算得出更精确的结果，使坐标计算更加可靠。
最终目标是让用户可以通过Excel VBA自行完成坐标计算程序设计。
认识：学习VBA到底需要什么基础和了解些什么？学习VBA需要认识英文字母、一般的单词（如：函数所用的过程）、数学基础知识、测量常识、逻辑性思维即可。
主线坐标计算
设计参数录入 交点编号 JD7 直线方位角 178.40308 转 角 17.08269 桩 号 K001+053.286 半 径R 600.00 缓和曲线Ls1 65.000 缓和曲线Ls2 65.000 X 坐标 38605.913 Y 坐标 74184.790
ZX RAD-Ca RAD-Cb ZJ-JD R Ls1 Ls2 X-JD Y-JD DK-JD
# 0 # 0
#
#
2 #
#
三、前双交点圆复曲线
注：计算数据全部由设计提供
四、前双交点两端带缓
注:参数全部由设计提供 曲线特征： ZH-HY1-Y1Y2-Y2H-HZ
曲线特征：ZY-Y1Y2-YZ
设计参数录入 交点1编号 直线方位角 转 角 桩 号 半 径R X 坐标 Y 坐标 交点2编号 桩 号 转 角 半 径R
六、前双交点起端带缓和曲线的复曲线（3）
复曲线特征点参数表 复曲线起点-ZH K001+394.599 桩 号 0°0′0″ 切线方位角 894.599 X坐 标 1000.000 Y坐 标 复曲线-HY1 K001+494.599 桩 号 切线方位角 353°10′44″ 994.457 X坐 标 996.036 Y坐 标 复曲线-Y1Y2 K001+554.555 桩 号 345°0′0″ 切线方位角 1053.279 X坐 标 984.697 Y坐 标 复曲线闭点-YZ K001+688.486 桩 号 切线方位角 326°33′24″ 1174.894 X坐 标 929.986 Y坐 标
五、前双交点两端带缓和曲线的复曲线（2）
六、前双交点起端带缓和曲线的复曲线
注:参数部份由设计提供 R2由程序计算获得 曲线特征：闭端不带回旋线 ZH-HY1-Y1Y2-YZ
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
桩号偏距X（m)Y（m)方位角高程1808002961525.733487467.350137.728016511808502961529.688487470.409737.728016511809002961533.642487473.469237.728016511809502961537.597487476.528837.728016511810002961541.551487479.588437.728016511810502961545.506487482.64837.728016511811002961549.461487485.707537.728016511811502961553.415487488.767137.728016511812002961557.37487491.826737.728016511812502961561.325487494.886237.728016511813002961565.279487497.945837.728016511813502961569.234487501.005437.728016511814002961573.188487504.064937.728016511814502961577.143487507.124537.728016511815002961581.098487510.184137.728016511815502961585.052487513.243637.728016511816002961589.007487516.303237.728016511816502961592.962487519.362837.728016511817002961596.916487522.422437.728016511817502961600.871487525.481937.728016511818002961604.825487528.541537.728016511818502961608.78487531.601137.728016511819002961612.735487534.660637.728016511819502961616.689487537.720237.728016511820002961620.644487540.779837.728016511820502961624.599487543.839337.728016511821002961628.553487546.898937.728016511821502961632.508487549.958537.728016511822002961636.462487553.01837.728016511822502961640.417487556.077637.728016511823002961644.372487559.137237.728016511823502961648.326487562.196837.72801651桩号偏距X（m)Y（m)方位角高程1824002961652.281487565.256337.728016511824502961656.235487568.315937.728016511825002961660.19487571.375537.728016511825502961664.145487574.43537.728016511826002961668.099487577.494637.728016511826502961672.054487580.554237.728016511827002961676.009487583.613737.728016511827502961679.963487586.673337.728016511828002961683.918487589.732937.728016511828502961687.872487592.792537.728016511829002961691.827487595.85237.728016511829502961695.782487598.911637.728016511830002961699.736487601.971237.728016511830502961703.691487605.030737.728016511831002961707.646487608.090337.728016511831502961711.6487611.149937.728016511832002961715.555487614.209437.728016511832502961719.509487617.26937.728016511833002961723.464487620.328637.728016511833502961727.419487623.388137.728016511834002961731.373487626.447737.728016511834502961735.328487629.507337.728016511835002961739.283487632.566937.728016511835502961743.237487635.626437.728016511836002961747.192487638.68637.728016511836502961751.146487641.745637.728016511837002961755.101487644.805137.728016511837502961759.056487647.864737.728016511838002961763.01487650.924337.728016511838502961766.965487653.983837.728016511839002961770.92487657.043437.728016511839502961774.874487660.10337.72801651桩号偏距X（m)Y（m)方位角高程1840002961778.829487663.162537.728016511840502961782.783487666.222137.728016511841002961786.738487669.281737.728016511841502961790.693487672.341337.728016511842002961794.647487675.400837.728016511842502961798.602487678.460437.728016511843002961802.556487681.5237.728016511843502961806.511487684.579537.728016511844002961810.466487687.639137.728016511844502961814.42487690.698737.728016511845002961818.375487693.758237.728016511845502961822.33487696.817837.728016511846002961826.284487699.877437.728016511846502961830.239487702.936937.728016511847002961834.193487705.996537.728016511847502961838.148487709.056137.728016511848002961842.103487712.115737.728016511848502961846.057487715.175237.728016511849002961850.012487718.234837.728016511849502961853.967487721.294437.728016511850002961857.921487724.353937.728016511850502961861.876487727.413537.728016511851002961865.83487730.473137.728016511851502961869.785487733.532637.728016511852002961873.74487736.592237.728016511852502961877.694487739.651837.728016511853002961881.649487742.711337.728016511853502961885.604487745.770937.728016511854002961889.558487748.830537.728016511854502961893.513487751.890137.728016511855002961897.467487754.949637.728016511855502961901.422487758.009237.72801651桩号偏距X（m)Y（m)方位角高程1856002961905.377487761.068837.728016511856502961909.331487764.128337.728016511857002961913.286487767.187937.728016511857502961917.241487770.247537.728016511858002961921.195487773.30737.728016511858502961925.15487776.366637.728016511859002961929.104487779.426237.728016511859502961933.059487782.485737.728016511860002961937.014487785.545337.728016511860502961940.968487788.604937.728016511861002961944.923487791.664537.728016511861502961948.878487794.72437.728016511862002961952.832487797.783637.728016511862502961956.787487800.843237.728016511863002961960.741487803.902737.728016511863502961964.696487806.962337.728016511864002961968.651487810.021937.728016511864502961972.605487813.081437.728016511865002961976.56487816.14137.728016511865502961980.514487819.200637.728016511866002961984.469487822.260137.728016511866502961988.424487825.319737.728016511867002961992.378487828.379337.728016511867502961996.333487831.438937.728016511868002962000.288487834.498437.728016511868502962004.242487837.55837.728016511869002962008.197487840.617637.728016511869502962012.151487843.677137.728016511870002962016.106487846.736737.728016511870502962020.061487849.796337.728016511871002962024.015487852.855837.728016511871502962027.97487855.915437.72801651桩号偏距X（m)Y（m)方位角高程1872002962031.925487858.97537.728016511872502962035.879487862.034537.728016511873002962039.834487865.094137.728016511873502962043.788487868.153737.728016511874002962047.743487871.213337.728016511874502962051.698487874.272837.728016511875002962055.652487877.332437.728016511875502962059.607487880.39237.728016511876002962063.562487883.451537.728016511876502962067.516487886.511137.728016511877002962071.471487889.570737.728016511877502962075.425487892.630237.728016511878002962079.38487895.689837.728016511878502962083.335487898.749437.728016511879002962087.289487901.808937.728016511879502962091.244487904.868537.728016511880002962095.199487907.928137.728016511880502962099.153487910.987737.728016511881002962103.108487914.047237.728016511881502962107.062487917.106837.728016511882002962111.017487920.166437.728016511882502962114.972487923.225937.728016511883002962118.926487926.285537.728016511883502962122.881487929.345137.728016511884002962126.836487932.404637.728016511884502962130.79487935.464237.728016511885002962134.745487938.523837.728016511885502962138.699487941.583437.728016511886002962142.654487944.642937.728016511886502962146.609487947.702537.728016511887002962150.563487950.762137.728016511887502962154.518487953.821637.72801651桩号偏距X（m)Y（m)方位角高程1888002962158.472487956.881237.728016511888502962162.427487959.940837.728016511889002962166.382487963.000337.728016511889502962170.336487966.059937.728016511890002962174.291487969.119537.728016511890502962178.246487972.17937.728016511891002962182.2487975.238637.728016511891502962186.155487978.298237.728016511892002962190.109487981.357837.728016511892502962194.064487984.417337.728016511893002962198.019487987.476937.728016511893502962201.973487990.536537.728016511894002962205.928487993.59637.728016511894502962209.883487996.655637.728016511895002962213.837487999.715237.728016511895502962217.792488002.774737.728016511896002962221.746488005.834337.728016511896502962225.701488008.893937.728016511897002962229.656488011.953437.728016511897502962233.61488015.01337.728016511898002962237.565488018.072637.728016511898502962241.52488021.132237.728016511899002962245.474488024.191737.728016511899502962249.429488027.251337.728016511900002962253.383488030.310937.728016511900502962257.338488033.370437.728016511901002962261.293488036.4337.728016511901502962265.247488039.489637.728016511902002962269.202488042.549137.728016511902502962273.157488045.608737.728016511903002962277.111488048.668337.728016511903502962281.066488051.727837.72801651桩号偏距X（m)Y（m)方位角高程1904002962285.02488054.787437.728016511904502962288.975488057.84737.728016511905002962292.93488060.906637.728016511905502962296.884488063.966137.728016511906002962300.839488067.025737.728016511906502962304.794488070.085337.728016511907002962308.748488073.144837.728016511907502962312.703488076.204437.728016511908002962316.657488079.26437.728016511908502962320.612488082.323537.728016511909002962324.567488085.383137.728016511909502962328.521488088.442737.728016511910002962332.476488091.502237.728016511910502962336.43488094.561837.728016511911002962340.385488097.621437.728016511911502962344.34488100.68137.728016511912002962348.294488103.740537.728016511912502962352.249488106.800137.728016511913002962356.204488109.859737.728016511913502962360.158488112.919237.728016511914002962364.113488115.978837.728016511914502962368.067488119.038437.728016511915002962372.022488122.097937.728016511915502962375.977488125.157537.728016511916002962379.931488128.217137.728016511916502962383.886488131.276637.728016511917002962387.841488134.336237.728016511917502962391.795488137.395837.728016511918002962395.75488140.455437.728016511918502962399.704488143.514937.728016511919002962403.659488146.574537.728016511919502962407.614488149.634137.72801651桩号偏距X（m)Y（m)方位角高程1920002962411.568488152.693637.728016511920502962415.523488155.753237.728016511921002962419.478488158.812837.728016511921502962423.432488161.872337.728016511922002962427.387488164.931937.728016511922502962431.341488167.991537.728016511923002962435.296488171.05137.728016511923502962439.251488174.110637.728016511924002962443.205488177.170237.728016511924502962447.16488180.229837.728016511925002962451.115488183.289337.728016511925502962455.069488186.348937.728016511926002962459.024488189.408537.728016511926502962462.978488192.46837.728016511927002962466.933488195.527637.728016511927502962470.888488198.587237.728016511928002962474.842488201.646737.728016511928502962478.797488204.706337.728016511929002962482.751488207.765937.728016511929502962486.706488210.825437.728016511930002962490.661488213.88537.728016511930502962494.615488216.944637.728016511931002962498.57488220.004237.728016511931502962502.525488223.063737.728016511932002962506.479488226.123337.728016511932502962510.434488229.182937.728016511933002962514.388488232.242437.728016511933502962518.343488235.30237.728016511934002962522.298488238.361637.728016511934502962526.252488241.421137.728016511935002962530.207488244.480737.728016511935502962534.162488247.540337.72801651桩号偏距X（m)Y（m)方位角高程1936002962538.116488250.599837.728016511936502962542.071488253.659437.728016511937002962546.025488256.71937.728016511937502962549.98488259.778637.728016511938002962553.935488262.838137.728016511938502962557.889488265.897737.728016511939002962561.844488268.957337.728016511939502962565.799488272.016837.728016511940002962569.753488275.076437.728016511940502962573.708488278.13637.728016511941002962577.662488281.195537.728016511941502962581.617488284.255137.728016511942002962585.572488287.314737.728016511942502962589.526488290.374337.728016511943002962593.481488293.433837.728016511943502962597.436488296.493437.728016511944002962601.39488299.55337.728016511944502962605.345488302.612537.728016511945002962609.299488305.672137.728016511945502962613.254488308.731737.728016511946002962617.209488311.791237.728016511946502962621.163488314.850837.728016511947002962625.118488317.910437.728016511947502962629.073488320.969937.728016511948002962633.027488324.029537.728016511948502962636.982488327.089137.728016511949002962640.936488330.148737.728016511949502962644.891488333.208237.728016511950002962648.846488336.267837.728016511950502962652.8488339.327437.728016511951002962656.755488342.386937.728016511951502962660.709488345.446537.72801651桩号偏距X（m)Y（m)方位角高程1952002962664.664488348.506137.728016511952502962668.619488351.565637.728016511953002962672.573488354.625237.728016511953502962676.528488357.684837.728016511954002962680.483488360.744337.728016511954502962684.437488363.803937.728016511955002962688.392488366.863537.728016511955502962692.346488369.923137.728016511956002962696.301488372.982637.728016511956502962700.256488376.042237.728016511957002962704.21488379.101837.728016511957502962708.165488382.161337.728016511958002962712.12488385.220937.728016511958502962716.074488388.280537.728016511959002962720.029488391.3437.728016511959502962723.983488394.399637.728016511960002962727.938488397.459237.728016511960502962731.893488400.518737.728016511961002962735.847488403.578337.728016511961502962739.802488406.637937.728016511962002962743.757488409.697537.728016511962502962747.711488412.75737.728016511963002962751.666488415.816637.728016511963502962755.62488418.876237.728016511964002962759.575488421.935737.728016511964502962763.53488424.995337.728016511965002962767.484488428.054937.728016511965502962771.439488431.114437.728016511966002962775.394488434.17437.728016511966502962779.348488437.233637.728016511967002962783.303488440.293137.728016511967502962787.257488443.352737.72801651桩号偏距X（m)Y（m)方位角高程1968002962791.212488446.412337.728016511968502962795.167488449.471937.728016511969002962799.121488452.531437.728016511969502962803.076488455.59137.728016511970002962807.031488458.650637.728016511970502962810.985488461.710137.728016511971002962814.94488464.769737.728016511971502962818.894488467.829337.728016511972002962822.849488470.888837.728016511972502962826.804488473.948437.728016511973002962830.758488477.00837.728016511973502962834.713488480.067537.728016511974002962838.667488483.127137.728016511974502962842.622488486.186737.728016511975002962846.577488489.246337.728016511975502962850.531488492.305837.728016511976002962854.486488495.365437.728016511976502962858.441488498.42537.728016511977002962862.395488501.484537.728016511977502962866.35488504.544137.728016511978002962870.304488507.603737.728016511978502962874.259488510.663237.728016511979002962878.214488513.722837.728016511979502962882.168488516.782437.728016511980002962886.123488519.841937.728016511980502962890.078488522.901537.728016511981002962894.032488525.961137.728016511981502962897.987488529.020737.728016511982002962901.941488532.080237.728016511982502962905.896488535.139837.728016511983002962909.851488538.199437.728016511983502962913.805488541.258937.72801651桩号偏距X（m)Y（m)方位角高程1984002962917.76488544.318537.728016511984502962921.715488547.378137.728016511985002962925.669488550.437637.728016511985502962929.624488553.497237.728016511986002962933.578488556.556837.728016511986502962937.533488559.616337.728016511987002962941.488488562.675937.728016511987502962945.442488565.735537.728016511988002962949.397488568.795137.728016511988502962953.352488571.854637.728016511989002962957.306488574.914237.728016511989502962961.261488577.973837.728016511990002962965.215488581.033337.728016511990502962969.17488584.092937.728016511991002962973.125488587.152537.728016511991502962977.079488590.21237.728016511992002962981.034488593.271637.728016511992502962984.988488596.331237.728016511993002962988.943488599.390737.728016511993502962992.898488602.450337.728016511994002962996.852488605.509937.728016511994502963000.807488608.569537.728016511995002963004.762488611.62937.728016511995502963008.716488614.688637.728016511996002963012.671488617.748237.728016511996502963016.625488620.807737.728016511997002963020.58488623.867337.728016511997502963024.535488626.926937.728016511998002963028.489488629.986437.728016511998502963032.444488633.04637.728016511999002963036.399488636.105637.728016511999502963040.353488639.165237.72801651桩号偏距X（m)Y（m)方位角高程2000002963044.308488642.224737.728016512000502963048.262488645.284337.728016512001002963052.217488648.343937.728016512001502963056.172488651.403437.728016512002002963060.126488654.46337.728016512002502963064.081488657.522637.728016512003002963068.036488660.582137.728016512003502963071.99488663.641737.728016512004002963075.945488666.701337.728016512004502963079.899488669.760837.728016512005002963083.854488672.820437.728016512005502963087.809488675.8837.728016512006002963091.763488678.939637.728016512006502963095.718488681.999137.728016512007002963099.673488685.058737.728016512007502963103.627488688.118337.728016512008002963107.582488691.177837.728016512008502963111.536488694.237437.728016512009002963115.491488697.29737.728016512009502963119.446488700.356537.728016512010002963123.4488703.416137.728016512010502963127.355488706.475737.728016512011002963131.31488709.535237.728016512011502963135.264488712.594837.728016512012002963139.219488715.654437.728016512012502963143.173488718.71437.728016512013002963147.128488721.773537.728016512013502963151.083488724.833137.728016512014002963155.037488727.892737.728016512014502963158.992488730.952237.728016512015002963162.946488734.011837.728016512015502963166.901488737.071437.72801651桩号偏距X（m)Y（m)方位角高程2016002963170.856488740.130937.728016512016502963174.81488743.190537.728016512017002963178.765488746.250137.728016512017502963182.72488749.309637.728016512018002963186.674488752.369237.728016512018502963190.629488755.428837.728016512019002963194.583488758.488437.728016512019502963198.538488761.547937.728016512020002963202.493488764.607537.728016512020502963206.447488767.667137.728016512021002963210.402488770.726637.728016512021502963214.357488773.786237.728016512022002963218.311488776.845837.728016512022502963222.266488779.905337.728016512023002963226.22488782.964937.728016512023502963230.175488786.024537.728016512024002963234.13488789.08437.728016512024502963238.084488792.143637.728016512025002963242.039488795.203237.728016512025502963245.994488798.262837.728016512026002963249.948488801.322337.728016512026502963253.903488804.381937.728016512027002963257.857488807.441537.728016512027502963261.812488810.50137.728016512028002963265.767488813.560637.728016512028502963269.721488816.620237.728016512029002963273.676488819.679737.728016512029502963277.631488822.739337.728016512030002963281.585488825.798937.728016512030502963285.54488828.858437.728016512031002963289.494488831.91837.728016512031502963293.449488834.977637.72801651桩号偏距X（m)Y（m)方位角高程2032002963297.404488838.037237.728016512032502963301.358488841.096737.728016512033002963305.313488844.156337.728016512033502963309.268488847.215937.728016512034002963313.222488850.275437.728016512034502963317.177488853.33537.728016512035002963321.131488856.394637.728016512035502963325.086488859.454137.728016512036002963329.041488862.513737.728016512036502963332.995488865.573337.728016512037002963336.95488868.632837.728016512037502963340.904488871.692437.728016512038002963344.859488874.75237.728016512038502963348.814488877.811637.728016512039002963352.768488880.871137.728016512039502963356.723488883.930737.728016512040002963360.678488886.990337.728016512040502963364.632488890.049837.728016512041002963368.587488893.109437.728016512041502963372.541488896.16937.728016512042002963376.496488899.228537.728016512042502963380.451488902.288137.728016512043002963384.405488905.347737.728016512043502963388.36488908.407237.728016512044002963392.315488911.466837.728016512044502963396.269488914.526437.728016512045002963400.224488917.58637.728016512045502963404.178488920.645537.728016512046002963408.133488923.705137.728016512046502963412.088488926.764737.728016512047002963416.042488929.824237.728016512047502963419.997488932.883837.72801651桩号偏距X（m)Y（m)方位角高程2048002963423.952488935.943437.728016512048502963427.906488939.002937.728016512049002963431.861488942.062537.728016512049502963435.815488945.122137.728016512050002963439.77488948.181637.728016512050502963443.725488951.241237.728016512051002963447.679488954.300837.728016512051502963451.634488957.360437.728016512052002963455.589488960.419937.728016512052502963459.543488963.479537.728016512053002963463.498488966.539137.728016512053502963467.452488969.598637.728016512054002963471.407488972.658237.728016512054502963475.362488975.717837.728016512055002963479.316488978.777337.728016512055502963483.271488981.836937.728016512056002963487.225488984.896537.728016512056502963491.18488987.956137.728016512057002963495.135488991.015637.728016512057502963499.089488994.075237.728016512058002963503.044488997.134837.728016512058502963506.999489000.194337.728016512059002963510.953489003.253937.728016512059502963514.908489006.313537.728016512060002963518.862489009.37337.728016512060502963522.817489012.432637.728016512061002963526.772489015.492237.728016512061502963530.726489018.551737.728016512062002963534.681489021.611337.728016512062502963538.636489024.670937.728016512063002963542.59489027.730537.728016512063502963546.545489030.7937.72801651桩号偏距X（m)Y（m)方位角高程2064002963550.499489033.849637.728016512064502963554.454489036.909237.728016512065002963558.409489039.968737.728016512065502963562.363489043.028337.728016512066002963566.318489046.087937.728016512066502963570.273489049.147437.728016512067002963574.227489052.20737.728016512067502963578.182489055.266637.728016512068002963582.136489058.326137.728016512068502963586.091489061.385737.728016512069002963590.046489064.445337.728016512069502963594489067.504937.728016512070002963597.955489070.564437.728016512070502963601.91489073.62437.728016512071002963605.864489076.683637.728016512071502963609.819489079.743137.728016512072002963613.773489082.802737.728016512072502963617.728489085.862337.728016512073002963621.683489088.921837.728016512073502963625.637489091.981437.728016512074002963629.592489095.04137.728016512074502963633.547489098.100537.728016512075002963637.501489101.160137.728016512075502963641.456489104.219737.728016512076002963645.41489107.279337.728016512076502963649.365489110.338837.728016512077002963653.32489113.398437.728016512077502963657.274489116.45837.728016512078002963661.229489119.517537.728016512078502963665.183489122.577137.728016512079002963669.138489125.636737.728016512079502963673.093489128.696237.72801651桩号偏距X（m)Y（m)方位角高程2080002963677.047489131.755837.728016512080502963681.002489134.815437.728016512081002963684.957489137.874937.728016512081502963688.911489140.934537.728016512082002963692.866489143.994137.728016512082502963696.82489147.053737.728016512083002963700.775489150.113237.728016512083502963704.73489153.172837.728016512084002963708.684489156.232437.728016512084502963712.639489159.291937.728016512085002963716.594489162.351537.728016512085502963720.548489165.411137.728016512086002963724.503489168.470637.728016512086502963728.457489171.530237.728016512087002963732.412489174.589837.728016512087502963736.367489177.649337.728016512088002963740.321489180.708937.728016512088502963744.276489183.768537.728016512089002963748.231489186.828137.728016512089502963752.185489189.887637.728016512090002963756.14489192.947237.728016512090502963760.094489196.006837.728016512091002963764.049489199.066337.728016512091502963768.004489202.125937.728016512092002963771.958489205.185537.728016512092502963775.913489208.24537.728016512093002963779.868489211.304637.72801651桩号偏距X（m)Y（m)方位角高程桩号偏距X（m)Y（m)方位角高程桩号偏距X（m)Y（m)方位角高程桩号偏距X（m)Y（m)方位角高程桩号偏距X（m)Y（m)方位角高程。