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:

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 
*/

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))

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. 

ncalm

/*
array is a column of stuff to which we want to apply element function
row_function is some function that produces an array with a fixed number of columns
  the column count produced by row_function must be identical regardless of input
stack_function is one of V or H

If you're unsure how these work or why we would use them, please review these videos:
https://youtu.be/04jOeiMypXw
https://youtu.be/wEBLT9QfQRw

ExcelRobot

/*
Excel Array Manipulation LAMBDA functions
Courtesy of Excel Robot

The Microsoft Excel team recent released 11 new Excel functions for combining, shaping, and resizing arrays.
I had already created similar ones for myself using the amazing LAMBDA function.  Since the new functions
are only available to users running Beta Channel, I've renamed my versions and given them the same function 
names so anyone with LAMBDA and LAMBDA helper functions (like MAKEARRAY), and import these LAMBDAs into your
workbook and have nearly the same functionality.

cwas101

//All in 1 change formulas, EXCEPT EARNINGS RATIO------------------
//New is the column with the most recent values
//Old is the column with the older values
Change=
LAMBDA(
    NEW, OLD,
   IFERROR(IF(AND(LEFT(CELL("format",NEW),1)="P", LEFT(CELL("format",OLD),1)="P"),
NEW-OLD,

ExcelExciting

/*
TIRED OF WRITING EXCEL FORMULA AGAIN AND AGAIN, WELL EXPORT THIS LAMBDA LINK INTO YOU EXCEL WORKBOOK AND ENJOY THE USING THE CODE. DON'T FORGET THE SHARE AND LIKE.
EACH LAMBDA IS CREATED BY DIFFERENT AUTHOR, PLEASE REFER TO DETAILS WITHIN EACH FORMULA
*/

/*
--------------------- HIJRI AGE CALCULATOR ---------------------
*/
HIJRIAGE =
/*Hijri Age Calculator allows you to calculate the age of person as per arabic calander.

G33kDude

#NoEnv
SetBatchLines, -1

#Include <Socket>

MATRIC_CONFIG_PATH := A_Desktop "\..\Documents\.matric\config.json"
APP_NAME := "AutoHotkey"
API_PORT := 50300
RESP_PORT := 50301

Aldaviva

Easy PowerShell Remoting

PowerShell Remoting allows you to connect to a remote shell on another Windows computer.

The server is the Windows computer that will host the shell, and that you will connect to. The client is the Windows computer that will create the connection, on which you will see and interact with the shell.

These steps assume a workgroup with Windows 10 or Server 2016 or later on the server, and Windows 7 or later on the client. It assumes that the client is running with a user account that also exists on the server with the same password. Neither the server nor the client need to be joined to a domain or using Kerberos.

Prerequisites