A01.13_Technical_Exhibit_4_Crane_Maintenance_PWS_Data-Entry_Spreadsheet_rev_Fin___.xlsx

New Asset List

u4pwzrcm: u4pwzrcm:

Parent – The name of the building or building number the asset is located at or installed in and associated asset. The parent can also be the system that a component is an integral part. FEM Asset # / Building # FEM Description Level1 - System u4pwzrcm: u4pwzrcm:

You will populate with the Equipment Mapper as you develop the asset inventory. Select the proper description from the Builder Drop-down catalog. Level2 - Component u4pwzrcm: u4pwzrcm:

You will populate with the Equipment Mapper as you develop the asset inventory. Select the proper description from the Builder Drop-down catalog. Level3 - Mat_Cat u4pwzrcm: u4pwzrcm:

You will populate with the Equipment Mapper as you develop the asset inventory. Select the proper description from the Builder Drop-down catalog. Level4 - Comp_Type u4pwzrcm: u4pwzrcm:

You will populate with the Equipment Mapper as you develop the asset inventory. Select the proper description from the Builder Drop-down catalog. Need New Level 4 Comp_Type Description added to the UniFormat, list specifications of new Comp_Type description Here Unit Number u4pwzrcm: u4pwzrcm:

the unit number is the number of units found in a top asset. I.e. 1 through 30 fan coils found in a building. Or Boiler 1 and Boiler 2 found in a building. etc Grid and Section Number By Floor (auto populates) Select Floor # Floor Make a selection By Room (auto populates) Room Make a selection Room Free text By Wing (auto populates) Wing free text u4pwzrcm: u4pwzrcm:

this needs a free test option plus and cardinal direction pick list Wing Make a selection By Bay (auto populates) Bay Make a selection Bay free text u4pwzrcm: u4pwzrcm:

this needs a free test option plus and cardinal direction pick list By Cardinal Direction By Space Type By Roof Section (auto populates) Roof Section Make a selection Roof Section (free text by roof plan section) u4pwzrcm: u4pwzrcm:

this needs a free test option plus and cardinal direction pick list Physical Location (auto populates)

T0ULARBW: T0ULARBW:

Is the physical and/or geographical location that the items is being stored, installed or used to support the mission. (Exp. Bldg. C1 Mech. Room) New FEM UniqueIdentifier New FEM Asset Name Legacy UniqueIdentifier Legacy ASSET NAME/DESCRIPTION

T0ULARBW: T0ULARBW:

Is the common name or descriptive name. TMDE

T0ULARBW: T0ULARBW:

Enter Y for yes if the asset requires calibration and N for no if it does not. See the attachment INSTRUCTIONS AND DEFINITIONS for more information. Asset Priority

T0ULARBW: T0ULARBW:

See the attachment INSTRUCTIONS AND DEFINITIONS for determining priority.

Enter 1 -10 Property Source

T0ULARBW: T0ULARBW:

Enter R for Real Property, P for Personal Property or L for Local See the attachment INSTRUCTIONS AND DEFINITIONS for additional information. Site

T0ULARBW: T0ULARBW:

This will be your three letter abbreviation for your Division or District plus a –ULA. An example for a district is MVM-ULA. An example for a Division is LRD-ULA. NSN / Catalog ID

T0ULARBW: T0ULARBW:

The National Stock number is the 13-digit stock number replacing the 11-digit Federal Stock Number. It consists of the 4-digit Federal Supply Classification code and the 9-digit National Item Identification Number, also referred to as catalog ID in APPMS. If there is no NSN required for the asset use N/A. Serial #

T0ULARBW: T0ULARBW:

Serial Number - (also manufacturer's serial number or MSN) is a unique code assigned for identification of a single unit or item. Although usually called a number, it may include letters, though ending with digits. See the attachment INSTRUCTIONS AND DEFINITIONS for additional information. Part Number

T0ULARBW: T0ULARBW:

Is an identifier of a particular part design used in a particular industry.

See the attachment INSTRUCTIONS AND DEFINITIONS for additional information. Model #

T0ULARBW: T0ULARBW:

Model - an identifier of a product given by its manufacturer (also called model number). It defines a particular unit of hardware, equipment or material, known by its style or type using alpha-numeric characters.

See the attachment INSTRUCTIONS AND DEFINITIONS for additional information.

Bar Code

T0ULARBW: T0ULARBW:

The Number issued, used, or assigned on the Property Book Officer or technician used to identify equipment, or items that are (Personal Property). Barcodes can be physically on the equipment or the storage container the items are being stored. For real property used N/A Tag Number

T0ULARBW: T0ULARBW:

The number on the vehicle license plate that is issue to all Corps owned vehicles used on all public or private hi-ways and road ways use to support or transport material, personnel, and equipment (cars, trucks, and trailers). This does not include construction type equipment (real property, dozer, excavators, or loaders etc). Vendor

T0ULARBW: T0ULARBW:

a person or company that is a supplier of goods or services, (In a supply chain, a vendor, or a supplier, is an enterprise that contributes goods or services. Generally, a supply chain vendor manufactures inventory/stock items and sells them to the next link in the chain). In most cases the vendor is a middle man between the manufacturer and the consumer. Put the vendors name for the asset in this section. For a building or structure constructed on site use N/A. Manufacture

T0ULARBW: T0ULARBW:

Is an entity that makes a good through a process involving raw materials, components or assemblies, usually on a large scale with different operations divided among different workers. Commonly used interchangeably with producer. Put the manufacture’s name for the asset in this section. For a building or structure constructed on site use N/A.

See the attachment INSTRUCTIONS AND DEFINITIONS for additional information. Purchasing Doc #

T0ULARBW: T0ULARBW:

A purchasing document number is generated by CEFMS. The purchasing document is also known as a Property Purchase Request. Enter the CEFMS generated number in the purchasing document number cell on the spreadsheet. Purchase Price

T0ULARBW: T0ULARBW:

The actual price paid for an item or services being performed. The actual value of what an item or equipment cost. Enter the cost of the item or equipment in the purchase price cell on the spreadsheet. Replacement Cost

T0ULARBW: T0ULARBW:

See the attachment INSTRUCTIONS AND DEFINITIONS for additional information. Installation Date

T0ULARBW: T0ULARBW:

For personal property assets the installation date would be the same as acquisition date of purchase In APPMS. For a building or structure it would be the beneficial occupancy date. This built date should be available in REMIS. For other real property replacement assets it would be the date the item was installed. Warranty Expiration Date

T0ULARBW: T0ULARBW:

The date the warranty actually expires for the item/equipment purchased. Enter the date if the warrant expires is the asset currently is under warranty. Leaving the cell blank means the asset is not under warranty. Yr Manufac

T0ULARBW: T0ULARBW:

See the attachment INSTRUCTIONS AND DEFINITIONS for additional information. Service Life

T0ULARBW: T0ULARBW:

See the attachment INSTRUCTIONS AND DEFINITIONS for additional information. HRH Name

T0ULARBW: T0ULARBW:

The primary hand receipt or sub Hand receipt holder signing for or actual user of items or equipment. This section is filled out for Personal Property Assets only. Enter the HRH’s Name in this section of the spreadsheet. HRH Number

T0ULARBW: T0ULARBW:

Hand Receipt Holder (HRH) Number - The HRH Number assigned to each individual Primary or Sub-hand receipt holder of items or equipment on the Property Book. This section is field out for Personal Property Assets only. Enter the HRH’s Number in this section of the spreadsheet. Builder ID # u4pwzrcm: u4pwzrcm:

AUTO populated by Builder tool generated. Only used by the Builder tool. No action required. FacilityNumber u4pwzrcm: u4pwzrcm:

From Real Estate Management Information System (REMIS) # FacilityName u4pwzrcm: u4pwzrcm:

Local/Common name (in parentheses name - From Real Estate Management Information System (REMIS) ) FacilityRPUID u4pwzrcm: u4pwzrcm:

Real Estate Management Information System (REMIS) # WarrantyCompany Capacity u4pwzrcm: u4pwzrcm:

Capacity Capacity unit Spec Spec Unit 10 K lbs N/A N/A

350K BTU N/A N/A

240/120 volts Dry Transformer 3 ph 277/480 volts wet Transformer 3 ph – 4 wire 480 V primary 120/208 V secondary Volts dry-type Transformer 112.5 kVA 15 kV primary, 277/480 V secondary volts oil-filled Transformer 1000 kVA 8 Inch gate valve 150 # 10 Ton DX AC Unit N/A CapacityUnit u4pwzrcm: u4pwzrcm:

Capacity Capacity unit Spec Spec Unit 10 K lbs N/A N/A

350K BTU N/A N/A

240/120 volts Dry Transformer 3 ph 277/480 volts wet Transformer 3 ph – 4 wire 480 V primary 120/208 V secondary Volts dry-type Transformer 112.5 kVA 15 kV primary, 277/480 V secondary volts oil-filled Transformer 1000 kVA 8 Inch gate valve 150 # 10 Ton DX AC Unit N/A u4pwzrcm: u4pwzrcm:

Parent – The name of the building or building number the asset is located at or installed in and associated asset. The parent can also be the system that a component is an integral part. Spec u4pwzrcm: u4pwzrcm:

Capacity Capacity unit Spec Spec Unit 10 K lbs N/A N/A

350K BTU N/A N/A

240/120 volts Dry Transformer 3 ph 277/480 volts wet Transformer 3 ph – 4 wire 480 V primary 120/208 V secondary Volts dry-type Transformer 112.5 kVA 15 kV primary, 277/480 V secondary volts oil-filled Transformer 1000 kVA 8 Inch gate valve 150 # 10 Ton DX AC Unit N/A SpecUnit u4pwzrcm: u4pwzrcm:

Capacity Capacity unit Spec Spec Unit 10 K lbs N/A N/A

350K BTU N/A N/A

240/120 volts Dry Transformer 3 ph 277/480 volts wet Transformer 3 ph – 4 wire 480 V primary 120/208 V secondary Volts dry-type Transformer 112.5 kVA 15 kV primary, 277/480 V secondary volts oil-filled Transformer 1000 kVA 8 Inch gate valve 150 # 10 Ton DX AC Unit N/A EstimatedDate Quantity UoM Floor ConditionRating ConditionDate sample B1000 U4V-B1000 u4pwzrcm: u4pwzrcm:

C7 should populate from the "location grid" tab "a2" through "a200" in a drop down selection list if "u4v-b1000" is selected from the drop down in C7 then "ERDC Headquarters Building" in the "location grid" tab "b2" needs to populate D7 then "u4v-BN-1000 in the "location grid" tab "c2" needs to populate B7 (B7 can also be blank or typed over)

u4pwzrcm: u4pwzrcm:

To add a new row simply highlight and copy/paste the entire row of of unpopulated cells to the row below.

u4pwzrcm: u4pwzrcm:

C7 should populate from the "location grid" tab "a2" through "a200" in a drop down selection list if "u4v-b1000" is selected from the drop down in C7 then "ERDC Headquarters Building" in the "location grid" tab "b2" needs to populate D7 then "u4v-BN-1000 in the "location grid" tab "c2" needs to populate B7 (B7 can also be blank or typed over) then "Grid 8 - Section G-10" in the "location grid" tab "d2" needs to populate O7 (O7 can be blank) then O7 needs to populate in AG7 as it currently does u4pwzrcm: u4pwzrcm:

You will populate with the Equipment Mapper as you develop the asset inventory. Select the proper description from the Builder Drop-down catalog.

u4pwzrcm: u4pwzrcm:

You will populate with the Equipment Mapper as you develop the asset inventory. Select the proper description from the Builder Drop-down catalog.

u4pwzrcm: u4pwzrcm:

You will populate with the Equipment Mapper as you develop the asset inventory. Select the proper description from the Builder Drop-down catalog.

u4pwzrcm: u4pwzrcm:

You will populate with the Equipment Mapper as you develop the asset inventory. Select the proper description from the Builder Drop-down catalog.

u4pwzrcm: u4pwzrcm:

the unit number is the number of units found in a top asset. I.e. 1 through 30 fan coils found in a building. Or Boiler 1 and Boiler 2 found in a building. etc u4pwzrcm: u4pwzrcm:

this needs a free test option plus and cardinal direction pick list u4pwzrcm: u4pwzrcm:

this needs a free test option plus and cardinal direction pick list u4pwzrcm: u4pwzrcm:

this needs a free test option plus and cardinal direction pick list

T0ULARBW: T0ULARBW:

Is the physical and/or geographical location that the items is being stored, installed or used to support the mission. (Exp. Bldg. C1 Mech. Room)

T0ULARBW: T0ULARBW:

Is the common name or descriptive name.

T0ULARBW: T0ULARBW:

Enter Y for yes if the asset requires calibration and N for no if it does not. See the attachment INSTRUCTIONS AND DEFINITIONS for more information.

T0ULARBW: T0ULARBW:

See the attachment INSTRUCTIONS AND DEFINITIONS for determining priority.

Enter 1 -10

T0ULARBW: T0ULARBW:

Enter R for Real Property, P for Personal Property or L for Local See the attachment INSTRUCTIONS AND DEFINITIONS for additional information.

T0ULARBW: T0ULARBW:

This will be your three letter abbreviation for your Division or District plus a –ULA. An example for a district is MVM-ULA. An example for a Division is LRD-ULA.

T0ULARBW: T0ULARBW:

The National Stock number is the 13-digit stock number replacing the 11-digit Federal Stock Number. It consists of the 4-digit Federal Supply Classification code and the 9-digit National Item Identification Number, also referred to as catalog ID in APPMS. If there is no NSN required for the asset use N/A.

T0ULARBW: T0ULARBW:

Serial Number - (also manufacturer's serial number or MSN) is a unique code assigned for identification of a single unit or item. Although usually called a number, it may include letters, though ending with digits. See the attachment INSTRUCTIONS AND DEFINITIONS for additional information.

T0ULARBW: T0ULARBW:

Is an identifier of a particular part design used in a particular industry.

See the attachment INSTRUCTIONS AND DEFINITIONS for additional information.

T0ULARBW: T0ULARBW:

Model - an identifier of a product given by its manufacturer (also called model number). It defines a particular unit of hardware, equipment or material, known by its style or type using alpha-numeric characters.

See the attachment INSTRUCTIONS AND DEFINITIONS for additional information.

T0ULARBW: T0ULARBW:

The Number issued, used, or assigned on the Property Book Officer or technician used to identify equipment, or items that are (Personal Property). Barcodes can be physically on the equipment or the storage container the items are being stored. For real property used N/A

T0ULARBW: T0ULARBW:

The number on the vehicle license plate that is issue to all Corps owned vehicles used on all public or private hi-ways and road ways use to support or transport material, personnel, and equipment (cars, trucks, and trailers). This does not include construction type equipment (real property, dozer, excavators, or loaders etc).

T0ULARBW: T0ULARBW:

a person or company that is a supplier of goods or services, (In a supply chain, a vendor, or a supplier, is an enterprise that contributes goods or services. Generally, a supply chain vendor manufactures inventory/stock items and sells them to the next link in the chain). In most cases the vendor is a middle man between the manufacturer and the consumer. Put the vendors name for the asset in this section. For a building or structure constructed on site use N/A.

T0ULARBW: T0ULARBW:

Is an entity that makes a good through a process involving raw materials, components or assemblies, usually on a large scale with different operations divided among different workers. Commonly used interchangeably with producer. Put the manufacture’s name for the asset in this section. For a building or structure constructed on site use N/A.

See the attachment INSTRUCTIONS AND DEFINITIONS for additional information.

T0ULARBW: T0ULARBW:

A purchasing document number is generated by CEFMS. The purchasing document is also known as a Property Purchase Request. Enter the CEFMS generated number in the purchasing document number cell on the spreadsheet.

T0ULARBW: T0ULARBW:

The actual price paid for an item or services being performed. The actual value of what an item or equipment cost. Enter the cost of the item or equipment in the purchase price cell on the spreadsheet.

T0ULARBW: T0ULARBW:

See the attachment INSTRUCTIONS AND DEFINITIONS for additional information.

T0ULARBW: T0ULARBW:

For personal property assets the installation date would be the same as acquisition date of purchase In APPMS. For a building or structure it would be the beneficial occupancy date. This built date should be available in REMIS. For other real property replacement assets it would be the date the item was installed.

T0ULARBW: T0ULARBW:

The date the warranty actually expires for the item/equipment purchased. Enter the date if the warrant expires is the asset currently is under warranty. Leaving the cell blank means the asset is not under warranty.

T0ULARBW: T0ULARBW:

See the attachment INSTRUCTIONS AND DEFINITIONS for additional information.

T0ULARBW: T0ULARBW:

See the attachment INSTRUCTIONS AND DEFINITIONS for additional information.

T0ULARBW: T0ULARBW:

The primary hand receipt or sub Hand receipt holder signing for or actual user of items or equipment. This section is filled out for Personal Property Assets only. Enter the HRH’s Name in this section of the spreadsheet.

T0ULARBW: T0ULARBW:

Hand Receipt Holder (HRH) Number - The HRH Number assigned to each individual Primary or Sub-hand receipt holder of items or equipment on the Property Book. This section is field out for Personal Property Assets only. Enter the HRH’s Number in this section of the spreadsheet.

u4pwzrcm: u4pwzrcm:

AUTO populated by Builder tool generated. Only used by the Builder tool. No action required.

u4pwzrcm: u4pwzrcm: