Appendix C1 - Connections List - Annual Survey Report.xlsx

This file is an Excel spreadsheet containing a comprehensive master list and annual survey report of backflow prevention devices across Fairchild Air Force Base (FAFB) and contractor-maintained facilities. The spreadsheet tracks approximately 625 total devices, including 502.5 active installations, with detailed information on each device including building location, serial number, manufacturer, model type, size, testing status, hazard classification (AOI, FIRE, IRR, PREMISE), operational status, test dates, operator names, and maintenance notes. The data reveals that 429 devices have been tested with an 85.37% completion rate, while 73.5 devices remain untested. Device manufacturers include Wilkins, Febco, Watts, Ames, and others, with backflow types classified as DC (double check), RP (reduced pressure), PVB (pressure vacuum breaker), DCDA, and SVB configurations.

The survey encompasses devices across military buildings numbered from 0001 through 9010, as well as contractor-maintained facilities at schools, housing areas, and clinics. Testing data includes checkvalve readings (CV1 and CV2 metrics), relief/population data, repair and replacement history, and isolation status notes. A separate contractor dataset covers approximately 79.5 devices at facilities including Michael Anderson School, FAFB Housing, Alaska Boiler locations, and clinic facilities. The spreadsheet includes summary statistics by device type and location, operator rosters with technician names and BAT (Backflow Assembly Tester) numbers, and a color-coded tracking system indicating tested devices (green), devices requiring removal (red), isolated devices (blue), and untested devices (black). Notably, multiple devices are marked as isolated, removed, or out of service, with several irrigation and premise devices deactivated seasonally or permanently.