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 |
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¶" & |
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 | |
*/ | |
Aboutλ = TRIM(TEXTSPLIT( |
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 |
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: →BXL's Workbook Information module. Suggested module name: BXW¶" & | |
"Version: →Jun 12 2023¶" & | |
"Gist URL: →https://gist.github.com/CHatmaker/3ff1b5ce97344c2dfc3f1623a656676a ¶" & |
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
class PathMe { | |
moves: string[] = []; | |
constructor() { | |
this.moves = []; | |
return this; | |
} | |
moveTo(x: number, y: number) { |
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λ | |
*/ |
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: |
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
/* 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; |
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
import * as firebase from 'firebase/app'; | |
import 'firebase/firestore'; | |
var firebaseConfig = { | |
// your firebase credentials | |
}; | |
// Initialize Firebase | |
firebase.initializeApp(firebaseConfig); |
NewerOlder