Predictive Maintenance Sensor Mapping & Priority Worksheet

{ "Title": "Predictive Maintenance Sensor Mapping & Priority Worksheet", "IntroductionHtml": "

Use this worksheet to identify assets suitable for predictive-maintenance pilots, record dominant failure modes, candidate signals, estimated lead times, and a simple priority score. You can enter one structured asset at a time (handy for focused planning) or paste a bulk CSV of many assets. Read the scoring guidance below before submitting.

Scoring guidance

Priority combines equipment criticality, expected lead time (how early a signal appears before failure), and pilot readiness (data availability, access, and maintenance process). Use the 0–10 priority scale where 10 is highest priority for a pilot. Suggested quick formula: Priority ≈ (Criticality weight) + (Lead-time weight) + (Readiness weight). See the example below.

Example

Asset: Compressor A
Criticality: Critical (4)
Dominant failure: Bearing wear
Candidate signals: Vibration RMS (high freq), temperature trend, oil-particle count
Expected lead time: 7–14 days
Pilot readiness: Partially Ready (sensor available but historical data limited)
Priority (0–10): 8 — good candidate for a short-term pilot.

", "DataType": "pdm-sensor-map-worksheet-v1", "SchemaVersion": 1, "SubmitLabel": "Save Asset Row", "SuccessMessage": "Asset mapping saved. You can submit additional rows or paste a bulk CSV to add many assets at once.", "Fields": [ { "Key": "entry_mode", "FieldType": "radio", "Label": "Entry mode", "HelpText": "Choose how you want to add asset data: single structured row or bulk CSV paste.", "Options": [ {"Value": "single", "Label": "Single structured row"}, {"Value": "bulk", "Label": "Bulk paste (CSV)"} ], "Required": true }, { "Key": "asset_name", "FieldType": "text", "Label": "Asset name / description", "HelpText": "Human-friendly name. e.g., 'Compressor A (Line 2)'. Leave blank if using bulk paste.", "Required": false }, { "Key": "asset_tag", "FieldType": "text", "Label": "Asset tag / ID", "HelpText": "Unique asset identifier in your CMMS or asset registry. Leave blank if using bulk paste.", "Required": false }, { "Key": "criticality", "FieldType": "select", "Label": "Criticality", "HelpText": "Operational impact if the asset fails. Choose the option that best fits. You can map these to numeric weights when scoring.", "Options": [ {"Value": "low", "Label": "Low"}, {"Value": "medium", "Label": "Medium"}, {"Value": "high", "Label": "High"}, {"Value": "critical", "Label": "Critical"} ], "Required": false }, { "Key": "dominant_failure_modes", "FieldType": "textarea", "Label": "Dominant failure modes", "HelpText": "List the primary ways this asset fails (bearing wear, seal leakage, electrical winding insulation, misalignment, clogging, etc.).", "Required": false }, { "Key": "candidate_signals", "FieldType": "textarea", "Label": "Candidate signals / measurements", "HelpText": "Potential predictive signals to monitor. Give examples and sensor types, e.g., 'vibration RMS 1–10 kHz, high-frequency envelope,-bearing temperature, acoustic emission, motor current signature, oil debris count, pressure drift'.", "Required": false }, { "Key": "sampling_rate_suggestion", "FieldType": "text", "Label": "Sampling rate / frequency suggestion", "HelpText": "Practical suggestion (e.g., 1s burst every minute, continuous 10 kHz, hourly temperature), helpful to plan sensor and storage needs.", "Required": false }, { "Key": "data_owner", "FieldType": "text", "Label": "Data owner / responsible person", "HelpText": "Who will own the sensor data, field engineer or system team? Include name, role, or team.", "Required": false }, { "Key": "expected_lead_time_days", "FieldType": "number", "Label": "Expected lead time (days)", "HelpText": "How many days before a typical failure you expect to see an actionable signal. Enter an integer if known. Leave blank if unknown.", "Required": false }, { "Key": "pilot_readiness", "FieldType": "select", "Label": "Pilot readiness", "HelpText": "How ready this asset is for a pilot given access, data availability, and maintenance process maturity.", "Options": [ {"Value": "not_ready", "Label": "Not ready"}, {"Value": "partially_ready", "Label": "Partially ready"}, {"Value": "ready", "Label": "Ready"} ], "Required": false }, { "Key": "priority_score", "FieldType": "scale", "Label": "Priority score (0–10)", "HelpText": "Your judgment of overall priority for a predictive-maintenance pilot. 0 = lowest priority, 10 = highest. Use the scoring guidance above.", "Min": 0, "Max": 10, "Required": false }, { "Key": "remarks", "FieldType": "textarea", "Label": "Remarks / notes", "HelpText": "Anything else to record: required access, supplier constraints, expected pilot duration, estimated cost, risks, or links to work orders and failure history.", "Required": false }, { "Key": "bulk_csv", "FieldType": "textarea", "Label": "Bulk paste CSV (optional)", "HelpText": "If you have many assets, paste CSV with header row. Required columns (recommended order): asset,asset_tag,criticality,dominant_failure_modes,candidate_signals,sampling_rate_suggestion,data_owner,expected_lead_time_days,pilot_readiness,priority_score,remarks. Example row: Compressor A, C-A-01, critical, bearing wear, vibration RMS|temp|oil, continuous 10kHz, Reliability Team, 7, partially_ready, 8, 'easy access'. If CSV is used, single-row structured fields may be left blank.", "Required": false } ] }