EXCEL曲线坐标计算系统

1、目目 录录1、竖曲线计算程序2、路线中边桩坐标计算程序3、坐标反算程序4、涵洞坐标计算程序5、附合导线近似平差程序6、缓、圆曲线坐标计算程序7、坐标计算面积程序编写：刘辉 QQ：108100808竖竖曲曲线线计计算算程程序序计计算算示示例例交点桩号:K9+080.000交点标高:190.6半径:12439.47起点坡度i%-0.00519终点坡度i%0.0343T:245.5551此曲线是：1凹曲线待求点桩号计算坡度 边坡标高 实测标高(左)距离实测标高(右)距离待求点标高K9+460.0000.0343 203.375191.11734.95191.11734.95203.630K7+800

2、.0000.0052 196.988191.11721.81191.11721.81197.243K8+880.0000.0052 191.466191.11713.52191.11713.52191.721K8+900.0000.0052 191.452189.36416.13189.36416.13191.707K8+920.0000.0052 191.470191.725K8+940.0000.0052 191.519191.774K8+960.0000.0052 191.601191.856K8+980.0000.0052 191.716191.971K9+000.0000.0052

3、191.862192.117本表自动计算竖曲线各点标高K9+020.0000.0052 192.040192.295除黑框内数值可填写外,其它K9+040.0000.0052 192.251192.506 数值请勿随便改动，将影响到整个K9+060.0000.0052 192.494192.749 数值计算区的计算准确性. K9+080.0000.0343 192.769193.024K9+100.0000.0343 193.076193.331本表自动判断是凹或凸曲线及根据桩号K9+120.0000.0343 193.415193.670自动判断是位于直线段还是竖曲线段K9+140.0000

4、.0343 193.786194.041 K9+160.0000.0343 194.190194.445K9+180.0000.0343 194.626194.881K9+200.0000.0343 195.093195.348K9+220.0000.0343 195.593195.848K9+240.0000.0343 196.126196.381 K9+260.0000.0343 196.690196.945K9+280.0000.0343 197.286197.541K9+300.0000.0343 197.915198.170K9+320.0000.0343 198.576198.83

5、1K9+340.0000.0343 199.260199.515K9+360.0000.0343 199.946200.201 直 线 段起 点 段 直 线 段竖 曲 线 段终 点 段 计算: 复核: 日期:第4页,共15页线线路路放放样样坐坐标标计计算算成成果果表表桩桩号号边边桩桩( (左左+ +右右-)-)X X坐坐标标Y Y坐坐标标左左侧侧方方位位角角K7+240.000左10572204.173496036.385133.4513K7+260.000右10572203.558496008.107133.4513K7+280.000572182.196496001.499133.4513

6、K7+300.000572167.750495987.668133.4513K7+320.000572153.303495973.837133.4513K7+340.000572138.857495960.006133.4513K7+360.000572124.411495946.175133.4513K7+380.000572109.964495932.344133.4513K7+400.000572095.518495918.512133.4513K7+420.000572081.071495904.681133.4513K7+440.000572066.625495890.850133.

7、4513K7+460.000572052.179495877.019133.4513K7+480.000572037.732495863.188133.4513K7+500.000572023.286495849.357133.4513K7+520.000572008.839495835.525133.4513K7+540.000571994.393495821.694133.4513K7+560.000571979.946495807.863133.4513K7+580.000571965.500495794.032133.4513K7+600.000571951.054495780.201

8、133.4513K7+620.000571936.607495766.370133.4513K7+640.000571922.161495752.538133.4513K7+660.000571907.714495738.707133.4513K7+680.000571893.268495724.876133.4513K7+700.000571878.822495711.045133.4513K7+720.000571864.375495697.214133.4513K7+740.000571849.929495683.383133.4513K7+760.000571835.482495669

9、.551133.4513K7+780.000571821.036495655.720133.4513K7+800.000571806.590495641.889133.4513K7+820.000571792.143495628.058133.4513K7+840.000571777.697495614.227133.4513K7+860.000571763.250495600.396133.4513K7+880.000571748.804495586.564133.4513K7+900.000571734.358495572.733133.4513K7+920.000571719.91149

10、5558.902133.4513K7+940.000571705.465495545.071133.4513K7+960.000571691.031495531.227133.5450K7+980.000571676.654495517.324134.0960K8+000.000571662.338495503.357134.2510K8+020.000571648.084495489.328134.4019K8+040.000571633.892495475.235134.5529K8+060.000571619.763495461.081135.1039K8+080.000571605.6

11、96495446.864135.2549K8+100.000571591.692495432.585135.4058K8+120.000571577.751495418.245135.5608K8+140.000571563.873495403.843136.1118 计算: 复核: 日期:第5页,共15页线线路路放放样样坐坐标标计计算算成成果果表表桩桩号号边边桩桩( (左左+ +右右-)-)X X坐坐标标Y Y坐坐标标左左侧侧方方位位角角K8+160.000571550.059495389.380136.2628K8+180.000571536.309495374.856136.4138K8

12、+200.000571522.624495360.272136.5647K8+220.000571509.002495345.628137.1157K8+240.000571495.446495330.923137.2707K8+260.000571481.954495316.159137.4217K8+280.000571468.528495301.336137.5726K8+300.000571455.167495286.454138.1236K8+320.000571441.872495271.512138.2746K8+340.000571428.643495256.513138.42

13、56K8+360.000571415.480495241.455138.5806K8+380.000571402.383495226.339139.1315K8+400.000571389.354495211.166139.2825K8+420.000571376.392495195.935139.4335K8+440.000571363.497495180.647139.5845K8+460.000571350.669495165.303140.1354K8+480.000571337.909495149.902140.2904K8+500.000571325.218495134.44514

14、0.4414K8+520.000571312.594495118.932140.5924K8+540.000571300.039495103.363141.1433K8+560.000571287.553495087.740141.2943已已知知坐坐标标点点X0X045858.21已已知知坐坐标标点点Y0Y036542.32待待求求点点X1X1待待求求点点Y1Y1角角度度()()距距离离(m)(m)48525.135254.32334.13172961.6344578.5437851.58134.20431830.774843335821.25344.21182673.85K8+926K8+

15、926 涵涵洞洞施施工工放放样样坐坐标标计计算算中心桩号:K8+926中心X:571069.912中心Y:494793.552前进方位角:2 23 33 3 4 42 2 3 36 6偏 角:90设计宽度:2.350左边距离:13.850右边距离:15.150计算斜宽:2.350点号X坐标Y坐标备注左571058.748494801.750右571082.123494784.5851571057.357494799.8562571068.521494791.6583571080.732494782.6914571060.139494803.6445571071.302494795.446657

16、1083.514494786.480计算示意图夹角左边距离右边距离计算宽度中心桩号123456附附合合导导线线计计算算表表略略图图与与备备注注点点X XY Y方方位位角角计计算算辅辅助助说说明明A A3628.0223628.0226183.7646183.76481.572581.572510.151410.1514表表示示: : 101514101514B B3680.0163680.0166551.7196551.719C C3991.0963991.0968016.2238016.22383.282183.2821选选择择观观测测角角属属性性值值：观观测测左左角角D D4045.453

17、4045.4538491.2758491.275点点号号观观测测角角改改正正数数改改正正后后角角值值坐坐标标方方位位角角边边长长坐坐标标增增量量计计算算值值改改正正后后坐坐标标增增量量坐坐标标点点号号度度. .分分秒秒 度度. .分分秒秒度度. .分分秒秒(m)(m)xx改改正正yy改改正正xxyyX XY YA A81.572581.57253628.0223628.0226183.7646183.764A AB B227.2559227.25590.500.50227.2560227.2560129.2324129.2324191.559191.5593680.0163680.016655

18、1.7196551.719B B1 194.043194.04310.500.5094.043294.043243.275643.2756158.448158.448-121.563-121.5630 0148.045148.0450.0000.000-121.563-121.563148.045148.0453558.4533558.4536699.7646699.7641 12 2197.5741197.57410.500.50197.5742197.574261.253761.2537242.538242.538115.000115.0000 0108.999108.9990.0010.

19、001115.000115.000109.000109.0003673.4533673.4536808.7646808.7642 23 3244.0637244.06370.500.50244.0638244.0638125.3215125.3215172.046172.046116.000116.0000 0212.999212.9990.0000.000116.000116.000212.999212.9993789.4533789.4537021.7637021.7633 34 4118.5323118.53230.500.50118.5324118.532464.253864.2538

20、180.701180.701-99.999-99.9990 0140.000140.0000.0000.000-99.999-99.999140.000140.0003689.4543689.4547161.7637161.7634 45 5221.5514221.55140.500.50221.5515221.5515106.2053106.2053234.48234.4878.00078.0000 0162.999162.9990.0010.00178.00078.000163.000163.0003767.4543767.4547324.7637324.7635 56 6102.5901

21、102.59010.500.50102.5902102.590229.195429.1954240.881240.881-65.999-65.9990 0225.000225.0000.0000.000-65.999-65.999225.000225.0003701.4553701.4557549.7637549.7636 67 7259.4209259.42090.500.50259.4210259.4210109.0204109.0204211.568211.568209.999209.9990 0118.000118.0000.0000.000209.999209.999118.0001

22、18.0003911.4543911.4547667.7637667.7637 78 8115.5548115.55480.500.50115.5549115.554944.575344.5753210.082210.082-69.000-69.0000 0200.000200.0000.0010.001-69.000-69.000200.001200.0013842.4543842.4547867.7647867.7648 8218.3028218.30280.500.50218.3029218.302983.282183.2821148.642148.6420 0148.459148.45

23、90.0000.000148.642148.642148.459148.459C C3991.0963991.0968016.2238016.223C CD D4045.4534045.4538491.2758491.275D D辅辅助助计计算算观观测测角角数数量量: : 1010D=D= 1842.3031842.303fx=X-(Xc-Xb)=fx=X-(Xc-Xb)= 0 0f=CDf=CD - - (AB(AB +kn180-+kn180- kiki ) )fy=y-(Yc-Yb)=fy=y-(Yc-Yb)= -0.003-0.003= =55f=(fxf=(fx2+fy+fy2)=)

24、= 0.000.00Vi=Vi= -kW/n-kW/n = = 0.50.5K=f/D=K=f/D= 1/6141011/614101 1/20001/2000f=4010=f=4010= 126126观观测测: :计计算算: :复复核核: :日日期期: :ABCD1234 AB CD 计算: 复核: 日期:第9页,共15页曲曲线线放放样样坐坐标标计计算算成成果果表表桩号距离(左+右-)距离(前+后-)X坐标Y坐标切线方位角202.0500271989.25369425.118262.63639205-31.05271991.71669420.767262.6410221000271988.2

25、3569417.234262.6699621500271987.60069412.274262.7254322000271986.97069407.314262.8074222500271986.34869402.353262.9159423000271985.73869397.390263.0509823000271985.73869397.390263.0509823500271985.13969392.426263.2125524000271984.55669387.460263.4006424500271983.99169382.492263.6152625000271983.4456

26、9377.522263.8564125500271982.92169372.550264.1240826000271982.42269367.575264.4182826500271981.95069362.597264.7390027000271981.50669357.617265.0862527500271981.09469352.634265.4600328000271980.71669347.648265.8603328500271980.37369342.660266.2871629000271980.06969337.669266.7405129500271979.8066933

27、2.676267.2203930000271979.58669327.681267.7267930500271979.41169322.684268.2597231000271979.28569317.686268.8191831500271979.20869312.686269.4051632000271979.18469307.686270.0176732500271979.20769302.687270.6521133000271979.29269297.688271.2887333500271979.43269292.690271.9253534000271979.62869287.6

28、94272.5619734500271979.87969282.700273.1985935000271980.18669277.709273.8352135500271980.54869272.723274.4718336000271980.96669267.740275.1084536500271981.43969262.762275.7450637000271981.96769257.790276.3816837500271982.55069252.825277.0183038000271983.18969247.866277.6549238500271983.88269242.9142

29、78.2915439000271984.63169237.970278.9281639500271985.43469233.035279.5647840000271986.29269228.110280.2014040500271987.20569223.194280.8380241000271988.17369218.288281.4746441500271989.19469213.394282.1112642000271990.27169208.511282.74788 计算: 复核: 日期:第10页,共15页曲曲线线放放样样坐坐标标计计算算成成果果表表桩号距离(左+右-)距离(前+后-)

30、X坐标Y坐标切线方位角42500271991.40169203.640283.3845043000271992.58569198.783284.0211243500271993.82469193.939284.6577444000271995.11669189.108285.2943644500271996.46169184.293285.9309845000271997.86169179.493286.5676045500271999.31369174.708287.2042246000272000.81869169.940287.8408446500272002.37769165.1892

31、88.4774647000272003.98769160.456289.1140847500272005.65169155.741289.7507048000272007.36769151.044290.3873248500272009.13569146.367291.0239449000272010.95469141.710291.6605649500272012.82669137.074292.2971850000272014.74869132.458292.9338050500272016.72269127.864293.5704251000272018.74769123.293294.

32、2070451500272020.82269118.744294.8436652000272022.94869114.218295.4802852500272025.12469109.717296.1169053000272027.35069105.240296.7535253500272029.62669100.787297.39014536.81500272030.46469099.178297.6212354500272034.32669091.962311.8937855000272036.74369087.585311.3138455500272039.20469083.232310

33、.7604356000272041.70569078.903310.2335456500272044.24669074.596309.7331857000272046.82369070.311309.2593557500272049.43469066.048308.8120358000272052.07869061.804308.3912558500272054.75269057.579307.9969959000272057.45369053.372307.6292659500272060.18169049.181307.2880560000272062.93369045.007306.97

34、33760500272065.70769040.847306.6852261000272068.50169036.700306.4235961500272071.31269032.566306.1884862000272074.14069028.442305.9799062500272076.98269024.328305.7978563000272079.83669020.222305.6423363500272082.70069016.124305.5133364000272085.57269012.031305.4108564500272088.45169007.943305.33490

35、65000272091.33469003.858305.28548 计算: 复核: 日期:第11页,共15页曲曲线线放放样样坐坐标标计计算算成成果果表表桩号距离(左+右-)距离(前+后-)X坐标Y坐标切线方位角65500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.26

36、25865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305.2625865500272094.22068999.775305