SONOFF ZigBee 3.0 Micro USB Adaptor, USB 2.0 High Speed Adaptor, Smart USB Switch 5V-22V, Support Fast Charging Adaptor, Compatible with Alexa, Google Home, Requires ZigBee hub, ZBMicro

Excellent for network stability!
Got these to fix a zigbee network that was constantly dropping off devices here and there, sometimes after minutes sometimes after days, since installing these in some locations throughout the house the links of devices all skyrocketed to 120+ link quality and my whole network seems to be stable, now its been a few days and no drop offs have happened!Using these with zigbee2mqtt pairing was fast and the rf turbo mode is available and turning it on increased the link quality even more. Since i got low amounts of 2.4ghz equipment this is not an issue.The plus side is the toggle for the usb port, fibally a way to turn a “smart” led light on and off with automation.The switch is silent, has no sound what so ever when turning on or off.Definitely a great addition to my zigbee network all sems to be stable and happy. The ends are a bit bulky but not a problem.Can be powered from a wall outlet, a phone charger or any usb port really.Might be a bit expensive but worth it. Works with aqara sensors as well as tuya and sonoff.

Used for some led lights
Seem to work fine so far and I’m using home assistant. Paired quickly no problems so far. I use them to turn some usb lights on.

the smallest zigbee repeater which also acts as a USB power switch. Perfect for xmas lights.
Bought to extend a zigbee network – easily configured and works well. Also doubles as a USB powered device switch so handy for turning on low powered xmas lights and other usb powered devices. Joins zigbee immediately and thankfully does not need any chinese rubbish app to work.

Good
Worked right out of the box

PROS:ReliableFairly CompactVersatileCONS:Requires separate powerForm factor might work better as a dongle as opposed to a brickGreat device overall. Does what I need it to do. Just to be clear about what this is: This is a Zigbee-controlled device that simply switches a USB connection on or off. This means it can be used in between a USB power brick and a USB device to turn something on or off or some people use it to connect or disconnect a USB data connection since it also works for that. These are very specific use cases but as long as you know what you’re buying, it works great. This biggest thing to note is that IT DOES NOT PROVIDE POWER. If your USB source is not providing power, this will be useless. This means it needs to be connected to a powered device such as a USB power brick, computer, car, charger, or anything that is providing USB power. The only bad thing I can say about it is that its form-factor might be an issue in some cases considering it’s cube-shaped. If it were shaped like a dongle it might allow it be used in tighter spaces.

Sub CalculateMoMMovements()Dim ws As WorksheetDim macroSheet As WorksheetDim monthToFind As StringDim momCol As Long, monthCol As LongDim r As Long, lastRow As LongDim headerRow As LongDim val1 As Variant, val2 As VariantSet macroSheet = ThisWorkbook.Sheets(“Macro”)monthToFind = Trim(macroSheet.Range(“E1”).Value)If monthToFind = “” ThenMsgBox “Macro!E1 is empty. Please enter a month name.”, vbExclamationExit SubEnd If’ Loop through each sheet EXCEPT the Macro sheetFor Each ws In ThisWorkbook.WorksheetsIf ws.Name <> “Macro” ThenmomCol = 0monthCol = 0′ Search rows 1 to 4 for headersFor headerRow = 1 To 4For col = 1 To ws.Cells(headerRow, ws.Columns.Count).End(xlToLeft).ColumnIf LCase(ws.Cells(headerRow, col).Value) = “mom movements” ThenmomCol = colElseIf Trim(LCase(ws.Cells(headerRow, col).Value)) = LCase(monthToFind) ThenmonthCol = colEnd IfNext colNext headerRowIf momCol = 0 Or monthCol = 0 ThenMsgBox “Sheet ‘” & ws.Name & “‘ is missing either MOM Movements or the month ‘” & monthToFind & “‘ in rows 1–4.”, vbExclamationGoTo NextSheetEnd IflastRow = ws.Cells(ws.Rows.Count, monthCol).End(xlUp).Row’ Start from row 5For r = 5 To lastRowval1 = ws.Cells(r, momCol – 1).Value ‘ previous column before MoMval2 = ws.Cells(r, monthCol).Value ‘ month valueIf IsNumeric(val1) And IsNumeric(val2) Thenws.Cells(r, momCol).Value = val1 – val2Elsews.Cells(r, momCol).Value = CVErr(xlErrNA)End IfNext rEnd IfNextSheet:Next wsMsgBox “MoM calculation complete.”, vbInformationEnd Sub

Der Sonoff Zigbee USB-Dongle hat mich auf ganzer Linie überzeugt. Ich verwende ihn in Kombination mit Home Assistant und Zigbee2MQTT (Z2M), und die Integration funktionierte völlig problemlos. Der Stick wurde direkt erkannt, die Einrichtung war in wenigen Minuten abgeschlossen.Besonders positiv: Er fungiert nicht nur als Endgerät, sondern auch als Repeater im Zigbee-Netzwerk. Das verbessert die Reichweite und Stabilität des gesamten Mesh-Netzes spürbar – ideal in größeren Wohnungen oder Häusern mit mehreren Zigbee-Geräten. In meinem Setup hat sich der Empfang durch diesen Stick deutlich verbessert.Die Empfangsqualität ist durchweg sehr gut, auch Geräte, die vorher nur sporadisch erreichbar waren, lassen sich nun stabil steuern. Das macht ihn zu einer echten Empfehlung – nicht nur als Schnittstelle, sondern auch zur Netzwerkerweiterung.Verarbeitung und Kompatibilität stimmen ebenfalls. Für den günstigen Preis bekommt man hier ein sehr zuverlässiges und leistungsfähiges Gerät. Für alle Home Assistant-Nutzer mit Zigbee-Komponenten ist dieser Dongle fast schon ein Pflichtkauf. Klare Empfehlung!