Skip to content

Instantly share code, notes, and snippets.

/* 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
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
/* 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
CHatmaker / BXL 5g Functions LAMBDA Financial Models 2025
Last active August 18, 2025 01:33
BXL 5g Functions LAMBDA Financial Models 2025
// 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
*/
Aboutλ = TRIM(TEXTSPLIT(
@CHatmaker
CHatmaker / BXL 5g Functions LAMBDA Modeling Templates
Last active August 18, 2025 01:36
BXL 5g Functions LAMBDA Modeling Templates
// 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
CHatmaker / BXL 5g Functions LAMBDA Workbook Info
Last active August 18, 2025 01:37
BXL 5g Functions LAMBDA for Excel Workbook Information
/* 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: →BXL's Workbook Information module. Suggested module name: BXW¶" &
"Version: →Jun 12 2023¶" &
"Gist URL: →https://gist.github.com/CHatmaker/3ff1b5ce97344c2dfc3f1623a656676a ¶" &
class PathMe {
moves: string[] = [];
constructor() {
this.moves = [];
return this;
}
moveTo(x: number, y: number) {
@CHatmaker
CHatmaker / BXL LAMBDA Reporting with Arrays
Last active July 3, 2025 12:20
5G functions for Excel for Reporting with Arrays
/* 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
CHatmaker / BXL 5g Functions LAMBDA for Excel CrtIdxλ
Last active July 20, 2025 08:08
BXL 5g Functions LAMBDA for Excel: CrtIdxλ
/* 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:
@vlrmprjct
vlrmprjct / counter.ino
Created July 31, 2020 07:33
Arduino Simple Counter
/* Simple Counter
* ——————
*
* This is a simple counter that takes a digital input
*
*/
int ledPin = 13; // choose the pin for the LED
int switchPin =2; // choose the input pin (for a pushbutton)
int val = 0; // variable for reading the pin status
int counter = 0;
@codediodeio
codediodeio / config.js
Last active April 7, 2025 00:44
Snippets from the Firestore Data Modeling Course
import * as firebase from 'firebase/app';
import 'firebase/firestore';
var firebaseConfig = {
// your firebase credentials
};
// Initialize Firebase
firebase.initializeApp(firebaseConfig);