Craig Hatmaker CHatmaker
CHatmaker
/ BXL LAMBDA Financial Models
Last active
June 20, 2024 02:24
5g Function for Excel Financial Models
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
| /* FUNCTION NAME: Aboutλ | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Jul 13 2023 Craig Hatmaker Original Development | |
| May 13 2024 Craig Hatmaker Spring 2024 Version | |
| May 18 2024 Craig Hatmaker Added RollingAvgλ, RollingMinλ and RollingMaxλ | |
| May 28 2024 Craig Hatmaker See SumContainsλ | |
| May 29 2024 Craig Hatmaker See LabelAmortizeλ | |
| Jun 19 2024 Craig Hatmaker See RollingX functions | |
| */ |
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
| // Base Template | |
| /* FUNCTION NAME: <enter name here>λ | |
| DESCRIPTION:*//**<this comment displays in name manager>*/ | |
| /* REVISIONS: Date Developer Description | |
| <changed> <your name> <what changed> | |
| */ | |
| BaseTemplateλ = LAMBDA( | |
| // Parameter Declarations |
CHatmaker
/ BXL LAMBDA Array Essentials
Last active
June 6, 2024 15:48
5G functions for basic Excel Dynamic Array handling
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
| /* FUNCTION NAME: Aboutλ | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Feb 27 2024 Craig Hatmaker Copyright | |
| Jun 05 2024 Craig Hatmaker Code Simplification | |
| */ | |
| Aboutλ = TRIM(TEXTSPLIT( | |
| "About: →Basic functions for working with dynamic arrays. Suggested module name: BXE¶" & | |
| "Version: →Jun 06 2024¶" & |
CHatmaker
/ BXL LAMBDA Workbook Info
Last active
April 7, 2024 15:06
5G functions for Excel Workbook Information
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
| /* FUNCTION NAME: Aboutλ | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Dec 14 2023 Craig Hatmaker Original Development | |
| */ | |
| Aboutλ = TRIM(TEXTSPLIT( | |
| "About: →BXL's Workbook Information module. Suggested module name: BXW¶" & | |
| "Version: →Jun 12 2023¶" & | |
| "Gist URL: →https://gist.github.com/CHatmaker/3ff1b5ce97344c2dfc3f1623a656676a ¶" & |
CHatmaker
/ BXL LAMBDA Debt Module
Last active
February 3, 2024 00:07
5G functions for Excel for debt modeling
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
| /* FUNCTION NAME: Aboutλ | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Aug 10 2023 Craig Hatmaker Copyright | |
| Feb 02 2024 Craig Hatmaker See DebtSculptλ | |
| */ | |
| Aboutλ = TRIM(TEXTSPLIT( | |
| "About: →BXL's Debt module. Suggested module name: BXLDebt¶" & | |
| "Version: →Aug 10 2023¶" & |
CHatmaker
/ BXL LAMBDA Financial Models 2024-05-29
Last active
June 19, 2024 16:07
5G functions for Excel for Financial Models 2024-05-29
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
| /* FUNCTION NAME: Aboutλ | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Jul 13 2023 Craig Hatmaker Original Development | |
| May 13 2024 Craig Hatmaker Spring 2024 Version | |
| May 18 2024 Craig Hatmaker Added RollingAvgλ, RollingMinλ and RollingMaxλ | |
| May 28 2024 Craig Hatmaker See SumContainsλ | |
| May 29 2024 Craig Hatmaker See LabelAmortizeλ | |
| */ |
CHatmaker
/ BXL LAMBDA Reporting with Arrays
Last active
April 7, 2024 15:06
5G functions for Excel for Reporting with Arrays
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
| /* 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
/ BXL LAMBDA Dynamic Ranges
Last active
January 27, 2024 15:46
5G functions for Excel for Dynamic Ranges
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
| /* 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
/ BXL Excel LAMBDA Math
Last active
January 27, 2024 15:47
5G functions for Excel: Miscellaneous Math
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
| /* 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*/ |
CHatmaker
/ BXL LAMBDA Excel Dates.txt
Last active
June 12, 2024 01:24
5g Functions for Excel: Dates
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
| /* 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λ |
NewerOlder