Data GenieBETA
-
R3ID Filters (Customs, TAR, rTSA etc.)
Filters
Product Group
0 selected
Product Name
0 selected
Case Type
Loading...
0 selected
Process Step
Click Load to populate
0 selected
Group
User
Click Load to populate
0 selected
User Role (applies when a user is selected)
Advanced Filters
Side
0 selected
Facility
State
Case Flags
0 selected
Surgeon (Last Name)
Quick view:
All Cases
Volume
-
PSP completed
Total Lead Time
- d
Avg - shipped
Segmentation LT
- d
Avg - seg completed
Surgeon Approval LT
- d
Avg - surgeon approved
Digital Production LT
- d
Avg - PSP completed
Volume: cases with first PSP reviewer accept in range. Total LT: ship date − scan date (shipped cases only). Seg LT: seg review − scan upload. Surgeon LT: surgeon approval − PSP review. Digital Prod LT: PSP review − scan upload, minus surgeon wait and on-hold time.
Excluding Outliers (digital_lt < 2x avg AND total_lt 50d)
Volume
-
Excl. outliers
Total Lead Time
- d
Avg - excl. outliers
Segmentation LT
- d
Avg - excl. outliers
Surgeon Approval LT
- d
Avg - excl. outliers
Digital Production LT
- d
Avg - excl. outliers
Same metrics, with outliers excluded: digital LT under 2× the population average AND total LT under 50 days.
WIP Pipeline Active cases at each step - excludes on-hold
Segmentation
-
Load WIP first
PSP
(CAD Active)
-
Load WIP first
Surgeon Approval
-
Load WIP first
Peer Review
-
Load WIP first
Manufacturing
-
Load WIP first
On Hold
-
Click Calculate
Segmentation: scan uploaded, seg review pending. PSP (CAD Active): seg done, PSP review pending, not awaiting surgeon. Surgeon Approval: PSP reviewed, awaiting surgeon. Peer Review: past PSP, peer review pending, not shipped — excludes marketing surgeon. Manufacturing: in mfg phase, work not complete — excludes marketing surgeon. On Hold: currently flagged on hold, any step.
Volume
Loading...
Click Update to load chart
Volume of cases with first PSP reviewer accept per period, grouped by product. Click a bar to view those cases. Monthly bars drill into weekly.
Lead Time Trend
Click Update to load chart
Average lead time per period for the selected metric (Total / Seg / Surgeon / Digital Prod), grouped by product. Click a bar to view those cases.
Utilization
Team Avg
—
Click UpdateClick Update to load chart
User work load: time signed off at each step ÷ standard time. By User view shows per-user breakdown; Trend shows total utilization over time.
First Pass Yield
Team Avg FPY
—
Click UpdateClick Update to load chart
% of cases that passed each step on the first review. Pass = reviewer's first signoff was ACCEPT (no rework loop).
Process Efficiency
Team Avg
—
Click UpdateClick Update to load chart
Standard time ÷ actual touch time × 100%. Workers only. Last signoff per step per case. Excludes pairs <2 min (click-throughs) and >8 hr (overnight gaps) — counts in Exclusion Breakdown →
Exclusion Breakdown
Total Excluded
—
Click Update
Click-through <2min
>200% of standard time
No pair found
Click Update to load chart
Signoffs excluded from efficiency calc by reason. High click-throughs = engineers signing off without self-assigning. >200% of standard time = elapsed time was implausibly long or outside acceptable range.
Design Time
Filter to Products (optional)
0 selected
Avg Actual
—
Avg Standard
Click Update
—
Click Update to load chart
Average actual vs. standard design time per case, from the same validated signoff pairs used by Process Efficiency (workers only, last signoff per step per case, click-through/overnight-gap pairs excluded) — so these numbers always agree with Process Efficiency for the same filters. Solid line = actual minutes, dashed = standard minutes. Product/Step/Designer/date-range filters come from the global filter bar above; "By Product/Step/Designer" picks which dimension breaks out the lines (chart) or rows (table).
Case List
Case List
Apply filters or click a KPI card button to load cases
| Case | Product | Phase | Surgeon | Total LT | Seg LT | Surgeon LT | Digital LT | Outlier | On Hold Days | Ship Date | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|
Apply filters or click a KPI card button to load cases | |||||||||||