Most people got huge water bills after some time due to COVID-19. I wanted to double-check the calculation because the amount was somewhat big. Unlucky I didn’t find any online calculator that gets the job done (there was one in the waterboard, but it has a maximum limit of 60 days). So I went with the default option, Excel. I thought of sharing the excel workbook I used as It might be helpful to others. I really don’t know how the VAT calculation is done, so I used 15%. (Thanks to Madura for the suggested edit)
These are the supporting document I used.
Hi, Nice work. But when you enter 90 units it gives a wrong answer. Please check.Tks
Thanks for the feedback, I will check that. It’s great if you can provide me with the number of days as well.
Basically correct the formulas to include the row 10 as well. That will fix the issue
Thanks for the tip, will check that
Aluth foformula nedda brother
Updated the formula
Did the update, should work fine for large bills now, thanks Madura!
How do they calculate the unit price for bulk units for residential apartments?
If they have the internal meters for the houses how could they divide the unit price?
I personally have no clue, but will keep this posted if someone decides to answer.
My water meter is running crazy. Each time i take a reading within a day meter indicates usage of 3- 4 units. Its about 3-4 thousand liters. Just washing my hands meter runs upto a unit. Not covid hand washing just normal hand wash about few seconds. Water board is telling me to check up with a private company. Water board sucks..
My House bill mentioned 12,345.00 for 98 unit for 30 days. I can’t believe that.
Do you have previous gazette?
My House bill mentioned 12 unit for 30 days. can you calculate the monthly payment .
Hi. Could you pls update with new water tariff data. it would be so much helpful. great work.