AnsweredAssumed Answered

HVAC scheduling: account for gaps in a room's occupancy

Question asked by kbobeck on Jul 18, 2017
Latest reply on Jul 18, 2017 by kbobeck

We're trying to automate the turning off/on of a room's HVAC system using a schedule pre-loaded into the BAS as well as user requests. My formula works when the BAS schedule and a user request are consecutive:

 

BAS start time: 8:00am

BAS stop time: 10:00am

 

Request start time: 10:00am

Request stop time: 12:00pm

 

Actual start time: If ReqStart < BASstart Then ReqStart Else BASstart = 8:00am

Actual stop time: If ReqStop > BASstop Then ReqStop Else BASstop = 12:00pm

 

Total run time: 4 hours

Total occupied time: 4 hours

 

However, since my formula decides start and stop times by whichever time is earliest and latest (respectively), if the request has a non-consecutive start or stop time, this causes run time to be greater than occupation time:

 

BAS start time: 8:00am

BAS stop time: 10:00am

 

Request start time: 3:00pm

Request stop time: 5:00pm

 

Actual start time: If ReqStart < BASstart Then ReqStart Else BASstart = 8:00am

Actual stop time: If ReqStop > BASstop Then ReqStop Else BASstop = 5:00pm

 

Total run time: 9 hours

Total occupied time: 4 hours

 

Any suggestions on how to account for breaks between occupation periods?

Outcomes