Timeslice
Column Type = Single
The Timeslice column is used to reference a pattern variable Timeslice ID from the Timeslice Definition table or to define a custom pattern type directly.
Timeslice patterns are defined using key characters. These characters are:
| Symbol | Range | Definition |
|
Q |
1-4 | Quarter of the year (1=Jan to Mar, 2=Apr to Jun, etc.) |
|
M |
1-12 | Month of calendar year (1=Jan, 2=Feb, etc.) |
|
K |
1-53 | Week of the year (1=first week of the year). Note that week of the year numbering is based on ISO-8601. The first week of the year always contains 4 January. |
|
D |
1-31 | Day of month |
|
W |
1-7 | Day of week (1=Monday, 2=Tuesday, etc.) |
|
H |
1-24 | Hour of the day (1=midnight to 1:00am, 24=11:00pm to 12am midnight) |
|
! |
n/a | The "not" operator, e.g., !H1-6 means the data applies in hours other than 1-6 |
To define a pattern, begin with the desired symbol then specify the range. Use commas to separate symbols and semicolons for multiple patterns.
Examples of patterns are:
| Pattern | Interpretation |
| M1-2 | Value applies to January and February. |
| D1-5, H7-9 | Value applies to hours 7-9 for the days 1-5 of each month. |
| Q1,H3; Q3, H9-11 | Value applies to hour 3 in the first quarter and hours 9-11 in the third quarter. |
| !H4-9 | Value does not apply to hours 4-9. Value will apply to hours 1-3 and 10-24. |
NOTE: For patterns that overlap (Ex: M1 and M1,H1) the value for the most granular time pattern will be used during the time specified. All other values in the overlap will use the less granular data.
Timeslice Column
