Quartiles Solver
Generate possible solutions to the Apple News+ Quartiles game by comparing all 1- to 4-tile combinations against a large word list.
Hi, I’m John!
I write code.
In many languages.
Across multiple platforms.
To solve problems.
For fun.
Projects
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.
Super Fun Math Game
Improve your math skills with the Super Fun Math Game! Enjoy customizable arithmetic challenges for all ages.
Analytical Spam Filter
WordPress plugin to block comment spam, trackback spam, and pingback spam through intelligent analytics instead of interactive challenge response tests.
Head Trimmer
Customizable WordPress plugin to selectively remove WordPress version information, feeds, shortlinks, xmlrpc, emoji support and other miscellaneous extras from the HEAD element.
Micro Contact Form
WordPress contact form plugin requiring only basic data entry (message subject, message content, from name, and return e-mail address) to send a brief message to the blog administrator’s e-mail address.
Custom Field Embedder
Embed custom field values like text, HTML, and JavaScript into WordPress posts/pages with the lightweight Custom Field Embedder plugin and simple shortcode.
Latest Blog Posts
Power Query: Check if Text Value is Alphabetic Only
Two simple ways to check if text contains only alphabetic characters in Power Query using a custom function or Text.Select with if-then-else.
Concatenate Excel Ranges, Arrays, and Values Without TEXTJOIN Using VBA
No TEXTJOIN? No problem. Use this simple VBA function to concatenate Excel ranges, arrays, and values with control over delimiters, empty cells, and row or column priority.
How to Count Cells by Background Color in Excel with VBA
Learn how to count Excel cells based on background color using simple VBA functions. Includes step-by-step instructions, code, and practical examples.
Excel VBA: Improve Excel Range Evaluation by Trimming Unused Cells
Improve Excel range evaluation by trimming unused cells with a custom VBA function. Optimize performance while keeping the flexibility of whole-column references.
Contact Form for Static Sites Using Cloudflare Workers and Airtable
Create a free, spam-protected contact form for your static website using Cloudflare Pages, Workers, and Airtable — no dedicated server required.