- Formula
- dB(X) = 10·log₁₀( Σ 10^((Lᵢ + Xᵢ)/10) ), X = B, C, D, R or H weighting
- Output
- dB(B) / dB(C) / dB(D) / dB(R) / dB(H) — single figure
- Bands
- Summarises the bands of the row that the curve defines (B, D, R, H: 25 Hz – 10 kHz; C: 10 Hz – 10 kHz, and below on the LF sheet)
- Standard / Source
- General acoustics (no standard cited)
- Access
- Toolbar block, Inline =function
What it does
The siblings of A-Weighted Total: each collapses a spectrum into a single weighted level using a different frequency-weighting curve — B, C, D, R or H. The correction for each band is added to its level, then the bands are energy-summed. (For the unweighted total see Z-Weighted Total.)
A band the chosen curve has no correction for (B, D, R and H have none below 25 Hz) is left out of the sum rather than rejected, so a low-frequency row is weighted over the bands the curve covers.
Equation
where is the band correction of curve X (see Weighting Curve Fill (A / B / C / D / R / H / Z) for the values). The octave corrections are:
| Band (Hz) | 31.5 | 63 | 125 | 250 | 500 | 1000 | 2000 | 4000 | 8000 |
|---|---|---|---|---|---|---|---|---|---|
| B | −17.1 | −9.3 | −4.2 | −1.3 | −0.3 | 0 | −0.1 | −0.7 | −2.9 |
| C | −3.0 | −0.8 | −0.2 | 0 | 0 | 0 | −0.2 | −0.8 | −3.0 |
| D | −16.7 | −10.9 | −5.5 | −1.6 | −0.3 | 0 | 7.9 | 11.1 | 5.5 |
| R | −100 | −100 | −100 | −71 | −55 | −26 | −20 | −13 | 0 |
| H | −56 | −35 | −21 | −12 | −6 | −5 | 0 | 4 | −15 |
How to use it
- From the ribbon — select the spectrum row(s) and choose Ratings → Weightings → Overall dB(B) (or dB(C), dB(D), dB(H), dB(R)). This writes e.g.
=DBC(range, anchor)into each row's Rating column (click again to remove it) — no dialog, no inserted calc block. Several weightings can share one Rating cell, one per line. - As a function —
=DBB(range),=DBC(range),=DBD(range),=DBR(range),=DBH(range)(returns e.g.92.5 dB(C)). The pre-rename spellingsBWEIGHTRATING/CWEIGHTRATING/DWEIGHTRATING/RWEIGHTRATING/HWEIGHTRATINGstill work. An optional trailing"dp:2"sets the decimal places (default 1).
Inputs
| Input | Meaning | Unit | Example |
|---|---|---|---|
| Spectrum | octave- or 1/3-octave-band levels | dB | see below |
Worked example
The same spectrum as the A- and Z-weighted entries, [31.5: 78, 63: 85, 125: 91, 250: 83, 500: 78, 1000: 65, 2000: 64, 4000: 62, 8000: 55] dB:
| Curve | B | C | D | R | H |
|---|---|---|---|---|---|
| Total | 88.6 dB(B) | 92.5 dB(C) | 87.9 dB(D) | 56.3 dB(R) | 76.6 dB(H) |
(For comparison, 79.9 dB(A) and 92.8 dB(Z). C-weighting barely discounts the loud 125 Hz band, so dB(C) sits close to dB(Z); R-weighting all but removes everything below 250 Hz.)
Source
C: IEC 61672-1 (tabulated 10 Hz – 10 kHz). B and D: historical curves that are not part of IEC 61672-1 (they were dropped after IEC 60651); no values are given below 25 Hz. R and H: bespoke, non-standard Timbral curves, with no published values below 25 Hz. Energy summation as standard.