EXCEL工程量計(jì)算表

1、,項(xiàng)目名稱,做法,單位,工程量計(jì)算式,結(jié)果,做法匯總,備注1,樹池1,個(gè),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基礎(chǔ),m,0.24寬*(0.6-0.15-0.1)高*1.26長*4*10個(gè),4.23,24.12,砂漿標(biāo)號(hào)未定,MU10-240磚墻,m,0.24*(0.4-0.06)*1.26*4*10同上,4.11,95.25,砂漿標(biāo)號(hào)未定,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根數(shù)*0.26*10,23.4,198.46,10厚-青片石貼面 立面,m,1.5*4*(0.4+0.06)高*10,27.6,533.7,做法中無找平厚度及標(biāo)號(hào),10厚-青片石貼面 平面,m,1.26*4*0.24寬*10,12.1,57.79,做法中無找平厚度及標(biāo)號(hào)2,樹池2,個(gè),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基礎(chǔ),m,0.24寬*(0.6-0.15-0.1)高*2.76長*4*4個(gè),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根數(shù)*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,個(gè),

4、4,4,100寬*300高*495長-砼條石,m,16.34+15.29+13.39+10.95共四個(gè),55.97,55.97,30厚-1:3水泥砂漿,m,55.97長*0.1寬,5.6,25.82,4,樹池4,個(gè),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基礎(chǔ),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根數(shù)*0.26,2.63,10厚-青片石貼面 立面,m,6.75*(1+0.06)高,7.16,10厚-青片石貼面 平面,m,6.03*0.24寬,1.45,5,樹池5,個(gè),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基礎(chǔ),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根數(shù)*0.26,2.26,10厚-青片石貼面 立面,m,5.8*(1+0.06)高,6.15,10厚-青片石貼面 平面,m,5.8*0.24寬,1.39,6,樹池6,個(gè),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基礎(chǔ),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根數(shù)*0.26,6.01,10厚-青片石貼面 立面,m,15.4*(1+0.06)高,16.32,10厚-青片石貼面 平面,m,14.44*0.24寬,3.47,7,樹池7,個(gè),3,3,150寬*300高*495

8、長-砼條石,m,1.65長*4面*3個(gè),19.8,49.8,30厚-1:3水泥砂漿,m,19.8*0.15寬,2.97,8,樹池8,個(gè),3,3,150寬*300高*495長-砼條石,m,(3.55*2長+1.45*2寬)*3個(gè),30,30厚-1:3水泥砂漿,m,30*0.15寬,4.5,9, 樹池9-1,個(gè),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基礎(chǔ),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根數(shù)*0.26,2.34,10厚-青片石貼面 立面,m,6.0*(1+0.06)高,6.36,10厚-青片石貼面 平面,m,5.04*0.24寬,1.21,10, 樹池9-2,個(gè),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基礎(chǔ),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根數(shù)*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,個(gè),1

11、4,14,100寬*300高*495長-砼條石(圓型),m,2*3.14*1.45直徑*14,127.48,127.48,尺寸未設(shè)計(jì),30厚-1:3水泥砂漿,m,127.48*0.1寬,12.75,12, 樹池11,個(gè),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基礎(chǔ),m,0.12寬實(shí)際為240*(0.6-0.15-0.1)高*26.584長*4,4.47,MU10-240磚墻,m,0.12寬實(shí)際為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根數(shù)*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,個(gè),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基礎(chǔ),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根數(shù)*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,個(gè),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基礎(chǔ),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根數(shù)*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,個(gè),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基礎(chǔ),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根數(shù)*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,個(gè),1,1,做法見圖紙15-2,150厚-3:7灰土,m,0.675長*0.64寬*0.15高*3個(gè)腿,0.19,300厚-C15砼墊層,m,0.675長*0.44寬*0.3高*3個(gè)腿,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個(gè)腿,2.25,51.77,坐凳-60*30木條,m,(2.1-0.15*3)*4,6.6,181.2,17,坐凳2,個(gè),1,1,150厚-3:7灰土,m,0.675長*0.64寬*0.15高*8個(gè)腿,0.52,300厚-C15砼墊層,m,0.675長*0.44寬*0.3高*8個(gè)腿,0.71,坐凳-零星砌體,m,0.675長*0.24寬*0.56高*8,0.73,支墩四周刷-防木漆,m,(0.675+0.24)*2周長*0.410以上高度*8個(gè)腿,6,坐凳-60*30木條,m,(4.05+2.1-0.15*8)*4,19.8,18,坐凳3

18、,個(gè),2,2,150厚-3:7灰土,m,0.675長*0.64寬*0.15高*3個(gè)腿*2,0.39,300厚-C15砼墊層,m,0.675長*0.44寬*0.3高*3個(gè)腿*2,0.53,坐凳-零星砌體,m,0.675長*0.24寬*0.56高*3*2,0.54,支墩四周刷-防木漆,m,(0.675+0.24)*2周長*0.410以上高度*3個(gè)腿*2,4.5,坐凳-60*30木條,m,(2.1-0.15*3)*4*2,13.2,19,坐凳5,個(gè),4,4,木條根數(shù)未設(shè)計(jì),150厚-3:7灰土,m,0.675長*0.64寬*0.15高*13個(gè)腿*4,3.37,300厚-C15砼墊層,m,0.675長

19、*0.44寬*0.3高*13個(gè)腿*4,4.63,坐凳-零星砌體,m,0.675長*0.24寬*0.56高*13*4,4.72,支墩四周刷-防木漆,m,(0.675+0.24)*2周長*0.410以上高度*13個(gè)腿*4,39.02,坐凳-60*30木條,m,(3.2+4.6+3-0.15*13)*4*4,141.6,20,擋土墻1-1,個(gè),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基礎(chǔ),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,個(gè),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基礎(chǔ),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,個(gè),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,個(gè),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基礎(chǔ),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,個(gè),1,1,400厚-C10砼墊層,m,3.6*3.6*0.4*2,10.37,10.37,C20-獨(dú)立基礎(chǔ)有梁式,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)根數(shù)*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斷面),個(gè),3,3,見圖紙13-1,竹編-景墻80竹子,m,(5+5.35+6.2)*1,16.55,16.55,80竹子縱橫編制,水平3道長度16.55*3米,豎向每間距540設(shè)置一道,長度每根1米,隔1道綁2根,用5#鍍鋅鐵絲固定26,景墻2,個(gè),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基礎(chǔ),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,個(gè),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基礎(chǔ),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,大池,個(gè),1,1,見圖紙11-3,400厚-級(jí)配砂石,m,135.33CAD面積*0.4*1.3折加系數(shù),70.37,108.75,100厚-C15砼墊層,m,135.33CAD面積*0.1*1.3折

28、加系數(shù),17.59,150厚-C20鋼筋砼池壁,m,135.33*0.15*1.3,26.39,42.51,藍(lán)色-馬賽克面層,m,135.33*1.3,175.93,175.93,20厚1:2水砂找平、10厚1:1水砂結(jié)合層,鍍鋅-鐵箅子,m,1*1,1,3,A8200-鋼筋,kg,17*0.395*(9/0.2)*2層*1.3系數(shù),785.66,2533.98,A8200-鋼筋,kg,9*0.395*(17/0.2)*2層*1.3系數(shù),785.66,29,小池,個(gè),1,1,見圖紙11-3,400厚-級(jí)配砂石,m,76.75CAD面積*0.4*1.25折加系數(shù),38.38,100厚-C15砼墊層,m,76.75CAD面積*0.1*1.25折加系數(shù),9.59,150厚-C20鋼筋砼池壁,m,76.75*0.15*1.4,16.12,天藍(lán)色磨光-花崗巖面層150*150*20,m,76.75*1.4,107.45,107.45,20厚1:2水砂找平、10厚1:1水砂結(jié)合層,鍍鋅-鐵箅子,m,1*1*2,2,A8200-鋼筋,kg,12.8*0.395*(6.8/0.2)*2層*1.4系數(shù),481.33,A8200-鋼筋,kg,6.8*0.395*(12.8/0.2)*