{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["1楼及3楼车间工程量"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"1楼及3楼车间工程量","index":0,"n_rows":101,"n_cols":7,"rows_kept":101,"merged":[[0,0,0,6],[2,0,2,6],[3,0,3,6],[10,0,10,6],[23,0,23,6],[24,0,24,6],[33,0,33,6],[41,6,42,6],[53,0,53,6],[62,0,62,6],[69,4,70,5],[83,0,83,6],[85,6,90,6],[97,2,97,4],[98,2,98,4],[99,2,99,4],[100,2,100,4]]}
["深九电器光明分厂车间及仓库部分区域装修改造工程清单"]
["序号","品名规格","单位","工程量","单价（元）","小计","备注"]
["深九电器光明分厂1楼库房改造工程量清单"]
["一、拆除部分"]
[1,"铁网","M2",{"$f":"52+94","v":{"v":146,"d":"146.00"}},{"v":0,"d":"0.00"},{"$f":"D5*E5","v":{"v":0,"d":"0.00"}},"两扇铁网拆除"]
[2,"开门洞","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"$f":"D6*E6","v":{"v":0,"d":"0.00"}},"扩一个2*2.2米的门洞"]
[3,"1楼大门扩宽","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"$f":"D7*E7","v":{"v":0,"d":"0.00"}},"需能放入1.8米宽，2.2米高的门"]
[4,"1楼内货台拆除","M3",{"$f":"4.2*1.83*1.3","v":{"v":9.9918,"d":"9.99"}},{"v":0,"d":"0.00"},{"$f":"D8*E8","v":{"v":0,"d":"0.00"}},"需要拆除4.2*1.83*1.3米的货台"]
[5,"1楼外货台拆除","M3",{"$f":"0.9*4.2*1.3","v":{"v":4.914,"d":"4.91"}},{"v":0,"d":"0.00"},{"$f":"D9*E9","v":{"v":0,"d":"0.00"}},"需要拆除0.9*4.2*1.3米的货台"]
[null,"小计",{"$nulls":3},{"$f":"SUM(F5:F9)","v":{"v":0,"d":"0.00"}}]
["二、装修部分"]
[1,"4号货梯环保砖砌墙隔间180*600*200","M2",60.26,{"v":0,"d":"0.00"},{"$f":"D12*E12","v":{"v":0,"d":"0.00"}},"（含1个门洞，能放入1.8米宽，2.2米高的门）以及挂网批沙批灰"]
[2,"防火卷闸门环保砖砌墙180*600*200","M2",{"$f":"4*4","v":{"v":16,"d":"16.00"}},{"v":0,"d":"0.00"},{"$f":"D13*E13","v":{"v":0,"d":"0.00"}},"挂网批沙批灰"]
[3,"新墙墙面乳胶漆","M2",{"v":402.5,"d":"402.50"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"腻子粉两遍，打磨、面刷立邦环保工程漆"]
[4,"北面IQC房间环保砖砌隔墙180*600*200","M2",49.04,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"挂网批沙批灰"]
[5,"北面大门环保砖砌墙隔间180*600*200","M2",{"v":125,"d":"125.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"（含一个门洞，能放入1.8米宽，2.2米高的门）以及挂网批沙批灰"]
[6,"构造柱","M",{"v":52.9,"d":"52.90"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"含支模、螺纹钢、混凝土及人工费用"]
[7,"构造梁","M",{"v":52,"d":"52.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"含支模、螺纹钢、混凝土及人工费用"]
[8,"门密码锁（利旧）","套",{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"利用现有的密码锁安装"]
[9,"双开防火门甲级","膛",{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"要求1.8米宽，2.2米高，附甲级防火合格证书。（1800*2200为不含门框尺寸）"]
[10,"北大门外斜坡","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"水泥填充"]
[11,"外货台楼梯","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"外货台凿一个0.7米宽楼梯"]
[null,"小计",{"$nulls":3},{"$f":"SUM(F12:F22)","v":{"v":0,"d":"0.00"}}]
["深九电器光明分厂3楼车间+仓库改造参考工程量清单"]
["一、拆除部分"]
[1,"拆除实墙","M2",{"$f":"8*4.6+20.93-3.6-3.6+4.8","v":55.33},{"v":0,"d":"0.00"},{"$f":"D26*E26","v":{"v":0,"d":"0.00"}},"两堵墙，总长4.55+8+4.8米，高4.8米，\n扣除两个门洞"]
[2,"扩门洞","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"$f":"D27*E27","v":{"v":0,"d":"0.00"}},"扩能放入1.8米宽，2.2米高的门"]
[3,"开门洞","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"开能放入1.8米宽，2.2米高的门"]
[4,"天花拆除","M2",{"v":345,"d":"345.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"天花拆除及打包"]
[5,"地面拆除","M2",{"v":345,"d":"345.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"地面拆除及打包"]
[6,"拆风淋房","间",{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"2扇风淋门拆除"]
[7,"空调拆除","台",{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"1楼一个，2楼一个"]
[null,"小计",{"$nulls":3},{"$f":"SUM(F26:F32)","v":{"v":0,"d":"0.00"}}]
["二、装修部分"]
[1,"补风淋门门洞，包含风淋门拆除后的天花及墙面恢复","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"$f":"D35*E35","v":{"v":0,"d":"0.00"}},"1米宽，2米高，环保砖砌墙150*600*200（挂网批沙批灰）"]
[2,"环保砖砌墙150*600*200","M2",54.53,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"两堵墙，总长4.55+8米，高4.8米（含两个门洞，能放入1.8米宽，2.2米高的门）以及挂网批沙批灰"]
[3,"墙面乳胶漆","M2",{"v":109,"d":"109.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"腻子粉两遍，打磨、面刷立邦环保工程漆"]
[4,"构造柱","根",{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"含支模、螺纹钢、混凝土及人工费用"]
[5,"双开防火门甲级","膛",{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"要求1.8米宽，2.2米高。带证"]
[6,"双开防火门甲级（利旧拆装）","膛",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"利旧安装（风淋门拆除后区域使用）"]
[7,"门密码锁（利旧）","套",{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"利旧设备现有的密码锁安装包含调试"]
[8,"照明线路铺设","M2",{"v":405,"d":"405.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"九洲电工同步安装，需要配合"]
[9,"防爆灯安装利旧","个",{"v":47,"d":"47.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[10,"新做600*600天花吊顶","M2",{"v":405,"d":"405.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"无尘板，厚度9mm，加厚龙骨0.6mm，吊杆安装"]
[11,"防静电PVC地胶铺设","M2",{"v":405,"d":"405.00"},{"v":0,"d":"0.00"},{"$f":"D45*E45","v":{"v":0,"d":"0.00"}},"厚度 2.0mm 尺寸 600x600mm，含铜箔，能过防静电接地检测"]
[12,"消防放水费","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"消防放水费"]
[13,"风管房空调电箱及空开","套",{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"风管房空调主电箱及空开，和成品暂存区主电线及空开"]
[14,"风管房、成品暂存区空调拉主电","M",{"v":65,"d":"65.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"电缆线  4*25+1*16  成品暂存区主电安装使用，风管房主电利旧"]
[15,"空调电源","M",{"v":283,"d":"283.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"4平方电线，PVC套管材料及人工"]
[16,"空调电源","M",{"v":510,"d":"510.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"2.5平方电线，PVC套管材料及人工"]
[17,"消防栓改方向","项",{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"电子仓从墙面改到柱头，成品暂存区从背面改正面"]
[18,"窗户隔热","平方",{"$f":"3*2+4*2+6*2*2+12*2+7*2+7.2*2","v":{"v":90.4,"d":"90.40"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"隔热反射膜，窗户规格：3*2*1 4*2*1   6*2*2 12*2*1  7*2*1 7.2*2*1"]
[null,"小计",{"$nulls":3},{"$f":"SUM(F35:F52)","v":{"v":0,"d":"0.00"}}]
["三、新装空调部分"]
[1,"5匹天花机","台",{"v":12,"d":"12.00"},{"v":0,"d":"0.00"},{"$f":"D55*E55","v":{"v":0,"d":"0.00"}},"5匹天花机（建议格力与美的），报价需提供空调品牌"]
[2,"铜管","M",{"$f":"148+160","v":{"v":308,"d":"308.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"铜管"]
[3,"水管","M",{"$f":"60+80","v":{"v":140,"d":"140.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"PVC排水管，含保温棉"]
[4,"墙孔","个",{"$f":"12*2","v":{"v":24,"d":"24.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"墙面打孔孔"]
[5,"内机吊架","付",{"v":12,"d":"12.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"内机吊架"]
[6,"外机不锈钢架","付",{"v":12,"d":"12.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"外机不锈钢架"]
[7,"高空费","台",{"v":12,"d":"12.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"高空作业费"]
[null,"小计",{"$nulls":3},{"$f":"SUM(F55:F61)","v":{"v":0,"d":"0.00"}}]
["四、旧机安装"]
[1,"5P天花机机安装","台",{"v":6,"d":"6.00"},{"v":0,"d":"0.00"},{"$f":"E64*D64","v":{"v":0,"d":"0.00"}},"5P天花机安装（其中有1台安装到1楼）"]
[2,"1.5P挂式空调机安装","台",{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"$f":"E65*D65","v":{"v":0,"d":"0.00"}},"1.5P挂式空调机安装"]
[3,"3P柜机安装","台",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"3P柜机安装"]
[4,"5P柜机安装","台",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"5P柜机安装"]
[5,"清洗","台",{"v":12,"d":"12.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"清洗"]
[6,"5P机铜管（4台外移机器用）","M",{"v":10,"d":"10.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"5P外移机铜管"]
[7,"5P机铜管","M",{"v":166,"d":"166.00"},"不参与报价，若利旧铜管无法使用，额外走工程量变更",null,"5P机铜管，本次报价不包含，优先利旧"]
[8,"3P机铜管","M",{"v":24,"d":"24.00"},null,null,"3P机铜管，本次报价不包含，优先利旧"]
[9,"1.5P机铜管","M",{"v":65,"d":"65.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"1.5P机空调"]
[10,"墙孔","个",{"v":16,"d":"16.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"墙面打孔"]
[11,"排水管","M",{"v":87,"d":"87.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"PVC排水管，含保温棉"]
[12,"拆装5P外机","台",{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"拆装5P外机"]
[13,"5P不锈钢架","付",{"v":11,"d":"11.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"5P不锈钢架"]
[14,"3P不锈钢架","付",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"3P不锈钢架"]
[15,"1.5P不锈钢架","付",{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"2P不锈钢架"]
[17,"冷媒","台",{"v":12,"d":"12.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"冷媒"]
[18,"高空作业","台",{"v":11,"d":"11.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"高空作业"]
[19,"高空作业吊车","台",{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"高空作业吊车（2天完工）"]
[20,"提升水泵","台",{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"提升水泵"]
[null,"小计",{"$nulls":3},{"$f":"SUM(F64:F82)","v":{"v":0,"d":"0.00"}}]
["五、其他工程"]
[1,"垃圾外运","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"$f":"E85*D85","v":{"v":0,"d":"0.00"}},"垃圾外运至指定填埋场"]
[2,"六类千兆网线305米/箱","箱",{"v":5,"d":"5.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"网络、监控、办公用电恢复使用，物品交付，由九洲电工自行安装"]
[4,"5×450白色扎带（250根/包）","包",{"v":10,"d":"10.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[5,"6类水晶头 100个/盒","盒",{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[6,"2.5平方铜线-红（100米）","卷",{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[7,"2.5平方铜线-蓝（100米）","卷",{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[8,"2.5平方铜线-黄绿（100米）","卷",{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[9,"成品保护费","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"通道成品保护费"]
[10,"材料搬运","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"装修材料搬运至施工现场"]
[11,"施工措施费","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"高空搭架及局部成品保护"]
[12,"工程保险费","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"工程保险费"]
[13,"卫生费","项",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"完工粗保洁卫生费（精细卫生由业主方负责）"]
[null,"小计",{"$nulls":3},{"$f":"SUM(F85:F96)","v":{"v":0,"d":"0.00"}}]
["A","合计",{"$nulls":3},{"$f":"F10+F23+F33+F53+F62+F83+F97","v":0},"1楼及3楼工程直接造价"]
["B","工程管理费",{"v":0.03,"d":"3%"},null,null,{"$f":"SUM(F98*3%)","v":0},"施工组织管理费"]
["C","税金",{"v":0.09,"d":"9%"},null,null,{"$f":"SUM(F98*9%)","v":0},"税金"]
[null,"工程总造价","A+B+C",null,null,{"$f":"SUM(F98:F100)","v":0},"工程含税总造价"]