BK Team Metrics
SLOT ATTENDANT COACHING  /  EXCEL  /  v3.6.13
BK Team Metrics

Every attendant, measured against the whole floor - in plain English.

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.

  • Excel 2021 or newer
  • Data stays in the workbook
  • One button, about a minute
The Coaching Corner page for one attendant. Sample data.
The old way and the new way

Stop staring at report exports. Start the coaching conversation.

By hand
  1. Pull the Adept reports
  2. Build pivots and filters every week
  3. Eyeball who looks slow or busy, with no idea how the rest of the floor compares
  4. Write coaching notes from memory - or not at all.
With BK Team Metrics
  1. STEP 1

    Download

    The week's three Adept reports.

  2. STEP 2

    Update

    One button imports them and rebuilds everything.

  3. STEP 3

    Read

    Team Progress for the team, the Coaching Corner for each person.

  4. STEP 4

    Coach

    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.

What you get

Fair, specific, and ready before the shift starts.

Compared with the whole floor

Every attendant is ranked against everyone else who worked enough shifts - not against a guess. Top 25%, middle, or bottom 25%, on every metric.

Written in plain English

Strengths, things to work on, patterns that combine metrics, and an overall summary with the one or two things to coach first.

Trends, week over week

Improving or declining since last week (or last month), with flags when a weak spot is getting worse or a strength is slipping.

Rockstars and Growth Candidates

Who to recognize in front of the team, and who has the most to gain from coaching. The rules are numbers you set.

The exact events

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".

Tips and training built in

What each metric means, why it matters, best practices and short training videos, chosen for whatever that person needs to work on.

The nine metrics

Every name says what good looks like, so #1 is always the best.

How it runs

One workbook. One button. Nothing to install.

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.

Getting started

Set up in a few minutes.

  1. Import

    Pick one or more weeks of Adept downloads.

  2. Change Team

    Name the team and tick your attendants (up to five on Team Progress).

  3. Add photos

    Click a grey placeholder to give each person their picture.

  4. Update weekly

    Update Data is the only button you need after that.

Print it or pass it on:Download this brochure as a PDF