Craig Hatmaker BXL CHatmaker
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
/ 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
/ 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
/ 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¶" & |
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 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 |
NewerOlder