自编Excel测量计算程序

1、程序目录曲线主点桩号与坐标计算!A1直线段坐标计算!A1方位角计算及随机!A1卵型曲线隐藏计算!A1卵型曲线主点桩号计算!A1附合导线平差!A1水准平差!A1四等水准!A1四等水准数据反推!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卵卵型型曲曲线线隐隐藏藏段段缓缓和和曲曲线线长长度度、完完整整缓缓和和曲曲线线长长、桩桩号号、坐坐标标及及方方位位角角计计算算转角方向缓和曲线参数曲线半径缓和曲线长卵型曲线长第二缓和曲线起点第二缓圆曲线起点计算方位角左+1,右-1AR1LS1LFY1HHY2 （度）（弧度）1345.965480140140.00108326.250108466.253709.930N(X)E(Y)N(X)E(Y)142 2339142.39416672.48524704R2LS2512690.665370849.859409.878260140注：卵型

22、曲线参数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监理单位：河北通达工程监理咨询有限公司 编 号：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测站数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监理单位：河北通达工程监理咨询有限公司 编 号：

34、07-01点号站数或距离实测高差平均高差改正数改正后高差 平差后高程点号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监理单位：河北通达工程监理咨询有限公司 编 号：02-02测站编号点号后尺上丝前尺上丝方水准尺读数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监理单位：河北通达工程监理咨询有限公司 编 号：测站编号点号后尺下丝前尺下丝方水准尺读数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测量：记录：复核：计计算算参参数数输输入入1#控制点坐标2#控制点坐标架站点至1#距离架站点至2#距离G(X)H(Y)E(X)F(Y)BC100100200300250150相相关关参参数数计计算算结结果果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）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相相关关参参数数计计算算结结果果坡度差曲线长切线长外矩起点桩号终点桩号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计计算算参参数数输输入入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相相关关参参数数计计算算结结果果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计计算算参参数数输输入入21边与23边夹角（Q)相相关关参参数数计计算算结结果果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年年北北京京坐坐标标系系中间参数中间参数子午圈曲率半径卯酉圈曲率半径平均曲率半径=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V20.0758139891.0028697636344916.77563813

50、85.8396363125.1819801980年年西西安安坐坐标标系系中间参数中间参数子午圈曲率半径卯酉圈曲率半径平均曲率半径=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V20.0758194811.0028701786344807.5196381281.246363018.245WGS-84WGS-84坐坐标标系系(GPS)(GPS)中间参数中间参数子午圈曲率半径卯酉圈曲率半径平均曲率半径=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)参参考考椭椭球球元元素素值值数数据据输输入入处处坐标系名称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年年北北京京坐坐标标系系中间参数中间参数子午圈曲率半径卯酉圈曲率半径平均曲率半径

53、任意法截弧曲率半径=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V2RA0.0758118521.0028696016344919.846381386.8676363127.236378004.38919801980年年西西安安坐坐标标系系中间参数中间参数子午圈曲率半径卯酉圈曲率半径平均曲率半径任意法截弧曲率半径=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V2RA0.0758173441.0028700166344810.5856381282.2686363020.2956377899.355WGS-84WGS-84坐坐标标系系(GPS)(GPS)中间参数中间参数

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数数据据输输入入处处大地水准面相对参考椭球高度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年年北北京京坐坐标标系系中间参数中间参数子午圈曲率半径卯酉圈曲率半径平均曲率半径=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V20.0487446771.0011873176376957.5146392109.4426384528.983中间参数中间参数子午线弧长子午线收敛角子午线收敛角高斯平面坐标t=tanBm=COSB*LFN(X)1.3550010260.0390146575938430.2823.0304835

57、5230150.5945024.82619801980年年西西安安坐坐标标系系中间参数中间参数子午圈曲率半径卯酉圈曲率半径平均曲率半径=e，cosBV=1+2M=C/V3N=C/VR=MN=C/V20.0487482081.0011874896376852.3426392006.2166384424.783中间参数中间参数子午线弧长子午线收敛角子午线收敛角高斯平面坐标t=tanBm=COSBLFN(X)1.3550010260.0390146575938328.8713.03048355430150.5944923.308十进制（度）53.57242139L=经度-(经度)/3)*3(经度)/

58、3)取整数*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年年北北京京坐坐标标系系中间参数底点纬度底点纬度中间参数中间参数中间参数已知P点在3度带的坐标x=3272782.317（X-3)Bf（度）Bf(弧度）f2tfny=40444700.455,求P点在6度带的坐标2.72837472651.684809740.9020701030