用excel计算工程量(实例)
序号项 目 名 称一垫层
5个DJp01
DJp02
DJp03
2个DJp04
DJp05
DJp06
4个DJp07
DJp08
DJp09
DJp10
2个DJp11
2个DJp12
DJp13
DJp14
DJp15
2个DJp16
二独立基础
5个DJp01
DJp02
DJp03
2个DJp04
DJp05
DJp06
4个DJp07
DJp08
DJp09
DJp10
2个DJp11
2个DJp12
DJp13
DJp14
DJp15
2个DJp16
三标高3.550 1柱
KZ1
KZ2
KZ3
KZ4
3个KZ5
KZ6
KZ7
KZ8
KZ9
KZ10
9个KZ11
KZ12
2个KZ13
KZ14
KZ15
KZ16
KZ17
2个KZ18
2个KZ19
KZ20
KZ21
KZ22
KZ23
2个KZ24
KZ25
KZ26
2个KZ27
扣减柱头
扣减梁口
2梁
KL1(8)300*650
2个KL2(8)300*650 KL3(5)300*650
KL4(2)300*650
KL5(1)250*450
KL6(1)250*450
KL7(1)250*500
KL8(3A)300*700
KL9(4A)300*700 KLa（3B)300*700
KL10（3B)300*700 KL11（3B)300*700 KL12（3B)300*700
KL12（4B)300*700
KL13(4A)300*700
KL14(2)250*500
KL15（3B)300*700
L1(8)250*450
L2(8)250*450
L3(5)250*450
3个L4(1)250*450
L5(5)250*450
L6(2)250*450
L7（1B）250*500
29个L8（1）200*300 2个L9（3B）250*500 L10（3B）250*500
L11（1）200*400
L12（3B）250*500
L13（3B）250*500
L14（1）200*400
L15（2A）250*500
L16（3B）250*500
L16（2）250*450
KLA（1A）300*500
扣减梁口
3顶板
加洞口封边
扣减柱头
4雨篷
2个
5门厅造型
KL-a（1）200*400
2个KL-b（1A）200*400
LZ1 250*300
KL-c（1）200*400
KL-？（1）200*400
6半层空调板
四标高7.150
1柱
KZ1
KZ2
KZ3
KZ4
3个KZ5
KZ6
KZ7
KZ8
KZ9
KZ10
9个KZ11
KZ12
2个KZ13
KZ14
KZ15
KZ16
KZ17
2个KZ18
2个KZ19
KZ20
KZ21
KZ22
KZ23
2个KZ24
KZ25
KZ26
扣减梁口
2梁
KL1(8)300*650
KL2(8)300*650
KL3(5)300*650
KL4(5)300*650
KL5(2)300*650
KL6(1)250*450
KL7(1)250*500
KL8(3A)300*700
KL9(4A)300*700
KL10（3B)300*700
KL11（3B)300*700
2个KL12（3B)300*700 KL13(4A)300*700
KL14(2)250*600
KL15（3B)300*700
KL16（3B)300*700
L1(8)250*450
L2(7)250*450
2个L3(1)250*450
L4(4)250*450
L5(1)250*450
L6(5)250*450
L7（3）250*500
24个L8（1）200*300
L9（3B）250*500
L10（3B）250*500
L11（3B）250*500
2个L12（3B）250*500
L13（3B）250*500
L14（2A）250*500
L15（2）250*450
扣减梁口
3顶板
加洞口封边
5-5
扣减柱头
4半层空调板
五标高10.750
1柱
KZ1
KZ2
KZ3
KZ4
3个KZ5
KZ6
KZ7
KZ8
KZ9
KZ10
9个KZ11
KZ12
2个KZ13
KZ14
KZ15
KZ16
KZ17
2个KZ18
2个KZ19
KZ20
KZ21
KZ22
KZ23
2个KZ24
KZ25
KZ26
扣减梁口
2梁
KL1(8)300*650
KL2(8)300*650
KL3(8)300*650
KL4(5)300*650
KL5(2)300*650
KL6(1)250*450
KL7(1)250*500
KL8(3A)300*700
KL9(4A)300*700
KL10（3B)300*700
4个KL11（3B)300*700 KL12(4A)300*700
KL13(2)250*500
KL14（3B)300*700
L1(8)250*450
L2(8)250*450
3个L3(1)250*450
L4(4)250*450
L5(5)250*450
L6（3）250*500
27个L7（1）200*300
L8（3B）250*500
L9（3B）250*500
L10（3B）250*500
2个L11（3B）250*500
L12（3B）250*500
L13（3A）250*500
扣减梁口
3顶板
加洞口封边
5-5
扣减柱头
4半层空调板
六标高14.400
1柱
扣减梁口
2梁
KL1（3A）
KL2（4A）
KL3（3B）
2个KL4（3B）
2个KL5（3B）
KL6（4A）
KL7（1）
KL8（3B）
KL-A（2）300*650
KL10（8)300*650
KL11（8)300*650
KL12(1)250*450
KL15(1)250*500
L1（1）200*300
L2（2A）250*500
5个L3（3）250*500
L-3（2）250*450
L4(8)250*450
LA（3）250*500
L5(1)250*450
L-5(5)250*450
扣减梁口
3顶板
加洞口封边
扣减柱头
七标高15.150
1梁
2个KL-16（1A）300*650
KL-17（1A）300*700
KL-18（1A）300*700
KL-19（1A）300*700
L1（2A）250*500
L-1（2）250*450
5个L-2A（2）250*500
扣减梁口
2顶板
扣减柱头
3水箱支墩
八标高18.200
1柱
扣减梁口
2梁
WKL-1（2）300*650 WKL-2（6）300*1100 WKL-3（8）300*650 WKL-4（8）300*650 WKL-5（8）300*1100 WKL-6（2A）300*700 WKL-7（3A）300*700 WKL-8（1A）300*700 WKL-8（3B）300*700
4个WKL-9（3B）300*700 WKL-10（4A）300*700 WKL-11（3B）300*700
L-4（3B）250*500
L-5（3B）250*500
L-6（3B）250*500
3个L-7（3B）250*500
L-8（3B）250*500
扣减梁口
3顶板
扣减柱头
3-3
2-2
1-1
5-5
4-4
6-6屋脊
7-7屋脊
屋面上人孔
九楼梯
1一号楼梯
TZ基础
第一步基础
TZ1
TZ2
7个TL1（1）250*400
4个TL2（1）200*350
4个TL3（1）250*350
5个TL4（1）200*350
PTB1
斜跑
侧面
踏步
2二号楼梯
第一步基础
6个TL1（1）250*400
3个TL2（1）200*350
3个TL3（1）250*350
3个TL4（1）200*350
PTB1
斜跑
侧面
踏步
十总计
建筑面积（图示）
实际结构面积
4#宿舍楼模板工程量
计 算 式工程量
4.7*4*0.1*5#NAME?
5.2*4*0.1#NAME?（7.6+4.2）*2*0.1#NAME?
3.6*4*0.1*2#NAME?（8.1+7）*2*0.1#NAME?（7.6+5.2）*2*0.1#NAME?（7.3+
4.9）*2*0.1*4#NAME?（7.4+5）*2*0.1#NAME?（6+3.6）*2*0.1#NAME?（7+4.9）*2*0.1#NAME?
4.6*4*0.1*2#NAME?
4.7*4*0.1*2#NAME?（4.9+3.6）*2*0.1#NAME?（4.2+2.9）*2*0.1#NAME?
4.2*4*0.1#NAME?
2.4*4*0.1*2#NAME?
4.5*3.8*0.35*5#NAME? 5*3.8*0.35#NAME?（7.4+4）*2*0.55#NAME?
3.4*4*0.4*2#NAME?（7.9+6.8）*2*0.45#NAME?（7.4+5）*2*0.45#NAME?（7.1+
4.7）*2*0.45*4#NAME?（7.2+4.8）*2*0.45#NAME?（
5.8+3.4）*2*0.4#NAME?（
6.8+4.7）*2*0.65#NAME?
4.4*4*0.35*2#NAME?
4.5*4*0.35*2#NAME?（4.7+3.4）*2*0.4#NAME?（4+2.7）*2*0.5#NAME?
4*4*0.35#NAME?
2.2*4*0.4*2#NAME?
0.6*4*5.2#NAME?
0.6*4*5.2#NAME?
0.65*4*4.65#NAME?
0.6*4*4.75#NAME?
0.6*4*4.75*3#NAME?
0.6*4*4.75#NAME?
0.6*4*4.85#NAME?
0.6*4*5.25#NAME?
0.6*4*5.25#NAME?
0.6*4*4.65#NAME?
0.6*4*4.7*8+0.6*4*5.2#NAME?
0.6*4*5.2#NAME?
0.6*4*4.85*2#NAME?
0.6*4*5.25#NAME?
0.6*4*5.25#NAME?
0.6*4*4.65#NAME?
0.6*4*5.2#NAME?
0.6*4*4.75+0.6*4*5.25#NAME?
0.7*4*5.25*2#NAME?
0.6*4*4.85#NAME?
0.6*4*4.85#NAME?
0.6*4*4.85#NAME?
0.6*4*4.85#NAME?
0.6*4*4.85#NAME?
0.6*4*4.85#NAME?（0.4+0.6）*2*4.85#NAME?（0.4+0.6）*2*4.85*2#NAME? 0-0.6*4*0.1*42#NAME? 0-0.25*0.35*6-0.3*0.4*4-0.3*0.6*40-0.35*0.75*4-
#NAME?
0.35*0.4*4-0.3*0.4*10-0.3*0.55*62-0.25*0.4*3
(0.53+0.55)*（2.85+6.575*2+6.6*4+6.45）#NAME?
0.55*2*（2.85+6.6*6+6.45）*2#NAME?
(0.53+0.55)*(6.6*2+6.55*2+6.5)#NAME?
(0.53+0.55)*(3+6.45)#NAME?
0.35*2*2.85#NAME?
0.35*2*3#NAME?
0.4*2*10.4#NAME?
7.9*1.3+1.8*1.6+6.6*1.3-4.9*0.02+1.1*1.3#NAME?
0.7*1.2+6.6*1.2*2-4.9*0.02*3+1.8*0.8+1.1*1.2#NAME?
1.1*1.2*2+6.6*1.2*2-4.9*0.04+1.8*0.8#NAME?
1.1*1.2*2+6.6*1.2*2-4.9*0.04*2+1.8*0.8#NAME?
1.1*1.2*2+6.6*1.2*2-4.9*0.04*2+1.8*0.8#NAME?
1.1*1.2*2+6.6*1.2*2-4.9*0.04*2+1.8*0.8#NAME?
1.1*0.8+
2.7*0.8+6.6*1.2*2-4.9*0.04*2+1.8*0.8+1.1*1.2#NAME?
0.7*1.2+6.6*1.2*2-4.9*0.04*2+1.8*0.8+1.1*1.2#NAME?
0.7*0.8+6.9*0.8-4.9*0.04#NAME?
1.1*1.3*2+6.6*1.3*2-4.9*0.04+1.8*1.6#NAME?
(3.3+6.9*7-0.25*7)*0.8#NAME?
(3.3+6.9*7-0.25*7)*0.68#NAME?（6.9*5-0.25*5+0.15*2）*0.68#NAME?（3.175+3.325+3.05）*0.68-3.325*0.02#NAME?（6.75*2+6.9*3-0.25*5）*0.8-10.6*0.1#NAME?（3.25+6.65）*0.8#NAME?（1.2*2+10.6）*0.9#NAME?
1.75*0.4*29#NAME?（1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8）*2#NAME?
1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8#NAME?
3.05*0.7#NAME?
1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8#NAME?
1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8#NAME?
3.05*0.7#NAME?
1.4*0.8+6.9*0.8-4.9*0.04+1.8*0.8#NAME?
1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8#NAME?（3.325+6.65）*0.68#NAME?
（1.6+1.1）*0.8#NAME? 0-0.25*0.35*114-0.25*4*4-0.2*0.3*4-0.2*0.2*58-
#NAME?
0.25*0.4*40
19.6*54.3+13.6*3.3-6.55*3.15-6.55*3.2#NAME?（6.55+3.15+6.55+3.2）*2*0.1#NAME? 0-0.6*0.6*42#NAME?
（1.5*3+6*0.3+5.68*0.2）*2#NAME?
（13.6+10.8）/2*1.353+（3.35+1.95）/2*1.353*2#NAME?（0.3+0.188+0.4）*10.4#NAME?（0.3*2+0.2）*3*2#NAME?（0.25+0.3）*2*1.25#NAME?（0.3+0.2+0.4）*2.65#NAME?（0.3+0.2+0.4）*1.95#NAME?可以按二次结构考虑
0.5*4*3.5#NAME?
0.6*4*3.5#NAME?
0.65*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5*3#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.6*4*3.5#NAME?
0.6*4*3.5#NAME?
0.6*4*3.5#NAME?
0.6*4*3.5*9#NAME?
0.6*4*3.5#NAME?
0.6*4*3.5*2#NAME?
0.6*4*3.5#NAME?
0.6*4*3.5#NAME?
0.6*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5*2#NAME?
0.7*4*3.5*2#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5*2#NAME?
0.5*4*3.5#NAME?（0.4+0.5）*2*3.5#NAME? 0-0.25*0.35*7-0.3*0.6*42-0.3*0.55*62-0.35*0.5*4-
#NAME?
0.35*0.4*4-0.3*0.4*10
（2.95+6.575+6.625+6.7*4+6.6）*1.08#NAME?（2.85+6.6*6+6.45）*1.1#NAME?（2.85+6.6*6+6.45）*1.1#NAME?（6.75+6.7+6.6+6.5+6.65）*1.08#NAME?（3.1+6.6）*1.08#NAME?
2.95*0.8#NAME?
3.1*0.8#NAME? 8*1.3+1.8*1.1+6.6*1.3-
4.9*0.02+1.2*1.3#NAME?
0.85*1.3+6.6*1.2*2-4.9*0.02*3+1.8*0.8+1.1*1.2#NAME?
1.2*1.2+6.6*1.2*2-4.9*0.04*2+1.8*0.8+1.05*1.2#NAME?
1.2*1.2*2+6.6*1.2*2-4.9*0.04*2+1.8*0.8#NAME?（1*1.2+6.6*1.2*2-4.9*0.04*2+1.8*0.8+1.2*1.2）*2#NAME?
0.85*1.3+6.6*1.2*2-4.9*0.02*3+1.8*0.8+1.2*1.2#NAME?
6.9*1+0.85*1#NAME?
1.2*1.2*2+6.6*1.2*2-4.9*0.04*2+1.8*0.8#NAME?
1.2*1.3*2+6.6*1.3*2-4.9*0.02*2+1.8*1.1#NAME?（3.3+6.9*7-0.25*7）*0.8#NAME?（3.3+6.9*6-0.25*6）*0.68#NAME?
（3.05+3.15）*0.68#NAME?（6.9*3+7.05-0.25*4）*0.68#NAME?
3.325*0.66#NAME?（6.85*2+6.9*3-0.25*5）*0.8#NAME?（3.25+6.65）*0.8#NAME?
1.75*0.4*24#NAME?
1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8#NAME?
1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8#NAME?
1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8#NAME?（1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8）*2#NAME?
1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8#NAME?
1.4*0.8+6.9*0.8-4.9*0.04+1.8*0.8#NAME?（3.325+6.65）*0.68#NAME? 0-0.25*0.35*84-0.25*0.4*42-0.2*0.2*48#NAME?
19.6*54.3-6.55*3.15-6.55*3.2#NAME?（6.55+3.15+6.55+3.2）*2*0.1#NAME?
3.9*3*0.2*2+（3.15*4+3.05+3.1*17+3*3）*0.15*2#NAME? 0-0.6*0.6*19-0.65*0.65-0.7*0.7*2-0.4*0.5-0.5*0.5*17#NAME?
可以按二次结构考虑
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.65*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5*3#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5*9#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5*2#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5*2#NAME?
0.5*4*3.5*2#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5#NAME?
0.5*4*3.5*2#NAME?
0.5*4*3.5#NAME?（0.4+0.5）*2*3.5#NAME? 0-0.25*0.35*7-0.3*0.6*42-0.3*0.55*62-0.35*0.5*4-
#NAME?
0.35*0.4*4-0.3*0.4*10
（2.95+6.675+6.625+6.7*4+6.6）*1.08#NAME?（2.95+6.7*6+6.6）*1.1#NAME?（2.95+6.7*6+6.6）*1.1#NAME?（6.75*2+6.7*3）*1.08#NAME?（3.1+6.6）*1.08#NAME?
2.95*0.8#NAME?
3.1*0.8#NAME?
8.1*1.3+1.8*1.1+6.7*1.3-4.9*0.02+1.2*1.3#NAME? 1*1.2+6.7*1.2*2-4.9*0.02*3+1.8*0.8+1.2*1.2#NAME?
1.2*1.2+6.7*1.2*2-4.9*0.04*2+1.8*0.8+1.05*1.2#NAME?（1.2*1.2*2+6.7*1.2*2-4.9*0.04*2+1.8*0.8）*4#NAME? 1*1.3+6.7*1.2*2-4.9*0.02*3+1.8*0.8+1.2*1.2#NAME?
6.9*0.8+1*0.8#NAME?
1.2*1.3*2+6.6*1.3*2-4.9*0.02*2+1.8*1.1#NAME?（3.3+6.9*7-0.25*7）*0.8#NAME?（3.3+6.9*7-0.25*7）*0.68#NAME?
（3.05+3.15）*0.68+3.325*0.66#NAME?（6.9*3+7.05-0.25*4）*0.68#NAME?（6.85*2+6.9*3-0.25*5）*0.8#NAME?（3.25+6.65）*0.8#NAME?
1.75*0.4*27#NAME?
1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8#NAME?
1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8#NAME?
1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8#NAME?（1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8）*2#NAME?
1.4*0.8*2+6.9*0.8*2-4.9*0.04*2+1.8*0.8#NAME?
1.4*0.8+6.9*0.8-4.9*0.04+1.8*0.8#NAME? 0-0.25*0.35*84-0.25*0.4*42-0.2*0.2*48#NAME?
19.6*54.3-6.55*3.15-6.55*3.2#NAME?（6.55+3.15+6.55+3.2）*2*0.1#NAME?
3.9*3*0.2*2+（3.15*5+3.05+3.1*15+3*3+3.2）*0.15*2#NAME? 0-0.65*0.65-0.4*0.5-0.5*0.5*38#NAME?
可以按二次结构考虑
H=3.55m
0.5*4*3.55*39+（0.4+0.5）*2*3.55#NAME? 0-0.25*0.35*5-0.3*0.55*38-0.3*0.6*40-0.25*0.4*2#NAME?
8.1*1.3+1.8*1.1+6.7*1.3+1.2*1.3#NAME? 1*1.2+6.7*1.2*2+1.8*0.8+1.2*1.2#NAME?
1.2*1.2*2+6.7*1.2*2+1.8*0.8#NAME?（1.2*1.2*2+6.7*1.2*2+1.8*0.8）*2#NAME?（1.2*1.2*2+6.7*1.2*2+1.8*0.8）*2#NAME? 1*1.2+6.7*1.2*2+1.8*0.8+1.2*1.2#NAME? 1*0.8#NAME?
1.2*1.3*2+6.7*1.3*2+1.8*1.1#NAME?（
2.95+6.75）*1.1#NAME?（2.95+6.7*6+6.6）*1.1#NAME?
（2.95+6.7*6+6.6）*1.1#NAME?
2.95*1.2#NAME?
3.1*0.8#NAME?
1.75*0.4#NAME?
6.9*0.8*2+1.8*0.8+1.4*0.8#NAME?（6.9*2+1.8）*0.8*5#NAME?
10.1*0.8#NAME?（3.3+6.9*7-0.25*7）*0.8#NAME?
6.9*2*0.8+1.8*0.8#NAME?
3.15*0.7#NAME?
34.4*0.8#NAME? 0-0.25*0.35*20-0.25*0.4*42-0.2*0.2*2#NAME?
19.6*54.3-6.55*3.15#NAME?（6.55+3.15）*2*0.1#NAME? 0-0.4*0.5-0.5*0.5*39#NAME?
（2.95+6.75）*1.2*2#NAME?（6.7+1.2）*1.3#NAME?（6.7+1.2）*1.3#NAME?（6.7+1.2）*1.2#NAME?（6.9+1.4-0.25*5）*0.8#NAME?（3.3+6.9）*0.8#NAME?（3.3+6.9）*0.8*5#NAME? 0-0.3*0.55*8-0.3*0.6*6-0.2*0.4*30-0.2*0.35*6#NAME?
8.9*11.1#NAME? 0-0.5*0.5*6#NAME?
（6.2+0.25）*2*0.6*5#NAME?