{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["WELCOME","Acute"," Chronic","Parameters"],"not_rendered":{"charts":0,"images":102,"macros":1,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"WELCOME","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,2,9],[3,1,3,9],[4,1,4,9],[5,1,5,9],[15,1,15,9],[12,1,14,9],[9,1,11,6],[6,1,6,6]]}
[]
[null,"EPA Region 8 National Pollutant Discharge Elimination System (NPDES) Whole Effluent Toxicity (WET) Laboratory Reporting Tools"]
[]
[null,"These tools are designed as customizable templates to assist with NPDES WET laboratory test reporting.  "]
[]
[]
[null,"The acute and chronic versions (see tabs below) are to assist with reporting acute and/or chronic data.  "]
[]
[]
[null,"The parameters tab is used where drop-downs are included in the form. The form uses macros and is protected."]
[]
[]
[null,"The parameters tab is used where drop-downs are included in the form. The form uses macros and is protected."]
[]
[]
[null,"Suggested format is derived from recommended parameters listed in Section 12 of the acute and chronic manuals."]

{"sheet":"Acute","index":1,"n_rows":99,"n_cols":14,"rows_kept":99,"cut":false,"hidden":false,"merged":[[28,6,28,7],[29,6,29,7],[30,6,30,7],[27,2,27,5],[46,2,46,8],[49,2,49,9],[8,2,8,9],[30,12,30,13],[33,12,33,13],[34,12,34,13],[36,12,36,13],[38,12,38,13],[39,12,39,13],[40,12,40,13],[27,12,27,13],[17,10,17,13],[9,2,9,9],[10,2,10,9],[11,2,11,9],[15,10,15,13],[4,10,4,11],[50,2,50,8],[45,2,45,8],[47,2,47,8],[48,2,48,8],[23,2,23,7],[24,2,24,7],[25,2,25,7],[26,2,26,7],[28,2,28,5],[29,2,29,5],[30,2,30,5],[27,8,27,11],[28,8,28,11],[29,8,29,11],[30,8,30,11],[27,6,27,7],[12,2,12,9],[13,2,13,9],[14,2,14,9],[15,2,15,9],[16,2,16,9],[18,2,18,9],[17,2,17,9],[62,2,62,13],[52,2,52,13],[44,2,44,13],[69,2,69,6],[70,2,70,6],[72,2,72,6],[73,2,73,6],[34,2,34,8],[33,10,33,11],[34,10,34,11],[41,10,42,13],[43,2,43,7],[43,8,43,13],[35,2,35,8],[36,2,36,8],[37,2,37,8],[38,2,38,8],[39,2,39,8],[40,2,40,8],[41,2,41,8],[36,10,36,11],[38,10,38,11],[53,12,53,13],[54,12,54,13],[59,12,59,13],[53,8,53,9],[54,8,54,9],[54,2,55,7],[53,2,53,7],[53,10,53,11],[54,10,54,11],[3,2,3,9],[3,10,3,11],[5,2,5,13],[56,2,57,7],[58,2,59,7],[59,10,59,11],[32,2,32,13],[20,2,20,13],[8,10,8,11],[8,12,8,13],[12,10,12,13],[22,2,22,5],[33,2,33,8],[39,10,39,11],[40,10,40,11],[28,12,28,13],[29,12,29,13],[94,2,94,13],[91,2,91,13],[85,2,85,13],[68,2,68,13],[71,2,71,13],[74,2,74,13],[77,2,77,13],[80,2,80,13],[75,2,75,6],[76,2,76,6],[78,2,78,6],[79,2,79,6],[81,2,81,6],[82,2,82,6],[92,11,92,13],[87,2,87,7],[93,11,93,13],[88,2,88,7],[63,2,63,6],[64,2,64,6],[65,2,65,6],[66,2,66,6],[67,2,67,6],[61,2,61,13],[97,2,97,13],[98,2,98,13],[83,2,83,13],[84,2,84,13],[86,2,86,13],[95,2,95,13],[96,4,96,7],[96,2,96,3],[96,8,96,9],[96,10,96,13],[90,2,90,13],[89,2,89,13],[93,2,93,4],[92,2,92,4],[92,5,92,7],[93,5,93,7],[92,8,92,10],[93,8,93,10],[6,2,6,9],[7,2,7,9],[6,10,6,13],[7,10,7,13],[22,12,22,13],[21,12,21,13],[21,6,21,7],[21,2,21,5],[21,8,21,11],[22,6,22,7],[22,8,22,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,"LABORATORY RESULTS (to be filled out by laboratory)"]
[null,null," ACUTE TOXICITY TEST REPORT FORMAT",null,null,null,null,null,null,null," LC50 @ 100%"]
[null,null,null,null,null,null,null,null,null,null,"Final LC50 /EC50:              (circle one)"]
[null,null,"I.   FACILITY INFORMATION & REQUIREMENTS (this section to be filled out by NPDES permit holder, i.e. Permittee)"]
[null,null,"PERMITTEE NAME",null,null,null,null,null,null,null,"NPDES PERMIT #"]
[null,null,"  "]
[null,null,"SPECIES SPECIFIED IN PERMIT? (one data sheet for each species) "]
[null,null,"TEST TYPE(S) SPECIFIED IN PERMIT? "]
[null,null,"LENGTH OF TEST SPECIFIED IN PERMIT? "]
[null,null,"ARE MORE FREQUENT RENEWALS REQUIRED? "]
[null,null,"     - IF YES, WHAT RENEWALS ARE SPECIFIED?"]
[null,null,"TEST TEMPERATURE SPECIFIED?"]
[null,null,"IS DILUTION WATER SPECIFIED IN THE PERMIT?  "]
[null,null,"     - IF YES, WHAT TYPE OF WATER IS SPECIFIED AND HARDNESS?"]
[null,null,"IS A DILUTION SERIES SPECIFIED? "]
[null,null,"     - IF YES, LIST SERIAL DILUTIONS ARE REQUIRED (e.g. 25%, 50%, 75%, etc.)? "]
[null,null,"SAMPLE TYPE SPECFIED IN PERMIT? "]
[]
[null,null,"II.    LABORATORY SAMPLE INFORMATION UPON ARRIVAL & TEST INFORMATION (to be filled out by laboratory)"]
[null,null,"SAMPLE COLLECTION DATE ",null,null,null,null,null,"SAMPLE COLLECTION TIME"]
[null,null,"TEST DATE ",null,null,null,null,null,"START & END TIMES"]
[null,null,"TEST DURATION PERFORMED?"]
[null,null,"TEST TYPE PERFORMED?"]
[null,null,"SAMPLE RECEIVED? "]
[null,null,"OUTFALL NUMBER OR LOCATION?"]
[null,null,"TEMPERATURE °C",null,null,null,null,null,"HARDNESS  mg/L CaCO3"]
[null,null,"CONDUCTIVITY  ",null,null,null,null,null,"AMMONIA mg/l as N"]
[null,null,"TOTAL RESIDUAL Cl mg/l",null,null,null,null,null,"OTHER "]
[null,null,"D.O. ",null,null,null,null,null,"OTHER "]
[]
[null,null,"III.  LABORATORY ALTERATIONS PRIOR TO TEST (to be filled out by laboratory)"]
[null,null,"WAS SAMPLE DECHLORINATED?"]
[null,null,"IS DECHLORINATION AUTHORIZED IN PERMIT?"]
[null,null,"DESCRIBE DECHLORINATION (if any)"]
[null,null,"WAS SAMPLE FILTERED?   "]
[null,null,"FILTER SIZE?              "]
[null,null,"WAS pH ADJUSTED?  "]
[null,null,"IS pH ADJUSTMENT AUTHORIZED IN PERMIT?"]
[null,null,"WAS RECEIVED SAMPLE AERATED?"]
[null,null,"OTHER ADJUSTMENTS? (if any, describe)"]
[]
[]
[null,null,"IV.  TEST ORGANISM INFORMATION (to be filled out by laboratory)"]
[null,null,"TYPE AND AGE OF ORGANISMS?"]
[null,null,"CULTURED IN-HOUSE OR FROM EXTERNAL SUPPLIER?   "]
[null,null,"FROM INDIVIDUAL CULTURE OR MASS CULTURE?   "]
[null,null,"HAS MONTHLY REFTOX MET CONTROL CHART PARAMETERS?  "]
[null,null,"DATE AND TIME OF MOST RECENT REF TOX TEST AND TEST RESULT?"]
[null,null,"HAVE ORGANISMS PERFORMED SUCCESSFULLY IN THE MONTHLY REFTOX?"]
[]
[null,null,"V.    TEST SET-UP (to be filled out by laboratory)"]
[null,null,"IDENTIFY THE DILUENT (O1) CONTROL (receiving water recommended)",null,null,null,null,null,"DILUTIONS USED:",null,"EFFLUENT",null,"DILUENT"]
[null,null,null,null,null,null,null,null,"CONTROL",null,"- - -",null,"500 mL"]
[null,null,null,null,null,null,null,null,null,"%",null,"mL",null,"mL"]
[null,null,"(if used) IDENTIFY THE SECONDARY (O2) CONTROL (MHRW recommended unless receiving water characteristics differ)",null,null,null,null,null,null,"%",null,"mL",null,"mL"]
[null,null,null,null,null,null,null,null,null,"%",null,"mL",null,"mL"]
[null,null,null,null,null,null,null,null,null,"%",null,"mL",null,"mL"]
[null,null,null,null,null,null,null,null,1,null,"500 mL",null,"- - -"]
[]
[null,null,"VI.      TEST RESULTS (to be filled out by laboratory)"]
[null,null,"SURVIVAL MEASUREMENTS"]
[null,null,"DILUTIONS",null,null,null,null,"O1","O2 (if used)","--%","--%","--%","--%",1]
[null,null,"# AT START OF TEST?"]
[null,null,"# ALIVE AT 24 HOURS?"]
[null,null,"# ALIVE AT 48 HOURS?"]
[null,null,"PERCENT SURVIVAL"]
[null,null,"TEMPERATURE MEASUREMENTS "]
[null,null,"DILUTIONS",null,null,null,null,"O1","O2 (if used)","--%","--%","--%","--%",1]
[null,null,"MAX/MIN TEMPERATURE IN °C"]
[null,null,"D.O. MEASUREMENTS"]
[null,null,"DILUTIONS",null,null,null,null,"O1","O2 (if used)","--%","--%","--%","--%",1]
[null,null,"MAX/MIN D.O IN mg/L"]
[null,null,"pH MEASUREMENTS"]
[null,null,"DILUTIONS",null,null,null,null,"O1","O2 (if used)","--%","--%","--%","--%",1]
[null,null,"MAX/MIN pH IN s.u"]
[null,null,"CONDUCTIVITY MEASUREMENTS"]
[null,null,"DILUTIONS",null,null,null,null,"O1","O2 (if used)","--%","--%","--%","--%",1]
[null,null,"MAX/MIN IN mS/cm"]
[null,null,"CO2 MEASUREMENTS (if used)"]
[null,null,"DILUTIONS",null,null,null,null,"O1","O2 (if used)","--%","--%","--%","--%",1]
[null,null,"MAX/MIN AS CALCULATED"]
[null,null,"ORGANISM OBSERVATIONS: (e.g. health of the organisms, was prodding required to determine death, were organisms responding in an abnormal manner, etc.) "]
[]
[]
[null,null,"VII.       DATA ANALYSIS (to be filled out by laboratory)"]
[null,null,"METHOD USED TO CALCULATE DATA ENDPOINTS?"]
[null,null,"SOFTWARE USED TO PERFORM CALCULATIONS?"]
[null,null,"WERE ANY OUTLIERS REMOVED FROM CALCULATION?  (describe)"]
[]
[null,null,"FINAL DATA CALCULATIONS"]
[null,null,"48-HR LC50",null,null,null,null,null,"48-hr EC50"]
[null,null,"96-HR LC50",null,null,null,null,null,"96-hr EC50"]
[null,null,"DESCRIBE ANY DEVIATIONS FROM TEST METHODS OR APPROVED MODIFICATIONS ADMINISTERED (e.g. pH-overlay used and how administered, D.O. issues, aeration used-rate of bubbles per minute and duration, temperature issues, holding time issues, etc.)"]
[]
[null,null,"ANALYST(S)",null,null,null,null,null,"QA OFFICER"]
[null,null,"EPA Region 8 Acute Toxicity Test Report Format "]
[null,null,"EPA REGION 8 (Modified 7/2020)"]

{"sheet":" Chronic","index":2,"n_rows":122,"n_cols":14,"rows_kept":122,"cut":false,"hidden":false,"merged":[[100,2,100,6],[103,2,103,6],[99,2,99,13],[101,2,101,6],[107,2,107,13],[114,2,114,4],[114,8,114,10],[115,2,115,13],[117,2,117,13],[108,2,108,13],[102,2,102,13],[104,2,104,6],[105,2,105,13],[106,2,106,13],[118,2,118,13],[119,2,119,3],[119,4,119,7],[119,8,119,9],[119,10,119,13],[109,2,109,7],[113,2,113,13],[111,2,111,13],[112,2,112,13],[116,2,116,4],[116,5,116,7],[116,8,116,10],[116,11,116,13],[110,2,110,7],[64,8,64,9],[64,10,64,11],[64,12,64,13],[64,2,65,7],[66,2,67,7],[68,2,69,7],[69,10,69,11],[69,12,69,13],[70,2,70,13],[94,2,94,6],[97,2,97,6],[91,2,91,6],[90,2,90,13],[92,2,92,6],[93,2,93,13],[95,2,95,6],[96,2,96,13],[71,2,71,13],[80,2,80,13],[48,2,48,8],[48,10,48,11],[48,12,48,13],[55,2,55,13],[56,2,56,8],[57,2,57,8],[58,2,58,8],[59,2,59,8],[52,2,52,8],[52,10,52,11],[52,12,52,13],[53,2,53,8],[53,10,54,13],[35,8,35,11],[35,12,35,13],[36,2,36,5],[36,6,36,7],[36,8,36,11],[36,12,36,13],[41,2,41,5],[49,2,49,8],[50,2,50,8],[50,10,50,11],[50,12,50,13],[40,2,40,5],[40,6,40,7],[40,8,40,11],[40,12,40,13],[39,2,39,5],[39,6,39,7],[39,8,39,11],[39,12,39,13],[35,6,35,7],[46,2,46,8],[46,10,46,11],[46,12,46,13],[47,2,47,8],[27,2,27,7],[29,2,29,5],[29,6,29,7],[29,8,29,11],[29,12,29,13],[23,2,23,5],[23,6,23,7],[23,8,23,11],[23,12,23,13],[24,2,24,7],[25,2,25,7],[20,8,20,11],[20,12,20,13],[11,2,11,9],[11,10,11,13],[12,2,12,9],[13,2,13,9],[14,2,14,9],[14,10,14,13],[26,2,26,7],[16,2,16,9],[16,10,16,13],[17,2,17,9],[32,2,32,5],[3,2,3,9],[4,2,4,13],[5,2,5,9],[5,10,5,13],[6,2,6,9],[6,10,6,13],[22,2,22,5],[22,6,22,7],[22,8,22,11],[22,12,22,13],[21,2,21,5],[21,6,21,7],[21,8,21,11],[21,12,21,13],[7,10,7,11],[7,12,7,13],[8,2,8,9],[9,2,9,9],[10,2,10,9],[15,2,15,9],[19,2,19,13],[20,2,20,5],[20,6,20,7],[34,2,34,5],[34,6,34,7],[34,8,34,11],[34,12,34,13],[7,2,7,9],[28,2,28,13],[33,2,33,13],[38,2,38,13],[37,2,37,5],[37,6,37,7],[37,8,37,11],[37,12,37,13],[32,6,32,7],[32,8,32,11],[32,12,32,13],[30,2,30,5],[30,6,30,7],[30,8,30,11],[30,12,30,13],[31,2,31,5],[31,6,31,7],[31,8,31,11],[31,12,31,13],[35,2,35,5],[121,2,121,13],[120,2,120,13],[60,2,60,9],[61,2,61,8],[41,6,41,7],[41,8,41,11],[41,12,41,13],[42,2,42,5],[42,6,42,7],[42,8,42,11],[42,12,42,13],[62,2,62,13],[63,2,63,7],[63,8,63,9],[63,10,63,11],[63,12,63,13],[44,2,44,13],[45,2,45,8],[45,10,45,11],[45,12,45,13],[51,2,51,8],[51,10,51,11],[51,12,51,13],[98,2,98,6]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,"LABORATORY RESULTS (to be filled out by laboratory)"]
[null,null," CHRONIC TOXICITY TEST REPORT FORMAT",null,null,null,null,null,null,null,"IWC="]
[null,null,"I.   FACILITY INFORMATION & REQUIREMENTS (this section to be filled out by NPDES permit holder, i.e. Permittee)"]
[null,null,"PERMITTEE NAME",null,null,null,null,null,null,null,"NPDES PERMIT #"]
[null,null,"  "]
[null,null,"SPECIES SPECIFIED IN PERMIT? (one data sheet for each species) "]
[null,null,"TEST TYPE(S) SPECIFIED IN PERMIT? "]
[null,null,"LENGTH OF TEST SPECIFIED IN PERMIT? "]
[null,null,"ARE MORE FREQUENT RENEWALS REQUIRED? "]
[null,null,"     - IF YES, WHAT RENEWALS ARE SPECIFIED?"]
[null,null,"TEST TEMPERATURE SPECIFIED?"]
[null,null,"IS DILUTION WATER SPECIFIED IN THE PERMIT?  "]
[null,null,"     - IF YES, WHAT TYPE OF WATER IS SPECIFIED AND HARDNESS?"]
[null,null,"IS A DILUTION SERIES SPECIFIED? "]
[null,null,"     - IF YES, LIST SERIAL DILUTIONS ARE REQUIRED (e.g. 25%, 50%, 75%, etc.)? "]
[null,null,"SAMPLE TYPE SPECFIED IN PERMIT? "]
[]
[null,null,"II.    LABORATORY SAMPLE INFORMATION UPON ARRIVAL & TEST INFORMATION (to be filled out by laboratory)"]
[null,null,"SAMPLE 1 COLLECTION DATE ",null,null,null,null,null,"SAMPLE 1 COLLECTION TIME"]
[null,null,"SAMPLE 2 COLLECTION DATE ",null,null,null,null,null,"SAMPLE 2 COLLECTION TIME"]
[null,null,"SAMPLE 3 COLLECTION DATE ",null,null,null,null,null,"SAMPLE 3 COLLECTION TIME"]
[null,null,"TEST DATE INTIATION",null,null,null,null,null,"START & END TIMES"]
[null,null,"TEST DURATION PERFORMED?"]
[null,null,"TEST TYPE PERFORMED?"]
[null,null,"SAMPLE RECEIVED? "]
[null,null,"OUTFALL NUMBER OR LOCATION?"]
[null,null,"SAMPLE 1 "]
[null,null,"TEMPERATURE °C",null,null,null,null,null,"HARDNESS  mg/L CaCO3"]
[null,null,"CONDUCTIVITY  ",null,null,null,null,null,"AMMONIA mg/l as N"]
[null,null,"TOTAL RESIDUAL Cl mg/l",null,null,null,null,null,"OTHER "]
[null,null,"D.O. ",null,null,null,null,null,"OTHER "]
[null,null,"SAMPLE 2 "]
[null,null,"TEMPERATURE °C",null,null,null,null,null,"HARDNESS  mg/L CaCO3"]
[null,null,"CONDUCTIVITY  ",null,null,null,null,null,"AMMONIA mg/l as N"]
[null,null,"TOTAL RESIDUAL Cl mg/l",null,null,null,null,null,"OTHER "]
[null,null,"D.O. ",null,null,null,null,null,"OTHER "]
[null,null,"SAMPLE 3"]
[null,null,"TEMPERATURE °C",null,null,null,null,null,"HARDNESS  mg/L CaCO3"]
[null,null,"CONDUCTIVITY  ",null,null,null,null,null,"AMMONIA mg/l as N"]
[null,null,"TOTAL RESIDUAL Cl mg/l",null,null,null,null,null,"OTHER "]
[null,null,"D.O. ",null,null,null,null,null,"OTHER "]
[]
[null,null,"III.  LABORATORY ALTERATIONS PRIOR TO TEST (to be filled out by laboratory)"]
[null,null,"WERE ANY SAMPLES DECHLORINATED?"]
[null,null,"IS DECHLORINATION AUTHORIZED IN PERMIT?"]
[null,null,"DESCRIBE DECHLORINATION (if any)"]
[null,null,"WERE ANY SAMPLES FILTERED?   "]
[null,null,"FILTER SIZE?              "]
[null,null,"WAS pH ADJUSTED?  "]
[null,null,"IS pH ADJUSTMENT AUTHORIZED IN PERMIT?"]
[null,null,"WERE ANY SAMPLES AERATED?"]
[null,null,"OTHER ADJUSTMENTS? (if any, describe)"]
[]
[null,null,"IV.  TEST ORGANISM INFORMATION (to be filled out by laboratory)"]
[null,null,"TYPE AND AGE OF ORGANISMS?"]
[null,null,"CULTURED IN-HOUSE OR FROM EXTERNAL SUPPLIER?   "]
[null,null,"FROM INDIVIDUAL CULTURE OR MASS CULTURE?   "]
[null,null,"HAS MONTHLY REFTOX MET CONTROL CHART PARAMETERS?  "]
[null,null,"DATE AND TIME OF MOST RECENT REF TOX TEST AND TEST RESULT?"]
[null,null,"HAVE ORGANISMS PERFORMED SUCCESSFULLY IN THE MONTHLY REFTOX?"]
[null,null,"V.    TEST SET-UP (to be filled out by laboratory)"]
[null,null,"IDENTIFY THE DILUENT (O1) CONTROL (receiving water recommended)",null,null,null,null,null,"DILUTIONS USED:",null,"EFFLUENT",null,"DILUENT"]
[null,null,null,null,null,null,null,null,"CONTROL",null,"- - -",null,"500 mL"]
[null,null,null,null,null,null,null,null,null,"%",null,"mL",null,"mL"]
[null,null,"(if used) IDENTIFY THE SECONDARY (O2) CONTROL (MHRW recommended unless receiving water characteristics differ)",null,null,null,null,null,null,"%",null,"mL",null,"mL"]
[null,null,null,null,null,null,null,null,null,"%",null,"mL",null,"mL"]
[null,null,null,null,null,null,null,null,null,"%",null,"mL",null,"mL"]
[null,null,null,null,null,null,null,null,1,null,"500 mL",null,"- - -"]
[null,null,"VI.      TEST RESULTS (to be filled out by laboratory)"]
[null,null,"SURVIVAL MEASUREMENTS (Typically 4 reps are required for vertebrates, 10 reps for invertebrates)"]
[null,null,"REPLICATES",1,2,3,4,5,6,7,8,9,10]
[null,null,"CONTROL"]
[]
[]
[]
[]
[]
[null,null,100]
[null,null,"REPRODUCTION OR GROWTH MEASUREMENTS (Typically 4 reps are required for vertebrates, 10 reps for invertebrates)"]
[null,null,"REPLICATES",1,2,3,4,5,6,7,8,9,10]
[null,null,"CONTROL"]
[]
[]
[]
[]
[]
[null,null,100]
[]
[null,null,"TEMPERATURE MEASUREMENTS (MAX/MIN for test period)"]
[null,null,"DILUTIONS",null,null,null,null,"O1","O2 (if used)","--%","--%","--%","--%",1]
[null,null,"MAX/MIN TEMPERATURE IN °C"]
[null,null,"D.O. MEASUREMENTS"]
[null,null,"DILUTIONS",null,null,null,null,"O1","O2 (if used)","--%","--%","--%","--%",1]
[null,null,"MAX/MIN D.O IN mg/L"]
[null,null,"pH MEASUREMENTS"]
[null,null,"DILUTIONS",null,null,null,null,"O1","O2 (if used)","--%","--%","--%","--%",1]
[null,null,"MAX/MIN pH IN s.u"]
[null,null,"CONDUCTIVITY MEASUREMENTS"]
[null,null,"DILUTIONS",null,null,null,null,"O1","O2 (if used)","--%","--%","--%","--%",1]
[null,null,"MAX/MIN IN mS/cm"]
[null,null,"CO2 MEASUREMENTS (if used)"]
[null,null,"DILUTIONS",null,null,null,null,"O1","O2 (if used)","--%","--%","--%","--%",1]
[null,null,"MAX/MIN AS CALCULATED"]
[null,null,"ORGANISM OBSERVATIONS: (e.g. health of the organisms, was prodding required to determine death, were organisms responding in an abnormal manner, etc.) "]
[]
[]
[null,null,"VII.       DATA ANALYSIS (to be filled out by laboratory)"]
[null,null,"METHOD USED TO CALCULATE DATA ENDPOINTS?"]
[null,null,"SOFTWARE USED TO PERFORM CALCULATIONS?"]
[null,null,"HOW WERE ANY OUTLIERS REMOVED FROM CALCULATION?  (describe)"]
[]
[null,null,"FINAL DATA CALCULATIONS - SURVIVAL"]
[null,null,"IC25% DATA CALCULATION",null,null,null,null,null,"TUc CALCULATION"]
[null,null,"FINAL DATA CALCULATIONS - GROWTH OR REPRODUCTION"]
[null,null,"IC25% DATA CALCULATION",null,null,null,null,null,"TUc CALCULATION"]
[null,null,"DESCRIBE ANY DEVIATIONS FROM TEST METHODS OR APPROVED MODIFICATIONS ADMINISTERED (e.g. pH-overlay used and how administered, D.O. issues, aeration used-rate of bubbles per minute and duration, temperature issues, holding time issues, etc.)"]
[]
[null,null,"ANALYST(S)",null,null,null,null,null,"QA OFFICER"]
[null,null,"EPA Region 8 Chronic Toxicity Test Report Format "]
[null,null,"EPA REGION 8 (Modified 7/2020)"]

{"sheet":"Parameters","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Test","TestLength","TestType","SampleType","DataAnalysis","Species","Water","Temperature","Age"]
["Acute","24-hr","Static non-renewal","Grab","GRAPHICAL","2002.0 Daphnia, Ceriodaphnia dubia ","Upstream Receiving Water","20°C +/- 1°C","less than 24 hrs old"]
["Chronic","48-hr","Static-renewal","Composite","SPEARMAN-KARBER","2021.0 Daphnia magna ","Recon Water - Very Soft","25°C +/- 1°C","1-14 days"]
["Chronic survival  & growth","96-hr","Flow-through","Not specified","TRIMMED SPEARMAN-KARBER","2021.0 Daphnia puplex ","Recon Water - Soft","12°C +/- 1°C","15-30 days"]
["Chronic survival & reproduction","not specified",null,null,"PROBIT","2000.0 Fathead Minnow, Pimephales promela, and Bannerfin shiner, Cyprinella leedsi ","Recon Water - Moderaltely Hard","13°C +/- 1°C","30-60 days"]
["Chronic survival & teratogenicity","7 days",null,null,null,"2019.0 Rainbow trout, Oncorhynchus mykiss ","Recon Water - Hard","15°C +/- 1°C","1-5 days"]
[null,"60% or more with 3 broods",null,null,null,"2019.0 Brook trout, Salvelinus fontinalis ","Recon Water - Very Hard",null,"9-14 days"]
[null,"9 days",null,null,null,"2007.0 Mysid, Americamysis bahia ","Dilute Mineral Water",null,"3-4 days post hatch"]
[null,"1 hr, 20 min.",null,null,"DataProgram","2004.0 Sheepshead minnow, Cyprinodon variegatus ","Groundwater","Chronic"]
[null,"not specified",null,null,"TOXSTAT","2006.0 Silverside, Menidia beryllina ","Uncontaminated seawater","25°C +/- 1°C","Newly hatched less than 24 hr"]
[null,null,null,null,"CETIS","2006.0 Silverside, Menidia menidia","5-30% +/- 10% salinity",null,"Less than 36 hr old embryos"]
[null,null,null,null,"EXCEL","2006.0 Silverside, Menidia peninsulae ","5-32% +/- 10% salinity",null,"Less than 24 hr old"]
[null,null,null,null,null,"Holmesimysis costata (ATP Pacific Coast method)","1-32% +/- 10% salinity",null,"Less than 24 hrs, within 8 hr period"]
[null,null,null,null,null,null,"15-32% +/- 10% salinity",null,"4 to 7 days"]
[null,null,null,null,null,"1000.0 Fathead minnow, Pimephales promelas, larval survival and growth ","32% +/- 2% salinity",null,"7-11 days post hatch"]
[null,null,null,null,null,"1001.0 Fathead minnow, Pimephales promelas, larval survival and teratogenicity ","15-32% +/- 10% salinity",null,"7 days"]
[null,null,null,null,null,"1002.0 Daphnia, Ceriodaphnia dubia, survival and reproduction ","20-32% +/- 2% salinity","Marine"]
[null,null,null,null,"LC50%","1003.0 Green alga, Selenastrum capricornutum, growth ","32% +/- 2% salinity","25°C +/- 1°C"]
[null,null,null,null,"NOAEC","1004.0 Sheepshead minnow, Cyprinodon variegatus, larval survival and growth ","20-33% +/- 2% salinity"]
[null,null,null,null,"LC50%","1005.0 Sheepshead minnow, Cyprinodon variegatus, embryo-larval survival and teratogenicity ","30% +/- 2% salinity"]
[null,null,null,null,"IC25%","1006.0 Inland silverside, Menidia beryllina, larval survival and growth "]
[null,null,null,null,"IC50%","1007.0 Mysid, Americamysis bahia, survival, growth,and fecundity "]
[null,null,null,null,"NOEC","1008.0 Sea urchin, Arbacia punctulata, fertilization "]
[null,null,null,null,"LOEC"]
[null,null,null,null,"EC50"]