I've moved this to a repo as it's easier to see what's going on:
The Boobook the-boobook
ExcelRobot
/ ArrayManipulation.lambda
Last active
February 28, 2025 11:45
Array Manipulation LAMBDA Functions
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| 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. |
jkpieterse
/ Excel-lambda-water97.txt
Last active
February 25, 2026 16:50
Excel Lambda functions to calculate thermodynamic properties of water
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| cpreg1 = LAMBDA(temp, press, | |
| LET( | |
| tau, 1386 / temp, | |
| pi, 0.1 * press / 16.53, | |
| -0.001 * rgas_water * tau ^ 2 * gammatautaureg1(tau, pi) | |
| ) | |
| ); | |
| cpreg2 = LAMBDA(temp, press, | |
| LET( |
jkpieterse
/ excel-lambda-quadraticequation.txt
Last active
August 26, 2023 03:40
Excel lambda formula to calculate roots of a parabola
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| QuadraticEquation = LAMBDA(a, b, c, | |
| (-b + {-1, 1} * SQRT(b ^ 2 - 4 * a * c)) / 2 / a | |
| ); |
jkpieterse
/ excel-lambda-SheetName.txt
Last active
March 2, 2025 20:22
Excel lambda to get the name of the worksheet into a cell. Import this using the Excel Advanced Formula Environment add-in
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SheetName =LAMBDA(cl,LET(f,CELL("filename",cl),MID(f,FIND("]",f)+1,LEN(f)))) |
0xfeeddeadbeef
/ Test-ProcessElevated.ps1
Last active
June 20, 2024 18:26
Test whether or not a process is elevated (UAC run as admin)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function Test-ProcessElevated | |
| { | |
| [CmdletBinding()] | |
| [OutputType([bool])] | |
| param ( | |
| [Parameter(Mandatory = $true, ValueFromPipeline = $true)] | |
| [System.Diagnostics.Process] $Process | |
| ) | |
| begin { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Go to where Firefox is installed. (%programfiles%\Mozilla Firefox) | |
| Put the "mozilla.cfg" file in the current folder. (%programfiles%\Mozilla Firefox) | |
| Put the "local-settings.js" file in the defaults\pref folder. (%programfiles%\Mozilla Firefox\defaults\pref) |
jdhitsolutions
/ Get-GPLink.ps1
Created
January 18, 2021 16:47
A PowerShell function to list Group Policy links
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #requires -version 5.1 | |
| #requires -module GroupPolicy,ActiveDirectory | |
| Function Get-GPLink { | |
| <# | |
| .Synopsis | |
| Get Group Policy Object links | |
| .Description | |
| This command will display the links to existing Group Policy objects. You can filter for enabled or disabled links. The default user domain is queried although you can specify an alternate domain and/or a specific domain controller. There is no provision for alternate credentials. |
exhuma
/ wincred.py
Last active
September 2, 2024 15:57
— forked from mrh1997/wincred.py
Retrieve Windows Credential via Python
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| """ | |
| Access windows credentials | |
| Credentials must be stored in the Windows Credentials Manager in the Control | |
| Panel. This helper will search for "generic credentials" under the section | |
| "Windows Credentials" | |
| Example usage:: | |
| result = get_generic_credential('foobar') |
Ioan-Popovici
/ SIT Device by Boundary and Network.sql
Last active
May 31, 2024 12:13
List devices by boundary group, boundary and network information.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| .SYNOPSIS | |
| List devices by boundary and network information. | |
| .DESCRIPTION | |
| List devices by boundary group, boundary and network information. | |
| .NOTES | |
| Created by Ioan Popovici | |
| Part of a report should not be run separately. | |
| Requires | |
| CM_Tools.dbo.ufn_IsIPInSubnet |
NewerOlder