Spreadsheet: 271745d1382032820-index-match-with-date-range-criteria-formula-test-10-16
Sheet: Accruals-Pmts

All Accounted For? | GDN | ID1 | ID2 | Active Document | Type | CC |  | Transaction Type | Impacted Month | Month-Year Submitted on Accrual or Posted for Payment | 1 | mName | Line item total as of date in Col K | Line Item Cap | Current (today's) % Complete | % complete at time of accrual | Total Amount to [NAME] | Total [NAME] to [NAME] | Total Exp Amount to [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] for Fixed Billing milestones
 | 16565-16565 1999 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | T Support |  |  |  | 0.6
 | 16565-16565 1999 |  |  |  |  |  |  | Accrual | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 |  | T Support |  |  |  | 0.75
 | 16565-16565 1999 |  |  |  |  |  |  | Accrual | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 |  | T Support |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Accrual | 2013-03-01 00:00:00 | 2013-03-01 00:00:00 |  | Designing O |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Accrual | 2013-03-01 00:00:00 | 2013-03-01 00:00:00 |  | Build |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Accrual | 2013-03-01 00:00:00 | 2013-03-01 00:00:00 |  | T completion |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Accrual | 2013-04-01 00:00:00 | 2013-04-01 00:00:00 |  | U  and I |  |  |  | 0.7
 | 12345-18000 444 |  |  |  |  |  |  | Accrual | 2013-04-01 00:00:00 | 2013-04-01 00:00:00 |  | [NAME] (C1) |  |  |  | 0.8
 | 12345-18000 1002 |  |  |  |  |  |  | Accrual | 2013-03-01 00:00:00 | 2013-03-01 00:00:00 |  | U - W M-O-O C V 1.2 |  |  |  | 0.8
 | 12345-18000 1002 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | C1 P I Date Shift |  |  |  | 0.43
 | 16565-16565 1999 |  |  |  |  |  |  | Payment |  | 2013-10-01 00:00:00 |  | T Support |  |  |  | 1
 | 16888-16888 7000 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | E of E |  |  |  | 1
 | 16888-16888 7000 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | E of C |  |  |  | 0.5
 | 16888-16888 7000 |  |  |  |  |  |  | Accrual | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 |  | E of C |  |  |  | 0.7
 | 16888-16888 7000 |  |  |  |  |  |  | Accrual | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 |  | E of C |  |  |  | 1
 | 16888-16888 7000 |  |  |  |  |  |  | Accrual | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 |  | E of i |  |  |  | 0.4
 | 16888-16888 7000 |  |  |  |  |  |  | Accrual | 2013-08-01 00:00:00 | 2013-08-01 00:00:00 |  | E of i |  |  |  | 1
 | 16888-16888 7000 |  |  |  |  |  |  | Accrual | 2013-09-01 00:00:00 | 2013-09-01 00:00:00 |  | E of W |  |  |  | 1
 | 16888-16888 7000 |  |  |  |  |  |  | Accrual | 2013-09-01 00:00:00 | 2013-09-01 00:00:00 |  | End C Dep |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | U  and I |  |  |  | 0.9
 | 12345-18000 444 |  |  |  |  |  |  | Accrual | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 |  | [NAME] (C1) |  |  |  | 0.8
 | 12345-18000 444 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | [NAME] (C1) |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | 12 Time (C2) |  |  |  | 0.7
 | 12345-18000 444 |  |  |  |  |  |  | Accrual | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 |  | U  and I |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Accrual | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 |  | 12 Time (C2) |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Payment |  | 2013-05-01 00:00:00 |  | Designing O |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Payment |  | 2013-05-01 00:00:00 |  | Build |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Payment |  | 2013-05-01 00:00:00 |  | T completion |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Payment |  | 2013-09-01 00:00:00 |  | U  and I |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Payment |  | 2013-08-01 00:00:00 |  | [NAME] (C1) |  |  |  | 1
 | 12345-18000 444 |  |  |  |  |  |  | Payment |  | 2013-09-01 00:00:00 |  | 12 Time (C2)
 | 12345-18000 1002 |  |  |  |  |  |  | Accrual | 2013-04-01 00:00:00 | 2013-04-01 00:00:00 |  | U - W M-O-O C V 1.2 |  |  |  | 0.9374999244690172
 | 12345-18000 1002 |  |  |  |  |  |  | Accrual | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 |  | U - W M-O-O C V 1.2 |  |  |  | 0.94
 | 12345-18000 1002 |  |  |  |  |  |  | Accrual | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 |  | C1 P I Date Shift |  |  |  | 1
 | 12345-18000 1002 |  |  |  |  |  |  | Payment |  | 2013-06-01 00:00:00 |  | U - W M-O-O C V 1.2 |  |  |  | 1
 | 12345-18000 1002 |  |  |  |  |  |  | Payment |  | 2013-09-01 00:00:00 |  | C1 P I Date Shift |  |  |  | 1
 | 12345-18000 2000 |  |  |  |  |  |  | Accrual | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 |  | 1R Sign Off |  |  |  | 1
 | 12345-18000 2000 |  |  |  |  |  |  | Payment |  | 2013-08-01 00:00:00 |  | 1R Sign Off |  |  |  | 1