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 a list of known words with at least 4 characters that include the specified required and optional letters.
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
WordPress plugin to embed custom field values into pages and posts through a simple shortcode.
Latest Blog Posts
How to Use Regular Expressions in Excel for Parsing Substrings with VBA
Learn how to use VBA and regular expressions in Excel to easily parse substrings from cell values without complex formulas.
Excel: Create Cascading Drop-Down Lists for Better Data Validation and Quality Control
How to create cascading drop-down lists in Excel using data validation and named ranges to improve data accuracy and quality in collaborative workbooks.
Power BI Slicer for Multi-Value Columns: Splitting Delimited Data for Better Filtering
Learn how to create a Power BI slicer that splits delimited data, allowing easy filtering of multi-value columns without selecting grouped entries manually.
Why I Continue Blogging
Reflecting on blogging for knowledge sharing and personal growth despite AI challenges and low traffic.
How to Manage Digital Photo Clutter: A Guide to Photo Deduplication
Learn how photo deduplication can help you manage digital clutter, save storage space, and organize your photo library with easy, effective methods.