Summary of currently loaded spend data for: Department of Energy and Climate Change

Lastfile: DECC_201607
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
DECC_201101.csv 195,633,065.86 561 0 348,722.04 103,487,500.00 2011-01-04 2011-01-31 27    
DECC_201102.csv 161,550,532.08 600 0 269,250.89 53,390,871.76 2011-02-01 2011-02-28 27    
DECC_201103.csv 437,933,812.77 945 0 463,422.02 180,000,000.00 2011-03-01 2011-03-31 30     Jump in TotalAmt.
DECC_201104.csv 71,831,123.13 508 0 141,399.85 14,922,839.68 2011-04-01 2011-04-28 27     Large drop in TotalAmt.
DECC_201105.csv 269,056,194.37 512 0 525,500.38 200,000,000.00 2011-05-03 2011-05-31 28     Jump in TotalAmt. Jump in AvgAmt
DECC_201106.csv 247,099,755.06 547 0 451,736.30 130,000,000.00 2011-06-01 2011-06-30 29    
DECC_201107.csv 200,103,669.39 447 0 447,659.22 150,000,000.00 2011-07-01 2011-07-29 28    
DECC_201108.csv 191,787,304.17 459 0 417,837.26 140,000,000.00 2011-08-01 2011-08-31 30    
DECC_201109.csv 202,702,147.40 435 0 465,981.95 140,000,000.00 2011-09-01 2011-09-30 29    
DECC_201110.csv 178,804,939.95 473 0 378,023.13 140,000,000.00 2011-10-03 2011-10-31 28    
DECC_201111.csv 148,496,342.40 494 0 300,599.88 105,000,000.00 2011-11-01 2011-11-30 29    
DECC_201112.csv 169,029,217.28 505 0 334,711.32 92,025,000.00 2011-12-01 2011-12-30 29    
DECC_201201.csv 216,336,833.09 578 0 374,285.18 150,000,000.00 2012-01-03 2012-01-31 28    
DECC_201202.csv 204,095,040.35 631 0 323,446.97 150,000,000.00 2012-02-01 2012-02-29 28    
DECC_201203.csv 232,475,523.99 920 0 252,690.79 100,000,000.00 2012-03-01 2012-03-30 29    
DECC_201204.csv 306,979,415.30 639 0 480,405.97 260,000,000.00 2012-04-02 2012-04-30 28    
DECC_201205.csv 664,629,236.01 584 0 1,138,063.76 327,000,000.00 2012-05-01 2012-05-31 30     Jump in TotalAmt. Jump in AvgAmt
DECC_201206.csv 19,111,824.34 212 0 90,150.11 8,810,000.00 2012-06-08 2012-06-28 20     Large drop in TotalAmt. Drop in AvgAmt
DECC_201207.csv 331,368,071.51 452 0 733,115.20 292,000,000.00 2012-07-02 2012-07-31 29     Large jump in TotalAmt. Jump in AvgAmt
DECC_201208.csv 221,205,282.42 586 0 377,483.42 179,000,000.00 2012-08-01 2012-08-31 30    
DECC_201209.csv 248,376,144.20 548 0 453,241.14 205,000,000.00 2012-09-04 2012-09-28 24    
DECC_201210.csv 361,188,972.27 611 0 591,143.98 304,000,000.00 2012-10-01 2012-10-31 30    
DECC_201211.xlsx 305,521,852.56 706 0 432,750.50 249,000,000.00 2012-11-01 2012-11-30 29    
DECC_201212.xlsx 295,020,547.15 647 0 455,982.30 199,540,000.00 2012-12-03 2012-12-31 28    
DECC_201301.xls 314,004,355.29 614 0 511,407.74 236,000,000.00 2013-01-02 2013-01-31 29    
DECC_201302.xlsx 362,473,490.09 622 0 582,754.81 311,000,000.00 2013-02-01 2013-02-27 26    
DECC_201303.xlsx 410,376,778.49 1182 0 347,188.48 171,460,000.00 2013-03-01 2013-03-28 27    
DECC_201304.csv 355,666,362.97 878 0 405,086.97 287,000,000.00 2013-04-02 2013-04-30 28    
DECC_201305.xlsx 375,763,830.41 606 0 620,072.33 325,000,000.00 2013-05-01 2013-05-31 30    
DECC_201306.xlsx 303,477,924.75 629 0 482,476.83 259,000,000.00 2013-06-03 2013-06-27 24    
DECC_201307.xlsx 372,354,384.06 757 0 491,881.62 320,000,000.00 2013-07-01 2013-07-31 30    
DECC_201308.xlsx 268,917,936.16 767 0 350,610.09 208,000,000.00 2013-08-01 2013-08-30 29    
DECC_201309.xlsx 311,882,135.37 707 0 441,134.56 271,000,000.00 2013-09-02 2013-09-30 28    
DECC_201310.xlsx 322,523,625.92 933 0 345,684.49 272,000,000.00 2013-10-01 2013-10-31 30    
DECC_201311.xlsx 235,671,029.45 721 0 326,866.89 193,000,000.00 2013-11-01 2013-11-28 27    
DECC_201312.xlsx 345,402,830.70 854 0 404,452.96 294,000,000.00 2013-12-02 2013-12-30 28    
DECC_201401.xls 393,505,195.37 808 0 487,011.38 332,000,000.00 2014-01-02 2014-01-31 29    
DECC_201402.xlsx 341,240,867.57 831 0 410,638.83 278,000,000.00 2014-02-03 2014-02-28 25    
DECC_201403.xlsx 360,186,951.47 1246 0 289,074.60 249,737,000.00 2014-03-03 2014-03-31 28    
DECC_201404.xlsx 414,379,143.51 842 0 492,136.75 300,000,000.00 2014-04-01 2014-04-29 28    
DECC_201405.xlsx 431,501,760.39 708 0 609,465.76 344,000,000.00 2014-05-01 2014-05-29 28    
DECC_201406.xlsx 320,750,768.28 697 0 460,187.62 260,000,000.00 2014-06-02 2014-06-30 28    
DECC_201407.xlsx 370,728,777.54 897 0 413,298.53 300,000,000.00 2014-07-01 2014-07-31 30    
DECC_201408.xlsx 301,004,422.05 653 0 460,956.24 253,000,000.00 2014-08-01 2014-08-29 28    
DECC_201409.xlsx 40,026,606.22 761 0 52,597.38 7,000,000.00 2014-09-01 2014-09-30 29     Large drop in TotalAmt. Drop in AvgAmt
DECC_201410.xlsx 359,288,372.15 867 0 414,404.12 257,000,000.00 2014-10-01 2014-10-31 30     Large jump in TotalAmt. Jump in AvgAmt
DECC_201411.xlsx 316,845,890.02 743 0 426,441.31 169,000,000.00 2014-11-03 2014-11-28 25    
DECC_201412.xlsx 434,610,015.43 766 0 567,376.00 286,000,000.00 2014-12-01 2014-12-31 30    
DECC_201501.xlsx 447,825,661.23 677 0 661,485.47 319,000,000.00 2015-01-02 2015-01-30 28    
DECC_201502.xlsx 396,120,494.07 766 0 517,128.58 266,000,000.00 2015-02-02 2015-02-26 24    
DECC_201503.xlsx 435,416,646.75 928 0 469,198.97 185,300,000.00 2015-03-02 2015-03-31 29    
DECC_201504.xlsx 384,504,533.11 921 0 417,485.92 261,000,000.00 2015-04-01 2015-04-30 29    
DECC_201505.xlsx 407,233,309.75 681 0 597,993.11 324,000,000.00 2015-05-01 2015-05-29 28    
DECC_201506.xlsx 384,086,140.22 799 0 480,708.56 293,000,000.00 2015-06-01 2015-06-30 29    
DECC_201507.xlsx 360,985,070.75 661 0 546,119.62 290,000,000.00 2015-07-01 2015-07-30 29    
DECC_201508.xlsx 327,587,604.82 610 0 537,028.86 246,000,000.00 2015-08-03 2015-08-27 24    
DECC_201509.xlsx 328,470,907.70 612 0 536,717.17 260,000,000.00 2015-09-01 2015-09-30 29    
DECC_201510.xlsx 426,303,566.30 642 0 664,024.25 313,000,000.00 2015-10-01 2015-10-30 29    
DECC_201511.xlsx 455,990,585.60 617 0 739,044.71 312,000,000.00 2015-11-02 2015-11-27 25    
DECC_201512.xlsx 400,600,507.73 685 0 584,818.26 241,000,000.00 2015-12-01 2015-12-30 29    
DECC_201601.xlsx 396,028,971.60 534 0 741,627.29 243,000,000.00 2016-01-04 2016-01-29 25    
DECC_201602.xlsx 371,903,573.56 617 0 602,761.06 257,000,000.00 2016-02-01 2016-02-29 28    
DECC_201603.xlsx 391,252,624.75 806 0 485,425.09 255,000,000.00 2016-03-01 2016-03-31 30    
DECC_201604.xlsx 435,341,566.81 684 0 636,464.28 330,000,000.00 2016-04-01 2016-04-29 28    
DECC_201606.csv 343,066,625.16 577 0 594,569.54 289,000,000.00 2016-06-01 2016-06-30 29    
DECC_201607.csv 348,044,520.47 537 0 648,127.60 284,000,000.00 2016-07-01 2016-07-29 28    

Total amount : £20,983,683,211.09 in 45,043 records from 66 source files (mean= £317,934,594 and 682 recs/mth) (Range=2011/01 - 2016/07)

OrigRecs shows the number of records that were in the original source file.
AggRecs shows the number of records if aggregation has been used - similar transactions (eg for the same supplier in the same month with the same expenditure type etc) have been combined together to give a single record with a total amount and the date set to the first of the month. Typically this results in a 70% reduction in the number of records.
AvgAmt shows the average (mean) transaction value per original record in that file. One might expect this value to be roughly constant across files.
MaxAmt shows the value of the single largest transaction in that file. Note that errors may be reversed out by subsequent contrary transactions.
MinDate shows the earliest transaction date in that file. MaxDate shows the highest transaction date. Diff shows the difference in days.
Comment highlights significant potential anomalies - large increases/decreases in Total Amt or Avg Amt.


Acknowledgement: Spend data provided by this department has been re-used under the Open Government Licence.