pbartxl

/* FUNCTION NAME:  MAPλ
    DESCRIPTION:    Implements a version of MAP that will return an array of arrays */
/*  REVISIONS:      Date            Developer           Description
                    28 Aug 2024     Peter Bartholomew   Adapted from BYROWλ to give MAPλ 
                    31 Aug 2024     Peter Bartholomew   JOINPAIRSλ modified to stack 2D result arrays
                    10 Sep 2024     Peter Bartholomew   Modified to accept 3 array argumments before λ-function
                    15 Nov 2024     David Clements      Improved branching using CHOOSE
*/
MAPλ = LAMBDA(
    //  Parameter Declarations     

CHatmaker

/*  FUNCTION NAME:  Aboutλ
    DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/
/*  REVISIONS:      Date            Developer       Description  
                    Mar 17 2023 Craig Hatmaker  Copyright
                    Apr 17 2023 Craig Hatmaker  Reorganizing and adding help
                    Jul 03 2023 Craig Hatmaker  See nFoldCartProdλ and PriorDimProdλ
                    Jul 11 2023 Craig Hatmaker  See UnPivotDetailλ
                    Feb 11 2024 Craig Hatmaker  See UnPivotDetailλ
*/

CHatmaker

/*  FUNCTION NAME:  Aboutλ
    DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/
/*  REVISIONS:      Date        Developer       Description  
                    Mar 02 2023 Craig Hatmaker  Original Development
                    Jun 08 2023 Craig Hatmaker  CBSE Compliant
                    Jan 17 2024 Craig Hatmaker  See DynamicArrayλ
*/

Aboutλ =TEXTSPLIT(
    "About:                         →BXL's Dynamic Array module. Suggested module name: BDR¶" &

CHatmaker

/*  Function        Description
    Aboutλ          About this module and links to online resources
    Fibonacciλ      Determine the nth number in a Fibonacci sequence 
*/




/*  FUNCTION NAME:  Aboutλ
    DESCRIPTION:*/  /**Displays the URL to this module's Gist which includes documentation*/

halbuki

/* USE NAMESPACE "List" */

Accumulate = LAMBDA(_list, _seed, _accumulator, REDUCE(_seed, _list, _accumulator));

AllTrue = LAMBDA(_list, AND(_list));

AnyTrue = LAMBDA(_list, OR(_list));

Average = LAMBDA(_list, AVERAGE(_list));

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

CHatmaker

/*  Module Contains 5g Compliant functions 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λ

CHatmaker

/*  FUNCTION NAME:  CrtIdxλ
    DESCRIPTION:*/  /**Creates an array of indexes that can be used with INDEX() can combine  
                        all rows in all tables as would a database 'Natrual Join' or 'Cross Join.'*/
/*                  This was developed for multidimensional modeling. A key to multidimensional modeling
                    is the ability to combine all instances of all dimensions, and then access each 
                    dimension's value. A dimension is a category of things like:
                        Customers, Products, Regions, Months, etc.
                        
                    When faced with the situation where each dimension has a piece of information needed
                    for a particular calculation such as:

ncalm

/*
OUTLIERS

These lambda functions allow us to quickly apply the standard deviation test to a series of transformed variables

Included in this file:

OUTLIER.THRESHOLDS - for calculating outlier thresholds using a standard deviation test

inputs:

ncalm

/*
ISLEAPYEAR

Calculates whether a year is a leap year

Inputs:
  - yr is the year you want to test
  
Returns:
  TRUE if the year is a leap year, FALSE otherwise