Summary of currently loaded LA spend data for : Bracknell Forest

Lastfile: BracknellForest_202007-11     LA spend page opens in new window
Sourcefile name Total Amount £ OrigRecs AggRecs AvgAmt£ AAZ   MaxAmt £     MinDate MaxDate Dif     Comment
BracknellForest_201501.csv 8,525,816.43 3189 0 2,673.51 0.0 460,609.70   2011-11-15 2015-02-23 39    
BracknellForest_201502-05.csv 11,862,215.07 10783 0 1,100.08 0.0 587,278.00   2013-12-12 2015-06-03 18    
BracknellForest_201506-09.csv 36,698,714.52 13823 0 2,654.90 0.0 924,963.08   2013-07-30 2016-02-25 31     Large jump in Total Amt. Analysis
BracknellForest_201510-12.csv 38,200,642.49 12652 0 3,019.34 0.0 1,479,429.70   2014-02-04 2016-03-18 25    
BracknellForest_201601-03.csv 33,242,481.17 12118 0 2,743.23 0.0 1,080,616.67   2014-08-18 2016-04-30 20    
BracknellForest_201604-06.csv 30,965,547.07 9060 0 3,417.83 0.0 1,648,588.15   2014-02-24 2017-03-30 37    
BracknellForest_201607-09.csv 29,910,269.93 10136 0 2,950.89 0.0 1,090,358.75   2013-08-31 2017-03-05 43    
BracknellForest_201610-12.csv 38,125,029.09 10321 0 3,693.93 0.0 1,282,500.00   2012-11-03 2017-03-12 52    
BracknellForest_201701-03.csv 29,396,612.23 11380 0 2,583.18 0.0 738,098.50   2016-01-27 2017-04-11 15    
BracknellForest_201704-06.csv 24,847,636.65 8497 0 2,924.28 0.0 956,147.51   2014-09-18 2017-08-01 35    
BracknellForest_201707-12.csv 30,428,913.43 11888 3607 2,559.63 0.0 894,777.17   2015-03-01 2018-03-01 36    
BracknellForest_201801-03.csv 35,228,378.97 11950 4002 2,947.98 0.0 1,402,807.48   2014-03-01 2018-12-01 57    
BracknellForest_201804-05.csv 17,528,278.10 6060 1956 2,892.46 0.0 1,386,742.75   2015-11-01 2018-07-01 32    
BracknellForest_201806-07.csv 18,030,080.96 6940 2224 2,597.99 0.0 1,290,123.45   2015-12-01 2019-03-01 39    
BracknellForest_201808-11.csv 42,718,596.18 12454 4067 3,430.11 0.0 2,951,540.79   2016-10-01 2019-03-01 29     Jump in Total Amt. Analysis
BracknellForest_201812-201903.csv 44,862,023.85 12418 4287 3,612.66 0.0 2,471,607.61   2017-01-01 2019-12-01 35    
BracknellForest_201904-05.csv 28,437,299.07 5690 2051 4,997.77 0.0 5,030,205.48   2018-03-01 2020-03-01 24    
BracknellForest_201906-09.csv 42,463,718.64 8888 3565 4,777.65 0.0 1,868,921.30   2003-04-01 2020-03-01 203    
BracknellForest_201910-11.csv 20,029,789.57 6533 2166 3,065.94 0.0 1,124,802.21   2017-08-01 2019-12-01 28    
BracknellForest_201912-202003.csv 46,533,858.67 8604 3992 5,408.40 0.0 1,645,568.00   2015-06-01 2020-12-01 66     Jump in Total Amt. Analysis
BracknellForest_202004-06.csv 43,074,600.44 6143 2552 7,011.98 0.0 7,440,000.00   2017-08-01 2020-07-01 35    
BracknellForest_202007-11.csv 59,733,846.94 12471 4500 4,789.82 0.0 5,452,617.44   2016-07-01 2021-03-01 56    

Totals: £710,844,349.47 from 211,998 original records (140,928 actual records) in 22 source files. Tot AvgAmt = £75,853.57

Averages: Amount/file: £32,311,106.79    Orig Records/file: 9,636    AvgAmt mean: 3,447.89    AvgAmt Std Dev: 0.00

LA Range: 2015/01 - 2021/12

The link on Sourcefile name will transfer to a new page to display all the records for that file.
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.
AAZ shows the number of standard deviations from the mean for the AvgAmt. Greater than ± 1.1 could suggest an unusual value. Now deprecated.
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. Dif shows the difference in months.
Comment highlights significant potential anomalies - large increases/decreases in Total Amt or high AAZ scores.
Analysis compares two files to identify possible factors relating to the anomaly. Opens in new window. NB under development.

Spend details and charts


Acknowledgement: Spend data from Bracknell Forest has been re-used under the Open Government Licence.