Craig Hatmaker BXL CHatmaker
CHatmaker
/ BXL Excel LAMBDA Math
Last active
January 27, 2024 15:47
5G functions for Excel: Miscellaneous Math
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 Description | |
| About位 About this module and links to online resources | |
| Fibonacci位 Determine the nth number in a Fibonacci sequence | |
| */ | |
| /* FUNCTION NAME: About位 | |
| DESCRIPTION:*/ /**Displays the URL to this module's Gist which includes documentation*/ |
CHatmaker
/ BXL 5g Functions LAMBDA for Excel Debt Module
Last active
February 4, 2025 11:20
BXL 5g Functions LAMBDA for Excel for debt modeling
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 10 2023 Craig Hatmaker Copyright | |
| Feb 02 2024 Craig Hatmaker See DebtSculpt位 | |
| */ | |
| About位 = TRIM(TEXTSPLIT( | |
| "About: 鈫払XL's Debt module. Suggested module name: BXLDebt露" & | |
| "Version: 鈫扐ug 10 2023露" & |
CHatmaker
/ BXL 5g Functions LAMBDA for Excel Financial Models 2024-05-29
Last active
February 4, 2025 11:20
BXL 5g Functions LAMBDA for Excel for Financial Models: deprecated on 2024-05-29
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 13 2023 Craig Hatmaker Original Development | |
| May 13 2024 Craig Hatmaker Spring 2024 Version | |
| May 18 2024 Craig Hatmaker Added RollingAvg位, RollingMin位 and RollingMax位 | |
| May 28 2024 Craig Hatmaker See SumContains位 | |
| May 29 2024 Craig Hatmaker See LabelAmortize位 | |
| */ |
CHatmaker
/ BXL LAMBDA Reporting with Arrays
Last active
July 3, 2025 12:20
5G functions for Excel for Reporting with Arrays
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 17 2023 Craig Hatmaker Copyright | |
| Apr 17 2023 Craig Hatmaker Reorganizing and adding help | |
| Jul 03 2023 Craig Hatmaker See nFoldCartProd位 and PriorDimProd位 | |
| Jul 11 2023 Craig Hatmaker See UnPivotDetail位 | |
| Feb 11 2024 Craig Hatmaker See UnPivotDetail位 | |
| */ |
CHatmaker
/ BXL 5g Functions LAMBDA for Excel CrtIdx位
Last active
July 20, 2025 08:08
BXL 5g Functions LAMBDA for Excel: CrtIdx位
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: CrtIdx位 | |
| DESCRIPTION:*/ /**Creates an array of indexes that can be used with INDEX() can combine | |
| all rows in all tables as would a database 'Natrual Join' or 'Cross Join.'*/ | |
| /* This was developed for multidimensional modeling. A key to multidimensional modeling | |
| is the ability to combine all instances of all dimensions, and then access each | |
| dimension's value. A dimension is a category of things like: | |
| Customers, Products, Regions, Months, etc. | |
| When faced with the situation where each dimension has a piece of information needed | |
| for a particular calculation such as: |
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: 鈫払XL's Financial Model Utilities. Suggested module name: FMU露" & | |
| "Version: 鈫払XL: Apr 22 2025露" & |
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 Financial Models
Last active
August 18, 2025 01:36
5g Function for Excel 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
| /* 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 | |
| May 13 2024 Craig Hatmaker Spring 2024 Version | |
| May 18 2024 Craig Hatmaker Added RollingAvg位, RollingMin位 and RollingMax位 | |
| May 28 2024 Craig Hatmaker See SumContains位 | |
| May 29 2024 Craig Hatmaker See LabelAmortize位 | |
| Jun 19 2024 Craig Hatmaker See RollingX functions | |
| Jul 17 2024 Craig Hatmaker IntOnInt位 fix |
CHatmaker
/ BXL 5g Functions LAMBDA Modeling Templates
Last active
August 18, 2025 01:36
BXL 5g Functions LAMBDA Modeling Templates
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
| // Base Template | |
| /* FUNCTION NAME: <enter name here>位 | |
| DESCRIPTION:*//**<this comment displays in name manager>*/ | |
| /* REVISIONS: Date Developer Description | |
| <changed> <your name> <what changed> | |
| */ | |
| BaseTemplate位 = LAMBDA( | |
| // Parameter Declarations |
CHatmaker
/ BXL 5g Functions LAMBDA Workbook Info
Last active
August 18, 2025 01:37
BXL 5g Functions LAMBDA for Excel Workbook Information
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 | |
| Dec 14 2023 Craig Hatmaker Original Development | |
| */ | |
| About位 = TRIM(TEXTSPLIT( | |
| "About: 鈫払XL's Workbook Information module. Suggested module name: BXW露" & | |
| "Version: 鈫扟un 12 2023露" & | |
| "Gist URL: 鈫抙ttps://gist.github.com/CHatmaker/3ff1b5ce97344c2dfc3f1623a656676a 露" & |
OlderNewer