Excel钢筋工程量自动计算表格 (1)

序号构件名称编号直径根数计算式根数筋长计算式m单根长度件数重量kg备注1底板配筋二级1616.7/0.15+111210.35+0.210.5523743.8312二级1410.35/0.15+17019.1+0.419.523301.4443二级141.2/0.2*21210.35+0.210.552306.2004池壁二级1616.7/0.2+1855564004.083二级2016.7/0.2+1852.52.521042.730二级145/0.2+12616.716.763150.520二级145/0.2+126444503.077二级125/0.2+126444369.608二级149.05/0.2+1465541118.621二级145/0.2+1269.19.141144.500二级1019.1/0.15+11281.31.32205.872二级101.3/0.2+1819.119.12176.771池体配筋二级1616/0.4+1410.25*1.21+20*0.0160.6225280.627二级14（8.4/0.4+1）220.25*1.21+20*0.0160.6225233.123二级16663.35+1.9*2+10.35*2+16*3+1.4+1.55*483.451790.866二级206616162473.856000010.000000010.000000010.000冲水洗回用水池钢筋工程量计算稿工程名称：综合池一、环形基础序号构件名称编号直径根数计算式根数筋长计算式m单根长度件数重量kg备注冲水洗回用水池钢筋工程量计算稿工程名称：综合池000010.000000010.000000010.000000010.000000010.000000010.000000010.000000010.000000010.000000010.000#VALUE!1#VALUE!#VALUE!1#VALUE!#VALUE!1#VALUE!#VALUE!1#VALUE!#VALUE!1#VALUE!#VALUE!1#VALUE!#VALUE!1#VALUE!#VALUE!1#VALUE!#VALUE!1#VALUE!#VALUE!1#VALUE!序号构件名称编号直径根数计算式根数筋长计算式m单根长度件数重量kg备注冲水洗回用水池钢筋工程量计算稿工程名称：综合池000010.000000010.000000010.000000010.000000010.000000010.000000010.000000010.000Φ6的钢筋分类合计60.00Φ6.5的钢筋分类合计6.50.00Φ8的钢筋分类合计80.00Φ10的钢筋分类合计10382.64Φ12的钢筋分类合计12369.61Φ14的钢筋分类合计149557.49Φ16的钢筋分类合计168619.41Φ18的钢筋分类合计180.00Φ20的钢筋分类合计201516.59Φ22的钢筋分类合计220.00Φ25的钢筋分类合计250.00序号构件名称编号直径根数计算式根数筋长计算式m单根长度件数重量kg备注冲水洗回用水池钢筋工程量计算稿工程名称：综合池Φ28的钢筋分类合计280.00Φ32的钢筋分类合计320.00合计直径10以下的钢筋≤10382.64合计直径10以上的钢筋1020063.0918684.61419971.87320445.729