Personal blog. I write about what I learn as I am learning it

Your Project Software Is Guessing at Resource Leveling

Every project management package has a button that fixes an over-allocated schedule. Microsoft Project calls it Level Resources. Primavera calls it resource leveling. You click it, the bars slide right, the red goes away, and you get a new finish date. What none of them tell you is how far that new date sits from the best one available.

I went looking for someone who had actually measured it. I found a paper from 1999 — and then noticed something strange about what happened to the topic afterwards.

Bar chart of daily crew demand on a 17-task renovation project. Demand sits at two or three people most days but spikes to five for four days in late October, above the dashed line marking the three-person crew that is actually available. — Nothing is over-allocated on paper. The plan just quietly assumes five people for four days.

Continue reading “Your Project Software Is Guessing at Resource Leveling”

Why My Free Shift Scheduler Became 13 Different Tools

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.

Staff scheduler industry page showing a fixed 24/7 shift scheduling card

CBC vs CP-SAT: My Lineup Optimizer Got 8x Faster

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.

▶ Try the free MLB lineup optimizer — no signup

A Free NFL Lineup Optimizer for DraftKings and FanDuel

The NFL lineup optimizer is live. It is free, there is no account, no email, and no cap on how many lineups you can build. It works with DraftKings and FanDuel, and it hands you a CSV formatted for direct re-upload to whichever one you came from.

It is the football version of the baseball optimizer I put up in June, built on the same solver with a different set of rules on top.

NFL Lineup Optimizer rules screen showing QB stacking, bring-back, exposure cap, and cooldown settings

Nine Named Ranges and a Macro Called alternate_qb

The football folder had twelve .xlsm files in it, all with the same file date because I had copied them off an old drive in one go. Windows was no help. The real dates were inside — every Office file carries its own modified timestamp in docProps/core.xml, and a spreadsheet is just a zip archive, so you can read it without opening Excel at all — which is how I tracked down the file that became this NFL lineup optimizer for DraftKings and FanDuel.

Eleven of them were from 2014 and 2015. One was from October 2021, had nineteen worksheets instead of five, and was called fanduel football 2021 fast.xlsm. That was the one worth porting.