Live Intraday Attendance & Conformance Tracker (NICE IEX + Excel)
The Challenge
Restricted tool access made it impossible to track live attendance, absence minutes, or non-productive intervals across 650+ agents and 22 LOBs.
The Solution
Engineered an automated workbook combining shift schedules with NICE IEX interval exports. Built dynamic roster filters, exact first-login / last-logout array logic, and status engines.
Business Impact
Eliminated manual reporting delays, reduced reporting time to < 1 minute, and provided interval-level visibility across 2 Management Units.
100% Native Formulas · No Macros · Fully Scalable