测量坐标计算程序 可算高程（新疆路桥精英群309335466收集）.xls

《测量坐标计算程序 可算高程（新疆路桥精英群309335466收集）.xls》由会员分享，可在线阅读，更多相关《测量坐标计算程序 可算高程（新疆路桥精英群309335466收集）.xls（303页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、计算：复核：监理：程 序 设 置 说 明尊敬的用户，您好！当您使用本程序时需要启用Office Excel VBA“宏”常称为安全级别设置，需将安全级别设置为“中或低”之后才可进 行下一步操作！如果您已启用“宏”请点击左上角“返回界面”按钮进入程序界面进行相关操作！提示 :本程序不支持金山WPS软件和Microsoft Excel 2003精简版，支持Microsoft Office Excel 2003及以上完整正版。为了保证本程序能正常运行建议使用微软Office Excel 2003以上完整版下载地址 ：Microsoft Office Excel推荐使用：Microsoft Offic

2、e Excel 2003或2013完整正版运行，不建议使用2007。若有疑问请详询QQ：295188316设置安全级别方法：特别注意：当打开程序运行过程中请勿点击其他操作，保存关闭时需等待完毕再点击关闭按钮，否则导致Excel崩溃出现下次无法运行。程序运行环境为Microsoft Office Excel 2003及以上完整正版，运行时要把安全级别设置为“低”或提示启用宏，否则点击程序按钮时没有任何反映，设置方法如下 ：Office Excel 2003版：点击顶部【工具】【宏】【安全性】【安全级】【低】【确定】【重新打开文件即可运行】。Office Excel 2007版：点击顶部【Offi

3、ce按钮】【Excel选项】【信任中心】【信任中心设置】【宏设置】【启用所有宏】【确定】。Office Excel 2010版：点击顶部【文件】【选项】【信任中心】【信任中心设置】【宏设置】【启用所有宏】【确定】。Office Excel 2013版：点击顶部【文件】【选项】【信任中心】【信任中心设置】【宏设置】【启用所有宏】【确定】。计算：复核：监理：临临时时用用表表说明：本表用于程序临时用表相关设置。序号赋值说明1TRUEAuto_Close2VBA5.9VBA5.93456789101112131415计算：复核：监理：纬地平面交点数据文件100QD 3381507.389 446682

4、.036 0 0 0 0 1 3381002.829 447530.464 5500 300 300 0 2 3379475.002 450979.99 8000 170 170 0 3 3378819.247 452290.956 5000 330 330 0 4 3378226.731 456053.721 4500 360 360 0 5 3373351.385 458628.379 0 0 0 0 计算：复核：监理：CASS公路曲线要素文件COORD,X=3381507.389,Y=446682.036,K=00+100.000JD1,X=3381002.829,Y=447530.46

5、4,R=5500,Lh=300JD2,X=3379475.002,Y=450979.99,R=8000,Lh=170JD3,X=3378819.247,Y=452290.956,R=5000,Lh=330JD4,X=3378226.731,Y=456053.721,R=4500,Lh=360JD5,X=3373351.385,Y=458628.379,R=0,Lh=0计算：复核：监理：海地读入交点线文件NE1QD 3381507.389 446682.036 0 1 3381002.829 447530.464 5500 300 300 0 0 2 3379475.002 450979.99

6、8000 170 170 0 0 3 3378819.247 452290.956 5000 330 330 0 0 4 3378226.731 456053.721 4500 360 360 0 0 5 3373351.385 458628.379 0 计算：复核：监理：EICAD平面交点设计文件-1 3381507.389 446682.036 100 QD 3 3381002.829 447530.464 100000000.0000000000 1284.5232578665 5500 1284.5232578665 100000000.0000000000 3 3379475.002

7、 450979.99 100000000.0000000000 1166.1903789691 8000 1166.1903789691 100000000.0000000000 3 3378819.247 452290.956 100000000.0000000000 1284.5232578665 5000 1284.5232578665 100000000.0000000000 3 3378226.731 456053.721 100000000.0000000000 1272.7922061358 4500 1272.7922061358 100000000.0000000000 -2

8、 3373351.385 458628.379 ZD 计算：复核：监理：鸿业交点文件SZDL71&-1 3381507.389 446682.036 0.0000000000 0.00000000001 3381002.829 447530.464 100000000.0000000000 1284.5232578665 5500 1284.5232578665 100000000.0000000000 1 3379475.002 450979.99 100000000.0000000000 1166.1903789691 8000 1166.1903789691 100000000.0000

9、000000 1 3378819.247 452290.956 100000000.0000000000 1284.5232578665 5000 1284.5232578665 100000000.0000000000 1 3378226.731 456053.721 100000000.0000000000 1272.7922061358 4500 1272.7922061358 100000000.0000000000 -2 3373351.385 458628.379 0.0000000000计算：复核：监理：程程序序信信息息设设置置名 称内 容单位名称：达濠市政建设有限公司工程名称：

10、桂三高速六队页眉(左)：页眉(中)：页眉(右)：页脚(左)：计算：页脚(中)：复核：页脚(右)：监理：计算：复核：监理：曲曲 线线 要要 素素 表表单位名称：新疆路桥精英群309335466收集（更多资料，软件，程序请关注新疆路桥精英群309335466）工程名称：交点号交点桩号交点坐标交点坐标曲线半径缓和曲线缓和曲线备 注 JDKX(N)Y(E)RLs1Ls2QD33344.3826895.994522303.922JD1234000.778827529.066522130.194900200200-118JD1335091.047828532.737522633.4401106.59200

11、20042JD1437262.836830524.034521557.939800170170-35JD1538216.910831479.349521788.95275017017025.8JD1640996.399834082.020520769.502110015015034.4JD1742230.514835321.369520864.9591000280280-45JD1843175.214836073.515521469.9421034.0518018022.7Z43645.605836585.602521417.929-3323.6已知交点桩号未知交点桩号计算：复核：监理：计算：

12、复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：控控制制点点坐坐标标表表工程名称：桂三高速六队序号点名坐标高程数据N(X)E(Y)H(Z)1CPI-03381591.083446627.4232CPI-13381134.153447256.9083CPI-23379468.364450967.7314CPI-33378519.247454343.2825CPII-13380885.288447894.0466CPII-23380489.931448685.2887CPII-33380207.501449373.8838CPII-43379893.749450231.4769C

13、PII-53379045.765451657.99710CPII-63378791.228452118.33211CPII-73378661.897452840.24412CPII-83378336.119453357.93613CPII-93378232.292455142.7414CPII-103377954.762455763.7415CPII-113377481.525456242.099计算：复核：监理：计算：复核：监理：直直 线线、曲曲 线线 及及 转转 角角 表表工程名称：桂三高速六队交点编号交 点 坐 标交点桩号(K)转 角 值()曲 线 要 素 表 (m)曲 线 主 点 位

14、置直线长度及方向备 注 N (X)E (Y)半 径R缓和曲线长度缓和曲线长度切 线长 度切 线长 度曲 线长 度外 距E第一缓和曲线第一缓和曲线终 圆曲线中点第二缓和曲线起第二缓和曲线直线段交点间计算方位角Ls1Ls2T1T2Lh起 点点或圆曲线起点点或圆曲线终点终 点长 (m)距(m)()123456789101112131415161718192021# #QD826895.9940522303.9220# #JD12827529.0660522130.194034+000.7780右 415829.33900200200445.9196445.9196859.338865.931833+

15、554.858433+754.858433+984.527834+214.197234+414.1972210.5570656.47663443916.621# 42 #JD13828532.7370522633.440035+091.0470左 550010.611106.59200200676.8471676.84711262.3070142.673834+414.199934+614.199935+045.353435+476.506935+676.50690.00311122.7698263745.95-127 # #JD14830524.0340521557.939037+262.8

16、360右 415803.84800170170392.3779392.3779755.980158.434936+870.458137+040.458137+248.448137+456.438237+626.43821193.95112263.17613313735.341# 42 #JD15831479.3490521788.952038+216.9100左 345903.08750170170321.8297321.8297627.942038.045337+895.080338+065.080338+209.051338+353.022338+523.0223268.6422982.8

17、498133539.19-114 # #JD16834082.0200520769.502040+996.3990右 254739.491100150150327.0596327.0596645.215129.342940+669.339440+819.339440+991.947041+164.554541+314.55452146.31642795.20573383636.111# 26 #JD17835321.3690520864.959042+230.5140右 342424.721000280280450.5367450.5367880.513150.252041+779.97734

18、2+059.977342+220.233942+380.490442+660.4904465.42351243.019742415.601434 #JD18836073.5150521469.942043+175.2140左 443639.161034.05180180514.7222514.7222985.118385.042842+660.491842+840.491843+153.050943+465.610043+645.61000.0017965.2606384840.32-139 # #Z836585.6020521417.9290计算：复核：监理：计算：复核：监理：计算：复核：监

19、理：线元法要素表线元桩号(K)起点坐标mN (X)起点坐标mE (Y)起点方位角（）起点半径（Rs）止点半径（Re）转向（d）起点桩号止点桩号252627282930313233+344.3033+554.86826895.9937522303.92213443916.620006.01535783733344.301344.39166233+554.8633+754.86827099.0442522248.20083443916.62090016.015357837 33554.85836 344.39166233+754.8634+214.20827293.6344522202.47583

20、510114.9390090016.126468948 33754.85836 351.01149334+214.2034+414.20827745.8029522247.1461201547.64900010.353660139 33984.52778 20.15476434+414.2034+414.20827927.6843522330.0634263745.950000.46477125 34214.19721 26.37459534+414.2034+614.20827927.6871522330.0647263745.9501106.59-10.46477125 34414.197

21、21 26.37459534+614.2035+476.51828109.0247522414.2529212706.271106.591106.59-10.374403543 34414.199921.27062735+476.5135+676.51828949.582522401.45863364815.021106.590-15.8783417534614.1999 336.48150235+676.5136+870.46829128.2733522311.79043313735.340005.787974044 35045.35342 331.37353436+870.4637+040

22、.46830178.7931521744.40393313735.34080015.787974044 35476.50695 331.37353437+040.4637+456.44830331.0608521669.00133374250.9880080015.894224044 35676.50695 337.42509837+456.4437+626.44830738.9544521616.100173023.55800010.131013887 36870.458097.30235537+626.4437+895.08830905.4193521650.1651133539.1900

23、00.237263887 37040.45809 13.35391937+895.0838+065.08831166.5355521713.3078133539.190750-10.237263887 37248.44815 13.35391938+065.0838+353.02831333.0689521746.977570602.51750750-10.123930553 37456.438217.06025138+353.0238+523.02831618.5837521727.52373450612.797500-16.023193257 37626.43821 345.0612793

24、8+523.0240+669.34831779.011521671.57633383636.110005.909859923 37895.0803 338.36361140+669.3440+819.34833777.4884520888.78513383636.110110015.909859923 38065.0803 338.36361140+819.3441+164.55833918.3344520837.27673423059.621100110015.978041742 38209.05128 342.30596241+164.5541+314.55834258.364552078

25、6.502402952.091100010.008688302 38353.022260.29520941+314.5541+779.98834408.1137520794.618442415.600000.07687012 38523.022264.24150141+779.9842+059.98834872.1628520830.360342415.600100010.07687012 40669.339434.24150142+059.9842+380.49835149.7872520864.8305122532.671000100010.21687012 40819.33943 12.

26、25326742+380.4942+660.49835446.5029520982.3551304723.241000010.53738321 40991.94696 30.47232442+660.4942+660.49835672.4341521147.3356384840.320000.67738321 41164.55449 38.48403242+660.4942+840.49835672.4355521147.3367384840.3201034.05-10.67738321 41314.55449 38.48403242+840.4943+465.61835815.8593521

27、256.0004334927.771034.051034.05-10.590346799 41779.97734 33.49277743+465.6143+645.61836406.132521430.91173591113.701034.050-16.268998227 42059.97734 359.11130143+645.6143+645.61836585.6025521417.9293541201.1600042220.2338942380.4904342660.4904342660.4917942840.4917943153.0509243465.6100543645.61005计

28、算：复核：监理：43645.60956计算：复核：监理：计算：复核：监理：坐坐 标标 计计 算算 表表交点法单位名称： 达濠市政建设有限公司工程名称： 桂三高速六队里程桩号(K)中桩坐标（m）左边桩坐标（m）右边桩坐标（m）切线方位角( “ )高程(m)左边桩画线 N(X)E(Y)偏距(m)偏角( )N(X)E(Y)偏距(m)偏角( )N(X)E(Y)37+820.000831093.5585521695.6607133539.19325.796037+840.000831112.9982521700.3615133539.19325.916037+860.000831132.43795217

29、05.0624133539.19326.036037+880.000831151.8776521709.7633133539.19326.156037+900.000831171.3174521714.4640133519.61326.276037+920.000831190.7618521719.1454132716.88326.396037+940.000831210.2243521723.7507130827.05326.516037+960.000831229.7187521728.2188123850.10326.6360计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复

30、核：监理：计算：复核：监理：右边桩画线layer m text c 2 Text 446681.52486,3381506.5295 1 239.26005723 DK00+000.000Text 448456.95035,3380591.38592 1 246.11100376 DK02+000.000Text 450285.61384,3379781.45393 1 246.11100376 DK04+000.000Text 451223.27645,3379352.19017 1 243.4254394 DK05+031.443Text 452102.56305,3378947.2467

31、6 1 249.73466086 DK06+000.000Text 453219.68192,3378671.98984 1 261.05121675 DK07+152.556Text 454055.52006,3378533.03808 1 258.0808374 DK08+000.000Text 447695.05416,3380931.81985 1 244.54839159 DK01+165.515Text 455857.91795,3377705.87321 1 232.6160465 DK10+000.000Text 447968.25367,3380807.83421 1 246

32、.11100376 DK01+465.515Text 457130.73672,3376184.72265 1 208.11930533 DK12+000.000Text 457189.76989,3376073.37905 1 207.83842193 DK12+126.030Text 458064.87585,3374416.28737 1 207.83842193 DK14+000.000layer m dx c 3 line 446681.78043,3381506.95925 446682.29157,3381507.81875 计算：复核：监理：line 448457.15283,

33、3380591.84309 448457.5578,3380592.75742 line 450285.81632,3379781.9111 450286.22129,3379782.82543 line 451223.50013,3379352.63735 451223.94749,3379353.5317 line 452102.73624,3378947.71581 452103.0826,3378948.65391 line 453219.7597,3378672.48375 453219.91525,3378673.47158 line 454055.62333,3378533.52

34、73 454055.82986,3378534.50574 line 447695.26903,3380932.27133 447695.69878,3380933.17428 line 455858.22153,3377706.2705 455858.82868,3377707.06509 line 447968.45615,3380808.29137 447968.86112,3380809.2057 line 457131.17771,3376184.9583 457132.05968,3376185.42961 line 457190.21202,3376073.61254 45719

35、1.09629,3376074.07952 line 458065.31798,3374416.52086 458066.20225,3374416.98784 osnap off layer m zx c 5 pline 446682.036,3381507.389 w 0.2 446682.036,3381507.389448457.35531,3380592.30026450286.01881,3379782.36827451223.72381,3379353.08453452102.90942,3378948.18486453219.83747,3378672.97766454055.

36、72659,3378534.01652447695.48391,3380932.7228455858.52511,3377706.66779计算：复核：监理：447968.65864,3380808.74854457131.61869,3376185.19396457190.65416,3376073.84603458065.76011,3374416.75435Osnap End,Cen,Mid,Per,Nea,Int计算：复核：监理：计算：复核：监理：计算：复核：监理：坐坐 标标 反反 算算 表表单位名称： 达濠市政建设有限公司工程名称： 桂三高速六队序号坐标(m)里程桩号(K)偏距(m)

37、备注与说明 N(X)E(Y)计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：37248.4481537248.4481537248.4481537248.4481537248.4481537248.4481537248.44815计算：复核：监理：线线 元元 法法 要要 素素 表表单位名称：达濠市政建设有限公司温馨提示：当选择“输入部分要素”时只需输入浅黄底色单元格部分内容，然后点击生成要素按钮即可计算。工程名称：桂三高速六队序号线元桩号(K)起点坐标mN (X)起点坐标mE (Y)起点方位角(d.ms)起点半径(Rs)止点半径(Re

38、)转向（d）备 注0起点桩号止点桩号15204.803671100.0000607.87133381507.3890446682.0360120.44237900000120.73994172607.8713907.87133381247.7946447118.5494120.4423790005500-1120.73994173907.87131265.51493381096.8073447377.7730119.1038390055005500-1119.177329541265.51491565.51493380932.7228447695.4839115.2705790055000-1

39、115.451607351565.51494586.46753380808.7486447968.6586113.53203800000113.888995164586.46754756.46753379585.3656450730.8115113.53203800080001113.888995174756.46754961.44303379515.9716450886.0023114.29519500800080001114.497762884961.44305131.44303379428.5968451071.4162115.57568500800001115.965791895131

40、.44305384.41663379353.0846451223.7239116.34284100000116.5745595105384.41665714.41663379239.9139451449.9715116.3428410005000-1116.5745595115714.41666922.55583379095.5467451746.6997114.4101680050005000-1114.6837988126922.55587252.55583378727.8897452894.4545100.5022350050000-1100.8395429137252.55587686

41、.70703378672.9778453219.837598.5655620000098.94878215147686.70708046.70703378605.4449453648.704198.5655620004500198.94878215158046.707011866.03013378544.7143454003.5186101.14262100450045001101.24061331611866.030112226.03013376389.8905457018.3244149.52110800450001149.8697458半径推算小工具计算：复核：监理：1712226.03

42、0115304.80373376073.8462457190.6543152.09416800000152.1615771815304.80373373351.3852458628.3791152.09416800152.161577计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：

43、复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：计算：复核：监理：2.1073095212.1073095212.0800368122.0150106921.9877379831.9877379831.9983629662.0239848842.0346098672.0346098672.001609861.7599820181.7269820121.7269820121.7669810312.61571952温馨提示：当选择“输入部分要素”时只需输入

44、浅黄底色单元格部分内容，然后点击生成要素按钮即可计算。半径推算小工具计算：复核：监理：2.6557195092.655719509计算：复核：监理：坐坐 标标 计计 算算 表表线元法单位名称：达濠市政建设有限公司工程名称：桂三高速六队里程桩号(K)中桩坐标（m）左边桩坐标（m）右边桩坐标（m） 高程左边桩画线 N(X)E(Y)切线方位角(“)偏距(m)偏角( )N(X)E(Y)偏距(m)偏角( )N(X)E(Y)00+000.0003381507.3890446682.03601204423.795903381511.6865446684.59175903381503.0915446679.4

45、803334.9830446684.592,3381511.68601+600.0003380754.2867448091.62261135320.385903380758.8583448093.64755903380749.7150448089.5978333.3830448093.647,3380758.85803+200.0003380106.3411449554.55341135320.385903380110.9128449556.57835903380101.7695449552.5286336.5830449556.578,3380110.91304+656.4673379515

46、.9716450886.00231142951.945903379520.5215450888.07565903379511.4218450883.9290330.1595450888.076,3379520.52104+800.0003379455.2863451016.07281153132.665903379459.7983451018.22745903379450.7744451013.9182329.3270451018.227,3379459.79805+614.4173379095.5467451746.69971144101.675903379100.0899451748.78775903379091.0036451744.6116324.6034451748.788,3379100.0906+400.0003378824.7870452483.28771054054.045903378829.6009452484.6