Spreadsheet: 114487d1310194859-using-advanced-filter-to-calculate-a-3-year-and-5-year-history-book1-1-
Sheet: report

Location | Financial Year | Total Payments
1 | 2007 | 0
2 | 2007 | 30886.75
3 | 2007 | 158.44
4 | 2007 | 136036.7
1 | 2007 | 166965.08
2 | 2007 | 12523.22
3 | 2007 | 0
4 | 2007 | 0
1 | 2007 | 0
2 | 2007 | 0
3 | 2007 | 0
4 | 2007 | 0
1 | 2007 | 0
2 | 2007 | 0
3 | 2007 | 0
4 | 2007 | 0
1 | 2007 | 0
2 | 2007 | 0
3 | 2007 | 0
4 | 2007 | 2158.02
1 | 2007 | 69
2 | 2007 | 0
3 | 2007 | 737.74
4 | 2007 | 251.85
1 | 2007 | 175
2 | 2007 | 655.76
3 | 2007 | 4750.39
4 | 2007 | 399.21
1 | 2007 | 888.65
2 | 2007 | 4114.98
3 | 2007 | 1458.59
4 | 2007 | 83
1 | 2007 | 379
2 | 2007 | 0
3 | 2007 | 0
4 | 2007 | 0
1 | 2007 | 0
2 | 2007 | 121
3 | 2007 | 0
4 | 2007 | 1703.24
1 | 2007 | 6876.55
2 | 2007 | 8684.09
3 | 2007 | 906
4 | 2007 | 91
1 | 2007 | 0
2 | 2007 | 121
3 | 2007 | 0
4 | 2007 | 69
1 | 2007 | 207
2 | 2007 | 227
3 | 2007 | 1160.38
4 | 2007 | 227
1 | 2007 | 411
2 | 2007 | 0
3 | 2007 | 141
4 | 2007 | 10519.47
1 | 2007 | 0
2 | 2007 | 116
3 | 2007 | 0
4 | 2007 | 0
1 | 2007 | 918.66
2 | 2007 | 525.76
3 | 2007 | 169
4 | 2007 | 333.8
1 | 2007 | 12666.27
2 | 2007 | 314
3 | 2007 | 0
4 | 2007 | 0
1 | 2007 | 0
2 | 2007 | 3072.79
3 | 2007 | 0
4 | 2007 | 2575.1
1 | 2007 | 8551.8
2 | 2007 | 237.42
3 | 2007 | 158.5
4 | 2007 | 0
1 | 2007 | 0
2 | 2007 | 69
3 | 2007 | 0
4 | 2007 | 993.74
3 | 2007 | 213
4 | 2007 | 443
2 | 2007 | 0
3 | 2007 | 240
4 | 2007 | 3583.24
1 | 2007 | 0
2 | 2007 | 0
3 | 2007 | 333.15
4 | 2007 | 237.42
1 | 2007 | 0
2 | 2007 | 58
3 | 2008 | 0
4 | 2008 | 149.47
1 | 2008 | 169
2 | 2008 | 395
3 | 2008 | 496
4 | 2008 | 1626.69
1 | 2008 | 4044.41
2 | 2008 | 1163.57
3 | 2008 | 3482.36
4 | 2008 | 38.59
1 | 2008 | 799.41
2 | 2008 | 0
3 | 2008 | 58
4 | 2008 | 71
1 | 2008 | 0
2 | 2008 | 0
3 | 2008 | 22000.46
4 | 2008 | 582.99
1 | 2008 | 94
2 | 2008 | 1068.32
3 | 2008 | 156
4 | 2008 | 99000
1 | 2008 | 1607.07
2 | 2008 | 0
3 | 2008 | 0
4 | 2008 | 9897.83
3 | 2008 | 0
4 | 2008 | 0
1 | 2008 | 0
2 | 2008 | 0
3 | 2008 | 0
4 | 2008 | 0
1 | 2008 | 0
2 | 2008 | 0
3 | 2008 | 0
4 | 2008 | 0
1 | 2008 | 4112.86
2 | 2008 | 1609
3 | 2008 | 1396.1
4 | 2008 | 0
1 | 2008 | 699.19
2 | 2008 | 839.46
3 | 2008 | 0
4 | 2008 | 587.69
1 | 2008 | 251
2 | 2008 | 0
3 | 2008 | 0
4 | 2008 | 496
1 | 2008 | 0
2 | 2008 | 7086.54
3 | 2008 | 638.75
4 | 2008 | 0
1 | 2008 | 2037.11
2 | 2008 | 94
3 | 2008 | 538
4 | 2008 | 1372.98
1 | 2008 | 390
2 | 2008 | 10679.58
3 | 2008 | 58
4 | 2008 | 0
1 | 2008 | 725.49
2 | 2008 | 2431.2
3 | 2008 | 783
4 | 2008 | 14082.31
1 | 2008 | 1678.29
2 | 2008 | 2570.49
3 | 2008 | 69
4 | 2008 | 226.3
1 | 2008 | 83
2 | 2008 | 402
3 | 2008 | 94
4 | 2008 | 501
1 | 2008 | 142
2 | 2008 | 86.6
3 | 2008 | 166
4 | 2008 | 13695.88
1 | 2008 | 46710.5
2 | 2008 | 288.95
3 | 2008 | 0
4 | 2008 | 2769.47
1 | 2008 | 467
2 | 2008 | 0
3 | 2008 | 83
4 | 2008 | 192
1 | 2008 | 548
2 | 2008 | 1049.2
3 | 2008 | 323.25
4 | 2008 | 575
1 | 2008 | 0
2 | 2008 | 7296.54
3 | 2008 | 340
4 | 2009 | 0
1 | 2009 | 91024
2 | 2009 | 144.2
3 | 2009 | 1151.51
4 | 2009 | 643.44
1 | 2009 | 436.95
2 | 2009 | 435.5
3 | 2009 | 0
4 | 2009 | 12515.68
1 | 2009 | 950.91
2 | 2009 | 340
3 | 2009 | 1665.78
4 | 2009 | 3287.77
1 | 2009 | 0
2 | 2009 | 2097.09
3 | 2009 | 0
4 | 2009 | 248
3 | 2009 | 220
4 | 2009 | 500.89
2 | 2009 | 550.93
3 | 2009 | 806.4
4 | 2009 | 6982.35
1 | 2009 | 194
2 | 2009 | 358
3 | 2009 | 1304
4 | 2009 | 207.58
1 | 2009 | 263
2 | 2009 | 38747.42
3 | 2009 | 483.46
4 | 2009 | 173.95
1 | 2009 | 272.95
2 | 2009 | 2823.48
3 | 2009 | 22570.37
4 | 2009 | 37500
1 | 2009 | 1
2 | 2009 | 0
3 | 2009 | 0
4 | 2009 | 8411.7
1 | 2009 | 207
2 | 2009 | 594.93
3 | 2009 | 0
4 | 2009 | 21510.72
1 | 2009 | 311
2 | 2009 | 1272.04
3 | 2009 | 1096
4 | 2009 | 24730.83
1 | 2009 | 25323.07
2 | 2009 | 0
3 | 2009 | 1337.42
4 | 2009 | 641.95
1 | 2009 | 510
2 | 2009 | 1215.75
3 | 2009 | 495
4 | 2009 | 3390.55
3 | 2009 | 0
4 | 2009 | 0
1 | 2009 | 124
2 | 2009 | 811.95
3 | 2009 | 0
4 | 2009 | 622.44
1 | 2009 | 209.8
2 | 2009 | 351.9
3 | 2009 | 395
4 | 2009 | 853.1
1 | 2009 | 0
2 | 2009 | 198
3 | 2009 | 74
4 | 2009 | 148
1 | 2009 | 11746.61
2 | 2009 | 1461.01
3 | 2009 | 7133.48
4 | 2009 | 237
1 | 2009 | 0
2 | 2009 | 0
3 | 2009 | 0
4 | 2009 | 0
1 | 2009 | 0
2 | 2009 | 9502.45
3 | 2009 | 38233.85
4 | 2009 | 1890.09
1 | 2009 | 233
2 | 2009 | 1167.28
3 | 2010 | 241.03
4 | 2010 | 18343.07
1 | 2010 | 137
2 | 2010 | 1281.07
3 | 2010 | 88
4 | 2010 | 146647.14
1 | 2010 | 235.53
2 | 2010 | 126
3 | 2010 | 291.71
4 | 2010 | 480.71
1 | 2010 | 2704.42
2 | 2010 | 0
3 | 2010 | 0
4 | 2010 | 131
1 | 2010 | 0
2 | 2010 | 1147.41
3 | 2010 | 15053.94
4 | 2010 | 577.08
1 | 2010 | 0
2 | 2010 | 2089.11
3 | 2010 | 0
4 | 2010 | 126
1 | 2010 | 713.35
2 | 2010 | 4985.98
3 | 2010 | 123.17
4 | 2010 | 0
1 | 2010 | 123.17
2 | 2010 | 715.35
3 | 2010 | 1816.54
4 | 2010 | 2762.08
1 | 2010 | 303
2 | 2010 | 17420.07
3 | 2010 | 99
4 | 2010 | 2329.3
1 | 2010 | 382.46
2 | 2010 | 179.35
3 | 2010 | 137
4 | 2010 | 235.53
1 | 2010 | 13973.33
2 | 2010 | 0
3 | 2010 | 0
4 | 2010 | 1452.99
1 | 2010 | 196
2 | 2010 | 4017.3
3 | 2010 | 0
4 | 2010 | 638.54
1 | 2010 | 273
2 | 2010 | 130
3 | 2010 | 0
4 | 2010 | 93.75
1 | 2010 | 564.07
2 | 2010 | 239
3 | 2010 | 389
4 | 2010 | 190
3 | 2010 | 0
4 | 2010 | 282.33
2 | 2010 | 0
3 | 2010 | 0
4 | 2010 | 125
1 | 2010 | 628.79
2 | 2010 | 2863.93
3 | 2010 | 997.35
4 | 2010 | 260
1 | 2010 | 240
2 | 2010 | 0
3 | 2010 | 1593.6
4 | 2010 | 852
1 | 2010 | 73967.32
2 | 2010 | 256
3 | 2010 | 0
4 | 2010 | 1054.79
1 | 2010 | 236
2 | 2010 | 66.99
3 | 2010 | 374.23
4 | 2010 | 909.44
1 | 2010 | 473.95
2 | 2010 | 903.22
3 | 2010 | 1236.15
4 | 2010 | 387.35
1 | 2010 | 271.5
2 | 2010 | 365.71
3 | 2010 | 846.35
4 | 2010 | 261.43
1 | 2010 | 0
2 | 2010 | 74
3 | 2010 | 373
4 | 2010 | 325.35
1 | 2010 | 7872.89
2 | 2010 | 0
3 | 2010 | 0
4 | 2010 | 2848.18
3 | 2010 | 1850
4 | 2010 | 660.59
3 | 2010 | 41418.39
4 | 2010 | 21434.11
1 | 2010 | 32832.69
2 | 2010 | 10863.79
3 | 2010 | 20956.13
4 | 2011 | 0
1 | 2011 | 213.71
2 | 2011 | 0
3 | 2011 | 796.96
4 | 2011 | 4205.55
1 | 2011 | 1043
2 | 2011 | 1965.43
3 | 2011 | 0
4 | 2011 | 3979.04
1 | 2011 | 0
2 | 2011 | 0
3 | 2011 | 0
4 | 2011 | 544.3
1 | 2011 | 230
2 | 2011 | 99
3 | 2011 | 0
4 | 2011 | 7524.13
1 | 2011 | 5241.4
2 | 2011 | 160
3 | 2011 | 0
4 | 2011 | 420.78
1 | 2011 | 0
2 | 2011 | 198
3 | 2011 | 761.95
4 | 2011 | 259
1 | 2011 | 252
2 | 2011 | 685
3 | 2011 | 420.91
4 | 2011 | 192
3 | 2011 | 143
4 | 2011 | 1717
2 | 2011 | 71
3 | 2011 | 0
4 | 2011 | 259
1 | 2011 | 0
2 | 2011 | 0
3 | 2011 | 0
4 | 2011 | 0
1 | 2011 | 0
2 | 2011 | 798
3 | 2011 | 596.73
4 | 2011 | 7648.75
1 | 2011 | 7658.05
2 | 2011 | 151
3 | 2011 | 14169.53
4 | 2011 | 70
1 | 2011 | 988.8
2 | 2011 | 1446.96
3 | 2011 | 0
4 | 2011 | 210
1 | 2011 | 0
2 | 2011 | 7364.05
3 | 2011 | 4872.5
4 | 2011 | 341
1 | 2011 | 267
2 | 2011 | 1584.49
3 | 2011 | 0
4 | 2011 | 773.73
1 | 2011 | 209
2 | 2011 | 142
3 | 2011 | 151
4 | 2011 | 12386.94
1 | 2011 | 692.1
2 | 2011 | 325
3 | 2011 | 2010.65
4 | 2011 | 533
3 | 2011 | 7435.65
4 | 2011 | 140