⚙️

PRODUCTIVITY CALCULATOR

MHD Automobiles LLC — Aftersales Operations

→
Select date range above

Global Settings

Sun–Thu · 8 hrs/day
104 hrs
📂

Import from Excel

Upload your productivity sheet — matched by Technician Code (primary key). Only techs already in the list are updated — unrecognised codes are skipped entirely. Drag & drop or click Browse.

📋

Import Results

⚙ COLUMN MAPPING

Auto-detection couldn't find the right columns. Please select which columns in your file contain the data:

Rows in file—
Matched—
Skipped (not in list)—

TECHNICIAN DATA ENTRY

10 techs + 5 additional slots
CODE TECHNICIAN NAME TOTAL
ALLOWED HRS
TOTAL
WORKED HRS
OVERTIME
HRS
TOTAL
AVAIL HRS
PRODUCTIVITY

SUMMARY

Total Allowed Hrs
—
all active techs
Total Worked Hrs
—
clocked time
Total Overtime
—
hrs
Avg Productivity
—
workshop average
Top Performer
—
—

📊 PRODUCTIVITY RANKING

Formula: Productivity % = (Total Allowed Hrs ÷ Total Available Hrs) × 100  ·  Total Available Hrs = (Working Days × 8) + Overtime Hrs  ·  Colour key: 🔴 <80%  🟡 80–99%  🟢 100–129%  🔵 ≥130%