Skip to Main Content

Easy Spreadsheet-style Transfer Records and Inventory Tracking

It is common to move materials such as grains from one place to another (on the farm or leaving the farm).  While there may be official “trade tickets” involved, we thought a simple transfer event tracker and approximate inventory tool would be useful. So, we generated a GoogleSheet with a couple simple macros or scripts to streamline these records.  This tool will make it very easy for farms or firms to track movement of products with an easy record of:

  • Who did the transfer
  • What was the origin
  • What was the destination
  • How much material was moved
  • Exactly what date/time did this occur

 

In conjunction with the transfer records, you automatically will have an updated approximate tally on balances or inventories in certain hoppers, bins, barns, fields, or bays. Check out this video for a brief demonstration. The video shows the tool in both PC and phone views. You’ll want to watch the video to see an important “hack” that allows you to fully use the tool on your smartphone.

The tool as it currently exists is tailored for grain movement, but it could easily be adapted to any other bulk or containerized products. We hope you find it useful.  You may freely copy/customize/use this tool.  If you do alter it and re-publish in some way, simply credit the original as noted in one of the spreadsheet cells.

The spreadsheet can be viewed by anyone; to use it, use your Google account and make a copy. Then customize away! We recommend to perhaps double check for your own satisfaction, that sharing of your copy is proper and appropriate for your farm or firm.

In a related post and associated video, you can learn a bit more of background on this approach toward automated spreadsheets and also see/copy a “manure records the easy way” 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