login
Holden Web
What you'll need to know tomorrow

pesa: the JSON

← pesa

Exactly what edjas pesa.xlsx pesa.toml writes to standard output, from the unmodified workbook. Run at build time, not stored, so this is the current output of the current code.

{
  "title": "Table 1.1 Total Managed Expenditure, 2020-21 to 2025-26",
  "unit": "£ million",
  "header": [
    null,
    "2020-21",
    "2021-22",
    "2022-23",
    "2023-24",
    "2024-25",
    "2025-26"
  ],
  "rows": [
    [
      "CURRENT EXPENDITURE",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Resource DEL",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Resource DEL excluding depreciation (1)",
      457935,
      442132,
      441157,
      452098,
      484342,
      511156
    ],
    [
      "Depreciation in resource DEL (1)",
      26127,
      20062,
      8830,
      28900,
      32324,
      28806
    ],
    [
      "Total resource DEL",
      484062,
      462193,
      449987,
      480998,
      516667,
      539962
    ],
    [
      "Resource departmental AME",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Social security benefits",
      229535,
      233022,
      246311,
      280256,
      311841,
      326220
    ],
    [
      "Tax credits (2) ",
      15390,
      11021,
      8915,
      7456,
      3239,
      163
    ],
    [
      "Net public service pensions",
      41938,
      57408,
      51746,
      -7020,
      -18256,
      -15085
    ],
    [
      "National lottery",
      1232,
      1544,
      1300,
      1061,
      1194,
      1586
    ],
    [
      "BBC domestic services ",
      3191,
      3607,
      4201,
      3471,
      4484,
      4115
    ],
    [
      "Student loans",
      -4851,
      -5127,
      -9358,
      -16611,
      -16063,
      -14533
    ],
    [
      "Non-cash items",
      38971,
      203983,
      -161128,
      35690,
      100562,
      156000
    ],
    [
      "Financial sector interventions",
      44548,
      47220,
      137220,
      39774,
      34690,
      40700
    ],
    [
      "Other departmental expenditure",
      138535,
      72899,
      74568,
      81593,
      75156,
      77312
    ],
    [
      "Total resource departmental AME",
      508490,
      625577,
      353775,
      425670,
      496848,
      576478
    ],
    [
      "Resource other AME",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Net expenditure transfers to the EU (3)",
      10930,
      315,
      -383,
      904,
      -1186,
      -108
    ],
    [
      "Locally financed expenditure",
      25304,
      39430,
      49770,
      52612,
      52342,
      69695
    ],
    [
      "Central government gross debt interest",
      41012,
      70892,
      108063,
      82933,
      84798,
      100443
    ],
    [
      "Accounting adjustments",
      -88206,
      -263272,
      91890,
      51404,
      -11125,
      -94942
    ],
    [
      "Total resource other AME",
      -10960,
      -152635,
      249340,
      187853,
      124830,
      75087
    ],
    [
      "Total resource AME",
      497530,
      472942,
      603115,
      613523,
      621678,
      651565
    ],
    [
      "Public sector current expenditure",
      981592,
      935135,
      1053102,
      1094521,
      1138345,
      1191527
    ],
    [
      "CAPITAL EXPENDITURE",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Capital DEL",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Total capital DEL",
      94916,
      93143,
      100451,
      106709,
      111886,
      121143
    ],
    [
      "Capital departmental AME",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "National lottery",
      198,
      164,
      201,
      347,
      414,
      444
    ],
    [
      "BBC domestic services ",
      20,
      90,
      755,
      458,
      663,
      146
    ],
    [
      "Student loans",
      22612,
      23464,
      26679,
      33448,
      33587,
      32559
    ],
    [
      "Financial sector interventions",
      -2742,
      -3779,
      2863,
      41065,
      28167,
      27000
    ],
    [
      "Other departmental expenditure",
      17309,
      -1974,
      2682,
      919,
      3403,
      14470
    ],
    [
      "Total capital departmental AME",
      37397,
      17965,
      33180,
      76237,
      66234,
      74620
    ],
    [
      "Capital other AME",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Locally financed expenditure",
      11560,
      9839,
      8364,
      8550,
      9943,
      9419
    ],
    [
      "Public corporations' own-financed capital expenditure",
      8498,
      7688,
      7924,
      12775,
      15831,
      10778
    ],
    [
      "Accounting adjustments",
      -26764,
      -20048,
      -42044,
      -69794,
      -57023,
      -60300
    ],
    [
      "Total capital other AME",
      -6705,
      -2521,
      -25756,
      -48469,
      -31249,
      -40104
    ],
    [
      "Total capital AME",
      30692,
      15444,
      7424,
      27768,
      34985,
      34516
    ],
    [
      "Public sector gross investment (4)",
      125608,
      108587,
      107875,
      134477,
      146871,
      155659
    ],
    [
      "less public sector depreciation ",
      53643,
      55309,
      60304,
      65315,
      69045,
      74113
    ],
    [
      "Public sector net investment (4) ",
      71965,
      53278,
      47571,
      69162,
      77826,
      81547
    ],
    [
      "TOTAL MANAGED EXPENDITURE (5) ",
      1107200,
      1043722,
      1160977,
      1228998,
      1285216,
      1347186
    ],
    [
      "of which:",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Total DEL (6)",
      552851,
      535274,
      541607,
      558807,
      596228,
      632299
    ],
    [
      "Departmental AME",
      545887,
      643542,
      386956,
      501907,
      563082,
      651098
    ],
    [
      "Other AME",
      8462,
      -135094,
      232414,
      168284,
      125906,
      63789
    ]
  ]
}

The example page has the specification that produced this, and the report rendered from it.