Customer RATE ESTIMATOR

 

  
  <% if request("a") = ""then %>
  Your Account Number
  -
Locate your account number on your bill

Water rates are proposed to increase coming this March 2010. This Water Bill Calculator is designed to help you estimate how the new rates will affect your average monthly water bill. (The average water bill is based on a 12 month average water usage from July 2008 – June 2009) You can lower your bill by conserving and using water efficiently. Find tips and rebates on water-efficient fixtures and appliances at www.wvwd.com/Conservation/

When you use the calculator, it may be helpful to have a copy of a recent water bill handy. Just key in your account number and click the "calculate" button. The online calculator is for estimating purposes only. Your actual bill will vary depending on actual water use.

If you have specific questions about your water bill, you can call (909) 348-8219 or e-mail the District at waterbill@wvwd.com.

<% if REQUEST("e") = 1 then response.write "

Invalid Account number. Please try again." %>

 

<% elseif request("a") = "calc" then if request("acct") = "" then response.redirect "rate-estimator.asp?e=1" if request("acct2") = "" then response.redirect "rate-estimator.asp?e=1" curAccount = replace(trim(request("acct")), "-", "") curAccount = CSTR(curAccount) curLocation = replace(trim(request("acct2")), "-", "") curLocation = CSTR(curLocation) 'CHECK VALIDATION OF ACCOUNT set acct = ConnectEX.Execute("SELECT * FROM [12mo Avg$]") flag=0 do until acct.eof or flag=1 tempAccount = CSTR(acct("CUSTOMER ID")) tempLocation = CSTR(acct("LOCATION ID")) if tempAccount = curAccount then if tempLocation = curLocation then flag=1 'response.write tempAccount&" : "&curAccount&"
" end if end if if flag=0 then acct.MoveNext loop if acct.eof or flag=0 then response.redirect "rate-estimator.asp?e=1" 'response.write acct("CUSTOMER ID") %>
Acct: <%=acct("CUSTOMER ID")&"-"&acct("LOCATION ID")%>
<%=acct("FULL ADDRESS")%>
<%=acct("CLASS")%>

Based on the previous 12 months of usage, this location uses an average of <%=acct("CONUSMPTION AVERAGE 12 MONTHS")%> ccf's per month. You can see how your amount may vary by adjusting the number in the usage box below.
         
Average Water Use Consumption Charge Pump Zone Charge Meter Charge Total Charges  
" /> ccf $<%=acct("TOTAL CONSUMPTION")%> $<%=acct("PUMP ZONE CHARGES")%> $<%=acct("FIXED CHARGE METER CHARGE")%> $<%=acct("TOTAL MONTHLY CHARGES")%>  
<% end if %>