Craig Hatmaker BXL CHatmaker
CHatmaker
/ BXL 5g Functions for Excel: Debt Library 2026
Last active
September 6, 2026 00:08
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 | |
| Aug 21 2026 Craig Hatmaker Copyright - New Version | |
| Sep 05 2026 Craig Hatmaker See Balloonλ, TermLoanλ, InputLabelsλ | |
| */ | |
| Aboutλ = TRIM( | |
| TEXTSPLIT( | |
| "About: →5g Compliant functions that deal with debt and loans. Suggested module name: BXL¶" & | |
| "Version: →BXL: Sep 05 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
| --- | |
| name: function-test | |
| description: Tests a custom Excel function by randomizing input arguments and verifying its spilled output produces identical results to a reference formula. | |
| --- | |
| metadata: | |
| version: 1.0.0 | |
| tags: | |
| - excel |
CHatmaker
/ BXL LAMBDA 5g Functions Dates 2025
Last active
September 1, 2026 16:05
(Deprecated) 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 for Excel: Date Library 2026
Last active
September 1, 2026 16:05
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 | |
| Sep 01 2026 Craig Hatmaker Added DateDifλ | |
| */ | |
| Aboutλ = TRIM( | |
| TEXTSPLIT( |
CHatmaker
/ add-debt-schedule
Created
August 21, 2026 16:23
BXL's Copilot Skill to Add a Debt Schedule
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
| --- | |
| name: add-debt-schedule | |
| description: Adds a debt schedule | |
| --- | |
| metadata: | |
| version: 1.0.0 | |
| tags: | |
| - excel | |
| - lambda | |
| - afe |
CHatmaker
/ amortizedebt
Last active
August 5, 2026 21:46
Copilot Skill for adding AmortizeDebtλ to financial models
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
| --- | |
| name: amortizedebt | |
| description: Assists in configuring inputs for and linking them to the 5g function, AmortizeDebtλ. | |
| --- | |
| metadata: | |
| version: 1.0.0 | |
| tags: | |
| - excel | |
| - lambda | |
| - afe |
CHatmaker
/ convert-to-5g
Last active
August 5, 2026 21:45
Copilot Custom Skill to convert formula sections into named LAMBDA functions that comply with 5g standards
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
| --- | |
| name: convert-to-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. | |
| --- | |
| metadata: | |
| version: 1.0.5 | |
| tags: | |
| - excel | |
| - lambda | |
| - afe |
CHatmaker
/ (Deprecated: Use Debt Library 2026) BXL 5g Functions LAMBDA Debt
Last active
July 4, 2026 16:04
(Deprecated: Use Debt Library 2026) BXL 5g Functions LAMBDA Debt
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 for Excel Dynamic Ranges
Last active
July 3, 2026 20:20
BXL 5g Functions LAMBDA for Excel for Dynamic Ranges
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 | |
| 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 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