J-0200000-09 CHARACTERISTIC METER READING INFO.xlsx
XLSX spreadsheet 30 KB Posted
- Solicitation number
- N4008523R2630
About this file
This document contains a template and guidance for submitting characteristic meter reading information to the Naval Facilities Engineering Command. The template includes six required fields to submit site information, asset details, meter name, observation values, measurement dates, and inspector details using a pipe delimited flat file format. Observation values for facilities are on a scale of A-R while utility values range from 1 to 5.
The related federal contract opportunity is solicitation number N4008523R2630 for Facility Investment Services for Electrical Maintenance and Repair Services in the Hampton Roads, Virginia area of responsibility. The requirement is for the Department of the Navy Naval Facilities Engineering Command and involves electrical maintenance and repair services.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| N4008523R2630 AMENDMENT 0007.pdf | ||
| N4008523R2630 AMENDMENT 0006.pdf | ||
| N4008523R2630 AMENDMENT 0005.pdf | ||
| AMENDMENT 0004 SITE VISIT 4.20.23.pdf | ||
| N4008523R2630 AMENDMENT 0004.pdf | ||
| N4008523R2630 AMENDMENT 0003.pdf | ||
| AMENDMENT 0003 SITE VISIT ISO N4008523R2630 REDACTED.pdf | ||
| N4008523R2630 Section C Annexes REV1.pdf | ||
| N008523R2630 Amendment 0002.pdf | ||
| N008523R2630 Amendment 0001.pdf | ||
| N4008523R2630.pdf | ||
| J-0200000-06 SERVICE PROVIDER INFORMATION.xlsx | XLSX spreadsheet | |
| J-0200000-04 Invoice Form.xlsx | XLSX spreadsheet | |
| J-0200000-13 Utility Elect Maint ELINs.xlsx | XLSX spreadsheet | |
| J-0200000-07 ASSET INFORMATION.xlsx | XLSX spreadsheet | |
| N4008523R2630 Section C Annexes.pdf | ||
| N4008523R2630 Section J Annexes.pdf | ||
| J-0200000-08 ASSET SPECIFICATION.xlsx | XLSX spreadsheet | |
| J-1602000-04 Job Plans.xlsx | XLSX spreadsheet | |
| J-1602000-01 to -03 Electrical.xlsx | XLSX spreadsheet |
Show all 20
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
1-Characteristic Meter Info
ATTACHMENT J-0200000-09
CHARACTERISTIC METER READING INFORMATION
| Interface: Characteristic Meter Reading | |
| VERSION #: | v2 |
| Current as of: | 30 Sept 2016 |
| Version History |
| v1 - Updated to reflect current interface in MAXIMO (December 12, 2012) |
| v2 - Updated to relect Utilities (DI) values only range from 1 to 5, not 10 (Sept 30, 2016) |
| TABS | |
| 1-Characteristic Meter Reading Info | This Sheet |
| 2-Characteristic Meter Reading Field List | Characteristic Meter Reading Template Data Format Information |
| 3-Characteristic Meter Reading - Template | Sample Excel Format |
| 4-Observation Values | Valid Observation values as of 9/2016 |
2-Characteristic Meter Fields
ATTACHMENT J-0200000-09
CHARACTERISTIC METER READING INFORMATION
| Interface: Characteristic Meter Reading |
| VERSION #: v2 |
| Current as of: 30 Sept 2016 |
| Position | Name | Required | Length | |
| Limit | Data Format Note | Field Definition | Content Notes | |
| NAVFAC |
MAXIMO_FIELD
(MEASUMENT / ASSETMETER)
See Note Below
| 1 | Site | Y | 8 | UPPER | Must match Value List in Maximo | Value list in REFERENCE SPREADSHEET -or- | |
| For this contract only: XXXXX | SITEID / SITEID | ||||||
| 2 | Asset | Y | 25 | Must match an existing ASSETNUM in Maximo | The asset number used must exist in NAVFAC MAXIMO prior to submission, or the record will be rejected. | Value list in REFERENCE SPREADSHEET |
| ASSETNUM / ASSETNUM | |||||||
| 3 | Meter | Y | 15 | UPPER | The value listed in the third position must be an existing, valid Maximo DCR or UCR meter. | Value must match existing value in Maximo. list in REFERENCE SPREADSHEET | METER NAME / |
METER NAME
| 4 | Observation | Y | 254 | ALN | Last Reading/Observation value. Must be a valid value in MAXIMO | Value must match existing value in Maximo list. Current value list included on | ||
| Tab 4 - Observation Values | OBSERVATION / LASTREADING | |||||||
| 5 | Measurement Date | Y | 10 | MM/DD/YYYY hh:mm:ss | Date Observation was recorded | MEASUREDATE / LASTREADINGDATE | ||
| 6 | Inspector | Y | 30 | Must match Value List in Maximo | Identifies the person reporting the observation | Value list in REFERENCE SPREADSHEET -or- |
For this contract:
- use the following identifier "XXXX" INSPECTOR / LASTREADINGINSPCTR
NOTE (NAVFAC MAXIMO/FIELD):
The observation information is filed in one of two locations. If the observation is the MOST CURRENT reading (by Measurement Date) - it is filed in the MEASUREMENT Table. If the data when received is not the most current, it is filed in the ASSETMETER Table. The filing location is irrelevant to the inteface use, but this information is provided to prevent confusion when reviewing the data in Maximo.
When reviewing the data in Maximo (after processing) - If the meter reading being imported is newer than the last reading applied to the Assets record, a new meter reading entry will also be added to the Assets record’s Meter tab. If the imported record is older than the last reading, it will only be visible in the (Select Action) “Manager Meter Reading History” dialog box, “Characteristic Meter Readings” tab.
3-Characteristic Meter-Template
ATTACHMENT J-0200000-09
CHARACTERISTIC METER READING INFORMATION
| Interface: Characteristic Meter Reading |
| VERSION #: v2 |
| Current as of: 30 Sept 2016 |
| Position | 1 | 2 | 3 | 4 | 5 | 6 |
| Name | Site | Asset | Meter | Observation | Measurement Date | Inspector |
| Required Field(s) | Y | Y | Y | Y | Y | Y |
NOTES:
• ONLY POSITIONs 1-6, and rows containing data should be be included in the FLAT-FILE SUBMISSION;
• Pipe Delimited (.txt) - | (Pipe is at the end of the column. Must have 7 PIPEs per row. Last PIPE indicates end of line (EOL))
4-Observation Values
| ATTACHMENT J-0200000-09 | ||
| CHARACTERISTIC METER READING INFORMATION | ATTACHMENT J-0200000-XX |
CHARACTERISTIC METER READING INFORMATION
| Interface: Characteristic Meter Reading |
| VERSION #: v2 |
| Current as of: 30 Sept 2016 |
| OBSERVATION VALUES |
| FACILITIES (DCR): | |
| A | (Amber) |
| A+ | (Amber Plus) |
| A- | (Amber Minus) |
| G | (Green) |
| G+ | (Green Plus) |
| G- | (Green Minus) |
| R | (Red) |
| R+ | (Red Plus) |
| R- | (Red Minus) |
| UTILITIES (UCR): | |
| 1 | (Best/Highest CI Ranking) |
| 2 | |
| 3 | |
| 4 | |
| 5 | (Worst/Lowest CI Ranking) |
File details come from the government source that posted it. Updated .