Module 3

profileQueenQuanna
Wingait.xlsx
Home>Education homework help>Module 3

Documentation

Wingait Farm
Author
Date
Purpose To calculate the yield and growth of a corn hybrid being grown on the farm

Yield

Wingait Farm
Corn Yield Calculator
Total Corn Crop (acres)
Sample Plot Agricultural Constants
Number of Rows Square Feet in an Acre 43,560
Row Width (ft.) Standard Corn Moisture Content 15.50%
Row Length (ft.) Pounds of Corn in a Bushel 56
Sample Area (acres) Market Price per Bushel $3.85
Corn Weight
Sample Weight (lbs.)
Moisture Content
Dry Weight (lbs.)
Market Weight (lbs.)
Yield
Sample Bushels
Bushels per Acre
Total Yield (bushels)
Projected Market Revenue

Yield History

Wingait Farm
Corn Yield History
Summary Year Yield (Bushels/Acre) Notes
Years 1995 176 In 2006, what would become Wingait Farm was undergoing foreclosure. While a corn crop was harvested that year, a reliable estimate of the 2006 yield is not available.
Average Yield 1996 151
Minimum Yield 1997 184
Maximum Yield 1998 172
Median Yield 1999 177
2000 172
2001 158
2002 174
2003 183
2004 144
2005 102
2006
2007 169
2008 168
2009 170
2010 185
2011 184
2012 187
2013 185
2014 178
2015 179
2016 183
2017 168

Growth

Wingait Farm
Corn Growth Calculator
Current Date Farm Day Daily Low (°F) Daily High (°F) Tmin Tmax GDD Cumulative GDD Harvest Ready Date Growing Temperatures
45 52 Range Temp (°F)
Estimated Stage Dates 42 64 Base Temp 50
Planting Date 38 70 Min Temp 50
Emergence 43 76 Max Temp 86
First Leaf 47 74
Pollination 45 74 Stages of Corn Growth
First Grains 47 71 Stage Day
Solid Grains 56 68 Emergence 5
60 85 First Leaf 8
Hybrid Summary 61 71 Pollination 72
Corn Hybrid 62 80 First Grains 88
Yield 65 79 Solid Grains 106
Stalk Height 67 80
Maturity (GDD) 56 70 Corn Hybrids
53 75 Hybrid Yield Height Maturity (GDD)
Harvesting 59 73 CS6300 Very Good Medium Tall 2521
Harvest Date 47 59 CS6389 Good Medium Tall 2640
43 69 CS6403 Very Good Medium 2725
49 73 CS6478 Very Good Medium 2795
54 62 CS6488 Excellent Medium 2790
57 76 CS6489 Excellent Tall 2920
62 82 CS6492 Excellent Medium 2768
63 78 CS6538 Excellent Medium 2847
43 63
39 59
44 53
41 77
50 78
57 76
60 72
63 81
62 71
57 82
62 78
61 76
56 64
50 71
52 73
54 73
61 78
63 80
67 86
66 77
66 87
62 89
65 95
73 91
65 77
63 70
65 77
70 81
64 76
60 81
69 85
64 79
63 82
64 93
68 85
72 89
62 83
64 79
67 79
64 77
61 84
64 86
65 83
67 82
63 76
59 71
59 80
61 82
65 89
66 79
58 74
60 70
58 82
63 82
70 86
74 93
77 97
73 91
72 80
71 88
74 95
76 90
72 85
68 87
62 82
63 80
67 86
70 88
74 89
70 90
71 86
71 89
68 86
64 89
69 90
68 88
73 93
67 84
66 79
69 81
67 84
69 90
72 84
71 85
67 85
63 86
65 87
66 87
71 89
69 88
69 89
71 78
60 72
57 68
53 80
63 83
65 84
56 73
53 76
53 77
53 79
57 76
64 79
64 73
60 79
68 88
69 90
71 89
73 91
71 91
73 93
72 94
71 87
67 82
64 82
65 84
55 70
49 71
49 75
60 84
67 87
66 89
72 87
53 73
50 71
50 75
55 78
66 83
67 78
67 80
63 82
59 81
59 81
60 85
54 72
47 67

Explanation of Formulas

Wingait Farm
Functions and Constants
Measures of Corn Yield
Sample Area The size of the sample area (in acres) used to estimate corn yield is calculated as:
area = 2 * rows * length * width / 43560
where rows = number of corn rows in the sample area length= length of each row in feet width = width of each row in feet
Dry Weight of Corn The dry weight (in pounds) is the weight of the corn kernels without the moisture content. Dry weight is calculated as:
dry weight = weight * (1 - moisture)
where weight = weight of the corn in pounds moisture = percentage of the corn weight due to moisture
Market Weight The market weight (in pounds) of corn used to determine the market price is calculated as:
standard weight = dry weight / (1 - 0.155)
where dry weight = dry weight of the corn
Bushels To convert the standard weight of corn to bushels, use the formula:
bushels = standard weight / 56
Measures of Corn Growth
GDD The Growing Degree Day or GDD measures the growth of a crop in response to changing temperature. GDD is calculated using the formula:
GDD = (Tmin + Tmax) / 2 - Base
where Tmin = minimum daily temperature (°F) Tmax = maximum daily temperature (°F) base = baseline temperature (°F) for the crop
Note that Tmin and Tmax cannot be lower or higher than a set value. For corn, Tmin cannot be lower than 50 and Tmax cannot be higher than 86.