Skip to content

Instantly share code, notes, and snippets.

View justfoo's full-sized avatar

Justin Williams justfoo

  • Seattle, WA
  • 19:05 (UTC -07:00)
View GitHub Profile
@justfoo
justfoo / excel-date-dimension-helper
Last active July 14, 2025 23:55
Create a date dimension for use in Excel
/*******************************************************************************
Excel Date Dimension Module
© 2025 Justin S. Williams <https://github.com/justfoo>
This work is marked CC0 1.0 Universal. To view a copy of this mark,
visit https://creativecommons.org/publicdomain/zero/1.0/
You can copy, modify, distribute, and use this code, even for
commercial purposes, without needing to ask for permission.
@justfoo
justfoo / excel-base-module-helpers
Last active July 10, 2025 22:47
General Helper functions for Excel
/*******************************************************************************
Excel Base Module Helper Functions
© 2025 Justin S. Williams <https://github.com/justfoo>
This work is marked CC0 1.0 Universal. To view a copy of this mark,
visit https://creativecommons.org/publicdomain/zero/1.0/
You can copy, modify, distribute, and use this code, even for
commercial purposes, without needing to ask for permission.
@justfoo
justfoo / Zotero Action Script for Color Labels
Last active May 25, 2025 18:38
PKM - Templates & Examples for Obsidian & Zotero
/**
* Customize color labels of reader
* @author windingwind
* @usage Set the `Event` to `Program Startup`; Edit the action script below to replace the labels.
* @link https://github.com/windingwind/zotero-actions-tags/discussions/211
* @see https://github.com/windingwind/zotero-actions-tags/discussions/211
*/
// Edit labels below
const replaceLabelMap = {
@justfoo
justfoo / excel-helper.txt
Last active May 7, 2025 16:48
General Excel Helper Functions
/*******************************************************************************
EXCEL HELPER FUNCTIONS
Common functions to help manipulating data in Ecel
VARIABLE OVERRIDES
The following optional variables can be defined within a worksheet. If they are
defined, the functions below will use them. However if the variable definitions
are omitted, then the functions will use default values instead.
o Override_AsOfYear (named cell) - generally the year that represents 'now' for
@justfoo
justfoo / grocy.txt
Last active March 29, 2025 23:12
Grocy: Functions for interacting with grocy data
// GROCY HELPER FUNCTIONS
// Functions for working with data imported from a Grocy instance
// Expected Module Name: gr
// Expects a worksheet with the following names defined:
// - grBaseUrl
// - grApiKey
// - grApiBaseUrl
// - grApiProductUrl