16Jul
How I Converted an Excel VBA Macro Into a Web-Compatible Script
I converted a 600-line Excel VBA macro into web-compatible JavaScript. Here's the step-by-step process, pitfalls I hit, and what I'd do differently next time.
Read MoreBlog
16Jul
How I Converted Excel Contacts to vCard for iPhone and iCloud (And What Actually Worked)
I converted 2,000 Excel contacts to vCard for iCloud and iPhone sync. Here's the exact process I used, what went wrong, and how to do it faster.
Read More
16Jul
How I Completed an Urgent Excel Data Entry Project in Record Time
Here's exactly how I tackled a 3,000-row urgent Excel data entry project under a tight deadline — using scoping, validation, sprint tracking, and smart delegation.
Read More
16Jul
How I Built Optimized Complex Blockchain Smart Contracts That Actually Perform
A practitioner's account of how I design, optimize, and secure complex blockchain smart contracts — covering storage layout, proxy patterns, security, and gas profiling.
Read More
16Jul
How I Built a Comprehensive Inventory Management System in Excel (And What I Learned Along the Way)
Here's exactly how I built a fully functional inventory management system in Excel — from data architecture to live dashboards — and what results it delivered in 60 days.
Read More
16Jul
How I Built a Comprehensive Budget Analysis Spreadsheet in Excel
Learn how I built a comprehensive budget analysis spreadsheet in Excel — from architecture and variance formulas to executive dashboards that actually get used.
Read More
16Jul
How I Built Automated Report Generation in Excel VBA — And Saved 10 Hours a Week
Here's how I built a fully automated Excel VBA report system that cut 10 hours of weekly manual work — including structure, error handling, and scheduling.
Read More
16Jul
How I Built AI-Powered Features Into Microsoft Word and Excel
Here's exactly how I built AI-powered features inside Microsoft Word and Excel using Office Add-ins, OpenAI, and Office.js — and what the results looked like.
Read More
16Jul
How I Automated Excel Report Conversions to Save Hours of Manual Work
I was losing 5+ hours a week reformatting Excel reports manually. Here's the exact process, tools, and scripts I used to automate it and reclaim that time.
Read More
16Jul
How I Turned Hino Melpha Parts Images Into Structured Excel Data
How I extracted structured Excel data from Hino Melpha parts catalog images using layout-aware OCR, Python normalization, and diagram-to-table reconciliation.
Read More