Spreadsheet: 30933d1226615376-sharing-the-value-of-job-over-a-certain-period-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-13 00:00:00 | Nov |  |  |  |  | 1917343 | 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 | Est. Revenue | 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 | 50000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Central |  | 0.25 |  | Yes | Won |  | Yes
 |  | Yes | 2009-05-21 00:00:00 | 2009-05-24 00:00:00 | 4 | 30000
 |  | Yes | 2009-07-08 00:00:00 | 2009-07-11 00:00:00 | 4 | 18000
 |  | Yes | 2009-07-02 00:00:00 | 2009-07-06 00:00:00 | 5 | 40000
 |  | Yes | 2009-07-23 00:00:00 | 2009-07-26 00:00:00 | 4 | 10000
 |  | Yes | 2009-08-13 00:00:00 | 2009-08-16 00:00:00 | 4 | 12000
 |  | Yes | 2009-09-17 00:00:00 | 2009-09-20 00:00:00 | 4 | 13000
 |  | No | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 | 365 | 250000
 |  | No | 2009-07-24 00:00:00 | 2009-07-26 00:00:00 | 3 | 180000
 |  | No | 2009-06-24 00:00:00 | 2009-06-28 00:00:00 | 5 | 678505
 |  | Yes | 2009-07-16 00:00:00 | 2009-07-19 00:00:00 | 4 | 535838
 |  | No | 2009-02-20 00:00:00 | 2009-02-24 00:00:00 | 5 | 50000
 |  | No | 2009-09-18 00:00:00 | 2009-09-22 00:00:00 | 5 | 50000
 |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0