Software Engineer - Wallin Farms

Software Engineer - Wallin Farms

Tags
Career
Python
React.js
Web Dev
Remote
Next.js
Vercel
Fullstack
Published
August 9, 2023
Author
Kalen Wallin
api_v1_role
Software Engineer
api_v1_company
Wallin Farms
api_v1_type
Freelance
api_v1_category
Career
api_v1_year
2024
api_v2_order
11

SnapScale

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 hours’ worth of photography.
Video preview
To streamline the use of SnapScale within the company, I created a website so employees can use the tool at any time, anywhere.
Video preview

How it works

  1. Take photos of your scale tickets.
  1. Upload the photos to SnapScale.
  1. Wait for the following information to be extracted and recorded into an Excel report: Date, Ticket, Gross Weight, Tare Weight, Moisture, Test Weight, Driver, and Truck. Further calculations are made for Net, Wet, and Dry.
  1. Download the Excel report.

Additional Information

The scale tickets are also saved to a database where they can be queried using the website’s report generator.

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 automatically subtracted from their respective cache.
  • Caches can be viewed on a dashboard or map with their capacities displayed as a pleasant graphic.

Bring it all together

Now that we have two potentially useful tools—SnapScale and CropCache—we need to unlock that potential with easy access for employees.
Enter websites.
Websites are the most easily accessible form of application because they can be accessed on almost any consumer device such as a computer, phone, or tablet. Since our employees are always on the move from field to field and cache to coop, they need to be able to access these tools on their mobile devices.
Mobile and desktop apps are great, don’t get me wrong. But websites work on either device and only need to be built once. Thereby reducing the development time and cost, while still providing the same value.