煤矿经纬仪导线计算表(左角).xls

煤矿经纬仪导线计算表导线名称测量日期2005年10月1日已已知知求求观观测测值值中中数数方方位位角角高高程程计计算算水水平平距距座座标标计计算算点点位位后后测测前前水水平平角角P倾倾角角斜斜长长（（L））已已知知仪仪器器高高已已知知 Z S 已已知知 X已已知知 Y前前 -180 △△H△△X△△Y左左右右视视站站视视。。′′″″-。。′′″″M前前视视高高所所求求所所求求 Z所所求求 X所所求求 Y后后 1011111 126426448482424-18183737414124.5424.54 2 2545431310 0. .8 8- -3 39 93 3. .5 53 31 1 23.25423.254 1 18 88 88 8. .9 92 24 44 40 08 87 7. .2 28 86 6 - -7 7. .3 33 34 40.9272 23 3. .2 23 36 6 87874242551 1. .3 30 05 5 -400.8651889.8514110.522 11111 12 2919150505 50 03636454521.921.9 0 0. .5 57 7 21.89921.8990 0. .3 33 34 4 21.898- -0 0. .1 17 72 2 3 35 59 93 33 30 00 0. .6 67 7-400.5311911.7494110.350 1 12 23 3179179393935350 04545383821.921.9 0 0. .8 84 4 21.89821.898 0 0. .1 10 01 121.896- -0 0. .3 30 02 2 3 35 59 91 12 23 35 50 0. .6 65 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.000 0.0000.000 0 0. .0 00 00 00.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.000 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 35 59 91 12 23 35 5-400.4301933.6454110.048 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 17 79 91 12 23 35 5-400.4301933.6454110.048 底底板板标标高高备备注注煤矿经纬仪导线计算表测量日期2005年10月1日煤矿经纬仪导线计算表左角导线名称测量日期年月日已已知知求求观观测测值值中中数数方方位位角角高高程程计计算算水水平平距距座座标标计计算算点点位位底底板板标标高高备备注注后后测测前前水水平平角角P倾倾角角斜斜长长（（L））已已知知仪仪器器高高已已知知 Z S 已已知知 X已已知知 Y前前 -180 △△H△△X△△Y左左右右视视站站视视。。′′ ″″-。。 ′′ ″″M前前视视高高所所求求所所求求 Z所所求求 X所所求求 Y后后 01 12 2131131 4040 3939 - -0 01212 16169.2569.256 32032010103 30 0. .6 61 15 5- -3 36 64 4. .1 11 16 6 9.2569.256 2 21 12 28 8. .9 92 20 03 33 38 81 11 1. .5 59 94 4 0 0. .4 45 50 00.298- -9 9. .2 25 51 1 2712715050421 1. .0 09 98 8 -363.6662129.21833802.343 1 12 23 398983333 30302727 1414 494918.39618.396 0 0. .9 97 74 4 16.35516.3558 8. .2 27 78 8 -16.086- -2 2. .9 95 53 3 1 19 90 02 24 41 12 20 0. .8 83 3-355.3882113.13233799.390 2 23 34 41831833 3323235355 5464615.37515.375 0 0. .7 75 5 12.58012.580 8 8. .7 70 09 9-12.234- -2 2. .9 92 29 9 1 19 93 32 27 74 44 40 0. .6 61 19 9-346.6792100.89833796.461 3 34 45 5121121 1515 18181515 5757 36363.8023.802 0 0. .3 31 12 2 3.6553.6551 1. .0 05 55 5 -2.5722 2. .5 59 98 8 1 13 34 44 43 32 20 0. .3 32 22 2-345.6242098.32633799.058 4 45 56 6122122 2323 52526 65050 25254.6754.675 0 0. .5 52 27 7 4.6424.6420 0. .9 99 98 8 1.0354 4. .5 52 25 5 7 77 76 65 54 40 0. .9 96 68 8-344.6262099.36133803.583 5 56 67 7290290 5656 12125 52727 525237.09537.095 1 1. .0 03 3 36.92636.9263 3. .6 66 67 7 -36.562- -5 5. .1 17 72 2 1 18 88 83 36 61 1. .1 16 65 5-340.9582062.79933798.411 6 67 78 863631717 1212 - -8 81717 404018.35018.350 1 1. .0 01 1 18.15818.158- -2 2. .6 68 82 2 5.8101 17 7. .2 20 03 3 7 71 12 20 01 18 80 0. .9 97 75 5-343.6402068.60933815.615 7 78 89 9178178 3535 1818 - -5 53737 111131.78031.780 0 0. .6 62 2 31.62731.627- -2 2. .9 98 86 6 10.8552 29 9. .7 70 06 6 6 69 95 55 53 36 60 0. .7 74 46 6-346.6272079.46433845.321 8 89 910103232 2727 - -5 57 7414120.89520.895 0 0. .6 65 5 20.81120.811- -1 1. .6 65 57 7 -6.958- -1 19 9. .6 61 14 4 2 25 50 02 28 83 30 0. .8 86 61 1-348.2832072.50633825.707 9 91010 11114 44343 - -7 72525 131320.19020.190 0 0. .6 62 2 20.02120.021 - -2 2. .1 13 30 06.6681 18 8. .8 87 78 8 7 70 03 32 24 46 61 1. .0 09 97 7-350.4142079.17433844.585 1010 1111 121233331 1- -1 11313 151537.49537.495 0 0. .7 72 25 5 37.48637.486- -0 0. .6 68 88 8 -12.145- -3 35 5. .4 46 65 5 2 25 51 15 54 47 70 0. .8 83 36 6-351.1022067.02933809.120 1111 1212 13135959 4141 - -5 53030 414135.47035.470 0 0. .5 57 76 6 35.30635.306- -3 3. .3 34 46 6 10.8573 33 3. .5 59 95 5 7 72 25 52 28 80 0. .6 63 37 7-354.4472077.88633842.716 1212 1313 14141111 2727 - -3 35353 101056.77156.771 1 1. .0 09 95 5 56.64056.640- -4 4. .2 24 43 3 -17.238- -5 53 3. .9 95 54 4 2 25 52 21 16 65 55 50 0. .7 7-358.6902060.64833788.762 1313 1414 151528282 29 958586 647.19047.190 0 0. .6 68 8 46.47846.4788 8. .0 08 84 4 13.7834 44 4. .3 38 87 7 7 72 24 44 45 57 70 0. .5 59 95 5-350.6062074.43233833.149 1414 1515 161631316 61111 5050 252543.59043.590 0 0. .5 50 05 5 42.66342.6639 9. .0 05 59 9 -12.283- -4 40 0. .8 85 56 6 2 25 53 31 16 63 30 0. .6 62 2-341.5472062.14933792.292 1515 1616 17171212 17175 55151 555544.37044.370 0 0. .7 70 03 3 44.13844.1384 4. .7 72 22 2 12.5564 42 2. .3 31 14 4 7 73 32 28 82 20 00 0. .8 89 91 1-336.8252074.70533834.606 1616 1717 181846469 91 140400 022.49522.495 0 0. .8 83 33 3 22.48522.4850 0. .7 75 52 2 -6.107- -2 21 1. .6 64 40 0 2 25 54 41 14 42 29 90 0. .9 93 31 1-336.0732068.59833812.966 1717 1818 191917174 40 01515 484845.34245.342 0 0. .8 86 66 6 45.34245.342- -0 0. .0 06 63 3 12.0974 43 3. .6 69 98 8 7 74 43 31 13 33 30 0. .5 59 95 5-336.1352080.69633856.664 1818 1919 20200.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 3 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 18 80 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 0 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 18 80 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 0 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 18 80 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 0 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 18 80 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 0 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 18 80 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 0 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 18 80 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 0 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 18 80 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 0 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 18 80 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 0 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 18 80 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 0 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 18 80 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 0 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 18 80 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 0 03 31 13 33 3-336.1352080.69633856.664 0.0000.0000 0. .0 00 00 0 0.0000 0. .0 00 00 0 1 18 80 03 31 13 33 3-336.1352080.69633856.664 经经纬纬仪仪导导线线反反算算表表（（最最新新））导线点名称座标导线点边长与方位角高程高差 XmYm平距Lmθ斜长Hm 1 249492.83549042.971 16.43187664 3340′3.6″ 18.60791213 -196.107 -8.732 349507.60449035.768-204.839 倾角 27.98645061 说明1、红色为要输入的数据； 2、高差计算为负数的时候，计算出的倾角也为负数，进行角度转换需去掉“-”号。度分秒 275911 经纬仪导线反算表对对边边点点座座标标已已知知点点座座标标 X XY YZ ZX XY Y 4839.0154839.0152753.9432753.943-483.310-483.3104848.2064848.2062766.2122766.212 水水平平距距斜斜长长高高差差 15.33015.33017.07217.0727.5137.513 倾倾角角水水平平角角方方位位角角 26.1090637326.10906373126.8377548126.8377548 - -度度分分秒秒倾倾角角26266 63232 水水平平角角方方位位角角备备注注 Z Z -490.823-490.823 角角度度1010进进制制备备注注经纬仪导线反算表已已知知点点座座标标高高差差 7.5137.513 方方位位角角 126.8377548126.8377548