WATER USE (TOILETS)

Sheet visibility: visible.

Back to workbook

Stored values and formulas are shown below. Cached formula results are source snapshots and have not been recalculated.

Cell	Stored value or cached result	Formula
A1	CALCULATED TOILET USE PER DAY (GALLONS)
C2	HOW MANY PEOPLE USE THE BULDING?
A3	WEEKDAY
C3	0
A4	0	=(C3C5/1003C11/8C7)+C3(100-C5)/100(C11/82C9+C11/81C7)
C4	WHAT PERCENTAGE OF THE PEOPLE EXCLUSIVELY USE TOILETS?
A5	WEEKEND
C5	0
D5		=IF(C5>100,"INVALID","")
A6	0	=((C13/100)*A4)
C6	HOW MUCH WATER IS USED BY EACH TOILET? (GALLONS/FLUSH)
C7	0
C8	HOW MUCH WATER IS USED BY EACH URINAL? (GALLONS/FLUSH)
C9	0
C10	HOW MANY HOURS PER DAY IS THE BUILDING USED?
C11	0
D11		=IF(C11>24, "INVALID", "")
C12	WHAT PERCENTAGE OF WEEKEDAY USE IS EXPECTED ON WEEKENDS?
C13	0