Submitted data error checks
0. Instructions for submitters
Submitters should use this file to check for problems with submitted data. Send either a list of problems or confirmation that everything looks OK to Sasha by email. Be sure to reference the dataset version and file creation date/time when doing so. These are:
## Version: 2.47## [1] "Date/time: 2024-04-04 14:51:07.529107"Each of these html files contains a summary of the data from a single submitted spreadsheet file. The html name is based on the name of the submitted file. Use the details below to check:
- Institute abbreviation, submitter and contributor names
- The plot location(s), using the map zoom and pan features if needed
- For problems in the first sections; “OK” means there are no problems in a particular section, “warning” is something that should be checked (but might be OK), “error” is a problem that needs to be addressed
- For numeric values outside the expected range in the “Value checks” section
- Variables with missing values–are there any missing that you thought you included?
- Plots of flux, cumulative emission over time, and final cumulative emission for strange patterns, unexpectedly high or low values
- Plots of weather data for appropriate differences between plots and expected diurnal or other patterns
- Plots of manure and application data for correct values
Finally, the numeric summary at the end might provide details that can help in pinpointing problems, but typically does not need to be checked.
1. Submitter
| inst.abbrev | submitter | version | date |
|---|---|---|---|
| AU | Pedersen, Johanna | 1 | 2022-07-07 |
2. Contributors
3. File and directory names
## [1] "../../data-submitted/03/AU"## [1] "../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx"4. Location
5.Keys and codes
Codes in Treatments sheet
## OK## OKCodes in Plots sheet
## OK## OKCodes in Emission sheet
## OK## OKCode merge check (matching project, experiment, field, plot, treatment)
## OK## OK## OK## OK## OK6. Publication info
Check for missing codes
## [1] "Missing pub codes in Publications sheet."## [1] "Some pub codes missing in Experiments sheet."Complete citations given
## OK## OK7. Emission sheet
Duplicated intervals
## OKMissing incorporation time
## OKDelay after application
## OKMissing or double interval number
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OKMissing time between intervals
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OKMeasurement method and units
Measurement technique:
| Method | Frequency |
|---|---|
| Wind tunnel | 851 |
Measurement technique classification:
| Classification | Frequency |
|---|---|
| wt | 851 |
Emission units and conversion factors.
| Original unit | Conversion factor applied | Final unit | |
|---|---|---|---|
| 1 | kg NH3/ha-hr | 0.8224414 | kg N/ha-hr |
| 9 | NA | NA | kg N/ha-hr |
7. Value checks
Check to see if submitted values are within a reasonable range.
Weather
## wind : OK
## rain.rate : OK
## air.temp : OK
## soil.temp : No values to check.
## soil.temp.surf : No values to check.
## air.temp.z : OK
## wind.z : No values to check.Manure and application
## man.stor : No values to check.
## man.dm : OK
## man.vs : No values to check.
## man.tkn : OK
## man.tan : OK
## man.tic : No values to check.
## man.ua : No values to check.
## man.vfa : No values to check.
## man.ph : OK
## app.rate : OK
## crop.z : OKEmission
## j.NH3 : OK
## e.int : OK
## e.rel : OK8. Missing values
Check for missing values.
All variables
## Some values missing:
## Table below has number of missing observations by variable:
## pub.id meas.tech.det silt sand soil.type
## 851 851 851 851 851
## soil.water.v man.source.det man.bed man.trt2 man.trt3
## 851 851 851 851 851
## man.stor man.vs man.tic man.ua man.vfa
## 851 851 851 851 851
## time.incorp man.area furrow.z furrow.w crop.area
## 851 851 851 851 851
## lai notes.plot bg.dl bg.val bg.unit
## 851 755 9 9 9
## pH.surf soil.temp soil.temp.z soil.temp.surf rad
## 851 851 851 851 851
## wind.z MOL ustar rl air.pres
## 851 851 851 851 851
## air.pres.unit rh wind.loc far.loc notes.int
## 851 851 851 851 850
## j.NH3.unit.orig j.NH3.orig j.NH3.conv.fact wind.2m pub.info
## 9 9 9 851 851
## soil.type2 exper2 rep2
## 851 851 851Application method and measurement method
## OK## OK9. Plots
Calculated cumulative emission
Cumulative emission. Missing values imputed (linear interpolation). Numeric labels show position of data in data file: row in the “Plots” sheet and first row in the “Emission” sheet. Labels in center of the first plot have measurement method, manure source, and application method. The same emission data are plotted a few different ways to facilitate checking for problems, e.g., comparing plot to each other or checking application dates. The same colors should be be used for particular field plots throughout this section.
Final cumulative emission
## `stat_bin()` using `bins = 30`. Pick better value with `binwidth`.
Relative versus absolute emission
Flux
Weather data
Manure and application
10. dfsumm summary
Plot-level data
##
## 9 rows and 174 columns
## 9 unique rows
## pub.id
## Class logical
## Minimum <NA>
## Maximum <NA>
## Mean <NA>
## Unique (excld. NA) 0
## Missing values 9
## Sorted <NA>
##
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx.E:21E.F:WUR.P:1.T:30.R:1.R2:.T:2021-11-09 09:38:00.M:Wind tunnelNA
## Maximum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx.E:21E.F:WUR.P:9.T:20diluted.R:3.R2:.T:2021-11-09 10:42:00.M:Wind tunnelNA
## Mean <NA>
## Unique (excld. NA) 9
## Missing values 0
## Sorted TRUE
##
## proj exper field plot rep plot.area
## Class character character character numeric numeric numeric
## Minimum eGylle 21E WUR 1 1 0.2
## Maximum eGylle 21E WUR 12 3 0.2
## Mean <NA> <NA> <NA> 6.33 2 0.2
## Unique (excld. NA) 1 1 1 9 3 1
## Missing values 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE FALSE TRUE
##
## lat long country topo clay silt sand
## Class numeric numeric character character numeric logical logical
## Minimum 52 5.65 NL Flat 16 <NA> <NA>
## Maximum 52 5.65 NL Flat 16 <NA> <NA>
## Mean 52 5.65 <NA> <NA> 16 <NA> <NA>
## Unique (excld. NA) 1 1 1 1 1 0 0
## Missing values 0 0 0 0 0 9 9
## Sorted TRUE TRUE TRUE TRUE TRUE <NA> <NA>
##
## oc soil.type soil.water soil.water.v soil.moist soil.ph
## Class numeric logical numeric logical character numeric
## Minimum 3.5 <NA> 0.49 <NA> wet 5.5
## Maximum 3.5 <NA> 0.49 <NA> wet 5.5
## Mean 3.5 <NA> 0.49 <NA> <NA> 5.5
## Unique (excld. NA) 1 0 1 0 1 1
## Missing values 0 9 0 9 0 0
## Sorted TRUE <NA> TRUE <NA> TRUE TRUE
##
## soil.dens crop.res till man.source man.source.det
## Class numeric character character character logical
## Minimum 0.98 Yes No cat <NA>
## Maximum 0.98 Yes No cat <NA>
## Mean 0.98 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1 1 0
## Missing values 0 0 0 0 9
## Sorted TRUE TRUE TRUE TRUE <NA>
##
## man.bed man.con man.trt1 man.trt2 man.trt3 man.stor
## Class logical character character logical logical logical
## Minimum <NA> Slurry Dilution <NA> <NA> <NA>
## Maximum <NA> Slurry None <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 2 0 0 0
## Missing values 9 0 0 9 9 9
## Sorted <NA> TRUE FALSE <NA> <NA> <NA>
##
## man.dm man.vs man.tkn man.tan man.tic man.ua man.vfa
## Class numeric logical numeric numeric logical logical logical
## Minimum 4.47 <NA> 2.3 1.14 <NA> <NA> <NA>
## Maximum 6.78 <NA> 3.48 1.73 <NA> <NA> <NA>
## Mean 6.01 <NA> 3.09 1.53 <NA> <NA> <NA>
## Unique (excld. NA) 2 0 2 2 0 0 0
## Missing values 0 9 0 0 9 9 9
## Sorted FALSE <NA> FALSE FALSE <NA> <NA> <NA>
##
## man.ph app.start app.end app.method
## Class numeric POSIXct, POSIXt POSIXct, POSIXt character
## Minimum 7.7 2021-11-09 09:38:00 2021-11-09 09:38:00 os
## Maximum 7.75 2021-11-09 11:06:00 2021-11-09 11:06:00 os
## Mean 7.72 2021-11-09 10:20:40 2021-11-09 10:20:40 <NA>
## Unique (excld. NA) 2 9 9 1
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE TRUE
##
## app.rate app.rate.unit incorp time.incorp man.area
## Class numeric character character numeric logical
## Minimum 20 t/ha none <NA> <NA>
## Maximum 30 t/ha none <NA> <NA>
## Mean 26.7 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 2 1 1 0 0
## Missing values 0 0 0 9 9
## Sorted FALSE TRUE TRUE <NA> <NA>
##
## dist.inj furrow.z furrow.w crop crop.z crop.area
## Class numeric logical logical character numeric numeric
## Minimum 25 <NA> <NA> grass 7.6 <NA>
## Maximum 25 <NA> <NA> grass 15.6 <NA>
## Mean 25 <NA> <NA> <NA> 11.6 <NA>
## Unique (excld. NA) 1 0 0 1 9 0
## Missing values 0 9 9 0 0 9
## Sorted TRUE <NA> <NA> TRUE FALSE <NA>
##
## lai notes.plot row.in.file.plot institute sub.period
## Class logical character numeric character numeric
## Minimum <NA> . 5 AU 3
## Maximum <NA> . 13 AU 3
## Mean <NA> <NA> 9 <NA> 3
## Unique (excld. NA) 0 1 9 1 1
## Missing values 9 8 0 0 0
## Sorted <NA> TRUE FALSE TRUE TRUE
##
## file
## Class character
## Minimum ../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## treat meas.tech meas.tech.det app.start.orig
## Class character character logical character
## Minimum 20 Wind tunnel <NA> 09-11-2021 09:38
## Maximum 30 Wind tunnel <NA> 09-11-2021 11:06
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 3 1 0 9
## Missing values 0 0 9 0
## Sorted FALSE TRUE <NA> FALSE
##
## app.end.orig
## Class character
## Minimum 09-11-2021 09:38
## Maximum 09-11-2021 11:06
## Mean <NA>
## Unique (excld. NA) 9
## Missing values 0
## Sorted FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx.E:21E.F:WUR.P:1.T:30.R:1.R2:.T:2021-11-09 09:38:00
## Maximum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx.E:21E.F:WUR.P:9.T:20diluted.R:3.R2:.T:2021-11-09 10:42:00
## Mean <NA>
## Unique (excld. NA) 9
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:eGylle.E:21E Pedersen, Johanna 34.3
## Maximum D:1.I:AU.Pr:eGylle.E:21E Pedersen, Johanna 51.9
## Mean <NA> <NA> <NA> 40.3
## Unique (excld. NA) 1 1 1 3
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE
##
## e.1 e.4 e.6 e.12 e.24 e.48 e.72
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum <NA> 1.55 2.41 3.98 5.88 7.51 8.34
## Maximum <NA> 3.1 4.82 8.46 12.8 17 18.9
## Mean <NA> 1.95 3.06 5.33 7.99 10.7 11.9
## Unique (excld. NA) 0 9 9 9 9 9 9
## Missing values 9 0 0 0 0 0 0
## Sorted <NA> FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.96 e.168 e.final e.tot e.cum.1 e.cum.4 e.cum.6
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum 9.06 10.2 10.2 10.2 <NA> 1.55 2.41
## Maximum 20.4 22.8 22.8 22.8 <NA> 3.1 4.82
## Mean 12.9 14.4 14.4 14.4 <NA> 1.95 3.06
## Unique (excld. NA) 9 9 9 9 0 9 9
## Missing values 0 0 0 0 9 0 0
## Sorted FALSE FALSE FALSE FALSE <NA> FALSE FALSE
##
## e.cum.12 e.cum.24 e.cum.48 e.cum.72 e.cum.96 e.cum.168
## Class numeric numeric numeric numeric numeric numeric
## Minimum 3.98 5.88 7.51 8.34 9.06 10.2
## Maximum 8.46 12.8 17 18.9 20.4 22.8
## Mean 5.33 7.99 10.7 11.9 12.9 14.4
## Unique (excld. NA) 9 9 9 9 9 9
## Missing values 0 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.cum.final e.cum.tot e.rel.1 e.rel.4 e.rel.6 e.rel.12
## Class numeric numeric numeric numeric numeric numeric
## Minimum 10.2 10.2 <NA> 0.0328 0.0583 0.113
## Maximum 22.8 22.8 <NA> 0.0597 0.0929 0.163
## Mean 14.4 14.4 <NA> 0.0493 0.0769 0.133
## Unique (excld. NA) 9 9 0 9 9 9
## Missing values 0 0 9 0 0 0
## Sorted FALSE FALSE <NA> FALSE FALSE FALSE
##
## e.rel.24 e.rel.48 e.rel.72 e.rel.96 e.rel.168 e.rel.final
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0.165 0.219 0.243 0.264 0.298 0.298
## Maximum 0.246 0.327 0.365 0.393 0.439 0.44
## Mean 0.199 0.264 0.294 0.317 0.355 0.355
## Unique (excld. NA) 9 9 9 9 9 9
## Missing values 0 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE
##
## e.rel.tot rain.1 rain.4 rain.6 rain.12 rain.24 rain.48
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum 0.298 <NA> 0 0 0 0 0
## Maximum 0.44 <NA> 0 0 0 0 0
## Mean 0.355 <NA> 0 0 0 0 0
## Unique (excld. NA) 9 0 1 1 1 1 1
## Missing values 0 9 0 0 0 0 0
## Sorted FALSE <NA> TRUE TRUE TRUE TRUE TRUE
##
## rain.72 rain.96 rain.168 rain.final rain.tot air.temp.1
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0 0 0 0 0 <NA>
## Maximum 0 0 0 0 0 <NA>
## Mean 0 0 0 0 0 <NA>
## Unique (excld. NA) 1 1 1 1 1 0
## Missing values 0 0 0 0 0 9
## Sorted TRUE TRUE TRUE TRUE TRUE <NA>
##
## air.temp.4 air.temp.6 air.temp.12 air.temp.24 air.temp.48
## Class numeric numeric numeric numeric numeric
## Minimum 8.04 8.85 9.57 6.63 7.06
## Maximum 9.88 10.2 9.92 8.58 8.12
## Mean 9.05 9.54 9.73 7.92 7.74
## Unique (excld. NA) 7 7 9 9 9
## Missing values 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE
##
## air.temp.72 air.temp.96 air.temp.168 air.temp.mn wind.1
## Class numeric numeric numeric numeric numeric
## Minimum 7.3 7.27 7.42 7.59 <NA>
## Maximum 7.96 7.88 7.72 7.84 <NA>
## Mean 7.73 7.65 7.62 7.76 <NA>
## Unique (excld. NA) 9 9 9 9 0
## Missing values 0 0 0 0 9
## Sorted FALSE FALSE FALSE FALSE <NA>
##
## wind.4 wind.6 wind.12 wind.24 wind.48 wind.72 wind.96
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum 0.33 0.33 0.33 0.33 0.33 0.33 0.33
## Maximum 0.33 0.33 0.33 0.33 0.33 0.33 0.33
## Mean 0.33 0.33 0.33 0.33 0.33 0.33 0.33
## Unique (excld. NA) 1 1 1 2 2 2 2
## Missing values 0 0 0 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE FALSE TRUE TRUE
##
## wind.168 wind.mn rain.rate.1 rain.rate.4 rain.rate.6
## Class numeric numeric numeric numeric numeric
## Minimum 0.33 0.337 <NA> 0 0
## Maximum 0.33 0.34 <NA> 0 0
## Mean 0.33 0.338 <NA> 0 0
## Unique (excld. NA) 2 3 0 1 1
## Missing values 0 0 9 0 0
## Sorted TRUE FALSE <NA> TRUE TRUE
##
## rain.rate.12 rain.rate.24 rain.rate.48 rain.rate.72
## Class numeric numeric numeric numeric
## Minimum 0 0 0 0
## Maximum 0 0 0 0
## Mean 0 0 0 0
## Unique (excld. NA) 1 1 1 1
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE
##
## rain.rate.96 rain.rate.168 rain.rate.mn
## Class numeric numeric numeric
## Minimum 0 0 0
## Maximum 0 0 0
## Mean 0 0 0
## Unique (excld. NA) 1 1 1
## Missing values 0 0 0
## Sorted TRUE TRUE TRUE
##
## first.row.in.file.int last.row.in.file.int n.ints dt1
## Class numeric numeric integer numeric
## Minimum 5 100 94 1.73
## Maximum 762 855 96 1.73
## Mean 384 478 94.6 1.73
## Unique (excld. NA) 9 9 3 1
## Missing values 0 0 0 0
## Sorted TRUE TRUE FALSE TRUE
##
## j.rel1 j.NH31 dt.min dt.max ct.min ct.max
## Class numeric numeric numeric numeric numeric numeric
## Minimum 0 0 1.73 8.12 1.73 171
## Maximum 0.0107 0.397 1.73 9.83 1.73 172
## Mean 0.00639 0.245 1.73 9.64 1.73 171
## Unique (excld. NA) 9 9 1 2 1 3
## Missing values 0 0 0 0 0 0
## Sorted FALSE FALSE TRUE TRUE TRUE FALSE
##
## t.start.p t.end.p air.temp.z
## Class POSIXct, POSIXt POSIXct, POSIXt numeric
## Minimum 2021-11-09 09:38:00 2021-11-16 11:32:00 2
## Maximum 2021-11-09 11:06:00 2021-11-16 13:08:00 2
## Mean 2021-11-09 10:20:40 2021-11-16 12:20:53 2
## Unique (excld. NA) 9 9 1
## Missing values 0 0 0
## Sorted FALSE FALSE TRUE
##
## soil.temp.z wind.z wind.loc far.loc pub.info soil.type2
## Class logical logical logical logical character logical
## Minimum <NA> <NA> <NA> <NA> <NA> <NA>
## Maximum <NA> <NA> <NA> <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 0 0 0 0 0
## Missing values 9 9 9 9 9 9
## Sorted <NA> <NA> <NA> <NA> <NA> <NA>
##
## exper2 rep2 acid meas.tech.orig meas.tech2 crop.orig
## Class logical logical logical character character character
## Minimum <NA> <NA> FALSE Wind tunnel wt Grass
## Maximum <NA> <NA> FALSE Wind tunnel wt Grass
## Mean <NA> <NA> 0 TRUE <NA> <NA> <NA>
## Unique (excld. NA) 0 0 1 1 1 1
## Missing values 9 9 0 0 0 0
## Sorted <NA> <NA> TRUE TRUE TRUE TRUE
##
## man.source.orig app.method.orig app.method2 incorp.orig
## Class character character character character
## Minimum Cattle Open slot injection os None
## Maximum Cattle Open slot injection os None
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1 1
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE
##
## date.start
## Class Date
## Minimum 2021-11-09
## Maximum 2021-11-09
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
## Interval-level emission data
##
## 851 rows and 137 columns
## 851 unique rows
## cpmid
## Class character
## Minimum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx.E:21E.F:WUR.P:1.T:30.R:1.R2:.T:2021-11-09 09:38:00.M:Wind tunnelNA
## Maximum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx.E:21E.F:WUR.P:9.T:20diluted.R:3.R2:.T:2021-11-09 10:42:00.M:Wind tunnelNA
## Mean <NA>
## Unique (excld. NA) 9
## Missing values 0
## Sorted TRUE
##
## pub.id proj exper field plot rep
## Class logical character character character numeric numeric
## Minimum <NA> eGylle 21E WUR 1 1
## Maximum <NA> eGylle 21E WUR 12 3
## Mean <NA> <NA> <NA> <NA> 6.31 2
## Unique (excld. NA) 0 1 1 1 9 3
## Missing values 851 0 0 0 0 0
## Sorted <NA> TRUE TRUE TRUE FALSE FALSE
##
## treat meas.tech meas.tech.det plot.area lat
## Class character character logical numeric numeric
## Minimum 20 Wind tunnel <NA> 0.2 52
## Maximum 30 Wind tunnel <NA> 0.2 52
## Mean <NA> <NA> <NA> 0.2 52
## Unique (excld. NA) 3 1 0 1 1
## Missing values 0 0 851 0 0
## Sorted FALSE TRUE <NA> TRUE TRUE
##
## long country topo clay silt sand oc
## Class numeric character character numeric logical logical numeric
## Minimum 5.65 NL Flat 16 <NA> <NA> 3.5
## Maximum 5.65 NL Flat 16 <NA> <NA> 3.5
## Mean 5.65 <NA> <NA> 16 <NA> <NA> 3.5
## Unique (excld. NA) 1 1 1 1 0 0 1
## Missing values 0 0 0 0 851 851 0
## Sorted TRUE TRUE TRUE TRUE <NA> <NA> TRUE
##
## soil.type soil.water soil.water.v soil.moist soil.ph
## Class logical numeric logical character numeric
## Minimum <NA> 0.49 <NA> wet 5.5
## Maximum <NA> 0.49 <NA> wet 5.5
## Mean <NA> 0.49 <NA> <NA> 5.5
## Unique (excld. NA) 0 1 0 1 1
## Missing values 851 0 851 0 0
## Sorted <NA> TRUE <NA> TRUE TRUE
##
## soil.dens crop.res till man.source man.source.det
## Class numeric character character character logical
## Minimum 0.98 Yes No cat <NA>
## Maximum 0.98 Yes No cat <NA>
## Mean 0.98 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1 1 0
## Missing values 0 0 0 0 851
## Sorted TRUE TRUE TRUE TRUE <NA>
##
## man.bed man.con man.trt1 man.trt2 man.trt3 man.stor
## Class logical character character logical logical logical
## Minimum <NA> Slurry Dilution <NA> <NA> <NA>
## Maximum <NA> Slurry None <NA> <NA> <NA>
## Mean <NA> <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 2 0 0 0
## Missing values 851 0 0 851 851 851
## Sorted <NA> TRUE FALSE <NA> <NA> <NA>
##
## man.dm man.vs man.tkn man.tan man.tic man.ua man.vfa
## Class numeric logical numeric numeric logical logical logical
## Minimum 4.47 <NA> 2.3 1.14 <NA> <NA> <NA>
## Maximum 6.78 <NA> 3.48 1.73 <NA> <NA> <NA>
## Mean 6.01 <NA> 3.09 1.53 <NA> <NA> <NA>
## Unique (excld. NA) 2 0 2 2 0 0 0
## Missing values 0 851 0 0 851 851 851
## Sorted FALSE <NA> FALSE FALSE <NA> <NA> <NA>
##
## man.ph app.start app.end app.method
## Class numeric POSIXct, POSIXt POSIXct, POSIXt character
## Minimum 7.7 2021-11-09 09:38:00 2021-11-09 09:38:00 os
## Maximum 7.75 2021-11-09 11:06:00 2021-11-09 11:06:00 os
## Mean 7.72 2021-11-09 10:20:29 2021-11-09 10:20:29 <NA>
## Unique (excld. NA) 2 9 9 1
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE TRUE
##
## app.rate app.rate.unit incorp time.incorp man.area
## Class numeric character character numeric logical
## Minimum 20 t/ha none <NA> <NA>
## Maximum 30 t/ha none <NA> <NA>
## Mean 26.7 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 2 1 1 0 0
## Missing values 0 0 0 851 851
## Sorted FALSE TRUE TRUE <NA> <NA>
##
## dist.inj furrow.z furrow.w crop crop.z crop.area
## Class numeric logical logical character numeric numeric
## Minimum 25 <NA> <NA> grass 7.6 <NA>
## Maximum 25 <NA> <NA> grass 15.6 <NA>
## Mean 25 <NA> <NA> <NA> 11.6 <NA>
## Unique (excld. NA) 1 0 0 1 9 0
## Missing values 0 851 851 0 0 851
## Sorted TRUE <NA> <NA> TRUE FALSE <NA>
##
## lai notes.plot row.in.file.plot institute sub.period
## Class logical character numeric character numeric
## Minimum <NA> . 5 AU 3
## Maximum <NA> . 13 AU 3
## Mean <NA> <NA> 8.98 <NA> 3
## Unique (excld. NA) 0 1 9 1 1
## Missing values 851 755 0 0 0
## Sorted <NA> TRUE FALSE TRUE TRUE
##
## file
## Class character
## Minimum ../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx
## Maximum ../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx
## Mean <NA>
## Unique (excld. NA) 1
## Missing values 0
## Sorted TRUE
##
## app.start.orig app.end.orig
## Class character character
## Minimum 09-11-2021 09:38 09-11-2021 09:38
## Maximum 09-11-2021 11:06 09-11-2021 11:06
## Mean <NA> <NA>
## Unique (excld. NA) 9 9
## Missing values 0 0
## Sorted FALSE FALSE
##
## cpid
## Class character
## Minimum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx.E:21E.F:WUR.P:1.T:30.R:1.R2:.T:2021-11-09 09:38:00
## Maximum D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_220524_JP_21E_220610.xlsx.E:21E.F:WUR.P:9.T:20diluted.R:3.R2:.T:2021-11-09 10:42:00
## Mean <NA>
## Unique (excld. NA) 9
## Missing values 0
## Sorted TRUE
##
## ceid flag.plot submitter tan.app
## Class character character character numeric
## Minimum D:1.I:AU.Pr:eGylle.E:21E Pedersen, Johanna 34.3
## Maximum D:1.I:AU.Pr:eGylle.E:21E Pedersen, Johanna 51.9
## Mean <NA> <NA> <NA> 40.3
## Unique (excld. NA) 1 1 1 3
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE FALSE
##
## interval t.start t.end dt
## Class numeric POSIXct, POSIXt POSIXct, POSIXt numeric
## Minimum 1 2021-11-09 09:38:00 2021-11-09 11:22:00 1.73
## Maximum 96 2021-11-16 13:08:00 2021-11-16 14:52:00 9.83
## Mean 47.8 2021-11-13 02:33:03 2021-11-13 04:22:01 1.81
## Unique (excld. NA) 96 851 851 3
## Missing values 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE
##
## bg.dl bg.val bg.unit j.NH3 j.NH3.unit pH.surf
## Class character numeric character numeric character logical
## Minimum Yes 0.00188 ppm 0 kg N/ha-hr <NA>
## Maximum Yes 0.0233 ppm 1.1 kg N/ha-hr <NA>
## Mean <NA> 0.00874 <NA> 0.0781 <NA> <NA>
## Unique (excld. NA) 1 95 1 780 1 0
## Missing values 9 9 9 0 0 851
## Sorted TRUE FALSE TRUE FALSE TRUE <NA>
##
## air.temp air.temp.z soil.temp soil.temp.z soil.temp.surf
## Class numeric numeric numeric logical logical
## Minimum 2.33 2 <NA> <NA> <NA>
## Maximum 12.1 2 <NA> <NA> <NA>
## Mean 7.64 2 <NA> <NA> <NA>
## Unique (excld. NA) 328 1 0 0 0
## Missing values 0 0 851 851 851
## Sorted FALSE TRUE <NA> <NA> <NA>
##
## rad wind wind.z MOL ustar rl air.pres
## Class logical numeric logical logical logical logical logical
## Minimum <NA> 0.33 <NA> <NA> <NA> <NA> <NA>
## Maximum <NA> 0.33 <NA> <NA> <NA> <NA> <NA>
## Mean <NA> 0.33 <NA> <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 0 0 0 0 0
## Missing values 851 0 851 851 851 851 851
## Sorted <NA> TRUE <NA> <NA> <NA> <NA> <NA>
##
## air.pres.unit rain rh wind.loc far.loc notes.int
## Class logical numeric logical logical logical character
## Minimum <NA> 0 <NA> <NA> <NA> .
## Maximum <NA> 0 <NA> <NA> <NA> .
## Mean <NA> 0 <NA> <NA> <NA> <NA>
## Unique (excld. NA) 0 1 0 0 0 1
## Missing values 851 0 851 851 851 850
## Sorted <NA> TRUE <NA> <NA> <NA> TRUE
##
## row.in.file.int j.type t.start.orig
## Class numeric character character
## Minimum 5 emission rate 09-11-2021 09:38
## Maximum 855 emission rate 16-11-2021 13:08
## Mean 430 <NA> <NA>
## Unique (excld. NA) 851 1 851
## Missing values 0 0 0
## Sorted TRUE TRUE FALSE
##
## t.end.orig j.NH3.unit.orig j.NH3.orig j.NH3.conv.fact
## Class character character numeric numeric
## Minimum 09-11-2021 09:38 kg NH3/ha-hr 0 0.822
## Maximum 16-11-2021 13:08 kg NH3/ha-hr 1.34 0.822
## Mean <NA> <NA> 0.0932 0.822
## Unique (excld. NA) 851 1 771 1
## Missing values 0 9 9 9
## Sorted FALSE TRUE FALSE TRUE
##
## dt.calc dt.diff ct mt cta bta flag.int
## Class numeric numeric numeric numeric numeric numeric character
## Minimum 1.72 -0.00333 1.73 0.865 1.73 0
## Maximum 9.83 0.0133 172 172 173 171 m i
## Mean 1.82 -0.0026 89.9 89 90 88.2 <NA>
## Unique (excld. NA) 4 4 183 183 99 99 2
## Missing values 0 0 0 0 0 0 0
## Sorted FALSE FALSE FALSE FALSE FALSE FALSE FALSE
##
## rain.rate rain.cum wind.2m e.int e.cum e e.rel
## Class numeric numeric numeric numeric numeric numeric numeric
## Minimum 0 0 <NA> 0 0 0 0
## Maximum 0 0 <NA> 3.29 22.8 22.8 0.44
## Mean 0 0 <NA> 0.153 11.7 11.7 0.289
## Unique (excld. NA) 1 1 0 780 780 780 780
## Missing values 0 0 851 0 0 0 0
## Sorted TRUE TRUE <NA> FALSE FALSE FALSE FALSE
##
## j.rel pub.info soil.type2 exper2 rep2 acid
## Class numeric character logical logical logical logical
## Minimum 0 <NA> <NA> <NA> <NA> FALSE
## Maximum 0.0212 <NA> <NA> <NA> <NA> FALSE
## Mean 0.00192 <NA> <NA> <NA> <NA> 0 TRUE
## Unique (excld. NA) 780 0 0 0 0 1
## Missing values 0 851 851 851 851 0
## Sorted FALSE <NA> <NA> <NA> <NA> TRUE
##
## meas.tech.orig meas.tech2 crop.orig man.source.orig
## Class character character character character
## Minimum Wind tunnel wt Grass Cattle
## Maximum Wind tunnel wt Grass Cattle
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1 1
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE
##
## app.method.orig app.method2 incorp.orig date.start
## Class character character character Date
## Minimum Open slot injection os None 2021-11-09
## Maximum Open slot injection os None 2021-11-09
## Mean <NA> <NA> <NA> <NA>
## Unique (excld. NA) 1 1 1 1
## Missing values 0 0 0 0
## Sorted TRUE TRUE TRUE TRUE
##
## first.row.int row.plot first.rows ggplotgroup
## Class numeric numeric factor factor
## Minimum 5 5 Plots 10 Emis. 668 (4.99,9]
## Maximum 762 13 Plots 9 Emis. 574 (9,13]
## Mean 383 8.98 Plots 5 Emis. 5 (4.99,9]
## Unique (excld. NA) 9 9 9 2
## Missing values 0 0 0 0
## Sorted TRUE FALSE FALSE FALSE
##