Shade Automation Driven by a Spreadsheet - is that Possible?

[sidjohn1]

I’d recommend using the suncalc driver to know the sun position and an illuminance sensor to know how bright it is. I still use the same automation to accomplish your stated goal with some minor tweaks to the sun position, no spreadsheet required.

You can use what you already have to help determine what sun coordinates trigger your shades positions.

Track Sun Position for Automated Shades

I would say that the suncalc driver and an illuminance sensor working together would be best. This is a rule i use to lower a shade in the winter and use the suns position to set the proper level to block the sun. The tree right outside of the window handles the automation the rest of the year. [image]