<% Response.ContentType = "application/msexcel" Response.AddHeader "Content-Disposition", "attachment;filename=DUcalc.xls" 'get data Name=Request.form("Name") Site=Request.form("Site") TestDate=Request.form("Date") TestTime=Request.form("Time") ElaspedTime=Request.form("ElaspedTime") Area=Request.form("Area") Catchment1=Request.form("Catchment1") Catchment2=Request.form("Catchment2") Catchment3=Request.form("Catchment3") Catchment4=Request.form("Catchment4") Catchment5=Request.form("Catchment5") Catchment6=Request.form("Catchment6") Catchment7=Request.form("Catchment7") Catchment8=Request.form("Catchment8") Catchment9=Request.form("Catchment9") Catchment10=Request.form("Catchment10") Catchment11=Request.form("Catchment11") Catchment12=Request.form("Catchment12") Catchment13=Request.form("Catchment13") Catchment14=Request.form("Catchment14") Catchment15=Request.form("Catchment15") Catchment16=Request.form("Catchment16") Catchment17=Request.form("Catchment17") Catchment18=Request.form("Catchment18") Catchment19=Request.form("Catchment19") Catchment20=Request.form("Catchment20") Catchment21=Request.form("Catchment21") Catchment22=Request.form("Catchment22") Catchment23=Request.form("Catchment23") Catchment24=Request.form("Catchment24") Comments=Request.form("Comments") %> Chico State DU Calculator
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%>