Personal blog on early retirement and analytics projects. I write about what I learn as I am learning it.
The staff scheduler started as one page: give it your shifts, your people, and your coverage requirements, and it hands back a roster. That’s still true. What changed this week is that the one page became thirteen — a nurse scheduler, a firefighter scheduler, a police scheduler, a warehouse scheduler, and nine more — all running the exact same engine underneath. Same solver, same rules, same workbook format. Different pages. Here’s why I did that instead of leaving well enough alone.
Two months ago I wrote about CBC vs HiGHS on my staff scheduler, where swapping solvers turned a model that took minutes into one that took seconds. So when my daily fantasy lineup optimizer started feeling slow, I reached for the same fix — and HiGHS came back three times slower. This is the story of CBC vs CP-SAT on that model, why my own previous result did not transfer, and the failure mode I found on the way that was worse than being slow.
Continue reading “CBC vs CP-SAT: My Lineup Optimizer Got 8x Faster”People hear “route optimization algorithm” and picture something exotic — a black box, maybe a little AI magic. It isn’t. Underneath every routing tool, mine included, is a decades-old idea from combinatorial search, dressed up with a few tricks to make it fast enough to run in your browser instead of overnight on a mainframe. I’ve spent twenty-plus years building these models for real fleets, and the algorithm part is the least mysterious piece of the whole system. Here’s what’s actually happening when you click “optimize.”
Continue reading “How Route Optimization Algorithms Actually Work”Every so often someone emails me asking for a route optimization API — they want to hit an endpoint from their own app, get routes back as JSON, and skip the whole “upload a spreadsheet” workflow entirely. Fair ask. But before you go shopping for one, it’s worth understanding what you’re actually paying for, because “API” in this space covers everything from a thin wrapper around a free library to a genuinely expensive enterprise platform.
“Dynamic route planning software” gets thrown around as a marketing word more than a technical one, and it’s worth pinning down what it actually means before you pay for it. I’ve built routing models for real operations for over twenty years, and the honest answer is: dynamic isn’t a feature you either have or don’t — it’s a spectrum, and most businesses searching for it don’t actually need the far end of it.
Continue reading “Dynamic Route Planning Software, Explained”
