Skip to content
ContentsWorking in the SpreadsheetUser guide

Working in the Spreadsheet

Worksheets behave like an ordinary spreadsheet — type values or =formulas, copy and paste, and format cells — but with acoustics calculations built in. This page covers the everyday mechanics; the Formula Reference catalogues what each calculation does.

Input (yellow) cells

When you insert a calculation, its editable inputs are shown in yellow. Fill those in; the block's result rows recalculate automatically. You don't type into the result rows — they are computed for you and will overwrite anything you put there.

Inserting a calculation block

From the ribbon's Calculations group, open a family dropdown — Fundamentals, Propagation, Environmental, Mechanical, Buildings, Vibration or Ratings — and choose a calculation. Timbral inserts a small labelled block at your current position: a title row, one or more yellow input rows, and the result row(s).

ℹ️ The Environmental and Mechanical families are octave-band calculations, so on one-third-octave sheets their dropdowns are greyed out (hover over one to see why). Use them on an octave (1/1) sheet.

Moving a calculation

Each block has a coloured gutter handle on its left edge. Drag the handle to move the whole block within the sheet, or drop it on another sheet's tab in the tab strip to move the block onto that sheet — you don't need to have the target sheet open first. Any plot drawing that block follows it automatically.

Right-click the handle for the block's own menu: Edit calculation… (reopen its dialog and change it in place), Refresh calculation, Rename calculation…, Hide / Show workings (this calc), Publish output as variable…, Duplicate calculation and Delete calculation.

Published (global) variables

When several calculations need the same spectrum — a source level, a room's absorption — publish it once as a named variable and let the other calculations follow it:

  • Publish a result: right-click a calculation's result row and choose Publish as variable (or use Publish output as variable… on its gutter handle).
  • Type one in: Data ▾ › Global variable inserts a one-row block — type the name in Item, the quantity and unit in Description, and the spectrum in the band cells.
  • From the Data Library: select records and click Insert as Global Variable.
  • Use one: in a calculation's dialog (when inserting it, or via Edit calculation…), pick a published variable for a spectrum input. The input then follows the variable, shown as a purple chip, until you Unbind it.

The Variables pane (Add ▾ › Variables) lists every published variable and can Print to sheet a live, locked copy. Deleting a published variable asks first and shows what depends on it.

Custom blocks and templates

Save rows you build often as a custom block: select the whole rows, then Custom ▾ › Save selected rows as block… in the Calculations group (or right-click › Save as custom calc block…). Values, formulas and formatting are saved; formulas may only refer to rows inside the block. To reuse it, put the cursor where it should go and pick it from the Custom ▾ menu — it arrives as one block with its own gutter handle, so you can move, rename, duplicate or delete it like a calculation. A block can only go into the same kind of sheet (octave, 1/3-octave or low-frequency) it was saved from.

Whole sheets can be saved as templates from the sheet tab's right-click menu (see Getting Started). Custom blocks are kept in the same templates folder, so pointing everyone at a shared folder shares both; rename, share or delete them in File › Options… › Templates & data.

Combining levels: dB arithmetic

Because the decibel is logarithmic you can't add or subtract levels with ordinary + and −. Use the dB functions instead, in any cell:

  • =DBADD(…) — energy sum of levels;
  • =DBAVG(…) — energy average;
  • =DBSUB(L1, L2) — remove one level from another.

(See the dB Arithmetic entries in the Formula Reference.)

Summing rows

The old Σ Sum ribbon button has been retired. To total several sources, type an energy sum such as =DBADD(E5:E9) in the first band cell of the total row and drag the fill handle across the remaining bands. For other statistics down a range of rows, use Process Rows (below).

Process Rows (formerly Compute Across Rows)

Data ▾ › Process Rows in the Calculations group computes a statistic — Mean, Median, Mode, Max, Min, Percentile, Leq (energy average, dB), Sum (arithmetic), or Root mean square — down a range of rows, and can optionally group the result by Item, Description or Inputs instead of returning one overall row. Drag to pick the row range, choose the statistic and grouping, and Timbral writes it as a live formula, not a one-off value: edit a source cell later and the result recalculates automatically. A column with nothing to aggregate reads blank rather than an error or a misleading zero.

Once inserted, a Process Rows block behaves like any other calculation block: it gets its own coloured gutter handle so you can drag it to move it or drop it onto another sheet's tab, and right-clicking the handle offers Edit calculation… to change the statistic, range or grouping in place, without deleting and re-running it.

Excel-compatible functions

Any cell also accepts the standard spreadsheet functions you already know — SUM, IF, LOOKUP, ROUND, LOG, and several hundred more — so you can build your own intermediate working alongside the built-in acoustics blocks.

Converting between band resolutions

To move a spectrum between one-third-octave and octave bands, use the conversion functions (=SUMTHIRDTOOCTAVE, =SRITHIRDTOOCTAVE, =ABSORPTIONTHIRDTOOCTAVE) or the ribbon's 1/3 > 1/1 dropdown (Sum→Octave, SRI→Octave or α→Octave), which writes the converted spectrum into the selected row. (See the Band Conversion entries in the Formula Reference.)

Curve fills

The Curves dropdown drops a reference spectrum into the selected row for use as an overlay or target. It has four sub-menus: Ratings (an NR curve or the G-Curve), Weightings (A, B, C, D, R, H or Z), Absorption (ISO 11654 sound absorption classes A–E, octave sheets only) and Hearing (Equal Loudness ISO 226 contours and the ISO 389-7 Hearing Threshold). Each filled row has a yellow cell for switching the curve afterwards — for example the NR number, the weighting letter or the phon level. (See the Curves entries in the Formula Reference.)

Inserting from the Data Library

Open Data ▾ › Data library in the Calculations group. Where the records land depends on the cursor:

  • On a blank row, Insert adds the selected records as new rows.
  • On a calculation's yellow spectrum input row, Insert fills that input's bands with the record (and its name), so a library SRI or absorption spectrum can go straight into a calculation. Several records fill consecutive input rows of the same block. An input that is bound to a variable, or linked to another row, refuses — switch it back to its own values in Edit calculation… first.
  • Insert as Global Variable publishes each selected record as a variable instead (see above).

Cut, copy, paste and Paste special

Use Ctrl+X, Ctrl+C and Ctrl+V, or the right-click menu. Cut and paste moves cells the way Excel does: formulas that pointed at the moved cells follow them to their new position. Right-click › Paste special offers Values, Formulas, Transposed and Flip sign, or Paste special… (Ctrl+Alt+V) for the full dialog, where you choose All, Values or Formulas and can combine Transpose, Skip blanks and Flip sign. Formulas pastes the formulas with their references adjusted to the new position, as Excel does, but leaves the destination's own formatting alone.

Filling cells

Drag the small square at the bottom-right corner of a selection (the fill handle) to copy a value or formula across or down; formulas adjust their references as they go, and you can fill straight across a calculation's yellow input cells. From the keyboard, Ctrl+D fills down from the top of the selection, Ctrl+R fills right, and Ctrl+Enter puts what you have just typed into every selected cell. Calculated cells are never overwritten — Timbral skips them and tells you how many it skipped.

Inserting, deleting and hiding rows

Right-click a row number for Insert row above, Insert row below, Insert 25 rows below, Delete row and Hide row (right-click a cell and the same items are under Row operations). From the keyboard, Ctrl++ inserts as many rows above as you have selected and Ctrl+- deletes the selected rows. Right-click a column heading to rename, hide or unhide a column.

Pasting into Word or LibreOffice

Copy a calculation block — or any selected range — the same way you'd copy any cells. Pasting into Word, Excel, LibreOffice Writer or Calc, or Google Sheets lands as a real table, with rows, columns, and values intact, instead of a stretch of raw formula text. Rows currently hidden by the Workings toggle are left out of what you paste elsewhere, matching what's on screen.

To fill the cells of a table that already exists in a Writer report, install the small extension described in Pasting into LibreOffice Writer — without it, Writer puts everything into one cell.

Right-click the grid's top-left corner (above the row numbers) for Copy with column headings, Copy with column and row headings or Copy with row numbers. These copy the sheet's whole used area together with the column titles and/or row numbers — handy when the destination won't otherwise show which band or row a value belongs to.

Conditional formatting

Colour cells automatically based on their value: select a range and click Conditional formatting in the ribbon's Cells group to open the rule builder and add threshold rules ("above X", "between X and Y", …) or a 2- or 3-stop colour scale. Rules are evaluated top to bottom — an earlier rule can stop later ones from applying — and are saved with the sheet, not baked into the cells' own formatting, so changing or removing a rule later doesn't leave stray colours behind.

Tidying a sheet: Workings and blank rows

  • Workings › Show switch — hides the intermediate rows inside calculation blocks so a finished sheet shows only inputs and results; switch it back on to inspect the steps. Right-click a block's gutter handle to show or hide the workings of just that one block.
  • Hide blank rows / Unhide blank rows — collapse empty rows for a clean printout, then restore them.

Hiding the 31.5 Hz column

Octave sheets hide the 31.5 Hz column by default. To show it, untick Hide 31.5 Hz in the ribbon's View group (or in File › Options… › General). The setting applies to every octave sheet at once, and hidden values still count in calculations, plots and exports.

Keyboard shortcuts

The familiar Excel shortcuts work in the grid:

KeysWhat it does
Ctrl+Z / Ctrl+Y (or Ctrl+Shift+Z)Undo / redo
Ctrl+C / Ctrl+X / Ctrl+VCopy / cut / paste
Ctrl+Alt+VPaste special…
Ctrl+D / Ctrl+RFill down / fill right
Ctrl+EnterEnter the same thing in every selected cell
F2 / EscEdit the active cell / cancel the edit
F4 (while editing a formula)Cycle a reference through B$4, B$4, B4 and B4
Ctrl+G or F5Go To a cell
Ctrl+FFind in project
Ctrl+Page Up / Ctrl+Page DownPrevious / next sheet
Ctrl+arrow keys, Ctrl+Home / Ctrl+EndJump to the edge of the data / the start / the end
Ctrl+Space / Shift+SpaceSelect the whole column / row
Ctrl++ / Ctrl+-Insert rows above / delete the selected rows
Ctrl+9 / Ctrl+Shift+9Hide / unhide rows
Ctrl+0 / Ctrl+Shift+0Hide / unhide columns
Ctrl+B / Ctrl+I / Ctrl+UBold / italic / underline
Alt+=AutoSum
Ctrl+; / Ctrl+:Insert today's date / the current time
Ctrl+`Show formulas instead of results
F9 / Shift+F9Recalculate everything / this sheet
Ctrl+Shift+UExpand or collapse the formula bar
Ctrl+S / Ctrl+O / Ctrl+NSave / Open / new workspace
Ctrl+PExport
Ctrl+WClose the current sheet (it is hidden, not deleted) or pane

Register interest

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