Back to Blog

2026-06-04

Case Study: PAT Testing Register for 250+ Appliances

How a facilities manager replaced a paper-based PAT register with a digital system.

A facilities management company was tracking PAT testing for 250+ appliances across 3 buildings using paper records and an Excel spreadsheet.

The Problem

  • Paper records scattered across multiple sites.
  • Overdue tests discovered too late.
  • No overview of compliance status across all sites.
  • Insurance audits required hours of searching.

The Solution

A web-based register where every appliance has a record with location, test history, next test date, and RAG status. Automatic email alerts for upcoming and overdue tests. Built in 3 days.

The Result

  • 100% visibility of PAT compliance across all sites.
  • Overdue tests dropped from 15% to zero within 2 months.
  • Insurance audit completed in 5 minutes instead of half a day.

Got a Spreadsheet That's Driving You Mad?

Send it over — I'll tell you what an app version would look like and what it'd cost. No obligation.

You Might Also Like

2026-04-25

Testing Your New Software — A Checklist for Business Owners

How to test custom software before going live. A practical checklist covering functionality, data accuracy, user experie...

Read More

2026-02-15

Case Study — Custom Booking System in Under a Week

How I built a booking system for a dog grooming business in 5 days. Client profiles, appointment scheduling, automated r...

Read More

2026-01-10

Spreadsheet to Web App Migration — A Step-by-Step Guide

How to migrate a critical business spreadsheet to a custom web application. Data migration, user training, running in pa...

Read More