top of page
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.

Have a similar problem?

If any of this sounds like your organisation, the first 30-minute conversation is free. Let's optimize your operational pipelines.

bottom of page