Load Profile File Format
Profiles are to be loaded on customer specified maintenance interval (Product recommends doing this weekly or bi-weekly to reduce the CSV file size). Profiles can be either at Meter level or aggregated by the customer from meter data to service transformers that are represented as load points within the NMS. The data provided for each service transformer will represent a profile for a specific date, for study mode only profiles (for example, Peak, Seasonal Peak) a blank date can be provided.
The transformer load profile data is provided as a comma-separated file with a comma separated header.
The expected (but not required) header is:
Date,TransformerName,TransformerAlternateName,FeederName,DayType,Hour,KW,KVAR,Temperature
Note 1: Date can be left blank is profile is for study mode only (for example, Peak, Seasonal Peak, etc).
Note 2: Optional fields may be omitted from the file, resulting in two consecutive commas.
Note 3: If KVAR is not measured, it can be calculated from KW with a default power factor.
Note 4: The temperature field is optional. A utility may provided temperature data for location, date, and time. If no temperature data is provided the adapter will use historical data stored in the NMS database. If this data is going to be omitted please leave the temperature field null.
If the customer wish to provide the input data at meter level then the SRS rule "PA_ProfileData" value has to set as "METER". And the data format in csv file should be as per the SRS rule PA_MeterColumnMap.
The Meter load profile data is provided as a comma-separated file with a comma separated header. The expected (but not required) header is:
Date,MeterID,MeterAlternateName,FeederName,DayType,Hour,KW,KVAR