Spreadsheet: 31221d1227021117-summary-sheet-problem-2009-pipeline-test
Sheet: 2009 Pipeline

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month start date | 2008-12-27 00:00:00 | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-04-04 00:00:00 | 2009-05-02 00:00:00 | 2009-05-30 00:00:00 | 2009-07-04 00:00:00 | 2009-08-01 00:00:00 | 2009-08-29 00:00:00 | 2009-10-03 00:00:00 | 2009-10-31 00:00:00 | 2009-11-28 00:00:00
OPPORTUNITIES 2009 | Current Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month end Date | 2009-01-30 00:00:00 | 2009-02-27 00:00:00 | 2009-04-03 00:00:00 | 2009-05-01 00:00:00 | 2009-05-29 00:00:00 | 2009-07-03 00:00:00 | 2009-07-31 00:00:00 | 2009-08-28 00:00:00 | 2009-10-02 00:00:00 | 2009-10-30 00:00:00 | 2009-11-27 00:00:00 | 2009-12-25 00:00:00
2008-11-18 00:00:00 | Nov |  |  |  |  |  |  | 25000 | 31900 |  |  |  |  |  |  |  |  | F'cast Rev | F'cast Rev | F'cast Rev | F'cast Rev | F'cast Rev | F'cast Rev | F'cast Rev | F'cast Rev | F'cast Rev | F'cast Rev | F'cast Rev | F'cast Rev | F'cast Rev | F'cast Rev
Customer | Event | National Account | Start Date | End Date | Agreement Duration Days | Event Start Month | QTR | Est. Revenue | Est Revenue Euro | Status | Rank | Tier | Area | Contact | Quoted | Won/Lost | Comments | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2009 YTD | 2008 FYF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Area |  | Potenetial |  | Quoted | Won/Lost |  | National Account
 |  | Yes | 2009-05-14 00:00:00 | 2009-05-17 00:00:00 | 4 | May | 2 | 50000 | 63800 | 0.75 | 9 | Tier 3 | Ireland |  |  |  |  | 0 | 0 | 0 | 0 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Central |  | 0.25 |  | Yes | Won |  | Yes
 |  | Yes | 2009-05-21 00:00:00 | 2009-05-24 00:00:00 | 4 | May | 2 | 30000 | 38280 | 0.75 | 21 | [NAME] | South East |  |  |  |  | 0 | 0 | 0 | 0 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30000
 |  | Yes | 2009-07-08 00:00:00 | 2009-07-11 00:00:00 | 4 | Jul | 3 | 18000 | 22968 | 0.75 | 35 | Tier 1 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 18000 | 0 | 0 | 0 | 0 | 0 | 0 | 18000
 |  | Yes | 2009-07-02 00:00:00 | 2009-07-06 00:00:00 | 5 | Jul | 3 | 40000 | 51040 | 0.75 | 18 | [NAME] |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 16000 | 24000 | 0 | 0 | 0 | 0 | 0 | 0 | 40000
 |  | Yes | 2009-07-23 00:00:00 | 2009-07-26 00:00:00 | 4 | Jul | 3 | 10000 | 12760 | 0.75 | 56 | Tier 1 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 10000
 |  | Yes | 2009-08-13 00:00:00 | 2009-08-16 00:00:00 | 4 | Aug | 3 | 12000 | 15312 | 0.75 | 46 | Tier 1 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12000 | 0 | 0 | 0 | 0 | 0 | 12000
 |  | Yes | 2009-09-17 00:00:00 | 2009-09-20 00:00:00 | 4 | Sep | 3 | 13000 | 16588 | 0.75 | 45 | Tier 1 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13000 | 0 | 0 | 0 | 0 | 13000
 |  | No | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 | 365 | Jan | 1 | 250000 | 319000 | 0.75 | 3 | Tier 3 |  |  |  |  |  | 20547.94520547945 | 19178.08219178082 | 23972.60273972603 | 19178.08219178082 | 19178.08219178082 | 23972.60273972603 | 19178.08219178082 | 19178.08219178082 | 23972.60273972603 | 19178.08219178082 | 19178.08219178082 | 19178.08219178082 | 0 | 245890.4109589041
 |  | No | 2009-07-24 00:00:00 | 2009-07-26 00:00:00 | 3 | Jul | 3 | 180000 | 229680 | 0.75 | 5 | Tier 3 | Central |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 180000 | 0 | 0 | 0 | 0 | 0 | 0 | 180000
 |  | No | 2009-06-24 00:00:00 | 2009-06-28 00:00:00 | 5 | Jun | 2 | 678505 | 865772.38 | 0.75 | 1 | Tier 3 | South West |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 678505 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 678505
 |  | Yes | 2009-07-16 00:00:00 | 2009-07-19 00:00:00 | 4 | Jul | 3 | 535838 | 683729.2880000001 | 0.75 | 2 | Tier 3 | Scotland |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 535838 | 0 | 0 | 0 | 0 | 0 | 0 | 535838
 |  | No | 2009-02-20 00:00:00 | 2009-02-24 00:00:00 | 5 | Feb | 1 | 50000 | 63800 | 0.5 | 9 | Tier 3 | South East |  |  |  |  | 0 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000
 |  | No | 2009-09-18 00:00:00 | 2009-09-22 00:00:00 | 5 | Sep | 3 | 50000 | 63800 | 0.5 | 9 | Tier 3 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000 | 0 | 0 | 0 | 0 | 50000
 |  | No | 2009-10-30 00:00:00 | 2009-10-31 00:00:00 | 2 | Oct | 4 | 50000 | 63800 | 0.5 | 9 | Tier 3 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25000 | 25000 | 0 | 0 | 50000
 |  | No | 2009-10-16 00:00:00 | 2009-10-21 00:00:00 | 6 | Oct | 4 | 50000 | 63800 | 0.5 | 9 | Tier 3 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000 | 0 | 0 | 0 | 50000
 |  | Yes | 2009-07-20 00:00:00 | 2009-08-07 00:00:00 | 19 | Jul | 3 | 35000 | 44660 | 0.25 | 19 | [NAME] | South West |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 22105.26315789474 | 12894.73684210526 | 0 | 0 | 0 | 0 | 0 | 35000
 |  | Yes | 2009-09-29 00:00:00 | 2009-09-30 00:00:00 | 2 | Sep | 3 | 5000 | 6380 | 1 | 63 | Tier 1 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 0 | 0 | 0 | 5000
 |  | Yes | 2009-08-22 00:00:00 | 2009-08-23 00:00:00 | 2 | Aug | 3 | 45000 | 57420 | 0.5 | 15 | [NAME] | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 45000 | 0 | 0 | 0 | 0 | 0 | 45000
 |  | Yes | 2009-07-15 00:00:00 | 2009-07-21 00:00:00 | 7 | Jul | 3 | 15000 | 19140 | 0.75 | 43 | Tier 1 | South West |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 15000 | 0 | 0 | 0 | 0 | 0 | 0 | 15000
 |  | Yes | 2009-05-31 00:00:00 | 2009-06-04 00:00:00 | 5 | May | 2 | 7000 | 8932 | 0.5 | 61 | Tier 1 | South West |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 7000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7000
 |  | Yes | 2009-08-02 00:00:00 | 2009-08-05 00:00:00 | 4 | Aug | 3 | 7500 | 9570 | 0.5 | 59 | Tier 1 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7500 | 0 | 0 | 0 | 0 | 0 | 7500
 |  | Yes | 2009-09-11 00:00:00 | 2009-09-14 00:00:00 | 4 | Sep | 3 | 14000 | 17864 | 0.5 | 44 | Tier 1 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14000 | 0 | 0 | 0 | 0 | 14000
 |  | Yes | 2009-10-05 00:00:00 | 2009-10-09 00:00:00 | 5 | Oct | 4 | 18000 | 22968 | 0.5 | 35 | Tier 1 | Scotland |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18000 | 0 | 0 | 0 | 18000
 |  | Yes | 2009-06-23 00:00:00 | 2009-07-07 00:00:00 | 15 | Jun | 2 | 23000 | 29348 | 0.5 | 30 | [NAME] | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 16866.66666666666 | 6133.333333333333 | 0 | 0 | 0 | 0 | 0 | 0 | 23000
 |  | Yes | 2009-08-25 00:00:00 | 2009-08-30 00:00:00 | 6 | Aug | 3 | 25000 | 31900 | 0.75 | 25 | [NAME] | Central |  |  | won |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16666.66666666666 | 8333.333333333332 | 0 | 0 | 0 | 0 | 25000
 |  | No | 2009-03-20 00:00:00 | 2009-03-25 00:00:00 | 6 | Mar | 1 | 54000 | 68904 | 0.5 | 7 | Tier 3 | South West |  |  |  |  | 0 | 0 | 54000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 54000
 |  | Yes | 2009-10-01 00:00:00 | 2009-11-30 00:00:00 | 61 | Oct | 4 | 240000 | 306240 | 0.75 | 4 | Tier 3 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7868.852459016394 | 110163.9344262295 | 110163.9344262295 | 11803.27868852459 | 0 | 240000
 |  | Yes | 2009-05-15 00:00:00 | 2009-07-20 00:00:00 | 67 | May | 2 | 54000 | 68904 |  | 7 | Tier 3 |  |  |  |  |  | 0 | 0 | 0 | 0 | 12089.55223880597 | 28208.9552238806 | 13701.49253731343 | 0 | 0 | 0 | 0 | 0 | 0 | 54000
 |  | Yes | 2009-06-27 00:00:00 | 2009-07-07 00:00:00 | 11 | Jun | 2 | 25000 | 31900 |  | 25 | [NAME] |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 15909.09090909091 | 9090.909090909092 | 0 | 0 | 0 | 0 | 0 | 0 | 25000
 |  | Yes | 2009-02-28 00:00:00 | 2009-10-30 00:00:00 | 245 | Feb | 1 | 42000 | 53592 |  | 16 | [NAME] |  |  |  |  |  | 0 | 0 | 6000 | 4800 | 4800 | 6000 | 4800 | 4800 | 6000 | 4800 | 0 | 0 | 0 | 42000
 |  | Yes | 2009-06-06 00:00:00 | 2009-06-20 00:00:00 | 15 | Jun | 2 | 7000 | 8932 |  | 61 | Tier 1 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 7000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7000
 |  | Yes | 2009-11-03 00:00:00 | 2010-01-04 00:00:00 | 63 | Nov | 4 | 24446 | 31193.096 | 0.5 | 27 | [NAME] | South West |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9700.79365079365 | 10864.88888888889 | 0 | 20565.68253968254
 |  | Yes | 2009-11-18 00:00:00 | 2010-01-04 00:00:00 | 48 | Nov | 4 | 10204 | 13020.304 | 1 | 54 | Tier 1 | Central |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2125.833333333333 | 5952.333333333334 | 0 | 8078.166666666668
 |  | Yes | 2009-11-18 00:00:00 | 2010-01-04 00:00:00 | 48 | Nov | 4 | 11697 | 14925.372 | 0.5 | 50 | Tier 1 | Scotland |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2436.875 | 6823.25 | 0 | 9260.125
 |  | Yes | 2009-01-05 00:00:00 | 2009-03-08 00:00:00 | 63 | Jan | 1 | 20012 | 25535.312 | 0.5 | 33 | [NAME] | Central |  |  |  |  | 8258.920634920634 | 8894.222222222223 | 2858.857142857143 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20012
 |  | Yes | 2009-11-11 00:00:00 | 2010-01-11 00:00:00 | 62 | Nov | 4 | 15458 | 19724.408 | 0.5 | 42 | Tier 1 | Central |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4238.483870967741 | 6981.032258064516 | 0 | 11219.51612903226
 |  | Yes | 2009-11-17 00:00:00 | 2010-01-04 00:00:00 | 49 | Nov | 4 | 9523 | 12151.348 | 0.5 | 57 | Tier 1 | South West |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2137.816326530612 | 5441.714285714285 | 0 | 7579.530612244897
 |  | Yes | 2009-11-17 00:00:00 | 2010-02-22 00:00:00 | 98 | Nov | 4 | 18685 | 23842.06 | 0.5 | 34 | Tier 1 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2097.295918367347 | 5338.571428571428 | 0 | 7435.867346938776
 |  | Yes | 2009-11-22 00:00:00 | 2010-01-11 00:00:00 | 51 | Nov | 4 | 41547 | 53013.972 | 0.5 | 17 | [NAME] | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4887.882352941177 | 22810.11764705883 | 0 | 27698
 |  | Yes | 2009-11-29 00:00:00 | 2010-01-04 00:00:00 | 37 | Nov | 4 | 22267 | 28412.692 | 0.5 | 31 | [NAME] | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16248.89189189189 | 0 | 16248.89189189189
 |  | Yes | 2009-11-29 00:00:00 | 2010-01-11 00:00:00 | 44 | Nov | 4 | 27272 | 34799.072 | 0.5 | 24 | [NAME] | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16735.09090909091 | 0 | 16735.09090909091
 |  | Yes | 2009-11-22 00:00:00 | 2010-01-04 00:00:00 | 44 | Nov | 4 | 31481 | 40169.756 | 0.5 | 20 | [NAME] | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4292.863636363636 | 20033.36363636364 | 0 | 24326.22727272727
 |  | Yes | 2009-12-17 00:00:00 | 2010-01-04 00:00:00 | 19 | Dec | 4 | 10201 | 13016.476 | 0.5 | 55 | Tier 1 | South West |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4832.052631578948 | 0 | 4832.052631578948
 |  | Yes | 2009-10-29 00:00:00 | 2010-01-09 00:00:00 | 73 | Oct | 4 | 20796 | 26535.696 | 0.5 | 32 | [NAME] | South West |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 569.7534246575342 | 7976.547945205479 | 7976.547945205479 | 0 | 16522.84931506849
 |  | Yes | 2009-11-21 00:00:00 | 2010-01-09 00:00:00 | 50 | Nov | 4 | 10790 | 13768.04 | 0.5 | 52 | Tier 1 | South West |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1510.6 | 6042.400000000001 | 0 | 7553.000000000001
 |  | Yes | 2009-11-26 00:00:00 | 2010-01-09 00:00:00 | 45 | Nov | 4 | 7819 | 9977.044 | 0.5 | 58 | Tier 1 | Central |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 347.5111111111111 | 4865.155555555556 | 0 | 5212.666666666667
 |  | Yes | 2009-10-18 00:00:00 | 2009-10-27 00:00:00 | 10 | Oct | 4 | 4536 | 5787.936 | 0.5 | 64 | Tier 1 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4536 | 0 | 0 | 0 | 4536
 |  | Yes | 2009-12-01 00:00:00 | 2010-01-09 00:00:00 | 40 | Dec | 4 | 15635 | 19950.26 | 0.5 | 41 | Tier 1 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9771.875 | 0 | 9771.875
 |  | Yes | 2009-11-14 00:00:00 | 2010-01-09 00:00:00 | 57 | Nov | 4 | 11394 | 14538.744 | 0.5 | 51 | Tier 1 | Central |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2798.526315789474 | 5597.052631578948 | 0 | 8395.578947368422
 |  | Yes | 2009-12-01 00:00:00 | 2010-01-16 00:00:00 | 47 | Dec | 4 | 10776 | 13750.176 | 0.5 | 53 | Tier 1 | Central |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5731.914893617021 | 0 | 5731.914893617021
 |  | Yes | 2009-12-01 00:00:00 | 2009-12-05 00:00:00 | 5 | Dec | 4 | 3579 | 4566.804 | 0.5 | 65 | Tier 1 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3579 | 0 | 3579
 |  | Yes | 2009-11-25 00:00:00 | 2010-01-06 00:00:00 | 43 | Nov | 4 | 15947 | 20348.372 | 0.5 | 38 | Tier 1 | Central |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1112.581395348837 | 10384.09302325581 | 0 | 11496.67441860465 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scotland |  | 0.5 |  | No | Lost |  | No
 |  | Yes | 2009-11-25 00:00:00 | 2010-01-06 00:00:00 | 43 | Nov | 4 | 15947 | 20348.372 | 0.5 | 38 | Tier 1 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1112.581395348837 | 10384.09302325581 | 0 | 11496.67441860465 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South West |  | 0.75 |  |  | Pending
 |  | Yes | 2009-11-25 00:00:00 | 2010-01-06 00:00:00 | 43 | Nov | 4 | 15947 | 20348.372 | 0.5 | 38 | Tier 1 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1112.581395348837 | 10384.09302325581 | 0 | 11496.67441860465 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South East |  | 0.95
 |  | Yes | 2009-10-31 00:00:00 | 2010-01-06 00:00:00 | 68 | Oct | 4 | 24426 | 31167.576 | 0.5 | 28 | [NAME] | South West |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10057.76470588235 | 10057.76470588235 | 0 | 20115.52941176471 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ireland |  | 1
 |  | Yes | 2009-11-07 00:00:00 | 2010-01-07 00:00:00 | 62 | Nov | 4 | 23384 | 29837.984 | 0.5 | 29 | [NAME] | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7920.387096774193 | 10560.51612903226 | 0 | 18480.90322580645
 |  | Yes | 2009-11-14 00:00:00 | 2010-01-08 00:00:00 | 56 | Nov | 4 | 17206 | 21954.856 | 0.5 | 37 | Tier 1 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4301.5 | 8603 | 0 | 12904.5
 |  | No | 2009-10-10 00:00:00 | 2009-10-20 00:00:00 | 11 | Oct | 4 | 100000 | 127600 | 0.5 | 6 | Tier 3 | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100000 | 0 | 0 | 0 | 100000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scotland |  | 0.5 |  | No | Lost |  | No
 |  | Yes | 2009-11-21 00:00:00 | 2010-01-04 00:00:00 | 45 | Nov | 4 | 12000 | 15312 | 0.5 | 46 | Tier 1 | Ireland |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1866.666666666667 | 7466.666666666667 | 0 | 9333.333333333334
 |  | Yes | 2009-11-24 00:00:00 | 2010-01-04 00:00:00 | 42 | Nov | 4 | 12000 | 15312 | 0.5 | 46 | Tier 1 | Ireland |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1142.857142857143 | 8000 | 0 | 9142.857142857143
 |  | Yes | 2009-11-28 00:00:00 | 2010-01-04 00:00:00 | 38 | Nov | 4 | 12000 | 15312 | 0.5 | 46 | Tier 1 | Ireland |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8842.105263157895 | 0 | 8842.105263157895
 |  | Yes | 2009-11-24 00:00:00 | 2010-01-07 00:00:00 | 45 | Nov | 4 | 7500 | 9570 | 0.5 | 59 | Tier 1 | Ireland |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 666.6666666666667 | 4666.666666666667 | 0 | 5333.333333333334
 |  | Yes | 2009-10-22 00:00:00 | 2010-01-18 00:00:00 | 89 | Oct | 4 | 29000 | 37004 | 0.5 | 23 | [NAME] | South East |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2932.584269662921 | 9123.595505617977 | 9123.595505617977 | 0 | 21179.77528089887
 |  | Yes | 2009-12-21 00:00:00 | 2010-03-23 00:00:00 | 93 | Dec | 4 | 30000 | 38280 | 0.5 | 21 | [NAME] |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1612.903225806452 | 0 | 1612.903225806452
 |  | No | 2009-02-18 00:00:00 | 2009-02-18 00:00:00 | 1 | Feb | 1 | 50000 | 63800 | 0.5 | 9 | Tier 3 | South East |  |  |  |  | 0 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000
 |  |  |  |  |  | Jan | 1 |  | 0 | 0.5 | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South West |  | 0.75 |  |  | Pending
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South East |  | 0.95
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ireland |  | 1
 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals | 28806.86584040008 | 128072.304414003 | 86831.45988258316 | 23978.08219178082 | 116067.6344305868 | 799462.3155393642 | 857847.0803112314 | 118039.4857005528 | 128174.7885320757 | 335180.3543123308 | 237310.2280499253 | 296692.1110494169 | 0 | 3156462.710254251