Summary of currently loaded spend data for: Department for Business, Innovation and Skills

Lastfile: BIS_201607
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
BIS_201101.csv 3,687,289,675.10 2592 0 1,422,565.46 1,060,687,404.00 2011-01-01 2011-01-31 30    
BIS_201102.csv 1,647,550,816.68 2627 0 627,160.57 364,872,565.00 2011-02-01 2011-02-28 27    
BIS_201103.csv 2,657,128,950.88 4099 0 648,238.34 570,698,000.00 2011-03-01 2011-03-31 30    
BIS_201104.csv 5,314,563,653.79 2548 0 2,085,778.51 1,283,977,275.00 2011-04-01 2011-04-28 27     Jump in TotalAmt. Jump in AvgAmt
BIS_201105.csv 1,499,461,231.84 2789 0 537,634.00 577,650,000.00 2011-05-01 2011-05-31 30     Drop in TotalAmt.
BIS_201106.csv 1,977,720,968.29 2535 0 780,166.06 571,200,000.00 2011-06-01 2011-06-30 29    
BIS_201107.csv 837,727,014.43 1301 0 643,910.08 262,467,000.00 2011-07-01 2011-07-29 28    
BIS_201108.csv 1,932,978,498.04 1993 0 969,883.84 677,850,000.00 2011-08-01 2011-08-31 30     Jump in TotalAmt.
BIS_201109.csv 3,292,183,005.38 2069 0 1,591,195.27 858,803,012.00 2011-09-01 2011-09-30 29    
BIS_201110.csv 2,077,266,350.00 2405 0 863,728.21 622,200,000.00 2011-10-03 2011-10-31 28    
BIS_201111.csv 1,756,040,903.28 2824 0 621,827.52 657,850,000.00 2011-11-01 2011-11-30 29    
BIS_201112.csv 3,575,256,907.23 2807 0 1,273,693.23 1,084,483,249.00 2011-12-01 2011-12-30 29     Jump in TotalAmt. Jump in AvgAmt
BIS_201201.csv 979,638,043.83 1871 0 523,590.62 385,101,000.00 2012-01-03 2012-01-31 28     Drop in TotalAmt.
BIS_201202.csv 1,710,576,549.17 3005 0 569,243.44 290,179,000.00 2012-02-01 2012-02-29 28    
BIS_201203.csv 2,909,332,217.54 4235 0 686,973.37 509,578,000.00 2012-03-01 2012-03-30 29    
BIS_201204.csv 5,338,699,815.41 2682 0 1,990,566.67 1,428,768,923.00 2012-04-02 2012-04-30 28     Jump in AvgAmt
BIS_201205.csv 1,482,946,803.78 3756 0 394,820.77 522,477,000.00 2012-05-01 2012-05-31 30     Drop in TotalAmt. Drop in AvgAmt
BIS_201206.csv 2,097,518,468.73 3308 0 634,074.51 529,500,000.00 2012-06-01 2012-06-29 28    
BIS_201207.csv 1,881,840,231.20 3463 0 543,413.29 540,000,000.00 2012-07-02 2012-07-31 29    
BIS_201208.csv 13,248,490,239.77 2565 0 5,165,103.41 10,500,000,000.00 2012-08-01 2012-08-31 30     Large jump in TotalAmt. Jump in AvgAmt
BIS_201209.csv 3,584,067,621.32 2379 0 1,506,543.77 819,465,000.00 2012-09-03 2012-09-28 25     Drop in TotalAmt.
BIS_201210.csv 2,885,032,434.70 2795 0 1,032,211.96 1,094,313,346.00 2012-10-01 2012-10-30 29    
BIS_201211.csv 1,353,879,382.61 3031 0 446,677.46 677,000,000.00 2012-11-01 2012-11-30 29    
BIS_201212.csv 3,498,200,817.50 2705 0 1,293,235.05 1,110,080,000.00 2012-12-03 2012-12-31 28     Jump in TotalAmt. Jump in AvgAmt
BIS_201301.csv 3,343,366,670.73 2602 0 1,284,921.86 1,109,547,556.00 2013-01-02 2013-01-31 29    
BIS_201302.csv 1,130,962,319.19 2654 0 426,135.01 327,801,000.00 2013-02-01 2013-02-28 27     Drop in TotalAmt.
BIS_201303.csv 5,582,668,013.87 3543 0 1,575,689.53 3,763,000,000.00 2013-03-01 2013-03-28 27     Large jump in TotalAmt. Jump in AvgAmt
BIS_201304.csv 5,853,893,541.63 2744 0 2,133,343.13 1,325,757,279.00 2013-04-02 2013-04-30 28    
BIS_201305.csv 1,398,180,647.31 2219 0 630,094.93 438,080,000.00 2013-05-01 2013-05-31 30     Drop in TotalAmt.
BIS_201306.csv 1,506,584,091.72 2295 0 656,463.66 461,730,000.00 2013-06-03 2013-06-28 25    
BIS_201307.csv 1,200,794,967.55 2652 0 452,788.45 455,991,000.00 2013-07-01 2013-07-31 30    
BIS_201308.csv 2,002,565,062.02 2149 0 931,859.03 775,223,000.00 2013-08-01 2013-08-30 29     Jump in AvgAmt
BIS_201309.csv 2,890,126,410.08 2262 0 1,277,686.30 634,151,603.00 2013-09-02 2013-09-27 25    
BIS_201310.csv 2,515,811,822.47 1843 0 1,365,063.39 1,702,722,378.98 2013-10-11 2013-10-31 20    
BIS_201311.csv 4,515,365,820.27 3928 0 1,149,533.05 1,167,840,427.00 2013-11-01 2013-11-29 28    
BIS_201312.csv 3,733,323,427.90 3720 0 1,003,581.57 699,946,044.00 2013-12-02 2013-12-31 29    
BIS_201401.csv 3,457,987,188.02 3713 0 931,318.93 1,209,719,264.00 2014-01-02 2014-01-31 29    
BIS_201402.csv 993,782,344.23 3566 0 278,682.65 303,953,000.00 2014-02-03 2014-02-28 25     Drop in TotalAmt.
BIS_201403.csv 3,002,729,661.85 4619 0 650,082.20 1,248,254,592.28 2014-03-03 2014-03-31 28     Jump in TotalAmt. Jump in AvgAmt
BIS_201404.csv 6,767,765,792.89 3643 0 1,857,745.21 1,959,805,975.00 2014-04-01 2014-04-30 29     Jump in TotalAmt. Jump in AvgAmt
BIS_201405.csv 1,300,679,044.71 3169 0 410,438.32 395,135,000.00 2014-05-01 2014-05-30 29     Large drop in TotalAmt.
BIS_201406.csv 1,376,939,614.43 3435 0 400,855.78 378,693,086.00 2014-06-02 2014-06-30 28    
BIS_201407.csv 1,441,464,338.86 3675 0 392,235.19 316,524,000.00 2014-07-01 2014-07-31 30    
BIS_201408.csv 2,318,137,374.38 2863 0 809,688.22 646,686,272.00 2014-08-01 2014-08-29 28     Jump in AvgAmt
BIS_201409.csv 4,808,434,515.93 3077 0 1,562,702.15 1,104,708,847.00 2014-09-01 2014-09-30 29     Jump in TotalAmt.
BIS_201410.csv 2,218,193,271.96 3747 0 591,991.80 355,111,000.00 2014-10-01 2014-10-31 30    
BIS_201411.csv 1,980,541,835.10 3417 0 579,614.23 422,118,004.00 2014-11-03 2014-11-28 25    
BIS_201412.csv 3,996,941,158.30 3844 0 1,039,786.98 671,184,335.00 2014-12-01 2014-12-31 30     Jump in TotalAmt.
BIS_201501.csv 3,846,181,943.25 3138 0 1,225,679.40 1,194,305,977.00 2015-01-02 2015-01-30 28    
BIS_201502.csv 1,582,303,008.08 3630 0 435,896.15 327,899,000.00 2015-02-02 2015-02-27 25    
BIS_201503.csv 2,944,984,591.44 5650 0 521,236.21 563,690,093.13 2015-03-02 2015-03-31 29    
BIS_201504.csv 7,417,360,809.88 4084 0 1,816,200.00 3,469,485,600.00 2015-01-04 2015-10-04 273     Jump in TotalAmt. Jump in AvgAmt
BIS_201505.csv 1,483,492,539.52 3242 0 457,585.61 344,201,805.00 2015-01-05 2015-12-05 334     Drop in TotalAmt.
BIS_201506.csv 1,859,292,327.42 3617 0 514,042.67 296,157,000.00 2015-06-01 2015-06-30 29    
BIS_201507.csv 1,836,347,707.33 3923 0 468,097.81 278,673,300.00 2015-07-01 2015-07-31 30    
BIS_201508.csv 2,671,500,379.36 3046 0 877,052.00 678,686,115.00 2015-08-03 2015-08-28 25    
BIS_201509.csv 3,745,520,246.82 2962 0 1,264,524.05 485,789,876.00 2015-09-01 2015-09-30 29    
BIS_201510.csv 3,596,367,334.68 3413 0 1,053,726.15 1,339,134,735.00 2015-10-01 2015-10-30 29    
BIS_201511.csv 1,916,058,789.27 3371 0 568,394.78 421,038,589.00 2015-11-02 2015-11-30 28    
BIS_201512.csv 3,742,605,292.68 3556 0 1,052,476.18 1,211,112,857.00 2015-12-01 2015-12-31 30    
BIS_201601.csv 5,249,539,483.51 2500 0 2,099,815.79 2,006,767,476.00 2016-01-04 2016-01-29 25    
BIS_201602.csv 1,480,999,768.42 3283 0 451,111.72 166,462,500.00 2016-02-01 2016-02-29 28     Drop in TotalAmt.
BIS_201603.csv 3,419,294,916.19 5383 0 635,202.47 329,970,261.80 2016-03-01 2016-03-31 30     Jump in TotalAmt.
BIS_201604.csv 7,687,526,891.83 3006 0 2,557,394.18 3,932,027,259.00 2016-04-01 2016-04-29 28     Jump in TotalAmt. Jump in AvgAmt
BIS_201605.csv 1,869,955,538.30 3245 0 576,257.48 307,388,000.00 2016-05-03 2016-05-31 28     Drop in TotalAmt.
BIS_201606.csv 2,257,581,393.28 3066 0 736,327.92 295,000,000.00 2016-06-01 2016-06-30 29    
BIS_201607.csv 1,286,583,933.39 3149 0 408,569.05 223,558,000.00 2016-07-01 2016-07-29 28    

Total amount : £200,456,126,430.55 in 209,027 records from 67 source files (mean= £2,991,882,484 and 3,119 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.