⚙️

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%