利用excel在section中快速准确生成抽水试验等曲线-表格.xlsx
《利用excel在section中快速准确生成抽水试验等曲线-表格.xlsx》由会员分享,可在线阅读,更多相关《利用excel在section中快速准确生成抽水试验等曲线-表格.xlsx(29页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、孔深(m)冲洗液消耗量(l/h)作图深度比例尺分母图上宽度(mm)代表最大消耗量(l/h)起始位置图面坐标(mm)转换孔深转换消耗量XY5005.2810097.04208.280.0058.95208.28100.153.0049.53202.2899.666.2097.00195.88102.169.806.39188.6897.3812.308.62183.6897.5015.7082.02176.88101.3718.9035.94170.4898.9422.1070.66164.08100.7725.3073.34157.68100.9127.1060.25154.08100.222
2、8.7032.91150.8898.7833.1020.06142.0898.1039.3093.16129.68101.9641.4033.07125.4898.7944.4045.20119.4899.4347.8061.60112.68100.2948.9032.77110.4898.7751.1059.50106.08100.1853.000.37102.2897.0656.3099.8595.68102.3159.8072.9788.68100.8965.4050.9877.4899.7368.7063.9870.88100.4270.4066.5167.48100.5573.909
3、9.9260.48102.3277.9047.5752.4899.5581.1017.5346.0897.9784.9086.3738.48101.6086.4011.4435.4897.6490.8063.7426.68100.4192.5071.0923.28100.7997.8046.4412.6899.49100.0050.108.2899.69冲冲洗洗液液消消耗耗量量120.00100.0080.0060.0040.0020.000.00100.0090.0080.0070.0060.0050.0040.0030.0020.0010.000.00冲冲洗洗液液消消耗耗量量(l l/ /
4、h h) )孔孔深深/ /m m回次回次起(M)回次止(M)进尺(M)岩心长(M)采取率(%)作图深度比例尺分母图上宽度(mm)代表最大采取率500810010.003.003.001.2040.0023.006.203.201.1034.3836.209.803.602.1058.3349.8012.302.501.5060.00512.3015.703.401.6047.06615.7018.903.201.7053.13718.9022.103.201.8056.25822.1025.303.201.1034.38925.3027.101.800.9050.001027.1028.701
5、.601.60100.001128.7033.104.402.5056.821233.1039.306.201.5024.191339.3041.402.101.0047.621441.4044.403.002.0066.671544.4047.803.403.40100.001647.8048.901.100.4036.361748.9051.102.202.20100.001851.1053.001.900.7036.841953.0056.303.303.30100.002056.3059.803.503.0085.712159.8065.405.605.2092.862265.4068
6、.703.303.30100.002368.7070.401.700.5029.412470.4073.903.503.50100.002573.9077.904.003.5087.502677.9081.103.203.20100.002781.1084.903.803.2084.212884.9086.401.501.50100.002986.4090.804.404.1093.183090.8092.501.701.70100.003192.5097.805.302.4045.283297.80100.002.202.1095.45起始位置图面坐标(mm)绘图孔深绘图采取率XY80.71
7、2208.29208.2983.91202.2983.46195.8985.38188.6985.51183.6984.48176.8984.96170.4985.21164.0983.46157.6984.71154.0988.71150.8985.26142.0982.65129.6984.52125.4986.05119.4988.71112.6983.62110.4988.71106.0983.66102.2988.7195.6987.5788.6988.1477.4988.7170.8983.0667.4988.7160.4987.7152.4988.7146.0987.4538.4
8、988.7135.4988.1726.6988.7123.2984.3312.6988.35回次回次起(M)回次止(M)进尺(M)岩心长(M)采取率(%)作图深度比例尺分母图上宽度(mm)代表最大采取率50081000.000.0010.003.003.001.2040.003.0040.0023.006.203.201.1034.386.2034.3836.209.803.602.1058.339.8058.3349.8012.302.501.5060.0012.3060.00512.3015.703.401.6047.0615.7047.06615.7018.903.201.7053.13
9、18.9053.13718.9022.103.201.8056.2522.1056.25822.1025.303.201.1034.3825.3034.38925.3027.101.800.9050.0027.1050.001027.1028.701.601.60100.0028.70100.001128.7033.104.402.5056.8233.1056.821233.1039.306.201.5024.1939.3024.191339.3041.402.101.0047.6241.4047.621441.4044.403.002.0066.6744.4066.671544.4047.8
10、03.403.40100.0047.80100.001647.8048.901.100.4036.3648.9036.361748.9051.102.202.20100.0051.10100.001851.1053.001.900.7036.8453.0036.841953.0056.303.303.30100.0056.30100.002056.3059.803.503.0085.7159.8085.712159.8065.405.605.2092.8665.4092.862265.4068.703.303.30100.0068.70100.002368.7070.401.700.5029.
11、4170.4029.412470.4073.903.503.50100.0073.90100.002573.9077.904.003.5087.5077.9087.502677.9081.103.203.20100.0081.10100.002781.1084.903.803.2084.2184.9084.212884.9086.401.501.50100.0086.40100.002986.4090.804.404.1093.1890.8093.183090.8092.501.701.70100.0092.50100.003192.5097.805.302.4045.2897.8045.28
12、3297.80100.002.202.1095.45100.0095.45100.000.00起始位置图面坐标(mm)绘图孔深绘图采取率XY80.712208.29208.2980.71208.2983.911202.2983.912202.2983.461195.8983.462195.8985.381188.6985.382188.6985.511183.6985.512183.6984.481176.8984.482176.8984.961170.4984.962170.4985.211164.0985.212164.0983.461157.6983.462157.6984.711154
13、.0984.712154.0988.711150.8988.712150.8985.261142.0985.262142.0982.651129.6982.652129.6984.521125.4984.522125.4986.051119.4986.052119.4988.711112.6988.712112.6983.621110.4983.622110.4988.711106.0988.712106.0983.661102.2983.662102.2988.71195.6988.71295.6987.57188.6987.57288.6988.14177.4988.14277.4988.
14、71170.8988.71270.8983.06167.4983.06267.4988.71160.4988.71260.4987.71152.4987.71252.4988.71146.0988.71246.0987.45138.4987.45238.4988.71135.4988.712采采取取率率100.00 80.00 60.00 40.00 20.00 0.00 100.00 90.00 80.00 70.00 60.00 50.00 40.00 30.00 20.00 10.00 0.00 35.4988.17126.6988.17226.6988.71123.2988.71223
15、.2984.33112.6984.33212.6988.3518.2988.3528.2980.712采采取取率率100.00 80.00 60.00 40.00 20.00 0.00 100.00 90.00 80.00 70.00 60.00 50.00 40.00 30.00 20.00 10.00 0.00 采采取取率率100.00 80.00 60.00 40.00 20.00 0.00 100.00 90.00 80.00 70.00 60.00 50.00 40.00 30.00 20.00 10.00 0.00 数据录入区抽抽水水阶阶段段历时时间日期时间水位读数 井台高 静水位
16、 实际水位降深流量分钟小时2017/2/11 9:30(m)(m)(m)(m)(m)(m3/h)(l/s)第一次降深00.002017/2/11 9:3011.900.5011.4011.400.000.000.0010.022017/2/11 9:3121.0220.529.121.830.5120.032017/2/11 9:3226.4725.9714.571.840.5130.052017/2/11 9:3330.8530.3518.951.910.5340.072017/2/11 9:3432.9932.4921.091.950.5460.102017/2/11 9:3635.523
17、5.0223.621.980.5580.132017/2/11 9:3837.3636.8625.462.000.56100.172017/2/11 9:4038.2737.7726.371.970.55150.252017/2/11 9:4539.0538.5527.151.930.54200.332017/2/11 9:5040.3239.8228.421.900.53250.422017/2/11 9:5541.0140.5129.111.870.52300.502017/2/11 10:0041.2340.7329.331.880.52400.672017/2/11 10:1041.4
18、240.9229.521.890.53500.832017/2/11 10:2041.5241.0229.621.890.53601.002017/2/11 10:3041.5641.0629.661.900.53801.332017/2/11 10:5041.5741.0729.671.900.531001.672017/2/11 11:1041.5641.0629.661.890.531202.002017/2/11 11:3041.5741.0729.671.910.531502.502017/2/11 12:0041.5941.0929.691.900.531803.002017/2/
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 利用 excel section 快速 准确 生成 抽水 试验 曲线 表格
限制150内