Excel钢筋工程量自动计算表格.xls
Sheet3
Sheet2
Sheet1
Print_Titles
根数计算式
筋长计算式
粉煤灰库钢筋工程量计算稿
工程名称：粉煤灰库
序号
构件名称
编号
等级
直径
根数计算式
根数
筋长计算式m
单根长度
件数
重量kg
备注
一、环形基础
环形基础上下环筋
11+11
15.25*3.14+（50-31）*0.025*6
环形基础上部环筋
0.5/0.2*2
15.25*3.14+（50-31）*0.012*6
环形基础下部环筋
0.5/0.15*2
外层腰筋
1.2/0.2*2
15.25*3.14+（50-31）*0.01*6
Φ6的钢筋分类合计
Φ6.5的钢筋分类合计
Φ8的钢筋分类合计
Φ10的钢筋分类合计
Φ12的钢筋分类合计
Φ14的钢筋分类合计
Φ16的钢筋分类合计
Φ18的钢筋分类合计
Φ20的钢筋分类合计
Φ22的钢筋分类合计
Φ25的钢筋分类合计
Φ28的钢筋分类合计
Φ32的钢筋分类合计
合计直径10以下的钢筋
≤10
合计直径10以上的钢筋
10
1.00
2.00
10.00
1.00
10.00
2.00
25.00
22.00
50.74
1.00
4304.23
2.00
6.17E-03
2.00
2.00
10.00
1.00
10.00
2.00
12.00
6.00
49.25
1.00
262.56
2.00
6.17E-03
3.00
2.00
10.00
1.00
10.00
2.00
25.00
8.00
50.74
1.00
1565.17
2.00
6.17E-03
4.00
1.00
10.00
1.00
10.00
2.00
10.00
12.00
49.03
1.00
362.98
2.00
6.17E-03
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
.00
.00
.00
.00
1.00
.00
6.00
.00
6.00
6.50
.00
6.50
8.00
.00
8.00
10.00
362.98
10.00
12.00
262.56
12.00
14.00
.00
14.00
16.00
.00
16.00
18.00
.00
18.00
20.00
.00
20.00
22.00
.00
22.00
25.00