sittim

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

jsb2505

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

ExcelRobot

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

ExcelRobot

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

halbuki

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

Bhavya2502

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

CHatmaker

/*  Module Contains 5g Compliant LAMBDAs that deal with dates */

/*  FUNCTION NAME:  Aboutλ
    DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/
/*  REVISIONS:      Date        Developer       Description  
                    Mar 17 2023 Craig Hatmaker  Original Development
                    Mar 22 2023 Craig Hatmaker  Added About
                    Apr 06 2023 Craig Hatmaker  Added Help to LAMBDAs
                    Aug 28 2023 Craig Hatmaker  Conformed to new template
                    Jan 02 2024 Craig Hatmaker  See CountDOWλ

ExcelRobot

/*
Name: Unpivot Table (UNPIVOT)
Description: Given a table range with headers and array of header names, unpivots the 
   specified columns in place, optionally removing any blank entries.
Written By: Excel Robot (@ExcelRobot)
Category: Array
*/
UNPIVOT=LAMBDA(table,[columns_to_unpivot],[attribute_name],[value_name],[remove_blanks], LET(
   _ColumnsToUnpivot, IF(
      ISOMITTED(columns_to_unpivot),

SergeiStPete

/*
Partly taken from samples to AFE
https://github.com/microsoft/advanced-formula-environment
more exactly from
https://github.com/microsoft/advanced-formula-environment/blob/main/examples/Lib.md
*/

// ======================================================================================================
// Timing a computation wrapped in a thunk

ExcelRobot

/*
Name: Convert Number To Ordinal (ADDTH)
Description: Converts number to ordinal ie: 1st, 2nd, 3rd, 4th, 11th, 12th, 13th, 21st, etc.
Author: Excel Robot (@ExcelRobot)
Inspired By: Rick de Groot (https://www.linkedin.com/posts/rickmaurinus_powerbi-businessintelligence-dax-activity-6920723485937790976-Wzdb?utm_source=linkedin_share&utm_medium=member_desktop_web)
Category: Conversion
*/
ADDTH = LAMBDA(number,LET(
    LastDigit, RIGHT(number),
    LastTwo, RIGHT(number, 2),