A shared spreadsheet replaced by an app
- Problem
- Technicians report their jobs by text message, and the schedule lives in a shared spreadsheet edited by five people.
- Solution
- A simple web app: technicians log their jobs on mobile, and the schedule and invoicing update.
- Expected result
- One version of the schedule, complete job reports and invoices that go out sooner.
| Before | After | |
|---|---|---|
| Field reports | Text messages and paper | Mobile entry, with photos |
| Schedule | A shared spreadsheet, several versions | One app, one version |
| Invoicing | Retyped from notes | Prepared from job reports |
What will be measured
- Delay between job and invoice
- Number of incomplete job reports
- Time spent preparing the schedule
Measured by: the operations manager, over one month before and one month after.