The water audit spreadsheet calculates the annual water use for a family based on data collected by students.

Students can use the data-collection sheet to record the number of times members of their families carry out water-using activities during a week. The spreadsheet uses an average water-use table to calculate the families' weekly, monthly and annual use of water.

The water audit spreadsheet is a Microsoft Excel file.

Download the water audit spreadsheet.