{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Pollution_Index_Calculator","DDW","Score","Score1","Print","List","PI"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pollution_Index_Calculator","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,0,1048575,16383]]}

{"sheet":"DDW","index":1,"n_rows":41,"n_cols":26,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
["BOD",null,"COD",null,null,null,null,null,null,null,"W2-4",null,"Wastewater generated W3-1-5",null,"W3-6-10",null,"A3-1-3",null,"A3-5-7",null,"A3-9-12",null,"H2-1-5",null,"B-1-7"]
["W1-1: BOD ≥ 5,000 mg/l ",35,"W1-1: COD ≥ 10,000 mg/l",35,"Adsorbable Organic Halogens (Aox)",30,"Ammonical Nitrogen",25,"Wastewater generated from fresh-water RO rejects",20,"Wastewater from cooling towers",15,"Wastewater ≥ 500 KLD",35,"Sewage ≥ 5,000 KLD",35,"Fuel consumption ≥ 24 TPD",35,"Fuel consumption ≥ 48 TPD",25,"Fuel consumption ≥ 120 TPD",20,"Hazardous Waste ≥ 5000 TPA",70,"No. of beds ≥ 1,000",100]
["W1-2: 1000 ≤ BOD < 5,000 mg/l ",30,"W1-2: 5000 ≤ COD < 10,000 mg/l",30,"Aluminium",30,"Nitrate  ",25,"Boiler blowdonws",20,"Cooling-re-circulation processes",15,"100 KLD ≤ Wastewater < 500 KLD",30,"2,000 KLD ≤ Sewage < 5,000 KLD",30,"12 TPD ≤ Fuel consumption < 24 TPD",30,"24 TPD ≤ Fuel consumption < 48 TPD",20,"60 TPD ≤ Fuel consumption < 120 TPD",15,"1000 TPA ≤ Hazardous Waste < 5000 TPA",50,"500 ≤ No. of beds < 1,000",80]
["W1-3: 500 ≤ BOD < 1,000 mg/l ",25,"W1-3: 1000 ≤ COD < 5,000 mg/l",25,"Ammonia",30,"Nitrate Nitrogen",25,"Brine solution rejects",20,"Other similar operations",15,"50 KLD ≤ Wastewater < 100 KLD",25,"500 KLD ≤ Sewage < 2,000 KLD",25,"Fuel consumption < 12 TPD",25,"Fuel consumption < 24 TPD",15,"Fuel consumption < 60 TPD",10,"200 TPA ≤ Hazardous Waste < 1000 TPA10 TPA ≤ Hazardous Waste < 200 TPA",30,"200 ≤ No. of beds < 500",60]
["W1-4: 100 ≤ BOD < 500 mg/l ",20,"W1-4: 250 ≤ COD < 1,000 mg/l",20,"Anionic detergents",30,"Oil & Grease",25,"Other similar operations",20,null,null,"10 KLD ≤ Wastewater < 50 KLD",20,"100 KLD ≤ Sewage < 500 KLD",20,null,null,null,null,"Electricity",0,"10 TPA ≤ Hazardous Waste < 200 TPA",20,"50 ≤ No. of beds < 200",50]
["W1-5: 10 ≤ BOD < 100 mg/l ",10,"W1-5: 50 ≤ COD < 250 mg/l",10,"Antimicrobial resistant drugs",30,"Total Kjeldahl Nitrogen (TKN)",25,null,null,null,null,"Wastewater < 10 KLD",15,"Sewage < 100 KLD",15,null,null,null,null,null,null,"Hazardous Waste < 10 TPA",10,"10 ≤ No. of beds < 50",40]
[null,null,null,null,"Antimony",30,"<5.5 or >9",25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of beds < 10",30]
[null,null,null,null,"Arsenic",30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-bedded facility ",25]
[null,null,null,null,"Barium",30," "]
[null,null,null,null,"Benzene",30]
[null,null,null,null,"Benzo-a-pyrene",30]
[null,null,null,null,"Cadmium",30]
[null,null,null,null,"Chloramines",30]
[null,null,null,null,"Chromium",30]
[null,null,null,null,"Copper",30]
[null,null,null,null,"Cyanide",30]
[null,null,null,null,"Fluoride",30]
[null,null,null,null,"Residual Antibiotics",30]
[null,null,null,null,"Iron ",30]
[null,null,null,null,"Lead",30]
[null,null,null,null,"Manganese",30]
[null,null,null,null,"Mercury",30]
[null,null,null,null,"Mineral Oil",30]
[null,null,null,null,"Molybdenum",30]
[null,null,null,null,"Nickel",30]
[null,null,null,null,"Pesticides",30]
[null,null,null,null,"Phenolic compounds",30]
[null,null,null,null,"Phosphates",30]
[null,null,null,null,"Polychlorinated biphenyls",30]
[null,null,null,null,"Polynuclear Aromatic Hydrocarbons",30]
[null,null,null,null,"Radioactive materials",30]
[null,null,null,null,"Selenium",30]
[null,null,null,null,"Silver",30]
[null,null,null,null,"Sulphide",30]
[null,null,null,null,"Tin",30]
[null,null,null,null,"Total Residual Chlorine",30]
[null,null,null,null,"Trichloroethane",30]
[null,null,null,null,"Trichloroethylene",30]
[null,null,null,null,"Vanadium",30]
[null,null,null,null,"Zinc",30]

{"sheet":"Score","index":2,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[[5,6,5,8],[38,1,39,4],[37,1,37,4],[33,1,33,4],[35,1,35,4],[9,0,9,2],[22,0,22,2],[31,0,31,2],[1,3,2,3],[3,3,6,3],[7,3,8,3],[1,4,2,4],[3,4,6,4],[7,4,8,4],[0,9,0,10],[42,2,42,4],[0,6,0,7],[11,2,11,4],[24,2,24,4],[25,3,28,3],[29,3,30,3],[25,4,28,4],[0,2,0,4],[12,3,15,3],[16,3,18,3],[19,3,21,3],[12,4,15,4],[16,4,18,4],[19,4,21,4],[34,1,34,4]]}
["Water Pollutant Group","Water Pollutants Considered","Score",null,null,null,"Inference",null,null,"Category"]
["W1: 1 - 5: BOD",null,{"$f":"IF(B2<>\"\", VLOOKUP($B$2, DDW!$A$3:$B$7, 2, 0), \"\")","v":""},{"$f":"MAX(C2:C3)","v":0},"W1",null,"imax",{"$f":"MAX(D10,D23,D32)","v":0},null,{"$f":"IF(H4>=80, 1, \"\")","v":""},{"$f":"SUM(J2:J6)","v":14}]
["W1: 1 - 5: COD",null,{"$f":"IF(B3<>\"\", VLOOKUP($B$3, DDW!$C$3:$D$7, 2, 0), \"\")","v":""},null,null,null,"i2 + i3",{"$f":"SUM(D10,D23,D32)-H2","v":0},null,{"$f":"IF(AND(H4<80, H4>=55), 2, \"\")","v":""}]
["W2:1 ",null,{"$f":"IF(B4<>\"\", 30, \"\")","v":""},{"$f":"MAX(C4:C7)","v":0},"W2",null,"PI",{"$f":"H2+(100-H2)*(H3/200)","v":0},null,{"$f":"IF(AND(H4<55, H4>=25), 3, \"\")","v":""}]
["W2:2",null,{"$f":"IF(B5<>\"\", 25, \"\")","v":""},null,null,null,"Category",{"$f":"IF(K2>10, \"Blue\", IF(K2=1, \"Red\", IF(K2=2, \"Orange\", IF(K2=3, \"Green\", IF(K2=4, \"White\", \"\")))))","v":"Blue"},null,{"$f":"IF(OR(AND(H4=0, H3=0, H2=0), H4<25), 4, \"\")","v":4}]
["W2:3",null,{"$f":"IF(B6<>\"\", 20, \"\")","v":""},null,null,null,"Blue category",null,null,10]
["W2:4",null,{"$f":"IF(B7<>\"\", 15, \"\")","v":""},null,null,null,null,null,null,null,null,"imax",{"$f":"ROUND(O7*100/N7, 2)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O7:O9)","v":0},{"$f":"H2","v":0}]
["W3: 1 - 5: Industrial Effluent",null,{"$f":"IF(B8<>\"\", VLOOKUP($B$8,DDW!$M$3:$N$7, 2, 0), \"\")","v":""},{"$f":"MAX(C8:C9)","v":0},"W3",null,null,null,null,null,null,"i2",{"$f":"ROUND(O8*100/N7, 2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND((100-O7)*(MIN(D10,D23,D32)/200), 2)","v":0}]
["W3: 6 - 10: Sewage",null,{"$f":"IF(B9<>\"\", VLOOKUP($B$9,DDW!$O$3:$P$7, 2, 0), \"\")","v":""},null,null,null,null,null,null,null,null,"i3",{"$f":"ROUND(O9*100/N7, 2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND((100-O7)*((SUM(D10,D23,D32)-O7-O8)/200), 2)","v":0}]
["Water Pollutant Score: PIW = W1+W2+W3",null,null,{"$f":"SUM(D2:D9)","v":0}]
[]
["Air Pollutant Group","Air Pollutants Considered","Score"]
["A1:1",null,{"$f":"IF(B13<>\"\", 35, \"\")","v":""},{"$f":"MAX(C13:C16)","v":0},"A1",null,"Industry"]
["A1:2",null,{"$f":"IF(B14<>\"\", 30, \"\")","v":""}]
["A1:3",null,{"$f":"IF(B15<>\"\", 25, \"\")","v":""}]
["A1:4",null,{"$f":"IF(B16<>\"\", 20, \"\")","v":""}]
["A2:1",null,{"$f":"IF(B17<>\"\", 30, \"\")","v":""},{"$f":"MAX(C17:C19)","v":0},"A2",null,"Maharashtra"]
["A2:2",null,{"$f":"IF(B18<>\"\", 25, \"\")","v":""},null,null,null,"S. No.","Sector","W1","W2","W3","PIW","A1","A2","A3","PIA","H1","H2","PIH","Pollution Index: PI","Category","Remarks"]
["A2:3",null,{"$f":"IF(B19<>\"\", 20,\"\")","v":""},null,null,null,null,{"$f":"Score1!A2","v":"Industry"},{"$f":"D2","v":0},{"$f":"D4","v":0},{"$f":"D8","v":0},{"$f":"D10","v":0},{"$f":"D13","v":0},{"$f":"D17","v":0},{"$f":"D20","v":0},{"$f":"D23","v":0},{"$f":"D26","v":0},{"$f":"D30","v":0},{"$f":"D32","v":0},{"$f":"B35","v":0},{"$f":"B36","v":"Blue"},{"$f":"B39","v":"Remarks1"}]
["A3:1-3",null,{"$f":"IF(B20<>\"\", VLOOKUP($B$20, DDW!$Q$3:$R$5, 2, 0), \"\")","v":""},{"$f":"MAX(C20:C22)","v":0},"A3"]
["A3:4-6",null,{"$f":"IF(B21<>\"\", VLOOKUP($B$21,DDW!$S$3:$T$55, 2, 0), \"\")","v":""}]
["A3:7-10",null,{"$f":"IF(B22<>\"\", VLOOKUP($B$22, DDW!$U$3:$V$6, 2, 0), \"\")","v":""}]
["Air Pollutant Score: PIA = A1+A2+A3",null,null,{"$f":"SUM(D13:D22)","v":0}]
[]
["Waste Pollutant Group","Waste Pollutants Considered","Score"]
["H1:1",null,{"$f":"IF(B26<>\"\", 30, \"\")","v":""},{"$f":"MAX(C26:C29)","v":0},"H1"]
["H1:2",null,{"$f":"IF(B27<>\"\", 25, \"\")","v":""}]
["H1:3",null,{"$f":"IF(B28<>\"\", 20, \"\")","v":""}]
["H1:4",null,{"$f":"IF(B29<>\"\", 10,\"\")","v":""}]
["H2: 1 - 5",null,{"$f":"IF(B30<>\"\", VLOOKUP(B30, DDW!$W$3:$X$7, 2, 0), \"\")","v":""},{"$f":"MAX(C30:C31)","v":0},"H2"]
["B1-7",null,{"$f":"IF(B31<>\"\", VLOOKUP(B31, DDW!$Y$3:$Z$9, 2, 0), \"\")","v":""},null,"B"]
["Waste Pollutant Score: PIH = (H1+H2) or B",null,null,{"$f":"SUM(D26:D31)","v":0}]
[]
[null,"Inference"]
["Cumulative Pollution Index: PI",{"$f":"H4","v":0}]
["Category of Sector:",{"$f":"H5","v":"Blue"}]
[]
[null,"Remarks"]
[null,"Remarks1"]
[]
[]
[]
[null,null,"Prepared by"]

{"sheet":"Score1","index":3,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[40,1,40,4],[47,2,47,4],[12,0,12,2],[25,0,25,2],[0,0,0,4],[1,0,1,4],[38,0,39,0],[34,0,34,2],[38,1,38,4],[39,1,39,4],[36,0,36,3],[42,1,44,4]]}
[{"$f":"Score!G17","v":"Maharashtra"}]
[{"$f":"Score!G13","v":"Industry"}]
[]
["Water Pollutant Group","Water Pollutants Considered","Score","Max"]
["W1: 1 - 5: BOD",{"$f":"Score!B2","v":0},{"$f":"Score!C2","v":""},{"$f":"Score!D2","v":0},"W1"]
["W1: 1 - 5: COD",{"$f":"Score!B3","v":0},{"$f":"Score!C3","v":""},{"$f":"Score!D2","v":0},"W1"]
["W2:1 ",{"$f":"Score!B4","v":0},{"$f":"Score!C4","v":""},{"$f":"Score!D4","v":0},"W2"]
["W2:2",{"$f":"Score!B5","v":0},{"$f":"Score!C5","v":""},{"$f":"Score!D4","v":0},"W2"]
["W2:3",{"$f":"Score!B6","v":0},{"$f":"Score!C6","v":""},{"$f":"Score!D4","v":0},"W2"]
["W2:4",{"$f":"Score!B7","v":0},{"$f":"Score!C7","v":""},{"$f":"Score!D4","v":0},"W2"]
["W3: 1 - 5: Industrial Effluent",{"$f":"Score!B8","v":0},{"$f":"Score!C8","v":""},{"$f":"Score!D8","v":0},"W3"]
["W3: 6 - 10: Sewage",{"$f":"Score!B9","v":0},{"$f":"Score!C9","v":""},{"$f":"Score!D8","v":0},"W3"]
["Water Pollutant Score: PIW = W1+W2+W3",null,null,{"$f":"Score!D10","v":0}]
[]
["Air Pollutant Group","Air Pollutants Considered","Score","Max"]
["A1:1",{"$f":"Score!B13","v":0},{"$f":"Score!C13","v":""},{"$f":"Score!D13","v":0},"A1"]
["A1:2",{"$f":"Score!B14","v":0},{"$f":"Score!C14","v":""},{"$f":"Score!D13","v":0},"A1"]
["A1:3",{"$f":"Score!B15","v":0},{"$f":"Score!C15","v":""},{"$f":"Score!D13","v":0},"A1"]
["A1:4",{"$f":"Score!B16","v":0},{"$f":"Score!C16","v":""},{"$f":"Score!D13","v":0},"A1"]
["A2:1",{"$f":"Score!B17","v":0},{"$f":"Score!C17","v":""},{"$f":"Score!D17","v":0},"A2"]
["A2:2",{"$f":"Score!B18","v":0},{"$f":"Score!C18","v":""},{"$f":"Score!D17","v":0},"A2"]
["A2:3",{"$f":"Score!B19","v":0},{"$f":"Score!C19","v":""},{"$f":"Score!D17","v":0},"A2"]
["A3:1-3",{"$f":"Score!B20","v":0},{"$f":"Score!C20","v":""},{"$f":"Score!D20","v":0},"A3"]
["A3:4-6",{"$f":"Score!B21","v":0},{"$f":"Score!C21","v":""},{"$f":"Score!D20","v":0},"A3"]
["A3:7-10",{"$f":"Score!B22","v":0},{"$f":"Score!C22","v":""},{"$f":"Score!D20","v":0},"A3"]
["Air Pollutant Score: PIA = A1+A2+A3",null,null,{"$f":"Score!D23","v":0}]
[]
["Waste Pollutant Group","Waste Pollutants Considered","Score","Max"]
["H1:1",{"$f":"Score!B26","v":0},{"$f":"Score!C26","v":""},{"$f":"Score!D26","v":0},"H1"]
["H1:2",{"$f":"Score!B27","v":0},{"$f":"Score!C27","v":""},{"$f":"Score!D26","v":0},"H1"]
["H1:3",{"$f":"Score!B28","v":0},{"$f":"Score!C28","v":""},{"$f":"Score!D26","v":0},"H1"]
["H1:4",{"$f":"Score!B29","v":0},{"$f":"Score!C29","v":""},{"$f":"Score!D26","v":0},"H1"]
["H2: 1 - 5",{"$f":"Score!B30","v":0},{"$f":"Score!C30","v":""},{"$f":"Score!D30","v":0},"H2"]
["B1-7",{"$f":"Score!B31","v":0},{"$f":"Score!C31","v":""},{"$f":"Score!D30","v":0},"B"]
["Waste Pollutant Score: PIH = (H1+H2) or B",null,null,{"$f":"Score!D32","v":0}]
[]
["Whether belongs to Essential Environemntal Services for Domestic/ Household Activities?: ",null,null,null,{"$f":"IF(Score!J6=10, \"Yes\", \"No\")","v":"Yes"}]
[]
["Cumulative Pollution Index: PI","Inference"]
[null,{"$f":"Score!B35","v":0}]
["Category of Sector:",{"$f":"Score!B36","v":"Blue"}]
[]
["Remarks:",{"$f":"IF(Score!B39=\"\", \"\", Score!B39)","v":"Remarks1"}]
[]
[]
[]
[]
[null,null,"Prepared by"]

{"sheet":"Print","index":4,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[9,0,9,2],[13,0,13,2],[15,0,15,3],[5,0,5,2],[0,0,0,4],[1,0,1,4],[26,2,26,4],[17,0,18,0],[17,1,17,4],[18,1,18,4],[19,1,19,4],[21,1,23,4]]}
[{"$f":"Score!G17","v":"Maharashtra"}]
[{"$f":"Score!G13","v":"Industry"}]
[]
["Water Pollutant Group","Water Pollutants Considered","Score","Max"]
["W2:1 ",{"$f":"Score!B4","v":0},{"$f":"Score!C4","v":""},{"$f":"Score!D4","v":0},"W2"]
["Water Pollutant Score: PIW = W1+W2+W3",null,null,{"$f":"Score!D10","v":0}]
[]
["Air Pollutant Group","Air Pollutants Considered","Score","Max"]
["A1:1",{"$f":"Score!B13","v":0},{"$f":"Score!C13","v":""},{"$f":"Score!D13","v":0},"A1"]
["Air Pollutant Score: PIA = A1+A2+A3",null,null,{"$f":"Score!D23","v":0}]
[]
["Waste Pollutant Group","Waste Pollutants Considered","Score","Max"]
["H2: 1 - 5",{"$f":"Score!B30","v":0},{"$f":"Score!C30","v":""},{"$f":"Score!D30","v":0},"H2"]
["Waste Pollutant Score: PIH = (H1+H2) or B",null,null,{"$f":"Score!D32","v":0}]
[]
["Whether belongs to Essential Environemntal Services for Domestic/ Household Activities?: ",null,null,null,{"$f":"IF(Score!J6=10, \"Yes\", \"No\")","v":"Yes"}]
[]
["Cumulative Pollution Index: PI","Inference"]
[null,{"$f":"Score!B35","v":0}]
["Category of Sector:",{"$f":"Score!B36","v":"Blue"}]
[]
["Remarks:",{"$f":"IF(Score!B39=\"\", \"\", Score!B39)","v":"Remarks1"}]
[]
[]
[]
[]
[null,null,"Prepared by"]

{"sheet":"List","index":5,"n_rows":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15],[2,2,2,15],[2,0,2,1]]}
["COMPUTATION OF POLLUTION INDEX"]
["CLASSIFICATION OF SECTORS RED, ORANGE, GREEN, WHITE, BLUE CATEGORIES"]
["STATE: ",null,{"$f":"Score1!A1","v":"Maharashtra"}]
["S. No.","Sector","W1","W2","W3","PIW","A1","A2","A3","PIA","H1","H2","PIH","Pollution Index: PI","Category","Remarks"]

{"sheet":"PI","index":6,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Pollution Index (PI)","Category of Sector"]
["PI ≥ 80","Red"]
["55 ≤ PI < 80","Orange"]
["25 ≤ PI < 55","Green"]
["PI < 25 ","White"]
[]
[]
["Essential Environmental Services for Domestic / Household activities","Blue"]