{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["管网水水质合格率","出厂水合格率","管网水、出厂水水质月检分析"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"管网水水质合格率","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[0,0,0,7],[1,0,1,2],[1,6,1,7],[2,0,4,1],[2,2,2,4],[2,5,2,7],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[5,0,12,0],[13,0,13,1],[14,0,14,1],[15,0,15,1],[15,2,15,4],[15,5,15,7]]}
["                                                     海润集团管网水水质检验合格率报表（2014年3月）"]
["监测部门：供水水质监测中心",{"$nulls":5},"填表日期：2014.4.2"]
["指  标",null,"本 月",null,null,"自 年 初 累 计"]
[null,null,"合格瓶次       (项目)","化验瓶次     （项目）","合格率     （%）","合格瓶次          (项目)","化验瓶次       （项目）","合格率       （%）"]
[]
["常规日检七项","浑浊度",189,189,{"$f":"C6/D6*100","v":{"v":100,"d":"100.00"}},567,567,{"$f":"F6/G6*100","v":{"v":100,"d":"100.00"}}]
[null,"色 度",189,189,{"$f":"C7/D7*100","v":{"v":100,"d":"100.00"}},567,567,{"$f":"F7/G7*100","v":{"v":100,"d":"100.00"}}]
[null,"臭和味",189,189,{"v":100,"d":"100.00"},567,567,{"v":100,"d":"100.00"}]
[null," 游离氯",189,189,{"v":100,"d":"100.00"},567,567,{"v":100,"d":"100.00"}]
[null,"菌落总数",189,189,{"v":100,"d":"100.00"},567,567,{"v":100,"d":"100.00"}," "]
[null,"总大肠菌群",189,189,{"v":100,"d":"100.00"},567,567,{"v":100,"d":"100.00"},null," "]
[null,"耗氧量                 （CODMn法，以O2计）",54,54,{"v":100,"d":"100.00"},162,162,{"v":100,"d":"100.00"}]
[null,"小计",{"$f":"SUM(C6:C12)","v":1188},{"$f":"SUM(D6:D12)","v":1188},{"v":100,"d":"100.00"},3564,3564,{"v":100,"d":"100.00"}]
["常规月检29项",null,2610,2610,{"v":100,"d":"100.00"},7830,7830,{"v":100,"d":"100.00"}]
["      综合合格率",null,{"$f":"SUM(C13:C14)","v":3798},{"$f":"SUM(D13:D14)","v":3798},{"v":100,"d":"100.00"},{"$f":"SUM(F13:F14)","v":11394},{"$f":"SUM(G13:G14)","v":11394},{"v":100,"d":"100.00"}]
["单位负责人：王晓芳",null,"                           审核:郭晓月",null,null,"                                                 制表：王玮"]
[]
[]
[]
[]
[]
[]
[{"$nulls":6}," "]

{"sheet":"出厂水合格率","index":1,"n_rows":20,"n_cols":30,"rows_kept":20,"merged":[[0,0,0,29],[1,5,1,8],[1,12,1,14],[2,0,2,10],[2,19,2,29],[4,0,7,2],[4,3,5,5],[4,6,5,8],[4,9,5,11],[4,12,5,14],[4,15,5,17],[4,18,5,20],[4,21,5,23],[4,24,4,26],[4,27,5,29],[5,24,5,26],[6,5,7,5],[6,8,7,8],[6,11,7,11],[6,14,7,14],[6,17,7,17],[6,20,7,20],[6,23,7,23],[6,26,7,26],[6,29,7,29],[8,1,8,2],[9,1,11,1],[12,1,12,2],[13,1,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,12,14,12],[13,13,14,13],[13,14,14,14],[13,15,14,15],[13,16,14,16],[13,17,14,17],[13,18,14,18],[13,19,14,19],[13,20,14,20],[13,21,14,21],[13,22,14,22],[13,23,14,23],[13,24,14,24],[13,25,14,25],[13,26,14,26],[13,27,14,27],[13,28,14,28],[13,29,14,29],[15,1,17,1],[18,1,18,2],[19,1,19,5],[19,13,19,18],[19,25,19,29]]}
["海润集团各水厂出厂水水质检验合格率报表（2014年3月）"]
[]
["监测部门：供水水质监测中心",{"$nulls":18},"                     填表日期：2014年4月2日"]
[]
["                                             单位            指  标                                                                        ",null,null,"总大肠菌群",null,null,"耐热大肠菌群",null,null,"菌落总数",null,null,"色度",null,null,"浑浊度",null,null,"臭和味",null,null,"肉眼可见物",null,null,"耗氧量",null,null,"余氯"]
[{"$nulls":24},"（CODMn法，以O2计）"]
[{"$nulls":3},"合格","化验","%","合格","化验","%","合格","化验","%","合格","化验","%","合格","化验","%","合格","化验","%","合格","化验","%","合格","化验","%","合格","化验","%"]
[{"$nulls":3},"瓶次","瓶次",null,"瓶次","瓶次",null,"瓶次","瓶次",null,"瓶次","瓶次",null,"瓶次","瓶次",null,"瓶次","瓶次",null,"瓶次","瓶次",null,"瓶次","瓶次",null,"瓶次","瓶次"]
["     本","崂山水厂",null,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100]
[null,"中法海润","白沙河水厂",31,31,100,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100]
[null,null,"仙家寨水厂",31,31,100,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100,31,31,100]
["     月",null,"小计",{"$f":"SUM(D10:D11)","v":62},{"$f":"SUM(E10:E11)","v":62},100,{"$f":"SUM(G10:G11)","v":62},{"$f":"SUM(H10:H11)","v":62},100,{"$f":"SUM(J10:J11)","v":62},{"$f":"SUM(K10:K11)","v":62},100,{"$f":"SUM(M10:M11)","v":62},{"$f":"SUM(N10:N11)","v":62},100,{"$f":"SUM(P10:P11)","v":62},{"$f":"SUM(Q10:Q11)","v":62},100,{"$f":"SUM(S10:S11)","v":62},{"$f":"SUM(T10:T11)","v":62},100,{"$f":"SUM(V10:V11)","v":62},{"$f":"SUM(W10:W11)","v":62},100,{"$f":"SUM(Y10:Y11)","v":62},{"$f":"SUM(Z10:Z11)","v":62},100,{"$f":"SUM(AB10:AB11)","v":62},{"$f":"SUM(AC10:AC11)","v":62},100]
[null,"总计",null,{"$f":"D9+D12","v":93},{"$f":"E9+E12","v":93},100,{"$f":"G9+G12","v":93},{"$f":"H9+H12","v":93},100,{"$f":"J9+J12","v":93},{"$f":"K9+K12","v":93},100,{"$f":"M9+M12","v":93},{"$f":"N9+N12","v":93},100,{"$f":"P9+P12","v":93},{"$f":"Q9+Q12","v":93},100,{"$f":"S9+S12","v":93},{"$f":"T9+T12","v":93},100,{"$f":"V9+V12","v":93},{"$f":"W9+W12","v":93},100,{"$f":"Y9+Y12","v":93},{"$f":"Z9+Z12","v":93},100,{"$f":"AB9+AB12","v":93},{"$f":"AC9+AC12","v":93},100]
["累","崂山水厂",null,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100]
[]
[null,"中法海润","白沙河水厂",90,90,100,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100]
[null,null,"仙家寨水厂",90,90,100,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100,90,90,100]
[null,null,"小计",{"$f":"SUM(D16:D17)","v":180},{"$f":"SUM(E16:E17)","v":180},100,{"$f":"SUM(G16:G17)","v":180},{"$f":"SUM(H16:H17)","v":180},100,{"$f":"SUM(J16:J17)","v":180},{"$f":"SUM(K16:K17)","v":180},100,{"$f":"SUM(M16:M17)","v":180},{"$f":"SUM(N16:N17)","v":180},100,{"$f":"SUM(P16:P17)","v":180},{"$f":"SUM(Q16:Q17)","v":180},100,{"$f":"SUM(S16:S17)","v":180},{"$f":"SUM(T16:T17)","v":180},100,{"$f":"SUM(V16:V17)","v":180},{"$f":"SUM(W16:W17)","v":180},100,{"$f":"SUM(Y16:Y17)","v":180},{"$f":"SUM(Z16:Z17)","v":180},100,{"$f":"SUM(AB16:AB17)","v":180},{"$f":"SUM(AC16:AC17)","v":180},100]
["计","总计",null,{"$f":"D14+D18","v":270},{"$f":"E14+E18","v":270},100,{"$f":"G14+G18","v":270},{"$f":"H14+H18","v":270},100,{"$f":"J14+J18","v":270},{"$f":"K14+K18","v":270},100,{"$f":"M14+M18","v":270},{"$f":"N14+N18","v":270},100,{"$f":"P14+P18","v":270},{"$f":"Q14+Q18","v":270},100,{"$f":"S14+S18","v":270},{"$f":"T14+T18","v":270},100,{"$f":"V14+V18","v":270},{"$f":"W14+W18","v":270},100,{"$f":"Y14+Y18","v":270},{"$f":"Z14+Z18","v":270},100,{"$f":"AB14+AB18","v":270},{"$f":"AC14+AC18","v":270},100]
[null,"单位负责人：王晓芳",{"$nulls":11},"审核：郭晓月",{"$nulls":9},"         制表：谭文帅",null,"       制表：王玮"]

{"sheet":"管网水、出厂水水质月检分析","index":2,"n_rows":53,"n_cols":10,"rows_kept":53,"merged":[[0,0,0,9],[1,0,1,2],[1,5,1,6],[1,7,1,9],[2,0,4,0],[2,1,4,1],[2,2,4,2],[2,3,4,3],[2,4,2,6],[2,7,2,9],[3,4,4,4],[3,5,3,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[48,0,51,2],[48,3,51,9],[52,0,52,1],[52,4,52,6]]}
["海润集团出厂水、管网水水质月检分析报表（2014年3月)"]
["监测部门：供水水质监测中心",{"$nulls":4},"采样日期：2014.3.3~4",null,"           填表日期：2014.4.2"]
["序号","项目","单位","标准","出厂水",null,null,"管网水"]
[{"$nulls":4},"崂山水厂","中法海润",null,"辛家庄","杭州路","太平路"]
[{"$nulls":5},"白沙河水厂","仙家寨水厂"]
[1,"总大肠菌群","CFU/100m L","不得检出","未检出","未检出","未检出","未检出","未检出","未检出"]
[2,"耐热大肠菌群","CFU/100m L","不得检出","未检出","未检出","未检出","未检出","未检出","未检出"]
[3,"大肠埃希氏菌","CFU/100m L","不得检出","未检出","未检出","未检出","未检出","未检出","未检出"]
[4,"菌落总数","CFU/m L","≤100","未检出","未检出","未检出","未检出","未检出","未检出"]
[5,"砷","mg/L","≤0.01","<0.0010","<0.0010","<0.0010","<0.0010","<0.0010","<0.0010"]
[6,"镉","mg/L","≤0.005","<0.0005","<0.0005","<0.0005","<0.0005","<0.0005","<0.0005"]
[7,"铬(六价)","mg/L","≤0.05","<0.004","<0.004","<0.004","<0.004","<0.004","<0.004"]
[8,"铅","mg/L","≤0.01","<0.0025","<0.0025","<0.0025","<0.0025","<0.0025","<0.0025"]
[9,"汞","mg/L","≤0.001","<0.0001","<0.0001","<0.0001","<0.0001","<0.0001","<0.0001"]
[10,"硒","mg/L","≤0.01","<0.0004","<0.0004","<0.0004","<0.0004","<0.0004","<0.0004"]
[11,"氰化物","mg/L","≤0.05","<0.002","<0.002","<0.002","<0.002","<0.002","<0.002"]
[12,"氟化物","mg/L","≤1.0",0.37,0.48,0.52,0.49,0.49,{"v":0.5,"d":"0.50"}]
[13,"硝酸盐(以N计)","mg/L","≤10地下水源限制时为20",3.58,3.86,{"v":5.2,"d":"5.20"},4.24,{"v":3.9,"d":"3.90"},4.22]
[14,"三氯甲烷","mg/L","≤0.06",0.0133,0.0049,{"v":0.006,"d":"0.0060"},0.0074,0.0188,0.0069]
[15,"四氯化碳","mg/L","≤0.002","<0.0003","<0.0003","<0.0003","<0.0003","<0.0003","<0.0003"]
[16,"色度","铂钴色度单位","≤15 ","<5","<5","<5","<5","<5","<5"]
[17,"浑浊度","NTU","≤1，水源与净水技术条件限制时≤3",0.16,0.19,0.14,0.33,0.34,{"v":0.5,"d":"0.50"}]
[18,"臭和味",null,"无异臭、异味",0,0,0,0,0,0]
[19,"肉眼可见物",null,"无","无","无","无","无","无","无"]
[20,"pH",null,"不小于6.5且不大于8.5",7.89,7.95,7.98,7.86,8.07,8.01]
[21,"铝","mg/L","≤0.2",0.146,"<0.010","<0.010",{"v":0.11,"d":"0.110"},0.144,"<0.010"]
[22,"铁","mg/L","≤0.3","<0.05","<0.05","<0.05","<0.05","<0.05","<0.05"]
[23,"锰","mg/L","≤0.1","<0.05","<0.05","<0.05","<0.05","<0.05","<0.05"]
[24,"铜","mg/L","≤1.0","<0.005","<0.005","<0.005","<0.005","<0.005",0.008]
[25,"锌","mg/L","≤1.0","<0.05","<0.05","<0.05","<0.05","<0.05","<0.05"]
[26,"氯化物","mg/L","≤250",47.2,86.9,69.4,78.1,{"v":84,"d":"84.0"},79.7]
[27,"硫酸盐","mg/L","≤250",81.6,{"v":139,"d":"139.0"},{"v":119,"d":"119.0"},129.1,137.2,131.9]
[28,"溶解性总固体","mg/L","≤1000",318,540,464,492,522,508]
[29,"总硬度                （以CaCO3计）","mg/L","≤450",175.6,268.2,{"v":249,"d":"249.0"},264.6,279.9,{"v":253,"d":"253.0"}]
[30,"永久硬度","mg/L","无",89.6,126.2,{"v":133,"d":"133.0"},134.6,140.9,{"v":120,"d":"120.0"}]
[31,"碳酸盐硬度","mg/L","无",86,142,116,130,139,133]
[32,"负硬度","mg/L","无",0,0,0,0,0,0]
[33,"耗氧量           （CODMn法，以O2计）","mg/L","≤3水源限制，原水耗氧量>6 mg/L时为5",{"v":2.2,"d":"2.20"},1.82,1.98,2.06,1.98,1.74]
[34,"挥发酚类    （以苯酚计）","mg/L","≤0.002","<0.002","<0.002","<0.002","<0.002","<0.002","<0.002"]
[35,"阴离子合成洗涤剂","mg/L","≤0.3","<0.05","<0.05","<0.05","<0.05","<0.05","<0.05"]
[36,"总α放射性","Bq/L","≤0.5","<0.01","<0.01","<0.01","<0.01","<0.01","<0.01"]
[37,"总β放射性","Bq/L","≤1",0.016,0.011,0.007,0.011,{"v":0.01,"d":"0.010"},0.006]
[38,"氯气与游离氯制剂（游离氯）","mg/L","与水接触30min后出厂水中余量≥0.3，出厂水中限值为4。管网末梢水中余量≥0.05",{"v":0.7,"d":"0.70"},0.51,0.51,{"v":0.2,"d":"0.20"},0.18,{"v":0.2,"d":"0.20"}]
[39,"三卤甲烷（总量）",null,"≤1",0.4,0.3,0.4,0.5,0.8,0.4]
[40,"三溴甲烷","mg/L","≤0.1","<0.0060","<0.0060","<0.0060","<0.0060","<0.0060","<0.0060"]
[41,"一溴二氯甲烷","mg/L","≤0.06",0.0047,0.0075,0.0095,0.0116,{"v":0.016,"d":"0.0160"},0.0106]
[42,"二溴一氯甲烷","mg/L","≤0.1",0.0046,{"v":0.008,"d":"0.0080"},0.0097,0.0113,0.0152,0.0105]
[43,"丙烯酰胺","mg/L","≤0.0005","<0.00005","<0.00005","<0.00005","<0.00005","<0.00005","<0.00005"]
["水质评价",null,null,"           集团公司的出厂水和管网水所检项目均符合《生活饮用水卫生标准》GB5749-2006的要求。"]
[]
[]
[]
["单位负责人:王晓芳",{"$nulls":3},"审核:郭晓月",{"$nulls":4},"制表:王玮"]