当前位置:文档之家› EXCEL工程量计算表1

EXCEL工程量计算表1


19
坐凳5

m³ m³ m³ m² m
4
0.675[长]*0.64[宽]*0.15[高]*13[个腿]*4 0.675[长]*0.44[宽]*0.3[高]*13[个腿]*4 0.675[长]*0.24[宽]*0.56[高]*13*4 (0.675+0.24)*2[周长]*0.41[±0以上高度]*13[个腿]*4 (3.2+4.6+3-0.15*13)*4*4 1 4[长]*0.65[宽]*0.15[高] 4*0.45*0.1 4*(0.6-0.25)*0.24 4*((0.5+1.5)/2[平均高度]-0.06)*0.24 4*0.24*0.06 4*0.26*2 0.24*(4/0.2)*0.26 4*1[平均高度]*2[面] 4*0.24 1 3[长]*0.65[宽]*0.15[高] 3*0.45*0.1 3*(0.6-0.25)*0.24
项目名称
做法
单位
m (4.05+2.1-0.15*8)*4
工程量计算式
结果 #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? #NAME?
做法汇总
备注
15
树池14
个 m³ m³ m³ m³ m³ kg kg m² m²
16
坐凳1

m³ m³ m³ m² m
1
0.675[长]*0.64[宽]*0.15[高]*3[个腿] 0.675[长]*0.44[宽]*0.3[高]*3[个腿] 0.675[长]*0.24[宽]*0.56[高]*3 (0.675+0.24)*2[周长]*0.41[±0以上高度]*3[个腿] (2.1-0.15*3)*4
做法见图纸15-2
17
坐凳2

m³ m³ m³ m²
1
0.675[长]*0.64[宽]*0.15[高]*8[个腿] 0.675[长]*0.44[宽]*0.3[高]*8[个腿] 0.675[长]*0.24[宽]*0.56[高]*8 (0.675+0.24)*2[周长]*0.41[±0以上高度]*8[个腿]
做法汇总
备注
尺寸未设计
12
树池11
个 m³ m³ m³ m³ m³ kg kg m² m²
0.64[宽]*0.15[厚]*(10.73*2+2.562*2)[长]*4 0.44[宽]*0.1[厚]*26.584[长]*4 0.12[宽实际为240]*(0.6-0.15-0.1)[高]*26.584[长]*4 0.12[宽实际为240]*(0.45-0.06)*26.584[同上]*4 0.12*0.06*26.584*4 (27.06)*2[根]*0.26*4 0.12*(27.06)/0.2[根数]*0.26*4 27.06*(0.45+0.06)[高]*4 26.584*0.12[宽]*4 2 0.64[宽]*0.15[厚]*(1.56*2+1.76*2)[长]*2 0.44[宽]*0.1[厚]*6.64[长]*2 0.24[宽]*(0.6-0.15-0.1)[高]*6.64[长]*2 0.24*(0.45-0.06)*6.64[同上]*2 0.24*0.06*6.64*2 (7.6)*2[根]*0.26*2 0.3*(7.6)/0.2[根数]*0.26*2 7.6*(0.45+0.06)[高]*2 6.64*0.24[宽]*2 2 5*6*10 0.44[宽]*0.1[厚]*9.44[长]*2 0.24[宽]*(0.6-0.15-0.1)[高]*9.44[长]*2
做法汇总
备注
5
树池5
个 m³ m³ m³ m³ m³ kg kg m² m²
6
树池6
个 m³ m³ m³ m³ m³ kg kg m²
项目名称
做法
单位
m² 14.44*0.24[宽] 3 1.65[长]*4[面]*3[个] 19.8*0.15[宽] 3
工程量计算式
结果 #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? #NAME?
9
树池9-1
个 m³ m³ m³ m³ m³ kg kg m² m²
10
树池9-2
个 m³ m³ m³ m³ m³ kg kg m² m²
项目名称 114 2*3.14*1.45[直径]*14 127.48*0.1[宽] 4
工程量计算式
结果 #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? #NAME?
做法汇总
备注
18
坐凳3

m³ m³ m³ m² m
2
0.675[长]*0.64[宽]*0.15[高]*3[个腿]*2 0.675[长]*0.44[宽]*0.3[高]*3[个腿]*2 0.675[长]*0.24[宽]*0.56[高]*3*2 (0.675+0.24)*2[周长]*0.41[±0以上高度]*3[个腿]*2 (2.1-0.15*3)*4*2
做法汇总
备注
7
树池7
个 m m²
8
树池8
个 m m²
(3.55*2[长]+1.45*2[宽])*3[个] 30*0.15[宽] 1 0.64[宽]*0.15[厚]*(1.26*2+1.26*2)[长] 0.44[宽]*0.1[厚]*5.04[长] 0.24[宽]*(0.6-0.15-0.1)[高]*5.04[长] 0.24*(0.45-0.06)*5.04[同上] 0.24*0.06*5.04 (1.5*2+1.5*2)*2[根]*0.26 0.3*(6)/0.2[根数]*0.26 6.0*(1+0.06)[高] 5.04*0.24[宽] 1 0.64[宽]*0.15[厚]*(1.26*2+1.26*2)[长] 0.44[宽]*0.1[厚]*5.04[长] 0.24[宽]*1.26[长]*(0.35*2+0.8*2)[不等高] 0.24[宽]*1.26[长]*(0.94*2+0.49*2)[不等高] 0.24*0.06*5.04 (1.5*2+1.5*2)*2[根]*0.26 0.3*(6)/0.2[根数]*0.26 1.26*(1+0.06)*2+1.26*(0.55+0.06)*2 5.04*0.24[宽]
工 程 量 计 算 书
项目名称 1 树池1 做法 单位
个 m³ m³ m³ m³ m³ kg kg m² m² 2*10*100 0.44[宽]*0.1[厚]*1.26[长]*4[面]*10 0.24[宽]*(0.6-0.15-0.1)[高]*1.26[长]*4*10[个] 0.24*(0.4-0.06)*1.26*4*10[同上] 0.24*0.06*1.26*4*10 1.5*4*2[根]*0.26*10 0.3*(1.5*4)/0.2[根数]*0.26*10 1.5*4*(0.4+0.06)[高]*10 1.26*4*0.24[宽]*10 2*3.14*1.45[直径]*14 0.64[宽]*0.15[厚]*(3-0.24)[长]*4[面]*4 0.44[宽]*0.1[厚]*2.76[长]*4[面]*4 0.24[宽]*(0.6-0.15-0.1)[高]*2.76[长]*4*4[个] 0.24*(0.4-0.06)*2.76*4*4[同上] 0.24*0.06*2.76*4*4 3*4*2[根]*0.26*4 0.3*(3.0*4)/0.2[根数]*0.26*4 3.0*4*(0.4+0.06)[高]*4 2.76*4*0.24[宽]*4 4 16.34+15.29+13.39+10.95[共四个] 55.97[长]*0.1[宽] 1 0.64[宽]*0.15[厚]*(2.85+2.4+1.5-0.24*3)[长] 工程量计算式
2
树池2
个 m³ m³ m³ m³ m³ kg kg m² m²
3
树池3
个 m m²
4
树池4
个 m³
项目名称
做法
单位
m³ m³ m³ m³ kg kg m² m²
工程量计算式 0.44[宽]*0.1[厚]*6.03[长] 0.24[宽]*(0.6-0.15-0.1)[高]*6.03[长] 0.24*(1-0.06)*6.03[同上] 0.24*0.06*6.03 (2.85+2.4+1.5)*2[根]*0.26 0.3*(6.75)/0.2[根数]*0.26 6.75*(1+0.06)[高] 6.03*0.24[宽] 1 0.64[宽]*0.15[厚]*(1.16*2+1.26*2)[长] 0.44[宽]*0.1[厚]*4.84[长] 0.24[宽]*(0.6-0.15-0.1)[高]*4.84[长] 0.24*(1-0.06)*4.84[同上] 0.24*0.06*4.84 (1.4*2+1.5*2)*2[根]*0.26 0.3*(5.8)/0.2[根数]*0.26 5.8*(1+0.06)[高] 5.8*0.24[宽] 1 0.64[宽]*0.15[厚]*(5.96*2+1.26*2)[长] 0.44[宽]*0.1[厚]*14.44[长] 0.24[宽]*(0.6-0.15-0.1)[高]*14.44[长] 0.24*(1-0.06)*14.44[同上] 0.24*0.06*14.44 (6.2*2+1.5*2)*2[根]*0.26 0.3*(15.4)/0.2[根数]*0.26 15.4*(1+0.06)[高]
相关主题