Anyone use a spreadsheet or notes somewhere to help keep track of which routines and apps are automating what devices? I’m new to ST and home automation and only have 4 light switches, 2 plugs, and 4 bulbs, a Schlage connect lock, ring doorbell and nest and i am staring to lose track of what is turning lights on or off for what reasons. I’m thinking of making a spreadsheet of sorts (also because I enjoy using Excel) and hoping to get some brainstorming ideas from others that might do the same, or if there is a better way? Thanks!
1 Like
I keep an Excel spreadsheet based on the punch list format by device. 
But it’s not really a good match, it just happened to be a template I already had that I thought I could use. I’m sure there are more effective formats.
mind sharing a screenshot? lol
Mine is pretty simple if you think device first. But a lot of people think trigger first, or restrictions first, so it really depends on how you want to use it.
Device
Trigger
Result
Day/Time restriction
Geopresence restriction on/off
Mode restriction on/off
Other restrictions
Notes
It’s not perfect, because it’s not really easy to drill down. It’s more just a reminder for myself, for those “what caused that light to turn on?” Moments. 
3 Likes
LOL thats exactly why im building one. Wife was in bed and told Alexa goodnight, took me a while to figure out why certain lights turned off lol.
1 Like
This very comprehensive spreadsheet was created by a past user. It’s a link in the thread below called Smart Things Programming.xlsx. Ignore the thread topic since Rule Machine is no longer available and replaced by WebCore.
3 Likes