This file contains 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
/* 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", |
This file contains 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
/* 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), |
This file contains 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
/* | |
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) |
This file contains 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
/* | |
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 |
This file contains 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
/**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), |
This file contains 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
// --- 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) |
OlderNewer