如何CAD批量畫道路橫斷面圖.xls

設想：1-偏距等差100處理，2-UCS C 0,4,PL中的C為閉合，能否用空格代替或N代替（ 新建的意思，new） 3-另外那個0，4是什么意思 這是需要驗證的東西 pline 33.172,383.786 26.776,385.447 17.625,385.495 8.249,385.407 0,385.3 -8.711,385.093 -21.055,384.389 -34.625,382.754 Ucs N 0,-20 pline 38.653,383.38 28.817,385.474 14.619,385.506 6.378,385.403 0,385.275 -8.225,385.296 -25.581,385.1 -39.688,384.977 Ucs N 0,-20 pline 38.653,383.38 28.817,385.474 14.619,385.506 6.378,385.403 0,385.275 -8.225,385.296 -25.581,385.1 -39.688,384.977 就用空格代替 設想：1-偏距等差100處理，2-UCS C 0,4,PL中的C為閉合，能否用空格代替或N代替（ 新建的意思，new） 3-另外那個0，4是什么意思 這是需要驗證的東西 K0+0.00855332949513740.3748.8119 K0+0.04245332953513748.5751.2564 K0+0.05945332959513759.5752.3397 K0+0.07645332950513741.7748.9529 K0+0.07645332943513727.7749.2128 K0+0.07645332940513722.6748.6211 K0+0.09345332949513739.5748.906 K0+0.09345332948513737.8750.2571 K0+0.09345332947513737.2750.3512 K0+0.12735332944513731.3749.5045 K0+0.17825332941513723.7748.741 K0+0.19525332960513763.3752.6825 K0+0.24615332951513744750.7707 K0+0.24615332957513756.1751.9259 K0+0.31405332946513733.9750.1084 K0+0.36495332955513752.5751.5642 K0+1.04385332949513742.2749.0809 K0+1.31535332948513740.1748.9891 K0+100.00675332870513785748.5685 K0+120.00765332867513804.8749.2051 K0+120.00765332893513808.3752.1712 K0+120.07315332870513805.3749.5958 K0+120.09495332874513805.8750.1126 K0+120.16035332888513807.7751.6205 K0+120.20395332884513807.2751.0158 K0+120.22575332879513806.6750.6052 K0+120.22585332864513804.5748.8923 K0+120.22595332859513804748.3967 K0+120.22605332855513803.2747.926 K0+120.22615332850513802.5747.4973 K0+120.22625332846513801.9747.0307 K0+120.22635332842513801.5746.605 K0+120.22645332845513781.7745.9973 K0+120.22655332849513782.4746.442 K0+120.22665332854513783.1746.9406 K0+120.22675332859513783.6747.5353 K0+120.22685332864513784.3747.9969 K0+120.22695332868513784.8748.4606 K0+120.22705332874513785.4749.0692 K0+120.22715332879513786.2749.5218 K0+120.22725332884513787.2750.1494 K0+120.22735332889513787.6750.6641 K0+120.22745332894513788.1751.2487 K0+120.22755332898513789751.7484 K0+120.22765332891513776.3750.4623 K0+120.22775332890513775.3750.2814 K0+120.22785332889513774.4750.0925 K0+120.22795332888513773.2749.9186 K0+120.22805332889513771.1749.8126 K0+120.22815332886513768.7749.5198 K0+120.22825332884513769.1749.171 K0+120.22835332883513771.7749.222 K0+120.22845332883513773.6749.3059 K0+120.22855332884513775.5749.5728 K0+120.22865332884513777.2749.7407 K0+120.22875332886513777.8750.0666 K0+120.22885332887513778.1750.2605 K0+120.22895332888513779.6750.3034 K0+120.22905332889513781.8750.3183 K0+120.22915332890513783.2750.5701 K0+120.22925332891513781751.3272 K0+120.22935332890513779750.9853 K0+120.22945332889513777.1750.9524 K0+120.22955332889513776.8750.9254 K0+120.22965332888513776750.4235 K0+120.22975332887513775.8750.7566 K0+120.22985332887513775750.6436 K0+120.22995332887513773.7750.1317 K0+120.23005332886513771.8750.5487 K0+120.23015332886513771.1750.4358 K0+120.23025332889513776.7750.8574 K0+120.23035332886513776.3750.4776 K0+120.23045332884513776749.4828 K0+120.23055332879513775.4749.2601 K0+120.23065332875513774.8748.8334 K0+120.23075332873513774.5748.5686 K0+120.23085332868513773.8748.1759 K0+120.23095332865513773.2747.7962 K0+133.55245332873513819.3751.1332 K0+133.57425332869513818.7750.7455 K0+133.68335332854513816.9749.3306 K0+133.72695332863513818.1750.164 K0+133.72695332849513816.2748.641 K0+133.72695332847513815.9748.3032 K0+133.74875332859513817.6749.6983 K0+133.74875332883513820.8752.1245 K0+133.83605332878513820.2751.6608 K0+133.85445332865513818.5750.3768 K0+133.91455332887513821.6752.6182 K0+133.95965332891513822.2752.9679 K0+139.66845332867513825.5751.1745 K0+139.72855332847513816.7748.4311 K0+139.74355332871513827.4751.7502 K0+139.87875332874513829.2752.1049 K0+139.99895332864513824.4750.7847 K0+140.01395332878513831.1752.6445 K0+140.02905332862513823.9750.6218 K0+140.02905332850513818.2749.1309 K0+140.14925332858513822749.9262 K0+140.16425332887513836753.8697 K0+140.17925332854513820.2749.6525 K0+140.17925332882513833.2753.0932 K0+140.17925332885513835.1753.6579 K0+141.41115332851513819749.2508 K0+141.44125332884513837.4753.7519 K0+141.47125332859513823.6750.1201 K0+141.48625332880513835.4753.2003 K0+141.51635332863513825.8750.8247 K0+141.56905332845513815.9748.1643 K0+141.58915332848513817.3748.563 K0+141.62945332876513833.5752.7316 K0+141.64955332872513831.3752.0939 K0+141.64955332885513838.5753.9598 K0+141.68975332866513827.5751.1875 K0+141.68975332868513828.8751.5113 K0+141.70995332855513821.7749.8954 K0+19.90945332928513737.1749.3319 K0+19.93935332933513758751.5959 K0+19.96925332930513744.5750.1325 K0+19.96925332936513767.9752.5244 K0+19.99915332930513745.9750.2631 K0+2.35065332948513744.7750.7809 K0+2.75795332947513742.2750.53 K0+20.02905332932513753.4751.1251 K0+20.05895332923513721.2747.7027 K0+20.05895332926513732.1748.8231 K0+20.08885332925513726.2748.2594 K0+20.11875332931513749750.6563 K0+20.14865332934513762.9752.1016 K0+20.17855332937513772.3752.8972 K0+20.20845332929513741.7749.8227 K0+3.04655332946513739.1750.1542 K0+39.85485332917513775.8752.3224 K0+39.91465332915513767.9751.6308 K0+4.25155332941513725.9748.958 K0+4.26845332948513753.8751.3876 K0+4.30245332949513757.8751.9024 K0+4.31945332944513737.4750.1794 K0+4.33635332945513741.8750.6642 K0+4.33635332952513766.1752.763 K0+4.35985332943513734.6749.8475 K0+4.41965332942513730.1749.3528 K0+4.41965332945513740.2750.7463 K0+4.41965332946513745.1750.977 K0+4.41965332947513749.3751.1138 K0+4.44955332940513722.7748.6131 K0+4.44955332950513761.7752.2682 K0+40.00435332911513751749.9413 K0+40.00435332910513747.5749.6798 K0+40.03425332914513763.5751.2161 K0+40.03425332916513772.1751.9546 K0+40.06415332908513739.6748.8342 K0+40.12395332912513755.3750.3595 K0+40.12395332913513759.3750.7043 K0+40.12395332904513727747.7068 K0+40.18375332906513734.7748.4365 K0+40.18375332905513731.2747.9866 K0+40.21365332909513743.9749.267 K0+41.14065332914513769.3751.5929 K0+41.26035332915513771.6751.7948 K0+41.85835332913513767.4751.38 K0+42.51625332914513773.6752.0447 K0+42.57605332914513774.4751.9927 K0+44.19085332911513769.4752.4991 K0+44.25065332911513768.8752.2931 K0+44.57955332911513769.1752.4381 K0+44.60945332910513765.9751.5093 K0+44.60945332912513772.7752.9129 K0+44.75895332911513772.8752.9069 K0+45.44675332912513777.4752.0548 K0+45.50655332912513779.4752.1997 K0+46.88205332909513771.5751.6992 K0+46.94185332910513775.8752.468 K0+47.00175332908513767.5751.0164 K0+47.39045332908513770.1751.5053 K0+47.65955332911513781.1751.9308 K0+47.89875332910513778752.8829 K0+49.78265332907513774.9751.5312 K0+50.11165332908513779.4752.177 K0+50.23125332907513778.5751.9531 K0+55.37455332901513775.7751.3636 K0+55.46425332901513773.7751.0697 K0+55.79325332902513778.2751.5525 K0+56.09225332901513776751.5656 K0+56.15205332901513779.6751.5394 K0+56.18195332902513784.4751.7852 K0+56.30155332902513781.7751.8594 K0+56.72025332899513772.9750.8898 K0+57.43795332900513779.7751.9955 K0+57.43795332899513775.1751.8698 K0+57.70705332901513782.2752.3494 K0+58.03595332899513776.1751.7188 K0+58.36495332901513785.3751.6113 K0+58.45465332898513773.9750.5649 K0+59.02275332900513784.1752.6104 K0+59.65075332897513776.5750.8658 K0+59.91985332886513734.9747.1689 K0+59.91985332896513773.3750.687 K0+59.97965332889513747.5748.3243 K0+60.00955332891513756.1749.1905 K0+60.00955332891513755749.0599 K0+60.00955332895513768.9750.2582 K0+60.03945332888513743.4747.9015 K0+60.03945332890513751.5748.6841 K0+60.03945332892513759.9749.5067 K0+60.03945332898513780751.4317 K0+60.06935332887513738.9747.5047 K0+60.06935332893513764.3749.9395 K0+60.09925332885513731.2746.8761 K0+60.12915332897513779.4751.3187 K0+60.33855332897513777.4751.2378 K0+65.42205332890513772.5750.1405 K0+65.45195332891513775.7750.3883 K0+65.48185332881513738.2747.1581 K0+65.51175332887513760.8749.155 K0+65.51175332889513768.6749.7677 K0+65.57155332888513764.7749.4838 K0+65.57155332884513750748.1266 K0+65.57155332883513745.9747.7818 K0+65.59805332886513757.5748.8348 K0+65.59805332879513733.6746.7394 K0+65.62105332885513754.1748.4904 K0+65.62105332882513742.1747.479 K0+79.85855332853513751.1746.1137 K0+79.90465332856513753.2746.4414 K0+79.97375332885513772.7749.9628 K0+79.97375332862513757.3747.0289 K0+79.99675332874513765.7748.3864 K0+80.01985332887513774.2750.5536 K0+80.01985332865513759.8747.3946 K0+80.04285332877513767.3748.6425 K0+80.06595332883513771.5749.214 K0+80.11195332872513764.3748.122 K0+80.11195332859513755.4746.8022 K0+80.15805332880513769.7748.8042 K0+80.20415332869513762.2747.7743 K0+81.49425332890513776.2750.5894 K0+89.05075332865513773.2747.8022 K0+89.05075332861513772.7747.4525 K0+89.05075332853513771.5746.6981 K0+89.11985332857513772.2747.0998 K0+89.11985332848513771.1746.2764 K0+89.11985332845513770.6745.8397 K0+89.18835332871513774.2748.4394 K0+96.40785332899513785.2751.6664 偏距高差 7.61.8 7.6,1.8 3.61.8 3.6,1.8 0.90 0.9,0 00 0,0 -0.90 -0.9,0 -3.61.8 -3.6,1.8 -5.11.8 -5.1,1.8 ucs n 0,-20 pl 畫完后，對整體用命令explode,將多段線打散。不符合條件的線 刪除。另外，超出原地面線或低于原地面線的部分怎么處理，按 坡比多少處理，看圖紙。 畫完后，對整體用命令explode,將多段線打散。不符合條件的線 刪除。另外，超出原地面線或低于原地面線的部分怎么處理，按 坡比多少處理，看圖紙。 高差偏距 K0+0752.68253.8370-25.651 752.33973.4950-21.493 751.92593.0810-17.588 751.56422.7190-13.433 751.25642.4110-9.222 750.77071.9260-4.015 750.78091.9360-3.733 749.08090.2360-1.551 748.95290.1080-1.493 748.8119 -0.0330-0.007 748.98910.14400.807 748.9060.06100.918 750.25711.41202.879 750.35121.50603.494 750.10841.26307.315 749.50450.659010.169 749.21280.368014.138 748.741-0.104018.636 748.6211 -0.224019.877 K0+004.4752.7633.9190-25.114 752.26823.4240-20.496 751.90243.0580-16.521 751.38762.5430-12.387 751.11382.2700-7.652 750.9772.1330-3.353 750.66421.82000.014 750.74631.90201.777 750.15421.31002.501 750.17941.33504.581 749.84751.00307.553 749.35280.509012.146 748.9580.114016.492 748.6131 -0.231019.83 K0+020752.89724.0560-27.259 752.52443.6830-22.787 752.10163.2600-17.632 751.59592.7550-12.595 751.12512.2840-7.807 750.65631.8150-3.232 750.26311.4220-0.013 750.13251.29101.353 749.82270.98104.331 749.33190.49009.067 748.8231 -0.018014.252 748.2594 -0.582020.33 747.7027 -1.139025.493 K0+040752.32243.4880-25.722 751.95463.1200-21.798 751.63082.7960-17.476 751.21612.3810-12.98 750.70431.8690-8.587 750.35951.5250-4.43 749.94131.10600.015 749.67980.84503.566 749.2670.43207.424 748.8342 -0.001011.851 748.4365 -0.398016.892 747.9866 -0.848020.521 747.7068 -1.128024.889 K0+060751.43172.5970-24.66 751.31872.4840-24.109 751.23782.4040-21.973 750.86582.0320-21.177 750.6871.8530-17.746 750.25821.4240-13.273 749.93951.1050-8.484 749.50670.6720-3.923 749.19050.3560-0.006 749.05990.22601.109 748.6841 -0.15004.741 748.3243 -0.51008.888 747.9015 -0.933013.154 747.5047 -1.330017.811 747.1689 -1.665021.899 746.8761 -1.958025.817 K0+065.59750.38831.5550-18.865 750.14051.3070-15.552 749.76770.9340-11.481 749.48380.6500-7.393 749.1550.3220-3.391 748.83480.00100.009 748.4904 -0.34303.578 748.1266 -0.70707.764 747.7818 -1.052012.066 747.479-1.354016.003 747.1581 -1.675019.97 746.1137 -2.720020.938 746.7394 -2.094024.807 K0+080750.58941.7590-18.49 750.55361.7230-15.239 749.96281.1320-12.549 749.2140.3830-10.378 748.8042 -0.0260-7.014 748.6425 -0.1880-2.817 748.3864 -0.4440-0.017 748.122-0.70902.737 747.7743 -1.05606.783 747.3946 -1.436010.732 747.0289 -1.802015.106 746.8022 -2.029018.806 K0+089.18750.85742.0280-17.889 750.47761.6490-14.985 749.48280.6540-12.816 749.26010.4310-8.301 748.83340.0040-4.248 748.5686 -0.2610-1.477 748.4394 -0.39000.001 748.1759 -0.65302.788 747.8022 -1.02706.434 747.7962 -1.03306.449 747.4525 -1.377010.435 747.0998 -1.729014.71 746.6981 -2.131018.762 746.2764 -2.553022.996 745.8397 -2.989026.864 K0+100751.24872.4220-24.31 750.66411.8370-19.588 750.14941.3220-14.256 749.52180.6950-9.265 749.06920.2420-4.615 748.5685 -0.2590-0.003 748.4606 -0.36601.336 747.9969 -0.83006.009 747.5353 -1.292010.604 746.9406 -1.886015.688 746.442-2.385020.471 745.9973 -2.830024.985 K0+120752.17123.3480-26.23 751.62052.7970-21.016 751.01582.1920-16.782 750.60521.7820-11.84 750.11261.2890-7.212 749.59580.7720-3.251 749.20510.3810-0.016 748.89230.06903.166 748.3967 -0.42707.938 747.926-0.898012.643 747.4973 -1.326017.188 747.0307 -1.793021.462 746.605-2.219025.636 K0+133.85752.96794.1470-26.162 752.61823.7970-22.36 752.12453.3030-17.639 751.66082.8400-13.159 751.13322.3120-8.201 750.74551.9240-3.463 750.37681.5560-0.015 750.1641.34302.543 749.69830.87706.304 749.33060.510011.176 748.641-0.180016.65 748.3032 -0.518018.748 K0+140753.86975.0500-26.181 753.65794.8380-24.018 753.09324.2730-19.922 752.64453.8240-15.763 752.10493.2850-11.636 751.75022.9300-7.674 751.17452.3540-3.44 750.78471.9650-0.001 750.62181.80201.355 749.92621.10605.778 749.65250.832010.138 749.13090.311014.624 748.4311 -0.389018.126 K0+141.5753.95985.1400-25.621 753.75194.9320-23.935 753.20034.3800-19.616 752.73163.9120-15.586 752.09393.2740-11.097 751.51132.6910-5.938 751.18752.3670-3.332 750.82472.0050-0.002 750.12011.30004.279 749.89541.07508.654 749.25080.431013.506 748.563-0.257017.174 748.1643 -0.656019.977 新坐標，直接復制此列，粘貼在CAD中，自動批量畫圖 -25.651,3.837 實測數(shù)據(jù) -21.493,3.495 -17.588,3.081 -13.433,2.719 -9.222,2.411 -4.015,1.926 -3.733,1.936 -1.551,0.236 -1.493,0.108 -0.007,-0.033 0.807,0.144CAD中偏距為X 0.918,0.061 2.879,1.412 3.494,1.506 7.315,1.263 10.169,0.659 14.138,0.368 18.636,-0.104 19.877,-0.224 7.6,1.8 標準橫斷面 3.6,1.8 0.9,0 0,0 -0.9,0 -3.6,1.8 -5.1,1.8 ucs n 0,-20 pl -25.114,3.919 -20.496,3.424 -16.521,3.058 -12.387,2.543 -7.652,2.27 -3.353,2.133 0.014,1.82 1.777,1.902 2.501,1.31 4.581,1.335 7.553,1.003 12.146,0.509 16.492,0.114 19.83,-0.231 7.6,1.8 3.6,1.8 0.9,0 0,0 -0.9,0 -3.6,1.8 -5.1,1.8 ucs n 0,-20 pl -27.259,4.056 -22.787,3.683 -17.632,3.26 -12.595,2.755 -7.807,2.284 -3.232,1.815 -0.013,1.422 1.353,1.291 4.331,0.981 9.067,0.49 14.252,-0.018 20.33,-0.582 25.493,-1.139 7.6,1.8 3.6,1.8 0.9,0 0,0 -0.9,0 -3.6,1.8 -5.1,1.8 ucs n 0,-20 pl -25.722,3.488 -21.798,3.12 -17.476,2.796 -12.98,2.381 -8.587,1.869 -4.43,1.525 0.015,1.106 3.566,0.845 7.424,0.432 11.851,-0.001 16.892,-0.398 20.521,-0.848 24.889,-1.128 7.6,1.8 3.6,1.8 0.9,0 0,0 -0.9,0 -3.6,1.8 -5.1,1.8 ucs n 0,-20 pl -24.66,2.597 -24.109,2.484 -21.973,2.404 -21.177,2.032 -17.746,1.853 -13.273,1.424 -8.484,1.105 -3.923,0.672 -0.006,0.356 1.109,0.226 4.741,-0.15 8.888,-0.51 13.154,-0.933 17.811,-1.33 21.899,-1.665 25.817,-1.958 7.6,1.8 3.6,1.8 0.9,0 0,0 -0.9,0 -3.6,1.8 -5.1,1.8 ucs n 0,-20 pl -18.865,1.555 -15.552,1.307 -11.481,0.934 -7.393,0.65 -3.391,0.322 0.009,0.001 3.578,-0.343 7.764,-0.707 12.066,-1.052 16.003,-1.354 19.97,-1.675 20.938,-2.72 24.807,-2.094 7.6,1.8 3.6,1.8 0.9,0 0,0 -0.9,0 -3.6,1.8 -5.1,1.8 ucs n 0,-20 pl -18.49,1.759 -15.