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

Purdue-led TOMI project receives $3.5M grant to turn a decade of data into new tools and strategies for tomato farmers

Indiana ranks third in the nation for tomato production. Lori Hoagland, a professor in Purdue...

Purdue research team uses a computer on top of a drone to gather data

Purdue researchers acquire and analyze data through AI network that predicts maize yield

Artificial intelligence (AI) is the buzz phrase of 2024. Though far from that cultural spotlight,...

Siddhartho Paul and his students use a RTK GPS in a soybean field to get precise location information

Satellites and soils: NIFA and AgSEED grants fund remote sensing data collection and machine-learning models to predict soil properties at farm-to-landscape scales

The few inches of soil you pick up on the tip of your shovel are part of a much bigger picture....

Data-Driven Seminar Series

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

two students lean over a counter as the tinker on a remote controlled car together

Digital Ag Club’s Scarecrow-bot making its debut at Boiler Gold Rush

Thumping hind legs. Two pointed ears. White, fluffy cottontails. The markers of an enemy to...

Songlin Fei, director of Purdue’s Institute for Digital Forestry and professor in the Department of Forestry and Natural Resources, standing among the trees in Martell Forest.

The Society of American Foresters honors Purdue professor with Award in Forest Science

The Society of American Foresters (SAF) annually recognizes individuals for their outstanding...