Skip to content
ContentsFormula ReferenceUser guide
Formula Reference

Z-Weighted Total

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

LZ=10 log⁡10 ⁣(∑i10Li/10)L_Z = 10\,\log_{10}\!\left(\sum_i 10^{L_i/10}\right)

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

InputMeaningUnitExample
Spectrumoctave-band levelsdBsee 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.

Register interest

Tell us a little about you and we'll be in touch when Timbral is ready.