melisamikko.coma place for work

Details

ForThe sales floor of an insurance agency
StatusBuilt
SinceApril 2026
ReplacedA master Excel sheet fed by daily downloads from two systems
Built withReact, Supabase, Google sign-in

Contacting Melisa

Back to all work

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

  • Tracker dashboard: a grid of agents by day, coloured by result, with totals above
  • Daily upload screen where the two reports are dropped in
  • Attendance screen for marking each agent's day
  • Agent roster screen
  • Sign-in screen of the production tracker

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.