- Formula
- reference curve shifted until Σ unfavourable deviations ≤ 10 dB (octave) / 32 dB (1/3-oct); Rw = shifted curve at 500 Hz
- Output
- Rw (C; Ctr) — e.g. 42 (-2; -6)
- Bands
- 125 Hz – 2 kHz (octave), or 100 Hz – 3.15 kHz (1/3-octave)
- Standard / Source
- ISO 717-1
- Access
- Toolbar block, Inline =function
What it does
Rates a measured or predicted sound-level spectrum against the ISO 717-1 reference curve, returning a single-number weighted rating plus the two spectrum adaptation terms C and Ctr (which correct the rating for pink-noise-like and traffic-noise-like source spectra respectively). One toggle, one gate, one underlying computation — three families of input, distinguished only by what the spectrum represents:
- Rw (C; Ctr) — laboratory sound reduction index (SRI).
- Dw (C; Ctr) — the same procedure applied to an in-situ level-difference spectrum, with no receiving-room normalisation.
- DnT,w (C; Ctr) — the Dw spectrum, first normalised to a reference reverberation time T₀ = 0.5 s (see below), then rated the same way.
Each family offers all four presentations: the plain weighted figure alone, +C, +Ctr, and (C; Ctr) together.
Auto-detects whether the input row is octave or 1/3-octave resolution and applies the matching reference curve and adaptation terms — no separate "which resolution" input needed.
Equation
The reference curve is shifted in 1 dB steps toward the measured spectrum. The weighted figure is the value of the shifted curve at 500 Hz, using the largest shift for which the sum of unfavourable deviations (measured level below the shifted curve) stays within the standard's cap:
Each adaptation term is a level-weighted correction against a standard source spectrum (C = pink noise-like sources, Ctr = traffic/low-frequency-heavy sources):
DnT,w's reverberation-time normalisation, applied to the level-difference spectrum before the shift above:
D is the raw in-situ level difference at each band; T is the room's own reverberation time (edit the formula's trailing argument to change it from the T₀ default — see below).
How to use it
- From the ribbon — select a row of levels and click the wanted variant under Ratings → Sound Insulation (Rw/Dw/DnT,w, each ×4 for the C/Ctr combinations — 12 in total). The result is written straight into the Rating column — no dialog, no inserted calc block.
- As a function —
=SRIRATING(range)for Rw (C; Ctr) (returns e.g.42 (-2; -6)), or=SRIRATING(range, anchor, "dw-c")etc. for a named variant, or=SRIRATING(range, anchor, "dnt-w", T)for DnT,w with an explicit reverberation time in seconds (omit T for the T₀ = 0.5 s default — a freshly-toggled DnT,w reads identically to Dw until you edit that trailing number).
The rating needs every reference band (125 Hz–2 kHz octave, or 100 Hz–3.15 kHz 1/3-octave) — a partial band set would silently return a different rating, not just an incomplete one. So if any of those bands is blank or missing, the formula returns an error instead of a number. The menu items are never disabled: on a sheet without the full band set (e.g. the low-frequency sheet) the tooltip says which bands are absent, and the written formula shows an error.
Inputs
| Input | Meaning | Unit | Example |
|---|---|---|---|
| Spectrum | SRI, in-situ level difference, or in-situ level difference (DnT,w — pre-normalisation), octave or 1/3-octave bands | dB | see below |
| T (DnT,w only) | reverberation time, edited directly in the inserted formula's trailing argument | s | 0.5 (default) |
Worked example
Spectrum [31.5: 18, 63: 20, 125: 24, 250: 33, 500: 39, 1000: 44, 2000: 49, 4000: 52, 8000: 55] dB (octave), as an Rw input:
→ Rw 42 (-2; -6)
The same spectrum as a DnT,w input with T = 1.0 s (twice the T₀ reference) shifts every band up by 10·log₁₀(1.0/0.5) = 3.0 dB before rating, raising the resulting single-figure value versus the Dw reading of the same raw spectrum.
Source
ISO 717-1 — rating of sound insulation, Part 1: Airborne sound insulation. Reference curve and spectrum adaptation terms C, Ctr. The DnT,w reverberation-time normalisation is the standard's own Dw→DnT,w extension, not a separate document.