I write code to solve problems — and often just for fun.
Featured Projects
- Quartiles Solver
Generate solutions for the Apple News+ Quartiles game by testing all 1 to 4 tile combinations against a curated word list.
- Wordle Solver
Find possible solutions to The New York Times Wordle game by filtering a list of 5-letter words using known game constraints.
- Spelling Bee Solver
Find possible solutions to The New York Times Spelling Bee game by searching words with at least 4 letters, including required and optional letters.
- Analytical Spam Filter
Block WordPress comment, trackback, and pingback spam using analytics-based detection instead of CAPTCHA or user interaction.
- Head Trimmer
Remove unnecessary elements from the WordPress HEAD section including version tags, feeds, emojis, XML-RPC, and shortlinks.
Latest Blog Posts
- Prevent SharePoint Trigger Loops in Power Automate
Prevent infinite SharePoint trigger loops in Power Automate flows using trigger conditions, flags, and proven patterns to stop repeated updates.
- Remove Lookup Column Links in SharePoint
Remove clickable links from SharePoint lookup columns using JSON formatting to keep list views clean and prevent unwanted navigation away from the list.
- Automatically E-mail Power BI Dashboard Screenshots
Schedule Power BI dashboard screenshots by e-mail using Power Automate and bookmarks, without any custom code or third-party tools.
- Power Query: Load Excel Data from Local, Web, or Current Workbook
Load Excel data into Power Query from local files, SharePoint, or the current workbook, including tables, worksheets, and named ranges.
- Excel Multi-Criteria Lookup Guide
Compare Excel multi-criteria lookup methods using SUMPRODUCT, INDEX with MATCH, and XLOOKUP with practical examples.