COPEPODITE Incoming Data Review

Fatal Format Issues:   none



HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-MDY ]       Date Set = 1
    Column # 2     [BIOM1= Total Dry Weight (mg/m3)]      ( date set 1 )
    Column # 3     [BIOM1= Total Ashfree Dry Weight (mg/m3)]      ( date set 1 )
    Column # 4     [BIOM1= Ratio of Mesozooplankton DW to AFDW]      ( date set 1 )
    Column # 5     [BIOM= Average Mesozooplankton DW (ug/individual)]      ( date set 1 )

    Column # 6     [ DATE-MDY ]       Date Set = 2
    Column # 7     [ABND3= Total Zooplankton (#/m3)]      ( date set 2 )
    Column # 8     [ABND1= Total Copepods (#/m3)]      ( date set 2 )

    Column # 9     [ DATE-MDY ]       Date Set = 3
    Column # 10     [BIOM1= Microzooplankton Dry Weight (mg/m3)]      ( date set 3 )
    Column # 11     [BIOM1= Microzooplankton Ashfree Dry Weight (mg/m3)]      ( date set 3 )
    Column # 12     [BIOM= Ratio of Microzooplankton DW to AFDW]      ( date set 3 )
    Column # 13     [ABDT= Total Microzooplankton (#/m3)]      ( date set 3 )
    Column # 14     [BIOM= Average Microzooplankton DW (ug/individual)]      ( date set 3 )
    Column # 15     [ABDT1= Copepodite C1-C5 Abundance (#/m3)]      ( date set 3 )
    Column # 16     [ABDT1= Nauplii Abundance (#/m3)]      ( date set 3 )

    Column # 17     [ DATE-MDY ]       Date Set = 4
    Column # 18     [ABDT2= Appendicularian Abundance (#/m3)]      ( date set 4 )
    Column # 19     [ABDT3= Cladoceran Abundance (#/m3)]      ( date set 4 )
    Column # 20     [ABDT2= Doliolid Abundance (#/m3)]      ( date set 4 )
    Column # 21     [ABDT3= Chaetognath Abundance (#/m3)]      ( date set 4 )
    Column # 22     [ABDT2= Siphonophore Abundance (#/m3)]      ( date set 4 )
    Column # 23     [ABDT2= Medusa Abundance (#/m3)]      ( date set 4 )
    Column # 24     [ABDT2= Pteropod Abundance (#/m3)]      ( date set 4 )
    Column # 25     [ABDT3= Ostracod Abundance (#/m3)]      ( date set 4 )
    Column # 26     [ABDT2= Salp Abundance (#/m3)]      ( date set 4 )
    Column # 27     [ABDT3= Larval Crustacean Abundance (#/m3)]      ( date set 4 )
    Column # 28     [ABDT3= Meroplankton Abundance (#/m3)]      ( date set 4 )

    Column # 29     [ DATE-MDY ]       Date Set = 5
    Column # 30     [TEMP4= Average Temperature ( C ) from 0-5 m]      ( date set 5 )
    Column # 31     [TEMP4= Temperature ( C ) at 75 m]      ( date set 5 )
    Column # 32     [TEMP4= Average Temperature ( C ) from 0-75 m]      ( date set 5 )
    Column # 33     [PSAL5= Average Salinity (PSU) from 0-5 m]      ( date set 5 )
    Column # 34     [PSAL5= Salinity (PSU) at 75 m]      ( date set 5 )
    Column # 35     [PSAL5= Average Salinity (PSU) from 0-75 m]      ( date set 5 )
    Column # 36     [CHLA= Average Chlorophyll (ug/l) from 0-75 m]      ( date set 5 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 7   [ ABND3= Total Zooplankton (#/m3) ]
        Column # 8   [ ABND1= Total Copepods (#/m3) ]

    Abundance (with zeros) Category
        Column # 13   [ ABDT= Total Microzooplankton (#/m3) ]
        Column # 15   [ ABDT1= Copepodite C1-C5 Abundance (#/m3) ]
        Column # 16   [ ABDT1= Nauplii Abundance (#/m3) ]
        Column # 18   [ ABDT2= Appendicularian Abundance (#/m3) ]
        Column # 19   [ ABDT3= Cladoceran Abundance (#/m3) ]
        Column # 20   [ ABDT2= Doliolid Abundance (#/m3) ]
        Column # 21   [ ABDT3= Chaetognath Abundance (#/m3) ]
        Column # 22   [ ABDT2= Siphonophore Abundance (#/m3) ]
        Column # 23   [ ABDT2= Medusa Abundance (#/m3) ]
        Column # 24   [ ABDT2= Pteropod Abundance (#/m3) ]
        Column # 25   [ ABDT3= Ostracod Abundance (#/m3) ]
        Column # 26   [ ABDT2= Salp Abundance (#/m3) ]
        Column # 27   [ ABDT3= Larval Crustacean Abundance (#/m3) ]
        Column # 28   [ ABDT3= Meroplankton Abundance (#/m3) ]

    Temperatures Category
        Column # 30   [ TEMP4= Average Temperature ( C ) from 0-5 m ]
        Column # 31   [ TEMP4= Temperature ( C ) at 75 m ]
        Column # 32   [ TEMP4= Average Temperature ( C ) from 0-75 m ]

    Salinities Category
        Column # 33   [ PSAL5= Average Salinity (PSU) from 0-5 m ]
        Column # 34   [ PSAL5= Salinity (PSU) at 75 m ]
        Column # 35   [ PSAL5= Average Salinity (PSU) from 0-75 m ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 1
        column # 8     [ ABND1= Total Copepods (#/m3) ]

    Category 2 Group # 3
        column # 7     [ ABND3= Total Zooplankton (#/m3) ]

    Category 4 Group # 4
        column # 30     [ TEMP4= Average Temperature ( C ) from 0-5 m ]
        column # 31     [ TEMP4= Temperature ( C ) at 75 m ]
        column # 32     [ TEMP4= Average Temperature ( C ) from 0-75 m ]

    Category 5 Group # 5
        column # 33     [ PSAL5= Average Salinity (PSU) from 0-5 m ]
        column # 34     [ PSAL5= Salinity (PSU) at 75 m ]
        column # 35     [ PSAL5= Average Salinity (PSU) from 0-75 m ]

    Category 8 Group # 1
        column # 15     [ ABDT1= Copepodite C1-C5 Abundance (#/m3) ]
        column # 16     [ ABDT1= Nauplii Abundance (#/m3) ]

    Category 8 Group # 2
        column # 18     [ ABDT2= Appendicularian Abundance (#/m3) ]
        column # 20     [ ABDT2= Doliolid Abundance (#/m3) ]
        column # 22     [ ABDT2= Siphonophore Abundance (#/m3) ]
        column # 23     [ ABDT2= Medusa Abundance (#/m3) ]
        column # 24     [ ABDT2= Pteropod Abundance (#/m3) ]
        column # 26     [ ABDT2= Salp Abundance (#/m3) ]

    Category 8 Group # 3
        column # 19     [ ABDT3= Cladoceran Abundance (#/m3) ]
        column # 21     [ ABDT3= Chaetognath Abundance (#/m3) ]
        column # 25     [ ABDT3= Ostracod Abundance (#/m3) ]
        column # 27     [ ABDT3= Larval Crustacean Abundance (#/m3) ]
        column # 28     [ ABDT3= Meroplankton Abundance (#/m3) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1994 2015
DATES in Column 6 no problems detected 1994 2015
DATES in Column 9 no problems detected 1994 2015
DATES in Column 17 no problems detected 1994 2015
DATES in Column 29 no problems detected 1994 2010

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-MDY DATE-MDY yes 1 12 1 31 1994 2015
6 DATE-MDY DATE-MDY yes 1 12 1 31 1994 2015
9 DATE-MDY DATE-MDY yes 1 12 1 31 1994 2015
17 DATE-MDY DATE-MDY yes 1 12 1 31 1994 2015
29 DATE-MDY DATE-MDY yes 1 12 1 31 1994 2010



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_BIOM1= Total Dry Weight (mg/m3) ]
no problems detected 416 1.20000005 17.0000000 416
( 100 %)
416
( 100 %)
Column 3 :
[ 05_BIOM1= Total Ashfree Dry Weight (mg/m3) ]
no problems detected 413 0.800000012 12.3000002 413
( 100 %)
411
( 99 %)
Column 4 :
[ 06_BIOM1= Ratio of Mesozooplankton DW to AFDW ]
no problems detected 413 1.04999995 2.85999990 413
( 100 %)
413
( 100 %)
Column 5 :
[ 07_BIOM= Average Mesozooplankton DW (ug/individual) ]
no problems detected 415 2.05999994 19.0400009 415
( 100 %)
415
( 100 %)
Column 7 :
[ 08_ABND3= Total Zooplankton (#/m3) ]
no problems detected 415 213.000000 5025.00000 415
( 100 %)
415
( 100 %)
Column 8 :
[ 09_ABND1= Total Copepods (#/m3) ]
no problems detected 415 132.000000 2512.50000 415
( 100 %)
415
( 100 %)
Column 10 :
[ 10_BIOM1= Microzooplankton Dry Weight (mg/m3) ]
no problems detected 390 0.100000001 13.0000000 390
( 100 %)
366
( 93 %)
Column 11 :
[ 11_BIOM1= Microzooplankton Ashfree Dry Weight (mg/m3) ]
no problems detected 385 5.00000007E-02 10.6999998 385
( 100 %)
324
( 84 %)
Column 12 :
[ 12_BIOM= Ratio of Microzooplankton DW to AFDW ]
no problems detected 385 1.00000000 3.54545450 385
( 100 %)
384
( 99 %)
Column 13 :
[ 13_ABDT= Total Microzooplankton (#/m3) ]
no problems detected 380 166.000000 12058.0000 380
( 100 %)
380
( 100 %)
Column 14 :
[ 14_BIOM= Average Microzooplankton DW (ug/individual) ]
no problems detected 380 7.63358772E-02 8.27195454 379
( 99 %)
99
( 26 %)
Column 15 :
[ 15_ABDT1= Copepodite C1-C5 Abundance (#/m3) ]
no problems detected 379 165.000000 10307.0000 379
( 100 %)
379
( 100 %)
Column 16 :
[ 16_ABDT1= Nauplii Abundance (#/m3) ]
no problems detected 377 17.0000000 5994.00000 377
( 100 %)
377
( 100 %)
Column 18 :
[ 17_ABDT2= Appendicularian Abundance (#/m3) ]
no problems detected 409 8.00000000 635.000000 408
( 99 %)
408
( 99 %)
Column 19 :
[ 18_ABDT3= Cladoceran Abundance (#/m3) ]
no problems detected 410 1.00000000 1522.00000 392
( 95 %)
385
( 93 %)
Column 20 :
[ 19_ABDT2= Doliolid Abundance (#/m3) ]
no problems detected 406 0.500000000 605.000000 379
( 93 %)
366
( 90 %)
Column 21 :
[ 20_ABDT3= Chaetognath Abundance (#/m3) ]
no problems detected 404 0.500000000 120.000000 378
( 93 %)
366
( 90 %)
Column 22 :
[ 21_ABDT2= Siphonophore Abundance (#/m3) ]
no problems detected 406 1.00000000 260.000000 397
( 97 %)
392
( 96 %)
Column 23 :
[ 22_ABDT2= Medusa Abundance (#/m3) ]
no problems detected 406 0.500000000 201.000000 300
( 73 %)
267
( 65 %)
Column 24 :
[ 23_ABDT2= Pteropod Abundance (#/m3) ]
no problems detected 401 1.00000000 203.000000 269
( 67 %)
250
( 62 %)
Column 25 :
[ 24_ABDT3= Ostracod Abundance (#/m3) ]
no problems detected 404 1.00000000 102.000000 328
( 81 %)
321
( 79 %)
Column 26 :
[ 25_ABDT2= Salp Abundance (#/m3) ]
no problems detected 390 1.00000000 199.000000 62
( 15 %)
43
( 11 %)
Column 27 :
[ 26_ABDT3= Larval Crustacean Abundance (#/m3) ]
no problems detected 392 1.00000000 201.000000 348
( 88 %)
329
( 83 %)
Column 28 :
[ 27_ABDT3= Meroplankton Abundance (#/m3) ]
no problems detected 391 1.00000000 549.000000 383
( 97 %)
379
( 96 %)
Column 30 :
[ 28_TEMP4= Average Temperature ( C ) from 0-5 m ]
no problems detected 403 13.4899998 29.0000000 403
( 100 %)
403
( 100 %)
Column 31 :
[ 29_TEMP4= Temperature ( C ) at 75 m ]
no problems detected 403 12.9300003 16.9899998 403
( 100 %)
403
( 100 %)
Column 32 :
[ 30_TEMP4= Average Temperature ( C ) from 0-75 m ]
no problems detected 403 13.3999996 23.3799992 403
( 100 %)
403
( 100 %)
Column 33 :
[ 31_PSAL5= Average Salinity (PSU) from 0-5 m ]
no problems detected 394 36.9749985 38.1100006 394
( 100 %)
394
( 100 %)
Column 34 :
[ 32_PSAL5= Salinity (PSU) at 75 m ]
no problems detected 395 37.2470016 38.2210007 395
( 100 %)
395
( 100 %)
Column 35 :
[ 33_PSAL5= Average Salinity (PSU) from 0-75 m ]
no problems detected 401 37.1500015 38.1040001 401
( 100 %)
401
( 100 %)
Column 36 :
[34_CHLA= Average Chlorophyll (ug/l) from 0-75 m ]
There is/are 1 count WARNING(S)!

Some of your values are zero or "one".

Possible warning triggers:
  • a non-numeric value was encountered!
  • text comments like "null" or "n/a" will be ignored.
  • Engineering units ("1.25E5", "1.25 x 10^5")

  • 346 7.00000003E-02 1.63000000 346
    ( 100 %)
    4
    ( 1 %)

    The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".