Model the real process
We watch the work before we design for it. The spreadsheet survives because it encodes a rule nobody wrote down.
- Process mapping with the people who do the work daily
- Explicit handling of exceptions, not just the standard path
- Approvals and state machines that match actual authority
- Migration of historic records, not just new data