Each spreadsheet has the following components:

  • Discipline sheets.
  • Automatic counts.
  • Manual counts.
  • Length.
  • Length (Itemised).
  • Area.
  • Area (Itemised).
  • Columns.

Discipline sheets

At the bottom of each Excel spreadsheet are separate “sheets” for each discipline within Countfire.

These sheets, and the way they correspond to disciplines are an important part of structuring your project within Countfire

Learn more about structuring your project.

Automatic counts

Any symbol descriptions you create in-app on the “Count” tab, that have selections below them which automatically match on any symbols, are listed within the “Automatic counts” section of the Excel spreadsheet.

Manual counts

Any manual points you add in-app on the “Measure” tab are listed within the “Manual counts” section of the Excel spreadsheet.

Length

Any lengths you measure in-app on the “Measure“ tab, that don’t have the itemise measurements box checked, are listed within the “Length” section of the Excel spreadsheet.

Length (Itemised)

Any lengths you measure in-app on the “Measure” tab, that have the itemise measurements box checked, are listed within the “Length (Itemised)” section of the Excel spreadsheet.

Area

Any areas you measure in-app on the “Measure” tab, that don’t have the itemise measurements box checked, are listed within the “Area” section of the Excel spreadsheet.

Area (Itemised)

Any areas you measure in-app on the “Measure” tab, that have the itemise measurements box checked, are listed within the “Area (Itemised)” section of the Excel spreadsheet.

Columns

By default, Countfire breaks down all quantities on a per drawing basis, and for each PDF file you upload, a separate column in the Excel spreadsheet is created.

How are demarcations are handled?

When the Excel spreadsheet is generated, demarcations are also taken into account, and additional columns are added for each demarcation heading you have within Countfire.

In the example above, you can see the “Level 3” drawing has been further broken down with the use of demarcations, and additional columns have been created for quantities within the “Drawing area” and “Restrooms” demarcations.

Why is there a column in red?

This column has been highlighted to emphasise that a demarcation multiplier has been used for the “Restrooms” demarcation, and all the values within that column have been multiplied by 5.

Learn more about demarcation multipliers.

Measurements with no scale set

If you've measured items on a drawing, but haven't set a scale, Countfire will highlight this in the spreadsheet by highlight those cells red.

This can be corrected by setting a scale on the relevant drawing (“Level 4” in the example above).

Learn more about setting scales.

How can I change or update the spreadsheet?

You can alter anything within the spreadsheet simply by changing the related item within Countfire itself, saving, and then reprocessing the project.

Learn more

How to: Make clean selections.

Did this answer your question?