Spreadsheet: 264247d1378828527-extracting-and-sorting-data-from-source-worksheet-excel-2003-top-5-autosort-revised
Sheet: Component Codes

Facility Component Codes
Code | Bldg/Fac | Group | Subgroup | Code Description | Com Points
01A | B | Architecture | Asbestos | Asbestos Abatement/Encapulation (roofs, floors, piping, walls) | 7
01B | B | Architecture | Lead/Contaminants | Lead paint Abatement/Encapsulation (walls, [NAME], railings, piping, towers, equipment) | 7
02A | U | Site Work | Gas Distribution | Distribution system (piping, regulators, valves, supports, meters) | 9
02B | U | Site Work | Sewage Treatment | Sewage Treatment Plants (all components) | 9
02C | U | Site Work | Sewage Collection | Sewage collection systems (piping, manholes, lift-stations, pumps, cleanouts) | 7
02D | U | Site Work | Water Systems | Storage/Treatment/distribution (filters, chlorinators, piping, hydrants, pumps, valves, tanks) | 9
02E | S | Site Work | Pavements-Primary | Pavements - Primary (paved surface, seal coat, base course, subbase, subgrade) | 6
02F | S | Site Work | Pavements-Secondary | Pavements - Secondary (improved/unimproved, sidewalks, curbs, gutters) | 3
02G | S | Site Work | Railroad | All components (track, ballast, switched, signals, ties, crossings, docks, ramps) | 1
02H | S | Site Work | Security/Safety | Physical Security/safety (barricades, fencing, gates, guardrails, traffic signals) | 8
02I | S | Site Work | Miscellaneous | Miscellaneous (landscaping, grading, signage, markings, retaining walls, flagpoles) | 1
02J | S | Site Work | Storm Drainage | Runoff drainage system (collection ponds, manholes, piping, pumps, valves, culverts, ditches, channels, headwalls) | 5
02K | S | Site Work | Fuel Containment Systems | Runoff contaiment systems (Dikes, berms, oil-water filters/separators, etc) | 8
02L | S | Site Work | Fuel Distribution | Fuel pipelines, valves, pumps, controls, filters/separators | 8
02M | S | Site Work | Fuel Storage | Fuel Storage tanks, USTs, ASTs | 9
02N | S | Site Work | [NAME] | Fuel transfer/dispensing (loading/unloading/transfer/dispensing) | 8
02P | S | Site Work | Other Fuel System | Other fuel storage (propane tanks, CNG, etc) | 8
02Q | S | Site Work | Protection System | Cathodic protection for tanks, pipelines, etc | 9
02R | S | Site Work | Dredging | Dredging | 8
02S | S | Site Work | Structural | Piers, wharfs, mooring buoys | 10
02T | S | Site Work | Non-Structural | Piers, wharfs, mooring buoys | 8
05A | B | Architecture | Structural | Structural (load bearing components, foundations, walls, columns, trusses, floors, docks, loading, ramps, stairs) | 10
07A | B | Architecture | Exterior Primary | Exteriors (non-load bearing walls, doors, windows, fascia, screens, day gates, ladders, wall insulation) | 8
07B | B | Architecture | Exterior Secondary | Exterior finishes (paint, siding, sealants) | 5
07C | B | Architecture | Roofs-Primary | Roof membrane, insulation, decking | 10
07D | B | Architecture | Roofs-Secondary | Other components (gutters, downspouts, flashing, skylights, vents, curbs, parapets) | 8
09A | B | Architecture | Interior Primary | Interior (walls, ceilings, doors, floor coverings, windows, blinds, trim, weather curtains) | 4
09B | B | Architecture | Interior Secondary | Interior finishes (paint, paneling, wall coverings, wall tile, floor sealants, coatings) | 3
10A | B | Architecture | Built-In Cabinetry | Built-Ins (cabinetry, counters, appurtenances) | 2
11A | B | Architecture | Installed Equipment | Installed Equipment-Real property (cargo elevators, cargo lifts, hoists, cranes, dock levelers, bumpers) | 6
11B | E | Special Equipment | Fuel Systems | All Fuel transfer, dispensing equipment (Personal Property) | 10
11C | E | Special Equipment | Fuel Monitor System | Fuel leak detection, tank alarm systems (Personal Property) | 8
11D | E | Special Equipment | Security System | intrusion Detection Systems (Personal Property) | 6
11E | E | Special Equipment | Terminal Automation | Terminal Automation (Personal Property) | 7
11F | E | Special Equipment | Fuel Lab | Fuel Lab Equipment (Personal Property) | 6
14A | B | Architecture | ADA Compliance | ADA Compliance (ramps, lifts, elevators, railings, fixtures, access, notification) | 7
15A | B | Mechanical | Fire Suppression | Suppression systems (sprinkler piping, heads, valves, pumps, switches, compressors, connections) | 9
15B | B | Mechanical | HVAC-Major | Major systems (chillers, cooling towers, boilers, tanks, AHU, distribution piping) | 8
15C | B | Mechanical | HVAC-Minor | Minor systems (controls, grills, coils, registers, ductwork, small A/C units) | 5
15D | B | Mechanical | HVAC-Ventilation | Ventilation systems (motors, fans, louvers, dampers, controls, hoods) | 4
15E | B | Mechanical | Interior Plumbing | Fixtures, piping, faucets, water heaters, traps, vents, drains, showers | 6
15F | U | Mechanical | Heat Plants | Central Plants (generators, boilers, piping, pumps, conveyors, converters, controls, stacks) | 10
15G | U | Mechanical | Heat Distribution | Major distribution systems (piping, supports, manholes, pits, valves, exchangers, tunnels, steam, HTW) | 8
16A | B | Electrical | Interior | Building Interior (conduit, wiring, switches, panels, lighting-all types, receptacles) | 8
16B | B | Electrical | Fire Alarms | Alarm system (alarm panels, detectors, pull stations, controls, wiring, transmitters/receivers) | 9
16C | U | Electrical | Primary Distribution | Exterior Substations, poles, wiring, switches, transformers, generators, metal-clad gear | 9
16D | U | Electrical | Secondary Distribution | Exterior lighting, poles, fixtures, wiring | 5
17A | B | Renovation | New Facility/Renovation | NEW FACILITY - Major Renovation or Rehabilitation (all types) | 9