Spreadsheet: 686537d1594671463-data-populate-according-the-2-drop-down-selection-excelhelp
Sheet: Master Sheet

Program Number | Project ID | OpCo | Segment | Business Unit | Status | CLEAR Number | Cost Center | CLEAR Title | Project Name | CLEAR Type | Lease Type | Lease Location Name | Region | Existing Lease Expiration Date | Capital Expense Cash Flow | Column1 | Created By Name | Responsible Manager Name | Responsible Manager ID | Project Manager | Project Manager Name | Project Manager ID | Create Date | Routing Initiation Date | Approved Date | Total Non RE Lease Component Requested Total Base | Column2 | Current RE Lease Component Requested Total | Column3 | Total Non RE Lease Component Freight Total | Column4 | Total Capital Component Expense Amount | Column5 | Total Capital Component Requested Total | Column6 | Capital Expense Cash Flow Base | Column7 | Capital Component Cash Flow | Column8 | Capital Component Cash Flow Base | Column9 | NRE Cash Flow | Column10 | NRE Cash Flow Base | Column11 | RE Cash Flow | Column12 | RE Cash Flow Base | Column13 | CLEAR Amount | Column14 | [NAME] | Column15 | Capitalized Interest Amount | Column16 | Capitalized Interest Amount Base | Column17 | Capitalized Interest Project# | Revised | Emergency | AE Holding CLEAR | Asset Trade | Multi Project | Multi OpCo CLEAR | On Airport | Airport ID
 |  | Services | Services | 10050 | Cancelled |  |  | Application Delivery Analysis (ADA) for 1SRC |  | Capital Only |  |  |  |  | 0 | US Dollars | [NAME] |  |  | Project Manager |  |  | 2013-04-30 00:00:00 |  |  | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 |  | Services | Services | 10050 | Cancelled |  |  | 12345 |  | Capital Only |  |  |  |  | 0 | US Dollars | [NAME] |  |  | Project Manager |  |  | 2013-04-30 00:00:00 |  |  | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9007390 | Services | Services | 10050 | Approved | 9007390 | 0250475 | P-133979-NonDrivingforCPC | FXG-NonDrivingContact | Capital Only |  |  |  |  | 0 | US Dollars | [NAME] | [NAME] | 395491 | Project Manager | [NAME] | 395167 | 2013-05-02 00:00:00 | 2013-06-07 00:00:00 | 2013-06-18 00:00:00 | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 700580.8 | US Dollars | 0 | US Dollars | 700580.8 | US Dollars | 700580.8 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 700580.8 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9007905 | Services | Services | 10050 | Approved | 9007905 | 0375352 | MCO IT LAB CLOSURE - 11th FL | MCO IT LAB CLOSURE | Capital Only |  |  |  |  | 504735 | US Dollars | [NAME] | [NAME] | 106034 | Project Manager | [NAME] | 429243 | 2013-05-03 00:00:00 | 2013-05-09 00:00:00 | 2013-06-04 00:00:00 | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 504735 | US Dollars | 305555.25 | US Dollars | 504735 | US Dollars | 305555.25 | US Dollars | 305555.25 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 305555.25 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9008704 | Services | Services | 10050 | Approved | 9008704 | 0777041 | FXG FY14 Field Properties Projects | FY14 Ground Field Proper | Capital Only |  |  |  |  | 136250 | US Dollars | [NAME] | [NAME] | 399593 | Project Manager | [NAME] | 399593 | 2013-05-06 00:00:00 | 2013-05-14 00:00:00 | 2013-06-28 00:00:00 | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 136250 | US Dollars | 5785175 | US Dollars | 136250 | US Dollars | 5785175 | US Dollars | 5785175 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 5785175 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9008566 | Services | Services | 10050 | Approved | 9008566 | 0777006 | eGIS Phase 2 | RPC eGIS Phase 2 | Capital Only |  |  |  |  | 3275108.52 | US Dollars | [NAME] | [NAME] | 190527 | Project Manager | [NAME] | 19146 | 2013-05-06 00:00:00 | 2013-08-26 00:00:00 | 2013-08-26 00:00:00 | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 3275108.52 | US Dollars | 1970680.8 | US Dollars | 3275108.52 | US Dollars | 1970680.8 | US Dollars | 1970680.8 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 1970680.8 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9008296 | Services | Services | 10050 | Approved | 9008296 | 0369122 | EDC-W 2nd Floor Completion | EDC-W 2nd Floor A and E | Capital Only |  |  |  |  | 33589.5 | US Dollars | [NAME] | [NAME] | 45422 | Project Manager | [NAME] | 85207 | 2013-05-08 00:00:00 | 2013-05-21 00:00:00 | 2013-09-03 00:00:00 | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 33589.5 | US Dollars | 18424222.04 | US Dollars | 33589.5 | US Dollars | 18424222.04 | US Dollars | 18424222.04 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 18424222.04 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9007840 | Services | Services | 10050 | Approved | 9007840 | 0250185 | SSFR Beta Hardware | FPOS Reinvention Part 3 | Capital Only |  |  |  |  | 0 | US Dollars | [NAME] | [NAME] | 253935 | Project Manager | [NAME] | 398199 | 2013-05-10 00:00:00 | 2013-05-14 00:00:00 | 2013-05-17 00:00:00 | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 201970.23 | US Dollars | 0 | US Dollars | 201970.23 | US Dollars | 201970.23 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 201970.23 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9008658 | Services | Services | 10050 | On Hold | 9008658 | 0369067 | Rocket Mobile TE Enterprise License | Rocket Mobile TE Enterpr | Capital Only |  |  |  |  | 35506.25 | US Dollars | [NAME] | [NAME] | 163346 | Project Manager | [NAME] | 163346 | 2013-05-14 00:00:00 | 2013-05-22 00:00:00 |  | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 35506.25 | US Dollars | 177531.25 | US Dollars | 35506.25 | US Dollars | 177531.25 | US Dollars | 177531.25 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 177531.25 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9008283 | Services | Services | 10050 | Approved | 9008283 | 0378051 | CRIS _ECS- [NAME] in Oracle and 1Source RDT | CRIS DAM ECS 1Src Enhcmt | Capital Only |  |  |  |  | 11700 | US Dollars | [NAME] | [NAME] | 70818 | Project Manager | [NAME] | 49379 | 2013-05-16 00:00:00 | 2013-06-04 00:00:00 | 2013-07-10 00:00:00 | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 11700 | US Dollars | 1147925.58 | US Dollars | 11700 | US Dollars | 1147925.58 | US Dollars | 1147925.58 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 1147925.58 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 |  | Services | Services | 10050 | Cancelled |  |  | Shop Wireless Expansion CLEAR |  | Capital Only |  |  |  |  | 0 | US Dollars | [NAME] |  |  | Project Manager |  |  | 2013-05-22 00:00:00 |  |  | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 |  | Services | Services | 10050 | Cancelled |  |  | Shop Wireless Expansion Project |  | Capital Only |  |  |  |  | 0 | US Dollars | [NAME] |  |  | Project Manager |  |  | 2013-05-22 00:00:00 |  |  | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 |  | Services | Services | 10050 | Cancelled |  |  | Local Business Network - Healthcare |  | Capital Only |  |  |  |  | 0 | US Dollars | [NAME] |  |  | Project Manager |  |  | 2013-05-23 00:00:00 |  |  | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 25000 | US Dollars | 25000 | US Dollars |  | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9008015 | Services | Services | 10050 | Approved | 9008015 | 0352203 | GRAPE2 | GRAPE 2 | Capital Only |  |  |  |  | 0 | US Dollars | [NAME] | [NAME] | 751510 | Project Manager | [NAME] | 751656 | 2013-05-29 00:00:00 | 2013-05-31 00:00:00 | 2013-08-01 00:00:00 | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 1042240.57 | US Dollars | 0 | US Dollars | 1042240.57 | US Dollars | 1042240.57 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 1042240.57 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9008710 | Services | Services | 10050 | Approved | 9008710 | 0352040 | EA Tooling Phase 1 | EA Tooling TROUX | Capital Only |  |  |  |  | 335439.9 | US Dollars | Rebecca Geller | [NAME] | 369950 | Project Manager | Rebecca Geller | 280026 | 2013-05-29 00:00:00 | 2013-05-31 00:00:00 | 2013-06-18 00:00:00 | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 335439.9 | US Dollars | 241192.1 | US Dollars | 335439.9 | US Dollars | 241192.1 | US Dollars | 241192.1 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 241192.1 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9008557 | Services | Services | 10050 | Approved | 9008557 | 0250290 | Business Objects 4 Upgrade | Business Objects 4 Upgra | Capital Only |  |  |  |  | 334737.5 | US Dollars | [NAME] | [NAME] | 752069 | Project Manager | [NAME] | 752225 | 2013-05-30 00:00:00 | 2013-06-07 00:00:00 | 2013-06-28 00:00:00 | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 334737.5 | US Dollars | 904923.75 | US Dollars | 334737.5 | US Dollars | 904923.75 | US Dollars | 904923.75 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 904923.75 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9007992 | Services | Services | 10050 | Approved | 9007992 | 0352145 | FY14 Sales Laptop Replacement | FY14 Sales Laptop Replac | Capital Only |  |  |  |  | 227071.77 | US Dollars | [NAME] | [NAME] | 60897 | Project Manager | [NAME] | 436533 | 2013-06-03 00:00:00 | 2013-06-04 00:00:00 | 2013-07-09 00:00:00 | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 227071.77 | US Dollars | 695640.3 | US Dollars | 227071.77 | US Dollars | 695640.3 | US Dollars | 695640.3 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 695640.3 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 9007992 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE
 | 9005018 | Services | Services | 10050 | Approved | 9005018 | 0358065 | SmartPad | FXE PowerPad [NAME] | Capital Only |  |  |  |  | 645478.85 | US Dollars | [NAME] | [NAME] | 298431 | Project Manager | [NAME] | 19146 | 2013-06-03 00:00:00 | 2013-06-07 00:00:00 | 2013-08-22 00:00:00 | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 17779535.37 | US Dollars | 53458240.76 | US Dollars | 645478.85 | US Dollars | 6301844.09 | US Dollars | 6301844.09 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars | 53458240.76 | US Dollars | 0 | US Dollars | 0 | US Dollars | 0 | US Dollars |  | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE