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.
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 | |||||||||||