The average annual rainfall in and around Kingsville, TX is roughly 24 inches/year. Roughly 1% of the rainfall is estimated to percolate into the ground and reach the water table (i.e., recharge the aquifer). A farmer intends to irigate his crops using well water. Of the extracted water 80% is lost to evapotranspiration and the remainder percolates back into the ground. How much groundwater could a farmer on a 20000 acre farm extract per year without depleting the groundwater reservoir. Develop a spreadsheet to make the necessary calculations.