自编Excel测量计算程序.xls

《自编Excel测量计算程序.xls》由会员分享，可在线阅读，更多相关《自编Excel测量计算程序.xls（69页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

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)E(Y

2、)左+1,右-1（度）（弧度）RLS1LS284214.68529269.533354662.765113305413.515055560.235882218950120120133054.2基基本本要要素素结结果果表表内移值内移值切线增值切线增值ZH至JD方位角缓和曲线角缓和曲线角切线长p1p2q1q2（度）（弧度）1 2T10.6310.63159.99259.992133 4313133.72027782.3338591240.0630.063172.6331334313.0ZH至HY支矩坐标切线长圆曲线长曲线长JD至ZH方位角 JD至HZ方位角HZ至JD方位角N(x)E(y)T2LyL

3、（弧度）（弧度）（弧度）（度）（度）119.9522.526172.633104.088344.0885.4754517772.0979769065.239569559300.20522223001219曲曲线线主主点点桩桩号号、坐坐标标结结果果表表ZH桩号HY桩号路线方向QZ桩号YH桩号HZ桩号84042.04784162.047左+1,右-184214.09184266.13584386.135N(X)E(Y)N(X)E(Y)1N(X)E(Y)N(X)E(Y)N(X)529388.846354537.999529304.118354622.946529240.846354707.02352

4、9182.681备备注注：此此程程序序适适用用于于对对称称、不不对对称称缓缓和和曲曲线线以以及及圆圆曲曲线线，当当为为对对称称缓缓和和曲曲线线时时，LS1=LS2;LS1=LS2;当当为为圆圆曲曲线线时时，LS1=LS2=0LS1=LS2=0。涂涂红红处处输输入入变变量量K84+042.047至K84+386.135任意点桩号里程差W支矩x坐标支矩y坐标至起点距离切线角距中桩距离待求点坐标WCD(C2+D2)E左+,右-N(X)E(Y)8420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.2

5、57354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530

6、000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.039950867-6529275.516354648.7788420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.25

7、7354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.95300

8、00.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.2573

9、54652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.039950867-6529275.516354648.7788420037.9530000.0399508670529280.257354652.4578420037.953000

10、0.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.4578420037.9530000.0399508670529280.257354652.457返回程序目录HY至JD方位角（弧度）2.270701229E(Y)354811.960HZ桩号84386.135直直线线段段计计算算要要素素表表(已已知知条条件件)起算点桩号起算点坐标起算点至JD方位角（K）N G(X)H(Y)（度）（弧度）03648404.852450880.8481425052.6142.84795562.49316715414

11、25052.6任意点桩号里程差距中桩距离待求点坐标X待求点坐标YW左+，右-N(X)E(Y)63.75063.7505.7003648357.483450923.89260.15060.1505.7003648360.353450921.71863.75063.7501.3003648354.826450920.38560.15060.1501.3003648357.695450918.21196.60096.6005.7003648331.301450943.73192.70092.7005.7003648334.409450941.37696.60096.6001.3003648328.6

12、43450940.22492.70092.7001.3003648331.752450937.869129.200129.2005.7003648305.317450963.419125.500125.5005.7003648308.266450961.185129.200129.2001.3003648302.660450959.912125.500125.5001.3003648305.609450957.678161.850161.8505.7003648279.294450983.138158.200158.2005.7003648282.203450980.933161.850161

13、.8501.3003648276.637450979.631158.200158.2001.3003648279.546450977.426194.700194.7005.7003648253.112451002.977190.800190.8005.7003648256.220451000.621194.700194.7001.3003648250.454450999.470190.800190.8001.3003648253.563450997.114227.400227.4005.7003648227.049451022.725223.500223.5005.7003648230.157

14、451020.370227.400227.4001.3003648224.391451019.218223.500223.5001.3003648227.500451016.863259.950259.9505.7003648201.105451042.383256.350256.3505.7003648203.974451040.209259.950259.9501.3003648198.448451038.876256.350256.3501.3003648201.317451036.702292.600292.6005.7003648175.082451062.102289.100289

15、.1005.7003648177.871451059.988292.600292.6001.3003648172.424451058.595289.100289.1001.3003648175.214451056.481325.300325.3005.7003648149.019451081.850321.800321.8005.7003648151.808451079.736325.300325.3001.3003648146.361451078.343321.800321.8001.3003648149.151451076.230358.050358.0505.7003648122.916

16、451101.629354.450354.4505.7003648125.785451099.455358.050358.0501.3003648120.258451098.122354.450354.4501.3003648123.128451095.948390.650390.6505.7003648096.932451121.317387.250387.2505.7003648099.642451119.264390.650390.6501.3003648094.275451117.810387.250387.2501.3003648096.985451115.757423.350423

17、.3505.7003648070.869451141.066419.950419.9505.7003648073.579451139.012423.350423.3501.3003648068.212451137.559419.950419.9501.3003648070.922451135.505456.050456.0505.7003648044.806451160.814452.650452.6505.7003648047.516451158.761456.050456.0501.3003648042.149451157.307452.650452.6501.3003648044.859

18、451155.254488.750488.7505.7003648018.743451180.563485.350485.3505.7003648021.453451178.510488.750488.7501.3003648016.086451177.056485.350485.3501.3003648018.796451175.003521.500521.5005.7003647992.640451200.342518.000518.0005.7003647995.430451198.228521.500521.5001.3003647989.983451196.835518.000518

19、.0001.3003647992.773451194.7211200.0001200.0000.0003647448.409451605.5671220.0001220.0000.0003647432.468451617.6451240.0001240.0000.0003647416.528451629.7241260.0001260.0000.0003647400.587451641.8031280.0001280.0000.0003647384.646451653.8811300.0001300.0000.0003647368.706451665.9601320.0001320.0000.

20、0003647352.765451678.0391340.0001340.0000.0003647336.824451690.1171360.0001360.0000.0003647320.883451702.1961380.0001380.0000.0003647304.943451714.2741400.0001400.0000.0003647289.002451726.3531420.0001420.0000.0003647273.061451738.4321440.0001440.0000.0003647257.121451750.5101460.0001460.0000.000364

21、7241.180451762.5891480.0001480.0000.0003647225.239451774.6681500.0001500.0000.0003647209.298451786.7461520.0001520.0000.0003647193.358451798.8251540.0001540.0000.0003647177.417451810.9041560.0001560.0000.0003647161.476451822.9821580.0001580.0000.0003647145.536451835.0611600.0001600.0000.0003647129.5

22、95451847.1401620.0001620.0000.0003647113.654451859.2181640.0001640.0000.0003647097.713451871.2971660.0001660.0000.0003647081.773451883.3751680.0001680.0000.0003647065.832451895.4541700.0001700.0000.0003647049.891451907.5331720.0001720.0000.0003647033.951451919.6111740.0001740.0000.0003647018.0104519

23、31.6901760.0001760.0000.0003647002.069451943.7691780.0001780.0000.0003646986.128451955.8471800.0001800.0000.0003646970.188451967.9261820.0001820.0000.0003646954.247451980.0051840.0001840.0000.0003646938.306451992.0831860.0001860.0000.0003646922.366452004.1621880.0001880.0000.0003646906.425452016.241

24、1900.0001900.0000.0003646890.484452028.3191920.0001920.0000.0003646874.543452040.3981940.0001940.0000.0003646858.603452052.4771960.0001960.0000.0003646842.662452064.5551980.0001980.0000.0003646826.721452076.6342000.0002000.0000.0003646810.781452088.7122020.0002020.0000.0003646794.840452100.7912040.0

25、002040.0000.0003646778.899452112.8702060.0002060.0000.0003646762.959452124.9482080.0002080.0000.0003646747.018452137.0272100.0002100.0000.0003646731.077452149.1062120.0002120.0000.0003646715.136452161.1842140.0002140.0000.0003646699.196452173.2632160.0002160.0000.0003646683.255452185.3422180.0002180

26、.0000.0003646667.314452197.4202200.0002200.0000.0003646651.374452209.4992220.0002220.0000.0003646635.433452221.5782240.0002240.0000.0003646619.492452233.6562260.0002260.0000.0003646603.551452245.7352280.0002280.0000.0003646587.611452257.8132300.0002300.0000.0003646571.670452269.8922320.0002320.0000.

27、0003646555.729452281.9712340.0002340.0000.0003646539.789452294.0492360.0002360.0000.0003646523.848452306.1282380.0002380.0000.0003646507.907452318.2072400.0002400.0000.0003646491.966452330.2852420.0002420.0000.0003646476.026452342.3642440.0002440.0000.0003646460.085452354.4432460.0002460.0000.000364

28、6444.144452366.5212480.0002480.0000.0003646428.204452378.6002500.0002500.0000.0003646412.263452390.6792520.0002520.0000.0003646396.322452402.7572530.1532530.1530.0003646388.230452408.889返回程序目录方方位位角角计计算算程程序序 架站点待求点X增量Y增量角度角度方位角距离返回程序目录N(X)坐标E(Y)坐标N(X)坐标E(Y)坐标mm m 527560.240356531.589527797.084356095.

29、150236.844-436.439-61.51245298.487552982915496.562527560.240356531.589527785.084356095.864224.844-435.725-62.70521297.294792971741490.317527560.240356531.589527804.821356125.819244.581-405.770-58.92024301.079763010447473.782527560.240356531.589527794.912356118.617234.672-412.972-60.39259299.60741299

30、3627474.992527560.240356531.589527785.002356111.415224.762-420.174-61.8565298.14352980837476.513随机范围（+5，-15）（+5，-10）（+10，-15）3-1-8-3-10-11-10-10-11卵卵型型曲曲线线隐隐藏藏段段缓缓和和曲曲线线长长度度、完完整整缓缓和和曲曲线线长长、桩桩号号、坐坐标标及及方方位位角角计计算算转角方向缓和曲线参数曲线半径缓和曲线长卵型曲线长第二缓和曲线起点第二缓圆曲线起点计算方位角左+1,右-1AR1LS1LFY1HHY2（度）1345.965480140140.001

31、08326.250108466.253709.930N(X)E(Y)N(X)E(Y)142 2339142.3941667R2LS2512690.67370849.859409.878260140注：卵型曲线参数A=SQRT(ABS(LF*R1*R2)/(R1-R2)隐藏缓和曲线长 完整缓和曲线长隐藏点起算桩号 隐藏缓和曲线角起算点至JD方位角隐藏缓和曲线长在完整缓和曲线中支矩坐标起算点坐标起算点至JD方位角L0LSN 1KxyGHKK1050.0011938.464107276.2491.0937513.578998931.34727351.347346513683.157370926.09

32、99205.0615012050341.40Y1HY1H至至HY2HY2卵卵型型曲曲线线坐坐标标计计算算任意点桩号里程差W支矩x坐标支矩y坐标 至起点距离切线角距中桩距离待求点坐标WCD(C2+D2)E左+,右-N(X)E(Y)1084001123.751960.1950271419.29431047.7511.2527930512635.751370899.1891084251148.751967.4903844443.27521064.204 1.30915460512618.985370917.8221084251148.751967.4903844443.27521064.204 1.

33、30915460512618.985370917.8221084251148.751967.4903844443.27521064.204 1.30915460512618.985370917.8221084251148.751967.4903844443.27521064.204 1.30915460512618.985370917.8221084251148.751967.4903844443.27521064.204 1.30915460512618.985370917.8221084251148.751967.4903844443.27521064.204 1.309154605126

34、18.985370917.822（弧度）2.485247返回程序目录半径R取最小半径卵型曲线-1计算要素表(已知条件)交点桩号转角值转角值两交点距离曲线半径JD11（度）1（弧度）2（度）2（弧度）AB R1615495.4230.98872220.540855231.032416670.01801907113.599480基基本本要要素素计计算算表表内移值切线增值切线长切线长缓和曲线角曲线长圆曲线长p1q1T1TA 1L1Ly10.13919.999153.102133.1030.083279.611214.812内移值切线增值切线长切线长缓和曲线角曲线长圆曲线长p2q2T2TB 2L2Ly

35、20.34414.99115.9750.9840.27616.962-37.837曲曲线线主主点点桩桩号号基基本本要要素素计计算算表表ZHHY1Y1HGQHY2Y2HHZ615342.318615382.318615597.130615621.928615646.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，试试计计算算卵卵形形曲曲线线要要素素和和主主点点桩桩号号。缓和曲线长卵型曲线长曲线半径缓和曲线

36、长LS1LFR2LS24049.60108.87530外矩E1返回程序目录18.247外矩E20.349卵卵形形曲曲线线计计算算：已已知知a1=5030，a2=4202，AB=70.78m，R1=60m，Ls1=40m，R2=108.87m，Ls2=30m，LF=49.60m，JD1=K5+300，试试计计算算卵卵形形曲曲线线要要素素和和主主点点桩桩号号。大广公路固安（京冀界）至深州段高速公路 导导 线线 测测 量量 平平 差差 计计 算算 表表 承包单位：中交第二航务工程局有限公司合同号：LM10监理单位：河北通达工程监理咨询有限公司 编 号：05-04点号转角值(左角)方向角边长(m)坐标

37、增量计算值坐标增量改正值改正后的增量平差后的坐标观测值改正值改正后值sxyxyxyXYJ252280622A24915748140.715748154246777.250473471.4642055437461.346-414.971-201.591-0.00520.0040-414.976-201.587LM1215649270.715649284246362.274473269.8771824405307.382-307.032-14.665-0.00340.0027-307.035-14.662J2619408140.719408144246055.238473255.215196521

38、9427.575-409.171-124.096-0.00480.0037-409.175-124.092C1018925110.718925114245646.063473131.1222061730468.719-420.230-207.615-0.00520.0041-420.236-207.611LM137259380.77259384245225.827472923.512991708138.015-22.269136.206-0.00150.0012-22.271136.208J2827712470.727712484245203.556473059.7191962956412.4

39、63-395.480-117.138-0.00460.0036-395.485-117.134J2917323040.717323044244808.071472942.5851895300317.749-313.033-54.539-0.00360.0028-313.037-54.536BO118920530.718920544244495.034472888.0491991354529.452-499.906-174.395-0.00590.0046-499.912-174.390LM1417244390.717244404243995.123472713.6591915833554.31

40、8-542.253-115.021-0.00620.0048-542.259-115.017LM1518834080.718834094243452.863472598.6422003242402.619-377.011-141.296-0.00450.0035-377.016-141.293LM1616716370.716716384243075.848472457.3491874920430.529-426.523-58.594-0.00480.0037-426.528-58.591LM1716944540.716944554242649.320472398.7591773414217.2

41、68-217.0739.209-0.00240.0019-217.0759.211LM1818708060.718708064242432.245472407.9701844221224.688-223.931-18.433-0.00250.0020-223.933-18.431LM1920710420.720710424242208.311472389.5392115303163.767-139.058-86.502-0.00180.0014-139.059-86.501G0914818570.714818574242069.252472303.0381801200测站数n15打印时 起点方

42、位角2280622起点坐标4246777.250473471.464隐藏26520528终点方位角1801200终点坐标4242069.252472303.0382652052810265205385055.890-4707.941-1168.470-0.0570.044-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合格计算：复核：负责人：日期：LM1920710420.720710424

43、242208.311472389.539点号返回程序目录J25A249LM12J26C10LM13J28J29BO1LM14LM15LM16LM17LM18LM19G09LM19大广公路固安（京冀界）至深州段高速公路水水 准准 点点 平平 差差 计计 算算 表表承包单位：中交第二航务工程局有限公司 合同号：LM10监理单位：河北通达工程监理咨询有限公司 编 号：07-01点号站数或距离实测高差平均高差改正数改正后高差 平差后高程点号L第一次第二次mmmmGPS6713.968GPS67G01-11600.0190.0200.020-0.00210.01713.985G01-1BM0180-0.

44、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.408-0.407-0.408-0.0034-0.41113.287J03LM033110.4760.4730.475-0.00400.47013.758LM03A2311970.4210.4230.422-0.00250.41914

45、.177A2311.820.2300.2350.233-0.0240.209h=H终-H始=0.209Fh=h测-(H终-H始）=24H始=13.968Fh容=20L 27FhFh容合格,可以平差H终=14.177计算:复核:负责人：日期:返回程序目录大广公路固安（京冀界）至深州段高速公路四四等等水水准准测测量量观观测测记记录录表表承包单位：中交第二航务工程局有限公司 合同号：LM10监理单位：河北通达工程监理咨询有限公司 编 号：02-02测站编号点号后尺上丝前尺上丝方水准尺读数K+黑平均高差下丝下丝向减后 距前 距及黑面红面视距差dd尺 号红（m）GPS6719581945后1562635

46、0-111671142前15436230079.180.3后-前19120-10.020-1.2-1.2G01-111641360后96356500763966前11635949140.139.4后-前-200-299-1-0.2000.7-0.5BM018681158后53153171195474前8155500267.368.4后-前-284-183-1-0.284-1.1-1.613181095后99256781665429前7625549065.366.6后-前23012910.230-1.3-2.9LM0112671491后98757731705946前12185906-156.25

47、4.5后-前-231-1332-0.2321.7-1.212231390后87255581521698前10445829270.269.2后-前-172-271-1-0.1721-0.2C215481431后123660221925822前11265813062.360.9后-前11020910.1101.41.222852001后18626549014391176前15886375084.682.5后-前27417400.2742.13.3每页校核后-前=-0.508后-前=-0.508总视距差=3.3后=55.902总视距d=1046.9前=56.41总高差=-0.254测量：记录：复核：

48、备注返回程序目录0.020-0.200-0.054-0.4040.384 合同号：LM10 编 号：02-02大广公路固安（京冀界）至深州段高速公路四四等等水水准准测测量量观观测测记记录录表表承包单位：中交第二航务工程局有限公司 合同号：LM10监理单位：河北通达工程监理咨询有限公司 编 号：测站编号点号后尺下丝前尺下丝方水准尺读数K+黑平均高差备注上丝上丝向减后 距前 距及黑面红面视距差dd尺 号红（m）GPS6719571945后15626350-10.02011671141前1543623007980.4后-前19120-10.020-1.4-1.4G01-111641360后96356

49、500-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后-前23012910.230-1.2-3LM0112671490后98757731707946前12185906-15654.4后-前-231-1332-0.2321.6-1.412231390后87255581-0.404521698前10445

50、829270.269.2后-前-172-271-1-0.1721-0.4C215481430后123660221924822前11265813062.460.8后-前11020910.1101.61.222852000后1862654900.38414391176前15886375084.682.4后-前27417400.2742.23.4每页校核后-前=-0.508后-前=-0.508总视距差=3.4后=55.902总视距d=1047前=56.41总高差=-0.254测量：记录：复核：返回程序目录计计算算参参数数输输入入1#控制点坐标2#控制点坐标架站点至1#距离架站点至2#距离G(X)H(