THIS FIELD SHOULD REMAIN HIDDEN!!!

---This field provides information for the person in charge of updating this calculator---

How to update the Tax and Fee rates each year:

1. Taxes may update each CY, generally in late Oct or early Nov.  We may know the new City of Columbia millage on July 1 but will likely not know each of the other millage rates until the Auditor releases the new millage table
   1. To update taxes, you will need to update the following fields:
      1. To update LOST rates, update these fields:
         1. LOST (for unincorporated tax districts)
         2. LostC (for COC tax districts)
      2. To update overall millage (shown on the Auditor's table as TOTAL LEVY), you will need to edit conditions.  You can do this by selecting the field identified in the parentheses below and clicking the button labeled "Conditions" (with an icon that looks like an organizational chart):
         1. For each unincorporated tax district (Levy)
         2. For each COC tax district (LevyC)
      3. To update school millage (shown on the Auditor's table as School Operating), you will need to edit the conditions for:
         1. Each School District, organized by each unincorporated tax district (School)
      4. Also, you should update the tax year in the first page text block that starts with "The average homeowner can save over $XXX per year..."
         1. Update the bolded tax year in the sentence that states, "Estimates are for the XXXX Tax Year"
      5. Update the tax year in the disclaimer text block (it is a widget).
2. Fees (i.e. utility fees for water/sewer) may update each FY.  Update the following fields:
   1. Solid Waste fees are currently charged to unincorporated residences; these fees are periodically updated by County Council. (SolidWasteU Res)
   2. Water rates
      1. WBRC is the montly base water rate for in-city residential customers 
      2. WBRU is the monthly base water rate for out-of-city residential customers
      3. WVR1C is the in-city volumetric rate for monthly consumption above the usage covered by the base rate.  Currently, the base rate covers the first 300 cubic feet of water usage, and THIS volumetric rate covers the next 9,700 cubic feet of water usage.  There also different volumetric rates for usage from 10,001 cubic feet to 100,000 cubic feet, and for usage over 100,000 cubic feet, but this would be EXTREMELY atypical for a residential customer and these other rates are not included in this calculator.  The average monthly residential water usage is about 8 cubic feet (aka 8 units).
      4. WVR1U is the OUT-OF-CITY volumetric rate for monthly consumption above the usage covered by the base rate.  See additional notes for WVR1C above.
   3. Sewer rates
      1. SewBRC is the base rate for in-city residential customers
      2. SewBRU is the base water rate for out-of-city residential customers
      3. SewVRC is
      4. SewVRU is
   4. Stormwater fees
      1. StormC is the total annual stormwater fee charged to in-city residents (on the water bill) for a single family residence/duplex.  This fee is charged monthly and is considered the base for all stormwater fees for commercial and multifamily properties - "ERU", or Equivalent Residential Unit.  This fee is set by council, updated from time-to-time, and is in the City ordinance (municode)
      2. StormU is currently zero as there is no stormwater fee charged on the water bill for out-of-City customers.  Out-of-City properties do get charged a stormwater fee, but it is (currently as of 2021 tax year) charged as a line item included with their millage - so stormwater fees are not tied to how much discharge a property creates but instead the taxable value of the property.
   5. Hydrant fees
      1. HydrantU
      2. HydrantC
   6. Fire fees
      1. FireU
      2. FireC

How am I saving money?

Your Tax bill is  lower  / Higher...

Your Water & Sewer...

note to me-  make the w/s matrix responsive to customer type response w only, w/s, s only, not a customer...