How to do a water audit spreadsheet

This is a longer video for beginners to google sheets and/or water audits. It takes data from a problem in the book To Catch the Rain and turns it into a spreadsheet.

Google sheets: How to make a water audit spreadsheet

This is a longer video for beginners to google sheets and/or water audits. It takes data from a problem in the book To Catch the Rain and turns it into a spreadsheet.

Authors: Lonny Grafman

Date: 2020-09-11

Location: California

Language: English (en)

Annotations:

0:24 Start a new spreadsheet
0:49 Calculate the water usage
1:50 Setting up the instructions
2:53 Set up conversion rate
3:53 First example: sources based on uses per day
5:20 Formatting
6:25 First calculation
7:15 Rounding
9:08 Adding up the total
10:00 Second example: sources based on flow rate
11:50 Calculating totals
12:56 Third example: sources based on usage per week
13:54 Converting weeks to days
15:02 Absolute spreadsheet references
16:17 Calculate daily, monthly and yearly totals
18:50 Final formatting

Page data
Keywords	measurement, water, audit
SDG
Authors
License	CC-BY-SA-4.0
Language	English (en)
Related	0 subpages, 0 pages link here
Views	161 page views (analytics)
Created	January 27, 2021 by Emilio
Last edit	April 24, 2026 by StandardWikitext bot
Cite as	"How to do a water audit spreadsheet". Appropedia. 2021–2026. Retrieved May 29, 2026.
API queries	basic, semantic, html, files, more