The Ag Technologies Solutions Group, in Greenville, Illinois, has a vision for simplifying drone pilot training, Part 107 certification, and demystifying drone operations. ATSG has created a hands-on workshop on navigating the Federal Aviation Administration (FAA) policies surrounding piloting unmanned … 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 →
A good friend invited me to Hutchinson, Minnesota last weekend to celebrate a joyous life event. Working in the Midwest most of my career, it is often easiest just to drive rather than fly to neighboring states. Earlier in my … 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 →
The last few months have provided opportunity to flex my spreadsheet skillset. Excel code and technique seemed to erupt through the keyboard. In the last few months, diverse datasets have included: 2024 household food expenditures 2024 household power consumption and … Continue reading →
After all is said and done, this residential solar array in the non-winter months offset 67 percent of home power production. This chart is monthly solar production and household consumption in kilowatt hours (kWh). While it required both the solar … Continue reading →
The joy of finding a new dataset to explore enflamed my modeling focus more than was justified. IT WAS GREAT TO BE LOOKING FOR STORIES IN A BRAND NEW DATASET! Challenge #1: Monthly data from the power utility was too … Continue reading →
