Tutorials TakeoffCraft help Reference

Export columns

Every worksheet and column of the XLSX export and the CSV, with the formulas the Estimate worksheet carries.

Written for TakeoffCraft 0.3. The same help is inside the app: press F1.

Estimate (XLSX worksheet and CSV)

One row per item, followed by a row per component of its assembly (indented). Then an empty row and the job total.

ColumnContentsIn the XLSX
A ItemItem name (bold) or component name (indented)Text
B TypeLinear, Area, Count or ComponentText
C UnitLF, m, SF, SY, m², EA, or the component's unitText
D QuantityMeasured total, or the formula resultNumber
E Waste %WastePercent (0.10 = 10%)
F Qty with wasteQuantity × (1 + waste)Formula D*(1+E)
G Material per unitMaterial rateNumber
H Labor per unitLabor rateNumber
I MaterialExtended materialFormula ROUND(F*G,2)
J LaborExtended laborFormula ROUND(F*H,2)
K TotalMaterial + laborFormula I+J
L NotesFormula used, formula error, marks on sheets with no scale, wall area, perimeterText

Job total row: SUM of columns I, J and K over every row above, and "Incomplete: see the notes above" in Notes when something was left out.

A row with a formula error has no quantity or amounts; its note gives the error. The header row is frozen.

In the CSV, the same columns hold plain values, Waste % is a number of percent (10 for 10%), and money is in dollars with two decimals. Text that a spreadsheet might take for a formula (starting with =, +, - or @) gets a leading ' so it stays text.

By sheet (XLSX only)

ColumnContents
SheetSheet name (with the PDF name when it is not open)
ItemItem name
QuantityThat item's quantity on that sheet, in its unit
UnitThe item's unit
MarksNumber of marks

Marks (XLSX only)

One row per mark.

ColumnContents
SheetSheet name
ItemItem name
TypeLinear, Area or Count
QuantityLength, net area, or 1
UnitLF or m; SF, SY or m²; EA
DetailLinear: the segment lengths. Area: gross and cut-out areas when there are cut-outs, and the perimeter. "Sheet has no scale" for unscaled marks.

Scales (XLSX only)

One row per sheet that has a scale or marks.

ColumnContents
SheetSheet name
ScaleThe preset's name, or the calibrated scale, or "No scale"
How"Preset", or "Calibrated on (the distance you typed)"
Feet per PDF unitThe exact scale factor TakeoffCraft uses

File names

  • (name).xlsx and (name).csv, where the name comes from the first PDF opened in the takeoff.
  • The CSV is UTF-8 with a byte order mark and Windows line endings, which spreadsheet programs on every platform read.