All Units Calculated - Now for the rest.

I did it! I calculated all the Units for all 103,024 properties.

The difficulty I had is with properties that have multiple uses or uses not linked to the tariff codes such as government properties. Well today I managed to get the script to calculate a suitable amount of Units for these properties too. There's a small catch in that for instance one unit for a mixed use commercial property is N1000 but it could be made up of assessment units that could be measured in N100 or N500 units so that in order to give an adequate number of units to these properties I had to calculate how much their bill would be if they were charged separately for each use and then find the appropriate number of units to apply.

This would be a whole lot easier if a unit of was the same measure for all tariffs, but it's not. It seems that the more valuable the property or profitable the business, the higher the price of a unit. It's an awkward system, but that's how they do it, and making the logic work in a computer system is quite a headache.

The next stage is to compare the data we have with the existing data set, looking for problems like, properties that we have not linked to their old database record, or properties that are on the old database record but we don't have. Hopefully we should get through these in the next few days, I have to write the tools to enable it to be done first, but I can then delegate out some of the work to get it done quickly. I hope someone from our clients staff might be involved so that at least they can see the effort that has gone in to making things good.

Lets hope progress continues.