Spreadsheet: 126903d1320053929-pivot-table-to-count-dates-from-two-columns-milestone-measurement-rev-03
Sheet: Sheet1

Junctions | Execution | Nick | [NAME] |  |  | [NAME] |  | Olympic | A71130 | A70630 | Notification to proceed | 2010-11-23 00:00:00 | 2010-09-02 00:00:00 | 2010-08-23 00:00:00 | 2010-09-21 00:00:00 | 2010-09-21 00:00:00 | 2010-09-21 00:00:00 | 2010-08-20 00:00:00 |  | 2010-08-20 00:00:00 | 2010-09-28 00:00:00 | 2010-10-11 00:00:00 | 2010-10-11 00:00:00 | 2011-06-01 00:00:00 | 2011-06-06 00:00:00 | 2011-06-06 00:00:00 | 2010-11-23 00:00:00 | 2010-12-06 00:00:00 | 2010-12-06 00:00:00 | 2010-12-06 00:00:00 | 2010-12-17 00:00:00 | 2011-01-25 00:00:00 | 2010-12-07 00:00:00 | 2010-12-10 00:00:00 | 2010-11-29 00:00:00 | 2010-11-29 00:00:00 | 2010-10-22 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-12-21 00:00:00 | 2010-12-21 00:00:00 | 2010-12-21 00:00:00 | 2011-01-25 00:00:00 | 2010-12-21 00:00:00 |  | 2010-12-21 00:00:00 |  | 2010-12-21 00:00:00 | 2010-12-21 00:00:00 | 2010-11-29 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-18 00:00:00 | #N/A |  |  | [NAME]
Junctions | Execution | Nick | [NAME] |  |  | UIP1513 |  | Olympic | A71140 | A70510 | Funding released | 2011-01-11 00:00:00 | 2010-10-08 00:00:00 | 2010-08-25 00:00:00 | 2010-08-23 00:00:00 | 2010-08-23 00:00:00 | 2010-08-23 00:00:00 | 2010-09-21 00:00:00 |  | 2010-09-03 00:00:00 | 2010-10-26 00:00:00 | 2010-11-16 00:00:00 | 2010-11-16 00:00:00 | 2010-11-16 00:00:00 | 2010-11-16 00:00:00 | 2010-12-15 00:00:00 | 2011-01-11 00:00:00 | 2011-01-13 00:00:00 | 2011-01-13 00:00:00 | 2011-01-13 00:00:00 | 2011-02-02 00:00:00 | 2011-02-02 00:00:00 | 2010-08-16 00:00:00 | 2010-08-16 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-10 00:00:00 | 2011-02-10 00:00:00 | 2011-02-10 00:00:00 | 2011-02-10 00:00:00 | 2010-08-24 00:00:00 |  | 2010-08-24 00:00:00 |  | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 | 2010-08-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-10 00:00:00 | #N/A |  |  | [NAME]
Junctions | Execution | Nick | [NAME] |  |  | UIP1513 |  | Olympic | F030-110_LU | F030-110 | Lift 4 Test and Commission Complete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-12 00:00:00 | 2011-01-12 00:00:00 | 2011-01-12 00:00:00 | 2011-01-25 00:00:00 | 2011-03-03 00:00:00 | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-09 00:00:00 |  |  |  |  |  |  |  |  |  | 2011-02-09 00:00:00 | 2011-02-09 00:00:00 | 2011-02-09 00:00:00 | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 | 2011-01-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-09 00:00:00 |  |  |  | [NAME]
Junctions | Execution | Nick | [NAME] |  |  | UIP1513 |  | Olympic | C030-215_LU | C030-215 | Start cladding lift 4 and UMC riser |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-11 00:00:00 | 2011-02-11 00:00:00 | 2011-02-11 00:00:00 | 2011-02-14 00:00:00 | 2011-01-17 00:00:00 | 2011-01-17 00:00:00 | 2011-01-17 00:00:00 | 2011-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2011-03-14 00:00:00 | 2011-03-14 00:00:00 | 2011-03-14 00:00:00 | 2011-02-14 00:00:00 | 2011-01-17 00:00:00 | 2011-01-17 00:00:00 | 2011-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-06-05 00:00:00 |  |  |  | [NAME]
Junctions | Execution | Nick | [NAME] |  |  | UIP1513 |  | Olympic | CLOS-666_LU | CLOS-666 | New stair 4/602 in public use |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-14 00:00:00 | 2011-02-14 00:00:00 | 2011-02-14 00:00:00 | 2011-02-14 00:00:00 | 2011-02-14 00:00:00 | 2011-03-21 00:00:00 | 2011-04-03 00:00:00 | 2011-05-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2011-03-15 00:00:00 | 2011-03-15 00:00:00 | 2011-03-15 00:00:00 | 2011-03-15 00:00:00 | 2011-03-15 00:00:00 | 2011-03-21 00:00:00 | 2011-04-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-04-12 00:00:00 |  |  |  | [NAME]
Junctions | Execution | Nick | [NAME] |  |  | UIP1513 |  | Olympic | F040-110_LU | F040-110 | Lift 5 & 6 Test and Commission Complete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-11 00:00:00 | 2011-03-11 00:00:00 | 2011-03-11 00:00:00 | 2011-03-23 00:00:00 | 2011-03-23 00:00:00 | 2011-03-23 00:00:00 | 2011-04-01 00:00:00 | 2011-05-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-04-08 00:00:00 |  |  |  |  |  |  |  |  |  | 2011-04-08 00:00:00 | 2011-04-08 00:00:00 | 2011-04-08 00:00:00 | 2011-03-23 00:00:00 | 2011-03-23 00:00:00 | 2011-03-23 00:00:00 | 2011-03-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-05-06 00:00:00 |  |  |  | [NAME]
Junctions | Execution | Nick | [NAME] |  |  | UIP1513 |  | Olympic |  |  | canopy structure complete | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | 2011-06-23 00:00:00 | 2011-06-23 00:00:00 | 2011-06-23 00:00:00 | 2011-06-23 00:00:00 | 2011-07-05 00:00:00 | 2011-05-17 00:00:00 | 2011-05-17 00:00:00 | 2011-05-17 00:00:00 | 2011-06-02 00:00:00 | 2011-05-18 00:00:00 | 2011-05-18 00:00:00 | 2011-06-02 00:00:00 | 2011-05-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A |  |  | 2011-09-14 00:00:00 |  | N/A | 2011-08-12 00:00:00 | 2011-08-12 00:00:00 |  | 2011-08-12 00:00:00 |  | 2011-08-12 00:00:00 | 2011-08-12 00:00:00 | 2011-06-27 00:00:00 | 2011-06-27 00:00:00 | 2011-06-27 00:00:00 | 2011-06-02 00:00:00 | 2011-05-18 00:00:00 | 2011-05-18 00:00:00 | 2011-06-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A |  |  |  |  |  |  |  | 2011-06-30 00:00:00 |  |  |  | [NAME]
Junctions | Execution | Nick | [NAME] |  |  | UIP1513 |  | Olympic | CLOS-660_LU | CLOS-660 | Replacement of ticket hall floor complete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-05-20 00:00:00 | 2011-05-20 00:00:00 | 2011-05-20 00:00:00 | 2011-05-20 00:00:00 | 2011-05-20 00:00:00 | 2011-05-20 00:00:00 | 2011-05-20 00:00:00 | 2011-05-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-19 00:00:00 |  |  |  |  |  |  |  |  |  | 2011-07-19 00:00:00 | 2011-07-19 00:00:00 | 2011-07-19 00:00:00 | 2011-05-23 00:00:00 | 2011-05-23 00:00:00 | 2011-05-20 00:00:00 | 2011-05-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-06-20 00:00:00 |  |  |  | [NAME]
Junctions | Execution | Nick | [NAME] |  |  | UIP1513 |  | Olympic |  |  | RC Req Date | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | 2010-06-01 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A |  |  | 2010-06-28 00:00:00 |  | N/A | 2010-06-28 00:00:00 | 2010-06-04 00:00:00 |  | 2010-06-04 00:00:00 |  | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 | 2010-06-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A |  |  |  |  |  |  |  | 2010-07-26 00:00:00 |  |  |  | [NAME]
Junctions | Execution | Nick | [NAME] |  |  | UIP1513 |  | Olympic |  |  | PC Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2011-01-14 00:00:00 | 2011-01-14 00:00:00 | 2011-02-03 00:00:00 | 2011-02-03 00:00:00 | 2010-08-17 00:00:00 | 2010-09-01 00:00:00 | 2010-09-01 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-11 00:00:00 | 2011-02-11 00:00:00 | 2011-02-11 00:00:00 | 2011-02-11 00:00:00 | 2010-08-25 00:00:00 |  | 2010-09-01 00:00:00 |  | 2010-09-01 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-31 00:00:00 |  |  |  | [NAME]
Junctions | Execution | Nick | [NAME] |  |  | UIP1513 |  | Olympic | A70930 | 1513AS-1300-PDM-0950 | Delivery into Service- BIU SFA Works | 2011-09-14 00:00:00 | 2011-09-14 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 |  | 2011-09-01 00:00:00 | 2011-09-22 00:00:00 | 2011-09-21 00:00:00 | 2011-09-21 00:00:00 | 2011-09-21 00:00:00 | 2011-09-21 00:00:00 | 2011-10-04 00:00:00 | 2011-09-27 00:00:00 | 2011-10-04 00:00:00 | 2011-10-04 00:00:00 | 2011-10-04 00:00:00 | 2011-10-11 00:00:00 | 2011-10-31 00:00:00 | 2011-10-04 00:00:00 | 2011-10-04 00:00:00 | 2011-10-04 00:00:00 | 2011-10-04 00:00:00 | 2011-09-21 00:00:00 | 2011-09-21 00:00:00 | 2011-09-21 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 | 2011-08-31 00:00:00 | 2011-08-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-05 00:00:00 | 2011-10-24 00:00:00 | 2011-10-24 00:00:00 | 2011-10-31 00:00:00 | 2011-10-24 00:00:00 |  | 2011-10-24 00:00:00 |  | 2011-10-24 00:00:00 | 2011-10-24 00:00:00 | 2011-09-21 00:00:00 | 2011-09-21 00:00:00 | 2011-09-21 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 | 2011-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-12 00:00:00 | #N/A |  | Y
Total
Positive
Negative
[NAME]
[NAME]