Results / Agribusiness and food
Three websites, ten locations, one chart. Every day.
Agronomists plan field work by the forecast. Instead of one to two hours of copying a day, the bot combines three sources into one overview and emails it.
- Client
- Leading regional energy and agribusiness group (NDA)
- Industry
- Agribusiness and food
- Systems
- Web, Excel, PowerShell, Outlook
~375 h
a year back to the team
3
sources in one overview
10
days of forecast, ~10 locations
01The challenge
To plan field work, agronomists need a 10-day temperature and rainfall forecast for about ten locations. Since weather services often disagree, several sources are compared.
Every working day someone opened three websites, copied the numbers into Excel and built a chart. It took one to two hours, every day.
02What the bot does
- For each location it collects the 10-day forecast from three weather sources.
- From each source it extracts minimum and maximum temperature and rainfall, converting units where needed.
- It fills in the Excel template and refreshes the chart.
- It exports the chart as an image and emails it to the agronomists in the message body, with the Excel attached.
03The result
Agronomists get the same comparable overview every day without opening a single website. The team gets back about 375 hours a year, the largest single saving of all the bots.
Manual work per year
Talk to us
What work does your team do only because someone has to?
Book 30 minutes. Show us the process and we’ll tell you whether it’s worth automating, how long it would take and how much time it gives back. You talk directly to the developer who builds the bot, not a salesperson.