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.
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: Aggregating Data from Multiple Tables Based on Conditions
Learn two methods for aggregating data from multiple tables based on selection criteria in Power Query, using Table.SelectRows and Table.NestedJoin.
Power Query: Get the Corresponding Value for a Date Within a Date Range
Learn how to use Power Query to retrieve corresponding values based on date ranges, ideal for various time-based data transformations in Excel.
Power BI: Convert UTC to Eastern Time in Power Query with Daylight Saving Adjustments
Learn how to convert UTC to Eastern Time in Power BI, accounting for daylight saving time, with a custom Power Query function for accurate time zone adjustments.
Rounding Decimals in Java: Avoiding Round-Off Errors with BigDecimal
Handling decimal rounding in Java with BigDecimal to avoid round-off errors and ensure precise calculations for critical applications.
How to Display the File Last Updated Date in Power BI Using Excel VBA or Power Query
Learn how to display the last updated date for an Excel file in Power BI using Excel VBA or Power Query, with step-by-step instructions for both methods.