Quantity take-off app · Windows, iOS and Android

Quantity take-offs:a real spreadsheet that turns dimensions into quantities.

The Sitabula Quantity Take-offs module is not a list but a real spreadsheet. You type the item and its dimensions in each row and the quantity is calculated; where needed, cells take formulas just as in Excel. A saved sheet goes to a subcontractor or the file as Excel or PDF, and is linked to a work item in Field Progress, from where the quantity flows into interim payments.

A take-off sheet: folder path, details strip, rows with formulas and the total

Screen taken as-is from the Windows app; data belongs to a sample project.

01 Source

Where did this quantity come from?

  • 01

    Which dimensions were multiplied: count, length, width and height on every row; the quantity is their product.

  • 02

    How much there is in one place: the total of filtered rows in the strip below.

  • 03

    Who changed it and when: each sheet's last change in the library.

  • 04

    Where the sheets are: a take-off library with folders up to three levels; the search box looks in sheet names.

02 Step by step

How it works

  1. 01

    Create a take-off.

    Press New take-off in the library; an empty sheet opens with forty working rows. Give it a name and, if you like, a folder and a subcontractor.

  2. 02

    Fill in the rows.

    Quantity = Count × Length × Width × Height. An empty dimension is left out of the product; 0 is a real zero. Type a number or formula into the quantity cell by hand and it is kept even if the dimensions change.

  3. 03

    Write formulas.

    A cell starting with = is a formula: arithmetic, cell references, ranges and absolute references. English and Turkish function names both work (SUM / TOPLA, ROUND / YUVARLA…); the argument separator is a semicolon.

  4. 04

    Shape the columns.

    Columns can be added, deleted, renamed and moved; the unit is part of the cell's number format, cells can be merged, and rows filtered and sorted.

  5. 05

    Save.

    Save updates the sheet; Save as makes a second version of it.

If you already have a sheet in Excel, use Import from Excel: download the template and fill it in, or pick your own file. The preview shows how many rows were read, which columns matched and how many formulas were converted; rows either replace the existing ones or are added at the end. Nothing is written until you confirm the preview.

You type the dimensions: Sitabula does not take quantities off drawings or models.

03 Exports

Exports

01

Excel

a details block (project, take-off name, folder, subcontractor, date), an orange header row and a TOTAL row. Numbers are numbers with the unit in the format; formulas come out as live Excel formulas. Header row frozen, filters on.

02

PDF

an A4 landscape table; date, row count, subcontractor and total in the top right; empty rows are not printed.

03

Import template

an empty Excel file carrying the sheet's column headers.

Exporting and filtering need no edit permission.

04 Safeguards

Safeguards

  • 01

    No total across mixed units: cubic metres and square metres are not added up, and the total reads (mixed units). A sheet with more than one unit cannot be linked to a work item.

  • 02

    A formula that cannot be calculated shows an error mark (#VALUE!, #DIV/0!, #REF!…); the mark is not saved.

  • 03

    A second sheet with the same name in the same folder is never created silently; the app offers to overwrite or asks for a new name.

  • 04

    If saving cannot reach the server, your rows stay on screen.

05 Connections

How it connects

A saved sheet is linked in Field Progress as the source of a work item; quantity and unit come from the sheet's total and are locked. The quantity of a unit-price work item ends up in Interim Payments; the sheet is the record of where that number came from.

06 On the phone

On the phone

Sheets are prepared and edited on Windows. In the Android and iOS apps you open and read saved sheets and export them to Excel and PDF.

07 Free plan

On the free plan

Quantity Take-offs is included in the free plan. The work items a sheet links to sit in the project structure, which on the free plan is limited to 1 building, 1 unit and 2 areas.

08 FAQ

Frequently asked

Can I import my take-off spreadsheet?

Yes. Recognised headers are matched by name and formulas are converted; the preview shows the result.

Do formulas work in the Excel export?

Yes; they come out live, so changing a dimension in the file changes the quantity.

Which function names can I use?

English names such as SUM, AVERAGE and ROUND, and their Turkish equivalents.

How does a take-off reach an interim payment?

The sheet is linked to a work item in Field Progress; once the item is Done, it is added to a payment through a unit-price agreement.

Does it take quantities off drawings?

No. You type dimensions into the sheet or import them from Excel.

Can I edit take-offs on the phone?

No. On the phone sheets are read and exported; editing is done on Windows.

Build your first take-off sheet in Sitabula. One project is free, with no time limit.