第一章习题.xls
习题1.1 按出版要求完成采矿培训2008-1班学员成绩表 学号姓名成 绩名次 煤矿开采井巷工程矿业信息总分平均分 要求 1.输入的成绩中,90 80-89 70-79 60-69 60 小计 学号姓名煤矿开采 井巷工程 矿业信息 通风安全总分 8101 8102 8103 8104 8105 8106 8107 8108 8109 8110 8111 8112 8113 8114 8115 8116 8117 8118 8119 8120 8121 8122 8123 8124 8125 要求 1.输入的成绩中,90 80-89 70-79 60-69 60 小计 习题1.3完成掘进班人员统计表 要求 1.正确绘制表头斜线 点号 斜距前 视边长 前视倾角仪器高前视点高水平角距左帮距右帮方位角 机口轨622.017.0760 过21.3445.5762.0431.90080.32601.81.8277.4059 128.0183.4461.5201.640177.28600.82.8 348.2711.1561.3431.280180.54600.82.8 548.1081.0061.4021.260179.20310.82.8 749.8549.5861.3851.050179.42300.82.8 949.4103.1361.1400.150181.07050.82.8 1126.4443.4060.7261.110180.29300.82.8 1321.420-0.4861.0380.430199.46250.82.8 1546.297-0.1760.7701.140158.35150.82.8 1749.461-2.1331.1801.160180.56450.82.8 1950.730-2.5561.2091.360179.49600.82.8 2150.179-3.3961.3461.080179.55500.82.8 2344.972-4.0861.1191.240179.47300.82.8 2548.831-2.0761.1631.420180.22600.82.8 2735.318-4.0861.6631.340179.44600.82.8 2949.2071.3561.0731.190180.28200.82.8 3148.0490.5761.3101.365179.56300.82.8 3344.488-5.4161.3411.000179.30150.82.8 3534.410-9.3151.2751.150180.43400.82.8 3749.485-2.1641.0151.100179.22100.82.8 3949.4302.2250.9650.950180.16550.82.8 4149.440-0.3931.0101.090179.49600.82.8 4348.057-1.0231.1111.020180.22600.82.8 4548.1751.2751.0631.380179.49450.82.8 4748.7881.3651.1571.230179.38100.82.8 4945.835-1.3361.1321.160180.03200.82.8 5146.198-2.2761.2501.010180.01250.82.8 5347.790-0.2110.9101.460180.05150.82.8 5549.250-0.4461.5551.030179.54500.82.8 5748.060-1.4011.0401.050180.17350.82.8 5948.438-0.4851.0800.890180.04550.82.8 6177.0721.3661.0220.850179.46100.82.8 6370.025-0.0031.0200.640176.05150.82.8 65100179.38250.82.8 276.1217 机口轨617.0760 川口43.962-8.2462.0431.55180.501517.5815 244.701-10.4861.5251.7175.436013.4215 449.7-4.4561.621.66114.1430307.5645 646.195-3.4631.731.95179.4630307.4315 836.9880.0661.6621.74180.0160307.4514 1038.487-2.2061.7651.48179.5715307.4229 1249.032.05151.521.49149.1030276.5259 1448.76212.2461.5641.66179.4310276.3609 1640.33210.0831.760.95179.5015276.2624 1849.4031.27451.1251.18179.3360276.0024 2048.14-0.5761.2261.2180.0160276.0224 2236.1931.3661.1941.14179.5125275.5349 2450.1820.4361.0811.14180.0360275.5749 2649.598-1.13451.1050.98180.0000275.5749 2848.817-3.4761.0340.83180.0230276.0019 3049.09-2.5760.971.1180.0460276.0519 3251.416-1.4961.2671.11179.5360275.5920 3449.164-6.45151.1880.99180.0060276.0019 3644.9261.2460.970.88179.585275.5909 3849.609-4.3160.9550.98179.4060275.4009 4049.006-3.4961.1070.87180.5220276.3230 4249.872-3.3231.0622.3179.2230275.5500 4446.888-2.1362.0111.11180.0120275.5620 4646.835-2.1061.2320.94180.1060276.0720 4846.753-0.3061.0080.95179.4530275.5250 5045.315-0.3131.0450.93180.0520275.5810 5245.048-1.1361.0351.15179.5245275.5055 5447.091-0.5161.240.91179.4660275.3755 5646.451-0.3661.0051.16180.2550276.0345 5845.9890.0731.2060.99179.4260275.4645 6048.055-0.4360.8851.19180.1860276.0545 6248.4840.47451.1871.345180.0360276.0945 6449.763-0.13151.3731.54179.4810275.5755 6641.785-0.54151.781.555180.4125276.3920 6848.0920.5531.3071.495175.2350272.0310 7037.844-1.3231.421.39179.5055271.5405 7248.467-0.4661.0651.3180.1520272.0925 7449.242-0.3361.2351.1180.0720272.1645 7644.180.21151.0980.92180.0425272.2110 7847.920.1631.0350.82179.5860272.2010 8046.8421.1330.7951.17180.0030272.2040 8248.9661.34451.1651.2180.0650272.2730 8448.5782.3131.1451.3179.1330271.4100 8645.545-0.5231.1381.36180.1860272.0000 8892.0000 90-88.0000 92 94 戊-31060三架法资料 南2南1242.2451 占1224.8650.12191.950134.5403197.1854 占237.9460.221-0.058218.5957236.1851 占3109.437-13.5244-0.058320.410116.5952 占446.885-18.0447-0.058182.173619.1728 占525.148-17.4757-0.058178.132417.3052 占681.968-11.5641-0.058179.160616.4657 占721.3756.4429-0.05880.5139277.3837 占839.9553.196-0.058177.0740274.4617 占988.7481.1029-0.058181.1812276.0429 占1062.229.3437-0.058179.1129275.1558 占1143.1210.4837-0.058181.0521276.2119 占1216.9873.4932-0.058182.0024278.2143 占1320.584-2.0202-0.058198.4240297.0423 占1497.719-1.2511-0.058158.2905275.3328 占15101.242-3.1927-0.058180.1907275.5235 占1690.436-3.0347-0.058179.5743275.5018 占1719.995-6.3656-0.058178.4924274.3942 占18131.840.2025-0.058181.3948276.1930 3560.708-8.5938179.3328275.5258 b180.0542275.5840 3118.262.49551.350.084396.2813 29179.440496.1217 p1050.209-8.2746180.420817.5257 交45.24-4.1561.3821.4178.49616.4257 a46.582-1.1961.140.80576.056272.4858 b47.752-1.1661.0451179.475272.3648 c49.16-2.0161.1130.61179.581272.3458 d47.8381.1630.8870.93179.4945272.2443 e48.3741.3561.0651179.556272.2042 8547.8060.00450.961.235179.4255272.0337 8736.388-3.5231.080.8179.5505271.5842 8949.052-0.5440.981.05179.506271.4942 9148.913-1.4631.1021.06178.3705270.2647 9332.859-1.0931.0910.98180.536271.2047 9527.7959.2261.0521.42182.0935273.3022 9747.703-2.2061.6061.1178.123271.4252 9945.517-0.5561.0081180.351272.1802 10146.9861.2361.061.12179.5845272.1647 10347.6120.5231.0481.15180.002272.1708 10548.621.5361.091.18179.5215272.0923 10749.6111.1530.98179.4355271.5318 10943.4412.4061.1320.66180.3245272.2603 切口21.187-7.21150.5570.762178.4215271.0818 切149.777-6.5331.03000.4300277.48608.5717 115 117 119 121 方位弧度XYH角度偏离度平行度对应点 0.2990330791498.5396610.915-420.10417.133 4.8464884451501.3776589.877-418.028277.683 4.802564325 1579.4695902.478 0.2990330791498.5396610.915-420.10417.133 0.3136502111539.9066624.333-427.03217.971 0.239182831582.5636634.735-435.24613.70482.545 5.3746687091613.0196595.678-439.336307.946DIV/053.143, 5.3707417191641.2206559.217-442.157307.72124.23526.098, 5.3713234951663.8676529.973-442.004307.75443.7013.569, 5.3705235521687.3876499.550-443.867307.70863.912-19.628, 4.8325258111693.2596450.906-442.111276.88364.668-23.407, 4.8276291921698.7356403.600-431.530276.60365.169-27.561, 4.8247930321703.1886364.149-425.238276.44065.474-31.043, 4.8172299391708.3566315.033-423.922276.00765.479-31.048, 4.8178117151713.4216267.167-424.761276.04065.5132359.132, 4.8153149251717.1386231.180-423.794275.89765.4482359.067, 4.8164784781722.3526181.274-423.092275.96465.4172359.036, 4.8164784781727.5046131.956-424.281275.96465.3862359.004, 4.8172056981732.6006083.514-427.720276.00665.3902359.009, 4.8186601391737.8006034.766-430.131276.08965.4662359.085, 4.816914811743.1625983.657-431.933275.98965.4562359.075, 4.8172056981748.2705935.102-437.913276.00665.4612359.080, 4.8168663291752.9545890.435-436.893275.98665.4502359.069, 4.8113394531757.8395841.223-440.789275.66965.1652358.783, 4.8265626021763.4105792.645-444.302276.54265.6272359.246, 4.8156542941768.5415743.133-446.145275.91765.5552359.174, 4.8160421451773.3895696.532-448.873275.93965.5052359.124, 4.8192419161778.3805649.998-450.949276.12265.6052359.223, 4.8150240371783.1705603.493-451.429275.88165.5072359.126, 4.816575441787.8825558.426-451.959275.96965.4832359.102, 4.8144665011792.4715513.623-452.814275.84965.3632358.982, 4.8106849541797.0925466.765-453.856275.63265.0612358.680, 4.8181995661801.9985420.576-454.201276.06365.1122358.731, 4.8132544671806.6295374.821-454.316275.77964.9352358.554, 4.8187813431811.7325327.042-454.626276.09665.0162358.635, 4.8199448961816.9365278.843-453.795276.16365.1532358.772, 4.8165027181822.1085229.350-453.820275.96565.1232358.742, 4.8285503381826.9505187.852-454.704276.65665.6012359.220, 4.7482167111828.6725139.797-453.740272.053164.7122006.934, 4.7455744771829.9275101.988-454.788271.901164.6472006.869, 4.7500347631831.7515053.560-455.216272.157164.7802007.002, 4.7521679431833.7095004.359-455.838272.279165.0192007.242, 4.7534526991835.5234960.217-455.742272.353165.2922007.514, 4.7531618111837.4764912.337-455.727272.336165.573223.294, 4.7533072551839.3924865.545-454.351272.344165.8542008.077, 4.7552949911841.4914816.643-452.967272.458166.2452008.468, 4.7417686891842.9174768.133-450.672271.683165.9782008.200, 4.7472955651844.5064722.621-451.145272.000165.9772008.199, 1.6057029121844.5064722.621-451.14592.000165.9772008.199, -1.5358897421844.5064722.621-451.145-88.000165.9772008.199, 4.2309253621491.0676633.202-356.107242.414, 3.4437964141276.3946566.277-357.251197.315, 4.1244602771255.3486534.703-356.949236.3141931.534, 0.2966671881356.9496565.761-383.14116.998257.7942035.824, 0.3366934051399.0176580.486-397.63419.291214.4182079.201, 0.3056847221421.8516587.692-405.26317.514190.9562102.663, 0.292914731498.6286610.847-422.17016.783112.1792181.440, 4.8457951611501.4516589.808-419.603277.644111.5702182.048, 4.7956654261504.7696550.059-417.221274.771112.4252181.193, 4.8184128841514.1596461.828-415.344276.075112.3102181.309, 4.8042999581519.7906400.734-404.934275.266113.0952180.523, 4.8233095021524.5636357.882-404.266276.355112.828-48.349, 4.8583324431527.0286341.113-403.075278.362112.129-4.720, 5.1849029381536.3906322.796-403.748297.073104.733-14.702, 4.8093905021545.8516225.566-406.111275.558105.487-16.768, 4.8149513151556.1996125.025-411.923275.876105.705-19.478, 4.814287121565.3856035.187-416.698275.838105.960-22.216, 4.7937504121566.9996015.391-418.943274.662106.424-24.834, 4.8227810561581.5235884.356-418.102276.325105.677-28.866, 4.8150628221587.6695824.710-427.593275.883105.800-31.290, 4.8167208851587.6695824.710-427.593275.978105.800-34.858, 1.6837239781579.4685902.478-415.85096.470105.827-31.263, 1.6790891591579.4685902.478-415.85096.205105.827-34.831, 0.3121133521620.0414986.927-427.69817.88277778 -86.045909 2132.442298, 6.5749364841663.2494999.903-431.04616.71611111-5.2122176.77, 11.04472471665.5374953.39-432.465272.81611110.6632174.183, 17.324370871667.7144905.7-433.579272.61333331.1752171.363, 23.607022881669.9284856.621-435.826272.58277781.6742168.435, 29.887226581671.9414808.837-434.719272.41194442.0192165.442, 36.169248341673.924760.522-433.433272.34527782.312162.36, 42.44746431675.6394712.747-433.148272.06055562.3612159.076, 48.729219411676.8924676.464-435.887271.97861112.3472156.529, 55.009786721678.4574627.443-436.597271.82861112.22152.962, 61.268852551678.8384578.555-438.154270.44666670.8752148.23, 67.567745821679.614545.712-438.929271.34666670.52145.565, 73.888625391681.2874518.34-434.029273.50638891.2212144.372, 80.140540221682.7134470.698-436.491271.71472220.9832140.81, 86.433955091684.544425.224-437.24272.30083331.2222137.874, 92.716776791686.4094378.289-436.032272.281.4522134.826, 99.000059061688.3084330.72-435.203272.28555561.692131.743, 105.280991690.1364282.161-433.501272.15638891.8222128.485, 111.55949681691.774232.589-433.392271.88833331.7252124.928, 117.85220871693.6134189.235-431.83272.43416672.0542122.23, 124.11277751694.034168.226-434.337271.13833331.7372120.448, 132.10318571742.8454175.918-440.918.95550.7912169.8, X,Y 1613.019,6595.6781613.019,6595.678 1641.22,6559.2171641.22,6559.217 1663.867,6529.9731663.867,6529.973 1687.387,6499.551687.387,6499.55 1693.259,6450.9061693.259,6450.906 1698.735,6403.61698.735,6403.6 1703.188,6364.1491703.188,6364.149 1708.356,6315.0331708.356,6315.033 1713.421,6267.1671713.421,6267.167 1717.138,6231.181717.138,6231.18 1722.352,6181.2741722.352,6181.274 1727.504,6131.9561727.504,6131.956 1732.6,6083.5141732.6,6083.514 1737.8,6034.7661737.8,6034.766 1743.162,5983.6571743.162,5983.657 1748.27,5935.1021748.27,5935.102 1752.954,5890.4351752.954,5890.435 1757.839,5841.2231757.839,5841.223 1763.41,5792.6451763.41,5792.645 1768.541,5743.1331768.541,5743.133 1773.389,5696.5321773.389,5696.532 1778.38,5649.9981778.38,5649.998 1783.17,5603.4931783.17,5603.493 1787.882,5558.4261787.882,5558.426 1792.471,5513.6231792.471,5513.623 1797.092,5466.7651797.092,5466.765 1801.998,5420.5761801.998,5420.576 1806.629,5374.8211806.629,5374.821 1811.732,5327.0421811.732,5327.042 1816.936,5278.8431816.936,5278.843 1822.108,5229.351822.108,5229.35 1826.95,5187.8521826.95,5187.852 1828.672,5139.7971828.672,5139.797 1829.927,5101.9881829.927,5101.988 1831.751,5053.561831.751,5053.56 1833.709,5004.3591833.709,5004.359 1835.523,4960.2171835.523,4960.217 1837.476,4912.3371837.476,4912.337 1839.392,4865.5451839.392,4865.545 1841.491,4816.6431841.491,4816.643 1842.917,4768.1331842.917,4768.133 1844.506,4722.6211844.506,4722.621 1844.506,4722.6211844.506,4722.621 1844.506,4722.6211844.506,4722.621 1491.067,16633.2021491.067,16633.202 1276.394,16566.2771276.394,16566.277 1255.348,16534.7031255.348,16534.703 1356.949,16565.7611356.949,16565.761 1399.017,16580.4861399.017,16580.486 1421.851,16587.6921421.851,16587.692 1498.628,16610.8471498.628,16610.847 1501.451,16589.8081501.451,16589.808 1504.769,16550.0591504.769,16550.059 1514.159,16461.8281514.159,16461.828 1519.79,16400.7341519.79,16400.734 1524.563,16357.8821524.563,16357.882 1527.028,16341.1131527.028,16341.113 1536.39,16322.7961536.39,16322.796 1545.851,16225.5661545.851,16225.566 1556.199,16125.0251556.199,16125.025 1565.385,16035.1871565.385,16035.187 1566.999,16015.3911566.999,16015.391 1581.523,15884.3561581.523,15884.356 1587.66867627016,15824.71018119091587.668,15824.710 1587.66867627016,15824.71018119091587.668,15824.710 1579.46783403844,15902.47753390291579.467,15902.477 1579.46783403844,15902.47753390291579.467,15902.477 1620.041,4986.927 1663.249,4999.903 1665.537,4953.39 1667.714,4905.7 1669.928,4856.621 1671.941,4808.837 1673.92,4760.522 1675.639,4712.747 1676.892,4676.464 1678.457,4627.443 1678.838,4578.555 1679.61,4545.712 1681.287,4518.34 1682.713,4470.698 1684.54,4425.224 1686.409,4378.289 1688.308,4330.72 1690.136,4282.161 1691.77,4232.5891691.77,4232.589 1693.613,4189.2351693.613,4189.235 1694.03,4168.2261694.03,4168.226 1742.845,4175.918277.486,4168.226 机口1498.5396610.915-420.10422.0 要求 过1.使用公式将前面测量表的相应数据传送过来正确绘制表头斜线 12.数据X,Y,Z,距左帮,距右帮 33.用逗号格式*.csv将此表单独存盘 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 49 51 53 55 57 59 61 63 1.使用公式将前面测量表的相应数据传送过来正确绘制表头斜线 习题1.5 练习各种查询 时间2004.12 人数322 某矿采煤队职工明细表 顺序号单位姓名工号年龄工龄基本工资工种文化程度 1综一a1101234121198支架工高中 2综一a2101335131216支架工高中 3综一a310142541148支架工中专 4综一a412341891084支架工本科 5综一a5286542201204支架工初中 6综一a6161445201204支架工初中 7综一a7283851271204支架工文盲 8综一a8287344201204材料员初中 9综一a9287850271204机电工初中 10综一a10290737131204支架工小学 11综一a11295431121204支架工初中 12综一a12295837121204支架工初中 13综一a13300147311204机电工初中 14综一a14303131131190支架工初中 15综一a15291033121190支架工初中 16综一a16296736121190支架工初中 17综一a17291546231190支架工小学 18综一a18110740191190支架工小学 19综一a19110632131190支架工高中 20综一a20258435131190机电工高中 21综一a21286436121190机电工初中 22综一a22290541181190支架工初中 23综一a23292643151190机电工初中 24综一a24295135131190机电工初中 25综一a25295230121190机电工初中 26综一a26230133151190支架工初中 27综一a27298734121176支架工初中 28综一a28290139131176支架工初中 29综一a29300838131176支架工文盲 30综一a30243235131176支架工初中 31综一a31283630121176支架工初中 32综一a32295336131176机电工高中 33综一a33102843081176机电工初中 34综一a341155126101176机电工初中 35综一a3510092861176支架工初中 36综一a36249828111176支架工高中 37综一a372813261176支架工小学 38综一a382832461176支架工初中 39综一a392843361176支架工小学 40综一a402953361176支架工小学 41综一a413063061176支架工小学 42综一a42308030121162机电工高中 43综一a43107013181162支架工小学 44综一a44294135121162机电工初中 45综一a45289431121162机电工初中 46综一a46300936131162机电工初中 47综一a4714902261162机电工初中 48综一a48108236151162支架工初中 49综一a49285837201162支架工初中 50综一a5010382321162支架工初中 51综一a5114912121162支架工初中 52综一a523002461162支架
矿业文库