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:52:24.087175"

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; Kamp, Jesper 1 2023-11-10

2. Contributors

contributor institute
Pedersen, Johanna Aarhus University
Kamp, Jesper Aarhus University
Pacholski, Andreas Thünen Institute
Hafner, Sasha Aarhus University

3. File and directory names

## [1] "../../data-submitted/03/AU"
## [1] "../../data-submitted/03/AU/ALFAM2_template_7.0_DFCtest_JP_231108_JK.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
## 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
## OK

Measurement method and units

Measurement technique:

Method Frequency
bLS 1011
Dynamic chamber 2867
Wind tunnel 71

Measurement technique classification:

Classification Frequency
chamber 2867
micro met 1011
wt 71

Emission units and conversion factors.

Original unit Conversion factor applied Final unit
1 kg N/ha-hr 1.0000000 kg N/ha-hr
543 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 : No values to check.
## 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             oc      soil.type   soil.water.v 
##           3949           3949           3949           3949           3949 
##        soil.ph        man.bed       man.trt2       man.trt3       man.stor 
##           3949           3949           3949           3949           3949 
##         man.vs        man.tic         man.ua        man.vfa    time.incorp 
##           3949           3949           3949           3949           3949 
##       man.area       dist.inj       furrow.z       furrow.w      crop.area 
##           3949           3949           3949           3949           3949 
##            lai     notes.plot          bg.dl        pH.surf      soil.temp 
##           3949           3923           3949           3949           2938 
##    soil.temp.z soil.temp.surf            rad         wind.z            MOL 
##           2938           2938           2938           2938           3090 
##          ustar             rl       air.pres  air.pres.unit             rh 
##           3090           3090           2938           2937           2938 
##        far.loc      notes.int     j.NH3.orig        wind.2m       pub.info 
##           3949           3945            208           2938           3949 
##     soil.type2         exper2           rep2 
##           3949           3949           3949

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

10. dfsumm summary

Plot-level data

## 
##  37 rows and 225 columns
##  37 unique rows
##                     pub.id      proj     exper
## Class              logical character character
## Minimum               <NA>       MAG     testA
## Maximum               <NA>       MAG     testC
## Mean                  <NA>      <NA>      <NA>
## Unique (excld. NA)       0         1         3
## Missing values          37         0         0
## Sorted                <NA>      TRUE      TRUE
##                                               
##                                                                                                                                                                                          cpmid
## Class                                                                                                                                                                                character
## Minimum                      D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_DFCtest_JP_231108_JK.xlsx.E:testA.F:A.P:plot1.T:WT.R:1.R2:.T:2022-10-11 15:24:00.M:Wind tunnelNA
## Maximum            D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_DFCtest_JP_231108_JK.xlsx.E:testC.F:A.P:plot8th.T:DFC_th.R:6.R2:.T:2022-11-24 12:57:00.M:Dynamic chamberNA
## Mean                                                                                                                                                                                      <NA>
## Unique (excld. NA)                                                                                                                                                                          37
## Missing values                                                                                                                                                                               0
## Sorted                                                                                                                                                                                    TRUE
##                                                                                                                                                                                               
##                        field      plot     rep plot.area     lat    long
## Class              character character numeric   numeric numeric numeric
## Minimum                    A     plot1       1       0.2    56.5    9.56
## Maximum                    A     plot9       9       100    56.5    9.56
## Mean                    <NA>      <NA>       4      5.82    56.5    9.56
## Unique (excld. NA)         1        30       9         5       1       1
## Missing values             0         0       0         0       0       0
## Sorted                  TRUE     FALSE   FALSE     FALSE    TRUE    TRUE
##                                                                         
##                      country      topo soil.samp.z    clay    silt    sand
## Class              character character   character numeric numeric numeric
## Minimum                   DK      Flat         0-5       9      24      65
## Maximum                   DK      Flat         0-5       9      24      65
## Mean                    <NA>      <NA>        <NA>       9      24      65
## Unique (excld. NA)         1         1           1       1       1       1
## Missing values             0         0           0       0       0       0
## Sorted                  TRUE      TRUE        TRUE    TRUE    TRUE    TRUE
##                                                                           
##                         oc soil.type soil.water soil.water.v soil.moist soil.ph
## Class              logical   logical    numeric      logical  character logical
## Minimum               <NA>      <NA>       0.19         <NA>        Wet    <NA>
## Maximum               <NA>      <NA>       0.22         <NA>        Wet    <NA>
## Mean                  <NA>      <NA>       0.21         <NA>       <NA>    <NA>
## Unique (excld. NA)       0         0          2            0          1       0
## Missing values          37        37          0           37          0      37
## Sorted                <NA>      <NA>       TRUE         <NA>       TRUE    <NA>
##                                                                                
##                    soil.dens  crop.res      till man.source
## Class                numeric character character  character
## Minimum                  1.3       Yes        No        mix
## Maximum                  1.3       Yes        No        mix
## Mean                     1.3      <NA>      <NA>       <NA>
## Unique (excld. NA)         1         1         1          1
## Missing values             0         0         0          0
## Sorted                  TRUE      TRUE      TRUE       TRUE
##                                                            
##                                                                man.source.det
## Class                                                               character
## Minimum            mix of slurry co-digested with other agricultural residues
## Maximum            mix of slurry co-digested with other agricultural residues
## Mean                                                                     <NA>
## Unique (excld. NA)                                                          1
## Missing values                                                              0
## 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 Anaerobic digestion     <NA>     <NA>
## Mean                  <NA>      <NA>                <NA>     <NA>     <NA>
## Unique (excld. NA)       0         1                   1        0        0
## Missing values          37         0                   0       37       37
## Sorted                <NA>      TRUE                TRUE     <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>    5.03    <NA>    2.61    1.83    <NA>    <NA>
## Maximum                <NA>    5.99    <NA>    2.73       2    <NA>    <NA>
## Mean                   <NA>    5.45    <NA>    2.66    1.93    <NA>    <NA>
## Unique (excld. NA)        0       3       0       3       3       0       0
## Missing values           37       0      37       0       0      37      37
## Sorted                 <NA>   FALSE    <NA>   FALSE   FALSE    <NA>    <NA>
##                                                                            
##                    man.vfa  man.ph           app.start             app.end
## Class              logical numeric     POSIXct, POSIXt     POSIXct, POSIXt
## Minimum               <NA>     7.5 2022-10-11 15:24:00 2022-10-14 04:58:00
## Maximum               <NA>     7.6 2022-11-24 13:30:00 2022-12-02 23:24:00
## Mean                  <NA>    7.54 2022-11-08 03:08:45 2022-11-13 14:21:50
## Unique (excld. NA)       0       2                  37                  37
## Missing values          37       0                   0                   0
## Sorted                <NA>    TRUE               FALSE               FALSE
##                                                                           
##                    app.method app.rate app.rate.unit    incorp time.incorp
## Class               character  numeric     character character     numeric
## Minimum                  bsth       35          t/ha      none        <NA>
## Maximum                    os       45          t/ha      none        <NA>
## Mean                     <NA>     37.4          <NA>      <NA>        <NA>
## Unique (excld. NA)          2        2             1         1           0
## Missing values              0        0             0         0          37
## Sorted                  FALSE    FALSE          TRUE      TRUE        <NA>
##                                                                           
##                    man.area dist.inj furrow.z furrow.w      crop  crop.z
## Class               logical  logical  logical  logical character numeric
## Minimum                <NA>     <NA>     <NA>     <NA>   stubble       8
## Maximum                <NA>     <NA>     <NA>     <NA>   stubble       8
## Mean                   <NA>     <NA>     <NA>     <NA>      <NA>       8
## Unique (excld. NA)        0        0        0        0         1       1
## Missing values           37       37       37       37         0       0
## Sorted                 <NA>     <NA>     <NA>     <NA>      TRUE    TRUE
##                                                                         
##                    crop.area     lai notes.plot row.in.file.plot institute
## Class                numeric logical  character          numeric character
## Minimum                 <NA>    <NA>          .                5        AU
## Maximum                 <NA>    <NA>          .               41        AU
## Mean                    <NA>    <NA>       <NA>               23      <NA>
## Unique (excld. NA)         0       0          1               37         1
## Missing values            37      37         36                0         0
## Sorted                  <NA>    <NA>       TRUE            FALSE      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_7.0_DFCtest_JP_231108_JK.xlsx
## Maximum            ../../data-submitted/03/AU/ALFAM2_template_7.0_DFCtest_JP_231108_JK.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     POSIXct, POSIXt
## Minimum                  bLS         bLS          <NA> 2022-10-11 15:24:00
## Maximum                   WT Wind tunnel          <NA> 2022-11-24 13:30:00
## Mean                    <NA>        <NA>          <NA> 2022-11-08 03:08:45
## Unique (excld. NA)         7           3             0                  37
## Missing values             0           0            37                   0
## Sorted                 FALSE       FALSE          <NA>               FALSE
##                                                                           
##                           app.end.orig
## Class                  POSIXct, POSIXt
## Minimum            2022-10-14 04:58:00
## Maximum            2022-12-02 23:24:00
## Mean               2022-11-13 14:21:50
## Unique (excld. NA)                  37
## Missing values                       0
## Sorted                           FALSE
##                                       
##                                                                                                                                                                       cpid
## Class                                                                                                                                                            character
## Minimum                  D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_DFCtest_JP_231108_JK.xlsx.E:testA.F:A.P:plot1.T:WT.R:1.R2:.T:2022-10-11 15:24:00
## Maximum            D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_DFCtest_JP_231108_JK.xlsx.E:testC.F:A.P:plot8th.T:DFC_th.R:6.R2:.T:2022-11-24 12:57:00
## Mean                                                                                                                                                                  <NA>
## Unique (excld. NA)                                                                                                                                                      37
## Missing values                                                                                                                                                           0
## Sorted                                                                                                                                                                TRUE
##                                                                                                                                                                           
##                                       ceid flag.plot
## Class                            character character
## Minimum            D:1.I:AU.Pr:MAG.E:testA          
## Maximum            D:1.I:AU.Pr:MAG.E:testC          
## Mean                                  <NA>      <NA>
## Unique (excld. NA)                       3         1
## Missing values                           0         0
## Sorted                                TRUE      TRUE
##                                                     
##                                          submitter tan.app     e.1     e.4
## Class                                    character numeric numeric numeric
## Minimum            Pedersen, Johanna; Kamp, Jesper      64  0.0013 0.00591
## Maximum            Pedersen, Johanna; Kamp, Jesper      90     1.8    11.4
## Mean                                          <NA>    72.3   0.602    5.94
## Unique (excld. NA)                               1       4       3      37
## Missing values                                   0       0      34       0
## Sorted                                        TRUE   FALSE   FALSE   FALSE
##                                                                           
##                        e.6    e.12    e.24    e.48    e.72    e.96   e.168
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum            0.00732  0.0206  0.0694   0.125   0.224   0.241    0.24
## Maximum               15.9    25.7      36    44.4    48.7    51.2    36.2
## Mean                  8.24    13.4    19.2      24    20.2    21.4    14.7
## Unique (excld. NA)      37      37      37      37      25      25      16
## Missing values           0       0       0       0      12      12      21
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                           
##                    e.final   e.tot e.cum.1 e.cum.4 e.cum.6 e.cum.12 e.cum.24
## Class              numeric numeric numeric numeric numeric  numeric  numeric
## Minimum              0.241   0.241  0.0013 0.00591 0.00732   0.0206   0.0694
## Maximum               56.4    56.4     1.8    11.4    15.9     25.7       36
## Mean                  28.5    28.5   0.602    5.94    8.24     13.4     19.2
## Unique (excld. NA)      37      37       3      37      37       37       37
## Missing values           0       0      34       0       0        0        0
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE    FALSE    FALSE
##                                                                             
##                    e.cum.48 e.cum.72 e.cum.96 e.cum.168 e.cum.final e.cum.tot
## Class               numeric  numeric  numeric   numeric     numeric   numeric
## Minimum               0.125    0.224    0.241      0.24       0.241     0.241
## Maximum                44.4     48.7     51.2      36.2        56.4      56.4
## Mean                     24     20.2     21.4      14.7        28.5      28.5
## Unique (excld. NA)       37       25       25        16          37        37
## Missing values            0       12       12        21           0         0
## Sorted                FALSE    FALSE    FALSE     FALSE       FALSE     FALSE
##                                                                              
##                     e.rel.1  e.rel.4  e.rel.6 e.rel.12 e.rel.24 e.rel.48
## Class               numeric  numeric  numeric  numeric  numeric  numeric
## Minimum            1.93e-05 8.75e-05 0.000108 0.000305  0.00103  0.00186
## Maximum              0.0281    0.177    0.249    0.401    0.562    0.694
## Mean                 0.0094   0.0826    0.115    0.185    0.264    0.329
## Unique (excld. NA)        3       37       37       37       37       37
## Missing values           34        0        0        0        0        0
## Sorted                FALSE    FALSE    FALSE    FALSE    FALSE    FALSE
##                                                                         
##                    e.rel.72 e.rel.96 e.rel.168 e.rel.final e.rel.tot  rain.1
## Class               numeric  numeric   numeric     numeric   numeric numeric
## Minimum             0.00332  0.00356   0.00356     0.00357   0.00357       0
## Maximum                0.76    0.799     0.535       0.881     0.881       0
## Mean                   0.31    0.328     0.218       0.396     0.396       0
## Unique (excld. NA)       25       25        16          37        37       1
## Missing values           12       12        21           0         0      34
## Sorted                FALSE    FALSE     FALSE       FALSE     FALSE    TRUE
##                                                                             
##                     rain.4  rain.6 rain.12 rain.24 rain.48 rain.72 rain.96
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum                  0       0       0       0       0       0       0
## Maximum                  0       0       0       0       1       1       1
## Mean                     0       0       0       0  0.0541    0.08    0.08
## Unique (excld. NA)       1       1       1       1       2       2       2
## Missing values           0       0       0       0       0      12      12
## Sorted                TRUE    TRUE    TRUE    TRUE   FALSE   FALSE   FALSE
##                                                                           
##                    rain.168 rain.final rain.tot air.temp.1 air.temp.4
## Class               numeric    numeric  numeric    numeric    numeric
## Minimum                   0          0        0        6.1       6.33
## Maximum                   1          1        1       8.09       10.7
## Mean                  0.125     0.0541   0.0541       6.76       8.29
## Unique (excld. NA)        2          2        2          2         11
## Missing values           21          0        0         34          0
## Sorted                FALSE      FALSE    FALSE      FALSE      FALSE
##                                                                      
##                    air.temp.6 air.temp.12 air.temp.24 air.temp.48 air.temp.72
## Class                 numeric     numeric     numeric     numeric     numeric
## Minimum                  6.52        6.59        6.66        5.76        4.63
## Maximum                  10.2         9.3        9.85        9.87          10
## Mean                     8.13        7.75        7.76        7.36        7.16
## Unique (excld. NA)         15          27          27          32          31
## Missing values              0           0           0           0           0
## Sorted                  FALSE       FALSE       FALSE       FALSE       FALSE
##                                                                              
##                    air.temp.96 air.temp.168 air.temp.mn  wind.1  wind.4  wind.6
## Class                  numeric      numeric     numeric numeric numeric numeric
## Minimum                   3.52            2           2    2.21    0.33    0.33
## Maximum                     10           10          10    5.72    5.48    5.46
## Mean                      6.78         5.87           6    3.38    1.14    1.14
## Unique (excld. NA)          34           35          35       2       4       4
## Missing values               0            0           0      34       0       0
## Sorted                   FALSE        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.33    0.33    0.33    0.33    0.33     0.33    0.33
## Maximum               5.25    5.29    5.15    4.32    3.79     2.96    2.97
## Mean                  1.12    1.14    1.12    1.09    1.09     1.06    1.14
## Unique (excld. NA)       4       4       4       4       4        5       8
## Missing values           0       0       0       0       0        0       0
## Sorted               FALSE   FALSE   FALSE   FALSE   FALSE    FALSE   FALSE
##                                                                            
##                    rain.rate.1 rain.rate.4 rain.rate.6 rain.rate.12
## 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              34           0           0            0
## Sorted                    TRUE        TRUE        TRUE         TRUE
##                                                                    
##                    rain.rate.24 rain.rate.48 rain.rate.72 rain.rate.96
## Class                   numeric      numeric      numeric      numeric
## Minimum                       0            0            0            0
## Maximum                       0       0.0208       0.0139       0.0104
## Mean                          0      0.00113     0.000751     0.000563
## Unique (excld. NA)            1            2            2            2
## Missing values                0            0            0            0
## Sorted                     TRUE        FALSE        FALSE        FALSE
##                                                                       
##                    rain.rate.168 rain.rate.mn soil.temp.1 soil.temp.4
## Class                    numeric      numeric     numeric     numeric
## Minimum                        0            0           1           1
## Maximum                  0.00595      0.00595           1           1
## Mean                    0.000322     0.000322           1           1
## Unique (excld. NA)             2            2           1           1
## Missing values                 0            0          34          34
## Sorted                     FALSE        FALSE        TRUE        TRUE
##                                                                      
##                    soil.temp.6 soil.temp.12 soil.temp.24 soil.temp.48
## Class                  numeric      numeric      numeric      numeric
## Minimum                      1            1            1            1
## Maximum                      1            1            1            1
## Mean                         1            1            1            1
## Unique (excld. NA)           1            1            1            1
## Missing values              34           34           34           34
## Sorted                    TRUE         TRUE         TRUE         TRUE
##                                                                      
##                    soil.temp.72 soil.temp.96 soil.temp.168 soil.temp.mn
## Class                   numeric      numeric       numeric      numeric
## Minimum                       1            1             1            1
## Maximum                       1            1             1            1
## Mean                          1            1             1            1
## Unique (excld. NA)            1            1             1            1
## Missing values               34           34            34           34
## Sorted                     TRUE         TRUE          TRUE         TRUE
##                                                                        
##                    soil.temp.surf.1 soil.temp.surf.4 soil.temp.surf.6
## Class                       numeric          numeric          numeric
## Minimum                           1                1                1
## Maximum                           1                1                1
## Mean                              1                1                1
## Unique (excld. NA)                1                1                1
## Missing values                   34               34               34
## Sorted                         TRUE             TRUE             TRUE
##                                                                      
##                    soil.temp.surf.12 soil.temp.surf.24 soil.temp.surf.48
## Class                        numeric           numeric           numeric
## Minimum                            1                 1                 1
## Maximum                            1                 1                 1
## Mean                               1                 1                 1
## Unique (excld. NA)                 1                 1                 1
## Missing values                    34                34                34
## Sorted                          TRUE              TRUE              TRUE
##                                                                         
##                    soil.temp.surf.72 soil.temp.surf.96 soil.temp.surf.168
## Class                        numeric           numeric            numeric
## Minimum                        0.906             0.854              0.786
## Maximum                            1                 1              0.976
## Mean                           0.969             0.951              0.913
## Unique (excld. NA)                 2                 2                  2
## Missing values                    34                34                 34
## Sorted                          TRUE              TRUE               TRUE
##                                                                          
##                    soil.temp.surf.mn wind.2m.1 wind.2m.4 wind.2m.6 wind.2m.12
## Class                        numeric   numeric   numeric   numeric    numeric
## Minimum                        0.789      2.54      2.71      2.64       2.51
## Maximum                        0.979      6.59      6.31      6.29       6.04
## Mean                           0.916      3.89      3.91      3.86       3.69
## Unique (excld. NA)                 2         2         2         2          2
## Missing values                    34        34        34        34         34
## Sorted                          TRUE     FALSE     FALSE     FALSE      FALSE
##                                                                              
##                    wind.2m.24 wind.2m.48 wind.2m.72 wind.2m.96 wind.2m.168
## Class                 numeric    numeric    numeric    numeric     numeric
## Minimum                  2.76       2.52       2.38       2.62        2.52
## Maximum                  6.09       5.93       4.97       4.36        3.41
## Mean                     3.87       3.66       3.24        3.2        2.82
## Unique (excld. NA)          2          2          2          2           3
## Missing values             34         34         34         34          34
## Sorted                  FALSE      FALSE      FALSE      FALSE       FALSE
##                                                                           
##                    wind.2m.mn   rad.1   rad.4   rad.6  rad.12  rad.24  rad.48
## Class                 numeric numeric numeric numeric numeric numeric numeric
## Minimum                  2.52       1       1       1   0.521   0.333   0.354
## Maximum                  3.42       1       1       1   0.688   0.375   0.375
## Mean                     2.83       1       1       1   0.576   0.347   0.361
## Unique (excld. NA)          3       1       1       1       2       2       2
## Missing values             34      34      34      34      34      34      34
## Sorted                  FALSE    TRUE    TRUE    TRUE   FALSE   FALSE   FALSE
##                                                                              
##                     rad.72  rad.96 rad.168  rad.mn    rh.1    rh.4    rh.6
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum              0.361   0.354   0.339   0.342       1       1       1
## Maximum              0.389   0.406   0.387    0.39       1       1       1
## Mean                  0.37   0.372   0.355   0.358       1       1       1
## Unique (excld. NA)       2       2       2       2       1       1       1
## Missing values          34      34      34      34      34      34      34
## Sorted               FALSE   FALSE   FALSE   FALSE    TRUE    TRUE    TRUE
##                                                                           
##                      rh.12   rh.24   rh.48   rh.72   rh.96  rh.168   rh.mn
## Class              numeric numeric numeric numeric numeric numeric numeric
## Minimum                  1       1       1       1       1       1       1
## Maximum                  1       1       1       1       1       1       1
## Mean                     1       1       1       1       1       1       1
## 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
##                                                                           
##                    first.row.in.file.int last.row.in.file.int  n.ints     dt1
## Class                            numeric              numeric integer numeric
## Minimum                                5                   30      19     0.5
## Maximum                             3620                 3960     337     2.4
## Mean                                1150                 1250     107    1.71
## Unique (excld. NA)                    37                   37      16       4
## Missing values                         0                    0       0       0
## Sorted                             FALSE                FALSE   FALSE   FALSE
##                                                                              
##                     j.rel1   j.NH31  dt.min  dt.max  ct.min  ct.max
## Class              numeric  numeric numeric numeric numeric numeric
## Minimum            1.4e-05 0.000944     0.5     0.5     0.5      60
## Maximum             0.0484      3.1    2.38     7.2     2.4     203
## Mean                 0.022     1.58    1.66    3.74    1.71     145
## Unique (excld. NA)      37       37       5       7       4       9
## Missing values           0        0       0       0       0       0
## Sorted               FALSE    FALSE   FALSE   FALSE   FALSE   FALSE
##                                                                    
##                              t.start.p             t.end.p air.temp.z
## Class                  POSIXct, POSIXt     POSIXct, POSIXt    numeric
## Minimum            2022-10-11 15:24:00 2022-10-13 21:46:00          2
## Maximum            2022-11-24 13:30:00 2022-12-02 22:04:00          2
## Mean               2022-11-08 03:05:11 2022-11-14 01:59:48          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 pub.info soil.type2
## Class                  logical logical character logical  logical    logical
## Minimum                  FALSE    TRUE     Field    <NA>     <NA>       <NA>
## Maximum                  FALSE    TRUE      Plot    <NA>     <NA>       <NA>
## Mean                    0 TRUE  1 TRUE      <NA>    <NA>     <NA>       <NA>
## Unique (excld. NA)           1       1         2       0        0          0
## Missing values              34      34         0      37       37         37
## Sorted                    TRUE    TRUE     FALSE    <NA>     <NA>       <NA>
##                                                                             
##                     exper2    rep2    acid meas.tech.orig meas.tech2 crop.orig
## Class              logical logical logical      character  character character
## Minimum               <NA>    <NA>   FALSE            bLS    chamber   Stubble
## Maximum               <NA>    <NA>   FALSE    Wind tunnel         wt   Stubble
## Mean                  <NA>    <NA>  0 TRUE           <NA>       <NA>      <NA>
## Unique (excld. NA)       0       0       1              3          3         1
## Missing values          37      37       0              0          0         0
## Sorted                <NA>    <NA>    TRUE          FALSE      FALSE      TRUE
##                                                                               
##                    man.source.orig              app.method.orig app.method2
## Class                    character                    character   character
## Minimum                        Mix Band spread or trailing hose        bsth
## Maximum                        Mix          Open slot injection          os
## Mean                          <NA>                         <NA>        <NA>
## Unique (excld. NA)               1                            2           2
## Missing values                   0                            0           0
## Sorted                        TRUE                        FALSE       FALSE
##                                                                            
##                    incorp.orig date.start
## Class                character       Date
## Minimum                   None 2022-10-11
## Maximum                   None 2022-11-24
## Mean                      <NA>       <NA>
## Unique (excld. NA)           1          3
## Missing values               0          0
## Sorted                    TRUE       TRUE
## 

Interval-level emission data

## 
##  3949 rows and 138 columns
##  3949 unique rows
##                                                                                                                                                                                          cpmid
## Class                                                                                                                                                                                character
## Minimum                      D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_DFCtest_JP_231108_JK.xlsx.E:testA.F:A.P:plot1.T:WT.R:1.R2:.T:2022-10-11 15:24:00.M:Wind tunnelNA
## Maximum            D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_DFCtest_JP_231108_JK.xlsx.E:testC.F:A.P:plot8th.T:DFC_th.R:6.R2:.T:2022-11-24 12:57:00.M:Dynamic chamberNA
## Mean                                                                                                                                                                                      <NA>
## Unique (excld. NA)                                                                                                                                                                          37
## Missing values                                                                                                                                                                               0
## Sorted                                                                                                                                                                                    TRUE
##                                                                                                                                                                                               
##                     pub.id      proj     exper     field      plot     rep
## Class              logical character character character character numeric
## Minimum               <NA>       MAG     testA         A     plot1       1
## Maximum               <NA>       MAG     testC         A     plot9       9
## Mean                  <NA>      <NA>      <NA>      <NA>      <NA>    3.33
## Unique (excld. NA)       0         1         3         1        30       9
## Missing values        3949         0         0         0         0       0
## Sorted                <NA>      TRUE      TRUE      TRUE     FALSE   FALSE
##                                                                           
##                        treat   meas.tech meas.tech.det plot.area     lat
## Class              character   character       logical   numeric numeric
## Minimum                  bLS         bLS          <NA>       0.2    56.5
## Maximum                   WT Wind tunnel          <NA>       100    56.5
## Mean                    <NA>        <NA>          <NA>      17.6    56.5
## Unique (excld. NA)         7           3             0         5       1
## Missing values             0           0          3949         0       0
## Sorted                 FALSE       FALSE          <NA>     FALSE    TRUE
##                                                                         
##                       long   country      topo soil.samp.z    clay    silt
## Class              numeric character character   character numeric numeric
## Minimum               9.56        DK      Flat         0-5       9      24
## Maximum               9.56        DK      Flat         0-5       9      24
## Mean                  9.56      <NA>      <NA>        <NA>       9      24
## Unique (excld. NA)       1         1         1           1       1       1
## Missing values           0         0         0           0       0       0
## Sorted                TRUE      TRUE      TRUE        TRUE    TRUE    TRUE
##                                                                           
##                       sand      oc soil.type soil.water soil.water.v soil.moist
## Class              numeric logical   logical    numeric      logical  character
## Minimum                 65    <NA>      <NA>       0.19         <NA>        Wet
## Maximum                 65    <NA>      <NA>       0.22         <NA>        Wet
## Mean                    65    <NA>      <NA>      0.218         <NA>       <NA>
## Unique (excld. NA)       1       0         0          2            0          1
## Missing values           0    3949      3949          0         3949          0
## Sorted                TRUE    <NA>      <NA>       TRUE         <NA>       TRUE
##                                                                                
##                    soil.ph soil.dens  crop.res      till man.source
## Class              logical   numeric character character  character
## Minimum               <NA>       1.3       Yes        No        mix
## Maximum               <NA>       1.3       Yes        No        mix
## Mean                  <NA>       1.3      <NA>      <NA>       <NA>
## Unique (excld. NA)       0         1         1         1          1
## Missing values        3949         0         0         0          0
## Sorted                <NA>      TRUE      TRUE      TRUE       TRUE
##                                                                    
##                                                                man.source.det
## Class                                                               character
## Minimum            mix of slurry co-digested with other agricultural residues
## Maximum            mix of slurry co-digested with other agricultural residues
## Mean                                                                     <NA>
## Unique (excld. NA)                                                          1
## Missing values                                                              0
## 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 Anaerobic digestion     <NA>     <NA>
## Mean                  <NA>      <NA>                <NA>     <NA>     <NA>
## Unique (excld. NA)       0         1                   1        0        0
## Missing values        3949         0                   0     3949     3949
## Sorted                <NA>      TRUE                TRUE     <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>    5.03    <NA>    2.61    1.83    <NA>    <NA>
## Maximum                <NA>    5.99    <NA>    2.73       2    <NA>    <NA>
## Mean                   <NA>    5.21    <NA>    2.69    1.91    <NA>    <NA>
## Unique (excld. NA)        0       3       0       3       3       0       0
## Missing values         3949       0    3949       0       0    3949    3949
## Sorted                 <NA>   FALSE    <NA>   FALSE   FALSE    <NA>    <NA>
##                                                                            
##                    man.vfa  man.ph           app.start             app.end
## Class              logical numeric     POSIXct, POSIXt     POSIXct, POSIXt
## Minimum               <NA>     7.5 2022-10-11 15:24:00 2022-10-14 04:58:00
## Maximum               <NA>     7.6 2022-11-24 13:30:00 2022-12-02 23:24:00
## Mean                  <NA>    7.56 2022-11-19 03:03:00 2022-11-24 16:11:11
## Unique (excld. NA)       0       2                  37                  37
## Missing values        3949       0                   0                   0
## Sorted                <NA>    TRUE               FALSE               FALSE
##                                                                           
##                    app.method app.rate app.rate.unit    incorp time.incorp
## Class               character  numeric     character character     numeric
## Minimum                  bsth       35          t/ha      none        <NA>
## Maximum                    os       45          t/ha      none        <NA>
## Mean                     <NA>     35.5          <NA>      <NA>        <NA>
## Unique (excld. NA)          2        2             1         1           0
## Missing values              0        0             0         0        3949
## Sorted                  FALSE    FALSE          TRUE      TRUE        <NA>
##                                                                           
##                    man.area dist.inj furrow.z furrow.w      crop  crop.z
## Class               logical  logical  logical  logical character numeric
## Minimum                <NA>     <NA>     <NA>     <NA>   stubble       8
## Maximum                <NA>     <NA>     <NA>     <NA>   stubble       8
## Mean                   <NA>     <NA>     <NA>     <NA>      <NA>       8
## Unique (excld. NA)        0        0        0        0         1       1
## Missing values         3949     3949     3949     3949         0       0
## Sorted                 <NA>     <NA>     <NA>     <NA>      TRUE    TRUE
##                                                                         
##                    crop.area     lai notes.plot row.in.file.plot institute
## Class                numeric logical  character          numeric character
## Minimum                 <NA>    <NA>          .                5        AU
## Maximum                 <NA>    <NA>          .               41        AU
## Mean                    <NA>    <NA>       <NA>             29.3      <NA>
## Unique (excld. NA)         0       0          1               37         1
## Missing values          3949    3949       3923                0         0
## Sorted                  <NA>    <NA>       TRUE            FALSE      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_7.0_DFCtest_JP_231108_JK.xlsx
## Maximum            ../../data-submitted/03/AU/ALFAM2_template_7.0_DFCtest_JP_231108_JK.xlsx
## Mean                                                                                   <NA>
## Unique (excld. NA)                                                                        1
## Missing values                                                                            0
## Sorted                                                                                 TRUE
##                                                                                            
##                         app.start.orig        app.end.orig
## Class                  POSIXct, POSIXt     POSIXct, POSIXt
## Minimum            2022-10-11 15:24:00 2022-10-14 04:58:00
## Maximum            2022-11-24 13:30:00 2022-12-02 23:24:00
## Mean               2022-11-19 03:03:00 2022-11-24 16:11:11
## Unique (excld. NA)                  37                  37
## Missing values                       0                   0
## Sorted                           FALSE               FALSE
##                                                           
##                                                                                                                                                                       cpid
## Class                                                                                                                                                            character
## Minimum                  D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_DFCtest_JP_231108_JK.xlsx.E:testA.F:A.P:plot1.T:WT.R:1.R2:.T:2022-10-11 15:24:00
## Maximum            D:1.I:AU.Pr:MAG.F:../../data-submitted/03/AU/ALFAM2_template_7.0_DFCtest_JP_231108_JK.xlsx.E:testC.F:A.P:plot8th.T:DFC_th.R:6.R2:.T:2022-11-24 12:57:00
## Mean                                                                                                                                                                  <NA>
## Unique (excld. NA)                                                                                                                                                      37
## Missing values                                                                                                                                                           0
## Sorted                                                                                                                                                                TRUE
##                                                                                                                                                                           
##                                       ceid flag.plot
## Class                            character character
## Minimum            D:1.I:AU.Pr:MAG.E:testA          
## Maximum            D:1.I:AU.Pr:MAG.E:testC          
## Mean                                  <NA>      <NA>
## Unique (excld. NA)                       3         1
## Missing values                           0         0
## Sorted                                TRUE      TRUE
##                                                     
##                                          submitter tan.app interval
## Class                                    character numeric  numeric
## Minimum            Pedersen, Johanna; Kamp, Jesper      64        1
## Maximum            Pedersen, Johanna; Kamp, Jesper      90      337
## Mean                                          <NA>    67.8     87.3
## Unique (excld. NA)                               1       4      337
## Missing values                                   0       0        0
## Sorted                                        TRUE   FALSE    FALSE
##                                                                    
##                                t.start               t.end      dt   bg.dl
## Class                  POSIXct, POSIXt     POSIXct, POSIXt numeric logical
## Minimum            2022-10-11 15:24:00 2022-10-11 17:48:00     0.5    <NA>
## Maximum            2022-12-02 22:04:00 2022-12-02 23:24:00     7.2    <NA>
## Mean               2022-11-22 18:22:59 2022-11-22 19:44:26    1.36    <NA>
## Unique (excld. NA)                3417                3417      15       0
## Missing values                       0                   0       0    3949
## Sorted                           FALSE               FALSE   FALSE    <NA>
##                                                                           
##                     bg.val    bg.unit   j.NH3 j.NH3.unit pH.surf air.temp
## Class              numeric  character numeric  character logical  numeric
## Minimum            0.00492        ppm -0.0393 kg N/ha-hr    <NA>    -4.83
## Maximum               11.4 ug NH3 /m3     3.1 kg N/ha-hr    <NA>     12.7
## Mean                 0.215       <NA>   0.144       <NA>    <NA>     4.38
## Unique (excld. NA)    1126          2    3869          1       0      529
## Missing values           0          0       0          0    3949        0
## Sorted               FALSE      FALSE   FALSE       TRUE    <NA>    FALSE
##                                                                          
##                    air.temp.z soil.temp soil.temp.z soil.temp.surf     rad
## Class                 numeric   numeric     logical        numeric numeric
## Minimum                     2         1       FALSE              0       0
## Maximum                     2         1       FALSE              1       1
## Mean                        2         1      0 TRUE          0.913   0.357
## Unique (excld. NA)          1         1           1              3       3
## Missing values              0      2938        2938           2938    2938
## Sorted                   TRUE      TRUE        TRUE          FALSE   FALSE
##                                                                           
##                       wind  wind.z                    MOL   ustar
## Class              numeric logical                logical logical
## Minimum              0.126    TRUE                  FALSE   FALSE
## Maximum               6.73    TRUE                   TRUE   FALSE
## Mean                  1.36  1 TRUE 0.993015133876601 TRUE  0 TRUE
## Unique (excld. NA)     679       1                      2       1
## Missing values           0    2938                   3090    3090
## Sorted               FALSE    TRUE                  FALSE    TRUE
##                                                                  
##                                          rl air.pres air.pres.unit     rain
## Class                               logical  numeric     character  numeric
## Minimum                               FALSE        1             .        0
## Maximum                                TRUE        1           hPa        1
## Mean               0.00349243306169965 TRUE        1          <NA> 0.000506
## Unique (excld. NA)                        2        1             2        2
## Missing values                         3090     2938          2937        0
## Sorted                                FALSE     TRUE          TRUE    FALSE
##                                                                            
##                         rh  wind.loc far.loc
## Class              numeric character logical
## Minimum                  1     Field    <NA>
## Maximum                  1      Plot    <NA>
## Mean                     1      <NA>    <NA>
## Unique (excld. NA)       1         2       0
## Missing values        2938         0    3949
## Sorted                TRUE     FALSE    <NA>
##                                             
##                                                                                     notes.int
## Class                                                                               character
## Minimum                                                                                     .
## Maximum            Weather station data is 1 hour average, so every other interval is put NaN
## Mean                                                                                     <NA>
## Unique (excld. NA)                                                                          2
## Missing values                                                                           3945
## Sorted                                                                                   TRUE
##                                                                                              
##                    row.in.file.int        j.type        t.start.orig
## Class                      numeric     character     POSIXct, POSIXt
## Minimum                          5 emission rate 2022-10-11 15:24:00
## Maximum                       3960 emission rate 2022-12-02 22:04:00
## Mean                          1980          <NA> 2022-11-22 18:22:59
## Unique (excld. NA)            3949             1                3417
## Missing values                   0             0                   0
## Sorted                       FALSE          TRUE               FALSE
##                                                                     
##                             t.end.orig j.NH3.unit.orig j.NH3.orig
## Class                  POSIXct, POSIXt       character    numeric
## Minimum            2022-10-11 15:24:00      kg N/ha-hr      -1.33
## Maximum            2022-12-02 22:04:00     ug NH3/m2/s         80
## Mean               2022-11-22 18:22:59            <NA>      0.645
## Unique (excld. NA)                3417               2       3741
## Missing values                       0               0        208
## Sorted                           FALSE           FALSE      FALSE
##                                                                  
##                    j.NH3.conv.fact dt.calc   dt.diff      ct      mt     cta
## Class                      numeric numeric   numeric numeric numeric numeric
## Minimum                     0.0296     0.5 -3.55e-15     0.5    0.25    -0.7
## Maximum                          1     7.2  3.55e-15     203     202     203
## Mean                         0.752    1.36 -1.96e-15    88.9    88.2    88.7
## Unique (excld. NA)               2      15         7     966    1024     965
## Missing values                   0       0         0       0       0       0
## Sorted                       FALSE   FALSE     FALSE   FALSE   FALSE   FALSE
##                                                                             
##                        bta  flag.int rain.rate rain.cum wind.2m   e.int
## Class              numeric character   numeric  numeric numeric numeric
## Minimum               -1.2                   0        0   0.145 -0.0196
## Maximum                201       m i         2        1    7.74    12.5
## Mean                  87.3      <NA>   0.00101    0.143    2.82   0.267
## Unique (excld. NA)     964         2         2        2     677    3869
## Missing values           0         0         0        0    2938       0
## Sorted               FALSE     FALSE     FALSE    FALSE   FALSE   FALSE
##                                                                        
##                       e.cum        e    e.rel     j.rel pub.info soil.type2
## Class               numeric  numeric  numeric   numeric  logical    logical
## Minimum            0.000472 0.000472 6.99e-06 -0.000613     <NA>       <NA>
## Maximum                56.4     56.4    0.881    0.0484     <NA>       <NA>
## Mean                   16.9     16.9    0.251   0.00207     <NA>       <NA>
## Unique (excld. NA)     3949     3949     3949      3869        0          0
## Missing values            0        0        0         0     3949       3949
## 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    chamber   Stubble
## Maximum               <NA>    <NA>   FALSE    Wind tunnel         wt   Stubble
## Mean                  <NA>    <NA>  0 TRUE           <NA>       <NA>      <NA>
## Unique (excld. NA)       0       0       1              3          3         1
## Missing values        3949    3949       0              0          0         0
## Sorted                <NA>    <NA>    TRUE          FALSE      FALSE      TRUE
##                                                                               
##                    man.source.orig              app.method.orig app.method2
## Class                    character                    character   character
## Minimum                        Mix Band spread or trailing hose        bsth
## Maximum                        Mix          Open slot injection          os
## Mean                          <NA>                         <NA>        <NA>
## Unique (excld. NA)               1                            2           2
## Missing values                   0                            0           0
## Sorted                        TRUE                        FALSE       FALSE
##                                                                            
##                    incorp.orig date.start first.row.int row.plot
## Class                character       Date       numeric  numeric
## Minimum                   None 2022-10-11             5        5
## Maximum                   None 2022-10-11          3620       41
## Mean                      <NA>       <NA>          1890     29.3
## Unique (excld. NA)           1          1            37       37
## Missing values               0          0             0        0
## Sorted                    TRUE       TRUE         FALSE    FALSE
##                                                                 
##                             first.rows ggplotgroup
## Class                           factor      factor
## Minimum             Plots 10 Emis. 211 (4.96,10.1]
## Maximum              Plots 9 Emis. 185   (35.9,41]
## Mean               Plots 30 Emis. 1664 (25.6,30.7]
## Unique (excld. NA)                  37           7
## Missing values                       0           0
## Sorted                           FALSE       FALSE
##