The daily spreadsheet routine, replaced by an app
An app for tracking daily sales agent performance, replacing a manual routine of downloading reports and pasting them into Excel.
Pics
The real app, shown with made-up sample agents and numbers. The company logo is blurred. Click a picture to see it full size.
The problem
Every day someone downloaded reports from two systems and pasted them into a master spreadsheet to see how each sales agent was doing. It was slow, and one bad paste broke the numbers.
What I built
- A tracking app with its own database that takes in the daily reports from both systems.
- Invite-only access through Google sign-in, so only the people who should see agent numbers can.
What changed
The numbers live in one place with one definition, not in a file that depends on who pasted it that morning.