Owen Price ncalm

🎯

Focusing

Stay sharp.

ncalm / excel-lambda-ISLAMBDA.txt

Last active October 4, 2023 17:02

This Excel LAMBDA function tests if its argument is a

ISLAMBDA = LAMBDA(x, AND(VALUETOTEXT(x)="λ", TYPE(x)=128)))

ncalm / excel-lambda-BMAPλ.txt

Created October 3, 2023 12:04

Recursive bisection LAMBDA function for Excel, by Peter Bartholemew

	/*
	Credit: Peter Bartholemew
	https://www.linkedin.com/in/peterbartholomew/
	https://techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/214174#profile

	---

	BMAPλ

	Recursively bisects an array and applies a function to the leaf nodes.

ncalm / excel-lambda-strip.txt

Created September 27, 2023 16:00

	// trip leading chars
	lstrip = LAMBDA(text, char,
	BYROW(text,
	LAMBDA(t, IF(LEFT(t)=char, lstrip(MID(t,2,len(t)),char), t))
	)
	);

	// trim trailing chars
	rstrip = LAMBDA(text, char,
	BYROW(text,

ncalm / python-in-excel-gpt4-custom-instructions.txt

Last active September 27, 2023 13:50

ChatGPT Plus Custom Instructions for Python in Excel

	There is a feature of Excel called Python in Excel. It allows you to create a "Python cell" in an Excel spreadsheet. In a Python cell, you can execute Python code.

	For each session, these imports are run automatically:

	import numpy as np
	import pandas as pd
	import matplotlib.pyplot as plt
	import statsmodels as sm
	import seaborn as sns
	import excel

ncalm / excel-python-integrate-image-function.py

Last active September 26, 2023 21:16

Use Python in Excel to integrate an expression and render the LaTeX expression and result to a plot

	from sympy import integrate

	def integration_image(symbol: str, expr: str):
	"""Integrates expr with respect to symbol

	integration_image(symbol='x', expr='exp(x)sin(x) + exp(x)cos(x)')

	Dependencies: 'from sympy import integrate' must be run before use
	"""

ncalm / excel-lambda-sudoku-solver-no-comments.txt

Last active May 4, 2024 23:51 — forked from lhem/sudoku

ncalm / excel-lambda-FORMULATEXT.PY.txt

Created August 25, 2023 15:53

This Excel LAMBDA function provides a FORMULATEXT capability for Python in a Python cell

	/*
	Provides a FORMULATEXT capability for Python cells

	pythonCell: A reference to a Python cell
	[asArray]: A TRUE/FALSE value indicating whether
	or not to spill the results of the formula
	default is TRUE
	*/
	FORMULATEXT.PY = LAMBDA(pythonCell,[asArray],
	LET(

ncalm / excel-lambda-chartQuadrants.txt

Created August 2, 2023 16:05

This Excel LAMBDA function calculates the coordinates for two series to add to a scatterplot to produce a vertical and horizontal line

	chart.Quadrants = LAMBDA(seriesData,
	LET(
	// The first column (x values)
	x, TAKE(seriesData, , 1),
	// The second column (y values)
	y, TAKE(seriesData, , -1),

	xMax, MAX(x),
	yMax, MAX(y),

ncalm / excel-lambda-FILLDOWN.txt

Created July 27, 2023 15:50

An Excel LAMBDA function to fill down a column.

FILLDOWN = LAMBDA(arr, SCAN(,arr,LAMBDA(a,b,IF(b<>"",b,a))));

ncalm / powerquery-fnCombineHeaders.m

Created June 10, 2023 14:13

This Power Query function handles headers which have been split onto multiple rows

	(Source as table, header_condition as function) as any =>
	let
	// two row header
	hh = Table.SelectRows(Source, header_condition) ,

	// list of new column headers
	h = List.Accumulate(
	Table.ToColumns(hh),
	{},
	(a,b) => List.Combine({a,{Text.Combine(b," ")}})