Each spreadsheet has the following components:
Sheets
Takeoff overview sheet
Drawing list sheet
Discipline sheets
Quantities
Count - which include the automatic counts
Measure - which include lengths, areas and manual points
Takeoff overview sheet
This sheet includes a per discipline breakdown of your takeoff's structure, with quick links through to individual sheets containing the quantities for each discipline.
It also shows the number of drawings within each discipline, the total number of drawings within the project, and quick links through to the check sheets for each discipline.
Drawing list sheet
This sheet includes a list of all drawings that were uploaded to the takeoff, broken down by discipline.
It also shows the date & time each PDF was uploaded, and any drawing titles (if present).
Discipline sheets
These sheets, and the way they correspond to disciplines are an important part of structuring your takeoff within Countfire.
Learn more about structuring your takeoff.
Count
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 “Count” section of the Excel spreadsheet.
These symbol descriptions are then further broken down according to any groups that were created in-app.
Measure
Any manual points, lengths and areas you create in-app on the “Measure” tab are listed within the “Measure” section of the Excel spreadsheet.
These measurements are then further broken down according to any groups that were created in-app.
Manual points
Any manual points you add in-app on the “Measure” tab are listed as 'Point' in the type column.
Lengths
Any lengths you measure in-app on the “Measure“ tab, that don’t have the itemise measurements box checked, are listed as “Length (m)” in the type column.
Lengths (Itemised)
Any lengths you measure in-app on the “Measure” tab, that have the itemise measurements box checked, are listed as “Length (m)” in the type column.
Areas
Any areas you measure in-app on the “Measure” tab, that don’t have the itemise measurements box checked, are listed as “Area (㎡)” in the type column.
Areas (Itemised)
Any areas you measure in-app on the “Measure” tab, that have the itemise measurements box checked, are listed as “Area (㎡)” in the type column.
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 zones handled?
When the Excel spreadsheet is generated, zones are also taken into account, and additional columns are added for each zone heading you have within Countfire.
In the example above, you can see the “Level 1” drawing has been further broken down with the use of zones, and additional columns have been created for quantities within the “Drawing area” and “Restrooms” zones.
Why is there a column in red?
This column has been highlighted to emphasise that a zone multiplier has been used for the “Restrooms” zone, and all the values within that column have been multiplied by 5.
Learn more about zone 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 takeoff.