测量数据绘制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.463467860.580446.9010446.901467866.9448.504-9.03658448.5043515061.527467858.993448.660448.66467862.9451.431-7.00116451.4313515041.590467857.406448.0890448.089467860451.297-6.39083451.2973515021.653467855.819448.7420448.742467858.4450.281-5.66874450.2813515001.716467854.232449.5410449.541467856.1450.367-5.7217450.3673514981.779467852.645449.3480449.348467854449.236-5.18851449.2363514961.842467851.058448.3820448.382467857.2448.344-8.51584448.3443514941.905467849.471448.0330448.033467858.2448.028-10.6784448.0283514921.968467847.884446.9540446.954467852446.81-8.1546446.813514902.031467846.297446.7970446.797467850.6447.208-7.03112447.2083514882.094467844.710446.6140446.614467845.9447.571-4.98262447.5713514862.157467843.124447.1970447.197467844449.175-5.4074449.1753514842.220467841.544447.1020447.102467849.9447.686-10.6639447.6863514822.281467839.974446.8490446.849467848.3447.144-10.3992447.1443514802.342467838.419447.3180447.318467844.1446.126-8.7621446.1263514782.401467836.883446.4590446.459467843445.998-8.08272445.9983514772.430467836.124446.530446.53467842.2445.744-8.12703445.7443514759.895467835.180446.5560446.5562829303132333435右第1点右第2点Y1平距Y1高程X1Y1Z1D1H1X2Y2Z23515863467896451.81626.9167796451.8163515864467891453.4453515859467853451.66770.41664113451.6673515854467853451.49870.74637606451.4983515842467851452.13671.75651871452.1363515818467842452.75278.35451138452.7523515793467840452.49677.75900421452.4963515769467847452.17568.59892164452.1753515772467831456.8043515740467899450.3343546738.558450.3343515752467829455.4153515721467885450.5263546718.728450.5263515731467826454.0453515706467882450.5423546703.265450.5423515716467829454.4093515708467832451.7678.47056109451.763515691467830451.47979.17944683451.4793515683467830451.19278.97397328451.1923515674467829451.16278.52617496451.1623515661467829.2451.00678.70079843451.0063515642467826450.66880.79470231450.6683515607467894450.4110.31158693450.413515615467822451.1783515580467893450.947.364966056450.943515582467887452.333515560467887451.4393546558.918451.4393515572467818452.0583515539467879451.4153546537.498451.4153515549467818451.17800003515485467850446.02842.53290324446.0283515459467851442.84639.2589297442.8463515440467850442.02240.033462442.0223515436467856442.47533.43203519442.4753515418467862444.95325.34307363444.9533515407467864445.01723.54406178445.0173515403467864444.94822.77893501444.9483515395467865444.921.77322631444.93515377467866444.80718.20454872444.8073515357467866445.32217.48685578445.3223515338467865445.4916.6929268445.493515318467864445.82916.14689571445.8293515301467862445.93215.83464572445.9323515288467856446.04120.72802094446.0413515281467853445.99923.02089629445.9993515260467853446.22722.26695938446.2273515240467851446.49722.03833544446.4973515220467850446.65721.88374374446.6573515199467847446.52122.97543351446.5213515180467843447.13325.46186609447.1333515168467836447.20131.72461899447.2013515152467834446.91332.51534138446.9133515136467833447.16132.51208872447.1613515121467831.9446.84831.89932955446.8483515103467830447.85432.1982627447.8543515081467828.4447.43432.17206684447.4343515060467827.2446.9531.78465046446.953515040467824.5447.22132.95651664447.2213515020467822.2447.11833.6562143447.1183515003467820.2446.59334.07237545446.5933514978467817.9446.27934.87856195446.2793514963467816.5446.12434.59413482446.1243514944467814.3446.5235.23281852446.523514924467811446.87136.98507942446.8713514901467809.4447.26736.95605444447.2673514886467808.5447.18836.41897398447.1883514864467803.1447.47240.03878481447.4723514837467807448.42735.00233394448.4273514817467816.9448.14123.64729483448.1413514794467815.6447.87224.36550911447.8723514779467828.4449.6219.057678124449.6213514779467818.7450.2093514769467828.5446.5248.498856394446.5243514756467822.7445.75913.04715272445.759363738394041424344右第3点右第4点Y2平距Y2高程Y3平距Y3高程D2H2X3Y3Z3D3H3X4Y431.48420329453.4453515869467854452.39469.47789452.3940000000000000000000084.12067297456.804003546742.004455.415003546720.309454.045003546706.231454.4090000000000000000000000000081.00851494451.1780013.76179251452.333515583467881451.94719.57884451.94735155864678743546562.225452.058003546538.842451.17800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000右第2点00000000000000000000000000000000000000000000000000000000000000000000000018.45233996450.2090000000000454647484950515253右第5点Y4平距Y4高程Y5平距Y5高程Z4D4H4X5Y5Z5D5H500000000000000000000000000000000000000000000000000000000000000000000450.72126.79135450.7213515595467821450.87680.38716450.87600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000右第4点0000000000000000000000000000000000000000000000000000000000000000000000000000000000005455565758592、平距转置表附注：

本表只需向右拖拉断面号1234左第4点平距0000左第3点平距0000左第2点平距0000左第1点平距-30.47530469-21.8985953-22.84157457-18.72224476左中线0000右第1点平距26.916779670.4166411370.7463760671.75651871右第2点平距31.48420329000右第3点平距69.47788809000右第4点平距0000右第5点平