How this site was built

This site is generated by EDJAS's own machinery, and it is worth being precise about what that does and does not mean.

The pages you are reading extend the same template as the reports. Every documentation page and every generated report inherit from one base.html, which carries the palette, the measure and the dark-mode rules. A page and a report are the same document with different content — and a test asserts that the committed reports are byte-for-byte what the code produces, so the two cannot drift apart.

The reports in the gallery were produced by EDJAS, from the unmodified workbooks listed above, by the same edjas-examples command anyone can run.

Some of what you are reading came out of a spreadsheet. The gallery cards' framing — the shape tag, the one-line description, the publisher — is held in a small workbook, docs/site.xlsx, and extracted when this site is built by an ordinary EDJAS specification. That is the same "one workbook, many audiences" idea the essay argues for, applied to this site.

Some of it deliberately did not. The list of built-in functions, the API signatures and the command-line help are read from the EDJAS code itself by introspection, not from a spreadsheet. A reference page that can disagree with the code is worse than no reference page at all. Where a table is held in the workbook and also exists in code, a test asserts the two agree, so a stale copy fails the suite rather than reaching you.

The prose is Markdown, composed rather than copied: this page renders the real ATTRIBUTION.md that ships inside the package, and this page renders the companion package's own README. Each gallery page takes its introduction from the comment header of the specification file it describes. Nothing is duplicated by hand, so nothing can quietly fall out of step.

Source data and licences

All seven bundled workbooks are UK public-sector statistics, Crown copyright, and redistributed here unmodified under the Open Government Licence v3.0 purely as realistic examples for the EDJAS reporting demo:

Contains public sector information licensed under the Open Government Licence v3.0.

Each entry below records the exact URL the bundled copy was downloaded from, so the provenance of every workbook can be checked. All seven were verified byte-for-byte against their published originals.

retail.xlsx — a flat statistics release

Retail Sales Index — Summary and Quality Tables, Retail Sales Index, Great Britain, May 2025, Office for National Statistics. Published 20 June 2025. More at ons.gov.uk.

A "Releasing statistics in spreadsheets" good-practice release: a cover sheet, a contents sheet, and data laid out as a named Excel Table (RevisionTriangles_Table1).

Downloaded from ons.gov.uk.

slgfs.xlsx — a local-government revenue ledger

Scottish Local Government Finance Statistics 2024-25 — LA Level, Net Revenue Expenditure by Subservice, Scottish Government. A revenue account per council: subservice line items grouped into categories, each closed by a Total … subtotal, down to All Services (GF + HRA). Every council sheet is a named Excel Table. Collection: gov.scot.

Downloaded from gov.scot.

pesa.xlsx — a central-government expenditure ledger

Public Expenditure Statistical Analyses 2025 — Chapter 1 (Departmental budgets), HM Treasury (Accredited Official Statistics). Table 1.1, Total Managed Expenditure, is a three-tier ledger — CURRENT/CAPITAL EXPENDITURE sections, budget categories, line items, and Total … roll-ups — over six years. Collection: GOV.UK.

Downloaded from GOV.UK.

dwp.xlsx — a departmental spending ledger

Public spending and administration budget 2021 to 2026, Department for Work and Pensions — the data-tables companion to the DWP Annual Report and Accounts 2024-25. Budget categories (Resource/Capital DEL and AME) head runs of Section A/B/C… estimate lines, each closed by a Total … subtotal with Of which: breakdowns. Its sheet is named Table 1, so the spec quotes it as Excel does. Publication: GOV.UK.

Downloaded from GOV.UK.

Note: these tables are compiled on the HM Treasury OSCAR budgetary basis and, as their own footnotes say, are not reported on the same basis as the audited financial statements.

wales.xlsx — a revenue account with GSS metadata

Local authority revenue and capital outturn expenditure: April 2024 to March 2025, Welsh Government. A GSS-format release — cover sheet, table of contents, notes, then one table per sheet. Table 1 is a full revenue account running from service line items through Gross/Net revenue expenditure and Budget requirement to Council tax requirement. Its value columns deliberately mix £ million, change, percentage and £-per-head, which the ledger template formats to differing precision. More at gov.wales.

Downloaded from gov.wales.

cra.xlsx — a COFOG-classified expenditure ledger

Country and Regional Analysis 2024, Chapter B tables, HM Treasury. Table B.1 classifies England's identifiable expenditure by COFOG function: ten numbered function headings, each over numbered sub-function line items (some with nested of which: detail) and closed by a Total <function> subtotal, ending at Total Expenditure on Services in England. Nil cells hold -, which the template passes through rather than formatting as a number. Publication: GOV.UK.

Downloaded from GOV.UK.

nbs.xlsx — a large multi-sheet reference workbook

The UK national balance sheet estimates, Office for National Statistics — the full reference-tables workbook: 19 sheets, including ~50-column time-series matrices per institutional sector, carrying 216 auto-generated Excel Table fragments. The spec deliberately extracts only the headline statement from Table A (net worth at the start of 2024, by sector and asset class, down to the Total economy roll-up), demonstrating how a small spec carves a readable brief out of a workbook built for expert reuse. Releases: ons.gov.uk.

Downloaded from ons.gov.uk.

The example workbooks

Where the example data comes from, and under what licence.