Skip to content

Instantly share code, notes, and snippets.

View ncalm's full-sized avatar
💭
hitting computer with hammer

Owen Price ncalm

💭
hitting computer with hammer
View GitHub Profile
@Bhavya2502
Bhavya2502 / Number_To_Words
Created August 9, 2022 13:17
Convert Very Large Numbers to Words for both Indian as well as International Numbers
/* Link to YouTube Video - https://www.youtube.com/watch?v=u1gzAcwmlpo*/
Number_To_Words = LAMBDA(Number, [Indian_or_InterN],
LET(
Option, IF(ISOMITTED(Indian_or_InterN), 1, Indian_or_InterN),
l, LEN(Number),
L_1, SEQUENCE(19),
R_1, VSTACK(
"One",
"Two",
@halbuki
halbuki / EXNAL
Last active September 1, 2022 14:41
Excel Lambda functions for numerical analyses
/* ROOTS OF FUNCTIONS */
BISEC = LAMBDA(f, lbound, ubound, [prec],
LET(
c, (lbound + ubound) / 2,
fl, f(lbound), fu, f(ubound), fc, f(c),
IF(
ABS(fc) < MAX(prec, 1E-15),
c,
IF(
SIGN(fl) = SIGN(fc),
@ExcelRobot
ExcelRobot / CROSSJOIN.lambda
Last active February 24, 2025 15:26
Cross Join LAMBDA Function
/*
Name: Cross Join Two Arrays or Tables (CROSSJOIN)
Description: Returns all possible combinations of two arrays of data, with or without header rows.
If the arrays have only one row, it will be assumed that they are row vectors, otherwise it
assumes the arrays are columns of data.
Parameters:
array1 - first array of data with one or more columns
array2 - second array of data with one or more columns
[has_header_row] - true if the first row of the arrays contain a header row, default: false
Source: Excel Robot (@ExcelRobot)
@ExcelRobot
ExcelRobot / mandelbrot.lambda
Last active March 11, 2025 15:54
Mandelbrot Lambda
/*
Name: Mandelbrot Set (Mandelbrot)
Description: Generates a Mandelbrot set based on given assumptions that can be used with conditional formatting to view the visual representation.
Parameters:
xleft - Left X value
xright - Right X value
ytop - Top Y value
ybottom - Bottom Y value
size - number of columns/rows in square output range
iterations - number of iterations
@jsb2505
jsb2505 / Geotech.txt
Last active October 3, 2023 10:03
A module of geotechnical related lambda functions.
/**Partial factor for action DA1 C1 or C2.
EXPECTED INPUTS:
Combination = 1 or 2.
Action = "permanent" or "variable".
Favourability = "unfavourable" or "favourable".
*/
Get_γ_action = LAMBDA(combination_1_or_2_as_number, action, [favourability],
LET(
_favourability, IF(ISOMITTED(favourability), "unfavourable", LOWER(favourability)),
_action, LOWER(action),
// --- Workbook module ---
// A file of name definitions of the form:
// name = definition;
// --- Workbook module ---
// Rows => ; Columns => ,
// arr, {a, b, c;
// d, e, f}
// Access row 1 => index(arr, , 1)