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).
- 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)
Quality has 3 sub-scores that combine into a quality percent, then convert to points.
Quality has 3 sub-scores that combine into a quality percent, then convert to points.
DSB Count (50% of Quality)
Delivered < 500 packages: 0%
DSB Count = 0: 50%
DSB Count = 1: 25%
DSB Count ≥ 2: 0%
Delivered < 500 packages: 0%
DSB Count = 0: 50%
DSB Count = 1: 25%
DSB Count ≥ 2: 0%
POD (30% of Quality)
POD ≥ 99: 30%
POD 98 to <99: 25%
POD 97 to <98: 15%
POD 96 to <97: 5%
POD < 96: 0%
POD ≥ 99: 30%
POD 98 to <99: 25%
POD 97 to <98: 15%
POD 96 to <97: 5%
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%
Quality Percent Total = DSB% + POD% + CDF%
Quality Points = Quality Percent Total * 0.50
Quality % = (Quality Points / 50) * 100
Quality Points = Quality Percent Total * 0.50
Quality % = (Quality Points / 50) * 100
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 data and match the same driver.
Step 2: Compute Safety Points (0 or 30).
Step 3: Compute Quality Points from DSB/POD/CDF 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 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
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.