.png%3Ftable%3Dblock%26id%3Dd9ffa5b6-10d5-4a09-95fc-64a9f361bc37%26cache%3Dv2&w=3840&q=75)
Each year, Wallin Farms employees spend several weeks manually entering scale tickets from the year’s harvest into Excel. After my encounter with the process, I realized it could be automated with the use of scripting languages like Python and OCR engines like Google Vision.
So, I created a tool called SnapScale that turns images of scale tickets into Excel reports effectively reducing weeks worth of manual entry to just a few hours.
What started off as a CLI eventually became a web app so less technical employees could use it.
How it works
- Take photos of your scale tickets.
- Upload the photos to SnapScale.
- Download the Excel report.
Upload Tickets
Upload multiple pictures at once.
Ticket Viewer
View tickets in a grid with column sorting, filtering, and resizing.
Search Tickets
Search for uploaded scale tickets by date range and sale location.
Excel Export
Download an Excel document with the searched tickets.
CLI Demo
Desktop Web Demo
Mobile Web Demo
CropCache
Several years ago, my brother came to me with an idea for a mobile app that tracks the inventory levels for bins and bags throughout their southwest Nebraska farming empire.
At the time, I was still in school at UNL and getting my feet wet with software engineering; I just wasn’t ready for the task. But now that I’ve graduated from university and have completed several side projects and internships, I believe I’m ready for that task. And since I’m already developing SnapScale and the wallinfarms.us website, I might as well begin development on CropCache and integrate it alongside these systems.
Here’s our vision for CropCache:
- Bins/bags (caches) are created with total capacity and current capacity amounts.
- When scale tickets are processed by SnapScale, the amounts are subtracted from their respective cache.
- Caches can be viewed on a dashboard or map with their capacities displayed.
Dashboard
This will be a list of bins and their information
.png%3Ftable%3Dblock%26id%3D20c35a1d-210b-80ab-bc3b-f7e828407b0d%26cache%3Dv2&w=3840&q=75)
.png%3Ftable%3Dblock%26id%3D20c35a1d-210b-800e-a9da-ec70a79badb1%26cache%3Dv2&w=1920&q=75)
.png%3Ftable%3Dblock%26id%3D20c35a1d-210b-80b4-a9b4-c92fca95db5b%26cache%3Dv2&w=3840&q=75)
Map
This will be like google maps where each bin is displayed at its latitude/longitude coordinates with a preview of its information.
Tapping the preview will take you to its Detail page.
.png%3Ftable%3Dblock%26id%3D20c35a1d-210b-801b-99af-f9cd468dce2f%26cache%3Dv2&w=1920&q=75)
Detail
This will be a detailed view of a bin where you can update its information
Tapping a property will allow you to edit its value.
Tapping the coordinates will allow you to select a new location on the map.
.png%3Ftable%3Dblock%26id%3D20c35a1d-210b-801a-a768-dcddabd5353c%26cache%3Dv2&w=3840&q=75)
.png%3Ftable%3Dblock%26id%3D20c35a1d-210b-8032-80a7-dd39cda07b90%26cache%3Dv2&w=3840&q=75)