- Formula
- curve level L = a + b·N; rating = lowest N with every band at or below its curve
- Output
- NR value (e.g. NR 45)
- Bands
- 31.5 Hz – 8 kHz (octave; 1/3-octave input is summed to octaves first)
- Standard / Source
- ISO 1996-1 / BS 8233:2014
- Access
- Toolbar block, Inline =function
What it does
Rates a measured or predicted spectrum against the standard family of Noise Rating (NR) curves, returning the single NR number of the lowest curve that fully contains the spectrum — i.e. the first NR curve, counting up, that no band of the spectrum exceeds. Ribbon: Ratings → Sound Level → NR Rating (ISO 1996-1).
Equation
Each NR curve is defined band-by-band by:
with tabulated constants a and b per octave band (31.5 Hz–8 kHz) and N the curve number, each curve level rounded to 1 decimal place. The rating is the lowest whole-number N for which every band of the spectrum (also rounded to 1 decimal place) is at or below the curve. Blank or zero bands are skipped, so a spectrum covering only some bands is rated over the bands it has.
How to use it
- From the ribbon — select the spectrum row(s) and choose Ratings → Sound Level → NR Rating (ISO 1996-1). This writes
=NRRATING(range, anchor)into each row's Rating column (click again to remove it) — no dialog, no inserted calc block. - As a function — type
=NRRATING(range)in any cell (it returns e.g.NR 45). If given 1/3-octave data it silently energy-sums to octaves first.
Inputs
| Input | Meaning | Unit | Example |
|---|---|---|---|
| Spectrum | octave-band levels 31.5 Hz–8 kHz | dB | see below |
Worked example
Spectrum [63: 85, 125: 91, 250: 83, 500: 78, 1000: 65, 2000: 64, 4000: 62, 8000: 55] dB:
→ NR 80
Source
ISO 1996-1 / BS 8233:2014, Annex B — NR curve constants; curve level L = a + b·N, rounded to 1 decimal place. The formula is treated as authoritative: the a and b constants were re-checked against BS 8233:2014 Annex B, whose printed contour table does not agree with its own formula.