交點法線路正反算V2.7

1、線線路路坐坐標標正正算算成成果果表表序序號號點點號號里里程程偏偏距距高高程程偏偏差差（向向上上+ +）切切向向角角設設計計高高程程1001K32+000.0003314014390.2602002K32+100.0003314014390.1203003K32+200.0003303226389.9694004K32+300.0003225955388.6495005K32+400.0003144849386.6856006K32+500.0003063742384.7217007K32+600.0002982636383.0558008K32+700.0002901530382.599900

2、9K32+800.000282423382.19910010K32+900.0002.112741736381.79911011K33+000.000PEG Error!PEG Error!12012K33+100.000272474381.08013K33+200.0002724710380.68014K33+300.0002755929380.28015K33+400.0000.00012804558379.88016K33+500.0002844616379.48417K33+600.0002845637379.07418K33+700.0002845637378.67819K33+80

3、0.0002845637378.42020K33+900.0002845637378.22021K34+000.0002845637378.02022K34+100.0002845637377.82023K34+200.0002845637377.62024K34+300.0002845637377.42025K34+400.0000.0912845637377.22026K34+500.0002845637377.02027K34+600.0002845637376.82028K34+700.0002845637376.57729K34+800.0002845637374.21030K34+

4、900.0002845637370.61031K35+000.0002845637367.01032K35+100.0002845637363.41033K35+200.0002845637359.81034K35+300.0002845637356.21035K35+400.0002845637352.74236K35+500.0002814036350.87237K35+600.0002732942350.11738K35+700.000265283348.19639K35+800.0002631846345.29640K35+900.0002642913342.39641K36+000.

5、000269239339.49642K36+100.00027000336.40243K36+200.00027000332.42544K36+300.00027000329.07845K36+400.00027000327.69046K36+500.00027000327.48147K36+600.00027000327.28148K36+700.000Out Of Range!327.08149K36+800.000Out Of Range!326.88150K36+900.000Out Of Range!326.681X X坐坐標標Y Y坐坐標標高高程程85826.422272005.7

6、851390.26085914.445571958.3310390.12086002.268771910.5136389.96986086.028871856.0597388.64986161.309971790.4019386.68586226.476371714.6951384.72186280.200471630.4817383.05586321.387771539.4773382.59986349.198871443.5361382.19986363.193371344.6212383.909PEG Error!PEG Error!#VALUE!86372.535071164.9527

7、381.08086377.395771065.0709380.68086384.386570965.3339380.28086398.863570866.4204379.88086421.435270769.0255379.48486448.138770668.7720379.07486473.925570572.1540378.67886499.712370475.5360378.42086525.499270378.9180378.22086551.286070282.3000378.02086577.072870185.6820377.82086602.859770089.0639377

8、.62086628.646569992.4459377.42086654.521269895.8514377.22086680.220169799.2099377.02086706.007069702.5919376.82086731.793869605.9739376.577線線路路坐坐標標正正算算成成果果表表86757.580669509.3559374.21086783.367469412.7379370.61086809.154369316.1199367.01086834.941169219.5019363.41086860.727969122.8839359.81086886.51

9、4869026.2659356.21086912.301668929.6478352.74286936.408968832.6189350.87286949.593368733.6016350.11786948.603868633.7116348.19686937.925568534.2932345.29686926.754668434.9220342.39686921.605768335.0949339.49686921.400068239.5419336.40286921.400068139.5419332.42586921.400068039.5419329.07886921.40006

10、7939.5419327.69086921.400067839.5419327.48186921.400067739.5419327.281Out Of Range!Out Of Range!327.081Out Of Range!Out Of Range!326.881Out Of Range!Out Of Range!326.681線線路路坐坐標標反反算算成成果果表表序序號號點點號號X X坐坐標標Y Y坐坐標標高高程程切切向向角角里里程程1T2ZD1 86550.157270280.5653382.1972845637K34+001.3852T2B586555.122770264.9659

11、377.5472845637K34+017.7373186544.803170292.7146373.8482845637K33+988.2664286543.383870296.2102373.8842845637K33+984.5225386542.543670301.5858373.8652845637K33+979.1126486541.152070307.2407373.9722845637K33+973.2897586545.040270307.7890373.5842845637K33+973.7628686545.649470304.5549373.5312845637K33+

12、977.0449786546.669670299.1244373.5402845637K33+982.55410886547.981470292.3927373.6192845637K33+989.39611986554.145270295.1918372.6482845637K33+988.281121086551.336470310.1824372.5712845637K33+973.073131186549.710770305.0486372.6852845637K33+977.614141286550.697470300.7559372.7162845637K33+982.016151

13、386551.160570295.5996372.8722845637K33+987.118161486555.882970311.0036372.6242845637K33+973.452171586557.228770307.6254372.7242845637K33+977.063181686559.001770303.6251372.8472845637K33+981.385191786560.641770300.0719372.9272845637K33+985.241201886561.843570296.8847372.9522845637K33+988.631211986567

14、.351770299.2804373.8102845637K33+987.737222086566.456370303.6652373.8812845637K33+983.269232186565.091470308.4176373.8942845637K33+978.325242286564.048770313.3611373.9002845637K33+973.280252386566.477670306.1794374.5072845637K33+980.845262486541.190770305.6081374.2892845637K33+974.877272586561.83677

15、0303.4202373.2262845637K33+982.315282686560.758870309.2158373.3582845637K33+976.437292786562.925870305.8417373.6542845637K33+980.256302886564.635370300.0826373.5642845637K33+986.261312986565.547070298.1156373.6692845637K33+988.397323086562.391670298.4597373.0532845637K33+987.250333186561.097670301.9

16、101373.0182845637K33+983.583343286557.344970290.2839376.1832845637K33+993.848353386551.214870289.7278376.2032845637K33+992.805363486551.585970311.7976372.8762845637K33+971.577373586554.033570287.4606376.0882845637K33+995.722383686547.357970288.7762376.3092845637K33+992.730393786552.451270288.7824376

17、.1942845637K33+994.037403886560.832470292.3734376.1742845637K33+992.72941186540.118470309.5446376.6672845637K33+970.79742286541.060570305.9815381.3242845637K33+974.48243386541.961570305.8455387.5142845637K33+974.84644486544.481170311.1032392.1852845637K33+970.41645586543.186970318.0656392.5992845637

18、K33+963.35546686539.216770319.6547389.2362845637K33+960.79647786536.675870322.9906384.8982845637K33+956.91848886537.147270320.9152381.4462845637K33+959.04549986539.102970313.3782380.0082845637K33+966.831501086544.317270325.3775393.9982845637K33+956.582511186547.641670326.9490394.7572845637K33+955.92

19、1521286549.041770318.8710394.7042845637K33+964.087531386550.461270309.7145394.5312845637K33+973.300541486552.093670303.0797394.5722845637K33+980.131551586555.728270307.0565394.5672845637K33+977.226561686557.243270314.2609393.5542845637K33+970.656571786557.227170323.1641392.1302845637K33+962.05058188

20、6558.987370328.5638388.9742845637K33+957.287591986562.023470319.1341388.0392845637K33+967.180602086563.511370314.4016387.6002845637K33+972.136612186560.881370311.2403391.8362845637K33+974.513622286557.866470305.9351394.1502845637K33+978.861632386562.129570319.9644387.3202845637K33+966.405642486562.5

21、94270321.4902377.2162845637K33+965.051652586563.958770316.4991377.9692845637K33+970.225662686561.684770324.7053380.1262845637K33+961.710672786559.827870331.2403379.6792845637K33+954.917682886557.182770341.7339378.9242845637K33+944.096692986561.916770323.8567381.8112845637K33+962.590703086545.8716702

22、87.7768377.7952845637K33+993.312713186545.895570287.7365382.1872845637K33+993.357723286546.333070287.0005385.4122845637K33+994.181733386547.005770289.1594388.6592845637K33+992.269743486551.739670290.8976393.2992845637K33+991.810753586555.945170290.9033394.5662845637K33+992.889763686555.157670293.389

23、2394.5782845637K33+990.284773786560.786070293.5348394.2812845637K33+991.595783886564.848770296.8221391.6692845637K33+989.466793986567.904570300.2037385.7852845637K33+986.987804086568.107370300.4269377.8822845637K33+986.824814186566.327170307.1465381.5412845637K33+979.872824286564.232870303.7050390.6

24、942845637K33+982.657834386559.459970307.3144393.4102845637K33+977.939844486567.035470304.5453379.2202845637K33+982.568設設計計高高程程高高程程偏偏差差（向向上上+ +）偏偏距距高高差差斷斷面面A A378.017-1.5384.179(2.062)377.985-0.763-0.438(2.837)378.044-3.578-4.1950.091378.051-4.048-4.1670.452378.062-3.474-4.1970.093378.074-3.360-4.102

25、(0.003)378.0730.538-4.4890.072378.0660.293-4.5350.179378.055-0.122-4.5150.270378.041-0.590-4.4220.311378.0446.087-5.3960.045378.0747.239-5.5030.082378.0654.344-5.3800.213378.0564.191-5.3400.195378.0463.308-5.1740.164378.07311.843-5.4490.164378.06612.272-5.3420.104378.05712.954-5.2100.058378.05013.62

26、2-5.1230.069378.04313.961-5.0910.093378.04519.901-4.2340.130378.05420.167-4.1720.068378.06320.073-4.1700.066378.07420.341-4.1730.069378.05820.836-3.5510.036378.070-3.743-3.7810.143378.05615.640-4.8300.162378.06716.093-4.7090.147線線路路坐坐標標反反算算成成果果表表378.06017.317-4.4060.163378.04817.483-4.4830.283378.04

27、317.857-4.3750.270378.04614.897-4.9930.168378.05314.537-5.0350.140378.0327.913-1.850(3.592)378.0351.847-1.831(2.824)378.0777.896-5.201(0.241)378.0293.985-1.940(3.137)378.035-2.125-1.725(1.475)378.0322.797-1.838(3.023)378.03511.821-1.860(3.407)378.079-3.764-1.4120.164378.071-3.7733.2530.173378.070-2.

28、9379.4430.186378.0790.85314.1060.125378.0931.39814.5060.136378.099-2.02911.1380.174378.106-3.6236.7920.137378.102-3.7033.3440.103378.086-3.7571.9210.157378.1074.37515.8910.046378.1087.99216.6490.103378.0927.26216.6120.122378.0746.27216.4570.109378.0606.13916.5130.188378.06610.67616.5010.109378.07913

29、.99715.4750.099378.09616.27814.0340.026378.10619.37110.8680.151378.08619.8739.9540.154378.07620.0909.5240.174378.07116.73413.7650.094378.06212.45316.0870.115378.08720.1899.2330.154378.09021.032-0.8740.232378.08021.063-0.1110.263378.09720.9822.0300.182378.11020.8731.5690.073378.13221.0230.7920.223378

30、.09520.9873.7160.187378.034-3.819-0.2380.219378.033-3.8064.1530.206378.032-3.5737.3800.188378.036-2.36710.6230.195378.0372.65515.2630.148378.0346.72016.5320.110378.0406.60016.5380.134378.03712.07616.2440.159378.04116.84913.6280.062378.04620.6737.7390.167378.04620.927-0.1650.127378.06020.9403.4800.14

31、0378.05518.02912.6390.152378.06414.34815.3460.133378.05520.9531.1650.153交交點點信信息息起起點點X X坐坐標標Y Y坐坐標標79032.474667552.9475序序號號交交點點點點號號X X坐坐標標Y Y坐坐標標前前緩緩和和曲曲線線圓圓曲曲線線半半徑徑后后緩緩和和曲曲線線1左JD3679156.318568003.216185800852左JD3779465.753968692.509785800853左JD3879823.078268923.447785700854左JD3980454.456269188.33973

32、01500305左JD4080572.569769243.8581301500306左JD4181378.951469582.1721301500307左JD4281490.196169623.4222301500308左JD4382767.545670159.328785675859左JD4482581.281871189.666484.65644.884.6510左JD4583193.740771664.633685.27805.285.2711左JD4683626.728972164.038684.68694.884.6812左JD4784245.412872349.325770.151

33、205.270.1513左JD4884445.656172431.883969.851194.869.8514左JD4984893.583572566.031970484.87015左JD5085310.011872284.18595515005516左JD5186345.243871726.0844857008517左JD5286385.197670904.59957012007018左JD5386962.310668742.2742857008519左JD5486921.400068393.34738510008520終點86921.400067697.8928里里程程斷斷鏈鏈信信息息K2

34、2+564.902圓圓曲曲線線偏偏移移量量序序號號來來向向樁樁號號去去向向樁樁號號屬屬性性1K23+197.277K23+198.846短鏈1.5692K24+355.665K24+366.293短鏈10.6283K25+072.907K25+072.897長鏈0.014K28+634.538K28+615.970長鏈18.5685K29+079.113K29+078.090長鏈1.0236K29+850.306K29+853.247短鏈2.9417K31+513.347K31+516.309短鏈2.9628K32+981.916K33+001.999短鏈20.0839K33+528.125K

35、33+524.376長鏈3.74910K36+050.387K36+054.833短鏈4.4460.1690.0910.1690.106豎豎曲曲線線參參數數隧隧道道斷斷面面參參數數縱縱坡坡點點號號變變坡坡點點樁樁號號變變坡坡點點高高程程豎豎曲曲線線半半徑徑斷斷面面A A( (初初支支) )1K22+478.012236.6125000序序號號X X坐坐標標Y Y坐坐標標2K22+975.000237.61230001-0.568-4.1043K23+325.000222.97850002-3.600-4.1044K23+595.000224.33850003-3.6005.2305K24+09

36、5.000246.5884-0.54312.7186K24+324.372256.8323000517.74312.7187K24+625.000257.4123000620.8005.2308K25+285.000279.8525000720.800-4.1049K26+185.000293.7725000817.768-4.10410K26+835.000293.772300011K27+106.107301.722500012K27+350.000306.3885000T2航站樓加深斷面初支13K27+973.920308.8725000以左線基準14K28+499.326322.122

37、500015K28+700.000329.60316K28+960.533338.442500017K29+195.000339.382500018K29+399.967345.12119K29+697.882353.52220K29+995.000361.7825000隧隧道道斷斷面面參參數數編編輯輯說說明明21K30+235.000363.100500022K30+500.134371.8441、一般的隧道斷面形狀主要有圓形和圓弧線段組成兩種形式。如果隧道形狀為圓形則僅需輸入圓心點相對于設計高程的坐標、圓的半徑即可，如下左圖：23K30+799.017381.74624K31+031.41

38、7389.500500025K31+496.679390.42926K31+779.642390.56927K32+234.642389.932500028K32+584.558383.061500029K33+400.000379.88030K33+729.642378.56131K34+235.000377.55032K34+735.000376.550300033K35+435.000351.350500034K35+645.000349.791500035K36+070.000337.595500036K36+315.000327.85150002、如果隧道由圓弧段組成則如上右圖，需逐

39、段輸入圓弧段的參數（包括斷面線元的起點坐標、半徑、轉角）。圖中所采用的坐標系的原點位于線路中線的設計高程位置（一般為軌面高），“轉角”為順時針到下一點的圓心角，直線段上的半徑和轉角均為0（可不輸入）。斷面線元輸入順序必須由順時針方向，逐點按照順序輸入。3、程序對斷面的圓弧段按照序號順序讀取，如果讀到某列坐標為空值則結束讀取過程，因此空一行后再下部單元格中添加注釋標識不會影響程序的計算結果。4、本說明的下部單元格可用于存儲其他的斷面數據，如果隧道工程有較多斷面，將斷面數據都存在表格中，在使用時直接復制到A、B斷面參數表中會十分方便。37K36+940.000326.6015000斷斷面面B B（

40、二二襯襯）半半徑徑轉轉角角序序號號X X坐坐標標Y Y坐坐標標半半徑徑轉轉角角1-1.936-1.7132.5008.7812-2.041-1.34433.10011.45610.70044.4153-2.7005.2309.80044.41512.80091.16940.10012.08811.90091.16910.70044.415517.10012.0889.80044.415619.9005.23033.10011.456719.241-1.3442.5008.78131.90033.403819.136-1.713T2航站樓加深斷面二襯（至TBM步進標高）以左線為基準隧隧道道斷斷面

41、面參參數數斷斷面面A A( (初初支支) )T2航站樓加深斷面初支以左線基準隧隧道道斷斷面面參參數數編編輯輯說說明明1、一般的隧道斷面形狀主要有圓形和圓弧線段組成兩種形式。如果隧道形狀為圓形則僅需輸入圓心點相對于設計高程的坐標、圓的半徑即可，如下左圖：2、如果隧道由圓弧段組成則如上右圖，需逐段輸入圓弧段的參數（包括斷面線元的起點坐標、半徑、轉角）。圖中所采用的坐標系的原點位于線路中線的設計高程位置（一般為軌面高），“轉角”為順時針到下一點的圓心角，直線段上的半徑和轉角均為0（可不輸入）。斷面線元輸入順序必須由順時針方向，逐點按照順序輸入。3、程序對斷面的圓弧段按照序號順序讀取，如果讀到某列坐標

42、為空值則結束讀取過程，因此空一行后再下部單元格中添加注釋標識不會影響程序的計算結果。4、本說明的下部單元格可用于存儲其他的斷面數據，如果隧道工程有較多斷面，將斷面數據都存在表格中，在使用時直接復制到A、B斷面參數表中會十分方便。線線路路參參數數檢檢核核交交點點點點號號轉轉向向角角( (起起始始方方位位角角) )主主點點編編號號主主點點樁樁號號主主點點坐坐標標X X坐坐標標Y Y坐坐標標起點743717QDK22+564.90279032.474667552.9475ZHK22+927.82779128.721167902.8782HYK23+012.82779152.707567984.412

43、5左JD3684751QZK23+031.74679158.897668002.2887YHK23+050.66479165.508768020.0135HZK23+135.66479198.937168098.1527ZHK23+509.53879351.412268437.8038HYK23+594.53879387.586468514.7103左JD37325658QZK23+782.06879492.036968668.7506YHK23+969.59879629.686868796.6673HZK24+054.59879700.238068844.0563ZHK24+096.3837

44、9735.331168866.7369HYK24+181.38379807.626568911.4136左JD3810651QZK24+200.66779824.556268919.9128YHK24+219.95179841.733868929.4096HZK24+304.95179919.420768963.8678ZHK24+849.17580411.465869170.3032HYK24+879.17580439.090769182.0016左JD3922455QZK24+895.79080454.310769183.7577YHK24+912.40680469.455869195.5

45、007HZK24+942.40680496.648469208.1718ZHK24+979.67580530.377569224.0260HYK25+009.67580557.570069236.6971左JD4022455QZK25+026.29180572.715269238.5308YHK25+042.90680587.935269250.1962HZK25+072.90680615.560269261.8946ZHK25+854.13181335.961169564.1357HYK25+884.13181363.663469575.6497左JD4122455QZK25+900.746

46、81379.083069577.3159YHK25+917.36281394.570269587.8570HZK25+947.36281422.663669598.3808ZHK25+972.76781446.483969607.2135HYK26+002.76781474.577369617.7373左JD4222455QZK26+019.38281490.064569619.3245YHK26+035.99881505.484069629.9446HZK26+065.99881533.186469641.4586ZHK26+820.12082228.586869933.2109HYK26+

47、905.12082306.247069967.7269左JD43772913QZK27+319.05682599.680870239.8002YHK27+732.99282676.930970650.5482HZK27+817.99282663.570770734.4765ZHK27+847.04582658.402270763.0666HYK27+931.69582645.171970846.6599左JD44622712QZK28+240.79282683.789071138.9401YHK28+549.88882858.125371402.0178HZK28+634.53882923.8

48、53971455.3340ZHK28+835.31383097.183571589.7526HYK28+920.58383163.624671643.1824左JD45111650QZK28+957.21383190.787671672.1581YHK28+993.84383216.805171693.5329HZ-K29+078.09083273.784871756.9558ZHK29+372.54083466.672271979.4305HYK29+457.22083523.422872042.2612左JD4632248QZK29+611.34383642.567672143.5163Y

49、HK29+765.46783780.193372208.2039HZK29+850.14783860.790072234.1366ZHK30+159.15484153.989372321.9457HYK30+229.30484220.989472342.7216左JD475441QZK30+254.53184244.850772352.4099YHK30+279.75984268.535572359.5950HZK30+349.90984333.643572385.7023ZHK30+376.30484358.045672395.7630HYK30+446.15484422.876372421

50、.7559左JD485441QZK30+471.01184446.213872431.7972YHK30+495.86884469.724272438.3816HZK30+565.71884536.436972459.0715ZHK30+673.33584639.530072489.9464HYK30+743.33584707.035572508.4056左JD49504547QZK30+923.09784885.670072513.6767YHK31+102.85985054.326572455.2048HZK31+172.85985113.210772417.3844ZHK31+307.5

51、1585224.725772341.9090HYK31+362.51585270.460872311.3606左JD5054541QZK31+410.43185311.038872283.5741YHK31+458.34785352.410072261.7106HZK31+516.30985400.661772235.3159ZHK32+151.55385959.824371933.8670HYK32+236.55386033.800471892.0321左JD51585310QZK32+553.76886256.860271669.0967YHK32+870.98286360.6691713

52、73.5257HZK32+955.98286366.514571288.7408ZHK33+197.83386377.287771067.2349HYK33+267.83386381.367670997.3565左JD5212933QZK33+360.16486392.162870924.0659YHK33+452.49486409.793970815.0810HZK33+522.49486427.185770747.2787ZHK35+417.62886916.847368912.6159HYK35+502.62886937.096468830.0774左JD53213751QZK35+592.26386949.079168756.0977YHK35+681.89886949.966668651.7603HZK35+766.89886941.780168567.1694ZHK35+840.97386933.154268493.5990HYK35+925.97386924.453668409.0523左JD5464114QZK35+941.83086923.509168408.