The comparison you keep doing by hand, and the two numbers it needs
Two things I keep seeing in projects that stall, and they are not technical problems.
The first is a comparison done by hand. Two lists, side by side, checked one item at a time, with the answer thrown away when it is done. The second is a cost nobody wrote down before starting.
They look unrelated. They are the same mistake.
The comparison that lives in a spreadsheet
Somebody has two lists of things β the items in a game, the entries in a table, the pages of a reference β and they need to know what is in one and not in the other.
The obvious move is to paste both into a spreadsheet and use a formula. That works exactly once.
After that, three things break. The spreadsheet becomes a second copy of the data, so every update has to be done twice. Nobody can share the result without sharing the file.β¦