Besides the calculation blocks you insert from the ribbon, any cell will take a formula you type yourself, the same way Excel does. Start with =, press Enter, and the cell shows the result and recalculates whenever its inputs change.
This page covers the functions available when you type into a cell. It is a different thing from the Formula Reference, which documents the acoustic calculations the ribbon inserts as row-blocks.
Timbral's own acoustic functions
These are specific to Timbral and are the ones worth knowing. All of them accept a range (C5:H5) or a list of values.
Level arithmetic
| Function | What it does | Example |
|---|---|---|
DBADD | Logarithmic (energy) sum of levels | =DBADD(C5:H5) |
DBSUB | Logarithmic subtraction of one level from another | =DBSUB(85, 80) |
DBAVG | Energy-average of levels | =DBAVG(C5:H5) |
SOURCECOUNTCORRECTION | Correction for n identical incoherent sources, i.e. 10·log₁₀(n). Add it to a single source's level. | =SOURCECOUNTCORRECTION(4) → 6.02 |
RMS | Root mean square of a signal sampled down a column | =RMS(C5:C40) |
BGCORRECT | ISO 16283-1 Formula 14 background-noise correction, given the measured and background levels | =BGCORRECT(60, 52) |
The background correction follows the standard's three cases: a margin of 10 dB or more takes no correction, 6 dB or less takes the fixed −1.3 dB penalty, and anything between is a straight energy subtraction.
Single-figure ratings
| Function | Rating |
|---|---|
NRRATING | Noise Rating |
GRATING | G (vibration) rating |
DBA | A-weighted overall level |
DBB, DBC, DBD, DBR, DBH | The corresponding weighted overall levels |
DBZ | Z-weighted (unweighted) overall level — the plain logarithmic sum, same maths as DBADD |
SRIRATING | Weighted sound reduction index, ISO 717-1 — Rw with its C and Ctr terms by default (e.g. 55 (-2; -7)); pass a variant code ("rw", "rw-c", "rw-ctr", "dw", "dw-c", "dnt-w", ...) as a trailing argument for a single figure or the Dw/DnT,w families, and a reverberation time in seconds after a "dnt-w*" code (default 0.5 s if omitted) |
ABSORPTIONWEIGHTING, ABSORPTIONCLASS | Weighted absorption coefficient and its class, ISO 11654 |
These are the same functions the Rating column writes for you when you switch it on, so a rating cell and a typed formula always agree.
The weighted levels (DBA–DBH, DBZ) show one decimal place by default. A trailing "dp:N" argument sets the number of decimal places, from 0 to 10: =DBA(C5:K5, "dp:2"). The ribbon's decimal-place buttons write this argument for you on a Rating cell.
One-third-octave to octave
Two shapes of the same conversion:
- Whole-spectrum —
SUMTHIRDTOOCTAVE,SRITHIRDTOOCTAVE,ABSORPTIONTHIRDTOOCTAVEtake a one-third-octave range and return a single aggregate number. - Per-band —
SUMTHIRDOCTAVE,SRITHIRDOCTAVE,ABSORPTIONTHIRDOCTAVEtake the range plus the octave band you want, so each octave cell can reference the one-third-octave row and update live:=SUMTHIRDOCTAVE(C5:AC5, 63).
Standard Excel functions
Around 440 Excel functions are available. The families below are verified against Excel's own answers on every build. A function name Timbral does not support gives #NAME?, as in Excel, and the formula text stays in the cell so you can correct it.
Lookups
VLOOKUP, HLOOKUP, MATCH, INDEX, LOOKUP and XLOOKUP all behave as they do in Excel, including the INDEX/MATCH idiom:
=VLOOKUP("Orange", A2:B5, 2, FALSE)
=INDEX(C1:C5, MATCH(3, A1:A5, 0))
=XLOOKUP(99, A1:A5, C1:C5, "not found")Worth knowing:
- Text matching ignores case, as in Excel —
"beta"findsBeta. - A miss is
#N/A, never a blank cell. - A column index past the table is
#REF!; below 1 it is#VALUE!. - Wildcards work on exact-match lookups:
?for one character,*for any run.
Conditional counting and summing
COUNTIF, SUMIF, AVERAGEIF and their …IFS forms take the usual criteria language:
=COUNTIF(A1:A5, ">2")
=SUMIF(D1:D5, "x", C1:C5)
=SUMIFS(C1:C5, D1:D5, "x", A1:A5, ">1")
=COUNTIF(D1:D5, "<>x")Everything else in common use
Aggregation (SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, MEDIAN, SMALL, LARGE, RANK), logic (IF, AND, OR, NOT, IFERROR, ISNA), text (UPPER, LEFT, LEN, CONCATENATE, TEXTJOIN, TRIM) and dates (DATE, YEAR) all behave as expected.
Numbers and how they display
Results are shown to 15 significant digits, which is Excel's own display precision. This is why =1.2+1.5+2.1 reads 4.8 rather than 4.800000000000001.
The full-precision value is what gets used downstream, so — exactly as in Excel — a comparison like =F1=0.3 can be FALSE while F1 plainly reads 0.3.
TRUE and FALSE display in capitals so that copying a cell into Excel gives you a real boolean rather than text.
Known limitations
These are real and current.
- Array formulae do not spill —
TRANSPOSE,SORTandUNIQUEhave nowhere to write their extra cells, andFILTERis not available. SUBTOTALis not available and gives#NAME?. UseSUM, orAGGREGATE(e.g.=AGGREGATE(9,6,C1:C5)) — but noteAGGREGATEcannot see hidden rows, so its "ignore hidden rows" options still count every row. Its "ignore errors" options work.- A few specialist functions are deliberately unavailable and give
#NAME?: the bond and coupon finance functions (PRICE,YIELD,DURATION,COUPNUMand relatives),XIRR,VDB, the F and beta distributions (FDIST,FINV,FTEST,BETADIST, ...), andINFO,SHEET,SHEETS,ISFORMULA. - Only the common dotted names work.
NORM.DIST,STDEV.P/.S,VAR.P/.S,QUARTILE.INC,PERCENTILE.INC,T.DIST,T.TEST,CONFIDENCE.NORMand similar are available; a dotted name outside that list gives#NAME?— try its undotted form (STDEV,QUARTILE). +with ordinary text joins the text instead of giving#VALUE!: if A1 holdsLmax event,=A1+1showsLmax event1. A rating label is the exception — arithmetic on a cell reading73.2 dB(A)orNR 35uses its number.
A note on the sign convention
Attenuation and sound reduction are stored as negative dB throughout Timbral, so a path is summed by adding its terms. Keep that in mind when writing your own arithmetic: a 40 dB partition contributes −40, not 40.