Craig Hatmaker BXL CHatmaker
CHatmaker
/ BXL 5g Functions for Excel: Date Library 2026
Created
June 26, 2026 15:23
BXL 5g Functions for Excel: Date Library 2026
This file contains hidden or 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 modules function list, version, and Gist and website URLs*/ | |
| /* REVISIONS: Date Developer Description | |
| Jun 26 2026 Craig Hatmaker New Version | |
| */ | |
| Aboutλ = TRIM( | |
| TEXTSPLIT( | |
| "About: →5g functions dealing with dates in models. Suggested module name: BXD¶" & |
CHatmaker
/ BXL 5g Functions for Excel: Debt Library 2026
Last active
July 3, 2026 11:31
BXL 5g Functions for Excel: Debt Library 2026
This file contains hidden or 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 03 2026 Craig Hatmaker Copyright - New Version | |
| */ | |
| Aboutλ = TRIM( | |
| TEXTSPLIT( | |
| "About: →5g Compliant functions that deal with debt and loans. Suggested module name: BXL¶" & | |
| "Version: →BXL: Jul 03 2026¶" & | |
| "Gist URL: →https://gist.github.com/CHatmaker/2ebb5b42457f35a36da103dd9b8d15fb ¶" & |
CHatmaker
/ BXL 5g Skill
Last active
July 3, 2026 20:35
Experimenting with skills for Copilot For Excel
This file contains hidden or 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
| # 5G LAMBDA Template Skill | |
| # Version: 1.4 | |
| # Last Updated: May-20-2026 | |
| skill: | |
| name: lambda-template-5g | |
| description: > | |
| Rules and conventions for creating well-structured Excel LAMBDA functions | |
| with inline help documentation using the Advanced Formula Environment (AFE). | |
| Follows 5th Generation Modeling standards from 5gmodelling.com. |
CHatmaker
/ BXL 5g Functions LAMBDA Debt
Last active
June 27, 2026 13:06
BXL 5g Functions LAMBDA Debt (Deprecated: Use Debt Library 2026)
This file contains hidden or 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 debt and loans. */ | |
| /* FUNCTION NAME: Aboutλ | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Nov 07 2025 Craig Hatmaker Copyright | |
| Nov 18 2025 Craig Hatmaker Loan Label Adjustments | |
| Nov 27 2025 Craig Hatmaker Added AdaptToTimelineλ | |
| Nov 29 2025 Craig Hatmaker See DebtLabelsλ | |
| Dec 06 2025 Craig Hatmaker See Installmentλ & AdaptToTimelineλ |
CHatmaker
/ BXL 5g Functions LAMBDA Text
Created
September 24, 2025 01:06
BXL 5g Functions LAMBDA Text
This file contains hidden or 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
| /* Text Function - A collection of functions for working with text.*/ | |
| /* FUNCTION NAME: Aboutλ | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Aug 23 2025 Craig Hatmaker Copyright | |
| */ | |
| Aboutλ = TRIM(TEXTSPLIT( | |
| "About: →A collection of functions for working with text. Suggested module name: TXT¶" & | |
| "Version: →BXL: Aug 23 2025¶" & |
CHatmaker
/ BXL 5g Functions LAMBDA for Excel: Financial Model Utilities
Last active
August 18, 2025 01:34
BXL 5g Functions LAMBDA for Excel: Financial Model Utilities
This file contains hidden or 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 | |
| Apr 10 2025 Craig Hatmaker Original Development | |
| Apr 22 2025 Craig Hatmaker See Refs2Txtsλ | |
| */ | |
| Aboutλ = TRIM(TEXTSPLIT( | |
| "About: →BXL's Financial Model Utilities. Suggested module name: FMU¶" & | |
| "Version: →BXL: Apr 22 2025¶" & |
CHatmaker
/ BXL 5g Functions LAMBDA Financial Models 2025
Last active
July 1, 2026 00:50
BXL 5g Functions LAMBDA Financial Models 2025
This file contains hidden or 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
| // BXL 5g Functions: Financial Library 2025 | |
| /* 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 | |
| Aug 07 2025 Craig Hatmaker Version 2 | |
| Sep 27 2025 Craig Hatmaker See Growthλ | |
| Oct 06 2025 Craig Hatmaker Added CorkscrewAλ | |
| Oct 08 2025 Craig Hatmaker Prep for loading to gist |
CHatmaker
/ BXL LAMBDA 5g Functions Dates 2025
Last active
November 29, 2025 22:01
BXL LAMBDA 5g Functions Dates 2025
This file contains hidden or 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 modules function list, version, and Gist and website URLs*/ | |
| /* 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
August 18, 2025 01:35
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 hidden or 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
July 1, 2026 00:57
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 hidden or 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 |
NewerOlder