自編Excel測量計算程序

1、程序目錄曲線主點樁號與坐標計算!A1直線段坐標計算!A1方位角計算及隨機!A1卵型曲線隱藏計算!A1卵型曲線主點樁號計算!A1附合導線平差!A1水準平差!A1四等水準!A1四等水準數(shù)據(jù)反推!A1自由測站!A1圓曲線圓心法!A1豎曲線!A1前方交會!A1參考橢球與高斯投影計算!A1高斯平面距離值!A1高斯投影坐標正算!A1坐標換帶計算!A1緩和曲線-1!A1圓曲線支矩法!A1緩和曲線-2!A1工程、國家坐標換算!A1超高橫坡計算!A1求弦長或弧長!A1不完整緩和曲線!A1曲曲線線計計算算要要素素表表( (已已知知條條件件) )交點樁號交點坐標轉角值方向轉角值曲線半徑緩和曲線長緩和曲線長JDN(X

2、)E(Y)左+1,右-1 （度）（弧度）RLS1LS211300.5983561841.022537361.4111943239.7231666670.16970127240000094323.基基本本要要素素結結果果表表內移值內移值切線增值切線增值ZH至JD方位角緩和曲線角緩和曲線角切線長p1p2q1q2 （度）（弧度） 1 2T10.0000.0000.0000.0001893554189.598253.3091137190.0000.000340.2191893554.ZH至HY支矩坐標切線長圓曲線長曲線長JD至ZH方位角 JD至HZ方位角HZ至JD方位角HY至JD方位角N(x)E(y)

3、T2LyL（弧度）（弧度）（弧度）（度）（度）（弧度）0.0000.000340.219678.805678.8050.1675210653.1394124466.2810051359.875083335952303.309113719曲曲線線主主點點樁樁號號、坐坐標標結結果果表表ZH樁號HY樁號路線方向QZ樁號YH樁號HZ樁號10960.37910960.379左+1,右-111299.78111639.18411639.184N(X)E(Y)N(X)E(Y)1N(X)E(Y)N(X)E(Y)N(X)E(Y)3562176.479537418.1393562176.479537418.139

4、3561500.803537362.1533561500.803537362.153備備注注：此此程程序序適適用用于于對對稱稱、不不對對稱稱緩緩和和曲曲線線以以及及圓圓曲曲線線，當當為為對對稱稱緩緩和和曲曲線線時時，LS1=LS2;LS1=LS2;當當為為圓圓曲曲線線時時，LS1=LS2=0LS1=LS2=0。涂涂紅紅處處輸輸入入變變量量K10+960.379至K11+639.184任意點樁號里程差W支矩x坐標支矩y坐標至起點距離切線角距中樁距離待求點坐標WCD(C2+D2)E左+,右-N(X)E(Y)10960.3790.0000001.05242E-0711.763562174.51753

5、7429.734109654.6210000.00115535511.763562169.974537428.968109709.6210000.00240535511.763562165.057537428.1461097514.6210000.00365535511.763562160.139537427.3301098019.6210000.00490535511.763562155.220537426.5191098524.6210000.00615535511.763562150.300537425.7151099029.6210000.00740535511.763562145.3

6、79537424.9171099534.6210000.00865535511.763562140.457537424.1261100039.6210000.00990535511.763562135.534537423.3401100544.6210000.01115535511.763562130.610537422.5611101049.6210000.01240535511.763562125.685537421.7871101554.6210000.01365535511.763562120.759537421.0201102059.6210000.01490535511.76356

7、2115.832537420.2591102564.6210000.01615535511.763562110.904537419.5051103069.6210000.01740535511.763562105.976537418.7561103574.6210000.01865535511.763562101.046537418.0131104079.6210000.01990535511.763562096.115537417.27711245284.6210000.07115535511.753561893.260537392.39711250289.6210000.072405355

8、11.753561888.298537391.92011255294.6210000.07365535511.753561883.335537391.45011260299.6210000.07490535511.753561878.371537390.98611265304.6210000.07615535511.753561873.407537390.52811270309.6210000.07740535511.753561868.442537390.07611275314.6210000.07865535511.753561863.477537389.63111280319.62100

9、00.07990535511.753561858.511537389.19111285324.6210000.08115535511.753561853.544537388.75811290329.6210000.08240535511.753561848.577537388.33111295334.6210000.08365535511.753561843.610537387.91111300339.6210000.08490535511.753561838.642537387.49611305344.6210000.08615535511.753561833.673537387.08811

10、310349.6210000.08740535511.753561828.704537386.68611315354.6210000.08865535511.753561823.734537386.29011320359.6210000.08990535511.753561818.764537385.90011325364.6210000.09115535511.753561813.794537385.51711330369.6210000.09240535511.753561808.8235373856210000.09365535511.753561803.851

11、537384.76911340379.6210000.09490535511.753561798.879537384.40411345384.6210000.09615535511.753561793.907537384.04511350389.6210000.09740535511.753561788.934537383.69311355394.6210000.09865535511.753561783.961537383.34711360399.6210000.09990535511.753561778.987537383.00711365404.6210000.10115535511.7

12、53561774.013537382.67311370409.6210000.10240535511.753561769.038537382.34511375414.6210000.10365535511.753561764.064537382.02411380419.6210000.10490535511.753561759.088537381.70911385424.6210000.10615535511.753561754.112537381.40011390429.6210000.10740535511.753561749.136537381.09811395434.6210000.1

13、0865535511.753561744.160537380.80111400439.6210000.10990535511.753561739.183537380.51111405444.6210000.11115535511.753561734.206537380.22711410449.6210000.11240535511.753561729.228537379.94911415454.6210000.11365535511.753561724.250537379.67811420459.6210000.11490535511.753561719.272537379.413114254

14、64.6210000.11615535511.753561714.2935373796210000.11740535511.753561709.315537378.90111435474.6210000.11865535511.753561704.335537378.65411440479.6210000.11990535511.753561699.356537378.41411445484.6210000.12115535511.753561694.3765373786210000.12240535511.753561689.3965373

15、77.95111455494.6210000.12365535511.753561684.416537377.73011460499.6210000.12490535511.753561679.435537377.51411465504.6210000.12615535511.753561674.454537377.30511470509.6210000.12740535511.753561669.473537377.10211475514.6210000.12865535511.753561664.491537376.90511480519.6210000.12990535511.75356

16、1659.510537376.714直直線線段段計計算算要要素素表表( (已已知知條條件件) )起算點樁號起算點坐標起算點至JD方位角（K）N G(X)H(Y) （度）（弧度）10729.0012404.61787456.71911893553.7189.598253.3091137191893554.任意點樁號里程差距中樁距離待求點坐標X待求點坐標YW左+，右-N(X)E(Y)1073010.4902403.5517457.03610740110.4902393.6917455.36810750210.4902383.8317453.70110760310.4902373.9717452.0

17、3410770410.4902364.1117450.36610780510.4902354.2517448.69910790610.4902344.3917447.03110800710.4902334.5317445.36410810810.4902324.6717443.69710820910.4902314.8117442.029108301010.4902304.9517440.362108401110.4902295.0917438.694108501210.4902285.2317437.027108601310.4902275.3717435.360108701410.4902

18、265.5117433.692108801510.4902255.6517432.025108901610.4902245.7917430.357109001710.4902235.9317428.690109101810.4902226.0717427.023109201910.4902216.2117425.355109302010.4902206.3517423.688109402110.4902196.4917422.0211095022111.7602184.7527431.46584000732710-69840.670-4760.38784100733710-69939.270-

19、4777.06184200734710-70037.870-4793.73584300735710-70136.470-4810.409方方位位角角計計算算程程序序 架站點待求點X增量Y增量角度角度方位角距離N(X)坐標E(Y)坐標N(X)坐標E(Y)坐標mm m 527560.240356531.589527797.084356095.150236.844-436.439-61.512448 298.4875522982915496.562527560.240356531.589527785.084356095.864224.844-435.725-62.705206 297.2947942

20、971741490.317527560.240356531.589527804.821356125.819244.581-405.770-58.920238 301.0797623010447473.782527560.240356531.589527794.912356118.617234.672-412.972-60.392587 299.6074132993627474.992527560.240356531.589527785.002356111.415224.762-420.174-61.856495 298.1435052980837476.513隨機范圍（+5，-15）（+5，-

21、10）（+10，-15）-505-11-109-5-1-7卵卵型型曲曲線線隱隱藏藏段段緩緩和和曲曲線線長長度度、完完整整緩緩和和曲曲線線長長、樁樁號號、坐坐標標及及方方位位角角計計算算轉角方向緩和曲線參數(shù)曲線半徑緩和曲線長卵型曲線長第二緩和曲線起點第二緩圓曲線起點計算方位角左+1,右-1AR1LS1LFY1HHY2 （度）（弧度）1345.965480140140.00108326.250108466.253709.930N(X)E(Y)N(X)E(Y)142 2339142.39416672.48524704R2LS2512690.665370849.859409.878260140注：卵型

22、曲線參數(shù)A=SQRT(ABS(LF*R1*R2)/(R1-R2)隱藏緩和曲線長 完整緩和曲線長隱藏點起算樁號 隱藏緩和曲線角起算點至JD方位角隱藏緩和曲線長在完整緩和曲線中支矩坐標起算點坐標起算點至JD方位角半徑L0LSN 1KxyGHKKR1050.0011938.464107276.2491.0937513 3.5789984 931.347271351.347346513683.1568370926.0999205.06150072050341.取最小半徑Y1HY1H至至HY2HY2卵卵型型曲曲線線坐坐標標計計算算任意點樁號里程差W支矩x坐標支矩y坐標 至起點距離切線角距中樁距離待求點坐

23、標WCD(C2+D2)E左+,右-N(X)E(Y)1084001123.751960.1950271419.294261047.751 1.252793030512635.751370899.1891084251148.751967.4903844443.27523 1064.2042 1.309154640512618.985370917.8221084251148.751967.4903844443.27523 1064.2042 1.309154640512618.985370917.8221084251148.751967.4903844443.27523 1064.2042 1.30

24、9154640512618.985370917.8221084251148.751967.4903844443.27523 1064.2042 1.309154640512618.985370917.8221084251148.751967.4903844443.27523 1064.2042 1.309154640512618.985370917.8221084251148.751967.4903844443.27523 1064.2042 1.309154640512618.985370917.822卵型曲線-1計算要素表(已知條件)交點樁號轉角值轉角值兩交點距離曲線半徑緩和曲線長JD11

25、（度）1（弧度）2（度）2（弧度）AB R1LS1615495.4230.98872222 0.540855234 1.0324166670.01801907113.59948040基基本本要要素素計計算算表表內移值切線增值切線長切線長緩和曲線角曲線長圓曲線長外矩p1q1T1TA 1L1Ly1E10.13919.999153.102133.1030.083279.611214.81218.247內移值切線增值切線長切線長緩和曲線角曲線長圓曲線長外矩p2q2T2TB 2L2Ly2E20.34414.99115.9750.9840.27616.962-37.8370.349曲曲線線主主點點樁樁號號

26、基基本本要要素素計計算算表表ZHHY1Y1HGQHY2Y2HHZ615342.318615382.318615597.130615621.9283615646.727615608.890615638.890卵卵形形曲曲線線計計算算： 已已知知a1=5030，a2=4202，AB=70.78m，R1=60m，Ls1=40m，R2=108.87m，Ls2=30m，LF=49.60m，JD1=K5+300，試試計計算算卵卵形形曲曲線線要要素素和和主主點點樁樁號號。 卵型曲線長曲線半徑緩和曲線長LFR2LS249.60108.87530卵型曲線-1計算要素表(已知條件)大廣公路固安（京冀界）至深州段高

27、速公路 導導 線線 測測 量量 平平 差差 計計 算算 表表 承包單位：中交第二航務工程局有限公司合同號：LM10監(jiān)理單位：河北通達工程監(jiān)理咨詢有限公司 編 號：05-04點號轉角值(左角)方向角邊長(m)坐標增量計算值坐標增量改正值改正后的增量平差后的坐標點號觀測值改正值改正后值sxyxyxyXYJ252280622J25A24915748140.715748154246777.250473471.464A2492055437461.346-414.971-201.591-0.00520.0040-414.976-201.587LM1215649270.715649284246362.274

28、473269.877LM121824405307.382-307.032-14.665-0.00340.0027-307.035-14.662J2619408140.719408144246055.238473255.215J261965219427.575-409.171-124.096-0.00480.0037-409.175-124.092C1018925110.718925114245646.063473131.122C102061730468.719-420.230-207.615-0.00520.0041-420.236-207.611LM137259380.77259384245

29、225.827472923.512L015-22.269136.206-0.00150.0012-22.271136.208J2827712470.727712484245203.556473059.719J281962956412.463-395.480-117.138-0.00460.0036-395.485-117.134J2917323040.717323044244808.071472942.585J291895300317.749-313.033-54.539-0.00360.0028-313.037-54.536BO118920530.718920544

30、244495.034472888.049BO11991354529.452-499.906-174.395-0.00590.0046-499.912-174.390LM1417244390.717244404243995.123472713.659LM141915833554.318-542.253-115.021-0.00620.0048-542.259-115.017LM1518834080.718834094243452.863472598.642LM152003242402.619-377.011-141.296-0.00450.0035-377.016-141.293LM161671

31、6370.716716384243075.848472457.349LM161874920430.529-426.523-58.594-0.00480.0037-426.528-58.591LM1716944540.716944554242649.320472398.759LM171773414217.268-217.0739.209-0.00240.0019-217.0759.211LM1818708060.718708064242432.245472407.970LM181844221224.688-223.931-18.433-0.00250.0020-223.933-18.431LM1

32、920710420.720710424242208.311472389.539LM192115303163.767-139.058-86.502-0.00180.0014-139.059-86.501G0914818570.714818574242069.252472303.038G091801200測站數(shù)n15打印時 起點方位角2280622起點坐標4246777.250473471.464隱藏26520528終點方位角1801200終點坐標4242069.252472303.0382652052810265205385055.890-4707.941 -1168.470-0.0570.04

33、4-4707.998 -1168.426輔助計算f=+始-終-n180= -10fx=X-(X終-X始)= 0.057f=(fx2+fy2)0.5= 0.0717f容=10n0.5= 39fy=Y-(Y終-Y始)= -0.044T=f/S= 1/705331/15000合格計算：復核：負責人：日期：2115303163.767-139.058-86.502-0.00180.0014-139.059-86.501大廣公路固安（京冀界）至深州段高速公路水水 準準 點點 平平 差差 計計 算算 表表承包單位：中交第二航務工程局有限公司 合同號：LM10監(jiān)理單位：河北通達工程監(jiān)理咨詢有限公司 編 號：

34、07-01點號站數(shù)或距離實測高差平均高差改正數(shù)改正后高差 平差后高程點號L第一次第二次mmmmGPS6713.968GPS67G01-11600.0190.0200.020-0.00210.01713.985G01-1BM0180-0.201-0.200-0.201-0.0010-0.20213.784BM01LM01268-0.056-0.054-0.055-0.0035-0.05813.725LM01C2249-0.408-0.404-0.406-0.0032-0.40913.316C2LM022900.3870.3840.386-0.00370.38213.698LM02J03265-0

35、.408-0.407-0.408-0.0034-0.41113.287J03LM033110.4760.4730.475-0.00400.47013.758LM03A2311970.4210.4230.422-0.00250.41914.177A2311.820.2300.2350.233-0.0240.209h=H終-H始= 0.209Fh=h測-(H終-H始）= 24H始= 13.968Fh容=20L 27FhFh容合格,可以平差H終= 14.177計算: 復核: 負責人： 日期:大廣公路固安（京冀界）至深州段高速公路四四等等水水準準測測量量觀觀測測記記錄錄表表承包單位：中交第二航務工程局

36、有限公司 合同號：LM10監(jiān)理單位：河北通達工程監(jiān)理咨詢有限公司 編 號：02-02測站編號點號后尺上絲前尺上絲方水準尺讀數(shù)K + 黑平均高差備注下絲下絲向減后 距前 距及黑面紅面視距差dd尺 號紅（m）GPS6719581945后15626350-10.02011671142180.3后 - 前19120-10.020-1.2-1.2G01-111641360后96356500-0.200763966前11635949140.139.4后 - 前-200-299-1-0.2000.7-0.5BM018681158后53153171195474前8155500267.

37、368.4后 - 前-284-183-1-0.284-1.1-1.613181095后99256781-0.054665429前7625549065.366.6后 - 前23012910.230-1.3-2.9LM0112671491后98757731705946前12185906-156.254.5后 - 前-231-1332-0.2321.7-1.212231390后87255581-0.404521698前10445829270.269.2后 - 前-172-271-1-0.1721-0.2C215481431后123660221925822前11265813062.360.9后 - 前

38、11020910.1101.41.222852001后1862654900.38414391176682.5后 - 前27417400.2742.13.3每頁校核后-前=-0.508后-前= -0.508總視距差=3.3后= 55.902總視距d=1046.9前= 56.41總高差= -0.254測量：記錄：復核：大廣公路固安（京冀界）至深州段高速公路四四等等水水準準測測量量觀觀測測記記錄錄表表承包單位：中交第二航務工程局有限公司 合同號：LM10監(jiān)理單位：河北通達工程監(jiān)理咨詢有限公司 編 號：測站編號點號后尺下絲前尺下絲方水準尺讀數(shù)K + 黑平均高差備注上絲上絲向減

39、后 距前 距及黑面紅面視距差dd尺 號紅（m）GPS6719571945后15626350-10.02011671141前1543623007980.4后 - 前19120-10.020-1.4-1.4G01-111641360后96356500-0.200762966前11635949140.239.4后 - 前-200-299-1-0.2000.8-0.6BM018681158后53153171194472前8155500267.468.6后 - 前-284-183-1-0.284-1.2-1.813191095后99256781-0.054665429前7625549065.466.6后

40、 - 前23012910.230-1.2-3LM0112671490后98757731707946前12185906-15654.4后 - 前-231-1332-0.2321.6-1.412231390后87255581-0.404521698前10445829270.269.2后 - 前-172-271-1-0.1721-0.4C215481430后123660221924822前11265813062.460.8后 - 前11020910.1101.61.222852000后1862654900.38414391176682.4后 - 前27417400.2742

41、.23.4每頁校核后-前=-0.508后-前= -0.508總視距差=3.4后= 55.902總視距d=1047前= 56.41總高差= -0.254測量：記錄：復核：計計算算參參數(shù)數(shù)輸輸入入1#控制點坐標2#控制點坐標架站點至1#距離架站點至2#距離G(X)H(Y)E(X)F(Y)BC100100200300250150相相關關參參數(shù)數(shù)計計算算結結果果X增量Y增量角度角度1#至2#方位角（J)1#至2#距離(I)mm 弧度 m 100.000200.00063.4349488263.434948826326061.107223.60712邊與13邊1#至架站點12邊與23邊2#至3#方位角2

42、#至架站點夾角（Q)方位角夾角（O)弧度 方位角0.6351470321.7421.4211674174.2487413712.827573954架架站站點點坐坐標標計計算算結結果果架站點坐標架站點坐標P(X)Z(Y)P(X)Z(Y)57.335346.33257.335346.332備備注注：自自由由測測站站宜宜布布設設近近似似等等邊邊三三角角形形，其其三三角角形形內內角角不不小小于于3030 , ,當當受受地地形形限限制制時時，個個別別角角 可可放放寬寬2525 ，兩兩邊邊相相差差不不宜宜過過長長或或過過短短。（P，Z）（G，H）（E，F(xiàn)）JBCIQOZY點樁號ZY點坐標YZ點樁號YZ點坐

43、標半徑NA(X)B(Y)C(X)D(Y)R06055.5787266.29785.2166107.5177331.931130X增量Y增量角度角度ZY至YZ方位角（J)圓心角mm 弧度 （O）弧度51.93965.63451.6439198451.643919845138380.9010.655507692圓心點至ZY方位角圓心點坐標（K）弧度度 G(X)H(Y)2.800160.42283191602522.6178.0628377222.737102任意點樁號里程差圓心角距中樁距離待求點坐標W弧度左+,右-N(X)E(Y)000.00006055.5787266.297550.038060

44、57.3447270.97515150.11506061.4077280.10920200.15406063.7007284.55220200.15406063.7007284.55230300.23106068.7887293.15830300.23106068.7887293.15840400.3086.756079.8997297.26540400.308-5.256070.3427304.52285850.65606107.5177331.93185850.65606107.5177331.931左轉彎右轉彎（，）（，）曲線長路線方向L左+，右-85.2161夾角ZY至圓心點方位角（Q

45、）弧度（J+Q）弧度1.243042481-0.342左轉彎右轉彎（，）（，）已已知知條條件件變坡點樁號變坡點高程前坡段坡度后坡段坡度豎曲線半徑豎曲線類型mm(i1)%(i2)%R凸-1，凹+1K137+230.00019.4741.6733-0.353517000-1相相關關參參數(shù)數(shù)計計算算結結果果坡度差曲線長切線長外矩起點樁號終點樁號LTEmm0.020268344.556172.2780.873K137+057.722K137+402.278豎豎曲曲線線設設計計高高程程計計算算里程樁號直坡高程高程改正值設計高程K137+30019.226550.30818.919K137+30019.2

46、26550.30818.919K137+30019.226550.30818.919K137+30019.226550.30818.919K137+18018.637350.44018.198K137+20018.972010.59518.377K137+22019.306670.77518.532K137+24019.438650.77518.664K137+26019.367950.59518.773計計算算參參數(shù)數(shù)輸輸入入1#控制點坐標2#控制點坐標12邊與13邊夾角（O)21邊與23邊夾角（Q)G(X)H(Y)E(X)F(Y) （度）（弧度） 781.2271323.385769.86

47、21428.98953334253.561666670.93482743650相相關關參參數(shù)數(shù)計計算算結結果果X增量Y增量1#至2#方位角（J)2#至1#方位角（J)12邊長13邊長mm弧度弧度(I)m（C）m-11.365105.604-83.8575247696.142475241.6780027444.819595106.21484.619架架站站點點坐坐標標計計算算結結果果架站點坐標架站點坐標P(X)Z(Y)P(X)Z(Y)843.5341380.641843.5341380.641（，）（，）（，）（度）（弧度）345550.581944440.88282147323邊長31邊與32

48、邊夾角(B)mV（弧度）88.1201.323943745計計算算參參數(shù)數(shù)輸輸入入21邊與23邊夾角（Q)相相關關參參數(shù)數(shù)計計算算結結果果13邊長（C）m84.619（，）（，）（，）參參考考橢橢球球元元素素值值輸輸入入處處坐標系名稱1954年北京坐標系 1980年西安坐標系 WGS-84坐標系(GPS)大地緯度（B)參考橢球名稱克拉索夫斯基橢球IUGG-1975橢球IUGG-1979橢球弧度a（長半軸）6378245637814063781372232 50 0.39352b（短半軸）6356863.0196356755.2886356752.314RA=N/(1+2cosA2)f（扁率）1

49、：298.31：298.2571：298.257223563e2（第一偏心率）0.0066934220.0066943850.00669438大地方位角（A)e，2（第二偏心率） 0.0067385250.0067395020.006739497弧度c（極曲率半徑）6399698.9026399596.6526399593.62615319 18 2.6759719541954年年北北京京坐坐標標系系中間參數(shù)中間參數(shù)子午圈曲率半徑卯酉圈曲率半徑平均曲率半徑=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V20.0758139891.0028697636344916.77563813

50、85.8396363125.1819801980年年西西安安坐坐標標系系中間參數(shù)中間參數(shù)子午圈曲率半徑卯酉圈曲率半徑平均曲率半徑=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V20.0758194811.0028701786344807.5196381281.246363018.245WGS-84WGS-84坐坐標標系系(GPS)(GPS)中間參數(shù)中間參數(shù)子午圈曲率半徑卯酉圈曲率半徑平均曲率半徑=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V20.0758194531.0028701766344804.566381278.2366363015.264任意法截弧曲率半

51、徑RA6352234.774任意法截弧曲率半徑RA6352126.447任意法截弧曲率半徑RA6352123.47919541954年年北北京京坐坐標標系系19801980年年西西安安坐坐標標系系WGS-84WGS-84坐坐標標系系(GPS)(GPS)參參考考橢橢球球元元素素值值數(shù)數(shù)據(jù)據(jù)輸輸入入處處坐標系名稱1954年北京坐標系 1980年西安坐標系 WGS-84坐標系(GPS)大地緯度（B)水平距離參考橢球名稱克拉索夫斯基橢球 IUGG-1975橢球IUGG-1979橢球弧度Da（長半軸）63782456378140637813722334 0.393593591.293b（短半軸）6356

52、863.0196356755.2886356752.314RA=N/(1+2cosA2)大地水準面相對參考橢球高度f（扁率）1：298.31：298.2571：298.2572235634.3e2（第一偏心率）0.0066934220.0066943850.00669438大地經度（A)高程e，2（第二偏心率）0.0067385250.0067395020.006739497弧度H c（極曲率半徑）6399698.9026399596.6526399593.626107412 1.8794435.419541954年年北北京京坐坐標標系系中間參數(shù)中間參數(shù)子午圈曲率半徑卯酉圈曲率半徑平均曲率半徑

53、任意法截弧曲率半徑=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V2RA0.0758118521.0028696016344919.846381386.8676363127.236378004.38919801980年年西西安安坐坐標標系系中間參數(shù)中間參數(shù)子午圈曲率半徑卯酉圈曲率半徑平均曲率半徑任意法截弧曲率半徑=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V2RA0.0758173441.0028700166344810.5856381282.2686363020.2956377899.355WGS-84WGS-84坐坐標標系系(GPS)(GPS)中間參數(shù)中間參數(shù)

54、子午圈曲率半徑卯酉圈曲率半徑平均曲率半徑任意法截弧曲率半徑=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V2RA0.0758173161.0028700146344807.6266381279.2646363017.3146377896.356邊長一端橫坐標y1210154邊長另一端橫坐標y2213577投影到橢球邊長值投影到高斯平面邊長值S0S03591.2706463593.252075投影到橢球邊長值投影到高斯平面邊長值S0S03591.2706463593.25214數(shù)數(shù)據(jù)據(jù)輸輸入入處處大地水準面相對參考橢球高度4.3參參考考橢橢球球元元素素值值輸輸入入處處坐標系名稱19

55、54年北京坐標系1980年西安坐標系 WGS-84坐標系(GPS)大地緯度（B)參考橢球名稱 克拉索夫斯基橢球 IUGG-1975橢球IUGG-1979橢球弧度a（長半軸）637824563781406378137533420.7170.935015142b（短半軸）6356863.0196356755.2886356752.314RA=N/(1+2cosA2)f（扁率）1：298.31：298.2571：298.257223563e2（第一偏心率） 0.0066934220.0066943850.00669438經度差（L)e，2（第二偏心率） 0.0067385250.0067395020

56、.006739497弧度c（極曲率半徑）6399698.9026399596.6526399593.62634552.1490.06570267219541954年年北北京京坐坐標標系系中間參數(shù)中間參數(shù)子午圈曲率半徑卯酉圈曲率半徑平均曲率半徑=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V20.0487446771.0011873176376957.5146392109.4426384528.983中間參數(shù)中間參數(shù)子午線弧長子午線收斂角子午線收斂角高斯平面坐標t=tanBm=COSB*LFN(X)1.3550010260.0390146575938430.2823.0304835

57、5230150.5945024.82619801980年年西西安安坐坐標標系系中間參數(shù)中間參數(shù)子午圈曲率半徑卯酉圈曲率半徑平均曲率半徑=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V20.0487482081.0011874896376852.3426392006.2166384424.783中間參數(shù)中間參數(shù)子午線弧長子午線收斂角子午線收斂角高斯平面坐標t=tanBm=COSBLFN(X)1.3550010260.0390146575938328.8713.03048355430150.5944923.308十進制（度）53.57242139L=經度-(經度)/3)*3(經度)/

58、3)取整數(shù)*33.764485833任意法截弧曲率半徑n=(L0+3)/6RAL0=6n-36377022.674n=L0/3L0=3nE(Y)249333.0957任意法截弧曲率半徑RA6376917.51E(Y)249329.0692輸輸入入處處大地緯度（B)RA=N/(1+2cosA2)經度差（L)19541954年年北北京京坐坐標標系系高斯平面坐標19801980年年西西安安坐坐標標系系高斯平面坐標參參考考橢橢球球元元素素值值實實例例說說明明坐標系名稱1954年北京坐標系1980年西安坐標系WGS-84坐標系(GPS)帶號 換算帶號已知P點在6度帶第21帶的坐標x=5728374.72

59、6參考橢球名稱克拉索夫斯基橢球IUGG-1975橢球IUGG-1979橢球2122y=21710198.193,求P點在6度帶第22帶坐標a（長半軸）637824563781406378137b（短半軸）6356863.0196356755.2886356752.314帶號輸入21，換算帶號輸入22f（扁率）1：298.31：298.2571：298.25722356高斯平面坐標X直接輸入x,Y輸入y去掉帶號21，e2（第一偏心率）0.0066934220.0066943850.00669438高斯平面坐標710198.193-500000=210198.193，Y輸入210198.193e，

60、2（第二偏心率） 0.0067385250.0067395020.006739497N(X)E(Y)結果：X=5728164.380, Y=22294920.035(已北京系為例）c（極曲率半徑）6399698.9026399596.6526399593.6265728374.726210198.19319541954年年北北京京坐坐標標系系中間參數(shù)底點緯度底點緯度中間參數(shù)中間參數(shù)中間參數(shù)已知P點在3度帶的坐標x=3272782.317（X-3)Bf（度）Bf(弧度）f2tfny=40444700.455,求P點在6度帶的坐標2.72837472651.684809740.9020701030