Craig Hatmaker BXL CHatmaker
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
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
August 6, 2026 00:41
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 05 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: Aug 05 2026¶" & | |
| "Gist URL: →https://gist.github.com/CHatmaker/2ebb5b42457f35a36da103dd9b8d15fb ¶" & |
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 |
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λ |
NewerOlder