Skip to content

Worksheet settings

A worksheet’s settings are at the top of its file, between --- lines, as key: value (YAML). Every one is optional, and most are set from the Format menu. A result. setting is written below result::

---
title: Beam B1
result:
significant: 3
header: {right: "Page {page} of {pages}"}
---
SettingDefaultWhat it does
titlethe file’s nameThe worksheet’s title, {title} in a header or footer.
pageA4The page size, A4 or letter, with ¾ inch margins.
headernoneText in the top margin of every page: header: Calculation 12 (centred), or header: {left: "{title}", centre: …, right: "Page {page} of {pages}"}. The fields are {page}, {pages}, {title} and {date}.
footernoneText in the bottom margin of every page, as header.
single_page_widthfalsetrue: printing and PDF export leave out what is past the right margin, rather than printing it on extra pages (File → Print single page width).
result.decimals3Decimal places shown in results.
result.significantnoneSignificant figures shown instead of decimal places.
result.strictfalseWith significant: round digits left of the decimal point too (1234.567 to 3 figures is 1230, not 1235).
result.trailing_zerosfalseWith decimals: pad results to the full number of places.
result.exponential_threshold6Numbers of 10ⁿ or more, or below 10⁻ⁿ, are shown with an exponent.
result.zero_threshold15Values below 10⁻ⁿ show as 0.
result.complex_threshold10A real or imaginary part smaller than 10⁻ⁿ of the other is hidden.
result.prefixestrueEngineering prefixes on results with no unit asked for (54 kN·m); false turns them off.
multiplicationdotHow * is drawn: dot (a·b) or space (a b) (Format → Multiplication).
origin0The first index of arrays, the starting value of ORIGIN.
tolerance1e-3The starting value of TOL, used by the solvers and by comparisons (==, <, …).
anglenonedimension makes angle a dimension of its own, with rad its unit (Format → Units).
angle_displaydegWith angle: dimension, how an angle shows when no unit is asked for: deg or rad.
currencynoneA currency dimension whose unit has this name, such as AUD or € (Format → Units).
beermat1The version of the file format, written by Beermat.
resultsA fingerprint of the sheet when its results were saved, written by Beermat, so that results left over from an older version of the sheet aren’t shown.