# Condition Monitoring Alarm Limits Register Worksheet > Source: https://netray.co/tools/condition-monitoring-alarm-limits-register-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable register of baselines, alert and alarm limits by asset and parameter, with percent of alarm calculated from the latest reading. ## Category maintenance ## Industry Manufacturing ## Audience - Reliability engineer - Condition monitoring analyst - Maintenance planner ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Asset **Key:** asset **Type:** text #### Parameter **Key:** param **Type:** text #### Technique **Key:** tech **Type:** select **Options:** - Vibration - Oil analysis - Thermography - Ultrasound - Motor current - Process #### Unit **Key:** unit **Type:** text #### Baseline **Key:** base **Type:** number **Format:** decimal #### Alert limit **Key:** alert **Type:** number **Format:** decimal #### Alarm limit **Key:** alarm **Type:** number **Format:** decimal #### Latest value **Key:** current **Type:** number **Format:** decimal #### Percent of alarm **Key:** pct **Type:** number **Expr:** if(gt(alarm,0),current / alarm * 100,0) **Format:** percent #### Responder **Key:** owner **Type:** text **Rows:** **Asset:** P-204 Cooling pump **Param:** Overall velocity motor DE **Tech:** Vibration **Unit:** mm/s RMS **Base:** 2.1 **Alert:** 4.5 **Alarm:** 7.1 **Current:** 6.8 **Owner:** Reliability **Asset:** GBX-12 Gearbox **Param:** Iron in oil **Tech:** Oil analysis **Unit:** ppm **Base:** 12 **Alert:** 50 **Alarm:** 100 **Current:** 18 **Owner:** Lubrication **Asset:** MCC-3 Feeder 7 **Param:** Lug temperature rise **Tech:** Thermography **Unit:** C **Base:** 5 **Alert:** 15 **Alarm:** 40 **Current:** 37 **Owner:** Electrical **Asset:** FAN-11 Exhaust fan **Param:** Bearing ultrasound **Tech:** Ultrasound **Unit:** dBuV **Base:** 22 **Alert:** 30 **Alarm:** 38 **Current:** 34 **Owner:** Reliability **Asset:** CMP-07 Compressor **Param:** Motor current **Tech:** Motor current **Unit:** A **Base:** 112 **Alert:** 125 **Alarm:** 135 **Current:** 118 **Owner:** Operations **Totals:** #### Highest percent of alarm **Key:** pct **Agg:** max **Format:** percent #### Parameters registered **Key:** asset **Agg:** count **Format:** integer **Notes:** This register assumes high values are bad. For parameters where a low value is bad, such as oil film thickness or flow, record the limits inversely and treat the percent column accordingly. Review limits after every major repair or load change. ## Content **Intro:** Alarm limits tend to live in the heads of analysts or buried in vendor software settings. This register puts every limit, baseline and owner on one sheet, so changes are visible and the team knows who responds when a value crosses. **Sections:** #### How to use the register **Body:** List each monitored parameter once, with its technique, unit and baseline taken when the asset was healthy. Set alert and alarm limits from a standard, the manufacturer or statistics of your own history. Update the latest value after each survey and the sheet shows how close each parameter is to its alarm. Assign a responder so a crossing is never ownerless. Export to Excel for review meetings and audits. #### Setting alert and alarm levels **Body:** There are three common routes. First, use published severity zones such as the ISO 20816 families for vibration. Second, use the equipment manufacturer values. Third, use statistics: for example the baseline plus two standard deviations for alert and plus three for alarm once you have enough data. Mixing approaches is fine as long as the source of each limit is noted, so you can justify changes later. **Bullets:** - Alert means plan an inspection, alarm means act now - Review limits after repairs, speed or load changes - Keep a rate-of-change rule in addition to absolute values #### Using percent of alarm **Body:** Percent of alarm is the latest value divided by the alarm limit. It lets you rank very different parameters on one scale. Values over 100% are in alarm, and those above the alert level but below alarm sit in the amber zone. Sort the exported file by this column before the weekly reliability meeting to decide which assets to discuss first. #### Common mistakes **Body:** Frequent problems are copying limits between unlike machines, leaving baselines out of date after an overhaul, too many alarms that train people to ignore them, and alarms with no response plan. Aim for few, meaningful alarms and a clear next step for each. **Cta:** Netray can help connect your limits to live data so crossings create notifications in your ERP maintenance module automatically. **Faq:** #### Can I use this for online monitoring systems? **Answer:** Yes. Use it as the master record of what each system should alarm on, then compare against the configuration in the software. It is especially useful when limits have been changed over time by different people. #### How many parameters should I register? **Answer:** Start with the critical assets and the two or three parameters that best reflect their main failure modes. A short register that is kept current beats a long one that nobody updates. #### What if a parameter has only a low limit? **Answer:** Enter the limits inversely or rename the columns in the Excel export. The percent formula assumes higher is worse, so for low-is-bad parameters calculate the margin separately. #### Who should approve limit changes? **Answer:** Usually the reliability engineer with the asset owner. Record the date and reason in the note field of your exported copy to keep an audit trail. ## Search terms condition monitoring alarm limits, vibration alarm limit register, alert and alarm levels template, condition monitoring parameter list excel, predictive maintenance threshold register, alarm setpoint worksheet, asset health limits spreadsheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json