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 get the job done (there was a one in 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 8%. (Thanks to Madura for the suggested edit)

These are the supporting document I used.

Last updated by Romesh Maling Perera.

*Related*

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

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.