Spreadsheet: 271781d1382043303-index-match-with-date-range-criteria-formula-test-10-16
Sheet: Fixed

Active? | ID1 | ID2 | Name | Mgr |  | Type | Doc # / Phase | Doc | GDN | S | mName |  |  |  | ETA | [NAME] | Exp | 0 | [NAME] | Date line added to file | amounts replaced by… | Replacement date | Comments | % Complete | Date Completed | Capital Completed | Expense Completed | Total Completed
 |  |  |  |  |  |  |  | 1999 V1.0 |  |  | T Support |  |  |  | 2013-08-16 00:00:00 |  |  | 5845.2 | 0 | 2013-05-15 00:00:00 |  |  |  | 1
 |  |  |  |  |  |  |  | 444 V1.3 |  |  | Designing O |  |  |  | 2012-07-01 00:00:00 |  |  |  | 0.704500277863883 | 2013-05-28 00:00:00 |  |  |  | 1 | 2012-11-27 00:00:00
 |  |  |  |  |  |  |  | 444 V1.3 |  |  | Build |  |  |  | 2012-11-01 00:00:00 |  |  |  | 0.933499958576406 | 2013-05-28 00:00:00 |  |  |  | 1 | 2013-01-15 00:00:00
 |  |  |  |  |  |  |  | 444 V1.3 |  |  | T completion |  |  |  | 2013-01-01 00:00:00 |  |  |  | 0.903300017593392 | 2013-05-28 00:00:00 |  |  |  | 1 | 2013-03-12 00:00:00
 |  |  |  |  |  |  |  | 444 V1.3 |  |  | U  and I |  |  |  | 2013-06-01 00:00:00 |  |  |  | 0.677 | 2013-05-28 00:00:00 |  |  |  | 1 | 2013-06-17 00:00:00
 |  |  |  |  |  |  |  | 444 V1.3 |  |  | Travel |  |  |  |  |  |  | 5000 | 0 | 2013-05-28 00:00:00
 |  |  |  |  |  |  |  | 1002 V1.2 |  |  | U - W M-O-O C V 1.2 |  |  |  | 2013-05-01 00:00:00 |  |  | 33099 | 0.953700111785855 | 2013-05-28 00:00:00 |  |  |  | 1 | 2013-05-22 00:00:00
 |  |  |  |  |  |  |  | 1002 V1.2 |  |  | Travel and Expense |  |  |  |  |  |  | 5000 | 0.954 | 2013-05-28 00:00:00
 |  |  |  |  |  |  |  | 1002 C1 V1.1 |  |  | C1 P I Date Shift |  |  |  | 2013-06-17 00:00:00 |  |  | 65516 | 0.953700012210758 | 2013-05-28 00:00:00 |  |  |  | 1 | 2013-06-24 00:00:00
 |  |  |  |  |  |  |  | 7000 V1.1 |  |  | E of E |  |  |  | 2013-05-31 00:00:00 |  |  | 98618.87 | 0 | 2013-05-01 00:00:00
 |  |  |  |  |  |  |  | 7000 V1.1 |  |  | E of C |  |  |  | 2013-07-05 00:00:00 |  |  | 156924.42 | 0.9 | 2013-05-01 00:00:00
 |  |  |  |  |  |  |  | 7000 V1.1 |  |  | E of i |  |  |  | 2013-08-19 00:00:00 |  |  | 159105.54 | 0.96 | 2013-05-01 00:00:00
 |  |  |  |  |  |  |  | 7000 V1.1 |  |  | E of W |  |  |  | 2013-09-20 00:00:00 |  |  | 50000 | 0 | 2013-05-01 00:00:00
 |  |  |  |  |  |  |  | 7000 V1.1 |  |  | Total Travel (if applicable) |  |  |  |  |  |  | 5000 | 0 | 2013-05-01 00:00:00
 |  |  |  |  |  |  |  | 7000 C2 V1.2 |  |  | E of E |  |  |  | 2013-05-31 00:00:00 |  |  | 98618.87 | 0 | 2013-07-07 00:00:00 |  |  |  | 1 | 2013-05-31 00:00:00
 |  |  |  |  |  |  |  | 7000 C2 V1.2 |  |  | E of C |  |  |  | 2013-07-05 00:00:00 |  |  | 197854.43 | 0.9 | 2013-07-07 00:00:00 |  |  |  | 1 | 2013-07-12 00:00:00
 |  |  |  |  |  |  |  | 7000 C2 V1.2 |  |  | E of i |  |  |  | 2013-08-19 00:00:00 |  |  | 179105.54 | 0.96 | 2013-07-07 00:00:00 |  |  |  | 1 | 2013-08-19 00:00:00
 |  |  |  |  |  |  |  | 7000 C2 V1.2 |  |  | E of W |  |  |  | 2013-09-20 00:00:00 |  |  | 50000 | 0 | 2013-07-07 00:00:00
 |  |  |  |  |  |  |  | 7000 C2 V1.2 |  |  | Total Travel (if applicable) |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 7000 C3 V1 |  |  | E of W |  |  |  | 2013-05-31 00:00:00 |  |  | 98618.87 | 0 | 2013-09-16 00:00:00 |  |  |  | 1 | 2013-05-31 00:00:00
 |  |  |  |  |  |  |  | 7000 C3 V1 |  |  | E of C |  |  |  | 2013-07-05 00:00:00 |  |  | 197854.43 | 0.9 | 2013-09-16 00:00:00 |  |  |  | 1 | 2013-07-12 00:00:00
 |  |  |  |  |  |  |  | 7000 C3 V1 |  |  | E of i |  |  |  | 2013-08-19 00:00:00 |  |  | 179105.54 | 0.96 | 2013-09-16 00:00:00 |  |  |  | 1 | 2013-08-19 00:00:00
 |  |  |  |  |  |  |  | 7000 C3 V1 |  |  | E of W |  |  |  | 2013-09-20 00:00:00 |  |  | 50000 | 0 | 2013-09-16 00:00:00 |  |  |  | 1 | 2013-09-20 00:00:00
 |  |  |  |  |  |  |  | 7000 C3 V1 |  |  | End C Dep |  |  |  | 2013-09-27 00:00:00 |  |  | 14776.7 | 0.96 | 2013-09-16 00:00:00 |  |  |  | 1 | 2013-09-16 00:00:00
 |  |  |  |  |  |  |  | 444 C1 V1.0 |  |  | [NAME] (C1) |  |  |  | 2013-02-01 00:00:00 |  |  | 675 | 0 | 2013-05-28 00:00:00 |  |  |  | 1 | 2013-05-01 00:00:00
 |  |  |  |  |  |  |  | 444 C2 V1.1 |  |  | 12 Time (C2) |  |  |  | 2013-06-17 00:00:00 |  |  | 14476 | 0.9 | 2013-06-05 00:00:00 |  |  |  | 1 | 2013-06-17 00:00:00
 |  |  |  |  |  |  |  | 2000 V1.0 |  |  | 1R Sign Off |  |  |  | 2013-05-01 00:00:00 |  |  | 28632.53 | 0 | 2013-06-18 00:00:00 |  |  |  | 1 | 2013-05-10 00:00:00