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:50:29.765063"

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:

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

contributor institute
Nyord, Tavs Aarhus Universitet

3. File and directory names

## [1] "../../data-submitted/03/AU"
## [1] "../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.xlsx"

4. Location

5.Keys and codes

Codes in Treatments sheet

## OK
## OK

Codes in Plots sheet

## OK
## OK

Codes in Emission sheet

## OK
## OK

Code merge check (matching project, experiment, field, plot, treatment)

## OK
## OK
## OK
## OK
## OK

6. Publication info

Check for missing codes

## OK
## OK

Complete citations given

## OK
## OK

7. Emission sheet

Duplicated intervals

## OK

Missing incorporation time

## OK

Delay after application

## OK

Missing or double interval number

## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK

Missing time between intervals

## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK
## OK

Measurement method and units

Measurement technique:

Method Frequency
Wind tunnel 3489

Measurement technique classification:

Classification Frequency
wt 3489

Emission units and conversion factors.

Original unit Conversion factor applied Final unit
1 kg NH3/ha-hr 0.8224414 kg N/ha-hr
26 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 : OK
## man.ph : OK
## app.rate : OK
## crop.z : No values to check.

Emission

## j.NH3 : OK
## e.int : OK
## e.rel : OK

8. Missing values

Check for missing values.

All variables

## Some values missing:
## Table below has number of missing observations by variable:
##   meas.tech.det              oc       soil.type    soil.water.v      soil.moist 
##            3489            3489            3489            3489            3489 
##  man.source.det         man.bed        man.trt2        man.trt3        man.stor 
##            3489            3489            3489            3489            3489 
##          man.vs         man.tic          man.ua     time.incorp        man.area 
##            3489            3489            3489            3489            3489 
##        dist.inj        furrow.z        furrow.w          crop.z       crop.area 
##            3489            3489            3489            3489            3489 
##             lai      notes.plot           bg.dl          bg.val         bg.unit 
##            3489            3397            3489               9               9 
##         pH.surf      air.temp.z       soil.temp     soil.temp.z  soil.temp.surf 
##            3489               9            3489            3489            3489 
##             rad            wind          wind.z             MOL           ustar 
##            3489            3305            3489            3489            3489 
##              rl        air.pres   air.pres.unit              rh        wind.loc 
##            3489            3489            3489            3489            3489 
##         far.loc       notes.int j.NH3.unit.orig      j.NH3.orig j.NH3.conv.fact 
##            3489            3488               9               9               9 
##         wind.2m      soil.type2          exper2            rep2 
##            3489            3489            3489            3489

Application method and measurement method

## OK
## OK

9. 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

## Warning: Removed 3305 rows containing missing values or values outside the scale range
## (`geom_line()`).
## Warning: Removed 3305 rows containing missing values or values outside the scale range
## (`geom_point()`).

Manure and application

10. dfsumm summary

Plot-level data

## 
##  36 rows and 174 columns
##  36 unique rows
##                       pub.id
## Class              character
## Minimum                    G
## Maximum                    G
## Mean                    <NA>
## Unique (excld. NA)         1
## Missing values             0
## Sorted                  TRUE
##                             
##                                                                                                                                                                                     cpmid
## Class                                                                                                                                                                           character
## Minimum            D:1.I:AU.Pr:MHB.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.xlsx.E:20E.F:FoulumgårdC.P:1.T:tank.R:1.R2:.T:2020-11-18 13:40:00.M:Wind tunnelNA
## Maximum            D:1.I:AU.Pr:MHB.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.xlsx.E:20H.F:FoulumgårdC.P:9.T:none.R:3.R2:.T:2020-12-09 15:01:00.M:Wind tunnelNA
## Mean                                                                                                                                                                                 <NA>
## Unique (excld. NA)                                                                                                                                                                     36
## Missing values                                                                                                                                                                          0
## Sorted                                                                                                                                                                               TRUE
##                                                                                                                                                                                          
##                         proj     exper       field    plot     rep plot.area
## Class              character character   character numeric numeric   numeric
## Minimum                  MHB       20E FoulumgårdC       1       1       0.2
## Maximum                  MHB       20H FoulumgårdC      12       3       0.2
## Mean                    <NA>      <NA>        <NA>    6.33       2       0.2
## Unique (excld. NA)         1         4           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 numeric numeric
## Minimum               56.5    9.57        DK      Flat       9      24      65
## Maximum               56.5    9.57        DK      Flat       9      24      65
## Mean                  56.5    9.57      <NA>      <NA>       9      24      65
## Unique (excld. NA)       1       1         1         1       1       1       1
## Missing values           0       0         0         0       0       0       0
## Sorted                TRUE    TRUE      TRUE      TRUE    TRUE    TRUE    TRUE
##                                                                               
##                         oc soil.type soil.water soil.water.v soil.moist soil.ph
## Class              logical   logical    numeric      logical    logical numeric
## Minimum               <NA>      <NA>       0.38         <NA>       <NA>     5.4
## Maximum               <NA>      <NA>        0.5         <NA>       <NA>     5.4
## Mean                  <NA>      <NA>       0.41         <NA>       <NA>     5.4
## Unique (excld. NA)       0         0          2            0          0       1
## Missing values          36        36          0           36         36       0
## Sorted                <NA>      <NA>      FALSE         <NA>       <NA>    TRUE
##                                                                                
##                    soil.dens  crop.res      till man.source man.source.det
## Class                numeric character character  character        logical
## Minimum                 1.03       Yes        No        cat           <NA>
## Maximum                 1.03       Yes        No        pig           <NA>
## Mean                    1.03      <NA>      <NA>       <NA>           <NA>
## Unique (excld. NA)         1         1         1          2              0
## Missing values             0         0         0          0             36
## Sorted                  TRUE      TRUE      TRUE      FALSE           <NA>
##                                                                           
##                    man.bed   man.con      man.trt1 man.trt2 man.trt3 man.stor
## Class              logical character     character  logical  logical  logical
## Minimum               <NA>    Slurry Acidification     <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          36         0             0       36       36       36
## 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 numeric
## Minimum               5.84    <NA>    2.86    1.86    <NA>    <NA>     7.2
## Maximum               9.35    <NA>    5.03    4.32    <NA>    <NA>    13.7
## Mean                  7.39    <NA>    3.85    2.69    <NA>    <NA>    10.2
## Unique (excld. NA)      12       0      11      12       0       0      11
## Missing values           0      36       0       0      36      36       0
## Sorted               FALSE    <NA>   FALSE   FALSE    <NA>    <NA>   FALSE
##                                                                           
##                     man.ph           app.start             app.end app.method
## Class              numeric     POSIXct, POSIXt     POSIXct, POSIXt  character
## Minimum                5.8 2020-02-12 13:25:00 2020-02-12 13:25:00       bsth
## Maximum                7.1 2020-12-09 15:25:00 2020-12-09 15:25:00       bsth
## Mean                  6.42 2020-09-09 06:25:08 2020-09-09 06:25:08       <NA>
## Unique (excld. NA)       9                  36                  36          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                  35          t/ha      none        <NA>     <NA>
## Maximum                  35          t/ha      none        <NA>     <NA>
## Mean                     35          <NA>      <NA>        <NA>     <NA>
## Unique (excld. NA)        1             1         1           0        0
## Missing values            0             0         0          36       36
## Sorted                 TRUE          TRUE      TRUE        <NA>     <NA>
##                                                                         
##                    dist.inj furrow.z furrow.w      crop  crop.z crop.area
## Class               logical  logical  logical character numeric   numeric
## Minimum                <NA>     <NA>     <NA>     grass    <NA>      <NA>
## Maximum                <NA>     <NA>     <NA>     grass    <NA>      <NA>
## Mean                   <NA>     <NA>     <NA>      <NA>    <NA>      <NA>
## Unique (excld. NA)        0        0        0         1       0         0
## Missing values           36       36       36         0      36        36
## Sorted                 <NA>     <NA>     <NA>      TRUE    <NA>      <NA>
##                                                                          
##                        lai notes.plot row.in.file.plot institute sub.period
## Class              logical  character          numeric character    numeric
## Minimum               <NA>          .                5        AU          3
## Maximum               <NA>          .               40        AU          3
## Mean                  <NA>       <NA>             22.5      <NA>          3
## Unique (excld. NA)       0          1               36         1          1
## Missing values          36         35                0         0          0
## Sorted                <NA>       TRUE            FALSE      TRUE       TRUE
##                                                                            
##                                                                                       file
## Class                                                                            character
## Minimum            ../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.xlsx
## Maximum            ../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.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                field Wind tunnel          <NA> 09-12-2020 14:29
## Maximum                 tank Wind tunnel          <NA>  12/9/2020 14:21
## Mean                    <NA>        <NA>          <NA>             <NA>
## Unique (excld. NA)         3           1             0               36
## Missing values             0           0            36                0
## Sorted                 FALSE        TRUE          <NA>            FALSE
##                                                                        
##                        app.end.orig
## Class                     character
## Minimum            09-12-2020 14:29
## Maximum             12/9/2020 14:21
## Mean                           <NA>
## Unique (excld. NA)               36
## Missing values                    0
## Sorted                        FALSE
##                                    
##                                                                                                                                                                      cpid
## Class                                                                                                                                                           character
## Minimum            D:1.I:AU.Pr:MHB.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.xlsx.E:20E.F:FoulumgårdC.P:1.T:tank.R:1.R2:.T:2020-11-18 13:40:00
## Maximum            D:1.I:AU.Pr:MHB.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.xlsx.E:20H.F:FoulumgårdC.P:9.T:none.R:3.R2:.T:2020-12-09 15:01:00
## Mean                                                                                                                                                                 <NA>
## Unique (excld. NA)                                                                                                                                                     36
## Missing values                                                                                                                                                          0
## Sorted                                                                                                                                                               TRUE
##                                                                                                                                                                          
##                                     ceid flag.plot         submitter tan.app
## Class                          character character         character numeric
## Minimum            D:1.I:AU.Pr:MHB.E:20E           Pedersen, Johanna    65.1
## Maximum            D:1.I:AU.Pr:MHB.E:20H           Pedersen, Johanna     151
## Mean                                <NA>      <NA>              <NA>    94.1
## Unique (excld. NA)                     4         1                 1      12
## 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> 0.00408 0.00616 0.00616  0.0811   0.413   0.578
## Maximum               <NA>    4.39    6.99    13.1    20.7      25    25.7
## Mean                  <NA>    1.45    2.24       4    6.15    8.47    10.1
## Unique (excld. NA)       0      36      36      36      36      36      36
## Missing values          36       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              0.744    7.22    1.31    1.31    <NA> 0.00408 0.00616
## Maximum               26.2    18.8      27      27    <NA>    4.39    6.99
## Mean                  11.4    13.4    14.6    14.6    <NA>    1.45    2.24
## Unique (excld. NA)      36       9      36      36       0      36      36
## Missing values           0      27       0       0      36       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             0.00616   0.0811    0.413    0.578    0.744      7.22
## Maximum                13.1     20.7       25     25.7     26.2      18.8
## Mean                      4     6.15     8.47     10.1     11.4      13.4
## Unique (excld. NA)       36       36       36       36       36         9
## Missing values            0        0        0        0        0        27
## 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                   1.31      1.31    <NA> 4.19e-05 5.21e-05 5.21e-05
## Maximum                     27        27    <NA>   0.0611   0.0975    0.182
## Mean                      14.6      14.6    <NA>    0.017   0.0265   0.0484
## Unique (excld. NA)          36        36       0       36       36       36
## Missing values               0         0      36        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.000686  0.00349  0.00808    0.011     0.101      0.0194
## Maximum               0.288    0.348    0.359    0.365     0.283       0.375
## Mean                 0.0755    0.104    0.122    0.136     0.201       0.169
## Unique (excld. NA)       36       36       36       36         9          36
## Missing values            0        0        0        0        27           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.0194    <NA>       0       0       0       0       0
## Maximum                0.375    <NA>       0       0       0       0       0
## Mean                   0.169    <NA>       0       0       0       0       0
## Unique (excld. NA)        36       0       1       1       1       1       1
## Missing values             0      36       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       27          0        0         36
## 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                  3.84       3.63        3.03        2.38        2.42
## Maximum                  11.6       11.2        10.8        9.65        6.92
## Mean                     7.01       6.85        6.53        5.95        4.66
## Unique (excld. NA)         36         36          35          36          36
## 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                   2.79        2.91         3.16        3.16    <NA>
## Maximum                   6.63        6.95         7.31        7.31    <NA>
## Mean                      4.22        4.18         4.75        4.91    <NA>
## Unique (excld. NA)          36          36           36          36       0
## Missing values               0           0            0           0      36
## 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       1       1       1       1
## Missing values          34      34      34      34      34      34      34
## Sorted                TRUE    TRUE    TRUE    TRUE    TRUE    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.33        <NA>           0           0
## Maximum                0.33    0.33        <NA>           0           0
## Mean                   0.33    0.33        <NA>           0           0
## Unique (excld. NA)        1       1           0           1           1
## Missing values           34      34          36           0           0
## Sorted                 TRUE    TRUE        <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                   96      92    1.73
## Maximum                             3390                 3490     107    1.73
## Mean                                1650                 1750    96.9    1.73
## Unique (excld. NA)                    36                   36       5       1
## Missing values                         0                    0       0       0
## Sorted                             FALSE                FALSE   FALSE    TRUE
##                                                                              
##                      j.rel1  j.NH31  dt.min  dt.max  ct.min  ct.max
## Class               numeric numeric numeric numeric numeric numeric
## Minimum            2.42e-05 0.00236    1.73    1.73    1.73     162
## Maximum             0.00997   0.715    1.73    4.53    1.73     185
## Mean                0.00286   0.247    1.73    2.43    1.73     168
## Unique (excld. NA)       36      36       1       2       1       5
## Missing values            0       0       0       0       0       0
## Sorted                FALSE   FALSE    TRUE   FALSE    TRUE   FALSE
##                                                                    
##                              t.start.p             t.end.p air.temp.z
## Class                  POSIXct, POSIXt     POSIXct, POSIXt    numeric
## Minimum            2020-11-18 13:40:00 2020-11-25 06:12:00          2
## Maximum            2020-12-09 15:25:00 2020-12-17 06:53:00          2
## Mean               2020-11-29 02:25:10 2020-12-06 01:22:45          2
## Unique (excld. NA)                  36                  36          1
## Missing values                       0                   0          0
## Sorted                           FALSE               FALSE       TRUE
##                                                                      
##                    soil.temp.z  wind.z wind.loc far.loc
## Class                  logical logical  logical logical
## Minimum                   <NA>    <NA>     <NA>    <NA>
## Maximum                   <NA>    <NA>     <NA>    <NA>
## Mean                      <NA>    <NA>     <NA>    <NA>
## Unique (excld. NA)           0       0        0       0
## Missing values              36      36       36      36
## Sorted                    <NA>    <NA>     <NA>    <NA>
##                                                        
##                                                                                                                                                                                                                                                                       pub.info
## Class                                                                                                                                                                                                                                                                character
## Minimum            Pedersen, J., Feilberg, A., Nyord, T. 2022. Effect of storage and field acidification on emissions of NH3, NMVOC, and odour from field applied slurry in winter conditions. Journal of Environmental Management, 310. doi.org/10.1016/j.jenvman.2022.114756
## Maximum            Pedersen, J., Feilberg, A., Nyord, T. 2022. Effect of storage and field acidification on emissions of NH3, NMVOC, and odour from field applied slurry in winter conditions. Journal of Environmental Management, 310. doi.org/10.1016/j.jenvman.2022.114756
## Mean                                                                                                                                                                                                                                                                      <NA>
## Unique (excld. NA)                                                                                                                                                                                                                                                           1
## Missing values                                                                                                                                                                                                                                                               0
## Sorted                                                                                                                                                                                                                                                                    TRUE
##                                                                                                                                                                                                                                                                               
##                    soil.type2  exper2    rep2                   acid
## Class                 logical logical logical                logical
## Minimum                  <NA>    <NA>    <NA>                  FALSE
## Maximum                  <NA>    <NA>    <NA>                   TRUE
## Mean                     <NA>    <NA>    <NA> 0.666666666666667 TRUE
## Unique (excld. NA)          0       0       0                      2
## Missing values             36      36      36                      0
## Sorted                   <NA>    <NA>    <NA>                  FALSE
##                                                                     
##                    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             Pig
## Mean                         <NA>       <NA>      <NA>            <NA>
## Unique (excld. NA)              1          1         1               2
## Missing values                  0          0         0               0
## Sorted                       TRUE       TRUE      TRUE           FALSE
##                                                                       
##                                 app.method.orig app.method2 incorp.orig
## Class                                 character   character   character
## Minimum            Band spread or trailing hose        bsth        None
## Maximum            Band spread or trailing hose        bsth        None
## Mean                                       <NA>        <NA>        <NA>
## Unique (excld. NA)                            1           1           1
## Missing values                                0           0           0
## Sorted                                     TRUE        TRUE        TRUE
##                                                                        
##                    date.start
## Class                    Date
## Minimum            2020-11-18
## Maximum            2020-12-09
## Mean                     <NA>
## Unique (excld. NA)          4
## Missing values              0
## Sorted                   TRUE
## 

Interval-level emission data

## 
##  3489 rows and 137 columns
##  3489 unique rows
##                                                                                                                                                                                     cpmid
## Class                                                                                                                                                                           character
## Minimum            D:1.I:AU.Pr:MHB.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.xlsx.E:20E.F:FoulumgårdC.P:1.T:tank.R:1.R2:.T:2020-11-18 13:40:00.M:Wind tunnelNA
## Maximum            D:1.I:AU.Pr:MHB.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.xlsx.E:20H.F:FoulumgårdC.P:9.T:none.R:3.R2:.T:2020-12-09 15:01:00.M:Wind tunnelNA
## Mean                                                                                                                                                                                 <NA>
## Unique (excld. NA)                                                                                                                                                                     36
## Missing values                                                                                                                                                                          0
## Sorted                                                                                                                                                                               TRUE
##                                                                                                                                                                                          
##                       pub.id      proj     exper       field    plot     rep
## Class              character character character   character numeric numeric
## Minimum                    G       MHB       20E FoulumgårdC       1       1
## Maximum                    G       MHB       20H FoulumgårdC      12       3
## Mean                    <NA>      <NA>      <NA>        <NA>    6.33       2
## Unique (excld. NA)         1         1         4           1       9       3
## Missing values             0         0         0           0       0       0
## Sorted                  TRUE      TRUE      TRUE        TRUE   FALSE   FALSE
##                                                                             
##                        treat   meas.tech meas.tech.det plot.area     lat
## Class              character   character       logical   numeric numeric
## Minimum                field Wind tunnel          <NA>       0.2    56.5
## Maximum                 tank Wind tunnel          <NA>       0.2    56.5
## Mean                    <NA>        <NA>          <NA>       0.2    56.5
## Unique (excld. NA)         3           1             0         1       1
## Missing values             0           0          3489         0       0
## Sorted                 FALSE        TRUE          <NA>      TRUE    TRUE
##                                                                         
##                       long   country      topo    clay    silt    sand      oc
## Class              numeric character character numeric numeric numeric logical
## Minimum               9.57        DK      Flat       9      24      65    <NA>
## Maximum               9.57        DK      Flat       9      24      65    <NA>
## Mean                  9.57      <NA>      <NA>       9      24      65    <NA>
## Unique (excld. NA)       1         1         1       1       1       1       0
## Missing values           0         0         0       0       0       0    3489
## Sorted                TRUE      TRUE      TRUE    TRUE    TRUE    TRUE    <NA>
##                                                                               
##                    soil.type soil.water soil.water.v soil.moist soil.ph
## Class                logical    numeric      logical    logical numeric
## Minimum                 <NA>       0.38         <NA>       <NA>     5.4
## Maximum                 <NA>        0.5         <NA>       <NA>     5.4
## Mean                    <NA>      0.409         <NA>       <NA>     5.4
## Unique (excld. NA)         0          2            0          0       1
## Missing values          3489          0         3489       3489       0
## Sorted                  <NA>      FALSE         <NA>       <NA>    TRUE
##                                                                        
##                    soil.dens  crop.res      till man.source man.source.det
## Class                numeric character character  character        logical
## Minimum                 1.03       Yes        No        cat           <NA>
## Maximum                 1.03       Yes        No        pig           <NA>
## Mean                    1.03      <NA>      <NA>       <NA>           <NA>
## Unique (excld. NA)         1         1         1          2              0
## Missing values             0         0         0          0           3489
## Sorted                  TRUE      TRUE      TRUE      FALSE           <NA>
##                                                                           
##                    man.bed   man.con      man.trt1 man.trt2 man.trt3 man.stor
## Class              logical character     character  logical  logical  logical
## Minimum               <NA>    Slurry Acidification     <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        3489         0             0     3489     3489     3489
## 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 numeric
## Minimum               5.84    <NA>    2.86    1.86    <NA>    <NA>     7.2
## Maximum               9.35    <NA>    5.03    4.32    <NA>    <NA>    13.7
## Mean                  7.35    <NA>    3.82    2.66    <NA>    <NA>    10.1
## Unique (excld. NA)      12       0      11      12       0       0      11
## Missing values           0    3489       0       0    3489    3489       0
## Sorted               FALSE    <NA>   FALSE   FALSE    <NA>    <NA>   FALSE
##                                                                           
##                     man.ph           app.start             app.end app.method
## Class              numeric     POSIXct, POSIXt     POSIXct, POSIXt  character
## Minimum                5.8 2020-02-12 13:25:00 2020-02-12 13:25:00       bsth
## Maximum                7.1 2020-12-09 15:25:00 2020-12-09 15:25:00       bsth
## Mean                  6.42 2020-09-11 02:42:44 2020-09-11 02:42:44       <NA>
## Unique (excld. NA)       9                  36                  36          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                  35          t/ha      none        <NA>     <NA>
## Maximum                  35          t/ha      none        <NA>     <NA>
## Mean                     35          <NA>      <NA>        <NA>     <NA>
## Unique (excld. NA)        1             1         1           0        0
## Missing values            0             0         0        3489     3489
## Sorted                 TRUE          TRUE      TRUE        <NA>     <NA>
##                                                                         
##                    dist.inj furrow.z furrow.w      crop  crop.z crop.area
## Class               logical  logical  logical character numeric   numeric
## Minimum                <NA>     <NA>     <NA>     grass    <NA>      <NA>
## Maximum                <NA>     <NA>     <NA>     grass    <NA>      <NA>
## Mean                   <NA>     <NA>     <NA>      <NA>    <NA>      <NA>
## Unique (excld. NA)        0        0        0         1       0         0
## Missing values         3489     3489     3489         0    3489      3489
## Sorted                 <NA>     <NA>     <NA>      TRUE    <NA>      <NA>
##                                                                          
##                        lai notes.plot row.in.file.plot institute sub.period
## Class              logical  character          numeric character    numeric
## Minimum               <NA>          .                5        AU          3
## Maximum               <NA>          .               40        AU          3
## Mean                  <NA>       <NA>               23      <NA>          3
## Unique (excld. NA)       0          1               36         1          1
## Missing values        3489       3397                0         0          0
## Sorted                <NA>       TRUE            FALSE      TRUE       TRUE
##                                                                            
##                                                                                       file
## Class                                                                            character
## Minimum            ../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.xlsx
## Maximum            ../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.xlsx
## Mean                                                                                  <NA>
## Unique (excld. NA)                                                                       1
## Missing values                                                                           0
## Sorted                                                                                TRUE
##                                                                                           
##                      app.start.orig     app.end.orig
## Class                     character        character
## Minimum            09-12-2020 14:29 09-12-2020 14:29
## Maximum             12/9/2020 14:21  12/9/2020 14:21
## Mean                           <NA>             <NA>
## Unique (excld. NA)               36               36
## Missing values                    0                0
## Sorted                        FALSE            FALSE
##                                                     
##                                                                                                                                                                      cpid
## Class                                                                                                                                                           character
## Minimum            D:1.I:AU.Pr:MHB.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.xlsx.E:20E.F:FoulumgårdC.P:1.T:tank.R:1.R2:.T:2020-11-18 13:40:00
## Maximum            D:1.I:AU.Pr:MHB.F:../../data-submitted/03/AU/ALFAM2_template_6_0_220310_JP_20EFGH_v2.xlsx.E:20H.F:FoulumgårdC.P:9.T:none.R:3.R2:.T:2020-12-09 15:01:00
## Mean                                                                                                                                                                 <NA>
## Unique (excld. NA)                                                                                                                                                     36
## Missing values                                                                                                                                                          0
## Sorted                                                                                                                                                               TRUE
##                                                                                                                                                                          
##                                     ceid flag.plot         submitter tan.app
## Class                          character character         character numeric
## Minimum            D:1.I:AU.Pr:MHB.E:20E           Pedersen, Johanna    65.1
## Maximum            D:1.I:AU.Pr:MHB.E:20H           Pedersen, Johanna     151
## Mean                                <NA>      <NA>              <NA>    93.2
## Unique (excld. NA)                     4         1                 1      12
## 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 2020-11-18 13:40:00 2020-11-18 15:24:00    1.73
## Maximum                 107 2020-12-17 06:53:00 2020-12-17 08:37:00    4.53
## Mean                   49.1 2020-12-02 23:50:58 2020-12-03 01:35:24    1.74
## Unique (excld. NA)      107                3489                3489       2
## 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              logical numeric character numeric  character logical
## Minimum               <NA> 0.00204       ppm       0 kg N/ha-hr    <NA>
## Maximum               <NA>  0.0109       ppm     1.4 kg N/ha-hr    <NA>
## Mean                  <NA> 0.00414      <NA>  0.0867       <NA>    <NA>
## Unique (excld. NA)       0     387         1    3439          1       0
## Missing values        3489       9         9       0          0    3489
## Sorted                <NA>   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               -3.37          2      <NA>        <NA>           <NA>
## Maximum                11.7          2      <NA>        <NA>           <NA>
## Mean                   4.78          2      <NA>        <NA>           <NA>
## Unique (excld. NA)     2414          1         0           0              0
## Missing values            0          9      3489        3489           3489
## 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        3489    3305    3489    3489    3489    3489     3489
## 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              3489       0    3489     3489    3489      3488
## Sorted                      <NA>    TRUE    <NA>     <NA>    <NA>      TRUE
##                                                                            
##                    row.in.file.int        j.type     t.start.orig
## Class                      numeric     character        character
## Minimum                          5 emission rate 01-12-2020 00:13
## Maximum                       3490 emission rate 30-11-2020 23:57
## Mean                          1750          <NA>             <NA>
## Unique (excld. NA)            3489             1             3489
## Missing values                   0             0                0
## Sorted                       FALSE          TRUE            FALSE
##                                                                  
##                          t.end.orig j.NH3.unit.orig j.NH3.orig j.NH3.conv.fact
## Class                     character       character    numeric         numeric
## Minimum            01-12-2020 00:13    kg NH3/ha-hr          0           0.822
## Maximum            30-11-2020 23:57    kg NH3/ha-hr        1.7           0.822
## Mean                           <NA>            <NA>      0.105           0.822
## Unique (excld. NA)             3489               1       3430               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.73    -0.02    1.73   0.865    1.73       0          
## Maximum               4.53 -0.00333     185     184    7220    7220       m i
## Mean                  1.74 -0.00338    85.5    84.6    1990    1990      <NA>
## Unique (excld. NA)       3        3     174     174     508     506         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.00408 0.00408 4.19e-05
## Maximum                    0        0    <NA>    2.42      27      27    0.375
## Mean                       0        0    <NA>   0.151    10.1    10.1    0.122
## Unique (excld. NA)         1        1       0    3439    3447    3447     3447
## Missing values             0        0    3489       0       0       0        0
## Sorted                  TRUE     TRUE    <NA>   FALSE   FALSE   FALSE    FALSE
##                                                                               
##                      j.rel
## Class              numeric
## Minimum                  0
## Maximum             0.0195
## Mean                 0.001
## Unique (excld. NA)    3439
## Missing values           0
## Sorted               FALSE
##                           
##                                                                                                                                                                                                                                                                       pub.info
## Class                                                                                                                                                                                                                                                                character
## Minimum            Pedersen, J., Feilberg, A., Nyord, T. 2022. Effect of storage and field acidification on emissions of NH3, NMVOC, and odour from field applied slurry in winter conditions. Journal of Environmental Management, 310. doi.org/10.1016/j.jenvman.2022.114756
## Maximum            Pedersen, J., Feilberg, A., Nyord, T. 2022. Effect of storage and field acidification on emissions of NH3, NMVOC, and odour from field applied slurry in winter conditions. Journal of Environmental Management, 310. doi.org/10.1016/j.jenvman.2022.114756
## Mean                                                                                                                                                                                                                                                                      <NA>
## Unique (excld. NA)                                                                                                                                                                                                                                                           1
## Missing values                                                                                                                                                                                                                                                               0
## Sorted                                                                                                                                                                                                                                                                    TRUE
##                                                                                                                                                                                                                                                                               
##                    soil.type2  exper2    rep2                   acid
## Class                 logical logical logical                logical
## Minimum                  <NA>    <NA>    <NA>                  FALSE
## Maximum                  <NA>    <NA>    <NA>                   TRUE
## Mean                     <NA>    <NA>    <NA> 0.666380051590714 TRUE
## Unique (excld. NA)          0       0       0                      2
## Missing values           3489    3489    3489                      0
## Sorted                   <NA>    <NA>    <NA>                  FALSE
##                                                                     
##                    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             Pig
## Mean                         <NA>       <NA>      <NA>            <NA>
## Unique (excld. NA)              1          1         1               2
## Missing values                  0          0         0               0
## Sorted                       TRUE       TRUE      TRUE           FALSE
##                                                                       
##                                 app.method.orig app.method2 incorp.orig
## Class                                 character   character   character
## Minimum            Band spread or trailing hose        bsth        None
## Maximum            Band spread or trailing hose        bsth        None
## Mean                                       <NA>        <NA>        <NA>
## Unique (excld. NA)                            1           1           1
## Missing values                                0           0           0
## Sorted                                     TRUE        TRUE        TRUE
##                                                                        
##                    date.start first.row.int row.plot          first.rows
## Class                    Date       numeric  numeric              factor
## Minimum            2020-11-18             5        5  Plots 10 Emis. 465
## Maximum            2020-11-18          3390       40   Plots 9 Emis. 373
## Mean                     <NA>          1700       23 Plots 28 Emis. 2156
## Unique (excld. NA)          1            36       36                  36
## Missing values              0             0        0                   0
## Sorted                   TRUE         FALSE    FALSE               FALSE
##                                                                         
##                    ggplotgroup
## Class                   factor
## Minimum            (4.96,10.8]
## Maximum              (34.2,40]
## Mean               (22.5,28.3]
## Unique (excld. NA)           6
## Missing values               0
## Sorted                   FALSE
##