工程量计算稿excel表格模板

D1首层 工程名称：宇宙中心产业园 单位：立方（m³） 构件类型 构件名称 构件数量 构件部位 计算式 数量 备注 墙 Q1，250 4 4-9/A-J (1.4+1.2+1.4+1.2)*4.5*0.25 5.85 3 1-3/B-D (0.88+0.88+1.3)*4.5*0.25 3.4425 3 10-12/B-D (0.88+0.88+1.3)*4.5*0.25 3.4425 Q2,250 1 2-3/D 1.3*4.5*0.25 1.4625 1 10-11/D 1.3*4.5*0.25 1.4625 楼梯间墙 LL下墙，250 2 1-3/B-D,10-12/B-D （2.6*(2.7-0.9)*0.25+1.2*(2.1-0.5)*0.25）*2 3.3 合计 18.96 柱 YBZ1 2 4-9/A (0.6*0.6+0.3*0.25)*4.5*2 3.915 YBZ2 4 4-9/A-J 0.25*0.4*4.5*4 1.8 YBZ3 2 4-9/J (0.6*0.6+0.3*0.25)*4.5*2 3.915 YBZ4 2 2-11/A (1.9*0.3+0.5*0.8+0.5*0.3)*4.5*2 10.08 YBZ5 2 2-11/J (1.5*0.3+0.5*0.8+0.5*0.3)*4.5*2 9 YBZ6 2 2-11/B (1.3*0.25+0.35*0.6+0.35*0.3)*4.5*2 5.76 YBZ7 2 2-11/D (1.3*0.25+0.35*0.5+0.55*0.35)*4.5*2 6.2325 YBZ8 2 3-10/B (1*0.25+0.3*0.25)*4.5*2 2.925 YBZ9 4 1-12/B-D (0.25*0.55+0.05*0.25)*4.5*4 2.7 YBZ10 2 3-10/D (1*0.25+0.3*0.25)*4.5*2 2.925 GBZ1 4 2-11/B-D 0.4*0.25*4.5*4 1.8 KZ1 2 4-9/D 0.6*0.6*4.5*2 3.24 KZ2 1 6/A 0.7*0.7*4.5 2.205 KZ3 1 6/D 0.8*0.8*4.5 2.88 KZ4 1 6/J 0.7*0.7*4.5 2.205 合计 61.5825 梁 LL(JX)1 2 2-11/B 1.9*0.25*0.5*2 0.475 LL(JX)2 2 2-11/D 1.9*0.25*0.5*2 0.475 LL(JX)3 2 3-10/B-D 1.2*0.25*0.5*2 0.3 LL4 2 1/B-D,12/B-D 2.6*0.25*0.9*2 1.17 LL(JX)5 2 3-10/D 1.55*0.3*0.6*2 0.558 L1 1 5/D-J 7.9*0.3*0.7 1.659 L2 1 7/D-J 7.9*0.25*0.6 1.185 L3 1 8/D-J 7.9*0.25*0.7 1.3825 L4 2 4-9/C (8+8)*0.3*0.7 3.36 L5 1 2-4/E 6.85*0.25*0.6 1.0275 L6 4 7-8/D-J 1.85*4*0.2*0.4 0.592 L7 1 9-11/E 6.85*0.25*0.6 1.0275 KL1 1 2/A-B 4.5*0.3*0.9 1.215 KL2 2 2/B-D 2.7*0.3*0.8*2 1.296 有变更，取消 KL3 1 2/D-H 6*0.3*0.9 1.62 KL4 2 4/A-G (7.6+5.3)*0.3*0.8 3.096 KL5 2 6/A-H (9.4+7)*0.35*1.2 6.888 KL6 2 9/A-G (7.6+5.3)*0.3*0.8 3.096 KL7 1 11/A-B 4.5*0.3*0.9 1.215 KL8 1 11/D-J 6*0.3*0.9 1.62 KL9 4 2-11/A (5.7+7.75+7.75+6.2)*0.3*0.8 6.576 KL10 2 3-10/B (1.7+1.7)*0.2*0.6 0.408 KL11 2 4-9/D (7.7+7.7)*0.4*0.8 4.928 KL12 4 2-11/J (5.7+7.75+7.75+5.7)*0.3*0.8 6.456 合计 51.6255 板 LB1 4 (4.76+14.26+2.96+4.76)*0.15 4.011 LB2 4 (64.89+64.89+11.71+11.71)*0.22 33.704 LB3 2 (46.2+46.2)*0.2 18.48 LB4 4 (41.56+41.56+11.84+11.84)*0.18 19.224 LB5 3 (30.735+30.454+30.735)*0.16 14.70784 LB6 1 0.52*0.15 0.078 合计 90.20484 楼梯 PTB1 4 (4.32+2.7)*0.12*2 1.6848 TL1 4 (2.7+2.7)*0.2*0.35*2 0.756 AT6 2 4*1.2*0.12+(0.26*0.17)/2*1.2*13*2 1.26552 AT7 2 4*1.2*0.12+(0.26*0.17)/2*1.2*13*2 1.26552 合计 4.97184 挑檐 节点 2 (7.7+7.2+8.5+31.6+8.5)*0.2*0.1*2 2.54 合计 2.54 其他 总计 229.88468&C&"仿宋,加粗"&24工程量计算稿D1二层 工程名称：宇宙中心产业园 单位：立方（m³） 构件类型 构件名称 构件数量 构件部位 计算式 数量 备注 墙 Q1，250 4 4-9/A-J (1.4+1.2+1.4+1.2)*4.5*0.25 5.85 3 1-3/B-D (0.88+0.88+1.3)*4.5*0.25 3.4425 3 10-12/B-D (0.88+0.88+1.3)*4.5*0.25 3.4425 Q2,250 1 2-3/D 1.3*4.5*0.25 1.4625 1 10-11/D 1.3*4.5*0.25 1.4625 楼梯间墙 LL下墙，250 2 3/B-D,10/B-D 1.2*(2.1-0.5)*0.25*2 0.96 合计 16.62 柱 YBZ1 2 4-9/A (0.6*0.6+0.3*0.25)*4.5*2 3.915 YBZ2 4 4-9/A-J 0.25*0.4*4.5*4 1.8 YBZ3 2 4-9/J (0.6*0.6+0.3*0.25)*4.5*2 3.915 YBZ4 2 2-11/A (1.9*0.3+0.5*0.8+0.5*0.3)*4.5*2 10.08 YBZ5 2 2-11/J (1.5*0.3+0.5*0.8+0.5*0.3)*4.5*2 9 YBZ7 2 2-11/B (1.3*0.25+0.35*0.6+0.35*0.3)*4.5*2 5.76 YBZ8 2 2-11/D (1.3*0.25+0.35*0.5+0.55*0.35)*4.5*2 6.2325 YBZ9 2 3-10/B (1*0.25+0.3*0.25)*4.5*2 2.925 YBZ10 4 1-12/B-D (0.25*0.55+0.15*0.25)*4.5*4 3.15 YBZ11 2 3-10/D (1*0.25+0.3*0.25)*4.5*2 2.925 GBZ1 4 2-11/B-D 0.4*0.25*4.5*4 1.8 KZ1 2 4-9/D 0.6*0.6*4.5*2 3.24 KZ2 1 6/A 0.7*0.7*4.5 2.205 KZ3 1 6/D 0.8*0.8*4.5 2.88 KZ4 1 6/J 0.7*0.7*4.5 2.205 合计 62.0325 梁 LL(JX)1 2 2-11/B 1.9*0.25*0.5*2 0.475 LL(JX)2 2 2-11/D 1.9*0.25*0.5*2 0.475 LL(JX)3 2 3-10/B-D 1.2*0.25*0.5*2 0.3 LL4 2 1/B-D,12/B-D 2.4*0.25*0.9*2 1.08 与首层尺寸不同 LL(JX)5 2 3-10/D 1.55*0.3*0.6*2 0.558 L1 1 5/D-J 7.9*0.3*0.7 1.659 L2 1 7/D-J 7.9*0.25*0.6 1.185 L3 1 8/D-J 7.9*0.25*0.7 1.3825 L4 2 4-9/C (8+8)*0.3*0.7 3.36 L5 1 2-4/E 6.85*0.25*0.6 1.0275 L6 4 7-8/D-J 1.85*4*0.2*0.4 0.592 L7 1 9-11/E 6.85*0.25*0.6 1.0275 KL1 1 2/A-B 4.5*0.3*0.9 1.215 KL2 2 2/B-D 2.7*0.3*0.8*2 1.296 有变更，取消 KL3 1 2/D-H 6*0.3*0.9 1.62 KL4 2 4/A-G (7.6+5.3)*0.3*0.8 3.096 KL5 2 6/A-H (9.4+7)*0.35*1.2 6.888 KL6 2 9/A-G (7.6+5.3)*0.3*0.8 3.096 KL7 1 11/A-B 4.5*0.3*0.9 1.215 KL8 1 11/D-J 6*0.3*0.9 1.62 KL9 4 2-11/A (5.7+7.75+7.75+6.2)*0.3*0.8 6.576 KL10 2 3-10/B (1.7+1.7)*0.2*0.6 0.408 KL11 2 4-9/D (7.7+7.7)*0.4*0.8 4.928 KL12 4 2-11/J (5.7+7.75+7.75+5.7)*0.3*0.8 6.456 合计 51.5355 板 LB1 4 (4.76+14.26+2.96+4.76)*0.15 4.011 LB2 4 (64.89+64.89+11.71+11.71)*0.22 33.704 LB3 2 (46.2+46.2)*0.2 18.48 LB4 4 (41.56+41.56+11.84+11.84)*0.18 19.224 LB5 3 (30.735+30.454+30.735)*0.16 14.70784 LB6 1 0.52*0.15 0.078 合计 90.20484 楼梯 PTB1 4 (4.32+2.7)*0.12*2 1.6848 TL1 4 (2.7+2.7)*0.2*0.35*2 0.756 AT8 2 4*1.2*0.12+(0.28*0.16)/2*1.2*13*2 1.27488 AT8 2 4*1.2*0.12+(0.28*0.16)/2*1.2*13*2 1.27488 合计 4.99056 挑檐 节点 2 (7.2+31.6+7.2+8.5+31.6+8.5)*0.2*0.1*2 3.784 合计 3.784 其他 总计 229.1674&C&"仿宋,加粗"&24工程量计算稿机房 工程名称：宇宙中心产业园 单位：立方（m³） 构件类型 构件名称 构件数量 构件部位 计算式 数量 备注 墙 Q1，200 4 1-3/B-D,10-12/B-D 5.8*4*0.2*3.2 14.848 合计 14.848 柱 GBZ1 4 1/B-D,12/B-D (0.2*0.5+0.2*0.15)*3.2*4 1.664 GBZ2 4 3/B-D,10/B-D (0.2*0.3+0.2*0.95)*3.2*4 3.2 LZ1 3 6-9/D-J 0.4*0.4*3.2*3 1.536 LZ2 1 8/H 0.4*0.4*3.2*1 0.512 合计 6.912 梁 WKL1 2 6/H-F,8/H-F 17.36*0.12*2 4.1664 WKL2 2 H/6-8,F/6-8 3.8*0.2*0.6*2 0.912 L1 1 7/H-F 4.8*0.2*0.6 0.576 L2 1 G/6-8 (2+1.8)*0.2*0.6 0.456 合计 6.1104 板 WB1 2 B-D/2-3,B-D/10-12 17.36*0.12*2 4.1664 WB2 2 7-8/F-H 4.17*0.15*2 1.251 WB3 2 6-7/F-H 4.63*0.12*2 1.1112 XB1 1 6-7/E-F 1.84*0.12 0.2208 XB2 2 3-4/B-D,9-10/B-D 1.836*0.12*2 0.44064 合计 7.19004 女儿墙 大屋面 1 大屋顶周圈 （48.6+46）*1.2*0.12+（48.6+46）*0.08*0.06 14.07648 小屋面 3 机房顶周圈 （19.5*0.61+9.5*0.06）*0.1*2+（18.4*0.6+18.4*0.06）*0.1 3.7074 合计 17.78388 总计 52.84432&C&"仿宋,加粗"&24工程量计算稿sheet 构件类型 构件名称 构件部位 计算式 数量 单位 墙 1+1 0 m³ 1+1+5 0 13.2405 1.16025&C&"仿宋,加粗"&24工程量计算书