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)
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
Keywords | measurement, water, audit |
---|---|
License | CC-BY-SA-4.0 |
Language | English (en) |
Related | 0 subpages, 0 pages link here |
Impact | 68 page views (more) |
Created | January 27, 2021 by Emilio Velis |
Last modified | October 23, 2023 by StandardWikitext bot |
Cite as | "How to do a water audit spreadsheet". Appropedia. 2021–2023. Retrieved September 11, 2024. |
API queries | basic, semantic, html, files, more |
Retrieved from "https://www.appropedia.org/w/index.php?title=How_to_do_a_water_audit_spreadsheet&oldid=1031937"
Hidden category:
Cookies help us deliver our services. By using our services, you agree to our use of cookies.