{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["填报说明","主要跨界河流简评","重污染河流简评"],"not_rendered":{"external_links":2,"defined_names":3,"comments":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"填报说明","index":0,"n_rows":26,"n_cols":1,"rows_kept":26,"merged":[[1,0,5,11],[7,0,23,11],[25,0,31,11]],"flags":["formulas_cached_only"]}
["填报说明"]
["1.原始数据填报：\nA.按照格式顺序要求，先填报跨界河流，后填报重污染河流；\nB.跨界河流上报《地表水环境质量标准》(GB3838-2002)表1 24项数据，未监测项目填-1,在检出限以下填\"检出限值L\"；\nC.重污染河流上报pH、溶解氧、化学需氧量、氨氮、总磷等5项，其他指标保持空白即可。\nD.填报原始数据的断面、监测上中下、左中右点位、涨退潮要求严格按照《广东省重点河流水质监测与评价方案》要求；\nE.详见表\"本期原始数据”和上期原始数据\"示例。"]
[]
[]
[]
[]
[]
["2.简评说明：\nA.未监测统一用长划号填写；\nB.超标项目/超标倍数计算，溶解氧为目标浓度与监测浓度的差值，其他指标以阶段目标计算，无阶段目标的以水质目标计算,计算过程为(本期浓度-目标浓度)/目标浓度，按照超标倍数由大到小排序，主要超标项目/超标倍数为超标倍数前三项，每个项目之间以顿号隔开；\nC.各指标与上年同比计算，计算过程为（本期浓度/上期浓度-1）*100%，指标排序均为氨氮/?%、总磷/?%、化学需氧量/?%、溶解氧/?%；\nD.跨界河流综合污染指数计算指标为《地表水环境质量标准》(GB3838-2002)表1中的除水温、总氮、粪大肠菌群、pH、溶解氧外的19项指标，即19项各项指标的监测浓度值除以Ⅲ类标准值求出各指标污染指数，再取19项污染指数均值；\nE.重污染河流综合污染指数以氨氮、总磷和化学需氧量三项计算，即以该三项污染指数求均值；\nF.综合污染指数均值与上年同期比较计算，计算过程为(本期综合污值/上期综合污指-1)*100%;\nG.水质类别均为罗马字母序号表示，不加\"类\"字，例如\"Ⅲ\";\nH.超标倍数、各指标与上年同比、综合污染指数均值及上年同比均保留一位小数位。\nI.水质达标状况按照备注中的阶段目标评价，若无阶段目标，按照水质目标评价，评价结果为\"达标\"和“未达标\"两种，达标情况背景颜色为以下4中，①水质劣于Ⅴ类且未达阶段控制目标，用红色标示,②水质为Ⅴ类且未达阶段控制目标，或水质类别同比下降时，用黄色标示,③水质达阶段控制目标且同比水质类别未下降时，用绿色标示④若均无以上述情况，请保留背景填充为无颜色。\nJ.详见表\"主要跨界河流简评\"和\"重污染河流简评\"示例。\n"]
{"$rows_empty":17}
["3.上报时间说明：\nA.按照<广东省重点河流水质状况信息发布方案>粤环[2014]61号文要求，每月25日前将当月监测数据及水质状况简要分析报送省环境监测中心，邮箱gdjhsz@163.om.\nB.对此表有任何疑问，请联系林秀榕 020-28368507."]

{"sheet":"主要跨界河流简评","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"merged":[[0,0,0,10],[2,0,3,0],[2,10,3,10],[6,0,9,10]],"flags":["formulas_cached_only"]}
["2016年1月份广东省主要跨市河流交接断面水质状况"]
["责任\n城市","监测城市","交接断面","所在河流","交接关系","水质控\n制目标","水质\n类别","上年同期\n水质类别","达标\n状况","主要超标项目\n/超标倍数","备注"]
["深圳","惠州","西湖村","龙岗河","深圳→惠州","Ⅲ","劣V","劣V","超标","氨氮/1.3，总磷/0.2","2015年度目标氨氮达Ⅴ类，其他指标达Ⅳ类。"]
[null,"惠州","上垟","坪山河","深圳→惠州","Ⅲ","劣V","劣V","超标","氨氮/1.3，总磷/0.6"]
["河源","惠州","江口","东江","河源→惠州","Ⅱ","Ⅱ","Ⅱ","达标"]
["东莞","惠州","石龙桥(左)","东江","惠州→东莞共河","Ⅱ","Ⅲ","Ⅱ","超标"]
["备注：1.未监测统一用长划号填写；\n      2.超标项目/超标倍数计算，溶解氧为目标浓度与监测浓度的差值，其他指标以阶段目标计算，无阶段目标的以水质目标计算;\n      3.综合污染指数计算指标为《国家地表水标准2002-3838》表1中的除水温、总氮、粪大肠菌群、pH、溶解氧外的19项指标。"]

{"sheet":"重污染河流简评","index":2,"n_rows":7,"n_cols":13,"rows_kept":7,"merged":[[0,0,0,12],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,1,11],[1,12,2,12],[3,12,4,12],[6,0,8,12]],"flags":["formulas_cached_only"]}
["2016年1月份重污染河流断面水质状况"]
["责任城市","监测城市","河流\n名称","断面\n名称","水质\n目标","水质\n类别","水质\n状况（手工）","达标\n状况","超标项目\n/超标倍数","各指标与上年同期比较","综合污染指数",null,"备注"]
[{"$nulls":10},"2016-01-01","与上年\n同期比较"]
["深圳","惠州","龙岗河","西湖村","Ⅲ","劣V","重度污染","超标","氨氮/1.3，总磷/0.2","总磷/-33.7%、化学需氧量/-15.7%、氨氮/-25.9%、溶解氧/6.1%",7.45,{"v":-0.266,"d":"-26.6%"},"2015年度目标氨氮达V类,其他指标达Ⅳ类。"]
["深圳","惠州","坪山河","上垟","Ⅲ","劣V","重度污染","超标","氨氮/1.3，总磷/0.6","氨氮/-31.3%、化学需氧量/-30.3%、总磷/20.5%、溶解氧/1.5%",{"v":8.1,"d":"8.10"},{"v":-0.214,"d":"-21.4%"}]
["惠州","惠州","淡水河","紫溪","Ⅲ","劣V","重度污染","超标","氨氮/1.1，总磷/0.03","化学需氧量/-4.9%、氨氮/-17.5%、总磷/-12.7%、溶解氧/5.2%、",6.82,{"v":-0.148,"d":"-14.8%"},"2015年度目标氨氮V类,其余Ⅳ类。"]
["备注：1.未监测统一用长划号填写；\n      2.超标项目/超标倍数计算，溶解氧为目标浓度与监测浓度的差值，其他指标以阶段目标计算，无阶段目标的以水质目标计算;\n      3.综合污染指数以氨氮、总磷和化学需氧量三项计算。\n      4.镇盛无2015年阶段目标，参照下游石碧阶段目标；水口水道沿用2014年阶段目标。"]