Time Tracker — Developer Accountability Dashboard
The Time Tracker measures developer activity by analyzing git commit timestamps. No manual time entry required — just commit your code as normal, and the system does the rest.
How Data Gets Here
Git commits → Sync Engine (parses git log) → SQL table (TimeTracker_Daily) → Dashboard
Sync is manual — click the Sync Now button on the dashboard, or run .\_time_tracker_sync.ps1 in PowerShell. Chat alone does not register as work — only git commits create time tracker data.
Scorecard (Top Row)
| Card | What It Shows | Source |
|---|
| Files Documented | Count of distinct files across all commit diffs | Sum of FilesDocumented from TimeTracker_Daily |
| Productivity % | Active coding minutes divided by total span minutes | Average of Productivity column |
| Verdict | Quick-glance productivity assessment | Derived from Productivity % |
Verdict Thresholds
| Productivity | Verdict | Color |
|---|
| 80%+ | HIGH - ON TRACK | Green |
| 50-79% | MODERATE | Blue |
| 20-49% | LOW - REVIEW | Orange |
| Under 20% | LOW - INVESTIGATE | Red |
Important: Productivity % is a git-commit-frequency proxy, not a measure of actual keystrokes or effort. It measures time gaps between commits relative to total session span. Long sessions with few commits = low %. Frequent small commits = high %. A "LOW - INVESTIGATE" verdict is a conversation starter, not an accusation.
Active Workers Strip
Shows who has committed recently using a live git log check:
- Green = Active (committed within 30 minutes)
- Orange = Recent (committed within 2 hours)
- Gray = Offline (no recent commits)
Goals Panel
Goals are data-driven from the TimeTracker_Goals table. Use the + button to add a goal and the × button to remove one. Deleted goals are soft-deleted — you can always re-add them.
| Goal Type | What It Measures | Calculation |
|---|
| Daily Avg Hours | Average hours per working day | Total hours ÷ distinct days with commits |
| Period Hours | Total hours in the selected date range | Sum of BillableHours across all rows |
| Workstream Target | Hours on a specific workstream | Sum of BillableHours where Workstream matches |
Progress bar colors: Red (<60%), Orange (60-99%), Green (100%+)
Workstream Breakdown Chart
Color-coded horizontal bars showing hours per workstream. Workstreams are auto-detected from git file paths during sync:
- Admin — Files in /Admin/ folder
- BibleJourney — Files in /BibleJourney/ folder
- Members — Files in /Members/ folder
- TimeTracker — Files matching _time_tracker* pattern
- Mission Control — Files matching *mission* or *scan* patterns
- Prayer Board — Files matching *prayer* pattern
- General — Everything else
Data Table
One row per author/date/workstream. The detail icon opens a Review modal showing changelog excerpts, journal notes, and git session details for that day.
Key Rule
Chat alone does not register as work. Only git commits create time tracker data. Commit early, commit often.
