Craig Hatmaker BXL CHatmaker
CHatmaker
/ BXL 5g Functions LAMBDA Financial Models 2025
Last active
April 6, 2025 07:37
BXL 5g Functions LAMBDA Financial Models 2025
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 | |
| Jul 17 2024 Craig Hatmaker IntOnInt位 fix |
CHatmaker
/ BXL LAMBDA 5g Functions Dates 2025
Last active
April 6, 2025 07:37
BXL LAMBDA 5g Functions Dates 2025
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 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
/ BXL 5g Functions LAMBDA RegEx Formula Prompter
Last active
April 6, 2025 07:37
When learners are entering formulas in instructional workbooks, RXFormulaPrompt位( Prompt, Formula, Entry), tells the learner what to enter and guides them in correcting errors.
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
| /* A collection of 5g Functions for creating classroom exercises that prompt | |
| learners during formula entry. Suggested module name: RXF | |
| */ | |
| /* FUNCTION NAME: About位 | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Dec 16 2024 Craig Hatmaker Copyright | |
| Dec 18 2024 Craig Hatmaker Added IsComment位, Display位Lines位, and Display位Prompts位 | |
| Jan 02 2025 Craig Hatmaker See FormulaSplit位 | |
| Jan 05 2025 Craig Hatmaker See DisplayEntries位 |
CHatmaker
/ BXL 5g Functions LAMBDA Array Essentials V2
Last active
April 6, 2025 07:37
Array Essentials Version 2.0: This version ads a few new functions and removes functions made relatively redundant with eta-reduced-formats.
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
| /* Array Essentials V2 - A collection of basic array 5g Functions | |
| This version trims the previous collection of 5g functions made redundant by eta-reduced syntax.*/ | |
| /* FUNCTION NAME: About位 | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Nov 29 2024 Craig Hatmaker Copyright | |
| Mar 11 2025 Craig Hatmaker General updates | |
| Mar 15 2025 Craig Hatmaker See MLookup位, XYLookup位 | |
| Mar 24 2025 Craig Hatmaker See DAF versions of common Excel functions |
CHatmaker
/ BXL 5g Functions LAMBDA Financial Ratios
Last active
March 11, 2025 16:51
5g Functions for Financial Ratios
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 a library of Financial Ratios */ | |
| /* FUNCTION NAME: About位 | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Jun 27 2024 Craig Hatmaker Copyright | |
| */ | |
| About位 = TRIM( | |
| TEXTSPLIT( | |
| "About: 鈫扐 library of Financial Ratios露" & |
CHatmaker
/ BXL 5g Functions LAMBDA Financial Models
Last active
February 4, 2025 11:14
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 | |
| Jul 17 2024 Craig Hatmaker IntOnInt位 fix |
CHatmaker
/ BXL 5g Functions LAMBDA Modeling Templates
Last active
March 11, 2025 23:22
BXL 5g Functions LAMBDA Modeling Templates
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 5g Functions LAMBDA for Excel Array Essentials
Last active
February 4, 2025 11:19
BXL 5g Functions LAMBDA for 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 | |
| Sep 05 2024 Craig Hatmaker Added RunTotCols位 and RunTotRows位 | |
| */ | |
| About位 = TRIM(TEXTSPLIT( | |
| "About: 鈫払asic functions for working with dynamic arrays. Suggested module name: BXE露" & |
CHatmaker
/ BXL 5g Functions LAMBDA Workbook Info
Last active
February 4, 2025 11:18
BXL 5g Functions LAMBDA 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: 鈫払XL's Workbook Information module. Suggested module name: BXW露" & | |
| "Version: 鈫扟un 12 2023露" & | |
| "Gist URL: 鈫抙ttps://gist.github.com/CHatmaker/3ff1b5ce97344c2dfc3f1623a656676a 露" & |
CHatmaker
/ BXL 5g Functions LAMBDA for Excel Debt Module
Last active
February 4, 2025 11:20
BXL 5g Functions LAMBDA 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: 鈫払XL's Debt module. Suggested module name: BXLDebt露" & | |
| "Version: 鈫扐ug 10 2023露" & |
NewerOlder