Timeslice
Column Type = Single

The Timeslice column is used to define a custom pattern type..

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.

 

 Input Tables

 Timeslice Definition Table

 Timeslice Column


For further assistance, please contact Aurora Support.

Copyright© 1997-2024 Energy Exemplar LLC. All rights reserved.