利用Ecel函数计算土建工程量

工程量清

序号名称位工程量注

2

建筑面m16251.85

2

地平整m955.89

1机械挖基坑土方nr1421.60

2人工挖基坑土方合：nr157.96

3人工夯填土方合：nr532.90

4余土外运nr1046.66

5C30微膨芯混凝土nr25.41

6C15混凝土基nr107.68

2

7模板m115.86

8C30s6承台混凝土m3494.43

9C30s6地梁混凝土nr9.10

10C30s6底板混凝上nr195.13

11C30s6集水坑混凝土nr7.56

12承台240厚模面nr198.83828.444

13梯基坑240厚模面nr41.50172.912

2

14基坑及底板外木模面m116.48

2

15模面粉刷m1001.36

2

16底板2.0厚水泥基防水涂料m1651.17

2

174()厚石混凝土保m658.77

18梁2.0厚水泥砂保m2992.40

19C35直形40以内nr238.72

20C35直形20以内nr224.55

21C30直形20以内nr1269.36

22C25直形20以内HP1490.89

23C35梯井直形40cm厚以内nr36.25

24C35梯井直形20cm厚以内nr29.04

25C30梯井直形20cm厚以内m5174.24

26C25梯井直形20cm厚以内nr214.04

第1，共196

工程量清

序号名称位工程量注

2

27直形剪力模板m31148.39

2

28梯井直形模板m4363.20

2

29直形剪力模板超高m274.97

301.8内柱C35m314.93

311.8内柱C30rrr38.88

321.8内柱C25nr50.54

331.8内柱C20nr13.17

2

341.8以内矩形柱模板m1327.25

2

35矩形柱模板超高m6.07

独立柱抹灰m21131.35

36构造柱C20nr96.06

37树造柱模板m21179.68

381梁C30（板厚20以内）nr42.10

2'3梁C30（板厚10以内）44.38

394〜28梁C25（板厚10以内）nr506.86

屋面梁C25（板厚15以内）24.11抗渗S6

2

40梁模板面m7767.70

41梁C25混凝土nr17.15

2

42梁模板m219.88

43圈梁C25混凝土nr24.47

2

44圈梁模板m371.95

45模板超高（按）nr42.10

46窗梁C25nr41.46

2

47窗梁模板m690.89

48窗梁筋Kg3670.10010

49窗梁筋Kg1306.8606.5

50圈梁C25:3.04

51圈梁模板：27.55

第2，共196

工程量清

序号名称位工程量注

52C25:20.65

53模板206.52

女儿构造柱筋360.22012

女儿构造柱筋135.5906.5

女儿筋210.34010

女儿筋235.8506.5

窗包框C2549.58

窗包框模板933.96

窗包框筋6102.67012

窗包框筋1396.6206.5

54砌台：2.20

55台水泥砂粘地2.20

56散水原土人工夯103.44

57散水模板8.62

58散水150厚卵石灌M2.5砂15.52

59散水50厚C20石5.17

60散水5厚1:1水泥砂面103.44

散水坡油膏灌172.40

54有梁板C30混凝土（板厚20以内）m376.56

55有梁板C30混凝土（板厚10以内）nr59.67

有梁板C30混凝上（板厚15以内）m?37.77

有梁板C25混凝土（板厚10以内）nr744.98

有梁板C25混凝土（板厚15以内）nr389.51

有梁板C25s6混凝土（板厚15以内）nr55.08

有梁板C25s6混凝上（板厚10以内）nr15.33

2

56有梁板模板m12190.69

第3，共196

工程量清

序号名称位工程量注

57板模板超高m388.12

59挑'阳台板C30混凝土m'33.68

60挑'阳台板C25混凝土nr327.42

2

61挑'阳台板模板m4179.86

62挑'阳台板C25s6混凝土nr59.13

63挑檐天沟C25混凝土nr0.50

64挑檐天沟C25s6混凝土nr9.78

2

65挑檐天沟模板m104.17

66小型构件C30混凝土nr0.84

67小型构件C25混凝土m324.38

68小型构件C25s6混凝土nr0.49

2

69小型构件模板m308.40

70直形楼梯C25混凝土m'168.58

2

71直形楼梯模板m650.69

72楼梯靠扶手m1217.30

73陶粒混凝上附100厚m?332.26已扣减厨反上地梁

74陶粒混凝土砌20()厚nr1456.93

75陶粒混凝土砌300厚nr84.76

76彻女儿nr44.50

大堂及口平台基nr26.35

2

大堂及口平台基抹灰m52.70

2

77fit/］面内抹灰m20491.36度数据

2

78混凝土剪力内抹灰m24432.48度数据

2

79混凝土梁内抹灰m5416.59度数据

2

80天棚刮子mErr:511

2

81内面刮耐水子mErr:511含厨

2

82女儿面抹灰m453.95

第4，共196

工程量清

序号名称位工程量注

2

838-10厚地m405.60屋面

2

8425厚干硬性水泥砂m440.80

40厚C25UEA面光（筋网2

85）m440.80

2

860.15厚聚乙薄膜一m440.80

8725厚聚某板保温隔nr3.40

8830厚聚某板保温隔nr13.22

2

89无布m136.13

1.5厚聚合物水泥基防水涂料（2

90麻生平面）m1807.56

1.5厚聚合物水泥基防水涂料（2

91扃立面）m1444.24

2

屋面SBS防水（屋面）m556.70

2

屋面SBS防水+彩砂（屋面'）m159.85

2

9220厚1:2.5水泥砂保m1807.56

2

9320厚1:2.5水泥砂拉平m1807.56

最薄2（）厚1:8水泥珍珠岩2%技坡

94nr37.50

2

95楼地面找平（理）mErr:511

2

98柱与交接网（宿）m1045.51内面

2

99外网合m0.00

2

100200耐喊网布（M）m1045.51内面

101体拉筋合Kg5820.7906.5

2

102水泥砂楼地面mErr:511井道'外空板

103厨房排烟道Err:511

2

104水泥子两遍面mErr:511厨

2

105水泥子两遍天棚mErr:5Il厨

2

106楼梯面水泥漆mErr:511楼梯

2

107楼梯天棚水泥漆mErr:511楼梯

2

108梯前室天棚水泥漆mErr:511梯前室

2

109石膏角mErr:5U

2

110骨挨特平板吊mErr:511市政梯前室

2

111面500X500玻化mErr:511

第5，共196

工程量清

序号名称位工程量注

2

112金花米黄□花岩面mErr:511

113金花米黄□花岩套m2Err:511

2

114□花岩地面mErr:511

2

115源石花岩地面664#mErr:511

2

116防滑缸300X300mErr:511

117踢脚面m2Err:511

2

118防滑缸600X600mErr:511屋面

119漏空卷帘Err:511

120FM甲防火Err:511

121FM乙防火Err:511

122FM丙防火Err:511

123入防盗防火Err:511

124高窗Err:511

125合金平Err:511

126合金推拉Err:511

127合金平窗合Err:511

128合金百叶窗Err:511

大堂Err:511

129外涂料合0.00

130外面合0.00

131-造型石合Err:511

132窗涂料Err:511

133外水泥砂抹灰0.00

134400mm高不窗m415.20

135600mm高不窗m526.40

136750mm高不窗m33.00

137900mm高不窗m6.60

138不杆（无障碍坡道）m8.96

139llOOmm高阳台玻璃板m874.80

140450mm空不杆m537.60嵋加客空板

141

142

143

第6，共196

工程量清

序号名称位工程量注

144

145

146

147

148

149

第7，共196

建筑面16251.85m2

混凝土量7806.90m3

混凝土平方含量0.48mVm

2

模板量64044.21m

1模板平方含量3.94m/m

2砌体量1873.96m,

1砌体平方含量0.12mVm

I

1

2

1

1

1

1

1

1

1

第8，共196

2

2

1

1

2

1

2

1

1

2

1

2

I

2

19239.04

第9，共196

1

1

1

1

1

1

1

2

第10,共196

1

1

2

1

1

1

2

1

1

I

2

2

第11，共196

第12,共196

第13,共196

第14,共196

13#楼基坑挖

放

序基承台度基外原地面高底板以下下高度坡

系

数放坡

号.名称数量高程K=b/h基坑土方

(m)a度(m)b程挖土高度(m)h度b

11'21/C-G25.161.6633.533.61.91.80.330.5940.3342.29

22'20'22'40/F-J42.5251.6633.533.61.91.80.330.5940.3341.82

33'19、23'39/C-D40.21.6633.533.61.91.80.330.5940.334.09

44'18'24'38/F-K43.4251.6633.533.61.91.80.330.594().3356.43

55、17'25'37/B-D40.91.6633.533.61.91.80.330.5940.3315.45

66'16'26'36/D-K47.61.6633.533.61.91.80.330.5940.33124.19

77'15'27'35/A-B41.71.6633.533.61.91.80.330.594().3328.44

89'13'29'33/A-F45.91.6633.533.61.91.8().330.5940.3396.60

911'31/A-1/C22.851.6633.533.61.91.80.330.5940.3323.55

1041/C-G17.11.6633.533.63.953.850.331.2710.3382.18

11A/7-15'27-35211.51.6633.533.61.91.80.330.5940.3393.74

12B/5-9'13-17'25-29'33-3745.4251.6633.533.61.91.80.330.5940.3388.89

13C/1-314.31.6633.533.61.91.80.330.594().3317.66

14C/39-4213.31.6633.533.61.91.80.330.5940.3313.60

15C/19-2317.71.6633.533.61.91.80.330.5940.3331.45

161/C/9-13'29-3328.7951.6633.533.61.91.80.330.594().3371.79

17D/3-6'16-19'23-26'36-3945.0751.6633.533.61.91.8().330.5940.3383.21

18F/2-6'16-20、22-26'36-4045.5751.6633.533.61.91.80.330.5940.3391.32

191/F/6-10'12-16'26-30、32-3643.1751.6633.533.61.91.80.330.5940.3352.37

20G/1-211.81.6633.533.61.91.80.330.5940.337.51

21G/20-2212.71.6633.533.61.91.80.330.5940.3311.17

22G/40-4110.81.6633.533.61.91.80.330.594().333.46

23J/2-4'18-20'22-24'38-4043.11.6633.533.61.91.80.330.5940.3351.16

24K/4-6'16-18'24-26'36-3843.41.6633.533.61.91.80.330.5940.3356.02

25DL1(8'28)22.90.9633.533.60.60.5().330.1650.333.27

26DLl(J/20-22)12.70.9633.533.60.60.5().330.1650.331.52

27DL2(E/6-9'26-29)22.740.9633.533.60.70.60.330.1980.333.82

28DL2(H/6-10'26-30)23.1750.9633.533.60.70.60.330.1980.334.43

29DL2(E/9-13'29-33)26.070.9633.533.60.70.60.330.1980.338.45

30DL2(3'19'23'39/D-F)43.1750.9633.53360.70.60.330.1980.338.86

31DL2(12'32/1/C-E)21.7750.9633.533.60.70.6().330.1980.332.48

32口12(人外/9-13)16.20.9633.533.60.70.60.330.1980.334.32

33DL3(9-13'29-33)46.070.9633.533.60.80.70.330.2310.3320.29

34XL1'XL220.80.9633.533.60.70.60.330.1980.331.13

35地梁23.3750.9633.533.60.70.60.33().19S0.334.71

36地梁23.40.9633.533.60.70.60.330.19S0.334.74

37地梁11.50.9633.533.60.70.60.330.198().331.05

38梯基坑底板27.484.7333.533.63.73.60.331.188().33322.11

39土方挖量：1579.56

土方挖及回埴

序

号_名称位数量

1机械挖基坑土方m31421.60

2人工挖基坑土方合：m3157.96

3扣C15混凝土基m3107.67553

4扣C30s6承台混凝土m3494.428

5扣C30s6地梁混凝土m39.0999

6扣C30s6底板混凝上m3195.13

7扣承台180厚模面m3198.82656

8扣梯基坑24()厚模面m341.49888

9人工夯填土方合：m3532.90

余土外运1046.66

注

第19,共】96

基承台工程量

序

高度承台模面模板模度模高模面

号名称数量度(m)度(m)C30(n?)C15

(m)(m2)(m)(m)度(m)旧)(nf)

11'2I/C-G25.1611.515.48028.8965.161.360.153.0962.105

22'20'22'40/F-J42.52511.515.15028.2802.5251.360.153.0302.060

33'19'23、39/C-D40.211.51.2002.2400.21.360.150.2400.163

4'18'24'38/F-K43.42511.520.55038.3603.4251.360.154.1102.795

5'17'25'37/B-D40.911.55.40010.0800.91.36().151.0800.734

6'16'26、36/D-K47.611.545.60085.1207.61.360.159.1206.202

7'15'27'35/A-B41.711.510.20019.0401.71.360.152.0401.387

9'13'29'33/A-F45.911.535.40066.0805.91.360.157.0804.814

11'31/A-l/C22.8511.58.55015.9602.851.360.151.7101.163

41/C-G17.113.5525.20548.9907.11.360.152.1301.448

A/7-15'27-35211.511.534.50056.00011.861.36().156.2164.839

、

B/5-9'13-1725-29'33-45.7424.721

375.42511.532.55049.5605.7851.36().15

C/l-314.311.56.45012.0404.661.360.151.3980.951

C/39-4213.311.54.9509.2403.661.360.151.0980.747

C/19-2317.711.511.55020.1608.061.360.152.1181.644

l/C/9-13'29-3328.79511.526.38540.8529.1551.360.154.5933.735

D/3-6'16-19、23-

45.07511.530.45056.8405.4350.155.9224.435

26、36-391.36

F/2-6'16-20、22-26'36-

4045.57511.533.45056.8405.5751.360.156.0904.549

l/F/6-10'12-16'26-

30'32-3643.17511.519.05035.5603.1751.360.153.2102.591

G/l-211.811.52.7005.0401.81.360.150.5400.367

第20,共】96

承台工程量

承台模面模板模度模高模面C15

名称数量度(m)C30(n?)

(m2)(m)(m)度(m)旧)(nf)

G/20-2212.74.0507.5602.71.360.150.6600.551

G/40-4110.81.2002.2400.81.360.150.2400.163

J/2-4'18-20'22-24'38-43.118.60034.7203.11.360.153.7202.530

40

K/4-6'16-18'24-26'36-43.420,40038.0803.761.360.154.5123.068

38

429.020767.77879.69557.763

DL1(8'28)22.90.3482.3202.90.660.151.7400.574

DL1(.1/20-22)12.70.1621.0802.70.660.150.8100.267

DL2(E/6-9'26-29)22.740.4933.2882.740.660.151.6440.543

DL2(H/6-10'26-30)23.1750.5723.8103.1750.660.151.9050.629

DL2(E/9-13'29-33)26.071.0937.2846.070.660.153.6421.202

DL2(3'19'23'39/D-F)43.1751.1437.6203.1750.660.153.8101.257

DL2(12'32/1/C-E)21.7750.3202.1301.7750.660.151.0650.351

DL2(A外/9-13)16.20.5583.7206.20.660.151.8600.614

DL3(9-13'29-33)46.072.91419.4246.070.660.157.2842.404

XL1'XL220.80.1440.9600.80.660.150.480