Production Case Study

Excel clinic system sold and used by two secretaries.

A production Excel system for a medical clinic that organizes appointments, separates morning and afternoon shifts, tracks payments and expenses, and gives the team daily and monthly visibility.

2

active secretaries

3k+

annual appointments

60%

less tracking time

Excel

production tool

Role

Business analysis, solution design, Excel build, deployment and user handoff

Users

2 medical secretaries

Status

Sold and deployed in clinic workflow

Stack

Excel, advanced formulas, conditional formatting, data validation

The problem

The clinic needed a clearer way to manage appointments and financial tracking. Manual methods made it harder to see daily performance, calculate balances and keep morning and afternoon shifts organized.

The goal

Create a practical Excel-based system that could be adopted quickly by secretaries, reduce calculation errors, organize appointments by shift and provide daily, monthly and annual summaries.

Product views

Monthly overview

Monthly overview

Daily appointment and finance totals aggregated into a month-level view.

Daily appointment sheet

Daily appointment sheet

Morning and afternoon shifts with payments, expenses and automatic balances.

Day totals

Day totals

Automatic totals for cash, transfers, consultations, expenses and balance.

Statistics dashboard

Statistics dashboard

Annual performance metrics and clinic overview.

Month navigation

Month navigation

Navigation across years, months, statistics and usage notes.

Configuration

Configuration

Clinic data, secretary names, contact fields and color guide.

What the system does

Appointment tracking

Organizes daily patients in separate morning and afternoon shift sections.

Financial control

Tracks cash, transfers, consultation prices, expenses and daily balances.

Monthly summaries

Aggregates daily sheets into month-level totals and quick navigation.

Statistics dashboard

Shows yearly clinic metrics and performance overview.

Secretary workflow

Keeps the interface familiar because the team already works in Excel.

Printable records

Uses structured sheets that can be printed and archived when needed.

How I built it

1

Observed the clinic workflow

The system came from seeing how secretaries handled appointment and financial tracking in daily work.

2

Chose Excel intentionally

Instead of forcing a new platform, I built inside a tool the team already understood, reducing adoption friction.

3

Delivered a usable system

The final workbook was sold, deployed and handed off to the clinic with a structure the secretaries could use every day.

Technical decisions

  • Separate daily sheets with morning and afternoon shift structures.
  • Cross-sheet formulas to aggregate daily totals into monthly summaries.
  • IF, AND, IFERROR and SUM logic to handle blanks and prevent calculation errors.
  • Data validation for specialties and consistent input options.
  • Conditional formatting and visual sections to make scanning easier for secretaries.
  • Print-oriented layouts for daily appointment and financial records.

Impact

The system is used by two secretaries in a real clinic workflow. It reduced appointment tracking time, removed manual balance calculations and gave the clinic clearer visibility into appointments and finances.

Why this project matters

This project shows that useful software is not always a full web app. Sometimes the right solution is a well-designed spreadsheet that fits the user's context and gets adopted quickly.