ncalm

/*
Credit: Peter Bartholemew
https://www.linkedin.com/in/peterbartholomew/
https://techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/214174#profile

---

BMAPλ

Recursively bisects an array and applies a function to the leaf nodes. 

teleksterling

Header = LAMBDA(Table, TAKE(Table, 1));

Data = LAMBDA(Table, DROP(Table, 1));

ConstArray = LAMBDA(value, rows, columns, 
    EXPAND(value, rows, columns, value)
);

Reverse = LAMBDA(array,
    LET(seq, SEQUENCE(ROWS(array)), SORTBY(array, seq, -1))

jonwittwer

/*  VERTEX42 LAMBDA LIBRARY
The functions included here are fully documented at the following site:
https://www.vertex42.com/lambda/

If importing this Gist into a separate module via the Excel Labs add-in, 
the name of the module (such as "VLL") is added to the beginning of the function
names in the Name Manager. For example, RESCALE would become VLL.RESCALE

Here are a few examples of module names you could use: L, VLL, LIB, LL 
*/

Grooviee

blueprint:
  name: ZHA - Xiaomi Aqara Wireless Mini Switch (WXKG11LM)
  description: Automate your Xiaomi Aqara Wireless Mini Remote Switch using ZHA events. Based on the blueprint from carlosmesquita
  domain: automation
  input:
    mijia_square_switch:
      name: Aqara Wireless Square Switch
      description: Aqara Wireless Square Switch to use
      selector:
        device: