Summary of currently loaded spend data for: Department for Exiting the European Union

Lastfile: DExEU_201911
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
DExEU_201607-201703.csv 2,169,667.00 2 0 1,084,833.50 1,646,400.00 2017-02-05 2017-02-06 1    
DExEU_201704-201710.csv 3,272,999.93 15 0 218,200.00 748,540.00 2017-04-04 2017-10-18 197    
DExEU_201711-201802.csv 7,312,326.63 17 0 430,136.86 3,357,900.00 2017-11-06 2018-02-28 114     Jump in TotalAmt.
DExEU_201803.csv 1,697,500.52 8 0 212,187.57 1,287,000.00 2018-03-01 2018-03-29 28     Drop in TotalAmt.
DExEU_201804.csv 1,339,293.83 6 0 223,215.64 960,000.00 2018-04-04 2018-04-20 16    
DExEU_201805.csv 1,372,677.84 3 0 457,559.28 1,191,250.00 2018-05-04 2018-05-23 19     Jump in AvgAmt
DExEU_201806.csv 747,372.29 3 0 249,124.10 667,500.00 2018-06-07 2018-06-22 15    
DExEU_201807.csv 2,478,534.67 8 0 309,816.83 853,550.78 2018-07-02 2018-07-26 24     Jump in TotalAmt.
DExEU_201808.csv 1,972,760.02 7 0 281,822.86 1,087,716.50 2018-08-01 2018-08-15 14    
DExEU_201809.csv 1,996,272.13 8 0 249,534.02 1,191,250.00 2018-09-03 2018-09-26 23    
DExEU_201810.csv 2,025,266.97 4 0 506,316.74 1,191,250.00 2018-10-02 2018-10-26 24     Jump in AvgAmt
DExEU_201811.csv 1,071,113.03 3 0 357,037.68 936,963.14 2018-11-02 2018-11-12 10    
DExEU_201812.csv 190,908.60 4 0 47,727.15 77,500.00 2018-12-06 2018-12-21 15     Large drop in TotalAmt. Drop in AvgAmt
DExEU_201901.csv 2,347,687.36 7 0 335,383.91 1,191,250.00 2019-01-03 2019-01-31 28     Large jump in TotalAmt. Jump in AvgAmt
DExEU_201902.csv 5,198,716.58 8 0 649,839.57 1,430,000.00 2019-02-05 2019-02-27 22     Jump in TotalAmt.
DExEU_201903.csv 419,959.96 3 0 139,986.65 241,033.96 2019-03-01 2019-03-28 27     Large drop in TotalAmt.
DExEU_201904.csv 619,772.10 4 0 154,943.02 446,307.66 2019-04-04 2019-04-30 26    
DExEU_201905.csv 175,884.43 3 0 58,628.14 80,460.00 2019-05-14 2019-05-28 14     Drop in TotalAmt.
DExEU_201906.csv 122,733.80 3 0 40,911.27 45,675.28 2019-06-10 2019-06-24 14    
DExEU_201907.csv 2,385,866.70 3 0 795,288.90 1,507,034.40 2019-07-01 2019-07-25 24     Large jump in TotalAmt. Jump in AvgAmt
DExEU_201908.csv 78,674.00 2 0 39,337.00 52,992.00 2019-08-07 2019-08-14 7     Large drop in TotalAmt. Drop in AvgAmt
DExEU_201909.csv 2,938,679.26 3 0 979,559.75 1,507,034.40 2019-09-04 2019-09-19 15     Large jump in TotalAmt. Jump in AvgAmt
DExEU_201910.xls 2,791,710.76 5 0 558,342.15 1,507,034.40 2019-10-04 2019-10-31 27    
DExEU_201911.xls 607,476.62 5 0 121,495.32 395,189.46 2019-11-07 2019-11-25 18     Drop in TotalAmt.

Total amount : £45,333,855.03 in 134 records from 24 source files (mean= £1,888,911 and 5 recs/mth) (Range=2016/07 - 2019/11)

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.