自編Excel測(cè)量計(jì)算程序

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

2、)E(Y)左+1,右-1 （度）（弧度）RLS1LS211300.5983561841.022537361.4111943239.7231666670.16970127240000094323.基基本本要要素素結(jié)結(jié)果果表表內(nèi)移值內(nèi)移值切線增值切線增值ZH至JD方位角緩和曲線角緩和曲線角切線長p1p2q1q2 （度）（弧度） 1 2T10.0000.0000.0000.0001893554189.598253.3091137190.0000.000340.2191893554.ZH至HY支矩坐標(biāo)切線長圓曲線長曲線長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曲曲線線主主點(diǎn)點(diǎn)樁樁號(hào)號(hào)、坐坐標(biāo)標(biāo)結(jié)結(jié)果果表表ZH樁號(hào)HY樁號(hào)路線方向QZ樁號(hào)YH樁號(hào)HZ樁號(hào)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備備注注：此此程程序序適適用用于于對(duì)對(duì)稱稱、不不對(duì)對(duì)稱稱緩緩和和曲曲線線以以及及圓圓曲曲線線，當(dāng)當(dāng)為為對(duì)對(duì)稱稱緩緩和和曲曲線線時(shí)時(shí)，LS1=LS2;LS1=LS2;當(dāng)當(dāng)為為圓圓曲曲線線時(shí)時(shí)，LS1=LS2=0LS1=LS2=0。涂涂紅紅處處輸輸入入變變量量K10+960.379至K11+639.184任意點(diǎn)樁號(hào)里程差W支矩x坐標(biāo)支矩y坐標(biāo)至起點(diǎn)距離切線角距中樁距離待求點(diǎn)坐標(biāo)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直直線線段段計(jì)計(jì)算算要要素素表表( (已已知知條條件件) )起算點(diǎn)樁號(hào)起算點(diǎn)坐標(biāo)起算點(diǎn)至JD方位角（K）N G(X)H(Y) （度）（弧度）10729.0012404.61787456.71911893553.7189.598253.3091137191893554.任意點(diǎn)樁號(hào)里程差距中樁距離待求點(diǎn)坐標(biāo)X待求點(diǎn)坐標(biāo)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方方位位角角計(jì)計(jì)算算程程序序 架站點(diǎn)待求點(diǎn)X增量Y增量角度角度方位角距離N(X)坐標(biāo)E(Y)坐標(biāo)N(X)坐標(biāo)E(Y)坐標(biāo)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隨機(jī)范圍（+5，-15）（+5，-

21、10）（+10，-15）-505-11-109-5-1-7卵卵型型曲曲線線隱隱藏藏段段緩緩和和曲曲線線長長度度、完完整整緩緩和和曲曲線線長長、樁樁號(hào)號(hào)、坐坐標(biāo)標(biāo)及及方方位位角角計(jì)計(jì)算算轉(zhuǎn)角方向緩和曲線參數(shù)曲線半徑緩和曲線長卵型曲線長第二緩和曲線起點(diǎn)第二緩圓曲線起點(diǎn)計(jì)算方位角左+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)隱藏緩和曲線長 完整緩和曲線長隱藏點(diǎn)起算樁號(hào) 隱藏緩和曲線角起算點(diǎn)至JD方位角隱藏緩和曲線長在完整緩和曲線中支矩坐標(biāo)起算點(diǎn)坐標(biāo)起算點(diǎn)至JD方位角半徑L0LSN 1KxyGHKKR1050.0011938.464107276.2491.0937513 3.5789984 931.347271351.347346513683.1568370926.0999205.06150072050341.取最小半徑Y(jié)1HY1H至至HY2HY2卵卵型型曲曲線線坐坐標(biāo)標(biāo)計(jì)計(jì)算算任意點(diǎn)樁號(hào)里程差W支矩x坐標(biāo)支矩y坐標(biāo) 至起點(diǎn)距離切線角距中樁距離待求點(diǎn)坐

23、標(biāo)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計(jì)算要素表(已知條件)交點(diǎn)樁號(hào)轉(zhuǎn)角值轉(zhuǎn)角值兩交點(diǎn)距離曲線半徑緩和曲線長JD11

25、（度）1（弧度）2（度）2（弧度）AB R1LS1615495.4230.98872222 0.540855234 1.0324166670.01801907113.59948040基基本本要要素素計(jì)計(jì)算算表表內(nèi)移值切線增值切線長切線長緩和曲線角曲線長圓曲線長外矩p1q1T1TA 1L1Ly1E10.13919.999153.102133.1030.083279.611214.81218.247內(nèi)移值切線增值切線長切線長緩和曲線角曲線長圓曲線長外矩p2q2T2TB 2L2Ly2E20.34414.99115.9750.9840.27616.962-37.8370.349曲曲線線主主點(diǎn)點(diǎn)樁樁號(hào)號(hào)

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

27、速公路 導(dǎo)導(dǎo) 線線 測(cè)測(cè) 量量 平平 差差 計(jì)計(jì) 算算 表表 承包單位：中交第二航務(wù)工程局有限公司合同號(hào)：LM10監(jiān)理單位：河北通達(dá)工程監(jiān)理咨詢有限公司 編 號(hào)：05-04點(diǎn)號(hào)轉(zhuǎn)角值(左角)方向角邊長(m)坐標(biāo)增量計(jì)算值坐標(biāo)增量改正值改正后的增量平差后的坐標(biāo)點(diǎn)號(hào)觀測(cè)值改正值改正后值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測(cè)站數(shù)n15打印時(shí) 起點(diǎn)方位角2280622起點(diǎn)坐標(biāo)4246777.250473471.464隱藏26520528終點(diǎn)方位角1801200終點(diǎn)坐標(biāo)4242069.252472303.0382652052810265205385055.890-4707.941 -1168.470-0.0570.04

33、4-4707.998 -1168.426輔助計(jì)算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合格計(jì)算：復(fù)核：負(fù)責(zé)人：日期：2115303163.767-139.058-86.502-0.00180.0014-139.059-86.501大廣公路固安（京冀界）至深州段高速公路水水 準(zhǔn)準(zhǔn) 點(diǎn)點(diǎn) 平平 差差 計(jì)計(jì) 算算 表表承包單位：中交第二航務(wù)工程局有限公司 合同號(hào)：LM10監(jiān)理單位：河北通達(dá)工程監(jiān)理咨詢有限公司 編 號(hào)：

34、07-01點(diǎn)號(hào)站數(shù)或距離實(shí)測(cè)高差平均高差改正數(shù)改正后高差 平差后高程點(diǎn)號(hào)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測(cè)-(H終-H始）= 24H始= 13.968Fh容=20L 27FhFh容合格,可以平差H終= 14.177計(jì)算: 復(fù)核: 負(fù)責(zé)人： 日期:大廣公路固安（京冀界）至深州段高速公路四四等等水水準(zhǔn)準(zhǔn)測(cè)測(cè)量量觀觀測(cè)測(cè)記記錄錄表表承包單位：中交第二航務(wù)工程局

36、有限公司 合同號(hào)：LM10監(jiān)理單位：河北通達(dá)工程監(jiān)理咨詢有限公司 編 號(hào)：02-02測(cè)站編號(hào)點(diǎn)號(hào)后尺上絲前尺上絲方水準(zhǔn)尺讀數(shù)K + 黑平均高差備注下絲下絲向減后 距前 距及黑面紅面視距差dd尺 號(hào)紅（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測(cè)量：記錄：復(fù)核：大廣公路固安（京冀界）至深州段高速公路四四等等水水準(zhǔn)準(zhǔn)測(cè)測(cè)量量觀觀測(cè)測(cè)記記錄錄表表承包單位：中交第二航務(wù)工程局有限公司 合同號(hào)：LM10監(jiān)理單位：河北通達(dá)工程監(jiān)理咨詢有限公司 編 號(hào)：測(cè)站編號(hào)點(diǎn)號(hào)后尺下絲前尺下絲方水準(zhǔn)尺讀數(shù)K + 黑平均高差備注上絲上絲向減

39、后 距前 距及黑面紅面視距差dd尺 號(hào)紅（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測(cè)量：記錄：復(fù)核：計(jì)計(jì)算算參參數(shù)數(shù)輸輸入入1#控制點(diǎn)坐標(biāo)2#控制點(diǎn)坐標(biāo)架站點(diǎn)至1#距離架站點(diǎn)至2#距離G(X)H(Y)E(X)F(Y)BC100100200300250150相相關(guān)關(guān)參參數(shù)數(shù)計(jì)計(jì)算算結(jié)結(jié)果果X增量Y增量角度角度1#至2#方位角（J)1#至2#距離(I)mm 弧度 m 100.000200.00063.4349488263.434948826326061.107223.60712邊與13邊1#至架站點(diǎn)12邊與23邊2#至3#方位角2

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

43、標(biāo)半徑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圓心點(diǎn)至ZY方位角圓心點(diǎn)坐標(biāo)（K）弧度度 G(X)H(Y)2.800160.42283191602522.6178.0628377222.737102任意點(diǎn)樁號(hào)里程差圓心角距中樁距離待求點(diǎn)坐標(biāo)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左轉(zhuǎn)彎右轉(zhuǎn)彎（，）（，）曲線長路線方向L左+，右-85.2161夾角ZY至圓心點(diǎn)方位角（Q

45、）弧度（J+Q）弧度1.243042481-0.342左轉(zhuǎn)彎右轉(zhuǎn)彎（，）（，）已已知知條條件件變坡點(diǎn)樁號(hào)變坡點(diǎn)高程前坡段坡度后坡段坡度豎曲線半徑豎曲線類型mm(i1)%(i2)%R凸-1，凹+1K137+230.00019.4741.6733-0.353517000-1相相關(guān)關(guān)參參數(shù)數(shù)計(jì)計(jì)算算結(jié)結(jié)果果坡度差曲線長切線長外矩起點(diǎn)樁號(hào)終點(diǎn)樁號(hào)LTEmm0.020268344.556172.2780.873K137+057.722K137+402.278豎豎曲曲線線設(shè)設(shè)計(jì)計(jì)高高程程計(jì)計(jì)算算里程樁號(hào)直坡高程高程改正值設(shè)計(jì)高程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計(jì)計(jì)算算參參數(shù)數(shù)輸輸入入1#控制點(diǎn)坐標(biāo)2#控制點(diǎn)坐標(biāo)12邊與13邊夾角（O)21邊與23邊夾角（Q)G(X)H(Y)E(X)F(Y) （度）（弧度） 781.2271323.385769.86

47、21428.98953334253.561666670.93482743650相相關(guān)關(guān)參參數(shù)數(shù)計(jì)計(jì)算算結(jié)結(jié)果果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架架站站點(diǎn)點(diǎn)坐坐標(biāo)標(biāo)計(jì)計(jì)算算結(jié)結(jié)果果架站點(diǎn)坐標(biāo)架站點(diǎn)坐標(biāo)P(X)Z(Y)P(X)Z(Y)843.5341380.641843.5341380.641（，）（，）（，）（度）（弧度）345550.581944440.88282147323邊長31邊與32

48、邊夾角(B)mV（弧度）88.1201.323943745計(jì)計(jì)算算參參數(shù)數(shù)輸輸入入21邊與23邊夾角（Q)相相關(guān)關(guān)參參數(shù)數(shù)計(jì)計(jì)算算結(jié)結(jié)果果13邊長（C）m84.619（，）（，）（，）參參考考橢橢球球元元素素值值輸輸入入處處坐標(biāo)系名稱1954年北京坐標(biāo)系 1980年西安坐標(biāo)系 WGS-84坐標(biāo)系(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年年北北京京坐坐標(biāo)標(biāo)系系中間參數(shù)中間參數(shù)子午圈曲率半徑卯酉圈曲率半徑平均曲率半徑=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V20.0758139891.0028697636344916.77563813

50、85.8396363125.1819801980年年西西安安坐坐標(biāo)標(biāo)系系中間參數(shù)中間參數(shù)子午圈曲率半徑卯酉圈曲率半徑平均曲率半徑=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V20.0758194811.0028701786344807.5196381281.246363018.245WGS-84WGS-84坐坐標(biāo)標(biāo)系系(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年年北北京京坐坐標(biāo)標(biāo)系系19801980年年西西安安坐坐標(biāo)標(biāo)系系WGS-84WGS-84坐坐標(biāo)標(biāo)系系(GPS)(GPS)參參考考橢橢球球元元素素值值數(shù)數(shù)據(jù)據(jù)輸輸入入處處坐標(biāo)系名稱1954年北京坐標(biāo)系 1980年西安坐標(biāo)系 WGS-84坐標(biāo)系(GPS)大地緯度（B)水平距離參考橢球名稱克拉索夫斯基橢球 IUGG-1975橢球IUGG-1979橢球弧度Da（長半軸）63782456378140637813722334 0.393593591.293b（短半軸）6356

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

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

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

55、54年北京坐標(biāo)系1980年西安坐標(biāo)系 WGS-84坐標(biāo)系(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經(jīng)度差（L)e，2（第二偏心率） 0.0067385250.0067395020

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

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

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)經(jīng)度差（L)19541954年年北北京京坐坐標(biāo)標(biāo)系系高斯平面坐標(biāo)19801980年年西西安安坐坐標(biāo)標(biāo)系系高斯平面坐標(biāo)參參考考橢橢球球元元素素值值實(shí)實(shí)例例說說明明坐標(biāo)系名稱1954年北京坐標(biāo)系1980年西安坐標(biāo)系WGS-84坐標(biāo)系(GPS)帶號(hào) 換算帶號(hào)已知P點(diǎn)在6度帶第21帶的坐標(biāo)x=5728374.72

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

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