The report's tables, written from the metric.
With a seat, Quadrat writes the BNG assessment's tables from the two files into your own Word report, in the browser: baseline and post-development per sheet, the headline results, the condition appendix, the cross-check. Every cell is transcribed from the metric as it stores it; no unit is calculated, no condition re-scored.
Drop the metric workbook here
.xlsx or .xlsm · statutory metric 1.0.x and small sites metric 1.2.x
The tables are written by JavaScript in this browser and nowhere else; with JavaScript off, nothing here can read the file.
Optional: drop the filled condition assessment workbook too (GOV.UK Technical Annex 1, .xlsx)
What comes out
- Baseline and post-development tables, one per metric sheet: area habitats, hedgerows, watercourses, on-site and off-site.
- Headline results per module, as the metric's Headline Results sheet states them.
- The condition assessment appendix: every criterion and justification as the surveyor marked it, from the GOV.UK condition workbook.
- The cross-check: each baseline parcel matched to its condition sheet by reference, and where the two documents the authority receives disagree.
- One descriptive sentence per parcel that says what was scored and never why.
A sample document (Word, 12 KB), built from a fictional survey — Mill Field, Anytown, nine parcels, deliberately inconsistent so the cross-check has something to find — shows all of it. A baseline table looks like this:
| Ref | Habitat | Area (ha) | Distinctiveness | Condition | Strategic significance | Units |
|---|---|---|---|---|---|---|
| G1 | Grassland - Modified grassland | 0.42 | Low | Good | Area/compensation not in local strategy/ no local strategy | 1.26 |
| G2 | Grassland - Modified grassland | 0.31 | Low | Moderate | Location ecologically desirable but not in local strategy | 0.68 |
| G3 | Grassland - Modified grassland | 0.18 | – | Poor | – | – |
Values exactly as the metric stores them; a dash is a cell the metric had not calculated.
What it replaces
By hand, these tables are the metric's rows copied cell by cell into Word — a site with twenty parcels is a few hundred cells, retyped at every iteration of the metric — and the condition appendix is fifty-odd sheets summarised one criterion at a time. The cross-check is the comparison the authority's ecologist makes when the report and the sheets disagree, run before they see it.
Into your own document
Drop your own template — the report you already write, with your styles, headers and footers — and you get it back with every table appended at the end, in your heading styles. Or use the starter template (Word, 4 KB), which has each table's place marked already. Or drop nothing and get a plain A4 document.
Optional: drop your Word template or report (.docx)
Placing each table exactly where you want it
If a template carries none of these, every table goes at its end. To put a table somewhere else, type its placeholder there, on a paragraph of its own; the tables take that paragraph's style. Case does not matter. The starter template has them all in place.
- {{quadrat.baseline}}
- baseline tables, one per sheet
- {{quadrat.post}}
- post-development tables
- {{quadrat.headline}}
- headline results per module
- {{quadrat.conditions}}
- the condition assessment appendix
- {{quadrat.crosscheck}}
- the cross-check
- {{quadrat.text}}
- the descriptive sentences
- {{quadrat.summary}}
- one paragraph
- {{quadrat.all}}
- everything, in order
And inline, anywhere, including headers and footers, keeping your formatting: {{quadrat.site}} {{quadrat.lpa}} {{quadrat.applicant}} {{quadrat.reference}} {{quadrat.type}} {{quadrat.completedBy}} {{quadrat.date}} {{quadrat.iteration}} {{quadrat.version}} {{quadrat.target}} {{quadrat.verdict}} {{quadrat.engine}} {{quadrat.generated}}. Anything else in the template is left exactly as it is.
£79 per seat per month, or £790 a year, ex VAT · one seat is one person · cancel in one click
Have a seat key?
It is checked in your browser and kept only in this browser.