Summer has arrived. While your friends are frolicking at the beach, you are struggling in a darkened cubicle to ensure that the load forecast performs well on July 4.

Indeed, holidays create a unique challenge for load forecasters. There are two broad categories of holidays:

  • Stationary holidays occur on the same weekday each year. For example, Martin Luther King, Jr. Day is celebrated in the U.S. on the third Monday in January. Memorial Day is celebrated on the last Monday in May.
  • Non-stationary holidays occur on different weekdays. In the U.S., Independence Day is July 4, regardless of the weekday. Similarly, in Canada, Canada Day is always on July 1.

Typically, short-term load models use five or fewer years of historical data. This creates no intrinsic problems regarding the stationary holidays. It can create issues when it comes to non-stationary holidays, however, because the model has not experienced those holidays on all seven days of the week.
First, we will look at the stationary holidays. For MLK Day, you can specify the variable as follows:

Let’s unpack this:

  • Month = 1 returns a 1 during January and 0 otherwise
  • Weekday = 2 returns a 1 on Mondays and 0 otherwise

The third Monday will fall between (and including) the 15th and the 21st.

  • Day>=15 returns a 1 on all days after and including the 15th of each month
  • Day<=21 returns a 1 on all days before and including the 21st of each month

The product of each of these expressions is a 1 on the third Monday in January. We can use similar logic to define a Memorial Day variable.

Now, let’s look at the non-stationary holidays. We can define Independence Day as follows:

This variable will return a 1 on July 4 every year. From a modeling perspective, the problem arises because July 4 is sometimes on Tuesday and sometimes on Sunday. The effect of the holiday on a Tuesday will likely be different than the effect on a Sunday. To complicate the issue further, we may need to address the surrounding days as well. For instance, when July 4 is on a Saturday, the holiday is likely observed on Friday, July 3.

Let’s first look at how to specify the variable accounting for different weekdays. In the following example, Saturdays are weighted with a 0.4, Sundays are weighted with a 0.25 and all other days are weighted with a 1.0. In other words, Saturdays will get 40% of the impact of the weekdays, while Sundays will get 25% of the impact of the weekdays.

You can do some analysis of residuals to determine the weights that make sense for your load.

You can expand this idea further by specifying weights for July 3 and July 5 as well.

By specifying the weights in transforms, you can build complicated logic to address the issue. Further, a single variable that accounts for July 3, July 4 and July 5 can be a powerful way to address the problem of the holiday spillover effect along with the shifting weekday.

Before you get too excited about this, you should consider the following. By the time you get the non-stationary holiday effect right, the holiday has already happened. And, when the holiday happens, you won’t get it right because it hasn’t happened on that same day in seven years. In other words, you’ll get it right, but it will be just in time to be too late.

Have you seen the new Itron website? Be sure to visit the new forecasting page at www.itron.com/forecasting.

Rich Simons
Principal Forecast Consultant - Itron