Fill in Blank Bio Template by qwk15328

VIEWS: 2,359 PAGES: 23

More Info
									***This is the spreadsheet template to be used when submitting data to the NOAA.
***For questions about how to fill out this spreadsheet, contact:
  Jay Field
  phone: 206-526-6404
  email: jay.field@noaa.gov

Instructions for this worksheet
***Please fill out as much of the following narrative questions as possible. In this worksheet, you may have
***responses that are larger than the box shown. For, simple statement entries, type your response and adjust
***the row height. You may also insert new rows below the text entry box if necessary for longer responses.
***All other worksheets in this template must complete entries in the locations where you see <data entry>.

Contact Information (for questions about the data study purposes, collection or analytical methods)
                        <Replace with Contact Name>
                        <Replace with Contact Phone Number>
                        <Replace with Contact Email Address>
                        <Replace with Agency name>




Study Questions
   Put a Yes or No to confirm data types included in spreadsheet
   Sediment chemistry
   Tissue chemistry
   Laboratory toxicity tests
   Paired sediment chem./toxicity

Station Questions
   Please verify (yes/no) that the station locations are reported in:
   Lat/Long
   NAD83

   How reliable are the provided coordinates (error)? Please describe any difficulties in establishing the station
   location that would affect the accuracy of the indicated position:


Sediment Sample Questions
  Sampling Methods
  How were the samples collected (Van Veen grab, core)?

   Were homogenized subsamples or composites collected from the same sampling device?

   Were multiple samples collected at the same station?

   What was the naming convention used for field replicate sampling?


   Analytical Methods
   Were there analytical laboratory replicates?, If so, how are they identified in the template?

   Were any analytes measured using more than one method? If so, which ones?

   Are chemistry data reported in dry weight or wet weight?

   Was total organic carbon measured on each sample and included in the chemistry worksheet?
   Was grain size measured on each sample and included in the chemistry worksheet?

   Are there totals provided (e.g., total PAHs, PCBs, etc.)? If so, please explain how these totals were derived:


Tissue Sample Questions
   Sampling Methods
   How were the tissue samples prepared (skinned, depurated, etc.)?

   Were multiple analyses conducted on the same specimen (e.g., fillet and bile)?
   If so, how are these identified in the templates?


   Analytical Methods
   Were there analytical laboratory replicates?, If so, how were they identified?

   Were any analytes measured using more than one method? If so, which ones?

   Are tissue data reported in dry weight or wet weight?

   Were %lipids measured on each sample and include in the chemistry worksheet?


Biological Toxicity Sample Questions
   Describe the tests and test methods used:

   Describe how the toxic response was measured, and how significance was established:

   Describe any problems that occurred with the test or control samples that the user should be aware of:


Spreadsheet Worksheets
  Identify the names of the worksheets used for chemistry data and which matrices and analytical methods
  contained on each sheet if applicable (see the instructions on the Dictionary worksheet for clarification).
                          Worksheet name             Matrix                     Analytical method
*** This spreadsheet provides the definitions for the columns used in the spreadsheets. Use this worksheet as a reference when completing the templates.
*** Use the Chem template to report your sediment chemistry results. Use the Chemtiss template to report your tissue chemistry results.
*** Provide notes on analytical methods and summing or other key study comments on the sheet named START.
*** An X in the Required column indicates the information must be provided. In the worksheets, these have green column headers. An (x) in the
*** Required column indicates that the information is required in certain situations. Refer to "Additional Comments".

 Worksheet
    Name                 Field                                            Description                             Required                     Additional Comments
Station    Station                              Unique station identifier                                            X     Should be 8 characters or less
           Station description                  General description of location of station
           Latitude                             Decimal degrees in NAD 83                                             X
           Longitude                            Decimal degrees in NAD 83                                             X

Samp_Sed      Field_ID                          Collection identifier, if different from sample identifier           (x)
              Station                           Station identifier                                                    X       Should match station name in 'Station' worksheet
              Sample                            Sample identifier                                                     X       Should be 6 characters or less
              Sample Type Code                  Code for sample type                                                  X       See "Nomenclature and Codes"
              Lab Rep                           Completed for lab subsamples of a single field-collected sample      (x)      Lab replicates should have same station and sample IDs

              Sample Collection Date            In YYYYMMDD format                                                    X
              Sample Collection Time            In HH:MM format
              Upper Collection Depth (cm)       0 if surface sample                                                   X
              Lower Collection Depth (cm)                                                                             X
              Water Depth (m)                                                                                                 If water depth is recorded, time of day should be reported.

SampTiss      Field_ID                          Collection Identifier, if different from Sample identifier           (x)
              Station                           Station identifier                                                    X       Should match station name in 'Station' worksheet
              Sample                            Sample identifier                                                     X       Should be 6 characters or less. Different tissues from same
                                                                                                                              organism are considered different samples
              Sample Type Code                  Code for sample type                                                  X       See "Nomenclature and Codes"
              Lab Rep                           Completed for lab subsamples of a single field-collected sample      (x)      Lab replicates should have same station and sample IDs

              Sample Collection Date            In YYYYMMDD format                                                    X
              Sample Collection Time            In HH:MM format
              Species                           Species name                                                          X
              Tissue                            Tissue type (e.g., whole body, liver, etc.)                           X
              Length (cm)                       Length of organism in centimeters                                     X       If composite sample, report the mean length
              Weight (g)                        Weight of organism in grams                                           X       If composite sample, report the total weight
              Sex                               M, F, or U                                                            X       U = unknown
              Age (yrs)                                                                                              (x)      If available.
              Life History stage                e.g., larvae, juvenile, adult                                         X
              Number in composite               Number of organisms in composite sample                               X       Required if composite. Use 1 for single organism sample
              Water Depth (m)                                                                                                 If water depth is recorded, time of day should be reported.
 Worksheet
   Name                    Field                                 Description                               Required                      Additional Comments
Chem and   Station                       Station identifier                                                   X     Should match station name in 'Station' worksheet
Chemtiss   Sample                        Sample identifier                                                    X     Should match sample name in 'Samp_Sed' worksheet
           Lab Rep                       Completed for lab subsamples of a single field-collected sample     (x)    Should match 'Lab Rep' in 'Samp_Sed' worksheet

           Method                        Chemical analysis method                                             (x)    Complete if the same chemical is generated for a single sample by
                                                                                                                     two different analytical results (e.g. hexachlorobenzene by 8270C
                                                                                                                     and pesticide analysis)
           CAS Number                    CAS Number
           Chemical                      Chemical name                                                         X
           Result (conc)                 Result                                                                X     If below detection limit, enter detection limit value
           Qualifier(s)                  Qualifier codes                                                      (x)    Required if data is qualified by lab or validator
           Units                         Units                                                                 X

Bioassay   Field ID                      Collection Identifier, if different from Sample identifier           (x)
           Station                       Station identifier                                                    X     Should match station name in 'Station' worksheet
           Reference Station? (Y or N)   Was the sample from a reference station?                              X
           Sample                        Sample identifier                                                     X     Should match sample name in 'Samp_Sed' worksheet
           Negative control? (Y or N)    Was the sample the negative control?                                  X
           Series                        Laboratory series identifier                                         (x)    To be used if more than one series and multiple negative control
                                                                                                                     samples are reported
           Test Medium                   Laboratory medium (e.g., sediment, elutriate, pore water)            X
           Test Species                  Genus and species of organism used for test                          X
           Life History Stage            e.g., larvae, juvenile, adult                                        X
           Test Duration                 Provide time and units (e.g., 72 hours, 10 days)                     X
           Endpoint                      e.g., percent survival, growth, reproduction                         X      Also provide units (count, percent, etc.)
           Mean Effect Value             Value of the measured result                                         X
           Number of replicates          Number of laboratory replicates included in the mean
           Standard deviation            Standard deviation of the mean effect value
           Significant? (Y or N)         Was the effect significant relative to negative control?             X
           Original significance code    Provide the original code/mark which designated significant vs.             Provide notes in the START page about the codes used
                                         non-significan or toxic vs. non-toxic results

Bio_reps   Field ID                      Collection Identifier, if different from Sample identifier           (x)
           Station                       Station identifier                                                    X     Should match station name in 'Station' worksheet
           Reference Station? (Y or N)   Was the sample from a reference station?                              X
           Sample                        Sample identifier                                                     X     Should match sample name in 'Samp_Sed' worksheet
           Replicate Number                                                                                    X
           Negative control? (Y or N)    Was the sample the negative control?                                  X
           Series                        Laboratory series identifier                                         (x)    To be used if more than one series and multiple negative control
                                                                                                                     samples.
           Test Medium                   Laboratory medium (e.g., sediment, elutriate, pore water)            X
           Test Species                  Genus and species of organism used for test                          X
           Life History Stage            e.g., larvae, juvenile, adult                                        X
           Test Duration                 Provide time and units (e.g., 72 hours, 10 days)                     X
Endpoint       e.g., percent survival, growth, reproduction   X   Also provide units (count, percent, etc.)
Effect Value   Value of the measured result                   X
***In this worksheet, or as an attachment, please provide the following information:

MEASURED                Provide an electronic table listing all chemical names, applicable
CHEMICALS
                        analytical methods, units, CAS# (if used), chemical codes (if used), .

QUALIFIERS              Provide a list of all qualifiers used and their definitions if different
                        from the codes shown below
SPECIES COLLECTED       For studies with tissue chemistry, provide an electronic table listing
                        all species names, common names, and species codes (if used).

LAB BIOASSAYS           For studies with lab bioassay from sediments, provide an electronic
                        table listing test species, duration, endpoint, and life history stage at
                        test initiation, and endpoint (measured response).

OTHER CODES             Please provide other codes below or in a separate file. GLNPO codes
                        have been included in this spreadsheet for convenience.

                                    QUALIFIER CODES
        Code                                          Description
         B              Analyte was detected in laboratory method blank.
                        Estimated Concentration. Analyte to internal standard ratio exceeds
          E
                        the range of calibration curve.
                        Estimated maximum possible concentration due to peak interferences.
           I
                        Estimated Concentration. Result is greater than detection limit, but
           J
                        less than reporting limit.
                        Lab Duplicate: Batch quality control for lab surrogate exceeds upper
         LD
                        or lower control limits.
                        Lab Surrogate: Batch quality control for lab surrogate exceeds upper
          LS
                        or lower control limits.
          M             MS/MSD recoveries exceed the upper or lower control limits.
                        MS/MSD: Analyte was present in the original sample at a
                        concentration X times greater than the spike concentration.
         MX
                        Therefore, control limits for the MS/MSD samples are not applicable.

                        The lower of the two values is reported when the percent difference
          P             between the results of two GC columns is greater than applicable
                        control limits.
          Q             Results was qualitatively confirmed, but not quantified.
          U             Analyte was not detected at or above the reporting limit.
                        Estimated Value. Analytes co-elution resulted in inability to
          X
                        differentiate different analytes.

                                                                                       SAMPLE TYPE CODES
Code                    Name
FDn                     Field Duplicate, ("n"-th member from field duplicate sets)
FRn   Field Replicate (n-th member of field replicate sets)




LDn   Lab Duplicate, ("n"-th member from lab)




RFS   Routine field sample
        File name, if applicable



        File name, if applicable

        File name, if applicable



        File name, if applicable




SAMPLE TYPE CODES
        Description                                      Purpose
        The "n"-th duplicate of a routine field sample   To evaluate field sampling and matrix
        (RFS). Taken at the SAME TIME and SAME           variability when duplicate samples
        PLACE and from the same sample material as       theoretically contain the same amount of the
        a RFS, using the same gear, and treated same     subject analyte
        as RFS through all field, transport, and lab
        procedures
The "n"-th replicate of a routine field sample To evaluate field variability of samples
(RFS). A second RFS is collected at the        located a very small distance apart. Provides
"approximately" the SAME TIME and              insight into spatial variability of sediments.
"approximately" the SAME PLACE, using the
same gear, and treated same as RFS through
all field, transport, and lab procedures.

The "n"-th duplicate of a routine field sample. To evaluate lab variation in reported results
Created in the lab and treated same as routine when duplicate samples theoretically contain
field sample through all procedures             the same amount of the subject analyte.
                                                Provides precision assessment of results

Sample or aliquot collected in the field.      To assess the environmental "level" of the
Routine field samples are the actual, "real"   subject analyte, species of interest, or other
samples taken in the field. Not a quality      collected entity
control sample of any kind
 Required?         Field Name                          Description                 <data entry>
Y            SITENAME           Name of site or watershed
N            EPAREGION          EPA Regiona
N            COUNTY             County
N            STATE              State
N            CERCLIS            CERCLIS Identifier, if applicable
N            REACH              River reach, if applicable
N            REACHSEG           River reach segment, if applicable
N            WATERSHED          Watershed name, if applicable
Y            STUDYNAME          Name of study
Y            CONTACT            Name of contact person for questions about data.
N            YEAR               Year of publication of data, if published
N            AUTHORS            Authors, if published
N            TITLE              Title of publication, if published
N            SOURCE             Source of citation
Station   Station description   Latitude   Longitude
                                                                      Sample
                                                         Sample      Collection     Upper      Lower
                               Sample                Collection Date   Time       Collection Collection
Field ID   Station   Sample   Type Code   Lab Rep   (YYYYMMDD) (HH:MM)            Depth (cm) Depth (cm)
 Water
Depth (m)
                                                                       Sample
                                                    Sample Collection Collection
                               Sample                    Date           Time
Field ID   Station   Sample   Type Code   Lab Rep    (YYYYMMDD) (HH:MM)            Species   Tissue
                                           Life History Number in    Water
Length (cm) Weight (g)   Sex   Age (yrs)       stage    composite   Depth (m)
Station   Sample   Lab Rep   Method   CAS Number   Chemical   Result (conc)   Qualifier(s)
Units
Station   Sample   Lab Rep   Method   CAS Number   Chemical   Result (conc)   Qualifier(s)
Units
                      Reference             Negative
                     Station? (Y            control?             Test                   Life History
Field ID   Station      or N)      Sample   (Y or N)   Series   Medium   Test Species      Stage
                                                                             Original
  Test                MeanEffect   Number of    Standard    Significant?   significance
Duration   Endpoint     Value      Replicates   Deviation     (Y or N)         code
                      Reference                         Negative
                     Station? (Y            Replicate   control?             Test
Field ID   Station      or N)      Sample   Number      (Y or N)   Series   Medium   Test Species
Life History     Test
   Stage       Duration   Endpoint   Effect Value

								
To top