Spreadsheet: 762607d1641659022-filter-formula-based-on-year-ts-and-ps-tanks-schedule-2022
Sheet: Lookup Tables

Terminals - Lookup | Terminal PM - Lookup | TS/PS - Lookup | Tank Type - Lookup | Service Status - Lookup | Inspection Status - Lookup | Contractor - Lookup | Project Managers | Project Schedule - Lookup | TS/PS - Lookup | Today | This Year | This Month | This Quarter | Quarters
Aldermaston - Gully | [NAME] | PS | AST | In-Service | N/A | N/A | [NAME] | On [NAME] (+/-) 2 Weeks | TS |  |  |  |  | Q1
Aldermaston - Top Site | [NAME] | PS | UST | In Service – Approved Postponement | Awaiting Tank Emptying | Mistras Group | [NAME] | 3-4 Weeks Behind Schedule | PS |  |  |  |  | Q2
Amsterdam | [NAME] | TS | Square | Out-of-Service For Inspection | Awaiting Tank Cleaning | Oceaneering | [NAME] | >4 Weeks Behind Schedule |  |  |  |  |  | Q3
[NAME] | [NAME] | PS | Horizontal | Out-of-Service - Awaiting Contract | Awaiting Op's Handover to PM | Rosen | [NAME] | N/A |  |  |  |  |  | Q4
Belfast | [NAME] | TS | Sphere | L.T.O.O.S | Awaiting [NAME] | TesTex NDT | [NAME]
Bramhall | [NAME] | PS | Bullet |  | Awaiting Inspection | Viking NDT | [NAME]
Clydebank | [NAME] | TS |  |  | Inspection Ongoing | UltraScan NDT
Eastham | [NAME] | TS |  |  | Inspection Complete - Awaiting Report
[NAME] | [NAME] | TS |  |  | Report Issued - Awaiting Review & Repair Plan
Grays | [NAME] | TS |  |  | Repair Plan Issued - Awaiting Repairs
Hallen | [NAME] | PS |  |  | Repairs Ongoing
Immingham - East | [NAME] | TS |  |  | Repairs Complete - Awaiting Post Repair Inspection
Immingham - West | [NAME] | TS |  |  | Post Repair Inspection Complete - Awaiting Post Repair Report
Inverness | [NAME] | PS |  |  | Under Hydro Test
Killingholme | [NAME] | PS |  |  | Tank Handed Over to Operations
Mannheim - North | [NAME] | TS
Mannheim - South | [NAME] | TS
Misterton | [NAME] | PS
[NAME] | [NAME] | PS
Redcliff Bay | [NAME] | PS
Riverside | [NAME] | TS
Runcorn | [NAME] | TS
[NAME] | [NAME] | PS
[NAME] | [NAME] | TS
[NAME] | [NAME] | TS
Shannon | [NAME] | TS
Thetford | [NAME] | PS
Tyneside | [NAME] | TS
[NAME] | [NAME] | PS
Drop-Down Options Dependant of Category
Terminal - DD | Service Status | Inspection Status | Year | Categorys Selection
Aldermaston - Gully | In-Service | N/A | 2021 | Terminal
Aldermaston - Top Site | In Service – Approved Postponement | Awaiting Tank Emptying | 2022 | Service Status
Amsterdam | Out-of-Service For Inspection | Awaiting Tank Cleaning | 2023 | Inspection Status
[NAME] | Out-of-Service - Awaiting Contract | Awaiting Op's Handover to PM | 2024 | Year
Belfast | L.T.O.O.S | Awaiting [NAME] | 2025
Bramhall |  | Awaiting Inspection | 2026
Clydebank |  | Inspection Ongoing | 2027
Eastham |  | Inspection Complete - Awaiting Report | 2028
[NAME] |  | Report Issued - Awaiting Review & Repair Plan | 2029
Grays |  | Repair Plan Issued - Awaiting Repairs | 2030
Hallen |  | Repairs Ongoing | 2031
Immingham - East |  | Repairs Complete - Awaiting Post Repair Inspection | 2032
Immingham - West |  | Post Repair Inspection Complete - Awaiting Post Repair Report | 2033
Inverness |  | Under Hydro Test | 2034
Killingholme |  | Tank Handed Over to Operations | 2035
Mannheim - North |  |  | 2036
Mannheim - South |  |  | 2037
Misterton |  |  | 2038
[NAME]
Redcliff Bay
Riverside
Runcorn
[NAME]
[NAME]
[NAME]
Shannon
Thetford
Tyneside
[NAME]