One screen that knows where every machine is.
Scenario: An equipment rental yard tracking assets across nine spreadsheets
A purpose-built internal app replaces the spreadsheet stack: bookings, check-in and check-out, maintenance intervals, and who has what, working on a phone in a gravel lot.
double bookings possible by design
screen instead of nine files
history on every unit
The problem
Spreadsheets do not enforce anything. Two people book the same skid steer, a service interval slips, and the only person who really knows where things are is on vacation.
How the system works
- 1
Model the assets properly
Each unit is a row with a serial, a status, a location, and a history. Availability is derived from bookings, not typed by hand — that alone kills double-booking.
- 2
Booking with conflict rules in the database
Overlapping reservations are rejected at the data layer with an exclusion constraint, so no race between two dispatchers can create one.
- 3
Check-out and check-in from a phone
Scan the tag, photograph the condition, capture the signature. Offline-tolerant: the form queues and syncs when there is signal again.
- 4
Maintenance that schedules itself
Hours or mileage cross a threshold and the unit is auto-flagged, pulled from availability, and a work order is created before something breaks in front of a customer.
- 5
Role-based views
Yard crew see today's moves. Dispatch sees the week. The owner sees utilization and revenue per unit. Same data, three screens, enforced at the row level.
- 6
Migration from the spreadsheets
The existing files are imported, reconciled, and kept read-only for a month so nobody has to trust the new system on faith.
What keeps it safe
The part most vendors leave out of the demo.
- Row-level security so a yard login cannot read financials
- Full audit trail — every status change records who and when
- Nightly backups with a tested restore, not just a backup that exists
- Export to CSV always available; the business owns its data outright
Typical build time
8–12 weeks
Starting price
$15,000
Every build starts with a written scope and a fixed quote. Larger systems begin with a $2,500 paid discovery, credited toward the build — and yours to keep either way.