In the recent post, US Farmer Age is Inversely Related to Value of Production, average farm producer age in 2022 was 55 years of age on farms that had over $1,000,000 in annual farm production. All 3.5 million farm producers … Continue reading →
The USDA provides a treasury of farm data in many different formats. With decades of farm data experience, I hoped I could bring new insights into the ‘aging farmer’ discussion. What I learned instead is that hemp producers don’t fit … Continue reading →
The Big Beautiful Bill has passed. I am trying to keep up as best as a multi-value chain, policy-adjacent economist can. I am a professional skeptic, and therefore, am pretty sure that regardless of the new policy, we will forge … Continue reading →
The American Biogas Council (ABC) had made available current and potential capacity of local state-level biogases, also known as, biogenic methane and other gases produced from ambient organic feedstocks. The ABC has been in action for less than two decades, … Continue reading →
On a total energy consumption basis, the United States hovers just above 10 percent that is sourced from renewable fuels; wind, solar, biomass, hydroelectric, and geothermal feedstocks. On a recent road trip, it was clear that the Midwest States were … Continue reading →
Ben Laine, Terrainag.com wrote an interesting report dairy digester sustainability. One graphic message in an animated version of this map shows US dairy digester growth since 2001. Dairy digesters keep growing in size. The most recent digesters dwarf the earlier … Continue reading →
This final lesson on shaping data in Excel is brought to you by the St. Louis Federal Reserve Bank, Federal Reserve Economic Data (FRED) website. Reviewing the YouTube videos created for this data-shaping exercise, the 4 videos span 45 total … Continue reading →
A traditional way of shaping data in Excel is by using the VLOOKUP() function. After identifying the item to look up and the array in which to search for it, a range is identified where the new information can be … Continue reading →
One of the most powerful Excel function tools is the INDEX/MATCH() combination. It can be set to find specific character strings and deliver the cell contents at the intersection of the row and column string matches. This is the third … Continue reading →
When cleaning data files in Excel, one never moves away from manually pushing data around. Manually entering data by hand, sorting, and/or dragging and dropping in a new location; they all take time. But for small amounts of data, a … Continue reading →
