Dual completion rates
CompletionRate tracks progress, CleanPassRate tracks quality — site teams and supervisors each get the right rate.
Mechanical Completion for every equipment and cable, fully online, with subsystem RFCC aggregated automatically.
Dual-rate accounting: CompletionRate (action done) and CleanPassRate (quality passed) — site and supervisor each get the rate they care about.
Import equipment/cable tags, establish unique codes
TagNo + CheckSheetCategory cascade dropdown prevents mismatch
InspectionDate marks action complete, CompletionRate +1
A/B class opinions auto-sync to the Punch module
Status flips to Cleared once all Punch items close, CleanPassRate +1
When every MC in a subsystem is Cleared, RFCC READY fires
CompletionRate tracks progress, CleanPassRate tracks quality — site teams and supervisors each get the right rate.
Picking a TagNo filters CheckSheetCategory to only valid options, killing mismatches at the source.
PunchCategory on an MC row is computed from the Punch table — hand-fill is disabled.
Update the same field on many rows at once (e.g. batch InspectionDate); every action lands in the activity log.
Preview Excel uploads — X new, Y updates, Z skipped — confirm before any write.
Filter MC by drawing number to match how the yard actually works.

Real product screenshot · from H588 NORSE WIND project (v4.3)
Key MC fields, linked to Punch, equipment, and subsystem data.
| Field | Description | Note |
|---|---|---|
| TagNo | Unique equipment/cable code | Required · dropdown |
| CheckSheetCategory | Inspection category (cascade) | Required · dropdown |
| InspectionDate | Actual inspection date | Drives CompletionRate |
| InspectionStatus | Passed / Cleared / Open | Inferred from Punch status |
| PunchCategory | Aggregated A / B class | Auto, hand-fill disabled |
| SubSystemNo | Owning subsystem | Drives RFCC aggregation |
| DrawingNo | Linked drawing number | Filter + jump to drawings |
Every Punch item bound to an owner + due date, AgingDays color-graded, closure state feeds back into MC instantly.
17-field inspection sheet, independent of MC, open/close opinion tracking — the standard intake for install-phase defects.
18-field vendor acceptance record with vendor info and conclusion. Standalone loop that does not affect RFCC.
Vercel AI SDK + Zod schema whitelist — the model is structurally constrained to cite real metrics only. Generates week-over-week trends.