Cycle Time Dashboard

Build Duration by Job

Idle Days by Stage — completed stages only

Total Idle Days — completed builds only (apples-to-apples)

All Builds

Job	Subdivision	Style	Calendar Days	Task Days	Idle Days	Idle %	Status

Home Style:

Template vs. Actual Task Duration (days)

Task Duration Benchmarks

Task	Template	Actual Avg	Variance	Trend

Phase Duration by Home Style

Idle by Stage — builds are graded only on stages they've completed

Foundation = Excavation→Backfill · Shell = Framing→Dried-In · Rough-Ins = Mechanicals · Finishes = Drywall→Closing. Idle % = idle weekdays ÷ stage business days. Colors compare each build to the average for that stage. Older seed builds (no task-level data) are excluded.

Idle Days by Job (sorted worst to best)

Idle Days Heatmap — Phase Transitions by Job

Idle Days by Sub (who's costing the most waiting time)

Drop BuilderTrend Schedule Exports

Drag .xlsx files exported from BuilderTrend here. You can drop multiple files at once. New data merges with the existing ${''} dataset — duplicates are updated, not duplicated.

Drop .xlsx files here

Or click to browse. Accepts BT schedule export format.

Review & Download

Saves directly to the portal database. Dashboard updates immediately.

Time window: Computed live from imported schedules (idle counted after excavation, weekdays only). Builds without task detail are excluded.

Sub Idle Days

Avg Idle per Job — concentration vs. spread

Sub Performance Scorecard

#	Sub	Trade	Idle Days Caused	Tasks	Jobs	Avg Idle / Job	Avg Task Over	Early Starts	Est. Cost (Tier 1)	Grade

Idle Days Caused = weekday gaps sitting in front of this sub's tasks (the job was ready, they weren't there). Early Starts = tasks begun before the preceding trade finished — showing up before the job is ready. Subs with no work in the window are listed at the bottom.