← All examples

EDJAS spec for the DWP public spending tables (Annual Report & Accounts companion).

'Table 1' has a space in its sheet name, so the reference is single-quoted exactly as Excel writes it. The ledger runs from row 8 (Resource DEL) to row 122 (Total AME); rows 129 onwards are footnotes and are deliberately left out.

Budget categories (Resource DEL, Resource AME, Capital DEL, ...) head runs of "Section A/B/C..." line items, each closed by a "Total ..." subtotal, with "Of which:" breakdowns. Columns are six years: four outturn, then plans.

The specification

The whole of dwp.toml, applied to the unmodified dwp.xlsx.

[extract]
title  = "'Table 1'!A1"
header = "['Table 1'!A5:G5]"
rows   = "['Table 1'!A8:G122]"

The JSON it produces

See the extracted JSON — exactly what edjas dwp.xlsx dwp.toml prints, which is the thing the report below is only one rendering of.

The report it produces

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.