Parts and formulas

Each part turns the item's measured quantity into a quantity of its own, through a formula, then into a cost.

An item with several parts is an assembly: one measurement drives every part. A stud wall's length becomes studs, track, board, screws, tape and the labor to hang it.

The parts grid

Each row is one part:

  • Part: its name.
  • Kind: Material, Labor, Equipment or Subcontract.
  • Quantity formula: how much of the part one takeoff needs. The result shows as you type.
  • Unit: the part's own unit, such as EA, LF or BOX.
  • Pack: a pack size, if it is bought in packs.
  • Price: see Price basis: cost each, tag or lump sum.
  • Labor basis · crew: for labor parts. See Labor parts.
  • Category: the labor category.
  • Tax: whether the part is taxable.
  • State: Priced, No charge, By others, Owner-furnished or Not priced.
  • Cost: what it comes to at the previewed quantity.

Click ▸ at the start of a row for its Advanced line: pack size, whole packs, what the price is per, whether it reads waste, the tag's value, and a note. Right-click a row for Edit labor…, Duplicate, Move up, Move down and Delete part.

Write a formula

A formula reads names in square brackets. As you type, Kredna suggests the names this item can use and shows the result.

  • [Qty]: the measured quantity, in the item's unit.
  • [Length], [Area], [Volume], [Perimeter] and [Segments] (the number of runs), as the item's measure allows.
  • [Count]: the number of takeoffs.
  • [QtyWithWaste] and [Waste].
  • Your properties, such as [Height] or [Spacing], and properties of the folders above the item.

Use + - * / ^ and parentheses, and these functions: roundup, rounddown, round, ceil, floor, min, max, abs, sqrt, if(condition, then, otherwise), and, or, not. Names are not case-sensitive.

Examples:

  • Studs at a spacing: roundup([Length] / [Spacing]) + 1
  • Board for both faces: [Length] * [Height] * [Sides]
  • Hangers every 16 square feet: roundup([Area] / 16)

Formulas run per takeoff

Each takeoff's quantity, with its own overrides, runs through the formula; then the results are added up. That way one wall at 10' and another at 14' each get the right number of studs.

Mistakes never price at zero

A formula Kredna can't work out marks the part Not priced with the reason ("Formula error"). It is never counted as $0. See Missing is never zero.

Something here doesn't match what you see in the app? Tell us at support@kredna.com.