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:43.685589"

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 Jesper Nørlem Kamp 1 2022-03-11

2. Contributors

3. File and directory names

## [1] "../../data-submitted/03/AU"
## [1] "../../data-submitted/03/AU/ALFAM2_template_6_1_eGylle_JK_3.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

## [1] "Problem, see following rows"
## [1] 96
## 
## head() of problem rows:
##    row.in.file.int plot interval             t.start
## 91              95    1       91 2021-08-11 15:00:00
## 92              96    1       92 2021-08-11 15:30:00
## 93              97    1       92 2021-08-11 16:00:00
## OK
## OK
## OK

Missing time between intervals

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

Measurement method and units

Measurement technique:

Method Frequency
bLS 1796

Measurement technique classification:

Classification Frequency
micro met 1796

Emission units and conversion factors.

Original unit Conversion factor applied Final unit
ug NH3/m2/s 0.0296079 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 : OK
## soil.temp.surf : OK
## air.temp.z : OK
## wind.z : OK

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 : OK

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:
##         pub.id  meas.tech.det           silt           sand             oc 
##           1796           1796            378            378           1418 
##      soil.type   soil.water.v     soil.moist        soil.ph man.source.det 
##           1796           1796           1418            468            378 
##        man.bed       man.trt2       man.trt3       man.stor         man.vs 
##           1796           1796           1796           1796           1796 
##        man.tic         man.ua        man.vfa    time.incorp       man.area 
##           1796           1796            378           1796            934 
##       dist.inj       furrow.z       furrow.w      crop.area            lai 
##           1796           1796           1796           1796           1796 
##     notes.plot          bg.dl         bg.val        bg.unit        pH.surf 
##           1330           1796           1704           1796           1796 
##      soil.temp    soil.temp.z soil.temp.surf            rad            MOL 
##            378            378            378            378              5 
##          ustar             rl  air.pres.unit             rh        far.loc 
##              5             11            467            378            378 
##      notes.int       pub.info     soil.type2         exper2           rep2 
##           1412           1796           1796           1796           1796

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

Manure and application

institute proj exper field plot man.dm man.ph man.tan app.rate tan.app
AU eGylle eGylle1 FoulumgårdD 1 5.31 7.7 1.900 35.9 68.210
AU eGylle eGylle2 FoulumgårdD 1 4.95 7.9 1.950 35.9 70.005
AU eGylle eGylle3 WUR 1 6.78 7.7 1.726 17.5 30.205
AU eGylle eGylle4 FoulumgårdD 1 4.47 7.9 1.720 35.9 61.748

10. dfsumm summary

Plot-level data

## 
##  4 rows and 224 columns
##  4 unique rows
##                     pub.id
## Class              logical
## Minimum               <NA>
## Maximum               <NA>
## Mean                  <NA>
## Unique (excld. NA)       0
## Missing values           4
## Sorted                <NA>
##                           
##                                                                                                                                                                                  cpmid
## Class                                                                                                                                                                        character
## Minimum            D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_eGylle_JK_3.xlsx.E:eGylle1.F:FoulumgårdD.P:1.T:eGylle_bLS.R:1.R2:.T:2021-08-11 16:20:00.M:bLSNA
## Maximum            D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_eGylle_JK_3.xlsx.E:eGylle4.F:FoulumgårdD.P:1.T:eGylle_bLS.R:1.R2:.T:2022-01-05 14:23:00.M:bLSNA
## Mean                                                                                                                                                                              <NA>
## Unique (excld. NA)                                                                                                                                                                   4
## Missing values                                                                                                                                                                       0
## Sorted                                                                                                                                                                            TRUE
##                                                                                                                                                                                       
##                         proj     exper       field    plot     rep plot.area
## Class              character character   character numeric numeric   numeric
## Minimum               eGylle   eGylle1 FoulumgårdD       1       1       336
## Maximum               eGylle   eGylle4         WUR       1       1      1540
## Mean                    <NA>      <NA>        <NA>       1       1       811
## Unique (excld. NA)         1         4           2       1       1         4
## Missing values             0         0           0       0       0         0
## Sorted                  TRUE      TRUE       FALSE    TRUE    TRUE     FALSE
##                                                                             
##                        lat    long   country      topo    clay    silt    sand
## Class              numeric numeric character character numeric numeric numeric
## Minimum                 52    5.65        DK      Flat       9      24      65
## Maximum               56.5    9.56        NL      Flat      16      24      65
## Mean                  55.4    8.58      <NA>      <NA>    10.8      24      65
## Unique (excld. NA)       2       2         2         1       2       1       1
## Missing values           0       0         0         0       0       1       1
## Sorted               FALSE   FALSE     FALSE      TRUE   FALSE    TRUE    TRUE
##                                                                               
##                         oc soil.type soil.water soil.water.v soil.moist soil.ph
## Class              numeric   logical    numeric      logical  character numeric
## Minimum                3.5      <NA>       0.21         <NA>        wet    5.24
## Maximum                3.5      <NA>       0.49         <NA>        wet    5.55
## Mean                   3.5      <NA>        0.3         <NA>       <NA>    5.43
## Unique (excld. NA)       1         0          3            0          1       3
## Missing values           3         4          0            4          3       1
## Sorted                TRUE      <NA>      FALSE         <NA>       TRUE   FALSE
##                                                                                
##                    soil.dens  crop.res      till man.source
## Class                numeric character character  character
## Minimum                 0.98       Yes        No        cat
## Maximum                 1.38       Yes        No        mix
## Mean                    1.28      <NA>      <NA>       <NA>
## Unique (excld. NA)         2         1         1          2
## Missing values             0         0         0          0
## Sorted                 FALSE      TRUE      TRUE      FALSE
##                                                            
##                                                                  man.source.det
## Class                                                                 character
## Minimum            Primarily cattle slurry, but also some pig slurry and silage
## Maximum            Primarily cattle slurry, but also some pig slurry and silage
## Mean                                                                       <NA>
## Unique (excld. NA)                                                            1
## Missing values                                                                1
## Sorted                                                                     TRUE
##                                                                                
##                    man.bed   man.con            man.trt1 man.trt2 man.trt3
## Class              logical character           character  logical  logical
## Minimum               <NA>    Slurry Anaerobic digestion     <NA>     <NA>
## Maximum               <NA>    Slurry                None     <NA>     <NA>
## Mean                  <NA>      <NA>                <NA>     <NA>     <NA>
## Unique (excld. NA)       0         1                   2        0        0
## Missing values           4         0                   0        4        4
## Sorted                <NA>      TRUE               FALSE     <NA>     <NA>
##                                                                           
##                    man.stor  man.dm  man.vs man.tkn man.tan man.tic  man.ua
## Class               logical numeric logical numeric numeric logical logical
## Minimum                <NA>    4.47    <NA>    2.49    1.72    <NA>    <NA>
## Maximum                <NA>    6.78    <NA>    3.48    1.95    <NA>    <NA>
## Mean                   <NA>    5.38    <NA>    2.89    1.82    <NA>    <NA>
## Unique (excld. NA)        0       4       0       3       4       0       0
## Missing values            4       0       4       0       0       4       4
## Sorted                 <NA>   FALSE    <NA>   FALSE   FALSE    <NA>    <NA>
##                                                                            
##                    man.vfa  man.ph           app.start             app.end
## Class              numeric numeric     POSIXct, POSIXt     POSIXct, POSIXt
## Minimum               0.16     7.7 2021-08-11 16:20:00 2021-08-11 16:20:00
## Maximum               0.51     7.9 2022-01-05 14:23:00 2022-01-05 14:23:00
## Mean                 0.323     7.8 2021-10-12 00:59:00 2021-10-12 01:00:15
## Unique (excld. NA)       3       2                   4                   4
## Missing values           1       0                   0                   0
## Sorted               FALSE   FALSE                TRUE                TRUE
##                                                                           
##                    app.method app.rate app.rate.unit    incorp time.incorp
## Class               character  numeric     character character     numeric
## Minimum                  bsth     17.5          t/ha      none        <NA>
## Maximum                    os     35.9          t/ha      none        <NA>
## Mean                     <NA>     31.3          <NA>      <NA>        <NA>
## Unique (excld. NA)          2        2             1         1           0
## Missing values              0        0             0         0           4
## Sorted                  FALSE    FALSE          TRUE      TRUE        <NA>
##                                                                           
##                    man.area dist.inj furrow.z furrow.w      crop  crop.z
## Class               numeric  logical  logical  logical character numeric
## Minimum                  27     <NA>     <NA>     <NA>     grass       7
## Maximum                  40     <NA>     <NA>     <NA>   stubble     7.6
## Mean                   33.5     <NA>     <NA>     <NA>      <NA>    7.15
## Unique (excld. NA)        2        0        0        0         2       2
## Missing values            2        4        4        4         0       0
## Sorted                FALSE     <NA>     <NA>     <NA>     FALSE   FALSE
##                                                                         
##                    crop.area     lai notes.plot row.in.file.plot institute
## Class                numeric logical  character          numeric character
## Minimum                 <NA>    <NA>          .                5        AU
## Maximum                 <NA>    <NA>          .                8        AU
## Mean                    <NA>    <NA>       <NA>              6.5      <NA>
## Unique (excld. NA)         0       0          1                4         1
## Missing values             4       4          3                0         0
## Sorted                  <NA>    <NA>       TRUE             TRUE      TRUE
##                                                                           
##                    sub.period
## Class                 numeric
## Minimum                     3
## Maximum                     3
## Mean                        3
## Unique (excld. NA)          1
## Missing values              0
## Sorted                   TRUE
##                              
##                                                                               file
## Class                                                                    character
## Minimum            ../../data-submitted/03/AU/ALFAM2_template_6_1_eGylle_JK_3.xlsx
## Maximum            ../../data-submitted/03/AU/ALFAM2_template_6_1_eGylle_JK_3.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            eGylle_bLS       bLS          <NA> 09/11/2021 10:15
## Maximum            eGylle_bLS       bLS          <NA>  5/01/2022 14:23
## Mean                     <NA>      <NA>          <NA>             <NA>
## Unique (excld. NA)          1         1             0                4
## Missing values              0         0             4                0
## Sorted                   TRUE      TRUE          <NA>            FALSE
##                                                                       
##                        app.end.orig
## Class                     character
## Minimum            09/11/2021 10:20
## Maximum             5/01/2022 14:23
## Mean                           <NA>
## Unique (excld. NA)                4
## Missing values                    0
## Sorted                        FALSE
##                                    
##                                                                                                                                                                           cpid
## Class                                                                                                                                                                character
## Minimum            D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_eGylle_JK_3.xlsx.E:eGylle1.F:FoulumgårdD.P:1.T:eGylle_bLS.R:1.R2:.T:2021-08-11 16:20:00
## Maximum            D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_eGylle_JK_3.xlsx.E:eGylle4.F:FoulumgårdD.P:1.T:eGylle_bLS.R:1.R2:.T:2022-01-05 14:23:00
## Mean                                                                                                                                                                      <NA>
## Unique (excld. NA)                                                                                                                                                           4
## Missing values                                                                                                                                                               0
## Sorted                                                                                                                                                                    TRUE
##                                                                                                                                                                               
##                                            ceid flag.plot          submitter
## Class                                 character character          character
## Minimum            D:1.I:AU.Pr:eGylle.E:eGylle1           Jesper Nørlem Kamp
## Maximum            D:1.I:AU.Pr:eGylle.E:eGylle4           Jesper Nørlem Kamp
## Mean                                       <NA>      <NA>               <NA>
## Unique (excld. NA)                            4         1                  1
## Missing values                                0         0                  0
## Sorted                                     TRUE      TRUE               TRUE
##                                                                             
##                    tan.app      e.1      e.4      e.6    e.12    e.24    e.48
## Class              numeric  numeric  numeric  numeric numeric numeric numeric
## Minimum               30.2 -0.00214 -0.00248 -0.00484 -0.0127 0.00935    2.26
## Maximum                 70  0.00235     4.65     10.8    20.2    22.6    27.1
## Mean                  57.5 0.000324     1.16      2.7    5.06    5.97    10.3
## Unique (excld. NA)       4        4        4        4       4       4       4
## Missing values           0        0        0        0       0       0       0
## Sorted               FALSE    FALSE    FALSE    FALSE   FALSE   FALSE   FALSE
##                                                                              
##                       e.72    e.96   e.168 e.final   e.tot  e.cum.1  e.cum.4
## Class              numeric numeric numeric numeric numeric  numeric  numeric
## Minimum               2.81    3.36    3.83    3.88    3.88 -0.00214 -0.00248
## Maximum               30.8    32.3    34.8    35.9    35.9  0.00235     4.65
## Mean                  14.1    15.4    16.7    17.2    17.2 0.000324     1.16
## Unique (excld. NA)       4       4       4       4       4        4        4
## Missing values           0       0       0       0       0        0        0
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE    FALSE    FALSE
##                                                                             
##                     e.cum.6 e.cum.12 e.cum.24 e.cum.48 e.cum.72 e.cum.96
## Class               numeric  numeric  numeric  numeric  numeric  numeric
## Minimum            -0.00484  -0.0127  0.00935     2.26     2.81     3.36
## Maximum                10.8     20.2     22.6     27.1     30.8     32.3
## Mean                    2.7     5.06     5.97     10.3     14.1     15.4
## Unique (excld. NA)        4        4        4        4        4        4
## Missing values            0        0        0        0        0        0
## Sorted                FALSE    FALSE    FALSE    FALSE    FALSE    FALSE
##                                                                         
##                    e.cum.168 e.cum.final e.cum.tot   e.rel.1   e.rel.4  e.rel.6
## Class                numeric     numeric   numeric   numeric   numeric  numeric
## Minimum                 3.83        3.88      3.88 -3.13e-05 -8.21e-05 -0.00016
## Maximum                 34.8        35.9      35.9  3.36e-05    0.0664    0.154
## Mean                    16.7        17.2      17.2  9.79e-07    0.0166   0.0385
## Unique (excld. NA)         4           4         4         4         4        4
## Missing values             0           0         0         0         0        0
## Sorted                 FALSE       FALSE     FALSE     FALSE     FALSE    FALSE
##                                                                                
##                     e.rel.12 e.rel.24 e.rel.48 e.rel.72 e.rel.96 e.rel.168
## Class                numeric  numeric  numeric  numeric  numeric   numeric
## Minimum            -0.000421 0.000137   0.0662   0.0931    0.111     0.127
## Maximum                0.289    0.323    0.387     0.44    0.462     0.497
## Mean                  0.0723     0.09    0.161    0.221    0.242     0.263
## Unique (excld. NA)         4        4        4        4        4         4
## Missing values             0        0        0        0        0         0
## Sorted                 FALSE    FALSE    FALSE    FALSE    FALSE     FALSE
##                                                                           
##                    e.rel.final e.rel.tot  rain.1  rain.4  rain.6 rain.12
## Class                  numeric   numeric numeric numeric numeric numeric
## Minimum                  0.128     0.128       0       0       0       0
## Maximum                  0.512     0.512       0     0.5     0.5     0.8
## Mean                     0.271     0.271       0   0.125   0.125     0.2
## Unique (excld. NA)           4         4       1       2       2       2
## Missing values               0         0       0       0       0       0
## Sorted                   FALSE     FALSE    TRUE    TRUE    TRUE    TRUE
##                                                                         
##                    rain.24 rain.48 rain.72 rain.96 rain.168 rain.final rain.tot
## Class              numeric numeric numeric numeric  numeric    numeric  numeric
## Minimum                  0       0       0       0      0.5        0.6      0.6
## Maximum                4.3     5.3     5.5     8.2     24.6       29.8     29.8
## Mean                  2.12     2.4    2.78    3.53     11.4       13.4     13.4
## Unique (excld. NA)       4       4       4       4        4          4        4
## Missing values           0       0       0       0        0          0        0
## Sorted               FALSE   FALSE   FALSE   FALSE    FALSE      FALSE    FALSE
##                                                                                
##                    air.temp.1 air.temp.4 air.temp.6 air.temp.12 air.temp.24
## Class                 numeric    numeric    numeric     numeric     numeric
## Minimum                   2.9       2.22       1.98        1.77        1.77
## Maximum                  18.8       17.2       16.1        15.9        15.2
## Mean                     11.3       10.9       10.5        9.66        9.32
## Unique (excld. NA)          4          4          4           4           4
## Missing values              0          0          0           0           0
## Sorted                  FALSE      FALSE      FALSE       FALSE       FALSE
##                                                                            
##                    air.temp.48 air.temp.72 air.temp.96 air.temp.168 air.temp.mn
## Class                  numeric     numeric     numeric      numeric     numeric
## Minimum                  0.466       0.795       0.934         1.08        3.36
## Maximum                   15.3        15.9        16.3         15.7        21.3
## Mean                      8.96        9.31        9.56         9.74        13.5
## Unique (excld. NA)           4           4           4            4           4
## Missing values               0           0           0            0           0
## Sorted                   FALSE       FALSE       FALSE        FALSE       FALSE
##                                                                                
##                    soil.temp.1 soil.temp.4 soil.temp.6 soil.temp.12
## Class                  numeric     numeric     numeric      numeric
## Minimum                    5.2        5.14        5.11         4.95
## Maximum                   16.9          17        16.9         16.6
## Mean                      12.3        12.3        12.3         12.3
## Unique (excld. NA)           3           3           3            3
## Missing values               1           1           1            1
## Sorted                   FALSE       FALSE       FALSE        FALSE
##                                                                    
##                    soil.temp.24 soil.temp.48 soil.temp.72 soil.temp.96
## Class                   numeric      numeric      numeric      numeric
## Minimum                     4.7         4.21         3.67         3.48
## Maximum                    16.4         16.4         16.5         16.6
## Mean                       12.1         11.9         11.8         11.8
## Unique (excld. NA)            3            3            3            3
## Missing values                1            1            1            1
## Sorted                    FALSE        FALSE        FALSE        FALSE
##                                                                       
##                    soil.temp.168 soil.temp.mn soil.temp.surf.1 soil.temp.surf.4
## Class                    numeric      numeric          numeric          numeric
## Minimum                     3.22         4.83             2.62             1.72
## Maximum                     16.6         22.6             19.2             16.6
## Mean                        11.7         16.6             11.9             11.4
## Unique (excld. NA)             3            3                3                3
## Missing values                 1            1                1                1
## Sorted                     FALSE        FALSE            FALSE            FALSE
##                                                                                
##                    soil.temp.surf.6 soil.temp.surf.12 soil.temp.surf.24
## Class                       numeric           numeric           numeric
## Minimum                        1.37              1.13              1.34
## Maximum                        16.2              16.5              15.2
## Mean                           10.9              10.4              9.91
## Unique (excld. NA)                3                 3                 3
## Missing values                    1                 1                 1
## Sorted                        FALSE             FALSE             FALSE
##                                                                        
##                    soil.temp.surf.48 soil.temp.surf.72 soil.temp.surf.96
## Class                        numeric           numeric           numeric
## Minimum                       -0.581           -0.0816             0.131
## Maximum                         15.3              15.8              16.1
## Mean                            9.25               9.6              9.99
## Unique (excld. NA)                 3                 3                 3
## Missing values                     1                 1                 1
## Sorted                         FALSE             FALSE             FALSE
##                                                                         
##                    soil.temp.surf.168 soil.temp.surf.mn  wind.1  wind.4  wind.6
## Class                         numeric           numeric numeric numeric numeric
## Minimum                         0.453              2.59    1.03    0.72   0.764
## Maximum                          15.6              21.1    2.22    2.54    2.61
## Mean                             10.1              14.9    1.84    1.69     1.7
## Unique (excld. NA)                  3                 3       4       4       4
## Missing values                      1                 1       0       0       0
## Sorted                          FALSE             FALSE   FALSE   FALSE   FALSE
##                                                                                
##                    wind.12 wind.24 wind.48 wind.72 wind.96 wind.168 wind.mn
## Class              numeric numeric numeric numeric numeric  numeric numeric
## Minimum              0.823    1.31    1.29    1.25    1.29     1.65     1.8
## Maximum               2.87     2.7    2.06    2.24    2.27     2.38    3.88
## Mean                  1.88    1.84    1.56    1.57    1.63     1.98       3
## Unique (excld. NA)       4       4       4       4       4        4       4
## Missing values           0       0       0       0       0        0       0
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE    FALSE   FALSE
##                                                                            
##                    wind.2m.1 wind.2m.4 wind.2m.6 wind.2m.12 wind.2m.24
## Class                numeric   numeric   numeric    numeric    numeric
## Minimum                 1.03      0.72     0.764      0.823       1.31
## Maximum                 2.22      2.54      2.61       2.87        2.7
## Mean                    1.84      1.69       1.7       1.88       1.84
## Unique (excld. NA)         4         4         4          4          4
## Missing values             0         0         0          0          0
## Sorted                 FALSE     FALSE     FALSE      FALSE      FALSE
##                                                                       
##                    wind.2m.48 wind.2m.72 wind.2m.96 wind.2m.168 wind.2m.mn
## Class                 numeric    numeric    numeric     numeric    numeric
## Minimum                  1.29       1.25       1.29        1.65        1.8
## Maximum                  2.06       2.24       2.27        2.38       3.88
## Mean                     1.56       1.57       1.63        1.98          3
## Unique (excld. NA)          4          4          4           4          4
## Missing values              0          0          0           0          0
## Sorted                  FALSE      FALSE      FALSE       FALSE      FALSE
##                                                                           
##                      rad.1   rad.4   rad.6  rad.12  rad.24  rad.48  rad.72
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum               65.6    20.6    13.7    6.91    15.8    26.1    23.3
## Maximum                200     324     321     321     171     169     184
## Mean                   154     142     130     119     107     121     124
## Unique (excld. NA)       3       3       3       3       3       3       3
## Missing values           1       1       1       1       1       1       1
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                           
##                     rad.96 rad.168  rad.mn rain.rate.1 rain.rate.4 rain.rate.6
## Class              numeric numeric numeric     numeric     numeric     numeric
## Minimum               22.2    18.1      24           0           0           0
## Maximum                198     176     222           0       0.125      0.0833
## Mean                   127     115     150           0      0.0312      0.0208
## Unique (excld. NA)       3       3       3           1           2           2
## Missing values           1       1       1           0           0           0
## Sorted               FALSE   FALSE   FALSE        TRUE        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.0667        0.179         0.11       0.0764
## Mean                     0.0167       0.0885         0.05       0.0385
## Unique (excld. NA)            2            4            4            4
## Missing values                0            0            0            0
## Sorted                     TRUE        FALSE        FALSE        FALSE
##                                                                       
##                    rain.rate.96 rain.rate.168 rain.rate.mn    rh.1    rh.4
## Class                   numeric       numeric      numeric numeric numeric
## Minimum                       0       0.00298      0.00357    60.5    68.1
## Maximum                  0.0854         0.146        0.177      84      87
## Mean                     0.0367         0.068       0.0798    74.9    75.9
## Unique (excld. NA)            4             4            4       3       3
## Missing values                0             0            0       1       1
## Sorted                    FALSE         FALSE        FALSE    TRUE    TRUE
##                                                                           
##                       rh.6   rh.12   rh.24   rh.48   rh.72   rh.96  rh.168
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum               70.2    65.1      75    74.8    74.8    74.5    73.8
## Maximum               87.6    87.9    90.2    86.2    87.2    88.4    89.8
## Mean                    77    78.1    82.8    81.4    81.2    81.2    81.5
## Unique (excld. NA)       3       3       3       3       3       3       3
## Missing values           1       1       1       1       1       1       1
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                           
##                      rh.mn first.row.in.file.int last.row.in.file.int  n.ints
## Class              numeric               numeric              numeric integer
## Minimum                110                     5                  470     378
## Maximum                125                  1330                 1800     484
## Mean                   116                   691                 1140     449
## Unique (excld. NA)       3                     4                    4       4
## Missing values           1                     0                    0       0
## Sorted               FALSE                  TRUE                 TRUE   FALSE
##                                                                              
##                        dt1    j.rel1   j.NH31  dt.min  dt.max  ct.min  ct.max
## Class              numeric   numeric  numeric numeric numeric numeric numeric
## Minimum                0.5 -4.15e-05 -0.00283   0.167     0.5     0.5     189
## Maximum                0.5  3.51e-05  0.00245     0.5     0.5     0.5     242
## Mean                   0.5   9.7e-07 0.000218   0.417     0.5     0.5     224
## Unique (excld. NA)       1         4        4       2       1       1       4
## Missing values           0         0        0       0       0       0       0
## Sorted                TRUE     FALSE    FALSE    TRUE    TRUE    TRUE   FALSE
##                                                                              
##                              t.start.p             t.end.p air.temp.z
## Class                  POSIXct, POSIXt     POSIXct, POSIXt    numeric
## Minimum            2021-08-09 18:00:00 2021-08-19 10:00:00          2
## Maximum            2022-01-04 15:00:00 2022-01-14 08:30:00          2
## Mean               2021-10-11 02:22:30 2021-10-20 10:15:00          2
## Unique (excld. NA)                   4                   4          1
## Missing values                       0                   0          0
## Sorted                            TRUE                TRUE       TRUE
##                                                                      
##                    soil.temp.z  wind.z  wind.loc far.loc pub.info soil.type2
## Class                  numeric numeric character numeric  logical    logical
## Minimum                    0.1       2     Field    5000     <NA>       <NA>
## Maximum                    0.1       2     Field    5000     <NA>       <NA>
## Mean                       0.1       2      <NA>    5000     <NA>       <NA>
## Unique (excld. NA)           1       1         1       1        0          0
## Missing values               1       0         0       1        4          4
## Sorted                    TRUE    TRUE      TRUE    TRUE     <NA>       <NA>
##                                                                             
##                     exper2    rep2    acid meas.tech.orig meas.tech2 crop.orig
## Class              logical logical logical      character  character character
## Minimum               <NA>    <NA>   FALSE            bLS  micro met     Grass
## Maximum               <NA>    <NA>   FALSE            bLS  micro met   Stubble
## Mean                  <NA>    <NA>  0 TRUE           <NA>       <NA>      <NA>
## Unique (excld. NA)       0       0       1              1          1         2
## Missing values           4       4       0              0          0         0
## Sorted                <NA>    <NA>    TRUE           TRUE       TRUE     FALSE
##                                                                               
##                    man.source.orig              app.method.orig app.method2
## Class                    character                    character   character
## Minimum                     Cattle Band spread or trailing hose        bsth
## Maximum                        Mix          Open slot injection          os
## Mean                          <NA>                         <NA>        <NA>
## Unique (excld. NA)               2                            2           2
## Missing values                   0                            0           0
## Sorted                       FALSE                        FALSE       FALSE
##                                                                            
##                    incorp.orig date.start
## Class                character       Date
## Minimum                   None 2021-08-09
## Maximum                   None 2022-01-04
## Mean                      <NA>       <NA>
## Unique (excld. NA)           1          4
## Missing values               0          0
## Sorted                    TRUE       TRUE
## 

Interval-level emission data

## 
##  1796 rows and 137 columns
##  1796 unique rows
##                                                                                                                                                                                  cpmid
## Class                                                                                                                                                                        character
## Minimum            D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_eGylle_JK_3.xlsx.E:eGylle1.F:FoulumgårdD.P:1.T:eGylle_bLS.R:1.R2:.T:2021-08-11 16:20:00.M:bLSNA
## Maximum            D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_eGylle_JK_3.xlsx.E:eGylle4.F:FoulumgårdD.P:1.T:eGylle_bLS.R:1.R2:.T:2022-01-05 14:23:00.M:bLSNA
## Mean                                                                                                                                                                              <NA>
## Unique (excld. NA)                                                                                                                                                                   4
## Missing values                                                                                                                                                                       0
## Sorted                                                                                                                                                                            TRUE
##                                                                                                                                                                                       
##                     pub.id      proj     exper       field    plot     rep
## Class              logical character character   character numeric numeric
## Minimum               <NA>    eGylle   eGylle1 FoulumgårdD       1       1
## Maximum               <NA>    eGylle   eGylle4         WUR       1       1
## Mean                  <NA>      <NA>      <NA>        <NA>       1       1
## Unique (excld. NA)       0         1         4           2       1       1
## Missing values        1796         0         0           0       0       0
## Sorted                <NA>      TRUE      TRUE       FALSE    TRUE    TRUE
##                                                                           
##                         treat meas.tech meas.tech.det plot.area     lat    long
## Class               character character       logical   numeric numeric numeric
## Minimum            eGylle_bLS       bLS          <NA>       336      52    5.65
## Maximum            eGylle_bLS       bLS          <NA>      1540    56.5    9.56
## Mean                     <NA>      <NA>          <NA>       775    55.5    8.74
## Unique (excld. NA)          1         1             0         4       2       2
## Missing values              0         0          1796         0       0       0
## Sorted                   TRUE      TRUE          <NA>     FALSE   FALSE   FALSE
##                                                                                
##                      country      topo    clay    silt    sand      oc
## Class              character character numeric numeric numeric numeric
## Minimum                   DK      Flat       9      24      65     3.5
## Maximum                   NL      Flat      16      24      65     3.5
## Mean                    <NA>      <NA>    10.5      24      65     3.5
## Unique (excld. NA)         2         1       2       1       1       1
## Missing values             0         0       0     378     378    1418
## Sorted                 FALSE      TRUE   FALSE    TRUE    TRUE    TRUE
##                                                                       
##                    soil.type soil.water soil.water.v soil.moist soil.ph
## Class                logical    numeric      logical  character numeric
## Minimum                 <NA>       0.21         <NA>        wet    5.24
## Maximum                 <NA>       0.49         <NA>        wet    5.55
## Mean                    <NA>       0.29         <NA>       <NA>    5.42
## Unique (excld. NA)         0          3            0          1       3
## Missing values          1796          0         1796       1418     468
## Sorted                  <NA>      FALSE         <NA>       TRUE   FALSE
##                                                                        
##                    soil.dens  crop.res      till man.source
## Class                numeric character character  character
## Minimum                 0.98       Yes        No        cat
## Maximum                 1.38       Yes        No        mix
## Mean                     1.3      <NA>      <NA>       <NA>
## Unique (excld. NA)         2         1         1          2
## Missing values             0         0         0          0
## Sorted                 FALSE      TRUE      TRUE      FALSE
##                                                            
##                                                                  man.source.det
## Class                                                                 character
## Minimum            Primarily cattle slurry, but also some pig slurry and silage
## Maximum            Primarily cattle slurry, but also some pig slurry and silage
## Mean                                                                       <NA>
## Unique (excld. NA)                                                            1
## Missing values                                                              378
## Sorted                                                                     TRUE
##                                                                                
##                    man.bed   man.con            man.trt1 man.trt2 man.trt3
## Class              logical character           character  logical  logical
## Minimum               <NA>    Slurry Anaerobic digestion     <NA>     <NA>
## Maximum               <NA>    Slurry                None     <NA>     <NA>
## Mean                  <NA>      <NA>                <NA>     <NA>     <NA>
## Unique (excld. NA)       0         1                   2        0        0
## Missing values        1796         0                   0     1796     1796
## Sorted                <NA>      TRUE               FALSE     <NA>     <NA>
##                                                                           
##                    man.stor  man.dm  man.vs man.tkn man.tan man.tic  man.ua
## Class               logical numeric logical numeric numeric logical logical
## Minimum                <NA>    4.47    <NA>    2.49    1.72    <NA>    <NA>
## Maximum                <NA>    6.78    <NA>    3.48    1.95    <NA>    <NA>
## Mean                   <NA>     5.3    <NA>    2.86    1.83    <NA>    <NA>
## Unique (excld. NA)        0       4       0       3       4       0       0
## Missing values         1796       0    1796       0       0    1796    1796
## Sorted                 <NA>   FALSE    <NA>   FALSE   FALSE    <NA>    <NA>
##                                                                            
##                    man.vfa  man.ph           app.start             app.end
## Class              numeric numeric     POSIXct, POSIXt     POSIXct, POSIXt
## Minimum               0.16     7.7 2021-08-11 16:20:00 2021-08-11 16:20:00
## Maximum               0.51     7.9 2022-01-05 14:23:00 2022-01-05 14:23:00
## Mean                 0.323    7.81 2021-10-10 05:14:28 2021-10-10 05:15:31
## Unique (excld. NA)       3       2                   4                   4
## Missing values         378       0                   0                   0
## Sorted               FALSE   FALSE                TRUE                TRUE
##                                                                           
##                    app.method app.rate app.rate.unit    incorp time.incorp
## Class               character  numeric     character character     numeric
## Minimum                  bsth     17.5          t/ha      none        <NA>
## Maximum                    os     35.9          t/ha      none        <NA>
## Mean                     <NA>       32          <NA>      <NA>        <NA>
## Unique (excld. NA)          2        2             1         1           0
## Missing values              0        0             0         0        1796
## Sorted                  FALSE    FALSE          TRUE      TRUE        <NA>
##                                                                           
##                    man.area dist.inj furrow.z furrow.w      crop  crop.z
## Class               numeric  logical  logical  logical character numeric
## Minimum                  27     <NA>     <NA>     <NA>     grass       7
## Maximum                  40     <NA>     <NA>     <NA>   stubble     7.6
## Mean                   34.3     <NA>     <NA>     <NA>      <NA>    7.13
## Unique (excld. NA)        2        0        0        0         2       2
## Missing values          934     1796     1796     1796         0       0
## Sorted                FALSE     <NA>     <NA>     <NA>     FALSE   FALSE
##                                                                         
##                    crop.area     lai notes.plot row.in.file.plot institute
## Class                numeric logical  character          numeric character
## Minimum                 <NA>    <NA>          .                5        AU
## Maximum                 <NA>    <NA>          .                8        AU
## Mean                    <NA>    <NA>       <NA>             6.47      <NA>
## Unique (excld. NA)         0       0          1                4         1
## Missing values          1796    1796       1330                0         0
## Sorted                  <NA>    <NA>       TRUE             TRUE      TRUE
##                                                                           
##                    sub.period
## Class                 numeric
## Minimum                     3
## Maximum                     3
## Mean                        3
## Unique (excld. NA)          1
## Missing values              0
## Sorted                   TRUE
##                              
##                                                                               file
## Class                                                                    character
## Minimum            ../../data-submitted/03/AU/ALFAM2_template_6_1_eGylle_JK_3.xlsx
## Maximum            ../../data-submitted/03/AU/ALFAM2_template_6_1_eGylle_JK_3.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 10:15 09/11/2021 10:20
## Maximum             5/01/2022 14:23  5/01/2022 14:23
## Mean                           <NA>             <NA>
## Unique (excld. NA)                4                4
## 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_eGylle_JK_3.xlsx.E:eGylle1.F:FoulumgårdD.P:1.T:eGylle_bLS.R:1.R2:.T:2021-08-11 16:20:00
## Maximum            D:1.I:AU.Pr:eGylle.F:../../data-submitted/03/AU/ALFAM2_template_6_1_eGylle_JK_3.xlsx.E:eGylle4.F:FoulumgårdD.P:1.T:eGylle_bLS.R:1.R2:.T:2022-01-05 14:23:00
## Mean                                                                                                                                                                      <NA>
## Unique (excld. NA)                                                                                                                                                           4
## Missing values                                                                                                                                                               0
## Sorted                                                                                                                                                                    TRUE
##                                                                                                                                                                               
##                                            ceid flag.plot          submitter
## Class                                 character character          character
## Minimum            D:1.I:AU.Pr:eGylle.E:eGylle1           Jesper Nørlem Kamp
## Maximum            D:1.I:AU.Pr:eGylle.E:eGylle4           Jesper Nørlem Kamp
## Mean                                       <NA>      <NA>               <NA>
## Unique (excld. NA)                            4         1                  1
## Missing values                                0         0                  0
## Sorted                                     TRUE      TRUE               TRUE
##                                                                             
##                    tan.app interval             t.start               t.end
## Class              numeric  numeric     POSIXct, POSIXt     POSIXct, POSIXt
## Minimum               30.2        1 2021-08-09 18:00:00 2021-08-09 18:30:00
## Maximum                 70      484 2022-01-14 08:30:00 2022-01-14 09:00:00
## Mean                    59      227 2021-10-13 23:26:59 2021-10-13 23:56:58
## Unique (excld. NA)       4      484                1796                1796
## Missing values           0        0                   0                   0
## Sorted               FALSE    FALSE                TRUE                TRUE
##                                                                            
##                         dt   bg.dl  bg.val bg.unit   j.NH3 j.NH3.unit pH.surf
## Class              numeric logical numeric logical numeric  character logical
## Minimum              0.167    <NA>  -0.752    <NA> -0.0223 kg N/ha-hr    <NA>
## Maximum                0.5    <NA>   0.746    <NA>    5.11 kg N/ha-hr    <NA>
## Mean                   0.5    <NA>  0.0261    <NA>  0.0775       <NA>    <NA>
## Unique (excld. NA)       3       0      92       0    1796          1       0
## Missing values           0    1796    1704    1796       0          0    1796
## Sorted               FALSE    <NA>   FALSE    <NA>   FALSE       TRUE    <NA>
##                                                                              
##                    air.temp air.temp.z soil.temp soil.temp.z soil.temp.surf
## Class               numeric    numeric   numeric     numeric        numeric
## Minimum                -3.4          2       2.5         0.1           -6.7
## Maximum                22.3          2      17.6         0.1           24.6
## Mean                   10.1          2      11.8         0.1           10.6
## Unique (excld. NA)      791          1       141           1            482
## Missing values            0          0       378         378            378
## Sorted                FALSE       TRUE     FALSE        TRUE          FALSE
##                                                                            
##                        rad    wind  wind.z     MOL   ustar       rl air.pres
## Class              numeric numeric numeric numeric numeric  numeric  numeric
## Minimum                  0  0.0765       2  -18700 0.00858 4.51e-08      974
## Maximum                784    7.49       2   67700   0.856    0.714   104000
## Mean                   107    2.25       2    95.7    0.22   0.0397    22500
## Unique (excld. NA)     749    1792       1    1673    1790     1744     1004
## Missing values         378       0       0       5       5       11        0
## Sorted               FALSE   FALSE    TRUE   FALSE   FALSE    FALSE    FALSE
##                                                                             
##                    air.pres.unit    rain      rh  wind.loc far.loc
## Class                  character numeric numeric character numeric
## Minimum                      hPa       0    45.1     Field    5000
## Maximum                       Pa     4.2    96.3     Field    5000
## Mean                        <NA>  0.0298    82.3      <NA>    5000
## Unique (excld. NA)             2      21     617         1       1
## Missing values               467       0     378         0     378
## Sorted                     FALSE   FALSE   FALSE      TRUE    TRUE
##                                                                   
##                                           notes.int row.in.file.int
## Class                                     character         numeric
## Minimum            Interpolated emission rate value               5
## Maximum            Interpolated emission rate value            1800
## Mean                                           <NA>             902
## Unique (excld. NA)                                1            1796
## Missing values                                 1412               0
## Sorted                                         TRUE            TRUE
##                                                                    
##                           j.type   t.start.orig     t.end.orig j.NH3.unit.orig
## Class                  character      character      character       character
## Minimum            emission rate 10/1/2022 0:00 10/1/2022 0:00     ug NH3/m2/s
## Maximum            emission rate 9/8/2021 23:30 9/8/2021 23:30     ug NH3/m2/s
## Mean                        <NA>           <NA>           <NA>            <NA>
## Unique (excld. NA)             1           1796           1796               1
## Missing values                 0              0              0               0
## Sorted                      TRUE          FALSE          FALSE            TRUE
##                                                                               
##                    j.NH3.orig j.NH3.conv.fact dt.calc   dt.diff      ct      mt
## Class                 numeric         numeric numeric   numeric numeric numeric
## Minimum                -0.752          0.0296   0.167 -3.33e-16     0.5    0.25
## Maximum                   173          0.0296     0.5  3.33e-16     242     242
## Mean                     2.62          0.0296     0.5         0     113     113
## Unique (excld. NA)       1796               1       3         3     485     486
## Missing values              0               0       0         0       0       0
## Sorted                  FALSE            TRUE   FALSE     FALSE   FALSE   FALSE
##                                                                                
##                        cta     bta  flag.int rain.rate rain.cum wind.2m   e.int
## Class              numeric numeric character   numeric  numeric numeric numeric
## Minimum              -45.8   -46.3                   0        0  0.0765 -0.0111
## Maximum                239     239                 8.4     29.8    7.49    2.56
## Mean                  90.7    90.2      <NA>    0.0597     6.71    2.25  0.0383
## Unique (excld. NA)    1796    1796         1        21       89    1792    1796
## Missing values           0       0         0         0        0       0       0
## Sorted               FALSE   FALSE      TRUE     FALSE    FALSE   FALSE   FALSE
##                                                                                
##                      e.cum       e     e.rel     j.rel pub.info soil.type2
## Class              numeric numeric   numeric   numeric  logical    logical
## Minimum            -0.0161 -0.0161 -0.000533 -0.000327     <NA>       <NA>
## Maximum               35.9    35.9     0.512    0.0731     <NA>       <NA>
## Mean                  14.5    14.5     0.223   0.00122     <NA>       <NA>
## Unique (excld. NA)    1796    1796      1796      1796        0          0
## Missing values           0       0         0         0     1796       1796
## Sorted               FALSE   FALSE     FALSE     FALSE     <NA>       <NA>
##                                                                           
##                     exper2    rep2    acid meas.tech.orig meas.tech2 crop.orig
## Class              logical logical logical      character  character character
## Minimum               <NA>    <NA>   FALSE            bLS  micro met     Grass
## Maximum               <NA>    <NA>   FALSE            bLS  micro met   Stubble
## Mean                  <NA>    <NA>  0 TRUE           <NA>       <NA>      <NA>
## Unique (excld. NA)       0       0       1              1          1         2
## Missing values        1796    1796       0              0          0         0
## Sorted                <NA>    <NA>    TRUE           TRUE       TRUE     FALSE
##                                                                               
##                    man.source.orig              app.method.orig app.method2
## Class                    character                    character   character
## Minimum                     Cattle Band spread or trailing hose        bsth
## Maximum                        Mix          Open slot injection          os
## Mean                          <NA>                         <NA>        <NA>
## Unique (excld. NA)               2                            2           2
## Missing values                   0                            0           0
## Sorted                       FALSE                        FALSE       FALSE
##                                                                            
##                    incorp.orig date.start first.row.int row.plot
## Class                character       Date       numeric  numeric
## Minimum                   None 2021-08-09             5        5
## Maximum                   None 2021-08-09          1330        8
## Mean                      <NA>       <NA>           677     6.47
## Unique (excld. NA)           1          1             4        4
## Missing values               0          0             0        0
## Sorted                    TRUE       TRUE          TRUE     TRUE
##                                                                 
##                            first.rows ggplotgroup
## Class                          factor     numeric
## Minimum               Plots 5 Emis. 5           1
## Maximum            Plots 8 Emis. 1333           1
## Mean                Plots 6 Emis. 471           1
## Unique (excld. NA)                  4           1
## Missing values                      0           0
## Sorted                           TRUE        TRUE
##