Data auditing

1
Data auditing
finding errorswhen data have been entered
already .
Wim Buysse ICRAF-ILRI Research Methods
Group August 2004
2
The error
3
Error checking approach 1 AutoFilter

• Click in the row heading to select the row with
  short titles

4
Error checking approach 1

• Now choose Data gt Filter gt AutoFilter

5
Error checking approach 1

• Discover the error in the drop-down list

6
Error checking approach 1

• Select and correct

7
Error checking approach 1

• When to use AutoFilter ?
• Especially useful for checking factors that have
  a limited number of levels such as
• replications
• blocks
• Treatments
• Etc.

8
Error checking approach 2 Auditing tools

• Type somewhere in the spreadsheet a list with
  possible treatment levels

9
Error checking approach 2

• Select the data to check and choose Data gt
  Validation to allow only values from that list

10
Error checking approach 2

• now choose Tools gt Formula Auditing gt Show
  Formula Auditing Toolbar

11
Error checking approach 2

• Click on the Circle Invalid Data button the
  error will be marked

12
Error checking approach 2

• Select the correct value from the in-cell
  drop-down list

13
Other Formula Auditing tools

• Tracing the precedents of a formula

14
Other Formula Auditing tools

• Tracing the dependents of a cell to see if it
  is used in any formula

15
Other Formula Auditing tools

• Tracing an error

16
Other Formula Auditing tools

• and let the computer give you all kinds of
  help on this error

17
Conclusion

• AutoFilter is a faster approach for finding and
  correcting errors in lists with repeated elements
  such as factor levels.