A unique full experiment season intermediate analysis Excel workbook is presented, containing an annotated variable list, and the primary investigation large data table linking all major experimental elements, such as the soil chemical and texture sampling, plus calculated and other values.

The MegaTable file is a version of Dr. Bronson’s intermediate analysis table. Therein is a list of variable names with their descriptions, although a few variables have not been full described. Additional soil fertility chemistry information and calculated values are also presented, and the file also serves as an example.

Nrate_ha is kg fertilizer N/ha
Nrate_lb_ac is lb fertilizer N/ac
Rain_mm is seasonal rain in mm
Irrig_mm is seasonal irrigation in mm
Water_mm is seasonal water input
NO3Appm is mg/kg 1 M KCL-extractable NO3-N in 0-12 inches or 0-30 cm
NO3Bppm is mg/kg 1 M KCL-extractable NO3-N in 12-24 inches or 30-60 cm
Zn_ppm is extractable Zn in ppm in 0-30 cm soil
Calcium_ppm is extractable Ca in ppm in 0-30 cm soil
CEC is cation ion exchange in 0-30 cm in mmol/kg
Sand_A is % sand in 0-30 cm soil
Sand_B is % sand in 30-60 cm soil
Sand_C is % sand in 60-90 cm soil
Sand_D is % sand in 90-120 cm soil
Sand_E is % sand in 120-150 cm soil
Plt_g58 is plant biomass sample in g on 58 day of year
Plt_ha58 is plant biomass in kg/ha on 58 day of year
pltN_58 is plant nitrogen content in % on 58 day of year
pltNha58 is plant nitrogen uptake in kg N/ha on 58 day of year
Grain_moist is in %
HHsed_g is final grain harvest by hand in g
HHYld_ha is final grain harvest by hand in kg/ha (dry basis)
CBsed_g is final grain harvest by combine in g
CBYld_ha is final grain harvest by combine in kg/ha
HI is harvest index (grain yield divide by total biomass)
Yellow_berry_per is yellow berry counts (%)
Weight_1000_seed_g is self-explanatory