Attach 6_MASTER eOMSI WORKBOOK REV 6.xlsx
XLSX spreadsheet 4 MB Posted
- Attached to
- Water Main Repair Wyman Ave
- Solicitation number
- N4008520B2559
About this file
This document contains a facility data matrix and facility data file for a federal contract opportunity to repair water mains on Wyman Avenue. The facility data matrix provides guidance on populating asset information for various building systems in the facility data file. The facility data file then lists individual assets and equipment in the facility, including information like the asset number, description, replacement cost, location, manufacturer, and warranty expiration date. The related federal contract opportunity is solicitation number N4008520B2559 from the Naval Facilities Engineering Command to repair water mains on Wyman Avenue. The opportunity type is a solicitation and responses are due based on the standard solicitation timeline.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attach 2_PNSYDIV1 Specs 152020.pdf | ||
| Attach 5_Drawings.pdf | ||
| Attach 3_Technical Specs.pdf | ||
| Attach 7_PWD ME Water and Sewer Standards.pdf | ||
| Attach 4_Submittal Register.xlsx | XLSX spreadsheet | |
| Attach 1_Bid Form.pdf | ||
| N4008520B2559.pdf | ||
| encl a SOW.pdf |
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
INSTRUCTIONS
MODEL AND FACILITY DATA MATRIX
| MODEL AND FACILITY DATA MATRIX | |||||
| STEP 1: | Is This a BIM Project? | No | Modeling Requirements | Required Facility Asset Fields | |
| STEP 2: | Select Yes or No in Column E for each MASTERSYSTEM, SYSTEM and SUBSYSTEM that is In the Project Scope | DESIGN MODEL | RECORD MODEL |
(AS-BUILT)
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 14 | 15 | 16 | 17 | |||||||||||
| CLASSIFICATION | ||||||||||||||||||||||||||||
| ID | MASTERSYSTEM / SYSTEM / SUBSYSTEM Name | System Type | UOM | In Scope | ||||||||||||||||||||||||
| (Yes or No) | DISCIPLINE | LOD | GRADE | LOD | ||||||||||||||||||||||||
| (AB) | GRADE | AssetNum | Description | Long Description | MASTERSYSTEM | SYSTEM | SUBSYSTEM | Building Number | Asset Quantity | Replacement Cost | Contract Number | Task/Delivery Order Number | Warranty Expiration Date | Installation Date | CLASSIFICATIONID | Room Number | Manufacturer | Model | Serial # | |||||||||
| D40 | D40 - FIRE PROTECTION | MASTERSYSTEM | ● | Yes | ● | ● | ● | ● | ● | |||||||||||||||||||
| D4090 | D4090 - OTHER FIRE PROTECTION SYSTEMS | SYSTEM | ● | Yes | ● | ● | ● | ● | ● | |||||||||||||||||||
| D4090901 | D4090901 - CARBON DIOXIDE EXTINGUISHING SYS | SUBSYSTEM | EA | No | FIRE PROTECTION | 300 | A | A+ | ||||||||||||||||||||
| D4090902 | D4090902 - HOOD FIRE PROTECTION | SUBSYSTEM | EA | No | FIRE PROTECTION | 300 | A | A+ | ||||||||||||||||||||
| D4090903 | D4090903 - BACKFLOW PREVENTER | SUBSYSTEM | EA | No | FIRE PROTECTION | 300 | A | A+ | ||||||||||||||||||||
| D4090904 | D4090904 - FIRE PUMPS | SUBSYSTEM | EA | No | FIRE PROTECTION | 300 | A | A+ | ||||||||||||||||||||
| D4090920 | D4090920 - CLEAN AGENT EXTINGUISHING SYSTEM | SUBSYSTEM | SF | No | FIRE PROTECTION | 300 | A | A+ | ||||||||||||||||||||
| D4020999 | D4020999 - OTHER | EA | Yes | 6" Gate Valves with Post Indicator |
SAMPLE KTR FACILITY DATA FILE
| SAMPLE KTR FACILITY DATA FILE | ||||||||||||||||||||
| Each facility component or piece of equipment will be a new row. Refer to Model & Facility Data Matrix for guidance on which fields are applicable to specific components & equipment. | ||||||||||||||||||||
| Position | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 14 | 15 | 16 | 17 | 18 | |
| Name | AssetNum | Description | Long Description | MASTERSYSTEM | SYSTEM | SUBSYSTEM | Building Number | Asset Quantity | Replacement Cost | Contract Number | Task/Delivery Order Number | Warranty Expiration Date | Installation Date | CLASSIFICATIONID | Room Number | Manufacturer | Model | Serial # | PAY ITEM | |
| Explanation | Asset tag number for MaximoTo be filled in by NAVFAC FOS | Primary Asset Name (100 Character Limit) To be completed by KTR | Additional Relevant Information (e.g. size, capacity, limits, etc…) (1000 Character Limit) To be completed by KTR | Reference values from Model & Facility Data Matrix tab (MASTERSYSTEM) Selected By DOR | Reference values from Model & Facility Data Matrix tab (SYSTEM) Selected By DOR | Reference values from Model & Facility Data Matrix tab (SUBSYSTEM) Selected By DOR | Current Building # in MAXIMO for renovation work. Will be provided by GVT for new construction | To be completed by KTR (Quantity in correct unit of measure as defined in UOM field of the Model & Facility Data Matrix) | Install cost (material and labor) from schedule of values, bid proposal, etc. To be completed by KTR | To be completed by GVT | To be completed by GVT | MM/DD/YYYY | ||||||||
| To be completed by KTR | MM/DD/YYYY | |||||||||||||||||||
| To be completed by KTR | Reference values from Model & Facility Data Matrix tab (SUBITEM) | Location for installed equipment/asset. Include floor & room number. (include equipment tag e.g AHU_1, FANN001) To be completed by KTR | To be completed by KTR | To be completed by KTR | To be completed by KTR | To be completed by KTR | ||||||||||||||
| BA2201638 | FOUNDATIONS, WALL FOOTINGS | A10 - FOUNDATIONS | A1010 - STANDARD FOUNDATIONS | A1010110 - STRIP FOOTINGS | WNY-212 | 552 | $28,704.00 | 3/1/42 | ||||||||||||
| BA2201640 | FOUNDATIONS, STRUCTURAL SLAB ON GRADE | A10 - FOUNDATIONS | A1030 - SLAB ON GRADE | A1030120 - PLAIN/REINFORCED | WNY-212 | 17588 | $105,528.00 | 3/1/42 | ||||||||||||
| BA2201641 | BASEMENT WALL CONSTRUCTION | A20 - BASEMENT CONSTRUCTION | A2020 - BASEMENT WALLS | A2020110 - CIP CONCRETE | WNY-212 | 764 | $48,132.00 | 3/1/42 | ||||||||||||
| BA2201642 | FLOOR CONSTRUCTION, CONCRETE SLAB, PLANK OR PANEL | B10 - SUPERSTRUCTURE | B1010 - FLOOR CONSTRUCTION | B1010220 - CIP CONCRETE BEAM AND SLAB | WNY-212 | 66312 | $1,193,616.00 | 3/1/42 | ||||||||||||
| BA2201644 | WOOD STRUCTURAL FRAME | B10 - SUPERSTRUCTURE | B1020 - ROOF CONSTRUCTION | B1020102 - WOOD DECK AND RAFTER | WNY-212 | 17588 | $471,491.98 | 3/1/70 | ||||||||||||
| BA2201645 | STEEL STRUCTURAL FRAME | B10 - SUPERSTRUCTURE | B1020 - ROOF CONSTRUCTION | B1020108 - STEEL DECK, BEAMS AND BAR JOIST | WNY-212 | 17588 | $257,079.25 | 3/1/70 | ||||||||||||
| BA2201643 | ROOF CONSTRUCTION, CONCRETE STRUCTURAL FRAME | B10 - SUPERSTRUCTURE | B1020 - ROOF CONSTRUCTION | B1020122 - CIP CONCRETE ROOF CONSTRUCTION | WNY-212 | 17588 | $140,704.00 | 3/1/42 | ||||||||||||
| BA2201646 | EXTERIOR WALLS, BRICK | B20 - EXTERIOR ENCLOSURE | B2010 - EXTERIOR WALLS | B2010125 - SOLID BRICK - SINGLE WYTHE | WNY-212 | 567 | $14,175.00 | 3/1/42 | ||||||||||||
| BA2201648 | EXTERIOR WALLS, VINYL SIDING | B20 - EXTERIOR ENCLOSURE | B2010 - EXTERIOR WALLS | B2010148 - WOOD CLADDING W/STUD BACKUP | WNY-212 | 3486 | $49,776.45 | 3/1/90 | ||||||||||||
| BA2201647 | EXTERIOR WALLS, STUCCO | B20 - EXTERIOR ENCLOSURE | B2010 - EXTERIOR WALLS | B2010151 - STUCCO WALL | WNY-212 | 20178 | $322,848.00 | 3/1/80 | ||||||||||||
| BA2201651 | EXTERIOR WINDOWS (BA2201596) | B20 - EXTERIOR ENCLOSURE | B2020 - EXTERIOR GLAZED OPENINGS | B2020102 - WOOD WINDOWS | WNY-212 | 875 | $1,890,436.37 | 3/1/95 | ||||||||||||
| WNY212-01 | EXTERIOR WINDOWS, ALUMINUM | B20 - EXTERIOR ENCLOSURE | B2020 - EXTERIOR GLAZED OPENINGS | B2020106 - ALUMINUM WINDOWS | WNY-212 | 395 | $454,250.00 | 3/1/95 | ||||||||||||
| BA2201653 | DOORS, EXTERIOR METAL DOORS | B20 - EXTERIOR ENCLOSURE | B2030 - EXTERIOR DOORS | B2030220 - STEEL DOORS | WNY-212 | 4 | $6,000.00 | 3/1/42 | ||||||||||||
| BA2201654 | ROOF, BUILT UP | B30 - ROOFING | B3010 - ROOF COVERING | B3010105 - BUILT-UP | WNY-212 | 16805 | $168,050.00 | 3/1/80 | ||||||||||||
| BA2201657 | INTERIOR PARTITIONS - CMU WALLS | C10 - INTERIOR CONSTRUCTION | C1010 - PARTITIONS | C1010102 - CONCRETE BLOCK | WNY-212 | 5376 | $69,888.00 | 3/1/42 | ||||||||||||
| BA2201655 | INTERIOR PARTITIONS - FRAMED WALLS | C10 - INTERIOR CONSTRUCTION | C1010 - PARTITIONS | C1010126 - DRYWALL W/STUD FRAMING | WNY-212 | 52656 | $315,936.00 | 3/1/00 | ||||||||||||
| BA2201660 | DOORS, INTERIOR METAL | C10 - INTERIOR CONSTRUCTION | C1020 - INTERIOR DOORS | C1020114 - METAL DOOR | WNY-212 | 59 | $15,367.68 | 3/1/42 | ||||||||||||
| BA2201659 | DOORS, INTERIOR WOOD | C10 - INTERIOR CONSTRUCTION | C1020 - INTERIOR DOORS | C1020120 - WOOD DOOR/WOOD FRAME | WNY-212 | 105 | $81,574.31 | 3/1/03 | ||||||||||||
| BA2201661 | DOORS, INTERIOR GLAZED | C10 - INTERIOR CONSTRUCTION | C1020 - INTERIOR DOORS | C1020120 - WOOD DOOR/WOOD FRAME | WNY-212 | 4 | $8,141.34 | 3/1/03 | ||||||||||||
| WNY212-02 | WALL FINISHES, WALL COVERINGS | C30 - INTERIOR FINISHES | C3010 - WALL FINISHES | C3010230 - WALL COVERING | WNY-212 | 4751 | $23,755.00 | 3/1/02 | ||||||||||||
| WNY212-03 | WALL FINISHES, TILE | C30 - INTERIOR FINISHES | C3010 - WALL FINISHES | C3010380 - WALL TILE | WNY-212 | 4953 | $59,436.00 | 3/1/02 | ||||||||||||
| BA2201667 | FLOORING, CARPET | C30 - INTERIOR FINISHES | C3020 - FLOORING | C3020901 - CARPET | WNY-212 | 66960 | $334,800.00 | 3/1/02 | ||||||||||||
| BA2201666 | FLOORING, RESILIENT | C30 - INTERIOR FINISHES | C3020 - FLOORING | C3020903 - COMPOSITION SHEET | WNY-212 | 1390 | $4,170.00 | 3/1/02 | ||||||||||||
| BA2201665 | FLOORING, TILE | C30 - INTERIOR FINISHES | C3020 - FLOORING | C3020910 - PORCELAIN TILE | WNY-212 | 2637 | $23,733.00 | 3/1/00 | ||||||||||||
| BA2201668 | CEILING, DRYWALL / GYPSUM BOARD | C30 - INTERIOR FINISHES | C3030 - CEILING FINISHES | C3030110 - DRYWALL | WNY-212 | 2700 | $13,500.00 | 3/1/02 | ||||||||||||
| BA2201669 | CEILING, TILE | C30 - INTERIOR FINISHES | C3030 - CEILING FINISHES | C3030210 - ACOUSTICAL | WNY-212 | 52201 | $313,206.00 | 3/1/42 | ||||||||||||
| BAN000003999 | PASSENGER ELEVATORS | D10 - CONVEYING | D1010 - ELEVATORS AND LIFTS | D1010110 - HYDRAULIC ELEVATORS | WNY-212 | 1 | $86,362.49 | 3/1/00 | ||||||||||||
| BAN000003999 | PASSENGER ELEVATORS | D10 - CONVEYING | D1010 - ELEVATORS AND LIFTS | D1010110 - HYDRAULIC ELEVATORS | WNY-212 | 1 | $86,362.49 | 3/1/00 | ||||||||||||
| BANC000020052 | PASSENGER ELEVATORS | TENSION GEARED | D10 - CONVEYING | D1010 - ELEVATORS AND LIFTS | D1010110 - HYDRAULIC ELEVATORS | WNY-212 | 1 | $140,000.00 | 3/1/00 | |||||||||||
| CONV001W212 | CONVERTER | D30 - HVAC | D3020 - HEAT GENERATING SYSTEMS | D3020999 - OTHER | WNY-212 | 1 | $2,345.00 | 3/1/92 | 1ST FL MER | BELL AND GOSSETT | SU-127-2 | 125693 | ||||||||
| CONV002W212 | Cooling Generating Systems,Condenser, DX, Air Cooled,Direct Drive, 5 ton, R-22 | D30 - HVAC | D3020 - HEAT GENERATING SYSTEMS | D3020999 - OTHER | WNY-212 | 1 | $1,875.00 | 3/1/92 | 1ST FL MER | AMTROL, INC. | S8842A | 25281 | ||||||||
| CHIL004W212 | CHILLER, RECIP AIR COOLED - ROOF | D30 - HVAC | D3030 - COOLING GENERATING SYSTEMS | D3030135 - CHILLER, RECIP, AIR COOLED | WNY-212 | 1 | $53,000.00 | 3/1/96 | D30301351010 - 20 TN | ROOF | CARRIER | 30GXR249A540KA | 1902F52592 | |||||||
| COND003W212 | CONDENSER, DX, AIR COOLED | D30 - HVAC | D3030 - COOLING GENERATING SYSTEMS | D3030901 - CONDENSER, DX, AIR COOLED | WNY-212 | 1 | $8,268.75 | 3/1/06 | D30309010220 - Belt Drive, 45 ton, R-22 | W ROOF | LENNOX | PFG10 | T04E00710 |
DRAFT DRAFT
KTR FACILITY DATA FILE
| KTR FACILITY DATA FILE | ||||||||||||||||||||
| Each facility component or piece of equipment will be a new row. Refer to Model & Facility Data Matrix for guidance on which fields are applicable to specific components & equipment. | ||||||||||||||||||||
| USE UPPER CASE TO FILL OUT DATA FILE | ||||||||||||||||||||
| Position | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | |
| Name | Asset Num | Description | Long Description | MASTER SYSTEM | SYSTEM | SUBSYSTEM | Building Number | Asset Quantity | Replacement Cost | Contract Number | Task/ Delivery Order Number | Warranty Expiration Date | Installation Date | CLASSIFICATIONID | Room Number | Manufacturer | Model | Serial # | PAY ITEM | |
| Explanation | Asset tag number for MaximoTo be filled in by NAVFAC FOS | Primary Asset Name (100 Character Limit) To be completed by DOR | Additional Relevant Information (e.g. size, capacity, limits, etc…) (1000 Character Limit) To be completed by KTR | Reference values from Model & Facility Data Matrix tab (SYSTEM) Selected By DOR | Reference values from Model & Facility Data Matrix tab (SUBSYSTEM) Selected By DOR | MAXIMO building number provided by DOR (Any questions ask FOS) | To be completed by DOR (refer to Model & Facility Data Matrix, Field) Can be edited by KTR for changes during project | Install cost (material and labor) from schedule of values, bid proposal, etc. To be completed by KTR | To be completed by GVT | To be completed by GVT | MM/DD/YYYY | |||||||||
| To be completed by KTR | MM/DD/YYYY | |||||||||||||||||||
| To be completed by KTR | Reference values from Model & Facility Data Matrix tab (SUBITEM) | Location for installed equipment/asset. Include floor & room number. (include equipment tag e.g AHU_1, FANN001) To be completed by KTR | To be completed by KTR | To be completed by KTR | To be completed by KTR | To be completed by KTR | ||||||||||||||
| EXAMPLE | K000000 | CONDENSING UNIT, AIR COOLED | ACCU-3A SERVES HP-24 / HP-25 | D30 - HVAC | D3030 - COOLING GENERATING SYSTEMS | D3030221 - CONDENSING UNIT, AIR COOLED | PNSY-59 | 1 | $5,000 | N40085-16-C-9329 | 2/1/19 | 2/1/18 | D3030221 | OUTDOOR PAD 1ST SET FROM STAIRS | ||||||
| , ACCU-3B | FUJITSU | AOUA120TLCVG | TNN000034 |
image1.emf image2.emf
File details come from the government source that posted it. Updated .