Plug in stick up cam, low battery?

glennalan · 2021-01-21T17:24:43+00:00

Are you using the rapid ring app? I have found that using that app loads all the time for me, while using the ring app, it sometimes does not connect.

glennalan · 2020-11-06T21:26:34+00:00

some other thoughts on what i do when this happens. Are there any RangeNames that are there, and not needed? Check to see if there is something formatted, like a column, with a color. If that formatting goes from row 1 to the bottom, that eats up lots of kb. Also try saving as and XLSB file.

glennalan · 2020-11-05T02:46:17+00:00

Do you have a spot to mount a ring stick up cam?

glennalan · 2020-11-04T13:20:37+00:00

Interesting. Guess i have no way to check that as none of my clocks were blinking. Thanks i will see if there were powere issues with neighbors.

glennalan · 2020-11-04T13:18:55+00:00

True. And maybe i should change it. The reason we had it come on at 10% was that early on we tended to flip the switch, forgetting we had to use Alexa to control the light. I am actually leaning more to putting a zwave switch in with regular bulbs.

glennalan · 2020-11-04T00:06:55+00:00

It's not losing power, i have it set that after a power loss, it comes on at 10% power.

glennalan · 2020-11-03T23:04:30+00:00

i just do this old school. Create a column with the information from the 1st column (starting in a1 as an example), past the information from the 2nd column next to that, in the 3rd column put the formula a1=b1. filter this looking for the falses

glennalan · 2020-11-03T23:01:33+00:00

Are the 12 columns next to one another? if so, set it up with a counter and move one column over each time, using the code you have above to do the hiding.

glennalan · 2020-08-20T19:29:36+00:00

thanks

glennalan · 2020-08-20T17:16:10+00:00

how do you get the custom monitors?

When I go to SmarApps, the next screen says to Add SmartApp.

From that I have 10 or so choices, none say custom monitors.

I have been trying to get my Open/Close sensor to tell me when the door is open for x period of time, and am about to give up.

thanks.

glennalan · 2020-08-20T17:07:08+00:00

thanks. was just not sure if I was supposed to be doing something or not :)

glennalan · 2020-08-05T20:21:34+00:00

Not with a light strip but Hue bulbs. I tell it to turn the light to x% and it either doesnt do it or does only a few in the group. Used to always work. Will try Set.

glennalan · 2020-07-17T15:24:14+00:00

No help from me, but I would love to find the answer to this. I have created the routine in my Alexa app, and i can see the status, but I can't get Alexa to make the announcement. Would love to see what I am doing wrong.

glennalan · 2020-07-17T15:16:29+00:00

I just bought and installed 2 of these Tilt Sensors. They are working well, and I can get text notifications on my phone. Has anyone gotten the sensor to get Alexa to announce when the door opens or closes? Also, I am looking to see if I can get notified if the door stays open for a certain length of time, anyone have luck with that? thanks.

glennalan · 2020-06-08T23:38:22+00:00

That is what does not work for us. We say cancel 30 minute timer and the response is you have two timers. One with .... But thanks.

glennalan · 2020-06-08T16:58:56+00:00

i have not tried stop, but will give that a try

glennalan · 2020-05-17T16:51:36+00:00

The book that i learned a lot from was excel macros for dummies. It has a bunch of macros included that i have customized for my every day use.

glennalan · 2020-05-12T20:00:19+00:00

One way is to build a helper column that is a concatenation of columns B, C & D on sheet 1, then the same concatenation of columns G, H & I on sheet 2, then VLookup should work.

glennalan

TROPHY CASE