Electronic Supplementary Material
UncertaintiesinLCA
Parameterization in life cycle assessment inventory data: review of current use and the representation of uncertainty
Joyce Smith Cooper • Michael Noon • Ezra Kahn
Received: 23 August 2012 / Accepted: 12 March 2012
© Springer-Verlag 2012
Responsible editor: Berlan RodriguezPerez
J. Smith Cooper () • M. Noon • E. Kahn
Design for Environment Laboratory, University of Washington, Box 352700, Seattle, WA 98195-2600, USA
e-mail:
() Corresponding author:
Tel: 011+1+206-543-5040
Fax: 011+1+206-685-8047
e-mail:
Table S1 Comparison of ILCD and EcoSpold v2 parameterized data format fields
ILCD / EcoSpold v2Field / eDocID / Field / FieldID
Model Description (required) / 1-1-12-31 / - / -
Parameter (required) / 1-1-12-33 / - / -
- / - / Name (required) / 1700
- / - / Parameter ID (UUID) (required) / 1705
- / - / Parameter Context ID (UUID) / 1706
Mean value (required) / 1-1-12-34 / Amount (required) / 1710
Min value / 1-1-12-35 / - / -
Max value / 1-1-12-36 / - / -
- / - / Unit ID (UUID) / 1712
- / - / Unit Context ID (UUID) / 1713
- / - / Unit Name / 1714
Name of parameter (required) / 1-1-12-33-1 / Variable Name / 1715
Formula (required) / 1-1-12-32 / Mathematical Relation / 1720
- / - / Is Calculated Amount / 1725
Uncertainty distribution type / 1-1-12-37 / Uncertainty / 1730
Relative standard deviation (95% CI) / 1-1-12-38 / - / -
Comments, units, defaults (required) / 1-1-12-39 / Comment / 1740
Table S2 ELCD parameterized datasets model descriptions and use advice
Model description / Use adviceExcavator; technology mix; 100 kW, Construction / The emission profile as well as the fuel consumption is calculated according to the settings of the variable parameters as described in the technology description. The calculation formulas of the single variables are given in the section variable / parameter. / The data set allows individual settings for selected variable parameters. In principle all emission data is based on so called basic emission factors relating emissions to the rated engine output of the excavator. The load factor of the engine (effective power in relation to maximum power) may be altered by the LCA expert based on case specific expert knowledge. The reference unit [kg emission/h] may be of particular interest if construction processes are modeled and specific productivity data [excavated material/h] is available. For cases no specific information on the productivity of the excavation process is readily available, a default figure for the productivity (performance) [m3/h] and density is presented [t/m3]. The productivity data is based on a bucket capacity of 1,1 m3 and a circulating time of operation of 80 s. Another variable parameter is the S-content of the diesel, determining the SO2-emissions. Vehicle production and end-of-life treatment are not included.
Waste water treatment; chemical reduction/oxidation process, municipal waste water; at waste water treatment plant / Variable parameters (with default setting) are: BOD, COD, cadmium, chromium (III), chromium (VI), copper, mercury, heavy metals (values will be used for arsenic, cobalt, manganese and thallium), nitrogen, ammonia, nickel, nitrate, phosphor, lead, phosphate and zinc entering the treatment plant and the reduction to be achieved. They are all measured in mg/l. For all these parameters, the reduction to be achieved in the process should also be given by the user (default values are provided). The emission profile is calculated according to the settings of the variable parameters. The calculation formulas of the single variables are given in the section variable / parameter. / The data set covers the end-of-life stage only, in form of a parameterized unit process level. It can be used to characterize the process chain situation of the respective end-of-life treatment in a representative manner within user specific product LCAs.
Table S3 Overview of ELCD parameterized datasets
Unit process / Number of parameters / Number of raw data points / Number of formulas / Includes nonlinear formulas? / Range of parameters/ formulaTRANSPORT SERVICES / Plane; technology mix, cargo; 68 t payload / 5 / 2 / 3 / Yes / 1 - 3
Container ship ocean; technology mix; 27.500 dwt pay load capacity / 4 / 2 / 2 / 2 - 2
Rail transport; technology mix, electricity driven, cargo; / 4 / 2 / 2 / Yes / 2 - 2
Barge; technology mix; 1.228 t pay load capacity / 5 / 2 / 3 / Yes / 1 - 3
Rail transport; technology mix, diesel driven, cargo; / 4 / 2 / 2 / Yes / 2 - 2
Bulk carrier ocean; technology mix; 100.000-200.000 dwt / 4 / 2 / 2 / Yes / 2 - 2
Mining Truck; technology mix; 220 t payload, 1.700 kW / 26 / 14 / 12 / 2 - 4
Articulated lorry transport; Euro 0, 1, 2, 3, 4 mix; 40 t total weight, 27 t max payload / 273 / 12 / 261 / 1 - 10
Lorry transport; Euro 0, 1, 2, 3, 4 mix; 22 t total weight, 17,3 t max payload / 273 / 12 / 261 / 1 - 10
Small lorry transport; Euro 0, 1, 2, 3, 4 mix; 7,5 t total weight, 3,3 t max payload / 273 / 12 / 261 / 1 - 10
EXAVATORS / Excavator; technology mix; 100 kW, Construction / 28 / 15 / 13 / 2 - 4
Excavator; technology mix; 500 kW, Mining / 28 / 15 / 13 / 2 - 4
WASTEWATER TREATMENT / Waste water treatment; chemical reduction/oxidation process, municipal waste water; at waste water treatment plant; / 48 / 32 / 16 / 2 - 2
TOTAL / 975 / 124 / 851
Table S4 Examples of ELCD parameters
Category / Example raw data / Example formulas**Concentration / [mg/l in] Biochemical oxygen demand (BOD) in the input to the wastewater treatment process / none
[ppm] sulphur content in fuel
Consumption Factor / None / [kgDiesel/(kg*km)] = (0.2254144+(0.34768674-0.2254144)*Auslast)/(Nutzlast*1000*Auslast
Consumption Rate / [kg fuel/h] fuel consumption at full load / none
Consumption Result / None / [kgDiesel/kg] Diesel consumption; Mix = E0Sp_Diesel_ges*Anteil_E0+E1Sp_Diesel_ges*Anteil_E1+E2Sp_Diesel_ges*Anteil_E2+E3Sp_Diesel_ges*Anteil_E3+E4Sp_Diesel_ges*Anteil_E4
[kg] Kerosene per kg cargo = Verbrauch/(Nutzlast*Auslast*1000)
Emission Factor / none / [gBenzene/kg] Benzene emissions weighted; Euro 0 = ((Anteil_AB*E0Sp_Benzol_AB)+(Anteil_AO*E0Sp_Benzol_AO)+(Anteil_IO*E0Sp_Benzol_IO))*Distanz
[gBenzene/(kg*km)] Benzene emissions motorway; Euro 0 = (0.008728771+(0.008298797-0.008728771)*Auslast)/(Nutzlast*1000*Auslast)
Emission Rate / [g Benzene/h] at full load / [kg SO2/h] at full load = fuel_h*sulphur_ppm/1000000*2
Emission Result / none / [g Benzene/t] = Benzene_h*load_factor/(performance*density) (this formula has been altered based on an analysis of units of measure)
[mg/l out] Chromium (III) in the output = cr3_in-cr3_red*cr3_in
[gBenzene/kg] Benzene emissions weighted; Mix = E0Sp_Benzol_ges*Anteil_E0+E1Sp_Benzol_ges*Anteil_E1+E2Sp_Benzol_ges*Anteil_E2+E3Sp_Benzol_ges*Anteil_E3+E4Sp_Benzol_ges*Anteil_E4
Physical or Thermodynamic Property / [m3] bucket volume / [kg] Diesel total consumption = (0.0057*Auslast^-0.9081*Tonnage*Distanz)
[t] dead weight tons average payload / [kg] heavy fuel oil total consumption = (0.2058*DWT^-0.4932*DWT*Distanz)
[t/m3] density of excavated material / [kg] heavy fuel oil total consumption = 0.0037*Distanz*DWT
[km] Distance Start - Finish / [kg] Kerosene total consumption = (3.6*75.773*Distanz^-0.3435*Distanz*Auslast*Nutzlast/43)
[kg] Diesel total consumption, payload 766t = (0.0049*Auslast^-0.6889*Distanz*Auslast*766)
[MJ] Power total consumption, payload 868t = 3.6*(0.0272*Auslast^-0.7333*Distanz*Auslast*868)
[t] max. loading = if(Distanz<600;15.1;if(Distanz>10000;68;0.5397*Distanz^0.525))
[t] Tonnage = Auslast*Nutzlast
Process Efficiency / [%] Load based on mass / none
[%] average utilisation ratio
[%] Chromium (III) reduction
Process Rate / [1/min] number of cycles per minute / [m3/h] excavator performance = bucket_volume*cycles_min*60
[m3/h] mining truck performance
Percentage / [%] Percentage on motorway (ave. speed X km/h), Standard = Y / none
[%] Percentage EUX ton kilometers
Balance*** / none / Result must be 1! given Anteil_E0+Anteil_E1+Anteil_E2+Anteil_E3+Anteil_E4
Result must be 1! given Anteil_AB+Anteil_AO+Anteil_IO
** where:
Anteil_XX = [%] share raw data (Production Mix: Percentage)Auslast = [%] utilization raw data (Process Efficiency)
Benzene_h = [g Benzene/h] benzene emission rate raw data (Emission Rate)
bucket_volume = [m3] bucket volume raw data (Physical or Thermodynamic Property)
cr3_in = [mg/l in] Chromium (III) in the input raw data (Concentration)
cr3_red = [%] Chromium (III) reduction raw data (Process Efficiency)
cycles_min = [1/min] excavator cycles per minute raw data (Process Rate)
density = [t/m3] density of excavated material raw data (Physical or Thermodynamic Property)
Distanz = [km] Distance Start - Finish raw data (Physical or Thermodynamic Property)
DWT = [t] dead weight tons average payload raw data (Physical or Thermodynamic Property) / EXSp_Benzol_XX = [gBenzene/(kg*km)] Benzene emissions formula (Emission Factor)
EXSp_Benzol_ges = [gBenzene/kg] Benzene emissions formula (Emission Factor)
EXSp_Diesel_ges = [kgDiesel/kg] Diesel consumption formula (Consumption Factor)
fuel_h = [kg fuel/h] fuel consumption raw data (Consumption Rate)
load_factor = [%] effective power in relation to maximum power raw data (Process Efficiency)
Nutzlast = [t] payload raw data or formula (Physical Property)
performance = [m3/h] equipment performance raw data or formula (Process Rate)
sulphur_ppm = [ppm] sulphur content in fuel raw data (Concentration)
Tonnage = [t] utilized payload formula (Physical Property)
Verbrauch = [MJ or kg] energy consumption formula (Physical or Thermodynamic Property)
*** The phrase “Result must be 1!” is provided in the Comments, units, defaults data field, interpreted here to mean that inventory code must recognize this requirement.
Table S5 Count of raw data and formulas by parameter categories in the 13 ELCD parameterized unit process data sets
Raw data / Formulas / Raw data / Formulas1. Concentration / 22 / 0 / 7. Emission Result / 0 / 82
2. Consumption Factor / 0 / 36 / 8. Physical or Thermodynamic Property / 19 / 11
3. Consumption Rate / 3 / 0 / 9. Process Efficiency / 26 / 0
4. Consumption Result / 0 / 12 / 10. Process Rate / 3 / 2
5. Emission Factor / 0 / 699 / 11. Percentage / 24 / 0
6. Emission Rate / 27 / 3 / 12. Balance / 0 / 6
Table S6 Example parameterized unit process data for synthetic nitrogen fertilizers applied to spring wheat (excluding durum) fields in Washington State in 2009: parameter category, description, name, uncertainty types, and values
row / Parameter category / Parameter description / Parameter name / Amount / Uncert. type / min Value / max Value / most Likely Value1 / Uncertainty / Sample size for ARMS jackknife estimate of variance / Sample_size / 3.00E+01
2 / Uncertainty / Degrees of freedom / df / 2.90E+01
3 / Uncertainty / Approximation g(df) / g_df / 3.51E-02
4 / Conversion Factor / Conversion factor for ha per acre / HA_per_AC / 4.05E-01
5 / Conversion Factor / Conversion factor for kg per lb / KG_per_LB / 4.54E-01
6 / Consumption / Raw data for Planted acres for synthetic fertilizer application method data (1,000 acres) / Raw_PLACRES_12 / 5.89E+02
7 / Uncertainty / RSE for Raw_PLACRES_12 / RSE_Raw_PLACRES_12 / 4.40E-02
8 / Uncertainty / Probability for t_PLACRES_12 / p_t_PLACRES_12 / 5.00E-01 / uniform / 0 / 1
9 / Uncertainty / Standard normal at p for t_PLACRES_12 / zp_t_PLACRES_12 / 0.00E+00
10 / Uncertainty / Student's t for PLACRES_12 / t_PLACRES_12 / 0.00E+00
11 / Consumption / Planted acres for synthetic fertilizer application method data (1,000 acres) / PLACRES_12 / 5.89E+02 / 0
12 / Percentage / Raw data for Acres treated with N (Percent of planted acres) / Raw_NITAC_12 / 9.87E+01
13 / Uncertainty / RSE for Raw_NITAC_12 / RSE_Raw_NITAC_12 / 9.53E-01
14 / Uncertainty / Probability for t_NITAC_12 / p_t_NITAC_12 / 5.00E-01 / uniform / 0 / 1
15 / Uncertainty / Standard normal at p for t_NITAC_12 / zp_t_NITAC_12 / 0.00E+00
16 / Uncertainty / Student's t for NITAC_12 / t_NITAC_12 / 0.00E+00
17 / Percentage / Acres treated with N (Percent of planted acres) / NITAC_12 / 9.87E+01 / 0 / 100
18 / Percentage / Raw data for No N broadcast (Percent of acres with N) / Raw_NITHOX1 / 8.67E+01
19 / Uncertainty / RSE for Raw_NITHOX1 / RSE_Raw_NITHOX1 / 4.82E+00
20 / Uncertainty / Probability for t_NITHOX1 / p_t_NITHOX1 / 5.00E-01 / uniform / 0 / 1
21 / Uncertainty / Standard normal at p for t_NITHOX1 / zp_t_NITHOX1 / 0.00E+00
22 / Uncertainty / Student's t for NITHOX1 / t_NITHOX1 / 0.00E+00
23 / Percentage / No N broadcast (Percent of acres with N) / NITHOX1 / 8.67E+01 / 0 / 100
24 / Percentage / Raw data for All N broadcast with incorp. (Percent of acres with N) / Raw_NITHOX2 / 3.27E+00
25 / Uncertainty / RSE for Raw_NITHOX2 / RSE_Raw_NITHOX2 / 4.99E+01
26 / Uncertainty / Probability for t_NITHOX2 / p_t_NITHOX2 / 5.00E-01 / uniform / 0 / 1
27 / Uncertainty / Standard normal at p for t_NITHOX2 / zp_t_NITHOX2 / 0.00E+00
28 / Uncertainty / Student's t for NITHOX2 / t_NITHOX2 / 0.00E+00
29 / Percentage / All N broadcast with incorp. (Percent of acres with N) / NITHOX2 / 3.27E+00 / 0 / 100
30 / Percentage / Raw data for All N broadcast without incorp. (Percent of acres with N) / Raw_NITHOX3 / 4.24E+00
31 / Uncertainty / RSE for Raw_NITHOX3 / RSE_Raw_NITHOX3 / 4.83E+01
32 / Uncertainty / Probability for t_NITHOX3 / p_t_NITHOX3 / 5.00E-01 / uniform / 0 / 1
33 / Uncertainty / Standard normal at p for t_NITHOX3 / zp_t_NITHOX3 / 0.00E+00
34 / Uncertainty / Student's t for NITHOX3 / t_NITHOX3 / 0.00E+00
35 / Percentage / All N broadcast without incorp. (Percent of acres with N) / NITHOX3 / 4.24E+00 / 0 / 100
36 / Percentage / Raw data for Mixed N application method, with incorp. (Percent of acres with N) / Raw_NITHOX4 / 1.57E+00
37 / Uncertainty / RSE for Raw_NITHOX4 / RSE_Raw_NITHOX4 / 2.06E+01
38 / Uncertainty / Probability for t_NITHOX4 / p_t_NITHOX4 / 5.00E-01 / uniform / 0 / 1
39 / Uncertainty / Standard normal at p for t_NITHOX4 / zp_t_NITHOX4 / 0.00E+00
40 / Uncertainty / Student's t for NITHOX4 / t_NITHOX4 / 0.00E+00
41 / Percentage / Mixed N application method, with incorp. (Percent of acres with N) / NITHOX4 / 1.57E+00 / 0 / 100
42 / Percentage / Raw data for Mixed N application method, without incorp. (Percent of acres with N) / Raw_NITHOX5 / 4.21E+00
43 / Uncertainty / RSE for Raw_NITHOX5 / RSE_Raw_NITHOX5 / 4.87E+01
44 / Uncertainty / Probability for t_NITHOX5 / p_t_NITHOX5 / 5.00E-01 / uniform / 0 / 1
45 / Uncertainty / Standard normal at p for t_NITHOX5 / zp_t_NITHOX5 / 0.00E+00
46 / Uncertainty / Student's t for NITHOX5 / t_NITHOX5 / 0.00E+00
47 / Percentage / Mixed N application method, without incorp. (Percent of acres with N) / NITHOX5 / 4.21E+00 / 0 / 100
48 / Balance / Balanced percent NITHOX2 / Bal_NITHOX2 / 3.27E+00
49 / Balance / Balanced percent NITHOX3 / Bal_NITHOX3 / 4.24E+00
50 / Balance / Balanced percent NITHOX4 / Bal_NITHOX4 / 1.57E+00
51 / Balance / Balanced percent NITHOX5 / Bal_NITHOX5 / 4.21E+00
52 / Balance / Balanced percent NITHOXU / Bal_NITHOXU / 1.00E-03
53 / Consumption / No N broadcast (Acres) / NITHOX1_Acres / 5.04E+05
54 / Consumption / All N broadcast with incorp. (Acres) / NITHOX2_Acres / 1.90E+04
55 / Consumption / All N broadcast without incorp. (Acres) / NITHOX3_Acres / 2.46E+04
56 / Consumption / Mixed N application method, with incorp. (Acres) / NITHOX4_Acres / 9.10E+03
57 / Consumption / Mixed N application method, without incorp. (Acres) / NITHOX5_Acres / 2.45E+04
58 / Consumption / N application method unspecified (Acres) / NITHOXU_Acres / 5.81E+00
59 / Consumption / Raw data for Planted acres for synthetic fertilizer quantity data (1,000 acres) / Raw_PLACRES_11 / 5.89E+02
60 / Uncertainty / RSE for Raw_PLACRES_11 / RSE_Raw_PLACRES_11 / 4.40E-02
61 / Uncertainty / Probability for t_PLACRES_11 / p_t_PLACRES_11 / 5.00E-01 / uniform / 0 / 1
62 / Uncertainty / Standard normal at p for t_PLACRES_11 / zp_t_PLACRES_11 / 0.00E+00
63 / Uncertainty / Student's t for PLACRES_11 / t_PLACRES_11 / 0.00E+00
64 / Consumption / Planted acres for synthetic fertilizer quantity data (1,000 acres) / PLACRES_11 / 5.89E+02 / 0
65 / Consumption factor / Raw data for Total N applied (Pounds N per treated acre) / Raw_NITLB / 7.91E+01
66 / Uncertainty / RSE for Raw_NITLB / RSE_Raw_NITLB / 6.86E+00
67 / Uncertainty / Probability for t_NITLB / p_t_NITLB / 5.00E-01 / uniform / 0 / 1
68 / Uncertainty / Standard normal at p for t_NITLB / zp_t_NITLB / 0.00E+00
69 / Uncertainty / Student's t for NITLB / t_NITLB / 0.00E+00
70 / Consumption factor / Total N applied (Pounds N per treated acre) / NITLB / 7.91E+01 / 0
71 / Percentage / Raw data for Acres treated with N (Percent of planted acres) / Raw_NITAC11 / 9.87E+01
72 / Uncertainty / RSE for Raw_NITAC11 / RSE_Raw_NITAC11 / 9.53E-01
73 / Uncertainty / Probability for t_NITAC11 / p_t_NITAC11 / 5.00E-01 / uniform / 0 / 1
74 / Uncertainty / Standard normal at p for t_NITAC11 / zp_t_NITAC11 / 0.00E+00
75 / Uncertainty / Student's t for NITAC11 / t_NITAC11 / 0.00E+00
76 / Percentage / Acres treated with N (Percent of planted acres) / NITAC11 / 9.87E+01 / 0 / 100
77 / Consumption / Total N applied (Pounds N) / NIT_LB / 4.60E+07
78 / Consumption / Raw data for tons anhydrous ammonia used in the US in 2009 (material tons) / Raw_anhydrous_NH3 / 4.01E+06
79 / Consumption / Raw data for tons aqueous ammonia used in the US in 2009 (material tons) / Raw_aqueous_NH3 / 4.39E+05
80 / Consumption / Raw data for tons ammonium nitrate used in the US in 2009 (material tons) / Raw_N2H4O3 / 7.57E+05
81 / Consumption / Raw data for tons ammonium sulfate used in the US in 2009 (material tons) / Raw_N2H8SO4 / 1.21E+06
82 / Consumption / Raw data for tons nitrogen solutions (as URAN) used in the US in 2009 (material tons) / Raw_URAN / 1.07E+07
83 / Consumption / Raw data for tons sodium nitrate used in the US in 2009 (material tons) / Raw_NaNO3 / 1.87E+04
84 / Consumption / Raw data for tons urea used in the US in 2009 (material tons) / Raw_N2H4CO / 5.23E+06
85 / Consumption / Raw data for tons other nitrogen fertilizers used in the US in 2009 (material tons) / Raw_N_other / 2.47E+06
86 / Percentage / Raw data for % N in anhydrous ammonia / pct_N_anhydrous_NH3 / 8.20E+01
87 / Percentage / Raw data for % N in aqueous ammonia / pct_N_aqueous_NH3 / 2.25E+01 / triangular / 20 / 25 / 22.5
88 / Percentage / Raw data for % N in ammonium nitrate / pct_N_N2H4O3 / 3.35E+01 / triangular / 33 / 34 / 33.5
89 / Percentage / Raw data for % N in ammonium sulfate / pct_N_N2H8SO4 / 2.10E+01
90 / Percentage / Raw data for % N in nitrogen solutions (as URAN) / pct_N_URAN / 3.00E+01 / triangular / 28 / 32 / 30
91 / Percentage / Raw data for % N in sodium nitrate / pct_N_NaNO3 / 1.60E+01
92 / Percentage / Raw data for % N in urea / pct_N_N2H4CO / 4.55E+01 / triangular / 45 / 46 / 45.5
93 / Percentage / Raw data for % N in other nitrogen fertilizers / pct_N_N_other / 1.41E+01 / triangular / 11 / 21 / 14.1
94 / Percentage / Most likely percent NIT_LB as anhydrous ammonia / c_NIT_pct_anhydrous_NH3 / 3.40E+01
95 / Percentage / Most likely percent NIT_LB as aqueous ammonia / c_NIT_pct_aqueous_NH3 / 1.02E+00
96 / Percentage / Most likely percent NIT_LB as ammonium nitrate / c_NIT_pct_N2H4O3 / 2.63E+00
97 / Percentage / Most likely percent NIT_LB as ammonium sulfate / c_NIT_pct_N2H8SO4 / 2.62E+00
98 / Percentage / Most likely percent NIT_LB as URAN / c_NIT_pct_URAN / 3.32E+01
99 / Percentage / Most likely percent NIT_LB as sodium nitrate / c_NIT_pct_NaNO3 / 3.10E-02
100 / Percentage / Most likely percent NIT_LB as urea / c_NIT_pct_N2H4CO / 2.47E+01
101 / Percentage / Most likely percent NIT_LB as other nitrogen fertilizers / c_NIT_pct_N_N_other / 3.61E+00
102 / Percentage / Percent NIT_LB as anhydrous ammonia / NIT_pct_anhydrous_NH3 / 3.40E+01 / triangular / 0 / 100 / c_NIT_pct_anhydrous_NH3
103 / Percentage / Percent NIT_LB as aqueous ammonia / NIT_pct_aqueous_NH3 / 1.02E+00 / triangular / 0 / 100 / c_NIT_pct_aqueous_NH3
104 / Percentage / Percent NIT_LB as ammonium nitrate / NIT_pct_N2H4O3 / 2.63E+00 / triangular / 0 / 100 / c_NIT_pct_N2H4O3
105 / Percentage / Percent NIT_LB as ammonium sulfate / NIT_pct_N2H8SO4 / 2.62E+00 / triangular / 0 / 100 / c_NIT_pct_N2H8SO4
106 / Percentage / Percent NIT_LB as URAN / NIT_pct_URAN / 3.32E+01 / triangular / 0 / 100 / c_NIT_pct_URAN
107 / Percentage / Percent NIT_LB as sodium nitrate / NIT_pct_NaNO3 / 3.10E-02 / triangular / 0 / 100 / c_NIT_pct_NaNO3
108 / Percentage / Percent NIT_LB as urea / NIT_pct_N2H4CO / 2.47E+01 / triangular / 0 / 100 / c_NIT_pct_N2H4CO
109 / Percentage / Percent NIT_LB as other nitrogen fertilizers / NIT_pct_N_N_other / 3.61E+00 / triangular / 0 / 100 / c_NIT_pct_N_N_other
110 / Balance / Balanced percent NIT_LB as aqueous NH3 / Bal_NIT_pct_aqueous_NH3 / 1.02E+00
111 / Balance / Balanced percent NIT_LB as N2H4O3 / Bal_NIT_pct_N2H4O3 / 2.63E+00
112 / Balance / Balanced percent NIT_LB as N2H8SO4 / Bal_NIT_pct_N2H8SO4 / 2.62E+00
113 / Balance / Balanced percent NIT_LB as URAN / Bal_NIT_pct_URAN / 3.32E+01
114 / Balance / Balanced percent NIT_LB as NaNO3 / Bal_NIT_pct_NaNO3 / 3.10E-02
115 / Balance / Balanced percent NIT_LB as N2H4CO / Bal_NIT_pct_N2H4CO / 2.47E+01
116 / Balance / Balanced percent NIT_LB as other nitrogen fertilizers / Bal_NIT_pct_N_N_other / 1.79E+00
117 / Consumption / N fertlizer applied as anhydrous NH3 (lb-N) / NIT_anhydrous_NH3_lb / 1.57E+07
118 / Consumption / N fertlizer applied as aqueous NH3 (lb-N) / NIT_aqueous_NH3_lb / 4.71E+05
119 / Consumption / N fertlizer applied as ammonium nitrate (lb-N) / NIT_N2H4O3_lb / 1.21E+06
120 / Consumption / N fertlizer applied as ammonium sulfate (lb-N) / NIT_N2H8SO4_lb / 1.21E+06
121 / Consumption / N fertlizer applied as URAN (lb-N) / NIT_URAN_lb / 1.53E+07
122 / Consumption / N fertlizer applied as sodium nitrate (lb-N) / NIT_NaNO3_lb / 1.42E+04
123 / Consumption / N fertlizer applied as urea (lb-N) / NIT_N2H4CO_lb / 1.13E+07
124 / Consumption / N fertlizer applied as other nitrogen fertilizers (lb-N) / NIT_N_other_lb / 8.22E+05
125 / Production / Raw data for Wheat, spring (excl durum) - PRODUCTION, MEASURED IN BU / Raw_PROD_spring_wheat_BU / 2.63E+07
126 / Uncertainty / RSE for Raw_PROD_spring_wheat_BU / RSE_Raw_PROD_spring_wheat_BU / 0.00E+00
127 / Uncertainty / Probability for t_PROD_spring_wheat_BU / p_t_PROD_spring_wheat_BU / 5.00E-01 / uniform / 0 / 1
128 / Uncertainty / Standard normal at p for t_PROD_spring_wheat_BU / zp_t_PROD_spring_wheat_BU / 0.00E+00
129 / Uncertainty / Student's t for PROD_spring_wheat_BU / t_PROD_spring_wheat_BU / 0.00E+00
130 / Production / Wheat, spring (excl durum) - PRODUCTION, MEASURED IN BU / PROD_spring_wheat_BU / 2.63E+07 / 0
131 / Phys. or Thermo. / Standard lb per bushel / LB_per_BU / 6.00E+01
132 / Production / Production of wheat, spring (excl. durum) (kg) / PRODMASS / 7.16E+08 / 0
133 / Consumption Result / No N broadcast (Hectares) / NITHOX1_Hectares / 2.85E-04
134 / Consumption Result / All N broadcast with incorp. (Hectares) / NITHOX2_Hectares / 1.07E-05
135 / Consumption Result / All N broadcast without incorp. (Hectares) / NITHOX3_Hectares / 1.39E-05
136 / Consumption Result / Mixed N application method, with incorp. (Hectares) / NITHOX4_Hectares / 5.14E-06
137 / Consumption Result / Mixed N application method, without incorp. (Hectares) / NITHOX5_Hectares / 1.38E-05
138 / Consumption Result / N application method unspecified (Hectares) / NITHOXU_Hectares / 3.28E-09
139 / Consumption Result / N fertlizer applied as anhydrous NH3 (kg-N) / NIT_anhydrous_NH3_kg / 9.91E-03
140 / Consumption Result / N fertlizer applied as aqueous NH3 (kg-N) / NIT_aqueous_NH3_kg / 2.98E-04
141 / Consumption Result / N fertlizer applied as ammonium nitrate (kg-N) / NIT_N2H4O3_kg / 7.65E-04
142 / Consumption Result / N fertlizer applied as ammonium sulfate (kg-N) / NIT_N2H8SO4_kg / 7.64E-04
143 / Consumption Result / N fertlizer applied as URAN (kg-N) / NIT_URAN_kg / 9.67E-03
144 / Consumption Result / N fertlizer applied as sodium nitrate (kg-N) / NIT_NaNO3_kg / 9.02E-06
145 / Consumption Result / N fertlizer applied as urea (kg-N) / NIT_N2H4CO_kg / 7.18E-03
146 / Consumption Result / N fertlizer applied as other nitrogen fertilizers (kg-N) / NIT_N_other_kg / 5.20E-04
Table S7 Example parameterized unit process data for synthetic nitrogen fertilizers applied to spring wheat (excluding durum) fields in Washington State in 2009: parameter category, description, name, and mathematical relations
row / Parameter category / Parameter description / Parameter name / Mathematical relation1 / Uncertainty / Sample size for ARMS jackknife estimate of variance / Sample_size
2 / Uncertainty / Degrees of freedom / df / Sample_size-1
3 / Uncertainty / Approximation g(df) / g_df / (df-1.5)/(df-1)^2
4 / Conversion Factor / Conversion factor for ha per acre / HA_per_AC
5 / Conversion Factor / Conversion factor for kg per lb / KG_per_LB
6 / Consumption / Raw data for Planted acres for synthetic fertilizer application method data (1,000 acres) / Raw_PLACRES_12
7 / Uncertainty / RSE for Raw_PLACRES_12 / RSE_Raw_PLACRES_12
8 / Uncertainty / Probability for t_PLACRES_12 / p_t_PLACRES_12
9 / Uncertainty / Standard normal at p for t_PLACRES_12 / zp_t_PLACRES_12 / SQRT(2)*(IF((2*p_t_PLACRES_12-1)<0,-1,IF((2*p_t_PLACRES_12-1)>0,1,0))*SQRT(SQRT((2/(PI()*0.140012289)+LN(1-(2*p_t_PLACRES_12-1)^2)/2)^2-LN(1-(2*p_t_PLACRES_12-1)^2)/0.140012289)-(2/(PI()*0.140012289)+LN(1-(2*p_t_PLACRES_12-1)^2)/2)))
10 / Uncertainty / Student's t for PLACRES_12 / t_PLACRES_12 / IF(p_t_PLACRES_12<0.5,-SQRT(df*EXP(zp_t_PLACRES_12^2*g_df)-df),SQRT(df*EXP(zp_t_PLACRES_12^2*g_df)-df))
11 / Consumption / Planted acres for synthetic fertilizer application method data (1,000 acres) / PLACRES_12 / Raw_PLACRES_12*(1+t_PLACRES_12*RSE_Raw_PLACRES_12/100)
12 / Percentage / Raw data for Acres treated with N (Percent of planted acres) / Raw_NITAC_12
13 / Uncertainty / RSE for Raw_NITAC_12 / RSE_Raw_NITAC_12
14 / Uncertainty / Probability for t_NITAC_12 / p_t_NITAC_12
15 / Uncertainty / Standard normal at p for t_NITAC_12 / zp_t_NITAC_12 / SQRT(2)*(IF((2*p_t_NITAC_12-1)<0,-1,IF((2*p_t_NITAC_12-1)>0,1,0))*SQRT(SQRT((2/(PI()*0.140012289)+LN(1-(2*p_t_NITAC_12-1)^2)/2)^2-LN(1-(2*p_t_NITAC_12-1)^2)/0.140012289)-(2/(PI()*0.140012289)+LN(1-(2*p_t_NITAC_12-1)^2)/2)))
16 / Uncertainty / Student's t for NITAC_12 / t_NITAC_12 / IF(p_t_NITAC_12<0.5,-SQRT(df*EXP(zp_t_NITAC_12^2*g_df)-df),SQRT(df*EXP(zp_t_NITAC_12^2*g_df)-df))
17 / Percentage / Acres treated with N (Percent of planted acres) / NITAC_12 / Raw_NITAC_12*(1+t_NITAC_12*RSE_Raw_NITAC_12/100)
18 / Percentage / Raw data for No N broadcast (Percent of acres with N) / Raw_NITHOX1
19 / Uncertainty / RSE for Raw_NITHOX1 / RSE_Raw_NITHOX1
20 / Uncertainty / Probability for t_NITHOX1 / p_t_NITHOX1
21 / Uncertainty / Standard normal at p for t_NITHOX1 / zp_t_NITHOX1 / SQRT(2)*(IF((2*p_t_NITHOX1-1)<0,-1,IF((2*p_t_NITHOX1-1)>0,1,0))*SQRT(SQRT((2/(PI()*0.140012289)+LN(1-(2*p_t_NITHOX1-1)^2)/2)^2-LN(1-(2*p_t_NITHOX1-1)^2)/0.140012289)-(2/(PI()*0.140012289)+LN(1-(2*p_t_NITHOX1-1)^2)/2)))
22 / Uncertainty / Student's t for NITHOX1 / t_NITHOX1 / IF(p_t_NITHOX1<0.5,-SQRT(df*EXP(zp_t_NITHOX1^2*g_df)-df),SQRT(df*EXP(zp_t_NITHOX1^2*g_df)-df))
23 / Percentage / No N broadcast (Percent of acres with N) / NITHOX1 / Raw_NITHOX1*(1+t_NITHOX1*RSE_Raw_NITHOX1/100)
24 / Percentage / Raw data for All N broadcast with incorp. (Percent of acres with N) / Raw_NITHOX2
25 / Uncertainty / RSE for Raw_NITHOX2 / RSE_Raw_NITHOX2
26 / Uncertainty / Probability for t_NITHOX2 / p_t_NITHOX2
27 / Uncertainty / Standard normal at p for t_NITHOX2 / zp_t_NITHOX2 / SQRT(2)*(IF((2*p_t_NITHOX2-1)<0,-1,IF((2*p_t_NITHOX2-1)>0,1,0))*SQRT(SQRT((2/(PI()*0.140012289)+LN(1-(2*p_t_NITHOX2-1)^2)/2)^2-LN(1-(2*p_t_NITHOX2-1)^2)/0.140012289)-(2/(PI()*0.140012289)+LN(1-(2*p_t_NITHOX2-1)^2)/2)))
28 / Uncertainty / Student's t for NITHOX2 / t_NITHOX2 / IF(p_t_NITHOX2<0.5,-SQRT(df*EXP(zp_t_NITHOX2^2*g_df)-df),SQRT(df*EXP(zp_t_NITHOX2^2*g_df)-df))
29 / Percentage / All N broadcast with incorp. (Percent of acres with N) / NITHOX2 / Raw_NITHOX2*(1+t_NITHOX2*RSE_Raw_NITHOX2/100)
30 / Percentage / Raw data for All N broadcast without incorp. (Percent of acres with N) / Raw_NITHOX3
31 / Uncertainty / RSE for Raw_NITHOX3 / RSE_Raw_NITHOX3
32 / Uncertainty / Probability for t_NITHOX3 / p_t_NITHOX3
33 / Uncertainty / Standard normal at p for t_NITHOX3 / zp_t_NITHOX3 / SQRT(2)*(IF((2*p_t_NITHOX3-1)<0,-1,IF((2*p_t_NITHOX3-1)>0,1,0))*SQRT(SQRT((2/(PI()*0.140012289)+LN(1-(2*p_t_NITHOX3-1)^2)/2)^2-LN(1-(2*p_t_NITHOX3-1)^2)/0.140012289)-(2/(PI()*0.140012289)+LN(1-(2*p_t_NITHOX3-1)^2)/2)))
34 / Uncertainty / Student's t for NITHOX3 / t_NITHOX3 / IF(p_t_NITHOX3<0.5,-SQRT(df*EXP(zp_t_NITHOX3^2*g_df)-df),SQRT(df*EXP(zp_t_NITHOX3^2*g_df)-df))
35 / Percentage / All N broadcast without incorp. (Percent of acres with N) / NITHOX3 / Raw_NITHOX3*(1+t_NITHOX3*RSE_Raw_NITHOX3/100)
36 / Percentage / Raw data for Mixed N application method, with incorp. (Percent of acres with N) / Raw_NITHOX4
37 / Uncertainty / RSE for Raw_NITHOX4 / RSE_Raw_NITHOX4
38 / Uncertainty / Probability for t_NITHOX4 / p_t_NITHOX4
39 / Uncertainty / Standard normal at p for t_NITHOX4 / zp_t_NITHOX4 / SQRT(2)*(IF((2*p_t_NITHOX4-1)<0,-1,IF((2*p_t_NITHOX4-1)>0,1,0))*SQRT(SQRT((2/(PI()*0.140012289)+LN(1-(2*p_t_NITHOX4-1)^2)/2)^2-LN(1-(2*p_t_NITHOX4-1)^2)/0.140012289)-(2/(PI()*0.140012289)+LN(1-(2*p_t_NITHOX4-1)^2)/2)))
40 / Uncertainty / Student's t for NITHOX4 / t_NITHOX4 / IF(p_t_NITHOX4<0.5,-SQRT(df*EXP(zp_t_NITHOX4^2*g_df)-df),SQRT(df*EXP(zp_t_NITHOX4^2*g_df)-df))
41 / Percentage / Mixed N application method, with incorp. (Percent of acres with N) / NITHOX4 / Raw_NITHOX4*(1+t_NITHOX4*RSE_Raw_NITHOX4/100)
42 / Percentage / Raw data for Mixed N application method, without incorp. (Percent of acres with N) / Raw_NITHOX5
43 / Uncertainty / RSE for Raw_NITHOX5 / RSE_Raw_NITHOX5
44 / Uncertainty / Probability for t_NITHOX5 / p_t_NITHOX5
45 / Uncertainty / Standard normal at p for t_NITHOX5 / zp_t_NITHOX5 / SQRT(2)*(IF((2*p_t_NITHOX5-1)<0,-1,IF((2*p_t_NITHOX5-1)>0,1,0))*SQRT(SQRT((2/(PI()*0.140012289)+LN(1-(2*p_t_NITHOX5-1)^2)/2)^2-LN(1-(2*p_t_NITHOX5-1)^2)/0.140012289)-(2/(PI()*0.140012289)+LN(1-(2*p_t_NITHOX5-1)^2)/2)))
46 / Uncertainty / Student's t for NITHOX5 / t_NITHOX5 / IF(p_t_NITHOX5<0.5,-SQRT(df*EXP(zp_t_NITHOX5^2*g_df)-df),SQRT(df*EXP(zp_t_NITHOX5^2*g_df)-df))
47 / Percentage / Mixed N application method, without incorp. (Percent of acres with N) / NITHOX5 / Raw_NITHOX5*(1+t_NITHOX5*RSE_Raw_NITHOX5/100)
48 / Balance / Balanced percent NITHOX2 / Bal_NITHOX2 / IF(NITHOX1=100,0,IF(NITHOX1+NITHOX2>100,100-NITHOX1,NITHOX2))
49 / Balance / Balanced percent NITHOX3 / Bal_NITHOX3 / IF(NITHOX1+Bal_NITHOX2=100,0,IF(NITHOX1+Bal_NITHOX2+NITHOX3>100,100-(NITHOX1+Bal_NITHOX2),NITHOX3))
50 / Balance / Balanced percent NITHOX4 / Bal_NITHOX4 / IF(NITHOX1+Bal_NITHOX2+Bal_NITHOX3=100,0,IF(NITHOX1+Bal_NITHOX2+Bal_NITHOX3+NITHOX4>100,100-(NITHOX1+Bal_NITHOX2+Bal_NITHOX3),NITHOX4))
51 / Balance / Balanced percent NITHOX5 / Bal_NITHOX5 / IF(NITHOX1+Bal_NITHOX2+Bal_NITHOX3+Bal_NITHOX4=100,0,IF(NITHOX1+Bal_NITHOX2+Bal_NITHOX3+Bal_NITHOX4+NITHOX5>100,100-(NITHOX1+Bal_NITHOX2+Bal_NITHOX3+Bal_NITHOX4),NITHOX5))
52 / Balance / Balanced percent NITHOXU / Bal_NITHOXU / IF(NITHOX1+Bal_NITHOX2+Bal_NITHOX3+Bal_NITHOX4+Bal_NITHOX5=100,0,100-(NITHOX1+Bal_NITHOX2+Bal_NITHOX3+Bal_NITHOX4+Bal_NITHOX5)
53 / Consumption / No N broadcast (Acres) / NITHOX1_Acres / PLACRES12*1000*NITAC12*NITHOX1/(100*100)
54 / Consumption / All N broadcast with incorp. (Acres) / NITHOX2_Acres / PLACRES12*1000*NITAC12*Bal_NITHOX2/(100*100)
55 / Consumption / All N broadcast without incorp. (Acres) / NITHOX3_Acres / PLACRES12*1000*NITAC12*Bal_NITHOX3/(100*100)
56 / Consumption / Mixed N application method, with incorp. (Acres) / NITHOX4_Acres / PLACRES12*1000*NITAC12*Bal_NITHOX4/(100*100)
57 / Consumption / Mixed N application method, without incorp. (Acres) / NITHOX5_Acres / PLACRES12*1000*NITAC12*Bal_NITHOX5/(100*100)
58 / Consumption / N application method unspecified (Acres) / NITHOXU_Acres / PLACRES12*1000*NITAC12*Bal_NITHOXU/(100*100)
59 / Consumption / Raw data for Planted acres for synthetic fertilizer quantity data (1,000 acres) / Raw_PLACRES_11
60 / Uncertainty / RSE for Raw_PLACRES_11 / RSE_Raw_PLACRES_11
61 / Uncertainty / Probability for t_PLACRES_11 / p_t_PLACRES_11
62 / Uncertainty / Standard normal at p for t_PLACRES_11 / zp_t_PLACRES_11 / SQRT(2)*(IF((2*p_t_PLACRES_11-1)<0,-1,IF((2*p_t_PLACRES_11-1)>0,1,0))*SQRT(SQRT((2/(PI()*0.140012289)+LN(1-(2*p_t_PLACRES_11-1)^2)/2)^2-LN(1-(2*p_t_PLACRES_11-1)^2)/0.140012289)-(2/(PI()*0.140012289)+LN(1-(2*p_t_PLACRES_11-1)^2)/2)))
63 / Uncertainty / Student's t for PLACRES_11 / t_PLACRES_11 / IF(p_t_PLACRES_11<0.5,-SQRT(df*EXP(zp_t_PLACRES_11^2*g_df)-df),SQRT(df*EXP(zp_t_PLACRES_11^2*g_df)-df))
64 / Consumption / Planted acres for synthetic fertilizer quantity data (1,000 acres) / PLACRES_11 / Raw_PLACRES_11*(1+t_PLACRES_11*RSE_Raw_PLACRES_11/100)
65 / Consumption factor / Raw data for Total N applied (Pounds N per treated acre) / Raw_NITLB
66 / Uncertainty / RSE for Raw_NITLB / RSE_Raw_NITLB
67 / Uncertainty / Probability for t_NITLB / p_t_NITLB
68 / Uncertainty / Standard normal at p for t_NITLB / zp_t_NITLB / SQRT(2)*(IF((2*p_t_NITLB-1)<0,-1,IF((2*p_t_NITLB-1)>0,1,0))*SQRT(SQRT((2/(PI()*0.140012289)+LN(1-(2*p_t_NITLB-1)^2)/2)^2-LN(1-(2*p_t_NITLB-1)^2)/0.140012289)-(2/(PI()*0.140012289)+LN(1-(2*p_t_NITLB-1)^2)/2)))
69 / Uncertainty / Student's t for NITLB / t_NITLB / IF(p_t_NITLB<0.5,-SQRT(df*EXP(zp_t_NITLB^2*g_df)-df),SQRT(df*EXP(zp_t_NITLB^2*g_df)-df))
70 / Consumption factor / Total N applied (Pounds N per treated acre) / NITLB / Raw_NITLB*(1+t_NITLB*RSE_Raw_NITLB/100)
71 / Percentage / Raw data for Acres treated with N (Percent of planted acres) / Raw_NITAC11
72 / Uncertainty / RSE for Raw_NITAC11 / RSE_Raw_NITAC11
73 / Uncertainty / Probability for t_NITAC11 / p_t_NITAC11
74 / Uncertainty / Standard normal at p for t_NITAC11 / zp_t_NITAC11 / SQRT(2)*(IF((2*p_t_NITAC11-1)<0,-1,IF((2*p_t_NITAC11-1)>0,1,0))*SQRT(SQRT((2/(PI()*0.140012289)+LN(1-(2*p_t_NITAC11-1)^2)/2)^2-LN(1-(2*p_t_NITAC11-1)^2)/0.140012289)-(2/(PI()*0.140012289)+LN(1-(2*p_t_NITAC11-1)^2)/2)))
75 / Uncertainty / Student's t for NITAC11 / t_NITAC11 / IF(p_t_NITAC11<0.5,-SQRT(df*EXP(zp_t_NITAC11^2*g_df)-df),SQRT(df*EXP(zp_t_NITAC11^2*g_df)-df))
76 / Percentage / Acres treated with N (Percent of planted acres) / NITAC11 / Raw_NITAC11*(1+t_NITAC11*RSE_Raw_NITAC11/100)
77 / Consumption / Total N applied (Pounds N) / NIT_LB / PLACRES11*1000*NITLB*NITAC11/100
78 / Consumption / Raw data for tons anhydrous ammonia used in the US in 2009 (material tons) / Raw_anhydrous_NH3
79 / Consumption / Raw data for tons aqueous ammonia used in the US in 2009 (material tons) / Raw_aqueous_NH3
80 / Consumption / Raw data for tons ammonium nitrate used in the US in 2009 (material tons) / Raw_N2H4O3
81 / Consumption / Raw data for tons ammonium sulfate used in the US in 2009 (material tons) / Raw_N2H8SO4
82 / Consumption / Raw data for tons nitrogen solutions (as URAN) used in the US in 2009 (material tons) / Raw_URAN
83 / Consumption / Raw data for tons sodium nitrate used in the US in 2009 (material tons) / Raw_NaNO3
84 / Consumption / Raw data for tons urea used in the US in 2009 (material tons) / Raw_N2H4CO
85 / Consumption / Raw data for tons other nitrogen fertilizers used in the US in 2009 (material tons) / Raw_N_other
86 / Percentage / Raw data for % N in anhydrous ammonia / pct_N_anhydrous_NH3
87 / Percentage / Raw data for % N in aqueous ammonia / pct_N_aqueous_NH3
88 / Percentage / Raw data for % N in ammonium nitrate / pct_N_N2H4O3
89 / Percentage / Raw data for % N in ammonium sulfate / pct_N_N2H8SO4
90 / Percentage / Raw data for % N in nitrogen solutions (as URAN) / pct_N_URAN
91 / Percentage / Raw data for % N in sodium nitrate / pct_N_NaNO3
92 / Percentage / Raw data for % N in urea / pct_N_N2H4CO
93 / Percentage / Raw data for % N in other nitrogen fertilizers / pct_N_N_other
94 / Percentage / Most likely percent NIT_LB as anhydrous ammonia / c_NIT_pct_anhydrous_NH3 / (Raw_anhydrous_NH3*pct_N_anhydrous_NH3*100)/((Raw_anhydrous_NH3*pct_N_anhydrous_NH3)+(Raw_aqueous_NH3*pct_N_aqueous_NH3)+(Raw_N2H4O3*pct_N_N2H4O3)+(Raw_N2H8SO4*pct_N_N2H8SO4)+(Raw_URAN*pct_N_URAN)+(Raw_NaNO3*pct_N_NaNO3)+(Raw_N2H4CO*pct_N_N2H4CO)+(Raw_N_other*pct_N_N_other)
95 / Percentage / Most likely percent NIT_LB as aqueous ammonia / c_NIT_pct_aqueous_NH3 / (Raw_aqueous_NH3*pct_N_aqueous_NH3*100)/((Raw_anhydrous_NH3*pct_N_anhydrous_NH3)+(Raw_aqueous_NH3*pct_N_aqueous_NH3)+(Raw_N2H4O3*pct_N_N2H4O3)+(Raw_N2H8SO4*pct_N_N2H8SO4)+(Raw_URAN*pct_N_URAN)+(Raw_NaNO3*pct_N_NaNO3)+(Raw_N2H4CO*pct_N_N2H4CO)+(Raw_N_other*pct_N_N_other)
96 / Percentage / Most likely percent NIT_LB as ammonium nitrate / c_NIT_pct_N2H4O3 / (Raw_N2H4O3*pct_N_N2H4O3*100)/((Raw_anhydrous_NH3*pct_N_anhydrous_NH3)+(Raw_aqueous_NH3*pct_N_aqueous_NH3)+(Raw_N2H4O3*pct_N_N2H4O3)+(Raw_N2H8SO4*pct_N_N2H8SO4)+(Raw_URAN*pct_N_URAN)+(Raw_NaNO3*pct_N_NaNO3)+(Raw_N2H4CO*pct_N_N2H4CO)+(Raw_N_other*pct_N_N_other))
97 / Percentage / Most likely percent NIT_LB as ammonium sulfate / c_NIT_pct_N2H8SO4 / (Raw_N2H8SO4*pct_N_N2H8SO4*100)/((Raw_anhydrous_NH3*pct_N_anhydrous_NH3)+(Raw_aqueous_NH3*pct_N_aqueous_NH3)+(Raw_N2H4O3*pct_N_N2H4O3)+(Raw_N2H8SO4*pct_N_N2H8SO4)+(Raw_URAN*pct_N_URAN)+(Raw_NaNO3*pct_N_NaNO3)+(Raw_N2H4CO*pct_N_N2H4CO)+(Raw_N_other*pct_N_N_other))
98 / Percentage / Most likely percent NIT_LB as URAN / c_NIT_pct_URAN / (Raw_URAN*pct_N_URAN*100)/((Raw_anhydrous_NH3*pct_N_anhydrous_NH3)+(Raw_aqueous_NH3*pct_N_aqueous_NH3)+(Raw_N2H4O3*pct_N_N2H4O3)+(Raw_N2H8SO4*pct_N_N2H8SO4)+(Raw_URAN*pct_N_URAN)+(Raw_NaNO3*pct_N_NaNO3)+(Raw_N2H4CO*pct_N_N2H4CO)+(Raw_N_other*pct_N_N_other))
99 / Percentage / Most likely percent NIT_LB as sodium nitrate / c_NIT_pct_NaNO3 / (Raw_NaNO3*pct_N_NaNO3*100)/((Raw_anhydrous_NH3*pct_N_anhydrous_NH3)+(Raw_aqueous_NH3*pct_N_aqueous_NH3)+(Raw_N2H4O3*pct_N_N2H4O3)+(Raw_N2H8SO4*pct_N_N2H8SO4)+(Raw_URAN*pct_N_URAN)+(Raw_NaNO3*pct_N_NaNO3)+(Raw_N2H4CO*pct_N_N2H4CO)+(Raw_N_other*pct_N_N_other))
100 / Percentage / Most likely percent NIT_LB as urea / c_NIT_pct_N2H4CO / (Raw_N2H4CO*pct_N_N2H4CO*100)/((Raw_anhydrous_NH3*pct_N_anhydrous_NH3)+(Raw_aqueous_NH3*pct_N_aqueous_NH3)+(Raw_N2H4O3*pct_N_N2H4O3)+(Raw_N2H8SO4*pct_N_N2H8SO4)+(Raw_URAN*pct_N_URAN)+(Raw_NaNO3*pct_N_NaNO3)+(Raw_N2H4CO*pct_N_N2H4CO)+(Raw_N_other*pct_N_N_other))
101 / Percentage / Most likely percent NIT_LB as other nitrogen fertilizers / c_NIT_pct_N_N_other / (Raw_N_other*pct_N_N_other*100)/((Raw_anhydrous_NH3*pct_N_anhydrous_NH3)+(Raw_aqueous_NH3*pct_N_aqueous_NH3)+(Raw_N2H4O3*pct_N_N2H4O3)+(Raw_N2H8SO4*pct_N_N2H8SO4)+(Raw_URAN*pct_N_URAN)+(Raw_NaNO3*pct_N_NaNO3)+(Raw_N2H4CO*pct_N_N2H4CO)+(Raw_N_other*pct_N_N_other))
102 / Percentage / Percent NIT_LB as anhydrous ammonia / NIT_pct_anhydrous_NH3
103 / Percentage / Percent NIT_LB as aqueous ammonia / NIT_pct_aqueous_NH3
104 / Percentage / Percent NIT_LB as ammonium nitrate / NIT_pct_N2H4O3
105 / Percentage / Percent NIT_LB as ammonium sulfate / NIT_pct_N2H8SO4
106 / Percentage / Percent NIT_LB as URAN / NIT_pct_URAN
107 / Percentage / Percent NIT_LB as sodium nitrate / NIT_pct_NaNO3
108 / Percentage / Percent NIT_LB as urea / NIT_pct_N2H4CO
109 / Percentage / Percent NIT_LB as other nitrogen fertilizers / NIT_pct_N_N_other
110 / Balance / Balanced percent NIT_LB as aqueous NH3 / Bal_NIT_pct_aqueous_NH3 / IF(NIT_pct_anhydrous_NH3=100,0,IF(NIT_pct_anhydrous_NH3+NIT_pct_aqueous_NH3>100,100-NIT_pct_anhydrous_NH3,NIT_pct_aqueous_NH3))
111 / Balance / Balanced percent NIT_LB as N2H4O3 / Bal_NIT_pct_N2H4O3 / IF(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3=100,0,IF(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+NIT_pct_N2H4O3>100,100-(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3),NIT_pct_N2H4O3))
112 / Balance / Balanced percent NIT_LB as N2H8SO4 / Bal_NIT_pct_N2H8SO4 / IF(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3=100,0,IF(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3+NIT_pct_N2H8SO4>100,100-(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3),NIT_pct_N2H8SO4))
113 / Balance / Balanced percent NIT_LB as URAN / Bal_NIT_pct_URAN / IF(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3+Bal_NIT_pct_N2H8SO4=100,0,IF(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3+Bal_NIT_pct_N2H8SO4+NIT_pct_URAN>100,100-(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3+Bal_NIT_pct_N2H8SO4),NIT_pct_URAN))
114 / Balance / Balanced percent NIT_LB as NaNO3 / Bal_NIT_pct_NaNO3 / IF(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3+Bal_NIT_pct_N2H8SO4+Bal_NIT_pct_URAN=100,0,IF(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3+Bal_NIT_pct_N2H8SO4+Bal_NIT_pct_URAN+NIT_pct_NaNO3>100,100-(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3+Bal_NIT_pct_N2H8SO4+Bal_NIT_pct_URAN),NIT_pct_NaNO3))
115 / Balance / Balanced percent NIT_LB as N2H4CO / Bal_NIT_pct_N2H4CO / IF(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3+Bal_NIT_pct_N2H8SO4+Bal_NIT_pct_URAN+Bal_NIT_pct_NaNO3=100,0,IF(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3+Bal_NIT_pct_N2H8SO4+Bal_NIT_pct_URAN+Bal_NIT_pct_NaNO3+NIT_pct_N2H4CO>100,100-(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3+Bal_NIT_pct_N2H8SO4+Bal_NIT_pct_URAN+Bal_NIT_pct_NaNO3),NIT_pct_N2H4CO))
116 / Balance / Balanced percent NIT_LB as other nitrogen fertilizers / Bal_NIT_pct_N_N_other / IF(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3+Bal_NIT_pct_N2H8SO4+Bal_NIT_pct_URAN+Bal_NIT_pct_NaNO3+Bal_NIT_pct_N2H4CO=100,0,100-(NIT_pct_anhydrous_NH3+Bal_NIT_pct_aqueous_NH3+Bal_NIT_pct_N2H4O3+Bal_NIT_pct_N2H8SO4+Bal_NIT_pct_URAN+Bal_NIT_pct_NaNO3+Bal_NIT_pct_N2H4CO))
117 / Consumption / N fertlizer applied as anhydrous NH3 (lb-N) / NIT_anhydrous_NH3_lb / NIT_LB*NIT_pct_anhydrous_NH3/100
118 / Consumption / N fertlizer applied as aqueous NH3 (lb-N) / NIT_aqueous_NH3_lb / NIT_LB*Bal_NIT_pct_aqueous_NH3/100
119 / Consumption / N fertlizer applied as ammonium nitrate (lb-N) / NIT_N2H4O3_lb / NIT_LB*Bal_NIT_pct_N2H4O3/100
120 / Consumption / N fertlizer applied as ammonium sulfate (lb-N) / NIT_N2H8SO4_lb / NIT_LB*Bal_NIT_pct_N2H8SO4/100
121 / Consumption / N fertlizer applied as URAN (lb-N) / NIT_URAN_lb / NIT_LB*Bal_NIT_pct_URAN/100
122 / Consumption / N fertlizer applied as sodium nitrate (lb-N) / NIT_NaNO3_lb / NIT_LB*Bal_NIT_pct_NaNO3/100
123 / Consumption / N fertlizer applied as urea (lb-N) / NIT_N2H4CO_lb / NIT_LB*Bal_NIT_pct_N2H4CO/100
124 / Consumption / N fertlizer applied as other nitrogen fertilizers (lb-N) / NIT_N_other_lb / NIT_LB*Bal_NIT_pct_N_N_other/100
125 / Production / Raw data for Wheat, spring (excl durum) - PRODUCTION, MEASURED IN BU / Raw_PROD_spring_wheat_BU
126 / Uncertainty / RSE for Raw_PROD_spring_wheat_BU / RSE_Raw_PROD_spring_wheat_BU
127 / Uncertainty / Probability for t_PROD_spring_wheat_BU / p_t_PROD_spring_wheat_BU
128 / Uncertainty / Standard normal at p for t_PROD_spring_wheat_BU / zp_t_PROD_spring_wheat_BU / SQRT(2)*(IF((2*p_t_PROD_spring_wheat_BU-1)<0,-1,IF((2*p_t_PROD_spring_wheat_BU-1)>0,1,0))*SQRT(SQRT((2/(PI()*0.140012289)+LN(1-(2*p_t_PROD_spring_wheat_BU-1)^2)/2)^2-LN(1-(2*p_t_PROD_spring_wheat_BU-1)^2)/0.140012289)-(2/(PI()*0.140012289)+LN(1-(2*p_t_PROD_spring_wheat_BU-1)^2)/2)))
129 / Uncertainty / Student's t for PROD_spring_wheat_BU / t_PROD_spring_wheat_BU / IF(<0.5,-SQRT(df*EXP(z^2*g_df)-df),SQRT(df*EXP(z^2*g_df)-df))
130 / Production / Wheat, spring (excl durum) - PRODUCTION, MEASURED IN BU / PROD_spring_wheat_BU / Raw_PROD_spring_wheat_BU*(1+t_PROD_spring_wheat_BU*RSE_Raw_PROD_spring_wheat_BU/100)
131 / Phys. or Thermo. / Standard lb per bushel / LB_per_BU
132 / Production / Production of wheat, spring (excl. durum) (kg) / PRODMASS / PROD_spring_wheat_BU*LB_per_BU*KG_per_LB
133 / Consumption Result / No N broadcast (Hectares) / NITHOX1_Hectares / NITHOX1_Acres*HA_per_AC/PRODMASS
134 / Consumption Result / All N broadcast with incorp. (Hectares) / NITHOX2_Hectares / NITHOX2_Acres*HA_per_AC/PRODMASS
135 / Consumption Result / All N broadcast without incorp. (Hectares) / NITHOX3_Hectares / NITHOX3_Acres*HA_per_AC/PRODMASS
136 / Consumption Result / Mixed N application method, with incorp. (Hectares) / NITHOX4_Hectares / NITHOX4_Acres*HA_per_AC/PRODMASS
137 / Consumption Result / Mixed N application method, without incorp. (Hectares) / NITHOX5_Hectares / NITHOX5_Acres*HA_per_AC/PRODMASS
138 / Consumption Result / N application method unspecified (Hectares) / NITHOXU_Hectares / NITHOXU_Acres*HA_per_AC/PRODMASS
139 / Consumption Result / N fertlizer applied as anhydrous NH3 (kg-N) / NIT_anhydrous_NH3_kg / NIT_anhydrous_NH3_lb*KG_per_LB/PRODMASS
140 / Consumption Result / N fertlizer applied as aqueous NH3 (kg-N) / NIT_aqueous_NH3_kg / NIT_aqueous_NH3_lb*KG_per_LB/PRODMASS
141 / Consumption Result / N fertlizer applied as ammonium nitrate (kg-N) / NIT_N2H4O3_kg / NIT_N2H4O3_lb*KG_per_LB/PRODMASS
142 / Consumption Result / N fertlizer applied as ammonium sulfate (kg-N) / NIT_N2H8SO4_kg / NIT_N2H8SO4_lb*KG_per_LB/PRODMASS
143 / Consumption Result / N fertlizer applied as URAN (kg-N) / NIT_URAN_kg / NIT_URAN_lb*KG_per_LB/PRODMASS
144 / Consumption Result / N fertlizer applied as sodium nitrate (kg-N) / NIT_NaNO3_kg / NIT_NaNO3_lb*KG_per_LB/PRODMASS
145 / Consumption Result / N fertlizer applied as urea (kg-N) / NIT_N2H4CO_kg / NIT_N2H4CO_lb*KG_per_LB/PRODMASS
146 / Consumption Result / N fertlizer applied as other nitrogen fertilizers (kg-N) / NIT_N_other_kg / NIT_N_other_lb*KG_per_LB/PRODMASS
1