钢筋工程量计算表格-内嵌自动计算和统计汇总公式

序号123456710111213141516171819202122232425项目名称KL1(1)250x600构件个数1111111111111111111111111部位3.00标高筋号上部通长下部筋支座钢筋支座钢筋支座钢筋支座钢筋箍筋加密钢筋型号Ⅲ22Ⅲ20Ⅲ22Ⅲ22Ⅲ22Ⅲ22Ⅰ8单根工程量单根长度计算公式根数#NAME?2#NAME?4#NAME?2#NAME?2#NAME?2#NAME?2根数计算公式#NAME?7.5+0.25+0.25-2*0.03+15*0.022*2#NAME?7.5+0.25+0.25-2*0.03+15*0.020*20.8-0.03+15*0.022+（7.5-0.55-#NAME?0.25）/30.5-0.03+15*0.022+（7.5-0.55-#NAME?0.25）/30.8-0.03+15*0.022+（7.5-0.55-#NAME?0.25）/40.5-0.03+15*0.022+（7.5-0.55-#NAME?0.25）/4#NAME?（0.25+0.6）*2-8*0.03+31.8*0.008#NAME?（0.25+0.6）*2-8*0.03+31.8*0.008#NAME?#NAME?#NAME?#NAME?#NAME?（0.25+0.6）*2-8*0.03+31.8*0.0087.5-0.55-0.25+2*12*0.0120.25-2*0.03+25.8*0.0087.5+0.125+0.25-2*0.03+15*2*0.0147.5+0.125+0.25-2*0.03+15*2*0.020箍筋非加密Ⅰ8附加箍筋构造钢筋拉筋上部通长下部筋支座钢筋箍筋构造钢筋拉筋上部通长下部筋下部筋支座钢筋支座钢筋箍筋加密Ⅰ8Ⅰ12Ⅰ8Ⅲ14Ⅲ20Ⅲ14Ⅰ8Ⅰ12Ⅰ8Ⅲ18Ⅲ18Ⅲ16Ⅲ20Ⅲ18Ⅰ8L1(1)250x6003.00标高#NAME?（1.5*0.6/0.1+1）*2（7.5-0.55-0.25-1.5*0.6*2）#NAME?/0.15-1#NAME?6#NAME?4#NAME?（7.5-0.55-0.25）/0.3*2#NAME?2#NAME?4#NAME?2#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?（7.5-0.125）/0.2+14（7.5-0.125）/0.4*2222#NAME?0.25-0.03+15*0.014+（7.5-0.125）/3#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?（0.25+0.6）*2-8*0.03+31.8*0.0087.5-0.125+2*12*0.0120.25-2*0.03+25.8*0.0087.5+0.25+0.2-2*0.03+15*0.018*27.5+0.25+0.2-2*0.03+15*0.018*27.5+0.25+0.2-2*0.03+15*0.016*20.6-0.03+15*0.02+（7.5-0.35-0.2）#NAME?/30.4-0.03+15*0.018+（7.5-0.35-0.2）#NAME?/3#NAME?（0.25+0.6）*2-8*0.03+31.8*0.008#NAME?（0.25+0.6）*2-8*0.03+31.8*0.008#NAME?（0.25+0.6）*2-8*0.03+31.8*0.008KL2(1)250x6003.00标高#NAME?2#NAME?2#NAME?（1.5*0.6/0.1+1）*2（7.5-0.35-0.25-1.5*0.6*2）#NAME?/0.15-1#NAME?6箍筋非加密Ⅰ8附加箍筋Ⅰ8序号26272829303132333435363738394041424344454748495051项目名称构件个数11111111111111111111111111部位筋号构造钢筋拉筋上部通长下部筋箍筋附加箍筋上部通长下部筋箍筋附加箍筋上部通长下部筋支座钢筋支座钢筋箍筋加密钢筋型号Ⅰ12Ⅰ8Ⅲ14Ⅲ20Ⅰ8Ⅰ8Ⅲ20Ⅲ20Ⅰ8Ⅰ8Ⅲ22Ⅲ20Ⅲ22Ⅲ22Ⅰ8单根工程量#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?单根长度计算公式根数#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?根数计算公式4（7.5-0.35-0.2）/0.3*233（7.5-0.25*2）/0.2+11233（7.5-0.25*2）/0.2+11224L2(2)250x4003.00标高L3(2)250x4003.00标高KL3(1)250x6503.00标高7.5-0.35-0.2+2*12*0.0120.25-2*0.03+25.8*0.0087.5+0.25-2*0.03+2*15*0.0147.5+0.25-2*0.03+2*15*0.014（0.25+0.4）*2-8*0.03+31.8*0.008（0.25+0.4）*2-8*0.03+31.8*0.0087.5+0.25-2*0.03+2*15*0.0147.5+0.25-2*0.03+2*15*0.014（0.25+0.4）*2-8*0.03+31.8*0.008（0.25+0.4）*2-8*0.03+31.8*0.0087.5+0.2+0.4-2*0.03+15*0.022*27.5+0.2+0.4-2*0.03+15*0.022*20.8-0.03+15*0.022+（7.5-0.2-0.4）#NAME?/30.4-0.03+15*0.022+（7.5-0.2-0.4）#NAME?/3#NAME?（0.25+0.65）*2-8*0.03+31.8*0.008#NAME?（0.25+0.65）*2-8*0.03+31.8*0.008#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?（0.25+0.65）*2-8*0.03+31.8*0.0087.5-0.55-0.25+2*12*0.0120.25-2*0.03+25.8*0.0087.5+0.25+0.25-2*0.03+15*0.025*27.5+0.25+0.25-2*0.03+15*0.022*20.8-0.03+15*0.025+（7.5-0.55-0.25）/30.5-0.03+15*0.025+（7.5-0.55-0.25）/30.8-0.03+15*0.025+（7.5-0.55-0.25）/40.5-0.03+15*0.025+（7.5-0.55-0.25）/4（0.25+0.6）*2-8*0.03+31.8*0.008#NAME?2#NAME?2#NAME?（1.5*0.65/0.1+1）*2（7.5-0.2-0.4-0.25-#NAME?1.5*0.65*2）/0.15-1#NAME?6#NAME?4#NAME?（7.5-0.2-0.4）/0.3*2#NAME?2#NAME?4#NAME?1#NAME?2#NAME?2#NAME?2#NAME?（1.5*0.6/0.1+1）*2箍筋非加密Ⅰ8附加箍筋构造钢筋拉筋上部通长下部筋支座钢筋支座钢筋支座钢筋支座钢筋箍筋加密Ⅰ8Ⅰ12Ⅰ8Ⅲ25Ⅲ22Ⅲ25Ⅲ25Ⅲ25Ⅲ25Ⅰ8KL4(1)250x6003.00标高序号52535455565758596061626365666768697071727374757677项目名称构件个数111111部位筋号钢筋型号单根工程量单根长度计算公式根数#NAME?#NAME?#NAME?#NAME?#NAME?根数计算公式（7.5-0.55-0.25-1.5*0.6*2）/0.2-12（7.5-0.55-0.25）/0.424箍筋非加密Ⅰ8构造钢筋拉筋上部通长下部筋支座钢筋3.00标高箍筋上部通长下部筋支座钢筋支座钢筋箍筋加密Ⅰ12Ⅰ8Ⅲ14Ⅲ20Ⅲ14Ⅰ8Ⅲ18Ⅲ16Ⅲ20Ⅲ18Ⅰ8#NAME?（0.25+0.6）*2-8*0.03+31.8*0.008#NAME?#NAME?#NAME?#NAME?7.5-0.55-0.25+2*12*0.0120.25-2*0.03+25.8*0.0087.5+0.125+0.25-2*0.03+15*2*0.0147.5+0.125+0.25-2*0.03+15*2*0.020L4(1)250x5003.00标高#NAME?0.25-0.03+15*0.014+（7.5-0.125）/3#NAME?（0.25+0.6）*2-8*0.03+31.8*0.008#NAME?7.5+0.25+0.25-2*0.03+15*0.025*2#NAME?7.5+0.25+0.25-2*0.03+15*0.022*20.6-0.03+15*0.02+（7.5-0.35-0.2）#NAME?/30.4-0.03+15*0.018+（7.5-0.35-0.2）#NAME?/3#NAME?（0.25+0.6）*2-8*0.03+31.8*0.008#NAME?（0.25+0.6）*2-8*0.03+31.8*0.008#NAME?7.5-0.55-0.25+2*12*0.012#NAME?0.25-2*0.03+25.8*0.008#NAME?2#NAME?（7.5-0.125）/0.2+1#NAME?2#NAME?4#NAME?2#NAME?1#NAME?（1.5*0.6/0.1+1）*2（7.5-0.35-0.2-1.5*0.6*2）#NAME?/0.2-1#NAME?2#NAME?（7.5-0.35-0.2）/0.4KL5(1)250x600111111111箍筋非加密Ⅰ8构造钢筋拉筋Ⅰ12Ⅰ8总工程量（m）#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?总工程量（m）#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?总工程量（m）#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?