1、使使 用用 說說 明明 1、本工作簿共含四張工作表，第一張表為使用說明；第二張表為數據錄入（曲線數據庫）；第三張表為曲線段中邊樁坐標計算表；第四張表為曲線任意點坐標正反算.使用前請認真閱讀使用說明。、數據錄入表的使用：你可將全線路或標段的各線段設計參數依序錄入表中。序號列不需輸入，表格根據錄入行的數據自動計數。本表設計有供輸入310行的線段點參數的單元區間,完全滿足全線或標段全程計算需要。、樁號輸入：按普通數值輸入，表格自動顯示為代公里標示的格式。（全程可逆向輸入）、切線方位角輸入：如：82536.2按 182.25362 輸入。（曲線轉向自動判斷、曲線屬性自動判斷） 、半徑輸入：直線段不作規

2、定；圓曲線輸入設計半徑值；緩和曲線接直線端輸入“1”，接圓曲線端輸入圓半徑；當不同半徑值的兩段曲線相接于公切點時，應在第二半徑列輸入作為下一曲線段起點計算的半徑值。（此類情況可發生在復曲線或反曲線） 、斷鏈：斷鏈值按長正短負輸入；處理在直線末端。程序自動計算斷鏈樁號。直線段大于1.2公里時，應分多端輸入。 、曲線段中邊樁坐標計算的選擇：你可在錄入表右上方的黃色單元格中輸入需要計算的線段序號，程序自動在線段中邊樁坐標計算表中進行計算。如：輸入“5”，程序自動選擇5-6序號段進行計算。 3、線段中邊樁坐標計算表的使用：打開此表，在逐樁欄輸入任意數值或字符，在左邊垂距和右邊垂距中輸入數值，表格自動計

3、算此曲線段中邊樁坐標，不輸入邊樁垂距，不計算邊樁點坐標；整樁取值：直線段按25或50米；曲線段按5、10、20、25、50米自動取值。 4、任意點坐標正反算表的使用： 、正算：可直接計算全線范圍內的有效樁號值中邊樁坐標。（有樁號范圍提示）一次只能進行一個樁號的計算。 、反算：只能進行一個曲線段中的樁號反算。方法：在正算欄輸入需要反算的曲線段區間的任意樁號值，程序自動跟蹤該曲線段參數作為反算依據，在反算欄輸入曲線點的坐標值，該點的樁號自動計算并顯示，誤差小于3毫米。一次計算一個點。 、放樣計算：可對正算的樁號點（包括中邊樁）自動進行放樣計算，得到的放樣參數為：以曲線起點為置鏡點，以起點切線方位線

4、為零方向的偏距和偏角。也可以任意點置鏡，得到的放樣參數為:以置鏡點和已知后視為零方向線的水平距離和水平夾角。 5、本表在電腦和智能手機上使用的方法：除使用說明表外，其余三張表不能作刪除（含單元格）移動拆分操作。最佳使用方法：在電腦上輸入全部數據，并計算整段中邊樁坐標后復制在智能手機上，你只需用智能手機在不同場合、現場打開任意點坐標正反算表，象操作計算器一樣，計算任意點（這里真正的是全程計算，309個曲線段間任意正反算）坐標和進行放樣計算。速度和界面是傳統計算器無法比擬的。設設 計計 數數 據據 錄錄 入入 表表交點號交點樁號交點坐標半徑R（M)X(M)Y(M)起點K265+000.000332

5、9306.410507279.759JD39K269+090.2193326586.195504225.2027000.000JD40K279+119.0353321373.319495653.0587000.000JD41K285+979.7063314644.764493448.8138000.000JD42K293+826.9673308869.586488052.64211000.000JD43K303+956.6953302240.371480391.82811000.000終點K306+100.0003300945.832478683.280請輸入中樁到 左 邊樁垂距（M)= 2.

6、502.50圓曲線自定義逐樁距（M)=請輸入中樁到 右 邊樁垂距（M)= 2.502.50緩和曲線自定義逐樁距（M）=第一Ls(M)第二Ls(M)使使 用用 說說 明明 本程序由十個交點升級到15個交點，曲線段(含670.000670.000直線段）由41條升級到61條。曲線算法也進行改變，670.000670.000即：直線按直線坐標；圓曲線按圓方程；緩和曲線按570.000570.000高斯拉格朗日5節點法進行曲線坐標解算。370.000370.000 按左表連續輸入交點設計參數，輸入左右偏距，370.000370.000根據全線各曲線段最大長度輸入適當的圓曲線、緩和曲線逐樁距即可進行全線

7、中邊樁坐標連續計算。直線段逐樁距由程序自動賦值。如果不輸入圓曲線自定義逐樁距和緩和曲線自定義逐樁距，將由程序根據其長度選擇2.5、5、10、20、25、50米六個級數中一個賦值進行自動逐樁距計算。 選擇自定義逐樁距時，請根據提供的每條曲線的計算顯示個數和全線段曲線出現的最大長度進行自定義逐樁距。（一旦自定義逐樁距全線都將采用） 圓曲線：每條圓曲線分配80個逐樁點空間； 緩和曲線：每條緩和曲線分配50個逐樁點空間。 升級后，程序將根據設計參數自動跟蹤交點間有無斷鏈，如出現斷鏈，程序將斷鏈值按樁號變化100.00100.00自動處理在交點間的直線段。100.00100.00圓曲線自定義逐樁距（M)

8、=緩和曲線自定義逐樁距（M）=123456#REF!#REF!#REF!線線路路交交點點主主要要曲曲線線元元素素計計算算交點號交點樁號轉 角切線方位角半 徑Ls1Ls2起點K265+000.0002281848.7JD39K269+090.219102254.82281848.77000.000670.000670.000JD40K279+119.035-403324.82384143.67000.000670.000670.000JD41K285+979.70624555.9198818.88000.000570.000570.000JD42K293+826.9676419.6223324.

9、711000.000370.000370.000JD43K303+956.69534313.2229744.411000.000370.000370.000終點K306+100.0002325057.7線線路路各各線線段段參參數數計計算算統統計計序 號點 號樁 號縱坐標 X橫坐標 Y切線方位角0起點K265+000.0003329306.410507279.7592281848.71ZHK268+119.0663327232.064504950.4542281848.72HYK268+789.0663326794.560504443.1092313203YHK269+387.455332643

10、8.771503962.2082355712.44HZK270+057.4553326081.597503395.4322384143.65ZHK276+196.6883322891.732498149.9632384143.66HYK276+866.6883322534.558497583.1862355712.47YHK281+151.6473319229.427494961.97320052508HZK281+821.6473318596.194494743.284198818.89ZHK283+926.7693316595.684494087.926198818.810HYK284+4

11、96.7693316056.185493904.066200104711YHK287+406.0233313565.785492431.381221056.612HZK287+976.0233313144.731492047.223223324.713ZHK293+058.5113309431.078488577.285223324.714HYK293+428.5113309162.152488323.169224113.715YHK294+224.2783308610.415487749.971228955.416HZK294+594.2783308366.741487471.5482297

12、44.417ZHK303+414.4253302595.209480801.884229744.418HYK303+784.4253302354.672480520.746230533.419YHK304+128.6833302137.982480253.260231538.720HZK304+498.6833301912.888479959.6122325057.721終點K306+100.0003300945.832478683.2802325057.7T1T2曲線長直線長斷鏈971.152971.1521938.3893119.0660.0002922.3472922.3475624.9

13、596139.2340.0002052.9372052.9374049.2542105.1220.000768.455768.4551535.7675082.4890.000542.269542.2691084.2578820.1470.0001601.3180.000半徑 R斷鏈值1.0000.0001.0000.0007000.0000.0007000.0000.0001.0000.0001.0000.0007000.0000.0007000.0000.0001.0000.0001.0000.0008000.0000.0008000.0000.000線線路路交交點點主主要要曲曲線線元元素素

14、計計算算線線路路各各線線段段參參數數計計算算統統計計切線方位角2281848.72281848.72313202355712.42384143.62384143.62355712.42005250198818.8198818.82001047221056.61.0000.0001.0000.00011000.0000.00011000.0000.0001.0000.0001.0000.00011000.0000.00011000.0000.0001.0000.0001.0000.000223324.7223324.7224113.7228955.4229744.4229744.4230533.

15、4231538.72325057.72325057.7123DK起點265000 270057.45281821.6473X3329306.4 3326081.63318596.194Y507279.76 503395.43494743.2841DKJD1269090.22 279119.04285979.7064X3326586.2 3321373.33314644.764Y504225.2 495653.06493448.813S14090.2186 9061.58044158.059072S210032.733 7080.40597903.881476a3.9848233 4.16602

16、173.458170388R700070008000LS1670670570LS2670670570T1636.17803 2587.37251767.949548T2636.17803 2587.37251767.949548Th1971.15245 2922.34692052.937492Th2971.15245 2922.34692052.937492P12.6718052 2.67180521.692110799P22.6718052 2.67180521.692110799Q1334.97442 334.97442284.9879432Q2334.97442 334.97442284

17、.9879432B10.0478571 0.04785710.035625B20.0478571 0.04785710.035625ZJ0.1811984 -0.7078510.434906737Ly598.38877 4284.95892909.253896ZX1-11XO3332238.9 3316734.53318815.914YO500043.14 501502.25486395.1452aOZY2.4140269 5.7368181.887374062ZXC3119.0661 6139.23352105.12158DLZ0003.9848233.9848234.032684.1181

18、654.1660224.1660224.1181653.5060283.458173.458173.4937953.8574523.8930773.8930773.9098953.9822383.9990563.9990564.0158744.047174.0639884.0639884567891011287976.0228 294594.28 304498.683313144.731 3308366.7 3301912.9492047.2229 487471.55 479959.61293826.9668 303956.693061003308869.586 3302240.4 33009

19、45.8488052.642 480391.83 478683.285850.943985 9362.4164 1601.318310130.87176 2143.58753.893077125 3.9990559 4.06398841100011000370370370370583.4570969 357.27097583.4570969 357.27097768.4553527 542.26922768.4553527 542.269220.518555368 0.51855540.518555368 0.5185554184.9982558 184.99826184.9982558 18

20、4.998260.016818182 0.01681820.016818182 0.01681820.105978805 0.0649325795.7668497 344.25719113316806.224 3310792.6480413.1653 473463.722.322280799 2.42825965082.488632 8820.1472 1601.318300012131415 ZD21QD01 112233442 252637483 392103114124 4132143154165 5172183194206 6212347 72348 82349 92341 10 02

21、341 11 12341 12 22341 13 32341 14 42341 15 5234ZDDKXYR1Ca起點265000.0003329306.410507279.7593.9848232281848.7ZH268119.0663327232.064504950.4541 3.9848232281848.7HY268789.0663326794.560504443.10970004.03268231320YH269387.4553326438.771503962.2087000 4.1181652355712.4HZ270057.4553326081.597503395.4321 4

22、.1660222384143.6ZH276196.6883322891.732498149.9631 4.1660222384143.6HY276866.6883322534.558497583.1867000 4.1181652355712.4YH281151.6473319229.427494961.9737000 3.5060282005250HZ281821.6473318596.194494743.28413.45817198818.8ZH283926.7693316595.684494087.92613.45817198818.8HY284496.7693316056.185493

23、904.0668000 3.4937952001047YH287406.0233313565.785492431.3818000 3.857452221056.6HZ287976.0233313144.731492047.2231 3.893077223324.7ZH293058.5113309431.078488577.2851 3.893077223324.7HY293428.5113309162.152488323.16911000 3.909895224113.7YH294224.2783308610.415487749.97111000 3.982238228955.4HZ29459

24、4.2783308366.741487471.5481 3.999056229744.4ZH303414.4253302595.209480801.8841 3.999056229744.4HY303784.4253302354.672480520.74611000 4.015874230533.4YH304128.6833302137.982480253.260110004.04717231538.7HZ304498.6833301912.888479959.6121 4.0639882325057.7終點306100.0003300945.832478683.2801 4.06398823

25、25057.70起點265000.0003329306.410507279.75910ZH268119.0663327232.064504950.45410HY268789.06613326794.56504443.108970000YH269387.45493326438.771503962.208470000HZ270057.45493326081.597503395.432210ZH276196.6883322891.732498149.96310HY276866.68843322534.558497583.186570000YH281151.64733319229.427494961.

26、973570000HZ281821.64733318596.194494743.284110ZH283926.7693316595.684494087.92610HY284496.76893316056.185493904.066280000YH287406.02283313565.785492431.38180000HZ287976.02283313144.731492047.222910ZH293058.5113309431.078488577.28510HY293428.51143309162.152488323.1687110000YH294224.27833308610.415487

27、749.9708110000HZ294594.27833308366.741487471.547510ZH303414.4253302595.209480801.88410HY303784.42543302354.672480520.7461110000YH304128.68263302137.982480253.2597110000HZ304498.68263301912.888479959.611910ZH306100.0003300945.832478683.28010HY3061003300945.832478683.2810YH0HZZH0HY0YH0HZZH0HY0YH0HZZH0

28、HY0YH0HZZH0HY0YH0HZZH0HY0YH0HZZH0HY0YH0HZZH0HY0YH0HZZH0HY0YH0HZZH0HY0YH0HZ終點3.9848233.9848234.032684.1181654.1660224.16602204.1181653.5060283.458173.4581703.4937953.8574523.8930773.89307703.9098953.9822383.9990563.99905604.0158744.047174.0639884.06398804.0639880點點號號中中 樁樁左左 邊邊 樁樁右右 邊邊 樁樁樁樁 號號X(M)Y(M)

29、X(M)Y(M)X(M)Y(M)起點K265+000.0003329306.410507279.7593329304.543507281.4223329308.277507278.0961K265+050.0003329273.157507242.4193329273.157507239.9193329273.157507244.9192K265+100.0003329239.905507205.0793329239.905507202.5793329239.905507207.5793K265+150.0003329206.652507167.7403329206.652507165.240

30、3329206.652507170.2404K265+200.0003329173.399507130.4003329173.399507127.9003329173.399507132.9005K265+250.0003329140.147507093.0603329140.147507090.5603329140.147507095.5606K265+300.0003329106.894507055.7203329106.894507053.2203329106.894507058.2207K265+350.0003329073.641507018.3813329073.641507015

31、.8813329073.641507020.8818K265+400.0003329040.389506981.0413329040.389506978.5413329040.389506983.5419K265+450.0003329007.136506943.7013329007.136506941.2013329007.136506946.20110K265+500.0003328973.883506906.3613328973.883506903.8613328973.883506908.86111K265+550.0003328940.630506869.0213328940.630

32、506866.5213328940.630506871.52112K265+600.0003328907.378506831.6823328907.378506829.1823328907.378506834.18213K265+650.0003328874.125506794.3423328874.125506791.8423328874.125506796.84214K265+700.0003328840.872506757.0023328840.872506754.5023328840.872506759.50215K265+750.0003328807.620506719.662332

33、8807.620506717.1623328807.620506722.16216K265+800.0003328774.367506682.3233328774.367506679.8233328774.367506684.82317K265+850.0003328741.114506644.9833328741.114506642.4833328741.114506647.48318K265+900.0003328707.862506607.6433328707.862506605.1433328707.862506610.14319K265+950.0003328674.60950657

34、0.3033328674.609506567.8033328674.609506572.80320K266+000.0003328641.356506532.9633328641.356506530.4633328641.356506535.46321K266+050.0003328608.104506495.6243328608.104506493.1243328608.104506498.12422K266+100.0003328574.851506458.2843328574.851506455.7843328574.851506460.78423K266+150.0003328541.

35、598506420.9443328541.598506418.4443328541.598506423.44424K266+200.0003328508.346506383.6043328508.346506381.1043328508.346506386.10425K266+250.0003328475.093506346.2653328475.093506343.7653328475.093506348.76526K266+300.0003328441.840506308.9253328441.840506306.4253328441.840506311.42527K266+350.000

36、3328408.588506271.5853328408.588506269.0853328408.588506274.08528K266+400.0003328375.335506234.2453328375.335506231.7453328375.335506236.74529K266+450.0003328342.082506196.9053328342.082506194.4053328342.082506199.40530K266+500.0003328308.829506159.5663328308.829506157.0663328308.829506162.06631K266

37、+550.0003328275.577506122.2263328275.577506119.7263328275.577506124.72632K266+600.0003328242.324506084.8863328242.324506082.3863328242.324506087.38633K266+650.0003328209.071506047.5463328209.071506045.0463328209.071506050.04634K266+700.0003328175.819506010.2073328175.819506007.7073328175.819506012.7

38、0735K266+750.0003328142.566505972.8673328142.566505970.3673328142.566505975.36736K266+800.0003328109.313505935.5273328109.313505933.0273328109.313505938.02737K266+850.0003328076.061505898.1873328076.061505895.6873328076.061505900.68738K266+900.0003328042.808505860.8473328042.808505858.3473328042.808

39、505863.34739K266+950.0003328009.555505823.5083328009.555505821.0083328009.555505826.00840K267+000.0003327976.303505786.1683327976.303505783.6683327976.303505788.66841K267+050.0003327943.050505748.8283327943.050505746.3283327943.050505751.32842K267+100.0003327909.797505711.4883327909.797505708.988332

40、7909.797505713.98843K267+150.0003327876.545505674.1493327876.545505671.6493327876.545505676.64944K267+200.0003327843.292505636.8093327843.292505634.3093327843.292505639.30945K267+250.0003327810.039505599.4693327810.039505596.9693327810.039505601.96946K267+300.0003327776.786505562.1293327776.78650555

41、9.6293327776.786505564.62947K267+350.0003327743.534505524.7893327743.534505522.2893327743.534505527.28948K267+400.0003327710.281505487.4503327710.281505484.9503327710.281505489.95049K267+450.0003327677.028505450.1103327677.028505447.6103327677.028505452.61050K267+500.0003327643.776505412.7703327643.

42、776505410.2703327643.776505415.27051K267+550.0003327610.523505375.4303327610.523505372.9303327610.523505377.93052K267+600.0003327577.270505338.0913327577.270505335.5913327577.270505340.59153K267+650.0003327544.018505300.7513327544.018505298.2513327544.018505303.25154K267+700.0003327510.765505263.411

43、3327510.765505260.9113327510.765505265.91155K267+750.0003327477.512505226.0713327477.512505223.5713327477.512505228.57156K267+800.0003327444.260505188.7313327444.260505186.2313327444.260505191.23157K267+850.0003327411.007505151.3923327411.007505148.8923327411.007505153.89258K267+900.0003327377.75450

44、5114.0523327377.754505111.5523327377.754505116.55259K267+950.0003327344.502505076.7123327344.502505074.2123327344.502505079.21260K268+000.0003327311.249505039.3723327311.249505036.8723327311.249505041.87261K268+050.0003327277.996505002.0333327277.996504999.5333327277.996505004.533點點號號中中 樁樁左左 邊邊 樁樁右右

45、 邊邊 樁樁樁樁 號號X(M)Y(M)X(M)Y(M)X(M)Y(M)62K268+100.0003327244.744504964.6933327244.744504962.1933327244.744504967.19363K268+119.0663327232.064504950.4543327232.064504947.9543327232.064504952.95464K268+200.0003327178.252504890.0013327178.252504887.5013327178.252504892.50165K268+300.0003327111.890504815.19

46、43327111.890504812.6943327111.890504817.69466K268+400.0003327045.817504740.1323327045.817504737.6323327045.817504742.63267K268+500.0003326980.195504664.6753326980.195504662.1753326980.195504667.17568K268+600.0003326915.188504588.6883326915.188504586.1883326915.188504591.18869K268+700.0003326850.9645

47、04512.0393326850.964504509.5393326850.964504514.53970K268+789.0663326794.560504443.1093326794.560504440.6093326794.560504445.60971K268+800.0003326787.694504434.6003326787.694504432.1003326787.694504437.10072K268+900.0003326725.517504356.2813326725.517504353.7813326725.517504358.78173K269+000.0003326

48、664.466504277.0813326664.466504274.5813326664.466504279.58174K269+100.0003326604.552504197.0183326604.552504194.5183326604.552504199.51875K269+200.0003326545.788504116.1073326545.788504113.6073326545.788504118.60776K269+300.0003326488.185504034.3643326488.185504031.8643326488.185504036.86477K269+387

49、.4553326438.771503962.2083326438.771503959.7083326438.771503964.70878K269+400.0003326431.757503951.8083326431.757503949.3083326431.757503954.30879K269+500.0003326376.471503868.4813326376.471503865.9813326376.471503870.98180K269+600.0003326322.179503784.5033326322.179503782.0033326322.179503787.00381

50、K269+700.0003326268.709503699.9993326268.709503697.4993326268.709503702.49982K269+800.0003326215.885503615.0903326215.885503612.5903326215.885503617.59083K269+900.0003326163.527503529.8923326163.527503527.3923326163.527503532.39284K270+000.0003326111.456503444.5193326111.456503442.0193326111.4565034

51、47.01985K270+057.4553326081.597503395.4323326081.597503392.9323326081.597503397.93286K270+100.0003326059.491503359.0813326059.491503356.5813326059.491503361.58187K270+200.0003326007.532503273.6393326007.532503271.1393326007.532503276.13988K270+300.0003325955.574503188.1973325955.574503185.6973325955

52、.574503190.69789K270+400.0003325903.615503102.7563325903.615503100.2563325903.615503105.25690K270+500.0003325851.656503017.3143325851.656503014.8143325851.656503019.81491K270+600.0003325799.698502931.8723325799.698502929.3723325799.698502934.37292K270+700.0003325747.739502846.4303325747.739502843.93

53、03325747.739502848.93093K270+800.0003325695.780502760.9893325695.780502758.4893325695.780502763.48994K270+900.0003325643.822502675.5473325643.822502673.0473325643.822502678.04795K271+000.0003325591.863502590.1053325591.863502587.6053325591.863502592.60596K271+100.0003325539.904502504.6633325539.9045

54、02502.1633325539.904502507.16397K271+200.0003325487.946502419.2223325487.946502416.7223325487.946502421.72298K271+300.0003325435.987502333.7803325435.987502331.2803325435.987502336.28099K271+400.0003325384.028502248.3383325384.028502245.8383325384.028502250.838100K271+500.0003325332.070502162.896332

55、5332.070502160.3963325332.070502165.396101K271+600.0003325280.111502077.4543325280.111502074.9543325280.111502079.954102K271+700.0003325228.152501992.0133325228.152501989.5133325228.152501994.513103K271+800.0003325176.193501906.5713325176.193501904.0713325176.193501909.071104K271+900.0003325124.2355

56、01821.1293325124.235501818.6293325124.235501823.629105K272+000.0003325072.276501735.6873325072.276501733.1873325072.276501738.187106K272+100.0003325020.317501650.2463325020.317501647.7463325020.317501652.746107K272+200.0003324968.359501564.8043324968.359501562.3043324968.359501567.304108K272+300.000

57、3324916.400501479.3623324916.400501476.8623324916.400501481.862109K272+400.0003324864.441501393.9203324864.441501391.4203324864.441501396.420110K272+500.0003324812.483501308.4793324812.483501305.9793324812.483501310.979111K272+600.0003324760.524501223.0373324760.524501220.5373324760.524501225.537112

58、K272+700.0003324708.565501137.5953324708.565501135.0953324708.565501140.095113K272+800.0003324656.607501052.1533324656.607501049.6533324656.607501054.653114K272+900.0003324604.648500966.7123324604.648500964.2123324604.648500969.212115K273+000.0003324552.689500881.2703324552.689500878.7703324552.6895

59、00883.770116K273+100.0003324500.731500795.8283324500.731500793.3283324500.731500798.328117K273+200.0003324448.772500710.3863324448.772500707.8863324448.772500712.886118K273+300.0003324396.813500624.9443324396.813500622.4443324396.813500627.444119K273+400.0003324344.855500539.5033324344.855500537.003

60、3324344.855500542.003120K273+500.0003324292.896500454.0613324292.896500451.5613324292.896500456.561121K273+600.0003324240.937500368.6193324240.937500366.1193324240.937500371.119122K273+700.0003324188.978500283.1773324188.978500280.6773324188.978500285.677123K273+800.0003324137.020500197.7363324137.0