bg_BRIAN GOETZSOFTWARE / SECURITY / HARDWARE
← Back to the workbench
BALTIMORE COUNTY / DESIGNED, BUILT & DEPLOYED

Shiftcraft

Shift rotations, leave groups & court scheduling

Originally deployed as Schedule Monkey

Shiftcraft emblem

I designed, built, and deployed Shiftcraft to simplify a scheduling process that was rebuilt manually each year. Supervisors maintained an Excel workbook covering multiple leave groups, alternating days off, and shifts that rotated between mornings and evenings every two weeks. They also tracked training, vacations, and court appearances.

Shiftcraft maintained a database of leave groups and employee assignments, calculated days-off and shift rotations, and assigned court days around each employee’s days off. It also automated the required individual Word documents for the courts, incorporating court and training dates from the schedule.

Scheduling automationDatabase designExcel & Word integration

The problem

Supervisors maintained a complex annual schedule alongside separate court-availability documents for each employee.

My contribution

Designed the scheduling database and application, implemented rotation calculations and court-day assignments, and automated document generation.

What it delivered

A coordinated workflow for leave-group assignments, rotating shifts, training, vacation planning, and employee court schedules.

← All projects
SYSTEM DETAIL