{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["单位工程概算费用计算表(表10.1.1-8)","建筑工程概算表(表10.1.1-9)","设备及安装工程概算表(表10.1.1-10)","主要材料用量表(表10.1.1-12)"],"read":"whole","date_system":"1900"}

{"sheet":"单位工程概算费用计算表(表10.1.1-8)","index":0,"n_rows":44,"n_cols":7,"rows_kept":44,"merged":[[0,0,0,1],[0,3,0,4],[0,5,0,6],[1,0,1,6],[2,0,2,4],[2,5,2,6],[3,1,3,3],[3,4,3,5],[4,1,4,3],[4,4,4,5],[5,1,5,3],[5,4,5,5],[6,1,6,3],[6,4,6,5],[7,1,7,3],[7,4,7,5],[8,1,8,3],[8,4,8,5],[9,1,9,3],[9,4,9,5],[10,1,10,3],[10,4,10,5],[11,1,11,3],[11,4,11,5],[12,1,12,3],[12,4,12,5],[13,1,13,3],[13,4,13,5],[14,1,14,3],[14,4,14,5],[15,1,15,3],[15,4,15,5],[16,1,16,3],[16,4,16,5],[17,1,17,3],[17,4,17,5],[18,1,18,3],[18,4,18,5],[19,1,19,3],[19,4,19,5],[20,1,20,3],[20,4,20,5],[21,1,21,3],[21,4,21,5],[22,1,22,3],[22,4,22,5],[23,1,23,3],[23,4,23,5],[24,1,24,3],[24,4,24,5],[25,1,25,3],[25,4,25,5],[26,1,26,3],[26,4,26,5],[27,1,27,3],[27,4,27,5],[28,1,28,3],[28,4,28,5],[29,1,29,3],[29,4,29,5],[30,1,30,3],[30,4,30,5],[31,1,31,3],[31,4,31,5],[32,1,32,3],[32,4,32,5],[33,1,33,3],[33,4,33,5],[34,1,34,3],[34,4,34,5],[35,1,35,3],[35,4,35,5],[36,1,36,3],[36,4,36,5],[37,1,37,3],[37,4,37,5],[38,1,38,3],[38,4,38,5],[39,1,39,3],[39,4,39,5],[40,1,40,3],[40,4,40,5],[41,1,41,3],[41,4,41,5],[42,1,42,3],[42,4,42,5],[43,0,43,1],[43,3,43,4],[43,5,43,6]]}
["表10.1.1-8"]
["单位工程概算费用计算表"]
["单位工程名称：压舱水输水工程-给水工程",{"$nulls":4},"第 2 页   共 8 页"]
["序号","费用项目名称",null,null,"计算公式",null,"金额(元)"]
["一","分部分项工程费",null,null,"Σ(分部分项工程量×综合单价)"]
["1.1","其中：1.人工费+机械费",null,null,"Σ分部分项(人工费+机械费)"]
["二","施工技术措施项目费",null,null,"Σ(技术措施项目工程量×综合单价)"]
["2.1","其中：2.人工费+机械费",null,null,"Σ技术措施项目(人工费+机械费)"]
["三","总价综合费用",null,null,"(1+2)×综合费率"]
["四","其他费用",null,null,"3+4+5"]
["4.1","其中：3.标化工地预留费",null,null,"(1+2)×费率"]
["4.2","其中：4.优质工程预留费",null,null,"(一+二+三)×费率"]
["4.3","其中：5.概算扩大费用",null,null,"(一+二+三)×扩大系数"]
["五","税前概算费用",null,null,"一+二+三+四"]
[null,"其中：6.不计税金额",null,null,"按规定不计税的工程设备费金额列入"]
["六","增值税",null,null,"(五-6)×税率"]
["七","建筑安装工程概算费用",null,null,"五+六"]
{"$rows_empty":26}
["编制人：",null,"审核人:","审定人：",null,"编制时间： 年  月  日"]

{"sheet":"建筑工程概算表(表10.1.1-9)","index":1,"n_rows":45,"n_cols":16,"rows_kept":45,"merged":[[0,0,0,2],[0,3,0,6],[0,7,0,10],[0,11,0,15],[1,0,1,15],[2,0,2,6],[2,7,2,15],[3,0,5,0],[3,1,5,1],[3,2,5,3],[3,4,5,4],[3,5,5,5],[3,6,3,11],[3,12,3,15],[4,6,5,7],[4,8,4,11],[4,12,5,12],[4,13,4,15],[5,10,5,11],[6,2,6,3],[6,6,6,7],[6,10,6,11],[7,2,7,3],[7,6,7,7],[7,10,7,11],[8,2,8,3],[8,6,8,7],[8,10,8,11],[9,2,9,3],[9,6,9,7],[9,10,9,11],[10,2,10,3],[10,6,10,7],[10,10,10,11],[11,2,11,3],[11,6,11,7],[11,10,11,11],[12,2,12,3],[12,6,12,7],[12,10,12,11],[13,2,13,3],[13,6,13,7],[13,10,13,11],[14,2,14,3],[14,6,14,7],[14,10,14,11],[15,2,15,3],[15,6,15,7],[15,10,15,11],[16,2,16,3],[16,6,16,7],[16,10,16,11],[17,2,17,3],[17,6,17,7],[17,10,17,11],[18,2,18,3],[18,6,18,7],[18,10,18,11],[19,2,19,3],[19,6,19,7],[19,10,19,11],[20,0,20,2],[20,3,20,6],[20,7,20,10],[20,11,20,15],[21,0,21,2],[21,3,21,6],[21,7,21,10],[21,11,21,15],[22,0,22,15],[23,0,23,6],[23,7,23,15],[24,0,26,0],[24,1,26,1],[24,2,26,3],[24,4,26,4],[24,5,26,5],[24,6,24,11],[24,12,24,15],[25,6,26,7],[25,8,25,11],[25,12,26,12],[25,13,25,15],[26,10,26,11],[27,2,27,3],[27,6,27,7],[27,10,27,11],[28,2,28,3],[28,6,28,7],[28,10,28,11],[29,2,29,3],[29,6,29,7],[29,10,29,11],[30,2,30,3],[30,6,30,7],[30,10,30,11],[31,2,31,3],[31,6,31,7],[31,10,31,11],[32,2,32,3],[32,6,32,7],[32,10,32,11],[33,2,33,3],[33,6,33,7],[33,10,33,11],[34,2,34,3],[34,6,34,7],[34,10,34,11],[35,2,35,3],[35,6,35,7],[35,10,35,11],[36,2,36,3],[36,6,36,7],[36,10,36,11],[37,2,37,3],[37,6,37,7],[37,10,37,11],[38,2,38,3],[38,6,38,7],[38,10,38,11],[39,2,39,3],[39,6,39,7],[39,10,39,11],[40,2,40,3],[40,6,40,7],[40,10,40,11],[41,2,41,3],[41,6,41,7],[41,10,41,11],[42,2,42,3],[42,6,42,7],[42,10,42,11],[43,0,43,11],[44,0,44,2],[44,3,44,6],[44,7,44,10],[44,11,44,15]]}
["表10.1.1-9"]
["建筑工程概算表"]
["单位工程名称：压舱水输水工程-给水工程",{"$nulls":6},"第 3 页   共 8 页"]
["序号","定额编号","工程项目或费用名称",null,"单位","数量","单价(元)",{"$nulls":5},"合价(元)"]
[{"$nulls":6},"合计",null,"其中",{"$nulls":3},"合计","其中"]
[{"$nulls":8},"人工费","材料费","机械费",null,null,"人工费","材料费","机械费"]
[1,"03B053","压舱水取水泵车 每套泵车设置2台水泵，配合设置吊臂，磁吸口；定制焊接\n单合水泵Q=300T/h，H=15m\nN=37KW",null,"套",2]
[2,"主材","磁吸口定制",null,"项",1]
[3,"03B053","定制滑轮吊杆 组装焊接",null,"套",1]
[4,"安10-1-65","HDPE给水管 DN350",null,"10m",53]
[5,"安10-1-65","HDPE给水管 DN250",null,"10m",0.5]
[6,"安10-1-65","软管 DN250",null,"10m",8]
[7,"安10-1-64","HDPE给水管 DN150",null,"10m",1.5]
[8,"安10-8-35","管道消毒、冲洗 公称直径(mm以内)400",null,"100m",5.3]
[9,"安10-8-34","管道消毒、冲洗 公称直径(mm以内)300",null,"100m",0.85]
[10,"安10-8-33","管道消毒、冲洗 公称直径(mm以内)200",null,"100m",0.15]
[11,"安13-1-31","一般管架制作",null,"100kg",17.666667]
[12,"安13-1-32","一般管架安装",null,"100kg",17.666667]
[13,"安12-1-5","手工除锈 一般钢结构轻锈",null,"100kg",17.666667]
[14,"安12-2-53 换","一般钢结构 红丹防锈漆第一遍 \u007f实际遍数(遍):2",null,"100kg",17.666667]
["编制人：",null,null,"审核人：",{"$nulls":3},"审定人：",{"$nulls":3},"编制时间： 年  月  日"]
["表10.1.1-9"]
["建筑工程概算表"]
["单位工程名称：压舱水输水工程-给水工程",{"$nulls":6},"第 4 页   共 8 页"]
["序号","定额编号","工程项目或费用名称",null,"单位","数量","单价(元)",{"$nulls":5},"合价(元)"]
[{"$nulls":6},"合计",null,"其中",{"$nulls":3},"合计","其中"]
[{"$nulls":8},"人工费","材料费","机械费",null,null,"人工费","材料费","机械费"]
[15,"安12-2-62 换","一般钢结构 调和漆第一遍 \u007f实际遍数(遍):2",null,"100kg",17.666667]
[16,"安2-8-89","水箱安装 200T成套镀锌钢板水箱 20m*4.0m*3.0m",null,"台",1]
[17,"主材","混凝土水箱基础",null,"项",1]
[18,"安8-3-30","蝶阀 球墨铸铁阀芯 DN350",null,"个",1]
[19,"安8-3-30","蝶阀 球墨铸铁阀芯 DN350",null,"个",1]
[20,"市5-457","不锈钢水表 DN350",null,"个",1]
[21,"安8-3-28","蝶阀 球墨铸铁阀芯 DN250",null,"个",3]
[22,"安8-3-26","蝶阀 球墨铸铁阀芯 DN150",null,"个",1]
[23,"安8-3-26","电动阀 球墨铸铁阀芯 DN150",null,"个",1]
[24,"安1-8-15","水箱取水泵组 暂定单台水泵Q=50T/h，H=15m，N=11kw",null,"组",1]
[]
[]
[]
[]
[]
[]
["合    计"]
["编制人：",null,null,"审核人：",{"$nulls":3},"审定人：",{"$nulls":3},"编制时间： 年  月  日"]

{"sheet":"设备及安装工程概算表(表10.1.1-10)","index":2,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[0,0,0,2],[0,3,0,7],[0,8,0,11],[0,12,0,17],[1,0,1,17],[2,0,2,7],[2,8,2,17],[3,0,6,0],[3,1,6,1],[3,2,6,3],[3,4,6,4],[3,5,6,5],[3,6,3,12],[3,13,3,17],[4,6,6,6],[4,7,4,12],[4,13,6,13],[4,14,4,17],[5,7,6,8],[5,9,5,12],[5,14,6,14],[5,15,5,17],[6,11,6,12],[7,2,7,3],[7,7,7,8],[7,11,7,12],[8,2,8,3],[8,7,8,8],[8,11,8,12],[9,2,9,3],[9,7,9,8],[9,11,9,12],[10,2,10,3],[10,7,10,8],[10,11,10,12],[11,2,11,3],[11,7,11,8],[11,11,11,12],[12,2,12,3],[12,7,12,8],[12,11,12,12],[13,2,13,3],[13,7,13,8],[13,11,13,12],[14,2,14,3],[14,7,14,8],[14,11,14,12],[15,2,15,3],[15,7,15,8],[15,11,15,12],[16,2,16,3],[16,7,16,8],[16,11,16,12],[17,2,17,3],[17,7,17,8],[17,11,17,12],[18,2,18,3],[18,7,18,8],[18,11,18,12],[19,0,19,17],[20,0,20,2],[20,3,20,7],[20,8,20,11],[20,12,20,17],[21,0,21,2],[21,3,21,7],[21,8,21,11],[21,12,21,17],[22,0,22,17],[23,0,23,7],[23,8,23,17],[24,0,27,0],[24,1,27,1],[24,2,27,3],[24,4,27,4],[24,5,27,5],[24,6,24,12],[24,13,24,17],[25,6,27,6],[25,7,25,12],[25,13,27,13],[25,14,25,17],[26,7,27,8],[26,9,26,12],[26,14,27,14],[26,15,26,17],[27,11,27,12],[28,2,28,3],[28,7,28,8],[28,11,28,12],[29,2,29,3],[29,7,29,8],[29,11,29,12],[30,2,30,3],[30,7,30,8],[30,11,30,12],[31,2,31,3],[31,7,31,8],[31,11,31,12],[32,2,32,3],[32,7,32,8],[32,11,32,12],[33,2,33,3],[33,7,33,8],[33,11,33,12],[34,2,34,3],[34,7,34,8],[34,11,34,12],[35,2,35,3],[35,7,35,8],[35,11,35,12],[36,2,36,3],[36,7,36,8],[36,11,36,12],[37,2,37,3],[37,7,37,8],[37,11,37,12],[38,2,38,3],[38,7,38,8],[38,11,38,12],[39,2,39,3],[39,7,39,8],[39,11,39,12],[40,0,40,17],[41,0,41,2],[41,3,41,7],[41,8,41,11],[41,12,41,17],[42,0,42,2],[42,3,42,7],[42,8,42,11],[42,12,42,17],[43,0,43,17],[44,0,44,7],[44,8,44,17],[45,0,45,12],[46,0,46,17],[47,0,47,2],[47,3,47,7],[47,8,47,11],[47,12,47,17]]}
["表10.1.1-10"]
["设备及安装工程概算表"]
["单位工程名称：压舱水输水工程-给水工程",{"$nulls":7},"第 5 页   共 8 页"]
["序号","定额编号","工程项目或费用名称",null,"单位","数量","单价（元）",{"$nulls":6},"合价(元)"]
[{"$nulls":6},"设备和主材费","定额单价(元)",{"$nulls":5},"设备和主材费","定额合价(元)"]
[{"$nulls":7},"合计",null,"其中",{"$nulls":4},"合计","其中"]
[{"$nulls":9},"人工费","材料费","机械费",{"$nulls":3},"人工费","材料费","机械费"]
[1,"03B053","压舱水取水泵车 每套泵车设置2台水泵，配合设置吊臂，磁吸口；定制焊接\n单合水泵Q=300T/h，H=15m\nN=37KW",null,"套",2]
[2,"主材","磁吸口定制",null,"项",1]
[3,"03B053","定制滑轮吊杆 组装焊接",null,"套",1]
[4,"安10-1-65","HDPE给水管 DN350",null,"10m",53]
[5,"安10-1-65","HDPE给水管 DN250",null,"10m",0.5]
[6,"安10-1-65","软管 DN250",null,"10m",8]
[7,"安10-1-64","HDPE给水管 DN150",null,"10m",1.5]
[8,"安10-8-35","管道消毒、冲洗 公称直径(mm以内)400",null,"100m",5.3]
[9,"安10-8-34","管道消毒、冲洗 公称直径(mm以内)300",null,"100m",0.85]
[10,"安10-8-33","管道消毒、冲洗 公称直径(mm以内)200",null,"100m",0.15]
[11,"安13-1-31","一般管架制作",null,"100kg",17.666667]
[12,"安13-1-32","一般管架安装",null,"100kg",17.666667]
["注：定额单价为按定额消耗量及项目编制期取定的基准价计算的单价值。"]
["编制人：",null,null,"审核人：",{"$nulls":4},"审定人：",{"$nulls":3},"编制时间： 年  月  日"]
["表10.1.1-10"]
["设备及安装工程概算表"]
["单位工程名称：压舱水输水工程-给水工程",{"$nulls":7},"第 6 页   共 8 页"]
["序号","定额编号","工程项目或费用名称",null,"单位","数量","单价（元）",{"$nulls":6},"合价(元)"]
[{"$nulls":6},"设备和主材费","定额单价(元)",{"$nulls":5},"设备和主材费","定额合价(元)"]
[{"$nulls":7},"合计",null,"其中",{"$nulls":4},"合计","其中"]
[{"$nulls":9},"人工费","材料费","机械费",{"$nulls":3},"人工费","材料费","机械费"]
[13,"安12-1-5","手工除锈 一般钢结构轻锈",null,"100kg",17.666667]
[14,"安12-2-53 换","一般钢结构 红丹防锈漆第一遍 \u007f实际遍数(遍):2",null,"100kg",17.666667]
[15,"安12-2-62 换","一般钢结构 调和漆第一遍 \u007f实际遍数(遍):2",null,"100kg",17.666667]
[16,"安2-8-89","水箱安装 200T成套镀锌钢板水箱 20m*4.0m*3.0m",null,"台",1]
[17,"主材","混凝土水箱基础",null,"项",1]
[18,"安8-3-30","蝶阀 球墨铸铁阀芯 DN350",null,"个",1]
[19,"安8-3-30","蝶阀 球墨铸铁阀芯 DN350",null,"个",1]
[20,"市5-457","不锈钢水表 DN350",null,"个",1]
[21,"安8-3-28","蝶阀 球墨铸铁阀芯 DN250",null,"个",3]
[22,"安8-3-26","蝶阀 球墨铸铁阀芯 DN150",null,"个",1]
[23,"安8-3-26","电动阀 球墨铸铁阀芯 DN150",null,"个",1]
[24,"安1-8-15","水箱取水泵组 暂定单台水泵Q=50T/h，H=15m，N=11kw",null,"组",1]
["注：定额单价为按定额消耗量及项目编制期取定的基准价计算的单价值。"]
["编制人：",null,null,"审核人：",{"$nulls":4},"审定人：",{"$nulls":3},"编制时间： 年  月  日"]
["表10.1.1-10"]
["设备及安装工程概算表"]
["单位工程名称：压舱水输水工程-给水工程",{"$nulls":7},"第 7 页   共 8 页"]
["合    计"]
["注：定额单价为按定额消耗量及项目编制期取定的基准价计算的单价值。"]
["编制人：",null,null,"审核人：",{"$nulls":4},"审定人：",{"$nulls":3},"编制时间： 年  月  日"]

{"sheet":"主要材料用量表(表10.1.1-12)","index":3,"n_rows":38,"n_cols":10,"rows_kept":38,"merged":[[0,0,0,1],[0,2,0,3],[0,4,0,6],[0,7,0,9],[1,0,1,9],[2,0,2,6],[2,7,2,9],[3,1,3,2],[3,3,3,4],[3,6,3,7],[4,1,4,2],[4,3,4,4],[4,6,4,7],[5,1,5,2],[5,3,5,4],[5,6,5,7],[6,1,6,2],[6,3,6,4],[6,6,6,7],[7,1,7,2],[7,3,7,4],[7,6,7,7],[8,1,8,2],[8,3,8,4],[8,6,8,7],[9,1,9,2],[9,3,9,4],[9,6,9,7],[10,1,10,2],[10,3,10,4],[10,6,10,7],[11,1,11,2],[11,3,11,4],[11,6,11,7],[12,1,12,2],[12,3,12,4],[12,6,12,7],[13,1,13,2],[13,3,13,4],[13,6,13,7],[14,1,14,2],[14,3,14,4],[14,6,14,7],[15,1,15,2],[15,3,15,4],[15,6,15,7],[16,1,16,2],[16,3,16,4],[16,6,16,7],[17,1,17,2],[17,3,17,4],[17,6,17,7],[18,1,18,2],[18,3,18,4],[18,6,18,7],[19,1,19,2],[19,3,19,4],[19,6,19,7],[20,1,20,2],[20,3,20,4],[20,6,20,7],[21,1,21,2],[21,3,21,4],[21,6,21,7],[22,1,22,2],[22,3,22,4],[22,6,22,7],[23,1,23,2],[23,3,23,4],[23,6,23,7],[24,1,24,2],[24,3,24,4],[24,6,24,7],[25,1,25,2],[25,3,25,4],[25,6,25,7],[26,1,26,2],[26,3,26,4],[26,6,26,7],[27,1,27,2],[27,3,27,4],[27,6,27,7],[28,1,28,2],[28,3,28,4],[28,6,28,7],[29,1,29,2],[29,3,29,4],[29,6,29,7],[30,1,30,2],[30,3,30,4],[30,6,30,7],[31,1,31,2],[31,3,31,4],[31,6,31,7],[32,1,32,2],[32,3,32,4],[32,6,32,7],[33,1,33,2],[33,3,33,4],[33,6,33,7],[34,1,34,2],[34,3,34,4],[34,6,34,7],[35,1,35,2],[35,3,35,4],[35,6,35,7],[36,0,36,7],[37,0,37,1],[37,2,37,3],[37,4,37,6],[37,7,37,9]]}
["表10.1.1-12"]
["主要材料用量表"]
["单位工程名称：压舱水输水工程-给水工程",{"$nulls":6},"第 8 页   共 8 页"]
["序号","材料名称及规格型号",null,"单位",null,"数量","单价（元）",null,"合价(元)","说明"]
[1,"二类人工",null,"工日",null,164.047684]
[2,"型钢综合",null,"kg",null,"1872.666702"]
[3,"酚醛调和漆各色",null,"kg",null,26.500001]
[4,"醇酸防锈漆C53-1",null,"kg",null,37.276667]
[5,"HDPE给水管 DN350",null,"m",null,537.95]
[6,"HDPE给水管 DN250",null,"m",null,5.075]
[7,"软管 DN250",null,"m",null,81.2]
[8,"HDPE给水管 DN150DN150",null,"m",null,15.225]
[9,"蝶阀 球墨铸铁阀芯 DN350DN350",null,"个",null,2]
[10,"蝶阀 球墨铸铁阀芯 DN250DN250",null,"个",null,3]
[11,"蝶阀 球墨铸铁阀芯 DN150DN150",null,"个",null,1]
[12,"电动阀 球墨铸铁阀芯 DN150DN150",null,"个",null,1]
[13,"不锈钢水表 DN350",null,"只",null,1]
[14,"水",null,"m3",null,371.025]
[15,"水箱取水泵组 暂定单台水泵Q=50T/h，H=15m，N=11kw",null,"组",null,1]
[16,"压舱水取水泵车 每套泵车设置2台水泵，配合设置吊臂，磁吸口；定制焊接\n单合水泵Q=300T/h，H=15m\nN=37KW",null,"套",null,2]
[17,"定制滑轮吊杆 组装焊接",null,"套",null,1]
[18,"200T成套镀锌钢板水箱",null,"台",null,1]
[19,"混凝土水箱基础",null,"项",null,1]
[20,"磁吸口定制",null,"项",null,1]
{"$rows_empty":12}
["合计"]
["编制人：",null,"审核人：",null,"审定人：",null,null,"编制时间： 年  月  日"]