附录A数据处理表(公式已编好).xls
表表A1A1 巷巷道道参参数数记记录录表表 测点序号巷道名称断面形状 支护类型 巷 道 规 格 上宽 m 下宽 m 高度 m 拱基高度 m 1杨地湾行人斜井三心拱砌碹4.223.06 2杨地湾行人斜井三心拱砌碹3.553.50 3杨地湾行人斜井三心拱喷浆2.824.12 4杨地湾井底车场三心拱喷浆3.952.59 52＃暗斜井岔口以东三心拱砌碹4.822.85 6355大巷三心拱裸巷4.632.95 7中岔人行上山岔口以东三心拱裸巷4.622.20 8北二石门半圆拱喷浆3.963.50 9北二石门半圆拱喷浆4.453.72 10北二石门半圆拱喷浆4.403.70 11295架空人车半圆拱喷浆3.223.19 12290机轨石门半圆拱喷浆3.183.05 13290机轨巷半圆拱喷浆3.202.62 14290机轨巷半圆拱喷浆5.202.82 15N21106运输巷梯形金支2.943.202.08 16N21106运输巷梯形金支2.943.202.08 17N21106运输巷梯形金支2.943.202.08 18N21106运输巷梯形金支2.943.202.08 19N21106工作面矩形液压支架2.300.84 20N21106工作面矩形液压支架2.300.84 21N21106回风巷半圆拱锚喷2.253.152.35 22N21106回风巷半圆拱锚喷2.253.152.35 23N21106回风巷半圆拱锚喷2.253.152.35 24N21106回风巷半圆拱锚喷2.253.152.35 25310总回风半圆拱裸巷4.803.40 26310总回风半圆拱裸巷4.604.10 27310总回风半圆拱裸巷4.613.40 28310总回风半圆拱裸巷4.453.35 29310总回风半圆拱裸巷4.123.29 30杨地湾回风斜井半圆拱砌碹4.453.60 31杨地湾回风斜井半圆拱砌碹4.653.65 32风硐半圆拱砌碹4.392.76 33风硐矩形砌碹4.422.96 1金鸡岩副斜井三心拱砌碹4.423.06 2金鸡岩副斜井三心拱裸巷4.553.15 3金鸡岩副斜井下车场三心拱砌碹4.223.12 4355大巷三心拱裸巷4.323.15 5北大巷半圆拱喷浆3.932.72 6北一石门北区皮带巷岔口三心拱喷浆4.522.78 7北区集中皮带巷三心拱喷浆4.292.91 8北区集中皮带巷三心拱喷浆4.352.82 9北区集中皮带巷三心拱喷浆4.453.16 10290机轨巷半圆拱喷浆5.13.08 11290机轨巷半圆拱喷浆5.123.04 12290三号上山半圆拱喷浆4.963.04 13340岩石轨道巷半圆拱喷浆3.543.31 14340岩石轨道巷半圆拱喷浆3.432.77 15N2705工作面矩形液压支架2.211.1 16N2705回风眼上口半圆拱喷浆3.152.35 17N2705回风眼下口半圆拱喷浆3.452.3 18310总回风半圆拱裸巷4.052.83 19310总回风半圆拱裸巷4.182.98 20300水仓巷半圆拱裸巷4.083.18 21300水仓巷半圆拱裸巷5.13.95 22300水仓巷半圆拱裸巷5.143.25 23东大巷300水仓巷岔口以北半圆拱裸巷5.483.32 24N05集中回风巷半圆拱裸巷4.723.35 25N05集中回风巷半圆拱裸巷4.543.72 26茅口总回风半圆拱裸巷4.053.3 27茅口总回风半圆拱裸巷4.023.56 28茅口总回风半圆拱裸巷4.683.3 29金鸡岩总回风半圆拱裸巷4.163.21 30金鸡岩总回风半圆拱裸巷4.233.18 31风硐矩形砌碹3.822.25 测点间距 m 累计长度 m 备注断面积 m2 周长 m 11.6113.1400 11.5012.90240240 11.0412.93160400 9.0911.75240640 12.0313.72160800 12.0913.602401040 8.6012.08401080 12.1713.222401320 14.4214.432401560 14.1914.312401800 9.1511.442402040 8.6111.092402280 5.3610.261952475 10.5413.802402715 4.8910.542402955 4.8910.542403195 4.8910.542403435 4.8910.542403675 1.936.281703845 1.936.281604005 6.3510.402404245 6.3510.402404485 6.3510.401704655 6.3510.402404895 13.8314.342405135 16.5715.422405375 13.3814.042405615 12.7713.692405855 11.7213.051806035 13.8814.192406275 14.6414.602406515 10.0412.41236538 14.7613.08356573 12.092513.47190 12.814313.8682240240 11.860513.2593170410 12.239413.4856122532 9.0215511.6101126658 11.067413.0783240898 11.134312.95572401138 表表A1A1 巷巷道道参参数数记记录录表表 巷 道 规 格 10.879312.87552401378 12.609813.72182401618 12.898914.1672391617 12.733614.11842401858 12.421413.86722402098 10.36412.17782402338 8.2304910.92512402578 1.903525.66972402818 6.330879.64552403058 6.6495310.01652403298 9.6900312.01852403538 10.569412.52261153653 11.176612.76562403893 17.335915.9072454138 13.851714.56982204358 14.950315.24362404598 13.405914.11042404838 14.662714.56782405078 11.593512.95852405318 12.565913.43142305548 13.078513.94762405788 11.484612.95122506038 11.51913.00111006138 8.59512.141006238 表表A2A2 风风速速记记录录表表 测点序号 巷道名称 表 速 m/s 平均风速 m/s 第一次第二次第三次 1杨地湾行人斜井4.704.784.834.77 2杨地湾行人斜井4.614.534.554.56 3杨地湾行人斜井4.454.514.534.50 4杨地湾井底车场6.256.366.116.24 52＃暗斜井岔口以东5.956.116.036.03 6355大巷2.953.153.033.04 7中岔人行上山岔口以东3.283.183.233.23 8北二石门5.205.285.265.25 9北二石门4.614.584.534.57 10北二石门0.850.830.890.86 11295架空人车0.440.420.450.44 12290机轨石门3.703.753.783.74 13290机轨巷4.034.064.154.08 14290机轨巷3.363.453.453.42 15N21106运输巷2.112.032.152.10 16N21106运输巷2.032.002.102.04 17N21106运输巷2.112.202.252.19 18N21106运输巷2.202.112.232.18 19N21106工作面2.032.101.982.04 20N21106工作面2.012.081.952.01 21N21106回风巷2.152.102.112.12 22N21106回风巷2.232.152.082.15 23N21106回风巷2.242.152.352.25 24N21106回风巷2.212.152.312.22 25310总回风6.736.706.616.68 26310总回风7.487.587.657.57 27310总回风7.988.108.068.05 28310总回风8.608.658.618.62 29310总回风8.618.658.758.67 30杨地湾回风斜井8.588.558.638.59 31杨地湾回风斜井8.738.658.688.69 32风硐10.2111.1810.7610.72 33风硐10.2210.9010.2510.46 1金鸡岩副斜井2433 2金鸡岩副斜井2433 3金鸡岩副斜井下车场2433 4355大巷2433 5北大巷2433 6北一石门北区皮带巷岔口2433 7北区集中皮带巷2433 8北区集中皮带巷2433 9北区集中皮带巷2433 10290机轨巷2433 11290机轨巷2433 12290三号上山2433 13340岩石轨道巷2433 14340岩石轨道巷2433 15N2705工作面2433 16N2705回风眼上口2433 17N2705回风眼下口2433 18310总回风2433 19310总回风2433 20300水仓巷2433 21300水仓巷2433 22300水仓巷2433 23东大巷300水仓巷岔口以北2433 24N05集中回风巷2433 25N05集中回风巷2433 26茅口总回风2433 27茅口总回风2433 28茅口总回风2433 29金鸡岩总回风2433 30金鸡岩总回风2433 31风硐2433 002433 仪器号备注 v11*v20.28 v10.429v20.03 v10.429v20.03 表表A2A2 风风速速记记录录表表 表A3 大气物理参数记录表 测点序号 巷道名称 干球温度 ℃ 湿球温度 ℃ 干湿温度差 ℃ 相对湿度 ％ 1杨地湾行人斜井21.6018.403.2075.64 2杨地湾行人斜井21.2018.302.9077.64 3杨地湾行人斜井21.1018.902.2082.44 4杨地湾井底车场20.6018.701.9084.40 52＃暗斜井岔口以东20.5018.701.8085.10 6355大巷20.5018.601.9084.30 7中岔人行上山岔口以东19.8017.202.6079.04 8北二石门20.0018.002.0083.00 9北二石门20.0018.002.0083.00 10北二石门20.0018.002.0083.00 11295架空人车20.0018.002.0083.00 12290机轨石门20.0018.002.0083.00 13290机轨巷20.0018.002.0083.00 14290机轨巷20.0018.002.0083.00 15N21106运输巷20.0018.002.0083.00 16N21106运输巷20.5019.301.2089.90 17N21106运输巷22.0020.002.0084.00 18N21106运输巷24.0022.002.0085.00 19N21106工作面26.8024.202.6081.40 20N21106工作面26.9024.502.4082.78 21N21106回风巷27.0025.301.7087.80 22N21106回风巷27.3025.701.6088.40 23N21106回风巷26.9025.301.6088.38 24N21106回风巷27.1025.801.3090.60 25310总回风24.2023.001.2090.48 26310总回风23.8022.401.4088.80 27310总回风23.6022.301.3089.60 28310总回风23.8022.501.3089.60 29310总回风23.8022.401.4088.80 30杨地湾回风斜井22.3021.301.0092.00 31杨地湾回风斜井23.6022.800.8093.60 32风硐22.8021.900.9092.80 33风硐23.2022.201.0092.00 1金鸡岩副斜井21.1201.1091.2 2金鸡岩副斜井21.1201.1091.2 3金鸡岩副斜井下车场21.1201.1091.2 4355大巷21.1201.1091.2 5北大巷21201.0092 6北一石门北区皮带巷岔口2119.51.5088 7北区集中皮带巷20191.0091 8北区集中皮带巷20191.0091 9北区集中皮带巷20191.0091 10290机轨巷19.5190.5095.5 11290机轨巷19190.00100 12290三号上山19190.00100 13340岩石轨道巷20191.0091 14340岩石轨道巷20191.0091 15N2705工作面2019.50.5096 16N2705回风眼上口23221.0092 17N2705回风眼下口12.425.813.4016.2 18310总回风12.425.813.4016.2 19310总回风12.425.813.4016.2 20300水仓巷12.425.813.4016.2 21300水仓巷12.425.813.4016.2 22300水仓巷12.425.813.4016.2 23东大巷300水仓巷岔口以北12.425.813.4016.2 24N05集中回风巷12.425.813.4016.2 25N05集中回风巷12.425.813.4016.2 26茅口总回风12.425.813.4016.2 27茅口总回风12.425.813.4016.2 28茅口总回风12.425.813.4016.2 29金鸡岩总回风12.425.813.4016.2 30金鸡岩总回风12.425.813.4016.2 31风硐12.425.813.4016.2 大气压力 Pa 空气密度 kg/m3 备注 96.21.136129689 97.41.151851363 97.91.158101149 98.91.17131451 97.81.159246672 97.81.159256993 97.81.162095048 97.81.161251036 97.61.158874096 97.71.160062566 98.21.166004917 98.41.168381857 98.41.168381857 98.41.168381857 98.11.164816447 98.41.166303421 98.71.163993063 98.91.158490877 98.51.143075857 98.41.14151633 98.21.138751144 98.01.135287344 97.81.134478781 97.61.131374347 97.51.141238279 97.41.141623732 97.41.142382936 97.31.140440263 97.21.139277209 96.41.145020286 95.91.139983763 95.21.143075562 96.81.141542917 109.3251.149700168 109.3251.149700168 109.3251.149700168 98.151.149700168 98.11.150080719 98.61.150132239 98.651.154016824 表A3 大气物理参数记录表 98.651.154016824 98.71.154016824 98.71.155930234 98.651.157850194 98.61.157850194 98.151.154016824 98.11.154016824 97.851.153952205 97.751.142313839 127.3251.185723774 128.3251.185723774 129.3251.185723774 130.3251.185723774 131.3251.185723774 132.3251.185723774 133.3251.185723774 134.3251.185723774 135.3251.185723774 136.3251.185723774 137.3251.185723774 138.3251.185723774 139.3251.185723774 140.3251.185723774 干温度℃在1立方米空气内g/m3在1公斤空气内g/kg水蒸汽的绝对压力 mmHgPa -20127.894 -15193.172 -10287.76 -5422.315 0610.159 1655.454 2704.746 3756.703 4811.324 5869.942 6932.557 7997.836 81068.444 91143.048 101226.978 111310.908 121401.5 131496.088 141597.337 151703.914 161817.154 171931.725 182064.947 192198.17 202331.392 212491.259 222637.804 232810.993 242984.182 253170.693 263357.204 273557.038 282783.516 294009.994 304236.472 314489.595 00.10.20.30.40.50.60.7 -10100979491888582.279.4 -9.910097.0294.0491.0688.0885.182.3279.54 -9.810097.0494.0891.1288.1685.282.4479.68 -9.710097.0694.1291.1888.2485.382.5679.82 -9.610097.0894.1691.2488.3285.482.6879.96 -9.510097.194.291.388.485.582.880.1 -9.410097.1294.2491.3688.4885.682.9280.24 -9.310097.1494.2891.4288.5685.783.0480.38 -9.210097.1694.3291.4888.6485.883.1680.52 -9.110097.1894.3691.5488.7285.983.2880.66 -910097.294.491.688.88683.480.8 -8.910097.2294.4491.6688.8886.183.580.9 -8.810097.2494.4891.7288.9686.283.681 -8.710097.2694.5291.7889.0486.383.781.1 -8.610097.2894.5691.8489.1286.483.881.2 -8.510097.394.691.989.286.583.981.3 -8.410097.3294.6491.9689.2886.68481.4 -8.310097.3494.6892.0289.3686.784.181.5 -8.210097.3694.7292.0889.4486.884.281.6 -8.110097.3894.7692.1489.5286.984.381.7 -810097.494.892.289.68784.481.8 -7.910097.494.892.289.68784.4481.88 -7.810097.494.892.289.68784.4881.96 -7.710097.494.892.289.68784.5282.04 -7.610097.494.892.289.68784.5682.12 -7.510097.494.892.289.68784.682.2 -7.410097.494.892.289.68784.6482.28 -7.310097.494.892.289.68784.6882.36 -7.210097.494.892.289.68784.7282.44 -7.110097.494.892.289.68784.7682.52 -710097.494.892.289.68784.882.6 -6.910097.4294.8492.2689.6887.184.982.7 -6.810097.4494.8892.3289.7687.28582.8 -6.710097.4694.9292.3889.8487.385.182.9 -6.610097.4894.9692.4489.9287.485.283 -6.510097.59592.59087.585.383.1 -6.410097.5295.0492.5690.0887.685.483.2 -6.310097.5495.0892.6290.1687.785.583.3 -6.210097.5695.1292.6890.2487.885.683.4 -6.110097.5895.1692.7490.3287.985.783.5 -610097.695.292.890.48885.883.6 -5.910097.6295.2492.8690.4888.185.983.7 -5.810097.6495.2892.9290.5688.28683.8 -5.710097.6695.3292.9890.6488.386.183.9 -5.610097.6895.3693.0490.7288.486.284 -5.510097.795.493.190.888.586.384.1 -5.410097.7295.4493.1690.8888.686.484.2 -5.310097.7495.4893.2290.9688.786.584.3 -5.210097.7695.5293.2891.0488.886.684.4 -5.110097.7895.5693.3491.1288.986.784.5 -510097.895.693.491.28986.884.6 -4.910097.895.693.491.28986.8284.64 -4.810097.895.693.491.28986.8484.68 -4.710097.895.693.491.28986.8684.72 -4.610097.895.693.491.28986.8884.76 -4.510097.895.693.491.28986.984.8 -4.410097.895.693.491.28986.9284.84 -4.310097.895.693.491.28986.9484.88 -4.210097.895.693.491.28986.9684.92 -4.110097.895.693.491.28986.9884.96 -410097.895.693.491.2898785 -3.910097.8295.6493.4691.2889.187.185.1 -3.810097.8495.6893.5291.3689.287.285.2 -3.710097.8695.7293.5891.4489.387.385.3 -3.610097.8895.7693.6491.5289.487.485.4 -3.510097.995.893.791.689.587.585.5 -3.410097.9295.8493.7691.6889.687.685.6 -3.310097.9495.8893.8291.7689.787.785.7 -3.210097.9695.9293.8891.8489.887.885.8 -3.110097.9895.9693.9491.9289.987.985.9 -310098969492908886 -2.9100989694929088.0286.04 -2.8100989694929088.0486.08 -2.7100989694929088.0686.12 -2.6100989694929088.0886.16 -2.5100989694929088.186.2 -2.4100989694929088.1286.24 -2.3100989694929088.1486.28 -2.2100989694929088.1686.32 -2.1100989694929088.1886.36 -2100989694929088.286.4 -1.910098.0296.0494.0692.0890.188.386.5 -1.810098.0496.0894.1292.1690.288.486.6 -1.710098.0696.1294.1892.2490.388.586.7 -1.610098.0896.1694.2492.3290.488.686.8 -1.510098.196.294.392.490.588.786.9 -1.410098.1296.2494.3692.4890.688.887 -1.310098.1496.2894.4292.5690.788.987.1 -1.210098.1696.3294.4892.6490.88987.2 -1.110098.1896.3694.5492.7290.989.187.3 -110098.296.494.692.89189.287.4 -0.910098.296.494.692.89189.2287.44 -0.810098.296.494.692.89189.2487.48 -0.710098.296.494.692.89189.2687.52 -0.610098.296.494.692.89189.2887.56 -0.510098.296.494.692.89189.387.6 -0.410098.296.494.692.89189.3287.64 -0.310098.296.494.692.89189.3487.68 -0.210098.296.494.692.89189.3687.72 -0.110098.296.494.692.89189.3887.76 -4.1E-1410098.296.494.692.89189.487.8 0.110098.296.494.692.89189.487.8 0.210098.296.494.692.89189.487.8 0.310098.296.494.692.89189.487.8 0.410098.296.494.692.89189.487.8 0.510098.296.494.692.89189.487.8 0.610098.296.494.692.89189.487.8 0.710098.296.494.692.89189.487.8 0.810098.296.494.692.89189.487.8 0.910098.296.494.692.89189.487.8 110098.296.494.692.89189.487.8 1.110098.2296.4494.6692.8891.189.587.9 1.210098.2496.4894.7292.9691.289.688 1.310098.2696.5294.7893.0491.389.788.1 1.410098.2896.5694.8493.1291.489.888.2 1.510098.396.694.993.291.589.988.3 1.610098.3296.6494.9693.2891.69088.4 1.710098.3496.6895.0293.3691.790.188.5 1.810098.3696.7295.0893.4491.890.288.6 1.910098.3896.7695.1493.5291.990.388.7 210098.496.895.293.69290.488.8 2.110098.496.895.293.69290.4288.84 2.210098.496.895.293.69290.4488.88 2.310098.496.895.293.69290.4688.92 2.410098.496.895.293.69290.4888.96 2.510098.496.895.293.69290.589 2.610098.496.895.293.69290.5289.04 2.710098.496.895.293.69290.5489.08 2.810098.496.895.293.69290.5689.12 2.910098.496.895.293.69290.5889.16 310098.496.895.293.69290.689.2 3.110098.4296.8495.2693.6892.190.789.3 3.210098.4496.8895.3293.7692.290.889.4 3.310098.4696.9295.3893.8492.390.989.5 3.410098.4896.9695.4493.9292.49189.6 3.510098.59795.59492.591.189.7 3.610098.5297.0495.5694.0892.691.289.8 3.710098.5497.0895.6294.1692.791.389.9 3.810098.5697.1295.6894.2492.891.490 3.910098.5897.1695.7494.3292.991.590.1 410098.697.295.894.49391.690.2 4.110098.697.295.894.49391.690.2 4.210098.697.295.894.49391.690.2 4.310098.697.295.894.49391.690.2 4.410098.697.295.894.49391.690.2 4.510098.697.295.894.49391.690.2 4.610098.697.295.894.49391.690.2 4.710098.697.295.894.49391.690.2 4.810098.697.295.894.49391.690.2 4.910098.697.295.894.49391.690.2 510098.697.295.894.49391.690.2 5.110098.697.295.894.49391.6290.24 5.210098.697.295.894.49391.6490.28 5.310098.697.295.894.49391.6690.32 5.410098.697.295.894.49391.6890.36 5.510098.697.295.894.49391.790.4 5.610098.697.295.894.49391.7290.44 5.710098.697.295.894.49391.7490.48 5.810098.697.295.894.49391.7690.52 5.910098.697.295.894.49391.7890.56 610098.697.295.894.49391.890.6 6.110098.697.295.894.49391.890.6 6.210098.697.295.894.49391.890.6 6.310098.697.295.894.49391.890.6 6.410098.697.295.894.49391.890.6 6.510098.697.295.894.49391.890.6 6.610098.697.295.894.49391.890.6 6.710098.697.295.894.49391.890.6 6.810098.697.295.894.49391.890.6 6.910098.697.295.894.49391.890.6 710098.697.295.894.49391.890.6 7.110098.6297.2495.8694.4893.191.990.7 7.210098.6497.2895.9294.5693.29290.8 7.310098.6697.3295.9894.6493.392.190.9 7.410098.6897.3696.0494.7293.492.291 7.510098.797.496.194.893.592.391.1 7.610098.7297.4496.1694.8893.692.491.2 7.710098.7497.4896.2294.9693.792.591.3 7.810098.7697.5296.2895.0493.892.691.4 7.910098.7897.5696.3495.1293.992.791.5 810098.897.696.495.29492.891.6 8.110098.897.696.495.29492.891.6 8.210098.897.696.495.29492.891.6 8.310098.897.696.495.29492.891.6 8.410098.897.696.495.29492.891.6 8.510098.897.696.495.29492.891.6 8.610098.897.696.495.29492.891.6 8.710098.897.696.495.29492.891.6 8.810098.897.696.495.29492.891.6 8.910098.897.696.495.29492.891.6 910098.897.696.495.29492.891.6 9.110098.897.696.495.29492.891.6 9.210098.897.696.495.29492.891.6 9.310098.897.696.495.29492.891.6 9.410098.897.696.495.29492.891.6 9.510098.897.696.495.29492.891.6 9.610098.897.696.495.29492.891.6 9.710098.897.696.495.29492.891.6 9.810098.897.696.495.29492.891.6 9.910098.897.696.495.29492.891.6 1010098.897.696.495.29492.891.6 10.110098.897.696.495.29492.8291.64 10.210098.897.696.495.29492.8491.68 10.310098.897.696.495.29492.8691.72 10.410098.897.696.495.29492.8891.76 10.510098.897.696.495.29492.991.
矿业文库