测量数据绘制CAD横断面图_精品文档.xlsx

测量数据绘制CAD横断面图_精品文档.xlsx

《测量数据绘制CAD横断面图_精品文档.xlsx》由会员分享，可在线阅读，更多相关《测量数据绘制CAD横断面图_精品文档.xlsx（120页珍藏版）》请在冰豆网上搜索。

1234567891、原始数据表附注：

本表请输入对应点的X,Y,Z坐标及里程桩号。

（公式可以往下拖拉）左第4点左第3点Z4平距Z4高程断面号桩号里程X3Y3Z3D3H3X3Y31K662+000.000002K662+020.000003K662+026.000004K662+040.000005K662+060.000006K662+080.000007K662+100.000008K662+120.000009K662+140.0000010K662+155.0000011K662+160.0000012K662+180.0000013K662+190.0000014K662+200.0000015K662+220.0000016K662+240.0000017K662+260.0000018K662+280.0000019K662+300.0000020K662+320.0000021K662+340.0000022K662+360.0000023K662+380.0000024K662+400.0000025K662+415.0000026K662+420.0000027K662+440.0000028K662+450.0000029K662+454.0000030K662+460.0000031K662+480.0000032K662+500.0000033K662+520.0000034K662+540.0000035K662+560.0000036K662+575.0000037K662+580.0000038K662+600.0000039K662+620.0000040K662+640.0000041K662+660.0000042K662+680.0000043K662+695.0000044K662+710.0000045K662+720.0000046K662+740.0000047K662+760.0000048K662+780.0000049K662+800.0000050K662+820.0000051K662+840.0000052K662+860.0000053K662+880.0000054K662+900.0000055K662+920.0000056K662+940.0000057K662+960.0000058K662+980.0000059K663+000.0000060K663+020.0000061K663+040.0000062K663+060.0000063K663+080.0000064K663+090.0000065K663+102.57000101112131415161718左第2点左第1点Z3平距Z3高程Z2平距Z2高程Z3D3H3X2Y2Z2D2H2X10000351585800003515833000035158270000351581800003515799000035157760000351575900000000000000003515693003515677467919454.306-11.2335454.3063515679000035156680000351566000003515640000035156170000000000000000000000000000351548600003515454000035154400000351543600003515416003515405467900444.64-14.0616444.643515407000035154010000351539500003515375000035153550000351533500003515316000035152960000351528100003515276000035152560000351523600003515216000035151960000351517600003515161000035151461、原始数据表附注：

本表请输入对应点的X,Y,Z坐标及里程桩号。

（公式可以往下拖拉）左第3点0000351513900003515116000035150970000351507700003515057003515037467867.9451.61-11.5225451.613515037003515015467865.6451.646-11.6126451.6463515017003514998467858.9451.152-6.04429451.1523514998003514976467862.2450.277-11.3641450.2773514977003514957467859.4449.222-9.81356449.2223514958003514938467858.7448.286-10.0047448.2863514938003513295467811.8444.607-1627.71444.6073514919003514898467858.2449.418-12.6187449.4183514896003514877467857.5452.139-13.979452.1393514878003514857467847.1448.825-6.43892448.8253514858003514837467849.2449.64-9.32848449.6435148370000351481800003514799000035147770000351476800003514756192021222324252627左中线Z1平距Z1高程Z0平距Z0高程Y1Z1D1H1X0Y0Z0D0H0467953450.417-30.4753450.4173515859.004467922.471451.3270451.327467942450.232-21.8986450.2323515839.067467920.884451.0560451.056467943450.285-22.8416450.2853515833.086467920.408450.4530450.453467938450.385-18.7222450.3853515819.130467919.297450.7370450.737467935451.327-16.8668451.3273515799.193467917.710451.6490451.649467935450.654-18.8216450.6543515779.256467916.123451.460451.46467927450.826-12.1419450.8263515759.319467914.536456.3270456.327000000000000467915452.707-7.92087452.7073515699.509467909.775452.8430452.843467913454.157-4.91601454.1573515679.572467908.188452.450452.45467914451.756-7.22249451.7563515669.603467907.395452.0080452.008467924452.365-16.9149452.3653515659.635467906.601451.7450451.745467925.9451.403-20.8923451.4033515639.698467905.014451.2990451.299467914450.73-10.5516450.733515619.761467903.427450.6660450.666003515599.824467901.840452.1320452.132003515579.887467900.253000000000000000000467913444.464-21.7485444.4643515480.202467892.319445.540445.54467908442.412-18.1649442.4123515460.265467890.732442.5250442.525467908441.711-18.9458441.7113515445.313467889.542441.580441.58467904441.719-15.7468441.7193515440.328467889.145441.9890441.989467899444.673-12.4295444.6733515420.391467887.558445.0780445.078467888444.862-3.85614444.8623515410.423467886.764444.9270444.927467899444.866-13.4615444.8663515406.436467886.447444.8050444.805467896444.686-11.4043444.6863515400.455467885.971444.8170444.817467896444.808-12.6779444.8083515380.518467884.384444.9440444.944467893445.415-11.8185445.4153515360.581467882.797445.2520445.252467890445.355-10.5887445.3553515340.644467881.210445.4490445.449467888445.15-9.07089445.153515320.707467879.623445.5970445.597467886445.528-9.03991445.5283515300.770467878.036445.8570445.857467884445.965-8.41269445.9653515285.817467876.846445.9890445.989467881445.994-6.3377445.9943515280.833467876.449446.1670446.167467881446.242-7.6322446.2423515260.896467874.862446.2840446.284467879446.507-7.45384446.5073515240.959467873.275446.5450446.545467878446.334-7.70543446.3343515221.022467871.688446.4630446.463467876446.085-7.98736446.0853515201.085467870.101446.3210446.321467874446.608-7.55362446.6083515181.148467868.514446.5530446.553467874446.905-8.54435446.9053515166.195467867.324447.1340447.134467873445.779-8.96814445.7793515151.243467866.134446.6290446.629左第1点467873446.001-7.72548446.0013515141.274467865.341446.4540446.454467871445.961-9.06334445.9613515121.337467863.754446.6960446.696467869.2446.26-8.44891446.263515101.400467862.167446.7730446.773467867.5446.471-8.26313446.4713515081.4634678