# Condition Monitoring Alarm Limit Worksheet (Mean plus Sigma)

> Source: https://netray.co/tools/condition-monitoring-alarm-limit-statistical-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Editable worksheet that sets alert (mean + 2 sigma) and alarm (mean + 3 sigma) limits per asset and measurement.

## Category

maintenance

## Industry

Manufacturing

## Audience

- Reliability engineer
- Condition monitoring analyst
- Maintenance planner

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Asset / measurement point

**Key:** asset

**Type:** text

#### Measurement

**Key:** measure

**Type:** select

**Options:**

- Velocity mm/s RMS
- Acceleration g
- Temperature C
- Current A
- Ultrasound dB

#### Baseline samples

**Key:** n

**Type:** number

#### Baseline mean

**Key:** mean

**Type:** number

**Format:** decimal

#### Standard deviation

**Key:** sd

**Type:** number

**Format:** decimal

#### Alert (mean + 2 sd)

**Key:** alert

**Type:** number

**Expr:** mean + 2 * sd

**Format:** decimal

#### Alarm (mean + 3 sd)

**Key:** alarm

**Type:** number

**Expr:** mean + 3 * sd

**Format:** decimal

#### Absolute limit

**Key:** abs_limit

**Type:** number

**Format:** decimal

**Help:** Standard or supplier limit, for example from ISO 10816 / 20816.

#### Alarm headroom to absolute limit

**Key:** headroom

**Type:** number

**Expr:** abs_limit - alarm

**Format:** decimal

**Rows:**

**Asset:** Cooling pump P-101 DE bearing

**Measure:** Velocity mm/s RMS

**N:** 30

**Mean:** 1.8

**Sd:** 0.25

**Abs limit:** 4.5

**Asset:** Cooling pump P-101 NDE bearing

**Measure:** Velocity mm/s RMS

**N:** 30

**Mean:** 1.5

**Sd:** 0.2

**Abs limit:** 4.5

**Asset:** Compressor C-12 motor DE

**Measure:** Acceleration g

**N:** 24

**Mean:** 0.6

**Sd:** 0.1

**Abs limit:** 2

**Asset:** Gearbox G-7 housing

**Measure:** Temperature C

**N:** 40

**Mean:** 62

**Sd:** 3.5

**Abs limit:** 85

**Asset:** Extruder motor M-3

**Measure:** Current A

**N:** 36

**Mean:** 41

**Sd:** 2.2

**Abs limit:** 52

**Totals:**

#### Highest alarm value

**Key:** alarm

**Agg:** max

**Format:** decimal

#### Smallest headroom

**Key:** headroom

**Agg:** min

**Format:** decimal

**Notes:** Collect baselines in normal, healthy, loaded operation. Where headroom is negative the statistical alarm sits above the absolute limit, so use the absolute limit instead. Mixing different operating states in one baseline inflates the standard deviation.

## Content

**Intro:** Fixed limits from standards are a good ceiling but they are blunt. A statistical baseline for each measurement point lets you detect change early. This worksheet computes alert and alarm limits from baseline readings and checks them against your absolute limits.

**Sections:**

#### How to use it

**Body:** Add a row for each measurement point. Record at least 20 to 30 healthy readings per point, then enter the mean and standard deviation from your spreadsheet or analysis software. The sheet calculates alert at mean plus two standard deviations and alarm at mean plus three. Enter the absolute limit from your standard or supplier and read the headroom. Export to Excel to load the thresholds into your monitoring system.

#### The method

**Body:** For roughly normal data, about 97.7% of healthy readings fall below mean plus two sigma and 99.87% below mean plus three sigma, so crossings are rare in a healthy machine and meaningful when they occur. This is the logic of a Shewhart control chart applied to condition data. Vibration and acceleration data are often skewed, so a log transform or percentile approach can be better if the standard deviation is large relative to the mean.

**Bullets:**

- Use one baseline per operating state (speed and load)
- Recalculate after a repair, re-alignment or lubricant change
- Cap statistical limits at the absolute limit

#### Common mistakes

**Body:** Building the baseline from a period when the machine was already degrading hides the very change you want to catch. Another is applying one limit to a machine that runs at several speeds. Setting alarms too tight causes nuisance alerts that train the team to ignore them, so review the alert rate after the first month and adjust.

**Bullets:**

- Baseline taken from unhealthy operation
- Too few samples for a stable standard deviation
- Ignoring trend slope and looking only at limits

**Cta:** Netray can compute baselines and rolling alarm limits from your historian or route data and raise a work request in your ERP when a point crosses a limit.

**Faq:**

#### How many readings do I need for a baseline?

**Answer:** At least 20 to 30 readings in stable, healthy operation give a usable mean and standard deviation. Fewer readings make the limits unstable and likely to cause false alarms.

#### Why mean plus 2 and 3 sigma?

**Answer:** For normally distributed data they correspond to roughly 2.3% and 0.13% exceedance for healthy machines, which gives an early alert and a stronger alarm with a low false positive rate.

#### Should I use the standard limits instead?

**Answer:** Use both. Standards such as ISO 10816 / 20816 set absolute severity ceilings. Statistical limits detect change from the machine's own healthy normal, usually well below the ceiling.

#### What if my data is not normal?

**Answer:** Use percentiles, for example the 95th and 99th percentile of baseline readings, or analyze the log of the readings. Many vibration measures are skewed to the right.

## Search terms

condition monitoring alarm limits, vibration alarm level statistical, mean plus 3 sigma alarm limit, baseline alarm setting worksheet, alert and alarm thresholds excel, predictive maintenance threshold setting, vibration alert alarm template, condition monitoring baseline worksheet

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json