I tried to enter in our know authorized consumption; found the worksheet is protected and requesting a password to make changes. Can you provide the password?
Regards
0
drewblackwell
Oct 30, 2017
@rromo thanks for the question! The Water Audit Software is password protected to keep all the formulas and tools locked and to ensure modified versions do are not inadvertently distributed. That said, the problem you are having is one we've heard before. It seems you may be trying to enter information into an auto-calculated cell based on previous input values (one of the yellow cells). The software will not let you do that. Instead, to get you total Authorized Consumption, you will need to insert a volume (as applicable) for Billed metered (your billed consumption based on meter reads), Billed unmetered (flat rate customers; if 100% of your customers are metered, you may report a zero volume here), Unbilled metered (this could be municipal or governmental uses or uses at your own facilities; if all your metered uses are billed, you may report a zero volume here), and Unbilled unmetered (this could be flushing, fire use, sometimes street sweeping use is here). Unbilled unmetered is often a hard volume to quantify, and therefore give you the option to apply the default (1.25% of Water Supplied) or, if you are tracking these typical uses through estimation methods and have those records, you can report it in your own estimated volume. To do this, you'll have to select the radio button over to the right of the Unbilled unmetered input cell.
@rromo thanks for the question! The Water Audit Software is password protected to keep all the formulas and tools locked and to ensure modified versions do are not inadvertently distributed. That said, the problem you are having is one we've heard before. It seems you may be trying to enter information into an auto-calculated cell based on previous input values (one of the yellow cells). The software will not let you do that. Instead, to get you total Authorized Consumption, you will need to insert a volume (as applicable) for Billed metered (your billed consumption based on meter reads), Billed unmetered (flat rate customers; if 100% of your customers are metered, you may report a zero volume here), Unbilled metered (this could be municipal or governmental uses or uses at your own facilities; if all your metered uses are billed, you may report a zero volume here), and Unbilled unmetered (this could be flushing, fire use, sometimes street sweeping use is here). Unbilled unmetered is often a hard volume to quantify, and therefore give you the option to apply the default (1.25% of Water Supplied) or, if you are tracking these typical uses through estimation methods and have those records, you can report it in your own estimated volume. To do this, you'll have to select the radio button over to the right of the Unbilled unmetered input cell.