利用excel在section中快速准确生成抽水试验等曲线-表格.xlsx

孔深（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.2228.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.9099.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/ /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.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.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.712208.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.4988.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.1318.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.803.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.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.283297.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.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.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.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 数据录入区抽抽水水阶阶段段历时时间日期时间水位读数 井台高 静水位 实际水位降深流量分钟小时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.5235.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.4240.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/11 12:3041.5941.0929.691.880.522103.502017/2/11 13:0041.5641.0629.661.890.532404.002017/2/11 13:3041.5641.0629.661.890.532704.502017/2/11 14:0041.5741.0729.671.890.533005.002017/2/11 14:3041.5741.0729.671.890.533305.502017/2/11 15:0041.5641.0629.661.900.533606.002017/2/11 15:3041.5641.0629.661.890.533906.502017/2/11 16:0041.5841.0829.681.890.534207.002017/2/11 16:3041.5741.0729.671.890.534507.502017/2/11 17:0041.5741.0729.671.890.534808.002017/2/11 17:3041.5841.0829.681.890.535108.502017/2/11 18:0041.5741.0729.671.890.53第二次降深5118.522017/2/11 18:0132.8732.3720.971.550.435128.532017/2/11 18:0231.6531.1519.751.570.445138.552017/2/11 18:0330.9330.4319.031.540.435148.572017/2/11 18:0430.5230.0218.621.540.435168.602017/2/11 18:0630.3729.8718.471.520.425188.632017/2/11 18:0830.6130.1118.711.510.425208.672017/2/11 18:1030.8530.3518.951.500.425258.752017/2/11 18:1531.0530.5519.151.480.415308.832017/2/11 18:2031.1130.6119.211.470.415358.922017/2/11 18:2531.1630.6619.261.450.405409.002017/2/11 18:3031.1730.6719.271.450.405509.172017/2/11 18:4031.2130.7119.311.450.405609.332017/2/11 18:5031.2730.7719.371.450.405709.502017/2/11 19:0031.2530.7519.351.450.405909.832017/2/11 19:2031.2530.7519.351.440.4061010.172017/2/11 19:4031.2830.7819.381.440.4063010.502017/2/11 20:0031.2530.7519.351.450.4066011.002017/2/11 20:3031.2830.7819.381.460.4169011.502017/2/11 21:0031.2730.7719.371.460.4172012.002017/2/11 21:3031.2730.7719.371.450.4075012.502017/2/11 22:0031.2630.7619.361.440.4078013.002017/2/11 22:3031.2530.7519.351.430.4081013.502017/2/11 23:0031.2730.7719.371.430.4084014.002017/2/11 23:3031.2630.7619.361.430.4087014.502017/2/12 0:0031.2630.7619.361.430.4090015.002017/2/12 0:3031.2630.7619.361.440.4093015.502017/2/12 1:0031.2830.7819.381.440.4096016.002017/2/12 1:3031.2630.7619.361.450.4099016.502017/2/12 2:0031.2630.7619.361.430.40102017.002017/2/12 2:3031.2630.7619.361.440.40第一次降深第三次降深102117.022017/2/12 2:3122.8322.3310.930.880.24102217.032017/2/12 2:3221.8121.319.910.890.25102317.052017/2/12 2:3321.2120.719.310.880.24102417.072017/2/12 2:3420.8620.368.960.870.24102617.102017/2/12 2:3620.7420.248.840.860.24102817.132017/2/12 2:3820.9420.449.040.840.23103017.172017/2/12 2:4021.1320.639.230.840.23103517.252017/2/12 2:4521.3120.819.410.810.23104017.332017/2/12 2:5021.3620.869.460.800.22104517.422017/2/12 2:5521.4020.909.500.800.22105017.502017/2/12 3:0021.4120.919.510.810.23106017.672017/2/12 3:1021.4420.949.540.820.23107017.832017/2/12 3:2021.5021.009.600.830.23108018.002017/2/12 3:3021.5021.009.600.820.23110018.332017/2/12 3:5021.5021.009.600.800.22112018.672017/2/12 4:1021.4820.989.580.810.23114019.002017/2/12 4:3021.4820.989.580.820.23117019.502017/2/12 5:0021.4920.999.590.820.23120020.002017/2/12 5:3021.5021.009.600.820.23123020.502017/2/12 6:0021.5021.009.600.810.23第二次降深126021.002017/2/12 6:3021.5021.009.600.820.23129021.502017/2/12 7:0021.4920.999.590.830.23132022.002017/2/12 7:3021.4920.999.590.830.23135022.502017/2/12 8:0021.4720.979.570.840.23138023.002017/2/12 8:3021.4820.989.580.830.23141023.502017/2/12 9:0021.4920.999.590.830.23144024.002017/2/12 9:3021.4920.999.590.830.23147024.502017/2/12 10:0021.4920.999.590.830.23150025.002017/2/12 10:3021.5021.009.600.830.23153025.502017/2/12 11:0021.5021.009.600.830.23恢复153125.522017/2/12 11:0118.2017.706.30153225.532017/2/12 11:0216.2015.704.30第三次降深153325.552017/2/12 11:0315.0514.553.15153425.572017/2/12 11:0414.2513.752.35153625.602017/2/12 11:0613.7513.251.85153825.632017/2/12 11:0813.3312.831.43154025.672017/2/12 11:1013.0312.531.13154525.752017/2/12 11:1512.8612.360.96155025.832017/2/12 11:2012.7112.210.81155525.922017/2/12 11:2512.5612.060.66156026.002017/2/12 11:3012.4311.930.53157026.172017/2/12 11:4012.3211.820.42158026.332017/2/12 11:5012.2211.720.32159026.502017/2/12 12:0012.1411.640.24161026.832017/2/12 12:2012.0811.580.18163027.172017/2/12 12:4012.0211.520.12165027.502017/2/12 13:0011.9811.480.08168028.002017/2/12 13:3011.9611.460.06171028.502017/2/12 14:0011.9511.450.05174029.002017/2/12 14:3011.9511.450.05177029.502017/2/12 15:0011.9511.450.05180030.002017/2/12 15:3011.9511.450.05183030.502017/2/12 16:0011.9511.450.05186031.002017/2/12 16:3011.9511.450.05189031.502017/2/12 17:0011.9511.450.05恢复恢复坐标转换区降深次数稳定降深S稳定流量Q稳定单位流量qQ=f（s）曲线q=f（s）曲线（m）(l/s)(l/sm)稳定降深s稳定流量Q稳定降深s稳定单位流量q第一次29.670.530.017708126.72189.94126.28279.70第二次19.360.400.020618137.03183.63136.59282.61第三次9.590.230.024083146.80175.22146.36286.08辅助行0.000.00156.39163.67曲线项目单位Q、s-t过程曲线起点坐标X141.952mmY199.337mm图上意义1mm时间轴0.200h1mm流量轴0.040l/s1mm降深轴2.000mQ-f(s)曲线起点坐标X163.670mmY156.392mm图上意义1mmQ轴0.020l/s1mms轴1.000mq-f(s)曲线起点坐标X261.995mmY155.950mm图上意义1mmq轴0.0010l/(sm)1mms轴1.000m说明：1、带底色的为自动填充格，无底色的是需要输入的数据；2、填入数据的时候请对应降深次数；3、为方便观测时间添加已将本表插入了空白行，B、C、D、H、I、K列根据观测时间自行下拉或删减，Section投图的时候不要有空空白行。数据录入区降降深深- -时时间间35.00 30.00 25.00 20.00 15.00 10.00 5.00 0.00 35.00 30.00 25.00 20.00 15.00 10.00 5.00 0.00 0.60 0.50 0.40 0.30 0.20 0.10 0.00 累累积积时时间间/ /h h降降深深/ /m m流流量量/ /( (L L/ /S S) )s-tQ-tQ = f(s)关系曲线0.60 0.50 0.40 0.30 0.20 0.10 0.00 35.00 30.00 25.00 20.00 15.00 10.00 5.00 0.00 稳稳定定流流量量Q Q( (L L/ /s s) )稳稳定定降降深深S S/ /M Mq = f(s)关系曲线0.030000 0.025000 0.020000 0.015000 0.010000 0.005000 0.000000 35.00 30.00 25.00 20.00 15.00 10.00 5.00 0.00 稳稳定定单单位位流流量量q q/ / l l/ /( (s sm m) ) 稳稳定定降降深深S S/ /M M降降深深- -时时间间35.00 30.00 25.00 20.00 15.00 10.00 5.00 0.00 35.00 30.00 25.00 20.00 15.00 10.00 5.00 0.00 0.60 0.50 0.40 0.30 0.20 0.10 0.00 累累积积时时间间/ /h h降降深深/ /m m流流量量/ /( (L L/ /S S) )s-tQ-tq = f(s)关系曲线0.030000 0.025000 0.020000 0.015000 0.010000 0.005000 0.000000 35.00 30.00 25.00 20.00 15.00 10.00 5.00 0.00 稳稳定定单单位位流流量量q q/ / l l/ /( (s sm m) ) 稳稳定定降降深深S S/ /M M