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 Biomass Category
        Column # 2   [ BIOM1= Total Dry Weight (mg/m3) ]
        Column # 3   [ BIOM1= Total Ashfree Dry Weight (mg/m3) ]
        Column # 4   [ BIOM1= Ratio of Mesozooplankton DW to AFDW ]
        Column # 5   [ BIOM= Average Mesozooplankton DW (ug/individual) ]
        Column # 10   [ BIOM1= Microzooplankton Dry Weight (mg/m3) ]
        Column # 11   [ BIOM1= Microzooplankton Ashfree Dry Weight (mg/m3) ]
        Column # 12   [ BIOM= Ratio of Microzooplankton DW to AFDW ]
        Column # 14   [ BIOM= Average Microzooplankton DW (ug/individual) ]

    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 ]

    Chlorophyll/Pigments Category
        Column # 36   [ CHLA= Average Chlorophyll (ug/l) from 0-75 m ]

DATA SORTED BY GROUPING SETS:

    Category 1 Group # 1
        column # 2     [ BIOM1= Total Dry Weight (mg/m3) ]
        column # 3     [ BIOM1= Total Ashfree Dry Weight (mg/m3) ]
        column # 4     [ BIOM1= Ratio of Mesozooplankton DW to AFDW ]
        column # 10     [ BIOM1= Microzooplankton Dry Weight (mg/m3) ]
        column # 11     [ BIOM1= Microzooplankton Ashfree Dry Weight (mg/m3) ]

    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. 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.8599999 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. 5025. 415
( 100%)		 415
( 100%)
Column 8 :
[ 09_ABND1= Total Copepods (#/m3) ] 		no problems detected 415 132. 2512.5 415
( 100%)		 415
( 100%)
Column 10 :
[ 10_BIOM1= Microzooplankton Dry Weight (mg/m3) ] 		no problems detected 390 0.100000001 13. 390
( 100%)		 366
( 93%)
Column 11 :
[ 11_BIOM1= Microzooplankton Ashfree Dry Weight (mg/m3) ] 		no problems detected 385 0.0500000007 10.6999998 385
( 100%)		 324
( 84%)
Column 12 :
[ 12_BIOM= Ratio of Microzooplankton DW to AFDW ] 		no problems detected 385 1. 3.5454545 385
( 100%)		 384
( 99%)
Column 13 :
[ 13_ABDT= Total Microzooplankton (#/m3) ] 		no problems detected 380 166. 12058. 380
( 100%)		 380
( 100%)
Column 14 :
[ 14_BIOM= Average Microzooplankton DW (ug/individual) ] 		no problems detected 380 0.0763358772 8.27195454 379
( 99%)		 99
( 26%)
Column 15 :
[ 15_ABDT1= Copepodite C1-C5 Abundance (#/m3) ] 		no problems detected 379 165. 10307. 379
( 100%)		 379
( 100%)
Column 16 :
[ 16_ABDT1= Nauplii Abundance (#/m3) ] 		no problems detected 377 17. 5994. 377
( 100%)		 377
( 100%)
Column 18 :
[ 17_ABDT2= Appendicularian Abundance (#/m3) ] 		no problems detected 409 8. 635. 408
( 99%)		 408
( 99%)
Column 19 :
[ 18_ABDT3= Cladoceran Abundance (#/m3) ] 		no problems detected 410 1. 1522. 392
( 95%)		 385
( 93%)
Column 20 :
[ 19_ABDT2= Doliolid Abundance (#/m3) ] 		no problems detected 406 0.5 605. 379
( 93%)		 366
( 90%)
Column 21 :
[ 20_ABDT3= Chaetognath Abundance (#/m3) ] 		no problems detected 404 0.5 120. 378
( 93%)		 366
( 90%)
Column 22 :
[ 21_ABDT2= Siphonophore Abundance (#/m3) ] 		no problems detected 406 1. 260. 397
( 97%)		 392
( 96%)
Column 23 :
[ 22_ABDT2= Medusa Abundance (#/m3) ] 		no problems detected 406 0.5 201. 300
( 73%)		 267
( 65%)
Column 24 :
[ 23_ABDT2= Pteropod Abundance (#/m3) ] 		no problems detected 401 1. 203. 269
( 67%)		 250
( 62%)
Column 25 :
[ 24_ABDT3= Ostracod Abundance (#/m3) ] 		no problems detected 404 1. 102. 328
( 81%)		 321
( 79%)
Column 26 :
[ 25_ABDT2= Salp Abundance (#/m3) ] 		no problems detected 390 1. 199. 62
( 15%)		 43
( 11%)
Column 27 :
[ 26_ABDT3= Larval Crustacean Abundance (#/m3) ] 		no problems detected 392 1. 201. 348
( 88%)		 329
( 83%)
Column 28 :
[ 27_ABDT3= Meroplankton Abundance (#/m3) ] 		no problems detected 391 1. 549. 383
( 97%)		 379
( 96%)
Column 30 :
[ 28_TEMP4= Average Temperature ( C ) from 0-5 m ] 		no problems detected 403 13.4899998 29. 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 0.0700000003 1.63 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".