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.

#AskA good answerStop and look closer if
1Rebuilding a report by handReports arrive in a shape the team can use.The same report is rebuilt every week in a spreadsheet.
2Checking numbers before trusting themPeople use the number as it arrives.Every figure is checked against a second source first.
3Waiting for data or accessRequests are answered within the day.Decisions wait days for an answer or a login.
4Keeping a private copyOne shared source the team trusts.Each person keeps their own spreadsheet version.
5Arguing about which number is rightOne agreed definition for each key number.Meetings start with whose figure to use.
6Typing data from one system into anotherSystems 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.

Turn the hours into a yearly cost

The worksheet converts hours into full-time staff and euros. Free.

Related