This only applies to 'Meter Data Consumption Profiles'.
What's the difference between Meter Data and Trading/Non-Trading Consumption Profiles?
If you have your customer's interval metering data, you can upload this information and re-use it later. This provides the most accurate assessment possible when you have interval metering data for a particular customer for an entire year.
The uploaded meter file must contain
one "DateTime" column, OR two separate date and time columns (one Date AND one Time column)
which have at least an hourly breakdown of consumption by kW or kWh (one kW OR one kWh column).
2. In the section marked below, format the dates (if necessary)
Dates will automatically be converted, however if they are being converted incorrectly, you'll need to specify their format. You must specify both date and time if you want to use this feature.
Dates from Excel spreadsheets may appear as numbers, this is due to the way Excel stores data. It is nothing to worry about, you will see the converted dates after you have defined your columns and saved.
You can quickly access this list anytime from the consumption profile editing screen. Just click the "Click here to see formatting options" link in the same section (shown above). Click this link again to hide the list.
Use the following symbols to identify the date and time format:
- d - Day of the month; with leading zeros
- j - Day of the month; without leading zeros
- D - Day of the month (Mon - Sun)
- l - Day of the month (Monday - Sunday)
- S - English suffix for day of the month (st, nd, rd, th)
- F - Monthname (January - December)
- M - Monthname (Jan-Dec)
- m - Month (01-12)
- n - Month (1-12)
- Y - Year (e.g 2013)
- y - Year (e.g 13)
- a and A - am or pm
- g - 12 hour format without leading zeros
- G - 24 hour format without leading zeros
- h - 12 hour format with leading zeros
- H - 24 hour format with leading zeros
- i - Minutes with leading zeros
- s - Seconds with leading zeros
- u - Microseconds (up to six digits)
- e, O, P and T - Timezone identifier
- U - Seconds since Unix Epoch
2.1. Specify the Date Format
Enter the conventional format of the date.
e.g. j/m/y for 3/11/16 where:
- j is Day of month,
- m is Monthname (Jan-Dec),
- y is Year (e.g 13, not 2013).
2.2. Specify the Time Format
Enter the conventional format of the time.
e.g. G:i for 5:30 where:
- G is 24 hour format without leading zeros,
- i is Minutes with leading zeros.
3. Click "Set columns"
4. Wait for the formatting to complete, then click "Save changes"
0 Comments