Form cover
Page 1 of 2

DataTabby Audit Checklist

Audit Checklist

A self-assessment tool to figure out if your spreadsheet is silently draining your time, sanity, or both.

Section 1: About your spreadsheet

What does this spreadsheet do? (Short answer)

How many people use it?

How often is this spreadsheet updated?

How often is this spreadsheet updated?

Where is this spreadsheet stored?

Where is this spreadsheet stored?

Section 2: The Symptoms

For each question below, pick the answer that fits. Yes = 2 points, Sometimes = 1, No = 0. Keep a running total - you'll need it at the end.

I waste time looking for information in this file

I waste time looking for information in this file
A
B
C

I'm afraid to change anything because it might break

I'm afraid to change anything because it might break
A
B
C

Formulas break when I add new data

Formulas break when I add new data
A
B
C

There are hidden rows/columns I'm scared to touch

There are hidden rows/columns I'm scared to touch
A
B
C

Different people enter data differently (VA vs Virginia vs va)

Different people enter data differently (VA vs Virginia vs va)
A
B
C

I can't get totals or summaries without manual work

I can't get totals or summaries without manual work
A
B
C

No one else can use this file without calling me

No one else can use this file without calling me
A
B
C

There are multiple versions floating around

There are multiple versions floating around
A
B
C

The file has grown way beyond its original purpose

The file has grown way beyond its original purpose
A
B
C

I dread opening this spreadsheet

I dread opening this spreadsheet
A
B
C

Add up your points from Section 2.

Section 3: The Real Cost

Scored section. A = 0 points, B = 1 point, C = 2 points, D = 3 points. Add up your score and enter it into the box below

If this spreadsheet disappeared tomorrow, how bad would it be?

If this spreadsheet disappeared tomorrow, how bad would it be?
A
B
C
D

How much time per week do you spend fighting with this spreadsheet?

How much time per week do you spend fighting with this spreadsheet?
A
B
C
D

Add up your points from Section 3.

Section 4: What You Actually Want

What would "fixed" look like for you?

(Short answer)

What's the most frustrating thing about this spreadsheet?

(Short answer)

Add up your points from Sections 2 and 3. What's your total score?

Scoring & Results:

0-7 points: 🟢Minor Mess

Your spreadsheet has some quirks, but it's manageable. A little cleanup and some best practices could help.

8-15 points: 🟡Needs Attention

You're losing time and probably some sanity. This spreadsheet is holding you back. Some structure and cleanup would make a real difference.

16+points: đź”´ Data Emergency

This spreadsheet is actively costing you time, money, or both. It's time to get help before something breaks that can't be fixed.

Ready to fix this? I can help.