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.