Skip to Main Content

Automate Data with Spreadsheets

These are not “your father’s spreadsheets”. We find that many people are put off by computer programming because the leading language keeps changing and the nuances of syntax, data architecture, and interfaces can be quite cumbersome to the novice.

But did you realize when you tell a spreadsheet to do certain calculations, analyses, or operations, you are programming? Most professionals in agriculture and related fields use spreadsheets regularly. Some of us may generate originals or significantly modify what we might get elsewhere. Some of us may just use what we see and change the inputs. Regardless, there is potential to do much more.

This video “demonstration” will give you some ideas for perhaps a better structure to your spreadsheets than you are used to seeing. The format demonstrated herein has been time tested and implemented by hundreds of students over recent years. But this video also uncovers a feature (macros or scripts), that isn’t necessarily new, but the availability in mobile platforms is relatively new.

Specifically demonstrated is a simple way to keep YOUR manure records in YOUR GoogleSheet. While a human must be “in the loop” to hit icons to save data, it is a nearly automatic way to record critical information you may need for reporting later – in a platform that is familiar to you. You could use a similar approach to track grain (or any other inventoried product) movement and inventories. You may take the demonstration file and duplicate it, control your permissions, and tailor it to your situation.

Screenshot of Manure Records SpreadsheetThis image to the right is an actual screen capture of a manure “app-like spreadsheet” from a phone.

The automated spreadsheets video will help you understand some of the differences between Microsoft Excel and Google Sheets and just might inspire you to start solving problems and answering “what if …” questions faster than ever before.

If you find this intriguing, also check out a different post regarding automated transfer and inventory records (like moving grain from field to bin, bin to bin, bin to elevator, etc.). That post explains why you should watch the video before getting the GoogleSheet.

Digital Agriculture Posts

uav in air
Fall 2022 Data-Driven Seminar Series

Purdue College of Agriculture presents a seminar series featuring experts in data science,...

Read More
soybean field with bins
Digital Marketing and Grain Delivery Records

Digital Marketing and Grain Delivery Records

Read More
Unmanned Aerial Vehicle sitting in  cornfield
Extension UAV Initiative Update

The Purdue University Cooperative Extension Service UAV (Unmanned Aerial Vehicle, aka drones)...

Read More
Research team in field
Long-range networks facilitate convenient producer data collection

Farming has forever and will always require efficiency and vigilance. Producers have long looked...

Read More
soybean field with bins
Digital Field Records: An Easy Way

Field records (who, what, where, how) are those elements of records and data that are often...

Read More
melons
Digital Records for FSMA: Free Toolkit

The Food Safety Modernization Act (FSMA) necessitates improved records of monitoring, cleaning,...

Read More
To Top