PART 1
The warning signs
Only one person understands the file. Copies disagree. Errors are found by customers. Every new location adds manual work. If two of these are true, the spreadsheet is now a risk.
PART 2
Map before you build
Document how work actually flows today, including the workarounds. The workarounds are where the real requirements hide.
PART 3
Migrate in stages
Move one process at a time, run old and new side by side briefly, and retire the spreadsheet only when the numbers match.
PART 4
Keep what works
Good software keeps the parts of the spreadsheet people love — speed and flexibility — and removes the parts that break.
