Skill data
Required hours 3
Page data
Type Skill
Keywords measurement, water, audit
Published by Emilio Velis
Published 2021
License CC BY-SA 4.0
Page views 37

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.
Date: 2020-09-11
Location: Arcata, California
Language: English (en)

Navigate the video:

  • #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