{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Secondary Values Report","A (Acute)","B (Acute-Optional)","C (Acute)","SAF (2D)","Acute-acceptiblity requirements","D (Chronic)","E (Chronic-Optional)","F (Chronic)","Chronic-acceptiblity requiremen","Tab Descriptions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":6,"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":"Secondary Values Report","index":0,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[25,1,25,4],[30,1,30,4],[6,1,6,4],[5,1,5,4],[26,1,26,4],[24,1,24,4],[23,1,23,4],[26,0,27,0],[28,0,29,0],[27,1,27,4],[28,1,28,4],[29,1,29,4],[0,0,0,4],[4,2,4,4],[14,0,14,4],[22,0,22,4],[8,1,8,2],[7,1,7,2],[1,1,1,4],[12,1,12,4],[11,1,11,2],[10,1,10,2],[9,1,9,2],[3,1,3,4],[17,0,18,0],[19,0,20,0],[2,1,2,4]]}
["General Information"]
["WDNR Staff Completing Review Name:"]
["WDNR Staff Email:"]
["Facility Name                 (Wastewater staff):"]
["WPDES Permit Number                 (if applicable):","WI-"]
["Product Trade Name:"]
["Product Manufacturer:"]
["Active Ingredients:","Ingredient Name*",null,"CAS Number*","%wt or %vol*"]
[]
[]
[]
[]
[null,"* Copy from MSDS sheet, if available "]
[]
["Product Secondary Values"]
["Select Designated Use Classification:"]
[null,false,false,false,false]
["Applicable Secondary Acute Value:",{"$f":"IF($B$17=TRUE,'C (Acute)'!H39,\"N/A\")","v":"N/A"},{"$f":"IF($C$17=TRUE,'C (Acute)'!I39,\"N/A\")","v":"N/A"},{"$f":"IF($D$17=TRUE,'C (Acute)'!J39,\"N/A\")","v":"N/A"},{"$f":"IF($E$17=TRUE,'C (Acute)'!K39,\"N/A\")","v":"N/A"},{"$f":"IF('C (Acute)'!M39=\"Units\",\"Units\",'C (Acute)'!M39)","v":"mg/L"}]
[null,{"$f":"IF($B$17=TRUE,'C (Acute)'!H40,\"N/A\")","v":"N/A"},{"$f":"IF($C$17=TRUE,'C (Acute)'!I40,\"N/A\")","v":"N/A"},{"$f":"IF($D$17=TRUE,'C (Acute)'!J40,\"N/A\")","v":"N/A"},{"$f":"IF($E$17=TRUE,'C (Acute)'!K40,\"N/A\")","v":"N/A"},"µg/L"]
["Applicable Secondary Chronic Value:",{"$f":"IF($B$17=TRUE,'F (Chronic)'!I76,\"N/A\")","v":"N/A"},{"$f":"IF($C$17=TRUE,'F (Chronic)'!J76,\"N/A\")","v":"N/A"},{"$f":"IF($D$17=TRUE,'F (Chronic)'!K76,\"N/A\")","v":"N/A"},{"$f":"IF($E$17=TRUE,'F (Chronic)'!L76,\"N/A\")","v":"N/A"},{"$f":"IF('F (Chronic)'!M76=\"Units\",\"Units\",'F (Chronic)'!M76)","v":"mg/L"}]
[null,{"$f":"IF($B$17=TRUE,'F (Chronic)'!I77,\"N/A\")","v":"N/A"},{"$f":"IF($C$17=TRUE,'F (Chronic)'!J77,\"N/A\")","v":"N/A"},{"$f":"IF($D$17=TRUE,'F (Chronic)'!K77,\"N/A\")","v":"N/A"},{"$f":"IF($E$17=TRUE,'F (Chronic)'!L77,\"N/A\")","v":"N/A"},"µg/L"]
[]
["Product Application Information"]
["Purpose of Additive:"]
["Does WPDES permit currently have a limit for this additive?"]
["Effective concentration:",null,null,null,null,"mg/L"]
["Average dosage rate:",null,null,null,null,"lbs/day"]
[null,null,null,null,null,"mg/L"]
["Estimated maximum discharge concentration:",null,null,null,null,"lbs/day"]
[null,null,null,null,null,"mg/L"]
[]
[]
[]
["Template last updated:","2016-04-20","Sarah Yang"]

{"sheet":"A (Acute)","index":1,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,3,1,3],[0,2,1,2],[0,1,1,1],[0,0,1,0],[0,5,0,6],[0,11,1,11],[0,9,1,9],[0,8,1,8],[0,7,1,7],[0,4,1,4],[0,10,1,10],[14,2,16,2],[14,3,16,3],[29,0,34,0],[29,1,31,1],[29,2,31,2],[29,3,31,3],[32,1,34,1],[32,2,34,2],[32,3,34,3],[23,0,28,0],[23,1,25,1],[23,2,25,2],[23,3,25,3],[26,1,28,1],[26,2,28,2],[26,3,28,3],[2,0,22,0],[2,1,10,1],[2,2,4,2],[2,3,4,3],[5,2,7,2],[5,3,7,3],[8,2,10,2],[8,3,10,3],[17,1,22,1],[17,2,19,2],[17,3,19,3],[20,2,22,2],[20,3,22,3],[11,1,16,1],[11,2,13,2],[11,3,13,3]]}
["Taxa Category","Genus","Species","Common Name","Test Duration & Endpoint","Toxicity Test Result",null,"Test Method","Exposure Format","Control Response","Toxicity Value (mg/L)","Acceptable?"]
[null,null,null,null,null," Value","Units"]
["Planktonic Crustacean","Ceriodaphnia","dubia","Cladoceran (water flea)",null,null,null,null,null,null,{"$f":"IF(L3=\"No\",\"\",IF(G3=\"mg/L (ppm)\",F3,(IF(G3=\"µg/L (ppb)\",F3/1000,(IF(G3=\"g/L\",F3*1000,\"\"))))))","v":""},{"$f":"IF(AND(E3=\"\",H3=\"\",I3=\"\",J3=\"\"),\"N/A\",(IF(OR(E3=\"\",E3=\"Other\",H3=\"\",I3=\"\",J3=\"Other\",J3=\"\",(AND(H3=\"Other\",'B (Acute-Optional)'!$B$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E4=\"\",H4=\"\",I4=\"\",J4=\"\"),\"N/A\",(IF(OR(E4=\"\",E4=\"Other\",H4=\"\",I4=\"\",J4=\"Other\",J4=\"\",(AND(H4=\"Other\",'B (Acute-Optional)'!$B$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E5=\"\",H5=\"\",I5=\"\",J5=\"\"),\"N/A\",(IF(OR(E5=\"\",E5=\"Other\",H5=\"\",I5=\"\",J5=\"Other\",J5=\"\",(AND(H5=\"Other\",'B (Acute-Optional)'!$B$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,"reticulata","Water flea",null,null,null,null,null,null,"",{"$f":"IF(AND(E6=\"\",H6=\"\",I6=\"\",J6=\"\"),\"N/A\",(IF(OR(E6=\"\",E6=\"Other\",H6=\"\",I6=\"\",J6=\"Other\",J6=\"\",(AND(H6=\"Other\",'B (Acute-Optional)'!$B$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E7=\"\",H7=\"\",I7=\"\",J7=\"\"),\"N/A\",(IF(OR(E7=\"\",E7=\"Other\",H7=\"\",I7=\"\",J7=\"Other\",J7=\"\",(AND(H7=\"Other\",'B (Acute-Optional)'!$B$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E8=\"\",H8=\"\",I8=\"\",J8=\"\"),\"N/A\",(IF(OR(E8=\"\",E8=\"Other\",H8=\"\",I8=\"\",J8=\"Other\",J8=\"\",(AND(H8=\"Other\",'B (Acute-Optional)'!$B$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,"serrulatus","Water flea",null,null,null,null,null,null,"",{"$f":"IF(AND(E9=\"\",H9=\"\",I9=\"\",J9=\"\"),\"N/A\",(IF(OR(E9=\"\",E9=\"Other\",H9=\"\",I9=\"\",J9=\"Other\",J9=\"\",(AND(H9=\"Other\",'B (Acute-Optional)'!$B$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E10=\"\",H10=\"\",I10=\"\",J10=\"\"),\"N/A\",(IF(OR(E10=\"\",E10=\"Other\",H10=\"\",I10=\"\",J10=\"Other\",J10=\"\",(AND(H10=\"Other\",'B (Acute-Optional)'!$B$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E11=\"\",H11=\"\",I11=\"\",J11=\"\"),\"N/A\",(IF(OR(E11=\"\",E11=\"Other\",H11=\"\",I11=\"\",J11=\"Other\",J11=\"\",(AND(H11=\"Other\",'B (Acute-Optional)'!$B$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,"Daphnia","magna","Water flea",null,null,null,null,null,null,"",{"$f":"IF(AND(E12=\"\",H12=\"\",I12=\"\",J12=\"\"),\"N/A\",(IF(OR(E12=\"\",E12=\"Other\",H12=\"\",I12=\"\",J12=\"Other\",J12=\"\",(AND(H12=\"Other\",'B (Acute-Optional)'!$C$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E13=\"\",H13=\"\",I13=\"\",J13=\"\"),\"N/A\",(IF(OR(E13=\"\",E13=\"Other\",H13=\"\",I13=\"\",J13=\"Other\",J13=\"\",(AND(H13=\"Other\",'B (Acute-Optional)'!$C$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E14=\"\",H14=\"\",I14=\"\",J14=\"\"),\"N/A\",(IF(OR(E14=\"\",E14=\"Other\",H14=\"\",I14=\"\",J14=\"Other\",J14=\"\",(AND(H14=\"Other\",'B (Acute-Optional)'!$C$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,"pulex","Water flea",null,null,null,null,null,null,"",{"$f":"IF(AND(E15=\"\",H15=\"\",I15=\"\",J15=\"\"),\"N/A\",(IF(OR(E15=\"\",E15=\"Other\",H15=\"\",I15=\"\",J15=\"Other\",J15=\"\",(AND(H15=\"Other\",'B (Acute-Optional)'!$C$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E16=\"\",H16=\"\",I16=\"\",J16=\"\"),\"N/A\",(IF(OR(E16=\"\",E16=\"Other\",H16=\"\",I16=\"\",J16=\"Other\",J16=\"\",(AND(H16=\"Other\",'B (Acute-Optional)'!$C$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E17=\"\",H17=\"\",I17=\"\",J17=\"\"),\"N/A\",(IF(OR(E17=\"\",E17=\"Other\",H17=\"\",I17=\"\",J17=\"Other\",J17=\"\",(AND(H17=\"Other\",'B (Acute-Optional)'!$C$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,"Simocephalus","serrulatus","Water flea",null,null,null,null,null,null,"",{"$f":"IF(AND(E18=\"\",H18=\"\",I18=\"\",J18=\"\"),\"N/A\",(IF(OR(E18=\"\",E18=\"Other\",H18=\"\",I18=\"\",J18=\"Other\",J18=\"\",(AND(H18=\"Other\",'B (Acute-Optional)'!$D$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E19=\"\",H19=\"\",I19=\"\",J19=\"\"),\"N/A\",(IF(OR(E19=\"\",E19=\"Other\",H19=\"\",I19=\"\",J19=\"Other\",J19=\"\",(AND(H19=\"Other\",'B (Acute-Optional)'!$D$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E20=\"\",H20=\"\",I20=\"\",J20=\"\"),\"N/A\",(IF(OR(E20=\"\",E20=\"Other\",H20=\"\",I20=\"\",J20=\"Other\",J20=\"\",(AND(H20=\"Other\",'B (Acute-Optional)'!$D$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,"vetulus","Water flea",null,null,null,null,null,null,"",{"$f":"IF(AND(E21=\"\",H21=\"\",I21=\"\",J21=\"\"),\"N/A\",(IF(OR(E21=\"\",E21=\"Other\",H21=\"\",I21=\"\",J21=\"Other\",J21=\"\",(AND(H21=\"Other\",'B (Acute-Optional)'!$D$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E22=\"\",H22=\"\",I22=\"\",J22=\"\"),\"N/A\",(IF(OR(E22=\"\",E22=\"Other\",H22=\"\",I22=\"\",J22=\"Other\",J22=\"\",(AND(H22=\"Other\",'B (Acute-Optional)'!$D$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E23=\"\",H23=\"\",I23=\"\",J23=\"\"),\"N/A\",(IF(OR(E23=\"\",E23=\"Other\",H23=\"\",I23=\"\",J23=\"Other\",J23=\"\",(AND(H23=\"Other\",'B (Acute-Optional)'!$D$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
["Non-Salmonid Fish","Pimephales","promelas","Fathead minnow",null,null,null,null,null,null,"",{"$f":"IF(AND(E24=\"\",H24=\"\",I24=\"\",J24=\"\"),\"N/A\",(IF(OR(E24=\"\",E24=\"Other\",H24=\"\",I24=\"\",J24=\"Other\",J24=\"\",(AND(H24=\"Other\",'B (Acute-Optional)'!$E$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E25=\"\",H25=\"\",I25=\"\",J25=\"\"),\"N/A\",(IF(OR(E25=\"\",E25=\"Other\",H25=\"\",I25=\"\",J25=\"Other\",J25=\"\",(AND(H25=\"Other\",'B (Acute-Optional)'!$E$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E26=\"\",H26=\"\",I26=\"\",J26=\"\"),\"N/A\",(IF(OR(E26=\"\",E26=\"Other\",H26=\"\",I26=\"\",J26=\"Other\",J26=\"\",(AND(H26=\"Other\",'B (Acute-Optional)'!$E$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,"Lepomis","Macrochirus","Bluegill",null,null,null,null,null,null,{"$f":"IF(L27=\"No\",\"\",(IF(G27=\"mg/L (ppm)\",F27,(IF(G27=\"µg/L (ppb)\",F27/1000,(IF(G27=\"g/L\",F27*1000,\"\")))))))","v":""},{"$f":"IF(AND(E27=\"\",H27=\"\",I27=\"\",J27=\"\"),\"N/A\",(IF(OR(E27=\"\",E27=\"Other\",H27=\"\",I27=\"\",J27=\"Other\",J27=\"\",(AND(H27=\"Other\",'B (Acute-Optional)'!$F$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L28=\"No\",\"\",IF(G28=\"mg/L (ppm)\",F28,(IF(G28=\"µg/L (ppb)\",F28/1000,(IF(G28=\"g/L\",F28*1000,\"\"))))))","v":""},{"$f":"IF(AND(E28=\"\",H28=\"\",I28=\"\",J28=\"\"),\"N/A\",(IF(OR(E28=\"\",E28=\"Other\",H28=\"\",I28=\"\",J28=\"Other\",J28=\"\",(AND(H28=\"Other\",'B (Acute-Optional)'!$F$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E29=\"\",H29=\"\",I29=\"\",J29=\"\"),\"N/A\",(IF(OR(E29=\"\",E29=\"Other\",H29=\"\",I29=\"\",J29=\"Other\",J29=\"\",(AND(H29=\"Other\",'B (Acute-Optional)'!$F$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
["Salmonid Fish","Oncorhynchus","mykiss","Rainbow trout",null,null,null,null,null,null,"",{"$f":"IF(AND(E30=\"\",H30=\"\",I30=\"\",J30=\"\"),\"N/A\",(IF(OR(E30=\"\",E30=\"Other\",H30=\"\",I30=\"\",J30=\"Other\",J30=\"\",(AND(H30=\"Other\",'B (Acute-Optional)'!$G$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E31=\"\",H31=\"\",I31=\"\",J31=\"\"),\"N/A\",(IF(OR(E31=\"\",E31=\"Other\",H31=\"\",I31=\"\",J31=\"Other\",J31=\"\",(AND(H31=\"Other\",'B (Acute-Optional)'!$G$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E32=\"\",H32=\"\",I32=\"\",J32=\"\"),\"N/A\",(IF(OR(E32=\"\",E32=\"Other\",H32=\"\",I32=\"\",J32=\"Other\",J32=\"\",(AND(H32=\"Other\",'B (Acute-Optional)'!$G$11=\"No\"))),\"No\",\"Yes\")))","v":"N/A"}]
[null,"Salvelinus","fontinalis","Brook trout",null,null,null,null,null,null,"",{"$f":"IF(AND(E33=\"\",H33=\"\",I33=\"\",J33=\"\"),\"N/A\",(IF(OR(E33=\"\",E33=\"Other\",H33=\"\",I33=\"\",J33=\"Other\",J33=\"\",H33=\"Other\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E34=\"\",H34=\"\",I34=\"\",J34=\"\"),\"N/A\",(IF(OR(E34=\"\",E34=\"Other\",H34=\"\",I34=\"\",J34=\"Other\",J34=\"\",H34=\"Other\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"","N/A"]
["Other*"]
["Other*"]
["Other*"]
["Other*"]
["Other*"]
["Other*"]
["Other*"]
["Other*"]
["Other*"]

{"sheet":"B (Acute-Optional)","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,0,3]]}
["Toxicity Test Parameters","Water flea     ",null,null,"Fathead Minnow","Bluegill","Rainbow Trout"]
[null,"(Ceriodaphnia spp.)","(Daphnia spp.)","(Simocephalus spp.)","(Pimephales promelas)","(Lepomis macrochirus)","(Oncorhynchus mykiss)"]
["Temperature:"]
["Dilution water:"]
["Number of test concentrations:"]
["Dilution series setup:"]
["Number of organisms/test chamber:"]
["Number of replicate chambers per concentration:"]
["Number of organisms per concentration:"]
[]
["Data acceptable?",{"$f":"IF(OR(B3=\"Other\",B3=\"\", B4=\"Other\",B4=\"\", B5=\"Other\",B5=\"\", B6=\"Other\",B6=\"\", B7=\"Other\",B7=\"\", B8=\"Other\",B8=\"\", B9=\"Other\", B9=\"\"),\"No\",\"Yes\")","v":"No"},{"$f":"IF(OR(C3=\"Other\",C3=\"\", C4=\"Other\",C4=\"\", C5=\"Other\",C5=\"\", C6=\"Other\",C6=\"\", C7=\"Other\",C7=\"\", C8=\"Other\",C8=\"\", C9=\"Other\", C9=\"\"),\"No\",\"Yes\")","v":"No"},"No","No","No","No"]

{"sheet":"C (Acute)","index":3,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,5,35,6],[36,5,36,6],[37,5,37,6],[29,8,31,8],[29,9,31,9],[29,10,31,10],[32,1,34,1],[32,2,34,2],[32,3,34,3],[32,5,34,5],[32,6,34,6],[32,7,34,7],[32,8,34,8],[32,9,34,9],[32,10,34,10],[26,9,28,9],[26,10,28,10],[29,0,34,0],[29,1,31,1],[29,2,31,2],[29,3,31,3],[29,5,31,5],[29,6,31,6],[29,7,31,7],[23,0,28,0],[23,7,25,7],[23,8,25,8],[23,9,25,9],[23,10,25,10],[26,1,28,1],[26,2,28,2],[23,1,25,1],[23,2,25,2],[23,3,25,3],[23,5,25,5],[23,6,25,6],[26,8,28,8],[17,9,22,9],[17,10,22,10],[20,2,22,2],[20,3,22,3],[20,5,22,5],[17,7,22,7],[17,2,19,2],[17,3,19,3],[17,5,19,5],[17,6,22,6],[17,8,22,8],[26,3,28,3],[26,5,28,5],[26,6,28,6],[26,7,28,7],[11,7,16,7],[11,8,16,8],[11,9,16,9],[11,10,16,10],[14,2,16,2],[14,3,16,3],[14,5,16,5],[11,6,16,6],[0,7,0,10],[2,6,10,6],[2,7,10,7],[2,8,10,8],[2,9,10,9],[2,10,10,10],[17,1,22,1],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[38,5,39,6],[2,0,22,0],[2,1,10,1],[2,2,4,2],[2,3,4,3],[2,5,4,5],[5,2,7,2],[5,3,7,3],[5,5,7,5],[8,2,10,2],[8,3,10,3],[8,5,10,5],[11,1,16,1],[11,2,13,2],[11,3,13,3],[11,5,13,5],[0,11,1,11],[23,11,25,11],[14,11,16,11],[11,11,13,11],[8,11,10,11],[5,11,7,11],[2,11,4,11],[26,11,28,11],[29,11,31,11],[32,11,34,11],[20,11,22,11],[17,11,19,11]]}
["Taxa Category","Genus","Species","Common Name","Test Result","SMAV","GMAV","Designated Use Classification",null,null,null,"Used as sensitive species?"]
[null,null,null,null,"mg/L","mg/L","mg/L","CW","WW","LFF","LAL"]
["Planktonic Crustacean","Ceriodaphnia","dubia","Water flea",{"$f":"IF('A (Acute)'!L3=\"No\",\"N/A\",(IF('A (Acute)'!K3=\"\",\"\",'A (Acute)'!K3)))","v":""},{"$f":"IF(ISERROR(GEOMEAN(E3:E5)),\"N/A\",GEOMEAN(E3:E5))","v":"N/A"},{"$f":"IF(ISERROR(GEOMEAN(F3:F11)),\"N/A\",GEOMEAN(F3:F11))","v":"N/A"},"X","X","X","X",{"$f":"IF(AND(COUNT('C (Acute)'!$F$3:$F$35)>1,'C (Acute)'!F3=MIN('C (Acute)'!$F$3:$F$35)),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L4=\"No\",\"N/A\",(IF('A (Acute)'!K4=\"\",\"\",'A (Acute)'!K4)))","v":""}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L5=\"No\",\"N/A\",(IF('A (Acute)'!K5=\"\",\"\",'A (Acute)'!K5)))","v":""}]
[null,null,"reticulata","Water flea",{"$f":"IF('A (Acute)'!L6=\"No\",\"N/A\",(IF('A (Acute)'!K6=\"\",\"\",'A (Acute)'!K6)))","v":""},{"$f":"IF(ISERROR(GEOMEAN(E6:E8)),\"N/A\",GEOMEAN(E6:E8))","v":"N/A"},null,null,null,null,null,{"$f":"IF(AND(COUNT('C (Acute)'!$F$3:$F$35)>1,'C (Acute)'!F6=MIN('C (Acute)'!$F$3:$F$35)),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L7=\"No\",\"N/A\",(IF('A (Acute)'!K7=\"\",\"\",'A (Acute)'!K7)))","v":""}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L8=\"No\",\"N/A\",(IF('A (Acute)'!K8=\"\",\"\",'A (Acute)'!K8)))","v":""}]
[null,null,"serrulatus","Water flea",{"$f":"IF('A (Acute)'!L9=\"No\",\"N/A\",(IF('A (Acute)'!K9=\"\",\"\",'A (Acute)'!K9)))","v":""},{"$f":"IF(ISERROR(GEOMEAN(E9:E11)),\"N/A\",GEOMEAN(E9:E11))","v":"N/A"},null,null,null,null,null,{"$f":"IF(AND(COUNT('C (Acute)'!$F$3:$F$35)>1,'C (Acute)'!F9=MIN('C (Acute)'!$F$3:$F$35)),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L10=\"No\",\"N/A\",(IF('A (Acute)'!K10=\"\",\"\",'A (Acute)'!K10)))","v":""}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L11=\"No\",\"N/A\",(IF('A (Acute)'!K11=\"\",\"\",'A (Acute)'!K11)))","v":""}]
[null,"Daphnia","magna","Water flea",{"$f":"IF('A (Acute)'!L12=\"No\",\"N/A\",(IF('A (Acute)'!K12=\"\",\"\",'A (Acute)'!K12)))","v":""},{"$f":"IF(ISERROR(GEOMEAN(E12:E14)),\"N/A\",GEOMEAN(E12:E14))","v":"N/A"},{"$f":"IF(ISERROR(GEOMEAN(F12:F17)),\"N/A\",GEOMEAN(F12:F17))","v":"N/A"},"X","X","X","X",{"$f":"IF(AND(COUNT('C (Acute)'!$F$3:$F$35)>1,'C (Acute)'!F12=MIN('C (Acute)'!$F$3:$F$35)),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L13=\"No\",\"N/A\",(IF('A (Acute)'!K13=\"\",\"\",'A (Acute)'!K13)))","v":""}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L14=\"No\",\"N/A\",(IF('A (Acute)'!K14=\"\",\"\",'A (Acute)'!K14)))","v":""}]
[null,null,"pulex","Water flea",{"$f":"IF('A (Acute)'!L15=\"No\",\"N/A\",(IF('A (Acute)'!K15=\"\",\"\",'A (Acute)'!K15)))","v":""},{"$f":"IF(ISERROR(GEOMEAN(E15:E17)),\"N/A\",GEOMEAN(E15:E17))","v":"N/A"},null,null,null,null,null,{"$f":"IF(AND(COUNT('C (Acute)'!$F$3:$F$35)>1,'C (Acute)'!F15=MIN('C (Acute)'!$F$3:$F$35)),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L16=\"No\",\"N/A\",(IF('A (Acute)'!K16=\"\",\"\",'A (Acute)'!K16)))","v":""}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L17=\"No\",\"N/A\",(IF('A (Acute)'!K17=\"\",\"\",'A (Acute)'!K17)))","v":""}]
[null,"Simocephalus","serrulatus","Water flea",{"$f":"IF('A (Acute)'!L18=\"No\",\"N/A\",(IF('A (Acute)'!K18=\"\",\"\",'A (Acute)'!K18)))","v":""},{"$f":"IF(ISERROR(GEOMEAN(E18:E20)),\"N/A\",GEOMEAN(E18:E20))","v":"N/A"},{"$f":"IF(ISERROR(GEOMEAN(F18:F23)),\"N/A\",GEOMEAN(F18:F23))","v":"N/A"},"X","X","X",null,{"$f":"IF(AND(COUNT('C (Acute)'!$F$3:$F$35)>1,'C (Acute)'!F18=MIN('C (Acute)'!$F$3:$F$35)),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L19=\"No\",\"N/A\",(IF('A (Acute)'!K19=\"\",\"\",'A (Acute)'!K19)))","v":""}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L20=\"No\",\"N/A\",(IF('A (Acute)'!K20=\"\",\"\",'A (Acute)'!K20)))","v":""}]
[null,null,"vetulus","Water flea",{"$f":"IF('A (Acute)'!L21=\"No\",\"N/A\",(IF('A (Acute)'!K21=\"\",\"\",'A (Acute)'!K21)))","v":""},{"$f":"IF(ISERROR(GEOMEAN(E21:E23)),\"N/A\",GEOMEAN(E21:E23))","v":"N/A"},null,null,null,null,null,{"$f":"IF(AND(COUNT('C (Acute)'!$F$3:$F$35)>1,'C (Acute)'!F21=MIN('C (Acute)'!$F$3:$F$35)),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L22=\"No\",\"N/A\",(IF('A (Acute)'!K22=\"\",\"\",'A (Acute)'!K22)))","v":""}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L23=\"No\",\"N/A\",(IF('A (Acute)'!K23=\"\",\"\",'A (Acute)'!K23)))","v":""}]
["Non-Salmonid Fish","Pimephales","promelas","Fathead minnow",{"$f":"IF('A (Acute)'!L24=\"No\",\"N/A\",(IF('A (Acute)'!K24=\"\",\"\",'A (Acute)'!K24)))","v":""},{"$f":"IF(ISERROR(GEOMEAN(E24:E26)),\"N/A\",GEOMEAN(E24:E26))","v":"N/A"},{"$f":"IF(ISERROR(GEOMEAN(F24:F26)),\"N/A\",GEOMEAN(F24:F26))","v":"N/A"},"X","X","X",null,{"$f":"IF(AND(COUNT('C (Acute)'!$F$3:$F$35)>1,'C (Acute)'!F24=MIN('C (Acute)'!$F$3:$F$35)),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L25=\"No\",\"N/A\",(IF('A (Acute)'!K25=\"\",\"\",'A (Acute)'!K25)))","v":""}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L26=\"No\",\"N/A\",(IF('A (Acute)'!K26=\"\",\"\",'A (Acute)'!K26)))","v":""}]
[null,"Lepomis","Macrochirus","Bluegill",{"$f":"IF('A (Acute)'!L27=\"No\",\"N/A\",(IF('A (Acute)'!K27=\"\",\"\",'A (Acute)'!K27)))","v":""},{"$f":"IF(ISERROR(GEOMEAN(E27:E29)),\"N/A\",GEOMEAN(E27:E29))","v":"N/A"},{"$f":"IF(ISERROR(GEOMEAN(F27:F29)),\"N/A\",GEOMEAN(F27:F29))","v":"N/A"},"X","X","X",null,{"$f":"IF(AND(COUNT('C (Acute)'!$F$3:$F$35)>1,'C (Acute)'!F27=MIN('C (Acute)'!$F$3:$F$35)),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L28=\"No\",\"N/A\",(IF('A (Acute)'!K28=\"\",\"\",'A (Acute)'!K28)))","v":""}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L29=\"No\",\"N/A\",(IF('A (Acute)'!K29=\"\",\"\",'A (Acute)'!K29)))","v":""}]
["Salmonid Fish","Oncorhynchus","mykiss","Rainbow trout",{"$f":"IF('A (Acute)'!L30=\"No\",\"N/A\",(IF('A (Acute)'!K30=\"\",\"\",'A (Acute)'!K30)))","v":""},{"$f":"IF(ISERROR(GEOMEAN(E30:E32)),\"N/A\",GEOMEAN(E30:E32))","v":"N/A"},{"$f":"IF(ISERROR(GEOMEAN(F30:F32)),\"N/A\",GEOMEAN(F30:F32))","v":"N/A"},"X",null,null,null,{"$f":"IF(AND(COUNT('C (Acute)'!$F$3:$F$35)>1,'C (Acute)'!F30=MIN('C (Acute)'!$F$3:$F$35)),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L31=\"No\",\"N/A\",(IF('A (Acute)'!K31=\"\",\"\",'A (Acute)'!K31)))","v":""}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L32=\"No\",\"N/A\",(IF('A (Acute)'!K32=\"\",\"\",'A (Acute)'!K32)))","v":""}]
[null,"Salvelinus","fontinalis","Brook trout",{"$f":"IF('A (Acute)'!L33=\"No\",\"N/A\",(IF('A (Acute)'!K33=\"\",\"\",'A (Acute)'!K33)))","v":""},{"$f":"IF(ISERROR(GEOMEAN(E33:E35)),\"N/A\",GEOMEAN(E33:E35))","v":"N/A"},{"$f":"IF(ISERROR(GEOMEAN(F33:F35)),\"N/A\",GEOMEAN(F33:F35))","v":"N/A"},"X",null,null,null,{"$f":"IF(AND(COUNT('C (Acute)'!$F$3:$F$35)>1,'C (Acute)'!F33=MIN('C (Acute)'!$F$3:$F$35)),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L34=\"No\",\"N/A\",(IF('A (Acute)'!K34=\"\",\"\",'A (Acute)'!K34)))","v":""}]
[null,null,null,null,{"$f":"IF('A (Acute)'!L35=\"No\",\"N/A\",(IF('A (Acute)'!K35=\"\",\"\",'A (Acute)'!K35)))","v":""}]
[null,null,null,null,null,"SAF:",null,{"$f":"IF('SAF (2D)'!B11=\"\",\"N/A\",'SAF (2D)'!B11)","v":"N/A"}]
[null,null,null,null,null,"Lowest GMAV:",null,{"$f":"MIN(IF(H3:H35=\"X\",$G$3:$G$35))","v":0},{"$f":"MIN(IF(I3:I35=\"X\",$G$3:$G$35))","v":0},{"$f":"MIN(IF(J3:J35=\"X\",$G$3:$G$35))","v":0},{"$f":"MIN(IF(K3:K35=\"X\",$G$3:$G$35))","v":0}]
[null,null,null,null,null,"Calculated SAV:",null,{"$f":"IF((AND(((OR($E$3=\"\",$E$3=\"N/A\"))),((OR($E$4=\"\",$E$4=\"N/A\"))),((OR($E$5=\"\",$E$5=\"N/A\"))),((OR($E$6=\"\",$E$6=\"N/A\"))),((OR($E$7=\"\",$E$7=\"N/A\"))),((OR($E$8=\"\",$E$8=\"N/A\"))),((OR($E$9=\"\",$E$9=\"N/A\"))),((OR($E$10=\"\",$E$10=\"N/A\"))),((OR($E$11=\"\",$E$11=\"N/A\"))),((OR($E$12=\"\",$E$12=\"N/A\"))),((OR($E$13=\"\",$E$13=\"N/A\"))),((OR($E$14=\"\",$E$14=\"N/A\"))),((OR($E$15=\"\",$E$15=\"N/A\"))),((OR($E$16=\"\",$E$16=\"N/A\"))),((OR($E$17=\"\",$E$17=\"N/A\"))),((OR($E$18=\"\",$E$18=\"N/A\"))),((OR($E$19=\"\",$E$19=\"N/A\"))),((OR($E$20=\"\",$E$20=\"N/A\"))),((OR($E$21=\"\",$E$21=\"N/A\"))),((OR($E$22=\"\",$E$22=\"N/A\"))),((OR($E$23=\"\",$E$23=\"N/A\"))))),\"N/A\",$H$37/$H$36)","v":"N/A"},{"$f":"IF((AND(((OR($E$3=\"\",$E$3=\"N/A\"))),((OR($E$4=\"\",$E$4=\"N/A\"))),((OR($E$5=\"\",$E$5=\"N/A\"))),((OR($E$6=\"\",$E$6=\"N/A\"))),((OR($E$7=\"\",$E$7=\"N/A\"))),((OR($E$8=\"\",$E$8=\"N/A\"))),((OR($E$9=\"\",$E$9=\"N/A\"))),((OR($E$10=\"\",$E$10=\"N/A\"))),((OR($E$11=\"\",$E$11=\"N/A\"))),((OR($E$12=\"\",$E$12=\"N/A\"))),((OR($E$13=\"\",$E$13=\"N/A\"))),((OR($E$14=\"\",$E$14=\"N/A\"))),((OR($E$15=\"\",$E$15=\"N/A\"))),((OR($E$16=\"\",$E$16=\"N/A\"))),((OR($E$17=\"\",$E$17=\"N/A\"))),((OR($E$18=\"\",$E$18=\"N/A\"))),((OR($E$19=\"\",$E$19=\"N/A\"))),((OR($E$20=\"\",$E$20=\"N/A\"))),((OR($E$21=\"\",$E$21=\"N/A\"))),((OR($E$22=\"\",$E$22=\"N/A\"))),((OR($E$23=\"\",$E$23=\"N/A\"))))),\"N/A\",$I$37/$H$36)","v":"N/A"},{"$f":"IF((AND(((OR($E$3=\"\",$E$3=\"N/A\"))),((OR($E$4=\"\",$E$4=\"N/A\"))),((OR($E$5=\"\",$E$5=\"N/A\"))),((OR($E$6=\"\",$E$6=\"N/A\"))),((OR($E$7=\"\",$E$7=\"N/A\"))),((OR($E$8=\"\",$E$8=\"N/A\"))),((OR($E$9=\"\",$E$9=\"N/A\"))),((OR($E$10=\"\",$E$10=\"N/A\"))),((OR($E$11=\"\",$E$11=\"N/A\"))),((OR($E$12=\"\",$E$12=\"N/A\"))),((OR($E$13=\"\",$E$13=\"N/A\"))),((OR($E$14=\"\",$E$14=\"N/A\"))),((OR($E$15=\"\",$E$15=\"N/A\"))),((OR($E$16=\"\",$E$16=\"N/A\"))),((OR($E$17=\"\",$E$17=\"N/A\"))),((OR($E$18=\"\",$E$18=\"N/A\"))),((OR($E$19=\"\",$E$19=\"N/A\"))),((OR($E$20=\"\",$E$20=\"N/A\"))),((OR($E$21=\"\",$E$21=\"N/A\"))),((OR($E$22=\"\",$E$22=\"N/A\"))),((OR($E$23=\"\",$E$23=\"N/A\"))))),\"N/A\",$J$37/$H$36)","v":"N/A"},{"$f":"IF((AND(((OR($E$3=\"\",$E$3=\"N/A\"))),((OR($E$4=\"\",$E$4=\"N/A\"))),((OR($E$5=\"\",$E$5=\"N/A\"))),((OR($E$6=\"\",$E$6=\"N/A\"))),((OR($E$7=\"\",$E$7=\"N/A\"))),((OR($E$8=\"\",$E$8=\"N/A\"))),((OR($E$9=\"\",$E$9=\"N/A\"))),((OR($E$10=\"\",$E$10=\"N/A\"))),((OR($E$11=\"\",$E$11=\"N/A\"))),((OR($E$12=\"\",$E$12=\"N/A\"))),((OR($E$13=\"\",$E$13=\"N/A\"))),((OR($E$14=\"\",$E$14=\"N/A\"))),((OR($E$15=\"\",$E$15=\"N/A\"))),((OR($E$16=\"\",$E$16=\"N/A\"))),((OR($E$17=\"\",$E$17=\"N/A\"))),((OR($E$18=\"\",$E$18=\"N/A\"))),((OR($E$19=\"\",$E$19=\"N/A\"))),((OR($E$20=\"\",$E$20=\"N/A\"))),((OR($E$21=\"\",$E$21=\"N/A\"))),((OR($E$22=\"\",$E$22=\"N/A\"))),((OR($E$23=\"\",$E$23=\"N/A\"))))),\"N/A\",$K$37/$H$36)","v":"N/A"}]
[null,null,null,null,null,"Selected SAV:",null,{"$f":"H38","v":"N/A"},{"$f":"IF(I38=\"N/A\", \"N/A\",MAX(H38:I38))","v":"N/A"},{"$f":"IF(J38=\"N/A\", \"N/A\",MAX(H38:J38))","v":"N/A"},{"$f":"IF(K38=\"N/A\", \"N/A\",MAX(H38:K38))","v":"N/A"},null,{"$f":"IF(E2=\"\",\"Units\",E2)","v":"mg/L"}]
[null,null,null,null,null,null,null,{"$f":"IF(H39=\"N/A\",\"N/A\",H39*1000)","v":"N/A"},{"$f":"IF(I39=\"N/A\", \"N/A\",I39*1000)","v":"N/A"},{"$f":"IF(J39=\"N/A\",\"N/A\",J39*1000)","v":"N/A"},{"$f":"IF(K39=\"N/A\", \"N/A\",K39*1000)","v":"N/A"},null,"µg/L"]

{"sheet":"SAF (2D)","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Taxa Requirements","Met?","Number of MDRs met","SAF"]
["Salmonid (e.g., rainbow trout, brook trout)",{"$f":"IF(AND('A (Acute)'!F30=\"\",'A (Acute)'!F31=\"\",'A (Acute)'!F32=\"\",'A (Acute)'!F33=\"\",'A (Acute)'!F34=\"\",'A (Acute)'!F35=\"\"),\"\",\"X\")","v":""},1,21.9]
["Non-salmonid fish (e.g., bluegill, fathead minnow)",{"$f":"IF(AND('A (Acute)'!F24=\"\",'A (Acute)'!F25=\"\",'A (Acute)'!F26=\"\",'A (Acute)'!F27=\"\",'A (Acute)'!F28=\"\",'A (Acute)'!F29=\"\"),\"\",\"X\")","v":""},2,13]
["Planktonic crustacean (Ceriodaphnia, Daphnia, Simocephalus spp.)",{"$f":"IF(AND('A (Acute)'!F3=\"\",'A (Acute)'!F4=\"\",'A (Acute)'!F5=\"\",'A (Acute)'!F6=\"\",'A (Acute)'!F7=\"\",'A (Acute)'!F8=\"\",'A (Acute)'!F9=\"\",'A (Acute)'!F10=\"\",'A (Acute)'!F11=\"\",'A (Acute)'!F12=\"\",'A (Acute)'!F13=\"\",'A (Acute)'!F14=\"\",'A (Acute)'!F15=\"\",'A (Acute)'!F16=\"\",'A (Acute)'!F17=\"\",'A (Acute)'!F18=\"\",'A (Acute)'!F19=\"\",'A (Acute)'!F20=\"\",'A (Acute)'!F21=\"\",'A (Acute)'!F22=\"\",'A (Acute)'!F23=\"\"),\"\",\"X\")","v":""},3,8]
["Benthic crustacean",null,4,7]
["Insect",null,5,6.1]
["Fish/amphibian in a family in the phylum Chordata",null,6,5.2]
["Organism in the a Phylum other than Arthropoda or Chordata",null,7,4.3]
["Organism in a family/phylum not already represented"]
["Number of MDRS Met:",{"$f":"COUNTIF(B2:B9,\"X\")","v":0}]
["Selected SAF:",{"$f":"IF(B10=0,\"\",IF(B10=C2,D2,IF(B10=C3,D3,IF(B10=C4,D4,IF(B10=C5,D5,IF(B10=C6,D6,IF(B10=C7,D7,IF(B10=C8,D8))))))))","v":""}]

{"sheet":"Acute-acceptiblity requirements","index":5,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":true,"merged":[[0,3,1,3],[0,1,1,1],[0,0,1,0],[25,0,26,0],[23,0,24,0],[21,0,22,0],[19,0,20,0],[17,0,18,0],[12,0,16,0],[9,0,11,0],[6,0,7,0],[2,0,4,0]]}
["Test Parameters","All species","Cladocerans","All Fish","Fathead Minnow","Bluegill","Rainbow Trout"]
[null,null,"(Ceriodaphnia, Daphnia, Simocephalus spp.)",null,"(Pimephales promelas)","(Lepomis macrochirus)","(Oncorhynchus mykiss)"]
["Exposure Format:","Static"]
[null,"Flow-through"]
[null,"Approved by DNR Toxicologist"]
[]
["Control response:","≥ 90% survival"]
[null,"Other"]
[null,"Approved by DNR Toxicologist"]
["Temperature:",null,"20±1 °C",null,"20±1 °C","20±1 °C","12 ± 1 °C"]
[null,null,"25±1 °C",null,"25±1 °C","25±1 °C","Other"]
[null,null,"Other",null,"Other","Other"]
["Dilution water:","Moderately hard synthetic water"]
[null,"Synthetic water"]
[null,"Receiving water"]
[null,"Ground water"]
[null,"Other"]
["Test concentrations:","≥ 5 + control"]
[null,"Other"]
["Dilution series","≥0.5 dilution series"]
[null,"Other"]
["Age of test organisms:",null,"< 24 h",null,"1-14 days","1-14 days","15-30 days"]
[null,null,"Other",null,"Other","Other","Other"]
["No. organisms/test chamber:",null,"≥ 5","≥ 10"]
[null,null,"Other","Other"]
["No. replicate chambers/concentration:",null,"≥ 4","≥ 2"]
[null,null,"Other","Other"]
["No. organisms/ concentration:","≥ 20"]
[null,"Other"]
[]
[]
[null,"Units"]
[null,"µg/L (ppb)"]
[null,"mg/L (ppm)"]
[null,"g/L"]
[]
[null,"Water flea Endpoints",null,"Fish Endpoints"]
[null,"48-hr EC50",null,"96-hr LC50"]
[null,"48-hr LC50",null,"Other"]
[null,"Other"]
[]
[]
[null," Ceriodaphnia Test Methods","Daphnia Test Methods",null,"FHM Test Methods","Bluegill & Simocephalus Test Methods","Brook & Rainbow Trout Test Methods"]
[null,"WI certified method/lab","WI certified method/lab",null,"WI certified method/lab","WI certified method/lab","WI certified method/lab"]
[null,"EPA 2002.0","EPA 2021.0",null,"EPA 2000.0","Other","EPA 2019.0"]
[null,"Other","Other",null,"Other","Approved by DNR toxicologist","Other"]
[null,"Approved by DNR toxicologist","Approved by DNR toxicologist",null,"Approved by DNR toxicologist",null,"Approved by DNR toxicologist"]

{"sheet":"D (Chronic)","index":6,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[23,3,25,3],[2,3,4,3],[0,6,0,7],[0,5,1,5],[0,4,1,4],[5,3,7,3],[17,3,19,3],[8,3,10,3],[14,3,16,3],[20,3,22,3],[11,3,13,3],[23,0,34,0],[17,2,19,2],[8,2,10,2],[5,2,7,2],[2,2,4,2],[26,1,28,1],[20,2,22,2],[11,2,13,2],[14,2,16,2],[29,1,31,1],[29,2,31,2],[23,1,25,1],[23,2,25,2],[29,3,31,3],[32,1,34,1],[32,2,34,2],[32,3,34,3],[26,2,28,2],[26,3,28,3],[0,1,1,1],[0,0,1,0],[0,8,1,8],[0,2,1,2],[2,0,22,0],[20,1,22,1],[17,1,19,1],[14,1,16,1],[11,1,13,1],[8,1,10,1],[5,1,7,1],[2,1,4,1],[0,9,1,9],[0,3,1,3],[0,10,1,10],[0,12,1,12],[0,11,1,11]]}
["Taxa Category","Genus","Species","Common Name","Test Type","Test Endpoint","Toxicity Test Result",null,"Test Method","Exposure Format","Control Response","Toxicity Value (mg/L)","Acceptable?"]
[null,null,null,null,null,null,"Value","Units"]
["Invertebrate","Ceriodaphnia","dubia","Water flea",null,null,null,null,null,null,null,{"$f":"IF(M3=\"No\",\"\",IF(H3=\"mg/L (ppm)\",G3,(IF(H3=\"µg/L (ppb)\",G3/1000,(IF(H3=\"g/L\",G3*1000,\"\"))))))","v":""},{"$f":"IF(AND(E3=\"\",F3=\"\",H3=\"\",I3=\"\",J3=\"\",K3=\"\"),\"N/A\",(IF(OR(E3=\"\",E3=\"Other\",F3=\"Other\",F3=\"\",(AND(I3=\"Other\",'E (Chronic-Optional)'!$B$12=\"No\")),I3=\"\",J3=\"Other\",J3=\"\",K3=\"Other\",K3=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E4=\"\",F4=\"\",H4=\"\",I4=\"\",J4=\"\",K4=\"\"),\"N/A\",(IF(OR(E4=\"\",E4=\"Other\",F4=\"Other\",F4=\"\",(AND(I4=\"Other\",'E (Chronic-Optional)'!$B$12=\"No\")),I4=\"\",J4=\"Other\",J4=\"\",K4=\"Other\",K4=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E5=\"\",F5=\"\",H5=\"\",I5=\"\",J5=\"\",K5=\"\"),\"N/A\",(IF(OR(E5=\"\",E5=\"Other\",F5=\"Other\",F5=\"\",(AND(I5=\"Other\",'E (Chronic-Optional)'!$B$12=\"No\")),I5=\"\",J5=\"Other\",J5=\"\",K5=\"Other\",K5=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,"Ceriodaphnia","reticulata","Water flea",null,null,null,null,null,null,null,"",{"$f":"IF(AND(E6=\"\",F6=\"\",H6=\"\",I6=\"\",J6=\"\",K6=\"\"),\"N/A\",(IF(OR(E6=\"\",E6=\"Other\",F6=\"Other\",F6=\"\",(AND(I6=\"Other\",'E (Chronic-Optional)'!$B$12=\"No\")),I6=\"\",J6=\"Other\",J6=\"\",K6=\"Other\",K6=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E7=\"\",F7=\"\",H7=\"\",I7=\"\",J7=\"\",K7=\"\"),\"N/A\",(IF(OR(E7=\"\",E7=\"Other\",F7=\"Other\",F7=\"\",(AND(I7=\"Other\",'E (Chronic-Optional)'!$B$12=\"No\")),I7=\"\",J7=\"Other\",J7=\"\",K7=\"Other\",K7=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E8=\"\",F8=\"\",H8=\"\",I8=\"\",J8=\"\",K8=\"\"),\"N/A\",(IF(OR(E8=\"\",E8=\"Other\",F8=\"Other\",F8=\"\",(AND(I8=\"Other\",'E (Chronic-Optional)'!$B$12=\"No\")),I8=\"\",J8=\"Other\",J8=\"\",K8=\"Other\",K8=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,"Ceriodaphnia","serrulatus","Water flea",null,null,null,null,null,null,null,"",{"$f":"IF(AND(E9=\"\",F9=\"\",H9=\"\",I9=\"\",J9=\"\",K9=\"\"),\"N/A\",(IF(OR(E9=\"\",E9=\"Other\",F9=\"Other\",F9=\"\",(AND(I9=\"Other\",'E (Chronic-Optional)'!$B$12=\"No\")),I9=\"\",J9=\"Other\",J9=\"\",K9=\"Other\",K9=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E10=\"\",F10=\"\",H10=\"\",I10=\"\",J10=\"\",K10=\"\"),\"N/A\",(IF(OR(E10=\"\",E10=\"Other\",F10=\"Other\",F10=\"\",(AND(I10=\"Other\",'E (Chronic-Optional)'!$B$12=\"No\")),I10=\"\",J10=\"Other\",J10=\"\",K10=\"Other\",K10=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E11=\"\",F11=\"\",H11=\"\",I11=\"\",J11=\"\",K11=\"\"),\"N/A\",(IF(OR(E11=\"\",E11=\"Other\",F11=\"Other\",F11=\"\",(AND(I11=\"Other\",'E (Chronic-Optional)'!$B$12=\"No\")),I11=\"\",J11=\"Other\",J11=\"\",K11=\"Other\",K11=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,"Daphnia","magna","Water flea",null,null,null,null,null,null,null,"",{"$f":"IF(AND(E12=\"\",F12=\"\",H12=\"\",I12=\"\",J12=\"\",K12=\"\"),\"N/A\",(IF(OR(E12=\"\",E12=\"Other\",F12=\"Other\",F12=\"\",(AND(I12=\"Other\",'E (Chronic-Optional)'!$C$12=\"No\")),I12=\"\",J12=\"Other\",J12=\"\",K12=\"Other\",K12=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E13=\"\",F13=\"\",H13=\"\",I13=\"\",J13=\"\",K13=\"\"),\"N/A\",(IF(OR(E13=\"\",E13=\"Other\",F13=\"Other\",F13=\"\",(AND(I13=\"Other\",'E (Chronic-Optional)'!$C$12=\"No\")),I13=\"\",J13=\"Other\",J13=\"\",K13=\"Other\",K13=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E14=\"\",F14=\"\",H14=\"\",I14=\"\",J14=\"\",K14=\"\"),\"N/A\",(IF(OR(E14=\"\",E14=\"Other\",F14=\"Other\",F14=\"\",(AND(I14=\"Other\",'E (Chronic-Optional)'!$C$12=\"No\")),I14=\"\",J14=\"Other\",J14=\"\",K14=\"Other\",K14=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,"Daphnia","pulex","Water flea",null,null,null,null,null,null,null,"",{"$f":"IF(AND(E15=\"\",F15=\"\",H15=\"\",I15=\"\",J15=\"\",K15=\"\"),\"N/A\",(IF(OR(E15=\"\",E15=\"Other\",F15=\"Other\",F15=\"\",(AND(I15=\"Other\",'E (Chronic-Optional)'!$C$12=\"No\")),I15=\"\",J15=\"Other\",J15=\"\",K15=\"Other\",K15=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E16=\"\",F16=\"\",H16=\"\",I16=\"\",J16=\"\",K16=\"\"),\"N/A\",(IF(OR(E16=\"\",E16=\"Other\",F16=\"Other\",F16=\"\",(AND(I16=\"Other\",'E (Chronic-Optional)'!$C$12=\"No\")),I16=\"\",J16=\"Other\",J16=\"\",K16=\"Other\",K16=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E17=\"\",F17=\"\",H17=\"\",I17=\"\",J17=\"\",K17=\"\"),\"N/A\",(IF(OR(E17=\"\",E17=\"Other\",F17=\"Other\",F17=\"\",(AND(I17=\"Other\",'E (Chronic-Optional)'!$C$12=\"No\")),I17=\"\",J17=\"Other\",J17=\"\",K17=\"Other\",K17=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,"Simocephalus","serrulatus","Water flea",null,null,null,null,null,null,null,"",{"$f":"IF(AND(E18=\"\",F18=\"\",H18=\"\",I18=\"\",J18=\"\",K18=\"\"),\"N/A\",(IF(OR(E18=\"\",E18=\"Other\",F18=\"Other\",F18=\"\",(AND(I18=\"Other\",'E (Chronic-Optional)'!$D$12=\"No\")),I18=\"\",J18=\"Other\",J18=\"\",K18=\"Other\",K18=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E19=\"\",F19=\"\",H19=\"\",I19=\"\",J19=\"\",K19=\"\"),\"N/A\",(IF(OR(E19=\"\",E19=\"Other\",F19=\"Other\",F19=\"\",(AND(I19=\"Other\",'E (Chronic-Optional)'!$D$12=\"No\")),I19=\"\",J19=\"Other\",J19=\"\",K19=\"Other\",K19=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E20=\"\",F20=\"\",H20=\"\",I20=\"\",J20=\"\",K20=\"\"),\"N/A\",(IF(OR(E20=\"\",E20=\"Other\",F20=\"Other\",F20=\"\",(AND(I20=\"Other\",'E (Chronic-Optional)'!$D$12=\"No\")),I20=\"\",J20=\"Other\",J20=\"\",K20=\"Other\",K20=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,"Simocephalus","vetulus","Water flea",null,null,null,null,null,null,null,"",{"$f":"IF(AND(E21=\"\",F21=\"\",H21=\"\",I21=\"\",J21=\"\",K21=\"\"),\"N/A\",(IF(OR(E21=\"\",E21=\"Other\",F21=\"Other\",F21=\"\",(AND(I21=\"Other\",'E (Chronic-Optional)'!$D$12=\"No\")),I21=\"\",J21=\"Other\",J21=\"\",K21=\"Other\",K21=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E22=\"\",F22=\"\",H22=\"\",I22=\"\",J22=\"\",K22=\"\"),\"N/A\",(IF(OR(E22=\"\",E22=\"Other\",F22=\"Other\",F22=\"\",(AND(I22=\"Other\",'E (Chronic-Optional)'!$D$12=\"No\")),I22=\"\",J22=\"Other\",J22=\"\",K22=\"Other\",K22=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E23=\"\",F23=\"\",H23=\"\",I23=\"\",J23=\"\",K23=\"\"),\"N/A\",(IF(OR(E23=\"\",E23=\"Other\",F23=\"Other\",F23=\"\",(AND(I23=\"Other\",'E (Chronic-Optional)'!$D$12=\"No\")),I23=\"\",J23=\"Other\",J23=\"\",K23=\"Other\",K23=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
["Fish","Pimephales","promelas","Fathead minnow",null,null,null,null,null,null,null,"",{"$f":"IF(AND(E24=\"\",F24=\"\",H24=\"\",I24=\"\",J24=\"\",K24=\"\"),\"N/A\",(IF(OR(E24=\"\",E24=\"Other\",F24=\"Other\",F24=\"\",(AND(I24=\"Other\",'E (Chronic-Optional)'!$E$12=\"No\")),I24=\"\",J24=\"Other\",J24=\"\",K24=\"Other\",K24=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E25=\"\",F25=\"\",H25=\"\",I25=\"\",J25=\"\",K25=\"\"),\"N/A\",(IF(OR(E25=\"\",E25=\"Other\",F25=\"Other\",F25=\"\",(AND(I25=\"Other\",'E (Chronic-Optional)'!$E$12=\"No\")),I25=\"\",J25=\"Other\",J25=\"\",K25=\"Other\",K25=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E26=\"\",F26=\"\",H26=\"\",I26=\"\",J26=\"\",K26=\"\"),\"N/A\",(IF(OR(E26=\"\",E26=\"Other\",F26=\"Other\",F26=\"\",(AND(I26=\"Other\",'E (Chronic-Optional)'!$E$12=\"No\")),I26=\"\",J26=\"Other\",J26=\"\",K26=\"Other\",K26=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,"Lepomis","Macrochirus","Bluegill",null,null,null,null,null,null,null,"",{"$f":"IF(AND(E27=\"\",F27=\"\",H27=\"\",I27=\"\",J27=\"\",K27=\"\"),\"N/A\",(IF(OR(E27=\"\",E27=\"Other\",F27=\"Other\",F27=\"\",I27=\"Other\",I27=\"\",J27=\"Other\",J27=\"\",K27=\"Other\",K27=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(E28=\"\",F28=\"\",H28=\"\",I28=\"\",J28=\"\",K28=\"\"),\"N/A\",(IF(OR(E28=\"\",E28=\"Other\",F28=\"Other\",F28=\"\",I28=\"Other\",I28=\"\",J28=\"Other\",J28=\"\",K28=\"Other\",K28=\"\"),\"No\",\"Yes\")))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"","N/A"]
[null,"Oncorhynchus","mykiss","Rainbow trout",null,null,null,null,null,null,null,"","N/A"]
[null,null,null,null,null,null,null,null,null,null,null,"","N/A"]
[null,null,null,null,null,null,null,null,null,null,null,"","N/A"]
[null,"Salvelinus","fontinalis","Brook trout",null,null,null,null,null,null,null,"","N/A"]
[null,null,null,null,null,null,null,null,null,null,null,"","N/A"]
[null,null,null,null,null,null,null,null,null,null,null,"","N/A"]
["Other*"]
["Other*"]
["Other*"]
["Other*"]
["Other*"]
["Other*"]
["Other*"]
["Other*"]
["Other*"]

{"sheet":"E (Chronic-Optional)","index":7,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,0,3]]}
["Toxicity Test Parameters","Water flea",null,null,"Fathead Minnow"]
[null,"(Ceriodaphnia spp.)","(Daphnia spp.)","(Simocephalus spp.)","(Pimephales promelas)"]
["Test duration:"]
["Temperature:"]
["Dilution water:"]
["Number of test concentrations:"]
["Dilution series setup:"]
["Number of organisms/test chamber:"]
["Number of replicate chambers per concentration:"]
["Number of organisms per concentration:"]
[]
["Data acceptable?",{"$f":"IF(OR(B3=\"\",B3=\"Other\",B4=\"\",B4=\"Other\",B5=\"\",B5=\"Other\",B6=\"\",B6=\"Other\",B7=\"\",B7=\"Other\",B8=\"\",B8=\"Other\",B9=\"\",B9=\"Other\",B10=\"\",B10=\"Other\"),\"No\",\"Yes\")","v":"No"},{"$f":"IF(OR(C3=\"\",C3=\"Other\",C4=\"\",C4=\"Other\",C5=\"\",C5=\"Other\",C6=\"\",C6=\"Other\",C7=\"\",C7=\"Other\",C8=\"\",C8=\"Other\",C9=\"\",C9=\"Other\",C10=\"\",C10=\"Other\"),\"No\",\"Yes\")","v":"No"},"No","No"]

{"sheet":"F (Chronic)","index":8,"n_rows":77,"n_cols":13,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,7,1,7],[0,6,1,6],[50,4,52,4],[53,4,55,4],[20,4,22,4],[17,4,19,4],[14,4,16,4],[11,4,13,4],[8,4,10,4],[44,4,46,4],[47,4,49,4],[27,4,29,4],[24,4,26,4],[5,4,7,4],[2,4,4,4],[41,4,43,4],[20,6,22,6],[44,7,46,7],[53,6,55,6],[27,11,29,11],[24,11,26,11],[2,8,4,8],[2,9,4,9],[2,10,4,10],[20,9,22,9],[20,10,22,10],[20,11,22,11],[11,8,13,8],[11,9,13,9],[11,10,13,10],[11,11,13,11],[14,8,16,8],[14,9,16,9],[14,10,16,10],[14,11,16,11],[17,8,19,8],[17,9,19,9],[17,11,19,11],[2,11,4,11],[5,8,7,8],[5,9,7,9],[5,11,7,11],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,8,0,11],[2,7,4,7],[5,7,7,7],[5,2,7,2],[5,3,7,3],[2,0,22,0],[2,2,4,2],[2,3,4,3],[11,2,13,2],[11,3,13,3],[14,7,16,7],[11,7,13,7],[20,7,22,7],[17,7,19,7],[8,7,10,7],[8,11,10,11],[17,2,19,2],[17,3,19,3],[20,8,22,8],[8,2,10,2],[59,7,61,7],[59,8,61,8],[24,0,35,0],[27,3,29,3],[27,7,29,7],[27,8,29,8],[24,1,26,1],[24,2,26,2],[24,3,26,3],[24,7,26,7],[30,8,32,8],[24,8,26,8],[33,4,35,4],[30,7,32,7],[27,1,29,1],[24,6,26,6],[27,6,29,6],[30,4,32,4],[56,7,58,7],[56,8,58,8],[53,1,55,1],[53,2,55,2],[53,3,55,3],[38,0,70,0],[38,11,40,11],[41,11,43,11],[44,10,46,10],[44,11,46,11],[47,1,49,1],[47,2,49,2],[62,7,64,7],[62,8,64,8],[62,9,64,9],[53,7,55,7],[53,8,55,8],[53,9,55,9],[53,10,55,10],[47,3,49,3],[50,8,52,8],[44,8,46,8],[56,4,58,4],[59,9,61,9],[59,10,61,10],[59,11,61,11],[56,11,58,11],[50,11,52,11],[53,11,55,11],[47,11,49,11],[30,11,32,11],[33,1,35,1],[33,2,35,2],[33,3,35,3],[33,7,35,7],[33,8,35,8],[33,9,35,9],[33,10,35,10],[33,11,35,11],[30,6,32,6],[33,6,35,6],[30,9,32,9],[30,10,32,10],[8,3,10,3],[17,10,19,10],[5,10,7,10],[2,6,4,6],[5,6,7,6],[8,6,10,6],[11,6,13,6],[14,6,16,6],[17,6,19,6],[8,8,10,8],[8,9,10,9],[8,10,10,10],[14,3,16,3],[2,1,4,1],[5,1,7,1],[8,1,10,1],[11,1,13,1],[14,1,16,1],[17,1,19,1],[30,1,32,1],[30,2,32,2],[14,2,16,2],[20,2,22,2],[56,9,58,9],[56,10,58,10],[50,9,52,9],[44,9,46,9],[47,9,49,9],[47,10,49,10],[38,7,40,7],[38,8,40,8],[38,9,40,9],[38,10,40,10],[41,7,43,7],[41,8,43,8],[41,9,43,9],[41,10,43,10],[47,7,49,7],[20,3,22,3],[38,1,40,1],[38,2,40,2],[38,3,40,3],[27,2,29,2],[20,1,22,1],[30,3,32,3],[50,10,52,10],[27,10,29,10],[24,9,26,9],[24,10,26,10],[27,9,29,9],[47,8,49,8],[50,1,52,1],[50,2,52,2],[50,3,52,3],[50,7,52,7],[38,6,40,6],[41,6,43,6],[44,6,46,6],[47,6,49,6],[50,6,52,6],[62,11,64,11],[65,1,67,1],[65,2,67,2],[65,3,67,3],[65,4,67,4],[65,7,67,7],[65,8,67,8],[65,9,67,9],[65,10,67,10],[65,11,67,11],[62,1,64,1],[62,2,64,2],[62,3,64,3],[62,4,64,4],[62,10,64,10],[65,6,67,6],[75,6,76,7],[68,11,70,11],[68,1,70,1],[68,2,70,2],[68,3,70,3],[68,4,70,4],[68,7,70,7],[68,8,70,8],[68,9,70,9],[68,10,70,10],[72,6,72,7],[73,6,73,7],[74,6,74,7],[68,6,70,6],[56,6,58,6],[59,6,61,6],[62,6,64,6],[41,1,43,1],[41,2,43,2],[41,3,43,3],[38,4,40,4],[59,4,61,4],[59,1,61,1],[59,2,61,2],[59,3,61,3],[44,3,46,3],[44,1,46,1],[44,2,46,2],[56,1,58,1],[56,2,58,2],[56,3,58,3]]}
["Taxa Category","Genus","Species","Common Name","SMAV","Chronic Test Value","SMCV","SMACR","Designated Use Classification"]
[null,null,null,null,"mg/L","mg/L",null,null,"CW","WW","LFF","LAL"]
["Invertebrate",{"$f":"'D (Chronic)'!B3","v":"Ceriodaphnia"},{"$f":"'D (Chronic)'!C3","v":"dubia"},"Water flea",{"$f":"IF(AND('A (Acute)'!K3=\"\",'A (Acute)'!K4=\"\",'A (Acute)'!K5=\"\"),\"\",GEOMEAN('A (Acute)'!K3:K5))","v":""},{"$f":"IF('C (Acute)'!L3=\"No\",'D (Chronic)'!L3,(IF('C (Acute)'!L3=\"Yes\",\"used in sensitive spp SMACR\")))","v":""},{"$f":"IFERROR(GEOMEAN(F3:F5),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E3/G3),\"\")","v":""},{"$f":"IF($B3=\"N/A\",\"\",\"X\")","v":"X"},{"$f":"IF($B3=\"N/A\",\"\",\"X\")","v":"X"},"X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L3=\"No\",'D (Chronic)'!L4,(IF('C (Acute)'!L3=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L3=\"No\",'D (Chronic)'!L5,(IF('C (Acute)'!L3=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,{"$f":"'D (Chronic)'!B6","v":"Ceriodaphnia"},{"$f":"'D (Chronic)'!C6","v":"reticulata"},"Water flea",{"$f":"IF(AND('A (Acute)'!K6=\"\",'A (Acute)'!K7=\"\",'A (Acute)'!K8=\"\"),\"\",GEOMEAN('A (Acute)'!K6:K8))","v":""},{"$f":"IF('C (Acute)'!L6=\"No\",'D (Chronic)'!L6,(IF('C (Acute)'!L6=\"Yes\",\"used in sensitive spp SMACR\")))","v":""},{"$f":"IFERROR(GEOMEAN(F6:F8),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E6/G6),\"\")","v":""},{"$f":"IF($B6=\"N/A\",\"\",\"X\")","v":"X"},"X","X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L6=\"No\",'D (Chronic)'!L7,(IF('C (Acute)'!L6=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L6=\"No\",'D (Chronic)'!L8,(IF('C (Acute)'!L6=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,{"$f":"'D (Chronic)'!B9","v":"Ceriodaphnia"},{"$f":"'D (Chronic)'!C9","v":"serrulatus"},"Water flea",{"$f":"IF(AND('A (Acute)'!K9=\"\",'A (Acute)'!K10=\"\",'A (Acute)'!K11=\"\"),\"\",GEOMEAN('A (Acute)'!K9:K11))","v":""},{"$f":"IF('C (Acute)'!L9=\"No\",'D (Chronic)'!L9,(IF('C (Acute)'!L9=\"Yes\",\"used in sensitive spp SMACR\")))","v":""},{"$f":"IFERROR(GEOMEAN(F9:F11),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E9/G9),\"\")","v":""},{"$f":"IF($B9=\"N/A\",\"\",\"X\")","v":"X"},"X","X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L9=\"No\",'D (Chronic)'!L10,(IF('C (Acute)'!L9=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L9=\"No\",'D (Chronic)'!L11,(IF('C (Acute)'!L9=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,{"$f":"'D (Chronic)'!B12","v":"Daphnia"},{"$f":"'D (Chronic)'!C12","v":"magna"},"Water flea",{"$f":"IF(AND('A (Acute)'!K12=\"\",'A (Acute)'!K13=\"\",'A (Acute)'!K14=\"\"),\"\",GEOMEAN('A (Acute)'!K12:K14))","v":""},{"$f":"IF('C (Acute)'!L12=\"No\",'D (Chronic)'!L12,(IF('C (Acute)'!L12=\"Yes\",\"used in sensitive spp SMACR\")))","v":""},{"$f":"IFERROR(GEOMEAN(F12:F14),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E12/G12),\"\")","v":""},{"$f":"IF($B12=\"N/A\",\"\",\"X\")","v":"X"},"X","X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L12=\"No\",'D (Chronic)'!L13,(IF('C (Acute)'!L12=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L12=\"No\",'D (Chronic)'!L14,(IF('C (Acute)'!L12=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,{"$f":"'D (Chronic)'!B15","v":"Daphnia"},{"$f":"'D (Chronic)'!C15","v":"pulex"},"Water flea",{"$f":"IF(AND('A (Acute)'!K15=\"\",'A (Acute)'!K16=\"\",'A (Acute)'!K17=\"\"),\"\",GEOMEAN('A (Acute)'!K15:K17))","v":""},{"$f":"IF('C (Acute)'!L15=\"No\",'D (Chronic)'!L15,(IF('C (Acute)'!L15=\"Yes\",\"used in sensitive spp SMACR\")))","v":""},{"$f":"IFERROR(GEOMEAN(F15:F17),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E15/G15),\"\")","v":""},{"$f":"IF($B15=\"N/A\",\"\",\"X\")","v":"X"},"X","X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L15=\"No\",'D (Chronic)'!L16,(IF('C (Acute)'!L15=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L15=\"No\",'D (Chronic)'!L17,(IF('C (Acute)'!L15=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,{"$f":"'D (Chronic)'!B18","v":"Simocephalus"},{"$f":"'D (Chronic)'!C18","v":"serrulatus"},"Water flea",{"$f":"IF(AND('A (Acute)'!K18=\"\",'A (Acute)'!K19=\"\",'A (Acute)'!K20=\"\"),\"\",GEOMEAN('A (Acute)'!K18:K20))","v":""},{"$f":"IF('C (Acute)'!L18=\"No\",'D (Chronic)'!L18,(IF('C (Acute)'!L18=\"Yes\",\"used in sensitive spp SMACR\")))","v":""},{"$f":"IFERROR(GEOMEAN(F18:F20),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E18/G18),\"\")","v":""},{"$f":"IF($B18=\"N/A\",\"\",\"X\")","v":"X"},"X","X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L18=\"No\",'D (Chronic)'!L19,(IF('C (Acute)'!L18=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L18=\"No\",'D (Chronic)'!L20,(IF('C (Acute)'!L18=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,{"$f":"'D (Chronic)'!B21","v":"Simocephalus"},{"$f":"'D (Chronic)'!C21","v":"vetulus"},"Water flea",{"$f":"IF(AND('A (Acute)'!K21=\"\",'A (Acute)'!K22=\"\",'A (Acute)'!K23=\"\"),\"\",GEOMEAN('A (Acute)'!K21:K23))","v":""},{"$f":"IF('C (Acute)'!L21=\"No\",'D (Chronic)'!L21,(IF('C (Acute)'!L21=\"Yes\",\"used in sensitive spp SMACR\")))","v":""},{"$f":"IFERROR(GEOMEAN(F21:F23),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E21/G21),\"\")","v":""},{"$f":"IF($B21=\"N/A\",\"\",\"X\")","v":"X"},"X","X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L21=\"No\",'D (Chronic)'!L22,(IF('C (Acute)'!L21=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L21=\"No\",'D (Chronic)'!L23,(IF('C (Acute)'!L21=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,null,"Invertebrate SMACR:",{"$f":"IF(ISERROR(GEOMEAN(H3:H23)),18,GEOMEAN(H3:H23))","v":18},{"$f":"IF(H24=18,\"(default)\",\"\")","v":"(default)"}]
["Fish",{"$f":"'D (Chronic)'!B24","v":"Pimephales"},{"$f":"'D (Chronic)'!C24","v":"promelas"},{"$f":"'D (Chronic)'!D24","v":"Fathead minnow"},{"$f":"IF(AND('A (Acute)'!K24=\"\",'A (Acute)'!K25=\"\",'A (Acute)'!K26=\"\"),\"\",GEOMEAN('A (Acute)'!K24:K26))","v":""},{"$f":"IF('C (Acute)'!L24=\"No\",'D (Chronic)'!L24,(IF('C (Acute)'!L24=\"Yes\",\"used in sensitive spp SMACR\")))","v":""},{"$f":"IFERROR(GEOMEAN(F25:F27),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E25/G25),\"\")","v":""},{"$f":"IF($B25=\"N/A\",\"\",\"X\")","v":"X"},"X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L24=\"No\",'D (Chronic)'!L25,(IF('C (Acute)'!L24=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L24=\"No\",'D (Chronic)'!L26,(IF('C (Acute)'!L24=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,{"$f":"'D (Chronic)'!B27","v":"Lepomis"},{"$f":"'D (Chronic)'!C27","v":"Macrochirus"},{"$f":"'D (Chronic)'!D27","v":"Bluegill"},{"$f":"IF(AND('A (Acute)'!K27=\"\",'A (Acute)'!K28=\"\",'A (Acute)'!K29=\"\"),\"\",GEOMEAN('A (Acute)'!K27:K29))","v":""},{"$f":"IF('C (Acute)'!L27=\"No\",'D (Chronic)'!L27,(IF('C (Acute)'!L27=\"Yes\",\"used in sensitive spp SMACR\")))","v":""},{"$f":"IFERROR(GEOMEAN(F28:F30),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E28/G28),\"\")","v":""},{"$f":"IF($B28=\"N/A\",\"\",\"X\")","v":"X"},"X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L27=\"No\",'D (Chronic)'!L28,(IF('C (Acute)'!L27=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L27=\"No\",'D (Chronic)'!L29,(IF('C (Acute)'!L27=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,{"$f":"'D (Chronic)'!B30","v":"Oncorhynchus"},{"$f":"'D (Chronic)'!C30","v":"mykiss"},{"$f":"'D (Chronic)'!D30","v":"Rainbow trout"},{"$f":"IF(AND('A (Acute)'!K30=\"\",'A (Acute)'!K31=\"\",'A (Acute)'!K32=\"\"),\"\",GEOMEAN('A (Acute)'!K30:K32))","v":""},{"$f":"IF('C (Acute)'!L30=\"No\",'D (Chronic)'!L30,(IF('C (Acute)'!L30=\"Yes\",\"used in sensitive spp SMACR\")))","v":""},{"$f":"IFERROR(GEOMEAN(F31:F33),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E31/G31),\"\")","v":""},{"$f":"IF($B31=\"N/A\",\"\",\"X\")","v":"X"}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L30=\"No\",'D (Chronic)'!L31,(IF('C (Acute)'!L30=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L30=\"No\",'D (Chronic)'!L32,(IF('C (Acute)'!L30=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,{"$f":"'D (Chronic)'!B33","v":"Salvelinus"},{"$f":"'D (Chronic)'!C33","v":"fontinalis"},{"$f":"'D (Chronic)'!D33","v":"Brook trout"},{"$f":"IF(AND('A (Acute)'!K33=\"\",'A (Acute)'!K34=\"\",'A (Acute)'!K35=\"\"),\"\",GEOMEAN('A (Acute)'!K33:K35))","v":""},{"$f":"IF('C (Acute)'!L33=\"No\",'D (Chronic)'!L33,(IF('C (Acute)'!L33=\"Yes\",\"used in sensitive spp SMACR\")))","v":""},{"$f":"IFERROR(GEOMEAN(F34:F36),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E34/G34),\"\")","v":""},{"$f":"IF($B34=\"N/A\",\"\",\"X\")","v":"X"}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L33=\"No\",'D (Chronic)'!L34,(IF('C (Acute)'!L33=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L33=\"No\",'D (Chronic)'!L35,(IF('C (Acute)'!L33=\"Yes\",\"used in sensitive spp SMACR\")))","v":""}]
[null,null,null,null,null,null,"Fish SMACR:",{"$f":"IF(ISERROR(GEOMEAN(H25:H36)),18,GEOMEAN(H25:H36))","v":18},{"$f":"IF(H37=18,\"(default)\",\"\")","v":"(default)"}]
[]
["Sensitive freshwater spp.",{"$f":"'D (Chronic)'!B3","v":"Ceriodaphnia"},{"$f":"'D (Chronic)'!C3","v":"dubia"},{"$f":"'D (Chronic)'!D3","v":"Water flea"},{"$f":"IF(AND('A (Acute)'!K3=\"\",'A (Acute)'!K4=\"\",'A (Acute)'!K5=\"\"),\"\",GEOMEAN('A (Acute)'!K3:K5))","v":""},{"$f":"IF('C (Acute)'!L3=\"Yes\",'D (Chronic)'!L3,\"\")","v":""},{"$f":"IFERROR(GEOMEAN(F39:F41),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E39/G39),\"\")","v":""},{"$f":"IF($B39=\"N/A\",\"\",\"X\")","v":"X"},{"$f":"IF($B39=\"N/A\",\"\",\"X\")","v":"X"},"X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L3=\"Yes\",'D (Chronic)'!L4,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L3=\"Yes\",'D (Chronic)'!L5,\"\")","v":""}]
[null,{"$f":"'D (Chronic)'!B6","v":"Ceriodaphnia"},{"$f":"'D (Chronic)'!C6","v":"reticulata"},{"$f":"'D (Chronic)'!D6","v":"Water flea"},{"$f":"IF(AND('A (Acute)'!K6=\"\",'A (Acute)'!K7=\"\",'A (Acute)'!K8=\"\"),\"\",GEOMEAN('A (Acute)'!K6:K8))","v":""},{"$f":"IF('C (Acute)'!L6=\"Yes\",'D (Chronic)'!L6,\"\")","v":""},{"$f":"IFERROR(GEOMEAN(F42:F44),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E42/G42),\"\")","v":""},{"$f":"IF($B42=\"N/A\",\"\",\"X\")","v":"X"},"X","X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L6=\"Yes\",'D (Chronic)'!L7,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L6=\"Yes\",'D (Chronic)'!L8,\"\")","v":""}]
[null,{"$f":"'D (Chronic)'!B9","v":"Ceriodaphnia"},{"$f":"'D (Chronic)'!C9","v":"serrulatus"},{"$f":"'D (Chronic)'!D9","v":"Water flea"},{"$f":"IF(AND('A (Acute)'!K9=\"\",'A (Acute)'!K10=\"\",'A (Acute)'!K11=\"\"),\"\",GEOMEAN('A (Acute)'!K9:K11))","v":""},{"$f":"IF('C (Acute)'!L9=\"Yes\",'D (Chronic)'!L9,\"\")","v":""},{"$f":"IFERROR(GEOMEAN(F45:F47),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E45/G45),\"\")","v":""},{"$f":"IF($B45=\"N/A\",\"\",\"X\")","v":"X"},"X","X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L9=\"Yes\",'D (Chronic)'!L10,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L9=\"Yes\",'D (Chronic)'!L11,\"\")","v":""}]
[null,{"$f":"'D (Chronic)'!B12","v":"Daphnia"},{"$f":"'D (Chronic)'!C12","v":"magna"},{"$f":"'D (Chronic)'!D12","v":"Water flea"},{"$f":"IF(AND('A (Acute)'!K12=\"\",'A (Acute)'!K13=\"\",'A (Acute)'!K14=\"\"),\"\",GEOMEAN('A (Acute)'!K12:K14))","v":""},{"$f":"IF('C (Acute)'!L12=\"Yes\",'D (Chronic)'!L12,\"\")","v":""},{"$f":"IFERROR(GEOMEAN(F48:F50),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E48/G48),\"\")","v":""},{"$f":"IF($B48=\"N/A\",\"\",\"X\")","v":"X"},"X","X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L12=\"Yes\",'D (Chronic)'!L13,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L12=\"Yes\",'D (Chronic)'!L14,\"\")","v":""}]
[null,{"$f":"'D (Chronic)'!B15","v":"Daphnia"},{"$f":"'D (Chronic)'!C15","v":"pulex"},{"$f":"'D (Chronic)'!D15","v":"Water flea"},{"$f":"IF(AND('A (Acute)'!K15=\"\",'A (Acute)'!K16=\"\",'A (Acute)'!K17=\"\"),\"\",GEOMEAN('A (Acute)'!K15:K17))","v":""},{"$f":"IF('C (Acute)'!L15=\"Yes\",'D (Chronic)'!L15,\"\")","v":""},{"$f":"IFERROR(GEOMEAN(F51:F53),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E51/G51),\"\")","v":""},{"$f":"IF($B51=\"N/A\",\"\",\"X\")","v":"X"},"X","X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L15=\"Yes\",'D (Chronic)'!L16,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L15=\"Yes\",'D (Chronic)'!L17,\"\")","v":""}]
[null,{"$f":"'D (Chronic)'!B18","v":"Simocephalus"},{"$f":"'D (Chronic)'!C18","v":"serrulatus"},{"$f":"'D (Chronic)'!D18","v":"Water flea"},{"$f":"IF(AND('A (Acute)'!K18=\"\",'A (Acute)'!K19=\"\",'A (Acute)'!K20=\"\"),\"\",GEOMEAN('A (Acute)'!K18:K20))","v":""},{"$f":"IF('C (Acute)'!L18=\"Yes\",'D (Chronic)'!L18,\"\")","v":""},{"$f":"IFERROR(GEOMEAN(F54:F56),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E54/G54),\"\")","v":""},{"$f":"IF($B54=\"N/A\",\"\",\"X\")","v":"X"},"X","X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L18=\"Yes\",'D (Chronic)'!L19,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L18=\"Yes\",'D (Chronic)'!L20,\"\")","v":""}]
[null,{"$f":"'D (Chronic)'!B21","v":"Simocephalus"},{"$f":"'D (Chronic)'!C21","v":"vetulus"},{"$f":"'D (Chronic)'!D21","v":"Water flea"},{"$f":"IF(AND('A (Acute)'!K21=\"\",'A (Acute)'!K22=\"\",'A (Acute)'!K23=\"\"),\"\",GEOMEAN('A (Acute)'!K21:K23))","v":""},{"$f":"IF('C (Acute)'!L21=\"Yes\",'D (Chronic)'!L21,\"\")","v":""},{"$f":"IFERROR(GEOMEAN(F57:F59),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E57/G57),\"\")","v":""},{"$f":"IF($B57=\"N/A\",\"\",\"X\")","v":"X"},"X","X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L21=\"Yes\",'D (Chronic)'!L22,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L21=\"Yes\",'D (Chronic)'!L23,\"\")","v":""}]
[null,{"$f":"'D (Chronic)'!B24","v":"Pimephales"},{"$f":"'D (Chronic)'!C24","v":"promelas"},{"$f":"'D (Chronic)'!D24","v":"Fathead minnow"},{"$f":"IF(AND('A (Acute)'!K24=\"\",'A (Acute)'!K25=\"\",'A (Acute)'!K26=\"\"),\"\",GEOMEAN('A (Acute)'!K24:K26))","v":""},{"$f":"IF('C (Acute)'!L24=\"Yes\",'D (Chronic)'!L24,\"\")","v":""},{"$f":"IFERROR(GEOMEAN(F60:F62),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E60/G60),\"\")","v":""},{"$f":"IF($B60=\"N/A\",\"\",\"X\")","v":"X"},"X","X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L24=\"Yes\",'D (Chronic)'!L25,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L24=\"Yes\",'D (Chronic)'!L26,\"\")","v":""}]
[null,{"$f":"'D (Chronic)'!B27","v":"Lepomis"},{"$f":"'D (Chronic)'!C27","v":"Macrochirus"},{"$f":"'D (Chronic)'!D27","v":"Bluegill"},{"$f":"IF(AND('A (Acute)'!K27=\"\",'A (Acute)'!K28=\"\",'A (Acute)'!K29=\"\"),\"\",GEOMEAN('A (Acute)'!K27:K29))","v":""},{"$f":"IF('C (Acute)'!L27=\"Yes\",'D (Chronic)'!L27,\"\")","v":""},{"$f":"IFERROR(GEOMEAN(F63:F65),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E63/G63),\"\")","v":""},{"$f":"IF($B63=\"N/A\",\"\",\"X\")","v":"X"},"X"]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L27=\"Yes\",'D (Chronic)'!L28,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L27=\"Yes\",'D (Chronic)'!L29,\"\")","v":""}]
[null,{"$f":"'D (Chronic)'!B30","v":"Oncorhynchus"},{"$f":"'D (Chronic)'!C30","v":"mykiss"},{"$f":"'D (Chronic)'!D30","v":"Rainbow trout"},{"$f":"IF(AND('A (Acute)'!K30=\"\",'A (Acute)'!K31=\"\",'A (Acute)'!K32=\"\"),\"\",GEOMEAN('A (Acute)'!K30:K32))","v":""},{"$f":"IF('C (Acute)'!L30=\"Yes\",'D (Chronic)'!L30,\"\")","v":""},{"$f":"IFERROR(GEOMEAN(F66:F68),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E66/G66),\"\")","v":""},{"$f":"IF($B66=\"N/A\",\"\",\"X\")","v":"X"}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L30=\"Yes\",'D (Chronic)'!L31,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L30=\"Yes\",'D (Chronic)'!L32,\"\")","v":""}]
[null,{"$f":"'D (Chronic)'!B33","v":"Salvelinus"},{"$f":"'D (Chronic)'!C33","v":"fontinalis"},{"$f":"'D (Chronic)'!D33","v":"Brook trout"},{"$f":"IF(AND('A (Acute)'!K33=\"\",'A (Acute)'!K34=\"\",'A (Acute)'!K35=\"\"),\"\",GEOMEAN('A (Acute)'!K33:K35))","v":""},{"$f":"IF('C (Acute)'!L33=\"Yes\",'D (Chronic)'!L33,\"\")","v":""},{"$f":"IFERROR(GEOMEAN(F69:F71),\"\")","v":""},{"$f":"IFERROR(GEOMEAN(E69/G69),\"\")","v":""},{"$f":"IF($B69=\"N/A\",\"\",\"X\")","v":"X"}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L33=\"Yes\",'D (Chronic)'!L34,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF('C (Acute)'!L33=\"Yes\",'D (Chronic)'!L35,\"\")","v":""}]
[null,null,null,null,null,null,"Sensitive Freshwater Species SMACR:",{"$f":"IF(ISERROR(GEOMEAN(H39:H71)),18, GEOMEAN(H39:H71))","v":18},{"$f":"IF(H72=18,\"(default)\",\"\")","v":"(default)"}]
[null,null,null,null,null,null,"SACR:",null,{"$f":"IFERROR(GEOMEAN(H3:H72),\"N/A\")","v":18},{"$f":"IFERROR(GEOMEAN(H3:H24,H25:H30,H37,H72),\"N/A\")","v":18},{"$f":"IFERROR(GEOMEAN(H3:H24,H25,H37,H72),\"N/A\")","v":18},{"$f":"IFERROR(GEOMEAN(H3:H24,H72),\"N/A\")","v":18}]
[null,null,null,null,null,null,"Selected SAV:",null,{"$f":"IF('C (Acute)'!H39=\"N/A\",\"N/A\",'C (Acute)'!H39)","v":"N/A"},{"$f":"IF('C (Acute)'!I39=\"N/A\",\"N/A\",'C (Acute)'!I39)","v":"N/A"},{"$f":"IF('C (Acute)'!J39=\"N/A\",\"N/A\",'C (Acute)'!J39)","v":"N/A"},{"$f":"IF('C (Acute)'!K39=\"N/A\",\"N/A\",'C (Acute)'!K39)","v":"N/A"}]
[null,null,null,null,null,null,"Calculated SCV:",null,{"$f":"IF(I74=\"N/A\",\"N/A\",I74/I73)","v":"N/A"},{"$f":"IF(J74=\"N/A\",\"N/A\",J74/J73)","v":"N/A"},"N/A","N/A"]
[null,null,null,null,null,null,"Selected SCV:",null,{"$f":"I75","v":"N/A"},{"$f":"IF(J75=\"N/A\", \"N/A\",MAX(I75:J75))","v":"N/A"},{"$f":"IF(K75=\"N/A\", \"N/A\",MAX(I75:K75))","v":"N/A"},{"$f":"IF(L75=\"N/A\", \"N/A\",MAX(I75:L75))","v":"N/A"},{"$f":"IF(E2=\"\",\"Units\",E2)","v":"mg/L"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I76=\"N/A\",\"N/A\",I76*1000)","v":"N/A"},{"$f":"IF(J76=\"N/A\", \"N/A\",J76*1000)","v":"N/A"},{"$f":"IF(K76=\"N/A\",\"N/A\",K76*1000)","v":"N/A"},{"$f":"IF(L76=\"N/A\", \"N/A\",L76*1000)","v":"N/A"},"µg/L"]

{"sheet":"Chronic-acceptiblity requiremen","index":9,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":true,"merged":[[1,0,3,0],[29,0,30,0],[18,0,19,0],[7,0,9,0],[5,0,6,0],[13,0,17,0],[10,0,12,0],[27,0,28,0],[22,0,23,0],[20,0,21,0],[24,0,26,0]]}
["Test Parameter","All species","Cladoceran/water flea (Ceriodaphnia dubia)","Fathead minnow (Pimephales promelas)"]
["Exposure Format:","Static"]
[null,"Flow-through"]
[null,"Approved by DNR Toxicologist"]
[]
["Test duration:",null,"≤ 8 days","7 days"]
[null,null,"Other","other"]
["Control response:","≥80% survival"]
[null,"Approved by DNR Toxicologist","≥80% survival, average of ≥15  young per surviving control female, and 80% of surviving control females must produce 3 broods  (recommended)","≥80% survival and average dry weight per organism of control ≥ 0.25 mg  (recommended for 1001.0)"]
[null,null,"Other","Other"]
["Temperature:","20±1 °C"]
[null,"25±1 °C"]
[null,"Other"]
["Dilution water:","Moderately hard synthetic water"]
[null,"Synthetic water"]
[null,"Receiving water"]
[null,"Ground water"]
[null,"Other"]
["Test concentrations:","≥ 5 + control"]
[null,"Other"]
["Dilution series","≥0.5 dilution series"]
[null,"Other"]
["Age of test organisms:",null,"< 24 h","< 48 hr"]
[null,null,"Other","Other"]
["No. organisms/test chamber:",null,"1 (at test outset)","≥10 with 500 mL chamber size (acceptable)"]
[null,null,"Other","2 with 30 mL chamber size (recommended)"]
[null,null,null,"Other"]
["No. replicate chambers/concentration:",null,"≥ 10","≥ 3 "]
[null,null,"Other","Other"]
["No. organisms/ concentration:",null,"≥ 10 ","≥ 30 "]
[null,null,"Other","Other"]
[]
[null,"Units"]
[null,"µg/L (ppb)"]
[null,"mg/L (ppm)"]
[null,"g/L"]
[]
[null,"Test Type"]
[null,"7-day Reproduction"]
[null,"7-day Growth"]
[null,"7-day Survival "]
[null,"Other"]
[]
[null,"Endpoints"]
[null,"NOEL/NOAEL"]
[null,"LOEL/LOAEL"]
[null,"Other"]
[]
[null,"Ceriodaphnia Test Methods","Other water flea or fish  species Test Methods","FHM Test Methods"]
[null,"WI certified method/lab","WI certified method/lab","WI certified method/lab"]
[null,"EPA 1002.0","Other","EPA 1000.0"]
[null,"Other","Approved by DNR Toxicologist","EPA 1001.0"]
[null,"Approved by DNR Toxicologist",null,"Other"]
[null,null,null,"Approved by DNR Toxicologist"]

{"sheet":"Tab Descriptions","index":10,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":true,"merged":[[1,1,4,1],[5,1,7,1]]}
["Tab","Value Category","Description","Steps"]
["A","Acute","Available Data","1-3"]
["B",null,"Data Acceptability","2A"]
["C",null,"SAV Calculation","4-9"]
["D",null,"Taxa Requirements",7]
["E","Chronic","Available Data","1-3"]
["F",null,"Data Acceptability","2A"]
["G",null,"SCV Calculation","4-9"]