For COOs · One-page sheet
Where do your teams lose hours to data they cannot use?
Teams lose hours to data workarounds in six places, most of the time. Ask each team lead for a rough weekly number per row. Rough is fine. The total is what matters.
None of these hours show up in the data budget. They sit in the payroll of sales, finance, marketing and operations. I keep seeing them come to more than the tools cost.
The checklist
One copy per team. Write hours per week in the margin of each row. The middle column is what healthy looks like. The right-hand column is the sign that the hours are permanent and nobody has priced them.
| # | Ask | A good answer | Stop and look closer if |
|---|---|---|---|
| 1 | Rebuilding a report by hand | Reports arrive in a shape the team can use. | The same report is rebuilt every week in a spreadsheet. |
| 2 | Checking numbers before trusting them | People use the number as it arrives. | Every figure is checked against a second source first. |
| 3 | Waiting for data or access | Requests are answered within the day. | Decisions wait days for an answer or a login. |
| 4 | Keeping a private copy | One shared source the team trusts. | Each person keeps their own spreadsheet version. |
| 5 | Arguing about which number is right | One agreed definition for each key number. | Meetings start with whose figure to use. |
| 6 | Typing data from one system into another | Systems pass the data on without people. | Someone copies it across by hand every week. |
How to read the answers
Add it up per team
Hours per week, times the people involved, times the working weeks in your year. Then multiply by a loaded hourly cost from finance.
Look for the same row twice
When three teams fill in the same row, look for one report or one definition behind all three.
Take the total to the CFO
It is a payroll number, so finance will recognise it.
The worksheet converts hours into full-time staff and euros. Free.