EXCEL工程量计算表

1、,项目名称,做法,单位,工程量计算式,结果,做法汇总,备注1,树池1,个,10,10,150厚-3:7灰土,m,0.64宽*0.15厚*(1.5-0.24)长*4面*10,4.84,36.83,100厚-C15砼垫层,m,0.44宽*0.1厚*1.26长*4面*10,2.22,42.02,MU10砖-240基础,m,0.24宽*(0.6-0.15-0.1)高*1.26长*4*10个,4.23,24.12,砂浆标号未定,MU10-240砖墙,m,0.24*(0.4-0.06)*1.26*4*10同上,4.11,95.25,砂浆标号未定,60厚-C15压顶,m,0.24*0.06*1.26*4*1

2、0,0.73,4.09,2A6-钢筋,kg,1.5*4*2根*0.26*10,31.2,189.07,A6200-钢筋,kg,0.3*(1.5*4)/0.2根数*0.26*10,23.4,198.46,10厚-青片石贴面 立面,m,1.5*4*(0.4+0.06)高*10,27.6,533.7,做法中无找平厚度及标号,10厚-青片石贴面 平面,m,1.26*4*0.24宽*10,12.1,57.79,做法中无找平厚度及标号2,树池2,个,4,4,150厚-3:7灰土,m,0.64宽*0.15厚*(3-0.24)长*4面*4,4.24,100厚-C15砼垫层,m,0.44宽*0.1厚*2.76长

3、*4面*4,1.94,MU10砖-240基础,m,0.24宽*(0.6-0.15-0.1)高*2.76长*4*4个,3.71,MU10-240砖墙,m,0.24*(0.4-0.06)*2.76*4*4同上,3.6,60厚-C15压顶,m,0.24*0.06*2.76*4*4,0.64,2A6-钢筋,kg,3*4*2根*0.26*4,24.96,A6200-钢筋,kg,0.3*(3.0*4)/0.2根数*0.26*4,18.72,10厚-青片石贴面 立面,m,3.0*4*(0.4+0.06)高*4,22.08,10厚-青片石贴面 平面,m,2.76*4*0.24宽*4,10.6,3,树池3,个,

4、4,4,100宽*300高*495长-砼条石,m,16.34+15.29+13.39+10.95共四个,55.97,55.97,30厚-1:3水泥砂浆,m,55.97长*0.1宽,5.6,25.82,4,树池4,个,1,1,150厚-3:7灰土,m,0.64宽*0.15厚*(2.85+2.4+1.5-0.24*3)长,0.58,100厚-C15砼垫层,m,0.44宽*0.1厚*6.03长,0.27,MU10砖-240基础,m,0.24宽*(0.6-0.15-0.1)高*6.03长,0.51,MU10-240砖墙,m,0.24*(1-0.06)*6.03同上,1.36,60厚-C15压顶,m,0

5、.24*0.06*6.03,0.09,2A6-钢筋,kg,(2.85+2.4+1.5)*2根*0.26,3.51,A6200-钢筋,kg,0.3*(6.75)/0.2根数*0.26,2.63,10厚-青片石贴面 立面,m,6.75*(1+0.06)高,7.16,10厚-青片石贴面 平面,m,6.03*0.24宽,1.45,5,树池5,个,1,1,150厚-3:7灰土,m,0.64宽*0.15厚*(1.16*2+1.26*2)长,0.46,100厚-C15砼垫层,m,0.44宽*0.1厚*4.84长,0.21,MU10砖-240基础,m,0.24宽*(0.6-0.15-0.1)高*4.84长,0

6、.41,MU10-240砖墙,m,0.24*(1-0.06)*4.84同上,1.09,60厚-C15压顶,m,0.24*0.06*4.84,0.07,2A6-钢筋,kg,(1.4*2+1.5*2)*2根*0.26,3.02,A6200-钢筋,kg,0.3*(5.8)/0.2根数*0.26,2.26,10厚-青片石贴面 立面,m,5.8*(1+0.06)高,6.15,10厚-青片石贴面 平面,m,5.8*0.24宽,1.39,6,树池6,个,1,1,150厚-3:7灰土,m,0.64宽*0.15厚*(5.96*2+1.26*2)长,1.39,100厚-C15砼垫层,m,0.44宽*0.1厚*14

7、.44长,0.64,MU10砖-240基础,m,0.24宽*(0.6-0.15-0.1)高*14.44长,1.21,MU10-240砖墙,m,0.24*(1-0.06)*14.44同上,3.26,60厚-C15压顶,m,0.24*0.06*14.44,0.21,2A6-钢筋,kg,(6.2*2+1.5*2)*2根*0.26,8.01,A6200-钢筋,kg,0.3*(15.4)/0.2根数*0.26,6.01,10厚-青片石贴面 立面,m,15.4*(1+0.06)高,16.32,10厚-青片石贴面 平面,m,14.44*0.24宽,3.47,7,树池7,个,3,3,150宽*300高*495

8、长-砼条石,m,1.65长*4面*3个,19.8,49.8,30厚-1:3水泥砂浆,m,19.8*0.15宽,2.97,8,树池8,个,3,3,150宽*300高*495长-砼条石,m,(3.55*2长+1.45*2宽)*3个,30,30厚-1:3水泥砂浆,m,30*0.15宽,4.5,9, 树池9-1,个,1,1,150厚-3:7灰土,m,0.64宽*0.15厚*(1.26*2+1.26*2)长,0.48,100厚-C15砼垫层,m,0.44宽*0.1厚*5.04长,0.22,MU10砖-240基础,m,0.24宽*(0.6-0.15-0.1)高*5.04长,0.42,MU10-240砖墙,

9、m,0.24*(0.45-0.06)*5.04同上,0.47,60厚-C15压顶,m,0.24*0.06*5.04,0.07,2A6-钢筋,kg,(1.5*2+1.5*2)*2根*0.26,3.12,A6200-钢筋,kg,0.3*(6)/0.2根数*0.26,2.34,10厚-青片石贴面 立面,m,6.0*(1+0.06)高,6.36,10厚-青片石贴面 平面,m,5.04*0.24宽,1.21,10, 树池9-2,个,1,1,150厚-3:7灰土,m,0.64宽*0.15厚*(1.26*2+1.26*2)长,0.48,100厚-C15砼垫层,m,0.44宽*0.1厚*5.04长,0.22,

10、MU10砖-240基础,m,0.24宽*1.26长*(0.35*2+0.8*2)不等高,0.7,MU10-240砖墙,m,0.24宽*1.26长*(0.94*2+0.49*2)不等高,0.86,60厚-C15压顶,m,0.24*0.06*5.04,0.07,2A6-钢筋,kg,(1.5*2+1.5*2)*2根*0.26,3.12,A6200-钢筋,kg,0.3*(6)/0.2根数*0.26,2.34,10厚-青片石贴面 立面,m,1.26*(1+0.06)*2+1.26*(0.55+0.06)*2,4.21,10厚-青片石贴面 平面,m,5.04*0.24宽,1.21,11, 树池10,个,1

11、4,14,100宽*300高*495长-砼条石(圆型),m,2*3.14*1.45直径*14,127.48,127.48,尺寸未设计,30厚-1:3水泥砂浆,m,127.48*0.1宽,12.75,12, 树池11,个,4,4,150厚-3:7灰土,m,0.64宽*0.15厚*(10.73*2+2.562*2)长*4,10.21,100厚-C15砼垫层,m,0.44宽*0.1厚*26.584长*4,4.68,MU10砖-240基础,m,0.12宽实际为240*(0.6-0.15-0.1)高*26.584长*4,4.47,MU10-240砖墙,m,0.12宽实际为240*(0.45-0.06)*

12、26.584同上*4,4.98,60厚-C15压顶,m,0.12*0.06*26.584*4,0.77,2A6-钢筋,kg,(27.06)*2根*0.26*4,56.28,A6200-钢筋,kg,0.12*(27.06)/0.2根数*0.26*4,16.89,10厚-青片石贴面 立面,m,27.06*(0.45+0.06)高*4,55.2,10厚-青片石贴面 平面,m,26.584*0.12宽*4,12.76,13, 树池12,个,2,2,150厚-3:7灰土,m,0.64宽*0.15厚*(1.56*2+1.76*2)长*2,1.27,100厚-C15砼垫层,m,0.44宽*0.1厚*6.64

13、长*2,0.58,MU10砖-240基础,m,0.24宽*(0.6-0.15-0.1)高*6.64长*2,1.12,MU10-240砖墙,m,0.24*(0.45-0.06)*6.64同上*2,1.24,60厚-C15压顶,m,0.24*0.06*6.64*2,0.19,2A6-钢筋,kg,(7.6)*2根*0.26*2,7.9,A6200-钢筋,kg,0.3*(7.6)/0.2根数*0.26*2,5.93,10厚-青片石贴面 立面,m,7.6*(0.45+0.06)高*2,7.75,10厚-青片石贴面 平面,m,6.64*0.24宽*2,3.19,14, 树池13,个,2,2,150厚-3:

14、7灰土,m,0.64宽*0.15厚*(2.26*2+2.46*2)长*2,1.81,100厚-C15砼垫层,m,0.44宽*0.1厚*9.44长*2,0.83,MU10砖-240基础,m,0.24宽*(0.6-0.15-0.1)高*9.44长*2,1.59,MU10-240砖墙,m,0.24*(0.45-0.06)*9.44同上*2,1.77,60厚-C15压顶,m,0.24*0.06*9.44*2,0.27,2A6-钢筋,kg,(10.4)*2根*0.26*2,10.82,A6200-钢筋,kg,0.3*(10.4)/0.2根数*0.26*2,8.11,10厚-青片石贴面 立面,m,10.4

15、*(0.45+0.06)高*2,10.61,10厚-青片石贴面 平面,m,9.44*0.24宽*2,4.53,15, 树池14,个,2,2,150厚-3:7灰土,m,0.64宽*0.15厚*(2.96*2+3.16*2)长*2,2.35,100厚-C15砼垫层,m,0.44宽*0.1厚*12.24长*2,1.08,MU10砖-240基础,m,0.24宽*(0.6-0.15-0.1)高*12.24长*2,2.06,MU10-240砖墙,m,0.24*(0.45-0.06)*12.24同上*2,2.29,60厚-C15压顶,m,0.24*0.06*12.24*2,0.35,2A6-钢筋,kg,(1

16、3.2)*2根*0.26*2,13.73,A6200-钢筋,kg,0.3*(13.2)/0.2根数*0.26*2,10.3,10厚-青片石贴面 立面,m,13.2*(0.45+0.06)高*2,13.46,10厚-青片石贴面 平面,m,12.24*0.24宽*2,5.88,16,坐凳1,个,1,1,做法见图纸15-2,150厚-3:7灰土,m,0.675长*0.64宽*0.15高*3个腿,0.19,300厚-C15砼垫层,m,0.675长*0.44宽*0.3高*3个腿,0.27,6.14,坐凳-零星砌体,m,0.675长*0.24宽*0.56高*3,0.27,6.26,支墩四周刷-防木漆,m,

17、(0.675+0.24)*2周长*0.410以上高度*3个腿,2.25,51.77,坐凳-60*30木条,m,(2.1-0.15*3)*4,6.6,181.2,17,坐凳2,个,1,1,150厚-3:7灰土,m,0.675长*0.64宽*0.15高*8个腿,0.52,300厚-C15砼垫层,m,0.675长*0.44宽*0.3高*8个腿,0.71,坐凳-零星砌体,m,0.675长*0.24宽*0.56高*8,0.73,支墩四周刷-防木漆,m,(0.675+0.24)*2周长*0.410以上高度*8个腿,6,坐凳-60*30木条,m,(4.05+2.1-0.15*8)*4,19.8,18,坐凳3

18、,个,2,2,150厚-3:7灰土,m,0.675长*0.64宽*0.15高*3个腿*2,0.39,300厚-C15砼垫层,m,0.675长*0.44宽*0.3高*3个腿*2,0.53,坐凳-零星砌体,m,0.675长*0.24宽*0.56高*3*2,0.54,支墩四周刷-防木漆,m,(0.675+0.24)*2周长*0.410以上高度*3个腿*2,4.5,坐凳-60*30木条,m,(2.1-0.15*3)*4*2,13.2,19,坐凳5,个,4,4,木条根数未设计,150厚-3:7灰土,m,0.675长*0.64宽*0.15高*13个腿*4,3.37,300厚-C15砼垫层,m,0.675长

19、*0.44宽*0.3高*13个腿*4,4.63,坐凳-零星砌体,m,0.675长*0.24宽*0.56高*13*4,4.72,支墩四周刷-防木漆,m,(0.675+0.24)*2周长*0.410以上高度*13个腿*4,39.02,坐凳-60*30木条,m,(3.2+4.6+3-0.15*13)*4*4,141.6,20,挡土墙1-1,个,1,1,150厚-3:7灰土,m,4长*0.65宽*0.15高,0.39,100厚-C15砼垫层,m,4*0.45*0.1,0.18,MU10砖-240基础,m,4*(0.6-0.25)*0.24,0.34,MU10-240砖墙,m,4*(0.5+1.5)/2

20、平均高度-0.06)*0.24,0.9,60厚-C15压顶,m,4*0.24*0.06,0.06,2A6-钢筋,kg,4*0.26*2,2.08,A6200-钢筋,kg,0.24*(4/0.2)*0.26,1.25,10厚-青片石贴面 立面,m,4*1平均高度*2面,8,10厚-青片石贴面 立面,m,4*0.24,0.96,21,挡土墙1-2,个,1,1,150厚-3:7灰土,m,3长*0.65宽*0.15高,0.29,100厚-C15砼垫层,m,3*0.45*0.1,0.14,MU10砖-240基础,m,3*(0.6-0.25)*0.24,0.25,MU10-240砖墙,m,3*(0.5+1

21、.5)/2平均高度-0.06)*0.24,0.68,60厚-C15压顶,m,3*0.24*0.06,0.04,2A6-钢筋,kg,4*0.26*2,2.08,A6200-钢筋,kg,0.24*(3/0.2)*0.26,0.94,10厚-青片石贴面 立面,m,3*1平均高度*2面,6,10厚-青片石贴面 立面,m,3*0.24,0.72,22,挡土墙2,个,1,1,尺寸不祥,MU10-240砖墙,m,314*0.8*0.24,60.29,10厚-青片石贴面 立面,m,314*0.8,251.2,10厚-青片石贴面 立面,m,314*0.24,75.36,23,挡土墙3,个,1,1,150厚-3:

22、7灰土,m,11.2长*0.65宽*0.15高,1.09,100厚-C15砼垫层,m,11.2*0.45*0.1,0.5,MU10砖-240基础,m,11.2*(0.6-0.25)*0.24,0.94,MU10-240砖墙,m,11.2*(1-0.06)*0.24,2.53,60厚-C15压顶,m,11.2*0.24*0.06,0.16,2A6-钢筋,kg,11.2*0.26*2,5.82,A6200-钢筋,kg,0.24*(11.2/0.2)*0.26,3.49,10厚-青片石贴面 立面,m,11.2*(1+0.06),11.87,10厚-青片石贴面 立面,m,11.2*0.24,2.69,

23、24,花架1,个,1,1,400厚-C10砼垫层,m,3.6*3.6*0.4*2,10.37,10.37,C20-独立基础有梁式,m,(2.8*2.8*0.6+(2.82+1.42+3.13)*0.4/3)*2,12.86,12.86,C20-矩形柱1400*1400,m,1.4*1.4*2.4*2,9.41,9.41,C20-矩形柱600*600,m,0.6*0.6*2.075*2,1.49,1.49,C20-矩型梁500*250,m,0.5*0.25*11*2,2.75,2.75,花架-木格条80*200,m,4.4*26,114.4,114.4,用膨胀螺栓固定,面刷清漆,8C14-钢筋,

24、kg,(12*0.014+0.6+0.4+2.4+2.075+12*0.014)*1.208*8*2,112.32,112.32,A6120-钢筋,kg,2.4箍长*0.26*11根*2,13.73,13.73,A6100-钢筋,kg,5.6箍长*0.26*(3.4/0.1)根数*2,99.01,99.01,5A10-钢筋,kg,2.8*0.617*5*2,17.28,17.28,A10130-钢筋,kg,2.8*0.617*(2.8/0.13)*2,74.42,74.42,4A8-钢筋,kg,11*0.395*4*2,34.76,34.76,A6200-钢筋,kg,1.5*0.26*(11/

25、0.1)*2,85.8,25,景墙1(1-3断面),个,3,3,见图纸13-1,竹编-景墙80竹子,m,(5+5.35+6.2)*1,16.55,16.55,80竹子纵横编制,水平3道长度16.55*3米,竖向每间距540设置一道,长度每根1米,隔1道绑2根,用5#镀锌铁丝固定26,景墙2,个,1,1,见图纸13-2,150厚-3:7灰土,m,0.64*0.15*(8.3+4),1.18,100厚-C15砼垫层,m,0.44*0.1*12.3,0.54,MU10砖-240基础,m,0.24*(0.6-0.25)*12.3,1.03,MU10-240砖墙,m,0.24*0.94*12.3,2.7

26、7,60厚-C15压顶,m,0.24*0.06*12.3,0.18,2A6-钢筋,kg,12.3*0.26*2,6.4,A6200-钢筋,kg,0.24*(12.3/0.2)*0.26,3.84,10厚-芝麻黑花岗岩贴面 立面,m,12.3*1*2面,24.6,51.6,10厚-芝麻黑花岗岩贴面 平面,m,12.3*0.24,2.95,6.19,27,景墙3,个,1,1,见图纸13-2,150厚-3:7灰土,m,0.64*0.15*(9.5+4),1.3,100厚-C15砼垫层,m,0.44*0.1*13.5,0.59,MU10砖-240基础,m,0.24*(0.6-0.25)*13.5,1.

27、13,MU10-240砖墙,m,0.24*0.94*13.5,3.05,60厚-C15压顶,m,0.24*0.06*13.5,0.19,2A6-钢筋,kg,13.5*0.26*2,7.02,A6200-钢筋,kg,0.24*(13.5/0.2)*0.26,4.21,10厚-芝麻黑花岗岩贴面 立面,m,13.5*1*2面,27,10厚-芝麻黑花岗岩贴面 平面,m,13.5*0.24,3.24,28,大池,个,1,1,见图纸11-3,400厚-级配砂石,m,135.33CAD面积*0.4*1.3折加系数,70.37,108.75,100厚-C15砼垫层,m,135.33CAD面积*0.1*1.3折

28、加系数,17.59,150厚-C20钢筋砼池壁,m,135.33*0.15*1.3,26.39,42.51,蓝色-马赛克面层,m,135.33*1.3,175.93,175.93,20厚1:2水砂找平、10厚1:1水砂结合层,镀锌-铁箅子,m,1*1,1,3,A8200-钢筋,kg,17*0.395*(9/0.2)*2层*1.3系数,785.66,2533.98,A8200-钢筋,kg,9*0.395*(17/0.2)*2层*1.3系数,785.66,29,小池,个,1,1,见图纸11-3,400厚-级配砂石,m,76.75CAD面积*0.4*1.25折加系数,38.38,100厚-C15砼垫层,m,76.75CAD面积*0.1*1.25折加系数,9.59,150厚-C20钢筋砼池壁,m,76.75*0.15*1.4,16.12,天蓝色磨光-花岗岩面层150*150*20,m,76.75*1.4,107.45,107.45,20厚1:2水砂找平、10厚1:1水砂结合层,镀锌-铁箅子,m,1*1*2,2,A8200-钢筋,kg,12.8*0.395*(6.8/0.2)*2层*1.4系数,481.33,A8200-钢筋,kg,6.8*0.395*(12.8/0.2)*