{"text_format":"3","workbook":"xls","n_sheets":10,"sheets":["封面 ","说","综合预算表 ","其他费用表","单位工程造价汇总表(含细项)","分部分项工程量清单与计价表","总价措施项目清单与计价表(含分项)","单价措施项目清单与计价表","分部分项工程量清单综合单价分析表","人工、材料设备、机械汇总表"],"not_rendered":{"external_links":2,"defined_names":4},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"封面 ","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"merged":[[0,0,1,2]],"flags":["formulas_cached_only"]}
["三明梅列区城投小溪施工变工程"]
[]
[null,"施工图设计"]
[null,"预算书"]
[]
[]
[]
[]
[null,"三明亿源电力勘察设计有限公司"]
[]
[null,"工程设计证书（乙）级编号：A235006436"]
[null,"发证机关：福建省住房和城乡建设厅"]
[]
[null,"2018-05-18"]

{"sheet":"说","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"merged":[[16,0,18,8]],"flags":["formulas_cached_only"]}
[{"$nulls":3},"设计（编制）说明"]
["一.任务依据："]
[null,"1.业扩工程设计委托书；"]
[null,"2.工程设计合同书。"]
["二.编制依据："]
[null,"1.定额采用《福建省通用安装工程预算定额（2017版）》第四册 电气设备安装工程、《福建省房屋建筑与装饰工程预算定额（2017版）》"]
[null,"2.工程量清单采用2013年7月1日起实施的中华人民共和国国家标准《通用安装工程工程量计算规范》。"]
[null,"3.取费标准根据闽建筑[2017]12号文“福建省住房和城乡建设厅关于颁发《福建省房屋建筑与装饰工程预算定额（2017版）》"]
["（2017版）的通知”，和闽建筑[2017]20号文“福建省建设厅关于颁发《福建省通用安装工程预算定额（2017版）》（2017版）的通知”，"]
[null,"4.根据福建省住房和城乡建设厅文件闽建筑[2016]13号关于建筑营业税改增值税调整福建省建设工程计价依据的实施意见的通知，税金取11%。"]
[null,"5.根据计价格[2002]10号文“国家计委、建设部关于发布《工程勘察设计收费管理规定》的通知取设计费。"]
[null,"6.工程主材价格根据三明市2018年2月份市场价计取。"]
[null,"7.工程量依据设计人员提供的图纸进行计算。"]
[null,"8.本工程不含青苗赔偿。"]
[null,"9.本工程汽车运距暂按18km计取。"]
["三.工程概况："]
["    本工程新立15m电杆2根，新增250kVA杆上变1台、跌落开关1组、JP柜1台、隔离开关1组、高压避雷器1组，沿杆敷设4*150型低压电缆10m。"]
[]
[]
[null,null,"人力运输平均运距：",0,null,"汽车运输平均运距：",18]
[null,"工程地形："]
[null,"平地：",{"v":1,"d":"100%"},"丘陵：",{"v":0,"d":"0%"},"山地：",{"v":0,"d":"0%"}]
["四.本工程投资"]
[null,"本工程投资:",{"v":107243.062746,"d":"107243"},"元"]

{"sheet":"综合预算表 ","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,1,1,5],[3,0,4,0],[3,1,4,1],[3,2,3,4]],"flags":["formulas_cached_only"]}
[]
[null,"综 合 预 算 表"]
[]
["序号","工程名称","预 算 价 值（元）"]
[null,null,"建筑费","安装费","设备费","合计(元)"]
["一","本体工程费",{"$nulls":3},101733]
[1,"建筑工程",0,null,null,0]
[2,"安装工程",null,48949,52784,101733]
["二","其它费用",{"$nulls":3},{"v":5510.062745999999,"d":"5510"}]
[null,"总 计",{"$nulls":3},{"v":107243.062746,"d":"107243"}]

{"sheet":"其他费用表","index":3,"n_rows":13,"n_cols":8,"rows_kept":13,"merged":[[1,2,1,5],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[12,0,12,1],[12,2,12,4]],"flags":["formulas_cached_only"]}
[]
[null,null,"其 它 费 用 表"]
["序号","费用名称","计算公式",null,null,"合计(万元)","编制依据","文件页码"]
[1,"工程设计费","基本设计收费+其他设计收费",null,null,{"v":0.5510062745999998,"d":"0.5510"},"“国家计委、建设部关于发布《工程勘察设计收费管理规定》的通知”（计价格[2002]10号）"]
[1.1,"基本设计收费","工程设计收费基价*专业调整系数*工程复杂程度调整系数*附加调整系数",null,null,{"v":0.4669544699999999,"d":"0.4670"},null,"第62页"]
["1.1.1","工程设计收费基价","收费基价9.0/计费额200=0.045",null,null,{"v":0.45779849999999994,"d":"0.4578"},null,"第88页"]
["1.1.2","专业调整系数","工程设计收费基价*1.2(取送变电工程)",{"$nulls":4},"第89页"]
["1.1.3","工程复杂程度调整系数","工程设计收费基价*0.85(取一般计费系数)",{"$nulls":4},"第63页"]
["1.1.4","附加调整系数","本工程不计列"]
[1.2,"其他设计收费",{"$nulls":3},{"v":0.08405180459999999,"d":"0.0841"}]
["1.2.1","施工图预算编制费","基本设计收费*10%",null,null,{"v":0.046695446999999994,"d":"0.0467"},null,"第63页"]
["1.2.2","竣工图纸编制费","基本设计收费*8%",null,null,{"v":0.037356357599999994,"d":"0.0374"},null,"第63页"]
["总合计（设计费）",{"$nulls":4},{"v":0.5510062745999998,"d":"0.5510"}]

{"sheet":"单位工程造价汇总表(含细项)","index":4,"n_rows":25,"n_cols":6,"rows_kept":25,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,4],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5]],"flags":["formulas_cached_only"]}
["单位工程造价汇总表"]
[""]
["工程名称：三明梅列区城投小溪施工变工程  单项工程  安装工程",{"$nulls":4},"第1页 共1页"]
["序号","汇 总 内 容","计算基数","费率(%)","金 额(元)"]
["1","分部分项工程费",100502,null,{"v":100502,"d":"100502.00"}]
["1.1","电气工程",0,null,{"v":100502,"d":"100502.00"}]
["2","措施项目费",1231,null,{"v":1231,"d":"1231.00"}]
["2.1","总价措施项目费",1231,null,{"v":1231,"d":"1231.00"}]
["2.1.1","安全文明施工费",1021,null,{"v":1021,"d":"1021.00"}]
["2.1.2","其他总价措施费",210,null,{"v":210,"d":"210.00"}]
["2.2","单价措施项目费",0]
["3","其他项目费",0]
["3.1","暂列金额",0]
["3.2","专业工程暂估价",0]
["3.3","总承包服务费",0]
["4","总造价",101733,null,{"v":101733,"d":"101733.00"}]
["","人工费合计",10751,null,{"v":10751,"d":"10751.00"}]
["","材料费合计",72230,null,{"v":72230,"d":"72230.00"}]
["","其中工程设备费合计",52784,null,{"v":52784,"d":"52784.00"}]
["","其中甲供材料费含税合计",0]
["","施工机具使用费",2949,null,{"v":2949,"d":"2949.00"}]
["","企业管理费合计",3250,null,{"v":3250,"d":"3250.00"}]
["","利润合计",2184,null,{"v":2184,"d":"2184.00"}]
["","规费合计",0]
["","税金合计",9138,null,{"v":9138,"d":"9138.00"}]

{"sheet":"分部分项工程量清单与计价表","index":5,"n_rows":21,"n_cols":11,"rows_kept":21,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,7],[2,8,2,9],[3,0,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,3,9],[4,7,4,8],[5,0,5,9],[6,0,6,9],[7,0,7,9],[8,0,8,1],[8,7,8,8],[9,0,9,1],[9,7,9,8],[10,0,10,1],[10,7,10,8],[11,0,11,1],[11,7,11,8],[12,0,12,1],[12,7,12,8],[13,0,13,1],[13,7,13,8],[14,0,14,1],[14,7,14,8],[15,0,15,1],[15,7,15,8],[16,0,16,1],[16,7,16,8],[17,0,17,1],[17,7,17,8],[18,0,18,1],[18,7,18,8],[19,0,19,1],[19,7,19,8],[20,0,20,8]],"flags":["formulas_cached_only"]}
["分部分项工程量清单与计价表",{"$nulls":9},""]
["",{"$nulls":9},""]
["工程名称：三明梅列区城投小溪施工变工程",{"$nulls":7},"第1页 共1页",null,""]
["序号",null,"项目编码","项目名称","项目特征描述","计量单位","工程量","金    额(元)",null,null,""]
[{"$nulls":7},"综合单价",null,"合价",""]
["单项工程",{"$nulls":9},"单项工程(17安装)"]
["安装工程",{"$nulls":9},"单位工程(17安装)"]
["电气工程",{"$nulls":9},"分项工程(17安装)"]
["1",null,"030410001001","电杆组立","(1)砼\r\n(2)15m以下\r\n(3)户外式\r\n(4)平地\r\n(5)15m电杆","根",{"v":2,"d":"2.000"},11199.82,null,22399.64,""]
["2",null,"040801001001","杆上变压器","(1)杆上变压器\r\n(2)250kVA\r\n(3)10kV","台",{"v":1,"d":"1.000"},38285.03,null,38285.03,""]
["3",null,"030414001001","电力变压器系统","(1)变压器调试\r\n(2)10kV","系统",{"v":1,"d":"1.000"},1631.25,null,1631.25,""]
["4",null,"040801008001","杆上配电箱","(1)杆上配电箱","台",{"v":1,"d":"1.000"},20319.94,null,20319.94,""]
["5",null,"040801017001","跌落式熔断器","(1)跌落熔断器\r\n(2)杆上","组",{"v":1,"d":"1.000"},917.11,null,917.11,""]
["6",null,"030410003001","导线架设","(1)平地\r\n(2)绝缘铝绞线\r\n(3)JKLYJ-10/50","km",0.279,7697.42,null,2147.58,""]
["7",null,"030408001001","电力电缆","(1)YJV\r\n(2)150mm2内\r\n(3)铜\r\n(4)低压电缆\r\n(5)0.4kV","m",{"v":10,"d":"10.000"},538.74,null,{"v":5387.4,"d":"5387.40"},""]
["8",null,"040803005001","电缆终端头","(1)4*150\r\n(2)电缆终端头\r\n(3)YJV\r\n(4)0.4kV\r\n(5)铜","个",{"v":2,"d":"2.000"},622.46,null,1244.92,""]
["9",null,"030409001001","接地极","(1)L50X5X2500\r\n(2)接地角钢\r\n(3)坚土","根",{"v":13,"d":"13.000"},126.45,null,1643.85,""]
["10",null,"030409002001","接地母线","(1)-50X5\r\n(2)接地扁钢","m",{"v":72,"d":"72.000"},47.94,null,3451.68,""]
["11",null,"030414011001","接地装置","(1)接地网\r\n(2)接地网","系统",{"v":1,"d":"1.000"},801.34,null,801.34,""]
["12",null,"030402006001","隔离开关","(1)隔离开关\r\n(2)杆上\r\n(3)10kV","组",{"v":1,"d":"1.000"},2272.46,null,2272.46,""]
["合        计",{"$nulls":8},{"v":100502.2,"d":"100502.20"},""]

{"sheet":"总价措施项目清单与计价表(含分项)","index":6,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,7],[2,8,2,9],[3,0,3,1],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[4,0,4,9],[5,0,5,9],[6,0,6,9],[7,0,7,1],[7,2,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,9],[8,0,8,1],[8,2,8,3],[8,4,8,5],[8,6,8,7],[8,8,8,9],[9,0,9,7],[9,8,9,9]],"flags":["formulas_cached_only"]}
["总价措施项目清单与计价表"]
[""]
["工程名称：三明梅列区城投小溪施工变工程",{"$nulls":7},"第1页 共1页"]
["序号",null,"项 目 名 称",null,"计 算 基 础\r\n(元)",null,"费    率(%)",null,"金    额(元)"]
["单项工程"]
["安装工程"]
["电气工程"]
["1",null,"安全文明施工费",null,{"v":47718,"d":"47718.00"},null,"2.14",null,{"v":1021,"d":"1021.00"}]
["2",null,"其他总价措施费",null,{"v":47718,"d":"47718.00"},null,"0.44",null,{"v":210,"d":"210.00"}]
["合    计",{"$nulls":7},{"v":1231,"d":"1231.00"}]

{"sheet":"单价措施项目清单与计价表","index":7,"n_rows":9,"n_cols":11,"rows_kept":9,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,7],[2,8,2,9],[3,0,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,3,9],[4,7,4,8],[5,0,5,9],[6,0,6,9],[7,0,7,9],[8,0,8,8]],"flags":["formulas_cached_only"]}
["单价措施项目清单与计价表",{"$nulls":9},""]
["",{"$nulls":9},""]
["工程名称：三明梅列区城投小溪施工变工程",{"$nulls":7},"第1页 共1页",null,""]
["序号",null,"项目编码","项目名称","项目特征描述","计量单位","工程量","金    额(元)",null,null,""]
[{"$nulls":7},"综合单价",null,"合价",""]
["单项工程",{"$nulls":9},"单项工程(17安装)"]
["安装工程",{"$nulls":9},"单位工程(17安装)"]
["电气工程",{"$nulls":9},"分项工程(17安装)"]
["合       计",{"$nulls":9},""]

{"sheet":"分部分项工程量清单综合单价分析表","index":8,"n_rows":86,"n_cols":15,"rows_kept":86,"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],[5,0,5,13],[6,0,6,13],[7,0,7,13],[27,0,27,13],[28,0,28,13],[29,0,29,11],[29,12,29,13],[30,0,31,0],[30,1,31,1],[30,2,31,2],[30,3,31,3],[30,4,31,4],[30,5,30,12],[30,13,31,13],[51,0,51,13],[52,0,52,13],[53,0,53,11],[53,12,53,13],[54,0,55,0],[54,1,55,1],[54,2,55,2],[54,3,55,3],[54,4,55,4],[54,5,54,12],[54,13,55,13],[71,0,71,13],[72,0,72,13],[73,0,73,11],[73,12,73,13],[74,0,75,0],[74,1,75,1],[74,2,75,2],[74,3,75,3],[74,4,75,4],[74,5,74,12],[74,13,75,13]],"flags":["formulas_cached_only"]}
["分部分项工程量清单综合单价分析表",{"$nulls":13},""]
["",{"$nulls":13},""]
["工程名称：三明梅列区城投小溪施工变工程",{"$nulls":11},"第1页 共4页",null,""]
["序号","项目编码","项目名称及特征描述","单位","工程量","综合单价组成(元)",{"$nulls":7},"综合单价\r\n(元)",""]
[{"$nulls":5},"人工费","材料费","其中：\r\n设备费","施工机具使用费","企业管理费","利润","规费","税金",null,""]
["单项工程",{"$nulls":13},"单项工程(17安装)"]
["安装工程",{"$nulls":13},"单位工程(17安装)"]
["电气工程",{"$nulls":13},"分项工程(17安装)"]
["1","030410001001","电杆组立\r\n(1)砼\r\n(2)15m以下\r\n(3)户外式\r\n(4)平地\r\n(5)15m电杆","根",{"v":2,"d":"2.000"},2419.71,5731.44,null,595.71,858.02,576.02,null,1018.91,11199.82,""]
["","","锥形水泥杆  非预应力,整根杆,15m，190mm,M","根",{"v":2,"d":"2.000"},null,{"v":2401,"d":"2401.00"},null,null,{"v":235.3,"d":"235.30"},158.18,null,279.45,3073.93,""]
["","","柱式绝缘子 PS-15","只",{"v":25.25,"d":"25.250"},null,32.76,null,null,3.21,2.16,null,3.81,41.94,""]
["","","金组-46","串",{"v":6.06,"d":"6.060"},null,216.45,null,null,21.21,14.26,null,25.19,277.11,""]
["","","电缆接线端子 DT-150","只",{"v":8.08,"d":"8.080"},null,18.49,null,null,1.81,1.22,null,2.15,23.67,""]
["","","电缆接线端子 DTL-70","只",{"v":26.26,"d":"26.260"},null,{"v":3.9,"d":"3.90"},null,null,0.38,0.26,null,0.45,4.99,""]
["","","接地挂环 JDL-50-240","只",{"v":3.03,"d":"3.030"},null,30.38,null,null,2.98,{"v":2,"d":"2.00"},null,3.54,{"v":38.9,"d":"38.90"},""]
["","","PVC管 φ25","m",{"v":3.15,"d":"3.150"},null,2.42,null,null,0.24,0.16,null,0.28,{"v":3.1,"d":"3.10"},""]
["","","杆号牌","块",{"v":1,"d":"1.000"},null,45.28,null,null,4.44,2.98,null,5.27,57.97,""]
["","","安全标示牌","块",{"v":1,"d":"1.000"},null,{"v":55,"d":"55.00"},null,null,5.39,3.62,null,{"v":6.4,"d":"6.40"},70.41,""]
["","","配变标示牌","块",{"v":1,"d":"1.000"},null,{"v":55,"d":"55.00"},null,null,5.39,3.62,null,{"v":6.4,"d":"6.40"},70.41,""]
["","","综合箱标示牌","块",{"v":1,"d":"1.000"},null,{"v":55,"d":"55.00"},null,null,5.39,3.62,null,{"v":6.4,"d":"6.40"},70.41,""]
["","","相序牌","块",{"v":1,"d":"1.000"},null,{"v":52.5,"d":"52.50"},null,null,5.15,3.46,null,6.11,67.22,""]
["","","防火堵料","kg",{"v":5,"d":"5.000"},null,6.67,null,null,0.65,0.44,null,0.78,8.54,""]
["","","拉线 G-7","组",{"v":1.01,"d":"1.010"},null,{"v":561.6,"d":"561.60"},null,null,55.04,{"v":37,"d":"37.00"},null,65.36,{"v":719,"d":"719.00"},""]
["","","铁件","kg",432.019,null,{"v":7,"d":"7.00"},null,null,0.69,0.46,null,0.82,8.97,""]
["1.1","30411041","施工定位(单杆)","基",{"v":2,"d":"2.000"},20.97,74.72,null,2.14,9.59,6.45,null,11.39,125.26,""]
["1.2","30411070","基坑石方施工(松砂石 挖深≤3m)","m3",24.146,84.67,null,null,4.28,8.72,5.86,null,10.35,113.88,""]
["1.3","30411173T","混凝土杆组立(混凝土 分段式单基重量≤2.5","基",{"v":2,"d":"2.000"},418.41,7.84,null,231.89,{"v":64.5,"d":"64.50"},43.36,null,{"v":76.6,"d":"76.60"},{"v":842.6,"d":"842.60"},""]
["分部分项工程量清单综合单价分析表",{"$nulls":13},""]
["",{"$nulls":13},""]
["工程名称：三明梅列区城投小溪施工变工程",{"$nulls":11},"第2页 共4页",null,""]
["序号","项目编码","项目名称及特征描述","单位","工程量","综合单价组成(元)",{"$nulls":7},"综合单价\r\n(元)",""]
[{"$nulls":5},"人工费","材料费","其中：\r\n设备费","施工机具使用费","企业管理费","利润","规费","税金",null,""]
["","","t) 工程施工电杆小于或等于5基","",{"$nulls":10},""]
["1.4","30411219T","10kV及以下横担安装(铁、木横担 双根)","组",{"v":2,"d":"2.000"},36.29,3.72,null,5.35,4.45,2.99,null,5.28,58.08,""]
["1.5","30411238T","绝缘子安装(普通绝缘子)","只",{"v":12,"d":"12.000"},3.63,0.05,null,0.93,0.45,{"v":0.3,"d":"0.30"},null,0.54,{"v":5.9,"d":"5.90"},""]
["1.6","30411237T","绝缘子安装(耐张绝缘子)","片",{"v":12,"d":"12.000"},3.83,0.05,null,0.93,0.47,0.32,null,0.56,6.16,""]
["1.7","30409035T","硬塑(UPVC)管铺设(外径≤50mm)","m",{"v":3,"d":"3.000"},1.81,0.02,null,0.09,0.19,0.13,null,0.22,2.46,""]
["1.8","30409309T","电缆防火设施安装(防火堵料)","t",0.004,4541.14,269.31,null,null,471.42,316.91,null,559.88,6158.66,""]
["1.9","30411204T","拉线制作与安装(水平拉线 截面≤70mm2) 工程施工电杆小于或等于5基","根",{"v":1,"d":"1.000"},123.31,1.76,null,29.21,15.12,10.16,null,17.96,197.52,""]
["1.10","30411100T","预制基础(拉线盘安装 单块重量≤300kg)","块",{"v":1,"d":"1.000"},14.11,null,null,4.58,1.83,1.23,null,2.18,23.93,""]
["1.11","30407006","铁构件制作与安装(一般铁构件安装)","t",{"v":0.43,"d":"0.430"},3422.56,188.99,null,353.99,388.62,261.25,null,461.54,5076.95,""]
["1.12","30411009","汽车运输(混凝土杆装卸)","t",3.358,16.23,7.48,null,83.46,{"v":10.5,"d":"10.50"},7.06,null,12.47,{"v":137.2,"d":"137.20"},""]
["1.13","30411010","汽车运输(混凝土杆运输)","t·km",60.444,0.71,null,null,1.13,0.18,0.12,null,0.21,2.35,""]
["1.14","30411021","汽车运输(金具、绝缘子、零星钢材装卸)","t",0.763,18.65,null,null,48.03,6.53,4.39,null,7.76,85.36,""]
["1.15","30411022","汽车运输(金具、绝缘子、零星钢材运输)","t·km",13.734,0.71,null,null,1.13,0.18,0.12,null,0.21,2.35,""]
["2","040801001001","杆上变压器\r\n(1)杆上变压器\r\n(2)250kVA\r\n(3)10kV","台",{"v":1,"d":"1.000"},{"v":1222.3,"d":"1222.30"},32598.82,{"v":32526,"d":"32526.00"},662.61,191.86,128.98,null,3480.46,38285.03,""]
["","","杆上变压器 S11-250KVA","台",{"v":1,"d":"1.000"},null,{"v":32526,"d":"32526.00"},{"v":32526,"d":"32526.00"},{"$nulls":4},{"v":3252.6,"d":"3252.60"},{"v":35778.6,"d":"35778.60"},""]
["2.1","30411297","变压器安装(油浸式变压器 容量≤315kV·AkV·A以下)","台",{"v":1,"d":"1.000"},{"v":1222.3,"d":"1222.30"},72.82,null,662.61,191.86,128.98,null,227.86,2506.43,""]
["3","030414001001","电力变压器系统\r\n(1)变压器调试\r\n(2)10kV","系统",{"v":1,"d":"1.000"},639.68,{"v":11.1,"d":"11.10"},null,623.36,124.87,83.94,null,{"v":148.3,"d":"148.30"},1631.25,""]
["3.1","30417022","变压器系统调试(容量≤800kV·A)","系统",{"v":1,"d":"1.000"},639.68,{"v":11.1,"d":"11.10"},null,623.36,124.87,83.94,null,{"v":148.3,"d":"148.30"},1631.25,""]
["4","040801008001","杆上配电箱\r\n(1)杆上配电箱","台",{"v":1,"d":"1.000"},219.74,18092.77,{"v":18057,"d":"18057.00"},101.63,{"v":35,"d":"35.00"},23.53,null,1847.27,20319.94,""]
["分部分项工程量清单综合单价分析表",{"$nulls":13},""]
["",{"$nulls":13},""]
["工程名称：三明梅列区城投小溪施工变工程",{"$nulls":11},"第3页 共4页",null,""]
["序号","项目编码","项目名称及特征描述","单位","工程量","综合单价组成(元)",{"$nulls":7},"综合单价\r\n(元)",""]
[{"$nulls":5},"人工费","材料费","其中：\r\n设备费","施工机具使用费","企业管理费","利润","规费","税金",null,""]
["","","综合配电箱","台",{"v":1,"d":"1.000"},null,{"v":18057,"d":"18057.00"},{"v":18057,"d":"18057.00"},{"$nulls":4},{"v":1805.7,"d":"1805.70"},{"v":19862.7,"d":"19862.70"},""]
["4.1","30411305T","配电设备安装(配电箱)","台",{"v":1,"d":"1.000"},219.74,35.77,null,101.63,{"v":35,"d":"35.00"},23.53,null,41.57,457.24,""]
["5","040801017001","跌落式熔断器\r\n(1)跌落熔断器\r\n(2)杆上","组",{"v":1,"d":"1.000"},85.78,712.28,{"v":686.7,"d":"686.70"},14.98,12.38,8.32,null,83.37,917.11,""]
["","","跌落式开关","组",{"v":1,"d":"1.000"},null,{"v":686.7,"d":"686.70"},{"v":686.7,"d":"686.70"},{"$nulls":4},68.67,755.37,""]
["5.1","30411302","配电设备安装(跌落式熔断器)","组",{"v":1,"d":"1.000"},85.78,25.58,null,14.98,12.38,8.32,null,{"v":14.7,"d":"14.70"},161.74,""]
["6","030410003001","导线架设\r\n(1)平地\r\n(2)绝缘铝绞线\r\n(3)JKLYJ-10/50","km",0.279,673.14,{"v":5255.6,"d":"5255.60"},null,83.63,589.21,396.09,null,699.77,7697.42,""]
["","","绝缘铝绞线  JKLYJ-10/50","km",0.284,null,5089.89,null,null,498.81,335.32,null,{"v":592.4,"d":"592.40"},6516.42,""]
["6.1","30411255T","绝缘铝绞线架设(截面≤95mm2)","km",0.279,673.14,74.49,null,83.63,81.46,54.76,null,96.75,1064.23,""]
["7","030408001001","电力电缆\r\n(1)YJV\r\n(2)150mm2内\r\n(3)铜\r\n(4)低压电缆\r\n(5)0.4kV","m",{"v":10,"d":"10.000"},11.73,406.02,null,3.06,41.24,27.72,null,48.97,538.74,""]
["","","低压电力电缆  YJV22-1-4*150","m",{"v":10.1,"d":"10.100"},null,396.54,null,null,38.86,26.12,null,46.15,507.67,""]
["7.1","30409141T","室内铜芯电力电缆敷设(电缆截面≤240mm2)","m",{"v":10,"d":"10.000"},11.73,5.51,null,3.06,1.99,1.34,null,2.36,25.99,""]
["8","040803005001","电缆终端头\r\n(1)4*150\r\n(2)电缆终端头\r\n(3)YJV\r\n(4)0.4kV\r\n(5)铜","个",{"v":2,"d":"2.000"},246.25,239.94,null,null,47.65,32.03,null,56.59,622.46,""]
["","","1kV电缆终端头 4*150,户外终端,热缩","个",{"v":2.04,"d":"2.040"},null,85.92,null,null,8.42,5.66,null,{"v":10,"d":"10.00"},{"v":110,"d":"110.00"},""]
["8.1","30409267T","10kV以下室外热（冷）缩式铜芯电力电缆(电缆截面≤240mm2)","个",{"v":2,"d":"2.000"},246.25,{"v":152.3,"d":"152.30"},null,null,39.06,26.26,null,46.39,510.26,""]
["9","030409001001","接地极","根",{"v":13,"d":"13.000"},24.27,64.38,null,10.11,9.68,6.51,null,{"v":11.5,"d":"11.50"},126.45,""]
["分部分项工程量清单综合单价分析表",{"$nulls":13},""]
["",{"$nulls":13},""]
["工程名称：三明梅列区城投小溪施工变工程",{"$nulls":11},"第4页 共4页",null,""]
["序号","项目编码","项目名称及特征描述","单位","工程量","综合单价组成(元)",{"$nulls":7},"综合单价\r\n(元)",""]
[{"$nulls":5},"人工费","材料费","其中：\r\n设备费","施工机具使用费","企业管理费","利润","规费","税金",null,""]
["","","(1)L50X5X2500\r\n(2)接地角钢\r\n(3)坚土","",{"$nulls":10},""]
["9.1","30410053","接地极（板）制作与安装(角钢接地极 坚土)","根",{"v":13,"d":"13.000"},22.28,61.06,null,{"v":9.5,"d":"9.50"},{"v":9.1,"d":"9.10"},6.12,null,10.81,118.87,""]
["9.2","30410055","接地极（板）制作与安装(圆钢接地极 坚土)","根",{"v":1,"d":"1.000"},25.91,43.15,null,7.91,7.54,5.07,null,8.96,98.54,""]
["10","030409002001","接地母线\r\n(1)-50X5\r\n(2)接地扁钢","m",{"v":72,"d":"72.000"},24.09,12.95,null,{"v":0.4,"d":"0.40"},3.67,2.47,null,4.36,47.94,""]
["10.1","30410059","接地母线敷设(户外接地母线敷设)","m",{"v":72,"d":"72.000"},24.09,12.95,null,{"v":0.4,"d":"0.40"},3.67,2.47,null,4.36,47.94,""]
["11","030414011001","接地装置\r\n(1)接地网\r\n(2)接地网","系统",{"v":1,"d":"1.000"},551.17,33.86,null,40.88,61.34,41.24,null,72.85,801.34,""]
["11.1","30410086","接地系统测试(接地网)","系统",{"v":1,"d":"1.000"},551.17,33.86,null,40.88,61.34,41.24,null,72.85,801.34,""]
["12","030402006001","隔离开关\r\n(1)隔离开关\r\n(2)杆上\r\n(3)10kV","组",{"v":1,"d":"1.000"},345.14,1542.82,1514.74,100.31,46.41,{"v":31.2,"d":"31.20"},null,206.58,2272.46,""]
["","","隔离开关","组",{"v":1,"d":"1.000"},null,1514.74,1514.74,{"$nulls":4},151.47,1666.21,""]
["12.1","30411303","配电设备安装(隔离开关)","组",{"v":1,"d":"1.000"},345.14,28.08,null,100.31,46.41,{"v":31.2,"d":"31.20"},null,55.11,606.25,""]

{"sheet":"人工、材料设备、机械汇总表","index":9,"n_rows":143,"n_cols":8,"rows_kept":143,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,5],[2,6,2,7],[44,0,44,7],[45,0,45,7],[46,0,46,5],[46,6,46,7],[88,0,88,7],[89,0,89,7],[90,0,90,5],[90,6,90,7],[129,0,129,7],[130,0,130,7],[131,0,131,5],[131,6,131,7]],"flags":["formulas_cached_only"]}
["人工、材料设备、机械汇总表"]
[""]
["工程名称：三明梅列区城投小溪施工变工程",{"$nulls":5},"第1页 共4页"]
["序号","工料机编码","工料机名称","规格、型号等特殊要求","单位","数量","单价","合价"]
["一","","人工","","","","",0]
["1","00010040","定额人工费","","元","","",10750.89]
["二","","材料","","","","",""]
["1","01030001","镀锌铁丝","综合","kg",7.108,4.49,31.91]
["2","01050030","钢丝绳","Φ14.1-15","kg",0.514,{"v":10.5,"d":"10.50"},5.39]
["3","01090050","镀锌圆钢","Φ10～25","kg",{"v":4.02,"d":"4.020"},4.44,17.85]
["4","01090050","镀锌圆钢","Φ10～25","kg",{"v":12.06,"d":"12.060"},4.44,53.55]
["5","01130190","镀锌扁钢","综合","kg",{"v":3.51,"d":"3.510"},5.11,17.94]
["6","01130230","镀锌扁钢","40×4","kg",0.198,4.02,{"v":0.8,"d":"0.80"}]
["7","01470020","铝绑线","Φ3.2","m",34.821,0.31,10.79]
["8","01470020","铝绑线","Φ3.2","m",{"v":3.6,"d":"3.600"},0.27,0.97]
["9","01530010","封铅","含铅65% 锡35%","kg",{"v":0.2,"d":"0.200"},48.77,9.75]
["10","02070240","橡胶垫","δ2","m2",{"v":0.01,"d":"0.010"},3.33,0.03]
["11","02130010","聚四氟乙烯带","","kg",{"v":0.8,"d":"0.800"},55.56,44.45]
["12","02130120","三色塑料带","20mm×40m","m",{"v":0.2,"d":"0.200"},0.26,0.05]
["13","02270001","白布","","kg",{"v":0.62,"d":"0.620"},{"v":24.5,"d":"24.50"},15.19]
["14","02270001","白布","","kg",{"v":3.26,"d":"3.260"},{"v":24.5,"d":"24.50"},79.87]
["15","02270270","棉纱头","","kg",0.651,5.13,3.34]
["16","02270270","棉纱头","","kg",{"v":0.1,"d":"0.100"},3.69,0.37]
["17","02330010","草袋","","个",0.134,1.54,0.21]
["18","03010550","圆钉","","kg",{"v":0.02,"d":"0.020"},4.31,0.09]
["19","03015460","膨胀螺栓","M10","套",{"v":1.4,"d":"1.400"},0.48,0.67]
["20","03130280","焊锡丝","","kg",{"v":0.48,"d":"0.480"},21.37,10.26]
["21","03130650","焊锡膏","","kg",0.096,32.48,3.12]
["22","03130850","冲击钻头","Φ12","只",{"v":0.01,"d":"0.010"},7.18,0.07]
["23","03131120","钢锯条","","根",29.449,0.22,6.48]
["24","03131120","钢锯条","","根",{"v":1,"d":"1.000"},0.09,0.09]
["25","03131590","低碳钢焊条","综合","kg",{"v":12.01,"d":"12.010"},6.65,79.87]
["26","04030140","中砂","","m3",0.001,{"v":106.8,"d":"106.80"},0.06]
["27","05030650","板枋材","","m3",0.015,{"v":1581.2,"d":"1581.20"},24.22]
["28","05050090","胶木板","","kg",0.402,12.03,4.84]
["29","05250020","木桩","","个",{"v":10,"d":"10.000"},6.97,{"v":69.7,"d":"69.70"}]
["30","05350080","竹桩","","个",{"v":32,"d":"32.000"},2.39,76.48]
["31","13010001","调和漆","","kg",{"v":1.66,"d":"1.660"},8.42,13.98]
["32","13010001","调和漆","","kg",{"v":0.4,"d":"0.400"},9.45,3.78]
["33","13010150","酚醛磁漆","","kg",0.094,13.15,1.24]
["34","13010160","酚醛调和漆","","kg",0.086,6.41,0.55]
["35","13010370","沥青清漆","","kg",0.702,6.44,4.52]
["36","13050060","防锈漆","C53-1","kg",0.129,{"v":7.4,"d":"7.40"},0.95]
["37","13050070","防锈漆","红丹","kg",{"v":0.2,"d":"0.200"},11.79,2.36]
["人工、材料设备、机械汇总表"]
[""]
["工程名称：三明梅列区城投小溪施工变工程",{"$nulls":5},"第2页 共4页"]
["序号","工料机编码","工料机名称","规格、型号等特殊要求","单位","数量","单价","合价"]
["38","13050070","防锈漆","红丹","kg",{"v":0.1,"d":"0.100"},11.17,1.12]
["39","13050100","醇酸防锈漆","C53-1","kg",0.984,6.82,6.71]
["40","13050100","醇酸防锈漆","C53-1","kg",{"v":0.2,"d":"0.200"},7.61,1.52]
["41","13050220","沥青绝缘漆","","kg",{"v":0.02,"d":"0.020"},13.39,0.27]
["42","14030060","汽油","92#","kg",{"v":0.1,"d":"0.100"},8.18,0.82]
["43","14030060","汽油","92#","kg",{"v":2.88,"d":"2.880"},8.07,23.24]
["44","14030080","汽油","100#","kg",{"v":0.1,"d":"0.100"},8.07,0.81]
["45","14030080","汽油","100#","kg",0.361,8.07,2.91]
["46","14090010","电力复合酯","综合","kg",0.448,21.47,9.61]
["47","14090010","电力复合酯","综合","kg",{"v":0.05,"d":"0.050"},21.48,1.07]
["48","14330190","硬脂酸","一级","㎏",{"v":0.01,"d":"0.010"},7.13,0.07]
["49","14351200","金属清洁剂","","kg",{"v":1.38,"d":"1.380"},6.01,8.29]
["50","17250620","塑料软管","DE8","m",{"v":17.5,"d":"17.500"},0.33,5.78]
["51","18037100","固定卡子","Φ90","个",{"v":4.12,"d":"4.120"},1.83,7.54]
["52","27060030","钢管接地极","Φ50 2.5m","根",{"v":1.05,"d":"1.050"},39.32,41.29]
["53","27060040","角钢接地极","50×5 2.5m","根",{"v":13.65,"d":"13.650"},55.56,758.39]
["54","27060130","接地母线","","m",{"v":73.08,"d":"73.080"},{"v":12.5,"d":"12.50"},{"v":913.5,"d":"913.50"}]
["55","27170040","自粘性橡胶带","25×20000","卷",{"v":0.67,"d":"0.670"},13.68,9.17]
["56","27170170","自粘性塑料带","20×20000","卷",4.464,2.56,11.43]
["57","27170180","电气绝缘胶带","18mm×10m×0.13mm","卷",{"v":2.05,"d":"2.050"},4.27,8.75]
["58","28010390","镀锡裸铜软绞线","TJRX 16MM2","kg",{"v":0.7,"d":"0.700"},51.28,{"v":35.9,"d":"35.90"}]
["59","28031960","铜芯聚氯乙烯绝缘电线","BV-4","m",{"v":5.46,"d":"5.460"},2.15,11.74]
["60","28032120","铜芯橡皮绝缘电线","BX-2.5","m",1.339,1.28,1.71]
["61","29060680","镀锌电缆吊挂","3.0×100","套",{"v":0.62,"d":"0.620"},1.71,1.06]
["62","29090310","铜接线端子","DT-16","个",{"v":2.04,"d":"2.040"},1.52,{"v":3.1,"d":"3.10"}]
["63","29090400","铜接线端子","DT-240","个",{"v":6.12,"d":"6.120"},16.32,99.88]
["64","29250120","镀锌电缆卡子","3×100","套",{"v":2.34,"d":"2.340"},14.15,33.11]
["65","29270060","电缆敷设滚轮","","个",{"v":0.02,"d":"0.020"},256.41,5.13]
["66","29270070","电缆敷设牵引头","","只",{"v":0.01,"d":"0.010"},5.13,0.05]
["67","29270080","电缆敷设转向导轮","","个",{"v":0.01,"d":"0.010"},59.83,{"v":0.6,"d":"0.60"}]
["68","33010840","钢支架、平台及连接件","","kg",2.747,3.08,8.46]
["69","34110080","水","","m3",0.001,2.14]
["70","34130010","标志牌","塑料扁形","个",{"v":0.6,"d":"0.600"},0.85,0.51]
["71","37090001","钢垫板","","kg",{"v":4.08,"d":"4.080"},3.56,14.52]
["72","49010030","其他材料费","","%",16.413,{"v":1,"d":"1.00"},16.41]
["73","49011001","电缆接线端子 DTL-70","","只",{"v":26.26,"d":"26.260"},{"v":3.9,"d":"3.90"},102.41]
["74","49011001","金组-46","","串",{"v":6.06,"d":"6.060"},216.45,1311.69]
["75","49011002","防火堵料","","kg",{"v":5,"d":"5.000"},6.67,33.35]
["76","49011003","柱式绝缘子 PS-15","","只",{"v":25.25,"d":"25.250"},32.76,827.19]
["77","49011003","接地挂环 JDL-50-240","","只",{"v":3.03,"d":"3.030"},30.38,92.05]
["人工、材料设备、机械汇总表"]
[""]
["工程名称：三明梅列区城投小溪施工变工程",{"$nulls":5},"第3页 共4页"]
["序号","工料机编码","工料机名称","规格、型号等特殊要求","单位","数量","单价","合价"]
["78","49011004","拉线","G-7","组",{"v":1.01,"d":"1.010"},{"v":561.6,"d":"561.60"},567.22]
["79","49011011","杆号牌","","块",{"v":1,"d":"1.000"},45.28,45.28]
["80","49011014","低压电力电缆","YJV22-1-4*150","m",{"v":10.1,"d":"10.100"},396.54,4005.05]
["81","49011015","1kV电缆终端头","4*150,户外终端,热缩","个",{"v":2.04,"d":"2.040"},85.92,175.28]
["82","49011018","铁件","","kg",432.019,{"v":7,"d":"7.00"},3024.13]
["83","49011020","锥形水泥杆","非预应力,整根杆,15m，190mm,M","根",{"v":2,"d":"2.000"},{"v":2401,"d":"2401.00"},{"v":4802,"d":"4802.00"}]
["84","49011022","电缆接线端子","DT-150","只",{"v":8.08,"d":"8.080"},18.49,149.37]
["85","49011024","PVC管 φ25","","m",{"v":3.15,"d":"3.150"},2.42,7.62]
["86","49011025","安全标示牌","","块",{"v":1,"d":"1.000"},{"v":55,"d":"55.00"},{"v":55,"d":"55.00"}]
["87","49011025","配变标示牌","","块",{"v":1,"d":"1.000"},{"v":55,"d":"55.00"},{"v":55,"d":"55.00"}]
["88","49011025","综合箱标示牌","","块",{"v":1,"d":"1.000"},{"v":55,"d":"55.00"},{"v":55,"d":"55.00"}]
["89","49011025","相序牌","","块",{"v":1,"d":"1.000"},{"v":52.5,"d":"52.50"},{"v":52.5,"d":"52.50"}]
["90","49011028","绝缘铝绞线  JKLYJ-10/50","","km",0.284,5089.89,1445.53]
["三","","设备","","","","",""]
["1","79011001","杆上变压器","S11-250KVA","台",{"v":1,"d":"1.000"},{"v":32526,"d":"32526.00"},{"v":32526,"d":"32526.00"}]
["2","79011002","隔离开关","","组",{"v":1,"d":"1.000"},1514.74,1514.74]
["3","79011008","综合配电箱","","台",{"v":1,"d":"1.000"},{"v":18057,"d":"18057.00"},{"v":18057,"d":"18057.00"}]
["4","79011008","跌落式开关","","组",{"v":1,"d":"1.000"},{"v":686.7,"d":"686.70"},{"v":686.7,"d":"686.70"}]
["四","","施工机具","","","","",""]
["1","98030050","数字电桥","","台班",0.841,63.76,53.62]
["2","98050020","电容分压器交直流高压测量系统","TPFRC","台班",{"v":0.6,"d":"0.600"},122.39,73.43]
["3","98050110","万用表","手持式","台班",1.262,6.83,8.62]
["4","98050210","相序表","","台班",1.179,4.05,4.77]
["5","98070110","直流高压发生器","","台班",{"v":0.33,"d":"0.330"},{"v":110.6,"d":"110.60"},{"v":36.5,"d":"36.50"}]
["6","98110010","变压器绕组变形测试仪","","台班",1.171,52.96,62.02]
["7","98110020","变压器直流电阻测试仪","","台班",{"v":0.99,"d":"0.990"},20.01,19.81]
["8","98110100","高压绝缘电阻测试仪","","台班",1.456,39.84,{"v":58,"d":"58.00"}]
["9","98110150","交/直流低电阻测试仪","","台班",1.262,7.91,9.98]
["10","98110170","接地电阻测试仪","","台班",4.206,9.72,40.88]
["11","98130010","计时/计频器/校准器","","台班",1.262,170.02,214.57]
["12","98130030","数字频率计","","台班",1.262,{"v":30.5,"d":"30.50"},38.49]
["13","98230020","示波器","","台班",1.179,10.34,12.19]
["14","98370001","微机继电保护测试仪","","台班",0.841,213.84,179.84]
["15","98410030","高压试验变压器配套操作箱、调压器","","台班",{"v":1.17,"d":"1.170"},39.58,46.31]
["16","98410060","全自动变比组别测试仪","","台班",1.262,18.41,23.23]
["17","98470430","回路电阻测试仪","","台班",{"v":0.27,"d":"0.270"},20.01,{"v":5.4,"d":"5.40"}]
["18","98470750","光导抗干扰介损测量仪","智能型","台班",{"v":0.33,"d":"0.330"},38.73,12.78]
["人工、材料设备、机械汇总表"]
[""]
["工程名称：三明梅列区城投小溪施工变工程",{"$nulls":5},"第4页 共4页"]
["序号","工料机编码","工料机名称","规格、型号等特殊要求","单位","数量","单价","合价"]
["19","99070510","载货汽车","装载质量4t","台班",0.874,371.59,324.62]
["20","99070520","载货汽车","装载质量5t","台班",0.514,377.26,193.93]
["21","99090310","汽车式起重机","提升质量8t","台班",0.573,{"v":609.3,"d":"609.30"},348.99]
["22","99090320","汽车式起重机","提升质量10t","台班",0.032,678.39,21.57]
["23","99110030","小型工程车","","台班",1.465,534.99,783.75]
["24","99191220","台式砂轮机","","台班",0.006,{"v":46,"d":"46.00"},0.28]
["25","99191450","液压压接机","100t","台班",0.023,103.97,2.44]
["26","99250001","交流弧焊机","容量21kVA","台班",5.556,56.53,314.09]
["27","99390040","试验变压器","YDQ 充气式","台班",{"v":0.6,"d":"0.600"},56.58,33.95]
["28","99450610","机动绞磨","3t","台班",0.213,117.69,25.09]