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¶" & |
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
/ 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
/ 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 |
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 |
OlderNewer