Sheet1¶
Sheet visibility: hidden.
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 |
|---|---|---|
| B4 | Day | |
| C4 | Storage Tank Actual Volume | |
| B5 | 1 | |
| C5 | 0 | =IF(('WATER USE (TOILETS)'!A4>'WATER USE (TOILETS)'!A6),('INPUT AND RESULTS'!A14-'WATER USE (TOILETS)'!A6-'WATER USE (OTHER)'!A14),('INPUT AND RESULTS'!A14-'WATER USE (TOILETS)'!A4-'WATER USE (OTHER)'!A4)) |
| B6 | 2 | |
| C6 | 0 | =MAX(0,(IF(('WATER USE (TOILETS)'!A4>'WATER USE (TOILETS)'!A6),(C5-'WATER USE (TOILETS)'!A6-'WATER USE (OTHER)'!A16),(C5-'WATER USE (TOILETS)'!A4-'WATER USE (OTHER)'!A6)))) |
| B7 | 3 | |
| C7 | 0 | =MAX(0,IF(('WATER USE (TOILETS)'!A4>'WATER USE (TOILETS)'!A6),(C6-'WATER USE (TOILETS)'!A4-'WATER USE (OTHER)'!A4),(C6-'WATER USE (TOILETS)'!A4-'WATER USE (OTHER)'!A8))) |
| F7 | SUFFICIENT | =IF(MIN(C5:C11)=0,"SUFFICIENT","INSUFFICIENT") |
| B8 | 4 | |
| C8 | 0 | =MAX(0,IF(('WATER USE (TOILETS)'!A4>'WATER USE (TOILETS)'!A6),((C7+'INPUT AND RESULTS'!A14)-'WATER USE (TOILETS)'!A4-'WATER USE (OTHER)'!A6),((C7+'INPUT AND RESULTS'!A14)-'WATER USE (TOILETS)'!A4-'WATER USE (OTHER)'!A10))) |
| B9 | 5 | |
| C9 | 0 | =MAX(0,IF(('WATER USE (TOILETS)'!A4>'WATER USE (TOILETS)'!A6),(C8-'WATER USE (TOILETS)'!A4-'WATER USE (OTHER)'!A8),(C8-'WATER USE (TOILETS)'!A4-'WATER USE (OTHER)'!A12))) |
| B10 | 6 | |
| C10 | 0 | =MAX(0,IF(('WATER USE (TOILETS)'!A4>'WATER USE (TOILETS)'!A6),((C9+'INPUT AND RESULTS'!A14)-'WATER USE (TOILETS)'!A4-'WATER USE (OTHER)'!A10),((C9+'INPUT AND RESULTS'!A14)-'WATER USE (TOILETS)'!A6-'WATER USE (OTHER)'!A14))) |
| B11 | 7 | |
| C11 | 0 | =MAX(0,IF(('WATER USE (TOILETS)'!A4>'WATER USE (TOILETS)'!A6),(C10-'WATER USE (TOILETS)'!A4-'WATER USE (OTHER)'!A12),(C10-'WATER USE (TOILETS)'!A6-'WATER USE (OTHER)'!A16))) |