Weight Table
Import WEIGHT.xlsx
task, tracker_dimension_column, weight, Hours
| Task | Tracker Col | Weight% | Min |
|---|
No weight table loaded
Initials
Import INTIAL.xlsx
initial, Name
| Initials | Name |
|---|
No initials loaded
Tracker Data
Import TACKER.xlsx
Auto-detects header row & DATE/INITIAL pairs
Tracker
Page 1
rows/page
Import tracker data in Setup tab first
Report Filters
Total Circuits
0
Overall Completion
0%
tasks filled / total possible
Weighted Completion
0%
by weight %, not count
Total Hours Allocated
0
from weight table
Weekly KPI's for Team
Person KPI
| Initials | Name | Tasks Done | KPI Score (Weight% × Hours) | Hours | Circuits Touched | Contribution % | KPI/Hr |
|---|
Completion by Task
Person Productivity
Task Distribution (Who Does What)
Completion Over Time
Asset Editor
▼
Search or select an asset above to edit its task completions
Task-Level Breakdown
| Task | Weight % | Hours | Completed | Remaining | % Done | Progress |
|---|
Bottlenecks (Lowest Completion)
Workload Balance
Weekly Timesheet
| Week Ending | ST Hours | OT Hours | Total Hours | Equip ($) | Total Cost ($) | Notes | |
|---|---|---|---|---|---|---|---|
| TOTALS | 0 | 0 | 0 | $0 | $0 |
PO & Billing Info
$0.00
(from timesheet total cost)
Total Hours Charged
0
from timesheet
Total Hours Gained (Tasks)
0
completed tasks × weight hours
Variance (Hours)
0
charged - gained
Efficiency
-
gained / charged × 100
Total PO Amount ($)
$0
Total Billed Amount ($)
$0
from timesheet total cost
PO Balance ($)
$0
PO - billed
Cost per Circuit ($)
$0
billed / total circuits
Hours: Charged vs Gained
PO: Billed vs Balance
