Skill data

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: 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
Page data
Type Skill
Keywords measurement, water, audit
Published 2021
License CC-BY-SA-4.0
Impact Number of views to this page and its redirects. Updated once a month. Views by admins and bots are not counted. Multiple views during the same session are counted as one. 46
Issues Automatically detected page issues. Click on them to find out more. They may take some minutes to disappear after you fix them. No main image
Cookies help us deliver our services. By using our services, you agree to our use of cookies.