Retail Calendar
A configurable merchandising and retail calendar generator. For a given year and configuration, generates merchandising calendar along with Gregorian boundaries. It can be used for generating all calendar types, including NRF 4-5-4 calendar, 4-4-5 calendar or Gregorian calendar.
Installation
Using npm:
$ npm i --save retail-calendar
Usage:
Instantiate RetailCalendarFactory with preferred options.
const {
WeekCalculation,
WeekGrouping,
LastDayOfWeek,
LastMonthOfYear,
RetailCalendarFactory,
} = require('retail-calendar')
const calendar = new RetailCalendarFactory(
{
weekCalculation: WeekCalculation.LastDayNearestEOM,
weekGrouping: WeekGrouping.Group454,
lastDayOfWeek: LastDayOfWeek.Saturday,
lastMonthOfYear: LastMonthOfYear.January,
},
2017,
)
A retail calendar either has 52 or 53 weeks.
calendar.numberOfWeeks
calendar.year // Given year, 2017 in this case
A retail calendar always has 12 months.
calendar.months
calendar.months[0].monthOfYear // Starts from 1, up to 12
A retail calendar has quarter of year and week of quarter
Both Month and Week has quarter information
calendar.months[0].quarterOfYear // from 1 to 4
calendar.weeks[0].quarterOfYear // from 1 to 4
The week also has week of quarter:
calendar.weeks[0].weekOfQuarter
Each month consist of complete weeks. Month boundaries are always at the end of week. End of week is given in lastDayOfWeek
option. Number of weeks for each month is defined in weekGrouping
option.
// Week grouping is 454 which means
calendar.months[0].numberOfWeeks // 4
calendar.months[1].numberOfWeeks // 5
calendar.months[2].numberOfWeeks // 4
calendar.months[3].numberOfWeeks // 4
calendar.months[4].numberOfWeeks // 5
calendar.months[5].numberOfWeeks // 4
// Each quarter repeats the same pattern.
// Each month has an array of weeks it contains.
calendar.months[0].weeks
Each month start and end boundaries expressed in Gregorian calendar.
// Date time of beginning of month.
// In this case Feb 5, 2017 12:00 AM
calendar.months[0].gregorianStartDate
// Date time of end of month.
// In this case March 5, 2017 11:59.999 PM
calendar.months[0].gregorianEndDate
All weeks in a retail calendar are also directly accessible. Each week also has boundaries available in Gregorian calendar.
calendar.weeks // All weeks in calendar.
calendar.weeks[0].gregorianStartDate // Date
calendar.weeks[0].gregorianEndDate // Date
53 week years
Based on given configuration, a year may contain 53 weeks.
Restated
⚠ previous versions of this library used the LeapYearStrategy option to configure restated behavior. This is no longer supported. All 53 week calendars are not restated ⚠
Dropping Last Week
LAST week of year is "dropped" for 53-week years. This is the default behavior.
// Last week of year has no month.
calendar.weeks[52].weekOfYear // 52
calendar.weeks[52].weekOfMonth // -1
calendar.weeks[52].monthOfYear // -1
// First month starts from 1st week
calendar.months[0].weeks[0].weekOfYear // 0
⚠ previous versions of this library returned weekOfYear as -1, this is no longer the case. Last week's weekOfYear is 52 ⚠
Add Leap Week to Month
If addLeapWeekToMonth
is 11
,
extra week is "added" to the ELEVENTH month
// AddToPenultimateMonth calendar example for 445 Calendar.
// 11th Month has 5 weeks instead of 4
calendar.months[10].weeks.length //5
⚠ previous versions of this library supported leapYearStrategy
option value LeapYearStrategy.AddToPenultimateMonth
for the same behavior. leapYearStrategy
is no longer supported ⚠
Options
LastDayOfWeek
Positive integer from 1 (Monday) to 7 (Sunday). Identifies on which day of week the calendar weeks end. Years, months, weeks of the retail calendar always ends on this day of week.
WeekCalculation
Identifies which method to use when calculating end of the retail calendar year.
See 4-4-5 Calendar article for how both of these methods work.
-
WeekCalculation.LastDayNearestEOM: Use the last end of retail week, nearest the end of last Gregorian month in the year.
-
WeekCalculation.LastDayBeforeEOM: Use the last end of retail week, before the end of last Gregorian month in the year.
-
WeekCalculation.LastDayBeforeEomExceptLeapYear: Use the last end of retail week, before the end of last Gregorian month in the year. If next year is leap year (has 53 weeks), make this year leap year by moving end of this year by 1 week forward.
-
WeekCalculation.FirstBOWOfFirstMonth: Use the first, beginning of week day, of the start month as the start day of year.
LastMonthOfYear
Specifies the month the year ends. Plan year is the Gregorian year of the first month.
For example if last month is January and given year is 2017. The last month of retail calendar is January 2018 If last month is December and given year is 2017. The last month of retail calendar is December 2017.
WeekGrouping
Specifies how many weeks each month has in a quarter.
-
WeekGrouping.Group454
: 1st month has 4 weeks, 2nd has 5, 3rd has 4. Repeats for each quarter. -
WeekGrouping.Group544
: 1st month has 5 weeks, 2nd has 4, 3rd has 4. Repeats for each quarter. -
WeekGrouping.Group445
: 1st month has 4 weeks, 2nd has 4, 3rd has 5. Repeats for each quarter.
addLeapWeekToMonth
If addLeapWeekToMonth
is set to 10
, then the penultimate month will not abide this rule, as it will have an extra week. This value is zero-indexed.
leapYear, leapYearEndDate, leapYearFrequency
Overrides how leap years are calculated. Used only if weekCalculation is set to WeekCalculation.CustomLeapYear
.
If these options are set, given leapYearEndDate
will be the end of calendar year of leapYear
.
Then remaining leap years will be calculated using leapYearFrequency
option.
For given { yearEndDate: '2006-03-11', calendarYear: 2006, leapYearFrequency: 6 }
customLeapYearOptions, 2006 will be a leap year and the last day of the year will be 2006-03-11.
Following leap years will be 2012, 2018, 2024 and so on.
LeapYearStrategy [Removed]
enum
If the year is a leap year (in the context of a retail calendar that means it has 53 weeks)
- And
LeapYearStrategy.Restated
is selected, the first week is not included in any month. - And
LeapYearStrategy.DropLastWeek
is selected, the last week is not included in any month. - And
LeapYearStrategy.AddToPenultimateMonth
is selected, the extra week is added to the 11th month
This option has no effect on 52 week years.
restated [Removed]
⚠ This option has been superseded by LeapYearStrategy ⚠
boolean
. If true, in leap years, first week is not included in any month. Otherwise, in leap years, last week is not included in any month.
Has no effect on 52 week years.