login
Holden Web
What you'll need to know tomorrow

dwp: the JSON

← dwp

Exactly what edjas dwp.xlsx dwp.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: Public spending for the Department for Work and Pensions",
  "header": [
    "All Years",
    "2020-21",
    "2021-22",
    "2022-23",
    "2023-24",
    "2024-25",
    "2025-26"
  ],
  "rows": [
    [
      "Resource DEL2",
      "0",
      "0",
      "0",
      "0",
      "0",
      "0"
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Section A: Core Department",
      4667,
      5990,
      6044,
      6252,
      6348,
      7767
    ],
    [
      "Section B: Health and Safety Executive (Net)",
      165,
      162,
      157,
      181,
      180,
      179
    ],
    [
      "Section C: Money and Pensions Service (Net)",
      139,
      150,
      156,
      165,
      164,
      210
    ],
    [
      "Section D: Other Arm's Length Bodies (Net)",
      106,
      105,
      108,
      116,
      118,
      133
    ],
    [
      "Section E: Employment Programmes",
      293,
      790,
      815,
      753,
      765,
      790
    ],
    [
      "Section F: Support for Local Authorities",
      237,
      214,
      212,
      206,
      212,
      203
    ],
    [
      "Section G: Funding for Public Corporations",
      -13,
      -1,
      -9,
      -20,
      -22,
      -8
    ],
    [
      "Section H: Other Benefits",
      344,
      813,
      978,
      979,
      977,
      864
    ],
    [
      "Section I: National Insurance Fund - Core Department",
      687,
      714,
      211,
      301,
      647,
      516
    ],
    [
      "Section J: Social Fund",
      36,
      34,
      26,
      23,
      31,
      22
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Total Resource DEL",
      6661,
      8972,
      8696,
      8957,
      9420,
      10677
    ],
    [
      "Of which:",
      0,
      0,
      0,
      0,
      0,
      0
    ],
    [
      "Staff costs",
      3499,
      3865,
      3756,
      4096,
      4458,
      4607
    ],
    [
      "Purchase of goods and services",
      2237,
      2504,
      2324,
      2528,
      2722,
      3840
    ],
    [
      "Income from sales of goods and services",
      -294,
      -229,
      -222,
      -192,
      -191,
      -283
    ],
    [
      "Current grants to local government (net)",
      640,
      1106,
      1236,
      1224,
      1257,
      983
    ],
    [
      "Current grants to persons and non-profit (net)",
      464,
      1672,
      1520,
      1279,
      1341,
      1160
    ],
    [
      "Current grants abroad (net)",
      -186,
      -283,
      -556,
      -541,
      -538,
      "-"
    ],
    [
      "Subsidies to public corporations",
      48,
      48,
      39,
      35,
      35,
      6
    ],
    [
      "Rentals",
      54,
      18,
      34,
      42,
      17,
      80
    ],
    [
      "Depreciation3",
      185,
      264,
      565,
      558,
      416,
      448
    ],
    [
      "Take up of provisions",
      8,
      8,
      "-",
      "-",
      3,
      "-"
    ],
    [
      "Change in pension scheme liabilities",
      27,
      "-",
      "-",
      "-",
      "-",
      "-"
    ],
    [
      "Other resource",
      -23,
      -1,
      1,
      -73,
      -100,
      -164
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Resource AME4",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Section K: Severe Disablement Benefit",
      72,
      62,
      58,
      56,
      54,
      49
    ],
    [
      "Section L: Industrial Injuries Benefits Scheme",
      723,
      705,
      695,
      736,
      752,
      737
    ],
    [
      "Section M: Universal Credit",
      38082,
      40592,
      41170,
      52039,
      66546,
      75993
    ],
    [
      "Section N: Employment and Support Allowance (Income-Related)",
      8817,
      8182,
      7561,
      7446,
      7169,
      2679
    ],
    [
      "Section O: Income Support",
      1074,
      768,
      866,
      647,
      280,
      "-"
    ],
    [
      "Section P: Pension Credit",
      5071,
      4834,
      4935,
      5467,
      6008,
      5948
    ],
    [
      "Section Q: Financial Assistance Scheme",
      281,
      945,
      -1664,
      -271,
      162,
      177
    ],
    [
      "Section R: Attendance Allowance",
      5345,
      5307,
      5668,
      6696,
      7767,
      8307
    ],
    [
      "Section S: Personal Independence Payment",
      13692,
      15209,
      17637,
      21689,
      25898,
      28519
    ],
    [
      "Section T: Disability Living Allowance",
      5808,
      5696,
      5975,
      6862,
      7723,
      8017
    ],
    [
      "Section U: Carer's Allowance",
      3039,
      3075,
      3250,
      3738,
      4239,
      4469
    ],
    [
      "Section V: Housing Benefit",
      17027,
      15545,
      14876,
      15162,
      14677,
      11552
    ],
    [
      "Section W: Statutory Maternity Pay",
      2594,
      2569,
      2629,
      2881,
      3054,
      3167
    ],
    [
      "Section X: Christmas Bonus (Non-Contributory)",
      36,
      37,
      41,
      46,
      51,
      53
    ],
    [
      "Section Y: Jobseeker's Allowance (Income-Related)",
      435,
      300,
      225,
      145,
      91,
      "-"
    ],
    [
      "Section Z: State Pension (Non-Contributory)",
      135,
      160,
      179,
      224,
      229,
      214
    ],
    [
      "Section AA: Support for Mortgage Interest",
      6,
      3,
      2,
      2,
      4,
      -1
    ],
    [
      "Section AB: Cost of Living Support Payments",
      "-",
      "-",
      5665,
      7792,
      -4,
      5
    ],
    [
      "Section AC: Other Expenditure",
      -49,
      6,
      29,
      -2,
      -9,
      "-"
    ],
    [
      "Section AD: Other Expenditure EALBs (Net)",
      -1,
      "-",
      "-",
      1,
      "-",
      "-"
    ],
    [
      "Section AE: Social Fund: Winter Fuel",
      1957,
      1974,
      4566,
      4655,
      302,
      316
    ],
    [
      "Section AF: Incapacity Benefit",
      5,
      -9,
      12,
      -1,
      1,
      "-"
    ],
    [
      "Section AG: Social Fund: Other",
      145,
      10,
      192,
      80,
      78,
      86
    ],
    [
      "Section AH: Employment and Support Allowance (Contributory)",
      4567,
      4507,
      4527,
      4911,
      5168,
      4975
    ],
    [
      "Section AI: Maternity Allowance",
      384,
      362,
      390,
      412,
      403,
      424
    ],
    [
      "Section AJ: Bereavement Benefits",
      498,
      341,
      399,
      330,
      349,
      311
    ],
    [
      "Section AK: Christmas Bonus (Contributory)",
      123,
      124,
      126,
      128,
      130,
      132
    ],
    [
      "Section AL: Jobseeker's Allowance (Contributory)",
      611,
      190,
      108,
      169,
      222,
      249
    ],
    [
      "Section AM: State Pension (Contributory)",
      101901,
      104533,
      110355,
      123884,
      136357,
      145404
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Total Resource AME",
      212378,
      216030,
      230471,
      265923,
      287701,
      301780
    ],
    [
      "Of which:",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Current grants to local government (net)",
      17027,
      15545,
      14876,
      15162,
      14677,
      11552
    ],
    [
      "Current grants to persons and non-profit (net)",
      194051,
      198889,
      217830,
      251524,
      273993,
      290271
    ],
    [
      "Depreciation3",
      -107,
      224,
      -1476,
      137,
      96,
      392
    ],
    [
      "Take up of provisions",
      1555,
      1504,
      -399,
      -512,
      -811,
      177
    ],
    [
      "Release of provision",
      -394,
      -498,
      -750,
      -774,
      -704,
      -953
    ],
    [
      "Change in pension scheme liabilities",
      -26,
      2,
      2,
      2,
      2,
      "-"
    ],
    [
      "Other resource",
      271,
      364,
      389,
      385,
      448,
      342
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Total Resource Budget",
      219039,
      225002,
      239167,
      274880,
      297121,
      312457
    ],
    [
      "Of which:",
      0,
      0,
      0,
      0,
      0,
      0
    ],
    [
      "Depreciation3",
      78,
      488,
      -911,
      695,
      512,
      840
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Capital DEL5",
      0,
      0,
      0,
      0,
      0,
      0
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Section A: Core Department",
      279,
      442,
      231,
      475,
      469,
      678
    ],
    [
      "Section B: Health and Safety Executive (Net)",
      11,
      17,
      14,
      26,
      9,
      13
    ],
    [
      "Section C: Money and Pensions Service (Net)",
      1,
      "-",
      12,
      6,
      12,
      15
    ],
    [
      "Section D: Other Arm's Length Bodies (Net)",
      8,
      6,
      8,
      12,
      -18,
      1
    ],
    [
      "Section G: Funding for Public Corporations",
      108,
      113,
      140,
      63,
      1,
      "-"
    ],
    [
      "Section J: Social Fund",
      62,
      49,
      46,
      51,
      49,
      50
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Total Capital DEL",
      468,
      626,
      450,
      632,
      522,
      756
    ],
    [
      "Of which:",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Staff costs",
      2,
      3,
      3,
      6,
      9,
      10
    ],
    [
      "Purchase of goods and services",
      3,
      14,
      8,
      6,
      8,
      20
    ],
    [
      "Capital grants to private sector companies (net)",
      "-",
      "-",
      3,
      9,
      -3,
      12
    ],
    [
      "Capital support for public corporations",
      108,
      110,
      138,
      61,
      48,
      86
    ],
    [
      "Purchase of assets",
      319,
      457,
      286,
      621,
      462,
      580
    ],
    [
      "Income from sales of assets",
      -25,
      -2,
      -34,
      -125,
      -48,
      "-"
    ],
    [
      "Net lending to the private sector and abroad",
      62,
      49,
      46,
      51,
      49,
      50
    ],
    [
      "Other capital",
      "-",
      -4,
      "-",
      3,
      -2,
      "-"
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Capital AME",
      0,
      0,
      0,
      0,
      0,
      0
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Section M: Universal Credit",
      168,
      70,
      110,
      129,
      267,
      462
    ],
    [
      "Section AA: Support for Mortgage Interest",
      29,
      18,
      16,
      30,
      46,
      71
    ],
    [
      "Section AC: Other Expenditure",
      "-",
      "-",
      7,
      46,
      -23,
      45
    ],
    [
      "Section AG: Social Fund: Other",
      -51,
      -58,
      -63,
      -49,
      -50,
      -60
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Total Capital AME",
      146,
      30,
      70,
      157,
      241,
      518
    ],
    [
      "Of which:",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Net lending to the private sector and abroad",
      443,
      475,
      197,
      263,
      578,
      554
    ],
    [
      "Other capital",
      -298,
      -445,
      -134,
      -156,
      -314,
      -82
    ],
    [
      "Take up of provisions",
      "-",
      "-",
      7,
      50,
      3,
      45
    ],
    [
      "Capital grants to private sector companies (net)",
      "-",
      "-",
      "-",
      "-",
      -5,
      "-"
    ],
    [
      "Release of provision",
      "-",
      "-",
      "-",
      "-",
      -20,
      "-"
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Total Capital Budget",
      614,
      656,
      520,
      790,
      763,
      1274
    ],
    [
      "Total departmental spending",
      219574,
      225170,
      240598,
      274975,
      297371,
      312892
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Of which:",
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Total DEL",
      6944,
      9334,
      8581,
      9031,
      9526,
      10985
    ],
    [
      "Total AME",
      212630,
      215836,
      232017,
      265943,
      287845,
      301906
    ]
  ]
}

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