- Formula
- dB(Z) = 10·log₁₀( Σ 10^(Li/10) )
- Output
- dB(Z) — single figure
- Bands
- Summarises every band of the row (1/1, 1/3-octave or LF sheet)
- Standard / Source
- General acoustics (no standard cited)
- Access
- Toolbar block, Inline =function
What it does
Collapses a full spectrum into a single Z-weighted level — Z-weighting applies no frequency correction (0 dB at every band), so this is simply the plain logarithmic (energy) sum of the spectrum, presented as a Rating alongside the A–H weighted totals. It is the same maths as =DBADD, just formatted as "xx.x dB(Z)" so it can sit in the Rating column next to other weightings via CHAR(10).
Equation
How to use it
- From the ribbon — select the spectrum row(s) and choose Ratings → Weightings → Overall dB(Z). This writes
=DBZ(range, anchor)into each row's Rating column (click again to remove it) — no dialog, no inserted calc block. - As a function —
=DBZ(range)(returns e.g.82.4 dB(Z)). New in this release — no pre-rename alias, unlike A–H (see A-Weighted Total for that history).
Inputs
| Input | Meaning | Unit | Example |
|---|---|---|---|
| Spectrum | octave-band levels | dB | see below |
Worked example
Spectrum [31.5: 78, 63: 85, 125: 91, 250: 83, 500: 78, 1000: 65, 2000: 64, 4000: 62, 8000: 55] dB:
→ 92.8 dB(Z) (unlike A-weighting, nothing is discounted — the loud low-frequency bands dominate the total far more than they do in the dB(A) figure for the same spectrum).
Source
Plain logarithmic summation; "Z-weighting" (flat response) is defined generically across acoustics standards, not tied to one specific document here.