192 Hours Saved Annually with Mileage Map Automation

A company's HR team spent around 16 hours every month creating mileage maps for more than 200 employees. The process relied on manually handling Excel files, generating routes one by one, and checking the results before they could be used for payroll.

I replaced the entire workflow with an automated solution. The system reads the Excel file, generates every mileage map automatically, and prepares the final output without manual intervention.

What previously took two full working days is now completed in a few minutes.

Results

• 99% reduction in processing time

• 16 hours saved every month

• 192 hours saved every year

• 200+ employee routes generated automatically

• Consistent results with no repetitive manual work

Technologies
Excel • Visual Basic