Defining interpolation calendars
To specify an interpolation calendar definition:
Applying override patterns
You can apply the override patterns for a specific date range using the Date After, Date Before, (Date After and Date Before) fields. This allows you to specify date ranges with an overlap.
General rules:
- Any range that exists completely within other ranges is considered.
- If two ranges overlap and provide conflicting patterns (for example, range A start < B start, but A end > B start) the last range added (B) is applied for the intersected dates. The other range can be applied outside of this intersecting area, if not conflicting with any other ranges.
- The default pattern for which date range is not specified, (Date Before or Date After) can be applied where no override pattern exists on the specified date.
The first entry (row) is the default pattern for which date range is not specified.
Date After | Date Before | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |
---|---|---|---|---|---|---|---|---|
1 | 1 | 1 | 1 | 1 | 0 | 0 | ||
2014-01-01 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |
An override pattern (1,1,1,1,1,1,0) is applied from 2014-01-01 for all future periods. All the periods before 2014-01-01 use the default pattern.
The first entry (row) is the default pattern for which date range is not specified.
Date After | Date Before | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |
---|---|---|---|---|---|---|---|---|
1 | 1 | 1 | 1 | 1 | 0 | 0 | ||
2014-01-01 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | |
2014-03-01 | 2014-04-01 | 1 | 1 | 1 | 0 | 0 | 0 | 0 |
- An override pattern (1,1,1,1,1,1,0) is applied from 2014-01-01 for all future periods. Only the periods between 2014-03-01 and 2014-04-01 use the specified override pattern (1,1,1,0,0,0,0).
- All the periods after 2014-04-01 use the specified override pattern (1,1,1,1,1,1,0).
- All the periods before 2014-01-01 use the default pattern.
The first entry (row) is the default pattern for which date range is not specified.
Date After | Date Before | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |
---|---|---|---|---|---|---|---|---|
1 | 1 | 1 | 1 | 1 | 0 | 0 | ||
2014-01-01 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | |
2014-04-01 | 1 | 1 | 1 | 1 | 2 | 0 | 0 |
- An override pattern (1,1,1,1,1,1,0) is applied from 2014-01-01 for all future periods. This override pattern is only used until 2014-04-01.
- All the future periods from 2014-04-01 use the specified override pattern (1,1,1,1,2,0,0).
- All the periods before 2014-01-01 use the default pattern.