Know who is a ROCKSTAR, who needs COACHING, and exactly WHAT to talk about.
BK Team Metrics is an Excel workbook that turns the weekly Adept 9 reports - All Alert Detail, Break Time and Escalation Detail - into a coaching dashboard for a slot attendant team. One Update button imports the files, compares every attendant with everyone else on the floor across nine metrics, and writes a plain-English breakdown for each person: their strengths, what to work on, how they are trending, and who stands out as a Rockstar or a Growth Candidate.
The week's three Adept reports.
One button imports them and rebuilds everything.
Team Progress for the team, the Coaching Corner for each person.
The focus, the facts, the tips and the videos are already on the page.
The numbers are not the point. The conversation is - and now it starts with facts.
Every attendant is ranked against everyone else who worked enough shifts - not against a guess. Top 25%, middle, or bottom 25%, on every metric.
Strengths, things to work on, patterns that combine metrics, and an overall summary with the one or two things to coach first.
Improving or declining since last week (or last month), with flags when a weak spot is getting worse or a strength is slipping.
Who to recognize in front of the team, and who has the most to gain from coaching. The rules are numbers you set.
A coaching list of long breaks, Busy right before a break, and escalations right before a break - with the time and the minutes, so nobody argues about "when".
What each metric means, why it matters, best practices and short training videos, chosen for whatever that person needs to work on.
Alerts finished per shift.
Assignment to arrival at the machine.
How long the alert stays open.
Minutes over the break allowance, per shift.
Breaks or lunches past their limit, per full-time week.
Busy taken right before a break.
Escalating right before a break, Busy or Guest Assist.
Busy plus break time, per shift.
Picking up alerts others escalated. Never held against anyone.
Everything lives inside the Excel file: the imported alerts, breaks and escalations, the comparisons and the written breakdowns. Importing the same week twice is safe - alerts already loaded are skipped - and the workbook tells you which weeks are still missing.
Built for Excel 2021 on a work PC. The HOME sheet shows one set of sheets at a time - the team view, setup, weekly stats, imported data or coaching - so the tabs never get overwhelming, and every rule is a number on the Setup sheet.
Pick one or more weeks of Adept downloads.
Name the team and tick your attendants (up to five on Team Progress).
Click a grey placeholder to give each person their picture.
Update Data is the only button you need after that.
Print it or pass it on:Download this brochure as a PDF