Data GenieBETA
-
Digital Production Report Generator
Report Filters
Last 6 Months
Last 12 Months
Select Month
Custom Range
Product Group
0 selected
Product Name
0 selected
Case Type
Select a product first
0 selected
Trend Granularity
More Filters
Surgeon (Last Name)
Facility
State
Case Flags
0 selected
Efficiency Filters (for Process Efficiency & Exclusion charts)
Process Step
Click Load to populate
0 selected
Engineer
Click Load to populate
0 selected
Select step first, then load engineers. Leave both blank = all steps & all engineers.
Charts to Include
Default Charts
Optional Charts
PDF Layout
Fetching data...
Crunching numbers...
0%
Initialising...
Digital Production Metrics
—
—
Case Volume
—
PSP completed
Cases whose effective PSP date falls in range. Effective PSP = earliest of PSP reviewer accept, peer review accept, or ship date.
Avg Total Lead Time
— d
Ship to scan
Days from first scan upload to ship complete, minus on-hold days.
Avg Digital Prod LT
— d
PSP completion
Days from first scan upload to PSP completion, excluding surgeon wait and on-hold time.
On Hold Cases
—
Current snapshot
Cases currently flagged on hold. Snapshot ignores date filter.
WIP Pipeline (Current)
Segmentation
—
Scan uploaded, segmentation not yet reviewed.
PSP / Design
—
Segmentation done, PSP not yet reviewed and not awaiting surgeon.
Surgeon Approval
—
PSP reviewed, awaiting surgeon approval. Includes cases held in design call prep queue.
Peer Review
—
Past PSP (any of PSP / peer review / ship), peer review not done, not shipped. Excludes marketing surgeon cases.
Manufacturing
—
In manufacturing phase, work not yet complete. Excludes marketing surgeon cases.
On Hold
—
Cases currently on hold across any step. Click to see hold reason & duration.
Volume & Pipeline
Case Submission vs. Completion
Submitted = cases with first scan upload in range. Completed = cases with first PSP reviewer accept in range. Click a bar to view those cases.
Digital Production WIP Trend
Cases in digital production pipeline (Scan Assessment → Peer Review) at end of each period. A case exits WIP when its peer review date falls before the period end — regardless of current phase. Excludes on-hold and marketing surgeon cases at every snapshot. Click a point to view cases in that snapshot.
Process Performance
Completed Cases Per Process
Distinct cases that completed each step in the date range. Scan Assessment uses worker accept; all other steps use reviewer accept. Cases skipping a step but completing a later one count as implicitly complete. Click a bar to view those cases.
Reviewer / Approver ACCEPT signoffs per step in the selected period
Lead Time by Step (Calendar Days)
Average calendar days from previous step's effective completion to this step's effective completion. Peer Review excludes surgeon wait. Population per step matches the Completed Cases chart. Click a bar to view cases.
Sub-step LTs scaled from Digital Production LT · Surgeon Approval drawn directly from KPI
Quality & Delivery
First Pass Yield by Step
Colors auto: ≥95% green · ≥80% amber · below red
% of cases that passed each step on the first review. Pass = reviewer's first signoff was ACCEPT. Cases implicitly complete via a later step also count as pass. Population per step matches the Completed Cases chart. Click a bar to view cases.
Digital Production On-Time Delivery
—
On Time %
—
On Time
—
Delayed
—
Denominator = all cases with effective PSP completion in range (matches Case Volume KPI). On Time = digital LT ≤ 14 days, or implicit PSP cases (no real PSP reviewer accept — assumed on time). Delayed = real PSP reviewer accept AND digital LT > 14 days. Digital LT = PSP reviewer accept − scan upload − surgeon wait − on-hold days. Click a segment to view cases.
Process Efficiency & Exclusions
Process Efficiency by Step
Efficiency = ideal hours / actual hours per step, capped at 200%. Values at cap are flagged.
Exclusion Breakdown by Engineer
Signoffs excluded from efficiency calculation per engineer.
Queue Time by Step
Avg Queue Time by Step (hours)
Avg hours a case waits before a worker picks it up. Queue starts at previous-step completion and ends at worker role assignment. Outlier caps: Planning = 14 days, all other steps = 7 days. Case count shown in parentheses per bar.
Camstar Production Report
Report Filters
Product Group
Product Line
Team
Select Month
From
To
Process Step
Click Load to populate
0 selected
Engineer
Click Load to populate
0 selected
Charts to Include
WIP (Current)
Total Open (WIP)
—
Across all products
Volume
Total Volume
—
—
Click Generate to load.
WIP Trend
Latest Total Open
—
—
Click Generate to load.
Same completion-signal methodology as the current WIP snapshot (v9), applied as of each period's end date.
Lead Time by Product
Click Generate to load.
Avg days from order entry (first transaction) to final step (last transaction), per product.
Utilization
Team Avg
—
—
Click Generate to load.
First Pass Yield
Team Avg FPY
—
—
Click Generate to load.
On-Time Delivery
Team OTD
—
—
Click Generate to load.
Completed Cases by Process
Click Generate to load.
Filter to one product to reduce clutter — this chart can get packed across all products at once.
R3ID Filters (Customs, TAR, rTSA etc.)
Filters
Last 7 Days
Last 2 Weeks
Last 4 Weeks
Last 8 Weeks
Last 6 Months
Last 12 Months
All Time
Select Month
Custom Range
Product Group
0 selected
Product Name
0 selected
Case Type
Loading...
0 selected
Process Step
Click Load to populate
0 selected
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)
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 | |||||||||||