Attachment 7 -Sioux Falls Inventory of Outlets.xlsx
XLSX spreadsheet 25 KB Posted
- Solicitation number
- 47PJ0025R0014
About this file
This file is an Excel inventory spreadsheet detailing water outlets and fixtures at the U.S. Courthouse in Sioux Falls, SD. The inventory catalogs 75 water sampling points throughout the facility, including 29 bathroom sinks, 12 kitchenette sinks, 5 drinking fountains, 8 bottle fillers, 3 hot water storage tanks, 3 expansion tanks, multiple hot water risers serving janitor mop sinks, 2 showers, and 3 cooling tower connections. Each fixture is identified by room location, sample number, equipment type (using a defined key), and whether it uses cold water (CW), hot water (HW), or both.
The inventory appears to be supporting documentation for a solicitation to install a digital water mixing valve on the domestic hot water system at this courthouse. The spreadsheet includes detailed location identifiers for all water outlets and provides a comprehensive mapping of the building's water distribution system across multiple floors (basement, 1st, 2nd, and 3rd floors, and roof).
View the file
Other files
Show all 11
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Inventory of Outlets
| Date | Label | Room/Location | Sample # | Equipment | |
| Type | Sample | ||||
| Category | Faucet Descriptor | Aerator/Filter |
(Y/N)
| RmFoyer-POE1 | Point of Entry | 1 | POE | CW |
| RmFoyer-POE2 | Point of Entry | 2 | POE | CW |
| RmB13-SK | Bathroom Sink #1 | 3 | SK | CW and HW |
| RmB20-SK | Bathroom Sink #2 | 4 | SK | CW and HW |
| Rm120-SK1 | Bathroom Sink #3 | 5 | SK | CW and HW |
| Rm120-SK2 | Bathroom Sink #4 | 6 | SK | CW and HW |
| Rm120-SK3 | Bathroom Sink #5 | 7 | SK | CW and HW |
| Rm122-SK1 | Bathroom Sink #6 | 8 | SK | CW and HW |
| Rm122-SK2 | Bathroom Sink #7 | 9 | SK | CW and HW |
| Rm122-SK3 | Bathroom Sink #8 | 10 | SK | CW and HW |
| Rm124D-SK | Bathroom Sink #9 | 11 | SK | CW and HW |
| Rm124C-SK | Bathroom Sink #10 | 12 | SK | CW and HW |
| Rm217-SK | Bathroom Sink #11 | 13 | SK | CW and HW |
| Rm207-SK1 | Bathroom Sink #12 | 14 | SK | CW and HW |
| Rm207-SK2 | Bathroom Sink #13 | 15 | SK | CW and HW |
| Rm206D-SK | Bathroom Sink #14 | 16 | SK | CW and HW |
| Rm206E-SK | Bathroom Sink #15 | 17 | SK | CW and HW |
| Rm202B-SK | Bathroom Sink #16 | 18 | SK | CW and HW |
| Rm210C-SK | Bathroom Sink #17 | 19 | SK | CW and HW |
| Rm218A-SK | Bathroom Sink #18 | 20 | SK | CW and HW |
| Rm218B-SK | Bathroom Sink #19 | 21 | SK | CW and HW |
| Rm303B -SK | Bathroom Sink #20 | 22 | SK | CW and HW |
| Rm306-SK1 | Bathroom Sink #21 | 23 | SK | CW and HW |
| Rm306-SK2 | Bathroom Sink #22 | 24 | SK | CW and HW |
| Rm306-SK3 | Bathroom Sink #23 | 25 | SK | CW and HW |
| Rm307-A-SK | Bathroom Sink #24 | 26 | SK | CW and HW |
| Rm311-A-SK | Bathroom Sink #25 | 27 | SK | CW and HW |
| Rm400-SK | Bathroom Sink #26 | 28 | SK | CW and HW |
| RmB20A-SK | Bathroom Sink #27 | 29 | SK | CW and HW |
| Rm111-SK | Bathroom Sink #28 | 30 | SK | CW and HW |
| Rm127-SK | Bathroom Sink #29 | 31 | SK | CW and HW |
| Rm231-SK | Kitchenette Sink #1 | 32 | SK | CW and HW |
| RmB19C-SK | Kitchenette Sink #2 | 33 | SK | CW and HW |
| RmB28C-SK | Kitchenette Sink #3 | 34 | SK | CW and HW |
| RmB18-SK | Kitchenette Sink #4 PROCESING | 35 | SK | CW and HW |
| Rm124B-SK | Kitchenette Sink #5 | 36 | SK | CW and HW |
| Rm115-SK | Kitchenette Sink #6 | 37 | SK | CW and HW |
| Rm119-SK | Kitchenette Sink #7 | 38 | SK | CW and HW |
| Rm222D-SK | Kitchenette Sink #8 | 39 | SK | CW and HW |
| Rm216-SK | Kitchenette Sink #9 | 40 | SK | CW and HW |
| Rm206-SK | Kitchenette Sink #10 | 41 | SK | CW and HW |
| Rm232-C | Kitchenette Sink #11 | |||
| Rm315-SK | Kitchenette Sink #11 | 42 | SK | CW and HW |
| Rm233-SK | Kitchenette Sink #12 | 43 | SK | CW and HW |
| RmB22-DF1 | Drinking Fountain #1 | 44 | DF | CW |
| RmFloor1-DF1 | Drinking Fountain #2 | 45 | DF | CW |
| RmFloor2-DF1 | Drinking Fountain #3 | 46 | DF | CW |
| RmFloor2-DF2 | Drinking Fountain #4 | 47 | DF | CW |
| RmFloor3-DF1 | Drinking Fountain #5 | 48 | DF | CW |
| RmB22-DF2 | Bottle Filler #1 | 49 | DF | CW |
| RmFloor1-DF2 | Bottle Filler #2 | 50 | DF | CW |
| RmFloor2-DF3 | Bottle Filler #3 (RM 215) | 51 | DF | CW |
| RmFloor2-DF4 | Bottle Filler #4 (RM 232) | 52 | DF | CW |
| RmFloor3-DF2 | Bottle Filler #5 | 53 | DF | CW |
| Bottle Filler #6 | 54 | DF | CW | |
| Bottle Filler #7 | 55 | DF | CW | |
| Bottle Filler #8 | 56 | DF | CW | |
| RmBasement-HWST1 | Storage Tank #1 | 57 | HWST | HW |
| RmBasement-HWST2 | Storage Tank #2 | 58 | HWST | HW |
| RmBasement-HWST3 | Storage Tank #3 | 59 | HWST | HW |
| RmBasement-EXT1 | Expansion Tank #1 | 60 | EXT | |
| RmBasement-EXT2 | Expansion Tank #2 | 61 | EXT | |
| RmBasement-EXT3 | Expansion Tank #3 | 62 | EXT | |
| RmB5A-WH | HW Riser #1 Janitor Mop Sink | |||
| RmB29B-WH | HW Riser #1 Janitor Mop Sink | 63 | WH | HW |
| RmB37-WH | HW Riser #2 Janitor Mop Sink | 64 | WH | HW |
| Rm113-WH | HW Riser #3 Janitor Mop Sink | 65 | WH | HW |
| Rm207-WH | HW Riser #4 Janitor Mop Sink | 66 | WH | HW |
| Rm306- | HW Riser #4 Janitor Mop Sink | |||
| RmB20-WH | Shower #1 | 67 | WH | HW |
| Rm119-WH | Shower #2 | 68 | WH | HW |
| 69 | ||||
| 70 | ||||
| RmRoof-CT1 | Cooling Tower #1- Make Up Line | 71 | CT | CT |
| RmRoof-CT2 | Cooling Tower #1- Cell | 72 | CT | CT |
| RmRoof-CT3 | Cooling Tower #2- Cell | 73 | CT | CT |
| 74 | ||||
| 75 |
Sheet1
| RmFoyer | POE1 | - | RmFoyer-POE1 | ||
| RmFoyer | POE2 | - | RmFoyer-POE2 | ||
| RmB | 13 | SK | - | RmB13-SK | RmB13-SK |
| RmB | 20 | SK | - | RmB20-SK | RmB20-SK |
| Rm120 | SK1 | - | Rm120-SK1 | ||
| Rm120 | SK2 | - | Rm120-SK2 | ||
| Rm120 | SK3 | - | Rm120-SK3 | ||
| Rm122 | SK1 | - | Rm122-SK1 | ||
| Rm122 | SK2 | - | Rm122-SK2 | ||
| Rm122 | SK3 | - | Rm122-SK3 | ||
| Rm124 | D | SK | - | Rm124D-SK | Rm124D-SK |
| Rm124 | C | SK | - | Rm124C-SK | Rm124C-SK |
| Rm217 | SK | - | Rm217-SK | ||
| Rm207 | SK1 | - | Rm207-SK1 | ||
| Rm207 | SK2 | - | Rm207-SK2 | ||
| Rm206 | D | SK | - | Rm206D-SK | Rm206D-SK |
| Rm206 | E | SK | - | Rm206E-SK | Rm206E-SK |
| Rm202 | B | SK | - | Rm202B-SK | Rm202B-SK |
| Rm210 | C | SK | - | Rm210C-SK | Rm210C-SK |
| Rm218 | A | SK | - | Rm218A-SK | Rm218A-SK |
| Rm218 | B | SK | - | Rm218B-SK | Rm218B-SK |
| Rm303 | B | SK | - | Rm303B -SK | Rm303B -SK |
| Rm306 | SK1 | - | Rm306-SK1 | ||
| Rm306 | SK2 | - | Rm306-SK2 | ||
| Rm306 | SK3 | - | Rm306-SK3 | ||
| Rm307 | A | SK | - | Rm307-A-SK | |
| Rm311 | A | SK | - | Rm311-A-SK | |
| Rm400 | SK | - | Rm400-SK | ||
| RmB20A | SK | - | RmB20A-SK | ||
| Rm111 | SK | - | Rm111-SK | ||
| Rm127 | SK | - | Rm127-SK | ||
| Rm231 | SK | - | Rm231-SK | ||
| RmB | 19C | SK | - | RmB19C-SK | RmB19C-SK |
| RmB | 28C | SK | - | RmB28C-SK | RmB28C-SK |
| RmB | 18 | SK | - | RmB18-SK | RmB18-SK |
| Rm124B | SK | - | Rm124B-SK | ||
| Rm115 | SK | - | Rm115-SK | ||
| Rm119 | SK | - | Rm119-SK | ||
| Rm222 | D | SK | - | Rm222D-SK | Rm222D-SK |
| Rm216 | SK | - | Rm216-SK | ||
| Rm206 | SK | - | Rm206-SK | ||
| Rm232 | C | - | Rm232-C | ||
| Rm315 | SK | - | Rm315-SK | ||
| Rm233 | SK | - | Rm233-SK | ||
| RmB | 22 | DF1 | - | RmB22-DF1 | RmB22-DF1 |
| Rm1 st Floor | DF1 | - | RmFloor1-DF1 | ||
| Rm2nd Floor | DF1 | - | RmFloor2-DF1 | ||
| Rm2nd Floor | DF2 | - | RmFloor2-DF2 | ||
| Rm3rd Floor | DF1 | - | RmFloor3-DF1 | ||
| RmB | 22 | DF2 | - | RmB22-DF2 | RmB22-DF2 |
| Rm1 st Floor | DF2 | - | RmFloor1-DF2 | ||
| Rm2nd Floor | DF3 | - | RmFloor2-DF3 | ||
| Rm2nd Floor | DF4 | - | RmFloor2-DF4 | ||
| Rm3rd Floor | DF2 | - | RmFloor3-DF2 | ||
| - | |||||
| - | |||||
| - | |||||
| RmBasement | HWST1 | - | RmBasement-HWST1 | ||
| RmBasement | HWST2 | - | RmBasement-HWST2 | ||
| RmBasement | HWST3 | - | RmBasement-HWST3 | ||
| RmBasment | EXT1 | - | RmBasement-EXT1 | ||
| RmBasment | EXT2 | - | RmBasement-EXT2 | ||
| RmBasment | EXT3 | - | RmBasement-EXT3 | ||
| RmB | 0.2083333333 | WH | - | RmB5A-WH | |
| RmB | 29 B | WH | - | RmB29B-WH | |
| RmB | 37 | WH | - | RmB37-WH | |
| Rm113 | WH | - | Rm113-WH | ||
| Rm207 | WH | - | Rm207-WH | ||
| Rm306 | - | Rm306- | |||
| RmB | 20 | WH | - | RmB20-WH | |
| Rm119 | WH | - | Rm119-WH | ||
| - | |||||
| - | |||||
| RmRoof | CT1 | - | RmRoof-CT1 | ||
| RmRoof | CT2 | - | RmRoof-CT2 | ||
| RmRoof | CT3 | - | RmRoof-CT3 |
Equipment Type Key
| Equipment Type | |
| SK | Sink |
| SHD | Showerhead |
| SHW | Shower hose with wand |
| IM | Ice machine |
| WH | Water heater |
| HWR | Hot water return |
| POE | Point of entry CW |
| CT | Cooling tower |
| WD | Water dispenser |
| DF | Drinking fountain |
| CWST | Domestic cold water storage tank |
| HWST | Domestic hot water storage tank |
| EXT | Expansion Tanks |
| DECFNT | Decorative Fountain |
| WH | Water Heater |
| HUMID | Humidifier |
| MIST | Mister |
| OTHER | Other |
| Sink Fixture Descriptor | |
| GN | Gooseneck |
| FF | Flat faucet |
| EF | Electronic faucet |
| Water Type | |
| HW | Hot Water |
| CW | Cold Water |
| MX | Mixed Hot/Cold |
| CW and HW | Hot and Cold Water |
| CT | Cooling Tower |
| Aerator | |
| AY | Aerator - YES |
| AN | Aerator - NO |
| FY | Filter - YES |
| FN | Filter - NO |
Dropdowns
| Equipment Type | Sink Fixture Descriptor | Aerator | |||
| SK | Sink | GN | Gooseneck | AY | Aerator - YES |
| SHD | Showerhead | FF | Flat faucet | AN | Aerator - NO |
| SHW | Shower hose with wand | EF | Electronic faucet | FY | Filter - YES |
| IM | Ice machine | FN | Filter - NO | ||
| WH | Water heater | ||||
| HWR | Hot water return | ||||
| POE | Point of entry CW | ||||
| CT | Cooling tower | Water Type | |||
| WD | Water dispenser | HW | Hot Water | ||
| DF | Drinking fountain | CW | Cold Water | ||
| CWST | Domestic cold water storage tank | MX | Mixed Hot/Cold | ||
| HWST | Domestic hot water storage tank | CW and HW | Hot and Cold Water | ||
| EXT | Expansion Tanks | CT | Cooling Tower | ||
| DECFNT | Decorative Fountain | ||||
| WH | Water Heater | ||||
| HUMID | Humidifier | ||||
| MIST | Mister | ||||
| OTHER | Other |
File details come from the government source that posted it. Updated .