{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Updates","Example","Calculator","TST Summary Sheet","Statistics","Formulas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":60,"n_cols":1,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["TST Spreadsheet Tool v1.9"]
[]
["TST Summary"]
["The Test of Significant Toxicity (TST) is a new statistical approach that assesses the whole effluent toxicity (WET) measurement of wastewater effects on specific test organisms’ ability to survive, grow, and reproduce developed by the U.S. EPA.  TST uses hypothesis testing techniques which examines whether a sample, at the critical concentration (e.g., in-stream waste concentration or IWC), and the control within a WET test differ by an unacceptable amount (the amount that would have a measured adverse effect on the ability of aquatic organisms to thrive and survive).  A sample can be either an effluent, stormwater, or receiving water.  Once the WET test has been conducted, the TST approach can be used to analyze valid WET test data to assess whether the sample is toxic.  The TST approach is designed to be used for a two concentration data analysis of the sample's critical concentration (e.g., IWC or a receiving water concentration) as compared to a control concentration."]
["TST Spreadsheet Tool"]
["This tool was created for several of the EPA WET test methods for the West Coast marine species (USEPA 1995) and the 2002 EPA WET test methods (USEPA 2002a, 2002b, 2002c) for other species."]
[]
["For questions, please contact:"]
["Jaime Gilliam"]
["Tetra Tech, Inc."]
["410-356-8993"]
[]
["The update from version 1.8 to 1.9 was performed by:"]
["John Wheeler"]
["Division of Water Quality"]
["State Water Resources Control Board"]
["John.Wheeler@waterboards.ca.gov"]
[]
["Instructions "]
["Before using this program, Macros must be enabled and the security certificate must be accepted. "]
[]
["For Excel 2007:"]
["1. Click the “Office Button” (big Office logo in the upper left), and select “Excel Options” (lower right)"]
["2. Click \"Trust Center\" on the left menu"]
["3. Click \"Trust Center Settings\" (lower right)"]
["4. Click \"Macro Settings\""]
["5. Click \"Enable all macros\" (last option)"]
["6. Click \"ok\" buttons to clear all open windows"]
["7. Exit program and re-open the file to use"]
[]
["For Excel pre-2007:"]
["1. Go to \"Tools\", \"Macro\", and Click \"Security\""]
["2. Set Macro security to medium"]
["3. Exit program and re-open file"]
["4. Click \"Enable Macros\""]
[]
["To use the program: "]
["1.  Enter test information in the first block of pink shaded cells - Lab Name, Client Name, Test ID, Test Date, Test Duration, and IWC (Critical Concentration) "]
["* \"Critical Conc.\" means a facility specific IWC or 100% receiving water, etc. (i.e., one concentration of WET test)"]
["2.  Fill in your raw test data (Number of Organisms Exposed or Counted and Response) for as many replicates as conducted in WET test "]
["* Percent data (survival, germination, etc.) should be input as whole numbers (not as decimals)"]
["* Fish growth must be input as biomass"]
["3.  Choose the appropriate test information from the pink \"Click to choose from menu\" cells "]
["4.  All gray cells will fill-in automatically if needed "]
["5.  Click on the yellow button to save data to the \"Statistics\" tab if desired "]
["* This will create a running log of the calculated values for each test entered"]
["6.  Click on the \"TST Summary Sheet\" tab for a printer friendly version of the data and print if desired "]
["7.  Click on the green button on the \"Calculator\" tab to clear all the red input cells to enter new dataset "]
["* Clearing the data on the \"Calculator\" tab will also clear the \"TST Summary Sheet\" - be sure to print before clearing"]
["8.  Enter your next set of test data as directed above and a log of your data will be formed on the \"Statistics\" tab "]
["9.  You must save the Excel workbook file when finished if you want your data to be available the next time you open the file "]
[" "]
["Results description: "]
["A t-value is calculated for your dataset (\"Calculated t-value\") and compared against the \"Critical t-value\" based on the degrees of freedom of your dataset.  If the Calculated t-value is greater than the Critical t-value, then the sample is not toxic at that concentration. If the calculated value is less than or equal to the critical value, then the sample is toxic. In the event that there is no variance in both the control and the IWC, the percent effect is used to determine whether the sample is toxic. "]
[" "]
["Notes:"]
["For acute tests with optional 2 or 4 replicates (e.g., fathead minnow), TST requires 4 replicates."]
["The chronic survival analysis is not available for C. dubia."]
["For a list of alpha, beta, and b (RMD) values for each test method/species, please refer to Table 1 of the Toxicity Provisions."]
["If no variance in both the control and the IWC,  a percent effect <25% for chronic, or <20% for acute is considered \"Passing\"."]

{"sheet":"Updates","index":1,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["TST Calculator v1.9 Updates (performed April 2021):"]
["The calculator was expanded to allow the user to input data for up to 40 replicates, instead of 20."]
["Minor formatting changes were made, in order to make the spreadsheet tool more accessible to individuals with disabilities (e.g. removed merged cells)."]
["The \"TST Summary Sheet\" sheet was rearranged to allow data from up to 40 replicates to fit on one printed page."]
["Screen tips were added to the \"Calculator\" sheet, to provide instructions when the data input cells are selected. "]
["The VBA code and hidden sheets were updated to work properly with the updated \"Calculator\" tab."]
["Certain terms used in the spreadsheet were slightly changed."]
["The \"Example\" sheet was updated in order to match the updated \"Calculator\" sheet."]
[]
["TST Calculator v1.8 Updates:"]
["TST Calculator v1.7 was updated to include space for a lab and client name, as well as making cells larger for test information input."]

{"sheet":"Example","index":2,"n_rows":64,"n_cols":22,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Click to choose from menu","Click to choose from menu","Click to choose from menu",null,null,null,null,null,null,"Conduct WET Test"]
[null,null,null,null,null,null,null,null,null,null,"Fertilization","A. affinis (topsmelt)","Acute",null,null,null,null,null,null,"↓"]
[null,null,null,null,null,null,null,null,null,null,"Germination","A. bahia (mysid shrimp)","Chronic",null,null,null,null,null,null,"Apply arcsine square root transformation for percent data"]
["Lab Name","Example Laboratory",null,null,null,null,null,null,null,null,"Germ-Tube Length","A. punctulata (echinoderm)",null,null,null,null,null,null,null,"↓"]
["Client Name","Example Client",null,null,null,null,null,null,null,null,"Growth","C. dubia (water flea)",null,null,null,null,null,null,null,"Calculate t value using TST Welch’s test"]
["Test ID","Test_001",null,null,null,null,null,null,null,null,"Larval Development","C. gigas (oyster)",null,null,null,null,null,null,null,"↓"]
["Test Date","2020-04-14",null,null,null,null,null,null,null,null,"Reproduction","C. variegatus (sheepshead minnow)",null,null,null,null,null,null,null,"Calculated t-value > critical t-value?"]
["Test Duration","7 day",null,null,null,null,null,null,null,null,"Survival","D. excentricus (echinoderm)",null,null,null,null,null,null,"↓",null,"↓"]
["IWC","50% effluent",null,null,null,null,null,null,null,null,null,"D. magna (water flea)",null,null,null,null,null,null,"YES",null,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,"D. pulex (water flea)",null,null,null,null,null,null,"\"PASS\"",null,"\"FAIL\""]
[null,"Control Data","Control Data","IWC (Instream Waste Concentration) Data","IWC (Instream Waste Concentration) Data",null,null,null,"Arcsine SqRt Transformation",null,null,"H. azteca (amphipod)",null,null,null,null,null,null,"Sample is NOT Toxic",null,"Sample is Toxic","If no variance in both the control and the IWC,  a % difference <25 for chronic, or <20 for acute is considered \"Passing\"."]
["Replicate Number","Number of Organisms Exposed or Counted","Response (Final Count, Weight, Length, etc.)","Number of Organisms Exposed or Counted","Response (Final Count, Weight, Length, etc.)","Control","IWC",null,"Control","Critical Conc. (IWC)",null,"H. costata (mysid)",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(S19=0,T19=0),((AVERAGE(C13:C52)-AVERAGE(E13:E52))/AVERAGE(C13:C52))*100,\"\")","v":""}]
[1,10,10,10,9,{"$f":"IF(AND(ISNUMBER(C13),$C$60=\"Yes\"),C13/B13,\"\")","v":1},{"$f":"IF(AND(ISNUMBER(E13),$C$60=\"Yes\"),E13/D13,\"\")","v":0.9},null,{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(F13),F13=0),ASIN(SQRT(1/(4*B13))),IF(AND($C$60=\"Yes\",ISNUMBER(F13),F13=1),ASIN(SQRT(1-(1/(4*B13)))),IF(AND($C$60=\"Yes\",ISNUMBER(F13)),ASIN(SQRT(F13)),\"\")))","v":1.4120161121491357},{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(G13),G13=0),ASIN(SQRT(1/(4*D13))),IF(AND($C$60=\"Yes\",ISNUMBER(G13),G13=1),ASIN(SQRT(1-(1/(4*D13)))),IF(AND($C$60=\"Yes\",ISNUMBER(G13)),ASIN(SQRT(G13)),\"\")))","v":1.2490457723982542},null,"H. rufescens (red abalone)"]
[2,10,9,10,8,{"$f":"IF(AND(ISNUMBER(C14),$C$60=\"Yes\"),C14/B14,\"\")","v":0.9},{"$f":"IF(AND(ISNUMBER(E14),$C$60=\"Yes\"),E14/D14,\"\")","v":0.8},null,1.2490457723982542,1.1071487177940904,null,"M. berryllina (inland silverside)"]
[3,10,10,10,9,1,0.9,null,1.4120161121491357,1.2490457723982542,null,"M. menidia (atlantic silverside)"]
[4,10,10,10,8,1,0.8,null,1.4120161121491357,1.1071487177940904,null,"M. peninsulae (tidewater silverside)",null,null,null,null,null,"Statistic","Control","IWC"]
[5,null,null,null,null,"","",null,"","",null,"M. pyrifera (giant kelp)",null,null,null,null,null,{"$f":"IF(AND($C$60=\"No\",ISNUMBER(C13)), \"Mean of Raw Data\",IF(AND($C$60=\"Yes\",ISNUMBER(C13)),\"Percent Mean of Raw Data\",\"\"))","v":"Percent Mean of Raw Data"},{"$f":"IF(AND($C$60=\"No\",ISNUMBER(C13)), AVERAGE(C13:C52),IF(AND($C$60=\"Yes\",ISNUMBER(C13)),AVERAGE(C13:C52)/AVERAGE(B13:B52),\"\"))","v":0.97499999999999998},{"$f":"IF(AND($C$60=\"No\",ISNUMBER(E13)), AVERAGE(E13:E52),IF(AND($C$60=\"Yes\",ISNUMBER(E13)),AVERAGE(E13:E52)/AVERAGE(D13:D52),\"\"))","v":0.85}]
[6,null,null,null,null,"","",null,"","",null,"Mytilus sp. (mussel)",null,null,null,null,null,{"$f":"IF(AND($C$60=\"No\",ISNUMBER(C13)), \"Mean used in Calculation (non-transformed)\",IF(AND($C$60=\"Yes\",ISNUMBER(C13)),\"Mean used in Calcuation (transformed)\",\"\"))","v":"Mean used in Calcuation (transformed)"},{"$f":"IF(C60=\"NO\",AVERAGE(C13:C52), IF(C60=\"YES\",AVERAGE(I13:I52),\"\"))","v":1.3712735272114154},{"$f":"IF(C60=\"NO\",AVERAGE(E13:E52), IF(C60=\"YES\",AVERAGE(J13:J52),\"\"))","v":1.1780972450961724}]
[7,null,null,null,null,"","",null,"","",null,"O. mykiss (rainbow trout)",null,null,null,null,null,{"$f":"IF(AND($C$60=\"No\",ISNUMBER(C13)), \"Variance used in Calculation (non-transformed)\",IF(AND($C$60=\"Yes\",ISNUMBER(C13)),\"Variance used in Calcuation (transformed)\",\"\"))","v":"Variance used in Calcuation (transformed)"},{"$f":"IF(C60=\"NO\",VAR(C13:C52),IF(C60=\"YES\",VAR(I13:I52),\"\"))","v":6.6398329096294352E-3},{"$f":"IF(C60=\"NO\",VAR(E13:E52),IF(C60=\"YES\",VAR(J13:J52),\"\"))","v":6.7115913684456805E-3}]
[8,null,null,null,null,"","",null,"","",null,"P. promelas (fathead minnow)",null,null,null,null,null,{"$f":"IF(AND($C$60=\"No\",ISNUMBER(C13)), \"Standard Deviation of Raw Data\",IF(AND($C$60=\"Yes\",ISNUMBER(C13)),\"Standard Deviation of Transformed Data\",\"\"))","v":"Standard Deviation of Transformed Data"},{"$f":"IF(ISNUMBER(S19),SQRT(S19),\"\")","v":8.1485169875440744E-2},{"$f":"IF(ISNUMBER(T19),SQRT(T19),\"\")","v":8.1924302672928995E-2}]
[9,null,null,null,null,"","",null,"","",null,"S. capricornutum (green algae)",null,null,null,null,null,{"$f":"IF(AND($C$60=\"No\",ISNUMBER(C13)), \"CV of Raw Data\",IF(AND($C$60=\"Yes\",ISNUMBER(C13)),\"CV of Transformed Data\",\"\"))","v":"CV of Transformed Data"},{"$f":"IF(ISNUMBER(S18),S20/S18,\"\")","v":5.9422987652322561E-2},{"$f":"IF(ISNUMBER(T18),T20/T18,\"\")","v":6.9539507892017197E-2}]
[10,null,null,null,null,"","",null,"","",null,"S. fontinalis (brook trout)",null,null,null,null,null,{"$f":"IF(ISNUMBER(S22),\"n\",\"\")","v":"n"},{"$f":"IF($C$60=\"NO\",COUNT(C13:C52),IF($C$60=\"YES\",COUNT(I13:I52),\"\"))","v":4},{"$f":"IF($C$60=\"NO\",COUNT(E13:E52),IF($C$60=\"YES\",COUNT(J13:J52),\"\"))","v":4}]
[11,null,null,null,null,"","",null,"","",null,"S. purpuratus (echinoderm)"]
[12,null,null,null,null,"","",null,"","",null,"T. gratilla (echinoderm)",null,null,null,null,null,"Mean % Effect at IWC",{"$f":"IF(AND(ISNUMBER(S17),ISNUMBER(T17)),((S17-T17)/S17)*100,\"\")","v":12.820512820512823}]
[13,null,null,null,null,"","",null,"",""]
[14,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,"Calculated t-value=",{"$f":"IF(OR(ISTEXT(C62),ISTEXT(C64),C58=\"Click to choose from menu\"),\"\",(T18-(C62*S18))/SQRT((T19/T22)+(((C62^2)*S19)/S22)))","v":1.5488470354765529}]
[15,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,"Degrees of Freedom (ν)=",{"$f":"IF(OR(ISTEXT(C62),ISTEXT(C64),C58=\"Click to choose from menu\"),\"\",INT(((((T19/T22)+((((C62)^2)*S19)/S22))^2))/((((T19/T22)^2)/(T22-1))+((((((C62^2)*S19)/S22)^2)/(S22-1))))))","v":5}]
[16,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,"Critical t-value=",{"$f":"IF(OR(ISTEXT(C62),ISTEXT(C64),C58=\"Click to choose from menu\"),\"\",TINV((2*C64),S27))","v":1.4758840488244813}]
[17,null,null,null,null,"","",null,"",""]
[18,null,null,null,null,"","",null,"",""]
[19,null,null,null,null,"","",null,"",""]
[20,null,null,null,null,{"$f":"IF(AND(ISNUMBER(C32),$C$60=\"Yes\"),C32/B32,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(E32),$C$60=\"Yes\"),E32/D32,\"\")","v":""},null,"",""]
[21,null,null,null,null,"","",null,"",""]
[22,null,null,null,null,"","",null,"",""]
[23,null,null,null,null,"","",null,"",""]
[24,null,null,null,null,"","",null,"",""]
[25,null,null,null,null,"","",null,"",""]
[26,null,null,null,null,"","",null,{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(F38),F38=0),ASIN(SQRT(1/(4*B38))),IF(AND($C$60=\"Yes\",ISNUMBER(F38),F38=1),ASIN(SQRT(1-(1/(4*B38)))),IF(AND($C$60=\"Yes\",ISNUMBER(F38)),ASIN(SQRT(F38)),\"\")))","v":""},""]
[27,null,null,null,null,"","",null,"",""]
[28,null,null,null,null,"","",null,"",""]
[29,null,null,null,null,"","",null,"",{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(G41),G41=0),ASIN(SQRT(1/(4*D41))),IF(AND($C$60=\"Yes\",ISNUMBER(G41),G41=1),ASIN(SQRT(1-(1/(4*D41)))),IF(AND($C$60=\"Yes\",ISNUMBER(G41)),ASIN(SQRT(G41)),\"\")))","v":""}]
[30,null,null,null,null,"","",null,"",""]
[31,null,null,null,null,"","",null,"",""]
[32,null,null,null,null,"","",null,{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(F44),F44=0),ASIN(SQRT(1/(4*B44))),IF(AND($C$60=\"Yes\",ISNUMBER(F44),F44=1),ASIN(SQRT(1-(1/(4*B44)))),IF(AND($C$60=\"Yes\",ISNUMBER(F44)),ASIN(SQRT(F44)),\"\")))","v":""},""]
[33,null,null,null,null,"","",null,"",""]
[34,null,null,null,null,"","",null,"",""]
[35,null,null,null,null,"","",null,"",""]
[36,null,null,null,null,"","",null,"",""]
[37,null,null,null,null,"","",null,"",""]
[38,null,null,null,null,"","",null,"",""]
[39,null,null,null,null,"","",null,{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(F51),F51=0),ASIN(SQRT(1/(4*B51))),IF(AND($C$60=\"Yes\",ISNUMBER(F51),F51=1),ASIN(SQRT(1-(1/(4*B51)))),IF(AND($C$60=\"Yes\",ISNUMBER(F51)),ASIN(SQRT(F51)),\"\")))","v":""},{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(G51),G51=0),ASIN(SQRT(1/(4*D51))),IF(AND($C$60=\"Yes\",ISNUMBER(G51),G51=1),ASIN(SQRT(1-(1/(4*D51)))),IF(AND($C$60=\"Yes\",ISNUMBER(G51)),ASIN(SQRT(G51)),\"\")))","v":""}]
[40,null,null,null,null,{"$f":"IF(AND(ISNUMBER(C52),$C$60=\"Yes\"),C52/B52,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(E52),$C$60=\"Yes\"),E52/D52,\"\")","v":""},null,{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(F52),F52=0),ASIN(SQRT(1/(4*B52))),IF(AND($C$60=\"Yes\",ISNUMBER(F52),F52=1),ASIN(SQRT(1-(1/(4*B52)))),IF(AND($C$60=\"Yes\",ISNUMBER(F52)),ASIN(SQRT(F52)),\"\")))","v":""},""]
[]
[null,"Test Species?","P. promelas (fathead minnow)"]
[]
[null,"Chronic or Acute?","Acute"]
[null,null,{"$f":"IF(AND(C54=\"C. dubia (water flea)\",C56=\"Chronic\",C58=\"Survival\"),\"Note: The chronic survival analysis is NOT available for C. dubia\",\"\")","v":""}]
[null,"Endpoint?","Survival"]
[]
[null,"Percent Data?",{"$f":"IF(OR(C58=\"Reproduction\",C58=\"Growth\",C58=\"Germ-Tube Length\"),\"No\",IF(OR(C58=\"Survival\",C58=\"Fertilization\",C58=\"Germination\",C58=\"Larval Development\"),\"Yes\",\"\"))","v":"Yes"}]
[]
[null,"b=",{"$f":"IF(AND(C54=\"C. dubia (water flea)\",C56=\"Chronic\",C58=\"Survival\"),\"\",IF(C56=\"Chronic\", 0.75, IF(C56=\"Acute\", 0.8,\"\")))","v":0.8}]
[]
[null,"α=",{"$f":"IF(AND(C56=\"Chronic\",C54=\"C. dubia (water flea)\"),0.2,IF(AND(C56=\"Chronic\",OR(C54=\"P. promelas (fathead minnow)\",C54=\"S. capricornutum (green algae)\",C54=\"C. variegatus (sheepshead minnow)\",C54=\"M. berryllina (inland silverside)\",C54=\"A. affinis (topsmelt)\")),0.25,IF(AND(C56=\"Chronic\",OR(C54=\"A. bahia (mysid shrimp)\",C54=\"H. costata (mysid)\")),0.15,IF(AND(C56=\"Chronic\",OR(C54=\"A. punctulata (echinoderm)\",C54=\"D. excentricus (echinoderm)\",C54=\"S. purpuratus (echinoderm)\",C54=\"H. rufescens (red abalone)\",C54=\"M. pyrifera (giant kelp)\", C54=\"C. gigas (oyster)\", C54=\"Mytilus sp. (mussel)\",C54=\"T. gratilla (echinoderm)\")),0.05,IF(C56=\"Acute\",0.1,\"\")))))","v":0.1}]

{"sheet":"Calculator","index":3,"n_rows":64,"n_cols":22,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Click to choose from menu","Click to choose from menu","Click to choose from menu",null,null,null,null,null,null,"Conduct WET Test"]
[null,null,null,null,null,null,null,null,null,null,"Fertilization","A. affinis (topsmelt)","Acute",null,null,null,null,null,null,"↓"]
[null,null,null,null,null,null,null,null,null,null,"Germination","A. bahia (mysid shrimp)","Chronic",null,null,null,null,null,null,"Apply arcsine square root transformation for percent data"]
["Lab Name",null,null,null,null,null,null,null,null,null,"Germ-Tube Length","A. punctulata (echinoderm)",null,null,null,null,null,null,null,"↓"]
["Client Name",null,null,null,null,null,null,null,null,null,"Growth","C. dubia (water flea)",null,null,null,null,null,null,null,"Calculate t value using TST Welch’s test"]
["Test ID",null,null,null,null,null,null,null,null,null,"Larval Development","C. gigas (oyster)",null,null,null,null,null,null,null,"↓"]
["Test Date",null,null,null,null,null,null,null,null,null,"Reproduction","C. variegatus (sheepshead minnow)",null,null,null,null,null,null,null,"Calculated t-value > critical t-value?"]
["Test Duration",null,null,null,null,null,null,null,null,null,"Survival","D. excentricus (echinoderm)",null,null,null,null,null,null,"↓",null,"↓"]
["IWC",null,null,null,null,null,null,null,null,null,null,"D. magna (water flea)",null,null,null,null,null,null,"YES",null,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,"D. pulex (water flea)",null,null,null,null,null,null,"\"PASS\"",null,"\"FAIL\""]
[null,"Control Data","Control Data","IWC (Instream Waste Concentration) Data","IWC (Instream Waste Concentration) Data",null,null,null,"Arcsine SqRt Transformation",null,null,"H. azteca (amphipod)",null,null,null,null,null,null,"Sample is NOT Toxic",null,"Sample is Toxic","If no variance in both the control and the IWC,  a % difference <25 for chronic, or <20 for acute is considered \"Passing\"."]
["Replicate Number","Number of Organisms Exposed or Counted","Response (Final Count, Weight, Length, etc.)","Number of Organisms Exposed or Counted","Response (Final Count, Weight, Length, etc.)","Control","IWC",null,"Control","Critical Conc. (IWC)",null,"H. costata (mysid)",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(S19=0,T19=0),((AVERAGE(C13:C52)-AVERAGE(E13:E52))/AVERAGE(C13:C52))*100,\"\")","v":""}]
[1,null,null,null,null,{"$f":"IF(AND(ISNUMBER(C13),$C$60=\"Yes\"),C13/B13,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(E13),$C$60=\"Yes\"),E13/D13,\"\")","v":""},null,{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(F13),F13=0),ASIN(SQRT(1/(4*B13))),IF(AND($C$60=\"Yes\",ISNUMBER(F13),F13=1),ASIN(SQRT(1-(1/(4*B13)))),IF(AND($C$60=\"Yes\",ISNUMBER(F13)),ASIN(SQRT(F13)),\"\")))","v":""},{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(G13),G13=0),ASIN(SQRT(1/(4*D13))),IF(AND($C$60=\"Yes\",ISNUMBER(G13),G13=1),ASIN(SQRT(1-(1/(4*D13)))),IF(AND($C$60=\"Yes\",ISNUMBER(G13)),ASIN(SQRT(G13)),\"\")))","v":""},null,"H. rufescens (red abalone)"]
[2,null,null,null,null,{"$f":"IF(AND(ISNUMBER(C14),$C$60=\"Yes\"),C14/B14,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(E14),$C$60=\"Yes\"),E14/D14,\"\")","v":""},null,"","",null,"M. berryllina (inland silverside)"]
[3,null,null,null,null,"","",null,"","",null,"M. menidia (atlantic silverside)"]
[4,null,null,null,null,"","",null,"","",null,"M. peninsulae (tidewater silverside)",null,null,null,null,null,"Statistic","Control","IWC"]
[5,null,null,null,null,"","",null,"","",null,"M. pyrifera (giant kelp)",null,null,null,null,null,{"$f":"IF(AND($C$60=\"No\",ISNUMBER(C13)), \"Mean of Raw Data\",IF(AND($C$60=\"Yes\",ISNUMBER(C13)),\"Percent Mean of Raw Data\",\"\"))","v":""},{"$f":"IF(AND($C$60=\"No\",ISNUMBER(C13)), AVERAGE(C13:C52),IF(AND($C$60=\"Yes\",ISNUMBER(C13)),AVERAGE(C13:C52)/AVERAGE(B13:B52),\"\"))","v":""},{"$f":"IF(AND($C$60=\"No\",ISNUMBER(E13)), AVERAGE(E13:E52),IF(AND($C$60=\"Yes\",ISNUMBER(E13)),AVERAGE(E13:E52)/AVERAGE(D13:D52),\"\"))","v":""}]
[6,null,null,null,null,"","",null,"","",null,"Mytilus sp. (mussel)",null,null,null,null,null,{"$f":"IF(AND($C$60=\"No\",ISNUMBER(C13)), \"Mean used in Calculation (non-transformed)\",IF(AND($C$60=\"Yes\",ISNUMBER(C13)),\"Mean used in Calcuation (transformed)\",\"\"))","v":""},{"$f":"IF(C60=\"NO\",AVERAGE(C13:C52), IF(C60=\"YES\",AVERAGE(I13:I52),\"\"))","v":""},{"$f":"IF(C60=\"NO\",AVERAGE(E13:E52), IF(C60=\"YES\",AVERAGE(J13:J52),\"\"))","v":""}]
[7,null,null,null,null,"","",null,"","",null,"O. mykiss (rainbow trout)",null,null,null,null,null,{"$f":"IF(AND($C$60=\"No\",ISNUMBER(C13)), \"Variance used in Calculation (non-transformed)\",IF(AND($C$60=\"Yes\",ISNUMBER(C13)),\"Variance used in Calcuation (transformed)\",\"\"))","v":""},{"$f":"IF(C60=\"NO\",VAR(C13:C52),IF(C60=\"YES\",VAR(I13:I52),\"\"))","v":""},{"$f":"IF(C60=\"NO\",VAR(E13:E52),IF(C60=\"YES\",VAR(J13:J52),\"\"))","v":""}]
[8,null,null,null,null,"","",null,"","",null,"P. promelas (fathead minnow)",null,null,null,null,null,{"$f":"IF(AND($C$60=\"No\",ISNUMBER(C13)), \"Standard Deviation of Raw Data\",IF(AND($C$60=\"Yes\",ISNUMBER(C13)),\"Standard Deviation of Transformed Data\",\"\"))","v":""},{"$f":"IF(ISNUMBER(S19),SQRT(S19),\"\")","v":""},{"$f":"IF(ISNUMBER(T19),SQRT(T19),\"\")","v":""}]
[9,null,null,null,null,"","",null,"","",null,"S. capricornutum (green algae)",null,null,null,null,null,{"$f":"IF(AND($C$60=\"No\",ISNUMBER(C13)), \"CV of Raw Data\",IF(AND($C$60=\"Yes\",ISNUMBER(C13)),\"CV of Transformed Data\",\"\"))","v":""},{"$f":"IF(ISNUMBER(S18),S20/S18,\"\")","v":""},{"$f":"IF(ISNUMBER(T18),T20/T18,\"\")","v":""}]
[10,null,null,null,null,"","",null,"","",null,"S. fontinalis (brook trout)",null,null,null,null,null,{"$f":"IF(ISNUMBER(S22),\"n\",\"\")","v":""},{"$f":"IF($C$60=\"NO\",COUNT(C13:C52),IF($C$60=\"YES\",COUNT(I13:I52),\"\"))","v":""},{"$f":"IF($C$60=\"NO\",COUNT(E13:E52),IF($C$60=\"YES\",COUNT(J13:J52),\"\"))","v":""}]
[11,null,null,null,null,"","",null,"","",null,"S. purpuratus (echinoderm)"]
[12,null,null,null,null,"","",null,"","",null,"T. gratilla (echinoderm)",null,null,null,null,null,"Mean % Effect at IWC",{"$f":"IF(AND(ISNUMBER(S17),ISNUMBER(T17)),((S17-T17)/S17)*100,\"\")","v":""}]
[13,null,null,null,null,"","",null,"",""]
[14,null,null,null,null,"","",null,{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(F26),F26=0),ASIN(SQRT(1/(4*B26))),IF(AND($C$60=\"Yes\",ISNUMBER(F26),F26=1),ASIN(SQRT(1-(1/(4*B26)))),IF(AND($C$60=\"Yes\",ISNUMBER(F26)),ASIN(SQRT(F26)),\"\")))","v":""},{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(G26),G26=0),ASIN(SQRT(1/(4*D26))),IF(AND($C$60=\"Yes\",ISNUMBER(G26),G26=1),ASIN(SQRT(1-(1/(4*D26)))),IF(AND($C$60=\"Yes\",ISNUMBER(G26)),ASIN(SQRT(G26)),\"\")))","v":""},null,null,null,null,null,null,null,"Calculated t-value=",{"$f":"IF(OR(ISTEXT(C62),ISTEXT(C64),C58=\"Click to choose from menu\"),\"\",(T18-(C62*S18))/SQRT((T19/T22)+(((C62^2)*S19)/S22)))","v":""}]
[15,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,"Degrees of Freedom (ν)=",{"$f":"IF(OR(ISTEXT(C62),ISTEXT(C64),C58=\"Click to choose from menu\"),\"\",INT(((((T19/T22)+((((C62)^2)*S19)/S22))^2))/((((T19/T22)^2)/(T22-1))+((((((C62^2)*S19)/S22)^2)/(S22-1))))))","v":""}]
[16,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,"Critical t-value=",{"$f":"IF(OR(ISTEXT(C62),ISTEXT(C64),C58=\"Click to choose from menu\"),\"\",TINV((2*C64),S27))","v":""}]
[17,null,null,null,null,"","",null,"",""]
[18,null,null,null,null,"","",null,"",""]
[19,null,null,null,null,"","",null,"",""]
[20,null,null,null,null,{"$f":"IF(AND(ISNUMBER(C32),$C$60=\"Yes\"),C32/B32,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(E32),$C$60=\"Yes\"),E32/D32,\"\")","v":""},null,"",""]
[21,null,null,null,null,"","",null,"",""]
[22,null,null,null,null,"","",null,"",""]
[23,null,null,null,null,"","",null,"",""]
[24,null,null,null,null,"","",null,"",""]
[25,null,null,null,null,"","",null,"",""]
[26,null,null,null,null,"","",null,{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(F38),F38=0),ASIN(SQRT(1/(4*B38))),IF(AND($C$60=\"Yes\",ISNUMBER(F38),F38=1),ASIN(SQRT(1-(1/(4*B38)))),IF(AND($C$60=\"Yes\",ISNUMBER(F38)),ASIN(SQRT(F38)),\"\")))","v":""},""]
[27,null,null,null,null,"","",null,"",""]
[28,null,null,null,null,"","",null,"",""]
[29,null,null,null,null,"","",null,"",{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(G41),G41=0),ASIN(SQRT(1/(4*D41))),IF(AND($C$60=\"Yes\",ISNUMBER(G41),G41=1),ASIN(SQRT(1-(1/(4*D41)))),IF(AND($C$60=\"Yes\",ISNUMBER(G41)),ASIN(SQRT(G41)),\"\")))","v":""}]
[30,null,null,null,null,"","",null,"",""]
[31,null,null,null,null,"","",null,"",""]
[32,null,null,null,null,"","",null,{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(F44),F44=0),ASIN(SQRT(1/(4*B44))),IF(AND($C$60=\"Yes\",ISNUMBER(F44),F44=1),ASIN(SQRT(1-(1/(4*B44)))),IF(AND($C$60=\"Yes\",ISNUMBER(F44)),ASIN(SQRT(F44)),\"\")))","v":""},""]
[33,null,null,null,null,"","",null,"",""]
[34,null,null,null,null,"","",null,"",""]
[35,null,null,null,null,"","",null,"",""]
[36,null,null,null,null,"","",null,"",""]
[37,null,null,null,null,"","",null,"",""]
[38,null,null,null,null,"","",null,"",""]
[39,null,null,null,null,"","",null,{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(F51),F51=0),ASIN(SQRT(1/(4*B51))),IF(AND($C$60=\"Yes\",ISNUMBER(F51),F51=1),ASIN(SQRT(1-(1/(4*B51)))),IF(AND($C$60=\"Yes\",ISNUMBER(F51)),ASIN(SQRT(F51)),\"\")))","v":""},{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(G51),G51=0),ASIN(SQRT(1/(4*D51))),IF(AND($C$60=\"Yes\",ISNUMBER(G51),G51=1),ASIN(SQRT(1-(1/(4*D51)))),IF(AND($C$60=\"Yes\",ISNUMBER(G51)),ASIN(SQRT(G51)),\"\")))","v":""}]
[40,null,null,null,null,{"$f":"IF(AND(ISNUMBER(C52),$C$60=\"Yes\"),C52/B52,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(E52),$C$60=\"Yes\"),E52/D52,\"\")","v":""},null,{"$f":"IF(AND($C$60=\"Yes\",ISNUMBER(F52),F52=0),ASIN(SQRT(1/(4*B52))),IF(AND($C$60=\"Yes\",ISNUMBER(F52),F52=1),ASIN(SQRT(1-(1/(4*B52)))),IF(AND($C$60=\"Yes\",ISNUMBER(F52)),ASIN(SQRT(F52)),\"\")))","v":""},""]
[]
[null,"Test Species?","Click to choose from menu"]
[]
[null,"Chronic or Acute?","Click to choose from menu"]
[null,null,{"$f":"IF(AND(C54=\"C. dubia (water flea)\",C56=\"Chronic\",C58=\"Survival\"),\"Note: The chronic survival analysis is NOT available for C. dubia\",\"\")","v":""}]
[null,"Endpoint?","Click to choose from menu"]
[]
[null,"Percent Data?",{"$f":"IF(OR(C58=\"Reproduction\",C58=\"Growth\",C58=\"Germ-Tube Length\"),\"No\",IF(OR(C58=\"Survival\",C58=\"Fertilization\",C58=\"Germination\",C58=\"Larval Development\"),\"Yes\",\"\"))","v":""}]
[]
[null,"b=",{"$f":"IF(AND(C54=\"C. dubia (water flea)\",C56=\"Chronic\",C58=\"Survival\"),\"\",IF(C56=\"Chronic\", 0.75, IF(C56=\"Acute\", 0.8,\"\")))","v":""}]
[]
[null,"α=",{"$f":"IF(AND(C56=\"Chronic\",C54=\"C. dubia (water flea)\"),0.2,IF(AND(C56=\"Chronic\",OR(C54=\"P. promelas (fathead minnow)\",C54=\"S. capricornutum (green algae)\",C54=\"C. variegatus (sheepshead minnow)\",C54=\"M. berryllina (inland silverside)\",C54=\"A. affinis (topsmelt)\")),0.25,IF(AND(C56=\"Chronic\",OR(C54=\"A. bahia (mysid shrimp)\",C54=\"H. costata (mysid)\")),0.15,IF(AND(C56=\"Chronic\",OR(C54=\"A. punctulata (echinoderm)\",C54=\"D. excentricus (echinoderm)\",C54=\"S. purpuratus (echinoderm)\",C54=\"H. rufescens (red abalone)\",C54=\"M. pyrifera (giant kelp)\", C54=\"C. gigas (oyster)\", C54=\"Mytilus sp. (mussel)\",C54=\"T. gratilla (echinoderm)\")),0.05,IF(C56=\"Acute\",0.1,\"\")))))","v":""}]

{"sheet":"TST Summary Sheet","index":4,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lab Name",{"$f":"IF(Calculator!B4=\"\",\"\",Calculator!B4)","v":""},null,null,"Client Name",null,{"$f":"IF(Calculator!B5=\"\",\"\",Calculator!B5)","v":""}]
[]
["Test ID",{"$f":"IF(Calculator!B6=\"\",\"\",Calculator!B6)","v":""},null,null,"Test Species",null,{"$f":"IF(Calculator!C54=\"Click to Choose from Menu\",\"\",Calculator!C54)","v":""}]
[]
["Test Date",{"$f":"IF(Calculator!B7=\"\",\"\",Calculator!B7)","v":""},null,null,"Test Type",null,{"$f":"IF(Calculator!C56=\"Click to Choose from Menu\",\"\",Calculator!C56)","v":""}]
[]
["Duration",{"$f":"IF(Calculator!B8=\"\",\"\",Calculator!B8)","v":""},null,null,"Endpoint",null,{"$f":"IF(Calculator!C58=\"Click to Choose from Menu\",\"\",Calculator!C58)","v":""}]
[]
["IWC",{"$f":"IF(Calculator!B9=\"\",\"\",Calculator!B9)","v":""}]
[]
[]
["Statistic",null,null,null,"Control",null,"Instream Waste Concentration (IWC)"]
[{"$f":"IF(Calculator!R17=\"\",\"\",Calculator!R17)","v":""},null,null,null,{"$f":"IF(Calculator!S17=\"\",\"\",Calculator!S17)","v":""},null,{"$f":"IF(Calculator!T17=\"\",\"\",Calculator!T17)","v":""}]
[{"$f":"IF(Calculator!R18=\"\",\"\",Calculator!R18)","v":""},null,null,null,{"$f":"IF(Calculator!S18=\"\",\"\",Calculator!S18)","v":""},null,{"$f":"IF(Calculator!T18=\"\",\"\",Calculator!T18)","v":""}]
[{"$f":"IF(Calculator!R19=\"\",\"\",Calculator!R19)","v":""},null,null,null,{"$f":"IF(Calculator!S19=\"\",\"\",Calculator!S19)","v":""},null,{"$f":"IF(Calculator!T19=\"\",\"\",Calculator!T19)","v":""}]
[{"$f":"IF(Calculator!R20=\"\",\"\",Calculator!R20)","v":""},null,null,null,{"$f":"IF(Calculator!S20=\"\",\"\",Calculator!S20)","v":""},null,{"$f":"IF(Calculator!T20=\"\",\"\",Calculator!T20)","v":""}]
[{"$f":"IF(Calculator!R21=\"\",\"\",Calculator!R21)","v":""},null,null,null,{"$f":"IF(Calculator!S21=\"\",\"\",Calculator!S21)","v":""},null,{"$f":"IF(Calculator!T21=\"\",\"\",Calculator!T21)","v":""}]
[{"$f":"IF(Calculator!R22=\"\",\"\",Calculator!R22)","v":""},null,null,null,{"$f":"IF(Calculator!S22=\"\",\"\",Calculator!S22)","v":""},null,{"$f":"IF(Calculator!T22=\"\",\"\",Calculator!T22)","v":""}]
[]
[]
["Mean Percent Effect at the IWC"]
[{"$f":"IF(Calculator!S24=\"\",\"\",Calculator!S24)","v":""}]
[]
["Calculated t-value",null,"Degrees of Freedom",null,"Critical t-value",null,"Percent Effect (if no variance)"]
[{"$f":"IF(ISNUMBER(Calculator!S26),Calculator!S26,\"\")","v":""},null,{"$f":"IF(ISNUMBER(Calculator!S27),Calculator!S27,\"\")","v":""},null,{"$f":"IF(ISNUMBER(Calculator!S28),Calculator!S28,\"\")","v":""},null,{"$f":"IF(Calculator!V12=\"\",\"\",Calculator!V12)","v":""}]
[]
["Results"]
[{"$f":"IF(A25<E25,\"Fail\",IF(A25>E25,\"Pass\",IF(AND(G5=\"Acute\",G25>=20),\"Fail\",IF(AND(G5=\"Acute\",G25<20),\"Pass\",IF(AND(G5=\"Chronic\",G25>=25),\"Fail\",IF(AND(G5=\"Chronic\",G25<25),\"Pass\",\"\"))))))","v":""},null,{"$f":"IF(D28=\"\",\"\",\"Sample is \")","v":""},{"$f":"IF(A25<E25,\"Toxic\",IF(A25>E25,\"Non-toxic\",IF(AND(G5=\"Acute\",G25>=20),\"Toxic\",IF(AND(G5=\"Acute\",G25<20),\"Non-toxic\",IF(AND(G5=\"Chronic\",G25>=25),\"Toxic\",IF(AND(G5=\"Chronic\",G25<25),\"Non-toxic\",\"\"))))))","v":""}]
[]
["Raw Data"]
[]
["Control Data",null,null,null,null,"Instream Waste Concentration Data"]
["Number of Organisms Exposed or Counted","Response (Final Count, Weight, Length, etc.)","Number of Organisms Exposed or Counted","Response (Final Count, Weight, Length, etc.)",null,"Number of Organisms Exposed or Counted","Response (Final Count, Weight, Length, etc.)","Number of Organisms Exposed or Counted","Response (Final Count, Weight, Length, etc.)"]
[]
[{"$f":"IF(Calculator!B13=\"\",\"\",Calculator!B13)","v":""},{"$f":"IF(Calculator!C13=\"\",\"\",Calculator!C13)","v":""},{"$f":"IF(Calculator!B33=\"\",\"\",Calculator!B33)","v":""},{"$f":"IF(Calculator!C33=\"\",\"\",Calculator!C33)","v":""},null,{"$f":"IF(Calculator!D13=\"\",\"\",Calculator!D13)","v":""},{"$f":"IF(Calculator!E13=\"\",\"\",Calculator!E13)","v":""},{"$f":"IF(Calculator!D33=\"\",\"\",Calculator!D33)","v":""},{"$f":"IF(Calculator!E33=\"\",\"\",Calculator!E33)","v":""}]
[{"$f":"IF(Calculator!B14=\"\",\"\",Calculator!B14)","v":""},{"$f":"IF(Calculator!C14=\"\",\"\",Calculator!C14)","v":""},{"$f":"IF(Calculator!B34=\"\",\"\",Calculator!B34)","v":""},{"$f":"IF(Calculator!C34=\"\",\"\",Calculator!C34)","v":""},null,{"$f":"IF(Calculator!D14=\"\",\"\",Calculator!D14)","v":""},{"$f":"IF(Calculator!E14=\"\",\"\",Calculator!E14)","v":""},{"$f":"IF(Calculator!D34=\"\",\"\",Calculator!D34)","v":""},{"$f":"IF(Calculator!E34=\"\",\"\",Calculator!E34)","v":""}]
[{"$f":"IF(Calculator!B15=\"\",\"\",Calculator!B15)","v":""},{"$f":"IF(Calculator!C15=\"\",\"\",Calculator!C15)","v":""},{"$f":"IF(Calculator!B35=\"\",\"\",Calculator!B35)","v":""},{"$f":"IF(Calculator!C35=\"\",\"\",Calculator!C35)","v":""},null,{"$f":"IF(Calculator!D15=\"\",\"\",Calculator!D15)","v":""},{"$f":"IF(Calculator!E15=\"\",\"\",Calculator!E15)","v":""},{"$f":"IF(Calculator!D35=\"\",\"\",Calculator!D35)","v":""},{"$f":"IF(Calculator!E35=\"\",\"\",Calculator!E35)","v":""}]
[{"$f":"IF(Calculator!B16=\"\",\"\",Calculator!B16)","v":""},{"$f":"IF(Calculator!C16=\"\",\"\",Calculator!C16)","v":""},{"$f":"IF(Calculator!B36=\"\",\"\",Calculator!B36)","v":""},{"$f":"IF(Calculator!C36=\"\",\"\",Calculator!C36)","v":""},null,{"$f":"IF(Calculator!D16=\"\",\"\",Calculator!D16)","v":""},{"$f":"IF(Calculator!E16=\"\",\"\",Calculator!E16)","v":""},{"$f":"IF(Calculator!D36=\"\",\"\",Calculator!D36)","v":""},{"$f":"IF(Calculator!E36=\"\",\"\",Calculator!E36)","v":""}]
[{"$f":"IF(Calculator!B17=\"\",\"\",Calculator!B17)","v":""},{"$f":"IF(Calculator!C17=\"\",\"\",Calculator!C17)","v":""},{"$f":"IF(Calculator!B37=\"\",\"\",Calculator!B37)","v":""},{"$f":"IF(Calculator!C37=\"\",\"\",Calculator!C37)","v":""},null,{"$f":"IF(Calculator!D17=\"\",\"\",Calculator!D17)","v":""},{"$f":"IF(Calculator!E17=\"\",\"\",Calculator!E17)","v":""},{"$f":"IF(Calculator!D37=\"\",\"\",Calculator!D37)","v":""},{"$f":"IF(Calculator!E37=\"\",\"\",Calculator!E37)","v":""}]
[{"$f":"IF(Calculator!B18=\"\",\"\",Calculator!B18)","v":""},{"$f":"IF(Calculator!C18=\"\",\"\",Calculator!C18)","v":""},{"$f":"IF(Calculator!B38=\"\",\"\",Calculator!B38)","v":""},{"$f":"IF(Calculator!C38=\"\",\"\",Calculator!C38)","v":""},null,{"$f":"IF(Calculator!D18=\"\",\"\",Calculator!D18)","v":""},{"$f":"IF(Calculator!E18=\"\",\"\",Calculator!E18)","v":""},{"$f":"IF(Calculator!D38=\"\",\"\",Calculator!D38)","v":""},{"$f":"IF(Calculator!E38=\"\",\"\",Calculator!E38)","v":""}]
[{"$f":"IF(Calculator!B19=\"\",\"\",Calculator!B19)","v":""},{"$f":"IF(Calculator!C19=\"\",\"\",Calculator!C19)","v":""},{"$f":"IF(Calculator!B39=\"\",\"\",Calculator!B39)","v":""},{"$f":"IF(Calculator!C39=\"\",\"\",Calculator!C39)","v":""},null,{"$f":"IF(Calculator!D19=\"\",\"\",Calculator!D19)","v":""},{"$f":"IF(Calculator!E19=\"\",\"\",Calculator!E19)","v":""},{"$f":"IF(Calculator!D39=\"\",\"\",Calculator!D39)","v":""},{"$f":"IF(Calculator!E39=\"\",\"\",Calculator!E39)","v":""}]
[{"$f":"IF(Calculator!B20=\"\",\"\",Calculator!B20)","v":""},{"$f":"IF(Calculator!C20=\"\",\"\",Calculator!C20)","v":""},{"$f":"IF(Calculator!B40=\"\",\"\",Calculator!B40)","v":""},{"$f":"IF(Calculator!C40=\"\",\"\",Calculator!C40)","v":""},null,{"$f":"IF(Calculator!D20=\"\",\"\",Calculator!D20)","v":""},{"$f":"IF(Calculator!E20=\"\",\"\",Calculator!E20)","v":""},{"$f":"IF(Calculator!D40=\"\",\"\",Calculator!D40)","v":""},{"$f":"IF(Calculator!E40=\"\",\"\",Calculator!E40)","v":""}]
[{"$f":"IF(Calculator!B21=\"\",\"\",Calculator!B21)","v":""},{"$f":"IF(Calculator!C21=\"\",\"\",Calculator!C21)","v":""},{"$f":"IF(Calculator!B41=\"\",\"\",Calculator!B41)","v":""},{"$f":"IF(Calculator!C41=\"\",\"\",Calculator!C41)","v":""},null,{"$f":"IF(Calculator!D21=\"\",\"\",Calculator!D21)","v":""},{"$f":"IF(Calculator!E21=\"\",\"\",Calculator!E21)","v":""},{"$f":"IF(Calculator!D41=\"\",\"\",Calculator!D41)","v":""},{"$f":"IF(Calculator!E41=\"\",\"\",Calculator!E41)","v":""}]
[{"$f":"IF(Calculator!B22=\"\",\"\",Calculator!B22)","v":""},{"$f":"IF(Calculator!C22=\"\",\"\",Calculator!C22)","v":""},{"$f":"IF(Calculator!B42=\"\",\"\",Calculator!B42)","v":""},{"$f":"IF(Calculator!C42=\"\",\"\",Calculator!C42)","v":""},null,{"$f":"IF(Calculator!D22=\"\",\"\",Calculator!D22)","v":""},{"$f":"IF(Calculator!E22=\"\",\"\",Calculator!E22)","v":""},{"$f":"IF(Calculator!D42=\"\",\"\",Calculator!D42)","v":""},{"$f":"IF(Calculator!E42=\"\",\"\",Calculator!E42)","v":""}]
[{"$f":"IF(Calculator!B23=\"\",\"\",Calculator!B23)","v":""},{"$f":"IF(Calculator!C23=\"\",\"\",Calculator!C23)","v":""},{"$f":"IF(Calculator!B43=\"\",\"\",Calculator!B43)","v":""},{"$f":"IF(Calculator!C43=\"\",\"\",Calculator!C43)","v":""},null,{"$f":"IF(Calculator!D23=\"\",\"\",Calculator!D23)","v":""},{"$f":"IF(Calculator!E23=\"\",\"\",Calculator!E23)","v":""},{"$f":"IF(Calculator!D43=\"\",\"\",Calculator!D43)","v":""},{"$f":"IF(Calculator!E43=\"\",\"\",Calculator!E43)","v":""}]
[{"$f":"IF(Calculator!B24=\"\",\"\",Calculator!B24)","v":""},{"$f":"IF(Calculator!C24=\"\",\"\",Calculator!C24)","v":""},{"$f":"IF(Calculator!B44=\"\",\"\",Calculator!B44)","v":""},{"$f":"IF(Calculator!C44=\"\",\"\",Calculator!C44)","v":""},null,{"$f":"IF(Calculator!D24=\"\",\"\",Calculator!D24)","v":""},{"$f":"IF(Calculator!E24=\"\",\"\",Calculator!E24)","v":""},{"$f":"IF(Calculator!D44=\"\",\"\",Calculator!D44)","v":""},{"$f":"IF(Calculator!E44=\"\",\"\",Calculator!E44)","v":""}]
[{"$f":"IF(Calculator!B25=\"\",\"\",Calculator!B25)","v":""},{"$f":"IF(Calculator!C25=\"\",\"\",Calculator!C25)","v":""},{"$f":"IF(Calculator!B45=\"\",\"\",Calculator!B45)","v":""},{"$f":"IF(Calculator!C45=\"\",\"\",Calculator!C45)","v":""},null,{"$f":"IF(Calculator!D25=\"\",\"\",Calculator!D25)","v":""},{"$f":"IF(Calculator!E25=\"\",\"\",Calculator!E25)","v":""},{"$f":"IF(Calculator!D45=\"\",\"\",Calculator!D45)","v":""},{"$f":"IF(Calculator!E45=\"\",\"\",Calculator!E45)","v":""}]
[{"$f":"IF(Calculator!B26=\"\",\"\",Calculator!B26)","v":""},{"$f":"IF(Calculator!C26=\"\",\"\",Calculator!C26)","v":""},{"$f":"IF(Calculator!B46=\"\",\"\",Calculator!B46)","v":""},{"$f":"IF(Calculator!C46=\"\",\"\",Calculator!C46)","v":""},null,{"$f":"IF(Calculator!D26=\"\",\"\",Calculator!D26)","v":""},{"$f":"IF(Calculator!E26=\"\",\"\",Calculator!E26)","v":""},{"$f":"IF(Calculator!D46=\"\",\"\",Calculator!D46)","v":""},{"$f":"IF(Calculator!E46=\"\",\"\",Calculator!E46)","v":""}]
[{"$f":"IF(Calculator!B27=\"\",\"\",Calculator!B27)","v":""},{"$f":"IF(Calculator!C27=\"\",\"\",Calculator!C27)","v":""},{"$f":"IF(Calculator!B47=\"\",\"\",Calculator!B47)","v":""},{"$f":"IF(Calculator!C47=\"\",\"\",Calculator!C47)","v":""},null,{"$f":"IF(Calculator!D27=\"\",\"\",Calculator!D27)","v":""},{"$f":"IF(Calculator!E27=\"\",\"\",Calculator!E27)","v":""},{"$f":"IF(Calculator!D47=\"\",\"\",Calculator!D47)","v":""},{"$f":"IF(Calculator!E47=\"\",\"\",Calculator!E47)","v":""}]
[{"$f":"IF(Calculator!B28=\"\",\"\",Calculator!B28)","v":""},{"$f":"IF(Calculator!C28=\"\",\"\",Calculator!C28)","v":""},{"$f":"IF(Calculator!B48=\"\",\"\",Calculator!B48)","v":""},{"$f":"IF(Calculator!C48=\"\",\"\",Calculator!C48)","v":""},null,{"$f":"IF(Calculator!D28=\"\",\"\",Calculator!D28)","v":""},{"$f":"IF(Calculator!E28=\"\",\"\",Calculator!E28)","v":""},{"$f":"IF(Calculator!D48=\"\",\"\",Calculator!D48)","v":""},{"$f":"IF(Calculator!E48=\"\",\"\",Calculator!E48)","v":""}]
[{"$f":"IF(Calculator!B29=\"\",\"\",Calculator!B29)","v":""},{"$f":"IF(Calculator!C29=\"\",\"\",Calculator!C29)","v":""},{"$f":"IF(Calculator!B49=\"\",\"\",Calculator!B49)","v":""},{"$f":"IF(Calculator!C49=\"\",\"\",Calculator!C49)","v":""},null,{"$f":"IF(Calculator!D29=\"\",\"\",Calculator!D29)","v":""},{"$f":"IF(Calculator!E29=\"\",\"\",Calculator!E29)","v":""},{"$f":"IF(Calculator!D49=\"\",\"\",Calculator!D49)","v":""},{"$f":"IF(Calculator!E49=\"\",\"\",Calculator!E49)","v":""}]
[{"$f":"IF(Calculator!B30=\"\",\"\",Calculator!B30)","v":""},{"$f":"IF(Calculator!C30=\"\",\"\",Calculator!C30)","v":""},{"$f":"IF(Calculator!B50=\"\",\"\",Calculator!B50)","v":""},{"$f":"IF(Calculator!C50=\"\",\"\",Calculator!C50)","v":""},null,{"$f":"IF(Calculator!D30=\"\",\"\",Calculator!D30)","v":""},{"$f":"IF(Calculator!E30=\"\",\"\",Calculator!E30)","v":""},{"$f":"IF(Calculator!D50=\"\",\"\",Calculator!D50)","v":""},{"$f":"IF(Calculator!E50=\"\",\"\",Calculator!E50)","v":""}]
[{"$f":"IF(Calculator!B31=\"\",\"\",Calculator!B31)","v":""},{"$f":"IF(Calculator!C31=\"\",\"\",Calculator!C31)","v":""},{"$f":"IF(Calculator!B51=\"\",\"\",Calculator!B51)","v":""},{"$f":"IF(Calculator!C51=\"\",\"\",Calculator!C51)","v":""},null,{"$f":"IF(Calculator!D31=\"\",\"\",Calculator!D31)","v":""},{"$f":"IF(Calculator!E31=\"\",\"\",Calculator!E31)","v":""},{"$f":"IF(Calculator!D51=\"\",\"\",Calculator!D51)","v":""},{"$f":"IF(Calculator!E51=\"\",\"\",Calculator!E51)","v":""}]
[{"$f":"IF(Calculator!B32=\"\",\"\",Calculator!B32)","v":""},{"$f":"IF(Calculator!C32=\"\",\"\",Calculator!C32)","v":""},{"$f":"IF(Calculator!B52=\"\",\"\",Calculator!B52)","v":""},{"$f":"IF(Calculator!C52=\"\",\"\",Calculator!C52)","v":""},null,{"$f":"IF(Calculator!D32=\"\",\"\",Calculator!D32)","v":""},{"$f":"IF(Calculator!E32=\"\",\"\",Calculator!E32)","v":""},{"$f":"IF(Calculator!D52=\"\",\"\",Calculator!D52)","v":""},{"$f":"IF(Calculator!E52=\"\",\"\",Calculator!E52)","v":""}]

{"sheet":"Statistics","index":5,"n_rows":1,"n_cols":15,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Lab Name","Client Name","Test ID","Test Date","Test Duration","IWC","Test Species","Chronic or Acute","Endpoint","Mean % Effect at IWC","Calculated t-value","Critical t-value","Percent Difference","Pass or Fail","Toxic or Non-toxic"]

{"sheet":"Formulas","index":6,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Statistics!A1","v":"Lab Name"},{"$f":"Statistics!B1","v":"Client Name"},{"$f":"Statistics!C1","v":"Test ID"},{"$f":"Statistics!D1","v":"Test Date"},{"$f":"Statistics!E1","v":"Test Duration"},"Critical Conc.",{"$f":"Statistics!G1","v":"Test Species"},{"$f":"Statistics!H1","v":"Chronic or Acute"},{"$f":"Statistics!I1","v":"Endpoint"},"Mean % Effect at Critical Conc.",{"$f":"Statistics!K1","v":"Calculated t-value"},{"$f":"Statistics!L1","v":"Critical t-value"},{"$f":"Statistics!M1","v":"Percent Difference"},{"$f":"Statistics!N1","v":"Pass or Fail"},{"$f":"Statistics!O1","v":"Toxic or Non-toxic"}]
[{"$f":"IF(Calculator!B4=\"\",\"\",Calculator!B4)","v":""},{"$f":"IF(Calculator!B5=\"\",\"\",Calculator!B5)","v":""},{"$f":"IF(Calculator!B6=\"\",\"\",Calculator!B6)","v":""},{"$f":"IF(Calculator!B7=\"\",\"\",Calculator!B7)","v":""},{"$f":"IF(Calculator!B8=\"\",\"\",Calculator!B8)","v":""},{"$f":"IF(Calculator!B9=\"\",\"\",Calculator!B9)","v":""},{"$f":"IF(Calculator!C54=\"Click to Choose from Menu\",\"\",Calculator!C54)","v":""},{"$f":"IF(Calculator!C56=\"Click to Choose from Menu\",\"\",Calculator!C56)","v":""},{"$f":"IF(Calculator!C58=\"Click to Choose from menu\",\"\",Calculator!C58)","v":""},{"$f":"IF(ISNUMBER(Calculator!S24),Calculator!S24,\"\")","v":""},{"$f":"IF(ISNUMBER(Calculator!S26),Calculator!S26,\"\")","v":""},{"$f":"IF(ISNUMBER(Calculator!S28),Calculator!S28,\"\")","v":""},{"$f":"IF(AND(Calculator!S19=0,Calculator!T19=0),((AVERAGE(Calculator!C13:C52)-AVERAGE(Calculator!E13:E52))/AVERAGE(Calculator!C13:C52))*100,\"\")","v":""},{"$f":"IF(K2<L2,\"Fail\",IF(K2>L2,\"Pass\",IF(AND(H2=\"Acute\",M2>=20),\"Fail\",IF(AND(H2=\"Acute\",M2<20),\"Pass\",IF(AND(H2=\"Chronic\",M2>=25),\"Fail\",IF(AND(H2=\"Chronic\",M2<25),\"Pass\",\"\"))))))","v":""},{"$f":"IF(K2<L2,\"Toxic\",IF(K2>L2,\"Non-toxic\",IF(AND(H2=\"Acute\",M2>=20),\"Toxic\",IF(AND(H2=\"Acute\",M2<20),\"Non-toxic\",IF(AND(H2=\"Chronic\",M2>=25),\"Toxic\",IF(AND(H2=\"Chronic\",M2<25),\"Non-toxic\",\"\"))))))","v":""}]
[]
[]
["Formulas on this page (in Row 1) are used to copy data from Calculator worksheet to the Statistics worksheet."]
["PasteSpecial-Values"]
["PasteSpecial-Formulas"]