I’ve been trying to figure out how to characterize and check for the states and transitions that I want to monitor and control.  It’s making my head hurt since I’ve not done this type of stuff in a while.

Here’s what the state of the door looks like over time.

The information I am gathering is the status of the Open and Closed sensor and time.

Building on this, here’s the chart

So now, I need the code to interpret the sensors so I can respond and control the door.

OK and Notify is when I want to update the spreadsheet that the door has opened or closed. Time Check is when the door will be auto-closed after a period of time (15 minutes?, maybe 5 minutes in winter).