{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["预结算书","工程项目造价汇总表(含分项)","单项工程造价汇总表(含分项)","分部分项定额计价表","分部分项定额综合单价分析表","人工、材料设备、机械汇总表"],"read":"biff_walk_short","date_system":"1900","formulas":"cached_only"}

{"sheet":"预结算书","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"merged":[[0,0,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,4],[8,0,8,1],[8,2,8,4],[9,1,9,4],[10,0,10,1],[10,2,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,0,14,1],[14,3,14,4]],"flags":["formulas_cached_only"]}
["工程预算书"]
["建设单位：",""]
["工程名称：","宁德职业技术学院风荷花苑6#楼东北角挡土墙修缮项目"]
["工程编号：",""]
["建筑面积：",{"$nulls":3},"平方米"]
["工程造价：",{"v":63246,"d":"63246.00"},null,null,"元"]
["经济指标：",{"$nulls":3},"元/平方米"]
["编 制 人：",""]
["编制人证书编号：",null,""]
["审 核 人：",""]
["审核人证书编号：",null,""]
["编制单位：",""]
["编制日期：","2019年05月14日"]
["",""]
["",null,"",""]

{"sheet":"工程项目造价汇总表(含分项)","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,1,0,4],[1,1,1,4],[2,0,2,4],[3,0,3,3],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,0,8,1],[8,3,8,4]],"flags":["formulas_cached_only"]}
["",""]
["",""]
["工程项目造价汇总表"]
["工程名称:宁德职业技术学院风荷花苑6#楼东北角挡土墙修缮项目",{"$nulls":3},"第1页 共1页"]
["序号","单项工程名称","金额(元)","其中:安全文明施工费(元)"]
["1","单项工程",{"v":63246,"d":"63246.00"},{"v":2179,"d":"2179.00"}]
["1.1","    房屋建筑与装饰工程",{"v":63246,"d":"63246.00"},{"v":2179,"d":"2179.00"}]
["","        一般土建",{"v":63246,"d":"63246.00"},{"v":2179,"d":"2179.00"}]
["合  计",null,{"v":63246,"d":"63246.00"},{"v":2179,"d":"2179.00"}]

{"sheet":"单项工程造价汇总表(含分项)","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"分部分项定额计价表","index":3,"n_rows":34,"n_cols":10,"rows_kept":34,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,6],[2,7,2,8],[3,0,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,3,8],[4,6,4,7],[5,0,5,1],[5,6,5,7],[6,0,6,1],[6,6,6,7],[7,0,7,1],[7,6,7,7],[8,0,8,1],[8,6,8,7],[9,0,9,1],[9,6,9,7],[10,0,10,1],[10,6,10,7],[11,0,11,1],[11,6,11,7],[12,0,12,1],[12,6,12,7],[13,0,13,1],[13,6,13,7],[14,0,14,1],[14,6,14,7],[15,0,15,1],[15,6,15,7],[16,0,16,1],[16,6,16,7],[17,0,17,1],[17,6,17,7],[18,0,18,1],[18,6,18,7],[19,0,19,1],[19,6,19,7],[20,0,20,1],[20,6,20,7],[21,0,21,1],[21,6,21,7],[22,0,22,1],[22,6,22,7],[23,0,23,1],[23,6,23,7],[24,0,24,1],[24,6,24,7],[25,0,25,1],[25,6,25,7],[26,0,26,1],[26,6,26,7],[27,0,27,1],[27,6,27,7],[28,0,28,1],[28,6,28,7],[29,0,29,1],[29,6,29,7],[30,0,30,1],[30,6,30,7],[31,0,31,1],[31,6,31,7],[32,0,32,1],[32,6,32,7],[33,0,33,7]],"flags":["formulas_cached_only"]}
["分部分项定额计价表",{"$nulls":8},""]
["",{"$nulls":8},""]
["工程名称：宁德职业技术学院风荷花苑6#楼东北角挡土墙修缮项目 一般土建",{"$nulls":6},"第1页 共1页",null,""]
["序号",null,"项目编码","项目名称","计量单位","工程量","金    额(元)",null,null,""]
[{"$nulls":6},"综合单价",null,"合价",""]
["1",null,"10116005","拆除砖（石）砌体(拆除整毛石 干砌)","m3",{"v":52.39,"d":"52.390"},187.03,null,{"v":9798.5,"d":"9798.50"},""]
["2",null,"10101038","人工运土(运距20m以内)","m3",{"v":52.39,"d":"52.390"},14.31,null,{"v":749.7,"d":"749.70"},""]
["3",null,"10101100","回填工程(填土人工夯实 平地)","m3",{"v":13,"d":"13.000"},9.64,null,125.32,""]
["4",null,"10104024","石基础(带形基础 整毛石利旧 浆砌)","m3",{"v":52.39,"d":"52.390"},323.18,null,{"v":16931.4,"d":"16931.40"},""]
["5",null,"10112031","勾缝(整毛石墙柱面水泥砂浆 平缝)","m2",{"v":96.72,"d":"96.720"},17.74,null,1715.81,""]
["6",null,"10104012","零星砌砖(零星砖砌体)","m3",{"v":1.56,"d":"1.560"},702.66,null,1096.15,""]
["7",null,"10112007","外墙面水泥砂浆一般抹灰(24+6mm厚 毛石墙面)","m2",{"v":13,"d":"13.000"},80.14,null,1041.82,""]
["8",null,"10111034","整体楼地面分割缝(缝深4cm)","m",{"v":82,"d":"82.000"},5.54,null,454.28,""]
["9",null,"10116036","拆除地面装饰层(拆除混凝土 垫层)","m3",{"v":6.15,"d":"6.150"},443.25,null,2725.99,""]
["10",null,"10101014","人工挖沟槽土方(一、二类土 槽深2m以内)","m3",{"v":67.65,"d":"67.650"},21.97,null,1486.27,""]
["11",null,"10101097","回填工程(砂基础)","m3",19.168,130.46,null,2500.66,""]
["12",null,"10102001","填料加固(灰土垫层)","m3",{"v":36.9,"d":"36.900"},{"v":29,"d":"29.00"},null,{"v":1070.1,"d":"1070.10"},""]
["13",null,"10102003","填料加固(碎石垫层)","m3",{"v":4.1,"d":"4.100"},197.93,null,811.51,""]
["14",null,"40203041T","C20水泥预拌非泵送细石混凝土路面(厚度10cm)","m2",{"v":61.5,"d":"61.500"},61.34,null,3772.41,""]
["15",null,"31001285","室外塑料排水管(热熔连接) 外径315mm以内","m",{"v":41,"d":"41.000"},110.53,null,4531.73,""]
["16",null,"10105254","检修井","座",{"v":1,"d":"1.000"},{"v":800,"d":"800.00"},null,{"v":800,"d":"800.00"},""]
["17",null,"10111034","整体楼地面分割缝(缝深4cm)","m",{"v":24,"d":"24.000"},5.54,null,132.96,""]
["18",null,"10116036","拆除地面装饰层(拆除混凝土 垫层)","m3",{"v":5.4,"d":"5.400"},443.25,null,2393.55,""]
["19",null,"10101014","人工挖沟槽土方(一、二类土 槽深2m以内)","m3",5.775,21.97,null,126.88,""]
["20",null,"10101086T","自卸汽车运土(载重10t以外 运距5km以内)","m3",5.775,15.32,null,88.47,""]
["21",null,"10101097","回填工程(砂基础)","m3",{"v":3.75,"d":"3.750"},130.46,null,489.23,""]
["22",null,"10102001","填料加固(灰土垫层)","m3",{"v":1.95,"d":"1.950"},{"v":29,"d":"29.00"},null,56.55,""]
["23",null,"10101094","原土夯实(人工)","m2",{"v":54,"d":"54.000"},0.98,null,52.92,""]
["24",null,"10102003","填料加固(碎石垫层)","m3",{"v":8.4,"d":"8.400"},197.93,null,1662.61,""]
["25",null,"40203041T","C20水泥预拌非泵送细石混凝土路面(厚度10cm)","m2",{"v":54,"d":"54.000"},61.34,null,3312.36,""]
["26",null,"10105254","检修井","座",{"v":2,"d":"2.000"},{"v":800,"d":"800.00"},null,{"v":1600,"d":"1600.00"},""]
["27",null,"31001282","室外塑料排水管(热熔连接) 外径160mm以内","m",{"v":15,"d":"15.000"},56.99,null,854.85,""]
["28",null,"10111060T","石块(乱毛石楼地面 220mm厚)","m2",{"v":3.6,"d":"3.600"},131.15,null,472.14,""]
["合        计",{"$nulls":7},60854.17,""]

{"sheet":"分部分项定额综合单价分析表","index":4,"n_rows":38,"n_cols":15,"rows_kept":38,"merged":[[0,0,0,13],[1,0,1,13],[2,0,2,11],[2,12,2,13],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,12],[3,13,4,13],[31,0,31,13],[32,0,32,13],[33,0,33,11],[33,12,33,13],[34,0,35,0],[34,1,35,1],[34,2,35,2],[34,3,35,3],[34,4,35,4],[34,5,34,12],[34,13,35,13]],"flags":["formulas_cached_only"]}
["分部分项定额综合单价分析表",{"$nulls":13},""]
["",{"$nulls":13},""]
["工程名称：宁德职业技术学院风荷花苑6#楼东北角挡土墙修缮项目 一般土建",{"$nulls":11},"第1页 共2页",null,""]
["序号","项目编码","项目名称","单位","工程量","综合单价组成(元)",{"$nulls":7},"综合单价\r\n(元)",""]
[{"$nulls":5},"人工费","材料费","其中：\r\n设备费","施工机具使用费","企业管理费","利润","规费","税金",null,""]
["1","10116005","拆除砖（石）砌体(拆除整毛石 干砌)","m3",{"v":52.39,"d":"52.390"},{"v":150.2,"d":"150.20"},{"$nulls":3},10.21,9.62,null,{"v":17,"d":"17.00"},187.03,""]
["2","10101038","人工运土(运距20m以内)","m3",{"v":52.39,"d":"52.390"},11.49,{"$nulls":3},0.78,0.74,null,{"v":1.3,"d":"1.30"},14.31,""]
["3","10101100","回填工程(填土人工夯实 平地)","m3",{"v":13,"d":"13.000"},7.69,0.04,null,null,0.53,{"v":0.5,"d":"0.50"},null,0.88,9.64,""]
["4","10104024","石基础(带形基础 整毛石利旧 浆砌)","m3",{"v":52.39,"d":"52.390"},215.64,40.64,null,3.24,17.65,16.63,null,29.38,323.18,""]
["5","10112031","勾缝(整毛石墙柱面水泥砂浆 平缝)","m2",{"v":96.72,"d":"96.720"},12.82,1.36,null,0.07,0.97,0.91,null,1.61,17.74,""]
["6","10104012","零星砌砖(零星砖砌体)","m3",{"v":1.56,"d":"1.560"},336.05,224.39,null,3.81,38.37,36.16,null,63.88,702.66,""]
["7","10112007","外墙面水泥砂浆一般抹灰(24+6mm厚 毛石墙面)","m2",{"v":13,"d":"13.000"},53.63,9.96,null,0.76,4.38,4.12,null,7.29,80.14,""]
["8","10111034","整体楼地面分割缝(缝深4cm)","m",{"v":82,"d":"82.000"},2.75,1.51,null,0.19,{"v":0.3,"d":"0.30"},0.29,null,{"v":0.5,"d":"0.50"},5.54,""]
["9","10116036","拆除地面装饰层(拆除混凝土 垫层)","m3",{"v":6.15,"d":"6.150"},355.94,{"$nulls":3},{"v":24.2,"d":"24.20"},22.81,null,{"v":40.3,"d":"40.30"},443.25,""]
["10","10101014","人工挖沟槽土方(一、二类土 槽深2m以内)","m3",{"v":67.65,"d":"67.650"},17.64,{"$nulls":3},{"v":1.2,"d":"1.20"},1.13,null,{"v":2,"d":"2.00"},21.97,""]
["11","10101097","回填工程(砂基础)","m3",19.168,{"v":11.8,"d":"11.80"},92.29,null,0.68,7.12,6.71,null,11.86,130.46,""]
["12","10102001","填料加固(灰土垫层)","m3",{"v":36.9,"d":"36.900"},46.96,-24.92,null,1.25,1.58,1.49,null,2.64,{"v":29,"d":"29.00"},""]
["13","10102003","填料加固(碎石垫层)","m3",{"v":4.1,"d":"4.100"},34.42,123.79,null,0.73,10.81,10.19,null,17.99,197.93,""]
["14","40203041T","C20水泥预拌非泵送细石混凝土路面(厚度10cm)","m2",{"v":61.5,"d":"61.500"},10.55,38.46,null,0.24,3.35,3.16,null,5.58,61.34,""]
["15","31001285","室外塑料排水管(热熔连接) 外径315mm以内","m",{"v":41,"d":"41.000"},16.61,{"v":62.9,"d":"62.90"},null,9.24,6.04,5.69,null,10.05,110.53,""]
["16","10105254","检修井","座",{"v":1,"d":"1.000"},6382.26,-5877.28,null,137.44,43.68,41.17,null,72.73,{"v":800,"d":"800.00"},""]
["17","10111034","整体楼地面分割缝(缝深4cm)","m",{"v":24,"d":"24.000"},2.75,1.51,null,0.19,{"v":0.3,"d":"0.30"},0.29,null,{"v":0.5,"d":"0.50"},5.54,""]
["18","10116036","拆除地面装饰层(拆除混凝土 垫层)","m3",{"v":5.4,"d":"5.400"},355.94,{"$nulls":3},{"v":24.2,"d":"24.20"},22.81,null,{"v":40.3,"d":"40.30"},443.25,""]
["19","10101014","人工挖沟槽土方(一、二类土 槽深2m以内)","m3",5.775,17.64,{"$nulls":3},{"v":1.2,"d":"1.20"},1.13,null,{"v":2,"d":"2.00"},21.97,""]
["20","10101086T","自卸汽车运土(载重10t以外 运距5km以内)","m3",5.775,0.15,null,null,12.15,0.84,0.79,null,1.39,15.32,""]
["21","10101097","回填工程(砂基础)","m3",{"v":3.75,"d":"3.750"},{"v":11.8,"d":"11.80"},92.29,null,0.68,7.12,6.71,null,11.86,130.46,""]
["22","10102001","填料加固(灰土垫层)","m3",{"v":1.95,"d":"1.950"},46.96,-24.92,null,1.25,1.58,1.49,null,2.64,{"v":29,"d":"29.00"},""]
["23","10101094","原土夯实(人工)","m2",{"v":54,"d":"54.000"},0.79,{"$nulls":3},0.05,0.05,null,0.09,0.98,""]
["24","10102003","填料加固(碎石垫层)","m3",{"v":8.4,"d":"8.400"},34.42,123.79,null,0.73,10.81,10.19,null,17.99,197.93,""]
["25","40203041T","C20水泥预拌非泵送细石混凝土路面(厚度10cm)","m2",{"v":54,"d":"54.000"},10.55,38.46,null,0.24,3.35,3.16,null,5.58,61.34,""]
["26","10105254","检修井","座",{"v":2,"d":"2.000"},6382.26,-5877.28,null,137.44,43.68,41.17,null,72.73,{"v":800,"d":"800.00"},""]
["分部分项定额综合单价分析表",{"$nulls":13},""]
["",{"$nulls":13},""]
["工程名称：宁德职业技术学院风荷花苑6#楼东北角挡土墙修缮项目 一般土建",{"$nulls":11},"第2页 共2页",null,""]
["序号","项目编码","项目名称","单位","工程量","综合单价组成(元)",{"$nulls":7},"综合单价\r\n(元)",""]
[{"$nulls":5},"人工费","材料费","其中：\r\n设备费","施工机具使用费","企业管理费","利润","规费","税金",null,""]
["27","31001282","室外塑料排水管(热熔连接) 外径160mm以内","m",{"v":15,"d":"15.000"},10.22,31.86,null,3.69,3.11,2.93,null,5.18,56.99,""]
["28","10111060T","石块(乱毛石楼地面 220mm厚)","m2",{"v":3.6,"d":"3.600"},62.89,40.89,null,1.54,7.16,6.75,null,11.92,131.15,""]

{"sheet":"人工、材料设备、机械汇总表","index":5,"n_rows":71,"n_cols":8,"rows_kept":71,"read":"biff_walk_short","flags":["formulas_cached_only"]}
["人工、材料设备、机械汇总表"]
[""]
["工程名称：宁德职业技术学院风荷花苑6#楼东北角挡土墙修缮项目 一般土建",{"$nulls":5},"第1页 共2页"]
["序号","工料机编码","工料机名称","规格、型号等特殊要求","单位","数量","单价","合价"]
["一","","人工","","","","",""]
["1","00010040","定额人工费","","元","","",52022.11]
["二","","材料","","","","",""]
["1","01010350","螺纹钢筋","HRB400EΦ16","t",1.618,3948.28,6386.74]
["2","01090290","圆钢","Ф10","t",1.879,{"v":4206.9,"d":"4206.90"},7904.34]
["3","03131480","铁砂布","","张",1.163,0.85,0.99]
["4","04010170","散装水泥","42.5","kg",16930.477,0.43,7229.31]
["5","04030170","机制砂","","m3",28.418,73.54,2089.88]
["6","04030230","净干砂（机制砂）","","m3",45.413,83.35,3785.21]
["7","04050190","碎石","综合","m3",{"v":13.77,"d":"13.770"},111.65,1537.42]
["8","04050200","碎石","Φ5-10 （细石）","m3",7.409,91.19,675.64]
["9","04050230","碎石","Φ5-25","m3",20.572,83.35,1714.67]
["10","04090030","粉煤灰","Ⅱ级","kg",2852.273,0.25,713.07]
["11","04090250","生石灰","","kg",9629.361,0.62,{"v":5970.2,"d":"5970.20"}]
["12","04090350","粘土","","m3",45.571,20.59,938.31]
["13","04090360","粘土膏","","m3",0.035,29.01,{"v":1,"d":"1.00"}]
["14","04110240","小乱毛石","","m3",{"v":0.32,"d":"0.320"},78.45,25.07]
["15","04110250","乱毛石","","m3",0.958,98.06,{"v":93.9,"d":"93.90"}]
["16","04110280","整毛石","定长","m3",42.876]
["17","04130540","烧结煤矸石普通砖","240×115×53","块",860.184,0.35,301.06]
["18","05030220","松木锯材","","m3",0.161,1331.41,214.49]
["19","13310050","石油沥青","10#","kg",20.147,2.26,45.53]
["20","14350190","防水剂","","kg",77.883,20.59,1603.61]
["21","14351100","减水剂","WR-S","kg",163.003,3.57,581.92]
["22","17251260","硬聚氯乙烯管","Φ15","m",135.325,2.51,339.67]
["23","17253160","塑料排水管","Φ160","m",14.895,{"v":32,"d":"32.00"},476.64]
["24","17253190","塑料排水管","Φ315","m",40.713,{"v":63,"d":"63.00"},2564.92]
["25","34090130","金刚石刀片","","片",{"v":0.36,"d":"0.360"},307.69,110.89]
["26","34110030","电","","kW·h",4.805,0.65,3.12]
["27","34110080","水","","m3",{"v":64.5,"d":"64.500"},2.76,178.02]
["28","35010140","胶合板","18厚、一级、酚醛","m2",158.053,38.99,6162.47]
["29","35030080","钢管","Φ48.3×3.6","t.月",2.985,{"v":95.3,"d":"95.30"},{"v":284.5,"d":"284.50"}]
["30","36010190","轻型铸铁井盖井座","Φ700","座",{"v":6,"d":"6.000"},284.37,1706.22]
["31","49010030","其他材料费","","%",211.849,{"v":1,"d":"1.00"},211.85]
["32","49010040","其他材料费","","元",1099.325,{"v":1,"d":"1.00"},1099.32]
["33","49010040","其他材料费","","元",-64397.535,{"v":1,"d":"1.00"},-64397.54]
["34","80010350","现拌砌筑砂浆","M5(42.5) 砂子4.75mm 稠度50~70mm","m3",11.942,166.87,1992.69]
["35","80010480","现拌抹灰砂浆","1:2 M45(42.5) 砂子4.75mm 稠度50~70mm","m3",0.362,{"v":360.3,"d":"360.30"},130.25]
["人工、材料设备、机械汇总表"]
[""]
["工程名称：宁德职业技术学院风荷花苑6#楼东北角挡土墙修缮项目 一般土建",{"$nulls":5},"第2页 共2页"]
["序号","工料机编码","工料机名称","规格、型号等特殊要求","单位","数量","单价","合价"]
["36","80010490","现拌抹灰砂浆","1:2.5 M40(42.5) 砂子4.75mm 稠度50~70mm","m3",1.856,315.56,585.68]
["37","80010500","现拌抹灰砂浆","1:3 M30(42.5) 砂子4.75mm 稠度50~70mm","m3",2.851,277.13,790.12]
["38","80010690","预拌同配比砂浆","C25(42.5)  砂子4.75mm","m3",0.719]
["39","80050150","现拌混合砂浆","M5(42.5)","m3",0.329,147.38,48.51]
["40","80213465","预拌非泵送细石混凝土","C20(42.5) 碎石10mm(细石) 塌落度120-160mm","m3",11.723,353.49,4144.05]
["41","80213670","预拌泵送普通混凝土","泵送100m以下 C15(42.5) 碎石25mm 塌落度160-200mm","m3",1.882,332.32,625.29]
["42","80213680","预拌泵送普通混凝土","泵送100m以下 C25(42.5) 碎石25mm 塌落度160-200mm","m3",30.333,378.36,11476.79]
["43","80310020","灰土","3:7","m3",39.627,175.17,6941.34]
["三","","设备","","","","",""]
["四","","施工机具","","","","",""]
["1","99050210","灰浆搅拌机","拌筒容量200L","台班",2.209,131.55,290.57]
["2","99050660","混凝土磨光机","","台班",{"v":0.77,"d":"0.770"},14.88,11.46]
["3","99050670","混凝土振动梁","","台班",{"v":0.77,"d":"0.770"},20.61,15.88]
["4","99070520","载货汽车","装载质量5t","台班",0.118,399.82,47.26]
["5","99070530","载货汽车","装载质量6t","台班",{"v":0.36,"d":"0.360"},420.04,151.21]
["6","99070670","自卸汽车","装载质量15t","台班",0.077,906.97,70.19]
["7","99090310","汽车式起重机","提升质量8t","台班",0.495,629.23,311.28]
["8","99130280","电动夯实机","夯击能力20～62N.m","台班",2.698,27.16,73.27]
["9","99130610","混凝土路面锯缝机","不含刀片","台班",0.869,23.04,20.03]
["10","99170020","钢筋切断机","直径40mm","台班",{"v":0.36,"d":"0.360"},39.14,{"v":14.1,"d":"14.10"}]
["11","99170040","钢筋弯曲机","直径40mm","台班",1.008,23.86,24.04]
["12","99210001","木工圆锯机","直径500mm","台班",1.639,24.13,39.54]
["13","99250110","直流弧焊机","容量 32kV·A","台班",{"v":0.71,"d":"0.710"},84.53,60.02]
["14","99250150","对焊机","容量75kVA","台班",0.174,103.61,{"v":18,"d":"18.00"}]
["15","99250660","热熔对接焊机","160mm","台班",0.225,15.61,3.51]