INPUT AND RESULTS¶
Sheet visibility: visible.
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 | INPUTS | |
| A3 | WHAT IS THE ROOF AREA THAT DRAINS TO THE CISTERN? (SQUARE FEET) | |
| A4 | 0 | |
| A5 | WHAT AMOUNT OF RUNOFF IS DIVERTED BY THE FIRST FLUSH DIVERTER? (INCHES) | |
| D5 | POTENTIAL MAXIMUM RETENTION AFTER RUNOFF BEGINS (INCHES) | |
| E5 | 0.204081632653061 | =((1000/A8)-10) |
| A6 | 0.01 | |
| D6 | INITIAL ABSTRACTION OF ROOF (INCHES) | |
| E6 | 0.04081632653061221 | =(0.2*E5) |
| A7 | CURVE NUMBER ROOF - ASSUMED 98, UNLESS USING A GREEN ROOF | |
| A8 | 98 | |
| A9 | MINIMUM VOLUME OF WATER, BUILDING UTILIZES DURING A THREE (3) DAY PERIOD. (GALLONS) | |
| A10 | 0 | =IF(OR('WATER USE (TOILETS)'!A4>'WATER USE (TOILETS)'!A6,'WATER USE (TOILETS)'!A6>'WATER USE (TOILETS)'!A4,),2'WATER USE (TOILETS)'!A6+'WATER USE (TOILETS)'!A4,3'WATER USE (TOILETS)'!A4) |
| D10 | WATER QUALITY DESIGN STORM RUNOFF (INCHES) | |
| E10 | 1.0345723126795847 | =(((1.25-E6)^2)/((1.25-E6)+E5)) |
| A11 | MINIMUM VOLUME OF WATER, BUILDING UTILIZES DURING A THREE (3) DAY PERIOD. (CUBIC FEET) | |
| D11 | WATER QUALITY DESIGN STORM RUNOFF AFTER DIVERSION (INCHES) | |
| E11 | 1.0245723126795847 | =E10-A6 |
| A12 | 0 | =A10/7.48052 |
| A13 | WATER QUALITY DESIGN STORM VOLUME (CISTERN'S MINIMUM CAPACITY) (GALLONS) | |
| A14 | 0 | =(((E11/12)A4)7.48052) |
| A15 | WATER QUALITY DESIGN STORM VOLUME (CISTERN'S MINIMUM CAPACITY) (CUBIC FEET) | |
| A16 | 0 | =((E11/12)*A4) |
| A18 | RESULT - 1ST STEP | |
| A19 | BUILDING'S WATER USAGE IS SUFFICENT TO JUSTIFY A CISTERN | =IF((A10<A14),"BUILDING'S WATER USAGE IS INSUFFICENT TO JUSTIFY A CISTERN","BUILDING'S WATER USAGE IS SUFFICENT TO JUSTIFY A CISTERN") |
| A20 | 0 | =IF(AND(Sheet1!F7="SUFFICIENT", A19="BUILDING'S WATER USAGE IS SUFFICENT TO JUSTIFY A CISTERN"), MAX(Sheet1!C5:C11)*1.1,"") |
| B20 | GALLONS | =IF(AND(Sheet1!F7="SUFFICIENT", A19="BUILDING'S WATER USAGE IS SUFFICENT TO JUSTIFY A CISTERN"), "GALLONS","") |
| A21 | =IF((A19="BUILDING'S WATER USAGE IS INSUFFICENT TO JUSTIFY A CISTERN"),"RESULT - 2ND STEP","") | |
| A22 | ADDITIONAL WATER USAGE IS INSUFFICIENT TO JUSTIFY A CISTERN | =IF(AND(Sheet1!F7="SUFFICIENT",A21="RESULT - 2ND STEP"),"ADDITIONAL WATER USAGE IS SUFFICIENT TO JUSTIFY A CISTERN","ADDITIONAL WATER USAGE IS INSUFFICIENT TO JUSTIFY A CISTERN") |
| A23 | AMOUNT OF WATER THAT REMAINS | =IF((A22="ADDITIONAL WATER USAGE IS SUFFICIENT TO JUSTIFY A CISTERN"),"ADDITIONAL STORAGE TANK NECESSARY (GALLONS)","AMOUNT OF WATER THAT REMAINS") |
| A24 | =IF(AND(Sheet1!F7="SUFFICIENT",A23="ADDITIONAL STORAGE TANK NECESSARY (GALLONS)"),MAX(Sheet1!C5:C11)*1.1,"") | |
| B24 | =IF(AND(Sheet1!F7="SUFFICIENT",A22="ADDITIONAL WATER USAGE IS SUFFICIENT TO JUSTIFY A CISTERN"),"GALLONS","") |