← All examples

EDJAS spec for the Scottish Local Government Finance Statistics ledger.

The 'Scotland' sheet is a revenue account: subservice line items grouped into categories, each closed by a "Total ..." subtotal, down to the grand total "All Services (GF + HRA)". The same block is also a named Excel Table (Table3), so [Table3] would resolve to exactly this range too.

The report renders header as the column titles and rows as the ledger body; the template classifies each row (line item vs "Total ..." subtotal) for styling.

The specification

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

[extract]
title  = "'Scotland'!A1"
region = "'Scotland'!A2"
header = "['Scotland'!A6:D6]"
rows   = "['Scotland'!A7:D89]"

The JSON it produces

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

The report it produces

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.