Spreadsheet: 762584d1641648505-dynamic-dropdown-list-based-on-cell-value-ts-and-ps-tanks-schedule-2022
Sheet: MAP

Counts |  |  | Get Rows Selction |  |  |  |  |  | Dropdown list options
 |  |  |  |  |  |  |  |  | Terminal |  | Service Status |  |  | Inspection Status |  | Year
Year | 2021 |  | Show By | Make Selection |  |  |  |  | Killingholme |  | Out-of-Service For Inspection |  |  | Awaiting Tank Emptying |  | 2021
Q1 |  |  | Terminal
Q2
Q3
Q4
Terminal | Exolum Tank Systems / Pipeline Systems | Tank Number | Tank Type | Maximum Tank Capacity (m3) | Contract Turn Around Period (WKS) | Weekly Delay Cost (£) | Next Out-of-Service Inspection Due Date | Inspection Due Year | Year & Quarter | Actual Out-of-Service Date | Target Return to Service Date - No Delays | Forcast Return to Service Date | Service Status | Inspection Status | Project Manager | Inspection Contractor | Inspection Completion Date | Inspection Report Issue Date | Report Review & Repair Plan Completion Date | Exolum Integrity Assessor | Completion of Repairs Date | Repair Time (Days) | Handed over to Operations Date | Return to Service Date | Project Budget (£) | Project [NAME] | Project Overspend (£) | Comments
 | PS | 1 | 0 | 10500 | 0 | 0 | 44645 | 2022 - Q1 | 0 | 44645 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0
Killingholme | PS | 3 | 0 | 10500 | 0 | 0 | 44589 | 2022 - Q1 | 0 | 44589 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0
Killingholme | PS | 4 | 0 | 10500 | 0 | 0 | 49823 | 2036 - Q2 | 0 | 49823 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0
Killingholme | PS | 5 | 0 | 10500 | 0 | 0 | 44870 | 2022 - Q4 | 0 | 44870 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0
Killingholme | PS | 6 | 0 | 0 | 0 | 0 | 0 | Date Required | 0 | 0 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0
Killingholme | PS | 7 | 0 | 5500 | 0 | 0 | 49810 | 2036 - Q2 | 0 | 49810 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0
Killingholme | PS | 9 | 0 | 5500 | 0 | 0 | 44870 | 2022 - Q4 | 0 | 44870 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0
Killingholme | PS | 10 | 0 | 0 | 0 | 0 | 0 | Date Required | 0 | 0 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0
Killingholme | PS | 11 | 0 | 0 | 0 | 0 | 0 | Date Required | 0 | 0 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0
Killingholme | PS | 12 | 0 | 0 | 0 | 0 | 0 | Date Required | 0 | 0 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0
Killingholme | PS | 15 | 0 | 0 | 0 | 0 | 0 | Date Required | 0 | 0 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0
Killingholme | PS | 16 | 0 | 10500 | 0 | 0 | 49863 | 2036 - Q3 | 0 | 49863 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0
Killingholme | PS | 17 | 0 | 10500 | 0 | 0 | 44870 | 2022 - Q4 | 0 | 44870 | 0 | In-Service | N/A | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0