A.02.12 Attachment A - Sample Bulk ISR.pdf

Installation Status Report

(ISR) - Infrastructure

STANDARDS RATING BOOKLET

BOOKLET 15

BULK FUEL FACILITIES

REVISION DATE: 26-Jul-2012

FOR USE WITH THE FY 2013 ISR-I DATA COLLECTION

Proponent(s):

Deputy Chief of Staff, G-4, DALO-SM (703) 767-0649/DSN 427-0649 (Army Materiel Command, AMCBT-F (703) 806-8724 /DSN 806-8724)

INCLUDES THE FOLLOWING FCG(s):

F41100 - BULK LIQUID FUEL STORAGE (BL) F41170 - LUBRICANT STR (BL)

FCG Unit of Measure. BL = Barrels. Refer to Implementing Instructions, Appendix J, for definitions.

CHANGE TO RATING STANDARDS REVIEW PROCESS, FY 2013

Component Methodology Re-Calculation and Process Redesign

The Rating Standards Booklets and component level calculation methodology have been modified. The methodology required to score individual components will now use the Component Calculation spreadsheet available for download from the ISR Website. This change is intended to provide a more accurate component level Green/Amber/Red rating for individual components.

Changes include:

The instructions on the component subtotal sections for each component have been modified.

The process by which we calculate the Green/Amber/Red component level ratings has been updated.

The data required to be entered into the Facility Condition Assessment Worksheet printed from the Data Input Module has changed. Please see the Notes section of the Component Calculation spreadsheet.

Update to the ‘ISR-I FACILITY INSPECTION INSTRUCTIONS’ page, added bullet to section 1 and added section 9

ISR-I FACILITY INSPECTION INSTRUCTIONS

1. Select the appropriate facility inspection worksheet and standards rating booklet to evaluate your facility.

The appropriate booklet number is identified at the top of the worksheet.

Only use worksheets that the current ISR Infrastructure software has produced. These worksheets have the correct installation and facility information printed at the top of the page.

Verify that the building number on the worksheet matches the building number of the facility you are inspecting.

Confirm that the Facility Category Group (FCG) description on the facility inspection worksheet matches the space you will be rating in the facility. Some facilities consist of space from several FCGs, each of which requires a separate facility inspection worksheet and associated rating booklet.

Confirm that category code matches the space to be rated, notify DPW if it is incorrect

2. At the top of the inspection worksheet, fill in the Inspector name, Inspector phone number, and date completed.

3. Grade each element of a component rating section by looking at the picture for each component, reading the condition description for each element, and determining the BEST FIT as it applies to your facility. Circle the appropriate “Point” weight for that element in the appropriate column.

Each component rating section has elements that you will evaluate as GREEN, AMBER, or RED. The points totaled for the rated elements will help in determine the rating of the component.

In those cases when an element does not exist and does not apply to a facility, check the N/A box for the element and exclude its point weight from the column total.

If an element is not present, but does apply to a facility, circle the points in the RED column.

Example: An element condition lists “Signage required,” but signage is not installed. Mark the element “RED.”

When evaluating a component consider all space in the facility for that component. If a deficiency can be resolved with a simple self-service supply item (for example, by replacing light bulbs) or with routine maintenance, do not rate that element low simply for that deficiency.

Rating a component AMBER (rather than RED) because of disabled-access issues does not imply that the AMBER condition meets applicable standards.

4. When each element of a component rating section has been graded, total the weights circled for each column (GREEN, AMBER, and RED).

5. Transfer the color ratings for each facility component rating section by placing the score in, or next to, the appropriate box for each component’s color on the facility condition inspection worksheet.

If an inspection component is not part of a facility and is not needed, place an “X” in the “N/A” box on the facility inspection worksheet for that component. However, if an inspection component is not a part of the facility and it is needed, rate that component as RED.

6. Use the Component Calculation spreadsheet – available for download on the ISR Website – to determine the final Mission Functional and Quality Component color ratings. Once the color ratings are calculated, record that rating on the facility condition inspection worksheet.

7. For every component that is rated RED for either Mission Functional Capability or Quality, write a brief explanation in the space provided on the facility inspection worksheet. Continue on the back of the worksheet or on a separate page if needed.

For each RED component rating, consider submitting a work order to correct the deficiency.

Optional: Write a brief comment concerning any facility location issues, such as location of the facility on the installation, proximity to related facilities, and appropriate vehicle access. Continue on the reverse of the inspection worksheet if needed.

Optional: Write a brief comment concerning any environmental, health, safety, and historic preservation issues. Continue on the reverse of the inspection worksheet if needed.

8. Each inspector must review the completed facility condition inspection worksheet and sign on the appropriate page.

9. Any single bullet listed in the assessment table can affect the rating. It is not required for all bullets to be applicable

Facility Specific Components Mission-Functional Rating Input

Quality Rating Input

Compo

Inspection Components Page No

Green Amber Red N/A Green Amber Red N/A

1 Storage Operations 1

2 Receiving And Issue Operations 7

SAMPLE FACILITY INSPECTION WORKSHEET

BULK FUEL FACILITIES (Booklet #15)

SITENO:

XYZ

Facility Number:

XYZ

Facility Category Group:

F00000

Use with Booklet #

Site: XYZ_______________________ FCG Description: __________________________________________

UIC: XYZ_______________________ Unit of Measure: __________________________________________

Inspector:_______________________ Phone#: ________________________________________________ Date Inspected:_____________

Note: This is a SAMPLE WORKSHEET. Facility inspectors must use worksheets GENERATED in the ISRWEB Data Input Module specific to each facility (see detail instructions on previous page)

RATING COMMENTS AND INSPECTOR SIGNATURE PAGE:

Red Rating Explanation:

Facility Readiness and Location Comment:

Environmental, Health, Safety, & Preservation (EHSP) Comment:

INSPECTOR SIGNATURE

BULK FUEL FACILITIES BOOKLET

GREEN AMBER RED

Booklet 15 - Page 1

STORAGE OPERATIONS (MISSION-FUNCTIONAL)

In each row, circle the “Points” next to the description that most closely describes the facility. If a rating element does not apply, check the N/A box for that element and exclude it from the column total.

HIGH PRIORITY: Points Points Points N/A

SPILL CONTAINER:

Facility sufficiently supplied with spill containers to meet all facility mission(s) requirements

10 SPILL CONTAINER:

Spill containers are installed but do not have the capacity to meet all facility mission(s)

10 SPILL CONTAINER:

Spill containers are not installed

10 [ ]

FENCING:

Facility completely surrounded by security fencing

10 FENCING:

Facility completely surrounded by security fencing

Facility NOT surrounded by security fencing

GAUGING EQUIPMENT:

Proper gauging equipment available to detect fuel leaks and/or water accumulation

10 GAUGING EQUIPMENT:

Proper gauging equipment available to detect fuel leaks and/or water accumulation

Proper gauging equipment is NOT available to detect fuel leaks and/or water accumulation

UTILITY WIRES:

Utility wires are not located directly overhead of facility

10 UTILITY WIRES:

Facility has waivers for utility wires directly overhead

10 UTILITY WIRES:

Facility has overhead wires with no waiver

LABELING:

Tanks are properly and completely marked with product identification

Pipelines are properly and completely marked with product identification

Manifold system on tank fully and properly labeled

Labels are easily readable (ex. not faded, not torn, etc.)

10 LABELING:

Tanks are NOT completely marked with product identification

Pipelines are NOT completely marked with product identification

Manifold system on tank is NOT completely labeled

Labels are not easily read (faded, torn, etc.)

10 LABELING:

Tanks are NOT marked with product identification

Pipelines are NOT marked with product identification

Manifold system on tank is NOT labeled, or;

Facilities are NOT labeled

ABOVEGROUND STORAGE TANKS:

Tanks have functional bottom drain (water draw off) system

High/Low level alarms and leak detection system

API 653 inspection has been previously performed and is current with copy of the report available, and the next inspection is due within the next 10 years

Test date is marked on tank

Documentation exists verifying tank is

10 ABOVEGROUND STORAGE TANKS:

Tank has a non-functional bottom drain (water draw off) system

Either High/Low level alarms or leak detection

API 653 inspection has been previously performed and is current with a copy of the report available, and the next inspection is due within the next year

Documentation does not exist verifying tank is not leaking

10 ABOVEGROUND STORAGE TANKS:

Tank has visual evidence of physical damage and/or visual signs of fuel stains (weeping)

Tank has no bottom drain system

Tank has neither High/Low level alarms or leak detection

API 653 has not been performed, or the results are not available, or the API 653 inspection is past due

Documentation exists verifying tank is leaking

Booklet 15 - Page 2

In each row, circle the “Points” next to the description that most closely describes the facility. If a rating element does not apply, check the N/A box for that element and exclude it from the column total.

not leaking

UNDERGROUND STORAGE TANKS:

Underground tanks are double-walled (tanks part of aircraft hydrant system can be single-walled)

High/Low level alarms and leak detection system

Cathodic protection systems for steel tanks are inspected annually with proper documentation available

Documentation exists verifying tank is not leaking

10 UNDERGROUND STORAGE TANKS:

N/A [No AMBER condition]

N/A [No AMBER condition]

Cathodic protection systems for steel tanks have not been inspected in the last year and/or are without the proper documentation

Documentation does not exist verifying tank is not leaking

Underground tanks are NOT double-walled (tanks part of aircraft hydrant system can be single-walled)

High/Low level alarms or leak detection system not installed

Cathodic protection system for steel tanks is not installed

Documentation exists verifying tank is leaking

PIPELINES:

Underground pipelines have functional leak detection system with current annual calibration documentation OR a current annual tightness test

Cathodic protection is inspected annually (on corrodible metallic pipes only) with documentation of the inspection on hand

10 PIPELINES:

Underground pipelines do NOT have a functional leak detection system, annual leak detection calibration documentation is within 3 months of expiration and is not programmed for retesting

Annual Cathodic protection inspection is overdue (on corrodible metallic piping only)

Underground pipelines do NOT have a functional leak detection system, do NOT have functional leak detection calibration documentation OR is past due a current annual tightness test

Underground pipes do not have Cathodic protection (on corrodible metallic piping only)

TELEPHONE SYSTEM:

Sufficient telephone jacks are available to support current mission requirements (such as FAS, public telephone, fuels operator, etc.)

10 TELEPHONE SYSTEM:

Sufficient telephone jacks available to support current mission requirements (such as FAS, public telephone, fuels operator, etc.)

Telephone jacks are not available to support current mission requirements (such as FAS, public telephone, fuels operator, etc.)

EXTERIOR LIGHTING:

Provides direct or area lighting for:

Pedestrian movement

Security

Signage

Landscape

10 EXTERIOR LIGHTING:

Not more than 1 of the 4 types of lighting in the GREEN column is missing

Two or more of the 4 types of lighting in the GREEN column are missing, or

No exterior lighting exists

DRAINAGE:

Sufficient drainage in place to prevent ponding or flooding

All drainage within the storage of

10 DRAINAGE:

Drainage is installed but is not sufficient to fully prevent ponding or flooding

Containment release valves exist but are in

10 DRAINAGE:

Drainage is not installed

Ground is contaminated by spills/leaks

Booklet 15 - Page 3

In each row, circle the “Points” next to the description that most closely describes the facility. If a rating element does not apply, check the N/A box for that element and exclude it from the column total.

dispensing area passes through an oil/water separator or drains to a retention pond of a sufficient size

Containment release valves are kept in a closed position and checked for POL sheen before releasing stormwater need of repair.

NOTE: If the valve is seized, it must be seized in the closed position to warrant an Amber rating. A valve frozen in the open position warrants a Red rating.

Containment release valves are kept open at all times to allow stormwater to escape

MEDIUM PRIORITY: Points Points Points N/A

BERM AREA:

Berm area is of sufficient size to contain single largest storage release plus sufficient freeboard

6 BERM AREA:

Berm area is of sufficient size to contain single largest storage release but insufficient freeboard

Spill berms are not installed, have no freeboard, or are insufficient to contain single largest storage release

6 [ ]

COMPUTER/LAN SYSTEM:

Enough LAN outlets are available to support the Facilities Automated System (FAS)

6 COMPUTER/LAN SYSTEM:

Not enough LAN outlets to support the Facilities Automated System (FAS)

LAN outlets are not available to support the Facilities Automated System (FAS)

LOW PRIORITY: Points Points Points N/A

OFFICE HVAC (Heating, Ventilation, Air Conditioning):

Facility office equipped with an HVAC system

HVAC is fully operational and has sufficient capacity to meet office climate control requirements

4 OFFICE HVAC (Heating, Ventilation, Air Conditioning):

N/A [no AMBER condition]

Facility office HVAC does NOT have sufficient capacity to meet office climate control requirements

HVAC system NOT installed in facility office

4 [ ]

LANDSCAPING:

No weeds, vegetation, or combustible material within the grounds of the facility

4 LANDSCAPING:

Maintained vegetation, weeds, or combustible material within the grounds of the facility

4 LANDSCAPING:

Dense vegetation growth or combustible material within the grounds of the facility

OFFICE RESTROOMS:

Restrooms in place for Storage Operations office

4 OFFICE RESTROOMS:

Restrooms are NOT in place for Storage Operatins office

SUBTOTAL OF POINTS CIRCLED IN THIS

COLUMN PAGES 1 THROUGH 3 _______

SUBTOTAL OF POINTS CIRCLED IN THIS

COLUMN PAGES 1 THROUGH 3 ______

COLUMN PAGES 1 THROUGH 3 ______

GREEN

AMBER

RED

Booklet 15 - Page 4

In each row, circle the “Points” next to the description that most closely describes the facility. If a rating element does not apply, check the N/A box for that element and exclude it from the column total.

TOTAL EACH COLOR COLUMN, AND THEN WRITE THE NUMERICAL SCORE OF EACH R/A/G RATING IN OR NEXT TO THE APPROPRIATE BOX ON THE FACILITY WORKSHEET.

Booklet 15 - Page 5

STORAGE OPERATIONS (QUALITY)

In each row, circle the “Points” next to the description that most closely describes the facility. If a rating element does not apply, check the N/A box for that element and exclude it from the column total.

HIGH PRIORITY: Points Points Points N/A

FENCING:

Security fencing shows no signs of deterioration, damage, or modification

Security fencing functioning but shows signs of deterioration, damage, or modification

Security fencing shows signs of deterioration, damage, or modification that hinder its performance

GAUGING EQUIPMENT:

Gauging equipment is fully operational with no signs of damage or deterioration

Gauging equipment is operational but has signs of damage or deterioration

Gauging equipment is not operational

ABOVEGROUND STORAGE TANKS:

Tank surfaces are coated with no signs of chipping, flaking, rusting, weeping of fuel, or denting

Tank surfaces are coated but chipped, flaking, rusting, or with minor denting

Tank surfaces are chipped, flaking, or rusting on over 20% of the surface

Tank has visual evidence of physical damage and/or visual signs of fuel stains (weeping)

UNDERGROUND STORAGE TANKS:

High/Low level alarms and leak detection system is installed and working

Cathodic protection system for steeel tanks is operating

High/Low level alarms or leak detection system installed but not functioning

Cathodic protection system for steel tanks is not operating

PIPELINES:

Aboveground pipes (carbon steel only) are coated with no signs of physical damage or deterioration (weeping fuel, chipping, flaking, or rusting)

Aboveground piping shows signs of fuel stains at joints or fittings

Aboveground piping has chipping or flaking coating or shows evidence of rusting

Aboveground piping shows evidence of fuel leaking

Aboveground piping is exposed fiberglass reinforced plastic (FRP)

Aboveground carbon steel piping is not coated and is rusting OR has physical damage beyond surface blemishes

TELEPHONE SYSTEM:

Telephone jacks are operable

Jacks need minor repairs to work

Existing jacks need major repairs to work

EXTERIOR LIGHTING:

More than 90% is working

75%–90% is working

Less than 75% is working

DRAINAGE: 10 DRAINAGE: 10 DRAINAGE: 10 [ ]

Booklet 15 - Page 6

STORAGE OPERATIONS (QUALITY)

In each row, circle the “Points” next to the description that most closely describes the facility. If a rating element does not apply, check the N/A box for that element and exclude it from the column total.

Drainage is fully operational with no clogs or obstructions

Containment release valves are kept in a closed position and checked for POL sheen before releasing stormwater

Drainage is operational but is clogged or obstructed

Containment release valves exist but are in need of repair.

NOTE: If the valve is seized, it must be seized in the closed position to warrant an Amber rating. A valve frozen in the open position warrants a Red rating.

Drainage is not operational

Containment release valves are kept open at all times to allow stormwater to escape

BERM AREA:

Berm area is impervious and shows no signs of deterioration or damage

Berm area is showing signs of deterioration or damage

Bermed area exists but shows signs of major damage or deterioration, compromising contained area

COMPUTER/LAN SYSTEM:

LAN outlets work reliably

Existing LAN outlets need minor repairs or operate intermittently

Existing LAN outlets need major repairs

OFFICE HVAC (Heating, Ventilation, Air Conditioning):

HVAC is fully operational

Facility office HVAC system is not fully functional

HVAC system is not operable

OFFICE RESTROOMS:

Restrooms in full operable condition

Restrooms show signs of damage or deterioration

Restrooms are NOT operable

COLUMN PAGES 5 THROUGH 6 _______

SUBTOTAL OF POINTS CIRCLED IN THIS

COLUMN PAGES 5 THROUGH 6 ______

COLUMN PAGES 5 THROUGH 6 ______

TOTAL EACH COLOR COLUMN, AND THEN WRITE THE NUMERICAL SCORE OF EACH R/A/G RATING IN OR NEXT TO THE APPROPRIATE BOX ON THE FACILITY WORKSHEET.

Booklet 15 - Page 7

RECEIVING AND ISSUE OPERATIONS (MISSION-FUNCTIONAL)

In each row, circle the “Points” next to the description that most closely describes the facility. If a rating element does not apply, check the N/A box for that element and exclude it from the column total.

HIGH PRIORITY: Points Points Points N/A

CONTAINMENT BERM:

Containment berm encompasses entire Receiving/Issue area

10 CONTAINMENT BERM:

A containment berm exists, but does not enclose the entire Receiving/Issue Area

10 CONTAINMENT BERM:

No spill containment control is installed in facility

TOP LOADING / UNLOADING

FACILITY:

Loading arm, platform, and stairs are installed in facility

10 TOP LOADING / UNLOADING FACILITY:

N/A (No AMBER Condition)

Loading arm, platform, or stairs are NOT installed in facility

BOTTOM LOADING / UNLOADING

FACILITY:

Bottom-loading equipment and high flow gravity & ramp loading & off-loading installed

Bottom-loading equipment and high flow gravity & ramp loading & off-loading equipment meets all facility mission(s) requirements

10 BOTTOM LOADING / UNLOADING

FACILITY:

N/A (No AMBER Condition)

Bottom-loading equipment and high flow gravity & ramp loading & off-loading equipment meets facility mission(s)

Bottom-loading equipment and high flow gravity & ramp loading & off-loading not installed

Bottom-loading equipment and high flow gravity & ramp loading & off-loading equipment do not meet facility mission(s)

OFF-LOADING ACCOMMODATIONS:

Facility accommodates off-loading and issue of bulk POL products

10 OFF-LOADING ACCOMMODATIONS:

Facility does not accommodate off-loading operations without modifications

10 OFF-LOADING ACCOMMODATIONS:

Facility cannot accommodate all facility off-loading mission(s) under any circumstances

GROUNDING ROD:

Grounding rod available for tank trucks

10 GROUNDING ROD:

Grounding rod NOT available for tank trucks

WEIGHING EQUIPMENT:

Calibrated meter or loading weigh station available

10 WEIGHING EQUIPMENT:

Meter/weigh station equipment not calibrated or accurate

Calibration has expired

Facility is NOT equipped with meter/weigh station

MANIFOLD:

Manifolding available to meet all facility fuel transferring missions

10 MANIFOLD:

Manifolding available to meet all facility transferring missions

Manifolding NOT available to meet all facility transferring missions

OFF-LOADING AREA: 6 OFF-LOADING AREA: 6 OFF-LOADING AREA:

Off-loading area is NOT composed of

Booklet 15 - Page 8

RECEIVING AND ISSUE OPERATIONS (MISSION-FUNCTIONAL)

In each row, circle the “Points” next to the description that most closely describes the facility. If a rating element does not apply, check the N/A box for that element and exclude it from the column total.

Off-loading area composed of concrete

N/A [no AMBER condition] concrete

VEHICLE ACCESS ROAD:

Road is circular or wide enough to permit forward movement of all tank trucks

6 VEHICLE ACCESS ROAD:

Road requires widening to permit forward movement of all tank trucks

6 VEHICLE ACCESS ROAD:

Road is unpaved

OCCUPIED BUILDING PROXIMITY:

Occupied buildings at least 50 feet from facility

6 OCCUPIED BUILDING PROXIMITY:

6 OCCUPIED BUILDING PROXIMITY:

Occupied building(s) less than 50 feet from facility

COLUMN PAGES 7 THROUGH 8 _______

SUBTOTAL OF POINTS CIRCLED IN THIS

COLUMN PAGES 7 THROUGH 8 ______

COLUMN PAGES 7 THROUGH 8 ______

TOTAL EACH COLOR COLUMN, AND THEN WRITE THE NUMERICAL SCORE OF EACH R/A/G RATING IN OR NEXT TO THE APPROPRIATE BOX ON THE FACILITY WORKSHEET.

Booklet 15 - Page 9

RECEIVING AND ISSUE OPERATIONS (QUALITY)

In each row, circle the “Points” next to the description that most closely describes the facility. If a rating element does not apply, check the N/A box for that element and exclude it from the column total.

HIGH PRIORITY: Points Points Points N/A

EQUIPMENT HOSE LINES:

Equipment hose lines and fittings are fully functional and show no signs of damage or deterioration

10 EQUIPMENT HOSE LINES:

Equipment hose lines and fittings are fully functional, but show signs of wear, deterioration, or damage

10 EQUIPMENT HOSE LINES:

Equipment hose lines and/or fittings leak

TOP LOADING / UNLOADING

FACILITY:

Loading arm, platform, and stairs are fully functional and show no signs of deterioration or damage

Loading arm, platform, and/or stairs are fully functional, but show signs of deterioration or damage

Loading arm, platform, and/or stairs are deteriorated or damaged to the extent of jeopardizing operations and/or safety

BOTTOM LOADING / UNLOADING

FACILITY:

Bottom-loading equipment and high flow gravity & ramp loading & off-loading equipment meets all facility mission(s) requirements and shows no signs of damage or deterioration

Bottom-loading equipment and high flow gravity & ramp loading & off-loading equipment meets facility mission(s) requirements, but shows signs of damage or deterioration

GROUNDING ROD:

Grounding rod shows no signs of

Grounding rod functional, but shows signs of deterioration or damage

Grounding rod not functional

WEIGHING EQUIPMENT:

Meter/weigh station equipment fully functional and shows no signs of

Meter/weigh station equipment functional but shows signs of deterioration or damage

Meter/weigh station equipment does not function

MANIFOLD:

Manifolding equipment functional with no signs of deterioration or damage

Manifolding equipment functional but shows signs of deterioration or damage

Manifolding equipment deteriorated and/or damaged and not functional

OFF-LOADING AREA:

Off-loading area is level with no large cracks or holes

6 OFF-LOADING AREA:

Off-loading area has cracks, holes, or deflections on no more than 25% of the surface

6 OFF-LOADING AREA:

Off-loading area has cracks, holes, or deflections on more than 25% of the

VEHICLE ACCESS ROAD: 6 VEHICLE ACCESS ROAD: 6 VEHICLE ACCESS ROAD: 6 [ ]

Booklet 15 - Page 10

RECEIVING AND ISSUE OPERATIONS (QUALITY)

In each row, circle the “Points” next to the description that most closely describes the facility. If a rating element does not apply, check the N/A box for that element and exclude it from the column total.

Road has no large cracks or holes

Road has large holes, cracks, or deflections on no more than 25% of the surface

Road has large holes, cracks, or deflections on more than 25% of the

COLUMN PAGES 9 THROUGH 10 _______

SUBTOTAL OF POINTS CIRCLED IN THIS

COLUMN PAGES 9 THROUGH 10 ______

COLUMN PAGES 9 THROUGH 10 ______

TOTAL EACH COLOR COLUMN, AND THEN WRITE THE NUMERICAL SCORE OF EACH R/A/G RATING IN OR NEXT TO THE APPROPRIATE BOX ON THE FACILITY WORKSHEET.

2013 FACILITY WORKSHEET SUPPLEMENT

Use with Booklet 15

BULK FUEL FACILITIES

Facility Number:

Facility Category Group:

Inspector:

Date Completed:

COMPONENT

ELEMENT GREEN AMBER RED N/A

1 (F) Storage Operations

- Spill Container O 10 O 10 O 10 N/A

- Fencing O 10 O 10 O 10 N/A

- Gauging Equipment O 10 O 10 O 10 N/A

- Utility Wires O 10 O 10 O 10 N/A

- Labeling OOOO 10 OOOO 10 OOOO 10 N/A

- Aboveground Storage Tanks OOOOO 10 OOOO 10 OOOOO 10 N/A

- Underground Storage Tanks OOOO 10 OOOO 10 OOOO 10 N/A

- Pipelines OO 10 OO 10 OO 10 N/A

- Telephone System O 10 O 10 O 10 N/A

- Exterior Lighting O 10 O 10 OO 10 N/A

- Drainage OOO 10 OO 10 OOO 10 N/A

- Berm Area O 6 O 6 O 6 N/A

- Computer/Lan System O 6 O 6 O 6 N/A

- Office Hvac (Heating, Ventilation, Air Conditioning) OO 4 OO 4 O 4 N/A

- Landscaping O 4 O 4 O 4 N/A

- Office Restrooms O 4 O 4 O 4 N/A

Mission Functional Totals _____ _____ _____ _____

1 (Q) Storage Operations

- Fencing O 10 O 10 O 10 N/A

- Gauging Equipment O 10 O 10 O 10 N/A

- Aboveground Storage Tanks O 10 O 10 OO 10 N/A

- Underground Storage Tanks OO 10 OO 10 OO 10 N/A

- Pipelines O 10 OO 10 OOO 10 N/A

- Telephone System O 10 O 10 O 10 N/A

- Exterior Lighting O 10 O 10 O 10 N/A

- Drainage OO 10 OO 10 OO 10 N/A

- Berm Area O 6 O 6 O 6 N/A

- Computer/Lan System O 6 O 6 O 6 N/A

- Office Hvac (Heating, Ventilation, Air Conditioning) O 4 O 4 O 4 N/A

- Office Restrooms O 4 O 4 O 4 N/A

Quality Totals _____ _____ _____ _____

2 (F) Receiving And Issue Operations

- Containment Berm O 10 O 10 O 10 N/A

- Top Loading / Unloading Facility O 10 O 10 O 10 N/A

- Bottom Loading / Unloading Facility OO 10 OO 10 OO 10 N/A

- Off-Loading Accommodations O 10 O 10 O 10 N/A

- Grounding Rod O 10 O 10 O 10 N/A

- Weighing Equipment O 10 OO 10 O 10 N/A

- Manifold O 10 O 10 O 10 N/A

- Off-Loading Area O 6 O 6 O 6 N/A

- Vehicle Access Road O 6 O 6 O 6 N/A

- Occupied Building Proximity O 6 O 6 O 6 N/A

Mission Functional Totals _____ _____ _____ _____

2 (Q) Receiving And Issue Operations

- Equipment Hose Lines O 10 O 10 O 10 N/A

- Top Loading / Unloading Facility O 10 O 10 O 10 N/A

- Bottom Loading / Unloading Facility O 10 O 10 O 10 N/A

- Grounding Rod O 10 O 10 O 10 N/A

- Weighing Equipment O 10 O 10 O 10 N/A

- Manifold O 10 O 10 O 10 N/A

- Off-Loading Area O 6 O 6 O 6 N/A

- Vehicle Access Road O 6 O 6 O 6 N/A

Quality Totals _____ _____ _____ _____

COLOR RATING

The use of this worksheet supplement is optional . The inspector may choose to record facility inspection details on here instead of on the rating standards booklet. The "bubbles" allow for recording and determining the component level G/A/R scores. Each G/A/R score must then be recorded on the appropriate Facilty Inspection Worksheet and later used in conjunction with the Component

Calculation Spreadsheet. If filled out, this document along with the specific facility inspection worksheet becomes an audit trail to be retained by the installation IAW AR 210 14.

Notes

Component Rating Calculation

Data Source: ISR Infrastructure FY 2013 (01 October 2013)

Document prepared by ISR-I Support Team helpline_isr@bah.com

Ratings Legends:

Component Rating Breakpoints

Green 1.00 to 1.66

Amber 1.67 to 2.33

Red 2.34 to 3.00

Component Rating Definitions

Green A condition that meets or exceeds the standard.

Amber A condition that is somewhat less than the standard.

Red A condition that is well below the standard.

Component Rating System

Step 1:

Enter Component Rating Scores from Facility Inspection Worksheet into appropriate row and column.

Step 2:

After component color rating is generated by the excel document using the new methodology, enter the corresponding color rating into the Data Input Module.

Notes:

The use of this calculation spreadsheet is required. The inspector must record the Green/Amber/Red numerical score of each component from either the supplemental worksheet or the inspection standard booklets on the specific facility condition assessment worksheet printed from the Data Input Module. Those numerical scores will then be entered into the appropriate row and column on the calculation spreadsheet. The color rating generated using this calculation spreadsheet will then be used as the component color rating to be entered into the Data Input Module. This document, if you so choose, along with the specific facility inspection worksheet, supplemental worksheet or the inspection standard booklet becomes an audit trail to be retained by the installation IAW AR 210 14.

mailto:helpline_isr@bah.commailto:helpline_isr@bah.com

Booklet 15

Facility Number:

Facility Category Group:

Inspector:

Date Completed:

Bulk Fuel Facilities

Compo # Inspection Components Green Amber Red N/A New Rating Green Amber Red N/A New Rating

Compo # Inspection Components Green Amber Red N/A New Rating Green Amber Red N/A New Rating

1 Storage Operations N/A N/A N/A N/A

2 Receiving And Issue Operations N/A N/A N/A N/A image1.jpeg image2.jpeg

Cover

Installation Status Report Affected FCGs

F41100 BULK LIQUID FUEL STORAGE

F41170 LUBRICANT STR

(ISR) - Infrastructure

REVISION DATE: 21 December 2012

FOR USE WITH THE FY 2013 ISR-I DATA COLLECTION

Booklet 15

BULK FUEL FACILITIES

INSPECTION RATING GUIDE

(modernized)

FCG Unit of Measure. BL = Barrels. Refer to Implementing Instructions, Appendix J, for definitions.

Proponents

Deputy Chief of Staff, G-4, DALO-SM (703) 767-0649/DSN 427-0649

(Army Materiel Command, AMCBT-F (703) 806-8724 /DSN 806-8724)

Affected FCGs

*** F41100-BULK LIQUID FUEL STORAGE *** F41170-LUBRICANT STR

Instructions

ISR-I FACILITY INSPECTION INSTRUCTIONS.

First, welcome to the to new and improved Excel version of the ISR Infrastructure Inspection Workbook. This electronic version takes the place of the following paper documents and automates the inspection process.

Optional: -Standard Rating Booklets, are optional and may be used

-Worksheet Supplement

-Component Calculation Worksheet (excel)

-Inspection Worksheet

MACROS: You must enable macros for this workbook, you will need to press the 'Enable Macros' button in a yellow bar across the top of the screen. Additionally, you could add a trusted location, which is a location where you would put trusted files, which run macros without security prompting.

Optional: To add a trusted location: 1.) Click file or windows button in the top left 2.) Click 'Options' > 'Trust Center' (left) > 'Trust Center Settings' (right) > 'Trusted Locations' (left) > 'Add New Location' (bottom) 3.) Browse for folder that you want to be the trusted location (check subfolders, if desired) 4.) Click 'OK' and continue to click 'OK' until back to Excel

The automated workbook will create the inspection worksheet for you and will enable the ISR Inspector to record everything necessary during the inspection. Simply by selecting from a drop down menu by component and element on the 'WB' tab all calculations will be done for you and applied to the Worksheet. The inspector will have seven (7) available options to make, by element with the only additional action being to record the reason an element or component is red.

No entries are possible in this workbook other than on the 'WB' tab in the 'Selection' and 'Red Comments' Fields to make a rating choice and to record a comment for a red rating. Everything else is being done for you automatically and the results applied to the 'Worksheet' tab.

Note: The Component Calculation Spreadsheet used in previous years is not visible but the calculations done on that spreadsheet are also being done here and hidden from view. Meaning the highest point total in a component will not always be the color displayed on the Worksheet.

Note: All required ratings and comments will be highlighted in Orange.

On the 'WB' tab, there are seven (7) available options in the 'Selection' field (column 'K'); these make up the component/element ratings. Below is a list of the seven (7) available options:

Green ------------------------ Meets the description for the rating described in the box of that color.

Amber ----------------------- Meets the description for the rating described in the box of that color.

Red --------------------------- Meets the description for the rating described in the box of that color.

N/A (Component) --------- The entire component is not present and not needed. This selection causes the entire component to gray out and a N/A to be posted on the Worksheet. Any scores recorded for other elements are discarded for that component.

N/A (Element) ------------- Only the element is not present and not needed. This selection causes only the element to gray out and is taken out of the calculation on the Worksheet. All other scores recorded for the component are used in calculating the final rating.

Needed (Component) --- The entire component is not present but needed. This selection causes the entire component to become red and red to be posted to the worksheet. Any scores recorded for other elements are discarded for that component.

Needed (Element) ------- Only the element is not present but needed. This selection causes only the element to red out and is taken out of the calculation on the Worksheet. All other scores recorded for the component are used in calculating the final rating.

Note: One more thing about Red rated elements. The Red comments (column 'L') will turn red for the element when Red is selected for the rating. Evaluators should make a bullet comment why it is red. If no comment is made the Worksheet tab will indicate a comment should be entered on the WB tab. The comments will be recorded in ISR web when the ratings are entered in the ISR system.

New/Overall ratings range, on the 'Worksheet' tab:

Green (1 - 1.669...)

Amber (1.67 - 2.339...)

Red (2.34 - 3)

At the top of the inspection 'Worksheet' tab, fill in the Site UID, Faculty Number, Site Name, UIC of predominant tenant, Inspector name, Inspector phone number, and date completed. Site information may be copied from ISR web for this facility or may be copied from the Inspection Worksheet generated within ISR Web. The system generated inspection worksheet is there for reference only and may optionally be used for local purposes.

Individual element ratings are determining the BEST FIT as it applies to your facility. When evaluating a component consider all space in the facility for that component. If a deficiency can be resolved with a simple self-service supply item (for example, by replacing light bulbs) or with routine maintenance, do not rate that element low simply for that deficiency. Rating a component AMBER (rather than RED) because of disabled-access issues does not imply that the AMBER condition meets applicable standards.

Required: Commander's signature (or designated representative, ie a Facility Operations Specialist -FOS)

Optional: Write comments concerning any facility location issues, such as location of the facility on the installation, proximity to related facilities, and appropriate vehicle access. Continue on the reverse of the inspection worksheet.

Optional: Write a brief comment concerning any environmental, health, safety, and historic preservation issues. Continue on the reverse of the inspection worksheet if needed.

WB

Booklet #: 15 0 Parity Check Max

49 49

Type CompNumber Component Rating Area Element Green Amber Red Notes Points Selection Red Comments Type Insp Num Description Rating Area For Alt Rows Compare Cell above for N/A or Needed Compare Cell below for N/A or Needed Value Other Column Green Amber Red Concatenate Red Comms1 Red Comms Red Comms Row 4L above 4L Below 4L Total Capacity Above Capacity Below Capacity Total

Facility Specific Components 1 Storage Operations F LANDSCAPING No weeds, vegetation, or combustible material within the grounds of the facility Maintained vegetation, weeds, or combustible material within the grounds of the facility Dense vegetation growth or combustible material within the grounds of the facility (blank) 4 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 4

EXTERIOR LIGHTING Provides direct or area lighting for:

- Pedestrian movement

- Security

- Signage

TELEPHONE SYSTEM Sufficient telephone jacks are available to support current mission requirements (such as FAS, public telephone, fuels operator, etc.) Sufficient telephone jacks available to support current mission requirements (such as FAS, public telephone, fuels operator, etc.) Telephone jacks are not available to support current mission requirements (such as FAS, public telephone, fuels operator, etc.) (blank) 10 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 6

COMPUTER/LAN SYSTEM Enough LAN outlets are available to support the Facilities Automated System (FAS) Not enough LAN outlets to support the Facilities Automated System (FAS) LAN outlets are not available to support the Facilities Automated System (FAS) (blank) 6 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 7

SPILL CONTAINER Facility sufficiently supplied with spill containers to meet all facility mission(s) requirements Spill containers are installed but do not have the capacity to meet all facility mission(s) requirements Spill containers are not installed (blank) 10 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 9

FENCING Facility completely surrounded by security fencing Facility completely surrounded by security fencing Facility NOT surrounded by security fencing (blank) 10 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 10

GAUGING EQUIPMENT Proper gauging equipment available to detect fuel leaks and/or water accumulation Proper gauging equipment available to detect fuel leaks and/or water accumulation Proper gauging equipment is NOT available to detect fuel leaks and/or water accumulation (blank) 10 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 11

UTILITY WIRES Utility wires are not located directly overhead of facility Facility has waivers for utility wires directly overhead Facility has overhead wires with no waiver (blank) 10 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 12

LABELING Tanks are properly and completely marked with product identification Pipelines are properly and completely marked with product identification Manifold system on tank fully and properly labeled Labels are easily readable (ex. not faded, not torn, etc.) Tanks are NOT completely marked with product identification Pipelines are NOT completely marked with product identification Manifold system on tank is NOT completely labeled Labels are not easily read (faded, torn, etc.) Tanks are NOT marked with product identification Pipelines are NOT marked with product identification Manifold system on tank is NOT labeled, or;

Facilities are NOT labeled (blank) 10 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 13

ABOVEGROUND STORAGE TANKS Tanks have functional bottom drain (water draw off) system High/Low level alarms and leak detection system API 653 inspection has been previously performed and is current with copy of the report available, and the next inspection is due within the next 10 years Test date is marked on tank Documentation exists verifying tank is not leaking Tank has a non-functional bottom drain (water draw off) system Either High/Low level alarms or leak detection API 653 inspection has been previously performed and is current with a copy of the report available, and the next inspection is due within the next year Documentation does not exist verifying tank is not leaking Tank has visual evidence of physical damage and/or visual signs of fuel stains (weeping) Tank has no bottom drain system Tank has neither High/Low level alarms or leak detection API 653 has not been performed, or the results are not available, or the API 653 inspection is past due Documentation exists verifying tank is leaking (blank) 10 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 14

UNDERGROUND STORAGE TANKS Underground tanks are double-walled (tanks part of aircraft hydrant system can be single-walled) High/Low level alarms and leak detection system Cathodic protection systems for steel tanks are inspected annually with proper documentation available Documentation exists verifying tank is not leaking N/A [No AMBER condition] N/A [No AMBER condition] Cathodic protection systems for steel tanks have not been inspected in the last year and/or are without the proper documentation Documentation does not exist verifying tank is not leaking Underground tanks are NOT double-walled (tanks part of aircraft hydrant system can be single-walled) High/Low level alarms or leak detection system not installed Cathodic protection system for steel tanks is not installed Documentation exists verifying tank is leaking (blank) 10 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 15

Underground pipes do not have Cathodic protection (on corrodible metallic piping only) (blank) 10 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 16

DRAINAGE Sufficient drainage in place to prevent ponding or flooding All drainage within the storage of dispensing area passes through an oil/water separator or drains to a retention pond of a sufficient size Containment release valves are kept in a closed position and checked for POL sheen before releasing stormwater Drainage is installed but is not sufficient to fully prevent ponding or flooding Containment release valves exist but are in need of repair.

NOTE: If the valve is seized, it must be seized in the closed position to warrant an Amber rating. A valve frozen in the open position warrants a Red rating. Drainage is not installed Ground is contaminated by spills/leaks Containment release valves are kept open at all times to allow stormwater to escape (blank) 10 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 17

BERM AREA Berm area is of sufficient size to contain single largest storage release plus sufficient freeboard Berm area is of sufficient size to contain single largest storage release but insufficient freeboard Spill berms are not installed, have no freeboard, or are insufficient to contain single largest storage release (blank) 6 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 18

OFFICE RESTROOMS Restrooms in place for Storage Operations office N/A [No AMBER condition] Restrooms are NOT in place for Storage Operatins office (blank) 4 Facility Specific Components 1 Storage Operations F 1 0 0 0 1F 19

Q EXTERIOR LIGHTING More than 90% is working 75%–90% is working Less than 75% is working (blank) 10 Facility Specific Components 1 Storage Operations Q 1 0 0 0 1Q 20

TELEPHONE SYSTEM Telephone jacks are operable Jacks need minor repairs to work Existing jacks need major repairs to work (blank) 10 Facility Specific Components 1 Storage Operations Q 1 0 0 0 1Q 21

COMPUTER/LAN SYSTEM LAN outlets work reliably Existing LAN outlets need minor repairs or operate intermittently Existing LAN outlets need major repairs (blank) 6 Facility Specific Components 1 Storage Operations Q 1 0 0 0 1Q 22

OFFICE HVAC (Heating, Ventilation, Air Conditioning) HVAC is fully operational Facility office HVAC system is not fully functional HVAC system is not operable (blank) 4 Facility Specific Components 1 Storage Operations Q 1 0 0 0 1Q 23

FENCING Security fencing shows no signs of deterioration, damage, or modification Security fencing functioning but shows signs of deterioration, damage, or modification Security fencing shows signs of deterioration, damage, or modification that hinder its performance (blank) 10 Facility Specific Components 1 Storage Operations Q 1 0 0 0 1Q 24

GAUGING EQUIPMENT Gauging equipment is fully operational with no signs of damage or deterioration Gauging equipment is operational but has signs of damage or deterioration Gauging equipment is not operational (blank) 10 Facility Specific Components 1 Storage Operations Q 1 0 0 0 1Q 25

Aboveground piping is exposed fiberglass reinforced plastic (FRP) Aboveground carbon steel piping is not coated and is rusting OR has physical damage beyond surface blemishes (blank) 10 Facility Specific Components 1 Storage Operations Q 1 0 0 0 1Q 28

Containment release valves exist but are in need of repair.

BERM AREA Berm area is impervious and shows no signs of deterioration or damage Berm area is showing signs of deterioration or damage Bermed area exists but shows signs of major damage or deterioration, compromising contained area (blank) 6 Facility Specific Components 1 Storage Operations Q 1 0 0 0 1Q 30

OFFICE RESTROOMS Restrooms in full operable condition Restrooms show signs of damage or deterioration Restrooms are NOT operable (blank) 4 Facility Specific Components 1 Storage Operations Q 1 0 0 0 1Q 31

2 Receiving And Issue Operations F CONTAINMENT BERM Containment berm encompasses entire Receiving/Issue area A containment berm exists, but does not enclose the entire Receiving/Issue Area No spill containment control is installed in facility (blank) 10 Facility…