Precipitation Rate Analysis Worksheet |
|
|
|
|
|
|
|
Site: |
<%=Site%> |
|
|
|
|
|
|
|
Auditor(s): |
<%=Name%> |
|
|
|
|
|
|
|
Date: |
<%=TestDate%> |
|
|
|
|
|
|
|
|
|
|
|
Test Time |
<%=TestTime%> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Catchment area (sq. in) |
<%=Area%> |
|
|
|
|
|
|
|
|
|
Elapsed Time (Minutes) |
<%=ElaspedTime%> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Container # |
Volume (ml) |
Depth (in.) |
Precip. Rate
(in./h) |
Rank |
LowQ |
|
|
|
|
|
|
Used for Ranking |
1 |
<%=Catchment1%> |
=IF(B11<>"",B11*0.061/$D$7,"") |
=IF(C11<>"",C11/$D$8*60,"") |
=IF(B11<>"",RANK(M11,$M$11:$M$34,1),"") |
=IF(E11<=$B$36/4,D11,"") |
|
|
|
|
|
|
=IF(D11<>"",D11+A11/1000,"") |
2 |
<%=Catchment2%> |
=IF(B12<>"",B12*0.061/$D$7,"") |
=IF(C12<>"",C12/$D$8*60,"") |
=IF(B12<>"",RANK(M12,$M$11:$M$34,1),"") |
=IF(E12<=$B$36/4,D12,"") |
|
|
|
|
|
|
=IF(D12<>"",D12+A12/1000,"") |
3 |
<%=Catchment3%> |
=IF(B13<>"",B13*0.061/$D$7,"") |
=IF(C13<>"",C13/$D$8*60,"") |
=IF(B13<>"",RANK(M13,$M$11:$M$34,1),"") |
=IF(E13<=$B$36/4,D13,"") |
|
|
|
|
|
|
=IF(D13<>"",D13+A13/1000,"") |
4 |
<%=Catchment4%> |
=IF(B14<>"",B14*0.061/$D$7,"") |
=IF(C14<>"",C14/$D$8*60,"") |
=IF(B14<>"",RANK(M14,$M$11:$M$34,1),"") |
=IF(E14<=$B$36/4,D14,"") |
|
|
|
|
|
|
=IF(D14<>"",D14+A14/1000,"") |
5 |
<%=Catchment5%> |
=IF(B15<>"",B15*0.061/$D$7,"") |
=IF(C15<>"",C15/$D$8*60,"") |
=IF(B15<>"",RANK(M15,$M$11:$M$34,1),"") |
=IF(E15<=$B$36/4,D15,"") |
|
|
|
|
|
|
=IF(D15<>"",D15+A15/1000,"") |
6 |
<%=Catchment6%> |
=IF(B16<>"",B16*0.061/$D$7,"") |
=IF(C16<>"",C16/$D$8*60,"") |
=IF(B16<>"",RANK(M16,$M$11:$M$34,1),"") |
=IF(E16<=$B$36/4,D16,"") |
|
|
|
|
|
|
=IF(D16<>"",D16+A16/1000,"") |
7 |
<%=Catchment7%> |
=IF(B17<>"",B17*0.061/$D$7,"") |
=IF(C17<>"",C17/$D$8*60,"") |
=IF(B17<>"",RANK(M17,$M$11:$M$34,1),"") |
=IF(E17<=$B$36/4,D17,"") |
|
|
|
|
|
|
=IF(D17<>"",D17+A17/1000,"") |
8 |
<%=Catchment8%> |
=IF(B18<>"",B18*0.061/$D$7,"") |
=IF(C18<>"",C18/$D$8*60,"") |
=IF(B18<>"",RANK(M18,$M$11:$M$34,1),"") |
=IF(E18<=$B$36/4,D18,"") |
|
|
|
|
|
|
=IF(D18<>"",D18+A18/1000,"") |
9 |
<%=Catchment9%> |
=IF(B19<>"",B19*0.061/$D$7,"") |
=IF(C19<>"",C19/$D$8*60,"") |
=IF(B19<>"",RANK(M19,$M$11:$M$34,1),"") |
=IF(E19<=$B$36/4,D19,"") |
|
|
|
|
|
|
=IF(D19<>"",D19+A19/1000,"") |
10 |
<%=Catchment10%> |
=IF(B20<>"",B20*0.061/$D$7,"") |
=IF(C20<>"",C20/$D$8*60,"") |
=IF(B20<>"",RANK(M20,$M$11:$M$34,1),"") |
=IF(E20<=$B$36/4,D20,"") |
|
|
|
|
|
|
=IF(D20<>"",D20+A20/1000,"") |
11 |
<%=Catchment11%> |
=IF(B21<>"",B21*0.061/$D$7,"") |
=IF(C21<>"",C21/$D$8*60,"") |
=IF(B21<>"",RANK(M21,$M$11:$M$34,1),"") |
=IF(E21<=$B$36/4,D21,"") |
|
|
|
|
|
|
=IF(D21<>"",D21+A21/1000,"") |
12 |
<%=Catchment12%> |
=IF(B22<>"",B22*0.061/$D$7,"") |
=IF(C22<>"",C22/$D$8*60,"") |
=IF(B22<>"",RANK(M22,$M$11:$M$34,1),"") |
=IF(E22<=$B$36/4,D22,"") |
|
|
|
|
|
|
=IF(D22<>"",D22+A22/1000,"") |
13 |
<%=Catchment13%> |
=IF(B23<>"",B23*0.061/$D$7,"") |
=IF(C23<>"",C23/$D$8*60,"") |
=IF(B23<>"",RANK(M23,$M$11:$M$34,1),"") |
=IF(E23<=$B$36/4,D23,"") |
|
|
|
|
|
|
=IF(D23<>"",D23+A23/1000,"") |
14 |
<%=Catchment14%> |
=IF(B24<>"",B24*0.061/$D$7,"") |
=IF(C24<>"",C24/$D$8*60,"") |
=IF(B24<>"",RANK(M24,$M$11:$M$34,1),"") |
=IF(E24<=$B$36/4,D24,"") |
|
|
|
|
|
|
=IF(D24<>"",D24+A24/1000,"") |
15 |
<%=Catchment15%> |
=IF(B25<>"",B25*0.061/$D$7,"") |
=IF(C25<>"",C25/$D$8*60,"") |
=IF(B25<>"",RANK(M25,$M$11:$M$34,1),"") |
=IF(E25<=$B$36/4,D25,"") |
|
|
|
|
|
|
=IF(D25<>"",D25+A25/1000,"") |
16 |
<%=Catchment16%> |
=IF(B26<>"",B26*0.061/$D$7,"") |
=IF(C26<>"",C26/$D$8*60,"") |
=IF(B26<>"",RANK(M26,$M$11:$M$34,1),"") |
=IF(E26<=$B$36/4,D26,"") |
|
|
|
|
|
|
=IF(D26<>"",D26+A26/1000,"") |
17 |
<%=Catchment17%> |
=IF(B27<>"",B27*0.061/$D$7,"") |
=IF(C27<>"",C27/$D$8*60,"") |
=IF(B27<>"",RANK(M27,$M$11:$M$34,1),"") |
=IF(E27<=$B$36/4,D27,"") |
|
|
|
|
|
|
=IF(D27<>"",D27+A27/1000,"") |
18 |
<%=Catchment18%> |
=IF(B28<>"",B28*0.061/$D$7,"") |
=IF(C28<>"",C28/$D$8*60,"") |
=IF(B28<>"",RANK(M28,$M$11:$M$34,1),"") |
=IF(E28<=$B$36/4,D28,"") |
|
|
|
|
|
|
=IF(D28<>"",D28+A28/1000,"") |
19 |
<%=Catchment19%> |
=IF(B29<>"",B29*0.061/$D$7,"") |
=IF(C29<>"",C29/$D$8*60,"") |
=IF(B29<>"",RANK(M29,$M$11:$M$34,1),"") |
=IF(E29<=$B$36/4,D29,"") |
|
|
|
|
|
|
=IF(D29<>"",D29+A29/1000,"") |
20 |
<%=Catchment20%> |
=IF(B30<>"",B30*0.061/$D$7,"") |
=IF(C30<>"",C30/$D$8*60,"") |
=IF(B30<>"",RANK(M30,$M$11:$M$34,1),"") |
=IF(E30<=$B$36/4,D30,"") |
|
|
|
|
|
|
=IF(D30<>"",D30+A30/1000,"") |
21 |
<%=Catchment21%> |
=IF(B31<>"",B31*0.061/$D$7,"") |
=IF(C31<>"",C31/$D$8*60,"") |
=IF(B31<>"",RANK(M31,$M$11:$M$34,1),"") |
=IF(E31<=$B$36/4,D31,"") |
|
|
|
|
|
|
=IF(D31<>"",D31+A31/1000,"") |
22 |
<%=Catchment22%> |
=IF(B32<>"",B32*0.061/$D$7,"") |
=IF(C32<>"",C32/$D$8*60,"") |
=IF(B32<>"",RANK(M32,$M$11:$M$34,1),"") |
=IF(E32<=$B$36/4,D32,"") |
|
|
|
|
|
|
=IF(D32<>"",D32+A32/1000,"") |
23 |
<%=Catchment23%> |
=IF(B33<>"",B33*0.061/$D$7,"") |
=IF(C33<>"",C33/$D$8*60,"") |
=IF(B33<>"",RANK(M33,$M$11:$M$34,1),"") |
=IF(E33<=$B$36/4,D33,"") |
|
|
|
|
|
|
=IF(D33<>"",D33+A33/1000,"") |
24 |
<%=Catchment24%> |
=IF(B34<>"",B34*0.061/$D$7,"") |
=IF(C34<>"",C34/$D$8*60,"") |
=IF(B34<>"",RANK(M34,$M$11:$M$34,1),"") |
=IF(E34<=$B$36/4,D34,"") |
|
|
|
|
|
|
=IF(D34<>"",D34+A34/1000,"") |
|
Average |
=AVERAGE(C11:C34) |
=AVERAGE(D11:D34) |
|
=AVERAGE(F11:F34) |
|
|
|
|
|
|
|
Count |
=COUNT(B11:B34) |
|
|
|
|
|
|
|
|
|
|
|
DU |
=F35/D35 |
|
|
|
|
|
|
|
|
|
|
|
SC Area |
=1/B36 |
|
|
|
|
|
|
|
|
|
|
|
SC |
=D35/MIN(D11:D34) |
|
|
|
|
|
|
|
|
|
|
|
Comments: |
|
|
|
|
|
|
|
|
|
|
|
|
<%=Comments%> |
|
|
|
|
|
|
|