{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["封-1 工程预算书","表-02 安装工程预(结)算表","表-03 价差汇总表","表-04 工程造价取费表-多专业"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"封-1 工程预算书","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"merged":[[1,0,1,5],[3,2,3,4],[5,2,5,4],[6,2,6,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[14,2,14,3]],"flags":["formulas_cached_only"]}
["","","","","",""]
["工 程 预 算 书","","","","",""]
["","","","","",""]
["","工程名称：","校内变电站更换一台变压器工程","","",""]
["","","","","",""]
["","预算造价(大写)：","壹拾肆万捌仟陆佰捌拾壹元陆角捌分","","",""]
["","(小写)：",148681.68,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},""]
["","","","","",""]
["","施工单位:","","","",""]
["","","(单位盖章)","","",""]
["","  法定代表人\r\n   或其授权人:","","","",""]
["","","(签字盖章)","","",""]
["","编制人:","","复核人:","",""]
["","","(造价人员签字盖执业章)","","(造价人员签字盖执业章)",""]
["","编制时间:","2022-05-12","","",""]
["","","","","",""]
["","","","","",""]

{"sheet":"表-02 安装工程预(结)算表","index":1,"n_rows":22,"n_cols":14,"rows_kept":22,"merged":[[1,0,1,13],[2,0,2,2],[2,12,2,13],[3,0,5,0],[3,1,5,1],[3,2,5,2],[3,3,5,3],[3,4,5,4],[3,5,3,6],[3,7,3,8],[3,9,3,13],[4,5,5,5],[4,7,5,7],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[7,7,8,7],[7,8,8,8],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[11,7,12,7],[11,8,12,8],[19,0,19,2],[19,9,19,13],[20,0,20,2],[20,9,20,13]],"flags":["formulas_cached_only"]}
["","","","","","","","","","","","","",""]
["安装工程预(结)算表","","","","","","","","","","","","",""]
["工程名称: 校内变电站更换一台变压器工程","","","","","","","","","","","","第1页、共1页",""]
["序号","定额编号","项目名称及规格","单位","数量","单  价","","合  价","","主   材   设   备","","","",""]
["","","","","","基价","其中","基价","其中","名  称","单位","数量","单价","主材"]
["","","","","","","工资","","工资","","","","","设备费"]
["","","分部分项工程和单价措施项目费\r\n","",{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},25415.07,4369.26,"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},112776.25]
["1","4-1-4","油浸式变压器安装 容量 S13-1250kV·A 全铜线圈","台",{"v":1,"d":"1.000"},3468.67,2137.75,3468.67,2137.75,"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["","","","",{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"油浸式变压器安装 容量 S13-1250kV·A 全铜线圈","台",{"v":1,"d":"1.000"},{"v":111400,"d":"111400.00"},{"v":111400,"d":"111400.00"}]
["2","4-9-289","电力电缆终端头制作与安装 10kV以下室外热(冷) 缩式铜芯电力电缆 电缆截面(mm2) ≤120","个",{"v":1,"d":"1.000"},262.35,170.85,262.35,170.85,"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["","","","",{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"户外热缩式电缆终端头","套",{"v":1.02,"d":"1.020"},{"v":1300,"d":"1300.00"},{"v":1326,"d":"1326.00"}]
["3","4-8-27","滑触线支架安装 3横架式支架 螺栓固定","副",{"v":1,"d":"1.000"},125.33,16.15,125.33,16.15,"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["","","","",{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"滑触线支架","副",1.005,{"v":50,"d":"50.00"},50.25]
["4","4-17-23","变压器系统调试 容量(kV·A) ≤2000","系统",{"v":1,"d":"1.000"},2878.72,1364.51,2878.72,1364.51,"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["5","估价","变压器至柜体铜排 TMY 3*10*100(主材价暂估)","m",{"v":10,"d":"10.000"},{"v":1500,"d":"1500.00"},{"v":0,"d":"0.00"},{"v":15000,"d":"15000.00"},{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["6","估价","吊装拆除原变压器 100T 吊车","项",{"v":1,"d":"1.000"},{"v":2500,"d":"2500.00"},{"v":0,"d":"0.00"},{"v":2500,"d":"2500.00"},{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["7","估价","原电缆端头拆装、电缆敷设","项",{"v":1,"d":"1.000"},{"v":500,"d":"500.00"},{"v":0,"d":"0.00"},{"v":500,"d":"500.00"},{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["8","估价","人工打洞、破混凝土散水及恢复","工日",{"v":8,"d":"8.000"},{"v":85,"d":"85.00"},{"v":85,"d":"85.00"},{"v":680,"d":"680.00"},{"v":680,"d":"680.00"},"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["","","合计","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},25415.07,4369.26,{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},112776.25]
["造 价 员 签 字:","","","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["","","","","","","","","","表-02","","","",""]
["","","","","","","","","","","","","",""]

{"sheet":"表-03 价差汇总表","index":2,"n_rows":13,"n_cols":9,"rows_kept":13,"merged":[[1,0,1,8],[2,0,2,4],[2,5,2,6],[2,7,2,8]],"flags":["formulas_cached_only"]}
["","","","","","","","",""]
["价 差 汇 总 表","","","","","","","",""]
["工程名称:校内变电站更换一台变压器工程","","","","","建筑面积:m2","","第1页、共1页",""]
["序号","材料编码","材料名称","单位","数量","定额价","市场价","价格差","合价"]
["1","00010104","综合工日","工日",51.403,{"v":85,"d":"85.00"},{"v":100,"d":"100.00"},{"v":15,"d":"15.00"},771.05]
["2","RG","人工","工日",1.633,{"v":85,"d":"85.00"},{"v":100,"d":"100.00"},{"v":15,"d":"15.00"},24.49]
["3","14030121","汽油(综合)","kg",{"v":2.46,"d":"2.460"},7.28,11.11,3.83,9.42]
["4","18250213","固定卡子 φ90","个",{"v":2.06,"d":"2.060"},1.84,{"v":12,"d":"12.00"},10.16,20.93]
["5","29090239","铜接线端子 DT-16mm2","个",{"v":1.02,"d":"1.020"},2.49,{"v":15,"d":"15.00"},12.51,12.76]
["6","CY","柴油","kg",22.778,6.45,9.25,{"v":2.8,"d":"2.80"},63.78]
["","","合计",{"v":0,"d":"0.00"},{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},902.42]
["","","","","","","","",""]
["","","","","","","","","表-03"]

{"sheet":"表-04 工程造价取费表-多专业","index":3,"n_rows":76,"n_cols":5,"rows_kept":76,"merged":[[1,0,1,4],[2,0,2,2],[2,3,2,4],[35,0,35,1],[35,2,35,4],[38,0,38,4],[39,0,39,2],[39,3,39,4],[74,0,74,1],[74,2,74,4]],"flags":["formulas_cached_only"]}
["","","","",""]
["工 程 造 价 取 费 表","","","",""]
["工程名称:校内变电站更换一台变压器工程","","","第1页、共2页",""]
["序号","名称","计  算  式","费率(%)","金额"]
["","安装工程","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["一","分部分项工程费","∑(工程量×消耗量定额基价)","",137511.32]
["1","其中：定额人工费","∑(工日消耗量×定额人工单价)","",3689.26]
["2","      定额材料费","∑(材料消耗量×定额材料单价)","",18431.19]
["3","      定额机械费","∑(机械消耗量×定额机械台班单价)","",2614.62]
["4","      定额主材费","∑(主材消耗量×定额主材单价)","",112776.25]
["5","      定额设备费","∑(设备消耗量×定额设备单价)","",{"v":0,"d":"0.00"}]
["二","单价措施项费","∑(工程量×消耗量定额基价)","",{"v":0,"d":"0.00"}]
["6","其中：定额人工费","∑(工日消耗量×定额人工单价)","",{"v":0,"d":"0.00"}]
["7","      定额材料费","∑(材料消耗量×定额材料单价)","",{"v":0,"d":"0.00"}]
["8","      定额机械费","∑(机械消耗量×定额机械台班单价)","",{"v":0,"d":"0.00"}]
["9","      定额主材费","∑(主材消耗量×定额主材单价)","",{"v":0,"d":"0.00"}]
["10","      定额设备费","∑(设备消耗量×定额设备单价)","",{"v":0,"d":"0.00"}]
["三","其他项目费","∑其他项目费","",{"v":2000,"d":"2000.00"}]
["四","总价措施费","[(1)+(6)]×相应费率","",336.43]
["11","安全文明环保","[(1)+(6)]×相应费率","9.119098",336.43]
["12","临时设施费","[(1)+(6)]×相应费率","3.903651",{"v":0,"d":"0.00"}]
["13","其他总价措施","[(1)+(6)]×相应费率","3.194858",{"v":0,"d":"0.00"}]
["五","企业管理费","[(1)+(6)]×相应费率","13.404704",494.53]
["六","利润","[(1)+(6)]×相应费率","11.13",410.61]
["七","人材机价差","∑(数量×价差)","",782.41]
["八","规费","[(1)+(3)+(6)+(8)]×相应费率","",997.28]
["14","社会保险费","[(1)+(3)+(6)+(8)]×相应费率","12.5",787.99]
["15","住房公积金","[(1)+(3)+(6)+(8)]×相应费率","3.16",{"v":199.2,"d":"199.20"}]
["16","工程排污费","[(1)+(3)+(6)+(8)]×相应费率","0.16",10.09]
["九","估价项目","∑估价项目","",{"v":0,"d":"0.00"}]
["十","税金","[(一)+(二)+(三)+(四)+(五)+(六)+(七)+(八)+(九)]×(征收率+附加税)","3.36",4789.09]
["十一","不取费","∑不取费项目","",{"v":0,"d":"0.00"}]
["十二","总价下浮","∑总价下浮","",{"v":0,"d":"0.00"}]
["十三","安装造价合计","(一)+(二)+(三)+(四)+(五)+(六)+(七)+(八)+(九)+(十)+(十一)+(十二)","",147321.67]
["","总计","","1",148681.68]
["造价员盖执业章:","","表-04","",{"v":0,"d":"0.00"}]
["","","","",{"v":0,"d":"0.00"}]
["","","","",""]
["工 程 造 价 取 费 表","","","",""]
["工程名称:校内变电站更换一台变压器工程","","","第2页、共2页",""]
["序号","名称","计  算  式","费率(%)","金额"]
["","安装工程造价合计","","",{"v":0,"d":"0.000"}]
["","建筑工程","",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["一","分部分项工程费","∑(工程量×消耗量定额基价)","",{"v":680,"d":"680.00"}]
["1","其中：定额人工费","∑(工日消耗量×定额人工单价)","",{"v":680,"d":"680.00"}]
["2","      定额材料费","∑(材料消耗量×定额材料单价)","",{"v":0,"d":"0.00"}]
["3","      定额机械费","∑(机械消耗量×定额机械台班单价)","",{"v":0,"d":"0.00"}]
["4","      定额主材费","∑(主材消耗量×定额主材单价)","",{"v":0,"d":"0.00"}]
["5","      定额设备费","∑(设备消耗量×定额设备单价)","",{"v":0,"d":"0.00"}]
["二","单价措施项费","∑(工程量×消耗量定额基价)","",{"v":0,"d":"0.00"}]
["6","其中：定额人工费","∑(工日消耗量×定额人工单价)","",{"v":0,"d":"0.00"}]
["7","      定额材料费","∑(材料消耗量×定额材料单价)","",{"v":0,"d":"0.00"}]
["8","      定额机械费","∑(机械消耗量×定额机械台班单价)","",{"v":0,"d":"0.00"}]
["9","      定额主材费","∑(主材消耗量×定额主材单价)","",{"v":0,"d":"0.00"}]
["10","      定额设备费","∑(设备消耗量×定额设备单价)","",{"v":0,"d":"0.00"}]
["三","其他项目费","∑其他项目费","",{"v":0,"d":"0.00"}]
["四","总价措施费","[(1)+(6)]×相应费率","",132.37]
["11","安全文明环保","[(1)+(6)]×相应费率","10.79058",73.38]
["12","临时设施费","[(1)+(6)]×相应费率","4.273916",29.06]
["13","其他总价措施","[(1)+(6)]×相应费率","4.400864",29.93]
["14","扬尘治理措施费","[(1)+(6)]×相应费率","",{"v":0,"d":"0.00"}]
["五","企业管理费","[(1)+(6)]×相应费率","23.795393",161.81]
["六","利润","[(1)+(6)]×相应费率","15.99",108.73]
["七","人材机价差","∑(数量×价差)","",{"v":120,"d":"120.00"}]
["八","规费","[(1)+(3)+(6)+(8)]×相应费率","",112.89]
["15","社会保险费","[(1)+(3)+(6)+(8)]×相应费率","13.11",89.15]
["16","住房公积金","[(1)+(3)+(6)+(8)]×相应费率","3.32",22.58]
["17","工程排污费","[(1)+(3)+(6)+(8)]×相应费率","0.17",1.16]
["九","估价项目","∑估价项目","",{"v":0,"d":"0.00"}]
["十","税金","[(一)+(二)+(三)+(四)+(五)+(六)+(七)+(八)+(九)]×(征收率+附加税)","3.36",44.21]
["十一","不取费","∑不取费项目","",{"v":0,"d":"0.00"}]
["十二","总价下浮","∑总价下浮","",{"v":0,"d":"0.00"}]
["十三","建筑造价合计","(一)+(二)+(三)+(四)+(五)+(六)+(七)+(八)+(九)+(十)+(十一)+(十二)","",1360.01]
["","总计","","",148681.68]
["造价员盖执业章:","","表-04","",{"v":0,"d":"0.00"}]
["","","","",{"v":0,"d":"0.00"}]