标贯统计计算表

1、勘探点编号 孔口标高-1层底深度层底标高厚度层底深度层底标高厚度1-1.342-1.313-1.164-1.215-1.296-1.217-1.098-1.839-1.6810-1.4711-1.2712-1.2813-1.3414-1.0715-0.9616-0.8817-0.9218-1.3619-1.2920-1.2621-0.9222-1.3723-1.3224-1.2125-0.9326-1.1327-1.2728-1.09-2层底深度层底标高厚度层底深度层底标高厚度层底深度层底标高-1厚度层底深度层底标高厚度层底深度层底标高厚度地地层层编编号号中中砂砂圆圆砾砾粉粉粘粘粗粗砂砂卵卵石

2、石强强风风化化标标贯贯击击数数22.022.090.09 90 024.024.0150.01 15 50 028.028.0230.011.011.056.05 56 626.026.072.07 72 262.06 62 2130.01 13 30 0220.053.05 53 353.05 53 3115.01 11 15 556.05 56 6120.01 12 20 0210.075.07 75 5135.01 13 35 5225.069.06 69 9115.01 11 15 5220.068.06 68 8119.01 11 19 9205.070.07 70 0125.01

3、12 25 5220.078.07 78 8145.01 14 45 5209.075.07 75 5126.01 12 26 6215.075.07 75 5143.01 14 43 353.05 53 3120.01 12 20 0179.01 17 79 9210.059.05 59 9105.01 10 05 5163.01 16 63 3标标贯贯击击数数标标贯贯击击数数标标贯贯击击数数标标贯贯击击数数标标贯贯击击数数标标贯贯击击数数个个数数0 00 00 03 31 10 00 0最最小小值值0 00 00 05 53 30 00 0最最大大值值0 00 00 01 17 79 90

4、 00 0平平均均值值#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!9 98 8. .5 5#DIV/0!#DIV/0!#DIV/0!#DIV/0!标标准准差差#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!3 37 7. .1 12 2#DIV/0!#DIV/0!#DIV/0!#DIV/0!变变异异系系数数#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0 0. .3 38 8#DIV/0!#DIV/0!#DIV/0!#DIV/0!0 0. .1 13 30 0. .1 14 40

5、0. .1 16 60 0. .2 23 30 0. .1 11 10 0. .3 30 0s#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0 0. .9 91 1#DIV/0!#DIV/0!#DIV/0!#DIV/0!标标准准值值#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!8 89 9. .9 98 8#DIV/0!#DIV/0!#DIV/0!#DIV/0!的取值2 20.444 40 00.273 30.426 60 00.224 40.418 80 00.195 50.41 10 00 00.176 60.39

6、1 12 20 00.16标标贯贯击击数数7 70.381 14 40 00.158 80.371 16 60 00.149 90.361 18 80 00.131 10 00.352 20 00 00.121 11 10.342 22 20 00.111 12 20.342 24 40 01 13 30.331 14 40.321 15 50.321 16 60.31170.31180.31190.3200.3300.29压压缩缩系系数数压压缩缩模模量量qqCqCq0 00 00 00 00 00 00 00 00 00 00 00 0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0 0. .3 33 30 0. .3 33 30 0. .3 33 30 0. .3 33 3#DIV/0!