Spreadsheet: 28076d1221913874-sumifs-from-2007-to-2003-example
Sheet: 180 ft or less (Def)

 |  |  |  |  | TANK 807
DEFENSIVE OPERATIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | Tank | Tank | Shell | Working | Type |  | Current
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tank # | of | [NAME] | Ht. | Capacity | Capacity | of | Permitted | Status
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Const | feet | feet | Bbls. | Bbls | Tank | Service |  | No. of Foam chambers | No. of Foam supply lines & size | No. of Inlet Connections & size | Req. Inlet press@ foam header(psig) | Foam connection location
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 807 | 1953 | 140 | 50 | 136000 | 105000 | EFR | Crude | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 813 | 1969 | 180 | 48 | 215000 | 175000 | EFR | Crude | O/S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 815 | 1976 | 190 | 50 | 250000 | 225000 | EFR | Crude | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 816 | 1976 | 190 | 50 | 250000 | 225000 | EFR | Crude | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 817 | 1977 | 190 | 50 | 250000 | 225000 | EFR | Crude | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 822 | 1978 | 190 | 50 | 250000 | 225000 | EFR | Crude | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 830 | 1981 | 275 | 50 | 500000 | 440000 | EFR | Crude | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 831 | 1981 | 275 | 50 | 500000 | 440000 | EFR | Crude | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 1 | 1920 | 115 | 40 | 70000 | 50000 | Cone | Gas Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 101 | 1919 | 114 | 30 | 55000 | 0 | Cone | Gas Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 102 | 1919 | 114 | 30 | 55000 | 38000 | Cone | Gas Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 103 | 1919 | 114 | 30 | 55000 | 0 | Cone | Gas Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 109 | 1919 | 114 | 30 | 55000 | 30000 | Cone | Gas Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 111 | 1919 | 114 | 30 | 55000 | 0 | Cone | Gas Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 112 | 1919 | 114 | 30 | 55000 | 38000 | Cone | Gas Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 113 | 1919 | 114 | 30 | 55000 | 38000 | Cone | Gas Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 118 | 1919 | 114 | 30 | 55000 | 38000 | Cone | Gas Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 85 | 1934 | 116.5 | 47.5 | 90000 | 75000 | Cone | Gas Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 203 | 1940 | 120 | 40 | 80000 | 70000 | Cone | Gas Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 206 | 1941 | 117.5 | 41.58 | 80000 | 50000 | Cone | Gas Oil | Active
Legend
Fire Hydrant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 50 | 1965 | 114.5 | 45 | 82000 | 67000 | IFR | Naphtha | Active
 |  |  |  |  |  | 2 1 / 2" Foam System Conn. |  |  |  | Dike Drain Valve |  |  |  |  |  |  | TANK 349 | 1967 | 67 | 40 | 25000 | 22000 | IFR | Naphtha | Active
-750 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 350 | 1967 | 67 | 40 | 25000 | 22000 | IFR | Naphtha | Active
Monitor (gpm) |  |  |  |  |  | Foam System Valve |  |  |  | [NAME] |  |  |  |  |  |  | TANK 66 | 1926 | 120 | 40 | 80000 | 50000 | Cone | Coker Feed | Active
Tank Data |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 204 | 1940 | 100 | 40 | 55000 | 30000 | Cone | [NAME] | Active
Tank Diameter (ft.) | #N/A |  | Nominal Capacity (bbls.) |  |  | #N/A |  | Tank Surface Area (sq. ft.)(.785 x D2) |  |  | #N/A |  |  |  |  |  | TANK 307 | 1943 | 120 | 50 | 100000 | 90000 | Cone | No. 2 Fuel Oil | Active
[NAME] (ft.) | #N/A |  | Nominal Capacity (gals.) |  |  | #N/A |  | Dike Surface Area (sq. ft.) (approx.) |  |  | 101600 |  |  |  |  |  | TANK 308 | 1943 | 120 | 50 | 100000 | 80000 | Cone | No. 2 Fuel Oil | Active
Tank Type | EFR |  | Gals. per Foot in Tank |  |  | #N/A |  |  |  |  |  |  |  |  |  |  | TANK 330 | 1999 | 117.5 | 41.58 | 80000 | 70000 | Cone | No. 2 Fuel Oil | Active
Permitted Service | Crude |  | Year of Construction |  |  | #N/A | Current Service |  |  |  | Active |  |  |  |  |  | TANK 331 | 1955 | 140 | 48 | 136000 | 110000 | Cone | No. 2 Fuel Oil | Active
Foam System Data |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 820 | 1977 | 190 | 50 | 250000 | 225000 | EFR | No. 2 Fuel Oil | Active
No. of Foam Chambers |  |  | N / A |  |  | Required Inlet Pressure @ Foam Header (psig) |  |  |  |  | N / A |  |  |  |  |  | TANK 340 | 1961 | 52 | 40 | 15000 | 12199 | IFR | Medium Reformate | Active
No. Foam Supply Lines & Size |  |  | N / A |  |  |  |  |  |  | Foam Connection Location | N / A |  |  |  |  |  | TANK 341 | 1961 | 60 | 40 | 20000 | 16234 | IFR | Medium Reformate | Active
No. of Inlet Connections & Size |  |  | N / A |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 353 | 1968 | 67 | 40 | 25000 | 20426 | IFR | Medium Reformate | Active
Tank Cooling Water Requirements |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 332 | 1955 | 140 | 48 | 136000 | 122000 | IFR | MTBE/Gasoline/Alkylate | Active
(All values based on cooling 8 ft. of shell above liquid level and .25 gpm/sq. ft. application rate) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 339 | 1961 | 52 | 40 | 15000 | 12000 | IFR | MTBE | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 342 | 1961 | 100 | 40 | 55000 | 45000 | IFR | Reformate | Active
Affected Tank Surface Area (sq. ft.)(DxHx3.14) |  |  |  |  | #N/A |  | [NAME] (gpm) |  |  | #N/A |  |  |  |  |  |  | TANK 343 | 1961 | 67 | 40 | 25000 | 20000 | IFR | MTBE | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 814 | 1975 | 120 | 40 | 100000 | 85000 | EFR | Alkylate
[NAME] for Exposure Tanks (gpm) (based on 1/3 dia. of tank) |  |  |  |  |  |  |  |  | 45 | 94.10580000000002 |  |  |  |  |  |  | TANK 824 | 1978 | 135 | 50 | 125000 | 110000 | EFR | Reformate | Active
Tank # 203 | 71 |  |  | Tank # 301 |  | 167 |  |  |  |  |  |  |  |  |  |  | TANK 825 | 1978 | 135 | 50 | 155000 | 125000 | EFR | [NAME] | Active
Tank # 208 | 97 |  |  | Tank # 303 |  | 151 |  |  |  |  |  |  |  |  |  |  | TANK 826 | 1981 | 150 | 50 | 155000 | 125000 | EFR | FCC Gasoline | Active
Tank # 212 | 97 |  |  | Tank # 304 |  | 314
Tank # 216 | 73 |  |  | Tank # 305 |  | 86 |  |  |  |  |  |  |  |  |  |  | TANK 808 | 1965 | 120 | 48 | 98000 | 80000 | EFR | Gasoline | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 810 | 1965 | 140 | 48 | 133000 | 115000 | EFR | Gasoline | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 811 | 1969 | 150 | 48 | 152000 | 130000 | EFR | Gasoline | Active
Original Issue Date : | 2008-09-04 00:00:00 |  |  | Current Revision Date: |  | 2008-09-04 00:00:00 |  | Current Revision # | 1 |  |  |  |  |  |  |  | TANK 812 | 1969 | 140 | 48 | 133000 | 115000 | EFR | Gasoline | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 818 | 1977 | 190 | 50 | 230000 | 200000 | EFR | Gasoline | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 51 | 1925 | 120 | 40 | 80000 |  | Cone | Recovered Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 79 | 1927 | 14 | 20 | 580 | 350 | Cone | Recovered Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 80 | 1927 | 14 | 20 | 580 | 350 | Cone | Recovered Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 98 | 1953 | 20.2 | 17.8 | 1000 | 700 | Cone | Recovered Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 315 | 1943 | 30 | 40 | 5000 | 0 | EFR | Recovered Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 316 | 1943 | 42.5 | 40 | 10000 | 0 | Cone | Recovered Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 317 | 1943 | 42.5 | 40 | 10000 | 8000 | Cone | Recovered Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 326 | 1943 | 30 | 40 | 5000 | 4200 | N/A | Recovered Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 327 | 1943 | 30 | 40 | 5000 | 4200 | Cone | Recovered Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 328 | 2001 |  |  | 20000 | 16000 | EFR | Recovered Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 348 | 1961 | 30 | 40 | 5000 | 3500 | Cone | Recovered Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 351 | 1968 | 42.5 | 40 | 10000 |  | Cone | Recovered Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 205 | 1940 | 100 | 40 | 55000 | 45000 | Cone | Recovered Oil | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 65 | 1926 | 120 | 40 | 80000 |  | IFR | Storm Water | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 97 | 1937 | 116.5 | 48 | 92000 |  | IFR | Wastewater | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 202 | 1940 | 80 | 40 | 35000 |  | EFR | [NAME] | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 309 | 1943 | 60 | 40.25 | 20000 |  | Cone | Sour Water/Kero | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 310 | 1943 | 60 | 40.25 | 20000 |  | Cone | Sour Water/Kero | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 312 |  |  |  |  |  | Cone | Caustic | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 313 | 1943 | 20 | 18 | 1000 |  | Cone | Caustic | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 321 | 1943 | 30 | 40 | 5000 |  | Cone | Caustic
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 335 | 1961 | 42.5 | 40 | 10000 |  | Cone | Caustic | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 311 | 1943 | 41.5 | 40 | 10000 |  | Cone | No. 2 Fuel Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 130 | 1969 | 12 | 32 | 726 |  | Cone | No. 2 Fuel Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 320 | 1943 | 30 | 40 | 5000 |  | IFR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 336 | 1961 | 42.5 | 40 | 10000 |  | IFR | No. 2 Fuel Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANK 337 | 1961 | 42.5 | 40 | 10000 |  | IFR | No. 2 Fuel Oil