Spreadsheet dependency
How do I give everyone one version of the truth?
Agree on the source and definition for each important measure, then make reports read from those sources consistently. Remove private copies that can drift and document how each metric is calculated. One version of the truth depends on governance as much as technology.
What to check
- Which system owns each key measure?
- Is the definition documented?
- Are teams still maintaining separate copies or calculations?