2019环刀法、压实度、原始记录自动计算表(F9)

36
0.17525957
0.5498197518
12
0.4134652762
2
0.7079304724
4
0.6977381556
25
0.2486016550
62
0.0248282109
5
0.5963100077
43
0.1284237870
41
0.1292445836
9
0.316650442
38 0.069687799
10 0.295729817
45 0.005476878
5
0.510194936
33 0.109339588
17 0.211487048
11 0.290828721
2
0.732665752
24 0.164326989
37 0.073462442
27 0.142489597
96.02
101.49
283.52
289.06
292.08
290.80
299.74
299.01
285.85
297.37
184.45
192.02
192.52
190.64
198.78
197.00
189.83
195.88
1.85
1.93
1.93
1.91
1.99
1.97
1.91
1.96
4
22
7
3
14 23 43 41 15 20 31
干密度
(g/cm³)
最大干密度
(g/cm³)
压实度
(%)
试验：
合同号： 代表部位 主要设备编号
试验编号： 试验日期 试验方法
38
17
48
32
52
45
64
21
99.70
99.49
99.75
99.81
99.89
100.00
99.39
99.94
99.07
97.04
99.56
100.16
100.96
102.01
辅助列
4 22 7 3 14 23 43 41 15 20 31 8 12 1 44 18 40 32 36 29 46 19
0.651050274 0.170694046 0.436674203 0.719982006 0.24857345 0.165965323 0.012007528 0.030669373 0.23657762 0.180573286 0.112354352 0.329612279 0.276389073 0.829215402 0.007827751 0.200291602 0.061671636 0.112186111 0.080303388 0.122875349 5.5272E-05 0.187265071
12
2
15.94
17
3
99.44 96.53
60
3
15.35
48
4
99.43 96.42
61
4
16.12
32
5
99.98 101.82
23
5
16.54
52
6
99.36 95.71
7
6
15.35
45
7
99.35 95.67
6
7
15.77
64
8
99.59 97.91
35
8
16.81
21
9
99.99 101.93
47
29
16.76
46
30
99.57 97.78
8
30
15.91
31
31
99.48 96.98
26
31
15.73
16
32
99.81 100.16
13
32
15.79
49
33
99.92 101.23
55
33
15.56
30
34
99.52 97.32
67
34
15.90
15
35
99.37 95.82
62
35
16.13
51
99.79 99.95
68
52
99.89 100.96
32
53
99.88 100.87
39
54
99.42 96.31
16
55
99.62 98.26
28
56
99.73 99.32
70
57
99.51 97.27
46
58
99.56 97.69
66
59
99.78 99.81
53
60
99.32 95.33
13
0.27546852
6
0.443541091
25 0.156560469
39 0.061798935
42 0.025908444
16 0.229759392
35 0.087477413
21 0.175110202
30 0.116285227
28 0.131593374
26 0.146002493
59
51
50
99.97 101.75
51
11
0.2991910667 0.2452037089 0.2593318732 0.5661233457 0.0632597739 0.0005083839 0.1101455744 0.2024939914
0.3234956823
0.1079135534 0.2057580118 0.3258460019 0.0825518494 0.2066438086 0.0018977435 0.1043653291 0.7035542251 0.0239287017 0.1332185628 0.3113355596 0.0723855101 0.1274079192 0.0026736962 0.4687189957 0.3614723366 0.1781369639 0.0991426920 0.4449398053
14.07 15.31 20.11 22.78 20.56 18.57 15.69 24.69 21.29 16.58 18.95 24.73 17.11 15.10 21.63 22.99
15.3 15.9 16.2 16.4 15.8 15.0 18.1 17.5 16.5 17.1 14.7 14.9 16.6 16.6 16.3 15.5
29
42
15.81
18
43
99.55 97.56
24
43
15.99
56
44
99.69 98.98
56
44
16.62
44
45
100.00 102.01
36
45
17.51
68
46
99.86 100.68
48
46
17.51
10
47
99.58 97.83
20
14
48
99.75 99.56
69
35
49
99.53 97.44
53
36
99.74 99.43
71
36
16.03
29
37
99.66 98.67
37
37
16.72
69
38
99.70 99.07
63
38
17.15
50
39
99.82 100.24
19
39
16.48
3
40
99.40 96.15
44
40
17.18
63
41
99.95 101.56
38
41
16.72
40
42
99.47 93.89
-0.3
-0.1
0.4
取整 ROUND (D10, 2)
注：1、黄色手动输入！ 2、辅助列只可拉长不可更改！ 3、绿色数值可自行修改！ 4、F9自动随机值！
0.3
-0.3
-0.1
0
0.4
最大干密度 1.74
环刀号 体积
质量 环刀号 铝盒 质量
1
99.45 96.67
15
1
16.03
38
2
99.50 97.12
34 0.091240736
19
16
99.83 100.33
1
16
16.61
28
17
99.49 97.04
14
17
16.50
39
18
99.90 101.04
42
18
15.61
1
19
99.68 98.86
31
19
16.64
54
20
99.76 99.69
17
20
16.57
42
21
99.94 101.49
2
21
16.32
61
22
99.38 95.99
23
99.34 95.56
34
23
16.48
20
24
99.72 99.25
49
24
16.14
26
25
99.91 101.17
65
25
16.36
23