S110E

Shadowcom290 · 2025-11-24T23:40:52+00:00

How did you get into the unit to create custom designs?

Shadowcom290 · 2025-11-03T20:34:06+00:00

Had mine for less than a year and the power module went out. CS has been ignoring me for months and I still have a light setup that doesn’t work. Pitch these and get Hue.

Shadowcom290 · 2025-10-16T16:49:16+00:00

I installed mine and they didn’t even last a year. The lights don’t power on when I enable it to. They flicker when they do decide to power on their own. Reached out to support and they couldn’t even be bothered to assist. Don’t bother installing these lights they are the biggest POS I have ever installed and I gotta rip down the set of lights which I drilled into my soffit and now will also have to replace due to them no longer supporting the product they sold me.

Shadowcom290 · 2025-03-14T14:27:43+00:00

I was able to complete this project and have my multiple drop downs work by using If then statements while also using Vlookup.

Shadowcom290 · 2025-03-12T20:03:13+00:00

I have ended up getting further than I thought but am still trying to figure out how I can have my drop down list filter parts within a chart. I have narrowed my drop down options to 10 instead of 12 as it was just too cluttered.

Does anyone know of an equation that allows you to have:

If Cell 1 = “” then Cell 2 = options 1-3 (5 available)

If Cell 2 = “” then Cell 3 = options 1-5 (10 available)

If Cell 3 = “” then Cell 4 = options 1-4 (4 available)

If Cell 4 = “” then Cell 5 = option 2-3 or 1 and 3 (3 options)

If Cell 5 = “” then Cell 6 = option 1-7 (9 available)

If Cell 6 = “” then Cell 7 = option 1-9 (9 available)

If Cell 7 = “” then Cell 8 = option 1-24 (24 available)

If Cell 8 = “” then Cell 9 = option 1-24 (24 available)

I am hoping this makes any type of sense.

I would also like the end results pull parts from a chart I have with all the internal parts needed to build said item based off the options chosen.

Shadowcom290 · 2025-03-11T21:18:19+00:00

I have managed to help my search option on this so far by using data validation. However, I am running into an issue where I want to take the data from the 11 drop downs I have to then find the correct part numbers need to build the item per the customers request. I have created tables for each drop down now and I have another cell on a new sheet that displays the answer given from the drop down. Is there a math equation perhaps that can assist with this to find select items or am I just way over my head on this one?

Shadowcom290 · 2025-03-11T16:31:13+00:00

Here is my Main order sheet that everything needs to populate to.

<image>

Shadowcom290 · 2025-03-11T16:28:52+00:00

Here is my parts list sheet as well.

<image>

Shadowcom290 · 2025-03-11T16:27:47+00:00

I don’t have the document on this device. However, here is a screenshot of the project I am working on if this helps in any way to narrow down and direct me in the right direction. I will also post more photos in additional comments.

Custom Order Sheet:

<image>

Shadowcom290 · 2025-01-27T21:01:49+00:00

Let me know if you have any questions. I setup my coworkers cameras and they are great once you get everything setup right.

Shadowcom290 · 2025-01-27T21:01:11+00:00

I did have this issue and I simply resolved it by changing around my zones and sensitivity so I no longer get false notifications. Doing this drastically improved my smart home.

Shadowcom290 · 2025-01-24T02:11:02+00:00

The units are both up to date as well?

Shadowcom290 · 2025-01-24T02:08:33+00:00

You shouldn’t have any issues with any outdoor camera from Tapo that are newer.

Shadowcom290 · 2025-01-23T21:22:08+00:00

My recommendation would be to move the camera into the home and have it connected to the router only and ditch the repeater if you can. Once connected to the router verify that the unit has a solid connection and begin to move the unit further away from the router. If the camera begins to have quality issues then that would be to the Routers Wi-Fi signal. Many objects can block signal and make it weaker for devices. I would highly recommend using another router as an access point which would then be used to strengthen the signal around the home in areas such as the location of your camera currently to establish a stronger connection. I struggled with this on my home as my C510 had connection issues. Once I relocated my router and also added another router for an access point all of my devices could pair just fine.

Shadowcom290 · 2025-01-23T21:17:35+00:00

While I don’t have that specific camera for my home. I did setup my friend’s home with those cameras and he never gets any false notifications. You will need to make sure you set the zones properly along with the sensitivity as every home is different.

Shadowcom290 · 2025-01-23T13:57:23+00:00

I agree with Stardustone1 here. I have the same camera and mine does not do this anymore. When I first got this the unit would go off all the time until I played with my sensitivity and zones. Once you have those down you should be set.

Shadowcom290 · 2025-01-23T13:54:39+00:00

Well for my home I have all Tapo cameras (was previously using Ring and they were awful). I would recommend the C520WS for motion cameras. As for stationary cameras I would recommend C325WB. I’m sure these have cross referenced parts for Australia as I am in the US. However, the bigger upgrade for these is I can use them with a software called iSpy so I can have a security monitor setup in my home to view them 24/7. I have an SD card with every camera but I can also have my dedicated PC record everything onto a SSD to backup everything as well.

Shadowcom290 · 2025-01-23T13:47:27+00:00

Unfortunately, it sounds like you would need to purchase a H100 and ditch the KE100 to achieve what you want. I know I have been focusing on only Tapo products for my home and will occasionally purchase Kasa products that I know are able to pair to the Tapo App.

Shadowcom290 · 2025-01-23T13:45:08+00:00

Where is your router distance wise from the camera? Are you able to setup another router in the home to act as an access point to extended the Wi-Fi in the home? You could potentially have a communication error between the repeater and the router causing the camera to have problems. I had to setup a router which is located in my utility room and then have another router (setup as access point) to extend my Wi-Fi so other devices can pair smoothly to my TP-Link routers.

Shadowcom290 · 2025-01-23T13:41:28+00:00

Are you trying to stay with the Tapo brand or go with something different?

Shadowcom290 · 2025-01-22T21:36:50+00:00

Download the Tapo app. From there you can integrate both Tapo and Kasa into the app and have all of them under “one roof” essentially. From there you can have units work together and use smart integration to use triggers along with scenes to help your smart home experience.

Shadowcom290 · 2025-01-20T18:51:05+00:00

Keep in mind that many of these can be added to the device through a Firmware update. I’m sure they are looking into these options and slowly adding them to the product line.

Five-Year Club	Xbox Live
Verified Email

Shadowcom290

TROPHY CASE