I write code to solve problems โ and often just for fun.
Featured Projects
- Quartiles Solver
Generate possible solutions to the daily Apple News+ Quartiles game by comparing all 1- to 4-tile combinations against a large word list.
- Wordle Solver
Find possible solutions to The New York Times Wordle game by searching a list of known 5-letter words.
- Spelling Bee Solver
Find possible solutions to The New York Times Spelling Bee game by searching known words with at least 4 letters including the required and optional letters.
- Analytical Spam Filter
Plugin for WordPress to block comment spam, trackback spam, and pingback spam through intelligent analytics instead of interactive challenge-response tests.
- Head Trimmer
Customizable plugin for WordPress to selectively remove version information, feeds, shortlinks, xmlrpc, emoji support and other extras from the HEAD element.
Latest Blog Posts
- Power Query: Load Excel Data from Local, Web, or Current Workbook
Covers loading Excel data into Power Query from a local file, SharePoint, or the current workbook โ including worksheets, tables, and defined names.
- Excel Multi-Criteria Lookup Guide
A practical comparison of multi-criteria lookup methods in Excel: SUMPRODUCT, INDEX with MATCH, and XLOOKUP, with examples for each.
- How to Create a Multi-Resolution favicon.ico File
A walkthrough for building a multi-resolution favicon.ico with Inkscape and ImageMagick, ensuring correct rendering across browsers and search results.
- How to Add Math Equations to Astro with KaTeX
Setup guide for rendering math equations in Astro using KaTeX, with Markdown examples and styling options suited to static sites.
- Java Permutation Generator: Partial and Full Strings
An efficient, duplicate-safe, iterative approach to generating partial and full string permutations in Java, with examples and performance considerations.