Weekly DA Ranking - How It Works
This page explains exactly how Weekly DA Ranking is computed. Final output is shown as percentages: Overall Rating %, Safety %, Quality %, and Speed %.
Inputs Used
- Cortex PDF: Delivered count, safety/violation rates, star and quality metrics.
- Email text: Weekly values (especially Weekly Ave. SPH for speed scoring).
- Coaching Tracker (.xlsx): Route Performance Coaching Tracker with one row per coaching email (Driver Name + Coaching Email date). Used for the CRP part of Quality. Only entries dated inside the selected ranking week (Sunday–Saturday, e.g. Wk 31 = Jul 26–Aug 1) are counted. The week auto-fills from the “Wk ##” in the pasted email text and can be changed on the form.
- Name matching: The system first tries full-name match, then first-name + last-initial, then unique first-name-only match. Displayed name stays the full name from the PDF.
Scoring Model
Rank is based on Overall Rating % (highest first).
Rating Points = Safety Points + Quality Points + Speed Points
Overall Rating % = Rating Points (0 to 100)
Overall Rating % = Rating Points (0 to 100)
1) Safety Violations (30 points)
Safety checks these values: SER, SOR, DR, FDR, SSVR.
If all available safety values are exactly 0.00, Safety Points = 30.
If any available safety value is greater than 0.00, Safety Points = 0.
Safety % = (Safety Points / 30) * 100
Safety checks these values: SER, SOR, DR, FDR, SSVR.
If all available safety values are exactly 0.00, Safety Points = 30.
If any available safety value is greater than 0.00, Safety Points = 0.
Safety % = (Safety Points / 30) * 100
2) Quality / Defects (50 points total)
The current formula has 4 sub-scores (DSB 45% + POD 20% + CDF 20% + CRP 15%) that combine into a quality percent, then convert to points.
The current formula has 4 sub-scores (DSB 45% + POD 20% + CDF 20% + CRP 15%) that combine into a quality percent, then convert to points.
DSB Count (45% of Quality)
Delivered < 500 packages: 0% (does not apply to exempt drivers)
DSB Count = 0: 45%
DSB Count = 1: 22.5%
DSB Count ≥ 2: 0%
Delivered < 500 packages: 0% (does not apply to exempt drivers)
DSB Count = 0: 45%
DSB Count = 1: 22.5%
DSB Count ≥ 2: 0%
OMs, OLs, Leads and Rescuers can be exempted from the under-500-package rule via
Driver Exemptions on the Weekly DA Ranking page. Exempt drivers are scored on
DSB Count normally regardless of packages delivered; every other criterion is unchanged.
POD (20% of Quality)
POD ≥ 99: 20%
POD 98 to <99: 16.67%
POD 97 to <98: 10%
POD 96 to <97: 3.33%
POD < 96: 0%
POD ≥ 99: 20%
POD 98 to <99: 16.67%
POD 97 to <98: 10%
POD 96 to <97: 3.33%
POD < 96: 0%
CDF DPMO (20% of Quality)
CDF = 0: 20%
CDF 1 to 2000: 10%
CDF > 2000: 0%
CDF = 0: 20%
CDF 1 to 2000: 10%
CDF > 2000: 0%
CRP — Coaching Route Performance (15% of Quality)
Counted from the Route Performance Coaching Tracker upload. Only coaching emails dated inside the selected ranking week (Sunday–Saturday, e.g. Wk 31 = Jul 26–Aug 1) count; older or newer entries are ignored. A driver counts at most once per day: duplicate entries for the same driver on the same date collapse to 1, while entries on different days of the week each count.
0 coaching emails: 15%
1 coaching email: 10%
2 coaching emails: 5%
3 or more: 0%
Counted from the Route Performance Coaching Tracker upload. Only coaching emails dated inside the selected ranking week (Sunday–Saturday, e.g. Wk 31 = Jul 26–Aug 1) count; older or newer entries are ignored. A driver counts at most once per day: duplicate entries for the same driver on the same date collapse to 1, while entries on different days of the week each count.
0 coaching emails: 15%
1 coaching email: 10%
2 coaching emails: 5%
3 or more: 0%
Quality Percent Total = DSB% + POD% + CDF% + CRP%
Quality Points = Quality Percent Total * 0.50
Quality % = (Quality Points / 50) * 100
Quality Points = Quality Percent Total * 0.50
Quality % = (Quality Points / 50) * 100
Legacy formulas remain selectable on the ranking page: DSB 50% + POD 30% + CDF 20%
(previous default, same tier logic at the old weights) and DSB 60% + POD 40% (No CDF test).
3) Speed (20 points)
Weekly average SPH > 20: 20 points
SPH from 20 down to 12: drops by 2 points each step
SPH < 12: 0 points
Missing Weekly SPH: 0 points
Speed % = (Speed Points / 20) * 100
Weekly average SPH > 20: 20 points
SPH from 20 down to 12: drops by 2 points each step
SPH < 12: 0 points
Missing Weekly SPH: 0 points
Speed % = (Speed Points / 20) * 100
Tie-breakers
If Overall Rating % is tied, the tool uses this order:
Safety Points, then Quality Points, then Speed Points, then Delivered, then Name.
If Overall Rating % is tied, the tool uses this order:
Safety Points, then Quality Points, then Speed Points, then Delivered, then Name.
Computation Flow
Step 1: Parse PDF + Email + Coaching Tracker data and match the same driver.
Step 2: Compute Safety Points (0 or 30).
Step 3: Compute Quality Points from DSB/POD/CDF/CRP rules (0 to 50).
Step 4: Compute Speed Points from Weekly SPH (0 to 20).
Step 5: Add points to get Rating Points (0 to 100).
Step 6: Convert each category to percentages for display.
Step 2: Compute Safety Points (0 or 30).
Step 3: Compute Quality Points from DSB/POD/CDF/CRP rules (0 to 50).
Step 4: Compute Speed Points from Weekly SPH (0 to 20).
Step 5: Add points to get Rating Points (0 to 100).
Step 6: Convert each category to percentages for display.
Violation Components
The violation scoring part uses these columns when available:
- SER (Speeding Event Rate)
- SOR (Seatbelt Off Rate)
- DR (Distractions Rate)
- FDR (Following Distance Rate)
- SSVR (Sign/Signal Violations Rate)
Abbreviations
SERSpeeding Event Rate
SORSeatbelt Off Rate
DRDistractions Rate
FDRFollowing Distance Rate
SSVRSign/Signal Violations Rate
PODPhoto-On-Delivery Acceptance Rate
CDF DPMOCustomer Delivery Feedback Defect Per Million Opportunities
DSB CntDSB Count
CRPCoaching Route Performance (coaching emails in the ranking week, Sun-Sat)
Important Notes
- This tool is currently focused on weekly scoring. 6-week trailing values are not used in ranking.
- POD values with percent signs (like 95.5%) are supported.
- When no safe unique name match is found, email metrics stay blank for that driver.
- Rank numbers are generated after the full sorted list is finalized.