excel测量程序--曲线主点桩号与坐标计算

1、曲曲线线计计算算要要素素表表( (已已知知条条件件) )交点桩号交点坐标转角值方向转角值曲线半径缓和曲线长缓和曲线长JDN(X)E(Y)左+1,右-1 （度）（弧度）RLS1LS2690019.5794399211.965498370.5277142262642.440594440.740728118000570570422626.1基基本本要要素素结结果果表表内移值内移值切线增值切线增值ZH至JD方位角缓和曲线角缓和曲线角切线长p1p2q1q2 （度）（弧度） 1 2T11.6921.692284.988284.9882932022293.33953335.1197406830.0360.0

2、363391.9012932022.3ZH至HY支矩坐标切线长圆曲线长曲线长JD至ZH方位角 JD至HZ方位角HZ至JD方位角HY至JD方位角N(x)E(y)T2LyL（弧度）（弧度）（弧度）（度）（度）（弧度）569.9286.7683391.9015355.8256495.8251.9781480294.3790125731.2374199270.898938897053565.084115683曲曲线线主主点点桩桩号号、坐坐标标结结果果表表ZH桩号HY桩号路线方向QZ桩号YH桩号HZ桩号686627.678687197.678左+1,右-1689875.590692553.5036931

3、23.503N(X)E(Y)N(X)E(Y)1N(X)E(Y)N(X)E(Y)N(X)E(Y)4397868.165501484.8814398087.744500958.9074398282.120495706.1394398102.015495165.375备备注注：此此程程序序适适用用于于对对称称、不不对对称称缓缓和和曲曲线线以以及及圆圆曲曲线线，当当为为对对称称缓缓和和曲曲线线时时，LS1=LS2;LS1=LS2;当当为为圆圆曲曲线线时时，LS1=LS2=0LS1=LS2=0。涂涂红红处处输输入入变变量量K686+627.678至K693+123.503任意点桩号里程差W支矩x坐标支矩

4、y坐标至起点距离切线角距中桩距离待求点坐标WCD(C2+D2)E左+,右-N(X)E(Y)687197.6780.0000003.81386E-0804398087.744500958.907686800172.322172.32212240.187028618172.32222390.00325602804397936.264501326.585686900272.322272.32050450.738127693272.32150480.00813151704397975.375501234.551687000372.322372.31370311.886400505372.3184820

5、.01519998904398013.936501142.285687100472.322472.29404393.851063778472.30974430.02446144304398051.742501049.7076872002.3220000.00029028804398088.587500956.743687300102.3220000.01279028804398124.299500863.338687400202.3220000.02529028804398158.841500769.494687500302.3220000.03779028804398192.20750067

6、5.225687600402.3220000.05029028804398224.392500580.547687700502.3220000.06279028804398255.391500485.474687800602.3220000.07529028804398285.200500390.020687900702.3220000.08779028804398313.813500294.202688000802.3220000.10029028804398341.226500198.033688100902.3220000.11279028804398367.434500101.5306

7、882001002.3220000.12529028804398392.435500004.7064398158.8406883001102.3220000.13779028804398416.223499907.5776884001202.3220000.15029028804398438.795499810.1594398438.7956885001302.3220000.16279028804398460.148499712.4666886001402.3220000.17529028804398480.278499614.5136887001502.3220000.1877902880

8、4398499.182499516.3176888001602.3220000.20029028804398516.857499417.8926889001702.3220000.21279028804398533.301499319.2546890001802.3220000.22529028804398548.510499220.4186891001902.3220000.23779028804398562.483499121.4006892002002.3220000.25029028804398575.217499022.2146893002102.3220000.2627902880

9、4398586.710498922.8786894002202.3220000.27529028804398596.960498823.4056895002302.3220000.28779028804398605.967498723.8126896002402.3220000.30029028804398613.728498624.1146897002502.3220000.31279028804398620.242498524.3276898002602.3220000.32529028804398625.508498424.4676899002702.3220000.337790288-64398635.522498324.7526900002802.3220000.35029028804398632.294498224.5876901002902.3220000.362790