Brandon Sheppard brandonsheppard

=iferror(sum(query(Transactions!$A:$F,"select D where B contains '"&$A11&"' and A = date '"&text(F$1,"yyyy-mm-dd")&"'")))

https://web.archive.org/web/*/URL/*

e.g.,

https://web.archive.org/web/*/https://github.com/NetoECommerce/Skeletal/*

formatNotes()

Pass commit data into this function to format a markdown commit note. Data structure is based on what Github's compare endpoint returns.

This is useful for generating a changelog for release notes based on git activity.

Based on response from Github's compareCommits endpoint.

This function generates a date-based version number. Year + Month + Iteration

So, the first release in March 2017 will be 17.3.0

If multiple releases occur in a month, the final number will increase. Otherwise, an entirely new verion number will be generated.

i.e.

	# Typeface
	font-family = FiraCode Nerd Font Mono
	font-style = Retina
	font-feature = calt
	font-size = 16
	adjust-cell-height = 18%

	# Colors
	theme = light:/Users/brandonsheppard/Library/Application Support/com.mitchellh.ghostty/themes/os-light,dark:/Users/brandonsheppard/Library/Application Support/com.mitchellh.ghostty/themes/os-dark
	background-opacity = 0.9

	addEventListener('fetch', event => {
	event.respondWith(handleRequest(event.request))
	})

	async function handleRequest(request) {
	const pageURL = new URL(request.url);
	return Response.redirect(`${pageURL.protocol}//${String(pageURL.host).substring(4)}${pageURL.pathname}${pageURL.search}`)
	}

	// Run on page load
	$('input').on('focus blur',function(e){
	performance.mark(e.type+ ' ' + e.target.name)
	});

	// Run to see results
	console.table(performance.getEntriesByType('mark'))

	var observer = new MutationObserver(function(mutations) {
	mutations.forEach(function(mutation) {
	console.log(mutation.type);
	});
	});

	observer.observe(document.getElementById('bill_selector'), {
	attributes: true,
	childList: true,
	characterData: true

	=date(year(edate(today(),-1)),MONTH(edate(today(),-1)),1)

	// assumes date in cell is the 1st