造价人必须要会的Excel的技能（配套表格资料）-工程量清单Excel

AverageAVERAGEIF月份地面工程量平均数430.80409.34430.8422.60420.7411.76无440.9419.5使用AVERAGEIF1月2月3月4月5月6月7月8月9月10月11月12月序号开始时间结束日期工期13/19/20186/14/201823序号 开始日期结束日期合同到期提醒13/19/201812/14/201923/1/20189/18/201932/4/20188/28/201944/5/20176/3/201956/1/20179/25/2019项目名称户型每户工程量总量ABCABC2012332332325123244127BV 2.5123233224NHBV 2.5123655643NHBV 2.5123334563项目分类工程量单位单价总价分类混凝土梁11100m336036000混凝土111150m336018000钢筋131120m33607200模板121180m336028800模板（墙）12200m26212400HPB235131200kg56000HRB335131250kg56250HRB400131200kg56000各项工程量汇总外墙C30混凝土C30混凝土梁C30混凝土板工程量单位人材机价差汇总表序号编号名称单位数量市场价定额价价差100010001工日592.634524908010200010002工日947.72214413012010300010003工日3810.53973145135104870007综合工日工日174.58480814582.162.9501010030钢筋t0.49441052606.841498.16601030062kg391.8566297.365.032.33701050063钢丝绳kg18.4343267.767.070.69801090017圆钢kg200.5851584.52.611.89902190001尼龙编织布m2163854.240.7610030001板方材m30.6318250019006001103015185kg52.7546364.54.320.181203015205铁钉kg486.0666094.524.320.213030191m30.10782500145010501403130500砂轮片7.5618034.023.850.171503130585乌钢头kg29.5782554.184.120.061603130695砂布张70.6905050.990.960.0317040049青灰kg228.660.35-0.351804050217砂砾石m30.336187264.377.631904090160石膏粉kg8.391841.190.430.762004090230生石灰粉kg11.8295910.440.280.162105010020松杂原木m30.122383600869.622730.382205030506m33.78417750001025.643974.362313010101kg7.466724229.4712.532413010175kg314.8779642311.1811.822513010410生漆kg14.1123082522.892.112613010493无光调合漆kg13.7291392522.892.112713010540光油kg134.097745196.3212.682813010550灰油kg356.62091712.51.8510.652914010020熟桐油kg1.76632211.6410.261.383014010130坯油kg14.11230813.1514.65-1.5单位人材机价差汇总表序号编号名称单位数量市场价定额价价差3114010140生桐油kg138.13954633.7918.3115.483214230210氧化铁红kg5.0886517.024.652.373314350950松香水kg1.592646.744.122.623414390090液化石油气kg891.7500154.392.891.53514410110白乳胶kg1.52459813.2612.270.993614410820煤胶kg226.6064784.832.742.093714411040kg0.24086211.349.152.193814411110kg451.4952814.97.877.03工程名称：XXX第 1 页 共 2 页一类综合用工二类综合用工三类综合用工镀锌低碳钢丝一般用途圆钢钉原木(落叶松)普通松杂锯材醇酸调合漆(综合)红丹环氧防锈漆工程名称：XXXX第 2 页 共 2 页羧甲基纤维素SBS弹性沥青防水胶39150017麻刀kg58.03081.21-1.214031170020血料kg3.413.240.174131170030白面kg63.3430443.43.210.194231170050银珠kg0.46750481.3344.2737.064331170060砖灰kg2.910.9124434110101焦炭kg1720.9432.631.371.264534110121水m310.437373.883.590.294635030001底座个24.7863688.795.493.34735030005钢管脚手架kg52.962.044835030111扣件个5.115.030.084935030150挡脚板m30.3011541137.931135.082.855035050050尼龙安全网m21205.6893213.662.211.4651450001青白石m32.39027500300045005280010430水泥砂浆m38.17418375.5204.04171.465380010532水泥砂浆m30.78350.6216.99133.615480010535水泥砂浆m30.880349375.5181.2194.35580030130纸筋石灰浆m310.293836488.65149.43339.225680030160石灰砂浆m30.2302284.48104.32180.165780030170石灰砂浆m3100.458462301.7294.91206.815880050720m32.867831172.41127.6744.7459810220m33.4299206.5-206.56099070520自卸汽车台班15.628717565.9554.7411.161782.7417342142.2185233208.0733081141.170815水泥混合砂浆深月白大麻刀灰调差金额Round5926.359477.2238105.410981.38740.09913.0312.72379.111244....