Summary of currently loaded LA spend data for : Dorset Council

Lastfile: DorsetCouncil_202103     LA spend page opens in new window
Sourcefile name Total Amount £ OrigRecs AggRecs AvgAmt£ AAZ   MaxAmt £     MinDate MaxDate Dif     Comment
DorsetCouncil_201904.xlsx 14,782,029.54 1493 961 9,900.89 0.0 1,780,400.00   2019-04-01 2019-04-01 0    
DorsetCouncil_201905.xlsx 14,994,399.60 1391 852 10,779.58 0.0 1,780,400.00   2019-05-01 2019-05-01 0    
DorsetCouncil_201906.xlsx 21,357,388.01 1589 935 13,440.77 0.0 3,258,101.59   2019-06-01 2019-06-01 0    
DorsetCouncil_201907.xlsx 16,920,351.43 1824 1080 9,276.51 0.0 1,780,400.00   2019-07-01 2019-07-01 0    
DorsetCouncil_201908.xlsx 13,285,393.30 1650 913 8,051.75 0.0 1,819,650.00   2019-08-01 2019-08-01 0    
DorsetCouncil_201909.xlsx 15,444,787.77 1775 1005 8,701.29 0.0 1,819,700.00   2019-09-01 2019-09-01 0    
DorsetCouncil_201910.xlsx 16,336,054.27 1369 824 11,932.84 0.0 1,793,500.00   2019-10-01 2019-10-01 0    
DorsetCouncil_201911.xlsx 21,170,464.10 1628 1038 13,003.97 0.0 5,158,542.34   2019-11-01 2019-11-01 0    
DorsetCouncil_201912.xlsx 14,075,240.83 1543 995 9,122.00 0.0 1,926,400.00   2019-12-01 2019-12-01 0    
DorsetCouncil_202001.xlsx 16,357,052.97 1670 1027 9,794.64 0.0 1,926,400.00   2020-01-01 2020-01-01 0    
DorsetCouncil_202002.xlsx 14,936,707.83 1687 936 8,854.01 0.0 1,926,400.00   2020-02-01 2020-02-01 0    
DorsetCouncil_202003.xlsx 22,387,547.23 2160 1289 10,364.61 0.0 1,815,044.17   2020-03-01 2020-03-01 0    
DorsetCouncil_202004.xlsx 18,963,958.40 2007 1046 9,448.91 0.0 1,987,300.00   2020-04-01 2020-04-01 0    
DorsetCouncil_202005.xlsx 14,328,062.09 1626 802 8,811.85 0.0 1,987,300.00   2020-05-01 2020-05-01 0    
DorsetCouncil_202006.xlsx 11,090,255.62 1361 764 8,148.61 0.0 1,344,873.59   2020-06-01 2020-06-01 0    
DorsetCouncil_202007.xlsx 24,305,481.60 1579 833 15,392.96 0.0 3,974,600.00   2020-07-01 2020-07-01 0     Jump in Total Amt. Analysis
DorsetCouncil_202008.xlsx 11,355,371.99 1362 748 8,337.28 0.0 945,975.85   2020-08-01 2020-08-01 0    
DorsetCouncil_202009.xlsx 15,307,642.26 1376 743 11,124.74 0.0 3,974,600.00   2020-09-01 2020-09-01 0    
DorsetCouncil_202010.xlsx 14,898,035.93 1272 774 11,712.29 0.0 1,987,300.00   2020-10-01 2020-10-01 0    
DorsetCouncil_202011.xlsx 21,857,820.40 1990 1067 10,983.83 0.0 1,987,300.00   2020-11-01 2020-11-01 0    
DorsetCouncil_202012.xlsx 13,326,203.21 1274 803 10,460.13 0.0 1,987,300.00   2020-12-01 2020-12-01 0    
DorsetCouncil_202101.xlsx 19,554,572.68 1719 947 11,375.55 0.0 1,864,800.00   2021-01-01 2021-01-01 0    
DorsetCouncil_202102.xlsx 17,744,352.59 1614 910 10,994.02 0.0 1,990,000.00   2021-02-01 2021-02-01 0    
DorsetCouncil_202103.xlsx 22,981,770.77 2507 1312 9,167.04 0.0 1,531,200.00   2021-03-01 2021-03-01 0    

Totals: £407,760,944.42 from 39,466 original records (22,604 actual records) in 24 source files. Tot AvgAmt = £249,180.06

Averages: Amount/file: £16,990,039.35    Orig Records/file: 1,644    AvgAmt mean: 10,382.50    AvgAmt Std Dev: 0.00

LA Range: 2019/04 - 2021/10

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 Dorset Council has been re-used under the Open Government Licence.