{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Main","Interim Results","Curves","Worksheet","1997Curves"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":17,"comments":1,"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":"Instructions","index":0,"n_rows":38,"n_cols":1,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Main!A1","v":"A Water Quality Index for Washington State streams (Version 6: 2014.06.11)."}]
["Summary"]
["This Water Quality Index is designed to rate general water quality relative to expected quality. Monitoring results from monthly grab samples can be converted to scores ranging from 1 to 100. In general, scores less than 40 indicate water quality did not meet expectations. These are areas of highest concern. Scores of 40 to 79 indicate moderate concern, and scores of 80 and greater indicate water quality met expectations and are of lowest concern."]
["Limitations"]
["Indexes by design contain less information than the raw data that they summarize; many uses of water quality data cannot be met with an index. An index is most useful for comparative purposes (what stations have particularly poor water quality compared to expectations?) and for general questions (how is water quality in my stream?). Indexes are less suited to specific questions. Site-specific decisions should be based on an analysis of the original water quality data. This index should not be used to compare stations unless expectations are the same. In short, an index is a useful tool for \"communicating water quality information to the lay public and to legislative decision makers;\" it is not \"a complex predictive model for technical and scientific application\" (McClelland, 1974)."]
[]
["Besides being general in nature (imprecise), there are at least two reasons that any index may fail to accurately communicate water quality information. First, this index, like most indexes, is based on a pre-identified set of water quality constituents. A particular station may receive a good WQI score, and yet have water quality impaired by constituents not included in the index. Second, aggregation of data may mask short-term water quality problems. A satisfactory WQI at a particular station does not necessarily mean that water quality was always satisfactory. A good score should, however, indicate that poor water quality (for evaluated constituents, at least) was not chronic."]
["Directions"]
["This spreadsheet is designed to convert and aggregate results from grab samples from a single station and a single year to index scores (up to 12 samples).  Scores must be determined separately for additional stations or years. Twelve monthly samples are not required. Scores may be based on as little as a single sample--though this, of course, may not be sufficiently representative to accurately assess water quality. "]
[]
["There are six tabs. The first, this one, contains instructions and narrative information. The second \"Main\" tab is where you enter your data and view the index scores. The third \"Interim Results\" tab shows scores for each individual result. The fourth \"Curves\" tab contains the equations used to calculate scores. The fifth \"Worksheet\" tab is for you to use as you wish. I have used it to convert some data in text format (bottom) to numbers (top), which can then be copied to the main tab (paste special/values)--or, as in this example, the main tab is set to equal the values in the worksheet. The last \"1997Curves\" tab are the equations used in previous versions of the WQI that are based on Ecology's 1997 Water Quality Standards."]
[]
["Under the \"Main\" tab:"]
["1. Enter the station's Aquatic Life and Recreation Uses (e.g., Core/Primary; See WAC 173-201A) and Ecoregion (1-4, 6-9)."]
["2. Select Yes if you want to use the small Puget Sound streams TN and TP curves and No to use the standard TN and TP curves. The small PS curves were developed using data from King County and the City of Redmond to reflect what they consider to be naturally high TN/TP concentrations in their small streams. (Only the summer TP curves are unique to small PS streams.) Although developed for small streams in Ecoregion 2 (Puget Sound), you may try using these curves if you believe your TN and summer TP scores are  unrealistically low (poor). "]
["3. Enter the data for the year being evaluated. We use water years, but the index may be calculated on a calendar year basis."]
["4. Edit the \"Curve to Use\" numbers if desired (see the \"Curves\" tab). You may want to do this if there is a station-specific criterion different than the standard class criterion (some special curves are available in the \"Curves\" tab; you may also add your own, though you will have to unlock the worksheet to edit this tab). You might also want to change the curve numbers if you believe the default curves do not accurately reflect expected conditions for your stream. Or, for example, you may want to use the small PS TN curves but keep the standard TP curves. Keep in mind, however, that if you do not use the standard curve numbers, your results will not be comparable with other stations where standard curves were used."]
["5. Click the \"Calc Interim WQI Scores\" button. This converts individual sample results to scores (stored under the \"Interim Results\" tab) and aggregates monthly scores."]
["6. Click the \"Calc Constituent & Overall Scores\" button. This aggregates the constituent scores and determines the overall score. "]
["If you have trouble"]
["Make sure your data are entered as numbers and not as text."]
["If you have added your own criteria curves, you must sort the \"Curves\" worksheet by parameter."]
["Make sure you have enabled macros. You may also need to set security to \"low\" (Tools/Macro/Security)"]
["Contact me (see below)"]
["For more information"]
["There is an overview of the WQI on the web here: http://www.ecy.wa.gov/programs/eap/fw_riv/docs/WQIOverview.html. A detailed description is here: http://www.ecy.wa.gov/biblio/0203052.html. You may contact Markus Von Prause at mvon461@ecy.wa.gov or 360 407-6681. You may download the most recent version of this application here: http://www.ecy.wa.gov/programs/eap/fw_riv/docs/WQIVer6.xls"]
["Change History"]
["11/19/02: Fixed a \"divide by zero\" error when no data were entered for a particular constituent or month."]
["11/19/02: Changed title of \"Calc Individual WQI scores\" button to \"Calc Interim WQI scores\""]
["11/19/02: Added text to instructions to clarify that security must be set to \"low\"/macros must be enabled to run the code."]
["12/13/02: Limited monthly scores to 1. (Overall score was also being miscalculated when monthly scores were <1.)"]
["09/10/03: Modified code to use similar ecoregions for ecoregions where there were insufficient data to develop curves. Added error handling for unrecognized stream class and ecoregion. "]
["06/25/04: Was behaving badly if some dates were missing. Modified code to correct this (re-sorting by original date order after determining minimum scores). This correction is released in version 3c."]
["06/03/2008: The curves that convert results to WQI scores for TP, TSS, temp, and Turb bend back down at very low results (e.g., TP<0.001mg/L), resulting in poorer than expected WQI scores. Added code to set WQI=100 for these constituents when results < 0.003, 1, 5, and 1, respectively."]
["02/20/2009: Modified curves and curve selection procedures to incorporate 2006 water quality standards.  This version is released as WQIVer4. Supplemental criteria have not been implemented in the spreadsheet, yet, though curves are available on the \"curves\" tab. "]
["03/30/2009: Corrected some \"comments\". No substantive changes."]
["07/01/2009: Major Change: Added supplemental spawning curves and dropdown to select them. Also adapted code: previous date range had been based on whole months (01/01 represented January). Sup curves include partial months (e.g., 02/15) so changed curves to decimal months. Corrected bug that resulted in some missing data being given WQI scores of 100. Corrected and tweaked some other curves to more closely match criteria at WQI=80. This version is released as WQIVer5. "]
["3/1/2014: Corrected a bug that was preventing non-standard curves from being used (i.e., curves in main tab row 10 rather than row 11 were being used).  Also combined the spreadsheet for Small Puget Sound streams with the standard WQI spreadsheet by adding the small PS streams TN and TP curves and a metadata option to select those curves. "]

{"sheet":"Main","index":1,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[7,2,7,3],[1,2,1,3],[2,2,2,3],[3,2,3,3],[5,2,5,3],[6,2,6,3],[4,2,4,3]]}
["A Water Quality Index for Washington State streams (Version 6: 2014.06.11)."]
["Station: ",null,"05B070",null,null,null,null,null,null,"KEY"]
["Recreation Use:",null,"Primary",null,null,null,null,null,null,"Input                    "]
["Aquatic Life (Temperature):",null,"Core(16)",null,null,null,null,null,null,"Low Concern"]
["Aquatic Life (Oxygen):",null,"Core",null,null,null,null,null,null,"Moderate Concern"]
["Supplemental Spawning:",null,"09/01 to 07/01",null,null,null,null,null,null,"High Concern"]
["Ecoregion:",null,"2",null,null,null,"OutSeason",{"$f":"IF(class=\"Core(16)\",5,IF(class=\"Special(20)\",3,4))","v":5}]
["Small Puget Sound Stream:",null,"Yes",null,null,null,"SupSpawn",{"$f":"H7 & IF(VLOOKUP(C6,Curves!$C$235:$D$253,2,FALSE)<10, 0,) & VLOOKUP(C6,Curves!$C$235:$D$253,2,FALSE)","v":"514"}]
[null,null,"Warning: The Small PS streams setting was designed for Ecoregion 2 streams. "]
[null,"Default Curve No.:",{"$f":"VLOOKUP($C$3,Curves!$C$215:$D$217,2,FALSE)","v":51},{"$f":"VLOOKUP($C$5,Curves!$C$220:$D$225,2,FALSE)","v":26},41,{"$f":"IF($C$8=\"Yes\",272,VLOOKUP($C$7,Curves!$C$256:$D$263,2,FALSE))","v":272},{"$f":"VLOOKUP($C$7,Curves!$C$286:$D$293,2,FALSE)","v":82},{"$f":"IF(C4=\"Char(12)\",7,IF(VLOOKUP(C6,Curves!$C$235:$D$253,2,FALSE)=0,VLOOKUP(class,Curves!$C$228:$D$233,2,FALSE),H8))","v":"514"},{"$f":"IF($C$8=\"Yes\",262,VLOOKUP($C$7,Curves!$C$266:$D$273,2,FALSE))","v":262},{"$f":"VLOOKUP($C$7,Curves!$C$276:$D$283,2,FALSE)","v":92}]
[null,"Curve to Use:",{"$f":"C10","v":51},{"$f":"D10","v":26},41,272,82,"514",{"$f":"I10","v":262},92]
[null,null,"FC","Oxygen","pH","TP","TSS","Temp","TN","Turbidity","Monthly "]
[null,"Date","col/100mL","mg/L","std. Units","mg/L","mg/L","C","mg/L","NTU","Scores"]
[null,"2009-10-20",25,10.19,7.16,4.4900000000000002E-2,24,9.6999999999999993,0.14899999999999999,14,{"$f":"'Interim Results'!O14","v":81.073416742828314}]
[null,"2009-11-17",33,12,null,0.47699999999999998,529,6,2.31,300,{"$f":"'Interim Results'!O15","v":32.651119551877407}]
[null,"2009-12-15",8,13.1,7.44,2.2800000000000001E-2,10,3.1,3.4380000000000002,7.4,{"$f":"'Interim Results'!O16","v":96.779219097392755}]
[null,"2010-01-26",1,12.6,7.37,1.43E-2,6,4.7,1.02,6.1,{"$f":"'Interim Results'!O17","v":98.301354808892825}]
[null,"2010-02-23",1,13.3,7.57,1.1599999999999999E-2,4,5.0999999999999996,0.52700000000000002,2.7,{"$f":"'Interim Results'!O18","v":99.68457271471938}]
[null,"2010-03-16",2,12.5,7.48,1.1299999999999999E-2,6,7.4,0.33800000000000002,5.0999999999999996,{"$f":"'Interim Results'!O19","v":98.825529495659381}]
[null,"2010-04-20",4,12.4,7.18,2.0400000000000001E-2,17,7.5,0.32800000000000001,12,{"$f":"'Interim Results'!O20","v":95.304687386729157}]
[null,"2010-05-18",7,11.4,7.51,1.0800000000000001E-2,6,10.3,2,3.8,{"$f":"'Interim Results'!O21","v":97.015450764466607}]
[null,"2010-06-22",2,10.9,7.6,8.0999999999999996E-3,3,14,3,1.9,{"$f":"'Interim Results'!O22","v":89.335724803669436}]
[null,"2010-07-27",4,10.3,8.4600000000000009,0.5,7,20.100000000000001,1.5,2,{"$f":"'Interim Results'!O23","v":66.102516084484819}]
[null,"2010-08-24",4,10.9,8.42,1.2200000000000001E-2,2,19.3,3,0.7,{"$f":"'Interim Results'!O24","v":81.464432884000004}]
[null,"2010-09-28",44,10.6,7.21,3.9399999999999998E-2,35,15,2,22,{"$f":"'Interim Results'!O25","v":65.992735202540672}]
[null,"Constituent Scores:",91,87,81,32,51,64,2,50]
[null,null,null,null,null,null,null,null,null,"Overall Score:",55]

{"sheet":"Interim Results","index":2,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Interim Scores: Individual results converted to WQI scores.",null,null,null,null,null,null,null,null,"Nutrient","Sediment",null,null,"Monthly"]
[null,{"$f":"Main!B13","v":"Date"},{"$f":"Main!C12","v":"FC"},{"$f":"Main!D12","v":"Oxygen"},{"$f":"Main!E12","v":"pH"},{"$f":"Main!F12","v":"TP"},{"$f":"Main!G12","v":"TSS"},{"$f":"Main!H12","v":"Temp"},{"$f":"Main!I12","v":"TN"},{"$f":"Main!J12","v":"Turbidity"},"Score","Score","Penalty","Count","Score"]
[1,{"$f":"Main!B14","v":"2009-10-20"},92.884928005491602,86.731628683000054,95.190783168000166,100,67.02192570924602,91.903843000000009,100,70.427092828389959,{"$f":"IF(Main!F14*Main!I14=0,MIN(F14,I14),IF(Main!I14/Main!F14<10,I14,IF(Main!I14/Main!F14>20,F14,MIN(F14,I14))))","v":100},{"$f":"IF(G14*J14=0,MAX(G14,J14),2/(1/G14+1/J14))","v":68.682329400119528},{"$f":"IF(AND(C14<80,C14>0),(85-C14)/2,0)+IF(AND(D14<80,D14>0),(85-D14)/2,0)+IF(AND(E14<80,E14>0),(85-E14)/2,0)+IF(AND(H14<80,H14>0),(85-H14)/2,0)+IF(AND(K14<80,K14>0),IF((85-K14)/2>20,20,(85-K14)/2),0)+IF(AND(L14<80,L14>0),IF((85-L14)/2>20,20,(85-L14)/2),0)","v":8.158835299940236},{"$f":"COUNTIF(C14:E14,\">0\")+COUNTIF(H14:H14,\">0\")+COUNTIF(K14:L14,\">0\")","v":6},{"$f":"IF(N14=0,0,IF((C14+D14+E14+H14+K14+L14)/N14-M14<1,1,(C14+D14+E14+H14+K14+L14)/N14-M14))","v":81.073416742828314}]
[2,{"$f":"Main!B15","v":"2009-11-17"},90.714346078773772,98.768320000000045,null,5.1296672663062832,25.065228080821598,100,47.702810479999997,15.708260308449098,{"$f":"IF(Main!F15*Main!I15=0,MIN(F15,I15),IF(Main!I15/Main!F15<10,I15,IF(Main!I15/Main!F15>20,F15,MIN(F15,I15))))","v":47.702810479999997},19.313095000613277,38.648594760000002,5,32.651119551877407]
[3,{"$f":"Main!B16","v":"2009-12-15"},99.718671523650258,100,99.023671808000017,90.311808263168658,92.716143959636312,100,3.5426103391999897,90.551743664196565,{"$f":"IF(Main!F16*Main!I16=0,MIN(F16,I16),IF(Main!I16/Main!F16<10,I16,IF(Main!I16/Main!F16>20,F16,MIN(F16,I16))))","v":90.311808263168658},91.621162989537694,0,6,96.779219097392755]
[4,{"$f":"Main!B17","v":"2010-01-26"},100,100,98.211372432000076,97.154892076064527,96.481760156409109,100,97.758494719999987,92.486440823630119,{"$f":"IF(Main!F17*Main!I17=0,MIN(F17,I17),IF(Main!I17/Main!F17<10,I17,IF(Main!I17/Main!F17>20,F17,MIN(F17,I17))))","v":97.154892076064527},94.441864345292373,0,6,98.301354808892825]
[5,{"$f":"Main!B18","v":"2010-02-23"},100,100,99.838671638999926,99.68641544930999,98.668154200511054,100,100,98.496693307409416,{"$f":"IF(Main!F18*Main!I18=0,MIN(F18,I18),IF(Main!I18/Main!F18<10,I18,IF(Main!I18/Main!F18>20,F18,MIN(F18,I18))))","v":99.68641544930999},98.582349200006419,0,6,99.68457271471938]
[6,{"$f":"Main!B19","v":"2010-03-16"},100,100,99.444165312000109,99.979933136918689,96.481760156409109,98.250531999999993,100,94.104973543329223,{"$f":"IF(Main!F19*Main!I19=0,MIN(F19,I19),IF(Main!I19/Main!F19<10,I19,IF(Main!I19/Main!F19>20,F19,MIN(F19,I19))))","v":99.979933136918689},95.278546525037385,0,6,98.825529495659381]
[7,{"$f":"Main!B20","v":"2010-04-20"},100,100,95.516179871999952,92.093723121371653,87.610803132145975,98.007874999999999,100,84.85395763783724,{"$f":"IF(Main!F20*Main!I20=0,MIN(F20,I20),IF(Main!I20/Main!F20<10,I20,IF(Main!I20/Main!F20>20,F20,MIN(F20,I20))))","v":92.093723121371653},86.210346327003307,0,6,95.304687386729157]
[8,{"$f":"Main!B21","v":"2010-05-18"},100,95.666858800000028,100,100,96.481760156409109,89.984922999999995,59.775199999999998,96.40011997263727,{"$f":"IF(Main!F21*Main!I21=0,MIN(F21,I21),IF(Main!I21/Main!F21<10,I21,IF(Main!I21/Main!F21>20,F21,MIN(F21,I21))))","v":100},96.440922786799632,0,6,97.015450764466607]
[9,{"$f":"Main!B22","v":"2010-06-22"},100,92.409124300000059,99.450993599999947,100,96.683606889408836,75.744400000000013,1,95.674944039717801,{"$f":"IF(Main!F22*Main!I22=0,MIN(F22,I22),IF(Main!I22/Main!F22<10,I22,IF(Main!I22/Main!F22>20,F22,MIN(F22,I22))))","v":100},96.176630922016514,4.6277999999999935,6,89.335724803669436]
[10,{"$f":"Main!B23","v":"2010-07-27"},100,87.692022700000052,81.195693276000043,1,85.32634990239896,63.722935099999994,73.207000000000008,95.232410103674994,{"$f":"IF(Main!F23*Main!I23=0,MIN(F23,I23),IF(Main!I23/Main!F23<10,I23,IF(Main!I23/Main!F23>20,F23,MIN(F23,I23))))","v":73.207000000000008},90.007640130908896,16.535032449999999,6,66.102516084484819]
[11,{"$f":"Main!B24","v":"2010-08-24"},100,92.409124300000059,82.350830203999976,100,100,67.256660699999998,1,100,{"$f":"IF(Main!F24*Main!I24=0,MIN(F24,I24),IF(Main!I24/Main!F24<10,I24,IF(Main!I24/Main!F24>20,F24,MIN(F24,I24))))","v":100},100,8.8716696500000012,6,81.464432884000004]
[12,{"$f":"Main!B25","v":"2010-09-28"},88.256232574272545,90.160730800000039,95.9893848480001,100,60.993024960237115,71.184500000000014,34.70800000000002,62.429730542462707,{"$f":"IF(Main!F25*Main!I25=0,MIN(F25,I25),IF(Main!I25/Main!F25<10,I25,IF(Main!I25/Main!F25>20,F25,MIN(F25,I25))))","v":100},61.703015748242819,18.556242125878583,6,65.992735202540672]

{"sheet":"Curves","index":3,"n_rows":297,"n_cols":14,"rows_kept":297,"cut":false,"hidden":false,"merged":[]}
["ParamClassID","param","WQIClass","Glacial","Criterion","Start Month","End Month","LowerResult","UpperResult","a","b","b2","Comments"]
[51,"FC","Primary",false,100,1,13,0,999999,103.59,0.81005499999999997,-1.28485,"WQI=LN(x)"]
[52,"FC","Secondary",false,200,1,13,0,999999,102.944,2.5972300000000001,-1.3061199999999999,"WQI=LN(x)"]
[53,"FC","Extraordinary",false,50,1,13,0,999999,103.05,-0.58320000000000005,-1.3564099999999999,"WQI=LN(x)"]
[21,"Oxygen","Spawning",false,8,1,13,0,12,-67.025499999999994,27.5473,-1.14663,""]
[21,"Oxygen","Spawning",false,8,1,13,12.000999999999999,99,100,0,0,""]
[22,"Oxygen","Rearing",false,6.5,1,13,0,8.5,-109.509,43.652900000000002,-2.23081,""]
[22,"Oxygen","Rearing",false,6.5,1,13,8.5009999999999994,99,100,0,0,""]
[23,"Oxygen","Char",false,9.5,1,13,12.500999999999999,99,100,0,0,""]
[23,"Oxygen","Char",false,9.5,1,13,0,12.5,-130.69999999999999,33.81,-1.22397,""]
[24,"Oxygen","S1",false,8,9.5,13,12.000999999999999,99,100,0,0,""]
[24,"Oxygen","S1",false,8,9.5,13,0,12,-67.025499999999994,27.5473,-1.14663,""]
[24,"Oxygen","S1",false,5,6,9.5,7.5010000000000003,99,100,0,0,""]
[24,"Oxygen","S1",false,5,6,9.5,0,7.5,-64.444400000000002,42.777799999999999,-2.7778,"Limited to >5.0 Jun1 through Sep15. (This evaluates ALL of Sep against 5.0 criterion)"]
[24,"Oxygen","S1",false,8,1,6,0,12,-67.025499999999994,27.5473,-1.14663,""]
[24,"Oxygen","S1",false,8,1,6,12.000999999999999,99,100,0,0,""]
[25,"Oxygen","S2",false,5,1,13,0,7.5,-64.444400000000002,42.777799999999999,-2.7778,"Limited to >5.0  year round"]
[25,"Oxygen","S2",false,5,1,13,7.5010000000000003,99,100,0,0,""]
[26,"Oxygen","Core",false,9.5,1,13,0,12.5,-130.69999999999999,33.81,-1.22397,""]
[26,"Oxygen","Core",false,9.5,1,13,12.5,99,100,0,0,""]
[41,"pH","All Uses",false,8.5,1,13,7.5010000000000003,9.9,-339.16199999999998,128.62700000000001,-9.3308900000000001,""]
[41,"pH","All Uses",false,6.5,1,13,4,7.5,-531.62199999999996,158.619,-9.9267199999999995,""]
[81,"SUSSOL","1","No",0,1,6,0,999999,100.7321,-5.1737700000000002,-1.3147800000000001,"WQI=LN(x)"]
[81,"SUSSOL","1","No",0,6,11,0,999999,102.34439999999999,-19.28875,8.7332000000000007E-2,"WQI=LN(x)"]
[81,"SUSSOL","1","No",0,11,13,0,999999,100.7321,-5.1737700000000002,-1.3147800000000001,"WQI=LN(x)"]
[82,"SUSSOL","2","No",0,1,6,0,999999,100.7779,1.4727300000000001,-2.1601400000000002,"WQI=LN(x)"]
[82,"SUSSOL","2","No",0,6,11,0,999999,109.9171,-11.278700000000001,-0.69810300000000003,"WQI=LN(x)"]
[82,"SUSSOL","2","No",0,11,13,0,999999,100.7779,1.4727300000000001,-2.1601400000000002,"WQI=LN(x)"]
[83,"SUSSOL","4","No",0,1,6,0,999999,100.90779999999999,-7.1955999999999998,-2.2653599999999998,"WQI=LN(x)"]
[83,"SUSSOL","4","No",0,6,11,0,999999,102.5005,-26.039000000000001,-0.768096,"WQI=LN(x)"]
[83,"SUSSOL","4","No",0,11,13,0,999999,100.90779999999999,-7.1955999999999998,-2.2653599999999998,"WQI=LN(x)"]
[84,"SUSSOL","7","No",0,1,6,0,999999,101.1482,-4.2313599999999996,-1.33006,"WQI=LN(x)"]
[84,"SUSSOL","7","No",0,6,11,0,999999,100.2034,8.4970599999999994,-5.1793699999999996,"WQI=LN(x)"]
[84,"SUSSOL","7","No",0,11,13,0,999999,101.1482,-4.2313599999999996,-1.33006,"WQI=LN(x)"]
[85,"SUSSOL","8","No",0,1,6,0,999999,102.687,-17.525600000000001,0.46776899999999999,"WQI=LN(x)"]
[85,"SUSSOL","8","No",0,6,11,0,999999,101.9152,-17.276499999999999,-1.3942399999999999,"WQI=LN(x)"]
[85,"SUSSOL","8","No",0,11,13,0,999999,102.687,-17.525600000000001,0.46776899999999999,"WQI=LN(x)"]
[6,"Temp","Special(21)","NA",21,1,13,-9,99,88.123400000000004,3.9807999999999999,-0.20788499999999999,""]
[7,"Temp","Char(12)","NA",12,1,13,-9,99,103.85,-0.17219999999999999,-0.15129999999999999,""]
[8,"Temp","Core(16)","NA",16,1,13,-9,99,99.92,0.92390700000000003,-0.13556000000000001,""]
[9,"Temp","Spawn(17.5)","NA",17.5,1,13,-9,99,105.345,0.92390700000000003,-0.13556000000000001,""]
[10,"Temp","Rear(17.5)","NA",17.5,1,13,-9,99,105.345,0.92390700000000003,-0.13556000000000001,""]
[13,"Temp","Special(20)","NA",20,1,13,-9,99,104.8229,2.0088599999999999,-0.16245299999999999,""]
[301,"Temp","SpecialSupSalm","NA",20,1,2.5,-9,99,104.8229,2.0088599999999999,-0.16245299999999999,"Special Temp Exception with Sup Salm spawning",{"$f":"VALUE(TRIM(SUBSTITUTE(E44,CHAR(160),CHAR(32))) )","v":20}]
[301,"Temp","SpecialSupSalm","NA",13,2.5,6,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Special Temp Exception with Sup Salm spawning"]
[301,"Temp","SpecialSupSalm","NA",20,6,13,-9,99,104.8229,2.0088599999999999,-0.16245299999999999,"Special Temp Exception with Sup Salm spawning"]
[401,"Temp","SpawnSupSalm","NA",17.5,1,2.5,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[401,"Temp","SpawnSupSalm","NA",13,2.5,6,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[401,"Temp","SpawnSupSalm","NA",17.5,6,13,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[402,"Temp","SpawnSupSalm","NA",17.5,1,2.5,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[402,"Temp","SpawnSupSalm","NA",13,2.5,6.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[402,"Temp","SpawnSupSalm","NA",17.5,6.5,13,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[403,"Temp","SpawnSupSalm","NA",17.5,1,2.5,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[403,"Temp","SpawnSupSalm","NA",13,2.5,7,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[403,"Temp","SpawnSupSalm","NA",17.5,7,13,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[404,"Temp","SpawnSupSalm","NA",13,1,5.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[404,"Temp","SpawnSupSalm","NA",17.5,5.5,8.5,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[404,"Temp","SpawnSupSalm","NA",13,8.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[405,"Temp","SpawnSupSalm","NA",13,1,5.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[405,"Temp","SpawnSupSalm","NA",17.5,5.5,9,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[405,"Temp","SpawnSupSalm","NA",13,9,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[406,"Temp","SpawnSupSalm","NA",13,1,5.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[406,"Temp","SpawnSupSalm","NA",17.5,5.5,9.5,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[406,"Temp","SpawnSupSalm","NA",13,9.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[407,"Temp","SpawnSupSalm","NA",13,1,5.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[407,"Temp","SpawnSupSalm","NA",17.5,5.5,10,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[407,"Temp","SpawnSupSalm","NA",13,10,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[408,"Temp","SpawnSupSalm","NA",13,1,6.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[408,"Temp","SpawnSupSalm","NA",17.5,6.5,8,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[408,"Temp","SpawnSupSalm","NA",13,8,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[409,"Temp","SpawnSupSalm","NA",13,1,6.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[409,"Temp","SpawnSupSalm","NA",17.5,6.5,8.5,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[409,"Temp","SpawnSupSalm","NA",13,8.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[410,"Temp","SpawnSupSalm","NA",13,1,6.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[410,"Temp","SpawnSupSalm","NA",17.5,6.5,9,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[410,"Temp","SpawnSupSalm","NA",13,9,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[411,"Temp","SpawnSupSalm","NA",13,1,6.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[411,"Temp","SpawnSupSalm","NA",17.5,6.5,9.5,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[411,"Temp","SpawnSupSalm","NA",13,9.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[412,"Temp","SpawnSupSalm","NA",13,1,6.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[412,"Temp","SpawnSupSalm","NA",17.5,6.5,10,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[412,"Temp","SpawnSupSalm","NA",13,10,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[413,"Temp","SpawnSupSalm","NA",13,1,7,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[413,"Temp","SpawnSupSalm","NA",17.5,7,8.5,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[413,"Temp","SpawnSupSalm","NA",13,8.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[414,"Temp","SpawnSupSalm","NA",13,1,7,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[414,"Temp","SpawnSupSalm","NA",17.5,7,9,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[414,"Temp","SpawnSupSalm","NA",13,9,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[415,"Temp","SpawnSupSalm","NA",13,1,7,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[415,"Temp","SpawnSupSalm","NA",17.5,7,9.5,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[415,"Temp","SpawnSupSalm","NA",13,9.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[416,"Temp","SpawnSupSalm","NA",13,1,7.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[416,"Temp","SpawnSupSalm","NA",17.5,7.5,8,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[416,"Temp","SpawnSupSalm","NA",13,8,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[417,"Temp","SpawnSupSalm","NA",13,1,7.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[417,"Temp","SpawnSupSalm","NA",17.5,7.5,8.5,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[417,"Temp","SpawnSupSalm","NA",13,8.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[418,"Temp","SpawnSupSalm","NA",13,1,7.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[418,"Temp","SpawnSupSalm","NA",17.5,7.5,9,-9,99,105.345,0.92390700000000003,-0.13556000000000001,"Spawning with Sup Salm spawning"]
[418,"Temp","SpawnSupSalm","NA",13,9,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Spawning with Sup Salm spawning"]
[501,"Temp","CoreSupSalm","NA",16,1,2.5,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[501,"Temp","CoreSupSalm","NA",13,2.5,6,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[501,"Temp","CoreSupSalm","NA",16,6,13,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[502,"Temp","CoreSupSalm","NA",16,1,2.5,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[502,"Temp","CoreSupSalm","NA",13,2.5,6.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[502,"Temp","CoreSupSalm","NA",16,6.5,13,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[503,"Temp","CoreSupSalm","NA",16,1,2.5,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[503,"Temp","CoreSupSalm","NA",13,2.5,7,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[503,"Temp","CoreSupSalm","NA",16,7,13,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[504,"Temp","CoreSupSalm","NA",13,1,5.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[504,"Temp","CoreSupSalm","NA",16,5.5,8.5,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[504,"Temp","CoreSupSalm","NA",13,8.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[505,"Temp","CoreSupSalm","NA",13,1,5.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[505,"Temp","CoreSupSalm","NA",16,5.5,9,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[505,"Temp","CoreSupSalm","NA",13,9,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[506,"Temp","CoreSupSalm","NA",13,1,5.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[506,"Temp","CoreSupSalm","NA",16,5.5,9.5,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[506,"Temp","CoreSupSalm","NA",13,9.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[507,"Temp","CoreSupSalm","NA",13,1,5.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[507,"Temp","CoreSupSalm","NA",16,5.5,10,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[507,"Temp","CoreSupSalm","NA",13,10,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[508,"Temp","CoreSupSalm","NA",13,1,6.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[508,"Temp","CoreSupSalm","NA",16,6.5,8,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[508,"Temp","CoreSupSalm","NA",13,8,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[509,"Temp","CoreSupSalm","NA",13,1,6.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[509,"Temp","CoreSupSalm","NA",16,6.5,8.5,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[509,"Temp","CoreSupSalm","NA",13,8.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[510,"Temp","CoreSupSalm","NA",13,1,6.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[510,"Temp","CoreSupSalm","NA",16,6.5,9,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[510,"Temp","CoreSupSalm","NA",13,9,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[511,"Temp","CoreSupSalm","NA",13,1,6.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[511,"Temp","CoreSupSalm","NA",16,6.5,9.5,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[511,"Temp","CoreSupSalm","NA",13,9.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[512,"Temp","CoreSupSalm","NA",13,1,6.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[512,"Temp","CoreSupSalm","NA",16,6.5,10,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[512,"Temp","CoreSupSalm","NA",13,10,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[513,"Temp","CoreSupSalm","NA",13,1,7,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[513,"Temp","CoreSupSalm","NA",16,7,8.5,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[513,"Temp","CoreSupSalm","NA",13,8.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[514,"Temp","CoreSupSalm","NA",13,1,7,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[514,"Temp","CoreSupSalm","NA",16,7,9,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[514,"Temp","CoreSupSalm","NA",13,9,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[515,"Temp","CoreSupSalm","NA",13,1,7,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[515,"Temp","CoreSupSalm","NA",16,7,9.5,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[515,"Temp","CoreSupSalm","NA",13,9.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[516,"Temp","CoreSupSalm","NA",13,1,7.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[516,"Temp","CoreSupSalm","NA",16,7.5,8,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[516,"Temp","CoreSupSalm","NA",13,8,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[517,"Temp","CoreSupSalm","NA",13,1,7.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[517,"Temp","CoreSupSalm","NA",16,7.5,8.5,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[517,"Temp","CoreSupSalm","NA",13,8.5,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[518,"Temp","CoreSupSalm","NA",13,1,7.5,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[518,"Temp","CoreSupSalm","NA",16,7.5,9,-9,99,99.92,0.92390700000000003,-0.13556000000000001,"Core with Sup salm spawning"]
[518,"Temp","CoreSupSalm","NA",13,9,13,-9,99,107.81,-0.17219999999999999,-0.15129999999999999,"Core with Sup salm spawning"]
[71,"TP_P","1","NA",0,1,6,0,999,-22.304300000000001,-31.206700000000001,-0.90880000000000005,"WQI=LN(x)"]
[71,"TP_P","1","NA",0,6,11,0,999,-45.643500000000003,-22.435700000000001,2.11808,"WQI=LN(x)"]
[71,"TP_P","1","NA",0,11,13,0,999,-22.304300000000001,-31.206700000000001,-0.90880000000000005,"WQI=LN(x)"]
[72,"TP_P","2","NA",0,1,6,0,999,-26.2561,-45.216000000000001,-3.8048299999999999,"WQI=LN(x)"]
[72,"TP_P","2","NA",0,6,11,0,999,-68.002300000000005,-57.864800000000002,-4.5721100000000003,"WQI=LN(x)"]
[72,"TP_P","2","NA",0,11,13,0,999,-26.2561,-45.216000000000001,-3.8048299999999999,"WQI=LN(x)"]
[272,"TP_P","2","SmallPS",0,1,6,0,999,-26.2561,-45.216000000000001,-3.8048299999999999,"WQI=LN(x)"]
[272,"TP_P","2","SmallPS",0,6,11,0,999,-50.905999999999999,-3.6518999999999999,18.805,"WQI=LN(x)"]
[272,"TP_P","2","SmallPS",0,11,13,0,999,-26.2561,-45.216000000000001,-3.8048299999999999,"WQI=LN(x)"]
[73,"TP_P","4","NA",0,1,6,0,999,-26.6586,-13.732699999999999,3.0929500000000001,"WQI=LN(x)"]
[73,"TP_P","4","NA",0,6,11,0,999,-82.350999999999999,-38.609099999999998,0,"WQI=LN(x)"]
[73,"TP_P","4","NA",0,11,13,0,999,-26.6586,-13.732699999999999,3.0929500000000001,"WQI=LN(x)"]
[74,"TP_P","7","NA",0,1,6,0,999,24.1568,-26.811299999999999,-2.1863600000000001,"WQI=LN(x)"]
[74,"TP_P","7","NA",0,6,11,0,999,28.3779,-17.2759,-0.2800899,"WQI=LN(x)"]
[74,"TP_P","7","NA",0,11,13,0,999,24.1568,-26.811299999999999,-2.1863600000000001,"WQI=LN(x)"]
[75,"TP_P","8","NA",0,1,6,0,999,-57.611699999999999,-58.0565,-5.11388,"WQI=LN(x)"]
[75,"TP_P","8","NA",0,6,11,0,999,-39.280500000000004,-29.718699999999998,0.2257024,"WQI=LN(x)"]
[75,"TP_P","8","NA",0,11,13,0,999,-57.611699999999999,-58.0565,-5.11388,"WQI=LN(x)"]
[61,"TPN","1","NA",0,1,6,0,999,102.3021,-43.188200000000002,-19.764099999999999,""]
[61,"TPN","1","NA",0,6,11,0,999,102.9609,-95.946299999999994,0,""]
[61,"TPN","1","NA",0,11,13,0,999,102.3021,-43.188200000000002,-19.764099999999999,""]
[62,"TPN","2","NA",0,1,6,0,999,102.55,-3.8620199999999998,-61.136400000000002,""]
[62,"TPN","2","NA",0,6,11,0,999,103.47790000000001,-42.563600000000001,-51.561100000000003,""]
[62,"TPN","2","NA",0,11,13,0,999,102.55,-3.8620199999999998,-61.136400000000002,""]
[262,"TPN","2","SmallPS",0,1,6,0,999,137,-38.326000000000001,-0.14319999999999999,""]
[262,"TPN","2","SmallPS",0,6,11,0,999,230.08,-125.27,13.792,""]
[262,"TPN","2","SmallPS",0,11,13,0,999,137,-38.326000000000001,-0.14319999999999999,""]
[63,"TPN","4","NA",0,1,6,0,999,113.2895,-239.5035,0,""]
[63,"TPN","4","NA",0,6,11,0,999,109.63,-296.29599999999999,0,""]
[63,"TPN","4","NA",0,11,13,0,999,113.2895,-239.5035,0,""]
[64,"TPN","7","NA",0,1,6,0,999,100.9614,-15.1479,0.66225500000000004,""]
[64,"TPN","7","NA",0,6,11,0,999,100,-14.14,0,""]
[64,"TPN","7","NA",0,11,13,0,999,100.9614,-15.1479,0.66225500000000004,""]
[65,"TPN","8","NA",0,1,6,0,999,100.3186,4.9997999999999996,-31.269100000000002,""]
[65,"TPN","8","NA",0,6,11,0,999,100,10,-35,""]
[65,"TPN","8","NA",0,11,13,0,999,100.3186,4.9997999999999996,-31.269100000000002,""]
[91,"Turb","1","No",0,1,6,0,999999,99.662099999999995,-4.0524699999999996,-2.0052599999999998,"WQI=LN(x)"]
[91,"Turb","1","No",0,6,11,0,999999,92.357900000000001,-14.113300000000001,-1.1456999999999999,"WQI=LN(x)"]
[91,"Turb","1","No",0,11,13,0,999999,99.662099999999995,-4.0524699999999996,-2.0052599999999998,"WQI=LN(x)"]
[92,"Turb","2","No",0,1,6,0,999999,101.1178,-3.7926000000000001E-2,-2.6186600000000002,"WQI=LN(x)"]
[92,"Turb","2","No",0,6,11,0,999999,100.2948,-5.87364,-2.0628299999999999,"WQI=LN(x)"]
[92,"Turb","2","No",0,11,13,0,999999,101.1178,-3.7926000000000001E-2,-2.6186600000000002,"WQI=LN(x)"]
[93,"Turb","4","No",0,1,6,0,999999,90.964500000000001,-16.296600000000002,-0.30113099999999998,"WQI=LN(x)"]
[93,"Turb","4","No",0,6,11,0,999999,83.981499999999997,-26.125,0.61845000000000006,"WQI=LN(x)"]
[93,"Turb","4","No",0,11,13,0,999999,90.964500000000001,-16.296600000000002,-0.30113099999999998,"WQI=LN(x)"]
[94,"Turb","7","No",0,1,6,0,999999,99.162400000000005,-6.4344200000000003,-1.31263,"WQI=LN(x)"]
[94,"Turb","7","No",0,6,11,0,999999,99.619699999999995,-4.4316500000000003,-3.1983999999999999,"WQI=LN(x)"]
[94,"Turb","7","No",0,11,13,0,999999,99.162400000000005,-6.4344200000000003,-1.31263,"WQI=LN(x)"]
[95,"Turb","8","No",0,1,6,0,999999,96.111800000000002,-18.16,0.48294999999999999,"WQI=LN(x)"]
[95,"Turb","8","No",0,6,11,0,999999,93.4405,-23.241599999999998,-1.71641,"WQI=LN(x)"]
[95,"Turb","8","No",0,11,13,0,999999,96.111800000000002,-18.16,0.48294999999999999,"WQI=LN(x)"]
["IF MORE Curves are added, look for row \"205\" in VB code and change as necessary to include  all curves"]
[]
[]
[]
[]
[]
[null,null,"DropDownLists"]
[]
[null,null,"FCWQIClass"]
[{"$f":"A3","v":52},{"$f":"B3","v":"FC"},{"$f":"C3","v":"Secondary"},{"$f":"A215","v":52}]
[{"$f":"A2","v":51},{"$f":"B2","v":"FC"},{"$f":"C2","v":"Primary"},{"$f":"A216","v":51}]
[{"$f":"A4","v":53},{"$f":"B4","v":"FC"},{"$f":"C4","v":"Extraordinary"},{"$f":"A217","v":53}]
[]
[null,null,"OxygenWQIClass"]
[{"$f":"A7","v":22},{"$f":"B7","v":"Oxygen"},{"$f":"C7","v":"Rearing"},{"$f":"A220","v":22}]
[{"$f":"A19","v":26},{"$f":"B19","v":"Oxygen"},{"$f":"C19","v":"Core"},26]
[{"$f":"A9","v":23},{"$f":"B9","v":"Oxygen"},{"$f":"C9","v":"Char"},23]
[{"$f":"A5","v":21},{"$f":"B5","v":"Oxygen"},{"$f":"C5","v":"Spawning"},21]
[{"$f":"A17","v":25},{"$f":"B17","v":"Oxygen"},{"$f":"C17","v":"S2"},25]
[{"$f":"A11","v":24},{"$f":"B11","v":"Oxygen"},{"$f":"C11","v":"S1"},24]
[]
[null,null,"TempWQIClass"]
[6,"Temp","Special(21)",6]
[7,"Temp","Char(12)",7]
[8,"Temp","Core(16)",8]
[9,"Temp","Spawn(17.5)",9]
[10,"Temp","Rear(17.5)",10]
[13,"Temp","Special(20)",13]
[null,null,"Supplemental Spawning"]
[0,"Temp","None",0]
[1,"Temp","02/15 to 06/01",1]
[2,"Temp","02/15 to 06/15",2]
[3,"Temp","02/15 to 07/01",3]
[4,"Temp","08/15 to 05/15",4]
[5,"Temp","09/01 to 05/15",5]
[6,"Temp","09/15 to 05/15",6]
[7,"Temp","10/01 to 05/15",7]
[8,"Temp","08/01 to 06/15",8]
[9,"Temp","08/15 to 06/15",9]
[10,"Temp","09/01 to 06/15",10]
[11,"Temp","09/15 to 06/15",11]
[12,"Temp","10/01 to 06/15",12]
[13,"Temp","08/15 to 07/01",13]
[14,"Temp","09/01 to 07/01",14]
[15,"Temp","09/15 to 07/01",15]
[16,"Temp","08/01 to 07/15",16]
[17,"Temp","08/15 to 07/15",17]
[18,"Temp","09/01 to 07/15",18]
[]
[null,null,"TP"]
[{"$f":"A155","v":71},{"$f":"B155","v":"TP_P"},{"$f":"C155","v":"1"},{"$f":"A256","v":71}]
[{"$f":"A158","v":72},{"$f":"B158","v":"TP_P"},{"$f":"C158","v":"2"},{"$f":"A257","v":72}]
[{"$f":"A257","v":72},{"$f":"B257","v":"TP_P"},3,72]
[{"$f":"A164","v":73},{"$f":"B164","v":"TP_P"},{"$f":"C164","v":"4"},73]
[{"$f":"A259","v":73},{"$f":"B259","v":"TP_P"},6,73]
[{"$f":"A167","v":74},{"$f":"B167","v":"TP_P"},{"$f":"C167","v":"7"},74]
[{"$f":"A170","v":75},{"$f":"B170","v":"TP_P"},{"$f":"C170","v":"8"},75]
[{"$f":"A262","v":75},{"$f":"B262","v":"TP_P"},9,75]
[]
[null,null,"TN"]
[{"$f":"A173","v":61},{"$f":"B173","v":"TPN"},{"$f":"C173","v":"1"},61]
[{"$f":"A176","v":62},{"$f":"B176","v":"TPN"},{"$f":"C176","v":"2"},62]
[{"$f":"A267","v":62},{"$f":"B267","v":"TPN"},3,62]
[{"$f":"A182","v":63},{"$f":"B182","v":"TPN"},{"$f":"C182","v":"4"},63]
[{"$f":"A269","v":63},{"$f":"B269","v":"TPN"},6,63]
[{"$f":"A185","v":64},{"$f":"B185","v":"TPN"},{"$f":"C185","v":"7"},64]
[{"$f":"A188","v":65},{"$f":"B188","v":"TPN"},{"$f":"C188","v":"8"},65]
[{"$f":"A272","v":65},{"$f":"B272","v":"TPN"},9,65]
[]
[null,null,"Turb"]
[{"$f":"A191","v":91},{"$f":"B191","v":"Turb"},{"$f":"C191","v":"1"},91]
[{"$f":"A194","v":92},{"$f":"B194","v":"Turb"},{"$f":"C194","v":"2"},92]
[{"$f":"A277","v":92},{"$f":"B277","v":"Turb"},3,92]
[{"$f":"A197","v":93},{"$f":"B197","v":"Turb"},{"$f":"C197","v":"4"},93]
[{"$f":"A279","v":93},{"$f":"B279","v":"Turb"},6,93]
[{"$f":"A200","v":94},{"$f":"B200","v":"Turb"},{"$f":"C200","v":"7"},94]
[{"$f":"A203","v":95},{"$f":"B203","v":"Turb"},{"$f":"C203","v":"8"},95]
[{"$f":"A282","v":95},{"$f":"B282","v":"Turb"},9,95]
[]
[null,null,"TSS"]
[{"$f":"A23","v":81},{"$f":"B23","v":"SUSSOL"},{"$f":"C23","v":"1"},81]
[{"$f":"A26","v":82},{"$f":"B26","v":"SUSSOL"},{"$f":"C26","v":"2"},82]
[{"$f":"A287","v":82},{"$f":"B287","v":"SUSSOL"},3,82]
[{"$f":"A29","v":83},{"$f":"B29","v":"SUSSOL"},{"$f":"C29","v":"4"},83]
[{"$f":"A289","v":83},{"$f":"B289","v":"SUSSOL"},6,83]
[{"$f":"A32","v":84},{"$f":"B32","v":"SUSSOL"},{"$f":"C32","v":"7"},84]
[{"$f":"A35","v":85},{"$f":"B35","v":"SUSSOL"},{"$f":"C35","v":"8"},85]
[{"$f":"A292","v":85},{"$f":"B292","v":"SUSSOL"},9,85]
[]
[null,null,"YesNo"]
[null,null,"Yes"]
[null,null,"No"]

{"sheet":"Worksheet","index":4,"n_rows":30,"n_cols":32,"rows_kept":30,"cut":false,"hidden":false,"merged":[[16,31,16,32],[17,31,17,32],[16,25,16,26],[17,25,17,26],[16,27,16,28],[17,27,17,28],[16,29,16,30],[17,29,17,30],[16,19,16,20],[17,19,17,20],[16,21,16,22],[17,21,17,22],[16,23,16,24],[17,23,17,24],[16,13,16,14],[17,13,17,14],[16,15,16,16],[17,15,17,16],[16,17,16,18],[17,17,17,18],[16,7,16,8],[17,7,17,8],[16,9,16,10],[17,9,17,10],[16,11,16,12],[17,11,17,12],[16,1,17,1],[16,2,17,2],[16,3,16,4],[17,3,17,4],[16,5,16,6],[17,5,17,6]]}
["Data can be pasted here from databases or web sites (e.g., http://www.ecy.wa.gov/programs/eap/fw_riv/rv_main.html), "]
["cleaned up, then pasted to the \"Main\" worksheet."]
["STATION","date","Fecal Coliform Bacteria","Oxygen","pH","Phosphorus, Total","Suspended Solids","Temperature","Total Persulf Nitrogen","Turbidity"]
[{"$f":"A18","v":"01A050"},{"$f":"B19","v":"2009-10-20"},{"$f":"H19","v":25},{"$f":"P19","v":10.19},{"$f":"R19","v":7.16},{"$f":"AB19","v":4.4900000000000002E-2},{"$f":"V19","v":24},{"$f":"X19","v":9.6999999999999993},{"$f":"AD19","v":0.39400000000000002},{"$f":"AF19","v":14}]
["01A050",{"$f":"B20","v":"2009-11-17"},{"$f":"H20","v":33},{"$f":"P20","v":12},null,{"$f":"AB20","v":0.47699999999999998},{"$f":"V20","v":529},{"$f":"X20","v":6},{"$f":"AD20","v":0.19500000000000001},{"$f":"AF20","v":300}]
["01A050","2009-12-15",8,13.1,{"$f":"R21","v":7.44},2.2800000000000001E-2,10,3.1,0.27100000000000002,7.4]
["01A050","2010-01-26",1,12.6,7.37,1.43E-2,6,4.7,0.22500000000000001,6.1]
["01A050","2010-02-23",1,13.3,7.57,1.1599999999999999E-2,4,5.0999999999999996,0.19400000000000001,2.7]
["01A050","2010-03-16",2,12.5,7.48,1.1299999999999999E-2,6,7.4,0.16,5.0999999999999996]
["01A050","2010-04-20",4,12.4,7.18,2.0400000000000001E-2,17,7.5,0.121,12]
["01A050","2010-05-18",7,11.4,7.51,1.0800000000000001E-2,6,10.3,9.7000000000000003E-2,3.8]
["01A050","2010-06-22",2,10.9,7.6,8.0999999999999996E-3,3,14,8.8999999999999996E-2,1.9]
["01A050","2010-07-27",4,10.3,8.4600000000000009,9.7999999999999997E-3,7,20.100000000000001,6.2E-2,2]
["01A050","2010-08-24",4,10.9,8.42,1.2200000000000001E-2,2,19.3,9.6000000000000002E-2,0.7]
["01A050","2010-09-28",44,10.6,7.21,3.9399999999999998E-2,35,13.2,0.20100000000000001,22]
[]
["STATION","date","time","COND",null,"DOC",null,"FC",null,"NH3_N",null,"NO2_NO3",null,"OP_DIS",null,"OXYGEN",null,"PH",null,"PRESS",null,"SUSSOL",null,"TEMP",null,"TOC",null,"TP_P",null,"TPN",null,"TURB"]
["01A050",null,null,"(umhos/cm)",null,"(mg/L)",null,"(#/100ml)",null,"(mg/L)",null,"(mg/L)",null,"(mg/L)",null,"(mg/L)",null,"(pH)",null,"(mm/Hg)",null,"(mg/L)",null,"(deg C)",null,"(mg/L)",null,"(mg/L)",null,"(mg/L)",null,"(NTU)"]
["01A050","2009-10-20","12:45:00",56,null,null,null,25,null,4.4999999999999998E-2,null,0.315,null,1.2699999999999999E-2,null,10.19,null,7.16,null,763.27,null,24,null,9.6999999999999993,null,null,null,4.4900000000000002E-2,null,0.39400000000000002,null,14]
["01A050","2009-11-17","12:40:00",27,null,null,null,33,"J",1.2999999999999999E-2,null,0.17100000000000001,null,5.3E-3,null,12,null,null,null,758.19,null,529,"J",6,null,null,null,0.47699999999999998,null,0.19500000000000001,null,300]
["01A050","2009-12-15","12:15:00",75,null,null,null,8,null,0.01,"U",0.24099999999999999,null,9.2999999999999992E-3,null,13.1,null,7.44,null,754.38,null,10,null,3.1,null,null,null,2.2800000000000001E-2,null,0.27100000000000002,null,7.4]
["01A050","2010-01-26","14:15:00",60,null,null,null,1,"U",0.01,"U",0.20599999999999999,null,6.3E-3,null,12.6,null,7.37,null,759.46,null,6,null,4.7,null,null,null,1.43E-2,null,0.22500000000000001,null,6.1]
["01A050","2010-02-23","15:40:00",66,null,null,null,1,"U",0.01,"U",0.151,null,6.4999999999999997E-3,null,13.3,null,7.57,null,753.11,null,4,"J",5.0999999999999996,null,null,null,1.1599999999999999E-2,null,0.19400000000000001,null,2.7]
["01A050","2010-03-16","14:45:00",58,null,null,null,2,null,0.01,"U",0.13400000000000001,null,5.7000000000000002E-3,null,12.5,null,7.48,null,762,null,6,null,7.4,null,null,null,1.1299999999999999E-2,null,0.16,null,5.0999999999999996]
["01A050","2010-04-20","14:05:00",41,null,null,null,4,"J",0.01,"U",9.8000000000000004E-2,null,3.7000000000000002E-3,null,12.4,null,7.18,null,751.84,null,17,null,7.5,null,null,null,2.0400000000000001E-2,null,0.121,null,12]
["01A050","2010-05-18","15:35:00",43,null,null,null,7,null,0.01,"U",6.7000000000000004E-2,null,3.0000000000000001E-3,"U",11.4,null,7.51,null,754.38,null,6,null,10.3,null,null,null,1.0800000000000001E-2,null,9.7000000000000003E-2,null,3.8]
["01A050","2010-06-22","15:20:00",58,null,null,null,2,null,0.01,"U",6.3E-2,null,4.3E-3,null,10.9,null,7.6,null,759.46,null,3,null,14,null,null,null,8.0999999999999996E-3,null,8.8999999999999996E-2,null,1.9]
["01A050","2010-07-27","15:40:00",80,null,null,null,4,null,0.01,"U",0.01,"U",5.7000000000000002E-3,null,10.3,null,8.4600000000000009,null,754.38,null,7,null,20.100000000000001,null,null,null,9.7999999999999997E-3,null,6.2E-2,null,2]
["01A050","2010-08-24","16:50:00",101,null,1,"J",4,null,3.3000000000000002E-2,null,3.4000000000000002E-2,null,7.9000000000000008E-3,null,10.9,null,8.42,null,756.92,null,2,null,19.3,null,1,"J",1.2200000000000001E-2,null,9.6000000000000002E-2,null,0.7]
[null,"2010-09-28","13:40:00",35,null,null,null,44,null,0.01,"U",0.14000000000000001,null,3.5999999999999999E-3,null,10.6,null,7.21,null,759.46,null,35,"J",13.2,null,null,null,3.9399999999999998E-2,null,0.20100000000000001,null,22]

{"sheet":"1997Curves","index":5,"n_rows":88,"n_cols":13,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["ParamClassID","param","WQIClass","Glacial","Criterion","Start Month","End Month","LowerResult","UpperResult","a","b","b2","Comments"]
[51,"FC","A","No",100,1,12,0,999999,103.59,0.81005499999999997,-1.28485,"WQI=LN(x)"]
[53,"FC","AA","No",50,1,12,0,999999,103.25,-0.58320000000000005,-1.3564099999999999,"WQI=LN(x)"]
[52,"FC","B","No",200,1,12,0,999999,102.944,2.5972300000000001,-1.3061199999999999,"WQI=LN(x)"]
[21,"Oxygen","A","No",8,1,12,0,12,-67.325500000000005,27.5473,-1.14663,""]
[21,"Oxygen","A","No",8,1,12,12.000999999999999,99,100,0,0,""]
[23,"Oxygen","AA","No",9.5,1,12,0,12.5,-131.19999999999999,33.81,-1.22397,""]
[23,"Oxygen","AA","No",9.5,1,12,12.500999999999999,99,100,0,0,""]
[22,"Oxygen","B","No",6.5,1,12,0,8.5,-109.509,43.652900000000002,-2.23081,""]
[22,"Oxygen","B","No",6.5,1,12,8.5009999999999994,99,100,0,0,""]
[24,"Oxygen","S","No",5,6,9,0,7.5,-64.444400000000002,42.777799999999999,2.7778,"Limited to >5.0 Jun1 through Sep15. (This evaluates ALL of Sep against 5.0 criterion)"]
[24,"Oxygen","S","No",5,6,9,7.5010000000000003,99,100,0,0,""]
[24,"Oxygen","S","No",8,1,5,0,12,-62.325499999999998,27.5473,-1.14663,""]
[24,"Oxygen","S","No",8,1,5,12.000999999999999,99,100,0,0,""]
[24,"Oxygen","S","No",8,10,12,0,12,-62.325499999999998,27.5473,-1.14663,""]
[24,"Oxygen","S","No",8,10,12,12.000999999999999,99,100,0,0,""]
[25,"Oxygen","S2","No",5,1,12,0,7.5,-64.444400000000002,42.777799999999999,2.7778,"Limited to >5.0  year round"]
[25,"Oxygen","S2","No",5,1,12,7.5010000000000003,99,100,0,0,""]
[41,"pH","A","No",6.5,1,12,4,7.5,-531.42200000000003,158.619,-9.9267199999999995,""]
[41,"pH","A","No",8.5,1,12,7.5010000000000003,9.9,-338.91199999999998,128.62700000000001,-9.3308900000000001,""]
[43,"ph","AA","No",6.5,1,12,4,7.5,-531.42200000000003,158.619,-9.9267199999999995,""]
[43,"ph","AA","No",8.5,1,12,7.5010000000000003,9.9,-338.91199999999998,128.62700000000001,-9.3308900000000001,""]
[42,"pH","B","No",6.5,1,12,4,7.5,-531.42200000000003,158.619,-9.9267199999999995,""]
[42,"pH","B","No",8.5,1,12,7.5010000000000003,9.9,-338.91199999999998,128.62700000000001,-9.3308900000000001,""]
[81,"TSS","1","No",0,1,5,0,999999,100.7321,-5.1737700000000002,-1.3147800000000001,"WQI=LN(x)"]
[81,"TSS","1","No",0,6,10,0,999999,102.34439999999999,-19.28875,8.7332000000000007E-2,"WQI=LN(x)"]
[81,"TSS","1","No",0,11,12,0,999999,100.7321,-5.1737700000000002,-1.3147800000000001,"WQI=LN(x)"]
[82,"TSS","2","No",0,1,5,0,999999,100.7779,1.4727300000000001,-2.1601400000000002,"WQI=LN(x)"]
[82,"TSS","2","No",0,6,10,0,999999,109.9171,-11.278700000000001,-0.69810300000000003,"WQI=LN(x)"]
[82,"TSS","2","No",0,11,12,0,999999,100.7779,1.4727300000000001,-2.1601400000000002,"WQI=LN(x)"]
[83,"TSS","4","No",0,1,5,0,999999,100.90779999999999,-7.1955999999999998,-2.2653599999999998,"WQI=LN(x)"]
[83,"TSS","4","No",0,6,10,0,999999,102.5005,-26.039000000000001,-0.768096,"WQI=LN(x)"]
[83,"TSS","4","No",0,11,12,0,999999,100.90779999999999,-7.1955999999999998,-2.2653599999999998,"WQI=LN(x)"]
[84,"TSS","7","No",0,1,5,0,999999,101.1482,-4.2313599999999996,-1.33006,"WQI=LN(x)"]
[84,"TSS","7","No",0,6,10,0,999999,100.2034,8.4970599999999994,-5.1793699999999996,"WQI=LN(x)"]
[84,"TSS","7","No",0,11,12,0,999999,101.1482,-4.2313599999999996,-1.33006,"WQI=LN(x)"]
[85,"TSS","8","No",0,1,5,0,999999,102.687,-17.525600000000001,0.46776899999999999,"WQI=LN(x)"]
[85,"TSS","8","No",0,6,10,0,999999,101.9152,-17.276499999999999,-1.3942399999999999,"WQI=LN(x)"]
[85,"TSS","8","No",0,11,12,0,999999,102.687,-17.525600000000001,0.46776899999999999,"WQI=LN(x)"]
[11,"Temp","A","No",18,1,12,-9,99,107.61499999999999,0.92390700000000003,-0.13556299999999999,""]
[14,"Temp","AA","No",16,1,12,-9,99,100,0.92390700000000003,-0.13556299999999999,""]
[12,"Temp","B","No",21,1,12,-9,99,88.123400000000004,3.9807999999999999,-0.20788499999999999,""]
[13,"Temp","S","No",20,1,12,-9,99,104.8229,2.0088599999999999,-0.16245299999999999,""]
[71,"TP","1","No",0,1,5,0,999,-22.304300000000001,-31.206700000000001,-0.90880000000000005,"WQI=LN(x)"]
[71,"TP","1","No",0,6,10,0,999,-45.643500000000003,-22.435700000000001,2.11808,"WQI=LN(x)"]
[71,"TP","1","No",0,11,12,0,999,-22.304300000000001,-31.206700000000001,-0.90880000000000005,"WQI=LN(x)"]
[72,"TP","2","No",0,1,5,0,999,-26.2561,-45.216000000000001,-3.8048299999999999,"WQI=LN(x)"]
[72,"TP","2","No",0,6,10,0,999,-68.002300000000005,-57.864800000000002,-4.5721100000000003,"WQI=LN(x)"]
[72,"TP","2","No",0,11,12,0,999,-26.2561,-45.216000000000001,-3.8048299999999999,"WQI=LN(x)"]
[73,"TP","4","No",0,1,5,0,999,-26.6586,-13.732699999999999,3.0929500000000001,"WQI=LN(x)"]
[73,"TP","4","No",0,6,10,0,999,-82.350999999999999,-38.609099999999998,0,"WQI=LN(x)"]
[73,"TP","4","No",0,11,12,0,999,-26.6586,-13.732699999999999,3.0929500000000001,"WQI=LN(x)"]
[74,"TP","7","No",0,1,5,0,999,24.1568,-26.811299999999999,-2.1863600000000001,"WQI=LN(x)"]
[74,"TP","7","No",0,6,10,0,999,28.3779,-17.2759,-0.2800899,"WQI=LN(x)"]
[74,"TP","7","No",0,11,12,0,999,24.1568,-26.811299999999999,-2.1863600000000001,"WQI=LN(x)"]
[75,"TP","8","No",0,1,5,0,999,-57.611699999999999,-58.0565,-5.11388,"WQI=LN(x)"]
[75,"TP","8","No",0,6,10,0,999,-39.280500000000004,-29.718699999999998,0.2257024,"WQI=LN(x)"]
[75,"TP","8","No",0,11,12,0,999,-57.611699999999999,-58.0565,-5.11388,"WQI=LN(x)"]
[61,"TN","1","No",0,1,5,0,999,102.3021,-43.188200000000002,-19.764099999999999,""]
[61,"TN","1","No",0,6,10,0,999,102.9609,-95.946299999999994,0,""]
[61,"TN","1","No",0,11,12,0,999,102.3021,-43.188200000000002,-19.764099999999999,""]
[62,"TN","2","No",0,1,5,0,999,102.55,-3.8620199999999998,-61.136400000000002,""]
[62,"TN","2","No",0,6,10,0,999,103.47790000000001,-42.563600000000001,-51.561100000000003,""]
[62,"TN","2","No",0,11,12,0,999,102.55,-3.8620199999999998,-61.136400000000002,""]
[63,"TN","4","No",0,1,5,0,999,113.2895,-239.5035,0,""]
[63,"TN","4","No",0,6,10,0,999,109.63,-296.29599999999999,0,""]
[63,"TN","4","No",0,11,12,0,999,113.2895,-239.5035,0,""]
[64,"TN","7","No",0,1,5,0,999,100.9614,-15.1479,0.66225500000000004,""]
[64,"TN","7","No",0,6,10,0,999,100,-14.14,0,""]
[64,"TN","7","No",0,11,12,0,999,100.9614,-15.1479,0.66225500000000004,""]
[65,"TN","8","No",0,1,5,0,999,100.3186,4.9997999999999996,-31.269100000000002,""]
[65,"TN","8","No",0,6,10,0,999,100,10,-35,""]
[65,"TN","8","No",0,11,12,0,999,100.3186,4.9997999999999996,-31.269100000000002,""]
[91,"Turbidity","1","No",0,1,5,0,999999,99.662099999999995,-4.0524699999999996,-2.0052599999999998,"WQI=LN(x)"]
[91,"Turbidity","1","No",0,6,10,0,999999,92.357900000000001,-14.113300000000001,-1.1456999999999999,"WQI=LN(x)"]
[91,"Turbidity","1","No",0,11,12,0,999999,99.662099999999995,-4.0524699999999996,-2.0052599999999998,"WQI=LN(x)"]
[92,"Turbidity","2","No",0,1,5,0,999999,101.1178,-3.7926000000000001E-2,-2.6186600000000002,"WQI=LN(x)"]
[92,"Turbidity","2","No",0,6,10,0,999999,100.2948,-5.87364,-2.0628299999999999,"WQI=LN(x)"]
[92,"Turbidity","2","No",0,11,12,0,999999,101.1178,-3.7926000000000001E-2,-2.6186600000000002,"WQI=LN(x)"]
[93,"Turbidity","4","No",0,1,5,0,999999,90.964500000000001,-16.296600000000002,-0.30113099999999998,"WQI=LN(x)"]
[93,"Turbidity","4","No",0,6,10,0,999999,83.981499999999997,-26.125,0.61845000000000006,"WQI=LN(x)"]
[93,"Turbidity","4","No",0,11,12,0,999999,90.964500000000001,-16.296600000000002,-0.30113099999999998,"WQI=LN(x)"]
[94,"Turbidity","7","No",0,1,5,0,999999,99.162400000000005,-6.4344200000000003,-1.31263,"WQI=LN(x)"]
[94,"Turbidity","7","No",0,6,10,0,999999,99.619699999999995,-4.4316500000000003,-3.1983999999999999,"WQI=LN(x)"]
[94,"Turbidity","7","No",0,11,12,0,999999,99.162400000000005,-6.4344200000000003,-1.31263,"WQI=LN(x)"]
[95,"Turbidity","8","No",0,1,5,0,999999,96.111800000000002,-18.16,0.48294999999999999,"WQI=LN(x)"]
[95,"Turbidity","8","No",0,6,10,0,999999,93.4405,-23.241599999999998,-1.71641,"WQI=LN(x)"]
[95,"Turbidity","8","No",0,11,12,0,999999,96.111800000000002,-18.16,0.48294999999999999,"WQI=LN(x)"]