Spreadsheet: 30358d1225847829-year-to-date-formula-needed-2009-pipeline-test
Sheet: 2009 Pipeline

OPPORTUNITIES 2009 | Current Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00
2008-11-05 00:00:00 | Nov |  |  |  |  |  |  | 1917343 | 2446529.668 |  |  |  |  |  |  |  |  | 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 |  | 5 | Tier 3 |  |  |  |  |  | 0 | 0 | 0 | 0 | 50000 | 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 |  | 9 | [NAME] |  |  |  |  |  | 0 | 0 | 0 | 0 | 30000 | 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 |  | 10 | Tier 1 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 18000 | 0 | 0 | 0 | 0 | 0 |  | 18000
 |  | Yes | 2009-07-02 00:00:00 | 2009-07-06 00:00:00 | 5 | Jul | 3 | 40000 | 51040 |  | 8 | [NAME] |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 40000 | 0 | 0 | 0 | 0 | 0 |  | 40000
 |  | Yes | 2009-07-23 00:00:00 | 2009-07-26 00:00:00 | 4 | Jul | 3 | 10000 | 12760 |  | 13 | Tier 1 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 0 | 0 | 0 | 0 |  | 10000
 |  | Yes | 2009-08-13 00:00:00 | 2009-08-16 00:00:00 | 4 | Aug | 3 | 12000 | 15312 |  | 12 | Tier 1 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12000 | 0 | 0 | 0 | 0 |  | 12000
 |  | Yes | 2009-09-17 00:00:00 | 2009-09-20 00:00:00 | 4 | Sep | 3 | 13000 | 16588 |  | 11 | Tier 1 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13000 | 0 | 0 | 0 |  | 13000
 |  | No | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 | 365 | Jan | 1 | 250000 | 319000 |  | 3 | Tier 3 |  |  |  |  |  | 21232.87671232877 | 19178.08219178082 | 21232.87671232877 | 20547.94520547945 | 21232.87671232877 | 20547.94520547945 | 21232.87671232877 | 21232.87671232877 | 20547.94520547945 | 21232.87671232877 | 20547.94520547945 | 21232.87671232877 |  | 250000
 |  | No | 2009-07-24 00:00:00 | 2009-07-26 00:00:00 | 3 | Jul | 3 | 180000 | 229680 |  | 4 | Tier 3 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 180000 | 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 |  | 1 | Tier 3 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 678505 | 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 |  | 2 | Tier 3 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 535838 | 0 | 0 | 0 | 0 | 0 |  | 535838
 |  | No | 2009-02-20 00:00:00 | 2009-02-24 00:00:00 | 5 | Feb | 1 | 50000 | 63800 |  | 5 | Tier 3 |  |  |  |  |  | 0 | 50000 | 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 |  | 5 | Tier 3 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000 | 0 | 0 | 0 |  | 50000
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scotland |  | 0.5 |  | No | Lost |  | No
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South West |  | 0.75 |  |  | Pending
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South East |  | 0.95
 |  |  |  |  |  | Jan | 1 |  | 0 |  | No Rev |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ireland |  | 1
 |  |  |  |  |  |  | 1 |  |  |  | No Rev
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals | 21232.87671232877 | 69178.08219178082 | 21232.87671232877 | 20547.94520547945 | 101232.8767123288 | 699052.9452054794 | 805070.8767123288 | 33232.87671232877 | 83547.94520547945 | 21232.87671232877 | 20547.94520547945 | 21232.87671232877 | 0 | 1917343