Performance Scorecard Tool

Role & Objective:

Automates performance tracking for the Data Collection team, providing employees with full transparency into their monthly scores, task breakdowns, and penalties without manual supervisor involvement.

Integrations (What It Is Connected To):

Master Sheet: The primary source containing company-wide quality logs and raw evaluation metrics.

Database Sheet: A filtered staging sheet that uses automated bulk scripts to sync and standardize data solely for target team members.

Web App Dashboard: A clean, standalone frontend where collectors search by their HR Code to view monthly cards and granular details.

Key Features (What It Does):

Interactive Deduction Drill-Down: Clicking any deduction penalty opens an itemized modal with match-level details (covering L/O, A-Review, Review App, Hypercare, Data Stability, and Rework).

Accurate Math & Floor Protection: Displays exact total deductions transparently, prevents scores from dropping below zero, and applies the +9 Operations Exception rule.

Dynamic Month Handling: Automatically defaults to the latest active month and hides newer September 2026 KPIs when viewing historical months like August.