{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["安装","支撑的使用分析表"],"not_rendered":{"external_links":1,"defined_names":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"安装","index":0,"n_rows":79,"n_cols":10,"rows_kept":79,"merged":[[0,0,0,9],[1,8,1,9],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,2,7],[2,8,3,8],[2,9,3,9],[53,0,53,1],[54,0,54,1],[55,0,55,1],[56,0,56,9],[57,8,57,9],[58,0,59,0],[58,1,59,1],[58,2,59,2],[58,3,59,3],[58,4,59,4],[58,5,59,5],[58,6,58,7],[58,8,59,8],[58,9,59,9],[78,0,78,9]],"flags":["formulas_cached_only"]}
["泰和县马市生态文化旅游特色小镇项目-风貌区景观提升安装劳务工程"]
[{"$nulls":8},"单位：元"]
["序号","工作内容","任务内容描述\n（包括但不限于以下工作内容）","单位","暂定\n工程量","不含税控制\n单价","不含税综合单价组成明细",null,"合价","备注"]
[{"$nulls":6},"劳务费","主材费"]
[null,"安装"]
[null,"灌溉给水"]
[1,"塑料管","喷灌给水管\r\n1.HDPE给水管DN165\r\n2.热熔连接\r\n3.管道冲洗消毒","m",{"v":12.1,"d":"12.10"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"管材主材甲供"]
[2,"塑料管","喷灌给水管\r\n1.HDPE给水管DN100\r\n2.热熔连接\r\n3.管道冲洗消毒","m",{"v":1272.3,"d":"1272.30"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"管材主材甲供"]
[3,"塑料管","喷灌给水管\r\n1.HDPE给水管DN80\r\n2.热熔连接\r\n3.管道冲洗消毒","m",{"v":1671.2,"d":"1671.20"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"管材主材甲供"]
[5,"塑料管","喷灌给水管\r\n1.HDPE给水管DN50\r\n2.热熔连接\r\n3.管道冲洗消毒","m",{"v":51.7,"d":"51.70"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"管材主材甲供"]
[8,"阀门","1.电磁阀DN100\r\n2.YC1419阀箱","个",{"v":6,"d":"6.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"阀门主材甲供"]
[9,"阀门","1.电磁阀DN80\r\n2.YC1419阀箱","个",{"v":14,"d":"14.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"阀门主材甲供"]
[10,"阀门","1.电磁阀DN50\r\n2.YC1419阀箱","个",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"阀门主材甲供"]
[11,"阀门","1.电磁阀DN65\r\n2.YC1419阀箱","个",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"阀门主材甲供"]
[12,"快速取水器","1.快速取水器\n2.YC708阀箱","个",{"v":29,"d":"29.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"阀门主材甲供"]
[13,"阀门","1.自动泄水阀DN25\n2.YC930阀箱","个",{"v":21,"d":"21.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"阀门主材甲供"]
[17,"喷灌配件安装","1.埋地式5004旋转喷头\r\n2.1/2千秋架","个",{"v":153,"d":"153.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"喷头主材甲供"]
[19,"挖沟槽土方","挖沟槽土方/三类土","m3",2052.38,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[20,"回填方","槽坑 天然砂","m3",384.82,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[21,"回填方","机械填土夯实 槽、坑","m3",1667.56,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"室外给排水","","",""]
[22,"塑料管","室外给水管\r\n1.钢丝网骨架（PE）塑料复合管DN65，SN8级\r\n2.电熔连接\r\n3.管道冲洗消毒","m",79.71,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"管材主材甲供"]
[23,"塑料管","污水管\r\n1.HDPE双壁波纹管De225，SN8级\r\n2.橡胶圈接口\r\n3.管道闭水试验","m",209.38,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"管材主材甲供"]
[24,"塑料管","污水管\r\n1.HDPE双壁波纹管De110，SN8级\r\n2.橡胶圈接口\r\n3.管道闭水试验","m",{"v":1.4,"d":"1.40"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"管材主材甲供"]
[25,"塑料管","雨水管\r\n1.HDPE双壁波纹管De500，SN8级\r\n2.橡胶圈接口","m",{"v":135.6,"d":"135.60"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"管材主材甲供"]
[26,"塑料管","雨水管\n1.HDPE双壁波纹管De400，SN8级 2.橡胶圈接口","m",{"v":91.7,"d":"91.70"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"管材主材甲供"]
[27,"塑料管","雨水管\r\n1.HDPE双壁波纹管De300，SN8级\r\n2.橡胶圈接口","m",120.96,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"管材主材甲供"]
[28,"塑料管","雨水管\r\n1.HDPE双壁波纹管De225，SN8级\r\n2.橡胶圈接口","m",324.71,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"管材主材甲供"]
[29,"阀门","1.闸阀DN65\r\n2.沟槽法兰","个",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"阀门主材甲供"]
[30,"阀门","1.止回阀DN65","个",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"阀门主材甲供"]
[31,"水表","1.水表DN40","个",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"水表主材甲供"]
[32,"混凝土井","1.水表井","座",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"包工包料"]
[33,"整体化粪池","玻璃钢化粪池YJBH-I-II","座",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"玻璃钢甲供"]
[34,"塑料检查井","污/雨水塑料检查井 16S524\r\n塑料检查井(井筒直径mm以内) 700","座",{"v":29,"d":"29.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"塑料检查井甲供"]
[35,"雨水口","成品塑料雨水口","座",{"v":6,"d":"6.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"雨水口甲供"]
[36,"挖沟槽土方","挖沟槽土方/三类土","m3",1288.36,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[37,"回填方","槽坑 天然砂","m3",933.08,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[38,"回填方","机械填土夯实 槽、坑","m3",355.28,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"室外电","","",""]
[39,"落地式配电箱","1.名称:景观照明配电箱1080*800*350mm\r\n2.落地安装\r\n3.C25混凝土基础\r\n4.基础槽钢制作安装","台",{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"配电箱甲供"]
[40,"电缆保护管","1.名称:电缆保护管\r\n2.材质:PE32","m",{"v":1500,"d":"1500.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"电缆保护管甲供"]
[41,"电缆","1.名称:铜芯电缆\r\n2.型号:YJV-5X6\r\n3.电缆终端头的制安","m",{"v":600,"d":"600.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"电缆甲供"]
[42,"电缆","1.名称:铜芯电缆\r\n2.型号:YJV-3X6","m",{"v":1500,"d":"1500.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"电缆甲供"]
[43,"电缆","1.名称:铜芯电缆\r\n2.型号:YJV-5X10\r\n3.电缆终端头的制安","m",{"v":100,"d":"100.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"电缆甲供"]
[44,"常规照明灯","1.名称:庭院灯\r\n2.型号:LED 35W IP65","套",{"v":40,"d":"40.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"灯具甲供"]
[45,"常规照明灯","1.名称:景观特色灯柱\r\n2.型号:LED 70W IP65","套",{"v":18,"d":"18.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"灯具甲供"]
[46,"景观照明灯","1.名称:草坪灯\r\n2.型号:LED 13W IP65","套",{"v":11,"d":"11.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"灯具甲供"]
[47,"景观照明灯","1.名称:地埋射灯\r\n2.型号:LED 13W IP65","套",{"v":30,"d":"30.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"灯具甲供"]
[48,"景观照明灯","1.名称:射树灯\r\n2.型号:LED 13W IP65","套",{"v":9,"d":"9.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"灯具甲供"]
[49,"挖沟槽土方","挖沟槽土方/三类土","m3",1226.83,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[50,"回填方","机械填土夯实 槽、坑","m3",1226.83,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[51,"电缆","1.名称:铜芯电缆\r\n2.型号:YJV-5X35\r\n3.电缆终端头的制安","m",{"v":300,"d":"300.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"电缆甲供"]
[52,"电缆保护管","1.名称:电缆保护管\r\n2.材质:PE50","m",{"v":1000,"d":"1000.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"电缆保护管甲供"]
["不含税小计",{"$nulls":7},{"v":0,"d":"0.00"}]
["增值税",null,"9%增值税",{"$nulls":5},{"v":0,"d":"0.00"}]
["合价",{"$nulls":7},{"v":0,"d":"0.00"}]
["泰和县马市生态文化旅游特色小镇项目-千年神樟安装劳务工程"]
[{"$nulls":8},"单位：元"]
["序号","名称","任务内容描述\n（包括但不限于以下工作内容）","单位","暂定\n工程量","不含税综合\n单价","不含税综合单价组成明细",null,"合价","备注"]
[{"$nulls":6},"劳务费","主材费"]
[1,"落地式控制箱","1.名称：景观照明配电箱\n2.安装方式：落地安装\n3.含配电箱基础、含铁构件制作安装\n4.具体参数详见图纸及满足技术规范要求\n5.开挖土方、混凝土基础浇筑、型钢基础，配电箱安装；包括：人工费、除配电箱外所有材料费及小型机具使用费","台",1,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"配电箱甲供"]
[2,"常规照明灯","1.名称：庭院灯\n2.60W 220V 3000K IP65\n3.安装方式：立柱安装\n4.组装、 板正、 螺栓紧固， 配线、接线、 试灯工作； 含混凝土基座","套",10,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"灯具甲供"]
[3,"景观照明灯","1.名称：草坪灯\n2.18W 220V 3000K IP67\n3.安装方式：立柱安装\n4.组装、板正、 螺栓紧固， 配线、\n接线、 试灯工作； 含混凝土基座","套",19,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"灯具甲供"]
[4,"景观照明灯","1.名称：插地射树灯\n2.15W 24V 3000K IP68\n3.安装方式：立柱安装\n4.灯具安装，包括人工费、除灯具外所有材料费及小型机具使用费；","套",9,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"灯具甲供"]
[5,"景观照明灯","1.名称：台阶灯\n2.5W 24V 3000K IP68\n3.安装方式：埋地安装\n4.灯具安装，包括人工费、除灯具外所有材料费及小型机具使用费；","套",18,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"灯具甲供"]
[6,"电缆","1.名称：电力电缆\n2.型号、规格：YJV5*10\n3.材质：铜芯\n4.以实际工程量为准\n5.开盘、检查、架线盘、敷设、锯断、配合试验等人工费、除电缆外材料费及小型机具使用费；","m",100,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"电缆甲供"]
[7,"电缆","1.名称：电力电缆\n2.型号、规格：YJV3*6\n3.材质：铜芯\n4.以实际工程量为准\n5.开盘、检查、架线盘、敷设、锯断、配合试验等人工费、除电缆外材料费及小型机具使用费；","m",700,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"电缆甲供"]
[8,"电缆终端头","1.名称:1kV以下室内干包式铜芯电力电缆头\n2. 电缆截面(mm2) ：≤10\n3.芯数：五芯\n4.开盘、检查、架线盘、敷设、锯断、配合试验等人工费、除电缆外材料费及小型机具使用费；","个",2,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"电缆甲供"]
[9,"配管","1.名称:塑料管\n2.规格：PE32\n3.敷设方式：埋地敷设\n4.电缆保护管敷设；包括人工费、除保护管外所有材料费及小型机具使用费","m",700,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"配管甲供"]
[10,"配管","1.名称:塑料管\n2.规格：PE50\n3.敷设方式：埋地敷设\n4.电缆保护管敷设；包括人工费、除保护管外所有材料费及小型机具使用费","m",100,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"配管甲供"]
[11,"供电系统调试","1.输配电装置系统调试 ≤1kV交流供电\n2.包括人工、所有材料及机具使用费","系统",1,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[12,"其他电器","1.开关电源\n2.外置防水电源DC24V 350W\n3.灯具安装，包括人工费、除灯具外所有材料费及小型机具使用费；","个",2,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},"开关甲供"]
[13,"挖沟槽土方","挖沟槽土方/三类土","m3",288,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[14,"回填土方","1、运土、回填、找平、夯实、500米以内的运输等；包含人工、机械、油料等全部费用；\n2、适用于安装工程中配管等土方回填","m3",288,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
["","不含税小计","","","",{"$nulls":3},0]
["","增值税（9%）",null,"","",{"$nulls":3},{"v":0,"d":"0.00"}]
["","合价","","","",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"总计",{"$nulls":6},{"v":0,"d":"0.00"}]
["注：\n本不含税综合单价包含完成工作内容中描述的：人工费、中小型机械费、材料费、除注明甲供材料以外的检验试验费领用甲供材料的保管费、二次搬运费、模板及脚手架、安全文明施工费用、施工人员食宿和交通、施工人员生活用水电费、成品保护费、夜间施工费、冬雨季施工费、垃圾清理和消纳费用、风险费、管理费用、利润、规费及应支付的保险（不仅限于工伤保险和意外伤害险）等一切费用。\n付款条件：甲方每月按月度结算价的【70】%支付；工程整体完工经甲方验收合格支付至初步结算价的【85】%（跨年度工程可进行年度完成工作量初步结算）；工程整体经发包人验收合格后支付至甲方审计部审定结算额的95%；余款自发包人验收合格之日起满1年无息支付。"]

{"sheet":"支撑的使用分析表","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"hidden":true,"merged":[[0,0,0,5],[2,1,8,1],[9,1,15,1],[16,0,16,5]],"flags":["formulas_cached_only"]}
["绿化工程常规支撑的使用分析表"]
["序号","苗木种类","规格","支撑杆长度\n(m)","支撑杆数量\n(根/株）","备注"]
[1,"常绿","H=3-4m",3,3]
[2,null,"H=4-5m",3,3]
[3,null,"H=5-6m",4,4]
[4,null,"H=6-7m",4,4]
[5,null,"H=7-8m",5,4]
[6,null,"H=8-9m",6,4]
[7,null,"H≥10m",6,4]
[8,"落乔","D=8-10cm",3,3]
[9,null,"D=11-15cm",3,3]
[10,null,"D=16-20cm",4,4]
[11,null,"D=21-25cm",4,4]
[12,null,"D=26-30cm",5,4]
[13,null,"D=31-35cm",6,4]
[14,null,"D≥35cm",6,4]
["说明：1.按照一般项目情况综合考虑，根据项目地理位置、项目性质不同合理调整；\n      2.常绿乔木H≥10m，落乔D≥35cm的苗木根据项目实际情况选用支撑杆或钢管、钢索支撑\n      3.辅材仅包含铁丝及固定用防寒面（井子架部位）"]