
Case Studies
Real operational problems.Real solutions, built from the inside.
These are real operational challenges I identified and solved during my time working inside NZ healthcare organisations. No simulated scenarios. No theoretical frameworks. These are examples of what I actually built — and what changed as a result.
CASE STUD STUDY 1
Automated Controlled Medication Record System
01
ORGANISATION TYPE
Residential care / disability support facility, NZ
SERVICE AREA
Healthcare Data & Reporting Solutions
Tools Used
Microsoft Excel
Advanced Formulas
Data Validation
Auto-Population
The Challenge
A healthcare facility was managing the administration of controlled drugs using a manual, paper-based recording system. Each administration required staff to manually record patient name, date and time, dose, and remaining stock balance. In practice — particularly during busy shifts — staff frequently forgot to complete entries at the time of administration. Entries were missed, times were estimated, and stock calculations were done by hand at month-end. The result was a recurring cycle of calculation errors, discrepancies in controlled drug records, and end-of-month compliance scrutiny. The organisation was spending significant time investigating errors that were entirely preventable — and staff morale suffered under the perception that they were being blamed for a system problem.
THE APPROACH
01
Auto-populated fields
Date, time, and shift information populated automatically — removing the most commonly missed manual entries.
02
Automated stock calculation
Formulas calculated remaining stock automatically after each entry, eliminating manual arithmetic.
03
Dropdown validation
Restricted input fields ensured staff could only enter valid data formats, preventing audit confusion.
04
Running balance visibility
Current stock balance always visible on the form — discrepancies became immediately obvious.
05
Simplicity by design
The form required fewer keystrokes than the paper system — adoption was earned, not mandated.
THE OUTCOME
Month-end calculation errors eliminated from the controlled drug record process.
Compliance scrutiny events related to medication records ceased.
Staff confidence and morale improved — the problem was correctly identified as a system failure, not a people failure.
Complete, auditable digital record of all controlled drug administrations, accessible for inspection at any time.
CASE STUD STUDY 2
Pair-Formation Rostering Model for Staff Continuity
02
ORGANISATION TYPE
Disability support / community health organisation, NZ
SERVICE AREA
Operations & Workforce Improvement
Tools Used
Microsoft Excel
Roster redesign
operational framework
Excel scheduling
The Challenge
As a Team Leader managing a disability support team, I was dealing with a persistent and demoralising operational problem: unexpected sick leave. One or more staff members calling in sick on any given day was not an occasional disruption — it was a near-daily occurrence. The traditional response was to scramble for a replacement, redistribute tasks ad-hoc, and hope critical client support was not missed. This created three compounding problems: inconsistent client support (whoever stepped in was unfamiliar with specific needs), overburdened resentful staff, and operational tasks completed incorrectly. Management could not solve the absenteeism itself — but the operational damage it caused was solvable.
THE APPROACH
01
Paired Accountability
Every staff member was assigned a designated partner for each shift. Each pair shared responsibility for a defined set of client support tasks. This was not just about coverage — it was about mutual ownership.
02
Built-In Continuity
If one member of a pair called in sick, the remaining partner had the knowledge, briefing and authority to complete the shift's tasks without management intervention.
03
Rotating Duty Allocation
Duties rotated across pairs on a structured schedule — every staff member developed familiarity with all client groups and task types.
THE OUTCOME
Roster continuity was maintained consistently, regardless of individual sick leave.
Client support quality improved — continuity of care was built into the structure, not dependent on who showed up.
Staff reported greater clarity about their responsibilities and less stress during disrupted shifts.
Management time spent on reactive rostering crisis was significantly reduced.
The model was adopted as the standard rostering approach for the team.