dmonder / index.html

Last active January 2, 2020 16:36

HTML Playground

<div>Hi, I'm GistPad!</div>

dmonder / README

Last active January 2, 2020 16:46

R Snippets

Store R snippets for future use.

dmonder / README.md

Last active January 2, 2020 16:53

Markdowns

This is a gist to store my general Markdown files.

dmonder / List.SelectPositions.pq

Created January 3, 2020 17:17 — forked from ImkeF/List.SelectPositions.pq

	let func =
	(SelectionList as list, ListOfPositions as list, optional StartWithOne as number, optional FillWithNulls as number) =>
	let

	selectionList = List.Buffer(SelectionList),
	listOfPositions = ListOfPositions,
	StartPosition = if StartWithOne = 1 then -1 else 0,

	Result = {List.Transform(listOfPositions, each selectionList{_ + StartPosition}), // null
	List.Transform(listOfPositions, each selectionList{_+StartPosition}?), // 0

dmonder / keybase.md

Created November 10, 2022 15:46

Keybase proof

I hereby claim:

I am dmonder on github.
I am dmonder (https://keybase.io/dmonder) on keybase.
I have a public key ASBNhl33u2Bdopw36Fw10wGB_x5UkzQDrzp2zmsOOpTkuwo

To claim this, I am signing this object:

dmonder / Chrome Onboarding - Pieces for Developers Snippet.md

Created March 18, 2024 21:11

A TypeScript function for deep cloning objects and arrays recursively.

Chrome Onboarding - Pieces for Developers Snippet

Preview:

const deepClone = (obj: any) => {
	if (obj === null) return null;
  let clone = { ...obj };

  Object.keys(clone).forEach(
	  (key) =>
 (clone[key] = typeof obj[key] === "object" ? deepClone(obj[key]) : obj[key])

dmonder / BXL LAMBDA Reporting with Arrays

Created January 10, 2025 04:30 — forked from CHatmaker/BXL LAMBDA Reporting with Arrays

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λ
	*/

dmonder / UNPIVOT.lambda

Created January 10, 2025 04:35 — forked from ExcelRobot/UNPIVOT.lambda

Unpivot Table LAMBDA Function

	/*
	Name: Unpivot Table (UNPIVOT)
	Description: Given a table range with headers and array of header names, unpivots the
	specified columns in place, optionally removing any blank entries.
	Written By: Excel Robot (@ExcelRobot)
	Category: Array
	*/
	UNPIVOT=LAMBDA(table,[columns_to_unpivot],[attribute_name],[value_name],[remove_blanks], LET(
	_ColumnsToUnpivot, IF(
	ISOMITTED(columns_to_unpivot),

dmonder / BXL LAMBDA Workbook Info

Created January 10, 2025 19:49 — forked from CHatmaker/BXL 5g Functions LAMBDA Workbook Info

5G functions 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 ¶" &

dmonder / BXL LAMBDA Array Essentials

Created January 10, 2025 19:52 — forked from CHatmaker/BXL 5g Functions LAMBDA for Excel Array Essentials

5G functions for basic Excel Dynamic Array handling

	/* FUNCTION NAME: Aboutλ
	DESCRIPTION://Displays the URL to this module's Gist which includes documentation/
	/* REVISIONS: Date Developer Description
	Feb 27 2024 Craig Hatmaker Copyright
	Jun 05 2024 Craig Hatmaker Code Simplification
	Sep 05 2024 Craig Hatmaker Added RunTotColsλ and RunTotRowsλ
	*/

	Aboutλ = TRIM(TEXTSPLIT(
	"About: →Basic functions for working with dynamic arrays. Suggested module name: BXE¶" &

David Onder dmonder

Markdowns

Keybase proof

Chrome Onboarding - Pieces for Developers Snippet

Preview: