CIET's Ask Us Anything series is a free monthly Q&A session with industry experts.

The How to Analyze Your Energy Data session featured Stephen Dixon, CIET Trainer and RETScreen® Expert.

If you missed it, here is a key topic that was discussed during the session.


Question: How do you deal with weekend-weekday consumption profile differences?


If I'm looking at interval data, sometimes there's no differences between the weekend and the weekdays.

Looking at it on a time series, looking at a weekly basis, certainly I can start to interpret what's happening. If you're talking about taking that data and starting to do a regression analysis on it where you're using a different amount of energy on a weekend day versus a weekday, then what I like to do is to use a binary variable in my RETScreen® analysis, or my regression analysis, to indicate whether it is a weekend or a weekday. From there, that will generate an equation which allows me to account for the differences between the weekend and the weekdays.

But to me, the first thing to do is to lay it out on a graph and look for differences. Sometimes the fact that the weekend is no different from the weekday is a very alarming thing. But it's also a big opportunity.

You can also look at the way chillers are cycling during a weekend period versus a weekday.

The other thing you could do within RETScreen® is to use the filtering feature. You filter out and only plot certain days, if you want to do it that way. Excel will do the same thing quite nicely.

Did you miss this Ask Us Anything session?

Here's another video highlight.

Want to learn more about Energy Management Software & Tools?

Our Energy Management Software & Tools learning path has comprehensive training courses designed to help professionals learn or master the main energy management software and tools, including RETScreen® Expert. Courses offered include:


See all programs included in this Learning Path.

If you are interested in integrating the latest energy management software and tools in your organization, or if your team requires training to ensure they are up-to-date on the latest technologies and best practices, we offer custom private group training that can be customized to fit organizational needs. You can book a call with our Business Development Representative here.



Newsletter subscription

Yes, I consent to receiving CIET communications. I understand that I may unsubscribe at any time.

Share your training needs with us!

Would you like to be trained on a specific topic? Just let us know!

Express my interest
Send us your question

Send us an email and we will respond as soon as possible.

This is to inform you that the course date is too close to be able to ship hard copies of the material to you on time. If you are willing to use the material in secured PDF, receive the material later (likely after the course) and pay upon registration, please click OK to continue the registration process. Please note that the shipping process will start only when the course fees are paid in full and delays are to be expected. Many thanks!